Basic Financial Reports: Accessing and Understanding the Reservation Report

Follow

The Reservation report is a summary report of basic financial information associated with a specific reservation during a selected time period selected

This report is the highest-level report available to you and, generally speaking, this export is not used for revenue-recognition purposes. 

 

How to access the Reservation report

  1. Go to "Reports" > "Reservations" 
  2. Specify the date range you'd like to include in your Invoices Report
  3. Click "Export"
  4. Your report will be emailed to you.

 

reservations_report.png

 

How the Reservation Report relates to other reports

  • Reservations are the source and "home base" of all invoices, transactions, and line items.
  • When a reservation is created in Dockwa, a unique reservation ID is created to identify this reservation.
  • As payable goods and services are added to a reservation (ex. dockage, electric, ice), a reservation becomes associated with:
    • Invoices - bills issued to the customer for goods/services provided
    • Line Items Ledger - individual goods or services included in an Invoice
    • Transactions - charges or refunds associated with settling an Invoice
  • Each Invoice, Transaction, and Line Item have their own unique IDs that, via the Invoice, Transaction, and Line Item Ledger reports, can be tied back to their one associated Reservation ID.
  • While a single Reservation ID can be associated with multiple Invoice, Transaction, and Line Item IDs, a single Invoice, Transaction, or Line Item ID can only be associated with one Reservation ID. 

 

Each reservation processed through your Dockwa account has its own row in the Reservation report, with the following attributed values:

 

Value
Definition
Reservation ID The unique string of letters and numbers that identifies each Dockwa reservation at your business.
Name The name of the customer associated with the reservation.
Email The email of the customer associated with the reservation.
Phone The phone number of the customer associated with the reservation.
Boat name The name of the boat associated with the reservation.
Arrival The start date of the reservation.
Departure The end date of the reservation
Nights Booked The total number of nights reserved as part of the reservation. 
Space Type Indicates whether the reservation represents dockage, moorage, or storage.
Status Indicates whether the reservation is "confirmed," "pending," or "canceled." 
Default Payment Type Indicates whether the reservation payment was processed via Dockwa ("credit") or manually settled outside of Dockwa ("manual").
Requested At The date and time at which the boater requested the reservation. 
Confirmed At The date and time at which the marina operator confirmed the reservation. 
Cancelled At The date and time at which the boater or marina operator cancelled the reservation.
Type Indicates whether the reservation is associated with a boater contract ("contract"), is a transient reservation ("transient"), or is a custom-billed long term reservation ("custom billing"). 
Space Price The dollar value of dockage, moorage, or storage included in the reservation. 
Space Discount The dollar value of dockage, moorage, or storage discounted in the reservation. 
Electrical Price The dollar value of electric included in the reservation. 
Electrical Discount The dollar value of electric discounted in the reservation. 
Adjustment Short for "Refund Adjustment." The dollar value retained by the marina, from the total reservation value in order to cover a fee, such as a cancellation fee.
Sales Tax The dollar value of sales tax charged in the reservation. 
Total Price The total dollar value of the reservation. 
Amount Paid The total dollar value of the reservation that is paid/settled at the time the export was created.
Balance The total dollar value of the reservation that is not paid/outstanding.
Discount Price The total dollar value of discounts applied to the reservation total price.
Discount Reasons The reason for applying discounts to the reservation total price. 
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.