2015-03-22 GnuCash IRC logs
00:12:11 *** ErKa has quit IRC
00:22:46 *** misha_ has quit IRC
00:23:11 *** misha has joined #gnucash
00:33:42 *** misha has quit IRC
00:44:39 *** StuM has quit IRC
01:23:48 *** gncbot sets mode: +o jralls
01:24:11 <jralls> @op mikee
01:24:12 *** gncbot sets mode: +o mikee
02:27:47 *** josePHPagoda1 has quit IRC
03:20:22 *** JoTraGo has joined #gnucash
03:50:00 *** StuM has joined #gnucash
03:51:15 *** MechtiIde has joined #gnucash
04:25:13 *** Krzysiek_K has joined #gnucash
04:49:22 *** misha has joined #gnucash
04:59:16 *** fell has joined #gnucash
04:59:16 *** gncbot sets mode: +o fell
05:25:22 *** cartsoftware has quit IRC
05:56:17 *** GabrieleV_ has joined #gnucash
05:56:29 *** GabrieleV has quit IRC
05:56:29 *** GabrieleV_ is now known as GabrieleV
06:02:19 *** pacon has joined #gnucash
06:31:46 *** GabrieleV_ has joined #gnucash
06:32:17 *** GabrieleV has quit IRC
06:32:18 *** GabrieleV_ is now known as GabrieleV
06:51:21 *** fabior has joined #gnucash
07:18:33 *** pacon has quit IRC
07:20:00 *** pacon has joined #gnucash
08:03:29 *** StuM has quit IRC
08:07:22 *** cartsoftware has joined #gnucash
08:27:26 *** fabior has quit IRC
08:31:57 *** JoTraGo has quit IRC
08:32:30 *** JoTraGo has joined #gnucash
08:48:31 *** StuM has joined #gnucash
08:51:04 *** andy has quit IRC
09:01:52 *** Jimraehl1 has left #gnucash
09:02:15 *** O01eg has joined #gnucash
09:02:20 *** Jimraehl1 has joined #gnucash
09:18:33 *** StuM has quit IRC
09:30:57 *** andy has joined #gnucash
09:42:34 *** pacon has quit IRC
09:46:42 *** misha_ has joined #gnucash
09:52:53 *** misha has quit IRC
10:06:27 <MechtiIde> do anyone know how to define a prepaid card
10:06:57 <MechtiIde> I did it like a giro but then I get negativ Saldo
10:10:02 *** fabior has joined #gnucash
10:37:19 *** GabrieleV_ has joined #gnucash
10:37:21 *** GabrieleV has quit IRC
10:37:22 *** GabrieleV_ is now known as GabrieleV
11:05:34 *** ErKa has joined #gnucash
11:09:07 *** MechtiIde has quit IRC
11:16:57 *** MechtiIde has joined #gnucash
11:20:45 *** aqua___ has joined #gnucash
11:43:20 *** JoTraGo has quit IRC
11:44:00 *** JoTraGo has joined #gnucash
11:56:33 *** JoTraGo has quit IRC
11:57:16 *** JoTraGo has joined #gnucash
12:18:31 *** ErKa has quit IRC
12:23:02 *** JoTraGo has quit IRC
12:27:35 *** JoTraGo has joined #gnucash
12:42:09 *** JoTraGo has quit IRC
12:52:25 *** JoTraGo has joined #gnucash
12:54:55 *** JoTraGo has quit IRC
12:55:54 *** misha has joined #gnucash
12:59:31 *** JoTraGo has joined #gnucash
13:00:06 *** misha_ has quit IRC
13:02:53 <fell> Mechtilde: My view of the Gnucash-accounts: http://wiki.gnucash.org/wiki/De/Referenz#Einordnung_der_in_GnuCash_definierten_Kontentypen
13:03:49 <fell> If you can online ask the saldo, I would treat it as a special Bank account
13:06:20 *** JoTraGo has quit IRC
13:06:42 *** JoTraGo has joined #gnucash
13:12:05 *** O01eg has quit IRC
13:18:41 <MechtiIde> it has IMO a wrong (negativ) Saldo
13:18:53 <MechtiIde> IMO It should be a positiv Saldo
13:22:03 *** O01eg has joined #gnucash
13:24:34 *** JoTraGo has quit IRC
13:24:50 *** vantage has joined #gnucash
13:26:18 <vantage> Hi all, is there an easy way to break out repetitive sales tax on purchases? For example, I have a credit card statement with purchases that include the standard 13% sales tax where I live. Is there a way to just get a checkbox or something to automatically calculate the 13% and split the transaction rather than having to do each one by hand?
13:28:40 *** n1k88 has joined #gnucash
13:36:26 *** JoTraGo has joined #gnucash
13:43:42 <vantage> It's weird that I can do it for invoices with tax tables, but can't seem to do it with expenses...
13:47:00 *** isaacd_ has quit IRC
13:47:05 *** ErKa has joined #gnucash
13:57:38 *** JoTraGo has quit IRC
14:15:42 <fell> vantage: either use the business features or split your transactions by entering expressions:cash -X; Expense X/1,13 Tax: X*13/113
14:15:59 *** warlord has joined #gnucash
14:16:00 *** gncbot sets mode: +o warlord
14:16:29 <vantage> fell: How would you use the business features for importing expenses?
14:16:55 *** cigarshark has joined #gnucash
14:17:00 *** JoTraGo has joined #gnucash
14:17:39 <fell> Firstr create a tax table, then business partners, finally invoices
14:18:14 <vantage> fell: I use that for invoices to clients, but I'm looking at just general business expenses. Here's my workflow.
14:18:15 <fell> push the invoice and process payment
14:19:20 <vantage> fell: 1. I need to get office supplies, 2. put it on corp credit card, 3. download corp card transactions from bank, 4. import them into gnucash and assign to appropriate expense account (e.g. office supplies). Now I need to split them all for sales tax. Right now I have to do each one by hand.
14:19:30 *** JoTraGo has quit IRC
14:19:57 <vantage> fell: What I'd like is something like I do with invoices, which is just X my HST tax table and it's done for me.
14:20:06 <vantage> fell: But I can't seem to do that for expenses
14:20:59 <fell> it is the same, create bill instead of invoice.
14:21:00 <warlord> vantage: you can; the vendor bill. But not via an import
14:21:33 <vantage> warlord: ugh, that's a pain. So I either I have to split the tax by hand or enter the transactions by hand?
14:22:25 <warlord> vantage: yes
14:22:46 <vantage> warlord: am I the only one that finds that silly?
14:23:15 <warlord> probably not ;)
14:23:24 <warlord> patches always welcome :-D
14:24:15 <vantage> warlord: If I had the capability, I totally would :) Is there any workarounds any one uses for this? It seems like a fairly common business workflow.
14:25:57 <warlord> I dont know. I dont use any importer myself; I feel it loses the chance to find bank errors
14:26:06 <fell> I used to enter from cash "€100" to expense "100/1,19" and tax (autofill)
14:26:29 <warlord> I'm not sure if there is a vendor-bill importer
14:29:39 <vantage> warlord: I use the importer, then go through each transaction prior to the final import. Saves me lots of time typing and I can still catch mistakes.
14:30:07 <vantage> fell: Can you explain the 100/1,19 formula? I've never used expressions before
14:30:30 <fell> Just enter it in the register
14:30:51 <fell> my tax rate was 19%
14:30:57 <vantage> fell: So can you break down what "expressions:cash -X; Expense X/1,13 Tax: X*13/113" is?
14:31:07 <warlord> vantage: a vendor importer is not the same as the importer you're using.
14:31:21 <warlord> It would be a CSV-based import to generate a vendor bill.
14:31:26 <vantage> warlord: I figured it wouldn't be.
14:32:00 <warlord> IMHO the issue with the importer is that while it does save a little typing, it makes it much harder to track down bank errors (which DO occur), because you're effectively trusting what the bank tells you
14:33:25 <fell> The gross amount is (netamount+taxrate)=>net amount = gross amount /(1+taxrate)
14:33:30 <vantage> warlord: Really? That hasn't been an issue for me thusfar *knocks on wood*. What small errors have come up, I've managed to catch by simply reviewing the transactions.
14:33:57 *** aqua___ has quit IRC
14:34:03 <warlord> Reviewing them from the receipts? At what point in the process do you do that?
14:35:19 <vantage> warlord: I review credit card transactions against purchases. I look for transactions that I can't account for purchasing.
14:36:46 <warlord> OKay, so if you're taking the time to do that why not enter the transaction while you're doing that work? The quickfill feature makes it easy to enter repetative/frequent transactions.
14:39:47 *** JoTraGo has joined #gnucash
14:42:17 *** JoTraGo has quit IRC
14:42:40 *** JoTraGo has joined #gnucash
14:44:52 <vantage> warlord: The import detection saves a ton of time. For common transactions it already prefills the not only the date, amount, and description, but also the expense account it should go to. I used to do them by hand, this saves me about an hour of work.
14:45:10 *** JoTraGo has quit IRC
14:47:44 <warlord> Okay.
14:48:56 <warlord> I guess for me I spend a few minutes every few days to input txns. The quickfill enters in everything except the amount (well, it will suggest the previous amount). Just start typing the description and then tab to auto-complete
14:49:41 *** fabior has quit IRC
14:55:00 *** JoTraGo has joined #gnucash
14:57:30 *** JoTraGo has quit IRC
15:17:20 *** JoTraGo has joined #gnucash
15:19:50 *** JoTraGo has quit IRC
15:29:52 *** JoTraGo has joined #gnucash
15:32:23 *** JoTraGo has quit IRC
15:42:07 *** JoTraGo has joined #gnucash
15:44:37 *** JoTraGo has quit IRC
15:52:52 *** cigarshark has quit IRC
15:54:07 *** JoTraGo has joined #gnucash
15:56:37 *** JoTraGo has quit IRC
16:06:25 *** JoTraGo has joined #gnucash
16:08:55 *** JoTraGo has quit IRC
16:27:18 *** JoTraGo has joined #gnucash
16:29:49 *** JoTraGo has quit IRC
16:30:22 *** JoTraGo has joined #gnucash
16:46:21 *** aqua___ has joined #gnucash
16:47:28 *** aqua___ has quit IRC
16:51:09 *** fell_ has joined #gnucash
16:51:10 *** gncbot sets mode: +o fell_
16:53:23 *** MechtiIde has quit IRC
17:00:00 *** fell has quit IRC
17:01:40 *** warlord has quit IRC
17:07:37 *** misha has quit IRC
17:08:00 *** misha has joined #gnucash
17:18:08 *** misha has quit IRC
17:55:16 *** misha has joined #gnucash
18:05:46 *** jimvideo has joined #gnucash
18:13:00 *** jethrogb has joined #gnucash
18:23:51 *** Krzysiek_K has quit IRC
18:42:24 *** GabrieleV_ has joined #gnucash
18:42:55 *** GabrieleV has quit IRC
18:42:56 *** GabrieleV_ is now known as GabrieleV
18:58:07 *** cartsoftware1 has joined #gnucash
18:59:46 *** misha_ has joined #gnucash
19:04:57 *** misha has quit IRC
19:05:07 *** cartsoftware has quit IRC
19:05:09 *** fell_ has quit IRC
19:25:48 *** jethrogb has quit IRC
19:30:49 *** jethrogb has joined #gnucash
19:40:14 *** misha has joined #gnucash
19:43:47 *** jethrogb has joined #gnucash
19:44:26 *** jethrogb has quit IRC
19:47:29 *** misha_ has quit IRC
19:56:49 *** StuM has joined #gnucash
19:58:30 *** himaxx has joined #gnucash
20:00:59 *** himaxx has quit IRC
20:05:38 *** jethrogb has joined #gnucash
20:13:36 *** jethrogb has quit IRC
20:30:53 *** jethrogb has joined #gnucash
20:33:40 *** jethrogb has quit IRC
20:56:59 *** GabrieleV_ has joined #gnucash
20:57:07 *** GabrieleV has quit IRC
20:57:08 *** GabrieleV_ is now known as GabrieleV
21:08:28 *** jethrogb has joined #gnucash
21:10:21 *** jethrogb has quit IRC
21:11:23 *** warlord has joined #gnucash
21:12:14 <warlord> @op
21:12:14 *** gncbot sets mode: +o warlord
21:16:46 *** ErKa has quit IRC
21:21:29 *** vantage has quit IRC
21:40:05 *** jethrogb has joined #gnucash
21:43:56 *** jethrogb has quit IRC
22:06:52 *** jethrogb has joined #gnucash
22:07:32 *** fell_ has joined #gnucash
22:07:32 *** gncbot sets mode: +o fell_
22:07:56 *** jethrogb has quit IRC
22:21:56 *** jethrogb has joined #gnucash
22:35:43 *** jralls has quit IRC
23:00:51 *** fell_ has quit IRC
23:46:42 *** jralls has joined #gnucash
23:46:43 *** gncbot sets mode: +o jralls
23:56:50 *** jralls has quit IRC