[GNC] Importing XLM into GNUCash
Dear community members, I am very new to GNUCash and here might be a dumb question to ask. We are using Logitude software to keep track of our invoices. They are exportable XML format. Is there a way to import XML into GNUCash? Since the import function does not support that (I only saw QIF/FIX/CSV…etc). Any help could be appreciated! Best, Gary ___ 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] Importing XLM into GNUCash
I am new to this mailing list although I have used GnuCash for years. I don't know if there exists a current solution to importing xml data, but it would seem to me to be a simple matter to write a translator that could convert xml into csv or some other format. Most languages (python, ruby, perl) have support for reading xml. Writing csv is easy. Will On 2020 Jun 2, at 06-02 20:42:00, Daming Gao wrote: Dear community members, I am very new to GNUCash and here might be a dumb question to ask. We are using Logitude software to keep track of our invoices. They are exportable XML format. Is there a way to import XML into GNUCash? Since the import function does not support that (I only saw QIF/FIX/CSV…etc). Any help could be appreciated! Best, Gary ___ 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] Can Finance::Quote look up bond prices by CUSIP?
Can Finance::Quote be used to look up bond prices? If so, how can I configure the security in GnuCash to get this done? A related question is how can I use it to fetch currency prices. Thanks! -Peter ___ 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] Can Finance::Quote look up bond prices by CUSIP?
Hello Peter, there are already sections in Help and Guide: https://www.gnucash.org/docs/v3/C/gnucash-help/set-prefs.html#prefs-online-quotes https://www.gnucash.org/docs/v3/C/gnucash-help/fq-sources.html#fq-sources-single https://www.gnucash.org/docs/v3/C/gnucash-guide/invest-stockprice1.html#invest-stockprice-auto2 https://www.gnucash.org/docs/v3/C/gnucash-guide/currency_howto1.html#currency_howto_Auto and a wiki page: https://wiki.gnucash.org/wiki/Online_Quotes We are open for sugestions to improve them. Regards Frank Am 03.06.20 um 16:52 schrieb peterb: > Can Finance::Quote be used to look up bond prices? If so, how can I > configure the security in GnuCash to get this done? > > A related question is how can I use it to fetch currency prices. > > Thanks! > > -Peter ___ 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] Tracking a health reimbursement arrangement
Hello, I am new to this list. I have not quite seen an answer to my scenario in the archives that I've seen online, so thought I'd join the list and ask. I'm in the USA, and my employer offers a Dental/Vision health reimbursement account. Each year, the employer will reimburse up to $200 for each person in my family to use for dental/vision. When I use the benefit, I put the charge on a credit card, then submit a reimbursement form, and then the company writes me a check. Right now, I'm just using an A/R account to basically zero-out the difference between the credit card charges and the deposits of the reimbursement checks. The benefit of doing it this way is that it doesn't show up on my monthly income statement as an expense that corresponds to some income. Details below: First, my account structure: Assets:Checking Liabilities:Credit Card Assets:Receivable:Health Reimbursement Arrangement Transactions: Medical appointment: Debit -> Liabilities:Credit Card Credit -> Assets:Receivable:Health Reimbursement Arrangement Reimbursement: Credit -> Assets:Checking Debit -> Assets:Receivable:Health Reimbursement Arrangement What I'd like to do, though, is figure out a way to track how much is left for each person in the family. The fiscal year for this HRA begins on July 1, so theoretically I'd like to be able to post an "employer contribution" on July 1 and then have these sorts of expenses debit away that amount. If I ever fail to totally use up my allowance in a year, I guess I'd just make a write-off expense account or something. But I can't figure out where to create an account for tracking the unspent money in the HRA. Thanks for any suggestions! Duncan ___ 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] Importing XLM into GNUCash
Will In a sense GnuCash does import xml as its main datafile is stored as an xml file if you are not using the database backends. XML is possibly a bit too wordy for general use as you have two tags in addition to the data for each piece of data. you cannot use random tags - the program has to know how to interpret the tags. GnuCash also does import OFX and QFX files which are XML files using a set of tags defined in the OFX specification for the exchange of finacial data. You could always format data for import as OFX but it has a lot of extraneous data identifying the sourceof the data and purpose that has to be supplied. CSV is generlly far easierto setup and import. David Cousens On Wed, 2020-06-03 at 08:17 -0500, w...@theprescotts.com wrote: > I am new to this mailing list although I have used GnuCash for years. I don't > know if there exists a current solution > to importing xml data, but it would seem to me to be a simple matter to write > a translator that could convert xml into > csv or some other format. Most languages (python, ruby, perl) have support > for reading xml. Writing csv is easy. > > Will > > On 2020 Jun 2, at 06-02 20:42:00, Daming Gao wrote: > > Dear community members, > > I am very new to GNUCash and here might be a dumb question to ask. > > We are using Logitude software to keep track of our invoices. They are > exportable XML format. Is there a way to import > XML into GNUCash? Since the import function does not support that (I only saw > QIF/FIX/CSV…etc). > > Any help could be appreciated! > > Best, > Gary > > ___ > 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. -- Dr David R Cousens B.Sc, M.Prof. Acc., Ph.D., G.C.Ed ___ 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] Tracking a health reimbursement arrangement
For starters, it looks like your Debits and Credits for the transactions and reimbursements are backwards, When you use a card to pay for something, you credit the card account and debit an expense. In this case, you are taking on a liability (card debt) on behalf of someone else. (the reimbursement asset) So that should be: Dr. Assets:Receivable:Health Reimbursement Arrangement Cr. Liabilities:Credit Card Note: Credits increase liabilities. You’ve increased your liability (debt) on the card, so that has to be a credit. Debits increase assets. When you pay with the card (up to the $200 limit), you are promised to be reimbursed. That is an asset for you. So it has to be debited to increase it. Then you receive the reimbursement you want to increase one asset (Checking) and decrease another (amount still to be reimbursed). So that would look like: Dr. Assets:Checking Cr. Assets:Receivable:Health Reimbursement Arrangement -- Another way to treat this is that the reimbursement is a source of funds to be used. (and is easier to track how much is left to use) That can still be tracked as an asset, but instead of only recording when you make the payment, you record the promise of it up front. So at the anniversary of the $200 rollover: Dr. Assets:Receivable:Health Reimbursement Arrangement:Person_1 $200 Dr. Assets:Receivable:Health Reimbursement Arrangement:Person_2 $200 ... Dr. Assets:Receivable:Health Reimbursement Arrangement:Person_n $200 Cr. Assets:Receivable:Health Reimbursement Arrangement $200*n Note that each person has a sub-account for individual tracking purposes. Also note, these initial ‘fundings’ are balanced out against the parent account, essentially making this entire part of the account tree ‘zero'. (technically, the funds are promised, but aren’t legally owed in any sense until you incur the expenses first) When you pay for covered dental/health visits on your credit card, do this instead: Dr. Expenses:Dental/Vision (as desired/needed) Dr. Assets:Receivable:Health Reimbursement Pending Cr. Liabilities:Credit Card Cr. Assets:Receivable:Health Reimbursement Arrangement:Person_X This will record the payment as your expense. (it really is yours, not your employers) It will record you temporarily paying for the expense via your card. (which you did) It will reduce the amount left available to be reimbursed per person. It will track how much is now a real asset waiting to be received. When you receive the reimbursement check: Dr. Assets:Checking Cr. Assets:Receivable:Health Reimbursement Pending This will increase the checking account and decrease the amount still pending to be reimbursed. The 'Health Reimbursement Pending’ is what is known as a ’suspense account’ and is used to track funds owed or owing but which haven’t technically changed hands yet. Another example would be an ‘undeposited funds’ account which some people use to record the receipt of checks, pending their deposit into the checking account. (this helps keep real-world accounts accurate while allowing for the time delays in physically making the deposit, clearing is a separate function) If you instantly ‘deposit’ checks via a smart-app, you may not need an ‘undeposited funds’ account. If you used one, it would be an additional transaction to record the actual deposit to checking. (the reimbursement would be debited to the undeposited funds account instead) When it is time to rollover the HRA, you can do something like this: Dr. Assets:Receivable:Health Reimbursement Arrangement (total unused) Cr. Assets:Receivable:Health Reimbursement Arrangement:Person_1 (balance) Cr. Assets:Receivable:Health Reimbursement Arrangement:Person_2 (balance) ... Cr. Assets:Receivable:Health Reimbursement Arrangement:Person_n (balance) That will still leave a balance in the parent account, for anything reimbursed. You could employ something like this as the final transaction for the year: Dr. Assets:Receivable:Health Reimbursement Arrangement Cr. Assets:Receivable:Health Reimbursement Arrangement:Used This would also give you an annual tally in one transaction of how much was reimbursed for the whole family without any report or filtering gymnastics. - Some may advise to put the 'Health Reimbursement Arrangement’ and personal sub accounts under Equity, or even a new top-level account (of type Equity or Asset) called Reimbursements or Budgeting, etc. There might even be a case for putting it under Expenses in some form. Be cautious too, that there might be tax implications for how this is setup and how the funds are handled and recorded. Be certain to get professional advice before going too far with any method. The above are just outlining possible options. They may not all be allowed. Regards, Adrien > On Jun 3, 2020 w23d
Re: [GNC] Tracking a health reimbursement arrangement
On 6/3/2020 4:56 PM, Duncan Johnson wrote: Hello, I am new to this list. I have not quite seen an answer to my scenario in the archives that I've seen online, so thought I'd join the list and ask. I'm in the USA, and my employer offers a Dental/Vision health reimbursement account. Each year, the employer will reimburse up to $200 for each person in my family to use for dental/vision. When I use the benefit, I put the charge on a credit card, then submit a reimbursement form, and then the company writes me a check. That's one way to do it. The decision on "best way" has to be made by each person and depends on exactly what information they want to be readily available. I am also in a similar situation PLUS have certain medical/dental/eye reimbursements from insurance as well as an HSA. Let's suppose that I wanted (like you) not to have reimbursements appear as income (they aren't) BUT also wanted to know actual medical expenses before reimbursement << there could be good reason for this -- making decisions for a future year >> Then I might have a parent in expenses "out of pocket medical" and under it "pre-reimbursement" with children for medical, dental, etc. and then a "reimbursements" which would be a contra account << credited for reimbursements>> Then I have an account that shows what the actual medical expenses were (and how broken down by category) plus an account (that top parent) showing "out of pocket" expense for medical (after reimbursement) plus what the actual medical expenses were. The key thing here is understanding that "income" and "expense" are both temporary accounts of fundamental type equity. They differ from each other only in what their NORMAL balance would be, debit or credit. Identification of these accounts as "income" or "expense" is only to place them in the P&L Report. Michael D Novack ___ 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] Importing XLM into GNUCash
Technically, XML files either follow a companion style sheet or follow an implicit style predetermined specifically for a given application. GnuCash applicable files and OFX files are both of the second type. There is no expectation that a XML type file not created explicitly for either of those applications or for any of the dozens of other applications could be read by a different application than the target application. You might compare XML to English or Chinese, rather than to assembly or Fortran or C. David Carlson On Wed, Jun 3, 2020, 4:42 PM David Cousens wrote: > Will > > In a sense GnuCash does import xml as its main datafile is stored as an > xml file if you are not using the database > backends. XML is possibly a bit too wordy for general use as you have two > tags in addition to the data for each piece of > data. you cannot use random tags - the program has to know how to > interpret the tags. GnuCash also does import OFX and > QFX files which are XML files using a set of tags defined in the OFX > specification for the exchange of finacial data. > You could always format data for import as OFX but it has a lot of > extraneous data identifying the sourceof the data and > purpose that has to be supplied. CSV is generlly far easierto setup and > import. > > David Cousens > > On Wed, 2020-06-03 at 08:17 -0500, w...@theprescotts.com wrote: > > I am new to this mailing list although I have used GnuCash for years. I > don't know if there exists a current solution > > to importing xml data, but it would seem to me to be a simple matter to > write a translator that could convert xml into > > csv or some other format. Most languages (python, ruby, perl) have > support for reading xml. Writing csv is easy. > > > > Will > > > > On 2020 Jun 2, at 06-02 20:42:00, Daming Gao > wrote: > > > > Dear community members, > > > > I am very new to GNUCash and here might be a dumb question to ask. > > > > We are using Logitude software to keep track of our invoices. They are > exportable XML format. Is there a way to import > > XML into GNUCash? Since the import function does not support that (I > only saw QIF/FIX/CSV…etc). > > > > Any help could be appreciated! > > > > Best, > > Gary > > > > ___ > > 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. > -- > Dr David R Cousens > B.Sc, M.Prof. Acc., Ph.D., G.C.Ed > > ___ > 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] Importing XLM into GNUCash
> On Jun 2, 2020, at 6:42 PM, Daming Gao wrote: > > Dear community members, > > I am very new to GNUCash and here might be a dumb question to ask. > > We are using Logitude software to keep track of our invoices. They are > exportable XML format. Is there a way to import XML into GNUCash? Since the > import function does not support that (I only saw QIF/FIX/CSV…etc). > > Any help could be appreciated! Well, GnuCash's default file format uses XML, but that doesn't mean that it can understand arbitrary XML emitted by any other program. XML is a language for creating data formats, not a format in itself. GnuCash can import invoices but they must be in something resembling a comma-separated-value format with the columns in a specific order. Regards, John Ralls ___ 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] Can Finance::Quote look up bond prices by CUSIP?
Currency exchange rates are easy and this documentation should help. I don't know of any way to get bond prices, but I haven't tried every source. It used to be possible, but it stopped working a few years ago. Mike On 3 Jun 2020, at 14:34, Frank H. Ellenberger wrote: Hello Peter, there are already sections in Help and Guide: https://www.gnucash.org/docs/v3/C/gnucash-help/set-prefs.html#prefs-online-quotes https://www.gnucash.org/docs/v3/C/gnucash-help/fq-sources.html#fq-sources-single https://www.gnucash.org/docs/v3/C/gnucash-guide/invest-stockprice1.html#invest-stockprice-auto2 https://www.gnucash.org/docs/v3/C/gnucash-guide/currency_howto1.html#currency_howto_Auto and a wiki page: https://wiki.gnucash.org/wiki/Online_Quotes We are open for sugestions to improve them. Regards Frank Am 03.06.20 um 16:52 schrieb peterb: Can Finance::Quote be used to look up bond prices? If so, how can I configure the security in GnuCash to get this done? A related question is how can I use it to fetch currency prices. Thanks! -Peter ___ 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.
