Skip to main content
G
gc527
November 1, 2022
Solved

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

  • November 1, 2022
  • 1 reply
  • 0 views

We recently migrated to QBO from the desktop version and we have had a lot of difficulties finding a report that provides us credits, debits, and open balance that looks exactly like the transaction list in the customer section of QBO.

 

We want to be able to create a report that tells us exactly how much each customer has paid, how much they owe for particular period of time.  The reports that we get from QBO do not give us an accurate view as they balance out credits and debits and the journal report does not provide us dates for all records.  The transaction report gives us a 0 balance for each customer.

 

it is really frustrating not being able to find a report with the customer transaction detail that we can manipulate and that will give us all transactions without balancing credits to debits equal 0.

Best answer by Daniela_A

Hi there, @gc527.

 

Thanks for getting back on this thread. Allow me to share another way to run a specific report.

 

I know a report where you can review the invoices without any duplication. We can run and customize it to see the desired details. Here's how:

 

  1. Go to Reports on the left panel.
  2. In the Search box, enter "Invoice list".
  3. Tap Invoice list.

       

To customize the report, follow these steps:

 

        1. Click Customize.

 

 

        2. Under the Filter dropdown, select A/R and change to Paid.

 

 

        3. Hit Run report.

 

You can also check this video article as your guide in making a modified report: Customize your reports in QuickBooks Online.

 

In addition, feel free to browse the following articles to learn about how to print, export, and email different reports available in your subscription:  

 

 

Feel free to post again if you have further concerns running your reports. Have a great day ahead.

1 reply

G
GlinetteC
November 1, 2022

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.

G
gc527Author
November 2, 2022

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?

J
jamespaul
November 2, 2022

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. 

Terms & ConditionsAccessibility statement