|
|
|
|
|
by nickjj
1515 days ago
|
|
I didn't include this in my original reply but today is May 1st. Since GnuCash involves manually entering in transactions it's easy to think that'll take a ton of time. I just timed myself and it took 5 minutes to input everything for April 2022 into GnuCash. This includes all income and expenses (personal and business). I'm not even using GnuCash's automated feature for recurring payments too, so that 5 minutes includes manually inputting various subscription costs (I don't have a lot). This also includes a bunch of business related things (estimated tax information, a few income streams in their own "GnuCash Accounts" and a few expense streams in their own "GnuCash Accounts"). I do this by opening GnuCash and my bank's dashboard side by side and then running through last month's entries. Most banks support exporting CSVs and I'm 100% certain I could write a Python script to parse this and auto-import things into GnuCash but since the bank item descriptions for the same transactions change over time I don't want to risk it. The 1 hour per year of manually entering numbers (I copy paste the dollar amounts to reduce human error btw) gives me more confidence than writing that script. I also know to make that script robust enough to consider using it for real in a way that wouldn't require manually checking it would be quite involved. As soon as the script's results require manually checking it for accuracy then you might as well have input things manually without the script. |
|
Later, switched to beancount, it had a CSV importer and I tweaked some example script to do an "interactive" import. Each transaction would be presented and I could accept it as is, or modify it. If I saw a common issue, I could make a copy of the CSV and do a bulk replace, massage the data up front and quickly import.
I'm not saying you need to switch to CSV since your system is working for you. I'm mainly just agreeing that manual entry from a monthly statement can be pretty quick. But for those that are lazy like me that don't responsible balance the books each month, manually grabbing the CSVs and importing many months of statements in an afternoon can still be pretty quick. I would keep the bank statement PDFS + the "official csv" around as a sort of backup. Someone wanting to try GnuCash or any accounting software can start by downloading their statements/csvs for the last year and start punching their transactions in to get a real feel for how working with it will be.