Posting a Purchase Invoice for a loan including part ex
Cordie
Registered Posts: 12 New contributor 🐸
Following on from my previous post about loans, thanks guys for replying, I went back to enter the actual details and have now got really bogged down as I cannot fathom the double entry on part of it.
Okay deep breath!
Purchase invoice for £202,750 + VAT
Less £16,000 + VAT for piece of equipment not on books
Leaves £186,750 + VAT
Deposit paid through bank of 10% - so £18675 + VAT (£21943.15 - has left bank)
So assume loan will be £168,075.00
I am trying to enter all this onto SAGE and just don't seem to be able to do it as the part exchange will have to be entered as sundry income, the invoice mentions VAT to contra on the part exchange and they wanted a sales invoice from us for it. I am just lost in a sea of double entries, there has to be a simple way of doing this that I am missing, as it never balances I am always left with a lump of VAT thats left over.
HELP!
Okay deep breath!
Purchase invoice for £202,750 + VAT
Less £16,000 + VAT for piece of equipment not on books
Leaves £186,750 + VAT
Deposit paid through bank of 10% - so £18675 + VAT (£21943.15 - has left bank)
So assume loan will be £168,075.00
I am trying to enter all this onto SAGE and just don't seem to be able to do it as the part exchange will have to be entered as sundry income, the invoice mentions VAT to contra on the part exchange and they wanted a sales invoice from us for it. I am just lost in a sea of double entries, there has to be a simple way of doing this that I am missing, as it never balances I am always left with a lump of VAT thats left over.
HELP!
0
Comments
-
Cordie,
I had something similar recently - it had me scratching my head for a while! Can't work your figures out - are you sure your assumed figure for the loan is correct?
Not much help I know, but I'll have a look how I posted my PI when I get back to work tomorrow. I do know that I had to post a sales invoice for the sale (in my case) of the asset.
You'll probably look at it again in the morning and it'll just fall into place. :001_smile:0 -
Hi Cordie
I would post as follows:
Open a supplier account and post the £238,231.25 invoice to fixed assets (£35,481.25 input VAT)
Open a customer account and post a sales invoice for the part exchange £18,800. £16,000 credit to capital introduced or DLA, £2,800 output VAT. [ you do not say if this is a ltd company or not and I have assumed that the asset has been provided to the business by an owner or a director as it is not already in the 'books'] and post this invoice to the supplier.
In the bank account post a supplier payment for the 10% of £21,943.15
Then in a bank account that you do not use I would:
Post a bank receipt for £18,800 to the customer account to take that to nil.
Post a bank payment to the customer account for £18,800.
The balance on the supplier account should now be £197,488.10. The amount of the loan.
Go back to the bank account that you do not use and
Post a bank payment to the supplier for the £197,488.10, to take that account to nil. (reconcile off)
Post a nominal ledger receipt, outside the scope for VAT (T9) to 2300 loans or 2310 HP for the amount of the loan £197,488.10
Reconcile the bank account to nil for tidiness.
I think that you became confused with the VAT. Only two entries have this attached the loan does not so £168,075 + 17.5% = £197,488.10 that is the amount of the loan.
If I have a client that has several loans like this then I also open different NL accounts for each loan for control.
Regards
Poodle1 -
Poodle you beat me to it! :001_smile:0
-
Hi guys
I went in today and had a go at doing it, I used a contra account to enter some of the transactions and did pretty much as you suggested Poodle, only thing was I put the sales invoice to sundry income.
You are right, I confused the VAT this was partly me and partly the nature of the very confusing invoice sent by the supplier. I rang them and they admitted they were confused, couldn't remember how or why they had done what they had and yes, it was wrong anyway!
I am quite annoyed really as the accounts are in a complete mess, they have several loans for which they have lost the paperwork, and some which they neglected to tell me were where the machinery is purchased by the HP company so I am trying to locate invoices on statements from suppliers that we have never seen anyway. Then they pass a comment that it seems to be taking a while to get the accounts up to speed. I have had 3 seperate people entering things into SAGE TOTALLY getting it wrong and I am having to sort the mess! Ooooh clients sometimes!!!!0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 323 NEW! Qualifications 2022
- 165 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 88 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership