yeboyye
Blogger
Share this content
0
9
14280

Sage T Balance and Debtors,Creditors

Sage T Balance and Debtors,Creditors

I am working at Accounts for the year ended 31 March 2011.  Client has Sage Instant Accounting.  I have printed a Trial Balance and Aged Debtors and Aged Creditors.  The balances on the Trial Balance for Debtors and for Creditors are different from those on the Aged lists.  Has anyone any ideas on how to reconcile these figures?

Replies

Please login or register to join the discussion.

avatar
24th Jun 2011 14:51

Difference...

If you run Check Data, are any errors reported? 

If there are no errors, are there any warnings relating to the difference between the TB & the Aged Reports.  If there are warnings, the first thing I'd do is look on the Debtors and Creditors control accounts for journal entries which would give rise to the warnings.

If there are no errors or warnings relating to this then it would suggest that the reports have not been run for the same date range.

John

Thanks (0)
24th Jun 2011 15:15

I assume ...

 you have exlcluded later entries when running the aged reports? Otherwise almost certainly journals are to blame.

Thanks (0)
avatar
By occca
24th Jun 2011 16:18

This is a known bug

This is an error that has been in Sage for a long time

If you have checked what the other posters have advised then you need to do the following :-

1. Supplier Activity - run the detailed report for the year, including brought forward info and excluding later payments

2. You will see two columns - Balance and Outstanding - these should agree for each supplier

3. If they don't , this will be your difference

If a payment is entered prior to the year end and the invoice is entered after the year end Sage cannot unmatch these transactions when running the aged reports

 

Thanks (0)
avatar
By thomas
garyturner
25th Sep 2014 14:15

Thanks OCCCA

occca wrote:

This is an error that has been in Sage for a long time

If you have checked what the other posters have advised then you need to do the following :-

1. Supplier Activity - run the detailed report for the year, including brought forward info and excluding later payments

2. You will see two columns - Balance and Outstanding - these should agree for each supplier

3. If they don't , this will be your difference

If a payment is entered prior to the year end and the invoice is entered after the year end Sage cannot unmatch these transactions when running the aged reports

 

Thank you.  I've jus used this to solve a similar issue

 

Thanks (0)
avatar
By yeboyye
24th Jun 2011 17:39

Sage T Balance and Debtors,Creditors

Thanks for the prompt replies.  No errors or warnings on the Data Check.  I have to leave client's office just now so I will check occca's suggestion another day.  Will keep you posted.

Thanks (0)
25th Jun 2011 08:26

Do it manually

If none of the above suggestions work you can always find the difference manually as follows:

Check the balances at the end of each month.

For any month where there are differences generated you can export the transactions to Excel.

Sort the transactions on a common field and compare the two sets of transactions.

This will highlight any differences.

Thanks (0)
avatar
26th Jun 2011 21:52

Possible reasons

Do not post journal entries to the debtors and creditors ledgers, as no ledger account is included. These make the trial balance disagree with the list of balances.

When printing the list of balances chose the correct period end and exclude later payments; if chosing the detailled list, make the date range start at 01/01/1980.

When allocating invoices and payments make sure that the allocation date is the same as or later than the latest date of any invoice, payment etc. involved in the allocation. If an earlier date is chosen any list of balances produced dated between the actual allocation date and the allocation that should of been used will be incorrect. Balances list with later dates are unaffected.

There may be other reasons for the difference that I don't know about.

Thanks (0)
avatar
26th Jun 2011 21:54

Possible reasons

Do not post journal entries to the debtors and creditors ledgers, as no ledger account is included. These make the trial balance disagree with the list of balances.

When printing the list of balances chose the correct period end and exclude later payments; if chosing the detailled list, make the date range start at 01/01/1980.

When allocating invoices and payments make sure that the allocation date is the same as or later than the latest date of any invoice, payment etc. involved in the allocation. If an earlier date is chosen any list of balances produced dated between the actual allocation date and the allocation that should of been used will be incorrect. Balances list with later dates are unaffected.

There may be other reasons for the difference that I don't know about.

Thanks (0)
avatar
By yeboyye
05th Aug 2011 18:05

Many thanks

Thanks to you all.  Since my original post I have not been back to the client's office until today.  I tried occca's solution and can confirm that it was successful.  A Sage bug!

Thanks (0)