What is the proper way to transfer and close a manual account?

Discussion
1

Hello, say I have some $100 in cash “Money from Grandma” and I’d like to track it in Tiller, so I create a manual account for it. At a later point, I deposit the cash in my (already tracked) bank account, and as of today that money is reflected in the new Tiller balance for that bank account.

I’d like to “properly” reflect the transfer, nullification, and closure of that manual account. Here’s what I’ve done so far:

  1. In the Transaction sheet, I added one transaction for the “Money from Grandma” account, in amount of -$100. That reflects the extraction of the cash from that account. The date of the transaction is the same date as the date of the transfer according to the bank (which Tiller has already loaded).
  2. In the “Balance History” sheet, I added one entry for “Money from Grandma”. The new balance of that entry is $0, reflecting the account has been depleted. The date and time is the same as the date/time for the bank account balance that is updated with the transfer.
  3. In the “Accounts” sheet, I choose “Hide” for “Money from Grandma” so it does not clutter other pages anymore.

Now everything seems to be in good order. (Anything I missed?) At a point, I’d like to remove that account entirely, yet keep its history of transactions. What steps do I need to do that?

2

Hi @andrei,

I believe you have accounted for everything.

You probably have already reviewed these workflows linked below. In case you haven’t, I’ve included them for your reference.

Note: If you are paid in cash, and thus no ATM withdraw transaction appears on your Transactions sheet simply add a row anywhere on your transactions sheet and fill in the details of the cash income transaction.

Note: When Tiller 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.

Clint

1 Like
3

Only problem I see here is you are going to be removing that Cash by using “Hide” in the Accounts sheets (which was part of your Net Worth) from your Net Worth history and any other sheets that may utilize historical data. If you care about preserving historical Net Worth data, here is my easy solution to that.

2 Likes
4

Fantastic, I made these edits and works like a charm. I even changed retroactively an account from Hide to Closed.
This should be a standard feature. Thanks much!

2 Likes
5

Great to hear. I agree - hopefully Tiller will incorporate it in the future because it seems like a missing feature that should come out of the box.

1 Like