2018-05-05 GnuCash IRC logs
01:05:02 *** Mechtilde has joined #gnucash
01:16:54 *** fell_afk has quit IRC
01:17:39 *** fell_afk has joined #gnucash
01:44:46 *** Mechtilde has quit IRC
01:50:41 *** gjanssens has joined #gnucash
01:50:42 *** ChanServ sets mode: +o gjanssens
02:26:09 *** gour has joined #gnucash
03:05:18 *** Mechtilde has joined #gnucash
03:06:31 *** ngong has joined #gnucash
03:29:59 *** Mechtilde has quit IRC
03:40:39 <gour> can custom reports from 2.6. work in 3.0?
03:46:06 *** Mechtilde has joined #gnucash
03:56:00 *** ncv has joined #gnucash
04:07:44 *** chris has joined #gnucash
04:08:09 <chris> gour it's time to dive in and learn how to fix your custom reports :)
04:08:27 <chris> (yes of course)
04:08:46 <chris> API has changed, check timepair / time64
04:21:29 *** Mechtilde has quit IRC
04:22:02 *** chris has quit IRC
04:36:00 *** Mechtilde has joined #gnucash
04:48:37 *** fabior has joined #gnucash
05:37:47 *** fourtytwo has left #gnucash
05:37:51 *** fourtytwo has joined #gnucash
06:07:24 *** pilotauto has quit IRC
06:11:55 *** eagles0513876 has joined #gnucash
06:12:47 *** eagles0513875 has quit IRC
06:12:47 *** eagles0513876 is now known as eagles0513875
06:27:49 *** fabior has quit IRC
06:47:37 *** fell_afk is now known as fell
06:47:49 *** gncbot sets mode: +o fell
06:53:59 *** Sveta has joined #gnucash
06:54:41 <Sveta> when importing transactions gnucash automatically detects some as salary, but it classifies public transport expenses as salary too
06:55:00 *** Mechtilde has quit IRC
06:55:04 <Sveta> i'm working on an import of over a year of transactions, and fixing this by hand one by one is not ideal
06:55:27 <Sveta> how do i filter the transactions by description and re-categorize multiple transactions when importing them?
06:56:01 <Sveta> or can i set gnucash to not categorize automatically at the time of import- then if filtering by description is available later then i can use that?
06:57:10 *** fabior has joined #gnucash
07:11:49 *** Aussie_matt has joined #gnucash
07:32:28 *** fabior has quit IRC
07:56:47 <warlord> Sveta: which importer method?
07:57:19 <warlord> QIF uses full-string text matching.
07:57:49 <warlord> OFX/HBCI/CSV uses tokenized matching, but that depends on whether you turn on Bayesian matching or not to "train" the matcher.
07:58:15 <warlord> You best bet is to import a small subset to train it, and then do it in batches. You still need to train it in the importer and validate your transactions in the importer.
08:06:37 *** kael has joined #gnucash
08:14:34 *** oozer has joined #gnucash
08:18:09 *** Farelli has joined #gnucash
08:19:31 * Farelli waves
08:21:05 <Farelli> I use split transactions to separate groceries from draws so i can track how much cash we withdraw
08:21:05 <Farelli> Now I'm trying to use a cash flow report to document the results of a month, and it doesn't seem to be adding up correctly
08:21:05 <Farelli> Is there anywhere I can look to better learn how that works, or a simpler way to break it down?
08:26:49 *** Jimraehl1 has joined #gnucash
08:27:43 *** boldstripe has joined #gnucash
08:27:44 *** Jimraehl1 has left #gnucash
08:30:23 *** eagles0513876 has joined #gnucash
08:32:57 *** eagles0513875 has quit IRC
08:33:35 *** eagles0513876 has quit IRC
08:41:06 *** eagles0513875 has joined #gnucash
08:46:44 *** harshitaneja has joined #gnucash
09:14:13 <warlord> Farelli: I dont understand what you mean by "to separate groceries from draws". What do you mean by a draw? How do you pay for groceries?
09:16:15 <warlord> Normally a grocery expense would be a simple transaction from Assets:Cash -> Expenses:Groceries (Or from Assets:Checking if you write a check or use a Debit card, or from Liabilities:CC if you use a credit card)
09:16:33 <warlord> I'm not sure what a "draw" is in your context, or how it fits into the grocery transaction.
09:17:18 <warlord> Do you mean a "cash back" transaction? Where your groceries are $80, you use your debit card for $100 and get $20 back from the store?
09:17:32 <Farelli> yes
09:17:56 <Farelli> wife likes to do cash withdrawals at the store so she has only one stop
09:18:28 <warlord> Okay. In that case it would be a split transaction. Credit $100 to Checking, Debit $80 to Groceries, and Debit $20 to Cash
09:19:17 <warlord> Your Cash Flow on your Bank will show the full $100. If you run a single Cash Flow and include both Bank AND Cash, then it will only show the $80 Grocery expense (and whatever additional Cash -> Expense transactions you record)
09:19:31 <warlord> Your other option is a P&L report which totals your Groceries regardless of how you pay for them.
09:35:44 <Farelli> ah, so running a cash flow with only groceries is what on confused
09:36:02 <Farelli> I need to select groceries and checking
09:36:40 <Farelli> or the p&l. that might be better, since that's really what I want. a total for groceries and a total for withdrawals
09:50:50 *** Mechtilde has joined #gnucash
09:52:58 *** fabior has joined #gnucash
10:00:03 *** Aussie_matt has quit IRC
10:22:13 *** fabior has quit IRC
11:16:18 *** O01eg has quit IRC
11:18:04 *** O01eg has joined #gnucash
11:25:45 *** kus has joined #gnucash
11:32:27 *** kael has joined #gnucash
12:24:50 *** kael has quit IRC
12:30:32 *** gour_ has joined #gnucash
12:32:34 *** gour has quit IRC
12:38:55 *** gour_ is now known as gour
13:19:56 *** Mechtilde has quit IRC
13:20:10 *** Mechtilde has joined #gnucash
13:25:18 *** gjanssens has quit IRC
13:30:31 *** boldstripe has quit IRC
13:37:54 <warlord> Farelli: The P&L will give you a total for Groceries, regardless of how it was paid (Cash,Credit Card, etc)
13:38:51 <Farelli> Good to know. Thanks
13:38:53 <warlord> Cash Flow shows you the amount that flows between the selected accounts and non-selected accounts.
13:39:49 <warlord> So if you select ONLY your bank, it will show you the $100 Credit. If you select Bank + Cash, it will only show you the $80 to Groceries (because the $20 from Bank to Cash is "within" the circle of selected accounts)
13:40:08 <warlord> It doesn't really make sense to run a cash flow selecting Expenses:Groceries.
13:48:21 <Farelli> Just ran a p&l quickly over my phone and I already see what you mean. Exactly what I needed
13:48:26 <Farelli> Thank you
14:20:07 *** fell_laptop has joined #gnucash
14:21:50 *** Mechtilde has quit IRC
14:22:32 *** fabior has joined #gnucash
14:40:58 *** Mechtilde has joined #gnucash
14:42:51 *** fabior_ has joined #gnucash
14:43:49 *** fabior has quit IRC
14:44:17 *** Mechtilde has quit IRC
15:01:15 *** Mechtilde has joined #gnucash
15:19:27 *** kus has quit IRC
15:27:56 *** fourtytwo has left #gnucash
16:07:10 <Sveta> warlord: csv
16:08:06 <Sveta> warlord: the transactions have a short description and a long description. what should be their column names when importing?
16:12:24 *** ArtGravity has joined #gnucash
16:18:16 *** Agfarmer18 has joined #gnucash
16:18:31 *** frakturfreak has joined #gnucash
16:21:16 *** Agfarmer18 has quit IRC
17:24:29 *** fabior_ has quit IRC
18:51:15 *** gour has quit IRC
20:10:09 *** fell_laptop has quit IRC
20:26:24 <warlord> Sveta: I dont understand what you mean by short and long descriptions..
20:26:32 <warlord> I;m not sure how to map them
20:44:06 *** harshitaneja has quit IRC
20:48:17 *** ncv has quit IRC
21:21:57 *** frakturfreak has quit IRC
21:27:05 <Sveta> warlord: okthanks, the idea about importing a small set to train on was really good
21:27:22 <Sveta> warlord: i've done that, seems like great progress
22:11:24 *** oozer has quit IRC
22:17:18 *** Aussie_matt has joined #gnucash
23:01:39 *** ArtGravity has quit IRC