Sage Difference

CMS

We are doing our year end but when we print out the trial balance the creditors control account on the TB does not match the printout of the creditors control account. We cannot work out why. Has anyone ever had the same problem and if so how did you fix it?

Thanks
CMS

Monsoon

The simplest explanation could be that someone has journalled directly to the Control account. Have a look to see if there are any journal entries.

Bluewednesday

CMS wrote: »

We are doing our year end but when we print out the trial balance the creditors control account on the TB does not match the printout of the creditors control account. We cannot work out why. Has anyone ever had the same problem and if so how did you fix it?

Thanks
CMS

Do you mean the aged creditors doesn't match or the cc control nominal doesn't match?

PGM

CMS wrote: »

We are doing our year end but when we print out the trial balance the creditors control account on the TB does not match the printout of the creditors control account. We cannot work out why. Has anyone ever had the same problem and if so how did you fix it?

Thanks
CMS

Make sure the report you do is a "retrospective" one.

Check the bank reconciliation is right ie dates & amounts correct.

Lastly, as mentioned, if a journal has gone to the control account this will throw it out. So check for any journals.

qwerty

I had a similar problem last year with a client of ours and it turned out to be allocated payments on account which were causing the problem.

The easiest way to check if this is likely to be the case is to run an aged creditors listing, including all future transactions and payments. The balance on this listing should equal the current balance on sage - if so below should help find the difference.

Try and discover which month the POA(s) took place in (run monthly TBs and aged listings to see which month the difference appears in).

Once you have the month run a report to list all payments on account for that month. Check each of the POAs against the invoices they have been allocated against (a quick first check is to see if any POAs are for the same amount as the difference between TB and aged listing).

If any of the invoice which POAs are allocated against are after the period end, the POA will not show up on the aged listing, but the control account balance on the TB will still be reduced.

Took me a long time to sort this out as when I had this problem there were a few incorrectly allocated POAs!!!

CMS

Thanks for your help. I had a feeling it was to do with the posting on account. Seems sage doesnt like it. I will work on finding the difference.

Thanks again to you all.

CMS