2010-04-09 GnuCash IRC logs
00:53:20 *** jpetersen has joined #gnucash
01:36:46 *** jpetersen has quit IRC
02:01:49 *** WaterDragon has joined #gnucash
02:14:29 *** trucklover has joined #gnucash
02:55:48 *** le0 has joined #gnucash
02:56:29 *** le0 has left #gnucash
03:01:49 *** gour has joined #gnucash
03:29:03 *** Swind has quit IRC
04:02:21 *** Swind has joined #gnucash
04:03:19 *** trucklover has quit IRC
04:17:32 *** timfrost has joined #gnucash
04:31:47 *** e-ndy has joined #gnucash
04:58:53 *** albin has joined #gnucash
05:52:56 <albin> Hello. Some of my friends are using GnuCash for various associations, and I heard them comment that the swedish translation was somewhat suboptimal, so I decided to try to fix it up a bit for the next stable release. Is there anything I should know that is't in the translation guide on the wiki?
06:39:22 *** fDavid has joined #gnucash
06:40:52 *** daedeloth has joined #gnucash
07:12:46 *** AlexStacey has joined #gnucash
07:22:07 <AlexStacey> Hi, I've got a few different income accounts set up and I'm now trying to work out how to account for VAT. What I'd like to do is to have 17.5% of the values in 2 of the income accounts automatically entered in a "VAT Man" (A/Payable or Liability - not quite sure which) account and then have our quarterly VAT payment zero that amount.
07:22:58 <AlexStacey> Am I on the right path with this thinking? Can I set up the tax thing to work in this way?
07:26:40 <kimmo> well, it's a liability, and you really should get the amount from the invoice you send
07:28:19 *** Jimraehl has left #gnucash
07:30:28 <AlexStacey> kimmo: ok, thanks. we use a method of VAt accounting called "cash accounting" which means we pay VAT only on payments received, not on all invoices sent, so I think it would make sense to calculate it from the payments rather than the invoices.
07:33:37 *** bentob0x has joined #gnucash
07:37:24 *** frozenjim has joined #gnucash
07:37:35 <AlexStacey> I have found the "tax tables" thing but I'm not sure if I can use it in the way I'd like to or if it's just for invoices.
07:38:18 *** Jimraehl has joined #gnucash
07:43:46 *** frozenjim has left #gnucash
07:50:21 *** frozenjim_ has joined #gnucash
07:53:52 *** frozenjim has joined #gnucash
07:57:44 *** frozenjim_ has quit IRC
07:57:45 *** frozenjim has left #gnucash
07:58:00 *** e-ndy has quit IRC
07:58:56 *** frozenjim has joined #gnucash
08:07:30 <AlexStacey> It seems the tax tables are to do with invoices (which I'm not using inside gnucash as we have an existing invoice system). I'm now thinking my best option is having separate entries for the VAT part of payments. The only downside is the amount of work involved in changing the existing payments. =/
08:36:26 <AlexStacey> Sorry for all the questions but I'm still trying to work out the best way to do this. As an example: I have a £117.50 payment going from and income account "Sales" to a bank account "Current Account". I would like to record the fact that £17.50 of that amount is a VAT liability. If I put a new line into the split transaction for that entry for £17.50 into a liability account "VAT Owed" then I end up with an imbalance as there is no dual ent
08:41:08 <frozenjim> Hey AlexStacey, it could be that everyone is still asleep in the U.S. I think most of the developers are still asleep(?)
08:42:18 <AlexStacey> frozenjim: ah, yes good point. perhaps i'll try again in a few hours. thanks =]
08:49:33 *** albin has quit IRC
09:17:36 *** message144 has joined #gnucash
10:01:09 *** gour has quit IRC
10:04:37 *** gour has joined #gnucash
10:14:54 *** WaterDragon has quit IRC
10:15:38 *** WaterDragon has joined #gnucash
10:18:44 *** ErKa has joined #gnucash
10:21:25 *** warlord-afk is now known as warlord
10:22:28 <warlord> AlexStacey: TaxTables are just for Invoices
10:22:51 <warlord> (and yes, most of us keep US hours)
10:23:29 <AlexStacey> warlord: thanks. I figured that after reading some info in a mailing list archive.
10:23:47 <AlexStacey> cool cool. good morning then! =]
10:25:03 <AlexStacey> The last big comment I made above is what I'm trying to figure out.
10:27:05 *** message144 has quit IRC
10:30:43 <warlord> AlexStacey: in general VAT reduces the "income". So let's say you get $100, but $12 of that is tax.. That would mean a split: $100 Debit Cash; $12 Cr VAT Collected; $88 Cr Income
10:31:37 *** jpetersen has joined #gnucash
10:35:31 <AlexStacey> warlord: OK. That make sense but the problem is that my Income account would then say $88, even though it actually has $100 in it.
10:35:53 <warlord> But technically only 88 of that 100 is income. the other 12 is tax!
10:40:53 <AlexStacey> Ok, fair enough. I've got bank accounts set up to mirror actual bank/card processing/paypal accounts and it's nice to be able to double check the balances so I don't really want to do it like that.
10:42:09 <AlexStacey> I can just work VAT out manually each month so it's not really a big deal.
10:44:22 <warlord> Well, your other option would be to split it out into a subaccount of Cash
10:58:47 <AlexStacey> warlord: thank you. i'll look more into that.
11:13:11 <warlord> ok
11:21:09 *** jpetersen has quit IRC
11:29:18 *** frozenjim1 has joined #gnucash
11:35:33 *** frozenjim has quit IRC
11:36:01 *** jpetersen has joined #gnucash
11:47:41 *** AlexStacey has left #gnucash
11:53:28 *** julien has joined #gnucash
11:54:44 <julien> Greetings all ! I was wondering if there was a way with gnucash to close books AND to have an expense histogram spanning over multiple accounting periods ?
11:54:59 <warlord> Nope
11:55:09 <warlord> One or the other. Not both.
11:55:24 <julien> ok. Too bad. But at least I've got a quick and clear answer :)
11:55:40 <julien> I'll manage two files then. Thanks for your reply.
11:56:13 <warlord> Two files wont give you a multi-year histogram either
11:57:02 <julien> err... Well : one file where I close the books and one file where I do not close them (And I'll just transfer batches of transaction every so often)
11:57:46 *** raleightile has joined #gnucash
11:58:01 <warlord> Ummm... and how do you propose to do that? GnuCash doesn't have a "merge files" feature.
11:59:49 <julien> Hmm... Good question... I though I could export all transactions for a given period and re-import them... But I do not find this feature any more ... Maybe I saw it when trying 2.4.x ?
11:59:57 <warlord> Honestly, the only thing closing the books does for you is lets the CoA show the current balance for the period.
12:00:34 <warlord> There is no real "export"..
12:00:54 <warlord> There "was" a "QSF Export", but there was never a QSF Import..
12:01:38 <julien> Hmm... I guess I can work with an unclosed file then, and simply close it in the past, and save under a new file when I want to see my year-to-date :)
12:03:20 <warlord> For year-to-date just run a P&L report
12:03:57 <julien> True... That's an other (probably simpler) way ...
12:04:12 *** bentob0x has quit IRC
12:04:13 <warlord> * nods *
12:04:25 <warlord> It's not like closing the books makes transactions readonly
12:07:12 <julien> Yes, I saw it was "only" a generic split transaction (without added magic I mean)
12:09:24 <warlord> Right
12:09:51 *** raleightile has quit IRC
12:10:46 *** raleightile has joined #gnucash
12:31:34 *** jpetersen has quit IRC
12:35:19 *** julien has left #gnucash
12:48:13 *** raleightile has quit IRC
12:59:28 *** gncbot` has joined #gnucash
13:02:24 *** gncbot has quit IRC
13:12:57 *** warlord sets mode: +o gncbot`
13:13:02 <warlord> @nick gncbot
13:13:03 *** gncbot` is now known as gncbot
13:36:45 *** Rafael has joined #gnucash
13:37:02 *** Rafael has left #gnucash
13:55:42 *** DGMurdockIII has joined #gnucash
13:55:47 <DGMurdockIII> hi
13:56:28 <DGMurdockIII> will gnucash allow me to link it with my bank account
13:58:23 <warlord> Maybe. Depends what protocols your bank speaks.
14:00:19 <DGMurdockIII> how can i tell what one they use
14:01:03 <warlord> I dont know. Ask them?
14:05:40 <DGMurdockIII> they use a id and password
14:05:53 <DGMurdockIII> that not what you want to know
14:05:55 <DGMurdockIII> right
14:06:24 *** jpetersen has joined #gnucash
14:07:03 <warlord> right
14:07:12 <warlord> are you in the US?
14:07:28 <warlord> Basically, there are two online protocols we support: HBCI (in Germany) and OFX.
14:10:35 <DGMurdockIII> yes
14:10:38 <DGMurdockIII> us
14:10:52 <warlord> Then your bank potentially supports OFX.
14:10:59 <warlord> You can check the WIKI for more info
14:13:58 *** ErKa has quit IRC
14:25:05 *** jpetersen has quit IRC
14:27:29 *** cortana has joined #gnucash
14:34:12 *** jpetersen has joined #gnucash
14:35:12 *** DGMurdockIII has quit IRC
15:05:35 *** Zoolooc_ has joined #gnucash
15:07:01 *** fDavid has quit IRC
15:14:15 *** gour has quit IRC
15:32:29 *** jpetersen has quit IRC
15:47:52 *** Suger has joined #gnucash
15:48:21 *** Suger has left #gnucash
15:57:05 *** cortana has quit IRC
16:07:16 *** cortana has joined #gnucash
16:20:56 *** sjc has joined #gnucash
17:01:01 *** warlord is now known as warlord-afk
18:28:42 *** frozenjim has joined #gnucash
18:36:22 *** frozenjim1 has quit IRC
18:49:42 *** fell has joined #gnucash
19:31:52 *** fell_ has joined #gnucash
19:40:27 *** fell has quit IRC
19:52:54 *** Zoolooc_ has quit IRC
20:08:24 *** ErKa has joined #gnucash
20:12:59 *** sjc has quit IRC
20:30:33 *** daedeloth has quit IRC
21:14:53 *** ErKa has quit IRC
22:23:48 *** cortana has quit IRC
23:09:01 <intangir> is there any docs that explain any good ascii formats i can copy myself? for doing a bulk import? my bank gives csv file only
23:39:46 <fell_> intangir: search the mailing list for calc2qif.
23:40:23 <fell_> ms excel and ooo calc can import csv
23:41:23 <fell_> and the macro xl2qif/calc2qif can create a qif file
23:41:39 <fell_> and gnucash can import qif.
23:44:41 *** me has joined #gnucash
23:45:05 <me> hi
23:46:08 <me> i want to be able to save a file with all the reports.... then open another file..do something.. and when I reopen my old file to get all the reports with the way they are setup ...
23:46:11 <me> how can I do that
23:50:28 <jsled> me: don't close them?
23:51:42 <me> thanx
23:55:16 <me> ok... is there a way to say Close of my current workplace (and still have it later) when I open it.
23:55:16 <me> I.e. instead of Opening new file...
23:55:52 <me> to exit the current
23:55:54 <jsled> so … the way it's supposed to work is all open tabs are associated with the file. So if you exit or close the file and open it later, all the tabs should return.
23:56:04 <jsled> Either accounts register tabs or reports or whatever.