Troubleshooting: Balance Sheet amount not tally with Creditor Aging Amount

Question: Balance Sheet amount not tally with Creditor Aging Amount

Version: 1.8 / 1.9 / 2.0

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’ and ‘Show Local Currency’ at More Options is checked.

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.

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.

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.

Remark : If you've transaction for Unrealize Gain/Loss, you're not advise to Reset and Update Debtor/Creditor Opening Balance.

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

Click on Data Consistency > Check Knock Off Date Consistency;

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

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