Skip to main content
Enhanced Reporting Overview
G
Written by Geoff Ostrega
Updated over 2 months ago

Description

SoftLedger provides out of the box reporting, from full in depth Financial Statements through to investigative reports such as viewing Ledger Account balances across Dimensions. Each report originates from one reporting page, where you select the Report Type and then specific Report for that type. Each Report Type will have a Default report to begin with that can be used as the foundation for customizations of each Report Type to be saved for later use. When relevant, reports can be viewed at the consolidated and unconsolidated level, as well as for any Location level from your entity structure, and for any date period(s).

Common Features

The following sections describe features and functionalities that are consistent across most, if not all, enhanced reports in SoftLedger. While there may be slight variations or additional options in specific reports, these core elements form the foundation of the enhanced reporting experience.

Customizing Reports

For each Report Type, you can start from the Report titled "Default". The process to create and run reports would be:

  1. Select the Report Type you want to run, and select the "Default" report

  2. Make Configuration adjustments such as:

    1. Toggle On or Off Consolidation

    2. Adjust the Location in the Location Picker or Override Location selection

    3. Adjust the date in the System Date Picker or the Override Date selection

    4. Input different Start and End Dates

    5. Make selections for Journal Status, displaying zero balances

    6. Adjust dimensions and ledger account groups (e.g. report groups, ledger account subtypes, etc.)

  3. When relevant, make adjustments to columns in view, column orders, filters across one or many data fields, etc.

  4. Adjust the number of rows in view

  5. Save report as a new title

  6. Export

To customize the layout of any Balance Sheet, Income Statement, or Cash Flow, review this article for more details-->

Column Header Actions

Sorting

Users can sort data by clicking on column headers. Columns can be sorted in ascending or descending order, by clicking on Sort by ASC or Sort by DESC respectively.

Pin a Column

Users can pin a column by clicking on Pin to Left or Pin to Right. This will pin the column to the left or right side of the report.

Filter

In addition to opening the filter menu from the "FILTERS" at the top of the report,, users can also filter data by clicking on the column header and selecting the filter icon. This will open the filter menu directly with the selected column preselected as the filter.

Hide a Column

Users can hide a column by clicking on the column header and selecting Hide Column. This will hide the column from the report.

Manage Columns

In addition to selecting "COLUMNS" at the top of the report, users can also manage columns by clicking on the column header and selecting Manage Columns. This will open a dialog where users can manage which columns are shown in the report.

Saving Report Configurations

Users can save report configurations, including filters, columns, column order, and location. To save a configuration:

  1. Apply desired filters and customized columns.

  2. Click the "Save As" button (For reports that are saved and updated, just click the "Save" button).

  3. Name the report for easy reference

Saved reports are viewable for all users within the SoftLedger tenant.

Deleting Reports

Custom reports can be deleted by clicking the "Delete" button in the report configuration.

Default reports can not be deleted.

Report Types

Balance Sheet

The Balance Sheet report captures the Asset, Equity, and Liabilities type ledger account balances. The report can be viewed in Standard, Entity, or Comparative format, while allowing for either Consolidated or Unconsolidated balances at all levels of the entity structure. The Balance Sheet layout can be custom formatted to meet any reporting requirements. Learn more about the Balance Sheet report here -->

Income Statement

The Income Statement report captures the Revenue and Expense type ledger account balances. The report can be viewed in Standard, Entity, or Comparative format, while allowing for either Consolidated or Unconsolidated balances at all levels of the entity structure. The Income Statement layout can be custom formatted to meet any reporting requirements. Learn more about the Income Statement report here -->

Journal Lines

The Journal Lines report brings together the line by line transaction information pulling from all ledgers (e.g. Financial, AP bills, AR invoices, etc.) in one place. This is the most comprehensive report and a great table to use to set up subsets of data for review/export/share. Learn more about the Journal Lines report here -->

General Ledger

The General Ledger report displays the starting, ending, and activity balances for each Ledger Account in each Location The General Ledger report is great for better understanding and confirming the activity during a set period of time, and is often times used by auditors. Learn more about the General Ledger report here -->

Trial Balance

The Trial Balance report displays the debit, credit, and final balances per Ledger Account per Location. The Trial Balance report can be viewed at the Consolidated or Unconsolidated level at any position in the entity structure. Learn more about the Trial Balance report here -->

Trial Balance by Posted Currency

The Trial Balance by Posted Currency report has the same functionality as the Trial Balance report, but it breaks down balances further to be displayed by Ledger Account, by Location, and by Posted Currency of the transaction. Learn more about the Trial Balance by Posted Currency report here -->

Ledger Account by Dimension

The Ledger Account by Dimension report can be set up to see any Ledger Account balance against a Dimension such as Customer/Vendor, Cost Center, Products, Jobs, or Custom Dimensions. The display of the report can be customized to group Ledger Accounts by Report Group, Type, or SubType, as well as filter the data returned in the Journal Lines that populate the report. Learn more about the Ledger Account by Dimension report here -->

Ledger Account Review Report

The Ledger Account Review report displays data in the same format as the Journal Lines report, but requires the input of a single Ledger Account to be analyzed. The report will return all Journal Lines that are associated with the selected Ledger Account, meaning all debit and credit sides of Journal Entries that the Ledger Account has been used within can be viewed in the report. Learn more about the Ledger Account Review report here -->

Cash Flow Report

A Cash Flow Report is an essential financial document that provides a detailed overview of the cash inflows and outflows within a business over a specific period. This report is crucial for understanding how a company generates and utilizes its cash, offering insights into its operating, investing, and financing activities. Select the Cash Flow report type in the Reports section and adjust report configurations and layouts to produce cash flow reports. Cash Flow Report here -->

Budget vs Actual Report

Review standalone, consolidated, and department budgets against actuals data for analysis and comparison to originally budgeted values. Budget vs Actual Report here -->

Account Balance by Currency

Select one or more Ledger Accounts to display the Ending balance for the Account(s) in any currency (regardless of reporting currency). Account Balance by Currency here -->

Did this answer your question?