Forum

• # 83307
• Wed 20 Jun 2012 07:31 AM

Hi - hoping someone can help.

Currently using Sage 12.01 with a client (we are switching very shortly to another package) and trying to understand how postings of sales invoices and bank receipts feed into the sales nominal - as the totals don't match the figures in the vat calculation.

For some customers invoices are raised through the customer's section (and show as SI) but other sales (from streamline) are being recorded in the bank as bank receipts (coded T1 to 0005).  The sales figures in the vat calcuator include both the SI and BR - which matches to my sales spreadsheets.

However, the nominal total doesn't appear to relate to the total sales shown on the VAT calc or indeed anything else.  There was an opening balance, but it was minimal and doesn't equate.

There is a load of historical data (back to 2008) which I think complicates the situation - am not sure year ends have been done properly in the past.

Any help in understanding how/why sales nominal doesn't match the VAT sales figures welcome (or maybe it's not meant to??).  

I need to extract opening balances to take into the new software but don't want to bring forward inaccurate figures.
 
Thanks

Lou


 

• 
  Quote
  

• # 83329
• Wed 20 Jun 2012 07:47 PM

You will need to use a nominal code other than 0005.  On Sage all nominals 3200 and below are balance sheet codes and those above are for P&L.  So even though you've given 0005 a T1 code which is being picked up for the VAT return it won't appear as a Sale on your accounts.

• Shirley
• 
  Quote
  

• # 83361
• Fri 22 Jun 2012 05:42 PM

Hi Lou,

Not sure if you're using the standard sage nominal, or if it's been interfered with in the past by predecessors, but the sales accounts are all in the 4000 family and the bank receipts should all be posted to there. I imagine the default code for sales is 4000 in your customer ledger, which is why the SI transactions seem to be ending up in the correct place?

As an aside, I think you've got the p&l/bs nominals muddled up there, Shirley? Balance Sheet '0010' - '3200' , P&L '4000' to the end (apart from the 99's, which can be treated as either, although I always think they should be on the balance sheet really!)

• Kind Regards 

  Karen Jewell

  Karen Jewell Ltd

  Bookkeeping~Accounts~Payroll

  www.karenjewellltd.biz

   

   

   

• 
  Quote
  

• # 83363
• Fri 22 Jun 2012 06:13 PM

Thanks for your advice - the whole COA looks to have been customised (no idea why) - every code (except suspense) starts with 0.

Think will wait for the accountant to come back with year end figures and then try to work out the details from there.

Hoping the new software does what it's anticipated to do!

Lou 

• 
  Quote
  

• # 83385
• Sat 23 Jun 2012 07:35 PM

Hi Lou,

Eeek - sounds like the new software can't come a day too soon!!

Good Luck with it :-)

• Kind Regards 

  Karen Jewell

  Karen Jewell Ltd

  Bookkeeping~Accounts~Payroll

  www.karenjewellltd.biz

   

   

   

• 
  Quote
  

• # 83387
• Sun 24 Jun 2012 08:56 AM

If you go to the company page showing the nominal ledger - along the top there should be a report called COA - if you click on that it will fetch up the charts of accounts stored within the company - again click on that and that should show you where the nominals are feeding too. Hope that helps

• 
  Quote