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 Allocations2014 - 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