Partner Logo
Home  > Trial Balance Worksheet
 Share  Print Version  Email

Trial Balance Worksheet


The trial balance is a report listing the ending debit and credit balances in all accounts at the end of a reporting period. The trial balance has three uses:

  • Debits equal credits. The total of all debits should equal the total of all credits, resulting a report balance of zero.
  • Worksheet. Depending on the report format, the trial balance can be used as a worksheet for planning adjusting entries.
  • Source of financial statements. The information on the report can be aggregated to create the financial statements, though accounting software handles this task automatically.
  • This is intended to be a simple and practical tool to be adjusted and used by SMEs working in all sectors. You may adapt it to reflect your business needs, type of clientele, products and services you offer.

     

    The trial balance spreadsheet contained in the attached file is designed to save you time and money in preparing the trial balance yourself. 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.

    File Description: The file contains a Microsoft Excel spreadsheet template. Once you've downloaded the file, you must copy it to your EXCEL\XLSTART directory in order to use it.

    Special Features:

    • Download this spreadsheet template just once, and be able to use it over and over again.
    • Customize the spreadsheet to suit your needs, adding or deleting accounts.
    • The spreadsheet is easy to use. Just plug in your numbers 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).

     

    Attachments:
    Trial Balance Worksheet Template
     Share  Print Version  Email
    Comments &Ratings (0)
    If you are a human, do not fill in this field.
    Click stars to rate.
       Comments are truncated at 1000 characters