Value Proposition: GOSI Reconciliation is a Month-End step that prevents the “disappearance” of contribution discrepancies between three systems: Payroll calculates, the GOSI platform/report reflects what has been approved/submitted, and the GL records the liability and expense. The operational issue: Payroll may match with GL but not with GOSI, or Payroll may match with GOSI but the entry in GL differs due to mapping, or there are timing differences (Operating Month ≠ Approval/Payment Month). This GOSI Reconciliation consolidates the three into one file: Payroll reconciliation with GOSI + GOSI reconciliation with the general ledger + GOSI contribution discrepancies with clear reasons + GOSI account reconciliation via rollforward, allowing the month to end with a file that can be delivered for review without additional efforts.

In 20 Seconds: What Will You Get?

• 3-Way Tie-out: Payroll vs GOSI vs GL in one table with “what should equal what?”.
• Payroll reconciliation with GOSI: Total employee deduction + employer share according to Payroll versus GOSI statement/report.
• GOSI reconciliation with the general ledger: Mapping GOSI figures to GL and linking them to liability/expense accounts.
• GOSI variance report: Variance analysis with reasons (Timing/Eligibility/Elements/Retro/Payments/Mapping).
• GOSI contribution discrepancies: Differences log (Owner + action + ETA) instead of leaving discrepancies “unowned”.
• GOSI account reconciliation: Rollforward for GOSI payable/clearing linked to TB/Adjusted TB.
• JE Log: Documented adjustments/True‑ups/Reclass with references.

CTA related to outputs: you will receive 3-way reconciliation + variance report + differences log + rollforward + JE Log + Closing Pack.

Suitable For

• Controller / GL Team: Closing GOSI accounts on TB and linking them to their sources.
• Payroll Team: Interpreting discrepancies between Payroll and GOSI (especially with Retro/Joiners/Leavers).
• Internal Audit / Compliance: A file of evidence proving that contributions are calculated, reconciled, and recorded correctly.

Not Suitable For

• If your Payroll system produces ready and approved 3-way reconciliations monthly linked to GL without discrepancies.
• If there are no GOSI contributions at all (not applicable/other country) — the product will not be used.

Without Reconciliation / With Reconciliation (Brief Comparison)

Before Use: 5 Symptoms That the GOSI Account Will Show Recurring Discrepancies

• Payroll totals do not match the GOSI statement/report for the same period without clear explanation (Timing/Retro/Eligibility).
• GL shows a company contribution entry but the total liability does not equal what is in GOSI due to mapping or classification.
• Discrepancies are resolved once and then return the following month because the root cause is not documented.
• No rollforward for the GOSI payable/clearing account explaining: Opening + current − payments = Closing.
• Upon review: there is no single handover file linking the three pieces of evidence and showing the impact of reconciliations on TB.

How GOSI Reconciliation Works in Practice (Payroll vs GOSI vs GL)?

The reconciliation is managed in two phases: First, establishing the “drivers” (subject wages, employee count, categories/exemptions) so that the difference is understood and not just a number. Second, executing a three-way reconciliation: (1) Payroll contribution summary against (2) GOSI statement/report, then mapping GOSI figures to (3) GL/TB. Any difference is recorded in the GOSI Variance Report with a clear reason (Timing/Retro/Eligibility/Payments/Mapping) and a closing plan, then a JE Log is issued to reconcile accounts and close the GOSI account reconciliation via rollforward and link it to the Adjusted TB.

Implementation Method (3 Steps)

Step 1: Preparation and Report Collection

• Payroll: Total deductions + employer contribution + employee count (or details by category/position).
• GOSI: Monthly contribution statement/report/confirmation for the period (any document proving the due/approved amount).
• GL/TB: Balance and movement of GOSI accounts (expense/payable/clearing) + JE batch reference.
• Payments (optional but important): Proof of payment/transfer to explain the outstanding balance.

Step 2: Reconciliation + Variance Report

• Payroll reconciliation with GOSI: Payroll totals (employee+employer) vs GOSI totals with variance analysis.
• GOSI reconciliation with the general ledger: Mapping from total GOSI to GL accounts (expense/payable) according to your entry design.
• Open GOSI contribution discrepancies in the Differences log:
  • Timing difference (Payroll month ≠ GOSI month)
  • Retro/adjustment not reflected yet
  • Eligibility/exception case
  • Payment posted but not linked
  • GL mapping / misclassification
• Issue a brief GOSI Variance Report: Size of discrepancies + reasons + responsible party + ETA.

Step 3: Account Reconciliation + JE Log + Closing Pack

• Prepare GOSI account reconciliation (rollforward) for the payable/clearing account linking Opening/Current/Payments/Closing.
• Output JE Log for adjustments/True-ups/Reclass (if necessary) with references linking to discrepancies.
• Match Closing with TB/Adjusted TB and document any open items and their closing plan.
• Prepare Closing Pack: 3-way tie-out + variance report + differences log + rollforward + sign-off.

Product Components (Clear Inventory)

1. Payroll Contribution Import
   • Practical Purpose: Consolidate payroll figures (employee deduction + employer contribution) for the period.
   • When to Use: Monthly after Payroll run.
   • Resulting Evidence: Payroll snapshot + run ID.
2. GOSI Statement Import
   • Practical Purpose: Input the monthly GOSI statement/report (due/approved) as a second reference for reconciliation.
   • When to Use: Monthly upon receipt of statement/confirmation.
   • Resulting Evidence: GOSI statement snapshot for the period.
3. GL/TB Import + Mapping
   • Practical Purpose: Input TB and GOSI accounts and link them to the accounts mapping (expense/payable/clearing).
   • When to Use: Within Month-End before issuing Adjusted TB.
   • Resulting Evidence: TB tie-out schedule + mapping references.
