Use the Cash Box Journal to reconcile your cash register, or cash box. If your company has a sales counter or showroom where employees take cash payments or deposits from customers, then you need to reconcile their collections to the receipts expected by the system.
After you have run the Cash Box Journal, use the Miscellaneous Cash Receipts program to post your cash to the appropriate bank accounts.
You can use the Cash Box Journal to preview invoices for counter sales and pick up orders where EPad is not used. You can drill into the orders from the report and change print flag from Q to P on the status tab.
For more information about what is on this report, see What the Report Shows.
To run a Cash Box Journal report:
From the A/R > Reports/Journals menu, select Cash Box Journal to display the Cash Box Journal window.
In the Start Date field, enter the first date in a range of dates for which to reconcile automatic postings. The system populates this field with today's date, but you can change it, if needed.
In the End Date field, enter the last date in a range of dates for which to reconcile automatic postings.
Note: If you do not populate the End Date field, the system populates it with the date you entered in the Start Date field.
In the Start Time field, enter the time to start running the report. The system populates this field with 12:00 am, but you can change it, if needed.
In the End Time field, enter the time to stop running the report. The system populates this field with 11:59 PM, but you can change it, if needed.
In the Branch/Territory field, enter the branch or territory for which to run the report. Enter ALL to run the report for all branches and territories.
In the Location field, to reconcile the receipts from just one location, enter that location here. To reconcile receipts from all locations, leave this field blank.
To reconcile the receipts for one employee only, in the User ID field, enter the employee's ID code; otherwise, leave this field blank.
In the Journal Format field, enter one of the following:
Narrow - Includes the total of all cash receipts and the remaining balance on each transaction involving a receipt.
Wide - Includes the total of all cash receipts and breaks them down by cash, check, and credit card receipt amounts, including payment information for credit card receipts. This is the default.
Note: When you set this field to Wide, the Payment Info column on the report displays credit card numbers. To determine how many digits of the credit card number actually display, set the CREDIT.CARD.ACCT authorization key.
In the Sort By field, enter one of the following to determine how to sort and subtotal the report:
User - Sorts by user ID numbers. This is the default value.
Customer - Sorts alphabetically by customer name.
Note: If you are running this journal to reconcile your cash box, use the WideJournal Format and the CustomerSort by selections.
Use the Cash Box Reconciliation and Deposit worksheet to complete your reconciliation process.
The following information displays on the Cash Box Journal Report:
Column | Description |
Br | Branch where the transactions occurred. |
User | User ID number of the person who ran the report. |
Order # | number assigned to the sales order. |
Post Date | date the payment was transferred from the purchaser's account. |
Customer | name of the customer. |
Cash | amount of cash received for this transaction. |
Check | amount of checks received for this transaction. |
amount of credit card payment authorized for this transaction. You can compare the total of this column with the total of the Tran Amount column for reconciliation purposes on the Credit Card Summary report. | |
GCard | amount of gift card credit used. |
Total | total amount received on this transaction. |
Open Bal | money not collected from this transaction. |
Payment Info | method used to pay on this transaction. If you run process credit cards using Element Payment Services, credit card payments include the card type followed by a pound sign and the last four digits of the masked credit card number. For example, Amex#1004. If you do not use Element Payment Services to process your credit card transactions, credit card payments include a two character credit card code followed by the full credit card masked number. |
Location | location for which the cash box is being reconciled. |
See Also: