FigureLane

Monthly bookkeeping checklist

Collect sales invoices and expense receipts, check bank transactions when available, resolve missing evidence and prepare your monthly handover. Use the free Excel checklist for freelancers, sole traders or bookkeepers preparing one business at a time. Track each task's status, owner and notes without signing up.

On this page

Your monthly bookkeeping checklist

Work through these checks for one business and month. The Excel checklist has editable business, month and reviewer fields, task statuses, owners and notes. Keep incomplete work visible for the next reviewer.

  • Collect sales invoices and check which have been paid; keep unpaid invoices visible.
  • Collect expense receipts and purchase invoices, with clear originals for each record.
  • If you use bank statements, compare every transaction and reconcile the opening and closing balances.
  • Check dates, duplicates and receipt-to-bank matches so each movement is counted once.
  • Record missing paperwork and unexplained transfers with an owner and next action.
  • Review categories and business-use choices against the originals.
  • Choose the report dates, download the report and originals, and identify unfinished work as DRAFT.

Set the scope before collecting files

For this monthly routine, choose one business and one month. List the bank accounts being prepared, the currency of the records and the person reviewing them. Keep another business's paperwork separate, even when the same person manages both.

List the paperwork you expect for your business. A checklist should describe what is needed, rather than simply count what has arrived. If an accountant will use the output, confirm their requirements. You can start with receipts and invoices without a bank statement.

Which documents should I collect each month?

  • If you are using bank statements, collect every page for each relevant account, including opening and closing balances where available.
  • Receipts and purchase invoices supporting payments. Keep the original file or a clear photo, rather than only a typed total.
  • Sales invoices and purchase invoices, with their purpose clear. Invoices created in FigureLane start unpaid; mark them paid in Income when payment arrives.
  • Any available bank CSV exports. Preserve the downloaded copy before changing column names, dates or amount signs.
  • A short list of missing files, unclear transfers and other transactions that need an explanation from the business owner.

Check the documents before reviewing the figures

Look for repeated uploads, paperwork belonging to another month and missing statement pages. Similar filenames do not prove that two files are duplicates; compare their contents before removing either copy.

When a statement is present, check its opening balance plus credits minus debits against its closing balance. A difference is a reason to investigate missing rows, signs or source details. An agreeing balance does not prove that every description or supporting document is correct.

Receipts and invoices can become preparation records on their own. If the same item appears in a bank statement, confirm the match so it is counted once. Choose a category and business portion during review; those choices do not establish the item's tax treatment.

Worked example: September paperwork with two open questions

Harbour Studio is a fictional business preparing its September 2026 operating account in USD. Its source statement and draft CSV contain four movements. The opening balance is USD 2,200.00, credits are USD 1,450.00 and debits are USD 1,084.00, giving a closing balance of USD 2,566.00.

The table separates bank-row checks from supporting evidence. The rent evidence and sales invoice are present in this illustrative packet; the Northline receipt and Alex transfer explanation are missing. Those supporting attachments are not included in the downloads. No accounting or tax categories have been assigned.

Bank movementSource checkEvidence statusNext action and owner
4 September: Northline supplies, USD 124.00 debitDate, description, amount and balance agreenorthline-receipt-2026-09-04.pdf is missingOperations owner: supply the receipt or report that it is unavailable
6 September: Studio rent, USD 680.00 debitDate, description, amount and balance agreestudio-rent-september-2026.pdf is present in the exampleLink the evidence to the existing bank row
9 September: Client payment, USD 1,450.00 creditDate, description, amount and balance agreesales-invoice-2026-091.pdf is present in the exampleLink the invoice to the existing bank row
18 September: Transfer to Alex, USD 280.00 debitDate, description, amount and balance agreealex-transfer-note-2026-09-18.txt is missing; purpose is unresolvedBusiness owner: explain the recipient and purpose, and provide evidence

Finish with a reviewable handover

In the Harbour Studio example, all four bank rows have been checked and the balance agrees, but the packet stays DRAFT because two evidence questions remain open. Send the source statement, draft CSV, received supporting files and handover together. Keep each question's affected row, owner and next action visible.

Record answers and attach new evidence to the affected row. Review unresolved items before using the figures for accounts or tax preparation. A missing receipt is not a reason to invent an explanation or silently drop the bank movement.

  • Compare extracted dates, descriptions and amounts with the originals, and correct uncertain figures before approving the records.
  • Make unresolved questions visible, with enough detail for someone else to find the relevant document.
  • Identify unfinished exports as drafts. Check the receiving software's import format before importing a CSV.
  • Save a copy of the preparation and its originals in your own records. Confirm any accounting or tax decisions with your adviser when needed.

How FigureLane fits this checklist

Open Documents and upload into Income or Expenses, or choose Mixed for a combined batch. The Document month filter uses each document’s date, so a September receipt uploaded in October belongs to September. Use Date to check to find files without a usable date. This filter does not change your monthly upload allowance.

Review the figures, categories and business portions, then open Reports. Download a PDF report or Excel workbook for the uploaded dates, one month or another chosen range. ZIP packs include originals. A saved tax rate can add an estimate; it does not calculate actual tax owed.

The free sample includes 10 uploads total with no expiry. Starter and Pro have monthly upload allowances; check Pricing for current plans and checkout availability.

Check your business figures

Use your reviewed totals in these free calculators. Each includes its formula, a worked example and downloadable results.

Common questions

Is the monthly bookkeeping Excel checklist free?

Yes. Download the reusable Excel checklist without an account or payment. It has business, month and reviewer fields, task statuses, owners and notes. FigureLane's document-reading workspace is separate and includes a sample of 10 uploads total.

Do I need receipts as well as a bank statement?

A statement records money movement. Receipts and invoices provide detail and can also be prepared without a statement. When both represent the same item, confirm the match to avoid counting it twice.

What should I do when a document is missing?

Record what is missing, which transaction it concerns and who can supply it. Keep the question visible in the handover.

Do monthly uploads require a separate workspace each month?

No. Keep uploading to the same business in Documents. Use Document month to focus on a month, then choose the date range separately in Reports. The free sample is 10 uploads total; paid plans have monthly allowances.

Sources

Prepare your own documents