Reconciling payments automatically with open banking

For many UK small business owners, the end of the month triggers a familiar, tedious ritual: reconciling payments. It involves manually logging into your bank, downloading statements, and painstakingly matching each incoming payment to the correct sales invoice in your spreadsheet or accounting software. This admin black hole not only consumes hours of your valuable time but also creates a dangerous lag in understanding your true cash flow position. This article explores how Open Banking is revolutionising this process, allowing you to automatically reconcile payments and gain a real-time, accurate view of who has paid and who hasn't.

The Grind of Manual Bank Reconciliation

Before we dive into the solution, it’s worth acknowledging the pain points of the traditional method. Manual reconciliation is more than just a chore; it's a genuine operational risk for a small business.

The process typically looks something like this:

1. Log in to your business bank account.
2. Navigate to the statements or transactions page.
3. Filter by date and download a CSV file or PDF statement.
4. Open your accounting software or spreadsheet in another window.
5. Go through the bank statement line-by-line, trying to match each deposit to an outstanding invoice.

This is where the problems begin. You might have a customer payment for £240, but three outstanding invoices for that client. Which one is it for? Another payment arrives with the reference "Payment" – from which of your 50 clients did that come? A customer might pay for three invoices in one single transaction, forcing you to do the maths to split the payment across them. Each of these scenarios requires detective work, wasting time and introducing the potential for human error.

The consequences of this manual slog are significant:

• Wasted Time: Time spent ticking and tying numbers is time you're not spending on sales, marketing, or serving your customers.
• Inaccurate Cash Flow: Your accounts are only as up-to-date as your last reconciliation. If you only do it weekly or monthly, you're making business decisions based on old data. You might think a client is a late payer when, in fact, they paid three days ago and you just haven't marked it off yet.
• Delayed Credit Control: You can't chase an overdue invoice if you don't know for certain that it's actually overdue. The delay between a payment arriving in your bank and you recognising it in your accounts gives late payers extra time they haven't earned.

What is Open Banking (in Plain English)?

Open Banking is a secure, UK-regulated technology that allows you to share your financial data with authorised third-party applications. It was introduced by the Competition and Markets Authority (CMA) to increase competition and innovation in financial services.

In simple terms, instead of you manually downloading data from your bank, Open Banking allows your accounting software to automatically and securely pull that data for you.

Crucially, this does not involve sharing your online banking username or password with the software provider. Instead, you grant specific, time-limited permission via a secure process managed by your bank. The connection uses an Application Programming Interface (API)—a highly secure and standardised digital messenger—to transmit the data. It's a "read-only" connection, meaning your accounting software can see your transactions but has no ability to move money or make payments on your behalf.

How Bank Feeds Automate Invoice Matching

This secure connection is what enables a "bank feed" in your accounting software. A bank feed is a live, automated stream of your bank transactions that flows directly into your accounting platform (like Xero, QuickBooks, FreeAgent, or Sage) every day.

Once this data is flowing in, the software gets to work on the reconciliation process. Instead of you manually matching payments, the software attempts to do it for you using a set of smart rules.

The Matching Process: From Transaction to 'Paid'

When a new transaction appears from your bank feed, the software analyses it and compares it against your list of outstanding (awaiting payment) sales invoices. It looks for clues to find a match:

• Exact Amount: If an incoming payment of £600.00 exactly matches a single outstanding invoice for £600.00, the software will suggest matching them. This is the most common and simple match.
• Payment Reference: This is the most powerful tool for automation. If you ask clients to use the invoice number (e.g., INV-0123) as their payment reference, the software can instantly and accurately match the payment to the corresponding invoice, even if the amount doesn't match perfectly (for example, due to a part-payment).
• Customer Name: The software will look at the name on the incoming bank transaction and try to match it to a customer in your system. If "Acme Widgets Ltd" pays you, it will suggest matching it to an outstanding invoice for your customer, Acme Widgets Ltd.
• Machine Learning: Modern accounting platforms learn from your behaviour. If you repeatedly match a payment from "AWL Trading" to the customer "Acme Widgets Ltd," the software will remember this and start suggesting it automatically in the future.

