Accounts tab error in Google sheets

Ask Anything
1

Hello. I hope you are well and feeling all right today.

I have my new Google Sheets Tiller spreadsheet for 2025. It’s been working well from my viewpoint; I don’t do much more than enter transactions in the Transactions tab, and reconcile transactions now and then.
But I’ve noticed that there are no accounts listed on the Accounts tab except one manual account (“Cash”). Somehow, accounts show up in the drop-down list
The header row on that page has columns labeled
A B C D E
Account Class Override Group Hide

Columns F through J have error messages in the header row.
F through I headers show #REF! . The header row for column J says #VALUE! .
Columns K through N have nothing in the header row.
Columns O and P have #REF! in their header row.
Column Q has “Hide” in the header row.

As an example, the content of Column F header row cell is a formula thus:
={“Unique Account Identifier”;arrayformula(if(isblank(INDIRECT(“G2:G”)),iferror(1/0),PROPER(INDIRECT(“J2:J”))&" - “&INDIRECT(“K2:K”)&” (“&upper(right(INDIRECT(“G2:G”),4))&”)"))}

How do I fix this?
I’d also like to populate the sheet with the accounts.
Thank you.

2

It makes me think there might be something wrong with your Balance History sheet, like is it missing the header row and is it updating with new data?

Note that the Balance History sheet is hidden by default.

1 Like
3

I agree with @Mark.S. I’d check two things…

  1. Unhide and peek at the Balance History sheet. Is it filling? Does everything look ok in there?
  2. Delete the Accounts and Balances sheets from your spreadsheet then use the Tiller Money Feeds Add-on to add the Balances template (it will also re-install the Accounts sheet).

If it still isn’t working, let us know.