Softwiro
Free Excel template

General Journal and Trial Balance Template for Excel

A free Excel workbook for double-entry bookkeeping. You record each transaction once in the general journal, with a date, an entry number, an account, a debit or credit and a memo. The workbook posts every line to a general ledger by account, builds an unadjusted trial balance, adds your adjusting entries, and draws the income statement and balance sheet from the adjusted figures. If any entry does not balance, it turns red and a warning appears on the Dashboard until you fix it. It opens in Excel, LibreOffice and Google Sheets and works in any currency.

Excel file (.xlsx) · 201 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
Harbor Lane Cycle ShopTwo months ended 2026-11-30 · amounts in $
BOOKS IN BALANCE: every entry balances and the trial balance agrees.
Total assets65,378.00Journal lines63
Total liabilities33,100.00Unbalanced journal entries0
Total equity incl. net profit32,278.00Unadjusted trial balance difference0.00
Net profit (adjusted)6,078.00Adjusted trial balance difference0.00
Journal lines with a problem0
Revenue and expensesUnadjustedAdjustedIncome statement (adjusted)Amount
Revenue37,735.0037,735.00Net sales37,700.00
Expenses29,457.0031,657.00Cost of sales14,350.00
Net profit8,278.006,078.00Operating expenses17,105.00
Other expenses202.00
Net profit6,078.00
Financial position (adjusted)Amount
Assets65,378.00
Liabilities33,100.00
Equity32,278.00

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

What is inside

  • Dashboard: A banner that reads BOOKS IN BALANCE or OUT OF BALANCE, total assets, liabilities, equity and adjusted net profit, the number of unbalanced entries, both trial balance differences, and three charts: where the sales went, assets against liabilities and equity, and revenue, expenses and profit before and after adjusting entries.
  • Journal: The general journal: date, entry number, account code, debit, credit, memo and a Regular or Adjusting type. The account name fills in by itself, each line is checked, and each entry shows its own difference. Room for 1,000 lines.
  • Chart of accounts: Your accounts with a code, a name and a group, plus opening debit and credit balances. The type and the normal balance are worked out from the group, and a check column catches duplicate codes and missing groups. Room for 100 accounts.
  • Ledger: Pick any account code to see every journal line posted to it, with a running balance and a Dr or Cr side, plus the opening balance, total debits, total credits and closing balance.
  • Trial Balance: Every account in unadjusted debit and credit columns, the adjustments, and the adjusted debit and credit columns, with totals and an In balance or OUT OF BALANCE flag for both the unadjusted and the adjusted trial balance.
  • Income Statement: Net sales, cost of sales, gross profit, operating expenses, operating profit, other income and expenses, and net profit, shown before and after adjustments, with each line as a percentage of net sales.
  • Balance Sheet: Current and non-current assets, current and long-term liabilities, equity and the period's net profit, before and after adjustments, with a check that assets equal liabilities plus equity.
  • Settings: Business name, currency symbol, the reporting period label, and the list of account groups that decides where each account appears on the statements.

The file opens on a start tab (“Start here”) that explains how to use it.

What makes it different

Most free trial balance templates are a single sheet where you type the balances yourself. This one starts from the journal, so the trial balance is a result, not an input. It keeps adjusting entries apart from everyday ones, so you can see the trial balance before and after them, and it carries the same figures through to the two statements. The sample is a small cycle shop with entries in October and November 2026, so every sheet is already working when you open it.

How do I make a trial balance in Excel from a general journal?

Start with a chart of accounts and, if the books already have history, the opening balance of each account. Then record every transaction in the journal as at least two lines: one account debited and another credited for the same total. For each account, the trial balance takes the opening balance, adds the debits, subtracts the credits, and places the result in the debit or the credit column.

In the sample, the journal holds 31 entries on 63 lines, with total debits of 97,592.00 and the same total credits. The unadjusted trial balance agrees, and Cash at bank stands at 26,778.00 debit. The adjusted trial balance agrees too.

What are adjusting entries and how do they change the trial balance?

Adjusting entries bring the books up to date at the end of a period for things that have happened but have not been recorded by an ordinary transaction, such as insurance used up, depreciation, or wages earned but not yet paid. In this workbook you enter them in the Journal like any other entry and set the Type to Adjusting.

