A. Use this program to Create a csv export file of rental agreement rental revenue that will match the Accounting DBR Report. This file can then be picked up by most spreadsheet programs.

NOTE: This program exports the revenue figures from the Accounting DBR. Payments, deposits, and billings to Accounts Receivable are not reported.

B. ACCESSING AND RUNNING THE DBR REVENUE EXPORT PROGRAM

This report may 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.

In order to get the CSV file, enter a printer name that causes the output to be opened or saved as a file. For most users, the value of CSV or EDITOR will work for this purpose. Please refer to the chapter for Edit Terminal Records or Change User Environment for more information on setting up printing to a file and/or opening a file in the default program for that file.

To access the DBR Revenue Export program, type DBREXP (RET) at any menu "OPTION:" field or the appropriate line number on the Export Data Menu. The screen will then display:

OPTION: __ DBR REVENUE EXPORT

1 Start Date 11-16-16
2 Start Time 0000
3 End Date 11-16-16
4 End Time 2359
5 Location ALL
6 RA Post Value B (Y=posted, N=Unposted, B=both)
7 RAs B (O=owned, F=foreign, B=both)
8 Vehicles B (O=owned, F=foreign, B=both)
9 Extract Inclusive N




1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8

Enter data as follows:

1. START DATE

Using your selected date format, enter the Starting DBR Date. Press RET to default to today's date.

EXAMPLE: Type 111516 (RET)

2. START TIME

Using your selected time format, enter the Starting DBR Time. Press RET to default to midnight.

EXAMPLE: Press (RET)

3. END DATE

Using your selected date format, enter the Ending DBR Date. Press RET to default to today's date.

Note: The size of the date range you can enter may be restricted by your system access level (see the Chapter on the program, Edit User Access). If you enter a date range that is larger than what is allowed for your account, the following message will appear at the bottom of the screen when you attempt to press F1 to start the report:

Employee Code REPORT DAYS LIMITED TO nnn

EXAMPLE: Type 111516 (RET)

4. END TIME

Using your selected time format, enter the Ending DBR Time. Press RET to default to 11:59PM.

EXAMPLE: Press (RET)

Records will be selected as follows:

  • RAs will be selected if any of their charges have a DBR date and time that falls within this date range.
  • Deposits, Payments and Petty Cash transactions will be selected if the payment's date and time falls within this date range.
  • If tour vouchers are invoiced at open, they will be selected if the RA's open date and time falls within this date range.
  • If tour vouchers are invoiced prior to open, they will be selected if the voucher's invoice date and time falls within this date range.

5. LOCATION

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 "+". In addition, for this report, a Location Group will trigger "subtotal roll-ups" (if the group contains groups within groups, subtotals will print for each group level). For more information on this feature, refer to the section on Subtotal Roll-Ups at the end of the Edit Group Names chapter.

3. Press RETURN to default to ALL locations.

If you plan to post transactions (Field 10 = "Y") in this run, you WILL be blocked if you have entered either a Location Group or ALL in this field and:

  • all locations do not have the same posting company, OR
  • all locations are not set up the same way as far as credit card settlement is concerned. OR
  • "Shared Fleet logic" (Field 31 on the Edit Locations screen) is set to "Y" on any location.

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:

RESTRICTED REPORT LOCATION

EXAMPLE: Type TUS (RET)

User tip: When a Location Group is entered in this field, the order in which the locations are processed are: individual locations (in alphabetical order) are listed first, then the groups are processed in alphabetical order, and then the locations within each group in alphabetical order.

6. RA POST VALUE

Enter 1 alpha character to select the records to be included.

Y = Posted transactions only
N = Unposted transactions only
B = Both posted and unposted transactions.

EXAMPLE: Type Y (RET)

FIELDS 7 & 8

Rental operations which are part of a national franchising organization are faced with several types of rental situations. These situations are summarized in the chart below:

Vehicle Ownership

RA

Description

Yours

Yours

Your rental of your vehicle.

Foreign

Yours

You rented a foreign vehicle.

Foreign

Foreign

A one-way rental to your location.

Yours

Foreign

A foreign location rented your vehicle.


Fields 7 and 8 allow you to select which of the four types of rentals listed above will be reported in the Closed RAs section of the DBR. As a result, this also determines which RAs are included in the revenue averages and other statistics.

7. RAs

Enter:

O = OWNED. Only your RAs will be reported.One-way rentals from foreign locations to your operation and foreign rentals of your vehicles will be excluded from the report.

F = FOREIGN. Only one way rentals from foreign locations and foreign use of your vehicles will be reported.

B = BOTH. All RAs will be reported.

EXAMPLE: Type B (RET)

8. VEHICLES

Enter:

O = OWNED. Only RAs involving your vehicles will be reported. Your use of foreign vehicles and one-way rentals of foreign vehicles to your locations will be excluded.

F = FOREIGN. Only RAs involving foreign owned vehicles will be reported. That is, your rentals of foreign vehicles and foreign vehicles that checked into your locations on one-way rentals.

B = BOTH. All RAs regardless of vehicle ownership will be reported.

EXAMPLE: Type B (RET)

Obviously, the combination of responses to Fields 14 and 15 will produce several different kinds of reports.For example:

Type of report

Field 14

Field 15

Foreign use of your vehicles

F

O

Your use of foreign vehicles

O

F

Revenue produced by your vehicles

B

O

RAs that you have written

O

B

RAs entered through Foreign RA Entry

F

B


Note: It is suggested that when you run this report to post daily business that you use the default values of "B, B" in order to be sure that all transactions have been posted. After that, additional reports can then be run for unique rental situations.

9. EXTRACT INCLUSIVE
This field allows inclusive items to be extracted from Time revenue. Enter:

Y = extract included items from Time revenue
N = do not extract included items from Time revenue

EXAMPLE: Type N (RET)


PRESS "F1" AT "OPTION:" TO BEGIN PRINTING.


C. DATA IN THE EXPORT


The following data will appear in the file for each RA that would appear on a similarly run accounting DBR:

RA#

DBR Date

Vehicle Class

Vehicle Number

Rate Code

Rate description

Renter's Customer #

Renter's Last name

Bill-to Customer #

Bill-to Last Name

Open Location

Open Date

Close Location (added as of release v15.3.0)

Close Date

Charges (one field for each option charge, listed in alphabetical order - RAs without a spefic charge will have no value for that option ",,")

Note: Revenue from both in voucher and out of voucher charges will be totaled together.


When imported into a spreadsheet program, the data will be arranged as follows:

RA#
DBR Date
Vehicle Class
Vehicle Number
Rate Code
Rate description
Renter's Customer #
Renter's Last name
Bill-to Customer #
Bill-to Last Name
Open Location
Open Date
Close Date
Charges:
Time
Miles/Kms
Upsell
Cust Service Adjustments
Discount
Promo
Service Adjustments
Column for each coverage
Fuel
Drop
Each option charge, listed in alphabetical order
Each tax type option
Each miscellaneous charge type option
Final column Gross Revenue