Balance Sheet Report

The Balance Sheet Report is a financial statement that provides a snapshot of a company's assets, liabilities, and equity/net assets at a specific point in time, showing what the company owns, what it owes, and what's left for the owners (or fund balances for a non-profit). 

It is standard for customers with the Plus and Premium subscriptions, with Sage Intacct (still in beta) & QuickBooks integrations only. These reports will be made available for other integrations in the future.

• Balance Sheet accounts (asset, liability, and equity/net assets) will match the status set in the accounting system. (These are set to inactive in all other Martus subscriptions.)
• A Balancing Dimension (typically the entity) is identified for Sage Intacct customers; this allows the Balance Sheet and Cash Flow to be displayed per entity and in summary.  
• 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.
• The report is organized into sections for Assets, Liabilities and Equity/Net Assets. Within each section, accounts are summarized by account category. Balances for accounts that are not assigned to an account category will show under the category “[Blank]”.
• Admin users and non-admin users with the Balance Sheet and Cash Flow Statement permission can access the report in Dashboard > Financials. NOTE: Non-admin user restrictions DO NOT apply to the Balance Sheet Report. They will see all dimensions and all accounts. 

How to Get Started

For existing customers, follow these steps to start using these reports.

• Run an account sync to be sure that all balance sheet accounts have been synced into Martus.
• Update the status on all of those accounts that you want to be Active in Martus.
• Assign balance sheet categories and cash flow categories to all balance sheet accounts.
• Run a monthly sync for the last year, or more, to pull balance sheet activity into Martus.

Navigating the Balance Sheet Report

The Balance Sheet Report can be found in Dashboard > Financials.

• End Date - Defaults to the Last Closed Month. A user can change the date to run the report for different time periods.  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.
• Num of Years - Select the number of years for the report.
• Show Blank Lines - Select to show blank lines for accounts that are active but have no balance. 
• Show Difference - If two years are selected in Num of Years, check Show Difference to display a Difference column.
• Dimension dropdown - For Sage Intacct customers, select from the dimension drop-down to filter to a single entity.
• Load - Click Load when any settings have been changed to refresh the report.
• Export - Export the report to Excel or PDF.
• + and - - Use the “+” and “-” to expand or summarize any section or subsection of the report.
• Additional tabs may display for each dimension, along with the Consolidated tab.
  
  

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.