Missing date identifies a row whose mapped date field is blank. Check the column mapping first, then confirm whether the original source provides the date elsewhere.
- Look at Date as read in Preview and compare the row with the bank export.
- If the wrong column was mapped, select the actual date column and review all rows again.
- If the export itself omits the date, obtain complete source evidence or exclude the row until you can establish its date.
Some statement layouts print a date once for several following transactions. A working CSV needs an actual date value for each row. Carry a date forward only when the original layout clearly shows that those transactions share it.
Check for nontransaction rows
A blank-date row may be a subtotal, opening balance, note or separator copied with the table. Confirm what it represents before treating it as a missing transaction.
Do not fill every blank with the statement ending date or today’s date. That changes the timing of the activity. Retain the original file and document any evidence-based repair so later reviewers can understand how the final date was established.
Was this article helpful?
Tell us whether this answered the question you came with.