Re: [GNC] GnuCash wiki
Thanks Geert I was able to get back in an hour later. David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] New User-Chase Bank Problems
Hello, I remember spending a lot of time to get it to work with my Chase Freedom card. There were 2 things that needed be done. #1, create a UUID and #2, go onto the website after you try it and give access. Summary: 1. Generated a Version 4 UUID here: a. https://www.uuidgenerator.net/version4 2. Entered it in my user settings ClientUID field in the aqbanking wizard - without the dashes 3. Changed the Header version to 103 (was 102) 4. Connect and instant success! Transactions and balance downloaded with no error messages in log. Go to your Chase Secure message box and allow the connection Thanks to Dave Reiser for figuring it out...I basically followed his instructions. If you'd like me to paste the entire email let me know. I saved it along with my summary above. Michael On Sat, Dec 15, 2018 at 7:32 PM David Reiser via gnucash-user < gnucash-user@gnucash.org> wrote: > > > On Dec 15, 2018, at 8:10 PM, Michael Mantei wrote: > > > > I was a user of Quicken for as long as I can remember. I'm now trying > to get serious about my finances and recently installed GNUCash on my > Windows 10 system. I simply installed the software, and built my entire > account structure manually, to match exactly what I wanted it to be. Now I > need to connect to my bank (Chase) and can't do it. > > > > I'm using the AQBanking Wizard and have setup a user account and it > won't connect. I started reading lots of messages here then created a new > user. This one has the User Name and User Id set to the same name I used > with Quicken. I used an online app to generate a Client UID. I've selected > JPMorqan Chase Bank as my bank and took the defaults on the Bank Settings > page. For the Application Settings, I have an Application ID of "QWIN". The > application version is set to 2700 and the header version is set to 103. > When I try to retrieve the account list, this is what I get: > > > > > > 14:06:57 Retrieving SSL certificate > > 14:06:57 Connecting to server... > > 14:06:57 Using GnuTLS default ciphers. > > 14:06:57 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD > > 14:06:57 Signer not found > > 14:06:57 Certificate is not trusted > > 14:06:57 Connected. > > 14:06:57 Disconnected. > > 14:06:57 Connection ok, certificate probably received > > 14:06:57 Operation finished, you can now close this window. > > > > The OFX.log file shows this: > > > > Sending: > > - > > OFXHEADER:100 > > DATA:OFXSGML > > VERSION:103 > > SECURITY:NONE > > ENCODING:USASCII > > CHARSET:1252 > > COMPRESSION:NONE > > OLDFILEUID:NONE > > NEWFILEUID:20181214144405.000 > > > > 20181214144405.000#NAME > REMOVED# > > #PASSWORD REMOVED# > > ENGChase > Bank1601QWIN22004f67a05f-bb69-45a7-ab66-d1f52dc4ef7120181214144405.000119691231 > > > > - > > > > Anyone have any ideas what I am doing wrong? Your help would be greatly > appreciated. > > > > SciFiGeek > > > > The ofx log says you set the APPVER to 2200 instead of 2700. That probably > matters. > > Another thing is that you’re likely to have to do is log into the Chase > web site, and check your secure messages for one that asks you if you were > the one trying to sign in with a previously unknown app (as identified by > the new unique CLIENTUID). Once you’ve followed the steps in the Chase > message, you’ll be in better shape. If you have no message yet, there’s a > possibility that the Chase system doesn’t think your software is capable > anyway (APPVER too low). Change the APPVER, try Aqbanking again, and then > check your account messages online again. > > I only have Chase credit cards. I don’t know if the procedure is different > for checking and savings accounts. Chase does by default charge a fee for > checking/savings access via OFXDirectConnect. But since you’ve connected > before, I’m assuming that isn’t causing you problems. > > I also don’t know if Chase has changed the out-of-band verification steps > since the first round two years ago. Good luck. > > > -- > Dave Reiser > dbrei...@icloud.com > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] New User-Chase Bank Problems
> On Dec 15, 2018, at 8:10 PM, Michael Mantei wrote: > > I was a user of Quicken for as long as I can remember. I'm now trying to get > serious about my finances and recently installed GNUCash on my Windows 10 > system. I simply installed the software, and built my entire account > structure manually, to match exactly what I wanted it to be. Now I need to > connect to my bank (Chase) and can't do it. > > I'm using the AQBanking Wizard and have setup a user account and it won't > connect. I started reading lots of messages here then created a new user. > This one has the User Name and User Id set to the same name I used with > Quicken. I used an online app to generate a Client UID. I've selected > JPMorqan Chase Bank as my bank and took the defaults on the Bank Settings > page. For the Application Settings, I have an Application ID of "QWIN". The > application version is set to 2700 and the header version is set to 103. When > I try to retrieve the account list, this is what I get: > > > 14:06:57 Retrieving SSL certificate > 14:06:57 Connecting to server... > 14:06:57 Using GnuTLS default ciphers. > 14:06:57 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD > 14:06:57 Signer not found > 14:06:57 Certificate is not trusted > 14:06:57 Connected. > 14:06:57 Disconnected. > 14:06:57 Connection ok, certificate probably received > 14:06:57 Operation finished, you can now close this window. > > The OFX.log file shows this: > > Sending: > - > OFXHEADER:100 > DATA:OFXSGML > VERSION:103 > SECURITY:NONE > ENCODING:USASCII > CHARSET:1252 > COMPRESSION:NONE > OLDFILEUID:NONE > NEWFILEUID:20181214144405.000 > > 20181214144405.000#NAME REMOVED# > #PASSWORD REMOVED# > ENGChase > Bank1601QWIN22004f67a05f-bb69-45a7-ab66-d1f52dc4ef7120181214144405.000119691231 > > - > > Anyone have any ideas what I am doing wrong? Your help would be greatly > appreciated. > > SciFiGeek > The ofx log says you set the APPVER to 2200 instead of 2700. That probably matters. Another thing is that you’re likely to have to do is log into the Chase web site, and check your secure messages for one that asks you if you were the one trying to sign in with a previously unknown app (as identified by the new unique CLIENTUID). Once you’ve followed the steps in the Chase message, you’ll be in better shape. If you have no message yet, there’s a possibility that the Chase system doesn’t think your software is capable anyway (APPVER too low). Change the APPVER, try Aqbanking again, and then check your account messages online again. I only have Chase credit cards. I don’t know if the procedure is different for checking and savings accounts. Chase does by default charge a fee for checking/savings access via OFXDirectConnect. But since you’ve connected before, I’m assuming that isn’t causing you problems. I also don’t know if Chase has changed the out-of-band verification steps since the first round two years ago. Good luck. -- Dave Reiser dbrei...@icloud.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] New User-Chase Bank Problems
I was a user of Quicken for as long as I can remember. I'm now trying to get serious about my finances and recently installed GNUCash on my Windows 10 system. I simply installed the software, and built my entire account structure manually, to match exactly what I wanted it to be. Now I need to connect to my bank (Chase) and can't do it. I'm using the AQBanking Wizard and have setup a user account and it won't connect. I started reading lots of messages here then created a new user. This one has the User Name and User Id set to the same name I used with Quicken. I used an online app to generate a Client UID. I've selected JPMorqan Chase Bank as my bank and took the defaults on the Bank Settings page. For the Application Settings, I have an Application ID of "QWIN". The application version is set to 2700 and the header version is set to 103. When I try to retrieve the account list, this is what I get: 14:06:57 Retrieving SSL certificate 14:06:57 Connecting to server... 14:06:57 Using GnuTLS default ciphers. 14:06:57 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD 14:06:57 Signer not found 14:06:57 Certificate is not trusted 14:06:57 Connected. 14:06:57 Disconnected. 14:06:57 Connection ok, certificate probably received 14:06:57 Operation finished, you can now close this window. The OFX.log file shows this: Sending: - OFXHEADER:100 DATA:OFXSGML VERSION:103 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:20181214144405.000 20181214144405.000#NAME REMOVED# #PASSWORD REMOVED# ENGChase Bank1601QWIN22004f67a05f-bb69-45a7-ab66-d1f52dc4ef7120181214144405.000119691231 - Anyone have any ideas what I am doing wrong? Your help would be greatly appreciated. SciFiGeek ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How To Handle Prepayments
Many thanks Adrien. I think your explanation works except for a minor detail, after the initial payment is exhausted all payments are after the fact. Each month I submit a report of participant count for the prior month. They will then send me a bill for the amount due. I don't think there is anything prepaid regarding these subsequent payments so I'm pretty sure I can just expense them. Best, Tom -- Original Message -- From: "Adrien Monteleone" To: "Gnucash Users" Sent: 12/15/2018 4:41:12 PM Subject: Re: [GNC] How To Handle Prepayments I’m not sure I’m entirely following the timing exactly, but many insurances, and it looks like your’s falls in this category, are pre-paid. Thus they are assets until they are ‘used’. So when you make the initial payment: Dr. Assets:Current Assets:Pre-Paid Assets:Insurance Cr. Assets:Current Assets:Cash/Checking You can handle that with a Vendor bill and Payment if you like. As the insurance is ‘used’: Dr. Expenses:Insurance Cr. Assets:Current Assets:Pre-Paid Assets:Insurance This can be handled with a manual or scheduled transaction as your situation dictates. (which could also be a vendor bill, if you didn’t use one for the initial payment) Subsequent payments are likely still in advance, and so would go to increase the pre-paid asset first and then when used, they are expensed. There is no need for involving A/P accounts or credit memos to adjust them. (unless you opt for the vendor bill route, but you still shouldn’t need credit memos) I had a thread some months back on a similar topic and the issue is something to consider: I receive a bill about a month in advance of the due date every six months for auto insurance. If I pay that bill early, or on time, I am gaining a ‘pre-paid’ asset to be used up over the next six months. My problem wasn’t using the bills feature to handle this, or the expensing (I just set up a scheduled transaction for that part) but that I couldn’t post the ‘advance’ bill without it posting to my assets right away. Yet, it isn’t an asset till I actually pay it. I was wanting to take advantage of the bills due reminder for this bill. I had to settle on waiting to post the bill until I actually make the payment and forgoing the reminder. That way, my assets weren’t inflated early. Otherwise, everything else works out fine. Regards, Adrien On Dec 15, 2018, at 3:06 PM, tbalaban wrote: My Company pays an initial payment to our insurer at the beginning of each policy year. As we incur insurance costs based on event participants, that initial payment is charged. After it is exhausted we get a monthly bill for the amount due. In no case do we ever get the initial payment back. I'd like to treat the initial payment as a credit to insurer's A/P account then each month create a bill for the amount payable. Is this the correct way to handle such a transaction? Assuming it is, how do I credit the amount due from whatever account I posted the initial payment to? In practice we pay the initial payment in February, the start of our paolicy year. Usually, in April or May, the initial payment is exhaused and we have to send more money to pay that month's bill. I'm not at all clear on how to post this situation. I'd appreciate knowing how to do this in GNUCash as well as any comments on the applicable general accounting rules. In Quickbooks I could debit or credit A/R or A/P diectly and selects the customer or vendor required. Since that capabiity does not appear to be available in GNUCash, how do I post it? Many thanks for your already generous help. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. Y
Re: [GNC] How To Handle Prepayments
Thanks Elvis. Because of the casual way the insurance company handles this highly specialized business, only had 5 transactions to post for the entire year. While report monthly I often don't get bills for 2 or 3 months. I ended up doing the Pre-Paid thing for the initial payment, then charging Insurance against that credit each month after I submit my report until it was exhausted. Subsequent payments were expensed directly against Insurance. It took me just few minutes to that this afternoon and I now have much better sense of what my obligation is to them. I care even if they don't. ;-)) Best, Tom -- Original Message -- From: "elvis" To: gnucash-user@gnucash.org Sent: 12/15/2018 5:50:49 PM Subject: Re: [GNC] How To Handle Prepayments Unless you really need to do accrual accounting, then don't. If you are never getting it back, it is not much of an asset. Put it though as Insurance Expense, Initial Payment, Payment 2 etc. Accounting is there to help you, not make more work to make it "correct". On 16/12/18 7:06 am, tbalaban wrote: My Company pays an initial payment to our insurer at the beginning of each policy year. As we incur insurance costs based on event participants, that initial payment is charged. After it is exhausted we get a monthly bill for the amount due. In no case do we ever get the initial payment back. I'd like to treat the initial payment as a credit to insurer's A/P account then each month create a bill for the amount payable. Is this the correct way to handle such a transaction? Assuming it is, how do I credit the amount due from whatever account I posted the initial payment to? In practice we pay the initial payment in February, the start of our paolicy year. Usually, in April or May, the initial payment is exhaused and we have to send more money to pay that month's bill. I'm not at all clear on how to post this situation. I'd appreciate knowing how to do this in GNUCash as well as any comments on the applicable general accounting rules. In Quickbooks I could debit or credit A/R or A/P diectly and selects the customer or vendor required. Since that capabiity does not appear to be available in GNUCash, how do I post it? Many thanks for your already generous help. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- "I love the smell of napalm in the morning." ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How To Handle Prepayments
Unless you really need to do accrual accounting, then don't. If you are never getting it back, it is not much of an asset. Put it though as Insurance Expense, Initial Payment, Payment 2 etc. Accounting is there to help you, not make more work to make it "correct". On 16/12/18 7:06 am, tbalaban wrote: My Company pays an initial payment to our insurer at the beginning of each policy year. As we incur insurance costs based on event participants, that initial payment is charged. After it is exhausted we get a monthly bill for the amount due. In no case do we ever get the initial payment back. I'd like to treat the initial payment as a credit to insurer's A/P account then each month create a bill for the amount payable. Is this the correct way to handle such a transaction? Assuming it is, how do I credit the amount due from whatever account I posted the initial payment to? In practice we pay the initial payment in February, the start of our paolicy year. Usually, in April or May, the initial payment is exhaused and we have to send more money to pay that month's bill. I'm not at all clear on how to post this situation. I'd appreciate knowing how to do this in GNUCash as well as any comments on the applicable general accounting rules. In Quickbooks I could debit or credit A/R or A/P diectly and selects the customer or vendor required. Since that capabiity does not appear to be available in GNUCash, how do I post it? Many thanks for your already generous help. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- "I love the smell of napalm in the morning." ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How To Handle Prepayments
I’m not sure I’m entirely following the timing exactly, but many insurances, and it looks like your’s falls in this category, are pre-paid. Thus they are assets until they are ‘used’. So when you make the initial payment: Dr. Assets:Current Assets:Pre-Paid Assets:Insurance Cr. Assets:Current Assets:Cash/Checking You can handle that with a Vendor bill and Payment if you like. As the insurance is ‘used’: Dr. Expenses:Insurance Cr. Assets:Current Assets:Pre-Paid Assets:Insurance This can be handled with a manual or scheduled transaction as your situation dictates. (which could also be a vendor bill, if you didn’t use one for the initial payment) Subsequent payments are likely still in advance, and so would go to increase the pre-paid asset first and then when used, they are expensed. There is no need for involving A/P accounts or credit memos to adjust them. (unless you opt for the vendor bill route, but you still shouldn’t need credit memos) I had a thread some months back on a similar topic and the issue is something to consider: I receive a bill about a month in advance of the due date every six months for auto insurance. If I pay that bill early, or on time, I am gaining a ‘pre-paid’ asset to be used up over the next six months. My problem wasn’t using the bills feature to handle this, or the expensing (I just set up a scheduled transaction for that part) but that I couldn’t post the ‘advance’ bill without it posting to my assets right away. Yet, it isn’t an asset till I actually pay it. I was wanting to take advantage of the bills due reminder for this bill. I had to settle on waiting to post the bill until I actually make the payment and forgoing the reminder. That way, my assets weren’t inflated early. Otherwise, everything else works out fine. Regards, Adrien > On Dec 15, 2018, at 3:06 PM, tbalaban wrote: > > My Company pays an initial payment to our insurer at the beginning of each > policy year. As we incur insurance costs based on event participants, that > initial payment is charged. After it is exhausted we get a monthly bill for > the amount due. In no case do we ever get the initial payment back. > > I'd like to treat the initial payment as a credit to insurer's A/P account > then each month create a bill for the amount payable. > > Is this the correct way to handle such a transaction? > > Assuming it is, how do I credit the amount due from whatever account I > posted the initial payment to? > > In practice we pay the initial payment in February, the start of our paolicy > year. Usually, in April or May, the initial payment is exhaused and we have > to send more money to pay that month's bill. I'm not at all clear on how to > post this situation. > > I'd appreciate knowing how to do this in GNUCash as well as any comments on > the applicable general accounting rules. In Quickbooks I could debit or > credit A/R or A/P diectly and selects the customer or vendor required. Since > that capabiity does not appear to be available in GNUCash, how do I post it? > > Many thanks for your already generous help. > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How To Handle Prepayments
My Company pays an initial payment to our insurer at the beginning of each policy year. As we incur insurance costs based on event participants, that initial payment is charged. After it is exhausted we get a monthly bill for the amount due. In no case do we ever get the initial payment back. I'd like to treat the initial payment as a credit to insurer's A/P account then each month create a bill for the amount payable. Is this the correct way to handle such a transaction? Assuming it is, how do I credit the amount due from whatever account I posted the initial payment to? In practice we pay the initial payment in February, the start of our paolicy year. Usually, in April or May, the initial payment is exhaused and we have to send more money to pay that month's bill. I'm not at all clear on how to post this situation. I'd appreciate knowing how to do this in GNUCash as well as any comments on the applicable general accounting rules. In Quickbooks I could debit or credit A/R or A/P diectly and selects the customer or vendor required. Since that capabiity does not appear to be available in GNUCash, how do I post it? Many thanks for your already generous help. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] how to track Futures and Options
I carry options as a stock. Just multiply the contracts by 100 to show shares under options. Regarding commissions, I have a subaccount under the brokerage account labeled “Open Commissions”. When I execute an opening transaction, then the commission is debited to “Open Commissions”. I think of this as a prepaid expense. When I execute a closing transaction, the commission is debited to “Open Commissions” also. And here’s the trick. When I use the lots function to match the two parts of the transaction, I get a realized gain that is then adjusted by crediting the two “Open Commissions”. (I actually do one additional step, which is to change the above “Open Commissions” to “Closed Commissions-CYxx” where xx is the year of the realized gain/loss. By doing this, I have an automatic check that I have accounted for commissions correctly, as the balance of Closed Commissions should always be 0.) So my accounts look like this: Brokerage: AAPL 01/15/2021 230.00 C Transactions: Opening (Sell Call to Open) 09/19/2018 SCO AAPL 01/15/2021 230.00 C -1200. Brokerage:Cash38,379.55 Brokerage:Open Commissions 8.45 Brokerage:AAPL 01/15/2021 230.00 C -1200. 31.99 38,388.00 Closing (Buy Call to Close) 11/09/2018 BCC AAPL 01/15/2021 230.00 C 0. Brokerage:AAPL 01/15/2021 230.00 C 1200. 25.58 30,696.00 Brokerage: Open Commissions 12.90 Brokerage:Cash 30,78.90 After matching up lots 11/09/2018 Realized Gain AAPL 01/15/2021 230.00 C Brokerage:AAPL 01/15/2021 230.00 C 7,692.00 Brokerage:ShtTermCapGain 7,670.65 Brokerage:Open Commissions 8.45 Brokerage:Open Commissions 12.90 I then go back to each of the above transactions and change the “Brokerage:Open Commissions” to “Brokerage:Closed Commissions-CY18” This way, the “Open Commissions” account holds only unclosed transactions, and all “Closed Commissions-CYxx” are 0. (For best results, copy this message into a text file and view with a fixed size font so columns match up.) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Account Balance Changes When View Filter Is Applied
Bottom of the register page. On 12/15/2018 9:10 AM, John Ralls wrote: Please remember to copy the list on all replies. That doesn’t answer the question of what balance field you’re talking about, the running balance on each transaction line or the one at the bottom of the register page. Regards, John Ralls On Dec 15, 2018, at 7:40 AM, John Diaz wrote: I'm using GnuCash strictly as a check register. On the transaction register, if all transactions are displayed, the correct balance is shown. If I apply a filter to hide the reconciled transactions, the balance changes. On the 'Accounts' tab, under 'Assets' the balance for that account is always correctly displayed. I didn't notice this kind of behavior until I reconciled my account this month. I'm running version 3.2 (3.2 + 2018-06-24) on Windows 10. The work around is to display all transactions, but I'd prefer to hide the reconciled ones. On 12/14/2018 7:55 AM, John Ralls wrote: On Dec 13, 2018, at 7:00 AM, John Diaz wrote: When I apply the filter to hid the reconciled transactions, the balance shown on the account ledger changes. The correct balance shows on the 'Accounts' tab. Just noticed this behavior after reconciling my checkbook this morning. You mean the balance in the summary bar at the bottom of the register page, right? What version of GnuCash are you using? Regards, John Ralls --- This email has been checked for viruses by AVG. https://www.avg.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Account Balance Changes When View Filter Is Applied
Please remember to copy the list on all replies. That doesn’t answer the question of what balance field you’re talking about, the running balance on each transaction line or the one at the bottom of the register page. Regards, John Ralls > On Dec 15, 2018, at 7:40 AM, John Diaz wrote: > > I'm using GnuCash strictly as a check register. On the transaction register, > if all transactions are displayed, the correct balance is shown. If I apply > a filter to hide the reconciled transactions, the balance changes. On the > 'Accounts' tab, under 'Assets' the balance for that account is always > correctly displayed. I didn't notice this kind of behavior until I > reconciled my account this month. I'm running version 3.2 (3.2 + 2018-06-24) > on Windows 10. The work around is to display all transactions, but I'd > prefer to hide the reconciled ones. > > On 12/14/2018 7:55 AM, John Ralls wrote: >> >>> On Dec 13, 2018, at 7:00 AM, John Diaz wrote: >>> >>> When I apply the filter to hid the reconciled transactions, the balance >>> shown on the account ledger changes. The correct balance shows on the >>> 'Accounts' tab. Just noticed this behavior after reconciling my checkbook >>> this morning. >>> >> You mean the balance in the summary bar at the bottom of the register page, >> right? What version of GnuCash are you using? >> >> Regards, >> John Ralls >> > > --- > This email has been checked for viruses by AVG. > https://www.avg.com > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Power Outage affecting code (wiki/email/gncbot)
Hi, Shortly after 10pm EST last night we had a power outage here. This immediately affected our network and shortly thereafter the servers themselves. The power came back somewhere around 12:30am and most of the servers rebooted on their own. I am checking various services now, so if you notice something still missing please let me know. Sorry for the inconvenience. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.