Contents x
    Balance Sheet
    • 18 Feb 2025
    • 3 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Balance Sheet

    • Updated on 18 Feb 2025
    • 3 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Article summary

    The Balance Sheet displays a company’s financial position by presenting account balances according to the Fiscal Calendar structure. Users can select from the report type options to compare balance sheet details for a specific time frame, location, legal entity, or period.

    Retained earnings are included based on net profit for the selected date to provide a clearer view of financial position.

    The report types provide a more detailed view of balances by displaying data by period, legal entity, location and other criteria. Available report types include:

    Navigation

    The Balance Sheet report is found on the Financial tab of My Reports.

    1. Navigate to My Reports.

    2. At the top of the My Reports screen, select the Financial tab.

    3. Locate the Balance Sheet report.

    4. Select Customize to adjust the report parameters before running the report.
      - or -
      Select Run to run the report with the default report parameters.

    Report Parameters


    Parameter

    Description

    1

    Report Type

    The organization of the Balance Sheet. Report types include:

    2

    Filter By

    Filter options for the report:

    3

    Filter

    A list of filter options, determined by the 'Filter By' category selected (#1).

    4

    As Of

    The date the balances are labeled as of.

    5

    Detail Level

    Detail - breaks down Parent accounts into their specified child accounts (ex. Inventory (P) --> Food (C), Produce (C), Dairy (C), ect.)

    Summary- includes all child Accounts in one parent account total amount.

    6

    Account View

    Name -alphabetically organizes GL accounts.

    Number Then Name - includes the GL account number and organizes by GL Account number.

    7

    Hide $0 Balances

    No - Displays all accounts - including GL accounts that have a balance of zero.

    Yes - Hides all GL accounts that have a balance of zero.
    Yes Show $0 Parents - Displays parent accounts with a balance of zero, but hides all other GL accounts that have a balance of zero.

    8

    Rounding

    No Rounding - Include decimal values.

    Whole Numbers - Rounds decimal values to the nearest whole number.

    9

    Show Unapproved

    No - Excludes unapproved transactions from the report results.

    Yes - Includes unapproved transactions in report results.

    10

    View Options

    This section provides options to select, save, edit, or delete a report view.

    11

    Run

    Generates the report. Click the down arrow to the right of the Run button to export, email, or print the report.

    Report Types

    Report columns vary depending on the Report Type that is selected in the report parameters.

    YTD (Year to Date)

    Column

    Description

    GL Type/GL Account

    A list of GL Types and GL accounts with the following GL Types:

    • Assets

    • Liabilities

    • Equity

    The GL accounts displayed are determined by the options selected for ‘Detail’ and ‘Hide $0 Balances’ in the report parameters.

    YTD

    The year to date balances of each Parent and Child Account

    Legal Entity Side by Side

    Column

    Description

    GL Type/GL Account

    A list of GL Types and GL accounts with the following GL Types:

    • Assets

    • Liabilities

    • Equity

    The GL accounts displayed are determined by the options selected for ‘Detail’ and ‘Hide $0 Balances’ in the report parameters.

    Legal Entity Columns

    The legal entities selected in the report parameters and the total balances for each GL Account.

    Location Side by Side

    Column

    Description

    GL Type/GL Account

    A list of GL Types and GL accounts with the following GL Types:

    • Assets

    • Liabilities

    • Equity

    The GL accounts displayed are determined by the options selected for ‘Detail’ and ‘Hide $0 Balances’ in the report parameters.

    Location Columns

    The locations selected in the report parameters and the total balances for each GL Account.

    YTD Periods Side by Side

    Column

    Description

    GL Type/GL Account

    A list of GL Types and GL accounts with the following GL Types:

    • Assets

    • Liabilities

    • Equity

    The GL accounts displayed are determined by the options selected for ‘Detail’ and ‘Hide $0 Balances’ in the report parameters.

    Period Columns

    The periods as of the selected date range in the report parameters and the total balances for each GL Account.

    Trailing 12 Period Side by Side

    Column

    Description

    GL Type/GL Account

    A list of GL Types and GL accounts with the following GL Types:

    • Assets

    • Liabilities

    • Equity

    The GL accounts displayed are determined by the options selected for ‘Detail’ and ‘Hide $0 Balances’ in the report parameters.

    Location Columns

    The twelve periods that follow the selected date range and their amounts side-by-side.

    Email, Export, or Print the Report

    This report can be emailed, exported, or printed in custom formatting directly from the reporting window.Learn more about how to send, export, or print this report.

    Was this article helpful?
    What's Next