Period Comparison Spreadsheet
The Period Comparison template allows you to compare budgets, actuals, and budget-net-actuals over two user-defined periods with sorting and sparkline functionality.
About the Period Comparison Spreadsheet
The Period Comparison template allows you to compare budgets, actuals, and budget-net-actuals over two user-defined periods with sorting and sparkline functionality.
Powered by Tiller
This template is designed for spreadsheets powered by Tiller, the only personal finance service based on Google Sheets and Microsoft Excel.
The best way to use this template is by trying Tiller free for a month. Your card isn't charged until the end of your trial, and you can easily cancel anytime. Any data and templates you download during your trial are yours to keep.
See the FAQ to download this template without a free Tiller trial.
FAQ
Continue the discussion at community.tillerhq.com
22 more replies
Hey @susandennis!
This is a cool idea. I’ve wanted something similar too. I gave it a try this afternoon.
Just
copy theinstall the Period Comparison template using the Tiller Community Solutions add-on.Period Comparison
sheet from this spreadsheet into your spreadsheetI haven’t done a ton of testing and the features are pretty sparing. Let me know what you think.
Cheers,
Randy
Randy, This is very cool. It’s pretty much exactly what I wanted! I deleted the budget and available columns because all I really wanted was to see the actuals and this makes that spot on easy to see them perfectly clearly. Thank you!!
Glad to hear it is helpful, @susandennis.
Just made an improvement where the Budget value will prorate partial months.
The equation in
N3:N
is… unpleasant but serviceable.(Since you deleted these columns, this won’t help you, @susandennis… but I did add some period dropdown selectors that you might appreciate.)
Ok those date drop downs are sexy!! Wonderful choices. Plus, it lets me hide the two columns I don’t need instead of having to delete them.
This is just EXCELLENT. Thank you!