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 DEBTOR LEDGER REPORTS
VIEW DEBTOR AGE ANALYSIS REPORT
  
The Debtor Age Analysis Options allows you to select the options to analyse your transactions with each of your debtors according to specified accounting periods. This could be a useful tool to manage your outstanding debts and to see which debtors are not performing according to your credit agreements. You may also use this facility to calculate provision for bad debts. This Report will display a break down of your debtor account balances for each of the specified periods for a selected debtor account or a range of selected debtor accounts.

Name of business. System date and time. Page number. Name of the report and the date until which transactions or balances are included. Debtor Account number and name or description. Reference number as in the Sales, Sales Returns, Receipts, General Journal, etc. If Invoices, POS Invoices and Credit Note 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. Debtor 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 totals for all the Debtor accounts included in this report. Totals for the Debtor account. Totals for the Debtor account. Reference number as in the Sales, Sales Returns, Receipts, General Journal, etc. If Invoices, POS Invoices and Credit Note documents were posted, the Document number will be displayed. Heading of the columns in the age analysis report. Contact information for the Debtor Account. Contact information for the Debtor 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 (Invoices and Credit Notes) the Document number will be displayed in this column. If the Show Transactions field is not selected on the Debtor 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 Debtor 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 Debtor Age Analysis Options screen, the batch type will not be displayed.

Column 4 - Transaction Total - The total outstanding balance for the debtor account 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 debtor 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 Debtor Age Analysis reports on the Debtor Age Analysis Options screen. The heading and the periods as entered on the Debtor 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 Debtor 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.