Sending customer statements is easy and flexible. Navigate to Menu > Accts Receivable > Invoices, then use the Quick Search bar to locate the records you want to work with. (Note: Customer statements are built using open invoices; if a customer has no balance / no open invoices, then a statement will not be sent to that customer.)
After you have a list of customers who need statements, there are several options for sending them out.
Note: Some of the following features use email functionality, which requires that your system administrator enable and configure integration with Mailgun.
Invoice Detail View Options
Print > Print Customer Statement
Generates a printout listing all the current customer’s invoices that are in Open status (not including adjustments). The Aging table on the printout is calculated by days past due.
You can print the statement or save it to PDF.
Print > Email Customer Statement
Generates a PDF listing all the current customer’s invoices that are in Open status, then opens your mail client, creating a new email with the following information:
- To: Populated with the first available data, as follows:
- A/P Contact email address — from the Bill To company record, Customer Details tab, Billing Setup section
- Invoice Contact email address — from the Bill To section's contact record
- If both these fields are blank, then you must manually enter an address.
- CC: If the A/P Contact email was used for the To: field, then the Invoice Contact email address (if available) is populated here; otherwise, the field is left blank.
- BCC: Your aACE system email address (if available). This ensures a copy of this initial message is stored in aACE. If your system is not configured with integrated email, the field is left blank.
- Subject: Statement
- Body:
Dear [A/P Contact name or Invoice Contact name],
Statement is attached.
Sincerely, [Your name]
Tags corresponding to the referenced Invoice Record IDs (e.g. “[INV12345]”). When you have an email showing a final resolution to the matter, you can forward it to your aACE system email address and this tag will identify which record to attach the email to.
- Attachment: A PDF of the statement
Invoice List View Options
From the list view, aACE only addresses records currently displayed in the list. It does not generate statements including all of a customer’s open invoices. These options allow you to select and exclude invoices, organizing the printout as needed. Use the Quick Search bar to organize a list of customers who need to receive a copy of their statement.
Print > Print Customer Statements in List
Generates a batch printout of customer statements, including only the invoices currently displayed in the list, separated by customer.
After generating the printout, you can use the Print screen navigation to review each invoice page, print the statements, or save them to PDF.
Print > Auto-Email Customer Statements in List
Emails a batch of customer statements.
When you trigger this process, aACE first filters your current found set to only include invoices that are in Open status. Then each customer statement is emailed with the following content:
- To: Populated with the first available data, as follows:
- A/P Contact email address — from the Bill To company record, Customer Details tab, Billing Setup section
- Invoice Contact email address — from the Bill To section's contact record
- If both these fields are blank, then the invoice is left in To Be Sent status for you to update or send manually.
- From: Populated with the email address you assign (Menu > System Admin > Preferences > My aACE > Auto-Email Invoices and Client Statements From). This address may be a general account (e.g. “ar@yourdomain.com”), so anybody in the A/R department can send statements and view any replies.
- BCC: Populated with your email address from your Team Member record, if you have marked the BCC self flag next to Auto-Email Invoices and Client Statements From.
- Subject: “Statement”
- Body:
Dear [A/P Contact name or Invoice Contact name],
Statement is attached.
Sincerely, [Your name]
- Attachment: A PDF of the customer statement and each invoice referenced in the statement. (Note: This is the only process for customer statements that automatically includes an invoice; all others only include the statement.)
The resulting found set will show any invoices that are open, but do not have an email address specified. Statements for these records must either be sent separately via regular mail or else the invoices must be corrected for inclusion in another batch. "Correcting" the invoices means adding an A/P Contact email address. (Note: This is because open invoices cannot be edited to add a Contact email.)
Print > Deliver Customer Statements in List
Prepares a batch of statements for both email and regular mail delivery.
The setting that controls the delivery method for a given statement is found on the Bill To company record. On the Customer Details tab, the Billing Setup section includes the Deliver Invoice Via field, where you can specify either "Email" or "Mail". (Note: This setting also applies to both invoices and orders.)
When you trigger this process, aACE filters your current found set to Open invoices. Each statement for a customer configured to Email delivery is emailed, using the content explained in "Auto-Email Customer Statements in List" above. Then those records are omitted from your found set. Statements for customers that are configured to Mail delivery (if any) are left remaining. aACE prompts you to generate a printout for these remaining statements.