Fastbase

If there are any variances related to the General Ledger AR Control Account, the following need to be investigated:

1.
Compare the AR Control Account Balance and Customer Aged Trial Balance for the month in question and prior months. Look for any variations.

By doing this, the month where the variance originated can be identified.

2.
Look for any manual journals that have been coded directly to the AR Control Account.

This is a common mistake that will result in a variance. Due to this, many areas of Fastbase have been updated to prevent manual postings being directly coded to the AR Control Account.

3.
Compare the totals of the different transactions (ie, Invoices, Receipts, Credit Notes, Journals, etc) in the Customers/Invoicing Audit Trail to the figures under the MTD figure in GL Account Enquiry for the AR Control Account.

NOTE: In GL Account Enquiry for the AR Control Account, click on the relevant period being compared. In the next screen, click on the line GL-UPDATE Journal. Look at the figures for Invoices, Receipts, Credit Notes, Journals, etc and compare them to the corresponding figures in the audit trail report.

All figures compared should balance. Figures that do not balance need to be investigated by going into the batches for each invidual transaction type.

Compare these figures for the month in question and prior months. Look for any variations.

This helps in narrowing down the cause of the variance.

In most cases, General Ledger Journal will have to be created to rectify the variance, if any.