2021-03-09 GnuCash IRC logs

00:22:05 *** fell has quit IRC
00:25:36 *** fell has joined #gnucash
00:25:36 *** ChanServ sets mode: +o fell
00:37:32 *** o01eg has joined #gnucash
00:45:38 *** dtux has quit IRC
01:02:55 *** Mechtilde has joined #gnucash
01:25:33 *** frakturfreak has quit IRC
01:32:02 *** sbluhm has joined #gnucash
01:32:02 *** ChanServ sets mode: +v sbluhm
01:36:39 *** fell has quit IRC
01:37:58 *** fell has joined #gnucash
01:37:58 *** ChanServ sets mode: +o fell
01:40:14 *** frakturfreak has joined #gnucash
01:59:35 *** jw4 has quit IRC
02:00:05 *** jw4 has joined #gnucash
02:00:05 *** ChanServ sets mode: +v jw4
02:07:45 *** dtux has joined #gnucash
02:46:44 *** KaiForce has quit IRC
02:47:55 *** KaiForce has joined #gnucash
03:03:59 *** gjanssens has joined #gnucash
03:04:00 *** ChanServ sets mode: +o gjanssens
03:37:58 *** Kara has joined #gnucash
03:38:08 <Kara> Hello, I need a bit of help with GNUcash
03:38:46 <Kara> I have an invoice made (first time using them) and when I go to process payment it says no document is chosen. How do I get a document able to be chosen so the invoice is marked paid
03:57:40 *** dtux has quit IRC
04:01:21 *** Aussie_matt has quit IRC
05:03:58 *** Aussie_matt has joined #gnucash
05:39:49 *** User_ has joined #gnucash
07:58:50 *** bindash has joined #gnucash
07:59:54 *** Aussie_matt has quit IRC
08:01:58 <warlord> Kara, good morning. Welcome to GnuCash.
08:02:08 <warlord> First question for you: did you post the invoice into your AR account?
08:39:31 *** storyjesse has joined #gnucash
08:40:47 *** halipaul has joined #gnucash
08:41:35 *** bindash has quit IRC
08:42:42 *** mikey has joined #gnucash
08:42:43 *** ChanServ sets mode: +v mikey
08:57:32 *** sbluhm has quit IRC
09:06:22 *** Jimraehl1 has joined #gnucash
09:07:11 *** Jimraehl1 has quit IRC
09:07:31 <Kara> I figured it out. No I didn't post.
09:10:09 <warlord> Glad you figured it out.
09:11:43 <Kara> But I don't know if there's a way that I can assign it to something that's not accounts receivable
09:12:01 <Kara> Like for example if it was prepaid and I have an account for that, if I could use that account instead of AR
09:12:44 <Kara> Or well, I guess how I did it is the right way
09:13:42 <warlord> No. Invoices have to go through AR.
09:13:58 <Kara> Alright
09:13:59 <warlord> You can still prepay (via AR)
09:14:12 <warlord> I.e., you can Process Payment (for the pre-payment) before you post the invoice.
09:14:21 <warlord> ... and then attach the payment to the invoice as you post it.
09:14:53 <Kara> Hmm. Okay.
09:15:33 <Kara> The way I did it was to make a prepaid service liability account and to use that account to pay off AR
09:18:50 <warlord> Well, if they prepaid you then you'd just start with a "payment" (AR -> Cash), then when you invoice them, it would balance with Income -> AR. No need for a separate liability account.
09:21:18 <Kara> It's just that accounts receivable is typically for stuff that you're owed and by accounting you'd normally have a liability account for that stuff right?
09:21:31 <Kara> Or am I wrong?
09:22:44 <warlord> Well, stuff you are owed would be an asset (a liability is stuff you owe to someone else)
09:23:24 <Kara> They pay 500, I do the work several days later, thats what I'm talking about
09:23:50 <warlord> That's still just a prepayment; you can use AR to account for that (even though the prepayment would be "negative")
09:24:54 <warlord> But the AR/Invoicing system was designed to handle your case.
09:26:49 <Kara> Hmm, I see
09:29:19 *** David has quit IRC
09:29:26 *** David has joined #gnucash
09:32:19 *** jw4 has quit IRC
09:32:38 *** jw4 has joined #gnucash
09:32:38 *** ChanServ sets mode: +v jw4
09:33:30 <Kara> Then what income account to I post it to because instead of service revenue account I was using my prepaid service account
09:34:17 <Kara> Am I just getting myself confused here
09:35:55 <warlord> I think you are. there are two transactions when using invoicing. There is the invoice transaction (Income:Sales -> AR), and the payment transaction (AR -> Cash).
09:39:08 <Kara> Okay so on the edit invoice there is an "Income Account"
09:39:33 <Kara> What am I supposed to choose there
09:39:43 <chris> Usually "Income:Sales"
09:39:57 <Kara> I can't count income as income until I do the work, I file accrual
09:40:56 <warlord> Biz features are accrual, so that works for you
09:42:27 <Kara> If I choose my income account as Income: Service Revenue, won't it add the revenues as of the date of the invoice? That's why I had a prepayment liability account
09:42:56 <Kara> I was using that instead of Income:Service Revenue for the prepaid amounts
09:45:30 <chris> uh.
09:45:39 <chris> prepaid amount == Cash -> AR --- doesn't touch income account
09:45:46 <warlord> Yes, it will add the income on the date of the invoice, but isn't that what you said you wanted?
09:46:17 <chris> create a transfer that increases cash, decreases A/Receivable. assign as payment to the customer.
09:46:37 <chris> later, create invoice, date as you like, post invoice, then Pay invoice using existing payment.
09:46:51 <chris> create a transfer that increases cash, decreases A/Receivable. assign as payment *from the customer.
09:50:01 <Kara> Oh I might see what you're getting at
09:50:33 <Kara> I had listed the overpayment on the invoice itself, rather than doing that I should just do a journal entry for it?
09:51:00 <Kara> Or rather, don't list it on the invoice, just put the overpayment
09:51:03 <warlord> A Process Payment
09:51:04 <Kara> Okay
09:54:43 <Kara> Ah alright I got it, now my AR looks like the payment of $500 credited followed by debits for the other things
09:56:27 <Kara> Seems to be correct on the journal entry side so Im just gonna leave it, I think it's right
10:01:21 <warlord> Excellent
10:53:35 *** Agfarmer18 has joined #gnucash
11:01:22 *** Agfarmer18 has quit IRC
11:04:24 *** jcarl43 has joined #gnucash
11:04:24 *** ChanServ sets mode: +v jcarl43
11:04:35 <chris> fwiw jralls latest commit has CI error for ubuntu-18
11:10:16 *** suukim has joined #gnucash
11:30:20 *** sbluhm has joined #gnucash
11:30:20 *** ChanServ sets mode: +v sbluhm
11:31:29 *** dtux has joined #gnucash
11:35:35 *** sbluhm has quit IRC
11:39:15 *** bindash has joined #gnucash
11:39:43 *** ArtGravity has joined #gnucash
11:39:43 *** ChanServ sets mode: +v ArtGravity
11:42:30 *** bindash has quit IRC
12:02:16 *** ArtGravity has quit IRC
12:02:38 *** guak has joined #gnucash
12:04:52 *** bindash has joined #gnucash
12:12:20 *** ArtGravity has joined #gnucash
12:12:20 *** ChanServ sets mode: +v ArtGravity
12:24:39 *** jervin has joined #gnucash
12:38:51 *** jervin has quit IRC
12:46:07 *** storyjesse has quit IRC
12:52:53 *** sbluhm has joined #gnucash
12:57:23 *** sbluhm has quit IRC
13:02:10 *** duelle has joined #gnucash
13:03:28 <duelle> Hi, is there a way to export the list of stocks/securities, best case including the number of shares and the price history?
13:03:48 <duelle> To something like a CSV file to use it in other tools (e.g., Portfolio Performance)
13:06:37 *** bindash has quit IRC
13:17:10 *** Agfarmer18 has joined #gnucash
13:21:46 *** Hamaryns has joined #gnucash
13:21:47 *** ChanServ sets mode: +v Hamaryns
13:23:27 <warlord> duelle, I don't think there is an explicit pricedb export.
13:25:27 <duelle> warlord: So then using the SQL database of Gnucash and exporting the data via query would be the "best" option?
13:26:24 <warlord> that or using the python bindings
13:26:24 *** Agfarmer18 has quit IRC
13:31:11 <duelle> Thanks for the hint warlord . Do you mean these with the Python bindings: https://piecash.readthedocs.io ?
13:31:46 <warlord> Not necessarily -- although I suppose piecash could work. I mean the actual GnuCash Python Bindings.
13:32:21 <duelle> Ah okay, thanks!