How Matching and the Paid To Date work
Posted by Nyree Tomkins, Last modified by Duncan Clarke on 25 February 2019 03:43 PM
On the Agreement table there are 4 fields which attempt to split the agreement balance by income stream.

These are:

TotRentUnpaid = Total unpaid rent
TotLateUnpaid = Total unpaid late fees
TotInsUnpaid = Total unpaid insurance
TotOthrUnpaid = Total "Other" unpaid transactions

The Paid to Date changes based on the value in the TotRentUnpaid field
If the agreement is in credit (ie the balance is negative) so will the TotRentUnpaid field be (the balance will default to this field)
The value of these 4 fields changes when receipts are added, and is dependent on how they are matched to charge transactions.

When a receipt is added, Storman looks at all unmatched charge transactions and determines which charge to match it to based on the following rules, in this order:

1) Match to the earliest exact amount (even if the exact charge is in the future and there are other unmatched charges in the past)
2) Match to the earliest combination of charges that will sum to the receipt amount.

If there are 2 transactions on the same date of the same amount, a rent charge will take priority.

Where there is not an exact match, the receipt remains unmatched.
Storman will then attempt to estimate the amount of income still unpaid in the 4 income streams, based on assigning the receipt with the following priorities:

Priority: Earliest unmatched charge in the past (prior to the date of the receipt). If there are 2 receipts on the same date, rent takes priority.
then: Earliest unmatched charge in the future (from and including the date of the receipt). If there are 2 charges on the same date, rent takes priority.

If there are no unmatched charges, the receipt is assigned as a credit to the TotalRentUnpaid field. This will push the Paid to Date into the future.
If there are 2 unmatched charges on the same date, rent charges take priority

NOTE: In Storman One a user can manually match a receipt to specific charges to override the above rules. If they run 'check matching' this could override their choice based on the above rules.
For facilities that use the cash accounting method, check matching can re-assign the way income is distributed. 
This is because the automated process starts from the top of the trx list and works it's way down, based on the above criteria. 
In real life, transactions are added and deleted at different times with prior or future transaction dates, and the order of that happening can give a different match result than if you took all the transactions and matched them all at the same time.
(0 vote(s))
Not helpful

Comments (0)