A model is never right but is sometimes useful.  However, models can certainly be wrong and our techniques help to ensure models are as close to the truth as possible and communicate problems clearly and as soon as they arise. 

  • Consistent rows 
  • No hardcoding 
  • No circular references 
  • No rounding in calculations 
  • Don’t use VBA for calculations 
  • Choose a sensible error tolerance 
  • Integrity checks 
  • Summarise checks by row, sheet and workbook 
  • Double entry summaries 
  • Check anything that can be checked. If in doubt, err of the side of more checks 
  • Consistent columns 
  • Consistent and well-established calculations