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
  • Customizing Reports
  • Column Header Actions
    • Sorting
    • Pin a Column
    • Filter
    • Hide a Column
    • Manage Columns
  • Saving Report Configurations
  • Deleting Reports
• Report Types
  • Balance Sheet
  • Income Statement
  • Journal Lines
  • General Ledger
  • Trial Balance
  • Trial Balance by Posted Currency
  • Ledger Account by Dimension
  • Ledger Account Review Report

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

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 -->