Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Major Timescale

Allowed Minor Scales

Notes

Year

Quarter, Month, Half-Month, Day, None


Quarter

Month, Half-Month, Day, None


Month

Half-Month, Day


Half-Month

Day


Accounting PeriodVaries

Please see notes below on reporting by accounting period

Accounting QuarterAccounting PeriodPlease see notes below on reporting by accounting period
Accounting YearAccounting Quarter, Accounting PeriodPlease see notes below on reporting by accounting period

Operational Period

Day


Operational QuarterOperational Period
Operational YearOperational Quarter, Operational Period

Week

Day

Weeks are never available as a minor time scale. This is because a week cannot go evenly into any of the other time periods.

Day

None


<Actual and Projected>NoneThe data field values will be broken up into two columns. One column will show actual data. The other projected data.

<None>

None

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.

...

Tip

Running an Accounting Analysis Report is probably a better choice than Ginsu by Accounting period. If the Accounting report is missing data you need then fall back to a Ginsu report.


Reporting by accounting period requires that you configure dates on the parameters tab carefully. A period will only be included if it's entire date range is encompassed by the parameters. For example, if I have monthly accounting periods and the parameter dates are May-15 through Jun-30 then only June will be included in the output. You also need to set your use actuals through date to be after the end date. Reason being, projected data does not get sent to accounting systems, therefore it is excluded when reporting by accounting period. 

The next important item to consider is tying out a ginsu report to your accounting system. The ginsu report pulls in GL batches regardless of batch status. Pending and failed batches are included in a Ginsu, but won't be in your accounting system. Make sure 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.Finally, time cards that are not in a batch are excluded from the report. You may want to create a batch and send it to your accounting system. 

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.

...

Tip

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!


Tip

In the event that a time card flows into a later accounting period because it's period was closed for GL, the hours are 'zero' and the work date is the last day of the accounting period. For example, a $100 time card in May is approved after month end close. It appears in the June accounting period, has zero hours, and a work date of June-30.