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;

(it may be your Desktop)

2.    Right click it, select Copy, right click on the white background and select Paste – a copy of the file will be made and will have the same name with  - Copy added to the name.  this copy will act as your backup.

3.    Right-click the original bank statement file, select Open with, and select Notepad.

 

The bank statement file has the following format: 

File type flag:          !Type:Bank

appears once as the first line of the file.

 

The Data Block follows:

Date of Trans:         D31/08/2013

Amount:                 T-15.00

Account name:         PAccount Name of Account

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.  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 – click Save to save your changes.

 

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

 

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

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)