Prepare bank-statement rows for a Sage
or Pastel workflow
No affiliation or certification is implied
Target outcome
A clean working CSV prepared for mapping—not an unsupported one-click import promise.
Do not edit the only clean copy.
Download the reviewed ReconReady CSV, preserve it as the conversion output, and create a separate working copy for Sage & Pastel. That keeps mapping changes traceable.
File lineage
Check the structure before the import.
Product requirements change. Use this as a control list, then compare it with Sage & Pastel’s current help or sample file.
- 01Confirm the current importer or Bank Manager template
- 02Match the company file’s date convention
- 03Map debit and credit direction deliberately
- 04Keep descriptions and references within the current field limits
- 05Test a short statement period before a full backlog
A small test catches expensive mistakes.
Import one short period first. Compare the first date, last date, transaction count, movement total, and resulting bank balance with the PDF before continuing.
First and last date
01Transaction count
02Amount direction
03Description mapping
04Ending balance
05Duplicate check
06Guidance without false shortcuts.
Which bank supplied the PDF?
Prepare the source before Sage & Pastel.
Convert the PDF, review the rows, and preserve a clean export before destination-specific mapping.