2014-02-12 GnuCash IRC logs
00:00:21 *** fell has quit IRC
00:17:35 *** warlord has joined #gnucash
00:17:36 *** gncbot sets mode: +o warlord
00:33:19 *** Ahmuck has quit IRC
01:15:46 *** aqua___ has quit IRC
01:18:06 *** MechtiIde has joined #gnucash
02:08:16 *** MechtiIde has quit IRC
02:11:17 *** brianjaod has quit IRC
02:13:24 *** brianjaod has joined #gnucash
02:37:50 *** antix has quit IRC
02:41:57 *** aqua___ has joined #gnucash
02:42:33 *** antix has joined #gnucash
02:45:10 *** jmd has joined #gnucash
02:59:58 *** jmd has quit IRC
02:59:58 *** jmd has joined #gnucash
03:14:32 *** gjanssens has joined #gnucash
03:14:33 *** gncbot sets mode: +o gjanssens
03:50:59 *** wiggin has quit IRC
03:52:33 *** wiggin has joined #gnucash
03:57:30 *** aqua___ has quit IRC
06:20:22 *** antix has quit IRC
06:34:53 *** Jimraehl1 has joined #gnucash
06:39:42 *** Jimraehl1 has left #gnucash
07:06:39 *** Jimraehl1 has joined #gnucash
07:12:01 *** Jimraehl1 has quit IRC
07:41:07 *** himaxx has joined #gnucash
07:49:09 *** himaxx has quit IRC
08:13:31 *** todd has quit IRC
08:27:10 *** aqua___ has joined #gnucash
08:41:21 *** brianjaod1 has joined #gnucash
08:47:33 *** brianjaod has quit IRC
08:54:38 *** todd has joined #gnucash
09:27:02 *** fell has joined #gnucash
09:27:02 *** gncbot sets mode: +o fell
09:53:31 *** barbado has joined #gnucash
09:53:46 <barbado> Hi all.
09:56:05 <barbado> Could you please point me to a trustable GPL "currency converter" for Android?
09:56:59 <warlord> barbado: I'm not sure what you are asking for... Something to get you real-time currency quotes??
10:00:49 <barbado> warlord: also but mainly to perform calculations from one currency into another.
10:01:15 <warlord> barbado: I just use google.com
10:01:30 <warlord> google for, e.g. "125USD in GBP"
10:03:04 <warlord> There may be apps to do what you want, but I've never used any.. I suspect you wont get an answer here.
10:04:24 <barbado> warlord: I think that suggestion of your is awesome :-)
10:04:52 <barbado> warlord: thanks!
10:04:53 <warlord> Google has had that functionality for years.
10:04:56 <warlord> you're welcome.
10:06:27 *** jmd has left #gnucash
10:09:14 <barbado> warlord: a point I'm thinking of is, if there's no Internet connection -- like when you're abroad, a second option would be interesting too.
10:10:01 <warlord> If you dont have an internet connection I have no idea how you would be able to find the current rate. If you're going to look it up ahead of time you might as well just use a regular calculator.
10:12:18 <barbado> warlord: yes. You're correct. I'm old and lazy :-) thank you this once more!
10:12:28 <warlord> you're welcome.
10:14:21 *** benoitg has joined #gnucash
10:58:23 *** gncbot has joined #gnucash
11:02:37 *** gjanssens sets mode: +o gncbot
11:02:51 *** gjanssens sets mode: +o warlord
11:03:41 <warlord> Thanks, gjanssens
11:03:42 <warlord> That was a cablemodem glitch.
11:03:50 <warlord> I need to make it easier for my wife to reset that.
11:04:11 <gjanssens> Due to the stormy weather ?
11:05:52 <warlord> Unclear
11:06:02 <warlord> but a power cycle of the CM fixed it.
11:06:19 <warlord> Anyways, I need to run.. I'll be back in an hour.
11:08:51 *** warlord has quit IRC
11:21:26 *** barbado has left #gnucash
11:47:17 *** O01eg has joined #gnucash
11:54:23 *** warlord has joined #gnucash
11:54:24 *** gncbot sets mode: +o warlord
12:15:24 *** TradeBorG114 has joined #gnucash
12:23:17 *** jmd has joined #gnucash
12:43:22 *** MechtiIde has joined #gnucash
12:45:16 *** Krzysiek_K has joined #gnucash
12:45:29 <jmd> In the /topic: Is there such a word as "publically" ?
12:48:24 *** aqua___ has joined #gnucash
12:52:25 <warlord> jmd: Probably not.
12:52:45 *** warlord changes topic to "Free GPL Personal and Small Business Accounting || Please don't ask to ask, just ask and wait! || publicly-logged channel || latest stable: 2.6.1 || www.gnucash.org"
13:01:03 *** aqua___ has quit IRC
13:04:43 <warlord> jmd: better?
13:06:20 <jmd> warlord: It looks more aesthetically pleasing.
13:07:08 <warlord> :)
13:11:29 *** TradeBorG114 has quit IRC
13:47:23 *** fell has quit IRC
14:34:07 *** aqua___ has joined #gnucash
14:54:18 *** jmd has quit IRC
14:57:10 *** MechtiIde has quit IRC
15:05:14 *** jmd has joined #gnucash
15:14:27 *** jmd has quit IRC
16:14:54 *** TradeBorG114 has joined #gnucash
16:38:36 *** digitect has joined #gnucash
16:38:50 <digitect> Hi all
16:39:38 <digitect> can gnucash use the cash basis method?
16:40:18 <warlord> digitect: yes, but if you use the business features it's accrual, and there is no report currently to convert that to cash-based.
16:41:41 <digitect> yikes
16:42:26 <digitect> I was hoping to use it for my new business
16:43:12 <digitect> can the personal features do invoicing, etc.?
16:49:53 <warlord> Ummmm...
16:50:15 <warlord> It's all one app. You either use Invoicing or you don't. The feature is avaliable under the Business menu.
16:50:30 <warlord> .. and when you do, by definition it's accrual
16:50:56 <digitect> okay
16:51:10 <digitect> disappointing
16:51:11 <warlord> Converting Accrual to Cash can be done by hand. You look at your balance sheet at the end of your tax period and any outstanding receivables get deducted from your income.
16:51:30 <warlord> You're welcome to write the appropriate reports to do the convert. Patches always welcome!
16:51:53 <warlord> You cannot have invoicing without doing it in accrual. It's definitional.
16:52:19 <digitect> are you saying the science of accounting dictates this?
16:52:23 <warlord> Yes
16:53:28 <digitect> I don't understand why an invoice doesn't trigger an AR
17:00:18 <warlord> Well, sort of.
17:00:21 <warlord> You could, theoretically, repost the invoice when it is paid to change the date to the pay date.. Which works if the invoice is paid-in-full.
17:00:21 <warlord> If it's not paid in full..... yeah, accounting science dictates accrual in the general case.
17:00:56 <warlord> ??? What do you mean "trigger an AR"?
17:01:18 <digitect> if I generate an invoice, it should show up in my Accounts Receivable
17:01:46 <digitect> otherwise, I'm not sure what the AR account is for
17:02:04 <warlord> It will, when you post it
17:02:35 <warlord> Basically, when you say "okay, I'm done entering this invoice.. apply it to my accounts because I'm sending it out"... Posting... When you do that it gets applied to AR
17:03:06 *** Ahmuck has joined #gnucash
17:03:15 <digitect> Yup!
17:03:21 <digitect> didn't realize I had to post
17:03:25 <Ahmuck> hi. the import function for gnucash imported the csv file crazy like
17:04:19 <warlord> Ahmuck: which import mechanism, and define "crazy like"
17:06:20 <digitect> warlord: in cash basis, it isn't considered income until the payment is received
17:07:37 <warlord> digitect: yes, I understand that.
17:07:49 <warlord> But by definition "A/R" is an accrual account.
17:08:11 <warlord> Money into A/R has to come from *somewhere*
17:08:52 <Ahmuck> cvs
17:08:55 <Ahmuck> csvv
17:10:01 <Ahmuck> import and it complains about the date feild. then it mixes the deposits and debits up and does not place them in the right columns, some it places in correctly other it places incorrectly
17:10:14 <Ahmuck> changes and mixes dates
17:10:53 <warlord> The csv importer has very strict formatting requirements. Honestly, you're better off finding or writing a script to convert to QIF.
17:14:09 <Ahmuck> i've resorted to hand entry
17:14:37 <Ahmuck> i exported the csv from libreoffice and wondered if there was formating there that libre office was introducing
17:15:51 <warlord> Could be.. But if it's in LO when why not use the Calc2QIF macro?
17:18:16 <Ahmuck> didn't know about it
17:19:22 <Ahmuck> thx, that will work for me
17:30:11 <digitect> warlord: another thought about cash basis
17:30:15 <digitect> warlord: is there a way for a payment on an invoice to shift the transaction from one revenue account to another?
17:31:02 <digitect> warlord: it initializes in an "invoiced" account, and upon payment, is exchanged to a "cash income" account
17:31:12 <digitect> obviously, this could be done manually
17:31:24 <digitect> I'm wondering if the payment receipt process could do it automatically
17:47:03 *** ErKa has quit IRC
17:49:34 *** TradeBorG114 has quit IRC
18:01:51 <warlord> digitect: sorry, had a meeting. The answer is "anything is possible", however doing the binding is... challengin.
18:01:56 <warlord> challenging, even.
18:02:51 <warlord> The problem is that the invoice transaction is specifically tied to the invoice. If you unpost the invoice the transaction disappears, so the payment then needs to potentially apply to a different invoice which may have different income accounts.
18:09:59 *** benoitg has quit IRC
18:30:41 <Ahmuck> i want to print the ledger of one account to compare and check. possible?
18:42:00 <warlord> Ahmuck: yes, Reports -> Account Report
18:42:12 <warlord> (from the account register)
19:25:19 <Ahmuck> i see an option for "blanking"a transaction and "cancel" a transaction. why blank?
19:30:45 <Ahmuck> nm
19:43:53 <digitect> warlord: my workaround will be to simply post invoice to an "invoiced" income account, and move it to a "revenue" income upon receipt of payment
19:44:26 <digitect> so it isn't the invoice transaction that is the problem, it is the "process payment" transaction
19:54:33 <warlord> digitect: note that you cannot "move" the transaction, per se.. You would need to create a new transaction to "move" the funds, but this wont be linked to the invoice in any way... and if you do modify the invoice it wont modify your "movement" transactions.
20:08:09 *** Jimraehl1 has joined #gnucash
20:13:22 *** Jimraehl1 has quit IRC
20:13:48 *** benoitg has joined #gnucash
20:22:49 <digitect> warlord: yeah, it would be easier if all this was automated with a [x] Cash Basis button :)
20:23:07 <warlord> digitect: patches always welcome
20:23:33 <digitect> warlord: yep, I have software with the same problem
20:24:02 <warlord> :)
20:25:21 *** benoitg has quit IRC
20:45:40 <digitect> it would be helpful to put a big "no cash basis" on the webpage though
20:45:46 <digitect> most US small businesses use it
20:46:10 <digitect> at least us service guys
20:50:43 *** digitect has left #gnucash
20:56:40 *** warlord has quit IRC
21:16:14 *** Ahmuck has quit IRC
21:39:28 *** kanru has quit IRC
21:40:38 *** kanru has joined #gnucash
21:50:54 *** noughth has joined #gnucash
21:51:06 *** noughth has left #gnucash
23:05:53 *** isaacd has quit IRC
23:07:00 *** isaacd has joined #gnucash
23:11:51 *** warlord has joined #gnucash
23:11:51 *** gncbot sets mode: +o warlord