Skip to main content
March 3, 2024
Question

I use Funds. In Desktop I created separate Balance Sheet and Profit & Loss for each Fund How do I make a custom Balance Sheet for each fund?

  • March 3, 2024
  • 1 reply
  • 0 views
P&L has option to filter and choose accounts.

Balance Sheet does not have that option.

1 reply

March 3, 2024

Let me share some information about how the Balance sheet works in QuickBooks Online (QBO).

 

The option to filter the Balance sheet report to accounts to see each fund is unavailable in QBO. A Balance Sheet report gives you a financial snapshot of your company as of a specific date. It calculates how much your business is worth by subtracting all the money your company owes from everything it owns (assets). What we can do is export the report to Excel to add columns for the accounts and funds. Here's how:

 

 

  1. At the top of the report, select the Export icon.
  2. Select Export to Excel.
  3. Save the file somewhere you can easily find, like your Downloads folder or your desktop.

 

If you’re missing data when you open the report in Excel, the file's in protected view. In Excel, you’ll need to select Enable Editing to view the full report. You can check out this article for more details: Export your reports to Excel from QuickBooks Online. Need data that isn’t found in basic reports? You can create custom reports to get the data that matters to you most.

 

Once everything is all set, you may also want to check out this article as your reference in knowing the complete list of reports available for your version of QBO: Reports included in your QuickBooks Online subscription.

 

Let me know if you have other reporting concerns or questions about managing financial transactions in QBO. I'll be here to help.