{"id":1001148,"date":"2018-04-26T13:08:25","date_gmt":"2018-04-26T17:08:25","guid":{"rendered":"http:\/\/blog.bmcgiverncpa.com\/?p=1001148"},"modified":"2020-01-22T04:10:34","modified_gmt":"2020-01-22T04:10:34","slug":"creating-customer-statements-in-quickbooks","status":"publish","type":"post","link":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/2018\/04\/26\/creating-customer-statements-in-quickbooks\/","title":{"rendered":"Creating Customer Statements in QuickBooks"},"content":{"rendered":"<p><em>Invoices not being paid promptly? Customers questioning their payment history? Create statements.<\/em><\/p>\n<p>Let\u2019s say you have a regular customer who used to pay on time, but he\u2019s been hit-and-miss lately. How do you get him caught up?<\/p>\n<p>Or, one of your customers thinks she\u2019s paid you more than she owes. How do you straighten out this account?<\/p>\n<p>Both of these situations have a similar solution. QuickBooks\u2019 statements provide an overview of every transaction that has occurred between you and individual customers during a specified period of time. They\u2019re easy to create, easy to understand, and can be effective at resolving payment disputes.<\/p>\n<p><strong>A Simple Process<\/strong><\/p>\n<p>Here\u2019s how they work. Click <strong>Statements <\/strong>on the home page, or open the <strong>Customers <\/strong>menu and select <strong>Create Statements<\/strong>. A<!--more--> window like this will open:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-1001149\" src=\"http:\/\/www.bmcgiverncpa.com\/wp-content\/uploads\/2018\/03\/QBC-1017-image-1_preview.jpeg\" alt=\"\" width=\"746\" height=\"420\" srcset=\"https:\/\/www.bmcgiverncpa.com\/blog\/wp-content\/uploads\/2018\/03\/QBC-1017-image-1_preview.jpeg 746w, https:\/\/www.bmcgiverncpa.com\/blog\/wp-content\/uploads\/2018\/03\/QBC-1017-image-1_preview-300x169.jpeg 300w\" sizes=\"(max-width: 746px) 100vw, 746px\" \/><\/p>\n<p style=\"text-align: center;\"><em>QuickBooks provides multiple options on this screen so you create the statement(s) you need.<\/em><\/p>\n<p>First, make sure the <strong>Statement Date <\/strong>is correct, so your statement captures the precise set of transactions you want. Next, you have to tell QuickBooks what that set is. Should the statement(s) include transactions <u>only<\/u> within a specific date range? If so, click the button in front of <strong>Statement Period From<\/strong>, and enter that period\u2019s beginning and ending dates by clicking on the calendar graphic. If you\u2019d rather, you can include all <u>open<\/u> transactions by clicking on the button in front of that option. As you can see in the screen shot above, you can choose to <strong>Include only transactions over <\/strong>a specified number of <strong>days past due date<\/strong>.<\/p>\n<p><strong>Choosing Customers<\/strong><\/p>\n<p>Now you have to tell QuickBooks which customers you want to include in this statement run. Your options here are:<\/p>\n<ul>\n<li><strong>All Customers<\/strong>.<\/li>\n<li><strong>Multiple Customers<\/strong>. When you click on this choice, QuickBooks displays a <strong>Choose <\/strong> Click on it, and your customer list opens in a new window. Click on your selections there to create a check mark. Click <strong>OK <\/strong>to return to the previous window.<\/li>\n<li><strong>One Customer<\/strong>. QuickBooks displays a drop-down menu. Click the arrow on the right side of the box, and choose the correct one from the list that opens.<\/li>\n<li><strong>Customers of Type<\/strong>. Again, a drop-down list appears, but this one contains a list of the <strong>Customer Types<\/strong> you created to filter your customer list, like <strong>Commercial <\/strong>and <strong>Residential<\/strong>. You would have assigned one of these to customers when you were entering data in their QuickBooks records (click the <strong>Additional Info<\/strong> tab in a record to view).<\/li>\n<li><strong>Preferred Send Method<\/strong>. <strong>E-mail <\/strong>or <strong>Mail<\/strong>?<\/li>\n<\/ul>\n<p><strong>Miscellaneous Options<\/strong><\/p>\n<p>At the top of the right column, you can select a different <strong>Template <\/strong>if you\u2019d like, or <strong>Customize <\/strong>an existing one. Not familiar with the options you have to change the layout and content of forms in QuickBooks? We can introduce you to the possibilities.<\/p>\n<p>Below that, you can opt to <strong>Create One Statement <\/strong>either <strong>Per Customer <\/strong>or <strong>Per Job<\/strong>. The rest of the choices here are pretty self-explanatory \u2013 except for <strong>Assess Finance Charges<\/strong>. If you\u2019ve never done this, we strongly recommend that you let us work with you on this complex process.<\/p>\n<p>When you\u2019re satisfied with the options you\u2019ve selected in this window, click the <strong>Preview <\/strong>button in the lower left corner of the window (not pictured here). QuickBooks will prepare all the statements in the background, then display the first one. You can click <strong>Next <\/strong>to view them one by one. At the bottom of each, you\u2019ll see a summary of how much is due in each aging period, like this:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-1001150\" src=\"http:\/\/www.bmcgiverncpa.com\/wp-content\/uploads\/2018\/03\/QBC-1017-image-2_preview.jpeg\" alt=\"\" width=\"713\" height=\"116\" srcset=\"https:\/\/www.bmcgiverncpa.com\/blog\/wp-content\/uploads\/2018\/03\/QBC-1017-image-2_preview.jpeg 713w, https:\/\/www.bmcgiverncpa.com\/blog\/wp-content\/uploads\/2018\/03\/QBC-1017-image-2_preview-300x49.jpeg 300w\" sizes=\"(max-width: 713px) 100vw, 713px\" \/><\/p>\n<p style=\"text-align: center;\"><em>It\u2019s easy to see how much each customer is past due within each aging period. This summary appears at the bottom of statements.<\/em><\/p>\n<p>After you\u2019ve checked all the statements, click the <strong>Print <\/strong>or <strong>E-mail <\/strong>button at the bottom of the window.<\/p>\n<p><strong>Other Avenues<\/strong><\/p>\n<p>Your company\u2019s 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, give us a call. We can work together to identify the trouble spots and get you on the road to recovery.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Invoices not being paid promptly? Customers questioning their payment history? Create statements. Let\u2019s say you have a regular customer who used to pay on time, but he\u2019s been hit-and-miss lately. How do you get him caught up? Or, one of your customers thinks she\u2019s paid you more than she owes. How do you straighten out [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[64],"tags":[61,40,62,63,65],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1001148"}],"collection":[{"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=1001148"}],"version-history":[{"count":1,"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1001148\/revisions"}],"predecessor-version":[{"id":1001221,"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1001148\/revisions\/1001221"}],"wp:attachment":[{"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=1001148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=1001148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=1001148"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/yst_prominent_words?post=1001148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}