2015-01-09 GnuCash IRC logs

00:35:57 *** StuM has joined #gnucash
01:31:34 *** GabrieleV_ has joined #gnucash
01:31:37 *** GabrieleV has quit IRC
01:31:38 *** GabrieleV_ is now known as GabrieleV
01:51:34 *** GabrieleV_ has joined #gnucash
01:51:44 *** GabrieleV has quit IRC
01:51:45 *** GabrieleV_ is now known as GabrieleV
02:36:34 *** GabrieleV_ has joined #gnucash
02:36:35 *** GabrieleV has quit IRC
02:36:35 *** GabrieleV_ is now known as GabrieleV
02:44:43 *** O01eg has quit IRC
02:51:03 *** pacon has joined #gnucash
02:52:38 *** uXus has quit IRC
02:55:00 *** uXus has joined #gnucash
02:55:31 *** gour has joined #gnucash
03:58:18 *** cartsoftware has joined #gnucash
03:59:57 *** StuM has quit IRC
04:20:58 *** StuM has joined #gnucash
04:32:55 *** nomeata has joined #gnucash
04:44:51 *** soa2ii has quit IRC
04:47:13 *** aqua___ has joined #gnucash
05:00:44 *** O01eg has joined #gnucash
05:17:48 *** uXus has quit IRC
05:21:39 *** uXus has joined #gnucash
05:22:03 *** Girobino has joined #gnucash
05:24:32 <Girobino> Hi! How can I save the settings for the invoice printing?
05:45:06 *** len has quit IRC
06:15:13 *** gour_ has joined #gnucash
06:23:46 *** gour has quit IRC
06:30:00 *** Girobino has quit IRC
06:31:14 *** aqua___ has quit IRC
06:39:45 *** Jimraehl1 has left #gnucash
06:58:59 *** Jimraehl1 has joined #gnucash
07:37:40 *** andy has quit IRC
07:48:41 *** rickoehn has joined #gnucash
07:51:00 *** andy has joined #gnucash
07:54:23 *** aqua___ has joined #gnucash
07:54:27 *** pacon has quit IRC
07:57:08 <warlord> anything: Yes, it needs to be recorded as Income.. and another balancing split to offset the value or the stock (basically converting unrealized to realized cap gain/loss)
08:09:05 *** aqua___ has quit IRC
08:17:01 *** uXus has quit IRC
08:19:17 *** uXus has joined #gnucash
08:48:37 *** aqua___ has joined #gnucash
08:53:42 *** Girobino has joined #gnucash
09:07:22 *** Ahmuck has joined #gnucash
09:17:55 <Ahmuck> hi. is there a way to show transaction histories in a graphical form and "connect the dots"?
09:38:08 <warlord> Ahmuck: I'm not sure what you mean. what 'dots'?
09:38:12 <Ahmuck> i think i've got it using a libreoffice spreadsheet
09:38:38 <Ahmuck> i'm trying compare all transactions between a set of dates accross six accounts
09:38:46 <Ahmuck> the date set is very narrow
09:39:23 <Ahmuck> payments, deposits, withdrawals. i'm trying to track a specific deposit, withdrawal, deposit
09:43:06 *** mlncn has quit IRC
09:46:17 <warlord> I'm not sure what "dots" you're trying to connect. GnuCash *does* have a line plot capability, but the only report that uses it is a Price Plot. I'm not sure how it would apply to regular transactions; the graph just wouldn't make sense.
09:54:03 *** mlncn has joined #gnucash
09:55:14 <Ahmuck> it's not actually a graph, but rather a visual view of transactions, similiar to a flow chart. tracking a set of transactions
09:55:19 <Ahmuck> i can do it with a spreadsheet
09:55:40 <Ahmuck> i can see the transactions + - side by side and see credits/debits
09:55:51 *** uXus has quit IRC
09:57:36 <warlord> I still have no idea what you mean or what that would look like.
09:58:35 *** codesmythe has joined #gnucash
10:07:52 *** uXus has joined #gnucash
10:27:06 <Ahmuck> i'll create a mockup
10:27:39 <Ahmuck> is there a way to select a date range and a set of accounts and pull those accounts in side by side for comparison?
10:29:58 <warlord> What kind of "side-by-side comparison"?
10:38:43 <Ahmuck> like a spreadsheet. account 1, account2, account 3 where i can see out/in to each account
10:38:48 <Ahmuck> add/minus
10:46:35 <Girobino> IMHO, this sounds like an data export.
10:49:59 <warlord> like a cash flow?
11:00:47 <Ahmuck> my bank statment differs from my bank slips
11:00:59 <Ahmuck> i am going to have to prove it was their error
11:01:19 <Ahmuck> because I have specific amounts for these accounts it's easy to track by amount.
11:01:52 <Ahmuck> being able to compare the accounts side by side money in, money out allows me to show myself and them where the error occured
11:03:28 *** AceofSheez has joined #gnucash
11:03:30 <AceofSheez> hi
11:03:45 <AceofSheez> im trying to import some transactions, and one of them says do not import, no action selected
11:03:47 <AceofSheez> how do i fix that?
11:04:15 <warlord> Ahmuck: multi-column cash flow report?
11:04:28 <warlord> AceofSheez: what import protocol?
11:04:32 <AceofSheez> ofx?
11:04:38 <Ahmuck> i honestly don't know what a cash flow report would be
11:04:44 <Ahmuck> no import protocal
11:04:45 <AceofSheez> it has 5 transactions, but one says that
11:04:52 <AceofSheez> and i can't seem to do anything
11:04:56 <Ahmuck> i already have everything in
11:05:09 <Ahmuck> help AceofSheez 4 now
11:05:18 <AceofSheez> clicking on it does nothing
11:06:13 *** rickoehn has quit IRC
11:07:34 <warlord> Hm, I'm afraid I'm not an expert on the ofx importer.
11:08:37 <AceofSheez> well, i have the generic import transaction matcher pulled up
11:08:45 <AceofSheez> and one of them is in red, and says do not import, no action selected
11:08:48 <AceofSheez> how do i select an action?
11:10:09 <warlord> AceofSheez: perhaps the transaction is a duplicate?
11:10:19 <AceofSheez> i think it thinks that, but it's not
11:10:57 <warlord> Is there an existing transaction that is "close" to it in terms of date/value?
11:11:09 <warlord> What if you double-click on the color bar?
11:19:03 <Ahmuck> sry, gtg. did it with a spreadsheet
11:19:10 *** Ahmuck has quit IRC
11:20:45 <AceofSheez> color bar?
11:20:54 <AceofSheez> if i then click reconcile
11:21:01 <AceofSheez> that dialog pops up, and i can't check R for it
11:21:15 <AceofSheez> actually that is unrelated
11:21:26 <warlord> AceofSheez: i recommend you email the gnucash-user list
11:21:30 <AceofSheez> k
11:21:40 <AceofSheez> i guess i can manually put it in, also
11:24:30 * warlord doesn't use any importers
11:31:11 *** StuM has quit IRC
11:35:08 *** Girobino has left #gnucash
11:40:40 *** wol has joined #gnucash
11:43:00 *** linas has quit IRC
11:49:33 *** nomeata has quit IRC
11:59:50 *** linas has joined #gnucash
12:42:42 *** wol has quit IRC
12:43:42 *** rickoehn has joined #gnucash
12:58:47 *** linas has quit IRC
13:00:49 *** jimvideo has joined #gnucash
13:08:21 *** wol has joined #gnucash
13:11:24 <jralls> AceofSheez: In the middle of the line in the import window you'll see 3 check boxes. Check the left-hand one in the red line to enable importing it; if it's yellow also select a counter-account for it to turn it green.
13:11:46 <jralls> AceofSheez: The red just means that the matcher thinks that it's already been imported.
13:12:42 <AceofSheez> jralls, it didn't allow me to check:(
13:12:47 <AceofSheez> but i just manually put it in
13:13:08 <AceofSheez> thanks
13:13:10 *** AceofSheez has quit IRC
13:15:28 *** wol has quit IRC
13:30:47 *** rpg has joined #gnucash
13:32:08 *** lmat has joined #gnucash
13:35:12 *** MechtiIde has joined #gnucash
13:49:22 *** lmat has quit IRC
14:30:28 *** lmat has joined #gnucash
15:00:04 *** rubdos has joined #gnucash
15:04:33 *** cartsoftware has quit IRC
15:07:23 *** MechtiIde has quit IRC
15:12:10 *** Ahmuck has joined #gnucash
15:12:15 *** Ahmuck has left #gnucash
15:12:16 *** Ahmuck has joined #gnucash
15:12:20 *** Ahmuck has left #gnucash
15:12:27 *** Ahmuck has joined #gnucash
15:12:46 <Ahmuck> warlord: would you like an exmaple of what i was trying to accomplish?
15:13:17 <warlord> Ahmuck: sure
15:14:03 <Ahmuck> before i do that, let me read on multi-column report. perhaps it might have solved my problem.
15:14:49 <Ahmuck> is there a way to set the order of entries manually, ie, assign them an additional id?
15:15:19 <Ahmuck> !help
15:15:28 <Ahmuck> !manual
15:17:31 *** gour_ has quit IRC
15:17:40 <warlord> Ahmuck: order of what entries? Transactions? Accounts??
15:18:01 <Ahmuck> transactions in accounts
15:18:06 <Ahmuck> so they match my statement
15:18:11 <warlord> (it would really help me if you used GnuCash terminology when asking questions)
15:18:16 <Ahmuck> i know the num option is there
15:18:27 <warlord> The num option is how you order transactions within a day.
15:18:29 <Ahmuck> i'm lucky enough if i know how to saw dollar :)
15:18:46 <warlord> You can reorder accounts in the CoA using account codes.
15:18:49 <Ahmuck> i've been using the num column to put the number of my checks in
15:19:17 <warlord> Which is what it is originally meant to be
15:19:23 <Ahmuck> and descriptions like DEP = deposit, TXF = Transfer, DBT = Debit, etc.
15:19:26 <Ahmuck> ok
15:19:41 <warlord> Note that you cannot guarantee that the order in your accounts == the order the bank processes, and making your books match the bank's is a BAD IDEA>
15:19:45 <Ahmuck> so it isn't uncommon for me to grab some counter checks which have no number to them
15:20:06 <Ahmuck> sure, i understand that. i'm just doing it at the end of year
15:20:13 <Ahmuck> btw, why a BAD IDEA?
15:20:29 * Ahmuck had to go and ask my bank to fix something for June.
15:20:37 <warlord> Let's say you write a check on Jan 2. But the person doesn't deposit it until Feb 1.
15:20:56 <warlord> You still want to track the fact that you wrote the check.
15:21:02 <warlord> But the bank has no idea you did.
15:21:14 <warlord> Hense: your books != the Bank's books.
15:21:20 <Ahmuck> oh, yes, i understand what your saying. i've not had to track checks
15:22:17 <warlord> Also, there can be delays between when you initiate a txn and when it gets processed. This is also something that can cause reordering. You should always enter transactions based on when you initiate them, not when you expect them to hit the bank
15:22:23 <Ahmuck> i was wondering if there was another column that would allow me to order transactions. i could still use gnucash for daily entry (not done it yet) but could also order transactions according to statement
15:22:33 <warlord> No, there is not.
15:22:43 <Ahmuck> ok. thx
15:23:07 <warlord> Order (in the register) is always: Date Posted (visible date), then Num Column, then Date Entered (invisible, not-modifyiable)
15:23:15 <Ahmuck> i think i'll use the description then to record the check number and the num column to order the entries
15:23:37 <Ahmuck> there is a entry record though as i see there is an option for ordering by entry
15:24:33 <warlord> "entry record"?/??
15:25:01 <Ahmuck> hrm, see, it's hard for me sometimes to move around looking for an entry on the statement because i've had this problem with a form of dyx where when i get to the end of the line and then come back to the beginning i miss my place
15:25:21 <Ahmuck> yes, sort by "date of entry"
15:25:33 <warlord> AHH, thank you.
15:25:45 <warlord> Can't you go by the color?
15:25:52 <warlord> Or where you have your mouse?
15:26:44 <warlord> (Sorry, I'm sure you've spent many hours and years trying to hone your personal workarounds)
15:28:52 <Ahmuck> it's ok. i use an envelope when working through the statement (it does not have color, just type, it's hard to read for a normal person I think)
15:30:04 <warlord> yeah, often when going through a statement I use a pen or pencil or sometimes a piece of paper or some other thing to point to the current line so I dont get lost.
15:30:38 <warlord> But I dont bother with making the orders match.. The reconcile window lets me select them "out of order".
15:32:14 <Ahmuck> i agree. my problem with the statement and the register was i was having problem tracking everything. my bank really messed up my statement in June.
15:32:33 <Ahmuck> i usually don't do books until the end of the year
15:33:03 <warlord> *THAT* is your problem :)
15:33:14 <warlord> You should spend time doing it weekly or monthly, not yearly.
15:33:25 <warlord> It takes much less time when you do it more frequently.
15:33:27 <warlord> (trust me!!)
15:34:08 <warlord> I have some accounts (investments) that I enter yearly. It takes me so much time to get it all done.. Whereas my CC and Bank accounts I do weekly, and I'm never getting frustrated.
15:44:18 *** codesmythe has quit IRC
15:54:01 <Ahmuck> well, i'm not frustrated per se, just trying to track things. i keep a running total in my head or on a piece of paper and round up, (ie 14.53 == 15.00). this way i don't overdraft and don't have to worry about the books so much.
16:03:09 *** rubdos has quit IRC
16:25:30 <lmat> Ahmuck: For what it's worth, some financial institutions won't correct errors a number of months in the past. (Another reason to do it when you can).
16:27:01 *** len has joined #gnucash
16:46:30 *** linas has joined #gnucash
17:06:37 *** cigarshark has joined #gnucash
17:31:39 *** GabrieleV_ has joined #gnucash
17:31:42 *** GabrieleV has quit IRC
17:31:42 *** GabrieleV_ is now known as GabrieleV
17:38:23 <Ahmuck> yes, i know. they will correct it if it's your error but not theirs. the problem is i travel and i often travel very light, as in a passport and a wallet
17:38:42 <Ahmuck> so often i don't have an opportunity to correct things until i return
17:38:54 <Ahmuck> lmat:
17:40:00 <lmat> ah
17:40:05 <Ahmuck> warlord: another reason for ordering by statement is for older people. while i am older, my parents are even older. it helps when they can go down the statement line by line with gnucash printout in hand as well. it reduces confusion when it's right next to each other
17:40:10 <lmat> Ahmuck: (thanks for the 'ping' ^_^)
17:41:21 <Ahmuck> thx 4 the thx
17:43:09 <Ahmuck> in respect to the report, in sql i might pull a column from x a column from y and a column from z. i was hoping to do this, i've just not dug deep enough in the docs to find out how to do it yet
17:43:44 <warlord> Ahmuck: I will repeat what I said -- this is what the reconciliation window/process is for.
17:44:33 <Ahmuck> ok, ok, i get it. what language is gnucash written in?
17:48:44 <lmat> Ahmuck: Mostly C, increasingly C++, and scheme.
17:50:41 <Ahmuck> ok, i could probably hack C++ in time, but i don't know anything about scheme
17:56:34 *** rickoehn has quit IRC
17:59:08 *** StuM has joined #gnucash
18:24:00 *** aqua___ has quit IRC
18:40:16 *** linas has quit IRC
18:48:56 *** nomeata has joined #gnucash
18:50:10 *** jimvideo has quit IRC
18:53:56 *** fell has joined #gnucash
18:53:57 *** gncbot sets mode: +o fell
18:56:39 *** himaxx has joined #gnucash
19:01:50 *** mlncn has quit IRC
19:11:55 *** linas has joined #gnucash
19:13:59 *** andy has quit IRC
19:17:39 *** andy has joined #gnucash
19:18:04 *** nomeata has quit IRC
19:20:42 *** rpg has quit IRC
19:35:13 *** len has quit IRC
19:58:57 <warlord> Ahmuck: scheme is mostly used for reports, options, and the qif importer.
19:59:02 <warlord> Pretty much everything else is C
20:40:10 *** cigarshark has quit IRC
20:42:32 *** len has joined #gnucash
20:42:51 *** fell has quit IRC
21:07:14 *** StuM has quit IRC
21:28:48 *** fell has joined #gnucash
21:28:48 *** gncbot sets mode: +o fell
21:35:20 *** len has quit IRC
21:52:43 *** lmat has quit IRC
22:03:47 *** linas has quit IRC
22:11:42 *** linas has joined #gnucash
23:00:04 *** fell has quit IRC
23:22:25 *** codesmythe has joined #gnucash
23:58:02 *** pacon has joined #gnucash