Public Sector Accounting and Budget Reporting Training Course

Course overview

Public-sector finance teams must reconcile legal budget authority with financial reporting requirements, demonstrate stewardship of public funds, and explain material variances to executives, auditors, legislators, and service managers. Weak links between the chart of accounts, budget classifications, commitments, accruals, and performance information can produce late reports, overspends, audit findings, and decisions based on incomplete data. This course addresses the practical reporting discipline needed to turn transaction-level financial data into credible budget and accountability reports.

Participants examine the full reporting cycle: budget formulation and approval, appropriations control, commitment and obligation tracking, IPSAS-based accrual accounting, year-end adjustments, budget-versus-actual reporting, variance investigation, and management commentary. They learn to map accounts to programme and economic classifications, build reporting-ready Excel workbooks, calculate key public-finance indicators, prepare cash-flow and financial-position schedules, and distinguish operating variances from timing, scope, price, volume, and accounting-adjustment effects.

The programme is delivered through instructor-led briefings, worked calculations, public-sector case files, and structured report-building workshops. Participants use a realistic government department dataset to create a monthly budget performance pack containing an appropriation-control schedule, variance analysis, forecast, narrative explanations, and action recommendations. They leave with reusable templates, calculation models, report checklists, and an individual application plan for improving a live reporting process in their organisation.

It is designed for finance professionals who already work with ledgers, budgets, or financial reports and need stronger capability in public-sector accounting and budget reporting. It is equally valuable to managers responsible for approving expenditure, monitoring programme delivery, or responding to audit and oversight queries.

Course objectives

By the end of this course, participants will be able to:

• Map a public-sector chart of accounts to administrative, economic, functional and programme budget classifications
• Apply IPSAS accrual principles to recognise revenue, expenses, assets, liabilities and year-end adjustments
• Build an appropriation-control schedule that tracks original budget, revised budget, commitments, actuals and available balance
• Prepare a budget-versus-actual variance report using price, volume, timing, scope and accounting-adjustment analysis
• Construct a rolling expenditure forecast using run-rate, known commitments and delivery milestones
• Reconcile general-ledger balances, commitment records and budget-monitoring reports using a documented control process
• Draft management commentary that explains material variances, risks, corrective actions and decisions required
• Produce a monthly public-sector budget performance pack with supporting schedules and review checks

Benefits of attending

Target competencies

Who should attend

• Public Sector Accountants — who prepare financial statements, budget reports and year-end adjustments
• Budget Officers — who monitor appropriations, commitments, transfers and spending limits
• Finance Managers — who must challenge forecasts and present reliable performance information to senior leaders
• Management Accountants — who translate ledger data into programme-level cost and variance analysis
• Programme and Service Managers — who control service budgets and need to explain delivery-related variances
• Internal Auditors and Finance Analysts — who assess reporting controls, reconciliations and stewardship evidence

Requirements and prerequisites

Participants should have practical experience reading a trial balance, income and expenditure report, balance sheet, or departmental budget monitor. They should understand basic double-entry concepts, including debits, credits, accruals, prepayments and reconciliations, and be comfortable working with spreadsheets using formulas, filters and pivot tables. Exposure to a public-sector chart of accounts, appropriation process, enterprise resource planning system or financial management information system is helpful but not essential. No prior IPSAS qualification, advanced financial modelling, Power BI experience or programming knowledge is required. Complete beginners in accounting should first attend a foundation accounting course.

Training methodology

Each day combines focused instructor-led explanation with guided analysis of a public-sector department case file. Participants work through appropriation registers, chart-of-accounts extracts, commitment listings, trial balances and programme delivery data in Microsoft Excel. Short case discussions test judgement on accruals, budget transfers, overspends and narrative disclosure, while peer review sessions assess whether reports are clear enough for a finance director or audit committee. The final workshop consolidates individual schedules into a monthly budget performance pack and ends with a practical plan to improve one reporting control or report in the participant’s workplace.

Course outline

Day 1: Public-sector financial architecture and budget authority

• Public accountability, stewardship and the purpose of budget reporting
• Appropriations, warrants, allotments and delegated spending authority
• Administrative, economic, functional and programme budget classifications
• Chart-of-accounts design and mapping to budget lines
• Cash, modified cash and accrual accounting bases in public entities
• IPSAS conceptual framework and qualitative characteristics of financial information
• Budget cycle stages from formulation through execution and accountability

Workshop: Participants map a departmental chart of accounts to a programme budget structure and identify reporting gaps in the case dataset.

Day 2: IPSAS accounting and period-end reporting controls

• Recognition and measurement of revenue from non-exchange and exchange transactions
• Expense recognition, accruals, prepayments and cut-off testing
• Property, plant and equipment capitalisation, depreciation and impairment
• Provisions, contingent liabilities and employee-benefit obligations
• Receivables, payables and inter-entity balance reconciliation
• Statement of financial position and financial performance preparation
• Period-end close checklist and supporting-schedule review controls

Workshop: Participants prepare adjusting journals and a reconciled set of financial statement schedules from an incomplete month-end trial balance.

Day 3: Budget execution, commitments and variance diagnosis

• Original, revised and supplementary budgets and authorised virement controls
• Commitment, obligation, invoice and payment stages of expenditure control
• Budget-versus-actual report design and materiality thresholds
• Price, volume, timing, scope and efficiency variance methods
• Distinguishing accounting adjustments from operational performance variances
• Root-cause analysis using programme delivery milestones and procurement data
• Exception reporting for overspends, underspends and dormant commitments

Workshop: Participants build an appropriation-control schedule and produce a variance bridge for three programmes showing causes, risks and corrective actions.

Day 4: Forecasting and management reporting for decisions

• Rolling forecast design using actuals, run-rate and known commitments
• Forecasting payroll, contracts, grants and capital expenditure
• Cash forecasting and liquidity monitoring for public entities
• Scenario analysis for funding cuts, delayed procurement and demand changes
• Key public-finance indicators and dashboard selection
• Microsoft Excel PivotTables, XLOOKUP and conditional-formatting controls
• Management commentary structure for executives, committees and legislators

Workshop: Participants create a forecast-outturn model and a one-page management dashboard for a department facing a projected overspend.

Day 5: Integrated budget performance pack and assurance

• Monthly budget performance pack structure and reporting calendar
• Reconciliation of general ledger, budget register and commitment report
• Evidence trails for audit, internal control and management sign-off
• Budget transfer, supplementary-funding and corrective-action documentation
• Communicating financial risks and recommendations to non-finance managers
• Power BI visual design principles for public-sector finance dashboards
• Personal reporting-process improvement planning and implementation measures

Workshop: Participants assemble and present a complete monthly budget performance pack, receive peer challenge, and finalise an implementation plan for their own reporting environment.

Tools & standards covered

IPSAS, GFSM 2014, Microsoft Excel, Microsoft Power BI

A typical training day

Live online deliveries follow the same structure in the East Africa Time zone, with shorter screen blocks and longer breaks.

What the fee includes

How you can take this course

Certification

Participants who complete the full five days receive the Skillset Development Certificate of Completion, stating the course title, course code, dates and delivery format — suitable for professional-development records and employer reimbursement.

Frequently asked questions