Stratancy Insights

Monthly Bookkeeping Checklist for Irish Small Businesses

A repeatable month-end routine for invoices, bank reconciliations, VAT records and financial review, with a free checklist you can open in Excel.

All insights

Published

A useful monthly bookkeeping checklist does more than confirm that transactions have been entered. It establishes that the bank reconciles, the supporting records are complete and unexplained balances have someone responsible for resolving them.

The routine below is a practical starting point for Irish SMEs. Adapt it to your structure, VAT position, payroll and software. It is a working process, not a substitute for your business's filing calendar.

Download the monthly checklist

Download the free monthly bookkeeping checklist: CSV for Excel.

Open the file in Excel, save a working copy for each period and assign a preparer and reviewer. The download includes columns for evidence, status, exceptions and completion dates. It contains no macros or bank connections.

Before you start: agree a cut-off

Choose when records must reach the bookkeeper and when reports should be ready. For example, a business might request documents by the fifth working day and aim for review by the tenth. These are illustrative internal targets, not statutory deadlines.

Late records still need assessment. Maintain a list of invoices received after the cut-off and decide whether they affect the closed period.

1. Confirm the completeness of income

Check invoice sequences, sales exports and credit notes. Compare sales-system totals with the ledger and investigate gaps. Customer payments should clear the correct invoice, not create a second sale.

For an online shop, compare orders, refunds and payment-provider activity separately. A bank payout alone does not establish the sales figure. See our Shopify and Stripe reconciliation guide.

2. Collect purchase invoices and expenses

Match bills to supporting documents and review duplicate invoice numbers. Separate business expenditure, personal spending, asset purchases and amounts requiring clarification.

Keep a missing-document list with the supplier, amount, responsible person and due date. A transaction description is not always enough to determine the accounting or VAT treatment.

3. Reconcile every bank and card account

Use the statement closing balance for the correct date. Match bank transactions to the ledger, identify outstanding items and investigate old differences.

A bank feed showing no uncoded lines is not the same as a completed reconciliation. Check feed coverage, missing days, duplicated imports and balances carried from the previous month.

4. Reconcile payment providers and cash

For Stripe, PayPal and marketplaces, reconcile the opening balance, receipts, deductions, transfers and closing balance. Keep currencies separate. Match transfers between business accounts on both sides so they do not become income or expenses.

Where cash is used, compare the cash record with the physical balance and investigate differences promptly.

5. Review customers and suppliers

Check overdue customer invoices, disputed amounts, unallocated receipts, supplier statements and duplicate bills. Agree a collection action for overdue balances.

Do not delete an invoice simply because it looks old. Establish whether it was paid, credited, disputed or requires a considered write-off.

6. Check payroll and tax control accounts

Reconcile payroll summaries to the ledger and explain amounts owed or paid. Check VAT control movements against the relevant records and returns where applicable.

A monthly bookkeeping close does not set the tax filing frequency. Maintain a separate due-date register for each obligation and name the person preparing, approving and submitting it. Our VAT3 article explains that return.

7. Review timing adjustments and assets

Look for annual subscriptions, insurance and costs incurred but not yet billed. Maintain a schedule supporting each material accrual or prepayment, including its calculation and release date.

Review equipment purchases, loans, interest and director transactions where relevant. Refer to Accruals and Prepayments for the timing principles; do not treat every bank payment as an immediate expense.

8. Challenge the reports

Read the profit and loss account alongside the balance sheet. Compare margins and major costs with prior periods and expectations.

For an illustrative business, a sudden fall in software costs could mean a cancelled subscription, a missing invoice or an annual payment posted elsewhere. Ask which explanation is supported by evidence.

Investigate old suspense items, unusual negative balances and amounts that never change. A neat report is not proof of accurate underlying records.

9. Record review and close the period

Keep the reconciliation evidence, adjustments, query log and reviewer sign-off together. Restrict changes to completed periods where your software supports it. Document any later correction and its effect rather than silently overwriting reviewed figures.

A useful summary is:

AreaCompletion evidence
Bank and cardsReconciliations tied to statements
Sales and purchasesComplete exports, invoices and exception list
Payment providersBalance and payout reconciliations
AdjustmentsSupported schedules and approved journals
ReportingReviewed reports with explanations

Records and retention

Revenue requires supporting business records and generally six-year retention; VAT records have additional format and circumstance-specific requirements. Check the official guidance before discarding originals. A scanned receipt does not automatically justify destroying every paper document.

Frequently asked questions

Can a small business use a spreadsheet?

A spreadsheet can support a simple process if the records remain complete and controlled. Complexity, transaction volume and reporting needs may justify accounting software.

Must every task happen monthly?

Adapt the routine to the business. Some tasks happen daily or weekly, while returns follow their own timetable. Monthly review helps prevent unresolved items accumulating.

Need a maintained monthly process?

Stratancy's bookkeeping service can help establish the records, responsibilities and review routine. If you need a fuller output, read our management reporting pack guide.

Official sources

Written by Stratancy Consulting Team

General information only. Accounting and tax treatment depend on your circumstances. Contact Stratancy for advice specific to your business.

Need help with your business?

Talk to Stratancy about accounting, payroll and tax support in Ireland.