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.
| Symptom | Check | Likely fix |
|---|---|---|
| Latest date is old | MAX of date column | Fill gap from statements; ask provider about the connection |
| Totals too low | Range lengths | Extend ranges |
| Duplicates | COUNTIFS on date, amount, text | Delete extras after checking |
| Dates sort wrongly | Cell format | Convert 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
- Latest date is within a few days of today.
- Row count matches the statement.
- Closing balance reconciles.
- Summary ranges cover every row.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


