more-arw search

Q&A Forum

Any best practices/recommendations for Financial Model naming conventions?

Looking for some recommendations on how folks name their financial models. Goal is to be able to easily tell: - What month of most recent closed actuals model includes - Forecast version (assume linked to outside file) - Description of scenario Thanks in advance

Answers

Jon Placa
Title: Director of Finance and Operations
Company: NarrativeDx
LinkedIn Profile
(Director of Finance and Operations, NarrativeDx) |

Typical nomenclature:

"[year]-[month]_[Person/Department]_[subject]-[status/notes]"

For example:
"2016-03_Sales_Contract-signed.pdf"
"2016-03_Finance_Projections-work in progress.xlsx"
"2016-03_John Smith_paystub.pdf"

All files will be automatically categorized in chronological order, filterable by Person/Dept

Topic Expert
Christie Jahn
Title: CFO
Company: Prime Investments & Development
(CFO, Prime Investments & Development) |

I also use year - month model.

I used to file mm/yy but then found as you gain multiple years of data it takes longer to locate the actual file you need.

Courtney O'Callaghan
Title: Director of Financial Reporting
Company: Insurance Company NJ
(Director of Financial Reporting, Insurance Company NJ) |

I agree with the yy/mm style (sorts years together) but to know what actuals are in the model, we also use "# months actual + # of forecast" naming convention. For example, in April when we are forecasting the rest of the year and we've closed Q1, we refer to our model as a "3+9". 3 months of actual (Jan-March) and 9 months remaining in the forecast (April - Dec).
1+11
2+10
3+9 ---> Q1 Forecast
4+8
5+7
6+6 ---> Q2 Forecast
7+5
8+4
9+3---> Q3 Forecast
10+2
11+1

1159 views
Topics
Products and Companies

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.