The Book-keepers Forum (BKF)

Post Info TOPIC: Opening Customer Balances


Member

Status: Offline
Posts: 10
Date:
Opening Customer Balances
Permalink Closed


Hi all

 

I've recently taken over the bookkeeping for a ltd company and had a trial balance from the old bookkeeper so I could enter my opening balances

 

The debtors control account had a debit balance of £35379.98.

I know to make it balance I now need to enter opening balances to the customer accounts but which nominal code do I enter them to? Also what happens regarding the vat, do I need to enter the vat amount or not as its already included in the opening balances?

 

Any help much appreciated.

 

Nic

 

 

 



__________________


Expert

Status: Offline
Posts: 2021
Date:
Permalink Closed

Hi Nic, are you using Sage?

__________________


Member

Status: Offline
Posts: 10
Date:
Permalink Closed

Hi Michelle

Yes it is sage I'm using, sorry forgot to add that bit!

__________________


Newbie

Status: Offline
Posts: 4
Date:
Permalink Closed

Assuming you are not cash accounting for VAT? - Enter the opening balances in to the Customer Accounts using nominal code 9998 Tax code T9. Run the Aged Debt report and make sure it balances to the total amount owed - enter the opening trial balance and then enter the debtors control total to nominal code 9998.

(As I am a newbie you might just want to get Michelle to confirm that the above is correct) :@)

 

The picture attached might help to explain further.



-- Edited by Elspethaq4b on Friday 17th of January 2014 05:04:51 PM

Attachments
__________________

Elspeth Webb

 "Creating Qualifications for the 21st Century

  

E elspeth@aq4b.com

W www.aq4b.com

 



Expert

Status: Offline
Posts: 2021
Date:
Permalink Closed

Elspeth is correct.

Enter your opening balances, posting the debtors figure to a temporary code. I actually use sundry debtors 1101 and sundry creditors 2101 (as you probably need to do this process for both, and this keeps it separate).

You then use your debtors(creditors) breakdown to enter invoices.

If you are on standard accounting, you enter these as T9 to code 1101/2101

If you are on cash accounting, enter them as T1 to 1101/2101. Once you have posted everything on, you should find that 1101/2101 is out by the VAT on these invoices. You then journal the VAT amount from 2200/2201 to 1101/2101

Hope this makes sense but do post again if you are unsure

__________________


Member

Status: Offline
Posts: 10
Date:
Permalink Closed

Thanks Michelle and Elspeth for your help.

That makes perfect sense.

Nic

__________________
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