#TipTuesday - Reckon Accounts Hosted/Desktop - re-import a bank statement file

Jason_Z
Jason_Z Reckon Staff Posts: 331 Reckon Staff Reckon Staff
edited January 27 in Accounts Hosted
df9c38f9-d2a1-402b-a9bc-4625fbcabe99.png

๐ŸŒŸ Tip Tuesday โ€“ Welcome to 2026! ๐ŸŒŸ

Good morning everyone, and welcome to my first Tip Tuesday of 2026.
I hope you all had a great New Year and are feeling well-rested and refreshed.

For this weekโ€™s tip, I want to remind everyone how to re-import a bank statement file (QIF) that didnโ€™t import successfully the first time. You might see a message that there are no new transactions to import, or nothing happens at all when you try again. Following this tip can help you re-import these bank statements.

Why does this happen?

When Reckon Accounts Business imports a QIF, it remembers the first transaction in the file. If the same transaction appears again, itโ€™s flagged as already imported, and the import wonโ€™t continue.

Renaming the file wonโ€™t help, because Reckon recognises the transaction data itself, not the file name.

Bank QIF file format (example)

Header:

image.png

The transaction block:

image.png

The ^ symbol marks the end of a transaction.

How to fix it

To work around this, we simply need to move the first transaction to the bottom of the file.
This makes Reckon treat it as a โ€œnewโ€ QIF file and allows the import to proceed.

Summarised steps

  1. Make a backup copy of the QIF file.
  2. Open the duplicate file in Notepad.
  3. Cut the first transaction block.
  4. Paste it at the very bottom of the file.
  5. Remove the blank line left behind.
  6. Save the file and re-import.


For more information check out our full help article here:
https://help.reckon.com/article/aaxfbwli65-kba-5029-how-to-re-import-a-bank-statement-file-qif

Tagged: