Page Comparison

Scenario

Multiple invoices are dispatched to multiple departments within a client company. That company has its own internal processes and approval processes and payment schedules. They occasionally pay exactly the amount invoiced, but often they pay it in instalments, or with they will amalgamate a number of demands into a single payment.

Implement a general ledger reconciliation in PhixFlow, matching amounts from two source streams tables (a Bank statement and a general ledger). Implement the reconciliation using a number of rules e.g. favour the least number of records in each set when making a reconciliation, allow more than 2 x 2 or 3 x 3 matches, consume matched records such that they cannot be part of more than one match.

Solution:

• Create a Stream table to merge input from 2 sources (other streams / DB collectors / file collectors)
• For each element, or group of elements in the first streamtable, try to match the element, or elements in the 2nd stream table that match the amount in the first streamtable.
• Repeat for all elements and groups of elements
• Mark those elements matched where amounts and totals agree