Financial Reporting and Allocations
Financial Reporting and Allocations
This domain tests how Financial Reporting Studio reports are built and how allocation rules distribute balances.
Financial Reporting Studio
A report contains a grid made of rows, columns, and cells. Rows typically come from chart of accounts members or hierarchies; columns come from periods, scenarios, or currencies. Cell definitions apply formulas, formatting, and calculations. Row sets, column sets, and account groups are reusable components. The Financial Reporting Center provides reports, books, and account groups. Smart View supports ad hoc analysis in a spreadsheet.
Allocations
An allocation rule has five parts: pool (the source balances), basis (the driver used to distribute), target (where the allocation goes), offset (the contra entry that relieves the pool), and formula. The pool and basis must have balances in the same ledger and period. Allocation batches run the rules and generate journals. Because the offset relieves the source, the allocation nets to zero across the pool and targets.
Worked example
Allocate $120,000 of rent from cost center 100 to centers 200 and 300 on a 60:40 headcount basis. Pool: rent account in cost center 100. Basis: headcount statistical account. Targets: rent account in 200 and 300. Offset: rent account in cost center 100. Result: 72,000 to 200 and 48,000 to 300, with a 120,000 credit offsetting cost center 100. Reasoning: the offset is what makes the source balance zero after allocation; omitting it would double-count the expense.
Traps
Do not omit the offset. Do not use a basis with no balance in the period. Do not confuse allocation with revaluation or translation: revaluation restates balances in the ledger currency using rates, translation converts a ledger to a reporting currency, and allocation redistributes costs.