Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceAccounting & BookkeepingBookkeepingSmall Business Bookkeeping Checklist

SpreadsheetBookkeepingFree

Small Business Bookkeeping Checklist

Every daily, weekly, monthly, quarterly and annual bookkeeping task with an owner, the date last done, the next due date and what is overdue.

Shown with sample data

Colour

Small Business Bookkeeping Checklist

Every daily, weekly, monthly, quarterly and annual bookkeeping task with an owner, the date last done, the next due date and what is overdue.

Books up to date
71%
Overdue tasks
4
Due in the next 3 days
2
Not started
1
Overdue tasks by frequency
  • Daily2
  • Weekly1
  • Monthly1

How to use it

  1. 1Edit the task list to fit your business: delete what does not apply and add your own.
  2. 2Assign an owner to every task.
  3. 3Type the date each task was last completed; the next due date and status calculate from its frequency.
  4. 4Start each week with tasks marked Overdue, then Due soon.
  5. 5Check the By frequency sheet monthly: it shows which part of the routine is slipping.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Bookkeeping fails quietly: a missed reconciliation in March becomes a lost weekend in April. This checklist sets out the routine every small business needs, from daily takings and weekly bill entry to monthly reconciliations, quarterly tax payments and year-end filings; record when each task was last done and it works out the next due date, flags what is overdue or due soon, and scores how up to date your books are.

Who it’s for

  • Owners doing their own books
  • Handing tasks to a bookkeeper or office manager
  • Getting ready for tax season without a scramble

What’s included

  • Tasks sheet: The full bookkeeping routine.
  • By frequency sheet: How up to date each part of the routine is.

How to use it

  1. 1Edit the task list to fit your business: delete what does not apply and add your own.
  2. 2Assign an owner to every task.
  3. 3Type the date each task was last completed; the next due date and status calculate from its frequency.
  4. 4Start each week with tasks marked Overdue, then Due soon.
  5. 5Check the By frequency sheet monthly: it shows which part of the routine is slipping.

Tips

  • Reconcile bank accounts monthly without fail. It is the single control that catches most errors and fraud.
  • Keep business and personal spending in separate accounts and cards.
  • Book a recurring 30-minute slot each week for bookkeeping; little and often beats a quarterly clean-up.

Questions

What bookkeeping tasks should be done monthly?

Reconcile bank and card accounts, send customer statements, reconcile supplier statements, pay payroll taxes, file sales tax if you are a monthly filer, review the profit and loss and balance sheet, and back up your records.

How long should I keep business records?

In the US, keep tax records for at least three years and often seven; employment records at least four years; asset records until seven years after disposal. Rules vary by country.

Do I need a bookkeeper?

If transactions take more than a few hours a week, you are behind on reconciliations, or you have payroll and sales tax, a bookkeeper usually costs less than the time and mistakes saved.

Related searchesbookkeeping checklistsmall business bookkeepingmonthly bookkeeping tasksbookkeeping scheduleaccounting checklist small businessyear end bookkeeping checklist

Details

Format
Spreadsheet
Category
Bookkeeping
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetBookkeepingFree

Small Business Bookkeeping Checklist

Every daily, weekly, monthly, quarterly and annual bookkeeping task with an owner, the date last done, the next due date and what is overdue.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Bookkeeping
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More bookkeeping templates

View all
General Ledger2 sheets

Total debits

$19,020

Total credits

$19,020

Out of balance

$0

ABCD
1Entry no.DateAccountDescription
2J-001Nov 1BankOwner investment
3J-001Nov 1Owner equityOwner investment
4J-002Nov 2EquipmentLaptop and printer
5J-002Nov 2BankLaptop and printer
Journal
SpreadsheetBookkeeping

General Ledger

A double-entry journal with account totals, a running check that debits equal credits and balances by account type.

10 min setupPreview
Chart of Accounts2 sheets

Accounts

18

Active

18

ABCD
1NumberAccount nameTypeStatement
21,000Bank: current accountAssetBalance sheet
31,100Accounts receivableAssetBalance sheet
41,200InventoryAssetBalance sheet
51,500EquipmentAssetBalance sheet
Accounts
SpreadsheetBookkeeping

Chart of Accounts

A numbered, ready-to-edit account list for a small business with types, statement mapping and active flags.

10 min setupPreview
Sales Journal (Sales Day Book)3 sheets

Net sales

$14,177

Sales tax collected

$940

Total receivable raised

$15,117

Gross invoiced by customer
$6,440
$4,522
$1,641
$1,314
$1,200
Juniper & CoHarbor LogisticsCedar HealthBluepeak RetailAtlas Freight
SpreadsheetBookkeeping

Sales Journal (Sales Day Book)

Record every credit sale once, then post the totals: receivables, sales by account and sales tax, with a balance check.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