Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Table of Contents
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
Overview
This guide highlights the reports within the Accounting Dropdown of the Interactive Reporting module. You will receive detailed instructions on how to run the reports with an example of the data that can be extracted.
Required Permissions
Interactive Reports
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.
Click on the Interactive Reports Icon from the left menu bar.
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.
Accounts Receivable Reconciliation
Identifies discrepancies between Accounts Receivable and the General Ledger. This includes the Sales Journal Batches as a reference.
To run the Accounts Receivable Reconciliation Report, Select Accounts Receivable Reconciliation from the Accounting dropdown.
Select the Ledger Account to run the report against.
Set your Detail Level (how expanded or collapsed you wish to view the report by).
Select View Report to process and produce the report.
In this example you will see we set a date range of one week against our account 1200 with a detail level of Transaction. This produced a report fully expanded showing the Date, SJ Batch, and member amount with columns showing us The A/R Amount, GL Amount, and the Difference if there are any.
Balance Sheet
An overview of current Assets and Liabilities for a period of time. Layout and format may be adjusted via the Overview Tab within the General Ledger dropdown.
To run the Balance Sheet, choose the reportfrom the Accounting dropdown,
Select the Company that this Balance Sheet is for.
Select the Balance Sheet Year.
Select the Period to run.
Set the currency format that you want to show.
Set whether to Show Prior TYD or not.
Select View Report.
In this example we see that we are reporting for all companies in July of 2023 and have chosen to include the Prior YTD so that we can compare current and previous year. .
Balance Sheet Drill Down
Details Asset and Liability transactions that occur by period.
To run the Balance Sheet Drill Down report, choose Balance Sheet Drill Down the report from the Accounting Dropdown,
Set the Company that you wish to run against.
Set the Currency Format.
Choose to Include Account Numbers or not.
Set the report Year.
Choose the Detail Level of the report.
Establish the Period.
Select View Report.
In this exampleyou can see that we ran the Balance Sheet Drill Down for all companies with a year and period of July 2023. We have chosen to run the report partially expanded via the Detail Level of Period and have chosen to Show Prior TYD.
Bank Reconciliation
Provides starting bank balance and any transactions that occurred during the period.
To run the Bank Reconciliation Report, select Bank Reconciliation the report from the Accounting dropdown,
Select the Bank Account that you wish to run the report for.
Choose the Date.
Set the Detail Level.
Select View Report.
In this example we ran the report against our Cash - Operating Account with a date of 9/30/2012 and have chosen the detail Level Transaction so that we can see the Date, Batch Number, Reference given to the batch, and it’s Description.
Cash Receipt Deposit Summary
Details the Credit Receipt Batches and all associated check deposits within that period.
To run the Cash Receipt Deposit Summary, access the report from the Accounting Dropdown,
Set the Year that you wish to run for.
Select the Batch Number.
Choose the Month.
Select View Report.
In this example we ran the report for the month of July 2023. We see the member, the check number, and the amount of the check.
CE Payments Daily Summary
CE Payments Daily summary report pulls in all CE Payments transactions and gives you information on those transactions for a given day.
To run the CE Payments Daily Summaryreport, select the report from the Accounting dropdown,
Choose the Date to run the report for.
Choose the Journal Batchesyou wish to see.
Select View Report.
This In this example of the report contains , we see the Transaction ID, Transaction Date and Time, Ticket number, Amount of ticket, and the Member the transaction was for.
CE Payment Settlements
Provides an overview of all transactions, payments and tickets related to CE Payments to assist with the reconciliation process.
To run the CE Payment Settlements report, choose the report from the Accounting dropdown,
Set the Date range you wish to see.
Set theFilter By parameter.
Choose how to Group the report.
If you have more than one Endpoint, choose which one to view.
Select the Funds in Transit account to report.
Select View Report.
In this example you will see that we ran the report from 5/2022 to 7/2023 and have chosen to Filter By All Transactions and have grouped by Transactions. The report will show us the Ticket number of the transaction with the Amount, Fees, and New Settlement.
Tip: Best to group by Settlements to make investigation easier if you are looking for a transaction within a settlement batch.
Chart of Accounts
List of all accounts in department order based on type Asset, Liability, Income, Etc.
To run the Chart Of Accounts, select the report from the Accounting Dropdown,
Select the Companies you wish to report for.
Select which Department/s to run.
Select View Report.
In this example, we ran the Chart of Accounts for all companies and all department. The report shows us the Account Number, Department, Account and Department Name.
General Ledger Activity
Details activity in the General Ledger by date range with the ability to filter by Department, Batch Type and Account.
To run the General Ledger Activity Report, choose the report from the Accounting Dropdown,
Set the Date Range to run the report for.
Choose the Companies.
Choose the Batch Type to view.
Apply a Filter account or department to run for all accounts or departments with the filter criteria.
Select the Departments to view.
Choose the Detail Level of the Report.
Select View Report.
In this example, you can see that we chose to run the report for 3 weeks in July 2023 and ran at the Transaction level. The report shows us the Account and department, the Beginning Balance of the account, all Debits and Credits, the Net Change and Ending Balance.
In this example, we chose to run the report with a filter, the word Cash has been entered and the results are our accounts with Cash in the name of the account.
General Ledger Activity Summary
Summarizes General Ledger activity by date range with the ability to filter by Department and Account.
To run the General Ledger Activity Summary, access the report from the Accounting dropdown,
Select your Date range.
Choose your Companies.
Select the Batch Type.
Add a Filter if you wish to only report accounts containing the filter.
Choose the Departments.
Select View Report.
In this example you can see that we ran the report for 3 weeks in July for all companies, batch types, and departments. We see the Account, Beginning Balance, Debits and Credits, the Net Change, and the Ending Balance.
In this example we chose to apply a filter. We see all accounts that contain the word Cash. Notice that unlike the General Ledger Activity report we see all accounts, even those without activity.
General Ledger Budget
Outlines the budget based on selected year with ability to filter by Department.
To run the General Ledger Budget, select the report from the Accounting dropdown,
Choose the budget Year you wish to run.
Select the Companies.
Choose the Departments to report on.
Choose the Budget Type.
Select View Report.
In this example we chose to run the Default Budget for 2023 viewing all departments and companies. We see the Accounts, periods 1-12 and the total for the year.
In this example we chose to run the report as a workbook. It runs the same as without workbook but also shows the budget versus actual for periods 1-12.
General Ledger Transaction
Displays transactions in the General Ledger based on Batch Type with ability to filter by Department.
Tip: Can be detailed down to the transaction.
General Ledger Transaction Export
Provides all General Ledger Transactions with ability to export.
Tip: Useful for printing.
Income Statement
Provides the net profit and loss for a specific period with the ability to filter by Department and Budget Type.
Income Statement Consolidated
Provides the net profit and loss for a specific period grouped by either Department or Rollup with the ability to filter by Department and Budget Type.
Income Statement Consolidated by Category
Provides the net profit and loss for a specific period grouped by either Department or Rollup with the ability to filter by Department, Budget Type, and Expense/Income Categories.
Income Statement Consolidated by Category Drill Down
Provides the net profit and loss for a specific period with the ability to filter by Department, Budget Type and Expense/Income Categories. Ability to include Account Numbers and hide Zero Balance Accounts.
Tip: Can be detailed to the transaction.
Income Statement Consolidate Drill Down
Provides the net profit and loss for a specific period with the ability to filter by Department and Budget Type. Ability to include Account Numbers and hide Zero Balance Accounts.
Tip: Can be detailed to the transaction.
Income Statement Consolidate Rolling
Provides the net profit and loss for a specific period providing rolling income backward or forward in time with the ability to filter by Department and Budget Type. Ability to include Account Numbers and hide Zero Balance Accounts.
Tip: Can be detailed to the transaction.
Income Statement Drill Down
Provides the net profit and loss for a specific period with the ability to filter by Department and Budget Type. Ability to include Account Numbers and hide Zero Balance Accounts.
Tip: Can be detailed to the transaction.
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.
Tip: Can detail down to the Tax Code Level.
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.
Tip: Can detail from Ledger Account down to Transaction.
Best Practices
Best Practices
Departmental and Area Access is required to view sales data for most reports.
FAQs
