Running creditors reports retrospectively

 If you run the trade creditors report retrospectively, why doesn't it agree to the trial balance? How do you get it to balance?

Lets say that you’ve just finished your June month end. You’ve run your creditors report and it reconciled to the June  trial balance so you close the periods in Sage.

You then post in July an invoice dated May so it appears in the July general ledger as May is already shut.

You then run the AP report for June and tick the retrospective button....but it doesn’t agree to the June TB as it now includes that pesky May invoice

What am I doing wrong? Or are there settings in Sage causing this issue?

Parents
  • 0

    First up, what Saeed suggests is totally valid, but a quick way to see if you have a physical imbalance is to run a TB to the future, then add any amounts for Creditors control from Current/Deferred postings, then compare the figure to a creditors control report run to the future again.  If this agrees then it'll either be an allocation date, late postings (both as Saeed suggests.)  If the figure doesnt balance, it could be Journals or postings to the PL creditors control (as per Saeed), or it could be good old fashioned corruption, so Balance ledgers (after a backup has run) PL and NL to check.  

    Other ideas could be Opening Balance Invoices/Credits (which affect PL and not NL), or a crash (which has posted to PL but not posted the NL elements.)

Reply
  • 0

    First up, what Saeed suggests is totally valid, but a quick way to see if you have a physical imbalance is to run a TB to the future, then add any amounts for Creditors control from Current/Deferred postings, then compare the figure to a creditors control report run to the future again.  If this agrees then it'll either be an allocation date, late postings (both as Saeed suggests.)  If the figure doesnt balance, it could be Journals or postings to the PL creditors control (as per Saeed), or it could be good old fashioned corruption, so Balance ledgers (after a backup has run) PL and NL to check.  

    Other ideas could be Opening Balance Invoices/Credits (which affect PL and not NL), or a crash (which has posted to PL but not posted the NL elements.)

Children
No Data