Missing information from a Commonwealth Bank QIF file

Legacy KB ID: 4625

Question

I have downloaded my Bank Account data from the Commonwealth Bank as a QIF file (Quicken Australia), but when I import it, Payee detail is different to what it used to be.  It shows: Direct Credit 012345 ABC COD0012 and not the actual information I want - ABC COD00123456789123.  How do I get the correct information?

Answer

This issue is a result from a change in payee detail implemented by the Commonwealth Bank recently.  The Bank now includes information about the transaction with the payee details.  The result is an entry that now exceeds the 32 character limit for the Payee Details field.  The information from the 33rd character onwards is ignored in the import.

You can modify the Payee Detail either in Reckon Accounts after the import or in the QIF file before import. 

Workaround 1:  Modify Payee detail after import:

1.    Import QIF in normal fashion and accept the Payee details as is

2.    Edit entries for the correct details.

Workaround 2:  Modify the QIF file before import.

A QIF file is a text file and can be opened by a Windows Notebook application.

1.    In Windows Explorer, make a copy of the QIF file to act as a backup;

2.    right-click your QIF file and select Open With;

3.    Choose Notepad as the application;

4.    Go to the Payee line - it commences “PDirect Credit 012345” where the phrase represents “Pay or Receive – transaction type – bank reference number”

5.    Delete the unnecessary information so that only required details show – eg: ABC COD00123456789123;

6.    File > Exit to save and close the file;

7.    Import the file into Reckon Accounts.

Need more help?

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

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