NjordMatch

The guide and practice files are free to read and download. The complete program is in the paid download; the free practice pack does not include it.

Product details and paid download · Online illustrated guide

NjordMatch application screen
Application screen; the program is supplied separately in the purchased download.

Try the free fixed example

Open the no-installation browser example to review five fictional payments, select two prepared matches and export seven rows. That separate teaching example does not import your files or execute the paid matching engine.

Before you start the purchased program

Steps

Open the downloaded local edition

Buy and extract the NjordMatch ZIP, then open its NjordMatch folder. For the purchased program: install Node.js 20.12 or newer. Extract the purchased NjordMatch ZIP and open its NjordMatch folder, then run: node start.mjs Open http://127.0.0.1:8787/ in desktop Google Chrome. Keep the terminal open; Ctrl+C stops it. The free guide pack has no program or start.mjs file. Follow the illustrated example below before buying; the program runs from your purchased local copy.

Open NjordMatch

In your open local copy, follow the controls described below. The three steps are Import files, Map columns and conventions, and Review and confirm.

Import both files

Choose your file under Bank statement (CSV or CAMT.053 XML) and under Shopify order export CSV. To practise first, click Load synthetic demo, which loads two small made-up files.

Check columns and formats

Choose the Decimal separator (Dot or Comma) and Date convention (YYYY-MM-DD, DD/MM/YYYY or MM/DD/YYYY). Check each column list: Transaction ID, Reference, Amount, Currency, Date, Direction and Booking status for payments; Order ID, Reference, Outstanding amount, Currency, Financial status and Cancelled at for orders. Standard headings are filled in automatically and the first two rows of each file are shown. Click Preview reconciliation.

Review the results

Each bank payment gets a state (Exact match, Ambiguous, Unmatched or Excluded) with a reason; orders without an exact payment are listed after the payments. What the states mean explains each one. Tick the matches you accept, or click Select all exact matches.

Confirm and export

Tick I reviewed these results and confirm the report, then click Export reconciliation CSV. The download njordmatch-report.csv lists every payment row, every order without an exact payment and any row errors, with a selected column. Update orders in Shopify yourself; NjordMatch changes nothing there.

Worked example: Reconcile five fictional bank lines with four orders

examples/njordmatch/fictional-bank-statement.csv (5 fictional bank lines) and examples/njordmatch/fictional-shopify-orders.csv (4 fictional pending orders).

  1. Open your local NjordMatch page. Choose fictional-bank-statement.csv under Bank statement and fictional-shopify-orders.csv under Shopify order export CSV.
  2. Keep Dot and YYYY-MM-DD; the column lists fill in automatically. Click Preview reconciliation.
  3. Click Select all exact matches, then tick I reviewed these results and confirm the report.
  4. Click Export reconciliation CSV.

The summary reads “5 payment rows: 2 match, 0 ambiguous, 2 unmatched, 1 excluded/invalid; 0 row errors.” BK-2001 and BK-2002 are Exact match for orders #2041 and #2042. BK-2003 is Unmatched with “Amount or currency differs” (19.00 was paid, order #2043 is 21.00); BK-2004 is Unmatched with “No eligible order with this reference”; the card-fee debit BK-2005 is Excluded as “Not a credit”. Orders #2043 and #2045 appear under “Orders without an exact payment (2)”. njordmatch-report.csv has 7 rows, with selected = yes for the two accepted matches.

Troubleshooting

A payment I expected to match is Excluded.

Only booked credits (direction CRDT, status BOOK) can match, and rows without a direction or status are excluded. Map the Direction and Booking status columns if your bank provides them.

An order never matches.

Only pending or unpaid orders are eligible, and the reference, amount and currency must match exactly. The reference comparison ignores one leading # and letter case; payer names and partial references are never used. A partial payment shows as Unmatched.

A payment shows as Ambiguous.

A transaction, payment reference or order reference appears more than once, so NjordMatch never proposes a match. Check the duplicates in your exports.

Amounts or dates look wrong in the preview.

Set Decimal separator to Comma for amounts such as 49,90, and pick the Date convention your bank uses.

Export reconciliation CSV is greyed out.

Click Preview reconciliation first, then tick I reviewed these results and confirm the report.

My files are gone after reloading the page.

Imported files stay only in the current browser tab and are never uploaded or stored. Choose them again.

Limits

Updated 23 October 2026. Examples are fictional or synthetic. Previously obtained software copies retain their included license rights.