Hi there @userhcurts
I’d be happy to help with your reports. The first thing to check would be the date range. Try broadening the date range and see if the totals match. Next, try opening QBO in a private browser and run the reports. Let's log out and log back in using a private browsing or incognito window. Depending on your browser, here's how:
If you need any further assistance with the reporting or any other issues, please don't hesitate to reach back out.
I had the date range set to 'all dates'. I changed the date range to custom to suit my needs better, but no change. I tried running the report in incognito mode and there is no change. The balances are still incorrect.
I have a few filters in place - transaction type, customer type, and A/R paid.
I'm in need of a report that shows the customer balance by customer type. We previously used desktop and this report was quick and easy to run.
I appreciate you for getting back and sharing more details here in the Community. Let me help you run the report you need in QuickBooks Online.
I've read the thread starting from the top and found out that you're running the Sales by Customer report. Since you want the payments and credit memos to reflect, I recommend using Customer Balance Detail.
You can customize the filter and set the A/R Paid to All. This way, it'll show all related transactions under each customer.
For additional reference, you can use the following article to learn more about how you can get the most out of your financial reports: Customize reports in QuickBooks Online.
Keep us posted if you need anything else regarding the setup. Have a great day.
Hi there, userhcurts.
I can help you with running this report.
Please know that the Sales by Customer Type Detail report will show credit memo and partial payments you've received from your customers. It also provides you the unit and sales amounts for each customer type and lists the transactions that contributed to each total.
To ensure that this report will reflect the partial payments and the actual balances of your customer, you'll need to set Cash as the Accounting method. I'll show you how to do it:
Take look at my screenshot below to know how the cash and accrual basis affect the customer's balance:
You'll also want to memorize this report to save its current customization settings. Additionally, I encourage reading this article to help streamline the reporting process in QuickBooks Online: Customize reports.
You can always find me here if you have any concerns or further questions about how reports work in QuickBooks Online. Have a pleasant day ahead.