CheckMark Knowledge Base CheckMark Knowledge Base

  • PRODUCTS
    • SOFTWARE
      • CheckMark Payroll
      • CheckMark MultiLedger
      • CheckMark 1099
      • CheckMark 1095
    • PAPER PRODUCTS
      • Checks & Envelopes
      • Business Forms
      • Tax Forms
  • SERVICES
    • HR Services
    • Time & Attendance
  • STORE
    • Online Store Home
    • Software
    • Software Updates
    • Bundles
    • Checks & Envelopes
    • Business-Forms
    • Tax Forms
    • HR Support
  • MORE
    • ABOUT COMPANY
      • Our Story
      • Culture
      • Contact Us
    • PARTNER PROGRAMS
      • Consultant Program
      • Software Partner
      • Resellers Program
    • SUPPORT
      • Request Support
      • Knowledgebase
      • Blog
      • Tutorials
      • Find a Consultant
  • Sign In
    • My Account
    • Other
      • HR Services
      • Time & Attendance
  • Free Trial
Home / CheckMark MultiLedger, Financial and Other Reports / How to Create Trial Balance Report

How to Create Trial Balance Report

creating trial balance report

Trial Balance Report

A trial balance report shows ledger accounts, their beginning balances (optional), their monthly activity and their year-to-date balances, and whether or not your debits equal your credits. Debits should equal credits for your books to balance.

You can use a trial balance report to quickly look at your account balances for a particular period.

  1. Click Trial Balance in the Command Center.

222

  1. Select a period for the report.

Only one period can be selected at a time. The default period selected corresponds to the last month in which transactions were entered.

  1. If necessary, check the option Show Zero Balances.

Image 223

If Show Zero Balances is checked, the report will show balances for all accounts in your chart of accounts, including those with zero activity and zero year-to-date balances.

  1. If desired, check the option Show Beginning Balances.

If checked, the report will show the beginning balances for the period selected along with monthly activity and YTD balances.

  1. Click View, Print, or Text File.

Drill Down on Trial Balance Report

The Trial Balance report has a drill-down function that allows you to quickly see the general ledger listing for any amount in the Monthly  Activity column on a Trial Balance report. To utilize the drill-down capabilities, do the following:

  1. While viewing a Trial Balance report, move the pointer over the Monthly Activity column.

The pointer tool changes to a magnifying glass tool.

  1. With the magnifying glass tool, click on the amount in the Monthly Activity column that you want to see in drill-down mode.

A General Ledger listing for that specific month and account appears. From this General Ledger listing you can go directly to an original transaction. For more details, see “Drill Down on General Ledger Report”

  1. To return to the Trial Balance report, click the General Ledger report’s close box.

Prior Year Income

If you have 2016, 2017, & 2018 open in your files, 2016 is considered your current year. You need to keep 2017 open in order to get Prior Year comparison reports for 2016 vs 2017.

Because you haven’t closed 2016, your income and expenses for 2016 haven’t rolled into retained earnings yet in the General Ledger or Trial Balance. So when you look at your trial balance for 2017, it shows the retained earnings from 2016 as a separate line at the bottom under the totals in “Prior Income”.

As long as the Ledger Debit line equals the total of the Ledger Credit+/- the Prior Income, then you are in balance.

If you look at the Balance Sheet, it reflects the amount going into Retained Earnings.

Trial Balance report example:

224


Related Articles

How to Create Chart of Accounts Report

How to Create Transaction Journals Reports

How to Create General Ledger Report

How to Create Balance Sheet Report

How to Create Income Statement Report

How to Create Cash Flow Reports

How to Create Financial Snapshot Reports

How to Create Sales Tax Reports

How to Create Salesperson Reports

How to Create Job Reports

Related

CheckMark MultiLedgerFinancial and Other Reports

Search the Knowledge Base

Browse by Topics

  • Getting Started
  • Initial Setup
  • Backing Up & Restoring
  • Multi-User
  • Setup Option
  • Customer, Vendor and Item Setup
  • Introduction to Transactions
  • Customer Transactions
  • Vendor Transactions
  • Other Activities
  • Integration with CheckMark Payroll
  • Customer, Vendor & Item Reports
  • Financial and Other Reports
  • Sample Chart of Accounts
  • AppleScript and Importing
  • Error Messages
  • Miscellaneous
accounting software

SOFTWARE

  • CheckMark Payroll
  • CheckMark MultiLedger
  • CheckMark 1099
  • CheckMark 1095

SERVICES

  • HR Services
  • Time & Attendance

PAPER PRODUCTS

  • Checks and Envelopes
  • Business Forms
  • Tax Forms

RESOURCES

  • Knowledge Base
  • Blog

ABOUT US

  • Our Story
  • Consultant Program
  • Software Partner
  • Resellers Program
  • Contact Us

CONTACT INFORMATION

  • 323 W Drake Rd, Ste. 100, Fort Collins, CO 80526
  • Tel: 970.225.0522
  • Fax: 970.225.0611
  • sales@checkmark.com

| | |

Terms of Service | Privacy Policy | Sitemap

Copyright © 2022 CheckMark, Inc.