2015-08-23 GnuCash IRC logs
00:00:03 *** fuzzybunny69y has joined #gnucash
00:15:24 *** fuzzybunny69y has quit IRC
00:17:06 *** fuzzybunny69y has joined #gnucash
00:19:34 *** fuzzbunn has joined #gnucash
00:21:14 *** fuzzybunny69y has quit IRC
00:42:52 *** fuzzybunny69y has joined #gnucash
00:44:47 *** fuzzbunn has quit IRC
01:02:35 *** fuzzbunn has joined #gnucash
01:04:27 *** fuzzybunny69y has quit IRC
01:22:14 *** fuzzybunny69y has joined #gnucash
01:23:58 *** fuzzbunn has quit IRC
01:37:38 *** fuzzbunn has joined #gnucash
01:39:34 *** fuzzybunny69y has quit IRC
01:49:10 *** fuzzybunny69y has joined #gnucash
01:50:57 *** fuzzbunn has quit IRC
01:56:21 *** fell_ has joined #gnucash
01:58:13 *** fell has quit IRC
02:00:58 *** fuzzbunn has joined #gnucash
02:02:59 *** fuzzybunny69y has quit IRC
02:16:30 *** fuzzybunny69y has joined #gnucash
02:18:25 *** fuzzbunn has quit IRC
02:20:54 *** frozenjim has quit IRC
02:39:30 *** fuzzbunn has joined #gnucash
02:40:52 *** fuzzybunny69y has quit IRC
02:57:11 *** fuzzybunny69y has joined #gnucash
02:59:03 *** fuzzbunn has quit IRC
03:12:50 *** fuzzbunn has joined #gnucash
03:14:39 *** fuzzybunny69y has quit IRC
03:27:20 *** fuzzybunny69y has joined #gnucash
03:29:13 *** fuzzbunn has quit IRC
03:37:29 *** fuzzybunny69y has quit IRC
03:44:55 *** fuzzybunny69y has joined #gnucash
03:51:09 *** fuzzybunny69y has quit IRC
03:56:38 *** fuzzybunny69y has joined #gnucash
03:59:28 *** fuzzbunn has joined #gnucash
04:01:15 *** fuzzybunny69y has quit IRC
04:14:09 *** fuzzybunny69y has joined #gnucash
04:15:51 *** fuzzbunn has quit IRC
04:30:16 *** fuzzbunn has joined #gnucash
04:32:04 *** fuzzybunny69y has quit IRC
04:51:26 *** fuzzybunny69y has joined #gnucash
04:52:50 *** fuzzbunn has quit IRC
05:03:26 *** fuzzybunny69y has quit IRC
05:04:44 *** fuzzybunny69y has joined #gnucash
05:10:40 *** fabior has joined #gnucash
05:14:24 *** fuzzybunny69y has quit IRC
05:25:30 *** frozenjim has joined #gnucash
05:34:02 *** MechtiIde has joined #gnucash
05:42:47 *** fuzzybunny69y has joined #gnucash
05:45:06 *** MechtiIde has quit IRC
05:54:32 *** himaxx has joined #gnucash
05:55:20 *** nomeata has joined #gnucash
05:55:33 *** fuzzbunn has joined #gnucash
05:56:51 *** fabior has quit IRC
05:57:27 *** fuzzybunny69y has quit IRC
06:06:18 *** himaxx has quit IRC
06:15:03 *** fuzzybunny69y has joined #gnucash
06:16:52 *** fuzzbunn has quit IRC
06:24:04 *** jralls has quit IRC
06:38:41 *** fabior has joined #gnucash
06:48:41 *** MechtiIde has joined #gnucash
07:18:44 *** himaxx has joined #gnucash
07:22:26 *** Jimraehl1 has left #gnucash
07:25:41 *** himaxx has quit IRC
07:29:49 *** Jimraehl1 has joined #gnucash
07:30:17 *** fuzzbunn has joined #gnucash
07:32:03 *** fuzzybunny69y has quit IRC
07:32:16 *** himaxx has joined #gnucash
07:35:44 *** MechtiIde has quit IRC
07:36:49 *** nomeata has quit IRC
07:54:35 *** himaxx has quit IRC
08:07:59 *** fuzzybunny69y has joined #gnucash
08:09:50 *** fuzzbunn has quit IRC
08:10:16 *** Unhammer has quit IRC
08:28:36 *** fuzzbunn has joined #gnucash
08:30:23 *** fuzzybunny69y has quit IRC
08:31:27 *** MechtiIde has joined #gnucash
08:35:58 *** fuzzybunny69y has joined #gnucash
08:36:02 *** Unhammer has joined #gnucash
08:37:57 *** fuzzbunn has quit IRC
09:23:46 *** fuzzbunn has joined #gnucash
09:25:33 *** fuzzybunny69y has quit IRC
09:28:29 *** jralls has joined #gnucash
09:28:30 *** gncbot sets mode: +o jralls
09:33:04 *** fabior has quit IRC
09:33:08 *** fuzzybunny69y has joined #gnucash
09:35:00 *** fuzzbunn has quit IRC
09:55:08 *** fuzzbunn has joined #gnucash
09:56:01 *** MechtiIde has quit IRC
09:56:46 *** fuzzybunny69y has quit IRC
10:12:04 *** fuzzybunny69y has joined #gnucash
10:12:29 *** jeffsf has quit IRC
10:12:54 *** jeffsf has joined #gnucash
10:13:39 *** fuzzbunn has quit IRC
10:29:10 *** fuzzbunn has joined #gnucash
10:30:50 *** fuzzybunny69y has quit IRC
10:33:17 *** jeffsf1 has joined #gnucash
10:34:15 *** jeffsf has quit IRC
10:47:39 *** fuzzybunny69y has joined #gnucash
10:49:23 *** fuzzbunn has quit IRC
10:50:22 *** jeffsf1 has quit IRC
10:50:57 *** jeffsf has joined #gnucash
11:15:44 *** fuzzbunn has joined #gnucash
11:17:33 *** fuzzybunny69y has quit IRC
11:24:21 *** fuzzybunny69y has joined #gnucash
11:26:00 *** fuzzbunn has quit IRC
11:41:06 *** jeffsf has quit IRC
11:44:29 *** jeffsf has joined #gnucash
11:47:18 *** chazdiezal1 has joined #gnucash
11:47:18 *** chazdiezal has quit IRC
11:49:19 *** chazdiezal1 has quit IRC
11:54:16 *** fuzzbunn has joined #gnucash
11:56:05 *** fuzzybunny69y has quit IRC
12:00:22 *** fuzzbunn has quit IRC
12:53:40 *** fuzzbunn has joined #gnucash
13:02:12 *** jeffsf has quit IRC
13:02:21 <frozenjim> Imbalance-CAD account had lots of transactions. I have reposted all of them correctly but now have an Imbalance-CAD full of zero-value entries. Do I simply delete them now?
13:03:03 <warlord> frozenjim: you need to make sure the Imabalnce account is *empty*.
13:03:41 <warlord> If there is a split with $0, then you can just remove that split by expanding the transaction, then clearing out all entries on the line
13:04:02 <warlord> you cannot delete the account until the account is empty... otherwise it will just create an Orphan-CAD account
13:04:03 <frozenjim> well, it has a zero balance, but is not "empty". Every transaction I posted (from Current:Visa to various Expense accounts) is still "there". But all now show zero balance. there are no splits in the imbalance account.
13:05:03 <frozenjim> Account total balance is zero.
13:05:05 <warlord> you just said two mutually-exclusive things. You said "Every transaction I posted... is still "there"". and then you said "there are no splits in the imbalance account". One or the other of these statements is false.
13:05:22 <warlord> It doesn't matter what the account balance is.
13:05:27 <warlord> Open up the imabalnce account.
13:05:31 <warlord> Do you see anything in the register?
13:06:21 <frozenjim> Yes. Everything is there but now the balance is zero for each item. I didn't change any values in imbalance, I just matched up the VISA items and changed them from imbalance to the correct expense account.
13:06:37 <frozenjim> I had presumed this would delete the imbalance item at the same time.
13:07:18 <warlord> how did you "change" them?
13:08:44 <frozenjim> For example, VISA showed an item "item one" for $20 to Imbalance. Imbalance also showed $20 to "Visa". I went into the VISA register and switched the account from Imbalance to "Expense". Now when I go back to Imbalance ledger, the item remains but now has a zero total. No debits, no credits, but the line item remains in imbalance.
13:09:16 *** reactormonk has joined #gnucash
13:10:07 *** Coderjoe has quit IRC
13:10:09 <warlord> frozenjim: please give me a screenshot of your Visa account with one of these transactions split-expanded?
13:10:18 <frozenjim> Sure, how?
13:10:30 <warlord> imagebin
13:10:36 <frozenjim> kk. one sec.
13:13:06 *** Coderjoe has joined #gnucash
13:14:30 *** fell_ has quit IRC
13:17:34 *** jeffsf has joined #gnucash
13:21:58 <frozenjim> warlord, I'm not comfortable using my twitter account this way. can I email you the images? (one from each register)
13:25:09 <frozenjim> warlord or Google Docs?
13:27:38 <warlord> frozenjim: I suggested imagebin. It's like pastebin but for images.
13:29:55 <warlord> Regardless, if you have a regular transaction and change the account from imbalance to something else, it should remove that from imbalance.... unless you have another imbalance somewhere. So that's why I want to see an example
13:32:54 <frozenjim> Using "Double Line" and "Split", looking at an AMAZON transaction in Imbalance-CAD, there are no debits, no credits. Just the one line with the date, description and balance (0.00). There is no other information.
13:41:02 *** fuzzbunn has quit IRC
13:41:59 <frozenjim> warlord, OK, try this link, it's a Google site with the images you're after: https://sites.google.com/a/resolutionit.ca/test1/
13:53:34 *** bozonius has joined #gnucash
13:56:17 *** MechtiIde has joined #gnucash
14:17:17 *** MechtiIde has quit IRC
14:19:15 *** MechtiIde has joined #gnucash
14:19:32 *** fell has joined #gnucash
14:20:49 <warlord> frozenjim: those transactions look weird. I can't tell for sure because it's missing the Debit/Credit amounts in the image, but the fact that there's only one entry with a line in the Account column is.... bad.
14:21:08 <warlord> I don't know how these transactions were created, but... they are definitely broken in some way.
14:37:31 *** MechtiIde has quit IRC
15:21:42 <jralls> warlord: It sometimes happens if you save an out-of-balance transaction, then edit it and zero the amount in the imbalance-account split and create a new split in the correct account to balance it that the original imbalance split with zero value will remain.
15:25:44 <jralls> frozenjim: If what I just described to warlord is what's happened to you, do a search (ctrl/cmd-F) and use "account", "matches any account", "Imbalance-CAD". This will produce a ledger tab with all of those transactions which isn't anchored to any account. Delete the Imbalance-CAD split from each transaction.
15:27:00 <jralls> warlord: Separate issue. A user Lonly22 created a wiki account yesterday and promptly began making a PITA of itself. What happened to the 1-week waiting period?
15:43:36 *** dgtlmoon has quit IRC
15:45:22 *** dgtlmoon has joined #gnucash
16:09:15 <frozenjim> Well, that sounds... disappointing. It isn't one transaction - it is ALL of them. There are about 100 like that. I imported my bank records, it assigned everything to imbalance-CAD, I went through my VISA ledger one at a time assigning the correct splits. then I checked Imbalance-CAD to ensure I hadn't missed anything and I found a ledger full of zeros. OK, well, nothing for it but to delete them manually, cross my fingers and see what happens!
16:09:46 <frozenjim> Is there any chance that my method of dealing with the imported transactions is in error? It seems pretty straight-forward...
16:11:43 <jralls> frozenjim: Well, it's a lot more efficient to use the import assistant to assign the target accounts, with the added benefit that it learns from your assignments and will, after a few imports, do most of the work for you.
16:12:48 <frozenjim> Yes... I see that now ;-).
16:13:01 <jralls> But if you insist on not using it, then when you assign the accounts from the imbalance account do it with a query like I explained earlier instead of editing the transactions in the imbalance account.
16:14:20 <jralls> The reason is that when you edit in an account it sometimes won't let you delete the split "anchoring" the transaction to the account being edited. That's what I think got you into this problem.
16:14:26 <frozenjim> I am a sucker for "the hard way". Some twisted part of myself thinks I learn more that way. To be clear: I am not editing the transactions in the imbalance account, rather I use it as a reference to ensure that I haven't missed anything. These Imbalance transactions were created by an import of my VISA account from the bank, I edited each in the VISA ledger simply by changing the "Imbalance-CAD" to the correct account.
16:15:35 <frozenjim> And it was EVERY transaction that this happened to. Not one or two.
16:15:51 <jralls> That shouldn't have left you with an imbalance split... unless you're operating in more than one currency, which complicates things.
16:16:31 <frozenjim> Everything I imported remained in the Imbalance-CAD with a zero balance after I had reassigned the transactions in the VISA ledger.
16:16:42 <jralls> I'm also not sure that the import assistant works in multiple currencies. I'm pretty sure that multicurrency wasn't considered in the design.
16:16:44 <frozenjim> No fancy currencies. Just CAD.
16:17:31 <frozenjim> (in fact, I spent quite a bit of time in Gnumeric calculating the CAD from the USD invoice totals!) Excellent exercise, but time consuming.
16:18:13 <frozenjim> Well, fingers crossed that it all holds together. It seems fine now. Thanks warlord, jralls. I really appreciate your help - or at least moral support.
16:19:08 <jralls> frozenjim: What's this about using Gnumeric to calculate CAD from USD invoices? Is that separate from the CC?
16:19:29 <frozenjim> warlord, While I'm at it, I am very impressed with your dedication. You're doing a great thing by simply being there every day - seemingly forever. Thank you.
16:19:42 <jralls> You do know that you can do calculations in the GnuCash register, right?
16:20:32 <frozenjim> jralls, noooo.... I didn't consider that. I was using Gnumeric to break out the PayPal USD totals into their CAD counterparts for splits. PayPal gave everything in USD EXCEPT for their calculated totals.
16:21:25 <jralls> frozenjim: So you imported transactions from Paypal in USD and then converted them into CAD?
16:22:24 <frozenjim> No, PayPal invoice breaks line items out as USD but then converts to CAD for presentation to VISA. So my VISA gives me a CAD total but I need to split out the PST, GST and Shipping as CAD line items. So I had to back-calculate the conversions.
16:24:27 <jralls> Ah, so you're not just changing the Imbalance-CAD to Expenses:Foo in Basic view, you're opening the transaction in splits and adding splits. Right?
16:25:12 <jralls> Sorry, opening the transaction in Split view...
16:27:04 *** Dudytz has joined #gnucash
16:27:47 <Dudytz> Hi all. I need to enter my Condo Fees, is there a existing standard account to these type of payments?
16:29:58 <jralls> Dudtyz: If you don't see one you like in the existing accounts just create a new one.
16:30:50 <Dudytz> jralls: ok, thank you
16:30:51 <frozenjim> jralls, exactly.
16:31:55 <jralls> frozenjim: Then the assistant won't help you anyway, it's only smart enough to deal with two-split transactions.
16:32:00 <Dudytz> I think that this is a common bill (several peoples lives in condo's) .. why not create it in the standard accounts?
16:32:54 <jralls> When you're editing the transaction, always tab into the empty split at the bottom to make sure that the transaction is balanced with no Imbalance split before hitting return to save it.
16:34:19 *** Dudytz has quit IRC
16:34:32 <jralls> Dudtyz: There are no "standard" accounts. There are *template* accounts to help get you started. You're expected to add and remove accounts to suit your own needs, and account creation and deletion is really easy for just that reason.
16:49:51 *** jralls is now known as jralls_afk
17:46:29 *** himaxx has joined #gnucash
17:51:02 *** himaxx has quit IRC
18:42:12 <warlord> jralls_afk: Huh. I dont know what happened to that.. I'm wondering if we should just turn off account creation, period, and require manual account creation.
18:42:24 <warlord> yes, that's a major PITA for everyone involved, but it would stop the spam problem.
18:42:54 <warlord> frozenjim: well, that was your first mistake -- you should never consciously assign transactions to an Imbalance account.
21:11:10 *** pryoclastic has joined #gnucash
21:12:46 <pryoclastic> Hey guys .. I am trying to an import of an OFX file. The generic import transaction matcher will match but after importing I cannot find the transaction. Any thoughts as to where it went?
21:26:10 <warlord> pryoclastic: what account did you set as the import account when you started the OFX import? (note that you may have set this mapping in a previous import from the same OFX Account; GnuCash remembers the mapping and will re-use it)
21:29:30 *** bozonius has quit IRC
21:33:47 <pryoclastic> warlord: I didnt pick an account per se.
21:34:14 <pryoclastic> I downloaded the OFX file, opened GNU cash and then went File > Import
21:35:21 <pryoclastic> So if I select "R" the status will flip to green and it will say "Reconcile (auto) match"
21:36:43 <pryoclastic> The help file says that it will import it balanced but I sure cannot find it. :D
21:37:33 <pryoclastic> The good news is that I did not save the file after import so I have been doing this over and over trying to figure out where I goofed.
22:06:23 *** fuzzbunn has joined #gnucash
22:12:47 *** fuzzybunny69y has joined #gnucash
22:14:30 *** fuzzbunn has quit IRC
22:20:39 *** Coderjoe has quit IRC
22:20:56 *** fuzzybunny69y has quit IRC
22:22:05 *** fell has quit IRC
22:24:25 *** fuzzybunny69y has joined #gnucash
22:26:17 *** Coderjoe has joined #gnucash
22:41:16 *** fuzzbunn has joined #gnucash
22:43:07 *** fuzzybunny69y has quit IRC
22:46:30 *** Coderjoe has quit IRC
22:49:49 *** fuzzybunny69y has joined #gnucash
22:51:35 *** fuzzbunn has quit IRC
22:51:49 *** Coderjoe has joined #gnucash
23:04:52 *** fuzzbunn has joined #gnucash
23:06:29 *** fuzzybunny69y has quit IRC
23:24:51 *** fuzzybunny69y has joined #gnucash
23:26:38 *** fuzzbunn has quit IRC
23:31:53 *** pryoclastic has quit IRC
23:58:48 *** fuzzybunny69y has quit IRC
23:59:41 *** fuzzybunny69y has joined #gnucash