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

Using TurboCASH

 







BAD DEBTS
CALCULATE PROVISION FOR BAD DEBTS BASED ON AGE ANALYSIS SCHEDULES
  
According to this method you need to first analyse your outstanding debtors account balances according to periods that each of these debts are outstanding. To do this, you need to have ageing schedules or an age analysis report. An age analysis report, is simply a list of outstanding debts, which originated in a specific period, but which is still outstanding (not yet paid, cancelled by credit note or written off) as at the end (last day) of each of the defined or specified periods.

Should you have started to use TurboCASH, and you have taken on the balances for each period of your debtor accounts, you may generate a Debtor Age Analysis report to base your calculations on. If this was not done, you may need to obtain the Debtors Age Analysis Schedules from your previous accounting system.

To Calculate Estimates on the Debtors Age Analysis Report:
If you have taken on the outstanding balances of your debtors to use the ageing facility in TurboCASH, or if you have been using TurboCASH for some time, click on the Reports - Debtors - Age Analysis menu option to generate the Debtors Age Analysis Report.
Select all your debtors and the Date of Ageing as the last day of the period for which you wish to use the totals. This would normally be the last day of your financial year. Do not select the Show Transactions on the Age Analysis Options screen, since you will not be using the transaction details at this stage.
Click on the OK button on the Debtors Age Analysis Report Options screen. The age analysis report would display as follows:

 

Handyman Hardware Store


In this example, it the ageing periods could be defined as follows:

Current Outstanding debt, as at the last day of February 2006.

30 Days Outstanding debt, as at the last day of January 2006.

60 Days Outstanding debt, as at the last day of December 2005.

90 Days Outstanding debt, as at the last day of November 2005.
Each of the balances will be considered individually and specific attention will be given to those accounts with the longest outstanding balances. You could also calculate the percentages of your ageing periods as a percentage of the transaction total to use as some guidelines in your calculations or considerations.
From this age analysis, the doubtful debts would be listed. The list of doubtful debts will then be used to create or adjust the provision for bad debts.

If you have accounting records on from a previous accounting system

Find your Debtors Age Analysis Schedule (summary) from your old accounting records (only if you did not take-on your Debtor Accounts for each outstanding period). A typical age analysis report in the manual system (previous accounting records) would look as follows:


Each of the balances will be considered individually and specific attention will be given to those accounts with the longest outstanding balances.
From this age analysis, the doubtful debts would be listed. The list of doubtful debts will then be used to create or adjust the provision for bad debts.