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
-
Call me 0407744914 Kevin0
-
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
Searching the Reckon Help and Support Centre | Asking good questions on the Community
#TipTuesday: Picture Paints a Thousand Words | How do I add screenshots to my discussion?
1 -
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?
0 -
Shirley the iif formats are in the help files. It's not easy. Call me if you need help 04077449140
-
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.
The in-Product help is accessible by clicking the Help menu and selecting Reckon Accounts Help
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.
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
Searching the Reckon Help and Support Centre | Asking good questions on the Community
#TipTuesday: Picture Paints a Thousand Words | How do I add screenshots to my discussion?
0
Reckon Staff 