Thames-Coromandel District Council

RFP for Budgeting and Forecasting System

We are seeking suitably qualified suppliers to submit a Proposal to enable us to replace set of complex and bespoke spreadsheets as our primary planning, budget and forecasting tool for an integrated off the shelf product that performs the core budget and forecasting functions expected of a modern District Council.

This includes the capability to determine and calculate Loans (both internal and external) and Development Contributions as well as the capability to incorporate the recent changes to legislative changes to water infrastructure (Local Water Done Well) to ensure our finances align to the Disclosure Determination set out by the Commerce Commission.
Also in scope is the requirement to build and publish reports and dashboards. These would include standard reports to aid operational and strategic decisions (up to 30 years) as well as key accountability documents such as the Annual Plan, Long Term Plan and Annual Report which include Financial Impact Statements.

The new system must be able to import actual data from our other systems (Payroll System, Microsoft Dynamics and Monday.com and Universe (AMS). Import data includes both financial and non-financial (by way of example Salary costs as well as FTE numbers). While the new system must be able to accommodate actual financial data at General Ledger level (we are not seeking any to change our existing general ledger structure) we are seeking to transfer five years of financial history from our existing budget system into the new system.

Our expectation is that the next Long Term Annual Plan will be developed using the new Budgeting and Forecasting System.