2023-10-10 GnuCash IRC logs
00:26:38 *** jwhite has quit IRC
01:41:32 *** fell has quit IRC
01:42:50 *** fell has joined #gnucash
01:42:50 *** ChanServ sets mode: +o fell
01:50:06 *** giuseppef has quit IRC
02:02:43 *** gandalf has joined #gnucash
02:31:36 *** gncbot has joined #gnucash
02:31:56 *** warlord has joined #gnucash
02:33:16 *** gjanssens has joined #gnucash
02:33:16 *** ChanServ sets mode: +o gjanssens
03:15:22 *** giuseppef has joined #gnucash
03:15:22 *** ChanServ sets mode: +v giuseppef
04:02:06 *** palerider has joined #gnucash
04:29:55 *** palerider has left #gnucash
04:56:28 *** gandalf1 has joined #gnucash
04:56:55 *** gandalf has quit IRC
04:56:56 *** gandalf1 is now known as gandalf
05:02:28 *** gandalf1 has joined #gnucash
05:02:58 *** gandalf has quit IRC
05:02:58 *** gandalf1 is now known as gandalf
05:12:53 *** fell has quit IRC
05:13:19 *** fell has joined #gnucash
05:13:19 *** ChanServ sets mode: +o fell
06:16:08 *** gandalf1 has joined #gnucash
06:16:35 *** gandalf has quit IRC
06:16:35 *** gandalf1 is now known as gandalf
07:12:56 *** nevivurn has joined #gnucash
07:12:56 *** ChanServ sets mode: +v nevivurn
07:19:16 *** Aussie_matt has joined #gnucash
08:08:24 *** chris has joined #gnucash
08:08:24 *** ChanServ sets mode: +v chris
09:07:51 *** gandalf1 has joined #gnucash
09:08:18 *** gandalf has quit IRC
09:08:18 *** gandalf1 is now known as gandalf
09:13:47 *** jwhite has joined #gnucash
09:13:47 *** ChanServ sets mode: +v jwhite
09:18:22 *** gandalf1 has joined #gnucash
09:18:50 *** gandalf has quit IRC
09:18:50 *** gandalf1 is now known as gandalf
09:27:25 *** gandalf1 has joined #gnucash
09:27:52 *** gandalf has quit IRC
09:27:52 *** gandalf1 is now known as gandalf
09:32:16 *** giuseppef has quit IRC
09:32:43 *** giuseppef has joined #gnucash
09:32:43 *** ChanServ sets mode: +v giuseppef
09:33:21 *** giuseppef has quit IRC
09:33:25 *** gandalf1 has joined #gnucash
09:33:31 *** giuseppef has joined #gnucash
09:33:31 *** ChanServ sets mode: +v giuseppef
09:33:52 *** gandalf has quit IRC
09:33:52 *** gandalf1 is now known as gandalf
09:35:29 *** giuseppef has quit IRC
09:35:38 *** giuseppef has joined #gnucash
09:35:38 *** ChanServ sets mode: +v giuseppef
09:39:29 *** giuseppef has quit IRC
09:39:38 *** giuseppef has joined #gnucash
09:39:38 *** ChanServ sets mode: +v giuseppef
09:41:03 *** miklcct has quit IRC
09:42:52 *** gandalf has quit IRC
09:43:31 *** gandalf has joined #gnucash
09:45:39 *** miklcct has joined #gnucash
09:45:39 *** ChanServ sets mode: +v miklcct
09:48:01 *** gandalf has quit IRC
09:48:08 *** gandalf has joined #gnucash
10:07:33 *** giuseppef has quit IRC
10:11:42 *** giuseppef has joined #gnucash
10:11:42 *** ChanServ sets mode: +v giuseppef
10:26:53 *** jervin has joined #gnucash
10:59:16 *** ArtGravity has joined #gnucash
10:59:17 *** ChanServ sets mode: +v ArtGravity
11:12:38 *** chf has quit IRC
11:19:57 *** chf has joined #gnucash
11:21:57 *** Aussie_matt has quit IRC
11:22:09 *** jervin has quit IRC
11:25:03 *** giuseppef has quit IRC
11:36:06 <chris> jralls: why isn't gnc_get_account_separator_string accessible from guile?
11:36:29 *** chf has quit IRC
11:51:41 *** fell has quit IRC
11:52:01 *** fell has joined #gnucash
11:52:01 *** ChanServ sets mode: +o fell
11:59:48 <chris> it's odd...^
12:16:07 *** chf has joined #gnucash
12:23:46 <jralls> chris, it is. You have to `(use-modules (gnucash engine))` to access it. grep for it in bindings/guile/swig-engine.cpp in your build directory to prove it to yourself.
12:38:14 *** AdrienM has quit IRC
12:50:20 *** gandalf1 has joined #gnucash
12:50:48 *** gandalf has quit IRC
12:50:49 *** gandalf1 is now known as gandalf
12:54:01 *** chris has quit IRC
12:54:59 *** sunyibo has joined #gnucash
12:54:59 *** ChanServ sets mode: +v sunyibo
13:00:51 *** gandalf1 has joined #gnucash
13:01:18 *** gandalf has quit IRC
13:01:19 *** gandalf1 is now known as gandalf
13:03:16 *** AdrienM has joined #gnucash
13:03:16 *** ChanServ sets mode: +v AdrienM
13:05:15 *** Tchaika has joined #gnucash
13:05:50 *** ChanServ sets mode: +v Tchaika
13:07:53 <Tchaika> Well that was easy. :D Greetings all. I'm looking to migrate from Moneydance into GNUCash, for a wall of text worth of reasons, and suffice it to say I'm having issues with QIF import. Out of something like 30k transactions, I only get five errors, so you'd think I'm pretty close, but is there no way to narrow these down other than tediously exporting individual accounts with narrow date ranges? Can the QIF importer not give a simple line number for the probl
13:08:34 <Tchaika> https://lists.gnucash.org/pipermail/gnucash-user/2015-February/058179.html <--- This is my issue in a nutshell, four of the first error described and one of the last. This should be easy to fix, I just need a way to find these five problematic transactions in a sea of tens of thousands of non-problematic ones.
13:10:21 *** palerider has joined #gnucash
13:11:21 *** gandalf1 has joined #gnucash
13:11:48 *** gandalf has quit IRC
13:11:48 *** gandalf1 is now known as gandalf
13:13:47 <jralls> Tchaika, we actually recommend that you do break up your import into 1-month chunks, at least for the first few months worth, in order to train the transaction matcher.
13:16:58 *** sunyibo has quit IRC
13:17:46 <jralls> Tchaika Unfortunately there's no way to get more detailed info about errors out of the QIF parser. While a search for "qif linter" turns up nothing there are a variety of qif->ofx converters out there. Some of them might provide better error reporting.
13:21:51 *** gandalf1 has joined #gnucash
13:22:19 *** gandalf has quit IRC
13:22:19 *** gandalf1 is now known as gandalf
13:25:18 <Tchaika> Splitting it into 1 month chunks is a tall order with 15+ years of transaction data. :(
13:26:18 <Tchaika> I think I figured out part of the issue, Moneydance doesn't encode opening balances in a double entry compatible way, so changing those to zero for my investment accounts and then populating the initial balance via a transaction got those to import cleanly.
13:26:47 <Tchaika> I suspect that may be the same issue now with other accounts but am about to have to pause on this to attend to other matters.
13:26:49 <jralls> Do the first 6 months in 1-month chunks then do the reset in 1-year chunks to isolate the errors.
13:27:52 <jralls> IIUC Moneydance doesn't do anything double-entry, it's like Quicken.
13:28:34 <Tchaika> It does with most transactions, it just calls the expense/income accounts "catagories"
13:28:59 <jralls> Yeah, that's not double-entry. There's no account corresponding to a category.
13:29:24 <Tchaika> I guess that's a distinction without a difference from my point of view?
13:29:44 <jralls> It's a critically important distinction if you want to use GnuCash.
13:30:35 <Tchaika> I understand the concept, I'm just saying MoneyDance calls it something else. Catagories in moneydance are accounts with ledgers, they just call them something else, which I concur is silly but transaction wise it's double entry.
13:30:50 <Tchaika> The double entry fail so far is only on the opening account balance and that I can fix easily enough.
13:31:18 <jralls> OK.
13:31:19 <Tchaika> In Moneydance you can open a "Catagory" and view it as a transaction ledger, in QIF export the "Catagory" becomes an account.
13:31:33 <Tchaika> So that part I'm not even mildly worried about, in my brain those catagories already are accounts.
13:31:41 <Tchaika> I suspect they call them that for folks without an accounting background.
13:32:00 <Tchaika> My issue is to figure out how to get a clean QIF import and what issues may be waiting for me after this opening balance thing is solved.
13:32:37 *** bertbob has quit IRC
13:33:08 <Tchaika> There is no clean way to export the data in 1 month chunks as you suggest, that would take hours of tedium. :(
13:33:41 <jralls> Fast compared to the weeks of tedium involved in typing it all in by hand.
13:33:50 *** bertbob has joined #gnucash
13:33:50 *** ChanServ sets mode: +v bertbob
13:34:54 <Tchaika> Yeah that's not gonna happen in any case. At that point I'd either start fresh and keep MD around for historical reference or abandon this migration concept altogether, lol
13:35:06 <jralls> But consider instead just starting over, or maybe hand-creating your accounts tree with opening balances at the beginning of this year and importing only this year's transactions.
13:35:48 <Tchaika> If I have to do that is there a way to preserve cost basis on existing investments? Losing the non-investment transaction data isn't a deal-breaker.
13:36:33 <Tchaika> Honestly already kind of figured it might be a clean start, that's why I'm messing with this now, plan was to run these side by side for the quarter and then make GNUCash the primary for 2024. If I can get the import to work though, huge bonus obviously.
13:37:19 *** gandalf has quit IRC
13:37:27 *** gandalf1 has joined #gnucash
13:39:48 *** gandalf1 is now known as gandalf
13:40:25 <jralls> For investments it depends. If you have a couple dozen open common stocks it's not to onerous to just create them in GnuCash by hand. If you have a bunch of mutual funds with years of reinvested dividends then you probably want to put some effort and endure some tedium to import them while excluding everything else.
13:40:52 <jralls> err, not too onerous
14:01:59 *** palerider has left #gnucash
15:08:22 *** gandalf has quit IRC
15:35:27 <Tchaika> For better or worse it's the latter scenario re investments. I'm going to return to attacking it in a little bit, but I got a seemingly clean import on the investment accounts when I figured out the opening balance thing, so hopeful on the rest.
15:35:55 <Tchaika> Confused why Moneydance went to the effort to make everything double entry (even if they call it something else) EXCEPT for opening/initial balance, but whatever, I'm looking to "fire" them for many reasons, lol
15:45:50 *** gjanssens has quit IRC
15:59:10 *** gjanssens has joined #gnucash
15:59:11 *** ChanServ sets mode: +o gjanssens
16:06:40 *** sunyibo has joined #gnucash
16:06:40 *** ChanServ sets mode: +v sunyibo
17:14:11 *** jervin has joined #gnucash
17:22:55 *** nevivurn has quit IRC
17:25:03 *** nevivurn has joined #gnucash
17:25:03 *** ChanServ sets mode: +v nevivurn
17:32:08 *** gjanssens has quit IRC
18:44:56 *** chris has joined #gnucash
18:44:56 *** ChanServ sets mode: +v chris
18:55:38 *** chris has quit IRC
19:32:48 *** jervin has quit IRC
19:51:39 *** chris has joined #gnucash
19:51:39 *** ChanServ sets mode: +v chris
20:00:03 *** raghukamath has quit IRC
20:12:39 *** raghukamath has joined #gnucash
20:12:39 *** ChanServ sets mode: +v raghukamath
20:28:12 <Tchaika> jralls, I did actually get a clean import once the opening balance issue was fixed. I had almost 30 accounts to fix it on, so it was tedious, but QIF import went through with no effort after that.
20:28:42 <Tchaika> It probably won't be my last pass, I think I need to restructure my chart of accounts to read better in the GNUcash universe, got some reading to do on best practices for that, but progress!
20:29:06 <Tchaika> Should very definitely be able to execute this before 2024 and from the looks of things without losing any historical data.
20:34:40 *** chris has quit IRC
21:56:12 *** nevivurn has quit IRC
22:03:17 *** mosiu has quit IRC
22:03:57 *** Aussie_matt has joined #gnucash
23:11:29 *** bertbob has quit IRC
23:18:39 *** bertbob has joined #gnucash
23:18:39 *** ChanServ sets mode: +v bertbob
23:21:54 *** bertbob has quit IRC
23:30:01 *** bertbob has joined #gnucash
23:30:01 *** ChanServ sets mode: +v bertbob
23:47:02 *** Aussie_matt has quit IRC