While we aren’t anywhere near done, we are working towards a Custom Reports option for ACCOUNTS. A draft of the window for specifying them, with a sample filled-in, looks like:
As you can see, it can have from one to four columns of data in the report. Each report can be a Budget for a given date range, Income and Expenses for a given date range, or a Difference between the two previous columns. Differences must be between two Budget columns, two Income and Expenses columns, or one of each.
The report can be for all funds combined (like the existing reports under Reports -> Summary) or split out by fund (like the existing reports under Reports -> Fund).
As with many existing reports, you can set them to include All Levels of Account, Only Top-Level and Subaccounts, or Only Top-Level Accounts.
You also give it a Report Title.
The Date Ranges can be any of the following:
Current Month to Date
Current Quarter to Date
Year to Date
Year to Last Month End
Year to Last Quarter End
Last Year to Date
Last Year to Last Month End
Last Year to Last Quarter End
Custom Date Range
The actual dates included in all of those are calculated for you, except for Custom Date Range, where you type in the dates.
If you Memorize and then replay such a report, the date ranges are re-calculated based on the current date, again except for Custom Date Range which uses the actual memorized dates. (There will be an option to redisplay the memorized Custom Report in the window above, so you can change such dates.)
There are going to be various rules about what ranges of dates are allowed for different columns, including:
- Budget columns must have their range of dates within one fiscal year.
- When you are showing a Difference between a Budget column and an Income and Expenses column, either the two columns must be for the exact same date range, or if the Income and Expenses is for less than a year, the Budget can be for the whole year.
- As in the current Budget reports, partial-year budgets are calculated as appropriate fractions of the entire year’s budget.
We would appreciate any thoughts and feedback you might have about this. Is there anything we have missed that your organization might realistically want, and that isn’t already in one of the built-in reports?
As always, you can reply directly by email, or by adding a Comment on this blog post. Thank you.