Accounts Receivable > Reports >

Monthly Statements

 

         

 

 

Overview

The Monthly Statements report allows you to print Accounts Receivable Statements.

 

This Help page contains the following sections:

Filters and Options

Report

 

 

Filters and Options

On the Filters tab enter the Statement Start Date and End Date. This date range is used for selecting detail to print on the Statement based on the Invoice Date. The End Date of this range is displayed on the Statement as the Statement Date.

 

You can then choose from the following options:

 

Include Statements with Zero Balances

Include Statements with Negative Balances

Include Zero Balance Invoices on Statements

 

A zero balance invoice is an invoice that never becomes an open invoice; it has both positive and negative detail lines that equal zero or detail lines that contain no amounts. Examples of these types of invoices would include a scholarship the church is giving to a person for a seminar they are sponsoring or if an item with a certain monetary value has been given as part of a purchase at the bookstore.

 

Select the Due Date for the statements. You have additional options to narrow down your report:

 

Bill To's

Revenue Centers

Sources

Divisions: There is a filter for each division you have set up in Preferences.

 

On the Options tab select your Statement Design from the drop-down list. This determines what prints on your statements and how they are laid out. You can create and modify statement designs in Modify Statement Design (More Information). Select your Report Options:

 

Print One Statement Per Customer

Include Invoice Distributions and Payments: This includes items, item descriptions, item amounts, and all payments for the invoice.

Email Statements?: Select this check box to send an email statement to each customer that has a valid email address and a phone number. The last 4 digits of the phone number is the security code used to open the attached PDF statement.

 

For Sort By you can select Bill To, Bill To Postal Code, Customer, or Customer Postal Code. The customer options are only available if you are choosing to Print One Statement Per Customer. You can also enter a Message to appear on the statement.

 

 

Report

Click the Run Report button to display a preview of your Monthly Statements report. You may also click the Clear Preferences link to reset all of your report preferences to their initial values. Once the preview displays you can navigate the pages, export to several formats (e.g., PDF, Excel, Word), and Print. Click Report Preferences on the blue bar above the report preview to return to Report Preferences.

 

Click the Close Report button to return to the main Accounts Receivable page.

 

Compiled on 1/24/2018 8:42:27 AM