Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
JohnGNC
Level 1

Customized Balance Sheet report

I upgraded from QuickBooks Desktop Pro to QuickBooks Plus On-Line.

I need two customized reports of Balance Sheet Accounts.

  • All checks written for more than $1,000.
  • A report on a Designated Fund (equity) with its sub-account.

I could do these in Desktop.

 

 

Thanks for your help.

John

2 Comments 2
Maybelle_S
QuickBooks Team

Customized Balance Sheet report

We appreciate your continued support and loyalty as you upgraded from QuickBooks Desktop (QBDT) to QuickBooks Online (QBO, John. We are committed to ensuring a seamless transition and providing you with the best possible service.

 

The Balance Sheet report presents the company's financial position, including assets, liabilities, and equity. However, checks are not directly listed because they are not categorized under assets, liabilities, or equity.

 

We can generate a Transaction Detail by Account report, applying filters for Transaction Type to show only checks. This report will list those that meet your criteria without affecting the Balance Sheet's structure.

 

Here's how:

 

  1. Go to the Reports menu.
  2. In the search bar, type Transaction Detail by Account.
  3. Click the Customize button.
  4. Select the Filter drop-down arrow.
  5. Choose Check in the Transaction Type drop-down arrow.
  6. Hit Run report.

 

Moreover, I recommend exporting the data to Excel and manually applying filters to display checks exceeding $1000. See the screenshots below to export the data.

 

Additionally, you can run a Balance Sheet report to see the Designated Fund (equity) with its sub-account.

 

I can see the importance of having this option for your business. With that, I suggest sending feedback to our product developers so they can review it and might consider adding this in our future updates. Please refer to the steps below:

 

  1. Go to the Gear icon.
  2. Under Profile, select Feedback.
  3. Enter your suggestion.
  4. Hit Next.

 

You can track your feature requests through our QuickBooks Online Feature Requests website.

 

Let me know in the comment below if you have other concerns or follow-up inquiries about managing reports in QBO. I'm just around to help. Take care!

JohnCVRA
Level 1

Customized Balance Sheet report

The idea of using Transaction Detail by Account with Excel will give me a list of checks > $1,000. 

However, using Transaction Detail by Account for Equity Funds detail does not show beginning balances for the account. It only shows the total of the transactions for the period. This does work in QBOL Advanced (different company).

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us