Sage Instant Accounts - Opening Balances for Bank Loan
Bracken
Registered Posts: 11 New contributor 🐸
I would very much appreciate it if someone could give me some guidance please.
My client tx accounts from excel to sage during 09/10. 5 years ago they took out a buisness loan and I am getting very frustrated with setting up this loan on sage for this financial year. The accountant provided me with the nominal codes to use and nothing else! This is how I in my novice brain am doing it . .
Opening balance for Buisness Loan (Capital Owed at 7th Apr 2010) N/C 2300 = Cr £1959.96
Monthly payments
Dr Buisness Loan £163.33 N/C 2300
Dr Loan Interest £56.29 N/C 7003
Cr Bank £219.62
It all works fine loan is paid off Interest paid registered but I have a suspense account of £1959.96. Which is what is frustrating me because I cant put it in the bank as the money was received 5 years ago and that will throw my bank reconciliations out, and I dont know where else to put it or do I leave it in the suspense till year end? but that seems wrong to me.
How would you suggest I deal with this please so that it will be in her accounts on sage for this financial year ( accountant added it manually last year I believe)
Many thanks for any help
My client tx accounts from excel to sage during 09/10. 5 years ago they took out a buisness loan and I am getting very frustrated with setting up this loan on sage for this financial year. The accountant provided me with the nominal codes to use and nothing else! This is how I in my novice brain am doing it . .
Opening balance for Buisness Loan (Capital Owed at 7th Apr 2010) N/C 2300 = Cr £1959.96
Monthly payments
Dr Buisness Loan £163.33 N/C 2300
Dr Loan Interest £56.29 N/C 7003
Cr Bank £219.62
It all works fine loan is paid off Interest paid registered but I have a suspense account of £1959.96. Which is what is frustrating me because I cant put it in the bank as the money was received 5 years ago and that will throw my bank reconciliations out, and I dont know where else to put it or do I leave it in the suspense till year end? but that seems wrong to me.
How would you suggest I deal with this please so that it will be in her accounts on sage for this financial year ( accountant added it manually last year I believe)
Many thanks for any help
0
Comments
-
Opening Trial balance
When you transferred their accounts to Sage, did you enter the opening trial Balance?
The £1959.56 credit balance on the loan account n/c 2300 will have been included in this., so you wouldn't have to enter the opening balance on the loan as a separate item.
I assume initially you posted Dr suspense a/c Cr Bank loan account?0 -
If you haven't got opening balances in Sage, your best bet is to post it to suspense and let the accountant deal with it - if you have only got partial opening balances/ brought forward balances then you aren't going to be able to get it right without all the information.
The loan DR would have initially been to the bank but if the bank reconciles then it will be part of the opening balance on the bank. Depending on where sage has put that, might give you a further clue, but suspense might be the best option. I know it's not ideal (but then, if the rest of your bookkeeping is spot on, you have to give the accountant something to do at year end!)0 -
thanks Paul yes i transferred the opening balances he gave me but he forgot about the loan. I believe he added it manually last year in his adjustments. I started by putting the opening balance on this loan account like I had done for the previous opening balances last year. It all worked lovely till I saw the suspense account!0
-
Thanks Monsoon yes all the other bookkeeping is spot on except for these loan repayments and me being the terribly annoying perfectionist that I am would like it included. The loan has now been repaid so think I'll include a note with the accounts telling him what the payments are etc and as you say give him something to do! Luckily its paid out of a personal account so I can still reconcile all the buisness accounts.
New to this forum thanks to you both for taking time to reply and for your advise0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 325 NEW! Qualifications 2022
- 160 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 95 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 274 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 202 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