Accounts Payable

Reconcile payments and credits to AP supplier invoices

Easily see how payments and applied credits match to AP supplier invoices using the Supplier reconciliation report. At a glance, you can see not only how much you owe a supplier, but also how payments and credits were matched to AP supplier invoices.

The Supplier reconciliation report answers the following types of questions:

  • Which credits and payments were applied to a given AP supplier invoice?
  • Where was a given credit applied?
  • Which transactions share a specified match sequence?
  • What transactions remain partially matched or not matched at all?

The reconciliation report matches transactions using lettering sequences, helping you evaluate how payments and credits were applied.

Details

Match sequences are alpha document sequences used in the Supplier reconciliation report to show the relationship between AP supplier invoices and the credits or payments applied to them.

Sage Intacct assigns a match sequence to a AP supplier invoice when you apply a payment or a credit against it. All payment entries that relate to the AP supplier invoice use the same sequence, establishing a relationship between them. As long as the AP supplier invoice is in a partially paid state, match sequences display in lower case letters, indicating that the AP supplier invoice is not completely reconciled. After the AP supplier invoice is paid in full, the match sequences are changed to upper case letters.

In the case of a credit, such as an adjustment or an advance, a match sequence is assigned to the credit when it’s applied to a transaction. You can track how the credit is matched to transactions by looking at credit's balancing entries, also called contra entries. The credit entry and the credit balancing entries share the same match sequence. This sequence displays in lower case letters until the credit is fully applied.

You can filter the Supplier reconciliation report to show you transactions that are unmatched, partially matched, or fully matched. You can also filter the report for a given match sequence.

How it works

Set up supplier reconciliation

  1. Go to Company > Setup tab > Settings > Document sequence.
  2. From the Document sequence list, select Add.
  3. Enter a Sequence ID and a Sequence name.
  4. Select Alpha as the Sequence type.
  5. If you want the maximum sequence to be shorter than 16 characters, override the default for Primary sequence maximum.

    This limits the number of increments allowed for the sequence. In general, you do not need to change the default.

  6. For Primary sequence, enter a.

    This is the initial value that Sage Intacct will use for the matching code. The second sequence is b, the third c, and so on. After the sequence increments to z, the next sequence will be aa.

  7. Optionally, define a Fixed prefix or Fixed suffix.

    Below the entry fields, you can preview how the sequence will appear in the report.

  8. Select Save.
  1. Go to Accounts Payable > Setup > Configuration.
  2. In the Document Sequencing section, select Enable supplier reconciliation.
  3. For AP match sequence, select the alpha document sequence you created in a previous step.
    Only alpha document sequences display in the list of selectable options. If you do not see the sequence that you created, check the sequence again to confirm that the Sequence type is set to alpha.
  4. Select Save.

Assign Accounts Payable Supplier reconciliation: Run permissions to users who need to review and post incoming transactions.

Follow the procedure that matches your configuration: Either assign permissions to a role or assign permissions to specific users.

Run the Supplier reconciliation report

  1. Go to Accounts Payable > All > Reports > Supplier reconciliation.
  2. Select a reporting period.
  3. Choose the suppliers that you want to include in the report.
    1. If you want to restrict the report to a single supplier, set the From supplier and To supplier to the supplier name.

    2. Select the Include all suppliers checkbox to include transactions from suppliers with zero balances.

    3. Select Include Zero balance suppliers with activity to include accounts with zero balances only if these suppliers had activity during the selected time period.

  4. If you want to examine the reconciliation for a particular match sequence only, enter it into Match sequence.
  5. To view only the transactions that are not fully reconciled, select the following:
    1. Under Matches to display, choose Select.
    2. Select Unmatched and Partially matched.
    3. Select Done.
  6. Set the Sort by order.

    In addition to sorting by supplier or AP supplier invoice, you can also sort by match sequence.

  7. Set any other filters that you need, such as Location or Currency.
  8. Select View.

Permissions and other requirements

Subscription

Accounts Payable
Regional availability

All regions
User type

Business
Permissions

Accounts Payable

  • Supplier reconciliation: Run
Configuration

Enable Supplier reconciliation and define an AP match sequence in Configure Accounts Payable.
Restrictions

Sage Intacct begins assigning match sequences to transactions after you enable Supplier reconciliation. Payments and credits that you applied to AP supplier invoices before enabling the feature are not assigned match sequences.