Date Driven Reports in all Capital Programs

In the 2010 product releases, users will enjoy more date driven control in financial reports. These reports are based upon the gl transactions created behind the scene by the products so it is important to understand these reports in order to get the most out of the software.

In all Capital Software revenue programs, when a charge is added, modified or paid the system will create historical transactions at the time of the transaction (AR transactions must be turned on in the tran code in order for the system to make entries when charges are applied or edited).  Capital recommends turning your AR transactions on for every tran code to enhance your reporting experience whether you are tracking AR entries in your accounting software or not.

The 2010 products include new or improved reports in the following areas:
Daily Balancing Cash - This report displays all payments by session in detail and is a critical daily balancing tool.  This report reads directly from the gltran database so if a payment was made it will appear on this report.
AR Distribution - Whenver a charge is applied (like a billing or monthly interest) or adjusted your Accounts Receivable is effected.  You can run this report for any date range and see the amounts. This is only AR not payments.
Fiscal Audit with Ageing (GL AR BASED) - Enter a starting and ending date and this report will display (by due date) all charges that have been billed, adjusted, penalties, interest, payments, credits, reversals, writeoffs and ending balancing as of whatever ENDING date you enter.  This is a great audit tool when looking at a specific fiscal year.
Aged Trial Balance by Code (GL BASED) - Enter an ending date and this report will display every tran code outstanding as of the ENDING date.  Each tran code is grouped by due date so you know what is applied, received and outstanding for that code/due date as of ending date.
Aged Trial Balance by Due Date (GL BASED) - Enter an ending date and this report will display every tran code outstanding as of the ENDING date for a due date.  You know what is applied, received and outstanding for that code/due date as of ending date.
Trial Balance Account Summary and Detail (GL BASED) - These reports allow you to analyze a single account or multiple accounts.  The report will display every line item on an account in the start and ending date range entered.  This is very helpful when looking at an account over time and explaining what has occurred.

CHARGES TAB vs. GLTRAN
Older reports like the original aged trial balance (which reads data from the Charges tab) are still available in the system but these reports are not date specific.  Some reports like the applied charges have been removed in exchange for the new GL based reports for created accuracy and to take advantage of the new system features.

We hope you enjoy these new reports.  Remember that the system will make AR entries from the point you turn the AR function on in the system.  It is not retroactive and can not recreate old transactions.

Thank you,
Capital Support Team.

Important Note about the Transaction Journal Reports

Capital Software has within its applications a large arsenal of reports in which to access and display our client’s data. Two of the most utilized weapons in that arsenal are the transaction journals. In particular the Transaction Journal by owner which is a detailed report that displays all pertinent detailed billing information for each individual account, and the Transaction Journal by Service which is a summarized report showing again all pertinent billing information for each charge line or Tran Code that has been place on each account. In more simple terms these reports show our clients the data for every bill that is being sent to their customers.

These powerful tools are real time reports. For example,this meaning that when any payments or reversals are performed the data changes to reflect these changes. These reports are entirely parameter driven (as are all crystal reports) and in this case that parameter is the due date. It is important to keep in mind when using these reports if the due date that is listed on the charge tab within the program does not fall in between the date range entered when launching, the data retrieved on the report may not be what was desired.

It is import to again state that these reports are real time and due to this feature this report is not capable of pulling information from a fixed point in time. There are points in time reports that may be used for that function. Using a report for a function that is was not designed is not recommended.

If the reports that have been provided within our software do not pull the information in just the format you require, please contact Support@capitalsoftwareinc.com and let us know what you desire. We will be able to let you know if a report already exists that will show that and if not we will research the issue and let you know if it is possible to create the report and if so the any possible fees.

Important Reminder when Running Delinquent Reports

It is important to remember when running any of the delinquent reports with in CSI software to first press the Delinquent Query for Reports-Run First Button. This will launch a sql query that will pull all of the delinquent information into a data base file called Delinquent Master , allowing the delinquent reports to pull their information from this table. If you attempt to run the reports with out first pressing the button your delinquent information may be inaccurate.

Norton's Virus Update (Caution)

During a recent Norton's virus update, there is an issue with it viewing our report viewer as a virus and removes it.

Steps to take if it prompts you.
1. When you click on a report button, it goes through a series of steps and then launches a seperate screen to view the report. If it has been blocked then it will not show the report but will pop up a box down by your clock that it states " The virus threat has been removed."

2. Click on the box.

3. Follow the instructions to putting it back in and making it a safe program to launch.

4. Once that is complete, then you should not have an issue.