About Background Matching

If you want to automatically match cash entries (cash receipts and cash refunds), sales invoices and credit notes, billing document invoices and billing document credit notes, you can use Background Matching. For example, you can automatically match cash entries that were generated from an imported file of credit card payments with sales invoices.

When you finish running the Background Matching process, all cash entries, sales invoices and credit notes, billing document invoices and billing document credit notes that meet the following conditions are matched:

• The transaction account lines for the cash entry A record of money received from, or refunded to, your customers, often in the form of cash or a check. Also used to record payments to and refunds from vendors., and sales invoice A commercial document issued by a seller to a buyer, indicating the products, quantities and agreed prices for goods or services that have already been provided. You issue sales invoices and receive payable/purchase invoices. or sales credit note, or billing document invoices or billing document credit note have a matching status of "Available".
• The account In this context, accounts are organizations or people that you conduct business with, such as customers or vendors. Account is a standard Salesforce object. FinancialForce accounts can be any Account Record Type. on the source document transaction account line is the same as the account on the target document.
• If you select the currency mode as Document, the source document currency is the same as the target document currency.
• The account reference on the source document account line is the same as either the Customer Reference on the target document, or on the target Document Number. This comparison is case sensitive. You choose whether you want to match by Customer Reference or by Document Number when you start the background matching process.

Note:

The source document is the document that is being matched. The target document is the document that the source document is being matched to.

The source and target outstanding values do not need to match exactly because you can choose to allow part payments, and you can add a condition to allow any available outstanding balance to be automatically matched to other documents for the same account. See Background Matching Example for an illustration.

When matching sales invoices to sales credit notes, select Custom Date as the matching date.

If you match a sales invoice to multiple cash entries, the date of the most recent cash entry is used as the matching date.

For matching to be carried out successfully, currency write-offs or settlement discounts may need to be posted to a general ledger account. If this is the case, the following general ledger accounts must be defined in your company information:

• Currency Write-off
• Settlement Discount

Note:

When calculating any settlement discounts that may be applied, the date to calculate the discounts is the one that you select as the matching date mode. The resulting cash matching journals are posted to the same date and period as that of the completed Background Matching process.

Match Statuses

A transaction line item can be in one of the following match statuses:

Match Status	Description
Available	Line is available for matching.
Matched	Line has been matched.
Not Matchable	Line is unsuitable for matching. An example of this is the tax line from an invoice.
Proposed	Line has been included in a payment proposal. It is not available for manual matching nor is it available for inclusion in subsequent payment proposals.

When the match status or outstanding value of a transaction account line is updated, the following related values are also updated:

• The account line summary on the transaction.
• The payment details on the related document.

Document Matching Scenarios

The following table lists a number of document matching scenarios and indicates which are currently supported in cash matching and background matching.

These scenarios apply to both sales documents and billing documents.

Document Matching Scenario	Supported By:
	Cash Matching	Background Matching
Invoice - Credit Note	Yes	Yes - in Lightning
Invoice - Cash Refund	Invalid The Commit button is disabled.	Invalid
Invoice - Cash Receipt	Yes	Yes
Credit Note - Cash Refund	Yes	Yes
Credit Note - Cash Receipt	Invalid The Commit button is disabled.	Invalid
Cash Refund - Cash Receipt	Yes	Yes - in Lightning.
Invoice - Credit Note - Cash Receipt	Yes	Yes - in Lightning. Partially supported when running in Visualforce. The Credit Note is ignored.
Invoice - Credit Note - Cash Refund	Yes	Yes - in Lightning. Partially supported when running in Visualforce. The Invoice is ignored.
Invoice - Cash Receipt - Cash Refund	Yes	Yes - in Lightning. Partially supported when running in Visualforce. The Cash Refund is ignored.
Credit Note - Cash Receipt - Cash Refund	Yes	Yes - in Lightning. Partially supported when running in Visualforce. The Cash Receipt is ignored.
Invoice - Credit Note - Cash Receipt - Cash Refund	Yes	Yes In Visualforce, the Invoice is matched to the Cash Receipt. In Visualforce, the Credit Note is matched to the Cash Refund.

Matching History Dates

You can select either Cash Entry Date or Custom Date as the Matching Date Mode for background matching. The selected date is used as the matching date on the resulting matching history.

If you select a custom date, that date is used in all scenarios.

The following are the different matching scenarios and the matching dates used

Matching Scenario	Matching Date
Invoice - Cash Receipt	Cash Entry Date
Credit Note - Cash Refund	Cash Entry Date
Cash Receipt - Cash Refund	Cash Refund Date
Invoice - Credit Note	Custom Date