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