QBP 2006 Property Management setup

Nov 20, 2006 2 Replies
J

I need to generate reports such as:


-YTD statement (transaction history) per tenant including security deposit transaction (payment, refunds, damages, deposit transfers to other apartments , cm's, rent per apartment.


-YTD apartment transaction listing with tenant name secondary.



What is the best way to set up tenants? I have seen several different options.



There are 20 apartments in the same building. Currently the apartment building name is the customer and the apartment number is the job. Can't generate complete tenant transaction reports.



Any comments or references would be appreciated.



Security deposits are also setup the same way. I can only print security deposits per apartment without the tenant name. The liabilty only shows the apartment number and not the tenant name, therefor I do not know whose deposit it is, especially any history transactions. Hope to have this revised by new year.



Do not want to use class if possible but would consider it since it is already used for other designated transactions.



This is a HUD property.


Vote
Twitter Facebook LinkedIn
S

Set the tenant up as a job of the apartment. Record all transactions to/from the tenant to the tenant job. R&M would go to the apartment job, not the tenant.

If you use Items like Rent, R&M, Security Deposit, as opposed to the Expense tab, and record all transactions via Sales Receipts, Invoices and Bills you should get accurate reports for your tenant jobs.

I setup individual liability accounts per property. Since I record security deposits with the tenant's name, and assign the tenant job, the security deposits are easy to identify. They sit in that property's liability account with the name information recorded in the transaction.

-- Tara

Vote
Twitter Facebook LinkedIn
Q

You may also want to look at

formatting link
for a software that manages this very well and integrates the accounting with the QuickBooks product line.

Laura QBTra> I need to generate reports such as:

transaction (payment, refunds, damages, deposit transfers to other apartments , cm's, rent per apartment.

building name is the customer and the apartment number is the job. Can't generate complete tenant transaction reports.

deposits per apartment without the tenant name. The liabilty only shows the apartment number and not the tenant name, therefor I do not know whose deposit it is, especially any history transactions. Hope to have this revised by new year.

used for other designated transactions.

name

building. 

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required