CSV Repair · Client handover

Statement review

synthetic-25-transactions.csv · 2026-10-28

Statement lines prepared
25
Net movement · source currency
1180.00
Exact duplicates found
0
Excluded lines
2
Invalid lines
0

Review status

No invalid lines detected. Human review is still required. Duplicate handling: duplicates kept. Date order: auto. Signs: source signs retained.

Reviewer confirmation: checked in the workbench. Confirm dates, payment signs, exclusions and net movement against the source statement before importing. This report does not verify running balances or certify reconciliation.

Findings and exclusions

All prepared transactions

All 25 prepared lines. Source row identifies the parsed CSV record, including the header; quoted multiline fields count as one record. The complete licensed CSV export is a separate file.

Source rowDateAmountPayeeDescriptionReference
301/10/2026100.00Synthetic customer receipt 1SAMPLE_1
402/10/2026-10.00Synthetic supplier payment 2SAMPLE_2
503/10/2026100.00Synthetic customer receipt 3SAMPLE_3
604/10/2026-10.00Synthetic supplier payment 4SAMPLE_4
705/10/2026100.00Synthetic customer receipt 5SAMPLE_5
806/10/2026-10.00Synthetic supplier payment 6SAMPLE_6
907/10/2026100.00Synthetic customer receipt 7SAMPLE_7
1008/10/2026-10.00Synthetic supplier payment 8SAMPLE_8
1109/10/2026100.00Synthetic customer receipt 9SAMPLE_9
1210/10/2026-10.00Synthetic supplier payment 10SAMPLE_10
1311/10/2026100.00Synthetic customer receipt 11SAMPLE_11
1412/10/2026-10.00Synthetic supplier payment 12SAMPLE_12
1513/10/2026100.00Synthetic customer receipt 13SAMPLE_13
1614/10/2026-10.00Synthetic supplier payment 14SAMPLE_14
1715/10/2026100.00Synthetic customer receipt 15SAMPLE_15
1816/10/2026-10.00Synthetic supplier payment 16SAMPLE_16
1917/10/2026100.00Synthetic customer receipt 17SAMPLE_17
2018/10/2026-10.00Synthetic supplier payment 18SAMPLE_18
2119/10/2026100.00Synthetic customer receipt 19SAMPLE_19
2220/10/2026-10.00Synthetic supplier payment 20SAMPLE_20
2321/10/2026100.00Synthetic customer receipt 21SAMPLE_21
2422/10/2026-10.00Synthetic supplier payment 22SAMPLE_22
2523/10/2026100.00Synthetic customer receipt 23SAMPLE_23
2624/10/2026-10.00Synthetic supplier payment 24SAMPLE_24
2725/10/2026100.00Synthetic customer receipt 25SAMPLE_25

Balance check

Opening: 1000.00. Closing: 2180.00. Expected closing: 2180.00. Difference (closing − opening − movement): 0.00.

Arithmetic comparison of user-supplied balances only; no verification of running balances or certification of reconciliation.

Review closure

Client reference: SAMPLE_025. Responsible reviewer: Synthetic review desk. Status: Closed by reviewer. Notes / unresolved items: Illustrative declaration: source balances and every exclusion reviewed. No real bank data..

Automatic checks: 0 invalid rows; 2 exclusions to review; 0 duplicate matches. Supplied balances agree arithmetically. Reviewer status is a recorded declaration, not an automatic approval.

File manifest

Source: synthetic-25-transactions.csv · SHA-256: bf4442ab156015bd15973c26e422e43578709c25bcdc08023f37b050f6be6c9a. Prepared CSV filename: xero-statement.csv · SHA-256: 8205657fedc024a5a173e748001ee84279199597f8e938f18996a8c2849b93ec. Settings: decimal ., encoding auto. Column mapping (zero-based positions; −1 means unused): {"date":0,"amount":1,"debit":-1,"credit":-1,"payee":-1,"description":2,"reference":3,"type":-1}. The CSV hash identifies exact UTF-8 download bytes; save both files together.

Source-to-output audit

Every parsed source record, including headers, invalid and excluded rows. Quoted multiline fields count as one record. Prepared values appear in the complete table above; source row links both tables.

Source rowOriginal cells (JSON)DecisionReview closure
1["Date","Amount","Description","Reference"]Header / preambleNot recorded · Unassigned ·
2["Opening balance","","",""]Excluded: Balance rowReviewed · Synthetic review desk · Opening balance entered in arithmetic check.
3["2026-10-01","100","Synthetic customer receipt 1","SAMPLE_1"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
4["2026-10-02","-10","Synthetic supplier payment 2","SAMPLE_2"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
5["2026-10-03","100","Synthetic customer receipt 3","SAMPLE_3"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
6["2026-10-04","-10","Synthetic supplier payment 4","SAMPLE_4"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
7["2026-10-05","100","Synthetic customer receipt 5","SAMPLE_5"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
8["2026-10-06","-10","Synthetic supplier payment 6","SAMPLE_6"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
9["2026-10-07","100","Synthetic customer receipt 7","SAMPLE_7"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
10["2026-10-08","-10","Synthetic supplier payment 8","SAMPLE_8"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
11["2026-10-09","100","Synthetic customer receipt 9","SAMPLE_9"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
12["2026-10-10","-10","Synthetic supplier payment 10","SAMPLE_10"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
13["2026-10-11","100","Synthetic customer receipt 11","SAMPLE_11"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
14["2026-10-12","-10","Synthetic supplier payment 12","SAMPLE_12"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
15["2026-10-13","100","Synthetic customer receipt 13","SAMPLE_13"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
16["2026-10-14","-10","Synthetic supplier payment 14","SAMPLE_14"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
17["2026-10-15","100","Synthetic customer receipt 15","SAMPLE_15"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
18["2026-10-16","-10","Synthetic supplier payment 16","SAMPLE_16"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
19["2026-10-17","100","Synthetic customer receipt 17","SAMPLE_17"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
20["2026-10-18","-10","Synthetic supplier payment 18","SAMPLE_18"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
21["2026-10-19","100","Synthetic customer receipt 19","SAMPLE_19"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
22["2026-10-20","-10","Synthetic supplier payment 20","SAMPLE_20"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
23["2026-10-21","100","Synthetic customer receipt 21","SAMPLE_21"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
24["2026-10-22","-10","Synthetic supplier payment 22","SAMPLE_22"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
25["2026-10-23","100","Synthetic customer receipt 23","SAMPLE_23"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
26["2026-10-24","-10","Synthetic supplier payment 24","SAMPLE_24"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
27["2026-10-25","100","Synthetic customer receipt 25","SAMPLE_25"]Prepared: date normalised; debit/credit signs applied; text trimmed; CSV formula markers escaped on exportNot recorded · Unassigned ·
28["Closing balance","","",""]Excluded: Balance rowReviewed · Synthetic review desk · Closing balance entered in arithmetic check.

Keep this report private

Generated locally, without uploading statement content. It may contain financial details: save and share it securely. Open in a browser and choose Print / Save as PDF for a paper copy.