TurboCASH Accounting Software TurboCASH United Kingdom
Select your Country
OPEN SOURCE ACCOUNTING SOFTWARE
HomeFeatures & ScreenshotsShop onlineCompareFAQForumRegisterContact
Community
Free Downloads
Shop
Other Titles

Using TurboCASH

 







VIEW CREDITOR LEDGER REPORTS
VIEW CREDITOR AGE ANALYSIS REPORT
  
The Creditor Age Analysis Options allows you to select the options to analyse your transactions with each of your creditor accounts according to specified accounting periods. This could be a useful tool to schedule your payments to your creditors. This Report will display a break down of your creditor account balances for each of the specified periods for a selected creditor account or a range of selected creditor accounts.

Name of business. System date and time. Page number. Name of the report and the date until which transactions or balances are included. Creditor Account number and name or description. Reference number as in the Purchase, Purchase Returns, Payments or General Journal, etc. If Purchase or Stock return documents were posted, the document number will be displayed Transaction date. The total of the transaction. The total of the transactions / balances for each of the selected ageing periods. Creditor Account number and name or description. Transaction date. Batch type or journal in which the transactions or documents were posted to the ledger. Batch type or journal in which the transactions or documents were posted to the ledger. The total of the transaction. The total of the transactions / balances for each of the selected ageing periods. The grand total for all the Creditor accounts included in this report. Totals for the Creditor account. Totals for the Creditor account. Reference number as in the Purchase, Purchase Returns, Payments or General Journal, etc. If Purchase or Stock return documents were posted, the document number will be displayed Heading of the columns in the age analysis report. Contact information for the Creditor Account. Contact information for the Creditor Account.

This report consists of the following 8 columns:

 

Column 1 - Reference No.
- This is the reference number of the transaction as entered into the reference field of the Batch Entry screen. If you generate documents (Purchase and Goods Returned documents) the Document number will be displayed in this column. If the Show Transactions field is not selected on the Creditor Age Analysis Options screen, the reference number will not be displayed.

Column 2 - Date - This is the date of the transaction. If the Show Transactions field is not selected on the Creditor Age Analysis Options screen, the date will not be displayed.

Column 3 - Batch Type - The name of the selected batch type in which the transaction was entered and posted or updated to the Ledger. If the Show Transactions field is not selected on the Creditor Age Analysis Options screen, the batch type will not be displayed.

Column 4 - Transaction Total - The total outstanding balance for the creditor as at the selected date of ageing.

Column 5 - Current to - The outstanding balances as at the end of the specified accounting period (e.g. the selected current accounting period).

Column 6 - 30 Days to - The outstanding balances as at the end of the specified accounting period (e.g. 1 accounting period or month back).

Column 7 - 60 Days to - The outstanding balances as at the end of the specified accounting period (e.g. 2 accounting period or months back).

Column 8 - 90 Days to - The outstanding balances as at the end of the specified accounting period (e.g. 3 accounting period or months back).

At the end of each of the selected creditors accounts, a total will be displayed and at the end of the report, a total for all of the selected reports will be displayed for each of the selected ageing periods.

You may customise the headings for columns 5 to 8 and you may also set the increment accounting periods from 1 to 12 according to your periods (as set in the Reporting Dates screen) on the Creditor Age Analysis reports on the Creditor Age Analysis Options screen. The heading and the periods as entered on the Creditor Age Analysis Options screen will then reflect as the headings of the generated report.

If you did not take on the opening balances for each accounting period for each of your creditors, you will not be able to use the ageing facility for the first ageing periods. To take-on Opening balances for Creditor Accounts, to use the ageing feature, click here.

The amounts which are displayed in <> indicates a credit or negative figure. You may change this negative amount indicator to a minus sign (-) to prefix your amounts or set it to display a D (for Debit) or a C (for Credit) in the Setup - Preferences - Data Parameters menu option.