Overview
Write a brief description of what the template does.
What is the goal of your workflow? What problem does it solve?
How did you come up with the idea for your workflow?
To provide a method to get account balances that ensured Transactions and Account Balances were always in sync and to get true balances for a specific date, even if Transactions prior to that date were not yet cleared.
The issue is that Tiller sometimes pulls down Account Balances that include Transactions that are not yet downloaded. This creates issues with cash flow calculations.
I also wanted to get true end-of-month, quarter, year, or whenever Account Balances, based on all Transactions from that month. Given the delay in processing Transactions near the end of each month (for example), the Account Balance and Balance History at the end of the month would not include any “pending” Transactions, so they did not have the correct Balances which included all the month’s Transactions.
You can download the Sheet from here.
Installation
Explain how to install the template in their spreadsheet…
Are there dependent sheets?
Where is the template hosted?
What steps are required to add it to a user’s personal spreadsheet?
Simply copy the sheet into your spreadsheet.
Setup
Explain what the user needs to do to initially configure the template…
Choose which Accounts you want to calculate the true balance for, enter the Starting Date and Starting Balance on that date for each Account, and it uses the Transaction sheet to calculate Today’s Balance
Usage
You can these Starting Balances to calculate the balance of any date you want. Simply replace “TODAY()” with the date you want to calculate the balance for…
Permissions
Is it ok for others to copy, use, and modify your workflow?
Yes
Notes
Anything else you’d like people to know?
Let me know if you have any questions or feedback and enjoy!
FAQ
Optionally, add common questions and answers…