Hi this is driving me nuts and is related to previous post about opening balance journals from accountant.
I have entered all the journals as supplied by the accountant but now have a warning of
Sales Aged Balance disagrees with Debtors control account by -397.91 (this is the same as the debit journal from the accountant)
Purchase Aged Balance disagrees with Creditors control account 561.06 (this is the same as the debit journal from the accountant)
When I have entered the journals the comment 'this will not be reflected in your sales/purchase ledger' appears so I am completely confused at what to do to rectify this is Sage.
Yes. Create supplier accounts for each of them and enter the outstanding invoices. I can't think of any easier way but someone more knowledgeable on SAGE may be along with a better suggestion.
My real suggestion would be to put SAGE in the bin :)
Usually if you are entering opening balances from the accountant's TB, post the debtors and creditors to suspense. Then create the customer and supplier accounts and individually enter the invoices via the OB (opening balance) button. Sage automatically posts a customer invoice by debiting 'Debtors control' and crediting suspense. So assuming all your outstanding customer invoices add up to the debtor balance you have been given this will clear the suspense for you. Your invoices will be reflected in the sales/purchases ledger and will equal the control account...hopefully!
Hi Rob, if I already have customer and supplier accounts set up but can't find the discrepancies what do I do then or des it not matter as the invoices are posted to suspense?
Your accountant has made an adjustment to the control account, god knows why, a late invoice or something, I don't really care, but he has journalled it into the control account (and ignored the pop up warnings about doing this).
Here is what I suggest you do.
Next to each control account make an "Accountant Debtors Control Adjustment" account.
Now journal back form the control account to the adjustment account and everything is fine.
You might need to adjust your chart of account to include the auditors adjustment with the control.
__________________
For just about anything Sage :- switch to renting, pay-as-you-go sage support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me.
if you don't know where the discrepancies are from then give the accountant a quick call and say you have entered the opening balance adjustments on but of course the control accounts are no longer equalling the sales and purchases ledger, did he/she make the adjustments to reflect any unrecorded invoices and if so can you get copies so you can post them. Otherwise Bruce's suggestion will balance the control accounts but of course leave balances on the 'accountant control adjustment' which kind of throws it back at the accountant for next year.
