manually add transactions google sheets foundation

Newly Updated: Add Manual Transactions in Google Sheets

Today we’re excited to share a new Google Sheets feature we’ve moved out of the Tiller Community Solutions add-on and…

Today we’re excited to share a new Google Sheets feature we’ve moved out of the Tiller Community Solutions add-on and into the Tiller Money Feeds add-on: Add Manual Transactions.

This feature makes it easy to add an individual or a few individual transactions at once to your Tiller-powered Google Sheet. If you have an account you’re already tracking manually you’ll also be able to update the balance for that account when you add the manual transaction.

One improvement is that you can now add tags and notes to your manual transactions in the sidebar as you’re adding the other details if those columns exist in your Transactions sheet.

manually add transactions google sheets foundation

You can flag transactions for reconciliation so they can be matched to the automated version when Tiller brings it in, but for now the reconciliation feature is still in the Tiller Community Solutions add-on. We’re working on bringing over the reconciliation features and hope to release that soon.


tiller top may 2022 banner

We’re also hoping to release these features for Microsoft Excel soon too, but for right now they’re only available for Google Sheets.

We’re transitioning features out of Tiller Community Solutions and into Tiller Money Feeds based on popularity and need so that these features get full support from our customer success and engineering teams. Similar to the split transaction feature that recently moved to Tiller Money Feeds, these features are core to many Tiller customers’ workflows and belong in our core product.

Lastly, the Tiller Money Feeds add-on has more limited scopes and permissions than the Tiller Community Solutions add-on. Transitioning these features allows us to make them available to all customers, including those who prefer not to install the Tiller Community Solutions add-on because of its broad access permissions.

Click here to learn more about the Add Manual Transaction tool for Google Sheets.

Other updates to the Tiller Money Feeds add-on

This latest push to Tiller Money Feeds for Google Sheets also includes some major updates including:

  • A bug fix where customers weren’t seeing a warning in the sidebar if their Date header in the Transactions sheet was missing
  • Updated the main Tiller Money Feeds menu (from Extensions) to include a Tools menu where you can find Split Transaction and Add Manual Transaction
  • Enabled a new “runtime” technology that is critical for upcoming improvements we hope to make to the Tiller Money Feeds add-on.

The runtime change may impact customers who are signed in to multiple Google accounts in their browser. If you find that you attempt to launch the add-on and get an “Authorization required” message and the rest of the sidebar is disabled, you can follow these steps to address the issue. You can also reach out to our support team for help by using the chat tool in the lower right corner of the Tiller Console at https://sheets.tillerhq.com/auth/login

What do you think?

Let us know if you have any feedback or questions about these updates by chiming in via the Tiller Community below.

Similar Posts

Notable Replies

  1. Just a quick note that this push introduced an issue where the add-on may have skipped filling some of your data in column A. You would only be missing data in column A if you are affected by this issue.

    For example, if you have your Date in column A you might have noticed transactions ended up at the bottom of your Transactions sheet without the date.

    We have resolved the issue for new fills, but any fills between Oct 18 1:30PM ET and Oct 13 6:18PM ET may have been affected.

    You can fix existing entries by restoring to the version before you last filled your sheet using the Version History option under the File menu and then re-fill your sheet.

  2. Does this apply to Excel Sheets also?

  3. @peterczapor - we have not released this feature in Excel yet.

Continue the discussion at community.tillerhq.com

Participants