This example illustrates how cash entries are matched to sales invoices when matches are based on Invoice Number, then by oldest document number first. Part payments are allowed.
Before Matching
This table lists the sales invoices and sales credit notes available for matching.
| Invoice Number | Customer | Invoice Value | Outstanding Value | TLI Matching Status |
|---|---|---|---|---|
| SIN000001 | HOWARD LTD | 100.00 | 100.00 | Available |
| SIN000002 | HOWARD LTD | 200.00 | 200.00 | Available |
| SIN000003 | HOWARD LTD | 300.00 | 300.00 | Available |
| SIN000004 | STOREY & CO | 100.00 | 100.00 | Available |
| SIN000005 | STOREY & CO | 200.00 | 200.00 | Available |
| SIN000006 | STOREY & CO | 300.00 | 300.00 | Available |
| SCR00010 | DILLON LTD | -125.00 | -125.00 | Available |
This table lists the cash entries available for matching.
| Cash Entry Number | Customer | Account Reference | Cash Entry Value | Outstanding Value | TLI Matching Status |
|---|---|---|---|---|---|
| CSH000001 | HOWARD LTD | SIN000001 | 100.00 | 100.00 | Available |
| CSH000002 | HOWARD LTD | SIN000002 | 100.00 | 100.00 | Available |
| CSH000003 | HOWARD LTD | 75.00 | 75.00 | Available | |
| CSH000004 | STOREY & CO | 700.00 | 700.00 | Available | |
| CSH000005 | DILLON LTD | SCR00010 | -125.00 | -125.00 | Available |
Where an account reference is specified by the cash entry, that cash entry is matched to the specified sales invoice or slaes credit note. Any surplus will be matched according to the chosen matching condition - in this example it is oldest document number first.
After Matching
| Invoice Number | Customer | Invoice Value | Outstanding Value | TLI Matching Status |
|---|---|---|---|---|
| SIN000001 | HOWARD LTD | 100.00 | 0.00 | Matched |
| SIN000002 | HOWARD LTD | 200.00 | 25.00 | Available |
| SIN000003 | HOWARD LTD | 300.00 | 300.00 | Available |
| SIN000004 | STOREY & CO | 100.00 | 0.00 | Matched |
| SIN000005 | STOREY & CO | 200.00 | 0.00 | Matched |
| SIN000006 | STOREY & CO | 300.00 | 0.00 | Matched |
| SCR00010 | DILLON LTD | -125.00 | 0.00 | Matched |
| Cash Entry Number | Customer | Account Reference | Cash Entry Value | Outstanding Value | TLI Matching Status |
|---|---|---|---|---|---|
| CSH000001 | HOWARD LTD | SIN000001 | 100.00 | 0.00 | Matched |
| CSH000002 | HOWARD LTD | SIN000002 | 100.00 | 0.00 | Matched |
| CSH000003 | HOWARD LTD | 75.00 | 0.00 | Matched | |
| CSH000004 | STOREY & CO | 700.00 | 100.00 | Available | |
| CSH000005 | DILLON LTD | SCR00010 | -125.00 | 0.00 | Matched |
Explaining the results:
- CSH000001 has exactly matched SIN000001
- CSH000002 has part-matched SIN000002, leaving 100.00 still available for matching.
- CSH000003 has no account reference so has been matched against the sales invoice with the oldest document number for HOWARD LTD which is SIN000002. This leaves 25.00 available for matching on SIN000002.
- SIN000003 remains unmatched pending further cash receipts from HOWARD LTD.
- CSH000004 has no account reference so has been matched against sales invoices for STOREY & CO starting with the oldest document number first. SIN000004, SIN000005 and SIN000006 have all been fully matched by CSH000004 and 100.00 is held on account.
-
CSH00005 has exactly matched SCR00010
Instead of matching oldest document number first, if we had chosen to match by highest outstanding value, CSH000003 would have been matched against SIN000003 because its outstanding value 300.00 is greater than the then outstanding value of SIN000002 (100.00).
SECTIONS