Columns are used to time-phase your data. Select:
- None for both dropdowns to remove time-phasing completely
- Major to divide by one date category
- Major and Minor to divide and subdivide (Year, by month)
- only and a minor timescale to subdivide the data. In the below example you can see Project Profit broken down by major timescale quarter and minor timescale month.
Not all major and minor timescales are compatible together. The table below denotes each major timescale and which minor timescales are available for it. Options are limited because if time-scales cannot evenly divide into one another, then Projector can't know whether a split bucket goes in the previous time period or the next time period.
Allowed Minor Scales
Quarter, Month, Half-Month, Day, None
Month, Half-Month, Day, None
|Accounting Quarter||Accounting Period|
|Accounting Year||Accounting Quarter, Accounting Period|
|Operational Quarter||Operational Period|
|Operational Year||Operational Quarter, Operational Period|
Weeks are never available as a minor time scale. This is because a week cannot go evenly into any of the other time periods.
|<Actual and Projected>||None||The data field values will be broken up into two columns. One column will show actual data. The other projected data.|
The data fields will not be broken up by columns.
Accounting and Operational Periods
Date ranges for these periods are defined in the Accounting Period Editor.
In order for a period to be included in the report, you must ensure that the start/end dates as defined on the parameters tab cover the entire date range of the period.
Projector only reports on data from existing GL batches. You may need to create a new GL batch to see the latest state of the system. The batch's status - pending/confirmed/etc - does not matter.
A Ginsu will only match your outside accounting system if all current batches are confirmed.
Because you need a batch in order to report by period, you cannot report on projected data when using periods as a column. And following on from that, because projected data cannot be reported on you should set your use actuals through date to be on or after your end date.
There are a few things like cost card units where we place the data on the cards incurred date. This is because moving units into future periods didn't make sense to us.
Most people know that System Revenue is organized into accounting periods, but what you may not realize is that other types of revenue are too - like contract and billing adjusted revenue!
The ageing report has a special columns fields tab. You manually specify the start and end dates you are interested in. Often these coincide with month end and month beginning.