Skip to content
General Ledger cover: a sample sheet with total debits, total credits and difference (should be 0) and a bar chart, beside the Dashboard and Journal tabs

General Ledger

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Minimal
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

This general ledger suits bookkeepers and small business owners who record transactions in double-entry form. The Journal tab takes each line with its date, reference number, account from a list, description, and a debit or credit amount. Each entry uses one reference for all of its lines, so you can trace a transaction from start to finish.

The Dashboard totals debits and credits, shows the difference between them, counts the journal lines and reports the cash balance. A breakdown lists every account with its total debit, total credit and net balance, and a bar chart sets them side by side. Sample entries cover a first month of trading, with capital, rent, sales, supplies and utilities.

Useful for

  • Posting each day's sales and payments to the right accounts
  • Tracing a figure back to the entry that created it
  • Checking the books before a trial balance

What's included

  • 3 tabs: Dashboard, Journal, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Journal: a table
  • 1 chart 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 Journal 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

Why must every entry balance?

Double-entry bookkeeping records each transaction in two places, so total debits always equal total credits. If they do not, a line is missing or has the wrong amount. The difference cell on the Dashboard shows this at a glance.

What is the difference between the journal and the ledger?

The journal lists transactions in the order they happened. The ledger groups them by account. This sheet holds the journal lines and summarizes each account on the Dashboard, which gives you the ledger view without a second tab.

Can I use an account that is not in the list?

Yes, but add it to the Account list first, using Data then Data validation, so every line can be picked from the same source. A typed name that does not match the list will not appear in the Dashboard breakdown.

  • #profit-and-loss
  • #general-ledger
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More profit and loss templates

See all 12

Also in Finance

All finance templates
Get this template

Preparing your template…