cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
usert-umair
Level 1

I want to know, is it possible if we can in customer estimate report, deal value and payment together to have balance amount

 
3 Comments 3
JenoP
Moderator

I want to know, is it possible if we can in customer estimate report, deal value and payment together to have balance amount

Hi there, usert-umair.

 

If you're using Progress Invoicing, you can run the Estimates and Progress Invoicing Summary By Customer report. This report has a column for the amount of the estimate, how much was invoiced, and the remaining balance. Here's how:

 

  1. Go to the Reports menu and type in the name of the report in the Search bar.
  2. Click Customise in the right hand corner then go to the Rows/Columns
  3. Make sure to check the Amount, Invoiced Amount, % Invoiced, and Balance boxes.
  4. Click Run report.

However, this report will not show the payments that are applied to the invoices. You can run the Invoices and Received Payments reports separately to see the list of payments for each invoice. Just go back to the Reports menu and type in the name of the report in the Search bar again.

 

I'd also like to share these articles with you about running and managing reports in QBO:

 

The Community is always here if you need anything else. 

 

estimate report.PNGestimate report2.PNG

SAMEH EWIS
Level 2

I want to know, is it possible if we can in customer estimate report, deal value and payment together to have balance amount

Invoiced Amount, % Invoicedand Balance boxes. Not available

I'm using QBO Plus Saudi Arabia Country Version

03.JPG04.JPG

Adrian_A
Moderator

I want to know, is it possible if we can in customer estimate report, deal value and payment together to have balance amount

Thanks for the screenshot, SAMEH EWIS. It gives me a visual representation of your concern.

 

The reports on QuickBooks Online depends on the region and the subscription level. The one that's provided by my colleague which is the Estimates and Progress Invoicing Summary By Customer report isn't available on the Saudi Arabia version. However, I have a workaround that you may want to consider.

 

You can open the Estimate by Customer report and export it to an Excel file. From there, you can manually calculate invoiced amount, percent invoiced, and the balance. Here's how to export it:

 

  1. Click the Reports tab.
  2. Enter and select Estimate by Customer.
  3. Click the Customise button.
  4. Filter the Report period.
  5. Click the Filter drop-down.
  6. Tick the Amount box.
  7. Click Run report.
  8. Click the Export button and then select Export to Excel.

 

Feel free to bookmark these references as your guide in managing reports:

 

 

I'm just a post-away if there's anything that I can help with. Keep safe!