This guide provides step-by-step instructions for importing bank transaction data, allowing for seamless bank reconciliation and ledger updates. Users can import data either by selecting a file from a secure server or by copying and pasting text, depending on their access permissions. The guide covers data preparation, file import options, handling recurring and duplicate transactions, and verifying transaction entries.
Navigation: Main Menu > Accounting > Banking.
Table of Contents
If the person importing the data has access to look for files on the organisation's server, choose to import a bank file.
If the person importing the data does not have access to the server, choose to copy and paste the data.
Export the data from your bank in .ofx (preferable) or .csv format and save the file in a location you have access to.
Note: You do not need to change anything, you can import the file exactly as your bank generates it.
Export an .ofx or .csv file from your bank.
Open the .ofx or .csv file you received from your bank using a text reader (eg. Notepad).
Select all the text in your text reader (Ctrl+A) and copy it (Ctrl+C).
In QuickEasy, navigate to Main Menu > Accounting > Banking.
Click on Menu (button) > Import.
Note: If multiple Bank Accounts have been set up, a submenu allows users to select the Bank being imported.
Paste your text in the block provided (Ctrl+V).
Click Import (button).
If the import is successful, a pop-up will appear confirming the Batch ID and stating that > Click OK.
If the import is unsuccessful, repeat Steps 2 to 7.
Double click the transactions one-by-one to process them - see below tutorial.
Note: When a transaction is linked to a Bank Transaction, the Date on the Ledger Transaction cannot be updated. A warning is displayed when a duplicate transaction is viewed. A duplicate transaction warning is triggered If the Date, Amount and Description are the same as another transaction.
Export a .ofx or .csv file from your bank.
In QuickEasy, navigate to Main Menu > Accounting > Banking.
Note: If multiple Bank Accounts have been set up, a submenu will open to select the Bank being imported.
Click on Menu (button) > Import > Select the File Type: Choose either .ofx or .csv.
Navigate to the file you received from your bank.
Click Import (button).
If the import is successful, a pop-up will appear confirming the Batch ID and stating that > Click OK.
If the import is unsuccessful, repeat Steps 2 to 5.
After the file has been imported, it will be renamed, by adding the Batch ID and the Date to the filename, and then moved to the Imported folder.
Double click the transactions one-by-one to process them - see below tutorial.
Note: When a transaction is linked to a Bank Transaction, the Date on the Ledger Transaction cannot be updated. A warning is displayed when a duplicate transaction is viewed. A duplicate transaction warning is triggered If the Date, Amount and Description are the same as another transaction.
Import your data by copying and pasting it, or by importing a file to create a list of transactions (see above).
Note: You will receive a warning if a transaction with the same date, amount, and description already exists.
Double-click to open a transaction:
The transaction will open with the transaction details on the right panel.
If there are matching records they will appear directly below the transaction details. Click the matching record to automatically post the current transaction to the same account.
Note: The software tries to match the name or reference to existing transactions. If a match is found, it appears under matching records.
Note: If it is a recurring transaction, like bank charges, and there are no matching records, click on the icon to the right of the description to create a matching record for future use.
If a matching record is not found, select a Transaction Type in the section below the transaction.
Note: The Transaction Types will vary depending on whether it's a deposit (+) or payment / expense (-).
Double-click to allocate the entry based on the Transaction Type:
Allocating Supplier Payments (see below).
Allocating Customer Receipts (see below).
Creating Other Entries (see below): e.g. Cash Up Surplus, General Income, General Expenses, Payroll - Payment, VAT Payment, Supplier Refund, Customer Refund, etc.
Click Done (button).
The Date will automatically be entered from the imported transactions.
Perform a Bank Import.
If you are posting Supplier Payments to the Ledger:
Double-click the payment on the bank import list of transactions,
Select Supplier Payment as the transaction type,
Click Actions (button) > Update Supplier Payment.
The Supplier Payment will be matched on the Supplier, Bank Account, Date and Amount and the entry will automatically be created.
Select the Supplier on the dropdown list next to Dr. Supplier.
Click View (button) to see a list of Outstanding Invoices.
Tick the boxes next to the Invoices that were paid.
Note: If you do not tick the boxes, the system will allocate the Supplier Payment to Invoices automatically.
Click Allocate (button).
Select the Customer on the dropdown list next to Cr. Customer.
Click View (button) to see a list of Outstanding Invoices.
Tick the boxes next to the applicable Invoices.
Note: If you do not tick the boxes, the system will allocate the Customer Receipt to Invoices automatically.
Click Allocate (button).
Choose an Account on the left (Ledger) to post the transaction to and complete the necessary fields, including the VAT component.
For Customer Refunds, the account will be the Customer account.
For Supplier Refunds, the account will be the Supplier account.
For all other entries select an Income, Expense, or Asset account.
ℹ️ It is important to enter the VAT correctly when processing general entries.
You may claim VAT on some direct Expenses, like Insurance.
You may not claim VAT on some direct Expenses, like Entertainment.
To create a VAT Payment transaction, allocate the payment to the VAT Control Account and select VAT Only under the VAT column.
Click on a transaction to open it.
Click Status (button) and select Cancelled.
Note: You can also cancel transactions with a zero balance.
You can find previously imported entries by searching for them.
Type the name of the entry in the Search block.
Type the Batch Number of the transaction in the Search ID block.
Note: When you import transactions a Batch Number is automatically assigned.
You set the Status of individual transactions by processing them:
Note: When transactions are first imported, their Status is automatically set to Pending.
Note: The colour shown on the ID will change as you process the transaction to indicate a change in Status.
Click Menu (button) > Batch Updates and select an option next to Batch Update - Status:
Status: Change the status of selected transactions (e.g., mark as Complete or Cancelled).
Select a new Status from the dropdown list.
Click Update (button).
Delete: Delete transactions with a Pending or Cancelled status.
Click on a transaction to open it.
Click Status (button) and select Cancelled.
When a Batch ID is entered, there are three fields at the bottom of the list of transactions:
Bank account
Ledger Account
Variance
If the Variance is zero, you have successfully processed all the transactions. The Bank matches the Ledger.
Note: If you are only processing some of the transactions, the variance will not be zero. For countries that still use cheques, there may be a variance because of uncleared cheques.