Search Date Definitions:
Transaction Date:
- For payment/tender transactions this is the date the payment was taken in Anchor.
- For revenue transactions this is the date the order was created or any new items were added to an existing order within that date range.
Accounting Date:
- For payment transactions the accounting date will match the transaction date.
- For revenue transactions this will be the Experience date when we want the order to recognize the revenue for services provided or products purchased.
Synonymous Fields:
- Booking ID and Confirmation Number
- Customer and Customer Name
- Room, Vessel and Vessel Name
- Coupon Code and Coupon Code Applied
- Node and Node Location
- Preferred Sales Method and Sales Channel
Popular Reports:
Below are the 4 most common reports used by accounting with what is provided in the default view of each report. There is a supplemental excel document that indicates what data is available in the background data of each report. We can take any of the detail fields available to create custom views within that report.
Sales/Revenue Report (beta)
- This is a date range report with the ability to pull up to 13 months of data at a time.
- The report can be generated based on either the Experience Date or the Transaction Date.
- The default is set to view by sales manager role but can be expanded down to the particular booking ID. It displays guest count, revenue allocated by ticket or enhancement, any discounts, taxes, fees, the amount paid and what is still be due.
Trial Balance Report
- This is a date range report that pulls based on the transactions with an accounting date within that range.
- The summary is used to book the tender, liability and revenue activity.
- The default shows GL Account Description, opening balance, debits, credits, net change and closing balance.
Cash Receipts Report
- This is a date range report that pulls based on the transactions with an accounting date within that range.
- It will pull any GL accounts that have been given the report connection “Cash Receipts”.
- The default is the same as the trial balance and shows GL Account Description, opening balance, debits, credits, net change and closing balance.
Master Monthly Report
- This is another date range report that can be run for a large date range. The limit for this report is a calendar year.
- It can be run by both Experience Date or Transaction date.
- In order to get the flexmonster pivot to customize the view it needs to be run in the CSV format.
- The report defaults to run without tax so in most cases you will want to include those amounts.
- You also have the ability to pull tickets only or food and beverage items only.
- The default pulls by Tour Name with the next layer of detail being the product name.