How To Set Up Your Balance Sheet

Modified on Tue, Jun 10 at 6:11 PM




The Balance Sheet is currently only available for QuickBooks and Intacct customers who have the Plus or Premium subscription tier.

Add Account Categories

  1. Setup > Account Categories
  2. Click 'Balance Sheet Quickstart' to automatically add in premade account categories
  3. Click 'Add'
  4. Or add in your own account categories for your balance sheet by clicking 'Add Category'


Assign the Account Categories to Your Balance Sheet Accounts

  1. Click 'Accounts' on the main menu
  2. Using the filter icon on the 'Type' column
    1. Filter only for 'Asset' 'Equity' and 'Liabilities' and click 'OK'
  3. Check the box to select the accounts 
  4. Click 'Edit Accounts' 
  5. Change the 'Category' dropdown at the bottom of the popup and choose the category the account(s) should fall under
  6. Click 'Update Accounts'
  7. Repeat this step until all accounts that should be on the balance sheet have an account category

Intacct Clients Only - Verify that the 'Closed-To Account' is Properly Designated

  1. If you are an Intacct customer, make sure that the account that needs to be designated as the 'Closed-To Account' is properly designated
  2. To mark an account as the 'Closed-To Account' account, click the box of that account and click 'Edit Account' 
  3. In the 'Subtype' dropdown, choose 'Closed-To Account'
  4. Make sure you click the box for 'Lock Type and Subtype' 
  5. Click 'Save' 
  6. If you had to designate an account as the 'Closed-To Account' you will need to sync your actuals 
  7. Click Dashboard > Updater 
  8. Choose your start and end date for actuals and click 'Sync Monthly Actuals' 


View Your Balance Sheet

  1. Click Dashboard > Financials
  2. Click the dropdown for the report and choose 'Balance Sheet' 
  3. To collapse a section, click the '-' icon 
  4. To expand a collapsed section,n click the '+' icon
  5. The tabs at the top will allow you to see the balance sheet by dimension
  6. To see blank lines on the balance sheet, click the 'Show Blank Lines' box
  7. Change the number of years you can see the balance sheet for
  8. If you select two years when viewing the balance sheet, the 'Show Difference' box will appear and you can choose to show the comparison or not for the years selected



Granting Non-Admins Access To The Balance Sheet 

  1. Be advised that the balance sheet does not adhere to dimension restrictions. If a user is given access to the balance sheet that user will be able to see the full balance sheet for all dimensions. 
  2. To give a non-admin user access to the balance sheet, an admin can go to Setup > Users 
    1. Click 'Edit' on the non-admin user who should have access
    2. Check the box for 'Balance Sheet and Cash Flow Statement'
    3. Click 'Save' 



Click here for How To Set Up Your Cash Flow Statement 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article