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

Rent deposit

Bookkeeping and Management Accounting help does not have to be specific to the use of Sage 50
Post Reply
ronnieg
User
User
Posts: 8
Joined: 06 Aug 2013, 13:41
Sage Version: v2010 16 UK/Europe/Africa

Rent deposit

Post by ronnieg » 15 Aug 2014, 13:17

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?

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Rent deposit

Post by brucedenney » 17 Aug 2014, 14:02

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)
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.

ronnieg
User
User
Posts: 8
Joined: 06 Aug 2013, 13:41
Sage Version: v2010 16 UK/Europe/Africa

Re: Rent deposit

Post by ronnieg » 18 Aug 2014, 08:58

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

Post Reply

Who is online

Users browsing this forum: No registered users and 10 guests