Understanding Vendor reconciliation match sequences

Say you recorded three bills for a vendor, in the amounts 100, 500, and 1000. Before you make any payment against the bills, they display in the Vendor reconciliation report as follows.

Sage Intacct has not assigned a match sequence to any of these transactions because you have not yet applied a payment or a credit against them.

After you pay bill 410 in full and make a partial payment against bill 526, your Vendor reconciliation report shows as follows.

You can see how payments were applied to transactions by following the match sequence:

• Sage Intacct assigns a match sequence of F to bill 410 and a match sequence of g to bill 526.
• The F match sequence is in upper case letters because bill 410 is fully paid, as you can see from the matching payment entry in line 5.
• The g match sequence is lower case because bill 526 is partially paid, as you can see from the matching payment entry in line 6.

When a single payment is applied to multiple transactions, the report shows each amount that was applied to a single transaction on its own line.

For example, say you have 3 bills for a vendor that total 450. You pay all three bills in full with a single payment. Instead of showing a single payment line in the amount of 450, the Vendor reconciliation report lists each payment individually, with a match sequence that corresponds to the bill that was paid.

In this example, the match sequences are all in upper case because all three transactions were paid in full.

Say you have a vendor credit C390 in the amount of 50.00 and bill 4001 in the amount of 500.00. When you pay the vendor, you apply credit C390 to the bill along with a check payment in the amount 450.00.

In this scenario, the Vendor reconciliation report shows the following entries.

• The credit (line 1) is given a match sequence of K and the bill (line 2) is given a match sequence of L.
• Application of the credit (line 4) and the check payment (line 5) both match to the bill.
• The balancing entry for the application of the credit (line 3) matches to the credit (line 1).

Say you have a bill in the amount 100 and you make payment in full. The Vendor reconciliation report shows an entry for the bill (line 1) and the payment (line 2). Sage Intacct assigns an uppercase match sequence (N) to these lines.

You discover the payment was made in error and void the payment, without reversing the bill. When you view the Vendor reconciliation report again, you see an additional entry (line 3) that reverses the payment. The bill, payment, and reversal all have the same match sequence, which is now lower case because the bill is not fully paid.

Say you have a bill in the amount of 1000 and a credit (debit memo adjustment) in the amount of 50. You apply the credit to the bill and then later make full payment on the balance.

When you run the Vendor reconciliation report, you see that the bill, credit application, and payment are matched using the sequence S. The credit and the balancing entry are matched using the sequence T.

Later, you discover that the credit was issued in error, and so you reverse the debit memo adjustment. When you run the Vendor reconciliation report again, you see the following:

• The match sequence for the bill is now in lower case, because the bill is no longer fully paid (line 1).
• A new Reversed Adjustment entry (line 3) adds a charge for the adjustment amount, reversing the adjustment that was previously applied (line 2).
• The adjustment payment entry (line 5) and the corresponding balancing entry (line 5) are now zeroed out.
• 2 lines balance the new Reversed entry and 2 more lines balance the Reversal (lines 7 through 10).
• The ending balance is 50.00, the remaining unpaid amount.