Skip to content
The title slide and first slides of the Journal Entry Log template

Journal Entry Log

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

A journal is where every transaction first lands, one entry at a time. In this log each entry can have two or more lines that share an entry number. The Entry check column adds the debits and credits for that number and turns the row red when they differ by even a cent. The sample holds eight October entries for a small print shop: rent, an invoice, a restock, a customer payment, payroll, a used machine bought partly on credit, a utility bill and cost of goods sold.

Ledger Totals sums the debits and the credits of 13 accounts and charts them, which makes it a ready source for a trial balance. Account names come from a dropdown, so spelling stays consistent and the totals pick up every line. If your accounts differ, edit the dropdown and the totals table together.

Useful for

  • Keep a simple double-entry journal without accounting software
  • Review a client's entries for unbalanced lines
  • Feed account totals into a trial balance each month

What's included

  • 3 tabs: Entries, Ledger Totals, How to use
  • Entries: a table
  • Ledger Totals: a dashboard with 4 summary figures
  • 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 Entries 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 a journal entry?

It is a record of one transaction that touches at least two accounts, with debits and credits that add up to the same amount.

How do I record a split transaction?

Use one row for each account and give all of them the same entry number. The check adds the lines together, so a three-line entry balances as a whole.

Can I add accounts to the dropdown?

Yes. Edit the list in the Account column's data validation and give the new account a row in the Ledger Totals table so its lines are counted.

  • #bookkeeping
  • #journal-entry-log
  • #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…