A UK company Built and supported in the United Kingdom Help in UK hours Hosted sites kept in London

Bank reconciliation

Match bank transfers to what your customers owe and mark it paid. ModuleFest Pet Services → Bank reconciliation lists everything outstanding — unpaid invoices and booking deposits awaiting payment. Tick an item off by entering the bank reference, the date it landed and an optional note, then Mark bank-paid. Invoices get a receipt and fire your paid automation just as a card payment would; deposits flip to paid on the booking.

If you bank each service separately, add a bank account for each (e.g. “HSBC – Grooming” linked to the Groomer role). Then the CSV import wizard works per account: pick the account, map its columns once (which is date, money-in amount and reference, plus the date format) and that layout is remembered on that account — so each bank’s format is stored independently. Money-in lines are matched first against that account’s role, though you can still pick any outstanding item in the dropdowns.

Example

You add two accounts — HSBC for grooming, NatWest for walking. Each Monday you upload both CSVs against their accounts; the layouts are recognised automatically, grooming payments match grooming work and walks match walks, and the week is reconciled in a couple of minutes.

FAQ

Do I have to set up accounts?
No — you can import without one and match across everything. Accounts are for when you bank services separately and want each layout and role remembered.

My dates import wrong (day/month swapped)?
On the mapping step choose the date format — Day first (DD/MM/YYYY) for UK statements, Month first for US.

What if a payment belongs to the “wrong” role?
The match dropdown always lists every outstanding item, so you can pick anything — the role only sets the default suggestion.

Do you store my account number?
No — only the last 4 digits, as a blind reference, never the full number.

I matched the wrong payment. Can I undo it?
Yes. Everything marked paid on this screen is listed under Recently reconciled. Press Undo and the invoice or deposit goes back to outstanding; the payment it recorded goes to the bin under Payments, where it can be restored if you change your mind.

Why does it not ask which trade an account is for?
Because this plugin runs one trade, every account is for that trade, so it is set for you. Pet Services sites, which run several, still choose.

What happens to money going out?
Choose the Money out column when you map the statement (or, if your bank uses one Amount column, the minus amounts are read as money out). Each line going out is matched to an expense you have already entered with the same amount, or you can record it as a new expense with a category. A supplier named in the description is linked, with its usual category. Undo unlinks a matched expense and puts one it recorded in the bin.

Does it move money?
No. It only records what the statement shows: payments in mark invoices and deposits paid, and payments out are matched to expenses.

Is there a statement I can test the import with?
Yes. Under Import a bank statement, Download an example statement makes a CSV from your own unpaid invoices, laid out like a UK bank’s export, with a couple of payments going out that should be left alone. Upload it, choose Date, Money in and Description on the next step, with dates as day/month/year, and the matching finds your invoices.

Was this helpful?

Still need help? Sign in to your account and raise a support ticket. The people who wrote the code will help, and most tickets are answered the same working day.

Sign in to raise a ticket