In many cases, the software finds a perfect match and can reconcile the payment with a single click of a "Confirm" button. For dozens or hundreds of transactions a month, this reduces hours of work to minutes.

Dealing with the Awkward Squad: When Payments Don't Match

Of course, the real world is messy. Not every payment is a perfect match. This is where automated feeds still provide a huge advantage over the fully manual method. The software will flag any transactions it can't automatically match for your review.

Common exceptions include:

• Batch Payments: A customer makes one payment of £1,500 to cover three separate invoices of £400, £600, and £500. The software will see the £1,500 transaction and allow you to easily find and select the three invoices that add up to that total.
• Part-Payments: A client pays £250 towards a £1,000 invoice. The system will suggest matching the £250 against the larger invoice, leaving the remaining £750 as outstanding.
• Minor Discrepancies: A customer paying an international invoice might have had a small bank fee deducted, so they pay £995 instead of the £1,000 invoiced. The software will highlight the near-match and let you approve it, while also allowing you to easily categorise the £5 difference as a bank fee.
• Vague References: The dreaded payment with the reference "Invoice" or the customer's own company name. While the software can't magically know which invoice this is for, it presents the transaction alongside a list of all outstanding invoices for that customer, making the manual detective work much faster.

Even when manual intervention is needed, you're working from a pre-populated list inside your accounting software, not toggling between a browser window and a CSV file.

The Tangible Benefits for Your Business

Adopting Open Banking feeds is not just about saving a bit of time on admin. It has a cascading positive effect on your entire business operation.

• Save Hours of Admin: For most businesses, this is the biggest and most immediate win. The time you get back can be reinvested into revenue-generating activities.
• Gain Real-Time Cash Flow Clarity: Your accounts become a live, accurate reflection of your financial position. You can log in any time and see exactly which invoices are paid and which are still outstanding, up to the last 24 hours. This empowers you to make better, faster decisions about spending, investment, and growth.
• Improve Accuracy: Automated matching removes the risk of human error like marking the wrong invoice as paid or making typos when entering data. This leads to more reliable financial reports and less stress at year-end or when preparing your VAT return.
• Accelerate Your Credit Control: With a real-time view of paid and unpaid invoices, you know the instant an invoice becomes overdue. There's no longer a week-long delay while you wait to do your manual reconciliation. This allows you to act immediately. By combining an automated bank feed with an invoice chasing tool like InvoiceReminder, you can create a fully automated accounts receivable process. The bank feed confirms a payment hasn't arrived, and the chasing software automatically sends a polite reminder email on your behalf, ensuring you get paid faster without lifting a finger.

Comparing Manual vs. Automated Reconciliation

The difference between the old and new ways of working is stark. The table below summarises the key advantages of using Open Banking feeds.

Feature	Manual Reconciliation	Automated Reconciliation (with Open Banking)
Time Investment	High (hours per week/month)	Low (minutes per week)
Accuracy	Prone to human error (typos, mismatches)	High, with software flagging exceptions for review
Cash Flow Visibility	Delayed and outdated (weekly or monthly view)	Real-time (daily updates)
Credit Control	Slow and reactive, based on an outdated accounts receivable ledger	Fast and proactive, enabling immediate chasing of overdue invoices
Data Security	Relies on downloading statement files to your local computer, which can be a security risk	Bank-level security via regulated APIs; no files stored locally
Setup Effort	No setup, but high ongoing effort	Low one-time setup (5-10 minutes), then minimal ongoing effort

Setting Up Your First Open Banking Feed: A 5-Step Guide

Getting started is surprisingly straightforward and typically takes less than 10 minutes. The exact steps will vary slightly depending on your accounting software, but the general process is the same.

