This program is not dependent on the DBR posting process and can, therefore, be run either before or after RAs have been posted.
This management report is similar in some respects to the Drawer Balance Report typically used by counter agents. The major differences between the two reports are;
1. The Drawer Balance Report can only report a single drawer's transactions while the Cash Receipts Report can report all deposit/payment records processed at a location.
2. The Cash Receipts Report provides for a selection of what types of FOPs (or customers) are to be reported.
3. The Cash Receipts Report also lists which General Ledger account will be debited or credited as the offset to the cash or petty cash account.
4. The Cash Receipts Report for EDC clients prints a code which indicates if the transaction has been processed through CARS+ EDC or if it was flagged for manual settlement.
Masking Credit Cards: When the system is configured to mask credit card numbers, most of the digits in the credit card number are replaced with a series of "X"'s. This is true regardless of the user running the report. User tip: Users that are exempt from masking (a field in their User Access record controls this) can access a full credit card number if necessary by doing the following: Access a search of the Dep/Pay File from Reservations, RA Open, RA Close, etc. Find the record, then select it from the search. A prompt for the username and password will appear. If approved, the full credit card number and expiration date will appear in a pop-up window. Refer to the chapter of the manual titled Overview - Masking Customer Data for full details in how to set up and use the masking logic in CARS+.
User tip: For operations using the net tour logic (also known as ghost tour logic) and entering tour vouchers through the Special Documents subwindow, be aware that net tour vouchers are not part of the Deposit/Payment File. Since it is the records from the Dep/Pay file that make up this report, net (ghost) tour vouchers are not shown on this report.
This report can be configured to run automatically from the CARS+ Report Driver. Users interested in this feature should contact Thermeon's Customer Support Dept. for further information.
To access the Cash Receipts Report program, type DCD (RET) at any menu "OPTION:" field or the appropriate line number on the Daily Reports Menu.The screen will then display:
| OPTION: __ CASH RECEIPTS REPORT 1 Start Date 10-20-11 2 Start Time 0000 3 End Date 10-20-11 4 End Time 2359 5 Location TUS 6 Drawer ALL 7 Unposted Records only? Y 8 FOP Type(s) ALL 9 10 11 (Select up to 4 types -- FOP types are: C, CC, B, BC, NON or ALL) 12 FOP ALL 13 Detail/Summary D 14 Print/Display P 15 Show G/L? Y 1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8 |
Enter data as follows:
|
1. START DATE |
Using your selected date format, enter the Starting Date.Press RET to default to today's date. EXAMPLE:Type 101911 (RET) |
|
2. START TIME |
Using your selected time format, enter the Starting Time.Press RET to default to midnight. EXAMPLE:Press (RET) |
|
3. END DATE |
Using your selected date format, enter the Ending Date.Press RET to default to today's date. EXAMPLE:Type 101911 (RET) |
|
4. END TIME |
Using your selected time format, enter the Ending Time.Press RET to default to 11:59 pm. EXAMPLE:Press (RET) |
|
5. LOCATION |
Each record in the Deposit/Payment file (such as: deposits, payments, petty cash transactions, vouchers, reimbursements, promos) has a location associated with the record. This is typically the default location (as seen in the Change User Environment program) of the user who entered the transaction, unless specifically overridden by entering a different location when recording it. By entering a location or group name in this field, only the transactions associated with the location or location group will be included in the report. Enter: 1. Up to 6 alphanumeric characters to select a single location. 2. A Group Name representing several locations (see the Chapter Edit Group Names for a discussion on location groups). Remember, the first character of a Group Name is the plus sign "+". 3. "ALL" to include ALL locations. Note: Your user access may be limited as to the locations for which you can run this report. If your access is restricted and you attempt to enter a location or location group which is outside your allowed parameters, the following message will be displayed at the bottom of the screen and your selection will be ignored:
EXAMPLE: Press (RET) |
|
6. DRAWER |
Enter up to 3 numeric characters to select the Cash Drawer. Because Cash Drawer numbers are not assigned to specific locations, CARS+ does not check to see if data in Fields 5 and 6 is contradictory. If, for example, Cash Drawer #1 is not at location TUS, then the above example will result in nothing reported. Press RET to default to All Drawers. EXAMPLE:Type 1 (RET) |
|
7. UNPOSTED |
Enter 1 alpha character to select the records to be printed.
EXAMPLE:Type Y (RET) |
|
8 - 11. FOP TYPE(s) |
FORMS OF PAYMENT TYPE CODES Forms of Payment are divided into five general types
in the CARS+ system. Note that the
FOP Type Code must not be confused
with the individual FOP Codes! The FOP Type Code is the Customer Type Code assigned in field 2 on page 2 of the customer record for the FOP. Please refer to the manual chapter Customer File Update for more information. C = Cash. Includes cash, checks, traveler's checks, Reimbursements, etc. CC = Bank depositable credit card payments. This category includes all credit cards that can be deposited directly into the operation's bank account. B = Billable FOPs. These are billable credit cards (as opposed those that are deposited directly into the bank. When a customer uses a billable credit card, the financial obligation is transferred from the renter to the FOP Customer Account. CARS+ will automatically create an accounts receivable for that amount against the credit card company. BC = Batch Processed Credit Cards. These FOPs are similar to the "B" type. However, instead of individual invoices for each transaction posting to the FOP's Open item account, a single "batch" invoice is posted for all transactions for the FOP received on that DBR date. See the chapter on the Accounting DBR for a more detailed description of this FOP Type. BF = Billable FOPs and a government tax document will print for this FOP. Combining the five available FOP Type Codes can produce various reports. Some typical reports are:
H = FOP's that have customer type "H". These are FOP's used in the S Subwindow, such as PROMO, TOUR, AWARD, etc. NON = "None of these". The report will list all types except those listed above. Enter up to 4 FOP type codes and/or Customer Types. Press RET for ALL Forms of payment. EXAMPLE:Type C (RET) CC (RET) BC (RET) |
|
12. FOP |
Enter up to 6 alphanumeric characters to select records with a single FOP. Or, if a non-FOP customer type was entered in the field(s) above, enter a customer number. Press RET to include ALL. EXAMPLE:Type MC (RET) |
|
13. DETAIL/ SUMMARY |
Enter 1 alpha character to select the report format.
EXAMPLE:Type D (RET) |
|
14. PRINT/ DISPLAY |
Enter:
EXAMPLE:Type P (RET) |
|
15. SHOW G/L? |
Certain CARS+ users prefer to use the space where the General Ledger account numbers normally print for other data. Enter:
EXAMPLE:Type Y(RET) |
The screen will then display:
| OPTION: __ CASH RECEIPTS REPORT 1 Start Date 10-19-11 2 Start Time 0000 3 End Date 10-19-11 4 End Time 2359 5 Location TUS 6 Drawer 1 7 Unposted Records only? Y 8 FOP Type(s) C 9 CC 10 11 (Select up to 4 types -- FOP types are: C, CC, B, BC, NON or ALL) 12 FOP MC 13 Detail/Summary D 14 Print/Display P 15 Show G/L? Y 1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8 |
PRESS "F1" AT "OPTION:" TO BEGIN PRINTING.
User tips:
Holding Drawers: Operations making use of the Holding Drawer feature should remember that selecting "ALL" drawers will include the Holding Drawer transactions.Petty Cash entries: The 30 character description field from Petty Cash entries
is shown under the entry itself.
Reimbursements: Reimbursements on RAs are listed on this report under the FOP code "REIMB". Reimbursement entries create a record in the Deposit/Payment file. Note that reimbursements are NOT a reduction in the revenue. Rather, they are a credit that is applied to the contract total.
User tip Hertz Canada: For corporate locations, cash-like FOP’s are handled a little differently from other forms of payment in that rather than printing the FOP name, various explanations such as “DEPOSIT”,“PARTIAL PAY”, “PAID IN FULL”, “DIRECT LOCAL PAY” or “CURRENCY EXCHANGE” print depending on the circumstances of the transaction. On certain transactions, the RA number entered on the Petty Cash Entry is shown in the RA number column.
EDC Column: The possible values are:
blank = this record has not been processed by the EDC logic (it has not been settled with your bank)
Y = this record was flagged as having been manually settled. It has not nor will not be processed by CARS+ EDC
2 = this record was settled through CARS+ EDC
3 = this record was settled though the Brazilian SiTef logic