Dashboard and Financial Reports : Martus Solutions

Dashboard Reporting - Overview

Martus offers a suite of standard reports. Each report is unique in the data that is shown and how it is displayed. Every report is similar in that it can be adjusted via the report criteria section.

Every user who interacts with Dashboard Financial reports will only see the data (Dimensions and Accounts) that they have been granted privileges to see. For more information on setting up users and managing permissions, click here

Anatomy of Dashboard Financials

Report Controls

All report controls will prompt Martus to auto-update to the action taken. The Load button in the Report Criteria section should only be utilized when the report criteria is changed.

Select Report - The dropdown is used to navigate to the various Dashboard Financial Reports. The control displays the name of the current report.
Set Default View - Each user can utilize this button to set their own default report. This will be the report that is displayed when the user navigates to Dashboard > Financials.
Set as Global Default View - Only available to Admin Users. This allows the Admin to set the default view for all Martus users. This can be overridden by the individual user after it has been set.
Saved Reports - This allows for a specific report with specific criteria to be saved for easy navigation after. The saved report is available in both this drop down and on the User's home screen. Click here for specific steps.
Shared Report - Only available to Admin Users. This allows an Admin to share the saved report to all users. The report, just like all Dashboard Financial reports will be automatically filtered to the user's permissions when that user navigates to the report.

Report Criteria

The report criteria differs from report to report. However, every report has criteria and similar options. The following are standard across all reports, for specific report criteria, use the links below.

Ending Date - this is the default date for the reports and is derived from the Last Closed Month defined in Setup > Calendar. This date identifies the month though which actuals data will be displayed. Change this date to see information through a different date.
Months - determines how many months of data will be reviewed with the most recent being the ending date. This will default to the month in the fiscal year that correspond to the Ending date.
Budget - Allows the user to chose which budget to compare actuals to. By default non-admin-users will only see the default budgets.
Rows - Controls the grouping of data on the rows. The rows can be set to Accounts, Account Categories or any of the dimensions within the system.
Include Excluded Data - will show Accounts or Dimensions that are set to Excluded via the Setup section.
Dimension Filters - when applied, will filter the report to the selected dimension. When a top level dimension is selected, the report will show all sub-dimensions.
Account Category - when applied, will filter the report to the selected Account Category
Load - refreshes the report with whatever criteria have been applied
Export - Most reports can be exported to either Excel or PDF.

Report Display

Information displayed will vary based on the report chosen and the criteria utilized.

Drillable Links- All blue values are drillable, when clicking on them Martus will provide more details about that value.
- Actual Columns -navigates to the Transaction report
- Budget Columns - navigates to a list of all worksheets with that line budgeted
- Title Columns (displayed when rows are set to dimensions) - navigates to the income statement filtered to that dimension
Favorable or Unfavorable - in general in columns with both black and red values, black is normally favorable and red is normally unfavorable
Rows impact Drillable Links - Depending on how the rows are set in the Criteria and which report being utilized, the blue links will expand into the Transaction report, or when they are in the columns, they will normally jump to the Income Statement filtered appropriately.

Step By Step - Change to new Report, change criteria and save that report

Navigate to Dashboard >Financials
Use the Select Report drop-down to chose a report
Give the Report a Name
Change one of the dimension filters to filter to a dimension
Click Load
Give the Report a Name and click Save

Report Specific Information:

Print Article

Saved Reports

To make it easier for you to quickly look at your favorite Martus reports, you can create and name Saved Reports. Saved reports are a combination of report filters and format selections for a specific report layout. There are two kinds of saved reports:

Shared reports are available to all users. Shared reports can only be created or deleted by Admin users.
User-specific reports are only available to the user who created the report.

Managing Saved Reports

The Saved Reports dropdown shows your user-specific reports and any shared reports. Shared reports show "(Shared)" after the report's name. Click any item in the dropdown to select that report. The report layout, filters, and format selections are applied immediately.

Just as with any report where you manually select various filters and formats, the default ending date and number of periods used when you display a saved report will always be the current Last Closed Month. You can change the ending date and the number of periods, then click Load, to see that information as of a specific month.

To add a new Saved Report, pick the report format and filters and click Load to display the report you’d like to save, then use the + icon.

Enter a name for this new saved report. Admin users can choose to make the report shared by selecting Shared Report before clicking Create New Saved Report.

Shared reports can be deleted and renamed. Just select the report, then click the Rename or Trash Can icon.

Additional Information about Saved Reports

Saved report names must be unique.
For a user with multiple profiles, any user-specific reports are also specific to the profile in which they were created.
A non-admin user's permissions and dimension limitations are always applied, even if a shared report is filtered to dimension values or other information that is not accessible to that user. For example, if a shared report specifies Department 200, a user who does not have access to that dimension value will not see Department 200 if they select that report.
A saved report cannot be changed from shared to user-specific or vice versa.
The combination of filters and layouts that are defined by a saved report cannot be changed. Simply create a new saved report if you'd like a different report with different data or format.

Print Article

Income Statement

The Income Statement is a flexible and powerful report. It can be used to compare budget to actuals, drill down to transaction details, and even drill down to budget details.

Income Statement-Specific Report Criteria

Columns - Adjust your columns to show only one month, or to display dimensions.
All Dimensions - When rows are set to a dimension or an account category, clicking All Dimensions will display the sub-departments with the appropriate sub-totals.
Expand - When rows are set to a dimension or an account category, clicking Expand will display the sub-departments as well as accounts within the department and sub-departments as well as the appropriate sub-totals.

General Report Criteria Available within the Income Statement

Ending Date - Show data in months in the fiscal year through the ending date.
Months - Determines how many months of data will be reviewed with the most recent being the ending date. This will default to the month in the fiscal year that corresponds to the Ending date.
Budget - Allows the user to choose the budget with which to compare actuals. By default, non-admin-users will only see default budgets.
Rows - Controls the grouping of data on the rows. The rows can be set to accounts, account categories, or any of the dimensions in Martus.
Include Excluded Data - Will show accounts or dimensions that are set to Excluded in Setup > Accounts or Setup > Dimensions respectively.
Dimension Filters - When applied, will filter the report to the selected dimensions. When a top-level dimension is selected, the report will show all sub-dimensions.
Account Category - When applied, will filter the report to the selected account category.
Load - Refreshes the report with whatever criteria have been applied.
Export - Most reports can be exported to either MS Excel or PDF.

Print Article

Forecast Report

The Forecast report will always show all 12 months in the fiscal year. Actuals will be shown through the Ending Date (defaulted to the Last Closed Month) and the budget for the remaining months. All 12 months will be totaled and compared to the annual budget. This is an excellent report for end-users as it indicates the remaining budget and any anomalies of which to be aware.

Forecast-Specific Report Criteria

Detail - Provides a drop down to choose All Dimensions or Expand
- All Dimensions - When rows are set to a Dimension or Account Category clicking Expand will display the sub-departments with the appropriate sub-totals
- Expand - When rows are set to a Dimension or Account Category clicking Expand will display the sub-departments as well as accounts within the department and sub-departments as well as the appropriate sub-totals.

Forecast General Report Criteria

Ending Date - Will show actuals in the months through the ending date.
Months - Determines how many months of data will be reviewed with the most recent being the ending date. This will default to the month in the fiscal year that corresponds to the Ending date.
Budget - Allows the user to choose which budget to compare actuals to. By default, non-admin-users will only see the default budgets.
Rows - Controls the grouping of data on the rows. The rows can be set to accounts, account categories, or any of the dimensions within the system.
Include Excluded Data - Will show accounts or dimensions that are set to Excluded via the Setup section.
Dimension Filters - When applied, will filter the report to the selected dimension. When a top-level dimension is selected, the report will show all sub-dimensions.
Account Category - When applied, will filter the report to the selected account category.
Load - Refreshes the report with whatever criteria have been applied.
Export - Most reports can be exported to either MS Excel or PDF.

Print Article

Monthly Budget Comparison

This report is helpful when trying to compare each month's budget to expenses. For every month shown, Martus will display Actuals, the Budget, the variance and percent variance. When rows are set to accounts, the Actual columns are drillable.

Monthly Budget Comparison Specific Criteria:

Periods - Controls how many months the report will display. Will default to the months that have elapsed in the fiscal year.
Detail - provides a drop down to choose All Dimensions or Exapnd
- All Dimensions - when rows are set to a Dimension or Account Category clicking Expand will display the sub-departments with the appropriate sub-totals
- Expand - when rows are set to a Dimension or Account Category clicking Expand will display the sub-departments as well as accounts within the department and sub-departments as well as the appropriate sub-totals.

Monthly Budget Comparison Generic Criteria:

Ending Date - Will show months in the fiscal year through the ending date.
Months - determines how many months of data will be reviewed with the most recent being the ending date. This will default to the month in the fiscal year that corresponds to the Ending date.
Budget - Allows the user to choose which budget to compare actuals to. By default, non-admin-users will only see the default budgets.
Rows - Controls the grouping of data on the rows. The rows can be set to Accounts, Account Categories, or any of the dimensions within the system.
Include Excluded Data - will show Accounts or Dimensions that are set to Excluded via the Setup section.
Dimension Filters - when applied, will filter the report to the selected dimension. When a top-level dimension is
selected, the report will show all sub-dimensions.
Account Category - when applied, will filter the report to the selected Account Category
Load - refreshes the report with whatever criteria have been applied
Export - Most reports can be exported to either MS Excel or PDF.

Print Article

YTD Budget Comparison

The YTD Budget Comparison provides a very compact look at budgets vs actuals. This report has clear comparisons and an easy way to quickly see the bottom line.

This report can be found under Dashboard > Financials > YTD Budget Comparison

This report can also provide a budget-to-actuals comparison for the entire life of a specific grant or project.

YTD Budget Comparison Report:

Multi-Year - When 'Multi Year' is checked and a Dimension filter is applied, the report will display all budget to actual data for all years available. Multi year will only work if a dimension filter is applied.
Start & End Date - Utilize to define a specific date range, for example, a grant that may span multiple fiscal years.

General Report Criteria available within the Income Statement report:

Ending Date - Will show months in the fiscal year through the ending date.
Months - determines how many months of data will be reviewed with the most recent being the ending date. This will default to the month in the fiscal year that corresponds to the Ending date.
Budget - Allows the user to choose which budget to compare actuals to. By default, non-admin-users will only see the default budgets.
Rows - Controls the grouping of data on the rows. The rows can be set to Accounts, Account Categories, or any of the dimensions within the system.
Include Excluded Data - will show Accounts or Dimensions that are set to Excluded via the Setup section.
Dimension Filters - when applied, will filter the report to the selected dimension. When a top-level dimension is selected, the report will show all sub-dimensions.
Account Category - when applied, will filter the report to the selected Account Category
Load - refreshes the report with whatever criteria have been applied
Export - Most reports can be exported to either MS Excel or PDF.

Print Article

Multi-Year Budget to Actuals Report

This report is particularly useful for tracking grant expenses. It shows activity over several years and allows you to drill down into specific years. It uses the default Dashboard budget for all years.

Multi-Year Budget to Actuals Specific Criteria:

Multi-Year - When selected and a Dimension filter is applied, the report will display all budget to actual data for all years and provide a Information icon to view the specific month data.
Start & End Date - Utilize to define a specific date range, for example, a grant that may span multiple fiscal years.
Detail - provides a drop down to choose All Dimensions or Expand
- All Dimensions - when rows are set to a Dimension or Account Category clicking Expand will display the sub-departments with the appropriate sub-totals
- Expand - when rows are set to a Dimension or Account Category clicking Expand will display the sub-departments as well as accounts within the department and sub-departments as well as the appropriate sub-totals.

Multi-Year Budget to Actuals Generic Criteria:

