QuickBooks HelpQuickBooksHelpIntuit

Create and send customer statements in QuickBooks Desktop

by Intuit4 Updated 3 days ago

Learn how to send statements to your customers to show them summaries of their invoices, payments, credits, and balances.

A statement is a summary of your customer's account, listing recent invoices, credit memos, and payments received. A reminder statement can be created and sent to your customers to show how much they owe on each invoice.

Create a billing statement

QuickBooks Desktop for Windows

Note: You can only review up to 4,500 customer records when you create statements. If you have more than 4,500 customers, you'll need to select them manually.

  1. Go to Customers, then select Create Statements.
  2. Choose the appropriate A/R account.
    Note: QuickBooks displays the A/R Account field ONLY when your Chart of Accounts contains more than one A/R.
  3. Check the statement date.
  4. Select the date period of the transactions.
    Note: You can specify the dates, or you can include all open (unpaid) transactions as of the statement date.
  5. Select the customers you want to print statements for.
  6. Select Additional options.
  7. Select Print or E-mail depending on how you want to send the statements to your customers.

QuickBooks Desktop for Mac

  1. Go to Customers, then select Create Statements.
  2. Select the appropriate A/R account for the statement.
  3. Set the Statement Dates.
  4. (Optional) Select the template for the statement.
    Note: If you want to customize your template, select New Template, to open the Layout Designer.
    Choose from the options including adding a Ship To address to your template.
  5. In the Customer section, select the customer you want to print statements for.
  6. Choose additional options.
  7. Select Print or Email depending on how you want to send the statements to your customers.

Creating billing statements is part of your usual A/R workflow in QuickBooks Desktop. To see the complete list of workflows and other customer-related transactions, refer to Accounts Receivable workflows in QuickBooks Desktop.

Note: Statements will automatically include available key details such as the invoice number, due date, original amount, invoice memo, and purchase order number.

If when creating statements the Email button doesn't work (no error message, the email simply does not send), follow the steps below:

  1. Ensure that all preferences are appropriately selected to generate a statement:
    • The appropriate customer is selected
    • The customer should have an invoice or sales receipts within the statement period or before the statement date
    • If the desired customer has a zero balance, under the Do not create statements: the box for with a zero balance should be unchecked
  2. For the Template, select the Intuit Standard Statement.
  3. If the Create One Statement is blank, choose Per Customer or Per Job from the drop-down.
  4. Ensure that the customer has a working email address set up, and that all the email preferences are appropriately chosen:
    1. Select the Edit tab, then choose Preferences.
    2. Select Send Forms.
    3. Check if the email address setup is working, then select OK.
  5. If the emails still fails, the issue may be an overflow error.
    1. Under the , put a check on the box for with a balance less than.
    2. Change the input to 0.00.
    3. Re-send the email.

Note: If the steps above don't resolve your issue, there may be an issue with your email service.

QuickBooks Accountant Desktop PlusQuickBooks Desktop Enterprise DiamondQuickBooks Desktop Enterprise GoldQuickBooks Desktop Enterprise PlatinumQuickBooks Desktop Mac PlusQuickBooks Desktop Premier PlusQuickBooks Desktop Pro Plus

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this