General Ledger preview
General Ledger sheet with journal entry columns for date, account code, description, debit, credit, and running balance tracking. 1/4

About this General Ledger spreadsheet template

This General Ledger template provides a complete accounting workbook with four structured sheets: a main General Ledger for posting journal entries per account, an Exception Queue for tracking unbalanced and unreconciled lines, an Executive Dashboard for profit and budget KPIs, and a Setup & Guide sheet for configuring currency, date style, and materiality thresholds.

Designed for finance teams and small business owners, the template uses pale-blue input cells to guide data entry and automatic calculations for debit/credit balancing, variance detection, and running balances. Every sheet is fully editable in WPS Office, Microsoft Excel, and Google Sheets.

4 integrated sheets

General Ledger, Exception Queue, Dashboard, and Setup & Guide work together for end-to-end accounting.

Automated balancing

Debit and credit columns auto-calculate variances and flag unbalanced journal entries.

Executive dashboard

Revenue, cost of sales, operating expense, and net profit KPIs with budget vs. actual comparisons.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

Frequently asked questions
The General Ledger template is designed for posting journal entries, tracking account balances, reconciling exceptions, and monitoring financial KPIs. Customize the sample data, layout, and other editable elements in WPS Office for your own accounting workflow.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the text and structure in a Notion database; for branded financial reports, adapt the content in Adobe Express.
Download the template, open it in WPS Office, and replace the placeholder journal entries, account codes, currency settings, and other editable elements with your own financial data.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for monthly bookkeeping, period-end reconciliation, budget tracking, and management reporting. It is available for personal and commercial projects, subject to the applicable template license.