Coming from YNAB, you only needed one number to reconcile an account, your current balance. You login to your account manually, check the balance, and tell YNAB the current balance. If it matches the transactions, YNAB puts a lock on those transactions to confirm they’ve been reconciled.
I saw a duplicate transaction come in to my tiller spreadsheet today, so I did some research on what the reconciliation process looks like with tiller, in case I missed any other import issues. I was brought to this page:
- Waiting until the end of the month.
- Logging into each account and opening the latest statement.
- Inputting 3 numbers from the statement for each account: Starting balance, net purchases, and net withdrawals.
- Going to the Transactions tab in Tiller, and manually marking each transaction, from each account, during the same time period of the statement.
Only then will I be informed if my transactions are off. And if so, I have to go through an entire month’s worth of data to find the error.
Why is this necessary? All YNAB needs is the current balance. Tiller already has the current balance on the Balances sheet, which is completely separate from the transactions sheet. If you edit a transaction, the balance on the Balances sheet for that account does not change.
In short, all the data is there already. Why can’t Tiller reconcile for me? Why can’t Tiller auto-check if the transactions match the balance, and inform me if they diverge?
Am I missing something? Does this sheet already exist?