Item 20

Item 20 always is the most challenging item to update. No matter how careful you are, the numbers never reconcile the first time you review them. Here is a list of the reconciliations that I perform to make sure that everything matches.

Table 1 – Double-check the math to make sure everything adds up correctly. This really should be left to the end, because the numbers may change based on what the other tables reveal.

Table 2 – Make sure the numbers in the table match the list of franchisees that have transferred. When you pull the transfer list, make sure that you include the state in which the store was located, not just the state where the former franchisee now lives. Otherwise, the state numbers will be off. For the list of former franchisees, I break the list into 3 categories: transferred stores, terminated stores that were open, and terminated franchise agreements for stores that never opened. By breaking these lists out, it is much easier to reconcile the numbers in the tables.

Table 3 – I start by double-checking the math, to make sure everything adds up correctly. I then compare the ending state totals to the list of current franchisees, to make sure that the numbers match the list. On the first time through, the numbers generally will not match and you will need to go back to reconcile the discrepancies and find the mistakes. For the list of current franchisees, I break this list into 2 categories: currently open stores and franchise agreements signed but store not yet open. This makes it easier to identify where the discrepancies in the table come from.

Table 4 – I also start here by double-checking the math, to make sure everything adds up correctly. I then compare the ending state totals to the list of company owned stores, to make sure that the numbers match the list. Note that this list is pulled only for reconciliation purposes, it does not go in the FDD.

Table 5 – For the franchise agreement signed but store not yet open, I reconcile the numbers against the list that will be included with the current franchisee list. For the other 2 columns, I obtain the information needed from the business people in charge of these areas. These 2 columns are projections of what is expected this fiscal year, so estimates are needed rather than absolute precision.

Your Item 20 will generally take more time to complete than most other areas of the FDD, so once everything matches, the hardest part is done! Good luck reconciling!