I hope you are doing great. Love your huge smile on your profile pic!.
It is indeed a hybrid model. I have a somewhat complex personal accounting model in excel that takes care of expense tracking and investment performance (some sort of super net worth tracker). I have no use of a budgeting tool, though (no offense, hehee). Nevertheless, tiller has been a godsend for me because of the tiller bot (no more scanning/typing CC statements) and autocat is just pure magic.
The reason I want to import excel tables to go google is because my assistant records all checking transactions/payments “as they happen” in an excel table for each of my checking accounts. I tried using tiller to pull my checking transactions but the problem there is that I have to wait a day for the transaction appears in the transaction sheet. That does not work because a check/transfer needs to be recorded when you execute it; not when it clears. See what I am saying. Therefore I have one table/tab for each account in excel and then I manually import them to my tiller transaction tab just to have autocat categorize the transactions. I then use power query in excel to AUTOMATICALLY import categorized transactions from the tiller transaction tab back to my excel model.
What I am now trying to do, and the reason for my question, is to have google sheets do something similar of what power query does on excel but in reverse…. I am trying to find some google sheets tool to automatically import my excel checking account tables to the transaction sheet for categorization.
Your help will be much appreciated.
BTW, I congratulate the great work you guys are doing…. Tiller has greatly evolved since the first time we chat.