Understanding and Using the FAN Collection Fund Accounting Models


Event summary

FAN produces the collection fund accounting spreadsheet models for its subscribers (and non-subscribers who wish to purchase them) to assist practitioners with the complexities of accounting for council tax and business rates. The models do not constitute official guidance but are intended to support practitioners in their understanding and application of the collection fund and subsequent general fund accounting requirements.


19 March 2018
Starts: 10:00
Ends: 16:00


Novotel Birmingham Centre Hotel
70 Broad Street
West Midlands
B1 2HT
[See map]

Standard price

£345.00 excl VAT

Network Member Price

£295.00 excl VAT

*the event has started.

About this event

The events will guide you through completing the models and understanding the mechanics of how they work and what they produce so as to maximise their benefit, not only as a closedown tool (bearing in mind quicker closedown) but also in financial planning. During these events we aim to do just that, using worked examples to walk step by step through both the council tax and NDR models, led by Caroline White who developed them.

The models will be updated to incorporate the 100% business rates retention pilots for 2017/18 and the last session of the day will cover their specific requirements and the additional functionality of the models for these.

Alongside these events we are running workshops on completing and accounting for NNDR 3 2017/18. To gain maximum benefit from the model events, practitioners may wish to consider attending the NNDR 3 events first, especially if they are new to the area of collection fund accounting.  

Who should attend?

This event is aimed at practitioners who are new to using the collection fund models for 2017/18 or who require a refresher, to assist in the production of their collection fund and general fund accounting.

How you will benefit

The events will:

  • give delegates a thorough understanding of how the models work and the best route to their completion
  • take delegates through a worked example of the model, step by step
  • provide the necessary skills to quality assure collection fund and related general fund entries
  • explain how the models can be utilised by authorities who are pool leads
  • explain the new functionality of the models for the 100% business rates retention pilots
  • provide the opportunity for delegates to share and discuss the issues and lessons learned from completing the models in previous years.


  • Accounting
  • / Business rates
  • / Financial reporting
  • / Revenues and benefits

Download programme schedule

PDF 133.5 KB

Speaker - Caroline White, Finance Advisor, Finance Advisory Network (FAN)

Caroline White

Caroline has been a Finance Advisory Network advisor at CIPFA since early 2013, supporting practitioners in all aspects of local government accounting and particularly in the technical area of collection fund accounting. E: caroline.white@cipfa.org, T: 01964 533097.