kdoederlein
New Member
- Joined
- May 10, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I don't believe that this particular question has been asked so if it has I apologize in advance. I am provided with a pdf of a transaction log from my client/landlord for each tenant that they are requesting Eviction proceedings for. It looks like this:
Now I have to convert this to an excel spreadsheet and then try to determine the amounts I need. When we file the documents with Court I have to determine the total amount of Rent owed to date, the amount of Water/Sewer, Late/Registration and Pet fees all separately. This is further complicated because there are late payments made and I need to apply these payments to the oldest debt (applied to all of the fees and rent combined) to find out when the tenant has actually paid their rent through (the month they owed no rent but may owe other fees). How can I calculate the amounts owed to date for each line item while applying payments to the oldest debt and then (as this is a process that can take months) apply new rent and costs that are due in successive months? I don't know if I have explained this well because quite frankly I have tried to solve this on paper and can't figure it out! I can't quite conceptualize the layout or process needed to make this simple as payments can be made three months from now and there are sometimes 3 pages of transaction logs! THANK YOU!
Now I have to convert this to an excel spreadsheet and then try to determine the amounts I need. When we file the documents with Court I have to determine the total amount of Rent owed to date, the amount of Water/Sewer, Late/Registration and Pet fees all separately. This is further complicated because there are late payments made and I need to apply these payments to the oldest debt (applied to all of the fees and rent combined) to find out when the tenant has actually paid their rent through (the month they owed no rent but may owe other fees). How can I calculate the amounts owed to date for each line item while applying payments to the oldest debt and then (as this is a process that can take months) apply new rent and costs that are due in successive months? I don't know if I have explained this well because quite frankly I have tried to solve this on paper and can't figure it out! I can't quite conceptualize the layout or process needed to make this simple as payments can be made three months from now and there are sometimes 3 pages of transaction logs! THANK YOU!