📝 Overview

The GL Report allows you to track and export your organization’s general ledger activity for reconciliation in external financial systems. By selecting from a variety of pre-formatted export options, you can generate files that match the requirements of your accounting software.

This feature ensures accurate financial reporting, reduces manual adjustments, and helps streamline the handoff between program revenue in the software and your general ledger. You can run the report by location, program, and date range, then choose the export type that best fits your workflow.

⚠️ For products that use split GL codes, use the GL Report – Split GL Codes instead.

🔑 Authorizations

Click the arrow to learn which roles can access the General Ledger report

To run this report, a role must include the GL Sales Report authorization.

If the role also has Global Financial, the format settings you choose (for example, basis, payment type, and offsets) are saved for your next session.

📍 Where

Click the arrow to learn where to access the GL Report

From the top menu, click on Reports. Select General Ledger.
Use the Global Search bar at the top of the page and type GL Report. General Ledger will appear as one of the search options

🛠️ Setup

Click the arrow to learn how to set up the General Ledger report before exporting

Confirm GL Codes are entered for each product you plan to include.
If your company uses JDE financial system, please email our support team at [email protected]. We will need to turn a specific feature on to allow you to Add Fund codes to each of your GL Codes.

📂 Available Export Options

The following export formats are currently available in the General Ledger report:

Default (CSV)
BS&A CR
BS&A GL
JDE Financial
Munis
Munis – Cash Misc Precursor
New World
New World – CSV
Sage
Springbrook Financial

👉 More export types may be added in future updates to support additional financial systems.

⚙️ How It Works

Click the arrow to learn how to run and export the General Ledger report

Set a Date Range:
- Use a predefined option (such as Last Month)
- Or enter custom Start and End Dates/Times
From the format type drop down, select from one of the following financial software systems: BSA&A (CR or GL), JDE, Munis, New World, Sage or Springbrook.
Depending on the selected software, configure any specific settings required for the export (accrual vs cash basis, payment type, cash and credit card receipts offset values).
Click Search to preview the report results.
Click Export to download the file.

💡 If your role includes Global Financial, your report settings will be remembered for the next time you run the report.

💡 Pro Tips

⚠️ Confirm the correct export format with your finance team before running the report.
🧠 If you have Global Financial, your format and setting choices will be remembered next time.
💬 Use Default when testing or if your financial software isn’t listed.
⛔️ Using split GL codes? Run the General Ledger – Split GL Codes report instead.
📌 For JDE with fund accounting, verify Fund Codes are enabled on GL Codes before exporting.

❓ Frequently Asked Questions (FAQs)

Click the arrow to view frequently asked questions