Matching Example

Let's assume that the following sales invoices have been raised for the same customer account.

Document number Document date Document Value
SIN000001 January 6, 2014 100.00
SIN000002 January 8, 2014 200.00
SIN000003 January 10, 2014 300.00

The examples below indicate how these sales invoices will be matched depending on the matching mode specified on the bank lockbox and whether or not document references are supplied:

  • If Matching Mode = Document, and your cash entry for 150 specifies the Document Reference SIN000001, 100.00 of that cash entry will be matched to SIN000001 and the remaining 50.00 will be left for you to match manually. It will not be automatically matched to another invoice.
  • If Matching Mode = Document Date - Oldest First, and your cash entry for 150 specifies the Document Reference SIN000001, 100.00 of that cash entry will be matched to SIN000001 and the remaining 50.00 will be matched to SIN000002 (reducing that invoice's outstanding value to 150.00).
  • If Matching Mode = Document Date - Oldest First, and your cash entry for 350.00 specifies no document references, 100.00 will be matched to SIN000001, 200.00 matched to SIN000002, and 50.00 matched to SIN000003.
  • If Matching Mode = Document Date - Newest First, and your cash entry for 350.00 specifies no document references, 300.00 would be matched to SIN000003, and 50.00 to SIN000002.