Combo Statement Style Alternate 3

For new customers, current statements do not meet company needs and federal guidelines for consumer statements.

Setup

Combo Statement Style Alternate 3 is available in the Statement Defaults section found at Accounting / Setup / Preferences / A/R.  

1. Select Alternate 3 in the Combo Statement drop-down menu.
2. After the Alternate 3 style has been chosen, go to Accounting Reports / Accounts Receivable / A/R Status / Combo Statement.
3. On this screen, choose Setup in the middle section toward the bottom of the window. 
4. From here, key in or choose the Start Date for the Statement.
   
5. Expand the drop-down menu by Legal Verbiage and select the appropriate item.
   Note: To set up Legal Verbiage, go to Accounting / Setup / A/R / Legal Verbiage for Statements and select Add.  Key in a Name and, in the area below the Name field, type the legal verbiage or copy and paste.  Optionally highlight text and select Font to choose the Font, Font Style, Size, Effects, and Script.  If opting to copy and paste, formatting will carry over.  When finished, select Save.
    
6. Optionally mark Print logo of customer’s location to print the logo from the customer’s location rather than the location logged into when creating the statement.
7. Select Prod. Class to open the Classifications window.
8. Double-click the <Classifications> heading to open the Select Product Classification Window and choose any applicable Classification(s) and select Done.  These classifications will appear in the Classifications window.
   
9. Expand the drop-down menu and choose from Include if ANY are true, Include if ALL are true, Include if ANY are false, and Include if ALL are false then choose Done.
10. Prod. Class will display red if Classifications have been chosen.
11. Optionally Suppress Remittance Barcode,  Include Current Purchase Summary, and/or Include Net due if paid by. 
    • The Current Purchase Summary will display on the cover page of the statement. This includes a Sales Group recap of the Invoices for the customer for the current fiscal month. The Department Sales Class is used to group dollar amounts.
    • The Include Net due if paid by option will print the net due in the statement header return label as well as the cover page.
12. Choose OK.
13. Select any other applicable criteria on the A/R Status Reports window and select OK.

Report Printout

The Alt3 style is most like the Standard Combo Statement with Condensed Headers but includes a Cover Page.

This page includes:

Remittance Stub

• Left Side
  1. The logo prints in the top left if Print logo of customer’s location is selected in the Combo Statement report criteria under Setup rather than the global location. If no logo exists at Setup / Location Preferences / Logo, the Location Address of the logged in location or the statement preference to print a Location Address rather than the customer’s location.
  2. The Customer name and address print below the logo in Arial with a font size of 9 pt.
  3. The Customer bar code prints below the Customer name and address.
     Note: This bar code is the Customer ID and can be scanned when adding a Payment on Account in Agvance to select that customer. The Select Customer window must be sorted by Cust ID and the cursor needs to be in the Cust ID field at the bottom. On the Filter tab, the Location needs to be set to All. If it is not and the customer is from a Location other than the one selected on the Filter tab, a different customer may be selected with a similar ID.
• Right Side
  1. The page number, Customer Statement label, and Customer ID display.
  2. Total Regular Due – This is the total regular due by that date excluding deferred and budget balances.
  3. Budget Amount Due by – This uses the Budget Billing label from Accounting / Setup / Preferences / A/R. No label is printed if the customer has no Budget Balance due.
  4. Total Due by – This is the total of Regular and Budget balances. This line will not print if there is no Budget amount due (if the label from Budget Amount Due did not print).
  5. An area to indicate the Amount Enclosed and the Remit To information is displayed. The Location name and address prints below the Remit To label. This follows the statement preference to print the logo of the customer’s location rather than location logged into when statements are generated. Location information is printed based on that setting. The location’s Remit To address is used if populated. If not, the location address from the Location Profile tab is used.
• Account Activity Summary
  1. Dates – The first date comes from Combo Statement report criteria by entering a Start Date after selecting Setup. The second date comes from the Statement/Aging date in the Combo Statement report criteria.
  2. Previous Balance – This is the customer’s prior month ending regular balance.
  3. Payments – This is the total of payments made on the regular balance for the current fiscal month.
  4. Other Credit – This is the total current fiscal month Invoices where the overall total is a credit amount.
  5. Purchases – This includes current fiscal month Invoices excluding the most recent Finance Charge Invoice and Fee Charges.
  6. Prepayments Applied - This is Prepay used on Invoices in the current fiscal month.
  7. Fees Charged – This is the total of products purchased in the current fiscal month based on Fees and Product Classification on the Combo Statement report criteria under Setup.
     • The Classification is optional and could include products like NSF charges, Late Fees, Warehouse Storage, etc. This depends on the company’s definition of Fees.
  8. Current Interest Charge – This is the most recent Finance Charge Invoice in the current month.
     • If Finance Charges are posted more than one time during the month, only the most recent based on transaction date and time is included here. The first Finance Charge Invoice would be included in Purchases.
  9. Account Balance – This is the sum of 2 - 8.
  10. Less Future Due – This is the sum of Invoices due after the Due Date from the Combo Statement report criteria.
  11. Level Pay Due – This is the sum of all unpaid Budget Memo Invoices. The Budget Billing Label is printed from Accounting / Setup / Preferences / A/R. The label does not print if the customer has no budget billing.
  12. Total Amount due by XXXX – This is the sum of 9 - 11.
• Balance subject to Interest charges – The amount that displays is the balance when the current month Finance Charge Invoice was posted.
  1. Previous Interest Charges – This is the sum of unpaid Finance Charge Invoices from prior months.
     • If Finance Charges are posted more than once during the month, this amount also includes the unpaid balance of the oldest Finance Charge Invoices from the current fiscal month.
  2. Current Interest Charge – This is the unpaid Finance Charge Invoice from the current fiscal month.
     • If Finance Charges are posted more than once during the month, only the newest Invoice’s unpaid amount is displayed here. This is based on the transaction date and time of the Invoice.
• Prepay Summary
  1. Previous Prepay Balance – This is the Prepay Balance from the end of the prior fiscal month.
  2. Prepay Received – This is the total of new Prepay received in the current fiscal month.
  3. Prepay Applied – This is the total of Prepay money applied to current month Invoices.
  4. Prepay Balance – This is the sum of 1 and 2 minus 3.
• Budget Billing Summary
  1. Budget Balance – This is the current Budget Balance. This section does not print if there is no Budget Balance.
     • If the current balance displays in Agvance as a negative, Budget Billing payments have not kept up with Budget Invoices. The balance on the statement should be a positive amount.
     • If the current balance displays as a positive in Agvance, Budget Billing payments have exceeded Budget Invoices. The balance on the statement should be a negative amount.
• Statement Terms – These should print across the right side of the Cover Page directly below the Remittance Stub and are set up at Accounting / Setup / Preferences / A/R / Statement Defaults.
  1. A new Terms selection is enabled to enter terms. Old Statement Terms are not used.
• Account Aging Summary – This section prints the aging buckets and corresponding balance in each bucket.
• Future Due Summary – This label follows the company setting at Accounting / Setup / Preferences / A/R / Aging Configuration. If this setting is blank, Future Due Summary is printed. This section prints a list of future due dates, based on Invoice due date, and the unpaid portion of those future due Invoices. This section does not print if there are no future due Invoices.
  1. Seven lines with dates and unpaid portion totals of the Invoices due on those dates are printed.
  2. If not all dates fit in the seven lines, an 8th Additional Dates line is printed and the total unpaid portion of Invoices due on the rest of the future dates.
• Terms and Conditions – These optionally print at the end of the statement and are set up at Accounting / Setup / A/R / Legal Verbiage for Statements.