The Balance Sheet Report shows information about balance sheet accounts. It is available to customers with the Plus and Premium subscriptions, with Sage Intacct & QuickBooks integrations only. The Balance Sheet Report is presently in beta and must be activated by Martus Support. A Balancing Dimension can be turned on for Sage Intacct customers.
- 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. 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 permissions can access the report in Dashboard > Financials.
Navigating the Balance Sheet Report
- 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.
- 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 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.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article