Home Collections Close the month
Tools to
Close the month
Reconcile the bank, match the GST, run the payroll, age the debtors and produce the statements — in the order you actually do them.
12 tools · 9 free with no account · 3 free to try with one
Month end is the same list every month, and the reason it takes three days is not difficulty but shuffling: exports that do not line up, names spelled differently in two systems, a figure that has to be recomputed because somebody changed an invoice. These are the tools for each step, roughly in the order the step comes.
Each one takes what the previous one produced. The bank statement categoriser writes a sheet the bookkeeping tool imports without being touched; the bookkeeping tool produces the trial balance the statements come from.
1 · Get the transactions in Statements and paperwork into something structured.
Bank Statement Categoriser — AI for Business Paste or upload a bank statement and get every transaction categorised to a ledger head — rent, salaries, GST paid, a named customer — as a spreadsheet, or as Tally receipt and payment vouchers ready to import. Free to try Invoice & Receipt Data Extractor — AI for Business Drop an invoice or receipt — PDF or pasted text — and get the vendor, numbers, dates, taxes and every line item back as a table you can download for your accounts. Free to try Expense Receipts to Spreadsheet — AI for Business Photograph up to four expense receipts at a time and get one row per receipt — date, merchant, category, amount, tax, currency and how it was paid — as a CSV or Excel file for the expense claim or the books. Free to try Merge & Dedupe Spreadsheets — Free Online Combine up to ten Excel or CSV files into one sheet — columns matched by heading, rows stacked — then remove duplicates on the columns you choose, with every removed row listed by source file and row. Runs in your browser; nothing is uploaded. Free
2 · Reconcile Make two systems agree, and see where they do not.
Bank Reconciliation — Free Online Match a bank statement against the bank ledger from your books — Tally, Zoho, QuickBooks or a spreadsheet — and get the unmatched entries on each side, the matched pairs, and the closing balances explained. Runs in your browser; nothing is uploaded. Free GSTR-2B Reconciliation — Free Online Match your purchase register against GSTR-2B — the portal’s JSON or Excel — and see which input tax credit is safe to claim, which suppliers have not filed, what is in 2B but not in your books, and where the tax amounts differ. Runs in your browser; nothing is uploaded. Free Receivables Ageing & Payment Reminders — Free Online Turn a list of unpaid invoices into a proper ageing report — 0–30, 31–60, 61–90, over 90 days, by customer — and get a reminder letter for each debtor that names their invoices and their total, with the tone stepping up the longer it has been. Runs in your browser; your debtors list is not uploaded. Free
3 · Post and report The books, and what comes out of them.
Bookkeeping: Trial Balance, P&L and Balance Sheet — Free Online Bring a bank statement, a sales day book or a set of journals into a real double-entry ledger and get the trial balance, profit and loss, balance sheet, VAT or GST figures and every account’s ledger back. Charts of accounts for the UK and India. Runs in your browser — a client’s books are never uploaded. Free VAT Return from a Spreadsheet (the nine boxes) — Free Online Turn a spreadsheet of sales and purchases into the nine boxes of a UK VAT return — standard accrual, cash accounting or the flat rate scheme — with every box opened up to show the rows behind it, and the sheet checked for net-plus-VAT that does not equal gross, duplicate invoice numbers and rows outside the period. It computes the figures; it does not file them. Runs entirely in your browser. Free MTD Quarterly Update Builder — Free Online Turn the income and expense spreadsheet you already keep into the figures a Making Tax Digital quarterly update asks for. It maps your own category names onto the standard self-employment or property headings, cuts the tax year into its four quarterly periods - standard or calendar - and gives the cumulative year-to-date total alongside the standalone quarter, with every unmatched row listed by name. It produces the figures; filing them needs software HMRC has recognised. Runs in your browser. Free
4 · Pay people The deadline inside the deadline.
Monthly Payroll Run: Payslips, Bank File & Statutory Summary — Free Online Drop in a salary sheet and get the whole month's payroll: a payslip PDF for every employee in a zip, a combined PDF, the bank bulk-transfer CSV, and a register workbook with PF, ESI, professional tax and TDS summaries. Pro-rates by paid days, computes the statutory deductions or takes them from your sheet, and refuses to run if anyone's net pay is negative. Runs in your browser; nothing is uploaded. Free Payslip Generator (PDF) — Free Online Create a clean, print-ready payslip PDF: company and employee details, attendance, earnings and deductions, and the net pay in figures and words. Free
Frequently asked questions Do these hand off to each other? Where it is useful, yes. The categoriser’s sheet imports into the bookkeeping tool with its ledger names matched to accounts, and anything it cannot match goes to Suspense and is listed rather than guessed. The rest exchange ordinary spreadsheets, which is deliberate — you can always see and edit what passes between them.
What if the reconciliation will not balance? You are told by how much and shown what is on each side that did not match, with a likely reason against each — a bank charge nobody entered, a cheque not yet presented. Nothing is forced to agree.