Getting started

Tiller not working: how to check a sheet that stopped filling

Tiller not working and your spreadsheet stopped updating? Check the last row, the formulas and the ranges, then fill the gap and keep the sheet safe.

Editorial illustration for Tiller not working: how to check a sheet that stopped filling

If your Tiller sheet has stopped filling with transactions, check three things in order: whether new rows really stopped arriving, whether your own formulas and ranges still see them, and whether the data connection needs attention. Tiller is a tool that feeds bank data into a spreadsheet, and we cannot describe its screens or limits, so use its help pages for product steps. The checks below work on any sheet.

Did new rows really stop?

Sort the transactions by date, newest first, and look at the latest one. Or use a formula: if dates are in column A, =MAX($A$2:$A$2000) shows the most recent date, and =TODAY()-MAX($A$2:$A$2000) gives the days since. If the answer is large, rows stopped coming. If the answer is small but your totals look wrong, the problem is in your formulas, not the feed.

Are your formulas still reading the new rows?

  • Ranges that end at a fixed row, such as $A$2:$A$500, will miss rows added below it. Extend them, or use a bigger range.
  • Filters left switched on can hide new rows from view.
  • Rows pasted as text dates will not match date conditions.
  • Summary tabs may point at a copied tab rather than the live one.

Worked example: a total that is too low

Say your monthly summary shows ₹38,200 for food, but you remember spending more. The transaction tab has data down to row 520, and the summary formula reads $C$2:$C$500, so it ignores rows 501 to 520. Those 20 rows add ₹6,350 of food. The true total is 38,200 + 6,350 = ₹44,550. Changing 500 to 2000 in every range fixes the problem for a good while. A quick check: =COUNTA($A$2:$A$2000) counts used date cells, and if that number plus 1 is greater than the last row in your summary ranges, those ranges are too short.

SymptomCheckLikely fix
Latest date is oldMAX of date columnFill gap from statements; ask provider about the connection
Totals too lowRange lengthsExtend ranges
DuplicatesCOUNTIFS on date, amount, textDelete extras after checking
Dates sort wronglyCell formatConvert text dates to real dates

How do you fill the gap?

Download the statement for the missing days from your own bank and paste rows beneath the last good one, in the same column order. Then check the balance: last good balance, plus credits, minus debits, should equal the statement's closing balance. Before you switch the feed back on, note the date range you entered by hand, then search for doubles.

When does a sheet stop being enough?

A sheet is flexible, but you maintain every formula. If you would rather upload a statement and review categorised rows, SpendixAI takes PDF, CSV or Excel files, with no bank connection and no net-banking login. Your corrections become history for next time, and there are ready-made reports and a CSV download. It is a different way of working, not a drop-in replacement for a sheet you have built yourself.

How do you stop the problem returning?

Give each sheet a small status area at the top: the latest transaction date, the number of rows, and today's date. If the latest date is more than a few days old when you open the file, you know before you read any totals. Keep a dated backup copy each month. Write down which tab holds the raw rows and which tabs only summarise, and never type over a summarising formula by hand.

A monthly health check

  1. Latest date is within a few days of today.
  2. Row count matches the statement.
  3. Closing balance reconciles.
  4. Summary ranges cover every row.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports