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.