How does Tiller Community Solutions identify matches for manual transactions for reconcile?

Google Sheets
#1

We use manual transactions entered via Community Solutions sidebar which results in metadata for transaction looking something like

{"manualTransaction":{"reconcile":true,"ignoredIds":[]}}

We get very poor results when attempting to use Community Solutions “Reconcile Transactions” function. While we understand this logic is somewhat ‘fuzzy’ would expect better results as this functionality consistently misses finding the Tiller Feed transaction where check number and / or Amount matches.

Is there a documented reason that would help us understand how this works better?

#2

Hi @Krywucki,

Thanks for letting us know that it seems inconsistent with matching. I don’t see anything in the docs about how it identifies a match.

@randy can you offer more detail here and possibly update the wiki with how it identifies a match or point us to the section if I just missed it. Thanks!

#4

Thanks I’d like to know this too, I’ve added alot of manual transactions using the migration tool - but to get the reconciliation feature to work, which columns need to have data?

Do they need a transaction ID? what else? At the moment none of the transactions that i’ve added through the migration tool show up in the reconciliation feature.

#5

Sorry I missed this earlier, @annaisakiwi.

I just peeked at the code and this is the gist of it…

  • Amount - exact match
  • Date - within ± specified window
  • Account ID, Account #, Account - exact match on first filled column in this order

The match master must have an Transaction ID that begins with manual: (i.e. created by the Add Manual Transaction workflow. The match candidates must not be manual transactions.

Hope this helps.

#6

Thanks Randy, in this bit:

The match master must have an Account ID that begins with manual: (i.e. created by the Add Manual Transaction workflow. The match candidates must not be manual transactions.

Are you meaning the Transaction ID? when i’ve added manual transactions through the tool it looks to use the account ID, that any other transactions recorded have (if the same account).

Do you know what the requirements are for the Transaction ID column?

#7

Sorry. You are correct. I meant Transaction ID. Thanks.