2016-02-12 GnuCash IRC logs
00:08:25 *** jralls has quit IRC
00:08:53 *** jralls has joined #gnucash
00:08:54 *** ChanServ sets mode: +o jralls
00:09:18 *** puck has quit IRC
00:09:24 *** puck has joined #gnucash
00:32:46 *** sm has joined #gnucash
00:49:43 <sm> evening all
00:50:02 <sm> thanks for gnucash! (again)
00:50:53 <sm> I'm visiting from the plain text ledger-verse, and wondering why General Ledger shows me only one transaction, when the accounts have many ?
00:54:16 <sm> also, is there a view that shows the transactions in an account and all subaccounts ?
01:00:41 *** Apteryx has joined #gnucash
01:03:15 *** Mechtilde has joined #gnucash
01:25:08 *** Apteryx has quit IRC
01:28:18 *** Apteryx has joined #gnucash
01:41:48 *** Apteryx has quit IRC
02:42:57 *** gncbot has joined #gnucash
02:44:44 *** fell has quit IRC
02:51:19 *** rubdos has quit IRC
03:31:38 *** Unhammer has quit IRC
03:42:21 *** fabior has joined #gnucash
03:55:41 *** Unhammer has joined #gnucash
03:56:08 *** bertbob has quit IRC
04:10:34 *** bertbob has joined #gnucash
04:13:46 *** bertbob has quit IRC
04:29:13 *** bertbob has joined #gnucash
04:32:21 *** bertbob has quit IRC
04:47:51 *** bertbob has joined #gnucash
05:21:49 *** rubdos has joined #gnucash
05:25:01 *** fell has joined #gnucash
05:38:35 <fell> mikee, can you /op gncbot?
05:41:23 <fell> sm: Edit->Preferences->Register defaults->Default Style (option 2 or 3)
05:43:39 <fell> In theCoA Edit->Open Subaccounts
05:44:10 <fell> But that wil be read only
05:48:45 *** fell has quit IRC
05:48:59 *** fell has joined #gnucash
05:56:54 *** mikee sets mode: +o gncbot
05:57:23 <mikee> fell: Done.
06:31:06 *** bertbob has quit IRC
06:45:04 *** bertbob has joined #gnucash
06:49:01 *** mlncn has quit IRC
06:52:57 *** Jimraehl1 has left #gnucash
06:56:28 *** Jimraehl1 has joined #gnucash
07:12:02 *** Hinnerk has quit IRC
07:26:28 *** warlord has joined #gnucash
07:26:28 *** frozenjim has joined #gnucash
07:26:28 *** gncbot sets mode: +o warlord
07:26:38 *** fabior has quit IRC
07:27:21 <warlord> sm: Not sure what you mean by " why General Ledger shows me only one transaction, when the accounts have many"
07:27:40 <warlord> For your second question: right-click on the parent account and select Open Subaccounts
07:28:48 <frozenjim> Have graduated from cash-based to accrual. One issue: How do I account for cheques etc. that are not CASHED during the statement month that I wrote them? Reconcilliation will fail unless I repost to the next month - which breaks the audit of accrual. (or am I just totally missing the plot?). Is there an accepted standard for reconcilliation of "Late" or "Floating" cheques/visa/etc?
07:33:53 <warlord> You're missing the point.
07:34:01 <frozenjim> sigh.
07:34:07 <warlord> When you reconcile you should enter the bank's balance..
07:34:26 <warlord> Then not check the check during the process.
07:34:38 <warlord> it sounds like you're not doing that and just using gnucash's suggested balance, which is wrong.
07:35:08 <frozenjim> OK.. I'm doing that. But it leaves "unchecked" boxes that I have presumed to be a problem. Does one just leave the unchecked for next month's statement - and continue to sleep easily?
07:35:19 <frozenjim> OCD. Sorry.
07:35:21 <warlord> Yes
07:35:40 <warlord> This is how you KNOW that "hey, Jim didn't cash my check, yet.. Maybe I should contact him"
07:35:40 <frozenjim> OK. Thanks. I'll try to rest knowing that those boxes remain unchecked.
07:36:06 <frozenjim> Right. Is there a report that pulls that, or is it a manual visual scan?
07:36:26 <warlord> Manual scan. Easily done via View -> Filter By ... [unselect 'Reconciled
07:36:28 <warlord> ']
07:36:49 <warlord> BIAB
07:37:01 <frozenjim> of course. Awesome, thanks Warlord. GnuCash is one of the best pieces of open source ever - you have my eternal gratitude.
08:01:14 <warlord> you're welcome frozenjim
08:39:44 *** fabior has joined #gnucash
08:50:43 <frozenjim> Vendor Bill: Invoice from pharmacy shows $1,000 total. If this I pay $100 and the other $900 is paid by Insurance. How do I account for the $900 income (my first thought was to add the line item and expense it to an income account: "insurance reimbursement" but I see that can't work.
08:52:04 <frozenjim> My idea is that I need to track my pharmacy expense - it's an important figure. But it needs to be offset by the income.
08:57:21 *** mlncn has joined #gnucash
09:00:53 <warlord> frozenjim: it's only a $100 expense to you. The $900 insurance payment probably shouldn't be in your books at all.
09:05:50 <frozenjim> I track the insurance because - for me - it's about a $40,000/year expense. For decision-making, this type of number is important. On cash-based it was a simple split. Ideally I would use the Bill feature - but I suppose I can continue using split to account for insurance matters.
09:06:37 <frozenjim> I would think that the same logic would apply to vendor discounts; it's good to know how much you are saving due to a discount structure - it helps you in negotiations. Same principle, I think.
09:09:07 *** gncbot sets mode: +o fell
09:20:09 *** rubdos has quit IRC
09:34:46 *** mikee is now known as mikee_afk
09:35:58 *** mikee_afk is now known as mikee
09:36:45 *** mikee is now known as mikee_afk
09:37:46 *** mikee_afk is now known as mikee
10:03:25 *** fabior has quit IRC
10:03:25 *** Jimraehl1 has quit IRC
10:03:25 *** bertbob has quit IRC
10:03:25 *** Cork has quit IRC
10:03:25 *** neena has quit IRC
10:03:25 *** GabrieleV has quit IRC
10:03:25 *** AlanTop has quit IRC
10:03:25 *** MoeD has quit IRC
10:03:25 *** wget has quit IRC
10:03:25 *** codesmythe has quit IRC
10:03:25 *** warlord has quit IRC
10:03:25 *** fell has quit IRC
10:03:25 *** g5pw has quit IRC
10:03:25 *** meb has quit IRC
10:03:25 *** gnomey has quit IRC
10:03:25 *** calp has quit IRC
10:03:25 *** ggherdov_ has quit IRC
10:03:25 *** redarrow has quit IRC
10:03:25 *** Simon has quit IRC
10:03:25 *** Bill has quit IRC
10:03:25 *** mlncn has quit IRC
10:03:25 *** frozenjim has quit IRC
10:03:25 *** Unhammer has quit IRC
10:03:25 *** sm has quit IRC
10:03:25 *** minot has quit IRC
10:03:25 *** Coderjoe has quit IRC
10:03:25 *** lmat has quit IRC
10:03:25 *** Qantourisc has quit IRC
10:03:25 *** jethrogb has quit IRC
10:03:44 *** mlncn has joined #gnucash
10:03:44 *** fabior has joined #gnucash
10:03:44 *** frozenjim has joined #gnucash
10:03:44 *** warlord has joined #gnucash
10:03:44 *** Jimraehl1 has joined #gnucash
10:03:44 *** bertbob has joined #gnucash
10:03:44 *** fell has joined #gnucash
10:03:44 *** Unhammer has joined #gnucash
10:03:44 *** sm has joined #gnucash
10:03:44 *** g5pw has joined #gnucash
10:03:44 *** minot has joined #gnucash
10:03:44 *** neena has joined #gnucash
10:03:44 *** GabrieleV has joined #gnucash
10:03:44 *** meb has joined #gnucash
10:03:44 *** AlanTop has joined #gnucash
10:03:44 *** Coderjoe has joined #gnucash
10:03:44 *** MoeD has joined #gnucash
10:03:44 *** gnomey has joined #gnucash
10:03:44 *** wget has joined #gnucash
10:03:44 *** lmat has joined #gnucash
10:03:44 *** codesmythe has joined #gnucash
10:03:44 *** calp has joined #gnucash
10:03:44 *** ggherdov_ has joined #gnucash
10:03:44 *** redarrow has joined #gnucash
10:03:44 *** Simon has joined #gnucash
10:03:44 *** Qantourisc has joined #gnucash
10:03:44 *** Bill has joined #gnucash
10:03:44 *** jethrogb has joined #gnucash
10:03:44 *** irc.acc.umu.se sets mode: +oo warlord fell
10:05:00 *** Cork has joined #gnucash
10:11:03 *** fabior has quit IRC
10:47:28 <sm> fell, warlord: thanks for your answers yesterday. Open subaccounts it is
10:48:37 <sm> my question about General Ledger (is it called General Journal in the docs ? which is the preferred spelling ?): I expected it to show all transactions from all accounts, but it seems to show only a couple of scheduled/auto-created ones
10:55:07 <sm> incidentally I got the current 2.6.11 download for osx to crash just now, while entering data into the preferences -> accounts -> separator field
10:59:13 <sm> hm.. in the register, can't widen the account name column leftward, so I can see more of those
11:08:23 <warlord> sm: Tools -> General Ledger will show all transactions from all accounts within the last month (by default). You can change the date range.
11:09:03 <warlord> sm: you need to widen it to the right --- the description column will always auto-expand to fill the width of the window.
11:10:33 <sm> aHA.. thanks
11:11:34 <sm> warlord: the trouble with widening to the right is it just widens the "n" column
11:13:47 <warlord> sm: unfortunately you need to effectively widen every column to the right.. You can *TRY* double-clicking on the account column to auto-size it, but I forget exactly what that does.
11:14:55 <sm> double-clicking worked \o/
11:15:18 <sm> that's the only thing that works
11:21:16 *** Mechtilde has joined #gnucash
11:22:35 <sm> I opened an old file which had created scheduled transactions enabled, and now I have 11 years of bogus bill payments :) what would be the best way to delete all of these ?
11:25:34 <warlord> Edit -> Preferences and turn off SX auto-create, then Exit without saving, then re-open
11:26:41 <sm> ah, too late.. the new txns have already been saved
11:26:53 <sm> I guess it's hammer on the delete button ?
11:28:21 <sm> not too bad
11:29:57 <warlord> Yep
11:51:13 *** Apteryx has joined #gnucash
11:56:47 <sm> hm this isn't good.. my 2005 gnucash data looks good until this one transaction - a $90000 gift ? that didn't happen :/
11:57:12 <sm> I assume there's no known bug with old data files that would inflate amounts
11:59:37 <sm> possibly involvinga currency conversion ?
12:17:04 *** fabior has joined #gnucash
12:28:42 *** mlncn has quit IRC
12:42:16 *** Apteryx has quit IRC
12:43:33 <warlord> Was there a currency conversion?
12:48:28 <sm> warlord: quite likely there was.. I don't remember how that would appear in gnucash, if at all
12:48:53 <sm> the base currency is $, and the gift might have been euros
12:49:18 <warlord> It's certainly possible that a currency exchange could do something lke that. What's the specific transaction?
12:50:39 <sm> it's a gift received in 2005, for 90,138.06
12:51:11 <sm> I don't know what the amount actually was
12:51:16 <sm> but not that :)
12:52:28 <sm> ah, I see more of them (>90k txns) now
12:53:29 <sm> all could be foreign currency transactions, indeed
12:54:28 *** KaiForce has joined #gnucash
12:56:57 *** fabior has quit IRC
12:59:10 *** fabior has joined #gnucash
13:03:29 *** fabior has quit IRC
13:12:07 *** ErKa has joined #gnucash
13:39:33 *** KaiForce has quit IRC
13:46:47 <sm> FWIW: the link in http://lists.gnucash.org/pipermail/gnucash-user/2008-April/024782.html (to corruptedfilerepair) leads to a browser hijack attempt
13:53:46 *** Apteryx has joined #gnucash
13:53:59 <sm> is there somewhere I can read more about the CSV export format for transactions
13:54:39 <sm> I'd like to get data moving between gnucash and *ledger
13:56:40 <warlord> sm: dont have much control over corruptedfilerepair -- you should contact them about the browser hijack attempt.
13:57:10 <warlord> why do you want to move back and forth with ledger?
13:57:45 <sm> oh I just mention it in case the gnucash list archive maintainer wants to clean it from there
13:59:05 <sm> warlord: I moved from gnucash to ledger (then created hledger) in 2007, but I always wanted the ability to eg import back to gnucash for gui browsing and reports
13:59:29 <sm> and generally I would like to make it easier to move data between accounting apps
14:00:51 <sm> but, right this moment what I'm exploring is to export my 2005 gnucash data to hledger, via CSV, to get another view on it
14:01:17 <sm> and ultimately the same for all old data, to consolidate
14:02:14 *** mlncn has joined #gnucash
14:03:35 *** fabior has joined #gnucash
14:06:39 <warlord> you might be better off with something like gnucash2qif
14:09:29 <sm> there's no qif to *ledger converter at present
14:09:45 <sm> I know the CSV format is funky, but I'd like to at least understand it
14:10:01 <sm> I see three records per transactino
14:11:08 <sm> ohhh.. never mind, I confused myself
14:11:29 <sm> I think I get the layout now. Still, any docs welcome
14:18:15 <warlord> ledger doesn't have a qif importer?
14:22:48 *** lwells has joined #gnucash
14:28:22 <sm> warlord: no, everybody converts from csv
14:28:58 <sm> oh wait a minute..
14:29:20 <sm> https://github.com/dmp1ce/qif2ledger, good idea
14:32:23 <sm> gnucash -> gnucash2qif -> qif2ledger -> hledger - brilliant, what could possibly go wrong
14:43:23 *** rubdos has joined #gnucash
15:04:33 <warlord> lol
15:20:25 *** Mechtilde has quit IRC
15:31:49 *** lfs has joined #gnucash
15:31:59 *** lfs has left #gnucash
15:39:06 <jralls> warlord, sm: To widen the account column in a split view put the focus in a split line. That changes the header to show the Account and Reconcile columns.
15:40:51 <jralls> sm: If you're using the XML backend you can just switch back to a backup file from before the save with the extra scheduled transactions.
15:41:03 <sm> good tips!
15:42:25 *** gjanssens has joined #gnucash
15:42:25 *** ChanServ sets mode: +o gjanssens
15:58:28 *** backbox has joined #gnucash
16:02:10 *** backbox has quit IRC
16:48:23 *** gjanssens has quit IRC
17:12:11 *** Apteryx has quit IRC
17:22:41 *** rubdos has quit IRC
17:35:02 *** fabior has quit IRC
18:57:50 *** Apteryx has joined #gnucash
20:01:14 *** gnomey has quit IRC
20:07:44 *** gnomey has joined #gnucash
20:23:57 *** mlncn has quit IRC
22:52:52 *** Apteryx has quit IRC
23:30:25 *** ErKa has quit IRC
23:32:21 *** codesmythe has quit IRC