Abstract

The Canada Community-Building Fund (CCBF) is a yearly grant given to municipalities, which must be spent on capital projects. While looking at the Village of Barons audited financials and the CCBF payment / allocation data, I noticed what I believe to be a very large discrepancy.

Audited Financials

In 2018, the audited financials started reporting a detailed deferred revenue break down. As the audited financials report the prior year, I chose to use 2017 as the ground truth for this analysis.

Data

Reported Deferred Revenue
Year Deferred
2017 $50,000
2018 $150,000
2019 $20,1694
2020 $251,694
2021 $404,060
2022 $454,060
2023 $504,060
2024 $281,942
2025 $214,270
Realized CCBF Payments
Year Payment Amount
2015 $100,000
2017 $50,000
2018 $100,000
2024 $350,000
2025 $100,000
CCBF Allocations
Year Allocation
2014 $50,000
2015 $50,000
2016 $50,000
2017 $50,000
2018 $50,000
2019 $100,000
2020 $50,000
2021 $100,000
2022 $50,000
2023 $50,000
2024 $68,234
2025 $69,011

Analysis

Year end deferred revenue should be the last years deferred revenue minus any realized payments plus the current years allocation. Which I have calculated as follows:

Year Deferred Start Allocation Payment Deferred End
2017 $50,000 $50,000 $50,000 $50,000
2018 $50,000 $50,000 $100,000 $0
2019 $0 $100,000 $0 $100,000
2020 $100,000 $50,000 $0 $150,000
2021 $150,000 $100,000 $0 $250,000
2022 $250,000 $50,000 $0 $300,000
2023 $300,000 $50,000 $0 $350,000
2024 $350,000 $68,234 $350,000 $68,234
2025 $68,234 $69,011 $100,000 $37,245

This looks completely different from the amounts reported on the villages audited financial statements:

Year Reported (Audit) Calculated (Above) Discrepancy
2017 $50,000 $50,000 $0
2018 $150,000 $0 $150,000
2019 $201,694 $100,000 $101,694
2020 $251,694 $150,000 $101,694
2021 $404,060 $250,000 $154,060
2022 $454,060 $300,000 $150,060
2023 $504,060 $350,000 $154,060
2024 $281,942 $68,234 $213,708
2025 $214,270 $37,245 $177,025

The calculated discrepancies are further substantiated by the February 25, 2021 special meeting minutes: 1

MPE – project funding $248,705 Gas Tax Funding

And the November 8, 2022 regular meeting minutes: 2

Currently the Village has $304,060 in Gas Tax Funds available

Year Calculated Reported (Minutes) Reported (Audit)
2021 $250,000 $248,705 $404,060
2022 $300,000 $304,060 $454,060

Auditor Sanctions

[11] The Scase firm underwent the following: 3

    a. An initial practice review on May 23-24, 2017, in which serious deficiencies were identified in respect of Audit and Quality Control professional standards, including for not-for-profit and municipality clients;

    b. A first follow-up practice review on May 31, 2018, in which the significant deficiencies remained in the same areas; and

    c. A second follow-up practice review on May 27, 2019, in which the deficiencies still remained.

[13] THEREFORE, I, Darryl Scase, CPA, CGA and Scase & Partner, Chartered Professional Accountants, admit to the allegations of unprofessional conduct as set out in the December 22, 2020 motion referring the matter to hearing, in that I:

Failed to comply with professional standards with respect to audit engagements and quality control in that serious deficiencies were noted in the areas of audit engagements and quality control in the three practice reviews conducted of Scase & Partner Chartered Professional Accountants on:

    a. May 23 and 24, 2017;

    b. May 31, 2018; and

    c. May 27, 2019.

Thoughts

This is one of the many reasons I am seriously concerned about the villages grant reporting, and finances in general. I have reported this and other discrepancies to the Minister of Municipal Affairs.

Unfortunately my fellow council members do not seem to share my concerns and have, in fact, taken actions to prevent further review of grant discrepancies.

Data Sources and Datasets

Open Alberta - CCBF Allocations
Open Alberta - Grant Disclosures
Municipal Affairs - Audited Financials

Extracted Data 2014 - 2025 CCBF Village Allocations
2014 - 2026 Barons Grant Payment Disclosure
2017 Audited Financials - Deferred Revenue
2018 Audited Financials - Deferred Revenue
2019 Audited Financials - Deferred Revenue
2020 Audited Financials - Deferred Revenue
2021 Audited Financials - Deferred Revenue
2022 Audited Financials - Deferred Revenue
2023 Audited Financials - Deferred Revenue
2024 Audited Financials - Deferred Revenue
2025 Audited Financials - Deferred Revenue
Source Data

2016 CCBF Allocations
2017 CCBF Allocations
2018 CCBF Allocations
2019 CCBF Allocations
2020 CCBF Allocations
2021 CCBF Allocations
2022 CCBF Allocations
2023 CCBF Allocations
2024 CCBF Allocations
2025 CCBF Allocations


  1. February 25, 2021 special meeting minutes↩︎

  2. November 8, 2022 regular meeting minutes↩︎

  3. Scase (Re), 2021 ABCPA 4↩︎