happytails.ai

CSV reconciliation report

Match two exports by business key and quantify missing records and amount differences.

Amounts use exact decimal arithmetic and differences are right minus left. Missing amounts and duplicate keys block reconciliation. Totals do not perform currency conversion, accounting classification or financial certification. Up to 1,000,000 characters, 10,000 data records, 100 columns and 100,000 cells across the sources. Files for multi-source tools are limited to 4,000,000 bytes total. Reports retain at most 500 diagnostic findings and state any omitted count. CSV and JSON outputs are limited to 4,000,000 characters. Output is budgeted incrementally before retaining each row; expanded decimal output counts toward the same 4,000,000-character limit even when input uses short exponent notation. Paste CSV data with unique column headers. Quoted multiline cells are supported. Results update as you type. Up to 1,000,000 characters.

Your result

Report a problem or share an idea.

How to use CSV reconciliation report
  1. Paste the two CSV exports.
  2. Choose unique business key columns and numeric amount columns.
  3. Download the row-by-row reconciliation and exact totals.

Useful next steps

Prepare the source

Paste the two CSV exports.

Choose the matching rules

Choose unique business key columns and numeric amount columns.

Review and keep the result

Download the row-by-row reconciliation and exact totals. Amounts use exact decimal arithmetic and differences are right minus left. Missing amounts and duplicate keys block reconciliation. Totals do not perform currency conversion, accounting classification or financial certification.