Skip to main content
B
BT777
November 26, 2024
Question

balance sheet report

  • November 26, 2024
  • 2 replies
  • 0 views

I can write a balance sheet report (in QBO) that shows account balances month by month. However, I would like to limit that report to a specific set of asset accounts, and have none of the other assets or any of the liabilities show up. I cannot figure out how to do that. There doesn't seem to be a way to filter a balance sheet report by account.

If absolutely necessary, I can export to excel and manipulate there, but that seems cumbersome.

Any ideas?

2 replies

Rainflurry
Rainflurry
November 26, 2024

@BT777 

 

How would your balance sheet balance if you remove some of the asset accounts and all of the liabilities?  

B
BT777Author
November 26, 2024

because i don't actually want a "balance sheet".

what i want is

acct 1 - july end, aug end, sept end

acct 2 - july end, aug end, sept end

acct 3 - july end, aug end, sept end

 

so i can track investment performance.


the pre-fab "balance sheet" report is the only thing that i can find that's even close. but i can't choose the accounts.

E
EmaicaD
November 26, 2024

The ability to filter accounts in the Balance Sheet report is unavailable in QuickBooks Online (QBO), @BT777. I'll provide other ways for you to proceed in this matter.

 

As you stated in your post, you have the option to export your Balance Sheet Report into Excel. 

 

You can also run the Transaction Detail by Account report and filter it to a specific set of asset accounts. You can follow these steps:

  1. Go to Reports.
  2. Search Transaction Detail by Account.
  3. Click Filter.
  4. Hit the first Dropdown button. Then, Select Account.
  5. Choose what account you want to filter.
  6. Once done, Click anywhere to refresh.

To include additional details when tracking Balance Sheet accounts, you can utilize this article: Run a balance sheet by class or location in QuickBooks Online.

 

Go ahead and leave a comment if you have any clarifications about running a Balance Sheet report. We'll get back to you as soon as we can.

B
BT777Author
November 26, 2024

Thanks.

The ability to filter by account would be helpful.

Using Transaction Detail by Account is no good because I only want the month end balance.

I will resort to Excel.

Terms & ConditionsAccessibility statement