How to Create a Customer Statement in QuickBooks Desktop

In this blog post, you’ll learn how to create a customer statement in QuickBooks Desktop.

For this example, I’m using QuickBooks Premier 2022. 

Quick Instructions:

  1. In the top menu, click Customers -> Create Statements…
  2. Enter a Statement Date
  3. Select a Statement Period date range
  4. Under SELECT CUSTOMERS select One Customer
  5. Find your customer in the drop-down list
  6. Click Print to print out a copy to mail. Or, click E-mail to e-mail a copy of the statement to your customer

Keep reading for a complete walkthrough with screenshots:

Why Create a Statement?

Let’s look at an example of when you might need to create a statement.

Below is a list of transactions from my make-believe customer “Sally The Customer.”

Example of a customer in QuickBooks Desktop with several invoices and payments including a prepayment.

On 11/25/22, Sally prepaid $750. 

On 11/30/22, Sally was invoiced for $1,250, but she only owes $500 because she already paid $750.

Here’s what the invoice looks like with the prepayment applied:

QuickBooks Desktop invoice with a prepayment applied.

Sally may see this invoice and ask for a list of her invoices and payments that led up to her owing $500. To do that, we create a statement.

Create a Customer Statement

To create a statement for a customer, click Customers in the top menu. Then click Create Statements…

Create statements in the main menu in QuickBooks Desktop.

Enter a Statement Date. Select a Statement Period date range.

Under SELECT CUSTOMERS, select One Customer and find your customer from the drop-down.

Click Preview to see what the invoice will look like before sending. 

Create a statement for a single customer in QuickBooks Desktop.

Previewing is a good way to double-check that you’re sending the customer the requested information. Here’s the preview of my statement for Sally the Customer:

Preview of a customer statement in QuickBooks Desktop

The statement shows a running balance on the right and the amount due at the bottom. Sally can now see how she came to owe me $500. 

Click Close to return to the Create Statement screen.

You can click Print to print out a copy to mail. Or click E-mail to e-mail a copy of the statement to your customer.

Edit the Statement Template

You may have noticed that the statement preview above is incredibly boring. 

You can edit the template to fit the look of your business. 

To do this, click Lists in the top menu and select Templates.

Navigating to Templates in the QuickBooks Desktop main menu.

On the Templates screen, click the Templates menu at the bottom and select New.

Create a new template in QuickBooks Desktop.

Then select Statement and click OK.

Create a new template in QuickBooks Desktop

You can edit this new template in any way you like without messing up the default template.

You can change colors, add or remove information, and even add a logo. There are all kinds of fun ways you can spruce up your templates.

You now know how to create a customer statement in QuickBooks Desktop.

☕ If you found this helpful, you can say “thanks” by buying me a coffee… https://www.buymeacoffee.com/gentlefrog

Below is a video if you prefer to watch a walkthrough.

If you have questions about statements in QuickBooks Desktop, click the green button below to schedule a free consultation.

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

2 Responses

  1. I’m using QuickBooks Desktop Pro 2023
    I select the all open transactions to statement date, and I select the customer for whom I need the statement.
    When I click on the Preview button or the Print button nothing happens.
    If I click on the email button I get a warning box saying no statements have been created .
    Any insights would be appreciated

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

Why You Shouldn’t Use a Refund Receipt for NSF Checks in QuickBooks

Learn the proper way to record an NSF check in QuickBooks Online.

How to Fix Duplicate Bill and Expense Entries in QuickBooks Online

Learn what to do if you have a bill and expense for the same transaction in QuickBooks Online.

How to Add and Edit a Receipt in QuickBooks Online

Learn how to add and edit a receipt in QuickBooks Online that you uploaded with the mobile app or within QBO.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.