Browse
 
Tools
Rss Categories

Invoice Detail Report

Reference Number: AA-00644 Views: 5851 Created: 2011-12-12 14:03 Last Updated: 2012-01-05 11:22 0 Rating/ Voters

In This Section

Invoice Detail Report

To Generate an Invoice Detail Report

To Print an Invoice Detail Report

To Export an Invoice Detail Report to Excel

Summary


Invoice Detail Report

 

The Invoice Detail Report shows the details of invoices generated for hired, returned, and closed transactions. These details include the rental fees, insurance, extra fees, additional kilometers, agent commission and gross sales tax, which, taken together, comprise the total cost of booking a reservation in Rental Car Manager. Using the Excel option this report is often used to export invoice lines to a financial system such as MYOB.


Back to Top


 

To Generate an Invoice Detail Report

 

1. On the Reports menu, click the Monthly Financial Reports tab.

2. Click Invoice Detail Report (see Fig. 217).

 

Fig. 217. Click Invoice Detail Report

 

3. On the Invoice Detail Report Report Page (see Fig. 218):

 

A. By default, location is set to your default location. You may change the location, if needed, or you may select a region instead. 

 

B. By default, the report is set to display the invoice details of transactions involving all vehicle categories. You may select a specific vehicle category and let the report display details of transactions for that specific category ONLY.

 

C. By default, booking status is set to Returned, meaning all returned transactions will be included in the report. You may change this to either Closed or Returned and Hired, if needed.

 

D. Enter a date range for the report. The date range may be for the date the transaction was closed, or the pickup or dropoff dates.

 

E. By default, the report is ordered according to pickup date. You may change the order to the RA number instead.

 

Fig. 218. The Invoice Detail Report Page

 

4. Click View to generate the report (see Fig. 219).

 

Fig. 219. The Invoice Detail Report

 

Once you generate the report, you can print it and export it to Excel. 

 

NOTE: Table 48 shows descriptions of each column found on the Invoice Detail Report.


Back to Top


 

To Print an Invoice Detail Report

 

1. Generate an Invoice Detail Report (see To Generate a Invoice Detail Report).

2. On the Invoice Detail Report Page, click Print to display a printer-friendly version of the report in a separate browser window (see Fig. 220).


Fig. 220. A Printer-Friendly Invoice Detail Report

 

3. Print the report using your browser's Print feature.


Back to Top


 

To Export an Invoice Detail Report to Excel

 

1. Generate a Invoice Detail Report (see To Generate a Invoice Detail Report).

2. After generating the report, click Excel.

3. You will be asked to either open or save the Excel file (see Fig. 221). To open the file in MS Excel, click Open. To save the file to your local drive, click Save.

 

Fig. 221. Click Either Open or Save

 

4. If you choose to open the file in Excel in Step 3, you can save the file by using Excel's Save As feature. If you choose to save the file to your local drive, navigate to the location on your local drive where you save the file and click the file to open it in Excel. Fig. 222 shows a sample Invoice Detail report exported to Excel.

 

Fig. 222. An Invoice Detail Report Exported to Excel

 

 

Table 48. The Invoice Detail Report Column Descriptions


Column Name

Description

Reservation#

The reservation number

Account#

The account number of the customer (entered under customer maintenance)

Customer

The name of the customer

Pickup Date

The date when the vehicle was picked up

Date Closed

The date when the reservation was closed

Rental

The amount paid for the reservation

Insurance

The insurance fees charged for the reservation

Extra

The extra fees charged against the reservation

Additional Kms

The fees for additional kilometers charged against the reservation

Agent Commission

The amount paid as commission to the agent that made the reservation

GST

Gross Sales Tax

Total Invoice

Total amount charged against the reservation


Back to Top



Summary


This article details the Invoice Detail Report tab, where a report that shows the details of invoices generated for hired, returned, and closed transactions is generated. The Invoice Detail Report screen allows you to view, print, or export to excel the Invoice Detail Report.


Back to Top