2015-10-26 GnuCash IRC logs
02:13:13 *** MechtiIde has joined #gnucash
02:31:52 *** fell has joined #gnucash
02:33:44 *** fell__ has quit IRC
02:50:45 *** MechtiIde has quit IRC
03:01:24 *** ErKa has joined #gnucash
03:05:13 *** ThomasKeller has quit IRC
03:20:28 *** ErKa has quit IRC
03:33:40 *** ErKa has joined #gnucash
04:18:11 *** ErKa has quit IRC
05:01:07 *** fabior has joined #gnucash
05:32:32 *** ThomasKeller has joined #gnucash
06:58:52 *** Jimraehl1 has joined #gnucash
07:05:35 *** fabior has quit IRC
07:08:10 *** ikebrok has joined #gnucash
07:09:34 *** adrian_ has quit IRC
07:09:50 *** uXus has quit IRC
07:13:07 *** uXus has joined #gnucash
07:14:19 <ikebrok> could anyone point me in the right direction for obtaining the information needed to set up accounts for OFX/Webconnect?
07:22:10 *** fabior has joined #gnucash
07:23:22 *** adrian_ has joined #gnucash
07:24:46 *** fabior has quit IRC
07:31:20 *** fabior has joined #gnucash
07:50:19 *** fabior has quit IRC
08:10:56 *** mlncn has joined #gnucash
08:10:57 *** nomeata has joined #gnucash
08:15:51 *** himaxx has joined #gnucash
08:17:41 *** himaxx has quit IRC
08:49:11 <warlord> ikebrok: have you looked at the Wiki?
08:49:32 <warlord> CDB-Man: click the "Get Quotes" button
08:52:23 *** neena has joined #gnucash
08:53:13 *** ikebrok has quit IRC
09:34:56 *** himaxx has joined #gnucash
09:36:49 *** aqua___ has joined #gnucash
10:13:12 *** lmat_ has joined #gnucash
10:30:01 *** lmat has quit IRC
10:30:09 *** lmat has joined #gnucash
10:41:33 *** aqua___ has quit IRC
11:19:09 *** cartsoftware has joined #gnucash
11:33:57 *** ThomasKeller has quit IRC
12:00:32 *** mlncn has quit IRC
12:14:21 *** ErKa has joined #gnucash
12:22:51 *** MechtiIde has joined #gnucash
12:24:48 *** mlncn has joined #gnucash
12:42:01 *** autoditac__ has joined #gnucash
12:43:46 *** ErKa has quit IRC
12:46:26 *** Coderjoe has quit IRC
12:46:43 *** nomeata has quit IRC
12:51:43 *** Coderjoe has joined #gnucash
12:59:50 *** mlncn has quit IRC
13:02:57 *** mlncn has joined #gnucash
13:08:29 *** ErKa has joined #gnucash
13:12:13 *** ErKa has quit IRC
13:22:18 *** autoditac__ has quit IRC
13:35:18 *** autoditac__ has joined #gnucash
13:42:39 *** CDB-Man_ has joined #gnucash
13:43:51 *** CDB-Man has quit IRC
13:53:32 *** aqua___ has joined #gnucash
14:14:33 *** aqua___ has quit IRC
14:16:01 *** mikom has quit IRC
14:36:06 *** MechtiIde has quit IRC
14:37:51 *** mlncn has quit IRC
14:49:14 *** ErKa has joined #gnucash
14:51:36 *** mikom has joined #gnucash
15:10:26 *** mlncn_ has joined #gnucash
15:16:29 *** mlncn_ has quit IRC
15:17:06 *** mlncn has joined #gnucash
15:27:43 <neena> Are the reports buggy or am I using them wrong?
15:28:24 <neena> My Balance Sheet (generated with eguile) doesn't seem to add up the numbers on to the last column.
15:29:00 <neena> It's more likely that I'm doing something wrong since this is my first time using a software like this.
15:30:08 <neena> I'm using v2.6.9 (rev 4241505+ on 2015-10-05) on OS X.
15:38:52 *** ArtGravity has joined #gnucash
15:42:01 <warlord> neena: what about the non-eguile balance sheet report?
15:44:22 <ArtGravity> I have managed to get my AP account fouled up due to a vendor refunding and reprocessing a transaction. Is there a good method to eliminate the problem entries and redo them?
15:53:37 <neena> That too. It's quite possible I'm just misunderstanding how to use this. I can share my .gnucash file/take a screenshot if that would help. (It's mostly dummy data right now)
15:56:50 <warlord> ArtGravity: delete and re-enter on your side, too?
15:57:04 <warlord> neena: do you have multiple currencies or stocks/
15:57:04 <warlord> ?
15:57:31 <ArtGravity> Thanks, warlord. I did that while I was waiting, and AP is looking good.
15:57:59 <ArtGravity> Now I have to get the liability account straightened out, but that is just tedious grun work. :)
15:59:35 <warlord> good luck
16:02:38 <neena> Single currency. I have no stocks. I'm using Cash-in-wallet, savings-account, brokerage-account, credit-card and education-loan right now.
16:06:46 *** autoditac__ has quit IRC
16:08:09 <warlord> neena: if you're not using multiple currencies or stocks then I see no reason the report would fail. I suspect it's working properly based on your input data, so most lkely your data isn't input correctly.
16:15:41 <neena> Hmm, right. I'll get back here if I don't figure it out after some reading
16:17:20 <warlord> Make sure all your data is properly doubly-entered.
16:23:08 *** mlncn has quit IRC
16:25:40 <ArtGravity> warlord: any idea how to fix a negative cleared balance on my AP?
16:26:45 <ArtGravity> The actual balance is 0, but the Cleared value shows -75
16:28:26 <warlord> Umm... Unclear the non-cleared 75 transaction -- or clear the additional balancing 75?
16:28:36 *** nomeata has joined #gnucash
16:38:09 <ArtGravity> How do I find it? There is no column for cleared in the AP ledger
17:29:40 *** nomeata has quit IRC
18:45:33 *** lucky has quit IRC
18:46:52 *** meb has joined #gnucash
18:48:02 *** jwhitmore has joined #gnucash
18:56:16 <ArtGravity> I think I found the entry that is not cleared, but I cannot toggle it from N to C. I click but nothing happens.
19:41:54 <warlord> ArtGravity: wait a sec... how are you even "clearing" an A/P account??
19:41:59 <warlord> (and WHY?)
19:42:04 <ArtGravity> I'm not
19:42:10 <warlord> Sure you are...
19:42:12 <ArtGravity> I was just looking at the AP ledger
19:42:14 <warlord> Otherwise it wouldn't be C
19:42:36 <ArtGravity> that was on a different account that I jumped to from the AP ledger
19:42:56 <warlord> Umm... <ArtGravity> warlord: any idea how to fix a negative cleared balance on my AP?
19:43:03 <ArtGravity> right
19:43:28 <warlord> That implies you have a non-zero cleared balance on you AP, which implies you are clearing your AP transactions... Which doesn't make sense.
19:43:37 <ArtGravity> at the bottom of the AP ledger I show Present: $0 Future: $0 Cleared: -$75
19:44:06 <ArtGravity> Reconciled: $0 Projected Minimum: $0
19:44:06 <warlord> Find your $75 cleared transaction and unclear it
19:44:47 <ArtGravity> I don't know how
19:44:52 <warlord> Open your AP account, then View -> Filter By -> Status
19:45:00 <warlord> uncheck "Unreconciled"
19:45:22 <ArtGravity> I set only cleared and it shows
19:45:27 <warlord> That should leave you only the "cleared" transactions... Which is going to be a payment that you accidentally clicked.
19:45:29 <ArtGravity> Not sure how to alter it
19:45:43 <warlord> It's a payment transaction, right?
19:45:52 <warlord> Click on the 'c'
19:45:53 <ArtGravity> It is
19:45:56 <warlord> Change it back to 'n'
19:46:31 <ArtGravity> that exists in the related bank ledger on the "other side" of the entry, but I have no 'c' in the AP ledger
19:46:53 <ArtGravity> toggling the other side has no effect on the ap ledger, only the bank ledger
19:47:41 <ArtGravity> there is no column for clearing in the AP ledger, so I am confused as to how it got set to cleared.
19:47:58 <ArtGravity> It's from two years ago when I first started using gnucash for my business books
19:48:03 <warlord> Go to the other side, select that transaction, click on the 'split' button, then click on the 'c'
19:48:23 <ArtGravity> awesome!
19:48:25 <ArtGravity> Thank you
19:49:04 <ArtGravity> It didn't really hurt anything to be 'cleared' in the AP ledger, but the non zero value was discomforting
19:49:33 <warlord> Sure.
19:50:44 <ArtGravity> Now I just need to figure out where to place an extra refund from a vendor and I'm golden.
19:51:23 <ArtGravity> The real answer is probably "Call them and ask them to bill me again."
19:52:07 <warlord> what do you mean by "extra refund"?
19:53:02 <ArtGravity> Vendor billed me
19:53:11 <ArtGravity> had problem with SKU
19:53:14 <ArtGravity> issued refund
19:53:23 <ArtGravity> sent new bill
19:53:36 <ArtGravity> for some reason sent another refund
19:53:58 <warlord> Huh.
19:53:58 <ArtGravity> when they bill it goes straight to a credit card
19:54:04 <warlord> Odd
19:54:17 <ArtGravity> It's a billing problem, not a gnucash problem
19:54:33 <ArtGravity> Their second refund is in error
19:55:00 <ArtGravity> I'm just going to leave it in Orphan until I figure out what I am going to do about it.
19:55:55 <warlord> You could just process it as a second credit note from the vendor.
19:56:52 <ArtGravity> then it breaks my nice zero balance on their account :)
19:57:42 <ArtGravity> Can existing transactions be attached to other transactions?
19:58:00 <warlord> What do you mean?
19:58:33 <ArtGravity> Normally I try to pay bills via the Gnucash menus before importing a QFX file with the actual transaction
19:58:49 <ArtGravity> That way I can reconcile or update & reconcile
19:59:18 <ArtGravity> If I pull in the QFX first, I can map the payment to AP, but it won't have a relation to the bill or vendor
19:59:40 <warlord> Are you using 2.6?
19:59:52 <warlord> If so, you can assign the split as a payment.
19:59:57 <ArtGravity> 2.6.9
20:00:33 <ArtGravity> Nice
20:01:06 <ArtGravity> I right clicked on a split in my credit card ledger and see that option at the bottom of the contextual menu
20:01:22 <ArtGravity> That might come in handy
20:01:49 <CDB-Man_> 8[08:49:30] @warlord: CDB-Man: click the "Get Quotes" button <-- yup i already figured out that last night
20:02:15 <CDB-Man_> 7[23:46:23] CDB-Man: hmm, http://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-stockprice1.html using this method to display gains isnt actually possible it seems, since it keeps trying to balance out the transaction if i enter that blank share split to allow me to enter the profit accoutn
20:02:15 <CDB-Man_> 7[23:49:15] CDB-Man: looks like it forces all gains into the "trading gains" section of the balance sheet, and teh commodity view doesnt allow a traditional gains account anymore
20:02:15 <CDB-Man_> ^ hmm, so that still stands I assume
20:03:15 *** CDB-Man_ is now known as CDB-Man
20:04:33 <warlord> CDB-Man: you can enter a split with 0 shares.. You do need to actually touch 2 (but not 3) of the number columns.
20:06:00 <CDB-Man> well, I had done that, but then gnuash asks if I eant an auto-balancing entry after I close the transaction
20:08:39 <warlord> CDB-Man: that implies you didn't fully balance the transactions. Do the sum of all debits and credits == 0?
20:12:04 <CDB-Man> it definitely balances
20:12:18 <CDB-Man> though I think ive found the issue; i may be creating too much currency on the sale
20:13:17 <CDB-Man> hmm, actually, it looks like the problem was that the TRADING:MSFT split has to equal the original cost basis
20:13:25 <CDB-Man> instead of the gross proceeds
20:15:13 <CDB-Man> though, given that the program already calculates the LTCG in the trading gains
20:15:31 <CDB-Man> I would think that me accruing a separate income account means double counting of the net gain
20:17:14 *** ikebrok has joined #gnucash
20:20:51 <CDB-Man> hmm, I suppose the 0 share split will net out what would have otherwise been presented as a trading gain
20:21:01 <CDB-Man> and effectively shift it to a regular income account gain
20:22:43 <warlord> CDB-Man: If you're using trading accounts then you dont need to specify the gains yourself
20:23:27 <CDB-Man> well, I dont want the gains to be obfuscated into the trading gains line
20:24:00 <CDB-Man> I'm cross analysing my trading results across several trading platforms, so I need to keep track of the gains for different trading strategies into multiple income accounts
20:24:22 *** codesmythe has joined #gnucash
20:24:44 <CDB-Man> my day job is accounting, so I prefer everything as fine grained as possible
20:26:48 *** ErKa has quit IRC
20:27:18 <warlord> okay
20:27:38 <warlord> If you dont want the gains into the "trading accounts" then turn off trading accounts.
20:27:41 <warlord> It's either-or
20:28:10 <CDB-Man> well, I want the trading accounts so that it will reflect fx gains and losses
20:29:00 <CDB-Man> that and, where's the flag to set trading accounts? I couldnt find it again after setting up the ledger
20:29:24 <CDB-Man> and hmm, it seems that with the offsetting 0 share split, the one that you can only get with tabs, that will properly net away the trading gain
20:30:09 <CDB-Man> evidenced by testing with a $999999 gain, and i can see that with that split, the trading gains dont accrue the gain
20:30:17 <CDB-Man> but it will show up in retained earnings as expected
20:36:12 *** ikebrok has quit IRC
20:55:07 *** codesmythe has quit IRC
20:55:12 *** codesmythe has joined #gnucash
20:58:25 *** meb has quit IRC
20:58:37 *** meb has joined #gnucash
21:00:02 *** mikom has quit IRC
21:00:11 *** linas has quit IRC
21:01:09 *** mikom has joined #gnucash
21:02:31 *** linas has joined #gnucash
21:27:49 *** codesmythe has quit IRC
21:30:15 *** mlncn_ has joined #gnucash
21:41:16 *** mlncn_ has quit IRC
21:41:49 *** ArtGravity has quit IRC
21:42:14 *** codesmythe has joined #gnucash
22:09:42 *** chazdiezal has joined #gnucash
22:12:21 *** chazdiezal has quit IRC
22:20:53 *** codesmythe has quit IRC
22:21:20 *** codesmythe has joined #gnucash
23:05:21 *** chazdiezal has joined #gnucash