1. Check Compatibility: First, confirm that your business bank account and your accounting software support Open Banking. Almost all major UK high street banks (Barclays, Lloyds, HSBC, NatWest, Santander, etc.) and challenger banks (Starling, Monzo) do, as do all major cloud accounting platforms.
2. Find the 'Bank Feeds' Section: Log in to your accounting software and look for a menu item called "Banking," "Bank Feeds," or "Connect a Bank Account."
3. Select Your Bank: You'll be presented with a list of UK banks. Choose yours from the list.
4. Authorise the Connection: You will be securely redirected to your bank's own website or mobile app. Here, you will log in using your normal banking credentials to approve the connection request from your accounting software. You are authorising a secure, read-only link.
5. Complete the Initial Import: Once authorised, you'll be sent back to your accounting software. It will begin importing your recent transaction history (often the last 30-90 days). From this point on, new transactions will typically appear automatically every 24 hours.

A key security feature of Open Banking is that you must re-authorise this connection every 90 days. Your software will prompt you when this is due. It's a quick process that ensures you remain in full control of who has access to your data.

Answering the Big Question: Is It Safe?

For any business owner, handing over access to financial data is a serious consideration. The good news is that Open Banking was designed with security as its absolute foundation.

• Bank-Level Security: The entire system uses the same level of encryption and security protocols that your bank uses for its own online banking and mobile app.
• FCA Regulation: Any company that uses Open Banking to access your data must be registered with or authorised by the Financial Conduct Authority (FCA) as an Account Information Service Provider (AISP). This means they are subject to strict rules on data security and privacy.
• Read-Only Access: To reiterate, your accounting software only gets "read-only" access. It can see transaction details but cannot initiate payments, set up direct debits, or move money in any way.
• No Shared Passwords: You never share your banking login details with your accounting software. The authorisation happens directly on your bank's secure platform.
• You Are in Control: You can see which connections you have active and revoke access at any time, either from within your accounting software or through your online banking portal. The mandatory 90-day re-authorisation is an extra layer of protection.

Frequently asked questions

Is Open Banking free to use?

The Open Banking connection itself is free. However, it is a feature of accounting software, so you will need a subscription to a platform like Xero, QuickBooks, FreeAgent, or Sage to use it. The cost is part of your overall software subscription.

Why do I have to re-authorise the connection every 90 days?

This is a regulatory requirement designed for your security. It ensures that connections don't remain active indefinitely without your knowledge and confirms that you still consent to sharing your data. Your accounting software will notify you when it's time to re-authorise.

How does the software handle a single payment for multiple invoices?

When a batch payment appears in your bank feed, the software won't find a single matching invoice. Instead, it will allow you to "Find & Match." You can then view all outstanding invoices for that customer and tick the ones that are being paid. The system will confirm that the total of the selected invoices matches the payment amount before you approve the reconciliation.

Can my accounting software take money from my bank account?

No, absolutely not. Open Banking bank feeds provide "read-only" access. The software can only view your transaction data to help with reconciliation. It has no permission or technical ability to initiate payments, transfer funds, or make any changes to your bank account.

Which UK banks support Open Banking?

Virtually all of them. The UK's nine largest banks (the "CMA9": Barclays, HSBC, Lloyds, RBS, Santander, Nationwide, Danske Bank, Bank of Ireland, and AIB) were required to implement it, and most other UK banks and building societies have followed suit, including challenger banks like Starling and Monzo.

What happens if I switch my business bank account?

The process is simple. In your accounting software, you would disconnect the bank feed for your old account. Then, you would follow the standard setup process to connect a new bank feed for your new account.

Get Paid Faster, Starting Today

Once your bank feeds are set up and reconciliation is automated, you have a powerful, real-time view of your accounts receivable. You know instantly who has paid and, more importantly, who hasn't. The logical next step is to automate the chasing process for those late payers. InvoiceReminder connects directly to your Xero, QuickBooks, Sage, or FreeAgent account to do just that. It uses your now-accurate data to automatically send scheduled reminder emails—from polite prompts to firm final notices—so you can stop chasing invoices by hand.

By pairing automated reconciliation with automated chasing, you create a powerful system to improve your cash flow and free up your time. InvoiceReminder is built by the team behind WeCovr, a UK company authorised and regulated by the Financial Conduct Authority, which has arranged over one million insurance policies. The platform currently offers a Free plan that includes unlimited email reminders at no cost, making it easy for any small business to get started.