MILabs
Integrations

Payments reconciliation with Kounta: matching till sales to bank settlements

Match Kounta sales records with card and bank settlements, flag gaps, and route unclear items to your team for review.

Updated 2026-06-29

Payments reconciliation with Kounta

A point-of-sale system such as Kounta records sales at the till, while the bank and card processor record when money actually arrives. Payments reconciliation brings those two views together. For a hospitality business the gaps are easy to miss: a day's card settlement may arrive net of fees, a refund may be processed on a later day than the sale it reverses, and cash takings may be counted against a different total. MILabs would build the reconciliation as an integration that reads the sales and settlement records, applies matching rules, and sets unclear items aside for the owner or bookkeeper to review. Kounta remains the system of record. The result is a checked list of what has been paid and what still needs an answer.

How it works

  1. Confirm which sales, settlement and payment exports your Kounta plan provides, since access can differ between plans and regions.

  2. Pull the day's sales records from Kounta and the matching settlement lines from the bank or card processor on a fixed schedule.

  3. Match each settlement to its sales total using amount, date and reference, allowing for processor fees where the statement shows them.

  4. Flag short payouts, duplicate charges and refunds that do not line up with a sale, and place them in a review queue.

  5. Post confirmed matches to the accounting ledger, with Kounta remaining the source for sales and the ledger holding the final entry.

good questions, straight answers

Frequently asked questions

What should I back up in Kounta first?
Before reconciliation work starts, export the sales, refund and payment reports your Kounta account allows, and save them with their dates in a folder the owner controls. Keep the bank and card processor statements for the same period beside them, so any mismatch can be traced to the original records.
How does a payments reconciliation connect to Kounta?
The connection starts with the records Kounta makes available for the account. A reconciliation job reads the sales and payment exports, then reads the settlement lines from the bank or card processor, and compares the two using amount, date and reference. Where a direct data connection is not offered for a given field, the job works from the exported files instead. Exports are a solid way in, and the matching works the same either way.
Do I need a developer to connect a payments reconciliation to Kounta?
In most cases, yes. The matching rules, the review queue and the link to the ledger are usually built and maintained by someone who can work with exports, scheduled jobs and accounting data. A bookkeeper or team lead can run the process day to day once it is set up, and check each flagged item. Whether a developer is needed for a particular account depends on which exports and access options are available, which is confirmed before any build starts.
How does a payments reconciliation stay in step with Kounta?
It stays in step through a schedule. Each run pulls the period's sales and payment records from Kounta, along with the newest settlement lines, so the reconciled view follows the till rather than a copy taken weeks earlier. Items that could not be matched stay in the review queue until someone resolves them, and a record of each decision is kept. Changes recorded in Kounta after a run should appear on the next one, provided the export includes them.
How do I know a payments reconciliation works with Kounta?
Run it against a closed period and watch it work. Take a month where the owner already knows the outcome, run the reconciliation, and compare the matched and flagged items with the known result. Look for each short payout, duplicate and partial refund appearing in the review queue. When the results agree across several periods, you have a build that fits your account, and you can repeat the same comparison whenever Kounta reports or the bank format changes.
let's make something happen

Custom development: how we can help

Choose how you want to work on this with MILabs. Both options start with an enquiry.

Discovery is free, no obligation from the first chat.

Let us build it for you

We build it and look after it.

Build it yourself, we'll help

You build it with our direction, teaching and a weekly check-in.