Office - Interactive Reports - Accounting - Accounts Receivable Reconciliation-Chart of Accounts
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 report from 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, choose 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 example you 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, select 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 Summary, select the report from the Accounting dropdown,
Choose the Date to run the report for.
Choose the Journal Batches you wish to see.
Select View Report.
In this example of the report, 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 the Filter 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.
Best Practices
Departmental and Area Access is required to view sales data for most reports.
FAQs
Â
Â