How To: Viewing & Printing the Balance Sheet (15-23)

Overview

This tutorial describes how to view and print G/L balance sheet(s).

Step-by-Step

Click image to enlarge.

  1. In the ‘Enter From Account Number’ and ‘Enter To Account Number’ fields, enter the range of accounts (first six digits of the G/L number) for which balance sheet(s) are being printed. Leave the ‘Enter From Account Number’ field blank to start with the first G/L number on file. Leave the ‘Enter To Account Number’ field blank to end with the last G/L number on file.

  1. From the ‘As of’ drop-down menu:
    1. Select ‘Current Month’ to view balance sheet(s) for the current G/L month.
    2. Select ‘Enter’ to specify a starting point for the balance sheet(s) in the ‘Month’ and ‘Year’ fields.

  1. At the ‘Consolidate Multiple Balance Sheets’ option:
    1. Check the box to view a consolidated balance sheet for the selected accounts. With a consolidated sheet, information for all selected accounts is combined on a single balance sheet.
    2. Leave the box unchecked to view separate balance sheet(s) for each account. Skip to Step 5 of this tutorial.

  1. When the ‘Consolidate Multiple Balance Sheets’ box is checked, the ‘Title and Format Codes from Group’ field appears. ‘Z0’ (Z00000) is the default Tyler grouping that is used for consolidated balance sheets. If your company uses a different group for this purpose, enter the first two digits of the group in this field.

    Please see the Setup Instructions for more information.

  1. From the ‘Detail or Summary Print’ drop-down menu:
    1. Select ‘Detail’ to include all balance sheet accounts.
    2. Select ‘Summary’ to only include accounts with a transaction code of 0, 1, 2, or 3. Accounts with a transaction code of 4 are not included.

  1. Check the ‘Print GL Account Numbers’ box to include the G/L Account Numbers on the balance sheet(s).

  1. Click ‘Done’ and the balance sheet(s) appear.

Click image to enlarge.
NOTE: You can double-click on a G/L Number to open the details for the account, for the selected month, in the G/L Inquiry (15-07) selection.

  1. Click ‘Print’ to print a paper copy of the balance sheet(s).

    At the ‘Do you want to include alternate row highlighting on the report’ prompt:

    1. Click ‘Yes’ and every other row will print on a darker background.
    2. Click ‘No’ and all lines will print on a white background (this option saves ink on a laser printer).

    At the ‘Select Printer’ prompt, enter the ID of a physical printer, or enter “PDF” to save the balance sheet(s) to a PDF file. If printing to a PDF, accept the pre-prompted save location on your computer, or enter a new one.

  1. Click ‘Export’ to open the balance sheet(s) directly in Excel (and also save them to your computer).
    IMPORTANT: In order for the balance sheet(s) to open directly in Excel (and be saved to your computer), the ‘General Ledger’ directory must be set up in Company/PDF Export (30-04) and/or By Term Company/PDF Export (30-05). If a ‘General Ledger’ directory is not specified in one of these selections, complete that process before exporting.
Tags: