A T-account template is a blank worksheet that shows an account in the shape of a capital “T”: debits go on the left and credits go on the right. It is useful for accounting homework, learning double-entry bookkeeping, analyzing journal entries, and checking how a transaction affects individual accounts.
Choose a printable PDF for handwritten practice, Excel for formulas and offline editing, or Google Sheets for browser-based collaboration. A T-account is an analysis and learning tool—not, by itself, a complete bookkeeping system.
Download or create a T-account template
| Format | Best for | Main benefit |
|---|---|---|
| Printable PDF | Homework, classroom exercises, and handwriting | Simple, distraction-free layout |
| Excel workbook | Calculations and customization | Automatic totals and offline editing |
| Google Sheets | Sharing and collaboration | Browser access and comments |
| Multi-account workbook | Journal-entry and posting practice | Shows one transaction across several accounts |
For downloadable examples, Jetpack Workflow lists Excel, Google Sheets, and PDF formats. Corporate Finance Institute provides a free Excel T-account resource, while Business Accounting Basics offers Excel and PDF versions.
“Free” can mean free to download rather than free to redistribute. For example, Business Accounting Basics states that its downloads are for personal or business use but may not be shared, distributed, or resold. Check each provider’s terms before republishing or modifying a downloaded file.
#1 Best Overall
Blank printable T-account template
Copy this layout into a document and print it, or use it as the design for your own spreadsheet:
| Account: ________________________________ | Period: __________________ | ||||
|---|---|---|---|---|---|
| Date | Description | Debit | Date | Description | Credit |
| ________ | ________________ | ________ | ________ | ________________ | ________ |
| ________ | ________________ | ________ | ________ | ________________ | ________ |
| ________ | ________________ | ________ | ________ | ________________ | ________ |
| ________ | ________________ | ________ | ________ | ________________ | ________ |
| Total debits | ________ | Total credits | ________ | ||
| Ending balance | ________ | ||||
The minimum useful fields are the account name, date, description, debit amount, and credit amount. Adding a journal-entry reference makes the worksheet more realistic and easier to audit later.
Spreadsheet version
For a single-account Excel or Google Sheets template, use these columns:
| Date | Description | Reference | Debit | Credit | Running balance |
|---|---|---|---|---|---|
| 2026-01-05 | Owner investment | JE-001 | 5,000 | 5,000 Dr |
Use separate debit and credit columns for a traditional T-account. You can add an account-type field, period field, opening balance, totals, and a balance-check cell. Protect formula cells so they are not accidentally overwritten.
Free tools Windows power users keep installed
One-click scans. No signup required.
For example, if debit amounts are in D2:D20 and credit amounts are in E2:E20:
Debit total: =SUM(D2:D20)
Credit total: =SUM(E2:E20)
Net amount: =D21-E21
Balance check: =IF(ROUND(SUM(D2:D20)-SUM(E2:E20),2)=0,"Balanced","Check entries")The balance-check formula tests arithmetic equality. It does not prove that the correct accounts were selected or that a transaction was recorded only once.
What is a T-account?
A T-account is a visual representation of one general-ledger account:
Rank #2
- 150 ruled sheets designed for structured accounting, recordkeeping, and data logs.
- Hardbound black cover offers durability and professional appearance.
- Ledger ruling supports clear entry alignment and consistent tracking.
- Premium paper reduces ink bleed for crisp, permanent records.
- Ideal for finance teams, education, business administration, and archival use.
Cash
---------------------
Debit | Credit
|The account name appears above the horizontal line. The vertical line separates the two sides:
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Clear out junk files and repair common Windows errors3Fix the driver behind crashes, sound loss and screen glitches- Left side: debit
- Right side: credit
Debit and credit do not inherently mean increase, decrease, money received, or money paid. Their effect depends on the account type.
Debit and credit rules
| Account type | Normal balance | Increases with | Decreases with |
|---|---|---|---|
| Assets | Debit | Debit | Credit |
| Expenses | Debit | Debit | Credit |
| Drawings or dividends | Debit | Debit | Credit |
| Liabilities | Credit | Credit | Debit |
| Owner’s or shareholders’ equity | Credit | Credit | Debit |
| Revenue or income | Credit | Credit | Debit |
The mnemonic DEALER can help: Dividends, Expenses, and Assets increase with Debits; Liabilities, Equity, and Revenue increase with credits. Use it as a memory aid, not as a replacement for analyzing the transaction and applying the accounting equation.
How to fill out a T-account
- Identify every affected account. A transaction normally affects at least two accounts.
- Classify each account as an asset, liability, equity, revenue, or expense.
- Determine whether each account increases or decreases.
- Apply the normal-balance rule to decide which side receives the entry.
- Enter the debit on the left and the credit on the right, with the date, description, and reference.
- Total the debit and credit columns separately.
- Check the complete transaction. Total debits must equal total credits.
Keep the underlying evidence—such as an invoice, receipt, bank statement, loan agreement, payroll record, or inventory record—separate from the T-account. The worksheet records the accounting effect; it does not replace the source document.
Worked T-account examples
1. Owner invests $5,000 cash
Cash Owner's Capital
--------------------- ---------------------
Debit | Credit Debit | Credit
$5,000 | | $5,000Cash is an asset, so its increase is a debit. Owner’s capital is equity, so its increase is a credit. Total debits and credits are both $5,000.
2. Buy equipment for $1,200 cash
Equipment Cash
--------------------- ---------------------
Debit | Credit Debit | Credit
$1,200 | | $1,200Equipment increases with a debit. Cash, another asset, decreases with a credit.
3. Pay $800 rent
Rent Expense Cash
--------------------- ---------------------
Debit | Credit Debit | Credit
$800 | | $800Rent expense increases with a debit, while cash decreases with a credit.
4. Make a $2,000 sale on account
Accounts Receivable Sales Revenue
--------------------- ---------------------
Debit | Credit Debit | Credit
$2,000 | | $2,000Accounts receivable increases because the customer owes the business money. Sales revenue increases with a credit. A “credit sale” does not mean the revenue account receives a debit.
5. Collect a $2,000 receivable
Cash Accounts Receivable
--------------------- -------------------------
Debit | Credit Debit | Credit
$2,000 | | $2,000Cash increases with a debit, while accounts receivable decreases with a credit. This collection does not create new revenue if the sale was already recorded.
Calculating the ending balance
For an account with a normal debit balance:
Ending balance = Total debits − Total credits
For an account with a normal credit balance:
Ending balance = Total credits − Total debits
A more explicit spreadsheet can show debit and credit totals separately and label the result as a debit or credit balance. If you use =SUM(DebitRange)-SUM(CreditRange), interpret the sign according to the account’s normal balance and include any opening balance.
For example, an asset account with an opening debit balance of $3,000, new debits of $5,000, and credits of $1,200 has an ending debit balance of $6,800:
$3,000 + $5,000 − $1,200 = $6,800 debit
A balanced difference alone cannot detect a duplicate transaction, an omitted transaction, or a transaction posted to the wrong accounts.
Using the template in Excel
- Open the
.xlsxworkbook in Excel. - Enter the account name, account type, period, dates, descriptions, references, and amounts in the designated input cells.
- Do not type over total, balance, or check cells containing formulas.
- Duplicate an account block when you need another account, then update its account name and opening balance.
- Review the debit total, credit total, ending balance, and balance-check result.
- Set print scaling to Fit Sheet on One Page or Fit All Columns on One Page, depending on the workbook layout.
For practice involving several accounts, create blocks for accounts such as Cash, Accounts Receivable, Equipment, Accounts Payable, Owner’s Capital, Sales Revenue, Rent Expense, and Wages Expense. The list is not universal; customize it to the exercise or business.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Using the template in Google Sheets
An Excel workbook can generally be opened in Google Sheets, but formatting, formulas, protection, named ranges, conditional formatting, and macros may not transfer identically.
Rank #4
- AN EASY & EFFICIENT WAY TO CONTROL YOUR FINANCES: Created for both small business and personal use, this horizontal accounting ledger book has spacious pages to log payments and deposits, so that you can monitor your finances and spot errors easily.
- LARGE FORMAT LEDGER WITH PLENTY OF WRITING SPACE: This accounting book ledger comes in a large format, measures 10 by 7 inches, and has 129 pages with 3,100 entry lines total.
- TRACK ACTIVITY IN MULTIPLE ACCOUNTS WITH JUST ONE BOOK: This accounting log book will be perfect if you want to track activity in multiple accounts. To do so, use the dedicated column to add the bank account number every time you make a record.
- PREMIUM DESIGN FOR COMFORTABLE DAILY USE: This accounting journal book has a durable eco-leather hardcover, thick 120gsm paper, sturdy elastic closure, pen loop, ribbon bookmark, and back pocket for extra notes, checks, and receipts.
- 60-DAY MONEY-BACK GUARANTEE: We will exchange or refund your small business log book if you aren’t satisfied with your business bookkeeping ledger for any reason. Reach out to us via message to refund your monthly accounting ledger book.
- Download the
.xlsxfile. - In Google Drive, select New → File upload.
- Upload the workbook.
- Open it with Google Sheets.
- Make a copy before editing the original.
- Check formulas, column widths, page layout, and print settings.
Use Google Sheets when several people need to edit or comment on the file. Use Excel when local editing, offline work, or Excel-specific features are more important.
Printing tips
- Use one account per page for classroom work and larger writing areas.
- Use several account blocks per page when analyzing one journal entry.
- Choose landscape orientation if the template has separate date, description, and amount columns on both sides.
- Set scaling to fit one page wide.
- Keep debit and credit labels prominent.
- Include account name, period, and optional prepared-by fields.
T-account vs. journal, general ledger, and trial balance
| Record | What it does |
|---|---|
| Source document | Provides evidence, such as an invoice, receipt, or bank statement. |
| Journal | Records transactions in chronological order as journal entries. |
| T-account | Groups debit and credit effects visually by account. |
| General ledger | Maintains the structured record of all accounts, transactions, references, and balances. |
| Trial balance | Lists account balances to test whether total debits equal total credits. |
The normal flow is:
Source document
↓
Journal entry
↓
T-accounts or general ledger
↓
Trial balance
↓
Financial statementsA T-account is therefore not automatically a journal, a complete general ledger, a trial balance, or a chart of accounts. General-ledger templates typically add account numbers, reporting periods, references, cumulative totals, and structured transaction records.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.When a T-account is not enough
A T-account worksheet can work for a short accounting exercise or a very small, low-volume operation doing limited manual tracking. It is not a complete substitute for:
Recommended Free Tools
- Source-document retention.
- Bank reconciliation.
- Accounts receivable and accounts payable tracking.
- Payroll records.
- Inventory accounting.
- Depreciation and other adjusting entries.
- Closing entries and financial statements.
- Tax reporting.
- Audit trails, backups, and user access controls.
Move to a general-ledger workbook when you need account numbers, references, recurring transaction records, running balances, a trial balance, or reporting-period organization. Broader resources such as small-business bookkeeping templates cover categories beyond a simple T-chart.
Consider accounting software when the business has regular sales or expenses, bank feeds, invoices, bills, payroll, inventory, multiple users, tax workflows, or a material risk of spreadsheet errors. A spreadsheet with reports or reconciliation features is still a spreadsheet, not necessarily a full accounting platform.
Common mistakes
Debit means money coming in
Not necessarily. A debit increases assets and expenses, but it decreases liabilities, equity, and revenue.
Credit means money going out
Not necessarily. A credit can increase revenue, liabilities, or equity, as well as decrease assets or expenses.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Best Value
- PERFECT LEDGER BOOK FOR SMALL BUSINESSES: This accounting ledger book for small businesses will help you organize finances, sort and summarize transactions, create balance summaries and set you up for financial success.
- SWITCH TO EFFICIENT & STRESS-FREE ACCOUNTING: This accounting book is undated and lasts a whole year and has 113 pages, including 53 weekly views, an annual summary, empty note pages, and, at the back, a spacious pocket for receipts.
- TAKE CONTROL OF YOUR FINANCES & SUCCEED: With this detailed record of all transactions and totals, you will be able to easily analyze your finances and quickly prepare accurate financial statements.
- COMPACT A5 FORMAT & DURABLE DESIGN: This bookkeeping record book comes in A5 format (5.8 by 8.3 inches) and has an eco-leather hardcover, 120gsm no-bleed paper, elastic, pen loop, bookmark, pocket for notes, and a user guide.
- 60-DAY MONEY-BACK GUARANTEE: We will exchange or refund your receipt book for small business if you aren’t satisfied with your expense tracker notebook for any reason. Reach out to us via message to refund your small business supplies.
Recording only one side
Identify every affected account. Every double-entry transaction must have equal total debits and credits.
Putting the transaction in one account
A cash equipment purchase affects both Equipment and Cash. A sale on account affects Accounts Receivable and Sales Revenue.
Confusing a credit-card payment with an accounting credit
In double-entry accounting, “credit” describes the right-hand side of an account. It does not necessarily refer to a payment method.
Assuming “balanced” means “correct”
A transaction can balance while using the wrong accounts, omitting details, or duplicating another entry. Review the transaction’s substance and supporting document.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Omitting dates and references
Even a classroom worksheet benefits from dates, descriptions, and journal references because these fields teach proper posting discipline.
Leaving the balance sign undefined
State whether the balance is debit-positive, credit-positive, or displayed with a debit/credit label. A bare positive or negative number can be misleading.
Which version should you choose?
- Choose PDF for homework, short exercises, exams, or handwriting.
- Choose Excel for automatic totals, local editing, and extensive customization.
- Choose Google Sheets for browser access, sharing, and collaboration.
- Choose a multi-account workbook for practicing journal entries and seeing transactions posted across accounts.
- Choose a general-ledger workbook when you need organized manual bookkeeping with references, balances, and reporting periods.
- Choose accounting software when recurring business operations require reconciliation, payroll, inventory, tax workflows, audit trails, backups, or controlled access.
For additional educational worksheets and worked keys, Newberry Accounting’s downloads page is another reference point. Use any downloaded file according to its stated terms and inspect its formulas before relying on it for business records.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
