How to re-import a bank statement file (*.qif)

Legacy KB ID: 5029

Question

How do I reimport a bank statement file that I unsuccessfully tried to import once already?  I keep getting a message that there are no new transactions to import. 

Answer

Move the first transaction inside the QIF file to the bottom and import again.

 

The Issue

Once you “import” the bank statement file into your Accounts Business and examine the first transaction, Accounts Business flags the file as being imported.  If you delete this file before importing any transaction, Accounts Business still notes as that file imported. 

If you change the name of the file you get the same messages. 

You can re-import the same file if you move the first transaction to the bottom of the file. 

 

Detailed Instructions

Open the bank statement file (it has the file extension: .QIF)

  1. In Windows Explorer, browse to the folder that contains your bank statement file.
  2. Right-click the file and select Copy.
  3. Then right-click on the white background and select Paste
    A copy of the file will be made. The file will have the same name with a - Copy added to the name.  This copy will act as your backup.
  4. Right-click the original bank statement file, select Open with, and then Notepad.

 


The bank statement file has the following format which appears once as the first line of the file.

File type flag:          !Type:Bank

The data block follows the following format.

Date of Trans:        D31/08/2013
Amount:                 T-15.00
Account name:       PAccount
End of Trans:         ^

To move the first transaction:

  1. Highlight the 4 lines of the first Data Block;
  2. Press [CTRL] + [X]. The Data Block will disappear and be replaced by a blank line.
  3. Scroll down to the bottom of the file and left click below the last end of Trans marker.
  4. Press [CTRL] + [V] to past the first transaction to this location.
  5. Scroll to the top of the file, click on the blank line that replaced the first entry and click on Delete to delete that line.
    Note: Line 2 of the file should now start with the Date of Trans line. 
  6. Close the file by clicking on the X in the top right.
  7. Click Save to save your changes.

 

You will now be able to import this bank statement file into Accounts Business.

 


Need more help?

Ask the Reckon Community at: https://community.reckon.com/categories/reckonaccounts

Or Log a Support Ticket: https://www.reckon.com/au/support/

How did we do?

How do I enter a refund or rebate to a customer?

How do I get my logo copied into a form that I exported to another company?

Related Articles

QIF file from St George Bank does not import
Missing information from a Commonwealth Bank QIF file
Last transaction of imported bank statement (QIF) does not import into RAB
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)