Where do I find a report in QBO similar to Quickbooks desktop?

I know it can be upsetting when you're unable to get the data needed on the report, gc527. 

Let me make it to you by ensuring you can run a report that has all the needed information.

If you're trying to run the Trial Balance report, this only gives you the summary of debit and credit balances of each account on your Chart of Accounts during a period.

You can run the Sales by Customer Detail report to show your sales grouped by customer, including the date, type of transaction, amount, and total. Combine both reports and export them into Excel to get the data needed.

To export a report to Excel:

1. Select Reports (Take me there).
2. Search for and select the report you want to export.
3. At the top of the report, select the Export icon. Then choose Export to Excel.
4. Save the file where you can easily find it.

Moreover, here's an article that provides information about customizing reports: Customize reports in QuickBooks Online. It includes instructions on how to share custom reports and automate one.

Drop a comment below if you have additional questions about running the report or other QuickBooks concerns. I'll be around to help.

Hi GlinetteC,

Appreciate your help greatly.  I believe the sales by customer report will help to see what we have invoiced.  What report can give me the detail of payments by customer?

If I combined those two reports (sales report and payment report) would I be able to match the transaction list for each customer?

Hello, gc527.

Thanks for getting back to us! And I'm glad my colleague's solution for the Sales by Customer Detail report works for you. I'll take it from here and share a report that would give you a detail of payments by customer. 

We can use the Invoices and Received Payments report to see a detailed view of the payments received within a given time period. 

Simply go to the Reports menu, then search for Invoices and Receive Payments in the search box. Specify the Report period when needed. 

Another option is to run and customize the Transaction List by Customer report. Both reports show the payments, but they have different ways of showing the data and how we want to customize the reports. Here's a sample comparison: 

To customize the report:

1. Open the Transaction List by Customer report. 
2. Click the Customize button.
3. Expand the Filter section.
4. Check Transaction Type, then select Payment from the drop-down menu.
5. Hit Run report.

We would be able match the transaction list for each customer by comparing both reports. If you'd prefer to see the data in Excel (adding columns, formulas, data and the like), we can do so by exporting both reports. We can follow the steps given by GlinetteC.

I'll add this article in case you need help running other reports within QuickBooks: Run reports in QuickBooks Online. 

Just like in QuickBooks Desktop, we also have the ability to memorize report for future viewing. If you'd like to pull up similar reports in the near future, we can memorize them. I'll add this guide if you want to learn more: Memorize reports in QuickBooks Online.

The year-end tax season is just around the corner. If you need to take care of your books, taxes, and balances, I'll share this guide with you: Year-end guide for QuickBooks Online.

This thread's still open if you have more questions about running reports. Ask away if you also have concerns about your entries like sales, expenses and bank records. Always here to help. 

Appreciate it.

It is incredible that no report gives me an accurate view of open balance that matches the transaction list.

Any idea which report does that by customer?

Thanks for coming back here and sharing some insights of your reporting needs in QuickBooks Online, @gc527.

As you may know already, QuickBooks Desktop and Online are two separate products. They use different database and the features are designed differently based on the program. Not all features are always the same for these products, including the reporting features. 

The reports shared by my colleagues are the closest workaround you can use, or you may try the Customer Balance Detail report. This report doesn't have the debit and credit columns but it will show you the current open balance of each customer for a certain period. See this:

 

Also, you can add a product request for our developers. They go through a wide range of feedback, and tries to navigate a path forward with accessibility leading.

Their goal is to be purposeful and thorough with the enhancements and product updates to make our program efficient to use. For now, we can't provide the turnaround time if they will release additional report preferences. They work on product enhancements internally. 

If you have any product suggestions to our developers about our report preferences, send your request through these steps:

1. Click the Gear icon and choose Feedback.
2. Enter your suggestion for our engineers on the Feedback box.
3. Once done, press Next to send it.

To be updated with the recent and upcoming changes for QuickBooks products, visit these sites:

• QuickBooks New Features and Innovations
• What's New in QBO?

If you need further help with the processes and features in QBO, please let me know in the comment below. I'll be right here to share some more information about QuickBooks reports. Have a nice day!

Hi GlinetteC,

Hope all is well.  I have been working on the "Sales by Customer Detail" report and I realized that the invoices show duplicate based on the number of payments received.  Is there another report that would show me the invoices or a way to filter the report to show the invoices once?  Maybe another report that will give me invoices by customer without any duplication?

Appreciate your help.  Thank you.

This worked.  Thank you!

The QB Desktop Sales Tax Liability Report contains at the bottom the TOTALS (Total Sales, Non-Taxable Sales, and Taxable Sales). How can we get the same in QB online. The issue is that a Sales Tax has various subcomponents, so figuring this out visually or in excel is not trivial. These totals are needed for manual reports to tax agencies that do not take QB automated tax payments.

Many thanks for your support.

Hello there, @HaroldM1.

I recognize the benefits of achieving your goal with the Sales Tax Liability report. However, we're unable to see the total amounts for each Total sales, Non-Taxable Sales, and Taxable sales in QuickBooks Online (QBO), unlike QuickBooks Desktop (QBDT). Thus, we can send this suggestion to our Product Developers so they can consider this in future product enhancements. 

Here's how:

1. Click the Gear icon and choose Feedback.
2. Enter your feedback Suggestion.
3. Press Next.

Alternatively, we can customize the report to see the tax amount totals. To do so, you click the Customize button on the report. Click the boxes from there, including the Tax amount. Once done, select Run Report to save the changes. You can see the screenshot below for your visual reference:

Moreover, I'll add this guide here to learn more about personalizing your reports in QBO: Customize reports in QuickBooks Online.

On top of that, you might want to save the current customization settings of your personalized report. Please visit this article: Memorize reports in QuickBooks Online.

You can always rely on me for additional assistance managing your reports or taxes in QBO. I'll be right there to help you whenever you need it.