3.2 Percentages, Ratios, and Reconciliation

Principles of Percentages and Financial Ratios in Public Administration

Financial management in Trinidad and Tobago public sector entities relies heavily on percentages, ratios, and proportion calculations. Clerks in public service administrative and accounting divisions must interpret financial statements, calculate budgetary variances, adjust unit prices for inflation or bulk procurement discounts, and allocate government funds accurately across ministries, departments, and statutory bodies. A thorough understanding of basic and advanced ratio analysis ensures sound fiscal stewardship and error-free reporting.

Percentage Computations and Budgetary Variance

Percentages express fractions as parts per hundred, providing a standardized baseline for comparing financial allocations across fiscal years. In government accounting, clerks frequently compute percentage increases, percentage decreases, and variance percentages between allocated budgets and actual expenditures.

Core Percentage Formulas

• Percentage of a Total: $\text{Percentage} = \frac{\text{Part}}{\text{Whole}} \times 100%$
• Percentage Change (Increase or Decrease): $\text{Percentage Change} = \frac{\text{New Value} - \text{Original Value}}{\text{Original Value}} \times 100%$
• Budget Variance Percentage: $\text{Variance %} = \frac{\text{Actual Expenditure} - \text{Budgeted Allocation}}{\text{Budgeted Allocation}} \times 100%$

Worked Example: Budget Variance Analysis

The Ministry of Works and Infrastructure allocated TT$4,500,000 for road rehabilitation in District A for the fiscal year. By the end of the fourth quarter, actual expenditure reached TT$5,175,000 due to emergency landslide repairs.

1. Calculate the Dollar Variance: $\text{Variance} = \text{TT\$5,175,000} - \text{TT\$4,500,000} = \text{TT\$675,000 (Overbudget)}$
2. Calculate the Percentage Variance: $\text{Variance \%} = \frac{\text{TT\$675,000}}{\text{TT\$4,500,000}} \times 100\% = 0.15 \times 100\% = +15\%$

This positive variance indicates a 15% expenditure overrun, requiring a supplemental warrant or transfer of funds from another sub-head under the Exchequer and Audit Act.

Ratios and Proportional Allocations

A ratio compares two or more quantities of the same unit, indicating their relative sizes. In public service administration, ratios are used to distribute grants, divide administrative overheads, and allocate staff resources among regional health authorities or educational districts.

Dividing Quantities in a Given Ratio

To divide a total financial grant $V$ among entities in the ratio $a : b : c$:

1. Find the Total Number of Parts: $T = a + b + c$
2. Determine the Value of One Part: $\text{Unit Value} = \frac{V}{T}$
3. Calculate Each Entity's Share: $\text{Share}_a = a \times \text{Unit Value}$, $\text{Share}_b = b \times \text{Unit Value}$, $\text{Share}_c = c \times \text{Unit Value}$

Worked Example: Division Grant Allocation

A special community development grant of TT$840,000 is to be distributed among three regional offices (Port of Spain, San Fernando, and Tobago) in the ratio $5 : 4 : 3$ based on population density and geographic area.

• Total Ratio Parts: $5 + 4 + 3 = 12 \text{ parts}$
• Value per Part: $\frac{\text{TT$840,000}}{12} = \text{TT$70,000}$
• Port of Spain Share (5 parts): $5 \times \text{TT$70,000} = \text{TT$350,000}$
• San Fernando Share (4 parts): $4 \times \text{TT$70,000} = \text{TT$280,000}$
• Tobago Share (3 parts): $3 \times \text{TT$70,000} = \text{TT$210,000}$
• Verification Check: $\text{TT$350,000} + \text{TT$280,000} + \text{TT$210,000} = \text{TT$840,000}$

Vote Book Accounting and Financial Reconciliation

Under the Financial Regulations of Trinidad and Tobago, every government ministry maintains a financial control ledger known as the Vote Book. The Vote Book tracks approved budgetary votes, commitments entered into (via purchase orders, requisitions, or indents), actual cash disbursements made via Treasury vouchers, and the remaining uncommitted balance.

Key Vote Book Concepts

• Approved Provision: The total funds voted by Parliament for a specific sub-head (e.g., Sub-head 04: Office Supplies).
• Commitments: Financial obligations incurred when a purchase order or contract is issued, reserving funds prior to actual payment.
• Expenditure (Disbursements): Actual cash payments executed upon receipt of goods and certified invoices.
• Uncommitted Balance: Funds remaining available for future spending.

$\text{Uncommitted Balance} = \text{Approved Provision} - (\text{Total Actual Expenditure} + \text{Total Outstanding Commitments})$

Worked Example: Vote Book Reconciliation Ledger

Consider the following ledger sequence for Sub-head 09 (Computer Maintenance & Software) with an initial approved provision of TT$250,000.00:

Notice that on Oct 20, when Order #101 was paid via Voucher #405 at a final actual cost of TT$14,800.00 (TT$200 less than the original commitment), the commitment of TT$15,000 was liquidated and actual expenditure increased by TT$14,800.00, resulting in a net increase of TT$200 in the uncommitted balance.

Bank and Cash Book Reconciliation

Reconciliation is the process of comparing internal financial records (such as a department's Cash Book or Vote Book disbursements) against external records (such as the monthly Treasury / Central Bank Statement) to identify timing differences, outstanding cheques, unpresented vouchers, and bank charges.

Standard Reconciliation Steps

1. Identify Unpresented Cheques: Cheques written and recorded in the Cash Book that have not yet cleared the bank statement. (Deduct from Bank Balance).
2. Identify Outstanding Deposits: Funds recorded in the Cash Book received on the last day of the month that do not yet appear on the Bank Statement. (Add to Bank Balance).
3. Account for Direct Charges/Credits: Adjust Cash Book for direct bank service fees, standing orders, or direct electronic receipts.

Reconciliation Formula

$\text{Adjusted Cash Book Balance} = \text{Bank Statement Balance} + \text{Deposits in Transit} - \text{Unpresented Cheques}$

Summary of Financial Ratios in Public Service Operations

The table below summarizes common financial ratios and indicators used in public sector financial management:

Mastering percentage calculations, ratio allocations, Vote Book maintenance, and reconciliation techniques prepares candidates to manage public funds with flawless precision.