Description

Manage your financial report definitions from this page.

Manage Reports

Create New Report

Click Create New Report, to add a new financial report.

Fields:

  • Report Group - This will be the top level name of the report
  • Invert Balance - If turned On, will show credits as positive

Edit Report

Select a Report Group and Click Submit to begin editing a report

The following actions are available:

  • Save Report - Save any updates you have made
  • Edit Details - Edit the name or toggle Invert Balance
  • Create Copy - Create a new report using the current as a template
  • Delete - Permanently Delete this report(Cannot be un-done)

Report Groups contain one or more child report groups.

They may also contain one or more "Report Mappings", which contain either a Ledger Account or a Ledger Account SubType.

The report group editor allows the following actions

Handle 

Menu Icon

Drag & Drop Groups

  • Grab the "handle"  (grey hamburger menu icon) on the left side of the group and drag it to a new position.
  • It can be dragged to a new nested location or its order changed.
  • If moved, all its children will be moved along with it

Add Child Group

  • Click the menu icon, then click Add Group to add a new child group

Add Mapping Type

Click the green ellipsis menu icon, then click Select Account. Choose a Location and then select the Mapping Type:

  • A single Ledger Account
  • A Ledger Account Sub-Type, that will pull all Ledger Accounts with that Sub-Type
  • A Formula, primarily used to map Current Period Net Income to the Balance Sheet:
SUM(debit - credit) for all Revenue and Expense Journal Entries, within the Date Range selected for the Report (excluding any Closing Entries)

Remove Group

  • Click the menu icon, then click Remove Group to remove this group and ALL of its children

Remove Mapping

  • Click the X icon for the report mapping to remove it from the group 
Did this answer your question?