To run a Cash Box Journal:Use the Cash Box Journal to reconcile automatic postings to actual cash receipts. 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 that the system expects.
After you run the Cash Box Journal, use the Miscellaneous Cash Receipts program to post your cash to the appropriate bank accounts.
The report provides the following information:
The Br column identifies the branch where the transactions occurred
The User column identifies the user ID number of the person who ran the report.
The Order # column identifies the number assigned to the sales order.
The PostDate column identifies the date the payment was transferred from the purchaser's account.
The Customer column identifies the name of the customer.
The Cash column identifies the amount in cash received for this transaction.
The Check column identifies the amount in checks received for this transaction.
The CCard column identifies the amount in credit card payments authorized for this transaction. Compare the total of this column with the total of the Tran Amount column for reconciliation purposes on the Credit Card Summary report.
The Total column identifies the total amount received for this transaction.
The Open Bal column identifies the money not collected from this transaction.
The Payment Info column identifies the method used to pay on this transaction.
The Location column identifies the location for which the cash box is being reconciled.
To run a Cash Box Journal:
From the A/R > Reports/Journals menu, select Cash Box Journal to display the Cash Box Journal screen.
In the Start Date field, enter the first date of the period you want to include in the report. The default is the current date.
In the Start Time field, enter the time in military format at which you want the report to start. The time zone that the report is run in is included in the report.
In the End Date field, enter the last date of the period you want to include in the report. The default is the current date.
In the End Time field, enter the time in military format at which you want the report to stop. The time zone that the report is run in is included in the report.
In the Br/Tr/All field, enter the branch or branches for which you want to run the report.
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.
In the User ID field, to reconcile the receipts for just one employee, enter that employee's name here. To reconcile receipts for all employees, leave this field blank.
In the Journal Format field, press F10 and select 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 the totals down by cash, check, and credit card receipt amounts, including payment information for credit card receipts.
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 User/Customer field, press F10 and select one of the following to determine how to sort and subtotal the report:
User – Sorts by user ID numbers. This is the default.
Customer – Sorts alphabetically by customer name.
Invoice Number – Sorts by invoice number in descending order. Subtotals are not available in this option.
Note: If you are running this journal to reconcile your cash box, use the Wide Journal Format and the Customer Sort by selections.
Use the Slct hot key to display the Additional Selection Input screen, where you can enter additional criteria for selecting specific customers to include in the report.
See Also: