Home  > Trial Balance Worksheet
 Share  Print Version  Email

Other Translations

Trial Balance Worksheet

Provided by the International Finance Corporation


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

    Copyright © 2000 - 2017, International Finance Corporation. All Rights Reserved.

    © International Finance Corporation [Year of First Publication].  All rights reserved.
    2121 Pennsylvania Avenue, N.W.
    Washington, D.C. 20433
    Internet:  www.ifc.org
     
    The material in this work is copyrighted. Copying and/or transmitting portions or all of this work without permission may be a violation of applicable law.  IFC does not guarantee the accuracy, reliability or completeness of the content included in this work, or for the conclusions or judgments described herein, and accepts no responsibility or  liability for any omissions or errors (including, without limitation, typographical errors and technical errors) in the content whatsoever or for reliance thereon

    2121 Pennsylvania Avenue, N.W., Washington, D.C. 20433, www.ifc.org

    The material in this work is copyrighted. Copying and/or transmitting portions or all of this work without permission may be a violation of applicable law.  IFC does not guarantee the accuracy, reliability or completeness of the content included in this work, or for the conclusions or judgments described herein, and accepts no responsibility or  liability for any omissions or errors (including, without limitation, typographical errors and technical errors) in the content whatsoever or for reliance thereon.

     Share  Print Version  Email
    Ratings (0)
    If you are a human, do not fill in this field.
    Click stars to rate.
      

    Discussion