Services · Diagnostic

General Ledger and Trial Balance Analysis

GLA

Performs diagnostic review of the general ledger and trial balance, including account classifications, unusual balances, reconciliations, mapping to financial statements and data integrity checks.

What changes

Financial data integrity improves; posting and classification errors are identified; reconciliations and audit readiness improve; financial statements are based on cleaner ledgers.

What you get

  1. Risk-based sampling plan and transaction testing workpaper GLA002
  2. Control account reconciliation workbook with exception log GLA003
  3. Variance and trend analysis workbook GLA004
  4. General Ledger and Trial Balance analysis report with recommended adjusting entries and management action plan GLA005

What has to come first

Who is involved

From the National Society's side. This is what the engagement asks of your people.

Your own staff work alongside the adviser throughout, so this is a commitment of their time as well as the Centre's. Ask in the request and you are given the day estimate per role before anything is signed.

RoleWhat they do
HNS Secretary GeneralReceives the report; endorses the action plan
HNS Finance Director / CFOProcess owner; approves adjustments
Finance unit managersReconciliation owners; validation of findings
Finance department staffWalkthroughs, queries, corrective postings
ERP administratorExtracts, module mapping checks
Program and operations managersContext for project and donor balances
GFDC delivery teamPerforms the analysis and advises

How it is measured

IndicatorTargetEvidence
Complete GL and TB extracted and arithmetically verified for all entities in scope 100% of active accounts captured; TB balanced Extraction and completeness checks in GLA001
Transactions tested per the risk-based sampling plan 100% of sampled items tested and documented; extensions recorded where thresholds were breached GLA002 testing workpaper
Control accounts reconciled and exceptions dispositioned 100% of control accounts reconciled; exceptions cleared or escalated within 4 weeks of the report GLA003 exception log
Analysis report and adjusting entries approved by HNS management within target time of fieldwork end 4 weeks Approved GLA005 report and posted entries

Tools

6 of 6 ready to download.

  • GLA001 General Ledger Analysis Tool XLSX
  • TBA001 Trial Balance Input XLSX
  • GLA002 Risk-based sampling plan and transaction testing workpaper Template DOCX
  • GLA003 Control account reconciliation workbook with exception log Template XLSX
  • GLA004 Variance and trend analysis workbook Template XLSX
  • GLA005 General Ledger and Trial Balance analysis report with management action plan Template DOCX

Standards

  • COSO Internal Control - Integrated Framework
  • IFRS / GAAP accounting standards
  • GFDC Operational Framework (intake, triage, service workflow)
  • INPAS reporting standards for non-profit organizations
  • HNS finance manual, accounting policies and close procedures
  • ERP configuration documentation and vendor manuals
  • Donor agreements and reporting requirements
  • External audit management letters and prior year adjustments
  • HNS chart of accounts and cost centre structure

Describe the problem, not the service

You do not need to know which of the 124 to ask for.