Troubleshooting and FAQ
How do I access hospoIQ reports and dashboards?
Dashboards on mobile are accessible by downloading the Power BI app from your App Store. A greater range of reports are accessible via the Power BI Service through your browser of choice (https://powerbi.microsoft.com/en-us/). In both cases, you then need to login with the hospoIQ credentials provided to you. A step by step guide can be found here: https://www.hospoiq.com/getting-started-help-guide.
How do I see the best sellers per category group?
A visual (Quantity by Category and Item) is provided on all dashboards (eg, Daily Dashboard, etc..) showing sales items, grouped by Category Group and Category, ordered from highest to lowest in terms of quantity. There is also the Highest Sellers report (go to the ‘Highest Sellers’ report tab) which allows you to choose the date range and also filter the data viewed.
Can we see individual staff sales for specific items or groups? (eg, who sold the most sides, who sold the most desserts, who sold the most Coronas?)
The Sales by Staff report allows you to filter by staff, category group, category and item and then shows which staff members have sold the most. It also provides staff % of sales and average sales value. The Sales Insights report also allows you to view historic sales, highest sellers and top selling staff in a single report and perform cross-filtering.
How do we easily break down what are our busiest times are - food, beverage, and then both together?
The Sales Analysis report shows the average sales per hour, split by food and beverage, and can be filtered by weekday, location, category group, category.
Can we set our own sales targets and/or change projected revenue ourselves if it’s consistently under- or over-performing expectations?
You can set your own daily sales targets by site and location in the hospoIQ app. These default to the daily projection, but then allow you to override this and save your changes. These targets will then appear on all dashboards. A detailed guide can be found here: https://www.hospoiq.com/target-helpguide.
How can I easily get the weekly target revenue for each week for the rest of the year? How do we get expected beverage/food split for those weekly targets? How do we see projected food revenue per day? (ie, so we know how much to order daily?)
The Forecast vs Actual Report shows projected/target revenue vs actual for the coming year, and also provides a projected food vs beverage split (by $ amount and %). You can also review the same information historically in the Historic Sales report.
Can we see how a future roster sits against expected revenue, including FOH vs Kitchen? How are salaried staff accounted for in this?
The Wage Costs - Daily report allows you to view actual or projected/target revenue against actual or rostered wage costs. You can then also filter by Department (ie, FOH vs Kitchen) and location. If salaried staff comes through as a particular type of ‘work group’ from your rostering system, you can then choose whether or not to include or exclude this from wage costs in hospoIQ and/or what Department to add it to. For further detail on this, you can refer to our help guide: https://www.hospoiq.com/wagecost.
How can I cost my recipes? Is there a way to link COG to each item to show GP - 50L keg going to Pint, Glass, Half Pint (ie, recipes linked to menu items)?
The hospoIQ app enables you to record all purchases. You can build recipes for any menu item, including sale price, the various purchase items included and quantity required and have them automatically costed out for you, as well as the resulting GP. For example, a 50L keg would be entered as a ‘Purchase Item’ and then put as a line item into a Recipe with a given sub-quantity. A more detailed help guide for this can be found here: https://www.hospoiq.com/recipes.
How long does it take to setup?
Usually within a day. It simply requires the install of a small Windows service on your POS till or server (this can be done either via a download from the hospoIQ website and easy install process; or if we are provided TeamViewer access, the support team can do it for you). Reports and dashboards are then provided through Power BI.
What POS systems do we integrate with?
Currently Menumate, Wizbang (OneTap), SWIFTPOS, IdealPOS, Tevalis and Kounta. We are adding new integrations all the time based on customer demand, so please get in touch with us even if your POS isn't yet on the list and we can discuss potential options.
What rostering systems do we integrate with?
Currently goRoster, Deputy, FlexiTime and Time Filer. We are adding new integrations all the time based on customer demand, so please get in touch with us even if your rostering system isn't yet on the list and we can discuss potential options.
What financial systems do we integrate with?
Currently Xero. Integration can be two-way, providing automated daily sales invoices in Xero (ie, Cash and EFTPOS, split into Food and Beverage accounts) and pulling P&L data into hospoIQ reports to augment the reporting information. We also pull P&L data for MYOB users.
How do the projections work?
Projections use a ‘machine learning’ algorithm which takes multiple factors into account to predict sales per hour and day. These factors include: weekday profile (eg, what does a typical Monday look like) using the last 12 weeks; the same day last year (52 weeks prior), and whether the day is a ‘special event’ (eg, Boxing Day, Regional Anniversary Day, etc)
Need more help?
Refer to our Help Guides found here: https://www.hospoiq.com/support-helpguides or email us at support@hospoiq.com
Xero - MYOB - Goroster - Deputy - Time Filer - Flexi TIme - hospoIQ
I haven't got my Xero sales invoices through
My Financial Reports aren't up to date
Food and Beverage COGS aren't displaying anything
My Wages for Front of House and Kitchen are not displaying
My Food and Beverage Sales aren't separated in my Financial Reports
Xero error
My Sales Invoices are going to the wrong Account
Not getting a Sales Invoice to Xero for a payment type
ct "Xero Configuration" from the hospoIQ menu. Then select "Configure" from the site that you wish to change the account settings for. This will bring up the invoice settings and account mappings.
I can't see all my staff in the wage reports
Time Sheet's are missing shifts/hours or are inaccurate
Staff on salaries are not showing in hospoIQ
First check that you have assigned the member of staff on Salary a salary value in your roster system.
My Sales and Payments don't match
Sales are a reflection of everything that has been inputted in to your till, including orders. These included account charges, open tabs (yet to be cleared) and parked transactions.
How can I exclude or include GST in my reports?
Can't save my Cash Up
Check that you have entered a Name against the Cash Up you are entering. This is required to be able to save a Cash Up.
No data on Cash Up Screen
Firstly, check the date and the site that you have selected to do Cash Up for.
How can I exclude or map tips from my invoices
Petty Cash is adding to my cash counted total
Put a minus before you input the amount (-).
How can I send just one sales invoice for one of my sites to Xero
Can't sign in to hospoIQ
How can I change a contact name in my Xero invoices or Tracking Categories?
How can I add a new payment type to my Xero invoices