This guide is for Google Sheets. We don’t yet have this feature for Microsoft Excel, but hope to have it soon.
The Tiller Money Feeds add-on for Google Sheets has a Manual Transaction tool to help you automate manually adding individual transactions.
Using the Manual Transaction Tool
Launch the Tiller Money Feeds add-on from the Extensions menu at the top of your Google Sheet
Click on the “Tools” menu
Click on the Add Manual Transactions menu item to open the Manual Transaction tool
Select the Transaction type from the Type drop down menu (deposit or withdrawal)
Fill in the details required for your new transaction
Date, Amount, Account, Description, and Category
(Optional) Note, Tags, and Check Number if you have those columns in your Transactions sheet.
Make sure your spelling for the Note column is not plural and your Tags column is, otherwise the Manual Transaction Tool won’t pick up on these columns.
(Optional) Check the box to Update the balance in the Balance History Sheet. This is only available if the chosen account is a manual account.
Click Add Transaction to add the transaction to your Transactions sheet. You can add a single transaction at a time or insert one and then add another by clicking the Add Transaction + 1 button.
Updating Balance History Sheet when adding Manual Transactions
The Update balance in Balance History checkbox will display when a non-automated/manual account is selected in the Account dropdown. When checked, this option will add a balance entry to Balance History that updates the last balance by the incoming manual transaction’s amount. This option is available only for transactions for non-automated accounts.
About Notes & Tags
If you have a Note column in your Transactions sheet you can customize the manually added transaction’s notes in the add-on sidebar. If you do not have a Note column, but want to add one, you can insert a column to the left of the Account column and then reload the Add Manual Transaction screen.
If you have a Tags column in your Transactions sheet you can customize Tags for a Manual Transaction. If you do not have a Tags column but want to add one you can insert a column to the left of the Account column and then reload the Add Manual Transaction screen. Multiple tags can be applied and should be separated by a comma.
Keyboard shortcuts
You can use the basic tab and enter keyboard commands to move between fields more intuitively in the Manual Transaction tool.
Troubleshooting
Some older Community Templates are not compatible with the Manual Transaction tool for Google Sheets
The Category select field shows 'Loading....'
If you're trying to add a manual transaction and there is an issue with Category list, it's possible the tool isn't able to run due to a sheet that's missing or misnamed. Double check your spreadsheet to confirm you have the following sheets and none of them have been renamed:
Accounts sheet
Categories sheet
Balance History sheet (hidden by default)
Important note: When using the tool, wait about a minute to see if the drop down loads. We've seen that this tool can take a few moments to load and isn't instantaneous.
Add manual transaction accounts list is blank
If you're trying to add a manual transaction and get a warning that there was an issue loading your accounts list, it’s possible your Account ID column is missing in your Balance History sheet. Try these steps to fix your accounts list:
Open the Balance History sheet (if you don't see it, open the View menu > Hidden Sheets to unhide it).
Unhide any columns in the Balance History sheet to double check that the Account ID column is not already there.
If the Account ID column isn't in the Balance History sheet already, insert a column to the right of the last visible column (right click and choose Insert 1 right)
If you’ve accidentally renamed your Account ID column at some point, make sure it is reverted to default and named Account ID.
Enter Account ID for the header (row 1) for the new column.
Navigate to Home in the Tiller Money Feeds add-on (or launch the add-on if it was closed).
Click the Fill button.
If this doesn't bring in new Balance History entries with the Account ID you'll need to wait until the next fill when new data is available or you can make a slight change to your account name on the Tiller Console to create a new balance history entry (with the same date, balance, etc) for the account, then repeat step 6.