QUICKBOOKS CSV PRACTICE - DO NOT IMPORT INTO A REAL ACCOUNT
All transactions are synthetic. No live QuickBooks import was performed.

SETTINGS
First row contains column names: on
Transaction date -> Date; Details -> Description; Amount -> Amount
Reference -> Ignore
Date order: Day / Month / Year
Number format: 1,234.56
Remove later copies of exact duplicates: OFF initially

EXPECTED FIRST PASS
5 source transactions; 4 valid; 1 invalid (source row 6: 31/02/2026).
1 exact duplicate. The repeated row remains in the output.
Money in 1250.00; money out 104.48; net 1145.52.
Output dates are MM/DD/YYYY. 03/02/2026 becomes 02/03/2026 (February 3).
The formatted practice download matches the first pass, including UTF-8 BOM
and CRLF line endings. It excludes the invalid row and omits Reference.

OPTIONAL DUPLICATE EXERCISE
Only for this fiction, suppose DEMO-B was accidentally copied.
Turn duplicate removal ON: 3 output rows, money in 1250.00,
money out 54.49, net 1195.51. This is not the supplied after file.
An identical row does not prove a duplicate real payment. Ignored columns
still participate in exact source-row comparison.

REVIEW CHECKLIST
[ ] Keep an untouched source file and a working copy.
[ ] Confirm source date order and amount signs from the source record.
[ ] Review every mapping, including ignored columns.
[ ] Download the issues list; resolve excluded rows against the source.
[ ] Never guess a replacement date. February has no day 31.
[ ] Rerun the full corrected working copy; compare counts and totals again.
[ ] Check existing QuickBooks records separately before any real upload.
[ ] Match the output date format and fields in the import preview.
[ ] Never import these practice transactions into a real account.

The tool cannot connect to QuickBooks, detect prior imports or guarantee
acceptance. Ordinary picker uploads of these files may count as tool
workflows; these counts do not establish customer use or successful imports.
Independent of Intuit. Formatting practice, not accounting advice.