2010-11-20 GnuCash IRC logs
01:13:29 *** mikee has joined #gnucash
01:14:56 *** mikee__ has quit IRC
03:19:25 *** felle has quit IRC
04:10:17 *** opalepatrick has joined #gnucash
04:39:37 *** bigkah624 has joined #gnucash
04:40:09 <bigkah624> Hi folks, just stopping by to say hello. I'm new to gnucash.
04:45:09 *** bigkah624 has quit IRC
05:54:08 *** Slurpee has quit IRC
05:59:05 *** Slurpee has joined #gnucash
07:36:41 *** Slurpee has quit IRC
07:40:02 *** Slurpee has joined #gnucash
07:47:59 *** gary has quit IRC
08:16:57 *** tristan has joined #gnucash
08:46:10 *** Jimraehl has left #gnucash
08:47:03 *** e-ndy has joined #gnucash
08:54:32 *** Jimraehl has joined #gnucash
08:55:17 *** Slurpee has quit IRC
08:57:25 *** fbond has joined #gnucash
09:00:18 *** Slurpee has joined #gnucash
10:01:17 *** Slurpee has quit IRC
10:04:36 *** Slurpee has joined #gnucash
10:32:01 *** kpreid has quit IRC
10:36:34 *** DananFear has joined #gnucash
10:37:18 *** kpreid has joined #gnucash
10:37:30 *** DananFear has quit IRC
10:39:06 *** e-ndy has quit IRC
10:54:09 *** fell has joined #gnucash
10:57:18 *** kpreid has quit IRC
10:59:21 *** fbond has quit IRC
11:10:07 *** kpreid has joined #gnucash
11:18:17 *** Slurpee has quit IRC
11:30:10 *** Slurpee has joined #gnucash
12:02:17 *** fbond has joined #gnucash
12:05:27 *** ErKa has joined #gnucash
12:33:10 *** Slurpee has quit IRC
12:58:52 *** Slurpee has joined #gnucash
13:06:31 *** ErKa has quit IRC
13:16:25 *** ErKa has joined #gnucash
13:51:57 *** Slurpee has quit IRC
13:54:54 *** Slurpee has joined #gnucash
13:55:06 <Plouj> how do I tell what my monthly spending on average is for a given account?
14:33:12 *** ErKa has quit IRC
14:36:01 *** e-ndy has joined #gnucash
14:38:17 *** e-ndy has quit IRC
15:22:20 *** Slurpee has quit IRC
15:40:10 *** Slurpee has joined #gnucash
16:10:46 *** Antisoche has joined #gnucash
16:34:18 *** Slurpee has quit IRC
16:37:11 *** Slurpee has joined #gnucash
17:36:49 *** Antisoche has quit IRC
17:37:03 <Plouj> gaaaah
17:37:10 <Plouj> how do I undo?
17:37:14 <Plouj> I don't know what I just did
17:37:19 <Plouj> and the file appears saved
17:52:16 *** Slurpee has quit IRC
17:52:31 <kimmo> there's no "undo", but if you look inside the file, the entries have timestamps for when they were entered
17:52:47 <kimmo> the <trn:date-entered> node in the xml
17:55:57 <Plouj> which xml file? I have .xac, .log .LNK and a few .gnucash
17:57:19 <Plouj> oh, .xac
18:00:40 <Plouj> ah, I found the latest file that had the entry mentioned, which would be the original
18:16:32 *** opalepatrick has quit IRC
18:20:29 <Plouj> is there a way for me to just point the curren .gnucash file an earlier .xac file
18:21:58 <Plouj> *.gnucash is old format?
18:22:41 <fell> .gnucash = current file; .xac = backup
18:22:53 <Plouj> o_O
18:23:03 <Plouj> I just deleted my .gnucash file because it was dated 2007
18:23:34 *** warlord-afk is now known as warlord
18:23:42 <warlord> Plouj: it's just a file. rename it. or File -> Open it
18:23:46 <warlord> (or both)
18:24:06 <Plouj> warlord: you mean .xac?
18:24:27 <Plouj> I also have a no-extension file
18:24:29 <Plouj> ...
18:26:17 <fell> before the windows port there was no need to have a file extension.
18:31:32 <kimmo> and for the windows port, 3 bytes wasn't appropriate? ;)
18:34:47 <Plouj> ok, how do I read the log file
18:34:56 <Plouj> what does it store? last changes?
18:35:06 <Plouj> does it store value before and/or after the change?
18:36:11 <kimmo> you File -> Import -> Replay gnucash log file
18:36:15 <Plouj> I need to do some gnucash forensics because I don't remember the last good state of these transactions
18:36:39 <Plouj> kimmo: is that going to invalidate later log files?
18:36:45 <kimmo> no
18:37:21 <kimmo> you have .xac files, and .log files. Each .log file should have the transactions that were made between two .xac autosaves
18:38:30 <Plouj> I see
18:42:07 <kimmo> so whenever you press "enter" to save a transaction, it is immediately written to the .log file. And when the trigger to create a complete autosave .xac file is reached, a new .log file is started
18:45:30 <Plouj> ok
18:48:11 <Plouj> ok, it records the transaction
18:48:21 <Plouj> how does this work to change the existing transactions?
18:48:32 <Plouj> do newer transactions replace older ones with the same guid?
18:51:02 <warlord> the log is just that, a log.. When you replay the log it re-runs any changes you made, recorded in the log.
18:51:26 <warlord> HOWEVER, it only works if the only thing you did was create/modify/delete transactions. Any modifications to Accounts are NOT recorded.
18:51:47 <Plouj> what kind of other modifications could I make to accounts?
18:51:56 <Plouj> create accounts?
18:52:08 <warlord> In 2.2.x, the .xac and .log files are named as a time stamped version of your base file. So foo (your real data file) will cause foo-YYYYMMDDHHMMSS.xac (and .log) files to be created
18:52:21 <Plouj> I actually need to undo some logs, it seems like
18:52:27 <warlord> ANY modifications to accounts are NOT recorded in the log, and will render the replay unusable.
18:53:23 <warlord> There is no way to 'undo' a log, short of reverting back to the .xac file before the changes were made.
18:54:18 <Plouj> yeah
18:54:29 <Plouj> that's what I think I need to do
18:54:43 <Plouj> I just have to find the right log then xac
18:55:02 <Plouj> it's hard because I'm dealing with a split..
18:55:16 <warlord> so what exactly is the problem here?
18:55:25 <Plouj> so I'm not sure which accounts guid's to search for
18:55:46 <Plouj> I was trying to improve an account split transaction and I messed it up to the point where I don't get what is going on
18:56:09 <Plouj> so I want to undo to the last good version of the split (created before today)
18:56:21 <Plouj> but I also modified other transactions today...
18:56:30 <Plouj> and created new accounts...
18:57:14 <Plouj> at least I know understand what the gnucash files mean
18:57:21 <Plouj> sort-of
18:57:26 <warlord> Why not just delete the transaction and start over from scratch>
18:57:27 <warlord> ?
18:57:37 <warlord> If it's just the single transaction that's messed up.
18:57:44 <Plouj> it's a complicated one
18:57:59 <Plouj> it was a complicated situation and I can't remember how I set it up
18:58:08 <Plouj> so, the problem is my poor memory
18:58:15 <warlord> Is it a duplicate of another existing transaction?
18:58:20 <warlord> What is it a transaction of?
18:58:37 <Plouj> I don't think I explicitly made it a duplicate
18:59:19 <Plouj> it's actually a strange split
18:59:37 <warlord> What is it?
18:59:41 <Plouj> money are going to cash, to checking to a store and to a reimbursement acccount...
18:59:50 <Plouj> money is*
19:00:15 <Plouj> at least that's what it looks like now, I think it made more sense before I messed it up
19:00:34 <warlord> What was the real-world transaction that took place?
19:01:12 <warlord> if you find yourself entering weird things, most likely you're doing something wrong. Txns in Gnc model the real-world.
19:01:22 <warlord> most real-world txns are not complicated
19:02:11 <Plouj> yeah, I definitely overcomplicated this
19:02:30 <warlord> Well, then, delete and start over.
19:02:33 <Plouj> this split transaction is part goes with another transaction
19:02:34 <warlord> (delete the txn)
19:02:48 <warlord> Can you describe what happened in real life?
19:03:04 <Plouj> I'm trying, hang on
19:04:51 <Plouj> I paid a deposit (half the cost for 15 people) for a event with visa (first transaction), after the event people gave cash and a cheque back the money (each what they had to pay for the event)
19:05:07 <Plouj> and I also had to account for what I paid as part of that for myself for that event
19:05:27 <Plouj> the split was supposed to represent everything after the visa payment :/
19:05:43 <Plouj> ok, the sentence is broken
19:05:49 <warlord> Okay, first transaction is a split: Visa -> Asset:Friends & Expense:Event
19:05:55 <Plouj> after the event, people gave back the money in terms of cash and a check
19:06:05 <warlord> (I suppose you could split it out into each friend, if you wis)
19:06:08 <warlord> *wish*
19:06:14 <Plouj> k
19:06:37 <warlord> the second transaction is Asset:Friends -> Cash
19:06:49 <warlord> (assuming you paid your portion up front)
19:07:09 <warlord> If not, well, then there's an additional split to Expense:Event, for your portion.
19:07:11 <Plouj> I guess it was part of the downpayment
19:07:22 <warlord> (The Event expense is always only your portion of the cost)
19:07:29 <Plouj> I didn't pay anything explicitly separate other than the visa downpayment
19:07:55 <Plouj> so yeah, looks like I need a split to Expense:Event
19:08:36 <Plouj> humm
19:08:57 <Plouj> then I also, actually, deposited the check into a checking account
19:09:02 <Plouj> and I don't know what happened to the cash!
19:09:08 * Plouj pulls hair
19:09:22 <Plouj> wait!
19:09:26 <Plouj> I got it wrong
19:09:35 <Plouj> I didn't recieve any cash explicitly
19:10:30 <Plouj> I collected the cash from the participants and gave it to the event organizers. This sum plus the deposit equals the total cost: (cost-per-person*(friends+me))
19:10:58 <Plouj> I only got to deposit the check because the deposit obviously was much more than my portion
19:11:19 <Plouj> warlord: am I making sense to you?
19:11:26 <warlord> Right. Which is why you only need to account for the part that came back to you.
19:12:02 <warlord> I.e., You paid $300 Visa, your portion was $30, and Asset:Friends is $270. Then you got $270 back so Asset:Friends -> Checking
19:12:15 <warlord> Ignore the cash that your friends gave to the venue.
19:13:59 *** Slurpee has joined #gnucash
19:15:25 <Plouj> ok, that makes more sense now
19:20:51 <Plouj> that's why I should really be recording transactions on the day they happen :)
19:21:12 <Plouj> plus it was helpful to understand how I can use assets to track money people owe me
19:27:19 <warlord> :)
19:34:43 *** fbond has quit IRC
20:00:01 *** aoc has joined #gnucash
20:02:49 *** aoc has quit IRC
20:14:25 *** Slurpee has quit IRC
21:26:01 <Plouj> splits are one to many, not many to many, right?
21:26:54 <warlord> technically they can be many to many.
21:27:13 <warlord> Although some reports (e.g. cash flow) might not quite handle it as you would expect.
21:34:57 <Plouj> oh
21:51:20 *** bentob0x has joined #gnucash
21:55:04 *** bentob0x has quit IRC
23:28:32 *** warlord is now known as warlord-afk