When Tiller Money pulls transaction and balance data into a sheet the data will remain there even if you unlink the account from the sheet or close the account. If you no longer want to see this data in your sheet you'll need to either remove it manually or in the case of balances for a closed account you can hide it or zero it out.

Removing the account's data

📺 Video demo below 📺

To remove the Transaction data:

  1. Turn on the filter in your Transactions sheet.

  2. Sort by the Account column. (Tip: turn on a filter to review transactions for only this account). 

  3. Clear all the rows of transaction data for the unlinked/closed account.

  4. If you filtered the account column, clear the filter on the Account column by selecting all accounts. 

  5. Sort the transactions sheet by the date column, Z > A.

To remove balance data:

  1. Open the Balance History sheet (this is usually a hidden sheet).

  2. Turn the filter on for the entire Balance History sheet.

  3. Sort by the Account column.

  4. Filter the Account column by the Account you want to remove

  5. Clear the rows of data for the account. 

  6. Sort the sheet newest to oldest by the Date column.

  7. Turn off the filter. 

Hiding or zeroing out balances

If you have an account that closes sometimes our data provider can't pull in the final $0 balance. You can either hide the account from your Balances sheet or you can create a final $0 entry.

Click here to read more about how to hide the account using the Accounts sheet

To create a final $0 balance

  1. Go to the Balance History sheet (hidden by default, but access via View > Hidden sheets)

  2. Find the most recent balance update row from that account and copy the entire row (right click the row number and choose copy)

  3. Right click the row number and choose Insert 1 above

  4. Paste the row number (right click the row number and chose paste)

  5. Manually edit the details for the copied row to use today's date and change the balance amount to $0

Did this answer your question?