Ending Date - Will show months in the fiscal year through the ending date.
Months - determines how many months of data will be reviewed with the most recent being the ending date. This will default to the month in the fiscal year that corresponds to the Ending date.
Budget - Allows the user to choose which budget to compare actuals to. By default, non-admin-users will only see the default budgets.
Rows - Controls the grouping of data on the rows. The rows can be set to Accounts, Account Categories, or any of the dimensions within the system.
Include Excluded Data - will show Accounts or Dimensions that are set to Excluded via the Setup section.
Dimension Filters - when applied, will filter the report to the selected dimension. When a top-level dimension is
selected, the report will show all sub-dimensions.
Account Category - when applied, will filter the report to the selected Account Category
Load - refreshes the report with whatever criteria have been applied
Export - Most reports can be exported to either MS Excel or PDF.

Print Article

Worksheet Budget Comparison

The Worksheet Budget Comparison report will show all worksheets (unique combinations of sheet dimensions) where there are either budget or actuals. This report will demonstrate where actuals maybe that either need to be budgeted for or transactions may need to be re-classified.

Worksheet Budget Comparison Report Criteria:

Ending Date - Will show actuals in the months through the ending date.
Budget - Allows the user to choose which budget to compare actuals to. By default, non-admin-users will only see the default budgets.
Include Excluded Data - will show Accounts or Dimensions that are set to Excluded via the Setup section.
Dimension Filters - when applied, will filter the report to the selected dimension. When a top-level dimension is
selected, the report will show all sub-dimensions.
Account Category - when applied, will filter the report to the selected Account Category
Load - refreshes the report with whatever criteria have been applied
Export - Most reports can be exported to either MS Excel or PDF.

Print Article

Detail Analysis

This report displays all rows of data within Martus. Each row is a unique combination of account and dimensions. This report will display all actuals through the Ending date, the total YTD, budget YTD, and compares the YTD actuals to the annual budget.

This report can be found in Dashboard > Financials > choose 'Detail Analysis' in the drop down

Detail Analysis Specific Criteria:

Periods - Controls how many months the report will display. Will default to the months that have elapsed in the fiscal year.

Detail Analysis Generic Criteria:

Budget - Allows the user to choose which budget to compare actuals to. By default, non-admin-users will only see the default budgets.
Rows - Controls the grouping of data on the rows. The rows can be set to Accounts, Account Categories, or any of the dimensions within the system.
Include Excluded Data - will show Accounts or Dimensions that are set to Excluded via the Setup section.
Dimension Filters - when applied, will filter the report to the selected dimension. When a top-level dimension is
selected, the report will show all sub-dimensions.
Account Category - when applied, will filter the report to the selected Account Category
Load - refreshes the report with whatever criteria have been applied
Export - Most reports can be exported to either MS Excel or PDF.

Print Article

Fund Balances Report

The Fund Balances Report shows fund balances by month and allows the user to drill down to see details.

The Fund Balances Report is part of the Dashboard Financials suite and accessed from the Select Report dropdown. This report is available for the Sage Intacct, QuickBooks Online, and QuickBooks Desktop integrations. It is an optional feature for file-based integrations, but it must be specifically configured. It is not available for Financial Edge NXT integrations.

This report is most useful for non-profit organizations that make use of fund accounting and want their Martus users to be able to review fund balances and activity. However, for processing efficiency, the report is not automatically configured. If you would like have this feature activated, create a ticket through the Knowledge Base if you are a direct Martus customer, or contact your Martus reseller if you are supported through one of our Martus partners.

The Fund Balances Report shows data for the current fiscal year, from the beginning of the current fiscal year through the last month closed. The user can select a different ending date and number of periods if desired. The output can be sent to Excel.

From the Fund Balances Report, click on any fund to drill down to a summary by month.

Drill down from the Net Change amounts to see the transaction details for that month.

For Sage Intacct Integrations

The Fund Balances Report also includes the filter and format options illustrated here:

Filter by any dimension configured in Martus
Set “Rows” to summarize by any dimension configured in Martus
For Admins and users with the appropriate permission, the ability to include Excluded Data on the report.

For QuickBooks Integrations

The Fund Balances Report reflects information in any account that is set to Equity type within Martus. The Category filter limits the data display on the basis of the account category.

