Skip to main content
T
tkirkendall
January 31, 2022
Solved

Creating a customer statement with a total amount billed for a fiscal year to include a total amount received.

  • January 31, 2022
  • 1 reply
  • 0 views
We need to provide customer's with a statement detailing a total amount they have been invoiced during a fiscal year. The statement also needs to show a total amount they have paid. Example: Customer Z was billed $1,280.00 from July through October for various services. Total amount of payments received towards these services was $950.00. Leaving a balance due of $330.00. I need to be able to create a statement for each individual customer that reflects this information.
Best answer by MonicaM3

Hello @tkirkendall

 

Happy Monday! Has January gone as quickly for you as it has for me?

 

I see that you’re looking for a detailed Customer transaction report. I can help you with that.

 

In QuickBooks Online, the Transaction list by Customer is the best report for what you’re looking for. You can customize it for the dates you need to reflect your Fiscal year.

 

In the Reports menu:

  1. Locate Sales & Customers then choose Transaction List by Customer.
  2. Click Customize report.
  3. Enter a date range.
  4. In the Filter drop-down, select the Customer name.
  5. Click Run Report.

 

You’ll repeat the process for each customer. If this is a report you’ll send every year, you can Save customization.

 

You can also customize reports to export to a PDF as well.

 

Feel free to let me know if you have any additional questions about reports or anything else. I’m here to help any time!

1 reply

MonicaM3
MonicaM3Answer
January 31, 2022

Hello @tkirkendall

 

Happy Monday! Has January gone as quickly for you as it has for me?

 

I see that you’re looking for a detailed Customer transaction report. I can help you with that.

 

In QuickBooks Online, the Transaction list by Customer is the best report for what you’re looking for. You can customize it for the dates you need to reflect your Fiscal year.

 

In the Reports menu:

  1. Locate Sales & Customers then choose Transaction List by Customer.
  2. Click Customize report.
  3. Enter a date range.
  4. In the Filter drop-down, select the Customer name.
  5. Click Run Report.

 

You’ll repeat the process for each customer. If this is a report you’ll send every year, you can Save customization.

 

You can also customize reports to export to a PDF as well.

 

Feel free to let me know if you have any additional questions about reports or anything else. I’m here to help any time!

    Terms & ConditionsAccessibility statement