Sales Cash Drawer Balance Report ranges and options

Ranges

See Report ranges.

Options

Sort by (T)aken by or (P)ayment Type, (B)ank

Specify:

(T)aken by to sort by the taken by operator initials.

(P)ayment Type to sort by payment type; the most common types are cash, check, charge, Visa/MC, Discover, and so on.

(B)ank to sort by bank so you can see how much of each payment type should go to each bank. A bank number of zero is displayed if the bank is not set up.

Print Unbalanced Journals Only?

Each journal record has a Balanced option. When a journal is opened, the Balanced option is not selected.

Select Yes to print unbalanced journals. The Balanced option is then selected on the journal record. This prevents the journal totals from repeatedly appearing on this report. After a journal prints, the system assumes that this report is balanced to the cash drawer and the totals do not need to be printed again.

Select No to reprint a journal. All journals in the specified range print.

Print Payment #?

Choose Yes to print the payment number under the detail line. To print this information, the Totals Only option must be set to No. If there is nothing in the Payment # field, the following is printed for the tendering journal session: OE Entry Journal #. The payment number is originally set up in Customer Setup-Ordering in the Credit Card # field and expiration date field. These values default into the Payment # field in Sales Order Entry-Tendering but can be overridden.

Totals Only?

Select No to print totals and order detail for each payment type. Grand totals by warehouse, subtotals by operator or by payment type, and a grand total for the cash drawer are printed.

The journal number prints for each transaction and the amount due for partial payments also appears. An asterisk (*) beside the Amt Tendered column denotes the invoice was not paid in full. The Amount Due column represents the invoice total less any payments recorded.

The order detail can become quite lengthy and is not needed unless the cash drawer does not balance to the Sales Cash Drawer Balance Report. The order detail is useful when an out-of-balance condition occurs and you need to determine which order(s) caused the problem.

In general, print the Balancing Report with the Totals Only option set to Yes. If a cash drawer is out of balance, reprint the Balancing Report, and select Yes to Print Unbalanced Journals Only and No for Totals Only.

You can only specify Yes one time to show unprinted journals. The next time you run the Sales Cash Drawer Balance Report, it will not find any unprinted journals. You should select No to Print Unbalanced Journals Only, and use the Warehouse and Open Date ranges to produce a report with the information you need.

Print Adjustment/Interdivisional Trans?

Select Yes to print type 0 adjustments and interdivisional transactions and include them in the totals.

Include Credit Card Payments

Select Yes to include credit card payments in the totals. Select No to see totals for cash only in the drawer at the end of the day. If you select No to Include Credit Card Payments, and Yes to Print Adjustments/Interdivisional Trans, the divisional adjustments still include the credit card posting amounts. The Adjustment GL transactions do not include the media code (payment type). Therefore, there is no way to know the amounts that are credit card-specific. To get a true cash drawer balance that does not include credit cards, run the report with Print Adjustments/Interdivisional Trans set to No and Include Credit Card Payments set to No.