Year-to-Date Comparison Sheet - How To Use

Tiller Labs has refreshed our original Year-To-Date Comparision sheet and its ready for use. The new and improved sheet provides budget versus actual analysis for the year to date period. The sheet is very simple and easy to use. It works for the current year.

Get the sheet using the Tiller Labs add-on and View Solutions then Add a Solution and look for Year to Date.

Get the add-on here or read this post for more info about it.

After copying the sheet into your Tiller spreadsheet, you can make 3 selections using the dropdown cells:

  1. Aggregate By: Options are Category or Group.

  2. Sort By: The report can be sorted by any of the columns.

  3. Sort Order: The report can be sorted A to Z or Z to A.

The sheet summarizes in your actual Transactions by Category and Group from the Transactions sheet for the year to date period.

The sheet works best if you are using a Categories sheet that includes budgets by month. The Foundation template includes this. If you don’t have a Categories sheet with budgets by month starting in Jan of this year, then you won’t have any YTD Budget data.

If a category or group doesn’t have an actual amount or a budget amount, it won’t appear in the report. Categories that are set to Hide won’t appear either.

1 Like

Looks cool, @jonorlin. Can’t wait to give this a try.

1 Like

I think your engineers should be conscious that Tiller is used in other countries apart from the US. The date should be easily customised. It is not all countries or individuals that want to use January to December?? In AU, yearly income, payment & Expenses are captures based on financial year July-June. This spreadsheet should be updated to accommodate customised date.

:wave:, @adekunledauda!

Thanks for your suggestion. We are only officially registered in the U.S. and while our data provider does support institutions from around the world, making it possible to use Tiller if you live outside the U.S. (except with EU banks), we’re focused on U.S. date formats, USD, and other U.S. specific conventions. We hope to provide better support for non-US customers in the future. Templates like this one (and all others aside from the Foundation Template) are experimental examples of what’s possible with Tiller’s bank data feeds and not a part of our core product offering at this time.

All that being said, this sheet is specifically built to be installed on top of the Foundation Template, which does allow you customize the fiscal year.

Check out the heading “Adjusting the start month of the budget” in this help article:

Heather

Hi @adekunledauda,
If you want to adjust the YTD Comparison sheet to use any time frame you want, you could make these changes.

  • Unhide Columns H, I, J and K
  • In cell I15, manually enter the start date you want. It should always be the first of the month. For example, 7/1/2019.
  • In cell I16, manually enter the end date you want… OR just keep it as is to use the end date of today.
  • Make sure you have a budget column in the Categories sheet for the starting month and then the next 12 months. If starting in July 2019, make sure there is a July 2019 column.
  • J15 and J16 should correctly identify the column number for the first and current months and K15 and K16 should contact the column letters. If they don’t, you can manually override the automatic results.
  • Re-hide Columns H,I,J and K.

Then the sheet should work for the time period you enter.

Hi,

I did that and the budget was ok but the actual was the problem. The actual still show transactions from 01/01/2019

Any way to correct it?

Thanks

Can you tell me the values you have in O4 and O5?
I may have spotted a bug.

The date in O4 and O5 is

O4 2019-07-01
O5 2019-10-24

OK. That’s good. But you helped me find a related bug.

I’ve fixed it. The new version has been published.
Anyone who installed the sheet before Oct 24, 2019 should go to the Tiller Labs add-on, then Manage solutions and update the sheet. The filter for the date range is now working correctly.

@adekunledauda , Let us know if it’s now working for you.

Thanks!

1 Like

Hm. I just added the labs add-on, and went through the process of setting that up (it had me “adopt” three sheets?), and it tells me I can’t add this new sheet because I already have a categories sheet that will conflict? Any ideas?

Good question, @slcronin. There are two Tiller variants of the Categories sheet. One has the traditional four columns and the other has those same columns + budget information off to the right. The YTD sheet is built for a Categories sheet with budget columns off to the right.

When you adopt a sheet, the add-on assumes you have the variant without the budget. Can you let me know which variant you have?

Randy

Is this just for google sheets or is there a version for Excel with the new logic?

hi @dminches,
The new version was just for Google Sheets.