2015-02-18 GnuCash IRC logs
00:30:00 *** O01eg has quit IRC
00:42:41 *** cartsoftware has joined #gnucash
00:53:49 <linas> so I'm not looking at IRC. derek, you haven't signed such an assignment, because no assignment of gnucash code is being done.
00:57:12 <linas> jralls, right, gnucash is not the "official project of GNU" (because I'm pretty sure FSF doesn't think this is the case, and even if they did think so, they've never ever provided any actual, effective suppport).
00:58:39 <linas> I thik we are sourceforge project #7 or #143 or somethng like that. The number would be even lower, except there was a few weeks dawdling to get registered
01:00:26 <linas> I seem to have found a g+ page from Yawar, I'll talk mto him there
01:05:00 *** len has quit IRC
01:19:11 *** MechtiIde has joined #gnucash
01:29:17 *** jimvideo has quit IRC
01:31:57 *** ErKa has quit IRC
01:48:09 *** cartsoftware has quit IRC
01:52:09 *** Gbarr has quit IRC
02:11:20 *** MechtiIde has quit IRC
02:32:25 *** gjanssens has joined #gnucash
02:32:25 *** gncbot sets mode: +o gjanssens
02:39:00 *** Krzysiek_K has joined #gnucash
02:39:07 *** wol has joined #gnucash
02:54:00 *** cartsoftware has joined #gnucash
03:26:52 *** cartsoftware has quit IRC
03:32:37 *** Krzysiek_K has quit IRC
04:03:28 *** fabior has joined #gnucash
04:06:01 *** wol1 has joined #gnucash
04:08:39 *** wol has quit IRC
04:14:59 *** jralls has quit IRC
04:26:02 *** wol1 has quit IRC
04:33:49 *** jralls has joined #gnucash
04:33:50 *** gncbot sets mode: +o jralls
04:37:38 *** keret has quit IRC
04:38:34 *** keret has joined #gnucash
04:44:29 *** cartsoftware has joined #gnucash
05:25:42 *** aqua___ has joined #gnucash
05:55:52 *** aqua___ has quit IRC
06:02:57 *** cartsoftware has quit IRC
06:18:01 *** uXus has quit IRC
06:20:54 *** uXus has joined #gnucash
06:25:21 *** cartsoftware has joined #gnucash
06:32:19 *** fabior has quit IRC
06:35:45 *** fabior has joined #gnucash
06:41:16 *** himaxx has joined #gnucash
06:52:58 *** Jimraehl1 has left #gnucash
06:58:20 *** Jimraehl1 has joined #gnucash
07:00:00 *** himaxx has quit IRC
07:10:41 *** fabior has quit IRC
07:19:46 *** aqua___ has joined #gnucash
07:32:03 *** andy has quit IRC
07:45:13 *** aqua___ has quit IRC
07:49:59 *** fellipe has joined #gnucash
07:50:31 <fellipe> Hi, what are the characters "n" and "p" at "o" column?
07:50:31 <gncbot> fellipe: Sent 1 week, 5 days, 0 hours, and 38 minutes ago: <warlord> I presume you mean the Reconciled column (in English), the values are Not-reconciled, Cleared, and Yes-reconciled. There is also a Void marking too.
07:50:32 <gncbot> fellipe: Sent 1 week, 5 days, 0 hours, and 37 minutes ago: <warlord> PS: It would help if you stuck around for more than a few minutes to get your answer.
07:52:45 *** aqua___ has joined #gnucash
07:55:44 *** aqua___ has quit IRC
07:56:23 *** rickoehn has joined #gnucash
07:57:11 *** aqua___ has joined #gnucash
08:02:50 <fellipe> Hi, what are the characters "n" and "p" at "o" column?
08:07:21 *** andy has joined #gnucash
08:14:36 *** fellipe has quit IRC
08:19:47 *** aqua___ has quit IRC
08:33:20 *** wol has joined #gnucash
08:33:54 *** cartsoftware has quit IRC
08:42:32 *** lmat has joined #gnucash
08:47:28 *** fellipe has joined #gnucash
08:47:28 *** mlncn has joined #gnucash
08:47:59 <fellipe> hi, what are those characters "n" and "p" at "o" column in transactions sheet?
08:55:30 *** mlncn has quit IRC
09:00:00 <lmat> @op
09:00:01 <gncbot> lmat: Error: You don't have the #gnucash,op capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
09:07:57 <fellipe> hi, what are those characters "n" and "p" at "o" column in transactions sheet?
09:08:54 <lmat> fellipe: Repeating won't help, my friend :-0
09:09:00 <lmat> oops, :-)
09:10:43 <fellipe> lmat, sorry. don't you know?
09:10:56 <lmat> fellipe: I don't know.
09:11:08 *** cartsoftware has joined #gnucash
09:11:56 <fellipe> lmat, heh, it's ok. I would use them as "non paid" and "paid"
09:12:12 <fellipe> lmat, while I don't find out what it is
09:14:11 *** cartsoftware has quit IRC
09:14:56 *** cartsoftware has joined #gnucash
09:16:57 *** wol has quit IRC
09:20:38 *** mlncn has joined #gnucash
09:22:12 *** fellipe has quit IRC
09:24:10 *** lmat_ has joined #gnucash
09:29:21 *** lmat has quit IRC
09:58:06 *** fabior has joined #gnucash
10:38:40 *** O01eg has joined #gnucash
10:47:22 *** lmat_ has quit IRC
10:47:32 *** lmat has joined #gnucash
10:53:28 *** ErKa has joined #gnucash
10:58:28 *** wol has joined #gnucash
10:58:50 *** O01eg has quit IRC
11:00:01 *** fell_ has joined #gnucash
11:00:01 *** gncbot sets mode: +o fell_
11:09:34 *** fell has quit IRC
11:18:05 *** O01eg has joined #gnucash
11:43:59 *** Eric has joined #gnucash
11:45:16 <Eric> Hi, I have a question about exporting "Due Bills" that must be payed.
11:45:52 *** MechtiIde has joined #gnucash
11:46:54 <Eric> I encode during the day multiple Bills for multiple Vendors. I post the different Bills. Then I want to export to a file (csv) all the bills in a certain range or all the bills that are due with sufficient information on the Bill and th Vendor.
11:47:09 *** mlncn-agaric has joined #gnucash
11:47:46 <Eric> Example Bill 0001, description, amount, Vendor xxx, name, adress, ...
11:48:42 <Eric> At the end I have a file that I will treat with an external program to format it in the correct way to be send to the Bank for payement.
11:49:20 *** mlncn has quit IRC
11:49:26 <Eric> It would be nice if in gbucash the payement is also geneterated (I use only one Bankaccount so this must be easy
12:03:33 *** wol has quit IRC
12:04:56 *** Gbarr has joined #gnucash
12:08:36 *** wol has joined #gnucash
12:11:21 <warlord> lmat: I answered fellipe's question already... See the logs from 7:50am (EST).
12:12:01 <warlord> I dont understand why he repeatedly asked the question when it *WAS* answered.
12:12:39 <warlord> @tell fellipe Dude, I answered your question already. The column is the RECONCILED column, and the values correspond to No, Cleared, and Yes (reconciled)... Translated into your language.
12:12:39 <gncbot> warlord: The operation succeeded.
12:31:41 *** wol has quit IRC
12:47:00 *** Eric has quit IRC
12:50:46 *** wol has joined #gnucash
12:54:07 *** rpg has joined #gnucash
12:55:17 *** len has joined #gnucash
12:57:11 *** daum has joined #gnucash
12:57:49 <daum> is there a way to do cash basis vs accurial reports in gnucash?
12:59:16 *** cartsoftware has quit IRC
13:07:37 *** Krzysiek_K has joined #gnucash
13:11:07 *** wol has quit IRC
13:12:49 <warlord> daum: no, if you use the biz features all reports are in accrual mode. You would need to manually convert to cash
13:20:07 <daum> warlord, how would you do that?
13:21:07 <warlord> Keep track of all invoices that are posted in Period P and payed in Period P+1
13:21:12 <warlord> (or +2, or...)
13:21:36 <warlord> I.e., subtract any outstanding A/R at the end of a Period from the Income from that period.
13:26:50 <daum> ok thanks will look into that
13:27:02 <daum> accountant was askign if there was a toggle like in quickbooks=p
13:27:12 <warlord> no
13:27:14 <warlord> there is not.
13:27:15 <daum> thanks sounds easy enough to tr yto do
13:27:54 <warlord> Oh, and when you subtract the outstanding A/R from Income, you need to remember to add that back in to the next period.
13:28:04 <daum> right - makes sense
13:31:14 *** len has quit IRC
13:32:07 *** len has joined #gnucash
13:32:26 *** wol has joined #gnucash
13:38:13 *** mr_wibble has joined #gnucash
13:38:47 *** mr_wibble has quit IRC
13:39:53 *** len has quit IRC
13:41:55 <daum> warlord, by the way thanks so much again for gnucash its great!
13:42:08 <warlord> you're welcome.
13:43:05 *** len has joined #gnucash
13:47:07 *** rpg has quit IRC
14:06:18 *** wol has quit IRC
14:07:22 *** fabior has quit IRC
14:08:06 <kimmo2_> I have no idea why anyone would really WANT to do cash basis if they already have a tool that does accrual
14:08:12 <kimmo2_> but that's just me
14:08:34 <warlord> kimmo2_: tax purposes?
14:08:48 <warlord> (it's often easier to file taxes via cash versus accrual basis)
14:18:31 <kimmo2_> oh, that might be. In Finland it doesn't really matter
14:19:08 <kimmo2_> if you do cash based you get to postpone your monthly VAT deposits by 1 or 2 months but that's about it
14:20:32 <gjanssens> kimmo2_: Belgian government is actually in the process of enforcing cash based tax declarations
14:21:04 <gjanssens> The law is in effect as of Jan 1st 2014, but we have one or two years to adapt
14:22:17 <daum> kimmo2_, yeah definitely for us its better to be on a cash basis rather than accrual if you don't have to be
14:25:34 *** Eric has joined #gnucash
14:33:23 <Eric> Hi, is there a convention to post a message?
14:34:18 <Eric> onto this chat (is what I meant)
14:35:11 <warlord> Eric: just ask away
14:35:17 <warlord> (dont ask to ask)
14:35:57 <Eric> Ok my question started at 11:47
14:38:50 <warlord> as far as I know there is no export of that data.
14:39:29 <Eric> warlord: any idea if it can be build?
14:40:46 <warlord> anything is possible; just a simple matter of programming
14:42:46 <Eric> warlord: report programming or c-code development
14:42:47 <warlord> How is your C?
14:42:56 <warlord> Ummm... That's a good question.
14:43:00 <Eric> bad ;-)
14:43:06 <warlord> I have no idea how the current "export" functionality is implemented.
14:43:33 <warlord> You could (in Scheme) write a report that you could then copy-and-paste out..
14:44:45 <Eric> any idea what is a good report to start from, since all reports I find cannot select multiple bills from multiple vendors
14:48:14 *** aqua___ has joined #gnucash
14:49:05 *** jimvideo has joined #gnucash
14:51:24 <warlord> Try the aging reports?
14:51:42 <warlord> You're not going to be able to "select" multples that way.
14:52:33 <Eric> The idea is either to specify a range of bill-id's or all bill that are Due
14:52:59 <warlord> The latter will be easier
14:55:31 *** fabior has joined #gnucash
14:57:02 *** MechtiIde has quit IRC
14:58:14 *** cartsoftware has joined #gnucash
15:03:11 *** cartsoftware1 has joined #gnucash
15:07:29 <Eric> I know from the documentation that you do not prefer to access directly the gnucash xml file (the database), but is that not an option in this case ?
15:10:22 *** cartsoftware has quit IRC
15:12:16 <warlord> read-only access is fine
15:13:24 <Eric> Is there an example program (whatever language) showing how it can be done
15:14:16 *** himaxx has joined #gnucash
15:14:26 <warlord> not that I know of
15:14:30 *** himaxx has quit IRC
15:15:52 <Eric> Should I ask it to somebody else or are you a gnucash guru ?
15:16:41 *** Gbarr has quit IRC
15:17:21 *** Gbarr has joined #gnucash
15:17:26 <gjanssens> :)
15:17:52 <gjanssens> Eric, warlord *wrote* most of the business functionality in gnucash
15:18:03 <gjanssens> you could call him a gnucash guru imo
15:18:23 <gjanssens> That doesn't mean you can ask around for such a program
15:19:20 <gjanssens> Many people do things around gnucash without letting us know
15:19:30 <gjanssens> The gnucash-user list would be a good place
15:20:11 <Eric> Warlord, my sincere apologizes, great job but job is not finisched
15:22:03 <gjanssens> Eric, we could use a hand in finishing it...
15:22:03 <Eric> Gjanssens : the reason for my question is the fact that I can't do payments with Belgian Banks since not available in the online banking module
15:22:26 <gjanssens> Indeed
15:22:41 <gjanssens> I have always done my payments manually so far
15:22:47 <gjanssens> I didn't have that many to do
15:23:01 <gjanssens> And still don't
15:23:36 <gjanssens> I once had aspirations to teach gnucash about CODA, but my time is severely limited lately
15:24:09 <Eric> Gjanssens : I solved the input for bank statements in translating the csv files I receive from the bank and convert it inti MT940 which can be imported
15:24:25 <gjanssens> Interesting approach
15:24:29 <gjanssens> What bank are you with ?
15:24:45 <gjanssens> I believe Belfius can even export to MT940
15:24:51 <gjanssens> It least it could at some point
15:24:59 <Eric> so the next step is the other way arround export from gnucash and upload it to the bank
15:25:26 <Eric> BNPP Fortis and KBC
15:26:59 <Eric> I upload today payments from a file and playin the right keystrokes to simulate a real user behind the banks on-line banking application
15:27:40 <Eric> Relatively easy but the content should come from my gnucash ledger, I do not like to code it twice
15:29:08 *** TommyT has joined #gnucash
15:29:14 <gjanssens> Ok
15:29:52 *** cartsoftware has joined #gnucash
15:33:12 <gjanssens> Eric, I quickly checked about the bills due reminder code
15:33:38 <gjanssens> Unfortunately it's not accessible from the scheme or python bindings :(
15:33:50 <gjanssens> That would have given you what you needed
15:33:56 *** cartsoftware1 has quit IRC
15:34:34 <gjanssens> As your C is bad, how well is your scheme ?
15:35:12 <gjanssens> Scheme as in guile the programming language
15:36:28 <Eric> I am trying but not yet successful, that's why I asked to access the database (xml) directly via VB for example
15:37:51 <Eric> But I will try, I find gnucash a good program, but the payement engine should be avaialbel otherwise it is useless. I will use it for 2 non-profit organisations and I have 20 bills a week.
15:37:52 <gjanssens> Ok
15:38:19 <gjanssens> The disadvantage of going directly into xml is that you can't leverage the business logic
15:38:40 <gjanssens> So you have to figure out yourself which bills are paid and which aren't
15:39:03 <gjanssens> That's not a property of the bill, but rather calculated from the lots that connect bills and payments
15:39:41 <gjanssens> If you want to work from a report, the vendor report is probably a relatively good one to start from
15:40:09 <gjanssens> The file is called owner-report.scm, because it's used for both vendor and customer reports.
15:40:35 <gjanssens> It will query all lots in A/P and filter on the selected vendor
15:40:38 <Eric> To know which bills I need to pay is in my case relatively easy, I encode the bills and then I pay and I know the bill numbers to be payed
15:41:23 <gjanssens> You apply the payments in gnucash you mean ?
15:41:59 <Eric> I tried already the vendor report , but this is mono vendor and when I code multiple bills, in neraly all cases it arde different vendors
15:42:34 <gjanssens> I meant for you to write a new report, starting from owner-report.scm
15:42:51 <gjanssens> Drop the vendor filter in the new report and it will give you all reports for all vendors
15:43:15 <gjanssens> Then you will have to make it filter unpaid invoices only
15:43:37 <gjanssens> Of course my assumption here is that you don't apply payments in gnucash yet until after you have run this report
15:43:53 <Eric> Indeed I will apply the payement in gnucash otherwise the ledger will not be in order. Payement for me also means do the manipulations on the Banks on-line banking site and do the real payement
15:45:09 <gjanssens> Ok, then the vendor-report approach is useless because it won't allow you to distinguish between previously paid bills and bills you want to pay now online
15:45:11 <Eric> Ok i can wait to start the gnucash payment until I did the job on the banks site, alltough it w ould be nice if I could do it with the same report
15:46:53 <gjanssens> Or here is maybe a completely different approach:
15:47:04 <gjanssens> Pay your bills in gnucash first
15:47:27 <gjanssens> When paying, add the payment ref you need for the bank in the payment memo
15:47:51 <gjanssens> Something like "Factuur 236"
15:48:07 <gjanssens> The open your bank register
15:48:35 <gjanssens> And apply a filter that will select you your most recently paid bills
15:48:46 <gjanssens> Then open an account report on the filtered result
15:49:11 <gjanssens> That report can be exported to html or copied into an excel sheet or whatever
15:49:47 <gjanssens> The way to select your most recently paid bills could be either based on payment references
15:50:30 <gjanssens> or if you mark all older payment transactions as cleared or reconciled you could also also filter on reconcile status
15:51:17 <gjanssens> By adding the payment ref in the payment's memo you can have it in the export data to massage into an actual file to send to the bank
15:52:56 <Eric> Indeed interesting. I will try this way of working tomorrow or this week-end. I will keep you informed if it was succesfull
15:53:04 <gjanssens> Ok
15:53:07 <gjanssens> Good luck
15:53:13 <Eric> Bye
15:53:16 <gjanssens> Bye
15:53:36 *** Eric has left #gnucash
16:01:13 *** gjanssens has quit IRC
16:06:19 *** fabior has quit IRC
16:30:20 *** daum has quit IRC
16:56:14 *** ErKa has quit IRC
17:10:50 *** lmat has quit IRC
17:18:11 *** lmat has joined #gnucash
17:31:53 *** benjamin-agaric has joined #gnucash
17:39:42 *** mlncn-agaric has quit IRC
17:54:44 *** lmat has quit IRC
17:57:59 *** rickoehn has quit IRC
18:10:55 *** Krzysiek_K has quit IRC
18:13:45 *** fellipe has joined #gnucash
18:13:58 <fellipe> hi, what are those characters "n" and "p" at "o" column in transactions sheet?
18:13:58 <gncbot> fellipe: Sent 6 hours and 1 minute ago: <warlord> Dude, I answered your question already. The column is the RECONCILED column, and the values correspond to No, Cleared, and Yes (reconciled)... Translated into your language.
18:14:51 <fellipe> warlord, are you there?
18:15:49 <fellipe> warlord, gncbot told me the message: " <warlord> Dude, I answered your question already. The column is the RECONCILED column, and the values correspond to No, Cleared, and Yes (reconciled)... Translated into your language."
18:17:26 <fellipe> warlord, you gave 3 options but the options are just two: "n" or "p"
18:47:03 *** TommyT has quit IRC
18:48:53 *** ErKa has joined #gnucash
18:51:26 *** benjamin-agaric has quit IRC
19:35:15 <warlord> fellipe: There are three options -- you get the third when you go through the reconcile process
19:35:43 <warlord> If you're in the register you can only cycle between No and Cleared
19:36:47 <fellipe> warlord, it's very different concepts in portuguese, so, when I click twice to open transaction sheet, I can see only "n" and "p" at "o" column
19:54:44 <warlord> fellipe: right. but if you click on [Menu] -> Actions -> Reconcile and go through the Reconcile Process it will turn the reconciled splits to "Yes"
19:55:04 <warlord> Please read the documentation on Clearing and Reconciling transactions.
20:02:11 *** fellipe has quit IRC
20:03:08 <warlord> @tell fellipe you're using pt_BR? n == "não reconciliada", p == "pré-reconciliado" as per the translation. Then you would also see r == "reconciliada" if you go through the process
20:03:08 <gncbot> warlord: The operation succeeded.
20:03:57 <warlord> @tell fellipe I'm not sure where the 'o' is coming from.
20:03:57 <gncbot> warlord: The operation succeeded.
20:19:59 *** cartsoftware has quit IRC
21:21:55 *** benjamin-agaric has joined #gnucash
23:08:50 *** fell__ has joined #gnucash
23:08:50 *** gncbot sets mode: +o fell__
23:17:39 *** fell_ has quit IRC
23:36:17 *** aqua_ has joined #gnucash
23:41:28 *** aqua___ has quit IRC
23:42:36 *** StuM has joined #gnucash