To run a Cash Receipts Journal:Use the Cash Receipts Journal to keep track of your company's credits and receivables. You can produce this report in a variety of formats to accommodate different reconciliation procedures.
For example, if your company has a sales counter or a showroom where employees take payments or deposits, you need to reconcile the collections with expected receipts. Each time an employee enters a payment received, this amount shows up in several places. In the A/R Ledger, the amount shows as a payment received. The amount would show up as a credit to the A/R Ledger, and a debit from the A/R Ledger for the account assigned to the cash box item in the G/L Automatic Postings account. You would run the Cash Receipts Journal to create a summary of all cash received for a certain date and from a certain location.
Because users with the proper authority can change closed transactions, the data on this report is subject to change. Therefore, this report is not for audit purposes.
To run a Cash Receipts Journal:
From the A/R > Reports/Journals menu, select Cash Receipts Journal to display the Cash Receipts Journal screen.
In the Br/Tr/All field, enter the branch or branches for which you want to run the report.
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 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 Detail/Summary/Totals field, press F10 and select one of the following to determine the level of detail to include in the report:
Detail – Displays all invoices and cash receipts for each customer, followed by the invoice date, check date, aging totals for that customer, disbursements, subledger information, and grand totals for all customers displayed.
Summary – Displays aging totals for each customer, followed by grand totals for all customers. This is the default.
Totals – Displays only cash receipts that have not been applied to an unpaid invoice. This level of detail does not display unapplied credits
In the Break on Periods (Y/N) field, indicate whether or not to produce separate reports for each end-of-month date that occurs between the start date and the end date of this report. N is the default.
In the Batch ID field, to run a report for only those cash or miscellaneous cash receipts with a particular batch ID, enter that batch ID. To run the report for all cash and miscellaneous cash receipts, leave this field blank.
In the Regular/Misc/Both field, press F10 and select one of the following to determine the receipt types to include in the report:
Regular – Includes all cash receipts. This is the default.
Misc – Includes all miscellaneous cash receipts.
Both – Includes all cash and miscellaneous receipts.
In the Sort by Date/Bank field, press F10 and select one of the following to determine how to sort the report:
Date – Sorts the report by the dates of the cash receipts. This is the default.
Bank – Sorts the report by the bank to which the cash was deposited.
In the S/O Customer Release # field, to include cash receipts based on the customer release number, enter that number.
In the Customer P/O # field, to include cash receipts based on the customer P/O number, enter that number.
In the S/O Ship-To Customer field, to include cash receipts based on customer ship-to information, enter the customer name, or use the Multi hot key to enter multiple customer release numbers, customer purchase order numbers, or customer ship-to information.
In the Service Charges (Inc/Exc/Only) field, press F10 and select one of the following to determine whether to include service charges:
Include – Includes all service charges in the report. This is the default.
Exclude – Excludes all services charges from the report.
Only – Includes only service charges in the report.
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: