I've got a problem with the creditors control a/c and the aged creditors report showing different amounts in Sage Instant Accounts? I have tried ticking the exclude later payments box but I still get a difference? I don't really want to check all the transactions as there's over 7,500! My client's accountant is chasing me for the records but I don't want to hand over the backup until I've sorted this issue.
I have found there is a strange quirk on Sage when you allocate credit notes or payments on account to purchase invoices, and where the purchase invoice is dated within the end date of your aged creditors report, but the credit or payment on account is after the end date. I have found it also happens if the payment on account is within the date range, but the invoice is after.
I think you will find that the invoice with an allocated credit note or payment on account does not appear in the aged creditors report. I have found that the creditors control account amount in the trial balance is the correct one to use. If you don't want to look for the difference, I would just print the aged creditors report and make a note of your assumption for the difference on the printout to give to the accountant.
__________________
"People who are exceptionally good in business arent so because of what they know but because of their insatiable need to know more"