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

Posting property maintenance

Bookkeeping and Management Accounting help does not have to be specific to the use of Sage 50
Post Reply
User avatar
Geordie613
User
User
Posts: 46
Joined: 03 Feb 2015, 17:31
Sage Version: v2018 24 UK/Europe/Africa

Posting property maintenance

Post by Geordie613 » 04 Feb 2015, 11:29

Hi, I'm a newbie on here. I'm a newly practicing bookkeeper in Bury, Greater Manchester.

I've got a new client who has a single property. It is managed by a local agent who has provided him with income & expenditure statements.

Income is rental income; in this case two months rent of £350 each. The expenditure is an 8% management fee with VAT, taken by the agent and an invoice for a gas service which has no VAT. The balance is remitted by the agent to my client's current account.

The client does not require, at this stage at least, specialist property management software, and I would like to use SAGE 50 for this task. But I am tearing whatever hair I have left out trying to get my head around this.

Firstly, who is the customer? The managing agent or the tenant? Or is the agent a supplier? Is the gas repairman a supplier, or should I just record it as an invoice from the agent?

Then, when the tenant pays his/her rent, 8% of that goes to the agent, a chunk goes to the gas man and the balance hits my client's 1200 current account. How is this all properly recorded?

I'm sure once I've done it once I'll be able to replicate it. I'm thinking the least complicated, if not easiest way is via an excel batch journal entry of DRs and CRs until everything is balanced.

I would appreciate any input that people may be able to offer, thank you.
"Difficulties mastered are opportunities won."
Sir Winston Churchill

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

Re: Posting property maintenance

Post by brucedenney » 04 Feb 2015, 12:46

The Tenant is the customer.
The Agent is a supplier of management services
The Gas company is a supplier

This is how I would do it. (You might find it easier to go in the demo company and actually post an example to follow this through)

Set up a bank account called "Managing Agent"

Enter the rent income into the Managing agent bank account, this could be a BR or a SR depending on if you are issuing invoices to the customer.

Enter the Agents Fees as a supplier invoice and pay it from the Bank account as a SP (or maybe just to a BP)
Do the same with any other deductions.

Then transfer form the Managing Agent Account to the Main Bank account, the amount the agent passed over.

Hope this helps


Bruce
(P.S. My sister live in Bury.)
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.

User avatar
Geordie613
User
User
Posts: 46
Joined: 03 Feb 2015, 17:31
Sage Version: v2018 24 UK/Europe/Africa

Re: Posting property maintenance

Post by Geordie613 » 05 Feb 2015, 11:37

Thank you very much Bruce.

I had to experiment a bit with the nominal codes and and the 'bank account' settings, but I've got it working now and I think everything is showing in the right place.

Many thanks again.
(p.s. Whereabouts? I'm in the Prestwich edge of Bury)
"Difficulties mastered are opportunities won."
Sir Winston Churchill

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

Re: Posting property maintenance

Post by brucedenney » 05 Feb 2015, 16:33

She is lives in Whitefield, near Stand golf club.
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.

User avatar
Geordie613
User
User
Posts: 46
Joined: 03 Feb 2015, 17:31
Sage Version: v2018 24 UK/Europe/Africa

Re: Posting property maintenance

Post by Geordie613 » 23 Feb 2015, 11:06

It's been a bit of time, but I'm still dealing with the company mentioned above.

I've received a copy of the previous year's trial balance. It includes a Trade Debtors amount in the debit column of £371.50. I have been told that this is a figure owed to my client by the management company.

I don't know how the previous accountant set up the company. The problem is, the way I have set it up now, is that the management company is a supplier as suggested above. So, when i entered the amount owing, (Tools/Opening balances/Enter opening balances for your suppliers; and under Type I used Credit) it shows up as a debit under N/C 2100 Creditors Control Account.

I'm not sure if this is a major problem, as a negative Creditor is like a Debtor, but I would like it to be uniform and easy for my client to understand.

Could anyone offer me some wisdom please.
"Difficulties mastered are opportunities won."
Sir Winston Churchill

User avatar
Geordie613
User
User
Posts: 46
Joined: 03 Feb 2015, 17:31
Sage Version: v2018 24 UK/Europe/Africa

Re: Posting property maintenance

Post by Geordie613 » 23 Feb 2015, 11:51

I'm just thinking... How would it appear if I added that amount as an Uncleared transaction in the bank account created for the Managing Agent? It would show as a debit balance, but obviously not show in Debtors Control.
"Difficulties mastered are opportunities won."
Sir Winston Churchill

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

Re: Posting property maintenance

Post by brucedenney » 23 Feb 2015, 12:01

The fact that it appears as a part of Creditors as a negative balance is a minor issue. The major issue is that it still exists. If the management company owe it, they should repay it and it should disappear.

The risk is that this is not money owing, that the Management agency does not acknowledge it and it is bunk or that actually it is a "deposit" that is held by the management company as surety or something.

I would focus on resolving the anomaly rather than how it is showing in the accounts.

The bottom line is that is is an anomaly and if it shows as a negative Creditor rather than a positive Debtor is semantics.
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.

Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests