3 - Accounts Receivable Reports

Customer Address List (Report # 3-1)

Customer List (Report # 3-2)

Customer Phone List (Report # 3-3)

Customer Types (Report # 3-4)

Multi-Code Sales Tax (Report # 3-5)

Quote Prices (Report # 3-6)

Shipping Labels From Orders (Report # 3-7)

Open Orders By Customers (Report # 3-8)

Customer Open Invoices (Report # 3-9)

Customer Order List (Report # 3-10)

Customer Invoice Ledger (Report # 3-11)

Customer Aged Trial Balance (Report # 3-12)

Customer Invoices on Plain Paper (Report # 3-13)

Customer Payment Ledger (Report # 3-14)

Customer Current Activity (Report # 3-15)

Customer Total Summary (Report # 3-16)

Shipping Info. By Customer (Report # 3-17)

Deposit Ticket (Report # 3-18)

Inventory Sold By G/L# (Report # 3-19)

Generate Finance Charges (Report # 3-20)

Packing List on Plain Paper (Report # 3-21)

Customer Invoice Payments (Report # 3-23)

Customer Orders Without Prices (Report # 3-24)

Customer Back-orders (Report # 3-25)

Customer Review (Report # 3-26)

A/R Sales By G/L # (Report # 3-27)

A/R Sales Journal by Invoice Number (Report # 3-28)

Count Customer Types (Report # 3-29)

Customer Address Labels (Report # 3-30)

Statements on Plain Paper (Report # 3-31)

Generate Invoices From Orders (Report # 3-32)

Customer Payments (Report # 3-33)

Sorted A/R Reports (Report # 3-34)

Customer Orders With Prices (Report # 3-35)

Statements on Nebs 9060 (Report # 3-36)

Cash Deposits By G/L# (Report # 3-37)

Customer Invoices on Forms 9040 (Report # 3-38)

Sales Tax Payable (Report # 3-39)

Salesperson List (Report # 3-40)

A/R Balancing (Report # 3-41)

Calculate Salesman Comission

Customer Address List (Report # 3-1)
This is a wide report that prints customer codes, names, addresses, and phone numbers. It may be printed for a certain customer type, or for only those customers who have activity after the date entered.

You first need to choose if you want the report sorted by customer, salesman, type, or zipcode.

Customer List (Report # 3-2)
This report allows you to specify if you want the Customer Codes & Names printed in a 1, 2, or 3-column format.

The computer asks "Do you want condensed print?" if you choose 3-column format.

Customer Phone List (Report # 3-3)
This report prints the customer names and phone numbers as set up in the Customer file (C).

The names and phone numbers are listed in two columns.

Customer Types (Report # 3-4)
This prints a list of the Customer Types and their Privileges as entered in the Customer Type file (Y).

Multi-Code Sales Tax (Report # 3-5)
This report calculates taxable and nontaxable sales, and the tax amount for one or more tax codes.

When you run the report, you have the option of a 4-column report or a wide 9-column report. You can specify starting and ending invoice dates. The invoices included in the report are those that are within the set of reference numbers and within the dates specified.

The report lists Invoice #, date and customer name. The Report totals are at the top of the report. This is so you don't have to print the whole report in order to see the totals.

The report shows Net Sales and Total Tax in the first column. In each of the following columns are shown Non-Taxable Sales, Taxable Sales, Net Sales, and the Tax Amount, one tax code per column. Net Sales is total sales excluding tax.

Invoices that have no Tax code specified will show up in a "?" column.

For information on how to set up various tax codes see <Multiple Tax Codes> in your manual. Or press M to see the same information on the screen.

Quote Prices (Report # 3-6)
This prints the list of quoted prices from the Quoted Prices file (Q), listing the customers in alphabetical order followed by the items and prices that have been quoted to them.

Shipping Labels From Orders (Report # 3-7)
This report works with Quantity/Label on the Inventory file (I). It takes the amount in Qty/Label to determine how many packages are needed to ship the orders on file.

A label is printed for each package or part package.

Open Orders By Customers (Report # 3-8)
This report prints a list of the open orders sorted alphabetically by customer Code.

Customer Open Invoices (Report # 3-9)
This report lists open invoices for each customer. This may be sorted by Customer, Salesman, or Customer Type.

Customer Order List (Report # 3-10)
This report prints a list of customer orders, listed numerically by Order #.

Customer Invoice Ledger (Report # 3-11)
This is a list of invoices in numerical order, with a total at the end. Use this report to get a sales total for a sequence of invoices; for example, to find the total sales for the day or the month. To get a summary, select the report by entering 11S from the 3 screen. The report will print only the total without listing the whole sequence of invoices.

The computer asks for Beginning and Ending customer Type. If you have the Enhanced Version of ABC Accounting, you can choose to list only the invoices of customers of a certain type, otherwise, simply press twice.

Customer Aged Trial Balance (Report # 3-12)
This is a report that lists open invoices for each customer, with amounts arranged in columns by age. Age is determined by subtracting the invoice date from the report date. A total aging appears at the end of the report.

You first need to choose to sort the report by customer, salesman or type (Customer Type is part of the Enhanced package.) You also have the option of choosing a one-line format (one line per customer), or the detailed format which lists each open invoice by customer.

This report checks the total of the open invoices and the non-invoice amount against the customer balance. If they are equal the customer is in balance. If an asterisk (*) appears to the left of a customer balance, it indicates that particular customer is out of balance. When this happens, there will also be an asterisk at the end of the

report, with the words OUT OF BALANCE and the pages which have the out-of-balance customers. If there are no asterisks on the report, the computer will print, REPORT IN BALANCE.

CAUTION! When an Aging Cutoff Date is used which is earlier than the current date and payments were made after that date, the computer will indicate that the report is out of balance. This is because the computer lists payments entered after the cut-off date but not invoices, but the BALANCE at the end of the report includes ALL invoices and payments.

Setting the Overdue Invoice Date determines which customers will be listed. Any customers who only have open invoices after that date will not be reported. Any customers who have one or more invoices on or before that date will be reported.

Customer Invoices on Plain Paper (Report # 3-13)
This report prints actual invoices on regular 8 1/2" x 11" paper, in numerical order. To print on company letterhead paper, enter a "Y" in Omit Company Heading on the System Setup Screen 2 (&).

On taxable invoices, a "T" is printed beside each taxable amount. The total taxable amount is printed on the sales tax line.

Customer Payment Ledger (Report # 3-14)
This is a list of payments in numerical order, with a total at the end. It also totals wherever there is a deposit record with a Y in Deposit Total. It may be printed for only a particular G/L Ledger # when Ledger numbers are entered on the Deposit screen (D). At the end of an accounting period the report will post the transactions to the G/L account if you enter a "P" when asked if posting is desired. The proper starting and ending Deposit # must be entered for the period.

To get a summary, select the report by entering 14S from the 3 screen. The report will print only the total without listing the whole sequence of payments.

Customer Current Activity (Report # 3-15)
This report prints a listing of each customer's activity for the current month. This report shows each customer's Prior Balance, Current Sales, Current Payments, and Current Balance. A total of each of these is printed at the end. Note: This will print for the current month only. An asterisk (*) at the end of a line indicates that the figures on that line do not balance, meaning Current Balance does not equal Prior Balance plus Current Sales minus Current Payments.

Customer Total Summary (Report # 3-16)
This is much the same as Report # 3 - 15 CUSTOMER CURRENT ACTIVITY, except it prints only the total number of Customers, Prior Balance, Current Sales, Current Payments, and Current Balance. Note: This will print for the current month only.

Shipping Info. By Customer (Report # 3-17)
This report lists each customer's Shipping Address and Ship VIA.

Deposit Ticket (Report # 3-18)
This report prints a Bank Deposit Ticket-size report that can be fastened to your preprinted deposit ticket from the bank. This way you do not have to manually write each check on the deposit ticket. It prints Customer Name, Check Number and Check Amount with a deposit total at the end. It separates foreign deposits, cash, and credit cards, and accumulates them into different totals. Foreign deposits must have a Payment Type of F, and cash deposits a Payment Type of C. Standard Payment Types for credit cards are as follows:

                    A - American Express     M - Master Card
                    B - Carte Blanche        N - Diners Club
                    D - Discover             V - Visa

Enter your bank account number in the Bank Dep# field on the System Setup screen 2 (&) as you want it to appear on this report.

Inventory Sold By G/L# (Report # 3-19)
This report lists the total quantities and amounts for each inventory item sold during the period and also the total amount sold by G/L number. Enter the starting and ending dates for the period you want this report to cover.

Generate Finance Charges (Report # 3-20)
This is more than just a report. It actually enters finance charges into the Receivable Invoice file (R) and prints them at the same time. Since this report changes file data, it is wise to back up the data before running it, in case a power failure or error occurs during the operation.

For finance charge calculation to work, the FINANCE CHARGE INFO must be set up in the System Setup Screen 2 (&).

When you invoice finance charges, the report date is critical because it is used to calculate the age of open invoices.

Finance charges are based on the actual number of days any invoice has been overdue, not including any days for which finance charges were already applied. Days overdue are determined by either the Due Date on the invoice or the Free Days in the System Setup Screen 2 (&), whichever comes first. However, a charge is applied only if the report date is past both the Due Date on the invoice and the Days Till Charge in the System Setup Screen 2 (&). When the report is finished, the Last Finance Charge Date is set to the Report Date.

Finance charges are not applied to customers with an "N" in Late Charge on the Customer file (C), or to individual invoices with an "N" in Interest Code.

Finance charges are stored as receivable invoices, beginning with the next available reference number. A total appears at the end of the report. Because they are stored as invoices, the finance charges may be reprinted with Report # 3 - 11 CUSTOMER INVOICE LEDGER.

Packing List on Plain Paper (Report # 3-21)
This report allows you to print packing lists for any one invoice (Repor or list of invoices. The packing list prints on regular 8 1/2" x 11" plain paper. It is much like an invoice on plain paper, except it prints # Ordered, # Shipped, # Backordered, and physical Location of the items so that it is easy for the person packing the items to know just where to find them. It also differs from the invoice in that it does not print the prices for the items.

Customer Activity Report With Balance (Report # 3-22)

This report prints an analysis of each customer's payments, paid invoices, and open invoices.

Every invoice and payment are listed, starting with the most recent. The fifth column is a running balance.

You have the choice of selecting a monthly analysis.

Customer Invoice Payments (Report # 3-23)
This prints a report of payments applied to the customer invoices in numerical order by invoice number.

Customer Orders Without Prices (Report # 3-24)
This report prints out orders, but does not print the prices. This can be used for packing slips, pick tickets, etc.

Customer Back-orders (Report # 3-25)
This report prints back-orders from any reference number to another.

Customer Review (Report # 3-26)
This report scans the Customer file and checks for a Review Date that is on or before the system date. These Customers are printed and any message you entered in the Message 1 field.

A/R Sales By G/L # (Report # 3-27)
This report sorts by G/L#, and lists all invoices under their proper G/L#. If you are on the accrual basis of accounting, use this report to post A/R Sales to General Ledger. You should post this at the end of the General Ledger accounting period after all the accounts receivable transactions for that period are entered. NOTE: When posting, Report Date is VERY important! The Report Date selects the period to be posted. (The Report Date is the date after the word On in the Report Generator screen.)

A/R Sales Journal by Invoice Number (Report # 3-28)
This report lists invoices by invoice number. It displays the invoice number, invoice date, customer code and name, terms, salesman, each item on the invoice, tax code, G/L account number, quantity, unit, extended price, extended cost, gross profit and gross profit percentage.

Count Customer Types (Report # 3-29)
This report prints a list of the customer types, a total number of customers of each type, and a total number of customers on file.

Customer Address Labels (Report # 3-30)
This report prints customer addresses on 15/16" x 3.5" labels, on envelopes, or merged with a Word Processor file (W) document. The report has the following options:

1. It can be printed alphabetically by Customer Code, or by Zip Code.

2. You may select customers with a Print Code, or a combination of several Print Codes. One customer may have Print Codes of A,B,C and another Print Codes of B,C,E. If you enter a Print Code of A,B and answer the question "Must a Customer have all the Codes? (Y/N)" with a "Y", only the first customer will print since the customer must have an A and a B in Print Code. If you enter "N", both the first and second customers will print since only one of the codes must be found in the customer Print Code.

3. When an Activity Date is entered, only customers who have a Post Date on or after the entered Activity Date will print.

4. The message prints on the first line of the address on the right hand side of the label or envelope.

5. If you are printing in alphabetical order by Customer Code, you may print on labels, print on envelopes, list the addresses on a page, or merge them with a record set up on the Word Processor file (W). When merging the file with a Word Processor record, the Word record must have print insert (^I) or replace (^R) information on the Word Processor page so that the name and address will print at the proper locations. For each customer record that this report selects, it will print the currently loaded page on the Word Processor screen (W) and merge the customer data at the places specified.

6. If you want a list of Customers sorted by how many invoices they have and\or by the dollar amount from a specified time in the past to the present, enter an Accumulation Date to specify the time to count from, enter the minimum number of invoices and enter the minimum dollar amount.

A total of the address labels printed will be printed on an additional label if there are more than 10 labels on the list.

Statements on Plain Paper (Report # 3-31)
This report prints customer statements on regular 8 1/2" by 11" paper. The date specified in Statement Cut off tells the computer not to list any invoices after this date on the statements. No statements are printed for customers whose balance is within the statement limits specified in the System Setup Screen 2 (&). The report date is used to calculate aging. The date specified in Date to end Print tells the computer not to print statements for customers that have invoices only after this date.

If you wish to print statements listing only invoices after a certain date, you can do so by entering a (#) followed by that date, when you are asked for a special message. This occurs immediately after you press S for screen or P for print. Be sure to enter it using this format: #04/01/1996.

Generate Invoices From Orders (Report # 3-32)
This report invoices recurring orders for uses such as service contracts, rentals, etc. This report does not delete the order from the Receivable Order file (% - O). When the computer asks for a password, enter PASS unless another password has been set up.

If a group of orders all have the same Bill Code, you can generate invoices for the whole group at once. (The Bill Code is entered in the bottom right-hand corner of the Order screen.) Enter the Bill Code of the orders that you wish to invoice, when the computer asks for an auto-invoice code.

You may have a special description print on the invoice. To do this you must enter a dash "-" in the description field on the order where you want the message to appear and a dash "-" in the Unit field of that line.

Customer Payments (Report # 3-33)
This report prints a list of all customer payments sorted alphabetically by Customer Code, with individual payments listed under each customer.

Sorted A/R Reports (Report # 3-34)
This is a two-column comparative report which can be sorted in seven different ways: (S)alesman, (C)ustomer, (I)tem, (A)ll Three, (1) Salesman & Customer, (2) Salesman and Inventory Item, (3) Customer & Inventory Item.

When you choose to sort with (S), (1), or (2), you will need to specify which salesmen you want the report printed for, rather than which A/R Invoices. Enter the Salesman Code in the "Starting at" and "Ending with" fields on the Report Generator screen.

TURNS OPTION - You can also select the (T)urns option by pressing "T". This shows your stock turnover; how many times your current stock quantity would be sold in the time period specified. The report lists the item code and description followed by current stock. The quantities sold are shown in the Quantity columns. The Amount columns tell how many times current stock would have been sold in the time frame shown at the top of the column.

You can specify Starting and Ending Inventory #'s as well as the Maximum and Minimum Turn Ratios. The (T)urns option can help you decide how much inventory you should stock.

When you choose a sort option (I, A, 2, 3, or T) that includes inventory items, you will have some additional options. You can enter a "Whole Goods Description Word" to select only whole goods items (with a "-" in item#) with a description that includes the word you entered. You can also enter an "Inventory Print code" to select only items with a print code that includes the code you enter.

Customer Orders With Prices (Report # 3-35)
This report allows you to print Customer Orders from any reference number to another.

Statements on Nebs 9060 (Report # 3-36)
This report prints Customer Statements on form # 9060 from Advanced Business Computers, form # 91302 from Deluxe or form # 9060 from NEBS. These are 6 1/2" x 7" statements with detachable remittance stubs.

The date specified in Statement Cut off tells the computer not to print statements for customers that have invoices only after this date. The date specified in Date to end Print tells the computer not to list any invoices after this date on the statements. No statements are printed for customers whose balance is within the statement limits specified in the System Setup Screen 2 (&). The report date is used to calculate aging.

Cash Deposits By G/L# (Report # 3-37)
This report runs from deposit # to deposit #, and generates a sales G/L distribution from the line amounts of the invoices to which the deposit was applied. When a deposit pays only part of an invoice, the percentage of the payment amount divided by the total invoice amount of the individual line G/L amount is used. This report may be run for a particular bank account if the Bank G/L # was entered on the Deposit screen (D). The G/L totals may be posted to the G/L accounts at the end of the accounting period by entering a "P" when asked to press "P" for posting. The proper Starting and Ending Deposit # for the period must be entered correctly.

Customer Invoices on Forms 9040 (Report # 3-38)
This report prints customer invoices on form # 9040 from Advanced Business Computers, form # 91300 from Deluxe or form # 9040 from NEBS. If Cut Sheet field on the 'P screen for the printer has a Y then it prints the Laser form. Laser forms need macros, which are graphic DOS *.MCR files, installed in the DOS ABC directory which are sent to the laser printer when ABC is started. If the printer is turned off after, or while ABC is started, the lines and the graphics on the invoice will not be printed. Exit ABC and restart the program while the laser printer is on. If the laser is attached to a terminal the terminal needs restarted.

On taxable invoices, a "T" is printed beside each taxable amount. The total taxable amount is printed on the sales tax line.

Sales Tax Payable (Report # 3-39)
This report calculates the taxable and nontaxable sale amount and the amount of sales tax collected, based on the amount of money received, as entered in the deposit ledger. If an invoice is partially paid, only the paid portion of the invoice is included in this report.

Salesperson List (Report # 3-40)
This prints a list of the salesmen as they are entered on the Salesman file (S). It lists Code, Name, and Commission Code.

A/R Balancing (Report # 3-41)
This report scans the Invoice file and adds up all invoice totals per customer. It also scans the Deposit file (D) and subtracts all payments applied to accounts receivable for each customer. It then compares the resulting balance with the balance on the Customer file (C). Any customers for which the balances are not the same are printed on the report.

Calculate Salesman Comission
This report calculates how much commission a salesman has earned, one salesman at a time.

When you run the report, you are asked to enter the salesman's code.

In the Starting at field, enter the first invoice that should be considered for the salesman's commission. In the Ending with field, put the last invoice to be included in the calculation.

The report gives total commission and total sales for each category as set up in the Salesman file (S). At the bottom of the report a total of all the categories is given both of commissions and total sales.