Description

Customize the structure and layout of your financial statements within SoftLedger to meet your reporting and regulatory requirements.

SoftLedger's default layouts for the Income Statement, Balance Sheet and Cash Flow are structured by Report Groups. With customized reports, you have the ability to build reports by Report Groups, SubTypes, individual Ledger Accounts, or a combination of all three. Customized financial reporting tools in SoftLedger provide users with the ultimate flexibility to produce, analyze and present their business' financial results.

Important Considerations

To change where a Report Group, SubType or Ledger Account is mapped, it must be un-mapped from its current Report Section.
As you un-map items, the top right corner will alert you to the number of Report Groups, SubTypes & Ledger Accounts that are not currently mapped to a section. You can save reports that do not have all accounts mapped, however, this is recommended only for the purposes of analyzing segments of your business. A Balance Sheet or Income Statement without all accounts mapped to it is not compliant with GAAP or IFRS.
The Report Layouts will not be saved unless you subsequently Save or Save As the report once Accepting the report layout within the Report Configuration section.

Building a Customized Report

To start building a customized financial report, first navigate to the Reports module and select the Report Type you would like to customize. Click on the Edit Layout button on the right side which will take you to the editing screen.

Fields on the Layout Screen

Once you are in the report editor, you will see all the sections of the financial report ready for customization. The numbers in the image below correspond to the following elements:

Report Type: The type of report being edited (Balance Sheet/Income Statement/Cash Flow).
Report Name: The name of the saved report. You can name the customized report before or after you begin editing. If you start editing first, then you will give your report a unique name after you accept all edits on this screen and are navigated back to the main report page. There you will click Save As, which prompts you to name your report. If you are editing an existing customized report, you will hit Save on the main report screen once all edits are accepted.
Reset Button: Resets the report layout to its default state.
Accept Button: Applies the layout settings for preview. Note that the report itself still needs to be saved after acceptance on the main report page to make this layout permanent.
Cancel Button: Discards changes and closes the editor.
Drag and Drop Editor: The main area for customizing the report layout.
Report Accuracy Status: Alerts you to any potential issues with your report and will display errors of the Ledger Accounts not mapped when relevant (see section below for more detail)
Insert/Edit Forms: This area displays forms for inserting new elements or editing existing ones.
Invert Balance: Controls how account balances are displayed
- Disabled:
  - Net Debit balances shown as Positive
  - Used for Asset/Expense Accounts
- Enabled:
  - Net Credit balances shown as Positive
  - Used for Revenue/Liability/Equity Accounts
Note: Inverting an account balance will only change how the number is displayed, not the math involved in computations (gross profit, net income)

There are two different types of sections: Reporting Sections & Header Sections. A Reporting Section is where you will map your Report Groups, SubTypes or Ledger Accounts. A Header Section has other sections nested underneath it, but does not have any Report Group, SubType or Ledger Account directly mapped to it. In the below example, Cost of Revenue is a Header Section as it has no accounts directly mapped to it, but has other sections nested underneath. Labor, Materials and Services COR are all Reporting Sections. This is where the direct mapping to accounts will occur.

Drag and Drop Re-ordering

By clicking on the handle of a section, you can drag it to different positions in the list of sections.

You can also drag and drop Reporting Sections into Header Sections (or Header Sections into Header Sections) to nest them underneath. To do this, click and hold the handle of the section you'd like to nest underneath, then drag and drop it into the handle of destination section. You will see the handle of the destination section highlight when you hover over it, indicating you can drop in the nested section. You must drag the nested section's handle to the destination section's handle section, not the destination section's title box, in order to nest. Example:

In the Balance Sheet below, I want to nest Allowance for Unbilled AR under Unbilled AR.

If I click and hold on the Allowance for Unbilled AR handle and try to drop it in Unbilled AR in the title box, the section is not highlighted and I cannot drop it in.

NOTE: Every section on the financial report requires a Header Section. You will not be able to drag and drop a Reporting Section into another Reporting Section in order to nest it underneath. Reporting Sections must be dropped into Header Sections

Inserting and Editing a Report Section

To insert a new row in the editor, hover over the row above where the new row should be inserted. A + Insert button will appear:

When clicked the Insert Report Section menu will appear (see image and description for section below):

A bold line and arrow will indicate where this new section will be.
The alert section will indicate unmapped accounts that can be added.
Edit the name of the group and summary of the group that will appear on the financial.
Select which Report Groups/SubTypes/Ledger Accounts to add to this section (this is optional; if none are selected, the Report Section will be used as a header for the section only).

NOTE: You can only map Report Groups, SubTypes and Ledger Accounts which are not mapped elsewhere. In order to reclassify a Report Group, SubType or Ledger Account from one section to another, you must un-map it from its current location before you re-map it to its desired location.

You can edit an existing row with the same information from above as well once a Report Section exists by clicking the pencil icon on any existing Report Section:

Report Accuracy

For financial reports to be accurate, all Ledger Accounts must be included within a mapped Report Group, included within a mapped SubType or mapped individually by Ledger Account.

Complete Mapping:

If all Ledger Accounts have been mapped successfully, you'll see this message:

Incomplete Mapping:

If there are unmapped Ledger Accounts, you'll see an alert like this:

The alert will adjust to show different levels of unmapped pieces of the chart of accounts based on the extent of unmapped accounts:

Report Group: If all SubTypes/Ledger Accounts in a report group are unmapped.
SubType: If all accounts in a SubType are unmapped.
Individual Accounts: If some Ledger Accounts for a SubType are mapped, but others aren't.

Balance Sheet Structure and Rules

In order for a Balance Sheet to balance, the following conditions must be met:

All Asset, Liability, and Equity accounts should be mapped.
Current Period Income should be mapped under the Equity section.
Currency Translation Difference should be mapped under the Equity section.

⚠️ Note: This applies to Consolidated Reports using multiple reporting currencies.

The following report sections can't be edited, moved, or deleted:

Assets
Liability & Equity
Liabilities
Equity

Warning:

The Balance Sheet will only balance if you have closed the previous accounting year, which books the Retained Earnings Journal Entry.

Income Statement Structure and Rules

All Revenue and Expense Type Ledger Accounts need to be mapped once each.

Cash Flow Structure and Rules

All Balance Sheet Type Accounts (Asset, Liability, and Equity) should be mapped.
Sections (Operating/Investing/Financing) can't be reordered.
Current Period Income is fixed under the Net Operating Income(LOSS) section.