Tiller’s data feed adds new balance records to the Balance History sheet sometimes more often than once per day. As time passes, the balances dataset can become very large, causing decreased spreadsheet performance.
The Trim Balance History utility removes extraneous balance history entries by trimming them down to a single balance entry for each day, week, or month (for each account). The frequency you’d like to see is configurable. You can choose all accounts or a single account for trimming.
- Open (or Install) the Tiller Community Solutions add-on from the Add-ons menu at the top of your Tiller-powered Google Sheet.
- Navigate to Tools > Utilities > Trim Balance History. The workflow will check for compatibility issues.
- Leave “All accounts” selected if you want to trim all accounts or choose an Account from the Account(s) dropdown list.
- Choose your frequency from the Balance History Frequency dropdown list. You can choose to keep one balance history entry per day, week, or month for all or a single account. If you’re trimming one account at a time, you can choose a different frequency option per account.
- Click the Trim button.
- Before deleting the Balance History entries, you will get a confirmation dialog— e.g. “Ready to trim 174 Balance History rows. Are you sure you want to proceed?”
- Click Yes.
Be aware that modifications from the Balance History Pruner can only be undone using Sheet’s Version History tools.
- The trimmer will always preserve the most recent balance history entry for all accounts.
If you have a question or need help first search the community to see if someone has already asked and if not click here to quickly post a question about this tool in the Get Help > Workflows & Tools category.
Be sure to customize the title of your post with keywords about the issue or question so others can easily find the Q&A in search.