Overview

• This guide gives information about the General Ledger reports and how to run them with an example so you can decide how to present the data you are looking for.

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.

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.

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,

1. Set the Date Range to run the report for.

2. Choose the Companies.

3. Choose the Batch Type to view.

4. Apply a Filter account or department to run for all accounts or departments with the filter criteria.

5. Select the Departments to view.

6. Choose the Detail Level of the Report.

7. 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,

1. Select your Date range.

2. Choose your Companies.

3. Select the Batch Type.

4. Add a Filter if you wish to only report accounts containing the filter.

5. Choose the Departments.

6. 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,

1. Choose the budget Year you wish to run.

2. Select the Companies.

3. Choose the Departments to report on.

4. Choose the Budget Type.

5. 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.

To run the General Ledger Transaction, select the report from the Accounting Dropdown,

1. Enter Date range.

2. Choose the Companies for the report.

3. Enter any terms or numbers to Filter by.

4. Choose Detail Level.

5. Select Departments to include.

6. Select View Report.

In this example you can see that we ran the report for 1 week for all companies and departments with a detail level of Account. We see the account number and name, the beginning balance, the debits and credits, the net change and the ending balance.

In this example we ran the report using the word Cash as our filter. Notice that only accounts with the word Cash show.

In this example we ran the report with the Suppress $0 Balance/Activity Accounts option selected.

General Ledger Transaction Export

Provides all General Ledger Transactions with ability to export.
To run the General Ledger Transaction Export, choose the report from the Accounting Dropdown,

1. Select the Date range that you wish to see.

2. Database Code is no longer used.

3. Select the Companies.

4. Select View Report.

In this example we see the report in a more printer/export friendly format. We see the ending date of our date range, the account, account name, the debits and credits, the starting and ending balance, and the net change.

Best Practices

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

FAQs