The sample has three: 400.00 of insurance used, 600.00 of depreciation and 1,200.00 of accrued wages. They move net profit from 8,278.00 before adjustments to 6,078.00 after them, and total assets from 66,378.00 to 65,378.00. Both the unadjusted and the adjusted columns are on the Trial Balance sheet, so you can see the effect of each.

What should I do when the trial balance does not balance?

A trial balance can only be out by an amount that a mistake explains. Start with the Journal: any entry whose debits and credits differ is shaded red and shows its difference, and the line check flags a missing or unknown account code, a line with both a debit and a credit, and a line with no amount. Then check the opening balances on Chart of accounts, which must also agree.

Be aware that a balanced trial balance does not prove the books are right. A transaction posted to the wrong account, or recorded twice, still balances. Use the Ledger sheet to look through one account at a time. For a spending view see the business expenses budget, and for cash timing the cash book template and the cash flow forecast.

How to use it

  1. On Settings type your business name, the currency symbol and a label for the reporting period. The account groups listed there decide where each account lands on the statements.
  2. On Chart of accounts list every account with a code, a name and a group, and type any opening balance under Debit or Credit. The opening balances must total the same on both sides.
  3. On Journal enter each transaction line by line: date, entry number, account code, debit or credit, a memo. Use the same entry number on every line of one entry, and mark year-end corrections as Adjusting in the last column.
  4. Watch the Line check and Entry check columns. Any entry whose debits and credits differ turns red, and the Dashboard shows an out-of-balance alert until it is fixed.
  5. On Ledger pick an account code to see every movement of that account with a running balance.
  6. On Trial Balance check that the unadjusted columns agree, read the adjustments and the adjusted balances, then open Income Statement and Balance Sheet.

Before you start:

  • Capacity: 100 accounts, 1,000 journal lines, and the Ledger lists the first 150 lines of the chosen account.
  • Debit and credit are typed in separate columns. Put an amount in one of them on each line, never in both.
  • Adjusting entries are ordinary journal entries marked Adjusting. The unadjusted trial balance leaves them out, the adjusted one includes them.
  • To test the alert, change the credit of entry 1 on Journal to another amount. Entry 1 turns red, both trial balances show a difference and the Dashboard warns you. Change it back afterwards.
  • Accounts with a normal credit balance (liabilities, equity, revenue) and contra accounts such as accumulated depreciation are handled by the group they belong to. A debit-balance equity account such as owner drawings reduces equity.
  • Net profit on the Balance Sheet comes from the Income Statement and is added to equity, so the balance sheet balances only when the whole journal is balanced.
  • This is a bookkeeping aid, not accounting or tax advice. Check your local rules and ask a qualified accountant before you rely on it for filings.

Excel file (.xlsx) · 201 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Still running this on Excel?

This sheet depends on someone entering journal entries accurately and reviewing them. In ProfAcc, double-entry postings are made automatically, periods are closed, and the financial statements are produced directly from the entries.

In this sheetIn ProfAcc — Manufacturing Accounts
Changing any cell can alter the numbers of a period that has ended.Correct double-entry from day one, with automatic posting and period closing that locks what has been closed.
Tax is calculated in one place and invoices live in another.Every sales invoice calculates VAT within the journal entry that records it.
You only learn the stock balance after the month-end count.Stock balances are live and move with every posting.
One file per company you serve, and the files can get mixed up.Each company is created from a Google account in about a minute with nothing to install, its data is kept separate, and it is reached through its own link.

See ProfAcc — Manufacturing Accounts · Ask for a demo

Frequently asked questions

Is this general journal and trial balance template free?

Yes. Download it, use it for your business, your studies or a client, and change anything you like.

Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets.

Can I use it to learn double-entry bookkeeping?

Yes. The sample entries cover sales, purchases, payments, a return, an owner withdrawal and three adjusting entries, and you can break an entry on purpose to see the out-of-balance alert. Change the credit of entry 1 and the Dashboard warns you.

How many accounts and entries can it hold?

100 accounts and 1,000 journal lines. The Ledger lists the first 150 lines of the account you pick. For more, save a copy and start the next period with the closing balances as the opening balances.

Does it handle tax or legal reporting?

No. It is a bookkeeping aid that produces a trial balance and basic statements. Reporting and tax rules differ by place, so check your local rules and ask a qualified accountant before you file anything.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Accounting

More free templates

All templates · Free tools