A bank export can include both a transaction date and a posted date. Identify which column represents the accounting source date you intend to import, then map Date consistently for the file.
The importer can suggest a mapping from headings such as Date or Posted date, but you should confirm the meaning against the bank’s export. A suggested column is not a decision about which date fits your company’s accounting process.
Compare representative movements
- Find a transaction whose purchase and posting dates differ. Check how the bank statement presents it.
- Choose the intended date column and inspect the preview for that transaction.
- Review the date range and any start-date or closed-period holds before committing.
Do not switch date columns only for rows that would otherwise be held. Mixing conventions within an import can make the statement period inconsistent.
If another source already contains the same transactions using a different date convention, inspect possible duplicates carefully. A date difference alone does not prove two rows represent separate movements. Keep the bank reference and original evidence available when resolving the overlap.
Was this article helpful?
Tell us whether this answered the question you came with.