Reporting gives critical insight into important aspects of a business like sales and staff performance. This list of frequently asked questions focuses on the various reports available in BackOffice.
Table of Contents
This section answers questions related to sales reporting.
Can I delete a sale or return from BackOffice?
No, you cannot delete or edit transactions in BackOffice.
Can I check my sales from a phone or mobile device?
Can I see a summary of my sales by day?
No, there is not currently a report that lists total sales by day over a date range. However, summaries of individual days can be viewed via the Analytics Dashboard.
Can I see a summary of my sales by hour?
Sure, view total or average sales per hour using the Analytics Dashboard. Visit the Analytics Dashboard article to learn how to run this report.
Where can I find tip/gratuity reporting?
Is there a report that shows discounts?
Yes, the Sales by Discount report displays detailed information about discounts applied.
How can I tell which of my suppliers have top selling items?
Check out the Sales by Supplier report for a detailed breakdown of item sales by supplier.
Can I view total sales for each department and category?
How can I compare employee sales performance?
Easy, just run the Sales by Employee report to view your top employees and to compare sales performance among employees.
Is there a report that shows items discarded before a sale was completed?
No, there is no such report at this time.
Can I view a report that shows which checks have been voided?
No, voids do not appear on any report currently available at the register or in BackOffice.
How do I compare sales from all of my business locations?
Where can I find cost of goods sold and gross margin?
How is my cost of goods sold affected when I sell/return an item?
When an item is sold, the overall cost of goods sold increases by the cost of the item at the time of the sale. When an item is returned, cost of goods sold decreases by the cost of the item at the time it was originally sold, not by the item’s current cost.
How is sales tax calculated?
Sales tax is calculated at the item-level based on the Tax Groups you have configured in BackOffice. At the register, the relevant tax rate is applied individually to each item on the transaction and rounded to the nearest penny.
Prior to version 2.10.0 of the ShopKeep register app, tax was calculated at the transaction-level, where the subtotal of each item in each Tax Group was summed before the tax rate was applied and then rounded.
Why is tax calculated at the item-level and not based on the sale’s subtotal?
Item-level tax makes it possible to return individual items, calculate taxable and non-taxable sales by tax group, and develop certain reporting features.
Currently, a sale with two items costing $5.51 each and a 9% tax rate would be charged $1 in sales tax ($0.50 per item). If tax was calculated based on the sale’s $11.02 subtotal, sales tax would be $0.99. If one item was returned, how much tax would be refunded: $0.49 or $0.50? Which item gets that extra penny? With transaction-level tax, you can have many “extra pennies” randomly assigned to items. When each sold item’s tax is summed, you can end up with a different total than what was actually collected at the register.
Is there a sales tax report?
Yes, visit the Sales by Tax Group Report article for more information on this report.
How can I figure out my total non-taxable sales?
Visit the Sales by Tax Group report to view taxable sales and non-taxable sales totals for any date range.
Where can I find information on the payment types customers use?
The Sales by Tender report allows you to see which tenders and credit card brands customers most often use when they pay. Visit the Sales by Tender Report article to learn how to run this report.
Where can I see who opened/closed a shift?
Can I print old Z reports?
Yes, you can reprint Z reports from the register for any shift opened within the past 48 hours. Visit the X and Z Reports article to learn how to reprint a Z report.
Can I view X/Z reports in BackOffice?
What gift card reporting is available?
The Gift Cards & Deposits report shows issue and redemption totals for gift cards, gift certificates, and deposits. If you have ShopKeep integrated gift cards, log into the reporting portal for additional reports.
This section answers questions related to inventory reporting.
How can I find my top selling items?
View a list of top selling items with the Sales by Item Report. Visit the Sales by Item Report article to learn how to run this report.
Can I run a sales report for a single item?
Yes, just filter the Sales by Item report so it displays only that item.
How can I find my top selling modifiers or variants for each item?
Easy, just use the Modifiers and Variants report to find this information. Visit the Modifiers and Variants Report article to learn how to run this report.
Where can I download an inventory report?
Export stock items to see price, cost, quantity, SKU, and other details entered for each item.
Which report shows how much my inventory is worth?
The Inventory Value report displays the current value of stock items and raw goods in inventory.
How can I find my inventory value for a certain date?
You must run the Inventory Value report on that date. This report cannot display the historical value of inventory for previous dates.
How can I get an end of year inventory report?
Can I see when inventory items were adjusted?
Yes, those details are in the Adjustment History report.
Can I see when each inventory item was last sold?
Yes. Export your stock items and look at column Q, Last Sold Date.
Can I view or print inventory by department/category/supplier?
Sure, just follow the steps to export your stock items and then sort the export spreadsheet.
Do deleted items still appear on reports?
This section answers questions related to customer reporting.
How can I see a list of all my customers?
Who are my top customers?
Visit the Sales by Customer Report to see which customers have the greatest number of sales, learn who spends the most money, and review other data about how customers shop at your store.
How do I see what a customer purchased?
Can I merge two or more customers’ purchase histories?
No, you cannot merge together multiple customers’ purchase histories.
Can I reprint or email an old customer receipt?
Yes. In BackOffice, you can download receipts from the Transactions Report. Print the receipt to a computer printer or attach the file to an email.
Visit our Using the Register article to learn how to reprint receipts directly from the register itself.
Can I see if customers are clicking the links in my email receipts?
Yes, the Marketing Dashboard breaks down how often customers click social media links in email receipts. This dashboard also displays details on top customers and Customer List growth.
This section answers questions related to staff and employee reporting.
How do I view an employee’s sales?
Check out the Sales by Employee report to view employee sales performance for a chosen date range. Also, you can filter the Transactions Report by employee name or print an X or Z report at the register containing their totals for the current shift.
How do I keep employees from seeing shift reports?
Cashiers can only see their personal shift report, but managers can see shift reports for all employees. If you do not want an employee to view shift report totals other than their own, assign them cashier permissions for the register.
Is there a labor report that I can use to do payroll?
No, but you can use the Time Clock to see each employee’s total hours worked.
This section focuses on miscellaneous reporting questions not covered in the sections above.
Can I adjust or change reports?
The only report you can adjust is the Time Clock report. All other reports are not editable, even if the report contains errors.
Can I delete reports from the Export Center?
No, but reports are automatically removed from the Export Center after 7 days.
Can I print reports from BackOffice?
Yes, most reports have a print and/or export option.
If a report has a print option: click ‘Print’ and print it from your web browser.
If a report has an export option: export the report, open it in spreadsheet software, and print it from there.
A report is displaying the wrong information. How can I get help?
Visit our Analytics Troubleshooting guide for help solving common reporting issues.