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) 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.


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


Novotel Leeds Hotel
4 Whitehall Quay
West Yorkshire
[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
  • / Local government
  • / Revenues and benefits

Download programme schedule

PDF 133.5 KB