I’ve been using TillerHQ for years but have a lot of manual work to import transactions from outside sources and categorize transactions.
My monthly TillerHQ process:
ensure all my bank accounts connections are up to date/working
fill transactions from automated accounts
copy/paste 2 external sources of transaction into google sheet and format the sheet into the required csv format
upload 2 manual csv into tiller
categorize manually all transactions (i disabled autocat but could set it up again)
I’m looking to find a way where I wouldnt have to do any of the above steps myself. It takes me between 2-3h/mo. Ideally I just open up the tillerHQ google sheet on my iphone and go straight to the dashboard or a report i’m interested in. I’m interested in the data produced by TillerHQ and not spending time doing operational work.
Wondering if anyone has any thoughts on this. Maybe some folks delegated their TillerHQ process to virtual assistants?
Hi @Pierre - before deciding to hire a VA for help, I’d recommend reviewing the community-supported automation options for the CSV to save you some time.
This community-supported add-on offers a few community built tools for importing data from other tools (Mint, Personal Capital, YNAB, and more).
Use the Basic Bank CSV option to build a workflow for your bank’s CSV format. You can also record a macro to easily re-format your bank’s CSV format for use with this basic bank CSV.
There are more steps to setting this one up, and it will require you to add a custom bound script to your spreadsheet, but it is by far the most flexible option for more easily creating a re-usable mapping for various bank CSVs.
No scripts required. This in-sheet option transforms your data in the spreadsheet and gives you some options for making sure you don’t import transactions a second time.