4. 3-Way Reconciliation (Payroll vs GOSI vs GL)
   • Practical Purpose: A three-way reconciliation showing the difference at each stage: Payroll↔GOSI then GOSI↔GL.
   • When to Use: Monthly + during any Retro/adjustment.
   • Resulting Evidence: Reconciliation schedule + variance breakdown.
5. Differences Log (GOSI Contribution Discrepancies)
   • Practical Purpose: Convert discrepancies into actionable items with reason codes, owner, and closing time.
   • When to Use: Throughout the month + Week-4 for reviewing open items before closing.
   • Resulting Evidence: Differences aging + resolution notes.
6. GOSI Variance Report
   • Practical Purpose: A brief report submitted to management: size of the difference, why, who is responsible, when it will close.
   • When to Use: Month-End and Year-End.
   • Resulting Evidence: Signed variance report.
7. Control Account Rollforward (GOSI Account Reconciliation)
   • Practical Purpose: Explain the balance of the GOSI payable/clearing account and link it to liabilities and payments.
   • When to Use: Month-End.
   • Resulting Evidence: Rollforward + open items listing.
8. JE Log (Adjustments / True‑ups / Reclass)
   • Practical Purpose: Document reconciliation entries and link them to discrepancies and TB tie-out.
   • When to Use: When discrepancies require accounting entries.
   • Resulting Evidence: JE batch list + references + approvals.
9. Closing Pack + Evidence Index
   • Practical Purpose: Compile evidence in a handover file (Payroll/GOSI/GL/Payments) with sign-off.
   • When to Use: Monthly and Year-End.
   • Resulting Evidence: Closing pack ready for review.

What Should Be Included in the Handover?

• 01-GOSI-Reconciliation-Pack.xlsx: The main file (imports + 3-way recon + reports + tie-outs).
• 02-Payroll-Contribution-Import.xlsx: Payroll totals (employee deduction + employer) + run ID.
• 03-GOSI-Statement-Import.xlsx: Monthly GOSI statement/report (due/approved) + period reference.
• 04-GL-TB-Import.xlsx: TB/GL extract for GOSI accounts (expense/payable/clearing).
• 05-GL-Mapping-GOSI.xlsx: Mapping from GOSI results to GL accounts according to your entry design.
• 06-3Way-Reconciliation-Template.xlsx: Payroll vs GOSI vs GL tie-out + variance breakdown.
• 07-Differences-Log.xlsx: GOSI contribution discrepancies + reason codes + owner + ETA.
• 08-GOSI-Variance-Report.xlsx: GOSI variance report for management + status summary.
• 09-GOSI-Control-Account-Rollforward.xlsx: GOSI payable/clearing account reconciliation + open items.
• 10-Payments-Tracker.xlsx: Payment tracking and linking to liabilities (optional but useful for explaining the balance).
• 11-JE-Log-GOSI.xlsx: JE Log for adjustments/True-ups/Reclass + references.
• 12-TB-TieOut-AdjustedTB.xlsx: TB/Adjusted TB tie-out + differences/resolution notes.
• 13-Evidence-Index.xlsx: Evidence index (Payroll exports/GOSI statements/GL postings/payments) + links.
• 14-Runbook.pdf: Step-by-step operation (Collect → Reconcile → Investigate → Post → Rollforward → Pack).
• 15-Controls-Checklist.pdf: Control checklist (completeness/variance review/approval/aging follow-up).
• 16-Archiving-Map.docx: Archiving tree (Year/Month/GOSI/Reconciliations/Pack) + naming convention.
• 17-Signoff-Page.docx: Prepared/Reviewed/Approved + period + version.

After Implementation (Two Points Only)

• Operational Outcome for the Team: Each month you have a clear 3-way tie-out, and any discrepancies turn into actionable items (reason + owner + closing date) instead of communication loops between Payroll and GL.
• Audit/Compliance Outcome: You can present a single file linking Payroll, GOSI, and GL with GOSI account reconciliation and JE references and TB tie-out within a testable Closing Pack.

FAQ — Questions Before Purchase

Is this an alternative to the monthly GOSI calculation template?

No. This product is dedicated to the three-way reconciliation (Payroll vs GOSI vs GL). It can be run alongside the monthly calculation template if you want to recalculate from scratch, or without it if you have ready Payroll figures.

Is it compatible with any Payroll and ERP system?

Yes. It relies on exports from Payroll and GOSI report/statement and TB/GL extract from ERP.

What if the timing of GOSI differs from the timing of Payroll?

The template handles Timing differences by recording them as a reason in the GOSI variance report, then closing them via rollforward and linking them to payments/periods.

Does it cover discrepancies due to Retro or late adjustments?

Yes. They are recorded as a separate reason (Retro/adjustments) and linked either to Payroll adjustment or JE true-up depending on your design.

Is there a GOSI account reconciliation that can be linked to TB?

Yes: Control account rollforward + TB/Adjusted TB tie-out to explain the balance and prevent accumulation.

Can it be used for multi-entity/branch companies?

Yes, by adding Company/Branch and outputting reconciliations for each entity then Consolidated.

Does it include a JE Log for entries?

Yes: JE Log for adjustments/True-ups/Reclass with references linking to discrepancies and tie-out.

What is the minimum required files for operation?

Payroll totals for the month + GOSI statement/report for the month + TB/GL for GOSI accounts. Adding payment proof enhances the quality of balance explanation.

Ready to close GOSI with a three-way reconciliation and produce a deliverable variance report instead of an outstanding balance?

Outputs: Payroll vs GOSI vs GL tie-out + GOSI variance report + GOSI account reconciliation + JE Log + Closing Pack.