Office - Interactive Reports - Accounting - Sales Tax Detail and Trial Balance

Owned by Benjamin Hacker
Last updated: Aug 16, 2023
2 min read

Table of Contents

Overview

 

Required Permissions

 

Accessing the Tool

Interactive Reports gives you the ability to filter, sort, and group the data using criteria. The available criteria are specific to the information the report contains. The report functions give you the ability to customize date settings, save criteria settings, delete saved reports, and schedule an email delivery. In this section you will learn how to use the criteria and report functionality.

  1. Click on the Interactive Reports Icon from the left menu bar. 

  2. On the Report Overview page, there is a list of reporting categories to choose from, or the User can search for a topic in the top search bar. It is best to keep the topic as broad as possible. If the club wants to see POS sales search for sale.

Sales Tax Detail

Provides all sales detail, both Taxable and Non-Taxable, with a list of Service Charges and Sales Tax for each area. Ability to filter by Area Group, Area, Item Group, Item Category and Tax Code Item.

To run the Sales Tax Detail, choose the report from the Accounting Dropdown,

  1. Enter Start and End date.

  2. Select the Area Groups.

  3. Choose the Item Groups.

  4. Select the Tax Code Items.

  5. Choose how to Group By.

  6. End Date.

  7. Choose the Areas.

  8. Select the Item Categories.

  9. Choose your Detail Level.

  10. Select View Report.

In this example we chose to run the report for 3 weeks in July, showing all available groups, items, and categories. We have grouped by Area and chose the detail level of Tax Code, fully expanding the report. We see the Tax Sales, Non-Tax Sales, Service Charge, Sales Tax, and the totals for each.

Trial Balance

Provides the current balance based on debits and credits as of a specified date with the ability to include or exclude Year End Transactions.

To run the Trial Balance, select the report from the Accounting Dropdown,

  1. Enter the Date.

  2. Choose the Companies.

  3. Choose the Detail Level.

  4. Select View Report.

In this example we ran the report for July 24, 2023 for all companies with the Ledger Account detail level. We see the Account Number, Account Name, Debits and Credits, and the Balance of the account.

In this example we ran the report but chose to Exclude the Year End Transactions. We see the same columns as the previous run of the report.

Best Practices

  • Departmental and Area Access is required to view sales data for most reports.

FAQs

 

Â