Accounts Payable Trade Accounts

Depending on whether the payment fully pays the voucher, and whether the offset method is S or Y, the system reconciles entries differently. The system reconciles entries when:

  • • The offset method is S and a pay item for a voucher is paid in full by one or more payments.

  • • The offset method is Y and a voucher is paid in full by one or more payments where the total amount matches the voucher exactly.

    If a voucher is paid by multiple payments and the offset method is Y, the system reconciles the entries when a payment amount exactly matches the entire remaining amount of the voucher

This table provides examples of how the R09150 reconciles AE entries in the accounts payable trade accounts:

Vouchers

Payments

Offset Method S (offset per pay item)

Offset Method Y (offset per document)

1 voucher with 1 pay item (10,000.00 USD)

1 payment that pays voucher in full (10,000.00 USD)

All items reconciled.

All items reconciled.

1 voucher with 3 pay items:

  • • 1: 25,000.00 USD

  • • 2: 25,000.00 USD

  • • 3: 25,000.00 USD

1 payment that pays voucher in full (75,000.0 USD)

All items reconciled.

All items reconciled.

1 voucher with 3 pay items:

  • • 1: 350.00 USD

  • • 2: 450.00 USD

  • • 3: 550.00 USD

1 payment that pays pay item 1 in full (350.00 USD)

1 payment that pays pay item 2 in full (450.00 USD)

Pay items 1 and 2 reconciled.

Pay item 3 not reconciled.

No items reconciled.

2 vouchers with 1 pay item each:

  • • 1: 18,000.00 USD

  • • 2: 22,000.00 USD

1 payment for 29,000.00 USD that pays voucher 1 in full and partially pays voucher 2 (18,000.00 USD applied to voucher 1 and 11,000.00 USD to voucher 2).

Voucher 1 reconciled.

Voucher 2 not reconciled.

No items reconciled.

29,000.00 USD doesn't match either voucher amount or the total of voucher 1 and 2.

1 voucher with one pay item for 1,000.00 USD

3 separate payments:

  • • 1: 400.00 USD

  • • 2: 400.00 USD

  • • 3: 200.00 USD

All items reconciled.

All items reconciled.

1 voucher with one pay item for 1,000.00 USD

3 separate payments:

  • • 1: 400.00 USD

  • • 2: 400.00 USD

  • • 3: 400.00 USD

All items reconciled.

No items reconciled because the total amount of 1,200.00 USD for all payments does not match the voucher total of 1,000.00 USD.