Cash Receipts Journal

The Cash Receipts Journal updates the payments and deposit total to the general ledger. 

The Cash Receipts Journal will also post a transaction to the cash in bank account, even if the deposit total is zero (e.g., credits are entered to offset the outstanding balance on a customer account). This will provide an audit record for that journal reference number in the General Ledger and will allow the journal to be unfinalized if needed.

Go to Receivables > Cash Receipts > Cash Receipts Journal.

A screenshot of a computer Description automatically generated

Print Current Batch

Select this box to print current entries which have not yet been updated to the General Ledger.

Deselect this box to print a journal for a specific date range.

Operator to Select

You can print and update individual reports for multiple users that are entering Cash Receipts by entering an operator name here.  Leave it blank to print all entries on the same report, regardless of which user entered the cash receipt.

Payment Type

Entries can be filtered by payment type by entering a prefix code that matches what is entered on the check #.  When you enter a payment type, the report will filter the entries and only print cash receipts that have a check # that starts with the letters that you enter for the payment type.

This feature is normally used for credit card payments that may post in different batches.  For example, suppose your credit card processor posts all Visa, MasterCard, and Discover charges together, but American Express charges are posted separately.  In this situation, you can use a specific code for the American Express charges such as “AMEX” for the check # when entering the cash receipts.  For the other credit cards, you could use codes that all begin the same, such as “CC VISA”, “CC MC” and “CC DISC”. 

This allows you to print a single Cash Receipt Journal for your American Express charges by entering AMEX in the Payment Type, then another report for the rest of your credit card charges by entering “CC”.  Finally, a third report can be run without a Payment Type that would include all of the checks that you are depositing.

The Cash Receipts Journal will also post individual transaction amounts to the cash in bank account for payments received via ACH. These payments should have "ACH" at the beginning when entered in the Cash Receipts window. If multiple customers make ACH payments on the same Cash Receipts Journal, each customer's ACH payment will be posted separately. This makes it possible for the transactions posted to the cash in bank account to match credits posted by the bank for each ACH amount.

Bank #

When printing a non-current batch report, select the bank account here.  The program will default to the cash receipts bank account number specified in the Program Setup.

Starting Date / Ending Date

Enter a date range to print the non-current report for.

Reference #

To reprint a specific report, you can enter the reference number from the original report.  (Usually this is not needed unless there was more than one deposit made on the same day).

Report Order

Select the order for the report. Select between By Date and By Customer.

Customer # to Select

Select the customer by entering the customer code or use the lookup function accessed by pressing [F4] or clicking the lookup button in this box. This entry is only available when the Report Order is set to Customer.

Business Type

Use the lookup button or press [F4] to select the type. This will open the Customer Type Lookup.

Customize Export

This button will open the select columns window. Here you can select which columns to include in the report and in which order.

Excel Filename

If exporting to an excel file, enter the file name or use the file browser to find a file or change the save location.