The 'financial report'

The 'financial report'

The Financial Report

⏱ Estimated time: 5 minutes

👤 Role: Finance Controllers, Hotel Accountants, General Managers

What you'll learn:

  • How to access and generate a detailed Financial Report.

  • Understanding the breakdown of transaction values, VAT, and fees.

  • How to interpret specific report columns for accurate bank reconciliation.

When should I use this?

The Financial Report is essential for your end-of-month reconciliation. It provides a granular view of every transaction placed within a specific period, detailing exactly what the guest paid, the tax components, and the deductions for gateway and service fees.

Key Logic:

Unlike a simple sales report, the Financial Report focuses on the "Net" vs "Gross" figures. It allows your finance team to see the journey of the funds from the guest's card to your bank account, accounting for all third-party deductions along the way.

Before you start:

  • Ensure you have "Manage" or "Reporting" level permissions in the platform.

  • Identify the specific date range required (e.g., the previous calendar month).

Step-by-step:

1. Access the Reporting Suite

The reporting tools are centralised to provide a quick overview of property performance and financial health.

  1. Log in to the Ecommerce platform.

  2. In the left-hand menu, under the Manage heading, click on Reports.

  3. From the list of available reports, select Financial Report.

2. Generate and Download the Report

Reports are generated as static files to ensure data integrity during the download process.

  1. Date Range: Choose the start and end dates for the period you wish to analyse.

  2. Click on Generate Report.

  3. Scroll to the bottom of the page to the Ready to Download list.

  4. Locate your new report (the most recent will be at the bottom) and click the Report Name to download the file to your device.

3. Interpret the Financial Columns

The exported file contains several columns. Use the table below to understand how these figures relate to your accounts:

Column Name

Definition

Total Order Value

The "Gross" amount paid by the guest (Includes VAT and fees).

Total VAT

The tax portion of the sale (already included in the Total Order Value).

Total Service Fees

The fee paid to Journey for platform usage.

Total Gateway Fee

The fee paid to Stripe for processing the transaction.

Client Sub Total

The "Net" amount your property receives after all fees are deducted.

Total Delivery Fee

Fees charged to the guest for physical shipping (Retail only).

Total Product Fulfilment

Internal costs/fees associated with physical delivery (Retail only).

Best practice:

Monthly Audits: Schedule a download of this report on the 1st of every month for the previous month's data. Cross-referencing the Client Sub Total with your Stripe Payouts is the most efficient way to ensure your Ecommerce revenue is reconciled correctly.

Important Notice:

VAT Clarity: Please remember that the Total VAT figure is a component of the Total Order Value, not an additional charge. When recording revenue in your PMS, ensure you are not double-counting tax by checking these columns against your internal PMS transaction codes.

    • Related Articles

    • Reports

      Reports ⏱ Estimated time: 3 minutes ? Role: General Managers, Finance Teams, Marketing Managers, Reservations Teams What you'll learn: The specific purpose and data included in each available report. How to generate and download reports for your ...

    • The 'Order report'

      The Order Report ⏱ Estimated time: 3 minutes ? Role: Reservations Managers, Front Office Managers, Marketing Teams What you'll learn: How to generate a comprehensive list of guest orders. Understanding the data points captured in the report ...

    • The 'arrivals report'

      The Arrivals Report ⏱ Estimated time: 5 minutes ? Role: Front Office Managers, Spa Receptionists, Restaurant Managers, Night Auditors What you'll learn: How to generate a list of upcoming guests booked via the storefront. How to filter out ...

    • The 'offer report'

      The Offer Report ⏱ Estimated time: 3 minutes ? Role: Marketing Managers, Revenue Managers, Ecommerce Administrators What you'll learn: How to track the performance of live offers on your storefront. The process for generating a report that isolates ...

    • How to run a guest report and what data does it contain?

      The Guest Report (Marketing Opt-ins) ⏱ Estimated time: 3 minutes ? Role: Marketing Managers, Data Privacy Officers, Ecommerce Administrators What you'll learn: How to generate a report specifically for marketing-compliant guest data. Understanding ...