Semi Automatic Statement Uploading
I use YNAB in such a way that I update my transactions to YNAB on a monthly basis. This way I dont have to worry about registering expenses every day.
What I usually do is
- I export my banks statements (as there is no integration supported by YNAB for UBS or Revolut accounts)
- I convert the statements to YNAB supported format
- Upload the statements
- Do the budgeting for the next months or two and analyze
What is your opinion on this method?
I would like to further automate this method such that
- I just upload my bank statements directly to a dropbox folder
- BOOM the statement transactions get loaded onto YNAB with some code I wrote
Therefore causing the system to just be a one human intervention to load the transactions to YNAB, once per month, or once per period that I want to be updating YNAB.
Please share your thoughts on this. Would love some inputs.
Hi Maroon Leopard !
I appreciate you being thorough in explaining how you use YNAB! To me, it sounds like you're using YNAB as a tracking system, and not a budgeting system?
YNAB is meant to be very hands on (as often as you spend money!), so I don't have any tips on how you can automate things more, in fact, I recommend automating things even less! 😉
To start, I suggest taking a step back and reading over the YNAB method (we all need a refresher sometimes!) or take our "Learn the Four Rules" workshop. YNAB helps you look forward and proactively decide where to spend your money (budgeting!) instead of looking back and kind of wondering, “Gosh, what happened? Where did it all go?” which is what most financial tracking software does.
Let me know if you have any more questions at all!Reply
Hi Jannelle ,
Thanks for your response. I could not agree with you more, I will most definitely re-read the material you have shared. But this is exactly the issue that I feel I am trying to solve with this process. As the steps of Rule 1 describe:
- Get some dollars.
- Prioritize those dollars.
- Follow the plan.
Follow the plan is where I struggle as I don't like to manually register ALL the transaction that I make every day I find this excessively time consuming, and therefore cannot follow the plan.
Much like you said "YNAB is meant to be very hands on (as often as you spend money!)", the money spent needs to be updated to YNAB as often as possible, my goal here is to be able to increase the frequency that I update YNAB from monthly to a weekly or daily basis by just being able to upload statements to the converter which pushes them to YNAB. Is this method really going against the YNAB principles?
Sincere question: what is the benefit of YNAB to you? It is a very expensive solution for the kind of post-hoc tracking you’re doing.
WordTenor currently my solution is post-hoc, but I want to be able to do it ad-hoc but without too many manual inputs from my side. Does that make sense?Reply
Hi Maroon Leopard ,
Thanks for your reply. dont mind you jumping in at all ;) Inputs and feedback is what I would like.
I don't know specifically which discussions you are referring to but if you could share them that would be fantastic.
here are a few users who have written code to pull transactions directly from their bank accounts, which would cut out the middle-man in this instance.
Ideally, this is precisely what I would like to be able to do, but in order to achieve this, one would need an API to be provided from their corresponding bank. In my case, there are no API's available for the two banks I am currently using: Revolut and UBS (or at least as far as I am aware). Therefore have no way to pull the data from automatically.
Outside of relying on that automatic import, is there anyway you could find the time to increase how often you're importing transactions? I imagine importing once a month means you're dealing with a lot of transactions which could take a sizable amount of time. However, if you switched to importing even once a week, you'd be dealing with less transactions which should make for a faster process.
Couldnt agree more, this is the reason why I would like automatic parsing of statements as on a daily/weekly basis could be the next best thing.
Please be aware: that this solution I propose is not for everyone, it is really for those of us who:
- Do not have a bank that offers an OpenAPI to interact with
- Are lazy and dont want to input each transaction they make manually