Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceAccounting & BookkeepingBookkeepingJournal Entry Template

SpreadsheetBookkeepingFree

Journal Entry Template

Prepare, review and approve journal entries with account lookups, a balance check per entry and a preparer and approver trail.

Shown with sample data

Colour

Journal Entry Template

Prepare, review and approve journal entries with account lookups, a balance check per entry and a preparer and approver trail.

Total debits
$25,747
Total credits
$25,647
Out of balance
$100
Must be zero
Lines awaiting approval
4
Entries
6
Approved
4
Debits by entry
  • JE-1101$1,240
  • JE-1102$2,150
  • JE-1103$850
  • JE-1104$19,808
  • JE-1105$499
  • JE-1106$1,200

How to use it

  1. 1Set up your account codes and names on the Accounts sheet.
  2. 2Give each entry a number and enter one row per line: account code, description and the debit or credit amount.
  3. 3Choose the entry type (accrual, adjusting, reversing…) and note the supporting document.
  4. 4Check the Entry check column shows Balanced for every line, then send for approval.
  5. 5The approver adds their initials; Entry register shows what is posted, unbalanced or awaiting approval.

In this workbook

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

About this template

Manual journals are where most accounting errors and audit findings start. This workbook records each entry line by line with the account code, name looked up from your chart of accounts, entry type and description, checks that every entry’s debits equal its credits, and tracks who prepared and approved it, giving you a clean journal register and the support auditors ask for.

Who it’s for

  • Month-end adjusting entries
  • Segregation of duties between preparer and approver
  • Keeping a journal register for audit

What’s included

  • Journal lines sheet: Every journal line, grouped by entry number.
  • Entry register sheet: One row per entry with totals and approval status.
  • Accounts sheet: Your chart of accounts for code lookups.

How to use it

  1. 1Set up your account codes and names on the Accounts sheet.
  2. 2Give each entry a number and enter one row per line: account code, description and the debit or credit amount.
  3. 3Choose the entry type (accrual, adjusting, reversing…) and note the supporting document.
  4. 4Check the Entry check column shows Balanced for every line, then send for approval.
  5. 5The approver adds their initials; Entry register shows what is posted, unbalanced or awaiting approval.

Tips

  • Write descriptions a stranger could understand a year from now: what, why and the period it relates to.
  • The preparer should never approve their own entry. Keep the two names different.
  • Set accruals to reverse automatically on day one of the next period so they do not double count when the invoice arrives.

Questions

What should a journal entry include?

Date, entry number, accounts and amounts with debits equal to credits, a clear description, the supporting document, and who prepared and approved it.

What are the main types of journal entries?

Standard (routine), adjusting (accruals, prepayments, depreciation), reversing (cancelling an accrual next period), correcting (fixing an error) and closing (moving income and expenses to retained earnings).

Why must debits equal credits?

Every transaction affects at least two accounts with equal and opposite amounts. If an entry does not balance, the trial balance will not balance either.

Related searchesjournal entry templatejournal voucheradjusting journal entriesmanual journal entry formje template exceldebits equal credits

Details

Format
Spreadsheet
Category
Bookkeeping
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetBookkeepingFree

Journal Entry Template

Prepare, review and approve journal entries with account lookups, a balance check per entry and a preparer and approver trail.

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
3
Setup
10 min
Level
Intermediate
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