Types of reports
Finance reports
Account transactions
A report of money incoming (deposits) and money outgoing (withdrawals) that’s been processed since the creation of your Easol account, great for accounting purposes.
Transactions are recorded by line item, which means that each item (variant or extra) booked are counted as separate transactions. For example, if a single booking contains 3 items and was paid on a payment plan of 3 instalments, it will result in 9 transactions when the payment is completed.
Each transaction includes the booking reference, amount, entry type (deposit or withdrawal), transaction type (e.g. instalment payment, balance payment reallocation credit), customer currency and conversion rate.
Attempted and completed payments
A report of payments made by customers and all automatic charges attempted by Easol on customer cards for payment plan instalments. This report is great for customer support to handle failed payments as well as monitoring popular payment methods.
Every payment (whether initiated by the customer or automatically charged by Easol) falls into one of 3 charge types:
- Immediate payment - a payment made at the time of booking, either a full payment, a deposit payment, or an initial instalment
- Balance payment - a payment made by the customer for an outstanding balance after a deposit or a booking update
- Instalment payment - a payment charged by Easol automatically against a payment plan instalment
Each payment includes the booking reference, charge type, state (charged or failed), payment type (card, Apple pay, Google pay etc.), customer currency, amount in customer’s currency, amount in your business’ currency.
Expected payments
A report of expected payments based on bookings made at checkout, including completed payments from the past and expected payments in the future. This is great for tracking incoming cash flow and what payments failed to arrive in the past.
Expected payments are recorded when a customer enters the checkout and selects a payment method (pay in full, deposit, payment plan). Every expected payment falls into one of 3 states:
- Pending - booking is created but payment has not yet been made
- Completed - payment is successfully made by the customer
- Cancelled - booking is cancelled
The state of the expected payment automatically updates.
Realised and outstanding revenue by product
A breakdown of revenue (including Easol fees) made from customer payments and outstanding revenue from pending payments. Realised revenue doesn’t always match the total sales value because customers can often choose a payment method other than full payment (e.g. deposit, payment plan).
This report is great for monitoring cash flow and risk management. For example, if a product involves suppliers being paid (e.g. accommodation), you can check whether the revenue to cover that has already been realised.
Weekly revenue forecast
A report of revenue you can expect to receive in upcoming weeks, based on sales where payments are still outstanding because the customer chose to pay with a payment plan or a deposit.
Dates shown in the report are the first days of the given week, so 2 January means the week commencing on the 2nd of January. Dates and numbers are automatically updated.
This report can be used to estimate the amount you’ll be paid out by Easol. Note that pay outs may not always match the expected amount due to:
- Payouts occurring the week after payment is made from the customer
- Payment plan instalments failing to be charged
- Customer chooses to pay an outstanding balance early
- Easol fees deducted
- Revenue held back to cover refunds and disputes
Sales reports
Average weekly booking value
A breakdown of the average value of bookings per week over time, as well as the cumulative average. This report is great for checking whether a sales strategy or launch has made an impact on average basket spend and forecasting how much revenue you can expect if you sell a set number of variants.
Sales
A full report of your sales with all raw data, such as:
- Product and variant name
- Customer details
- Booking state
- Price, discounts, fees
- Payment details in your business’ and customer currency, including the exchange rate applied
This report is great for importing into a third-party software and analysing how much revenue you made with booking fees.
Sales by country
A breakdown of your sales, categorised by countries. Country data is based on the billing country provided by the customer at checkout. This report is great for analysing your customers’ demographics and which products are popular with certain countries.
Sales by day
A breakdown of your daily sales. This report is great for tracking the impact of marketing over time and monitoring your sales cycles.
Sales by product
A breakdown of your sales, categorised by products. This report is great for tracking top performing products by sales value and sales count and monitoring underperforming products that may need a marketing push.
Sales by variant
A breakdown of your sales, categorised by variants and extras. This report is great for tracking top performing variants by sales value and sales count, monitoring underperforming variants that may need a marketing push and analysing popularity of variants over time.
Comments
0 comments
Article is closed for comments.