I have checked through and that is the case. The accountant has asked for a TB that matches how do i print one correctly, The difference is a Journal for opening balance at start of the year.? Thanks
Good old opening balances...... No doubt it was posted as the first day of the new year also......
Your accountant should be able to do this (especially if they did the opening balance adjustment....
Journals should never be posted direct to the control accounts. Do you know what is it made up of and what it is adjusting..?
In the first case, journal the entry out of the sales ledger to a 'other debtor code' being sales ledger adjustments.
When you identify what the adjustment was for then you need to enter the relevant sales credits, write offs or what ever the journal was for and post the other side to the 'other debtor account' to clear the journal.
Is a very common mistake
Hope that Helps
Optegra Support
__________________
"Quite simply the best add on for Sage we have ever invested in.."
Want to see what all the fuss is about? Click here: OptegraMRP
I've also had issues with the o/s debtors and creditors not matching the TB by *stupidly* doing the Pay In Full procedure using the wrong Financial Year. Always good for a laugh, that one. NOT.
Sorry, should have said the Pay In Full procedure to clear zero balances where there are debits and credits hanging around on the ledgers, not previously matched off.
Hi Journals in the control accounts, whilst being the most common cause, is not the only reason Sage TB can disagree with the aged Dr's and Cr's listings. It can also be to do with allocations of payments to invoices. If you have a payment on account prior to the report date which is allocated to an invoice after the date this will also report anomolies. There are sage reports available that can give you allocation errors. Send me a message and I can get you these.
