2010-04-02 GnuCash IRC logs

00:17:21 *** abhinav has quit IRC
01:19:13 *** Rafael has quit IRC
01:32:23 *** buthus has joined #gnucash
01:34:38 <buthus> Hi there. Does anybody know how to enable a Commonwealth Bank Netbank Account (Australia) in GnuCash? I can't find any informations about it on the Internet, in the Wiki nor on the Mailing List?
02:07:30 *** gour has joined #gnucash
02:15:14 *** Zoolooc has joined #gnucash
03:25:29 *** buthus has quit IRC
03:40:03 *** ErKa has joined #gnucash
04:06:35 *** daedeloth has joined #gnucash
05:44:01 *** bentob0x has joined #gnucash
06:09:30 *** hvx has joined #gnucash
06:18:00 *** hvx has quit IRC
06:53:18 *** cortana has joined #gnucash
07:35:52 *** hvx has joined #gnucash
07:47:10 *** Rafael has joined #gnucash
07:48:02 *** Rafael has left #gnucash
07:58:05 *** ErKa has quit IRC
08:07:14 *** giles_ has joined #gnucash
08:12:43 *** Jimraehl has left #gnucash
08:20:48 <giles_> Advanced Portfolio is reporting income as negative: anybody know why?
08:21:24 *** Jimraehl has joined #gnucash
08:23:20 *** ErKa has joined #gnucash
08:34:56 *** ErKa has quit IRC
08:37:26 *** KaiForce has joined #gnucash
09:56:56 *** cortana has quit IRC
09:59:23 *** twig11 has joined #gnucash
10:05:23 *** cortana has joined #gnucash
10:05:54 <twig11> Why is Gnucash coming up with an extra penny of sales tax on my invoices? As an example, I just made a sale worth $2,555. The tax table I applied for sales tax includes 4.5% state tax, 1.3% county tax, and 3% city tax, for a total of 8.8%. That should come out to $224.84, yet Gnucash shows $224.85. What's going on?
10:18:11 *** ErKa has joined #gnucash
10:32:15 <gour> twig11: $0.01 for open-source projects :-)
10:35:43 <twig11> So that's the catch! :-/
10:37:42 <twig11> Actually I think I located the issue. It's figuring each percentage separately, and the extra penny comes from rounding up the 4.5% portion. I still need to figure out if I can make it calculate the same way my dealer does.
10:53:11 *** ErKa has quit IRC
11:08:30 *** giles_ has quit IRC
11:21:55 <twig11> Okay, here's what's happening: When GnuCash figures the tax, it rounds each individual entry in the tax table to the nearest cent. In this case, 4.5% equals $114.975, so Gnucash rounds it to $114.98. 1.3% equals 33.215, so Gnucash rounds to 33.22. And there's the extra cent. But my state rounds off the total tax, not the individual percentages, and 8.8% comes out to an even $224.84. How can I make Gnucash work the same way?
12:07:48 *** daedeloth has quit IRC
12:18:29 *** bentob0x has quit IRC
12:20:03 *** johannes has joined #gnucash
12:56:16 *** twig11 has quit IRC
13:02:03 *** twig11 has joined #gnucash
13:17:52 *** twig11 has quit IRC
13:21:02 *** twig11 has joined #gnucash
13:29:31 <warlord-slow> twig11: dont break the tax into subparts?
13:34:12 *** KaiForce has quit IRC
13:43:31 *** bentob0x has joined #gnucash
13:46:09 *** ErKa has joined #gnucash
13:56:32 *** Zoolooc__ has joined #gnucash
14:05:43 *** Zoolooc has quit IRC
14:06:44 *** twig11 has quit IRC
14:36:17 *** lol_h has joined #gnucash
14:40:55 *** johannes has quit IRC
14:42:19 *** bentob0x has quit IRC
14:46:44 *** sixstringer has joined #gnucash
14:48:35 <sixstringer> Hi. I am trying to set up multiple currencies. When I click "Get Quotes" button, I receive error message "No commodities marked for quote retrieval."
14:53:02 *** jpetersen has joined #gnucash
14:53:47 <sixstringer> Hi. I am trying to set up multiple currencies. When I click "Get Quotes" button, I receive error message "No commodities marked for quote retrieval."
14:55:18 <jsled> sixstringer: hi. we saw it the first time. :) latency in here can be on the order of hours, so please feel free to hang out as long as you can.
14:56:37 <sixstringer> oh ok
15:13:52 *** cortana has quit IRC
15:25:15 *** cortana has joined #gnucash
16:00:50 *** twig11 has joined #gnucash
16:02:14 *** tedcx3 has joined #gnucash
16:11:13 *** mt3ch has joined #gnucash
16:13:52 <tedcx3> I have an account with a starting balance of $2390.50 and it should be at the opening balance of $0.00. Any suggestions?
16:15:11 <jsled> tedcx3: rephrase?
16:15:58 <warlord-slow> tedcx3: maybe you're hiding some transactions?
16:16:07 <jsled> or explain more about which is reality and which is gnucash? :)
16:19:19 <tedcx3> I.e. if I reconcile the first month on this account in gnucash the starting balance in the "RECONCILE INFORMATION" POPUP should be $0 and its not.
16:19:29 <tedcx3> How do I unhide?
16:21:55 <warlord-slow> have you ever reconciled that account?
16:22:04 <tedcx3> yes
16:22:30 <warlord-slow> reconciliation is always from the start of time. So you cannot reconcile at Feb 1 and then reconcile at Jan 1.
16:23:27 <warlord-slow> i.e., you cannot go back in time.
16:25:00 *** mt3ch has quit IRC
16:25:10 <tedcx3> That's bad, but understandable. I have to go back due to the need to track some invvestments over multi years. Perhaps I should export the account and reimport it?
16:26:40 <warlord-slow> It's fine to track over years, but you cannot start reconciling until you have the earliest txns in place.
16:27:38 <tedcx3> Yes, but that wasn't the case, I added previous years to a reconciled account.
16:33:35 <twig11> Is there a way to make GnuCash handle tax tables for sales tax the same way my state government does, i.e. not rounding to the nearest cent on each entry individually but rather adding State, County, and City taxes together and then rounding the total to the nearest cent?
16:36:30 <warlord-slow> tedcx3: yeah, don't do that. Once you start accounting from T0 don't change T0;.
16:36:47 <warlord-slow> twig11: as I said earlier, don't split the taxes.
16:38:56 <twig11> warlord-slow: I need them split for my records. Is there another way to collect the totals for each jurisdiction?
16:39:36 <warlord-slow> nope. either you split them and they round, or you dont split them.
16:40:06 <warlord-slow> Sorry, there is only 1 algorithm.. If your jurisdiction is computing it as the sum of taxes then who gets the partial cents?
16:52:01 *** jpetersen has quit IRC
16:55:31 *** warlord-slow has quit IRC
17:00:01 *** gour has quit IRC
17:01:19 *** tedcx3 has left #gnucash
17:18:10 *** WaterDragon has joined #gnucash
17:18:55 *** ErKa has quit IRC
17:20:21 <WaterDragon> Hey all. I am trying to program a new report but am relatively new to scheme and gnucash.
17:32:28 *** warlord has joined #gnucash
17:32:28 *** gncbot sets mode: +o warlord
17:32:44 <WaterDragon> I want to use the data I have in GNUCash to figure out how much money my partner and I each spent on joint expenses.
17:33:19 *** warlord is now known as warlord-slow
17:40:26 <WaterDragon> So I have figured out how to query for the splits I want but am having trouble understanding the structure of the split itself.
17:40:53 <WaterDragon> I understand xaccSplitGetOtherAccount now but that only works for 2 entry splits.
17:41:02 <WaterDragon> I have some splits that go 3 or even 4 ways.
17:41:07 <WaterDragon> How do I walk those splits?
17:53:24 <warlord-slow> xaccTransGetSplits() and look at each one?
18:04:10 <WaterDragon> Thanks. That looks like what I need.
18:04:35 <WaterDragon> Though looking at the transaction report I think I am better of just changing how I query for the splits in the first place.
18:05:01 <warlord-slow> that could be
18:05:09 <WaterDragon> If I reverse the sense of the transactions I think I get the "primary" split to be the one that I really want.
18:05:28 <WaterDragon> Which should be easier to handle than trying to walk the other splits and figure out if it is in the list of accounts I want.
18:06:00 <WaterDragon> Looks like I need to start all over again though. *sigh* learning curve == painful.
18:10:10 <warlord-slow> sorry
18:10:25 <WaterDragon> That is the nature of working with a new system. :)
18:10:34 <WaterDragon> Thanks for all the code though. Love GnuCash!
18:14:10 <warlord-slow> you're welcome
18:14:13 *** warlord-slow is now known as warlord-afk
18:16:58 *** warlord-afk has quit IRC
18:20:59 <WaterDragon> If I get a report that works I will be sure to add it to this page: http://wiki.gnucash.org/wiki/Custom_Reports_Using_Eguile
18:28:39 *** hvx has quit IRC
18:30:06 *** Askarii has joined #gnucash
18:30:09 <Askarii> ahhh
18:30:11 <Askarii> at last
18:30:25 <Askarii> anyone willing to share their wise gnucash wisdom?
18:30:32 <Askarii> I need some help :(
18:31:12 <Askarii> and now I wait
18:35:41 <jsled> Wait *after* you actually ask a question, not before. :)
18:37:09 <Askarii> okay
18:37:23 <Askarii> In quebec canada we have to apply two cumulative taxes
18:37:35 <Askarii> and the current invoice system doesn't seem to support it
18:37:57 <Askarii> the only thing I can do is charge both taxes as "one big tax" but I need to account for both in different accounts, and this "solution" only complicates things.
18:38:12 <Askarii> I need to know if I can put TWO taxes on an invoice (same item)
18:38:20 <Askarii> thx jsled ;)
18:41:22 *** jeremy has joined #gnucash
18:46:12 <Askarii> ...
19:00:42 *** twig11 has left #gnucash
19:03:20 <Askarii> a yes or no would be appreciated
19:07:02 <jsled> Askarii: the latency here can be on the order of hours normally, and this is a friday night entering a holiday weekend … if someone sees your question and knows the answer, they will.
19:07:44 <Askarii> alright, should I re-post once in a while? (say every 2-3 hours?
19:08:38 <jsled> usually the primary question answerers are persistenly connected, but if you like I suppose you can.
19:08:57 <jsled> I'm not sure if this is in the FAQ or not, either.
19:14:29 <Askarii> I went through the faq
19:14:34 <Askarii> didn't find anything
19:17:53 *** warlord has joined #gnucash
19:17:53 *** gncbot sets mode: +o warlord
19:18:06 *** warlord is now known as warlord-afk
19:21:02 *** lol_h has quit IRC
19:21:20 <raleightile> is it ok to create an invoice for a customer, and for the line item instead of Income:Sales change to Assets:Checkbook?
19:22:15 <raleightile> this would 1.) remove a negative balance from the customers account, and 2.) reduce that checking account by the same amount as the refund.
19:23:39 <raleightile> Likewise receiving merchandise would be like receiving money, but go into Assets:Inventory instead of Assets:Checkbook
19:24:11 <raleightile> Would this cause any unexpected side effects?
19:26:26 <raleightile> Askarii:http://lists.gnucash.org/logs/2007/05/2007-05-01.html
19:29:28 *** cortana has quit IRC
19:35:47 *** fDavid has joined #gnucash
19:35:52 <raleightile> Askarii:http://lists.gnucash.org/pipermail/gnucash-user/2009-December/032604.html
19:36:56 <raleightile> http://lists.gnucash.org/pipermail/gnucash-user/2009-December/032626.html
19:38:40 <raleightile> Maybe it would be great to make a wiki page for your area, a common question..
19:41:11 *** fDavid has quit IRC
19:41:58 *** fDavid has joined #gnucash
20:09:40 *** fDavid has quit IRC
20:10:40 *** mishehu has quit IRC
20:10:57 *** mishehu has joined #gnucash
20:15:57 *** mishehu has joined #gnucash
20:19:34 <Askarii> raleightile
20:19:39 <Askarii> u there?
20:19:47 <raleightile> on and off
20:19:50 <raleightile> but now yes
20:19:55 <Askarii> did someone answer your Q ?
20:20:00 <raleightile> not yet
20:20:10 <raleightile> it's a vacation weekend..
20:20:22 <Askarii> yeh
20:20:23 <Askarii> well
20:20:30 <Askarii> I do quite a bit of accounting
20:20:35 <Askarii> and from an accounting principal
20:21:00 <Askarii> you send the "sales" tot he sales book to track your sales (how much you sold and so forth)
20:21:25 <Askarii> Once you receive payment you credit the client account (or receivables) and debit your checkings
20:21:43 <raleightile> yes
20:21:51 <Askarii> thus removing the negative from the clients (since its paid) adding the cash to your checking (since you got paid) and sales still tell you how much you sold so far
20:22:11 <Askarii> I don't know if this answer your Q
20:22:38 <raleightile> that is the start of my problem,
20:22:46 <Askarii> explain
20:22:56 <Askarii> while I read your links :P
20:23:01 <raleightile> when they change their mind and bring something back, then they get a refund
20:23:22 <raleightile> but sales still shows the income, although I don't have any more..
20:24:04 <raleightile> it isn't possible to do negative invoice or bills from the business menu
20:27:12 <Askarii> you want to make in invoice for refunds??
20:28:29 <raleightile> well, I want the acounts receivable to reflect the reality
20:28:31 <Askarii> Usually a refund can simply be put as a reverse transaction or often crediting a client account
20:29:14 <Askarii> then debit the accounts receivable and credit the client account?
20:31:01 <raleightile> where is the client account?
20:31:16 <Askarii> I typically make sub-accounts of the accounts receivable
20:31:23 <Askarii> one for each client
20:31:27 <Askarii> so say a client orders a service
20:31:58 <Askarii> I debit de client account, credit the sales account
20:32:14 <Askarii> when I get paiement: I debit the checkings account, credit the client account
20:35:33 <raleightile> interesting
20:36:11 <raleightile> I have a lot of different customers, and they go about 7 years between orders
20:36:25 <raleightile> that might make a lot of subaccounts
20:38:07 <Askarii> true, but it sorts everything out oh so very well
20:38:33 <Askarii> you don't get the advanatage of setting the account to "inactive" like with invoices, thats the major drawback in your case
20:51:48 <Askarii> I love you raleightile
20:51:54 <Askarii> one of your links saved me :D
20:52:08 <Askarii> with an additional modification, but that wasn't too hard to find :)
20:52:10 <Askarii> thx again
20:52:21 <raleightile> no problem
20:53:30 *** Askarii has quit IRC
20:58:41 *** Askarii has joined #gnucash
21:02:47 *** fDavid has joined #gnucash
21:04:41 <raleightile> warlord: suggestion for refunds
21:05:34 <raleightile> create new top level account "Refunds" of type "Asset"
21:06:41 <sixstringer> Hi. I am trying to set up multiple currencies. When I click "Get Quotes" button, I receive error message "No commodities marked for quote retrieval."
21:09:46 <Askarii> raleightiule... no solution yet?%
21:10:42 <raleightile> then create invoice, just like you would a real invoice, only use negative quantity, this will give you a negative total for the invoice (you would receive a "you may not post an invoice with a negative total value") you can save an invoice with a zero balance, so on the last line enter quantity 1 and the total amount for the invoice with the account being "Refunds"
21:11:39 <raleightile> also, don't forget to make the last line non-taxable
21:12:17 <raleightile> so far we have reduced income, and the coresponding taxes, the opposite of a sale,
21:14:34 <raleightile> now if they want a refund we can write a check, and use the transfer from "Refunds" this will properly record the cash out, and zero out the "refunds"
21:16:08 *** jeremy has quit IRC
21:16:10 <raleightile> or if they have outstanding bills we could do a biz transaction receive payment, and select the "refund" account, this would show a payment on their a/r account and zero out the refund
21:16:37 *** sixstringer has left #gnucash
21:17:55 <raleightile> or if we want to show as a credit on an invoice, we could add a line "credit memo" for the description and then quantity "1" and then a negative amount to correspond with the return
21:19:16 <raleightile> and select "Refunds" for the Income account on that line, this would reduce the invoice by that amount, which would show when printing, and zero out the return.
21:20:54 <raleightile> The pros are you could do any of the three or even a combination of several, also you could find errors quickley because "Refunds" should always have a zero balance, and when it is off, you could open the register and clearly see who created the problem.
21:21:27 <raleightile> I hope you like this and I hope it works, can you think of any negative side effects?
21:21:55 <raleightile> if you approve, I'll email a summary
21:21:58 <raleightile> Thanks
21:23:46 <raleightile> Askarii: what do you think of my proposed solution?
21:24:59 <Askarii> hmm
21:25:49 <Askarii> have u tried just "reversing" your invoice ?
21:27:46 <raleightile> if it was the whole invoice, then I would just unpost it, but usally it is a combination of items from different invoices, the real problems stem from people not paying for everything at the time of purchase, and taxes, both are a pain to track!
21:28:26 <raleightile> without a/r and taxes you could just write a check and use "Income" as the transfer..
21:29:02 <Askarii> What I don't understand is why you don't just credit your client account (as a refund) for the desired amount, as a split transaction which debits your tax accounts
21:29:07 <Askarii> it seems so much simpler
21:29:17 <Askarii> debit your client acocount *
21:31:58 *** fDavid has quit IRC
21:35:55 <raleightile> customers need to have a print out of their return, itemized to show the what and why, i could do a spread sheet, and then enter the totals, but it would be easier to work in gnucash
21:45:15 <Askarii> good point
22:23:35 *** Zoolooc__ has quit IRC
22:23:45 *** Zoolooc_ has joined #gnucash
22:38:30 *** mishehu has quit IRC
22:39:26 *** mishehu has joined #gnucash
22:41:35 *** mishehu has quit IRC
22:46:40 *** mishehu has joined #gnucash
22:49:28 *** Askarii has quit IRC
23:04:03 *** mishehu has quit IRC
23:10:40 *** mishehu has joined #gnucash