We also incorporate Rolling 12's into our financial reporting and budgeting. I generally build my projections on a calendar basis, but I then link these schedules to quarterly versions that compare our current period
just ended 12 months to the comparable prior period and then to the anticipate next 12 month period (ie compare 12 mo's ended 9/30/18 with 9/30/17 and projected 9/30/19). This does require you to have some sort of rough future budget for the next year (ie you would need to have 2020's budget prepared once you report Q1 2019, but I typically make that second year out more based on typical flow than an actual backlog. Making the initial templates can be time consuming but i do think reporting on rolling 12's is much more telling than looking at a single month or quarter.
I hope this is helpful.
Chief Financial Officer
O – 205 327 6617
M – 205 283 8936
Home of the Connection Café.
100 Village Blvd., Suite 200, Princeton, NJ 08540Phone: 609-452-8000 | 888-421-9996 | Fax: 609-452-0474 | email@example.com