QuickBooks Tips > Efficiency Tips > Creating Customer Statements in QuickBooks
Creating Customer Statements in QuickBooks
Let’s say you have a regular customer who used to pay on time, but he’s been hit-and-miss lately. How do you get him caught up?
Or, one of your customers thinks she’s paid you more than she owes. How do you straighten out this account?
Both of these situations have a similar solution: QuickBooks Statements. QuickBooks’ statements provide an overview of every transaction that has occurred between you and individual customers during a specified period of time. They’re easy to create, easy to understand, and can be effective at resolving payment disputes.
A Simple Process
Here’s how they work. Click Statements on the home page, or open the Customers menu and select Create Statements. A window like this will open:
First, make sure the Statement Date is correct, so that your statement captures the precise set of transactions that you want. Next, you will need to tell QuickBooks what that set is. Should the statement(s) include transactions onlywithin a specific date range? If so, then click the button in front of Statement Period From, and enter that period’s beginning and ending dates by clicking on the calendar graphic. If you would rather, you can include all opentransactions by clicking on the button in front of that option. As you can see in the screen shot above, you can choose to Include only transactions over a specified number of days past due date.
Now, you need to tell QuickBooks which customers you want to include in this statement run. Your options here are:
At the top of the right column, you can select a different Template if you would like, or Customize an existing one. Not familiar with the options you have to change the layout and content of forms in QuickBooks? Let one of our QuickBooks experts introduce you to the possibilities.
Below that, you can opt to Create One Statement either Per Customer or Per Job. The rest of the choices here are pretty self-explanatory–except for Assess Finance Charges. If you have never done this, then it may be helpful to call the office and arrange for a QuickBooks pro to work with you on this complex process.
When you are satisfied with the options that you have selected in this window, click the Preview button in the lower left corner of the window (not pictured here). QuickBooks will then prepare all the statements in the background, and display the first one. Click Next to view them one by one. At the bottom of each, you will see a summary of how much is due in each aging period, like this:
After you have checked all the statements, click the Print or E-mail button at the bottom of the window.
Your company’s cash flow depends on the timely payment of invoices. Sending statements is only one way to encourage your customers to catch up on their past due accounts. There are many others, like opening a merchant account so customers can pay you online with a bank card or electronic check. If poor cash flow is threatening the health of your business, a QuickBooks professional can help.
Creating Customer Statementsjhbadmin2018-09-04T12:41:13+00:00