Finance & AdministrationAvailable for Download

General Ledger

Keep the ledger for every account in one workbook, with opening balances, running balances, and a check that the books balance. Excel workbook.

Who Should Use It:Small business owners, managers, and administrators.
Primary Task:Keep the ledger for every account in one workbook, with opening balances, running balances, and a check that the books balance. Excel workbook.
File FormatsMicrosoft Excel (.xlsx)
CompatibilityMicrosoft Excel, LibreOffice Calc, Google Sheets
License100% Free for Team Use
AccessDirect Download (No Sign-Up)
Free download

Download this template

Choose the file you need, then download it. No sign-up, no payment.

Excel (.xlsx)15 KBFree

Editable Excel workbook with formulas and print setup.

Free for team useNo sign-upEditable file
Document Preview

This is the actual first page of the file. Click the preview to see it larger, then download it below. The Sample card shows a completed example, filled in with sample details.

What’s Included in This Resource

Every resource on The Office File provides a complete toolkit rather than an empty, unhelpful document shell:

  • Editable Microsoft Excel (.xlsx) workbook with built-in formulas

Sample included: Example: General Ledger in use. Keep the ledger for every account in one workbook, with opening balances, running balances, and a check that the books balance. Excel workbook.

How to Use This Template

Follow these practical steps to customize and roll out this procedure with your team:

1

1. Download the file

Get the editable Excel workbook.

2

2. Replace the example figures

Overwrite the white cells with your own figures. Grey cells are formulas, so do not type over them.

3

3. Adjust to fit

Add or remove rows to match your needs, and copy the formulas down.

4

4. Save and share

Save the workbook, print it, or share it with your bookkeeper or accountant.