Access to the Fund Balances Report

Access to this report can be granted at the user role and individual user level.

Additionally:

For Sage Intacct integrations, a user’s dimensional access determines the funds that will be listed as well as the data within those funds.
For QuickBooks Desktop and QuickBooks Online, users can be limited to specific Equity accounts, via settings on the Accounts tab within Setup > Users.

Implementation Notes

The source of information on the Fund Balances Report depends on the client’s accounting system integration.

For Intacct, the Fund Balances Report is based on a specific dimension, set by Martus Support. Be sure that equity accounts are not marked Excluded for this report, and actuals are re-synced.
For QuickBooks, the report is based on accounts that are set to Equity type within Martus.
For file-based integrations, Martus’ Designated Fund Report is based on information imported into Martus. The file import for the designated fund data must be configured by Martus Support at the time of implementation.

Print Article

Dashboard Report and Dashboard Setup

The Dashboard Report within the standard reports found under Dashboard > Financials is a basic visual representation of your financial data. The widgets a User sees is determined by their User Role. Admin users see the layout assigned to their role, but they can also select any other dashboard layout if they wish.

Looking for information on ReportBuilder Charts? Click here.

Report Criteria:

Date Range: Will default to the Last Closed Month and the appropriate look back period, but can be adjusted
Dashboard: A default dashboard layout is displayed if the user has no role, or if the role has no assigned dashboard layout. Admins can view any Dashboard.
Periods: Allows for the columns to be set to months, or to show variances by quarters or years.
Dimension Filters: Allow the user to filter the Report.
Top Ten: Allows the user to choose a different dimension for the Top Ten Widgets.

The Widgets:

Monthly Income and Expense – This widget compares income to expense by month. Income is shown in teal columns and budget is shown with a red line. Hover over each column or the red circles to see specific amounts. The Total Income and Total Expense summarize ordinary income and expense for the period displayed.
Monthly Income – This widget compares income to budget by month. Current year totals are shown in teal and prior year totals are shown in gold. Hover over each column or the red circles to see specific amounts. The filters for the dashboard can be set to show information by quarter or year. If set to “quarters”, this widget provides a comparison to the quarters from the prior year. If set to “years”, this widget compares totals for the selected range of years. The totals shown in the white boxes are based on actuals and budget for ordinary income for the period displayed.
Income Top Ten – This widget summarizes income for the top 10 accounts, categories, or dimensions, as specified by the dashboard filter. Hover over any segment to see the complete name and the specific amount.
Monthly Expense - This widget compares expenses to budget by month. Current year totals are shown in teal and prior year totals are shown in gold. Hover over each column or the red circles to see specific amounts. The filters for the dashboard can be set to show information by quarter or year. If set to “quarters”, this widget provides a comparison to the quarters from the prior year. If set to “years”, this widget compares totals for the selected range of years. The totals shown in the white boxes are based on actuals and budget for ordinary expense for the period displayed.
Expense Top Ten - This widget summarizes expenses for the top 10 accounts, categories, or dimensions, as specified by the dashboard filter. Hover over any segment to see the complete name and the specific amount.
Gain/Loss Comparison - This widget compares net gain or loss to budget by month. Current year totals are shown in teal and prior year totals are shown in gold. Hover over each column or the red circles to see specific amounts. The filters for the dashboard can be set to show information by quarter or year. If set to “quarters”, this widget provides a comparison to the quarters from the prior year. If set to “years”, this widget compares totals for the selected range of years. The totals shown in the white boxes are based on actuals and budget for ordinary income and expenses for the period displayed.
Weekly Giving - Average weekly giving, calculated as the total of accounts identified as "donation accounts", divided by the number of Sundays in each month. This is available to all Martus customers, but it is applicable primarily to churches.

Admin User Management

Administrators can manage the Widgets within the various Dashboards

Step by Step:

