Hi there,
I am trying to make an app to track rent collection. So far, I have a payments table with the following columns:
- Payment ID
- Tenant ID
- Assignment ID (Tenant paired with contract period table)
- Payment type (rent, damages, etc.)
- Month (month that the rent applies to, enumlist)
- Amount Due
- Amount Paid
- Payment Method
- Check Number
- (The rest of the columns are for bills 1,5,10,20,50,and 100)
Sometimes, tenants pay for multiple months in advance. I plan on being able to record one payment (for example, $1,000 for two months instead of $500 and it applies to January and February rent using an enumlist), but I have a problem.
The owner wants a deposit slip for all of the checks and then a deposit slip for all of the cash when he takes the money to the bank. I can easily take the payment and filter the payments by payment method, but we also have a spreadsheet that shows all of the tenants and all of the months of the contract period. The totals for each month are then displayed at the bottom where he then uses that information to check against bank records. So the problem is that I record in one spot a tenant paying for two months ($1,000) but then I need a way to show that information as $500 and $500 for the months of January and February in their respective columns in the main spreadsheet.
So my question is, how could I go about making those two different reports? Deposit slip reports and an overall report? I was contemplating having an equation that counts the number of months recorded, dividing the amount paid by that number and then somehow recording that. I could also record those two months as separate and then combine them based on check number or something else for the deposit slip.
Any ideas on what I could maybe do?