Troubleshooting: Balance Sheet amount not tally with Creditor Aging Amount

From AutoCount Resource Center
Jump to navigation Jump to search

Question: Balance Sheet amount not tally with Creditor Aging Amount


Possible Reasons:

(1) The creditor is traded in foreign currency, and Creditor Aging Report is not converted and shown in local currency.

(2) Creditor Aging Report is viewed with the options setting of 'Use Original Document Date'. This causes the Aging Date field to follow Original Document Date (if there was value assigned to it).

(3) Opening Balance is not maintained correctly. The total amount of past documents does not tally with amount in the Opening Balance

(4) Knock Off date was entered as earlier than its Document Date. Creditor Aging Report is to base on knock off date but the ledger will base on payment date, which is the later date.


Possible Reason (1):

The creditor is traded in foreign currency, and Creditor Aging Report is not converted and shown in local currency.


Solution (1):

In Creditor Aging Report, make sure that ‘Show in Creditor & Local Currency By Document’ at More Options is checked.


Aging not tally1.jpg


Possible Reason (2) :

Creditor Aging Report is viewed with the options setting of 'Use Original Document Date'. This causes the Aging Date field to follow Original Document Date (if there was value assigned to it).


Solution (2) :

In Creditor Aging Report, uncheck 'Use Original Document Date' at More Options.


Aging not tally2.jpg


Possible Reason (3):

Opening Balance is not maintained correctly. The total amount of past documents does not tally with amount in the Opening Balance.


Solution (3):

Compare the amount of Creditor Aging as at before actual data start date with the amount of Creditor at Opening Balance.

Make sure the amounts are the same.


Aging not tally3.jpg

Aging not tally4.jpg


If the amount is not tally, most likely you have directly edited the amount Creditor at Opening Balance Maintenance.

You need to go to Tools > Manage Fiscal Year, click on Reset Debtor/Creditor Opening Balance to zero, and click on Update Debtor/Creditor Opening Balance from Past A/R and A/P Transaction.


Aging not tally5.jpg


The amount of Creditor in Opening Maintenance will then be filled and tally with that of Creditor Aging Report.


Possible Reason (4):

Knock Off date was entered as earlier than its Document Date. Creditor Aging Report is to base on knock off date but the ledger will base on payment date, which is the later date. E.g. Payment date = 29/12/2017, knock off date = 20/12/2017 Aging Report as at 20/12/2017 will be showing the deduction of knock off; but ledger report will only show the payment on 29/12/2017


Solution (4):

First of all, go to Start > All Programs > AutoCount Accounting > AutoCount Accounting Management Studio


Aging not tally6.gif


Click on Data Consistency > Check Knock Off Date Consistency;


Aging not tally7.png


Click on Check Inconsistent Knock Off Date Problem. You can be able to find out those documents whose knock off date is inconsistent here.


Aging not tally8.jpg


Go back to the related account book, retrieve the documents with inconsistent knock off date, then make the necessary correction (Make sure the knock off date same as payment date or later than payment date).


By: Lay Swan 180130, KM 180130, P180130



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations