Checkbook ledger with codes install#
Checkbook ledger with codes manual#

Getting an accurate starting balance from “Balance History” may be a problem if manual transactions have been entered without updating the history, especially if transactions were migrated/added from before the first Tiller sync.I have already been giving thought to your second suggestion, as many users won’t want to go through the effort of the reconciliation process. Try downloading the template again and it should/better be working. I use Conditional Formatting to hide the date fields when Custom isn’t chosen, and there were some issues with that in the first couple versions I shared. Thanks for the award and the feedback!įor your first comment, I think you’re using an old version, which did have that problem. An Excel version is available here.įunny you should post this today as I’ve been working on the Excel version and should have it ready for release tonight. Note that it’s use isn’t limited to checking accounts, it should work fine with any accounts that you reconcile transactions for in Account Reconciliation. I kept this pretty simple, mimicking the functionality of a real checkbook register. Everything looks correct in my setup (the balances match those on my Balance sheet), but use caution and don’t base any important financial decisions on this template without double-checking the numbers! Let me know if you run into any problems or if the numbers aren’t coming up right. Once the template has been copied, it’s a simple matter of choosing the account you want to see the register for, and the time period you’d like to see the transactions from, both selections are highlighted in green. “Account Register” gets it’s list of accounts, and their opening dates and balances from “Account Reconciliation”, so it’s an important step. Once installed, take the time to fully reconcile the accounts that you’d like to use in the “Account Register” template.

Checkbook ledger with codes install#

If you don’t already have it installed, it will be installed when you install Account Register. Because of this, the “Account Register” template relies on the “Account Reconciliation” template. Getting a reliable running balance requires having a reliable starting balance. Install the template from the Tiller Community Solutions Add-on.