The Tax Detail report provides a line-item audit of every taxable transaction, closed check, and tax calculation within a selected time period. Breaks down sales tax liabilities at the individual guest check and menu item level, making it easy to verify tax-exempt justifications, audit specific tax rule applications, and cross-reference tax amounts with individual transaction histories.
This report allows you to:
- Audit individual sales tax calculations down to the guest check and menu item level.
- Review and verify tax-exempt reasons and authorizing manager details.
- Group and organize granular tax records by Location, Tax Rule, Order Type, Revenue Center, or Daypart.
Filtering the Tax Detail Report
You can adjust the filters at the top of the page to refine your results for the entire report.
- Location: Select a Location (or location group) by ticking the box next to the desired location from the drop-down menu. You can also select All Locations (the default).
- Report View: Select a saved Custom View or the default Base Report from the drop-down menu. You can also create a new Custom View from this menu. For instructions, please see the article: How to Customize Reports in the Bridge.
- Date: Select a predefined date range (like Today, the default) or select a custom date range using the date picker.
Interacting with Report Sections
The report includes a set of controls to customize its appearance and export its data.
- Download: Click the Download icon (downward arrow) to export the data from the report as a CSV, Excel file, or download the entire report as a PDF.
-
Gear Icon Options: Click the Gear icon (⚙) to open a menu with additional report controls:
- Report Style: Change the grid's density. Options include Regular (the default), Compact, and Large.
- Schedule Report: Open the scheduling window to configure daily, weekly, monthly, or annual reports.
- Full Screen: Expand the Tax Detail Report to fill the screen.
- Sort Columns: Click any column header to sort the data in ascending (A-Z) or descending (Z-A) order.
- Reorder Columns: Click and drag a column header to a new position in the grid.
- Column Options: Click the three-dot menu on a column header to open more options.
Note: Making changes to options will activate the Save Changes button. These grid customizations can only be saved to a Custom View. If you are currently in the Base Report view, clicking Save Changes will prompt you to create a new Custom View to keep your layout.
Understanding the Metrics
The Tax Detail report organizes granular transaction details into defined columns to provide a clear view of tax calculations. You can enable or disable these columns to tailor your view.
- Closed At: The exact date and time the guest check was closed.
- Tax Reason: The specific reason or tax-exempt justification attributed to the check.
- Check: The unique identification number assigned to the guest check.
- Menu Item: The specific menu item sold.
- Fee Item: Any individual service charge or item-level fee applied.
- Reporting Category: The reporting category associated with the menu item.
- Tax Amount: The exact monetary amount of tax collected for this transaction line item.
- Daypart: The service period (e.g., Lunch, Dinner) during which the transactions occurred.
- Business Date: The fiscal business date the transaction is attributed to.
- Revenue Center: The specific area of the restaurant (e.g., Bar, Dining Room) where the transactions occurred.
- Order Type: The classification of the order (e.g., Dine In, Take Out).
- Tax Rule: The specific tax rate rule applied to the transaction.
- Location: The restaurant location where the transactions occurred.
Grouping Options
In addition to the columns above, you can further organize the report data by adding the following fields to the Row Groups section:
- Location
- Tax Rule
- Order Type
- Revenue Center
- Daypart
- Check
- Tax Reason
To do this, click and drag the field into the Row Groups section.
Comments
0 comments
Please sign in to leave a comment.