You do not need an automatic bank connection to use HirePOS bank matching and reconciliation.

Automatic Bank Feeds, currently provided through third-party provider Illion, are simply one way of bringing bank statement transactions into HirePOS.

You can instead export transactions from your online banking and import them into HirePOS using a CSV file.

Once imported, the same Bank Statements, matching and reconciliation tools are used.

This allows you to:

• Match customer payments to invoices

• Create payments

• Create expenses when using the Accounting/Bookkeeping module

• Review unmatched transactions

• Reconcile your bank account

CSV import is useful when:

• Your bank is not supported by automatic Bank Feeds

• A bank connection is temporarily unavailable

• You prefer not to connect your bank

• You want more control over which transaction periods are imported

• You need to bring historical bank transactions into HirePOS

For most businesses, importing transactions regularly keeps the process simple.

A weekly workflow works well:

1. Export recent transactions from your bank.

2. Import the CSV into HirePOS.

3. Match and process the transactions.

4. Reconcile the bank account.

Weekly or monthly imports are generally easier to manage than importing a very large transaction history at once.

Log in to your online banking and locate the transaction or statement export area.

Export the required transactions as a CSV file.

Weekly or monthly date ranges generally work well.

It can be useful to include a few days of overlap from your previous export.

This helps capture transactions that may previously have been pending or added to your bank statement after your last export.

HirePOS will attempt to identify transactions that have already been imported.

HirePOS needs three main pieces of information:

• Date

• Amount

• Description

Dates should be supplied in:

dd/MM/yyyy

For example:

14/09/2026

Use a single Amount column.

• Positive amounts represent money received.

• Negative amounts represent money paid out.

For example:

HirePOS imports one Description field for each bank transaction.

If your bank provides several description, reference or narrative columns, choose the most useful field or combine them into a single Description column before importing.

Some banks export separate Debit and Credit columns instead of one Amount column.

If so, edit the file in Excel or another spreadsheet program so that:

• Credits become positive amounts.

• Debits become negative amounts.

• Both are combined into one Amount column.

You can remove any columns that are not needed for the import.

The final file should provide clear values for:

• Date

• Amount

• Description

The most direct import path is:

Banking > Bank Reconciliation

Then:

1. Select the required bank account.

2. Click Import CSV.

3. Choose the CSV file or drag and drop it into the upload area.

4. Click Preview Data.

5. Match your CSV columns to:

   • Date

   • Amount

   • Description

6. Review the preview.

7. Click Import Data.

The transactions will be added to the Bank Statements area for the selected bank account.

You can also reach the bank statement workflow through:

Payments > Bank Feeds

Then select Match Transactions and proceed to the reconciliation area.

Once imported, CSV transactions are processed in the same way as transactions retrieved using Get Bankfeeds.

Depending on your HirePOS configuration, you can:

• Match incoming payments to existing payments or invoices

• Create customer payments

• Create expenses

• Match other banking transactions

• Void statement lines that should not be processed

Imported transactions use the same:

• Unmatched

• Matched

• Voided

workflow as automatic Bank Feeds.

After the relevant transactions have been matched or processed:

1. Go to Banking > Bank Reconciliation.

2. Select the bank account.

3. Review and mark off the required transactions.

4. Confirm that the closing balance matches your bank statement.

5. Complete the reconciliation.

HirePOS attempts to prevent the same bank statement transaction from being imported more than once.

The following details are used when identifying possible duplicates:

• Date

• Amount

• Description

This makes it practical to use overlapping export periods.

If two genuine bank transactions have the same date, amount and description, review the imported statement carefully to make sure both transactions are represented.

If an unwanted duplicate statement line appears, it can be moved to Voided so it is excluded from the normal matching process.

The available workflow depends on whether the Accounting/Bookkeeping module is enabled.

The bank statement workflow is primarily used for incoming customer payments.

Both incoming and outgoing transactions can be processed, including:

• Customer payments

• Expenses

• Other supported banking transactions

Both methods ultimately use the same Bank Statements, matching and reconciliation tools.

Automatic Bank Feeds retrieve available statement transactions from a connected bank feed provider.

CSV import allows you to provide those statement transactions manually.

After the transactions have been added to HirePOS, the remaining workflow is essentially the same.

Automatic Bank Feeds are optional.

By regularly exporting transactions from your bank and importing them as CSV files, you can still use HirePOS to:

• Match customer payments

• Create payments and expenses

• Review unmatched bank transactions

• Reconcile your bank account

• Maintain a complete banking workflow without an automatic bank connection

For information about setting up automatic bank connections or troubleshooting missing bank feed transactions, see the Bank Feeds guide.

For more information about balancing and completing a reconciliation, see the Bank Reconciliation guide.