Go to Setup > Dashboards
Click Add to add a new dashboard or click the Edit icon to view or update an existing dashboard.
Click on any widget name and use the single arrows (> and <) to move the widget from Available to Selected, or vice versa.
Use the double arrows (>> and <<) to move all widgets from Available to Selected, or vice versa.
Click on any widget in the Selected Widgets column and use the up and down arrows to organize the sequence of the widgets on the screen.
Update any Dashboard name as desired
Delete any dashboard layout that is not assigned to a role.
***Each User Role is given a Dashboard for the Users within that role

Print Article

Transactions

The Transaction report provides a listing of all transactions within the date range and dimension filters applied. With an API connection such as Sage Intacct, Martus will make a live request to pull up-to-date information into Martus when the transaction report loads. The transaction report is normally navigated to from another report and will apply the appropriate parameters. If navigating directly to the report, select one or more filters and click Load.

NOTE: If the total of the selected transactions does not match the Income Statement, limit your selection filters to a shorter date range and/or a single account to find more matching transactions, as there is a maximum number of transactions that are returned.

NOTE: If you notice that transaction amounts shown do not match those on the Income Statement, it is possible that transactions have been updated, but haven't synced with Martus. To resolve this, have an Admin user sync the necessary month(s) in Dashboard > Updater > Actuals.

Transactions General Report Criteria:

Start and End Dates - Determines the date range for the transactions that are shown.
Include Excluded Data - Show Accounts or Dimensions that are set to Excluded via the Setup section.
Account - Specify the account to view.
Account Type - Specify the account types to view.
Dimension Filters - When applied, will filter the report to the selected dimension(s). When a top-level dimension is selected, the report will show all sub-dimensions.
Account Category - When applied, will filter the report to the selected Account Category.
Load - Refreshes the report with selected criteria.
Export (xlsx) or PDF - Most reports can be exported to either Excel or PDF.

Print Article

Income Statement by Dimension in Excel

The Income Statement by Dimension in Excel report provides an export only (no on screen display). This report can be utilized to easily export the Income statement with an overview tab, and a tab for the each of the dimensions specified. For example, this report can be filtered to a location and exported with a tab per Department.

Specific Report Criteria:

Output Dimension - provides a drop down to choose the dimension each tab should display.
Export - Only appears after clicking load.

General Report Criteria:

Ending Date - Will show actuals in the months through the ending date.
Months - determines how many months of data will be reviewed with the most recent being the ending date. This will default to the month in the fiscal year that corresponds to the Ending date.
Budget - Allows the user to choose which budget to compare actuals to. By default, non-admin-users will only see the default budgets.
Include Excluded Data - will show Accounts or Dimensions that are set to Excluded via the Setup section.
Dimension Filters - when applied, will filter the report to the selected dimension. When a top-level dimension is
selected, the report will show all sub-dimensions.
Load - refreshes the report with whatever criteria have been applied

Print Article

Balance Sheet

The Balance Sheet Report shows information about balance sheet accounts. It is available to customers with the Plus and Premium subscriptions, with a QuickBooks integration. The Balance Sheet Report must be turned on for each Martus instance by Support.

Admin users and non-admin users with the Balance Sheet and Cash Flow Statement permissions can access the report in Dashboard > Financials.

The default ending date is your Last Closed Month. You can change this ending date to run the report for different time periods.
You can choose to run the report for multiple years. If you do so, then you can also display a Difference column comparing the two final years.
If you use an ending date that is not the last month in your fiscal year, every year’s column will show balances through that month.
The report will include all accounts with balances. It will also include Inactive accounts with balances. Inactive accounts are tagged with “[I]” for easy identification.
You can choose to show blank lines for accounts that are active but have no balance.
The report is organized into sections for Assets, Liabilities and Equity. Within each section, accounts are summarized by account category. Balances for accounts that are not assigned to a account category will show under the category “[Blank]”.
Use the “+” and “-” to expand or summarize any section or subsection of the report.

Additional Notes

The QuickBooks Online (QBO) Balance Sheet Report always shows Net Income for YTD, so be sure Martus is synced for the entire year and run the balance sheet reports for an entire year.

Print Article

Dashboard and Financial Reports

ReportBuilder - Customized Reporting

Report FAQs