We’ve updated several core reports to provide you with more flexibility, better data visualization, and alignment with standard accounting practices. This guide covers the key changes and "tips and tricks" to help you get the most out of the system. More of a visual learner? Check out a part of our webinar session where we discussed these reports:
General Ledger vs. Transaction List
While these reports look similar, they serve two distinct purposes. Understanding when to use each will save you time during your review.
| Feature | General Ledger Report | Transaction List Report |
|---|---|---|
| Primary Goal | Shows running balances by account. | Shows raw data for individual transactions. |
| Organization | Organized by Account Number (matches your Chart of Accounts). | Organized by Date. |
| Visibility | Breaks transactions apart to show specific account movement. | Keeps both sides of a transaction together in one spot. |
| Best For | Reconciling specific accounts and seeing current balances. | Hunting for specific entries or auditing data entry. |
Pro Tip: The General Ledger report ignores "fancy" account groupings and follows strict numerical order. If something looks out of place, check your account numbering!
The New Consolidated Income Statement
We are working to declutter your reports page by merging multiple versions of the Income Statement into one powerful, customizable report.
Filter by Fund or Tag: You no longer need separate "by Fund" reports. Use the Customize menu to isolate a specific fund or department with the "breakdown amounts by" drop down.
Fund Breakdowns: Under the Customize menu, choose to see funds as Columns (side-by-side) or Pages (each fund gets its own sheet when exporting to Excel).
Sticky Headers: Headers now stay at the top as you scroll, so you never lose track of your columns.
The Unified Budget to Actual Report
The Budget to Actual report has been reimagined to combine the standard view and the YTD comparative view into one "super-report."
Consolidation & Customization
Previously separate reports are now unified. By default, the report shows Current Period and Year-to-Date (YTD) side-by-side. If you prefer the classic view, simply toggle off the YTD columns in the Customize panel and click Save to create a permanent custom view.
Understanding Variance (The GAAP Standard)
The system has moved from "Budget Percentage" to Budget Variance Percentage. This measures how far "off-track" your actual spending or income is compared to your plan.
The Formula:
(Actual - Budget/Budget) x 100
How to Read it:
Income: A positive (+) variance is Good (you earned more than planned).
Expenses: A positive (+) variance is Bad (you spent more than planned).
| Category | Positive Variance (+) | Negative Variance (-) |
|---|---|---|
| Expenses | Overspent (Unfavorable) | Under Budget (Favorable) |
| Income | Exceeded Target (Favorable) | Under Target (Unfavorable) |
The "Actuals Only" Filter Trick
If you do not use "Advanced Budgeting" (budgeting by specific fund), your budget column might appear as zero when you filter the report. To fix this, select "Apply filter to actuals only" in the customize panel. This allows you to see specific fund spending against your total organizational budget.
Beta Preview: Comparative Income Statement
Check out the Comparative Income Statement (Periods) report in the Beta section. This is ideal for side-by-side comparisons over time:
Current Month vs. Previous Months: Compare the current month against the last three.
Multi-Year Comparisons: View FY 2026 alongside 2025, 2024, and 2023 at a glance.
Essential Tips & Tricks
Search with Ease: Instead of a built-in search bar, use your browser’s "Find" function (Ctrl+F on PC or Cmd+F on Mac) to instantly highlight any word, amount, or memo on the screen.
PDF Fit to Page: If you have many columns, use the PDF Fit to Page export option. It will automatically adjust to Landscape orientation to ensure your data fits.
Customize and Filter: When you are making changes to your report, first make changes you need int eh customize panel, THEN use the filters drop downs to filter the format of data down to the information you need
Related to