Import bank statements in Reckon Accounts Premier 2018?

I am using the Reckon Accounts Premier 2018 version. And now we do bank reconciliation manually by printing out the bank statements and enter Eftpos sales as sales receipts. I found out that we can actually import bank statements as a QIF file into reckon, however, we found 2 problems.

· The first issue is that we used bank account 2 to make online banking (batch payments) in Reckon, but when we do the bank reconciliation we reconcile bank account 1.

So when I import the bank statements, it seems that we can only import it to bank account 2.

How can we add bank account 1 to the select which account to import to option?

· The second issue is that It seems for the money we received, we only have 4 choices of allocation, which are

1. Ignore the transaction

2. Create a transfer

3. Create a deposit

4. Receive payments

But in our company, we record all income as sales receipts first, so how can we allocate the money we received by creating a new sales receipt.

Comments

Zappy

Call me 0407744914 Kevin

Datarec

Hi Shirley,

The QIF (bank import) you are attempting to use can only create transactions of type Transfer, Deposit or Payment. It cannot create "Sales Receipt" transactions.

The bank import can only be done to a bank account that has 'online banking' enabled.

You can edit an account and go to the "Online Bank Details" tab, where you can tick "Online Account Access" and enter the relevant banking details.

Regards,

Reckon Data Recovery Team

shirley_10349193

Thanks for your help. I think I am able to convert the bank statements into excel format. So is there any methods for me to import from excel to sales receipts for multiple transactions?

Zappy

Shirley the iif formats are in the help files. It's not easy. Call me if you need help 0407744914

Datarec

Hi Shirley,

As Kevin has indicated the in-product help has information on the import format that is accepted by the Reckon Accounts software.

He has helped many community members with importing data, so give him a call.

Chandra and Phuong are also members of the community who may be able to assist you with custom solutions.

Chandra,Professional Partner,
chandra@cosmicinnovations.com

Phuong Do / Reckon Developer Partner
phuong@cactussoftware.com.au

Note: Bank Statements may not contain enough information to create sales receipts without you adding additional information.

Look at what info is needed in a sales receipt and confirm that your bank statement data fields have enough corresponding data.

Image httpsd2r1vs3d9006apcloudfrontnets3_images1816339RackMultipart20191203-108080-uy3lgd-IIF_Sales_Receipt_inlinePNG1575356613

The in-Product help is accessible by clicking the Help menu and selecting Reckon Accounts Help

Image httpsd2r1vs3d9006apcloudfrontnets3_images1816345RackMultipart20191203-64361-190wp6u-REckon_Accounts_Help_menu_inlinePNG1575357018

Use the keyword IIF or IIF file format

Here is an example IIF import file when viewed in Excel that corresponds to the Sales Receipt above.

Image httpsd2r1vs3d9006apcloudfrontnets3_images1816340RackMultipart20191203-89643-159txnt-IIF_Sales_Receipt_-_1_inlinePNG1575356694

Image httpsd2r1vs3d9006apcloudfrontnets3_images1816341RackMultipart20191203-111016-1wjs1o0-IIF_Sales_Receipt_-_2_inlinePNG1575356710

Image httpsd2r1vs3d9006apcloudfrontnets3_images1816343RackMultipart20191203-82244-lkopps-IIF_Sales_Receipt_-_3_inlinePNG1575356733

Note that creating and troubleshooting IIF files is outside of the scope of assistance that can be provided to you by the Reckon Technical Support Team.

Regards,

Data Recovery Team