Period cut

The calendar convention an export or report uses: calendar month, 4-4-5 fiscal period, week ending Sunday, invoice date or ship date. Stated on every export; inherited by every report from its ledger of record; compared like to like, with a 53-week period flagged.

DefinitionThe calendar convention an export or report uses: calendar month, 4-4-5 fiscal period, week ending Sunday, invoice date or ship date. Stated on every export; inherited by every report from its ledger of record; compared like to like, with a 53-week period flagged.

Two Marches

Calendar March and fiscal period three differ by a week of invoices. Both are right; the cut is the difference.

Bridged, not summed

A calendar month does not nest in a 4-4-5 period. No identity holds between them.

How it is used

Each export and report states its calendar convention: calendar month, 4-4-5 fiscal periods, week ending day, invoice date or ship date. Comparisons are made only between like cuts.

Example

Sales reports on calendar months by order date. Finance reports 4-4-5 periods by invoice date. March differs by $310,000, all of it timing.

Where it goes wrong

Two correct reports compared as if they used the same calendar.

Articles that use this term

Board and management reporting · Finance and FP&A teams

Automating the sales report: from a manual monthly pack to computed tables

A practical path for a sales operations or finance team that assembles the monthly sales report by hand: what to automate first, the definitions that have to be written down before anything can be computed, the four exports the whole pack comes from, the identity checks that replace the reconciliation week, what stays manual, and the order in which the pack's sections move from spreadsheet to computed table.

16 Sept 20263 min read AI and self-service analytics

Citations on every number: what a citation from an analytics tool must contain

A number in a report or an assistant's answer is a claim until it carries a citation, and a citation has five parts: the table, the row, the period cut, the definition version, and the upload it was computed from. Why each part is there, what a reader does with it, the difference between a citation and a link, how a citation survives a re-upload, and the three shortcuts that turn a citation into decoration.

16 Sept 20263 min read Data quality and reconciliation

Control total and identity: the check against the world, and the check against itself

The difference between a control total, which tests an uploaded file against the figure the source system showed, and an identity, which tests the computed tables against each other, why both are needed and neither replaces the other, the failure each catches that the other cannot, a filtered export against a duplicated account, the order they run in, and what a report says when one of them is unavailable.

16 Sept 20262 min read Data quality and reconciliation

Fiscal calendars and period cuts: why March is not always March

Why two reports for the same month disagree when one uses the calendar month and the other the fiscal period, the four period conventions that appear in a single company, calendar month, 4-4-5 fiscal periods, week-ending Sunday, and invoice-date versus ship-date, the rule that every export states its cut and every report inherits it, the identity that a year's periods sum to the year, and the trap of comparing this March to last March across a 53-week year.

16 Sept 20263 min read How-to guides

How often should sales data be refreshed? A cadence per measure, not one for the tool

Why 'real-time' is the wrong answer to how often sales data should be refreshed, the cadence each measure actually needs, weekly for coverage and pipeline, monthly for share of wallet and concentration, quarterly for norms and segments, annually for definitions, what a refresh more frequent than the measure's cadence does to the reader, and the export schedule that follows.

16 Sept 20262 min read Data quality and reconciliation

Identity and reconciliation: the sum that must hold, and the work of making it hold

The difference between an identity, a sum that must be true by construction, region equals team equals person equals account equals the ledger, and a reconciliation, the work of finding why it is not and fixing the source, why the identity is checked on every upload and the reconciliation is done on the exceptions it lists, the three causes that account for most failures, and why a number is never adjusted to make an identity hold.

16 Sept 20262 min read