2013-02-03 GnuCash IRC logs
02:21:05 *** john has joined #gnucash
02:21:05 *** gncbot sets mode: +o john
02:50:11 *** john has quit IRC
03:10:06 *** benoitg has quit IRC
04:55:51 *** fabior has joined #gnucash
05:02:57 *** Wouter has joined #gnucash
05:04:18 <Wouter> Hello, Thank you for your help. I am Dutch and support my wife with her administration. We live in France. My wife runs a medical practice in a rural (social) area. For the year 2011 I managed to do her administration in GnuCash. I remember that I set-up her file with her accounts (I changed the names of the accounts to match the French accounting system – h
05:22:29 *** calbasi has joined #gnucash
06:34:45 *** Wouter has quit IRC
07:41:23 *** Topcat has joined #gnucash
07:50:27 *** Topcat has quit IRC
08:16:43 <mikee> warlord: I've locked my self out of @svn.gnucash.org my IP addr. is 31.185.250.101. Would you unblock me please?
08:17:26 <mikee> Trying to run git svn init ... on freshly cloned git repo. Failed so far.
08:25:17 *** Jimraeh1 has left #gnucash
09:01:01 <warlord> mikee: fixed. It's asking for a password, meaning your ssh key isn't being pulled in.
09:04:15 *** Jimraeh1 has joined #gnucash
09:08:54 <mikee> warlord: Thanks. Is that my fault or yours?
09:10:41 <warlord> yours.
09:10:57 <warlord> Make sure your ssh keys are accessible ;)
09:12:11 <mikee> Heh. OK. They should be as I've been using the same key to access svn for years.
09:15:45 <mikee> Worked OK this time, thanks. Now I just have to transfer my branches over and I can start hacking again.
09:15:52 <warlord> Awesome.
09:15:56 <warlord> I just responded to your email, too
09:16:09 <mikee> Apologies for disturbing you so early on a Sunday.
09:17:37 <warlord> It's okay, I was up and looking. Otherwise you wouldn't have had a reply ;)
09:17:50 <warlord> Just be happy I opened my laptop :-D
09:18:18 <mikee> :)
09:19:47 <mikee> I need to get out more.
09:22:05 <warlord> LOL
09:22:26 <warlord> I get to stay home (watching the kid) so the wife can go out.
09:24:27 *** Jimraeh1 has quit IRC
09:48:19 *** fell has joined #gnucash
09:48:19 *** gncbot sets mode: +o fell
10:11:14 *** kpreid has quit IRC
10:12:13 *** kpreid has joined #gnucash
10:17:22 *** fabior has quit IRC
11:33:07 *** calbasi has left #gnucash
11:44:32 *** aqua___ has joined #gnucash
12:01:39 <GiftdKook> I have two registers, one for a credit card and one for a bank account. Both have a entry for a payment that zeros out the outstanding balance for expenses and diminishes the checking account's balance. I am able to reconcile the transactions in the credit card register /except/ for the payment. Likewise, the payment won't reconcile in the register for the bank account. What could I be doing wrong?
12:19:21 *** aqua___ has quit IRC
12:21:18 *** Jimraeh1 has joined #gnucash
12:21:58 <kpreid> GiftdKook: What do you mean by "won't reconcile"? What stops you?
12:23:00 <GiftdKook> The program will not reconcile the register after I use the reconcile function, so gnucash is stopping me.
12:23:11 <GiftdKook> i.e. the c's won't turn into y's.
12:23:52 *** lost_soul has joined #gnucash
12:24:00 <kpreid> Reconcile has multiple steps: you start it, enter a balance, check off transactions, and finish the reconciliation. Where in that process is the problem?
12:24:38 <warlord> GiftdKook: are you entering in the correct ending balance from your statement? What happens when you check off all the appropriate transactions?
12:25:13 <GiftdKook> The n's turn to c's.
12:25:18 <kpreid> Oh, I see what the problem might be. The _statement's balance_ does _not_ include the payment, since you didn't make it when the statement was written.
12:25:20 <GiftdKook> The ending balance is indeed correct.
12:25:40 <kpreid> So, you should _not_ be including this month's payment in this reconciliation. but _next_ month's. Am I making sense?
12:25:50 <GiftdKook> I don't understand.
12:25:58 <GiftdKook> I have /one/ transaction that is the problem.
12:26:05 <GiftdKook> The payment of the credit card.
12:26:14 <GiftdKook> Every other transaction has reconciled fine.
12:26:44 <GiftdKook> Neither the CC's nor the bank's register will reconcile.
12:27:13 <kpreid> To reconcile, the balance of reconciled transactions must match the balance on the statement. Your payment isn't on your statement yet!
12:28:11 <GiftdKook> but, it is.
12:28:15 <GiftdKook> I just entered it.
12:28:33 <kpreid> I mean the statement from your CC company.
12:28:40 <GiftdKook> ahm
12:28:48 <kpreid> When you started the reconciliation, you entered the balance from that statement, yes?
12:28:50 <GiftdKook> The payment has been made by the bank.
12:28:51 <GiftdKook> yeah
12:29:12 <kpreid> So, that _balance_ on the CC's statement does not _include the effect of the payment_.
12:29:15 <GiftdKook> Regardless, this entry appears darned simple.
12:29:18 <kpreid> Therefore, it is not to be reconciled.
12:29:56 <GiftdKook> Regardless of whether it should or should not be reconciled, I can't reconcile it.
12:29:57 <kpreid> It is proper that it be in 'C' state but not 'Y' state, until you get your _next_ statement which should include a 'Payment' line for this one.
12:30:42 <GiftdKook> fine. but the person whom I am supporting confirmed with the CC that the payment was received. They want to reconcile now.
12:30:45 <GiftdKook> and they can't.
12:30:54 <GiftdKook> So, I am trying to figure this out for them
12:31:01 <warlord> GiftdKook: is the payment on the piece of paper your CC sent you at the end of the month?
12:31:10 <warlord> If not, then you shouldn't reconcile it.
12:31:16 <GiftdKook> Fine.
12:31:18 <GiftdKook> But
12:31:27 <GiftdKook> I won't be able to do so when the paper comes in.
12:31:29 <kpreid> Then what they should do is go to their CC's web site and look at the 'current balance' and 'current transactions', and enter that info in the reconcile instead of the statement.
12:31:32 <warlord> Similarly, on the bank side, is the payment to the CC on the statement from the bank they send you at the end of the month? Again, if not, then don't reconcile it.
12:31:33 <GiftdKook> The program won't let me.
12:31:41 <warlord> Sure it will..
12:31:44 <GiftdKook> yes. it /is/ on the bank statement.
12:31:47 <GiftdKook> No. It won't.
12:31:49 <GiftdKook> I have tried.
12:31:53 <warlord> Then you're doing it wrong.
12:31:56 <warlord> What happens when you try.
12:32:00 <GiftdKook> yes. Hence, my question.
12:32:02 <warlord> You're in the bank account.
12:32:05 <GiftdKook> yeah
12:32:09 <warlord> You click on..??
12:32:17 <warlord> Let's walk through this one step at a time.
12:32:28 <GiftdKook> I have the transaction. It has a C for the bank pmt -- and the CC pmt too.
12:32:35 <GiftdKook> I click on reconcile.
12:32:38 <warlord> That's irrelevant
12:32:44 <GiftdKook> that = ?
12:32:48 <warlord> (the 'c' is irrelevant)
12:33:00 <warlord> okay, you click on reconcile. It pops up a dialog. Now what do you do?
12:33:02 <GiftdKook> oh? You can reconcile a transaction with n.
12:33:06 <warlord> Of course!
12:33:17 <kpreid> Yes, you just have to click the entry in the reconcile dialog instead of it being checked by default.
12:33:21 <GiftdKook> I see the transaction. I see /no/ checkmark next to it.
12:33:33 <warlord> All the 'c' does is pre-check the transaction during reconcile if the txn date is before the reconcile date.
12:33:36 <warlord> Okay...
12:33:42 <GiftdKook> I click finish. The transaction does not reconcile.
12:34:09 <warlord> a) it shouldn't let you click finish if you entered the correct ending balance.
12:34:19 <GiftdKook> hmm?
12:34:27 <GiftdKook> I did not enter an ending balance.
12:34:34 <GiftdKook> The program calculated it for me.
12:34:48 <warlord> well, that's your first problem. You MUST enter the CORRECT ending balance from your bank statement
12:34:58 <GiftdKook> ahm. Where and how?
12:35:06 <warlord> b) click on the transaction during reconcile to mark it reconciled.
12:35:13 <GiftdKook> I just want a single transaction.
12:35:16 <warlord> Why?
12:35:17 <GiftdKook> ok. hang on.
12:35:23 <warlord> That's not what reconciling is for.
12:35:27 <GiftdKook> This is what the customer wants.
12:35:33 <warlord> Reconciling is to make sure your accounts match the bank's statement
12:36:00 <warlord> What reconcile date are you choosing? And what's the date of the payment?
12:36:02 <GiftdKook> In this case, reconciling is simply the demand placed upon the customer by their client.
12:36:08 <GiftdKook> 17th
12:36:15 <GiftdKook> I am not choosing a reconcile date.
12:36:28 <GiftdKook> 17 Jan
12:36:32 <warlord> okay, you've got a couple issues. Here they are:
12:36:45 <warlord> 1) You're not properly choosing the reconcile date and amount. You need to do that.
12:36:57 <warlord> 2) You're not checking off the transaction in the reconcile window. You need to do that, too.
12:37:01 <GiftdKook> How does one choose a reconcile date? amount?
12:37:05 <GiftdKook> let me see about 2.
12:37:15 <warlord> GiftdKook: you do it from the bank statement!
12:37:18 <GiftdKook> There is only one transaction. This account is pretty simple. :)
12:37:23 <GiftdKook> warlord, I am there!
12:37:27 <GiftdKook> hang on.
12:37:35 <kpreid> When you receive a CC/bank statement, it has a statement-date and a balance-as-of-that-date. You put in exactly those numbers.
12:37:53 <warlord> (and yes, gnucash does go out of its way to prevent reconciling in the future)
12:38:46 <GiftdKook> well
12:38:54 <GiftdKook> This entire exercise was pointless.
12:39:03 <GiftdKook> The client is extremely hard to work with.
12:39:10 <warlord> During reconcile gnucash wont let you "finish" if the transactions don't match your entered ending balance.
12:39:31 <GiftdKook> All sorts of actions happen, and I have no idea what has been done. Reconcile works fine now.
12:39:32 <warlord> LOL. Yeah, that happens. You can always charge them more to make them "go away" ;)
12:39:46 <GiftdKook> I shout at this person. A lot. :/
12:39:58 <warlord> Is this client related to you?
12:40:03 <GiftdKook> lol
12:40:08 <GiftdKook> I'll let you guess. :)
12:40:30 <warlord> LOL
12:40:56 <GiftdKook> The pay is terrible -- but I can't beat job security!
12:41:01 <warlord> hahahaha
12:41:08 <GiftdKook> Anyhow, thx.
12:41:29 <warlord> glad you got it working.
12:42:57 <GiftdKook> :)
12:43:39 <warlord> but fyi, yes, you can reconcile transactions from 'n' state. Just click them in the list during the reconcile process.
12:45:37 <GiftdKook> Good to know.
12:47:30 *** ErKa has joined #gnucash
12:58:36 *** LiamH has joined #gnucash
12:59:33 <LiamH> How do I reconcile a stock split? It's coming out imbalanced.
12:59:55 <LiamH> I used the stock split assistant for a share conversion.
13:02:44 *** aqua___ has joined #gnucash
13:15:43 <warlord> What do you mean?
13:20:58 <LiamH> The account won't balance; the share price increased with the new shares, so I have fewer shares. Thus I have a negative number of shares "transacted". This shows up on the reconcile window as a positive number on both the "Funds in" and "Funds out" side.
13:23:49 <LiamH> If I don't check the entry on the "Funds in", it balances.
13:25:23 <LiamH> I think I see why this happens: the assistant made the partner account the same account.
13:29:00 *** aqua___ has quit IRC
13:32:01 *** aqua___ has joined #gnucash
13:51:44 *** nomeata has joined #gnucash
14:04:08 *** aqua___ has quit IRC
14:30:01 *** Jimraeh1 has quit IRC
14:30:28 *** ErKa has quit IRC
14:56:07 *** benoitg has joined #gnucash
15:12:20 *** fabior has joined #gnucash
15:14:32 *** lost_soul has quit IRC
15:32:24 *** nomeata has quit IRC
15:33:18 *** arnotixe has quit IRC
16:00:17 *** aqua___ has joined #gnucash
16:26:40 *** fabior has quit IRC
17:48:48 *** Jimraeh1 has joined #gnucash
17:58:31 *** arrainey has joined #gnucash
18:13:43 *** arrainey has quit IRC
18:14:26 *** arrainey has joined #gnucash
18:24:30 *** arrainey has quit IRC
18:25:11 *** arrainey has joined #gnucash
18:30:21 *** aqua___ has quit IRC
18:37:32 *** arrainey has quit IRC
18:38:18 *** arrainey has joined #gnucash
18:53:32 *** arrainey has quit IRC
18:54:15 *** arrainey has joined #gnucash
18:59:18 *** arrainey has quit IRC
18:59:54 *** arrainey has joined #gnucash
19:09:44 *** fell has quit IRC
19:14:58 *** arrainey has quit IRC
19:51:55 *** arrainey has joined #gnucash
19:57:00 *** arrainey has quit IRC
19:57:37 *** arrainey has joined #gnucash
20:02:40 *** arrainey has quit IRC
20:03:13 *** arrainey has joined #gnucash
20:06:24 *** LiamH has quit IRC
20:08:51 *** john has joined #gnucash
20:08:52 *** gncbot sets mode: +o john
20:28:26 *** arrainey has quit IRC
20:29:01 *** arrainey has joined #gnucash
20:41:35 *** arrainey has quit IRC
20:43:24 *** rpg_ has joined #gnucash
20:50:27 *** benoitg has quit IRC
21:11:26 *** arnotixe has joined #gnucash
21:33:18 *** nafg has joined #gnucash
21:41:26 *** LiamH has joined #gnucash
21:48:17 *** john has quit IRC
21:53:28 *** arnotixe has quit IRC
22:08:28 *** LiamH has left #gnucash
22:29:53 *** rpg_ has quit IRC
22:50:49 *** arrainey has joined #gnucash
23:00:55 *** arrainey has quit IRC
23:01:28 *** arrainey has joined #gnucash
23:03:22 *** pkfg has joined #gnucash
23:05:49 *** nafg has quit IRC
23:05:53 <pkfg> Does anybody know the relationship on postgresql between customers, invoices, and accounts?
23:07:49 *** arnotixe has joined #gnucash
23:16:34 *** arrainey has quit IRC
23:17:22 *** arrainey has joined #gnucash
23:20:33 *** pkfg has quit IRC
23:28:04 *** arrainey has quit IRC
23:28:37 *** arrainey has joined #gnucash
23:29:45 *** ErKa has joined #gnucash
23:53:55 *** arrainey has quit IRC
23:54:31 *** arrainey has joined #gnucash
23:59:37 *** arrainey has quit IRC