Before updating General Ledger for the financial year, you should check to ensure that your Attaché PRO modules balance correctly with General Ledger. To do this you will need to keep copies of the reports that were printed prior to updating each of the Attaché PRO modules to compare to the General Ledger account totals.
On the following pages is the information that can be used to reconcile Accounts Receivable, Inventory Control, Cashbook and Accounts Payable to General Ledger.
If there are any problems with these checks and balances correct them by making the appropriate adjustments before updating General Ledger, there is further information on this detailed under Troubleshooting information.
Accounts Receivable
Once you have completed the updates for Accounts Receivable and Cashbook you will need to post the resulting batches in General Ledger to update the Sundry Debtors account. The amount in the Sundry Debtors account in General Ledger should then match to the total balance in the Customer Aged Trial Balance and Ledger Totals that were printed before beginning the end of year update in Accounts Receivable.
Receivables, Reports, Aged Trial Balance
Receivables, Ledger Totals
General Ledger, Reports, Trial Balance
Inventory Control
Once you have completed the end of year update for Inventory Control you will need to post the resulting batch in General Ledger to update the Stock accounts. The amount in the Stock on Hand account in General Ledger should then match to the total balance in the Sales and Valuation Report (based on your stock valuation method that is specified under Inventory, Settings) that was printed before beginning the end of year update in Inventory Control.
Note: It is possible to have multiple stock on hand accounts in General Ledger – if this is the case for your business you will need to print the Sales & Valuation Reports with the appropriate selections to allow you to reconcile each stock on hand account.
Inventory, Reports, Sales and Valuation report
General Ledger, Reports, Trial Balance
Cashbook
Once you have completed the end of year update for Cashbook you will need to post the resulting batch in General Ledger to update the Cash at Bank. The amount in the Cash at Bank account in General Ledger should then match to the bank accounts balance for each bank account on the reports that were printed before beginning the end of year update in Cashbook.
Cashbook, Ledger Totals
General Ledger, Reports, Trial Balance
Accounts Payable
Once you have completed the updates for Cashbook and Accounts Payable you will need to post the resulting batches in General Ledger to update the Sundry Creditors account. The amount in the Sundry Creditors account in General Ledger should then match to the total balance in the Creditor Aged Trial Balance and Ledger Totals that
were printed before beginning the end of year update in Accounts Payable.
Payables, Reports, Aged Trial Balance
Payables, Ledger Totals
General Ledger, Reports, Trial Balance
