Use the Balances sheet to review your account balances and when they were last updated. The Balances sheet gives a net worth total and organizes accounts by asset and liability as well as group if you have those configured on the Accounts sheet. 

By default accounts are grouped under Ungrouped Asset or Ungrouped Liability headers. You can customize this using the Accounts sheet. Read more below about the Accounts sheet.

Using the Accounts sheet to customize accounts

The Accounts sheet is a hidden sheet in the Tiller Foundation template. You can use it to customize or correct details about your accounts. 

The dropdown list in column A is populated from the Balance History sheet (another hidden sheet in the template). 

Choose an account and then customize. 

You can override the class (asset or liability) if it’s being assigned incorrectly. 

You can assign the account to a group, which will change the way it’s organized on the Balances sheet. 

You can hide the account from other reports by using the “hide” flag on the Accounts sheet. 

If you need to rename an account, do this on the Tiller Console under Account Summary. After renaming an account you will need to re-select accounts on the Accounts sheet from the dropdown in column A.

Increasing the Account Visibility Limit in the Foundation Template

If you find that some of your accounts are visible in the dropdown on the Accounts sheet or aren't displaying on the Balances sheet you may need to expand the formulas to increase the visible account limit.

  1. Unhide the Accounts sheet (View menu > Hidden sheets) if needed.

  2. Unhide the columns to the right of column D in the Accounts sheet (click the small black arrow at the top of the last visible column)

  3. If you have more accounts than the Accounts sheet supports, you should see Account IDs in column G extending beyond the “Unique Account Identifier” in column F.

    1. Expand the formula in H102 to the bottom of the spreadsheet to populate the account detail fields.

    2. Expand the formula in F101 to the bottom of the spreadsheet to populate the “Unique Account Identifier” field.

  4. You can re-hide the columns to the right of column D in the Accounts sheet now

  5. Unhide the columns to the right of column I in the Balances sheet

    1. Expand the formula in J102 to the bottom of the spreadsheet to populate the asset-account detail fields.

    2. Expand the formula in Q102 to the bottom of the spreadsheet to populate the liability-account detail fields.

  6. In the Balances sheet, expand the formula in B104 to the bottom of the spreadsheet to populate the visible asset-account fields.

  7. In the Balances sheet, expand the formula in F104 to the bottom of the spreadsheet to populate the visible liability-account fields.

  8. You can re-hide the columns to the right of column I in the Balances sheet now

  9. The Balances sheet often has hundreds of empty rows at the bottom. Consider trimming— deleting rows from the bottom up— extraneous rows (well beyond the rows that are populated) to improve performance by removing redundant formulas.

Did this answer your question?