The Book-keepers Forum (BKF)

Post Info TOPIC: Journal entries on Sage


Member

Status: Offline
Posts: 20
Date:
Journal entries on Sage
Permalink Closed


I have been told I need to put journal entries through the accounts as the vat was not recorded in the opening balance figures.
There are sales and purchase ledger invoices.
Can someone please tell me the accounts I should be debiting and crediting so I can see if I have done it correctly?

Thanks

__________________


Guru

Status: Offline
Posts: 882
Date:
Permalink Closed

do you mean that the opening figures were not balanced? or do you mean that the VAT element was excluded completely when the invocies were posted previously?

__________________


Member

Status: Offline
Posts: 20
Date:
Permalink Closed

The company I am employed by have had to move from a single cash system. The one they are running down records payments on receipt or payments when made, they do not input invoices as such beforehand. This is totally alien to me.

When I was employed the Accountant sat with me and told me to input all the balances outstanding as at 31 Mar 09.
These were input but all as gross figures.
Now I am being told vat should have been taken into account and I am trying to find out if this is the case.

Hope you can help

Thanks

__________________


Guru

Status: Offline
Posts: 882
Date:
Permalink Closed

ok, another question is - are these opening figures the year end opening figures or just because you are moving the data to Sage.

If they are just moving to Sage, I guess you will have posted the Sales Invoices to a 4000 code? The it will be just a case of doing a journal to move the VAT element

DR 4000
CR 2200  Sales Tax Control Account

This will have the effect of removing the VAT from the P&L and placing it on the Balance Sheet.

When the time comes to do the VAT, be careful to ensure the correct Output Tax is journalled to 2202 VAT Liability.



__________________


Member

Status: Offline
Posts: 20
Date:
Permalink Closed

These are the figures from the year end. The company had to move their accounts onto Sage as from 1st April this year.
The Accountant told me to input the outstanding balances ie purchase/sales ledger invoices to the suspense account then do the relevant journals.

All entries were input as gross figures but now I am being told vat should have been included.

I have put journals through for the vat elements by debiting the sales/purchase tax control account and crediting the creditors/debtors control account. Now I am wondering if this is correct but if I had input the entries to the suspense account I would still have to journal them out.

Hope this makes sense

__________________


Guru

Status: Offline
Posts: 882
Date:
Permalink Closed

so if the entries are from the year end, they will be balance sheets items only and the amount in the debtors control account should be gross figures anyway - so now I'm a little confused as to what figures you are transferring over, as the VAT would have been a separate entry from the year end figures...

if the VAT was not accounted for before the year end, that would mean the sales figures have been overstated etc and the P&L would be wrong



__________________


Newbie

Status: Offline
Posts: 1
Date:
Permalink Closed

To set up opening balances in Sage for Purchase and Sales Ledgers, one sets up the individual account first.

I.E. Go to Customers and either use tab New or Record & set up the customer. This is where opening balances are input & Sage deals automatically with the VAT & posts the other half of the transaction to suspense. It sounds as though you haven't set up the individul Customer accounts in the Sales Ledger.

If this is the case, and have Journalled in opening balances to the Sales Ledger Control Account, you'd do best to reverse those journals & input the opening balances in the correct way.

You always want the individual Sales & Purchase Ledger Accounts Balances to total the Balance of the Control Account. Thus one should never Journal transactions into the Control Accounts

Regards

Mike Page

__________________
Mike Page MichaelPageAccounting.co.uk
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About