Jump to content

Tenant Ledger Monthly Post

This topic is 5663 days old. Please don't post here. Open a new topic instead.

Recommended Posts

We have a tenant ledger that on the first of the month we have to go through each one and enter the amount of rent that is due. Time consuming to say the least when you have 200 properties.

We are looking for a way to do this automatically on the first day of the month.

We already have a tenant ledger (that is a portal from the journal line items) and would like it to fill in there.

Any suggestions would be appreaciated



Link to comment
Share on other sites

What I've done is to have a little table for the properties/units, with their rent prices. Then Import that table into the Rent line items table every month. The idea being that you need a record for each unit, even if the rent is not paid.

The tenants auto-enter by calculation from the month before, based on unit. That way if you get a new tenant, you just have to enter them once, and they'll be repeated each month.

The interface to the rents line items was from a Year-month table, with a single record for each month. This serves as a shell to view the rents in a portal, as these things are thought of as "monthly." A script does the creation of the month, which imports to populates the basic info, you just fill in the rents received.

You can also have a table for other expenses, and show it in a portal(s) on the same layout; well, probably on another layout or tab (FileMaker 8) if you have 200 units.

Link to comment
Share on other sites

This topic is 5663 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.