A few pointers, @JWienecke…
First, I generate the Transaction ID column content with the following call:
transactionId = 'manual:'+Utilities.getUuid();
(The important part is the manual: prefix. After that, any random number or string is sufficient.)
Second, you’ll want to put this in the Metadata column:
{"manualTransaction":{"reconcile":true}}
This JSON object will flag it for later reconciliation. Use false if you don’t want to reconcile the manual transaction.
Finally, the account fields (e.g. Account, Account #, Institution and Account ID) need to match between the manual transaction and the subsequent Tiller Money Feeds entry for the reconciliation to be recognized.
Please share your solution with the community if you get it up and running. I’m certain others will be interested— you’ve got a great concept!
Good luck,
Randy