Forum

• # 78489
• Thu 19 Jan 2012 08:21 AM

Hi All,


I'm working for a company and have just taken over from the previous bookkeeper. After looking at the creditors control account and aged creditors summary (they use Sage 50), they do not match.

I have gone through to see if any journals were posted but I can't find any. Does anyone know what else might make a difference in these totals? I've tried excluding later payments, including furture transactions etc. but no luck.    

• 
  Quote
  

• # 78490
• Thu 19 Jan 2012 08:27 AM

Have you checked for data corruption? The only other thing I can think off is direct postings from a bank account, I'm not entirely sure if it's still possible to do this in Sage but it was in the old "dos" versions.

• 
  Quote
  

• # 78492
• Thu 19 Jan 2012 08:53 AM

Hi Lady M,

I had this same problem when I started with my company. After my investigations, it was all down to some Purchase invoices being dated incorrectly when first being posted, i.e 01/01/2010 instead of 01/01/2009, then corrected through the maintanence option. Eventually these do 'come out in the wash'.

However. I also had the problem that the accountant had done an adjustment to the control account for some of  the differences, but when the deleted items 'came out in the wash' it caused the difference again, only the oppossite way round. I have waited for the other differences to sort themselves out (in the dated example above, this would sort itself out in March 2010), then I did reversal journals for the accountants journals, and now it matches!

Now, if I enter an invoice dated incorrectly, I will credit it and re-post the invoice, to avoid anything like the above happening.

Hope that makes sense and helps!

Kind regards,

Kerry

Edited at 19 Jan 2012 08:54 AM GMT

• www.berrybookkeeping.co.uk
  
  My responses are based on my opinions, not necessarily facts.
• 
  Quote
  

• # 78528
• Thu 19 Jan 2012 09:42 PM

Hello LadyM

Don't you just lurve inherited problems!

From my experience, it has to be journalling straight into/out of the 2100 account. It is the only way the balances wouldn't match - everything else would hit the creditors summary.

If it's not in the current financial year, try previous years.

If you still can't find it, look in Financials, sort by Nominal Code, and scroll down (or use Search facility) for 2100. It'll be there somewhere!

Good luck and keep us posted (pardon the pun!).

Helen x

• 
  Quote
  

• # 78537
• Thu 19 Jan 2012 11:54 PM

Hi LadyM

I have come across this problem a few times over the years. It tends to arise when a payment on account is allocated to and invoice after the period date of the if the Aged Creditords.

The reason it does not show up is the when you tick exclude later payments it does not re instate the allocated payment even though the invoice is after the date i.e. it is not a later payment. However as it is allocated to an invoice it will not show on the aged creditors. 

Sage have suite of reports you can download to pick up this specfic issue (I have been told by some sage operators the reoprts do not exist but if you insist they do they will eventually get you to download them).

I hope this makes sense if not e-mail me stuartwildman@yahoo.co.uk with your contact details and I will talk you through it.

Kind regards
Stuart    
         

• Forum Moderator, South East & Greater London Regional Chairman
• 
  Quote