PDF and bank statements lists XLS and XLSX among accepted statement formats. Use that workflow for a bank statement workbook, or export a reviewed CSV when you want the structured column-mapping import.
- Confirm the workbook contains one account and one currency for the intended period.
- Check that dates, descriptions and amounts are visible and that unrelated worksheets or summaries will not obscure the transaction source.
- Upload through the statement workflow and review the extracted results against the original workbook.
A workbook is not converted into a CSV by renaming its extension. The structured text reader expects actual text rows, while the statement workflow handles its supported statement formats.
Check calculated and displayed values
Spreadsheet formatting can hide precision or show dates differently from the underlying cell values. Compare the extracted values with the bank’s evidence, not only a visually rounded display.
Retain the original workbook. If you prepare a CSV working copy, verify the account, currency, row count, date range and totals after export. Import one representation of the same movements and keep the other as evidence to avoid adding duplicate activity.
Was this article helpful?
Tell us whether this answered the question you came with.