Bank Account Reconciliation

The retail management software you choose for your business needs to be able to handle the complexities of bank account reconciliation. RetailBasics makes bank account reconciliation for EOFY and quarterly BAS submissions a breeze, with the ability to import bank records downloaded from your banking application in any format, and to match those records to your rules, or a range of different business transactions.

Create custom match rules, upload bank statements and process. RetailBasics takes care of matching bank records to invoices, wage payments, superannuation payments, and the rules you've created. If necessary, we'll create the spend and receive money records required for automatic reconciliation.

Match against your own rules

RetailBasics will scan imported transaction records, looking for matches against words and phrases, transaction amounts, or combinations that you define, and create expenditure or money records accordingly. You can also define match criteria that result in transfer records between accounts being created automatically.

Superannuation owed

RetailBasics will look for amounts of superannuation owing across all employees belonging to a nominated fund and either update superannuation payments or create payment records accordingly. And if your payments are made to a fund payment service such as SuperChoice, RetailBasics will try and match the totals owing to all employees at any time and create matching contribution records and bookkeeping entries for each.

Wage payment amounts

For imported withdrawals, RetailBasics will match amounts against wage payments for the employee that you nominate in your custom rules and reconcile the bank transaction with the wage payment record automatically.

Supplier or customer invoice amounts

For withdrawal transactions that you've imported, RetailBasics will look for any supplier invoices with a matching outstanding amount and allocate payments to the correct invoices accordingly, and adjust your Accounts Payable records to match.

The most advanced bank account reconciliation features of any retail business management system

RetailBasics will automatically generate not only expense records and receive money records based on the rules you define, but will also create transfer transactions for amounts transferred between your various bank accounts, in both affected accounts. And if your bank transactions don't reconcile at import time but later you add a wage payment, superannuation payment or invoice detail that matches an imported transaction, RetailBasics will reconcile the bank transaction at time of creation as well.

Take the pain out of bank reconciliation. Start your free trial today!

Get Started

Bank Statement Reconciliation FAQ

Can your retail business management system handle multiple bank accounts?

keyboard_arrow_down

Businesses with multiple bank accounts need a system that can easily manage them, including automatic reconciliation and the ability to switch between accounts. RetailBasics will reconcile transactions across all of your transaction, debit and credit accounts, even if they are held with different financial institutions.

Can your retail business management software handle complex transactions?

keyboard_arrow_down

RetailBasics handles transactions like fees, interest, and adjustments accurately. It can match a single payment to the combined amount of multiple outstanding invoices against a single supplier. It can match a payment to multiple superannuation amounts to a single fund or aggregator. It can even automatically create transfers between different accounts.

Can your retail store management system import transactions from bank statements?

keyboard_arrow_down

RetailBasics can save time and reduce errors by importing data from bank statements that you download from your bank in Excel or CSV formats, and then search for matching payments to suppliers, wage payments and superannuation payments, or matching payments from suppliers. You can also setup rules for generating transfers between accounts, and spend money or receive money records, based on text found in the transaction description, deposit/withdrawal amount, or a combination of both.

Can your retail business management software handle reconciliation discrepancies?

keyboard_arrow_down

RetailBasics gives you total visibility of bank transactions that have yet to be reconciled so that you can pinpoint the source of the problem easily.