Skip to main content

Varicent ELT Help Center

Transaction reconciliation

Abstract

Transaction reconciliation helps Incentives customers match billed transactions to orders and get them ready for downstream processing.

The Transaction reconciliation pipe helps Incentives customers match billed transactions to orders and get them ready for downstream processing.

Order data and billed transactions are brought into the canvas. Match Billed Transactions - Orders.csv (Data) Match Billed Transactions - Billing Data.csv (Data)

Match Orders To Billing (Combination Matcher) tries to find matches between the Orders and Billing Data through Varicent ELT Combination Matcher. The columns to match are:

  1. ContractID

  2. Part ID

  3. Product

  4. Subscription start date

  5. Term

  6. New or renew

  7. Customer

  8. Address

  9. City

  10. State Province

  11. Country

Matching records will have TRUE "Match?" value, and a populated "ContractID". Records with a FALSE "Match?" value and null "ContractID" represent orders that do not have a corresponding transaction in the billing data.

Transactions with a match are then filtered Filter For Billed Records (Filter) and exported to Incentives for downstream processing. Export To Incentives (Export)