Property Management

[nzatmj]

I'm sure this question has been asked/answered, but I could not find an clear answer. Hopefully someone has a magic formula for me! Here is my situation:

I have 3 properties that have 4-7 tenants. I've created workbooks for each property and each tenant has a separate sheet within the workbook. On the sheet, I have general lease info and a rent payment schedule. I also have to keep track of deposits made for the bookkeeper and 99% of the deposits are rent checks and have made a separate sheet within the workbook for that. Is there a way to link the sheets so that when I put in a rent payment, it automatically populates in the bank deposit sheet? And is there a way to run a report to show which tenants have paid rent for the month?

I'm trying to set up a system that will keep duplicate entry to a minimum and at the end of the year, I can just print up sheets and hand them to the bookkeeper to prepare the taxes. Any help is much appreciated!

Thanks,
Nadia

[Duke Carey]

You make things much harder by having separate workbooks for properties &
worksheets for tenants, at least so far as rent payments are concerned.
Better to use a single sheet for all props/tenants.

On this main sheet have columns for (at least):
1) Property
2) Unit
3) Rental month
4) Payment date
5) Payment amount
6) Maybe a payment type (cash, check, ??)
7) Maybe a payment # (in case a tenant has to make 2 or 3 installments)
8) maybe a comments column (to note bounced checks or other matters)

With this layout you can take advantage of Excel's data filtering and
sorting features, and create pivot tables to analyze & report on your data.


"nzatmj" wrote:

>
> I'm sure this question has been asked/answered, but I could not find an
> clear answer. Hopefully someone has a magic formula for me! Here is
> my situation:
>
> I have 3 properties that have 4-7 tenants. I've created workbooks for
> each property and each tenant has a separate sheet within the workbook.
> On the sheet, I have general lease info and a rent payment schedule. I
> also have to keep track of deposits made for the bookkeeper and 99% of
> the deposits are rent checks and have made a separate sheet within the
> workbook for that. Is there a way to link the sheets so that when I
> put in a rent payment, it automatically populates in the bank deposit
> sheet? And is there a way to run a report to show which tenants have
> paid rent for the month?
>
> I'm trying to set up a system that will keep duplicate entry to a
> minimum and at the end of the year, I can just print up sheets and hand
> them to the bookkeeper to prepare the taxes. Any help is much
> appreciated!
>
> Thanks,
> Nadia
>
>
> --
> nzatmj
> ------------------------------------------------------------------------
> nzatmj's Profile: http://www.excelforum.com/member.php...o&userid=23572
> View this thread: http://www.excelforum.com/showthread...hreadid=525351
>
>