Hello All, I am very new to Tiller. Have my Foundation Template up and running with Add ons of Savings Budget, Budget Journal, and Auto Cat. I have several transactions that were input manually, have cleared my bank, show in my Tiller Daily Update emails, yet when I run “Reconcile Transactions” a …

Did you use the Manual Transaction workflow in the Tiller Community Solutions Add-on to add the transactions or were they added without that workflow? They will not be recognized if they weren’t added using the workflow with the flag set for later reconciliation.

Hi Randy, I did use the manual transaction workflow for each of the transactions and set the flag for reconciliation. Any ideas? K

So you see the “manual:” prefix in the Transaction ID column in the Transactions sheet and there is some JSON data in the Metadata column for the flagged transactions. Can you send an example of the metadata content for one of the transactions (feel free to hide/change anything that is personal).

Hi Randy, I have hidden columns so as to fit the information into the screen shot. This shows two transactions as an example. Mills and CHI St. Luke’s. [image]

The “manual:” prefix in the Transaction ID is a good start. Can you share or show the value in the Metadata column for those transactions?

Hi Randy, Here is the second screen shot displaying the metadata. Sorry I left that off yesterday… [image]

Can you copy and paste the contents here of one of those cells that starts “{manualTransaction…”?

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

Hi Randy, I have checked each item. I have only one account linked to the TMF and it is accurately indicated by Account Name, Account Number and Institution. The amounts are exact. The days have been since July 19th through today. No transactions are reconciling. I have 15 days set as the range to …

Reconcile Transaction Issue

Conversation Ask Anything

randy July 26, 2022, 7:34pm 11

That Metadata looks correct, @kfelicidario. Can you review these criteria and see if another field is amiss between your manually entered transaction and its TMF sibling?

Topic		Replies	Views
Reconcile functioning oddly Ask Anything	1	172	April 14, 2024
How does Tiller Community Solutions identify matches for manual transactions for reconcile? Google Sheets tcs-addon	5	728	June 21, 2022
Tiller Money Feeds Manual Transaction Tool Not Reconciling Google Sheets google-sheets , troubleshooting	4	121	August 23, 2024
How Do I Reconcile Manual Transactions? Google Sheets how-to	3	198	December 15, 2024
Labs Manual Transaction Reconcile Issue Google Sheets tcs-addon	6	1165	August 17, 2021

Reconcile Transaction Issue

Related topics