Choose your tool

DATA TOOL

CSV Amount Reconciliation

Reconcile two exports by unique key and exact two-decimal amounts; report missing IDs and deltas.

◇ Browser only

Your text

Or load a UTF-8 text file

0 lines · 0 characters

ResultsReady when you are

Your results will appear here.

Copy or download your result below.

Your text stays on this device.

LESS BUSYWORK, MORE DONE

Three steps. That’s it.

A useful toolkit for text, data, images and calculations.

01
Add your input
Choose a tool, enter values or select a file.
02
Make it yours
Adjust the options and run the action.
03
Take the result
Copy the result or download its file.

CSV amount matching tool online

Find missing IDs and amount differences between two exports. Amounts must have at most two decimal places; currency conversion and accounting rules are not inferred.

How to use it

Enter First export or select Try example. Provide Second export in the second editor. Review Key column, Amount column. Select Run tool and inspect the result before copying or downloading.

Options and example settings

Option	Choices / value	Example default
Key column	Enter a value	id
Amount column	Enter a value	amount

Worked examples

Find missing IDs and amount differences between two exports.

Worked example — CSV Amount Reconciliation

Settings: Key column: id; Amount column: amount

Input:

id,amount
001,10.00
002,20.00

SECOND INPUT:
id,amount
001,12.00
003,20.00

Output:

{
  "matched": 0,
  "changes": [
    {
      "key": "001",
      "status": "mismatch",
      "left": "10.00",
      "right": "12.00",
      "deltaRightMinusLeft": "2.00"
    },
    {
      "key": "002",
      "status": "missing-right",
      "left": "20.00",
      "right": null,
      "deltaRightMinusLeft": null
    },
    {
      "key": "003",
      "status": "missing-left",
      "left": null,
      "right": "20.00",
      "deltaRightMinusLeft": null
    }
  ],
  "leftTotal": "30.00",
  "rightTotal": "32.00",
  "totalDeltaRightMinusLeft": "2.00"
}

For this input, “matched” is 0. These are the named fields in the example output.

Choose the right tool

Reconciliation compares exact two-decimal amounts by unique key. Check the report for missing IDs as well as amount differences; equal grand totals alone do not establish that individual records match.

Limitations and common mistakes

Amounts must have at most two decimal places; currency conversion and accounting rules are not inferred.

Frequently asked questions

How can I reconcile two exports by unique key and exact two-decimal amounts online?

Enter First export or select Try example. Provide Second export in the second editor. Review Key column, Amount column. Select Run tool and inspect the result before copying or downloading.

Where is my input processed?

The bundled tool processes input in your browser. It does not upload tool input to a conversion service. Other site plugins, analytics, advertising and browser extensions may have separate behavior.