Skip to content
The title slide and first slides of the Income and Expense Ledger template

Income and Expense Ledger

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Style
Modern
Difficulty
Beginner
Updated
November 16, 2026

Every slide (6)

Overview

Sole proprietors often start with a bank statement and a shoebox of receipts. This ledger keeps the two sides apart. Income takes the date, customer, a category and the amount. Expenses adds a vendor, a payment method and a checkbox for saved receipts. The sample is a one-person print studio with 14 sales and 19 costs spread across ten months, so there is a trend to read before you change a single row.

The Summary tab adds both logs by calendar month and charts income against expenses. Net profit and margin sit above, and a pie shows which expense category takes the most. Because it works on a cash basis, a job counts in the month the payment is received. The month totals combine the same month of different years, so start a fresh copy for each year you track.

Useful for

  • Keep simple books for a freelance or side business
  • Hand a year of totals to a tax preparer
  • Spot which expense category grows faster than income

What's included

  • 4 tabs: Income, Expenses, Summary, How to use
  • Income: a table
  • Expenses: a table
  • Summary: a dashboard with 4 summary figures
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Income tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What is the difference between cash basis and accrual?

On a cash basis you record income when money arrives and expenses when you pay. Accrual records them when earned or billed. This ledger is cash basis.

Can I use my own expense categories?

Yes. Edit the Category dropdown and give the new name a row in the Expenses by category list on the Summary tab, otherwise it will not be counted.

Does it handle more than one year?

Monthly totals combine matching months, so keep a separate file for each year. Duplicate it in January and clear the sample rows.

  • #bookkeeping
  • #income-and-expense-ledger
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More bookkeeping templates

See all 6

Also in Finance

All finance templates
Get this template

Preparing your template…