Bookkeeping templates
Free templates to start your books from. Each one opens in any spreadsheet program and comes with a guide to what goes in each column.
Accounts payable template
A free accounts payable template as a CSV file: a creditors list of unpaid supplier bills, with due dates, amounts still owing and how far past due each is.
Accounts receivable template
A free accounts receivable template as a CSV file: a list of unpaid customer invoices, with the amount paid, the amount still owed and the days overdue.
Balance sheet template
A free balance sheet template as a CSV file: current and non-current assets and liabilities, net assets and equity at a single date.
Bank reconciliation template
A free bank reconciliation template as a CSV file: your statement balance and book balance at one date, and the items that explain the gap between them.
Bookkeeping spreadsheet template
A free bookkeeping spreadsheet template as a CSV file: a month's income and expenses by category, with a total for each category and the month's net result.
Business budget template
A free business budget template as a CSV file: planned income and costs by line for the financial year, with columns to compare them with actual figures.
Cash book template
A free cash book template as a CSV file: money in and out of the business bank account in date order, with a running balance after every entry.
Cash flow forecast template
A free cash flow forecast template as a CSV file: expected money in and out for the months ahead, with opening and closing cash for each month.
Chart of accounts template
A free chart of accounts template for a small business, as a CSV file: starter accounts grouped into assets, liabilities, equity, income and expenses.
Credit card reconciliation template
A free credit card reconciliation template as a CSV file: compare the card statement with the card account in your books and see what is left to explain.
Expense tracker template
A free expense tracker template as a CSV file: one row per business expense, with the supplier, purpose, category, amount, how it was paid and the receipt.
Fixed asset register template
A free fixed asset register template as a CSV file: each asset the business owns, its supplier, purchase date and cost, identifier, location and disposal.
Inventory list template
A free inventory list template as a CSV file: each stock item's code, description, supplier, quantity on hand, reorder point, reorder quantity and unit cost.
Journal entry template
A free journal entry template as a CSV file: the date, journal number, account, debit and credit for each line, and a narration saying why the entry was made.
Petty cash log template
A free petty cash log template as a CSV file: a set float, each payment with its voucher number and expense account, a running balance and each top-up.
Petty cash voucher template
A free petty cash voucher template as a CSV file: one slip per payment, showing who was paid, what for, the expense account, the receipt and the approval.
Profit and loss template
A free profit and loss template as a CSV file: sales, cost of goods sold, gross profit, expenses and net profit for a period, beside the same period last year.
Purchase order template
A free purchase order template as a CSV file: the order details, then each item with its quantity, unit price and line total, and the total for the order.
Quote template
A free quote template as a CSV file: the job, priced lines with quantity, rate and amount, the total, how long the price stands and the payment terms.
Remittance advice template
A free remittance advice template as a CSV file: a payment to a supplier, each bill it covers, any credit note used and the total paid.
Statement of account template
A free statement of account template as a CSV file: a customer's opening balance, the period's invoices, payments and credits, and the closing balance owed.
Stocktake sheet template
A free stocktake sheet template as a CSV file: each item and location, the quantity in your records and the count, any shortage or overage, and who counted it.
Supplier reconciliation template
A free supplier reconciliation template as a CSV file: one supplier's statement matched document by document against your own record of what you owe them.
Till reconciliation template
A free till reconciliation template as a CSV file: work out the cash a till should hold at close of trading, count it, and explain any shortage or overage.
Trial balance template
A free trial balance template as a CSV file: each ledger account's balance at one date, with its code and group, in debit and credit columns that should agree.