I absolutely agree that the tenant should be allowed to pay in a manner that is best for him. As long as it is on time
But as a landlord you want to get the easiest to understand statement that is possible. You don't want to have to go through mental gymnastics every month and for every differrent style of statement that you receive.
In relation to the credit shown I will try and discribe how I understand the figure shown.
This credit is a running balance that shows that the tenant has paid an amount in advance of the rental period indicated but that the amount is not sufficient to cover a full rental week.
So in the case of 'Unit 4' at the initial entry there was already a payment of $80 credit on the previous statement, his payment of $280 added to the credit as it was $70 more than the weekly rent. This then gives a new credit of $150. But as the rent is $210 this is credit is insufficient to ledger a full week, so its again carried forward.
The next period show the tenant paid $210 thus the credit stays at $150.
The next period the tenant paid $260, $50 over the rent and this $50 is added to the credit, now $200 still $10 short of a whole week.
Final period show tenant pays exaclty $210 thus credit stays at the $200.
Ones the credit reaches or exceed the weekly rental amount then it will be reduced by a multiple of the whole weekly rent and you would see the date move to cover not only the rent currently piad but also the credit period applied.
Throughout all of this the actual money that generated the 'credit' is actually remited to the landlord as per the figures in the credit column. So as a landlord you get the money immediately but the tenants ledger is short.
So at the end of the whole period 'Unit 4' status is actually paid up to 13/5 + 7 days * 200/210.
For us the problem occurs on this adjustment entry as there is a time when your statement will show two weeks piad but the money remitted is only for 1 week. This occurs because we have already been paid the money in a previous statement.
This has never been a problem until recent years with the entry of new software into the market place.
Prior to this change I had a simple check per property
1/ end date from previous statement for property =+1 start date on current statement for property.
2/ rent for property in credit column = the number of weeks between the start and end date for the property on the current statement.
Went on a bit, sorry but this has been a bone of contention of late trying to get new PM to my piint of view.
Cheers