Trial Balance Worksheet

Whatever kind of business you run, you have to close your books at least once a year to prepare an income tax return — or more frequently, if you want to get a better handle on how your business is doing.

An important part of closing your books is preparing a trial balance — in other words, a list of all of your bookkeeping accounts and the balance of each at the end of the period — to see if your books are still in balance. If you are already doing this, you know that it is tedious and time-consuming; if your accountant is doing it, you know that it is an added expense.

The Trial Balance Worksheet contained in the attached file is designed to save you time and money in preparing the trial balance yourself. The spreadsheet contains over 80 common account titles in a trial balance format. Simply plug in your balance for each account and the spreadsheet will automatically add up the debits and credits, and tell you if your books are out of balance (and by how much).

Since it is a spreadsheet template, you can add or delete accounts or otherwise modify it to suit your needs and preferences.

The file contains a Microsoft Excel (version 4.0 and above) spreadsheet template. 

Special Features:


©2024 CCH Incorporated and/or its affiliates. All rights reserved.