Rollover Forward Workpaper Prior-Year Balance Procedure
Reconcile prior-year ending balance, adjustments, current-year activity, opening balance, and ending balance in a rollover workpaper.
Description
A rollover reconciles opening balance from prior closing plus adjustments and closing balance from opening plus activity.
A rollover reconciles opening balance from prior closing plus adjustments and closing balance from opening plus activity. Both reported balances need comparison.1
The returned values include Ending difference, Opening difference, Rollover reconciled. The How section below explains the calculation, input rules and interpretation.
When to use Rollover Forward Workpaper Prior-Year Balance Procedure
Use Rollover Forward Workpaper Prior-Year Balance Procedure when you need to evaluate the supplied records under the calculation and evidence rules below. No source completeness, authorization or balancing entry is established.
Prepare source-backed observations and the applicable engagement policy before entering facts. Use consistent monetary units and periods. Supply all boolean evidence flags explicitly, and treat a successful screen as a reason to continue professional review.
How to use Rollover Forward Workpaper Prior-Year Balance Procedure and understand its results
- Prepare source-backed observations and the applicable engagement policy before entering facts. Use consistent monetary units and periods. Supply all boolean evidence flags explicitly, and treat a successful screen as a reason to continue professional review.
- Enter currentYearActivity, currentYearEndingBalance, currentYearOpeningBalance, priorYearAdjustments, priorYearEndingBalance, tolerance using the field table and calculation rules, then run the tool.
- Read endingDifference, openingDifference, reconciled. The explanation below defines the units, signs, ordering and any flags or placeholder values.
- If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
| Input field | Meaning | Value type; see rules below | Requirement |
|---|---|---|---|
| currentYearActivity | Current-year activity | number | Required |
| currentYearEndingBalance | Current-year ending balance | number | Required |
| currentYearOpeningBalance | Current-year opening balance | number | Required |
| priorYearAdjustments | Prior-year adjustments | number | Required |
| priorYearEndingBalance | Prior-year ending balance | number | Required |
| tolerance | Tolerance | number; minimum: 0 | Required |
Enter finite signed balances/activity/adjustments and finite nonnegative tolerance. Require finite expected totals; return reported-minus-expected opening/ending differences, normalize zero and compare both absolute differences≤tolerance.
expectedOpen=priorEnd+adjustments; expectedEnd=expectedOpen+activity Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.
| Output field | Meaning | Value type |
|---|---|---|
| endingDifference | Ending difference | number |
| openingDifference | Opening difference | number |
| reconciled | Rollover reconciled | boolean |
{
"input": {
"currentYearActivity": -120000,
"currentYearEndingBalance": 880000,
"currentYearOpeningBalance": 1000000,
"priorYearAdjustments": 0,
"priorYearEndingBalance": 1000000,
"tolerance": 1000
},
"output": {
"endingDifference": 0,
"openingDifference": 0,
"reconciled": true
}
}Limitations and assumptions
No source completeness, authorization or balancing entry is established.
Numeric inputs, where present, must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Missing fields without a declared default, extra fields, wrong value types and violations of the calculation rules are input errors. A successfully returned false flag is an evaluated outcome; its meaning is explained above.
Alternative or Complementary methods
Use Lead Schedule Supporting Detail Tie-Out Method Lookup: A lead schedule and supporting total should reconcile on matching units and scope. The residual should remain visible rather than be plugged. For a complementary task, use Adjusted Trial Balance Adjustments Total Tool: Adjusted trial balances apply signed journal changes to explicit account indexes. Balanced adjustments and a balanced closing trial are separate facts.
References
Similar or alternative tools
- Lead Schedule Supporting Detail Tie-Out Method Lookup
A lead schedule and supporting total should reconcile on matching units and scope. The residual should remain visible rather than be plugged.
- Adjusted Trial Balance Adjustments Total Tool
Adjusted trial balances apply signed journal changes to explicit account indexes. Balanced adjustments and a balanced closing trial are separate facts.