fbpx

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.

FAQ

This is a free template built by a member of the Tiller Community. While it’s free for anyone to use, it’s designed for spreadsheets automated by Tiller. Additionally, it’s recommended for use within the Foundation Template.

Tiller is the only automated personal finance service for Google Sheets and Microsoft Excel. Tiller automatically imports your daily spending, income, and balances in your spreadsheets, so you can see all your finances in one place and manage your money, your way. Learn more →

Unless otherwise noted above, this free template is installed with the Tiller Community Solutions add-on for Google Sheets. It's an easy way to browse and install dozens of free, prebuilt sheets for tracking budgets, debt payoff goals, net worth, savings, and more, all from the Google Sheets sidebar.

This template for Excel works best when installed in Tiller’s Foundation Template.

Visit the Tiller Community with any questions about this template.

Notable Replies

  1. Avatar for randy randy says:

    Hey @susandennis!

    This is a cool idea. I’ve wanted something similar too. I gave it a try this afternoon.

    Just copy the Period Comparison sheet from this spreadsheet into your spreadsheet install the Period Comparison template using the Tiller Community Solutions add-on.

    I haven’t done a ton of testing and the features are pretty sparing. Let me know what you think.

    Cheers,
    Randy

  2. 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!!

  3. Avatar for randy randy says:

    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.)

  4. 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!

Continue the discussion at community.tillerhq.com

22 more replies

Participants

Avatar for heather Avatar for randy Avatar for charlotte Avatar for adekunledauda Avatar for alkrongold Avatar for susandennis Avatar for rollmeaway Avatar for yossiea Avatar for brigvb Avatar for kra808

Start Your Free Trial

"There isn’t another tool on the market that does what Tiller can do.”
Will Hinton, Google Review October 30, 2023