Hi,
I need help to correctly adjust my Trial Balance and this is my query:
We moved into our offices and paid a deposit (posted to n/c 1104 Rent deposit)
We received monthly invoices which included rent, power, service charges and VAT. As we paid these invoices in arrears I set up a Supplier Account and posted each invoice, apportioning each line of the invoice into their correct nominal codes (rent posted to n/c 7100 Rent)
We left the offices and were allowed to set off the rent deposit against rent due, so only part paid the last invoice.
My Trial Balance is showing the amount of the original deposit in n/c 1104
I could do a journal to transfer the amount from 1104 to 7100, but this will still leave me with a balance on the Supplier Account for the short paid invoice.
How do I clear the balance on the Supplier Account without disturbing the trial balance?
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Rent deposit
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Rent deposit
7100 is not where it wants to go, the rent was on the invoice. what you want to do is move it onto creditors control as you are offsetting it against an invoice.
There are several ways to do this. I would raise a T9 credit note against 1104 for the deposit amount of the suppliers account. The deposit nominal will be zero, the supplier account is zero, you just need to match the credit against the balance of the part paid invoice. *(If you are on cash accounting for VAT this method will not work)
There are several ways to do this. I would raise a T9 credit note against 1104 for the deposit amount of the suppliers account. The deposit nominal will be zero, the supplier account is zero, you just need to match the credit against the balance of the part paid invoice. *(If you are on cash accounting for VAT this method will not work)
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: Rent deposit
Bruce,
Thanks for your advice.
Took me a while to get my head around it but it makes sense if I imagine 1104 (rent deposit) to be a kind of deposit account with my money in it. The credit note (n/c 1104) pays the rent invoice from this 'deposit account'.
Accountancy rocks!
Ron
Thanks for your advice.
Took me a while to get my head around it but it makes sense if I imagine 1104 (rent deposit) to be a kind of deposit account with my money in it. The credit note (n/c 1104) pays the rent invoice from this 'deposit account'.
Accountancy rocks!
Ron
Who is online
Users browsing this forum: No registered users and 2 guests