Free worked example · NjordMatch
Review five fictional payments
See why two payments match, two need attention and one is excluded. Select the matches you accept, then download the seven-row sample report.
Fixed example only. These results are prepared from the fictional files below. This page does not import files or run the paid matching engine. No purchase, account or installation is needed.
1. Check the fictional input
Five bank lines are compared with four pending Shopify orders. All names, order references and amounts are invented. The input files match the guide’s five-payment example.
Bank CSV · 5 lines · Order CSV · 4 orders
What is in these files?
Bank credits: BK-2001 pays 28.00 EUR for #2041; BK-2002 pays 54.50 EUR for #2042; BK-2003 pays 19.00 EUR for #2043; BK-2004 pays 40.00 EUR for #2044. BK-2005 is a 7.90 EUR fee debit.
Pending orders: #2041 is 28.00 EUR, #2042 is 54.50 EUR, #2043 is 21.00 EUR and #2045 is 12.00 EUR. The extra blank order line is a continuation item, not a fifth order.
2. Review the prepared results
5 payments: 2 exact matches, 2 unmatched, 1 excluded. Two orders still have no exact payment. There are no ambiguous results in this fixture.
A matching reference alone is not enough: BK-2003 and order #2043 differ by 2.00 EUR. The fee is a debit and cannot settle an order.
| Select | Row | Reference | Amount | State | Order | Reason |
|---|---|---|---|---|---|---|
| BK-2001 | #2041 | 28.00 EUR | Exact match | #2041 | Reference, amount and currency agree | |
| BK-2002 | #2042 | 54.50 EUR | Exact match | #2042 | Reference, amount and currency agree | |
| — | BK-2003 | #2043 | 19.00 EUR | Unmatched | — | Order #2043 is 21.00 EUR: amount differs |
| — | BK-2004 | #2044 | 40.00 EUR | Unmatched | — | No eligible order with this reference |
| — | BK-2005 | Card fees September | 7.90 EUR | Excluded | — | Debit: not a credit |
| — | #2043 | #2043 | 21.00 EUR | No exact payment | #2043 | The 19.00 EUR payment does not cover this order |
| — | #2045 | #2045 | 12.00 EUR | No exact payment | #2045 | No payment with this reference |
0 of 2 exact matches selected. Every row stays in the report.
3. Export and inspect the example
Select both exact matches, then export. The CSV has seven data rows: five payments and two orders without an exact payment. Only BK-2001 and BK-2002 should have selected = yes. Clearing a selection changes that column; it never removes unmatched rows.
Download the expected seven-row report to compare. This fixed download always has both exact matches selected.
This is a separate teaching example, not a run of the purchased application. Its sample CSV is for checking this example. No bank or Shopify account is connected, and no order is changed.
Need to compare your own exports?
NjordMatch is $7.99 USD once. The purchased local download imports CSV or CAMT.053 bank data and Shopify CSV files, lets you map columns, proposes matches and exports a report for your review. It needs Node.js 20.12 or newer and was checked in desktop Google Chrome.
This public example has no import, column mapping, general matching or duplicate detection. Use it to understand the result states; check the full product’s requirements before buying. It is not an accounting or audit certification.