2022-09-30 GnuCash IRC logs

00:16:50 *** Aussie_matt has joined #gnucash
00:36:56 *** FH_thecat has quit IRC
00:41:49 *** FH_thecat has joined #gnucash
01:06:51 *** fell has quit IRC
01:08:10 *** fell has joined #gnucash
01:08:10 *** ChanServ sets mode: +o fell
01:17:10 *** sbluhm has joined #gnucash
01:23:51 *** gjanssens has joined #gnucash
01:23:51 *** ChanServ sets mode: +o gjanssens
01:24:39 *** ChanServ sets mode: +v glorberto
01:24:46 <glorberto> Are we talking about me?
01:25:05 <glorberto> Additionally, what's the best report to export for an accountant if they only deal in paper?
01:29:34 <glorberto> I've been curious about this idea in my head of using the bank accounts as mere "lower layers" for another set of overlaid accounts used for other tracking. Is that method useful if I run multiple businesses out of a single bank account that I want to form business insights from?
01:31:49 *** Gandalf has joined #gnucash
01:39:08 *** dpchr has joined #gnucash
01:39:08 *** ChanServ sets mode: +v dpchr
01:59:25 *** NoobAlice has quit IRC
02:04:25 *** sbluhm has quit IRC
02:13:29 *** FH_thecat has quit IRC
02:51:33 *** tomk_dk has joined #gnucash
03:20:18 *** djbrown has joined #gnucash
03:20:18 *** ChanServ sets mode: +v djbrown
03:34:28 *** bertbob has quit IRC
03:39:01 *** bertbob has joined #gnucash
03:39:01 *** ChanServ sets mode: +v bertbob
03:45:00 *** storyjesse has joined #gnucash
04:40:45 *** djbrown1 has joined #gnucash
04:40:45 *** ChanServ sets mode: +v djbrown1
04:42:50 *** djbrown has quit IRC
04:42:50 *** djbrown1 is now known as djbrown
04:58:12 *** djbrown1 has joined #gnucash
04:58:12 *** ChanServ sets mode: +v djbrown1
05:00:53 *** djbrown has quit IRC
05:00:53 *** djbrown1 is now known as djbrown
05:26:42 *** Gandalf1 has joined #gnucash
05:27:11 *** Gandalf has quit IRC
05:27:12 *** Gandalf1 is now known as Gandalf
05:38:04 *** glorberto has quit IRC
05:40:21 *** glorberto has joined #gnucash
05:47:57 *** djbrown1 has joined #gnucash
05:47:58 *** ChanServ sets mode: +v djbrown1
05:50:30 *** djbrown has quit IRC
05:50:30 *** djbrown1 is now known as djbrown
05:59:24 *** glorberto has quit IRC
06:46:03 <warlord> jralls, no, i did not.
06:50:54 *** djbrown1 has joined #gnucash
06:50:54 *** ChanServ sets mode: +v djbrown1
06:53:37 *** djbrown has quit IRC
06:53:37 *** djbrown1 is now known as djbrown
07:32:47 *** djbrown1 has joined #gnucash
07:32:47 *** ChanServ sets mode: +v djbrown1
07:35:41 *** djbrown has quit IRC
07:35:41 *** djbrown1 is now known as djbrown
07:38:43 *** arst_ has joined #gnucash
07:51:29 *** chipxxx has joined #gnucash
07:56:59 *** glorberto has joined #gnucash
08:26:39 *** djbrown1 has joined #gnucash
08:26:39 *** ChanServ sets mode: +v djbrown1
08:27:29 *** Gandalf1 has joined #gnucash
08:27:56 *** Gandalf has quit IRC
08:27:56 *** Gandalf1 is now known as Gandalf
08:28:23 *** djbrown has quit IRC
08:28:23 *** djbrown1 is now known as djbrown
08:43:56 *** djbrown1 has joined #gnucash
08:43:56 *** ChanServ sets mode: +v djbrown1
08:46:25 *** djbrown has quit IRC
08:46:25 *** djbrown1 is now known as djbrown
08:50:50 *** sbluhm has joined #gnucash
08:51:12 *** storyjesse has quit IRC
09:01:10 *** tomk_dk has quit IRC
09:13:08 *** dpchr has quit IRC
09:13:23 *** dpchr has joined #gnucash
09:13:23 *** ChanServ sets mode: +v dpchr
09:28:53 *** djbrown1 has joined #gnucash
09:28:54 *** ChanServ sets mode: +v djbrown1
09:31:29 *** djbrown has quit IRC
09:31:30 *** djbrown1 is now known as djbrown
09:57:08 *** Gandalf1 has joined #gnucash
09:57:35 *** Gandalf has quit IRC
09:57:35 *** Gandalf1 is now known as Gandalf
09:58:40 *** djbrown1 has joined #gnucash
09:58:40 *** ChanServ sets mode: +v djbrown1
10:00:01 *** djbrown has quit IRC
10:00:02 *** djbrown1 is now known as djbrown
10:02:32 *** David has quit IRC
10:02:40 *** David has joined #gnucash
10:20:32 *** djbrown1 has joined #gnucash
10:20:32 *** ChanServ sets mode: +v djbrown1
10:21:06 *** djbrown has quit IRC
10:21:06 *** djbrown1 is now known as djbrown
10:23:36 *** David has quit IRC
10:23:44 *** David has joined #gnucash
10:35:50 *** sbluhm has quit IRC
10:40:49 *** Aussie_matt has quit IRC
11:10:54 *** chipxxx has quit IRC
11:23:40 *** sbluhm has joined #gnucash
11:25:36 *** David has quit IRC
11:25:48 *** David has joined #gnucash
11:27:32 *** guak has joined #gnucash
12:09:27 *** sbluhm has quit IRC
12:36:45 *** AdrienM has quit IRC
12:40:43 *** AdrienM has joined #gnucash
12:40:43 *** ChanServ sets mode: +v AdrienM
13:07:08 *** djbrown has quit IRC
13:39:15 *** NoobAlice has joined #gnucash
13:39:15 *** ChanServ sets mode: +v NoobAlice
13:50:41 *** jralls sets mode: -b starman!*@*
13:50:43 *** antonlada[m] has quit IRC
13:50:43 *** technicus[m] has quit IRC
13:50:43 *** shukonmatrix[m] has quit IRC
13:50:43 *** dtux[m] has quit IRC
13:50:43 *** PeterScholtens[m] has quit IRC
13:50:43 *** luwum[m] has quit IRC
13:50:43 *** reactormonk[m] has quit IRC
13:50:43 *** peter-butler[m] has quit IRC
13:50:43 *** FestplattenSchnitzel[m] has quit IRC
13:50:43 *** Julianold[m] has quit IRC
13:51:26 <jralls> starman_, I removed the ban on starman
13:52:05 <jralls> glorberto, no, we weren't talking about you.
13:53:06 *** ElonSatoshi[m] has joined #gnucash
13:54:02 <jralls> gloreberto, as for the accountant who can only deal with paper, what reports to give them depends on what they want. The Balance Sheet and Income Statement reports are the standard summary reports to show an enterprise's financial standing and results for the previous period.
13:54:52 <jralls> If the accountant wants details the transaction report is pretty flexible, and you can combine it with the Find facility to create a tailored journal.
13:58:52 <jralls> As for commingling the assets of several companies in a single bank account: That's pretty severely frowned upon in most jurisdictions that I know about. If you insist, you could create a bunch of hierarchies in a single book, one for each business, and have the one bank account outside all of them with a sub-account for each company to reflect its share of the bank account.
14:00:45 <jralls> To get a balance sheet for any of the companies you'd use the accounts tab in report options to select that company's hierarchy plus its sub-account under the one bank account.
14:02:30 <jralls> You'd have to be very careful indeed when doing data entry to make sure that everything goes in the right account.
14:05:42 <jralls> It would be saner to keep a separate file for each company and a master for the bank account. In the master account you'd have the same subaccounts for the bank account, but the other top level accounts--income, expense, liabilities, and equity--would have a single subaccount for each company and you'd enter every bank account transaction twice, once in the bank account file and once in the company file.
14:12:50 *** Gandalf1 has joined #gnucash
14:13:12 *** Gandalf has quit IRC
14:13:12 *** Gandalf1 is now known as Gandalf
14:28:58 *** Gandalf has quit IRC
15:11:13 *** MatrixTravelerbot[m] has joined #gnucash
15:11:13 *** reactormonk[m] has joined #gnucash
15:11:13 *** Julianold[m] has joined #gnucash
15:11:14 *** Ablu[m] has joined #gnucash
15:11:14 *** Trygve[m] has joined #gnucash
15:11:14 *** luwum[m] has joined #gnucash
15:11:15 *** peter-butler[m] has joined #gnucash
15:11:16 *** PeterScholtens[m] has joined #gnucash
15:11:17 *** dtux[m] has joined #gnucash
15:11:18 *** technicus[m] has joined #gnucash
15:11:18 *** antonlada[m] has joined #gnucash
15:11:19 *** FestplattenSchnitzel[m] has joined #gnucash
15:11:20 *** shukonmatrix[m] has joined #gnucash
15:12:56 *** sbluhm has joined #gnucash
15:14:25 *** djbrown has joined #gnucash
15:14:25 *** ChanServ sets mode: +v djbrown
15:18:45 *** MatrixTravelerbot[m] has quit IRC
15:19:13 *** Ablu[m] has quit IRC
15:20:20 *** ElonSatoshi[m] has quit IRC
15:32:07 *** Trygve[m] has quit IRC
15:32:26 *** sbluhm has quit IRC
15:33:13 *** sbluhm has joined #gnucash
16:14:02 *** djbrown1 has joined #gnucash
16:14:02 *** ChanServ sets mode: +v djbrown1
16:15:22 *** djbrown has quit IRC
16:15:22 *** djbrown1 is now known as djbrown
16:17:32 <dpchr> Hi. So I have been using gnucash for several years for personal finances and my default currency is HRK (Croatian Kuna).
16:17:32 <dpchr> Since HRK will be replaced with EUR beginning next year, I would like to hear some advice on how to best handle this transition.
16:17:32 <dpchr> How would you go about replacing one default currency with another?
16:17:32 <dpchr> Can default currency be changed without issues?
16:17:32 <dpchr> I would like to keep all of the existing transaction history.
16:17:32 <dpchr> There will be a fixed exchange rate between HRK and EUR from 2023-01-01 onward and there will be no new HRK transactions.
16:17:32 <dpchr> Those accounts that have balances and transaction in HRK - should the balances be moved to new EUR accounts or what other options are possible?
16:17:34 <dpchr> Does anyone here have past experience with similar conversion (multiple EU countries already did this between 2007 and 2015 IIRC)?
16:29:12 <jralls> dpchr, I have https://github.com/Gnucash/gnucash/pull/1433 ready to be merged and released in 4.13. That will set up the fixed exchange rate and I think will magic everything HRK into EUR. If that's right the only catch is that you'll want to wait until 1 Jan 2023 to switch to 4.13.
16:33:50 <dpchr> jralls, thanks - that sounds useful. Does this mean original HRK amounts will no longer be visible/accessible?
16:36:36 <jralls> I actually don't know. Let's see if I can figure it out from the source.
16:43:43 *** sbluhm has quit IRC
16:44:36 <dpchr> Looking at your commit https://github.com/Gnucash/gnucash/pull/1433/commits/e4ed901ae42379c4bfd171bf034e73896c94ad5f
16:45:19 <dpchr> I believe you need to use correct exchange rate for HRK/EUR which is 7.53450
16:45:21 <dpchr> See: https://www.hnb.hr/en/-/croatia-to-introduce-the-euro-on-1-january-2023
16:47:18 <jralls> Oh, thanks for catching that.
16:50:17 *** lagash has quit IRC
16:52:47 *** David has quit IRC
16:52:54 *** David has joined #gnucash
16:54:38 <jralls> Fixed. I'm called away to a meeting. I suggest you ask on gnucash-user for someone who has actual experience with this, but there may not be anyone as the last change was Latvia 9 years ago.
16:55:16 <dpchr> thanks
16:58:50 *** lagash has joined #gnucash
16:58:50 *** ChanServ sets mode: +v lagash
17:12:03 <Simon> shouldn't there be dates associated with those fixed rates?
17:12:39 <Simon> the currency should still have a different conversion rate in the past
17:13:40 *** djbrown1 has joined #gnucash
17:13:40 *** ChanServ sets mode: +v djbrown1
17:15:25 *** djbrown has quit IRC
17:15:25 *** djbrown1 is now known as djbrown
17:15:49 <dpchr> yes, that makes sense, otherwise past transactions would not balance, right? Not sure if that is how it's planned to work after jralls commits though.
17:19:31 *** field^Mop has joined #gnucash
17:20:38 <Simon> there's no question of the transactions having a different meaning, only the conversion to other currencies
17:20:58 <Simon> transactions before 2023 should not be converted to EUR at the fixed rate
17:22:30 <Simon> although "magic everything HRK into EUR" may mean the old transactions appear to be EUR at the fixed rate
17:22:49 <Simon> which to me is not at all accurate
17:23:31 <Simon> if your 100 HRK cash withdrawal is suddenly a rounded EUR value that makes your historical data a bit useless
17:23:51 <Simon> on the other hand the account can't have two currencies
17:24:15 <Simon> the balance has to make sense before/after 2023
17:25:04 <Simon> I recommend you make a *copy* of your data and manually edit it outside of gnucash so that it's FRF instead of HRK
17:25:20 <Simon> then you can see what it would look like if this automatic conversion happens
17:27:32 <Simon> I would probably want to duplicate all my accounts if this kind of thing happened to my money, but that's a massive operation
17:27:55 <Simon> suddenly I'd have Expenses:* in two currencies for almost everything
17:30:21 <Simon> and then there's the overhead of selecting "Expenses:*:OLD" and "Expenses:*:NEW" or the inability to combine both currencies with "Expenses OLD:*" and "Expenses NEW:*"
17:31:38 <dpchr> yes, that's a good summary of what I was concerned about as well.
17:32:58 <Simon> there is no easy solution to this - you need daily currency information to be able to show historical transactions correctly and you only have two decimal places of precision
17:33:41 <Simon> if I were you I'd be looking for historical HRK to EUR currency rates going back to your first transaction, just in case you want to do that
17:34:47 <Simon> ultimately the totals of Expenses:* aren't that useful because of inflation
17:35:00 <Simon> so I'd probably just split the top level by currency
17:35:51 <Simon> net worth is still relatively meaningful to calculate so I'd want transfer assets to a new account
17:36:51 *** gjanssens has quit IRC
17:37:49 <dpchr> good points, I'll need to think about the optimal approach / try it out - before the end of the year.
17:38:00 <Simon> do you use XML or an SQL database?
17:38:20 <dpchr> sqlite3
17:38:30 <Simon> aah. I'm not familiar with the format of that
17:38:50 <Simon> but you should be able to copy it and then manually change the currency of everything to FRF
17:44:43 *** djbrown1 has joined #gnucash
17:44:43 *** ChanServ sets mode: +v djbrown1
17:46:03 *** djbrown has quit IRC
17:46:04 *** djbrown1 is now known as djbrown
17:52:14 <jralls> OK, meeting over. Don't panic, there's much less magic than I thought.
17:58:24 <jralls> The register just changes the summary bar at the bottom. The transfer dialog makes sure that if there's an exchange rate required it's the statutory one.
18:00:33 <dpchr> what happens with old transactions between HRK and EUR accounts?
18:00:58 <jralls> Nothing happens to existing transactions.
18:02:45 <jralls> I guess the simplest thing to do would be to close your book on 31 December and create a new one in EUR with opening balances in the new amounts on 1 January.
18:03:51 <dpchr> so, I can change any top level account without posted transactions from HRK to EUR and then close balances on HRK accounts and copy over to new accounts?
18:04:14 <dpchr> I would have duplicated accounts, but there is no way to avoid that right?
18:05:52 <jralls> Yes, I think that's the fallback if you want to keep using the same file. You would indeed have to duplicate all of your active accounts into EUR ones.
18:07:24 <jralls> If you have outstanding bills or invoices in HRK you'd have to keep the HRK AP/AR accounts open so you can post those as they're paid.
18:08:04 <dpchr> Keeping the same file is the general idea since I can preserve transaction history.
18:08:44 <jralls> Or maybe you have to cancel the bills and invoices and create new ones in EUR since you'll be paying or getting paid in EUR in the new year.
18:10:19 <dpchr> rgr
18:11:29 <dpchr> another thing that would be helpful in gnucash would be to show account curreny code on each transaction line. That is not possible right now is it?
18:13:13 <fell> jralls, 54 - test-gnc-euro (Failed)
18:13:23 <jralls> IIRC it does that when you have trading accounts enabled.
18:14:05 <jralls> fell, yeah, got emails. I forgot to fix the price in the unit test. I'll push the fix in a couple of minutes.
18:15:09 <jralls> dpchr If you're not using trading accounts then the currency is always the one for the current register.
18:20:26 <dpchr> jralls, ok, just thought it would be helpful to show it all the time as a reminder of what you are looking at
18:20:30 *** starman_ is now known as starman
18:24:10 <jralls> It would have to be a preference. For those of us who use only one currency it would be distracting, especially if it's the three-letter code instead of the symbol, i.e. EUR instead of €.
18:24:45 <dpchr> preference for sure, no need to force it on anyone
18:25:32 *** ChanServ sets mode: +v starman
18:27:31 *** field^Mop has quit IRC
18:29:27 *** chipxxx has joined #gnucash
18:33:18 *** starman has left #gnucash
18:33:26 *** starman has joined #gnucash
18:33:26 *** ChanServ sets mode: +v starman
18:42:44 *** field^Mop has joined #gnucash
18:56:43 *** field^Mop has quit IRC
18:59:13 *** djbrown1 has joined #gnucash
18:59:13 *** ChanServ sets mode: +v djbrown1
19:01:12 *** djbrown has quit IRC
19:01:12 *** djbrown1 is now known as djbrown
19:18:56 *** NoobAlice has quit IRC
19:20:46 *** NoobAlice has joined #gnucash
19:20:46 *** ChanServ sets mode: +v NoobAlice
19:29:18 *** djbrown1 has joined #gnucash
19:29:18 *** ChanServ sets mode: +v djbrown1
19:31:12 *** djbrown has quit IRC
19:31:13 *** djbrown1 is now known as djbrown
19:53:15 *** Aussie_matt has joined #gnucash
19:57:19 *** guak has quit IRC
19:57:38 *** guak has joined #gnucash
19:59:18 *** djbrown1 has joined #gnucash
19:59:18 *** ChanServ sets mode: +v djbrown1
20:01:17 *** djbrown has quit IRC
20:01:17 *** djbrown1 is now known as djbrown
20:03:48 *** guak has joined #gnucash
20:29:18 *** djbrown1 has joined #gnucash
20:29:18 *** ChanServ sets mode: +v djbrown1
20:31:19 *** djbrown has quit IRC
20:31:19 *** djbrown1 is now known as djbrown
20:31:36 *** chipxxx has quit IRC
20:51:59 *** Aussie_matt has quit IRC
21:14:18 *** djbrown1 has joined #gnucash
21:14:18 *** ChanServ sets mode: +v djbrown1
21:16:09 *** djbrown has quit IRC
21:16:09 *** djbrown1 is now known as djbrown
21:22:21 *** guak has quit IRC
21:53:27 *** djbrown1 has joined #gnucash
21:53:27 *** ChanServ sets mode: +v djbrown1
21:54:34 *** djbrown has quit IRC
21:54:35 *** djbrown1 is now known as djbrown
22:35:03 *** ChanServ sets mode: +v glorberto
22:37:10 <glorberto> TEST
22:37:17 <glorberto> Okay, sweet. Thanks a bunch for the information, jralls.
22:37:51 <glorberto> What's the gnucash parlance for getting a summary of expenses PER some list of accounts? I basically have in my head that I can generate each one's contributions to these fused expense accounts.
22:39:07 <glorberto> (I noticed that the income & expense report will do that if I had separated accounts to separate incomes. I could do that, or I could currently get this information out of the current dataset by using "asset" accounts in place of the income ones)
22:50:18 <glorberto> (I'm gonna split things into the income categories properly, looks like)
22:52:58 <glorberto> Nope, I think I've messed this up. In order to make sure I had control of transfers to other businesses from when a card was mistakenly used in one place, I've got multiple accounts under the assets, and I'm thinking that if I generate this income and expense sheet, it won't be tracking it PER external asset account.
23:23:29 *** arst_ has quit IRC
23:32:42 <glorberto> Perhaps this Cash Flow report could be useful...