Free T Account Template (Excel, Google Sheets & PDF)

A T account is a simple visual accounting tool used to show how transactions affect individual ledger accounts. Debits appear on the left, while credits appear on the right, making it easier to understand account activity and double-entry bookkeeping.

Download our free T account template in Excel, Google Sheets, or printable PDF format. The editable T account worksheet can be used by accounting students, small business owners, bookkeepers, and accounting professionals to record transactions, calculate account balances, and identify posting errors.

This guide explains how T accounts work, how to complete the template, and how transactions move between journal entries and the general ledger.

Download the Free T Account Template

To make accounting easier, we’ve included a downloadable T account worksheet in multiple formats. 

Choose the one that works best for your workflow:

• Excel
• Google Sheets
• PDF

What Is a T Account?

A T account is a visual representation of an individual account in the general ledger. Its shape resembles the letter T, with the account name at the top, debits recorded on the left, and credits recorded on the right.

Each financial transaction affects at least two accounts. One account receives a debit and another receives a credit for the same amount. This is the foundation of double-entry bookkeeping.

For example, when a business pays $1,500 in rent:

• Rent Expense is debited by $1,500.
• Cash is credited by $1,500.

Total debits and credits for the complete transaction remain equal, even though the individual T accounts may have different balances.

Why Use a T Account Template?

Before diving into the steps, let’s quickly revisit why T accounts remain so important in accounting practice:

• Visual clarity: Debits and credits are easy to distinguish in a T chart format.
• Error detection: Helps quickly spot mismatches when debits don’t equal credits.
• Educational tool: Provides a simple framework for learning double-entry bookkeeping.
• Adaptability: Can be used for assets, liabilities, equity, revenue, and expense accounts.
  

By using a t account template, you can focus less on formatting and more on recording accurate data.

Debit and Credit Rules for T Accounts

How to Make T Accounts

Creating T accounts from scratch isn’t complicated, but using a template makes the process much faster. Below are key steps to follow, with practical tips for using our worksheet.

Step 1: Gather Your Financial Documents

Start by collecting source documents like invoices, receipts, and bank statements. These provide the raw data for journal entries. Without this foundation, even the most polished T chart accounting template won’t reflect reality.

Step 2: Record the Journal Entry

Each financial transaction must be entered into the general journal first. For example, if your company purchases supplies on credit, you’ll record:

• Debit: Supplies (Asset account)
• Credit: Accounts Payable (Liability account)
  

Step 3: Transfer Entries into T Accounts

Using the template, post each debit and credit into the corresponding T account. This step ensures balances are categorized under the right accounts.

Step 4: Calculate Each Account Balance

Add the debit entries and credit entries in each T account, then calculate the difference between the two sides. An individual account does not need equal debit and credit totals. Instead, its ending balance appears on the side with the greater total.

Step 5: Review and Adjust

Periodically review accounts for accuracy. Our T accounts in Excel template makes it simple to adjust balances or trace errors across different accounts.

Features of Our Excel T Account Template

Our downloadable worksheet is more than just a blank T chart. It’s designed with practical features:

• Multiple account categories (assets, liabilities, equity, revenue, expenses).
• Editable cells for flexible entry and customization.
• Built-in formatting so you don’t waste time drawing T charts manually.
• Compatibility with Google Sheets for easy cloud use.

Completed T Account Example

Assume a business earns $5,000 in cash from providing services and later pays $1,500 in office rent.

Transaction 1: Record Service Revenue

• Debit Cash: $5,000
• Credit Service Revenue: $5,000

Transaction 2: Record the Rent Payment

• Debit Rent Expense: $1,500
• Credit Cash: $1,500

After posting both transactions:

• Cash has a $3,500 debit balance.
• Service Revenue has a $5,000 credit balance.
• Rent Expense has a $1,500 debit balance.
• Total debits and credits across the two transactions both equal $6,500.

Tips for Using Jetpack Workflow’s T Account Worksheet

Here are some best practices to maximize the template:

1. Label clearly. Always include account names at the top of each T chart.
2. Be consistent. Stick to standard debit/credit placements to avoid confusion.
3. Reconcile regularly. Compare T accounts with bank statements or ledgers.
4. Use for teaching. Students can experiment by entering practice transactions.
5. Print as PDF. For compliance or record-keeping, export the completed template into PDF.

Whether you’re a beginner figuring out how to make T account tables or an advanced bookkeeper, these steps keep your records clean.

T Accounts vs. General Ledger vs. Journal Entries

T accounts help users visualize the movement between journal entries and the general ledger. For a complete transaction-tracking spreadsheet, use Jetpack Workflow’s free general ledger template.

Common T Account Mistakes to Avoid

• Recording debits and credits on the wrong sides
• Posting only one side of a transaction
• Using the wrong account classification
• Assuming each individual T account must balance to zero
• Forgetting to include the opening balance
• Failing to calculate the ending account balance
• Posting amounts that do not match the original journal entry
• Using T accounts as a substitute for complete accounting records

Need Help Managing New Client Projects?

A workflow management system is a great way to keep your bookkeeping firm organized and running efficiently. By automating tasks and keeping track of deadlines, you can be sure that nothing falls through the cracks and your clients are always getting the best possible service. 

In addition, a workflow management system can help you to allocate resources more effectively, ensuring your staff is always working on the most important tasks. Ultimately, a workflow management system can save you time and money, making it an essential tool for any bookkeeping firm.

Jetpack Workflow was designed from the ground up with bookkeepers and accountants in mind. The cloud-based workflow management system allows you to start with predefined templates, customize them for your firm, and track progress on all your work.

Jetpack Workflow offers a free 14-day trial which will give you the opportunity to see how much time you could be saving with a full workflow management system.

Final Thoughts

The T account template is one of the simplest yet most effective accounting tools you can use. By downloading our free worksheet in Excel, Google Sheets, or PDF, you’ll save time, reduce errors, and create a clear record of financial transactions.

Whether you’re managing your own small business finances or learning double-entry bookkeeping, our Excel T account template provides a reliable framework for organizing accounts. 

Try it out today and explore additional templates from Jetpack Workflow to make your accounting process even more efficient.