[GNC] Importing Accounts
TLDR; Create a new file choosing one of the template accounts to use as a basis to export account tree as csv then modify as required. The GnuCash csv conventions don't apply to the coa csv file. Specifically: 1. It must have a header line 2. iirc all fields must be included even though most of them are blank 3. Parent accounts must be created before the children Despite the format the process of creating accounts from csv is the smoothest of all csv imports. Regards ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 Accounts
To understand the account tree it is advised to export the account structure and use it as a reference. please find attached a sample Saludos Cordiales Murugan From: gnucash-user on behalf of Chris Miller via gnucash-user Sent: 22 September 2024 15:30 To: gnucash-user Subject: [GNC] Importing Accounts Hi Folks, I am importing accounts. The third step of the import dialog shows a row with column headers. Does my import CSV file have to use that *order*, or simply use those *names*? If "order" is discretionary, can I create a column mapping with the first row? Will the "Import Map Editor" do that for me? Traditionally, CSV can map columns in any arbitrary order, but I don't know how much I can assume about this process. Specifically, the import dialog shows these columns (Many of these are almost self-explanatory.): Type: Almost Self-explanatory. What are the precise keywords and where do I find them? Account Full Name: Is this simply documentation, or does the "Full Name" include "Par1:Par2:Acct"? Account Name: Self-explanatory Account Code: This looks like a number for creating numerical hierarchies. Can I ignore this, if I'm using "sub-accounts"? Description: Self-explanatory Account Color: Self-explanatory Notes: Self-explanatory Symbol: Can I assume this names portfolio instruments, and is not part of general ledger expense/income accounting? Namespace: Is this the parent path when creating sub-accounts? Will "import" create parents as necessary? Hidden: Self-explanatory Tax Info: This is obviously for export to tax-prep software. What are the permitted values, and where can I find them? Placeholder: Self-explanatory Thanks for the help, -- Chris. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C1f5f17d6a3484bdf14fc08dcdb34c989%7C84df9e7fe9f640afb435%7C1%7C0%7C638626266991464161%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=DnFnKO829dow2FOzx8kn7R26eeCOTslh%2Fn2Ndpnnxpo%3D&reserved=0<https://lists.gnucash.org/mailman/listinfo/gnucash-user> - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. Type,Full Account Name,Account Name,Account Code,Description,Account Color,Notes,Symbol,Namespace,Hidden,Tax Info,Placeholder ASSET,Assets,Assets,,Assets,,,USD,CURRENCY,F,F,T ASSET,Assets:Current Assets,Current Assets,,Current Assets,,,USD,CURRENCY,F,F,T CASH,Assets:Current Assets:Cash in Wallet,Cash in Wallet,,Cash in Wallet,,,USD,CURRENCY,F,F,F CASH,Assets:Current Assets:Petty Cash,Petty Cash,,Petty Cash,,,USD,CURRENCY,F,F,F BANK,Assets:Current Assets:Checking Account,Checking Account,,Checking Account,,,USD,CURRENCY,F,F,F BANK,Assets:Current Assets:Savings Account,Savings Account,,Savings Account,,,USD,CURRENCY,F,F,F RECEIVABLE,Assets:Accounts Receivable,Accounts Receivable,,Accounts Receivable,,,USD,CURRENCY,F,F,F LIABILITY,Liabilities,Liabilities,,Liabilities,,,USD,CURRENCY,F,F,T CREDIT,Liabilities:Credit Card,Credit Card,,Credit Card,,,USD,CURRENCY,F,F,F PAYABLE,Liabilities:Accounts Payable,Accounts Payable,,Accounts Payable,,,USD,CURRENCY,F,F,F INCOME,Income,Income,,Income,,,USD,CURRENCY,F,F,T INCOME,Income:Bonus,Bonus,,Bonus,,,USD,CURRENCY,F,F,F INCOME,Income:Gifts Received,Gifts Received,,Gifts Received,,,USD,CURRENCY,F,F,F INCOME,Income:Interest Income,Interest Income,,Interest Income,,,USD,CURRENCY,F,F,T INCOME,Income:Interest Income:Checking Interest,Checking Interest,,Checking Interest,,,USD,CURRENCY,F,F,F INCOME,Income:Interest Income:Other Interest,Other Interest,,Other Interest,,,USD,CURRENCY,F,F,F INCOME,Income:Interest Income:Savings Interest,Savings Interest,,Savings Interest,,,USD,CURRENCY,F,F,F INCOME,Income:Other Income,Other Income,,Other Income,,,USD,CURRENCY,F,F,F INCOME,Income:Reimbursed Expenses,Reimbursed Expenses,,Reimbursed Expenses,,,USD,CURRENCY,F,F,F INCOME,Income:Salary,Salary,,Salary,,,USD,CURRENCY,F,F,F INCOME,Income:Sales,Sales,,Sales,,,USD,CURRENCY,F,F,F EXPENSE,Expenses,Expenses,,Expenses,,,USD,CURRENCY,F,F,T EXPENSE,Expenses:Adjustment,Adjustment,,Adjustment,,,USD,CURRENCY,F,F,F EXPENSE,Expenses:Auto,Auto,,Auto,,,USD,CURRENCY,F,F,T EXPENSE,Expenses:Auto:Fees,Fees,,Fees,,,USD,CURRENCY,F,F,F EXPENSE,Expenses:Auto:Fuel,Fuel,,"Gas, diesel, LPG â¦",,"Create subaccounts for each used type, if desired.",USD,CURRENCY,F,F,F EXPENSE,Expenses:Auto:Parking,Parking,,Parking,,,USD,CURRENCY,F,F,F EXPENSE,Expenses:Auto:Repair and Maintenance,Repair and Maintenance,,Repair and Maintenance,,,USD,CURRENCY,F,F,F EXPENSE,Expenses:Bank Service Ch
[GNC] Importing Accounts
Hi Folks, I am importing accounts. The third step of the import dialog shows a row with column headers. Does my import CSV file have to use that *order*, or simply use those *names*? If "order" is discretionary, can I create a column mapping with the first row? Will the "Import Map Editor" do that for me? Traditionally, CSV can map columns in any arbitrary order, but I don't know how much I can assume about this process. Specifically, the import dialog shows these columns (Many of these are almost self-explanatory.): Type: Almost Self-explanatory. What are the precise keywords and where do I find them? Account Full Name: Is this simply documentation, or does the "Full Name" include "Par1:Par2:Acct"? Account Name: Self-explanatory Account Code: This looks like a number for creating numerical hierarchies. Can I ignore this, if I'm using "sub-accounts"? Description: Self-explanatory Account Color: Self-explanatory Notes: Self-explanatory Symbol: Can I assume this names portfolio instruments, and is not part of general ledger expense/income accounting? Namespace: Is this the parent path when creating sub-accounts? Will "import" create parents as necessary? Hidden: Self-explanatory Tax Info: This is obviously for export to tax-prep software. What are the permitted values, and where can I find them? Placeholder: Self-explanatory Thanks for the help, -- Chris. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 Data
Hi David, > The CSV importer can also work with tab separated data. There is a > setup screen in which you can set the separator so there is no need to > change it. Yes. There was an option to change the separator, but "tab" was not one of the choices. See the dialog below. > The confusion may be that there are two import processes The "File ==> > Import ==> Accounts" process imports an account tree structure that has > been exported from either GnuCash or another program or just built up > in a spreadshett. Yes. Exactly. Among the differences is the rigidity of column headers. They seem to be defined, meaning I'm going to have to hack my accounts.IIF, and now, apparently, not only to satisfy field separators. Here is the "Account" process: So, I need to find the docs to tell me what these fields mean, and I'm going to have to hack my IIF to correct the separator and order of fields, at a minimum. It would probably be easiest to do that with a spreadsheet, but I'm still going to need those field explanations ... Any thoughts? > I am not familiar with the IIF format I'm pretty sure it is simply a special case of the CSV, meaning a special set of columns. Thanks for the help, -- Chris. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 Data
Hi Murugan, > Please refer the following link for the steps to import transactions > [ https://lists.gnucash.org/docs/C/gnucash-manual/trans-import.html | > https://lists.gnucash.org/docs/C/gnucash-manual/trans-import.html ] As I have said, I'm importing "Accounts", not "Transactions" . These are different. Thanks for the help, -- Chris. V:916.799.9461 F:916.974.0428 A: Because we read from top to bottom, left to right. Q: > Why should I start my reply below the quoted text? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 Data
Please refer the following link for the steps to import transactions https://lists.gnucash.org/docs/C/gnucash-manual/trans-import.html Saludos Cordiales Murugan From: Chris Miller Sent: 21 September 2024 22:21 To: Murugan Mariappan Cc: gnucash-user Subject: Re: Importing Data Hi Folks, There are couple of steps and queries 1. Create the account structure in GNC. you can import your existing structure if you have a file for the same I was very much hoping that "File ==> Import ==> Accounts from CSV" would do that. On the column mapping it is straight forward, the import window will allow you to map the columns in GNU. Apparently not. I am not seeing the opportunity when I go to "File ==> Import ==> Accounts from CSV" Thanks for the help, -- Chris. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 Data
Hi Folks, > There are couple of steps and queries > 1. > Create the account structure in GNC. you can import your existing structure if > you have a file for the same I was very much hoping that "File ==> Import ==> Accounts from CSV" would do that. > On the column mapping it is straight forward, the import window will allow you > to map the columns in GNU. Apparently not. I am not seeing the opportunity when I go to "File ==> Import ==> Accounts from CSV" Thanks for the help, -- Chris. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 Data
There are couple of steps and queries 1. Create the account structure in GNC. you can import your existing structure if you have a file for the same 2. The account balance you mentioned does it come with a sign (negative or positive) depending on the account type or does it give debit , credit balance in seperate columns? This is critical for GNU to identify the correct entry On the column mapping it is straight forward, the import window will allow you to map the columns in GNU. After the mapping of columns on the next screen you will have the option to select the counter account, in your case of opening balance you can choose equity account Saludos Cordiales Murugan From: gnucash-user on behalf of Chris Miller via gnucash-user Sent: 21 September 2024 22:02 To: gnucash-user Subject: [GNC] Importing Data Hi Folks, QuickBooks does not give up its data graciously, but it will export many things as an IIF -- "Intuit Interchange File", which is almost like a "CSV", except with "tab" instead of "comma". I can replace the "tab" with ";" and I'm good to go. Almost. The first line is a header to identify the fields of the subsequent lines in the file. GNC does not understand IIF, but does understand CSV, and IIF is just a specialized CSV. Since one of the things I can get from QuickBooks is a chart of accounts with current balance, I have a place to start, but I need to understand more than I do. How do I map the existing "column" headers in the erstwhile IIF to columns that GNC understands? How do I know what that mapping is? I can't just assert an account balance; there has to be a complimentary entry to "Equity:Opening Balance", so how does that happen? I'm almost ready to light this candle. Thanks for the help, -- Chris. V:916.799.9461 F:916.974.0428 A: Because we read from top to bottom, left to right. Q: > Why should I start my reply below the quoted text? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C9d4baeb7df2248c4213208dcdaa25d69%7C84df9e7fe9f640afb435%7C1%7C0%7C638625638107859208%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=pLs54GU0mPv6DqLG8bXWKCG8BLlaNIvxKipHBufrkAE%3D&reserved=0<https://lists.gnucash.org/mailman/listinfo/gnucash-user> - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Importing Data
Hi Folks, QuickBooks does not give up its data graciously, but it will export many things as an IIF -- "Intuit Interchange File", which is almost like a "CSV", except with "tab" instead of "comma". I can replace the "tab" with ";" and I'm good to go. Almost. The first line is a header to identify the fields of the subsequent lines in the file. GNC does not understand IIF, but does understand CSV, and IIF is just a specialized CSV. Since one of the things I can get from QuickBooks is a chart of accounts with current balance, I have a place to start, but I need to understand more than I do. How do I map the existing "column" headers in the erstwhile IIF to columns that GNC understands? How do I know what that mapping is? I can't just assert an account balance; there has to be a complimentary entry to "Equity:Opening Balance", so how does that happen? I'm almost ready to light this candle. Thanks for the help, -- Chris. V:916.799.9461 F:916.974.0428 A: Because we read from top to bottom, left to right. Q: > Why should I start my reply below the quoted text? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Importing QFX with no transaction, only position/price updates?
Hey y'all - I'm doing a round of quarterly (yes I'm late for Q2/early for Q3) updates, and the QFX I have downloaded from my retirement account manager (TIAA/CREF) contains no actual transactions, only position updates with prices. This is correct, I've recently retired, so contributions have stopped. When I import the file in my standard book, nothing seems to happen. Checking the terminal (I'm a Linux user and launch from there) I see some INFO lines from LibOFX of the form "Created OfxDummyContainer to hold unsupported aggregate FOOBAR" for various values of FOOBAR. Nothing else happens. If I import into a brand new book, I get all the dialog prompts for creating securities and accounts, then ... nothing. The accounts and securities get created, but there are no transactions (expected) and no entries in the price database. Running with --debug shows a bunch of info, and three errors related to transactions: * 15:55:51 ERROR [ofx_proc_transaction_cb()] The transaction doesn't have a valid amount * 15:55:51 ERROR [ofx_proc_transaction_cb()] The transaction doesn't have a valid amount * 15:55:51 ERROR [ofx_proc_transaction_cb()] The transaction doesn't have a valid amount Digging into the QFC w/ ofxdump, I see exactly three transactions, all of type TRANSFER, with # of units: 0.000, and a memo of "Balance Update" so I think we can ignore them. What I'm interested in is there are a bunch of ofx_proc_position entries, with Unit prices and Date of Unit Price. Was hoping these would be imported into the price database. Digging through the code in gnucash/import-export/ofx/* I see nothing about positions. Heading deeper down the rabbit hole, I see libofx added support for POSITION entries in v 0.10.0 (2021). So I guess if I want convenient import of security prices, I'll have to brush up my C++ skills, and dust off the compiler. Any words of wisdom from more experienced GnuCash users, here? Ross Reedstrom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help with importing into GnuCash
Some previous discussions of this: https://lists.gnucash.org/pipermail/gnucash-user/2015-April/060025.html https://lists.gnucash.org/pipermail/gnucash-user/2019-April/083773.html https://lists.gnucash.org/pipermail/gnucash-user/2011-August/040761.html These are just a sample of the ideas available on this topic. You should try searching the archives of this list via the following: https://lists.gnucash.org/search/?idxinfo=gnucash-user You'll find many pages of past queries like your own. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help with importing into GnuCash
There is lot of knowledge base available for Quick book conversion, if you have specific queries please send it here and you will get guidance immediately Saludos Cordiales Murugan From: gnucash-user on behalf of Dr Lawrence M Fox Sent: 14 September 2024 14:22 To: gnucash-user@gnucash.org Subject: [GNC] Help with importing into GnuCash I would like to run GnuCash in tandem with QuickBooks Enterprise for a couple months just to see if GnuCash will work for me. I can export the Chart of Accounts, Vendors, Customers and Transactions, but I am next to clueless as to how to import (I've tried). Is there someone knowledgeable here who would be willing to do it for me for a fee? Thanks -- ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C5fb5e6fd748b4908df9708dcd4e1f1f9%7C84df9e7fe9f640afb435%7C1%7C0%7C638619314125193161%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=r%2FIbyTGFcefZtgDMbhMzo0oF%2BUqiANX2iBrHGubgziI%3D&reserved=0<https://lists.gnucash.org/mailman/listinfo/gnucash-user> - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Help with importing into GnuCash
I would like to run GnuCash in tandem with QuickBooks Enterprise for a couple months just to see if GnuCash will work for me. I can export the Chart of Accounts, Vendors, Customers and Transactions, but I am next to clueless as to how to import (I've tried). Is there someone knowledgeable here who would be willing to do it for me for a fee? Thanks -- ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 Transactions
Hi Ron, Go to edit-> pref-> import and read what the 'default transaction status' is set to. ~mark petryk ~w:http://www.lorimarksolutions.com On 8/13/24 08:47, Ronald Solomon wrote: I am just starting with Gnucash. I was importing transactions one month at a time. January and February of 2024 went okay. They were balanced and reconciled. When I did March the totals for February were changed and it took me hours to figure out that transactions in February were changed even when they had been reconciled. the same happened for April except it was both March and February. I think this is a bug. Let me know what you guys think. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Importing Transactions
I am just starting with Gnucash. I was importing transactions one month at a time. January and February of 2024 went okay. They were balanced and reconciled. When I did March the totals for February were changed and it took me hours to figure out that transactions in February were changed even when they had been reconciled. the same happened for April except it was both March and February. I think this is a bug. Let me know what you guys think. -- Ron Solomon DC Integrative Health PHMA PA Phone 252 671 2306 Fax 252 69310684 The reason you have a headache is not that you need more aspirin. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 causes 'y' in reconciliation?
do not know, sir, but I will find out :) ~mark petryk ~w:http://www.lorimarksolutions.com On 8/1/24 16:28, David Cousens wrote: Mark there is a preference setting on the Edit->_Preferences_->Import tab that sets the default status on imported transactions What was that setting at during the import? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 causes 'y' in reconciliation?
Mark there is a preference setting on the Edit->_Preferences_->Import tab that sets the default status on imported transactions What was that setting at during the import? On Thu, 2024-08-01 at 13:01 -0500, Mark at Lorimark wrote: > Helping someone out with their new GnuCash experience, regarding > importing and reconciliation. He reports that after an import, the > reconciliation balances are off, and the account balances are off. > > I looked at his register, and he had reconciled 5 months or so, and > then > following those reconciled transaction, were 'c' and 'n' type > transaction, and then intermixed with those were some also 'y' > transactions. > > We're not sure how that happened. Does importing set the > reconciliation > status to 'y' at any time for any reason? > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 causes 'y' in reconciliation?
Sounds like a bug. Stephen M Butler stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 8/1/24 12:58, Mark at Lorimark wrote: Hi Steve, yes but this seems like it's setting the R to 'y' which is really odd to me. I can see setting it to 'c', but not 'y'. Thank you for your reply. ~mark petryk ~w:http://www.lorimarksolutions.com On 8/1/24 14:01, Stephen M. Butler wrote: On 8/1/24 11:01, Mark at Lorimark wrote: Helping someone out with their new GnuCash experience, regarding importing and reconciliation. He reports that after an import, the reconciliation balances are off, and the account balances are off. I looked at his register, and he had reconciled 5 months or so, and then following those reconciled transaction, were 'c' and 'n' type transaction, and then intermixed with those were some also 'y' transactions. We're not sure how that happened. Does importing set the reconciliation status to 'y' at any time for any reason? Yes, depending on which boxes you checked during the import. Since most times you are importing from the "authenticating source", you want the import to go ahead and set the flag that this has been "cleared" at the source. It may also find that you already had that transaction (such as a payment to the CC) and it will then simply Match&Clear rather than loading a whole new transaction. By changing the check boxes you can change that behavior. --Steve ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - 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 - 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 causes 'y' in reconciliation?
Hi Steve, yes but this seems like it's setting the R to 'y' which is really odd to me. I can see setting it to 'c', but not 'y'. Thank you for your reply. ~mark petryk ~w:http://www.lorimarksolutions.com On 8/1/24 14:01, Stephen M. Butler wrote: On 8/1/24 11:01, Mark at Lorimark wrote: Helping someone out with their new GnuCash experience, regarding importing and reconciliation. He reports that after an import, the reconciliation balances are off, and the account balances are off. I looked at his register, and he had reconciled 5 months or so, and then following those reconciled transaction, were 'c' and 'n' type transaction, and then intermixed with those were some also 'y' transactions. We're not sure how that happened. Does importing set the reconciliation status to 'y' at any time for any reason? Yes, depending on which boxes you checked during the import. Since most times you are importing from the "authenticating source", you want the import to go ahead and set the flag that this has been "cleared" at the source. It may also find that you already had that transaction (such as a payment to the CC) and it will then simply Match&Clear rather than loading a whole new transaction. By changing the check boxes you can change that behavior. --Steve ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - 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 causes 'y' in reconciliation?
On 8/1/24 11:01, Mark at Lorimark wrote: Helping someone out with their new GnuCash experience, regarding importing and reconciliation. He reports that after an import, the reconciliation balances are off, and the account balances are off. I looked at his register, and he had reconciled 5 months or so, and then following those reconciled transaction, were 'c' and 'n' type transaction, and then intermixed with those were some also 'y' transactions. We're not sure how that happened. Does importing set the reconciliation status to 'y' at any time for any reason? Yes, depending on which boxes you checked during the import. Since most times you are importing from the "authenticating source", you want the import to go ahead and set the flag that this has been "cleared" at the source. It may also find that you already had that transaction (such as a payment to the CC) and it will then simply Match&Clear rather than loading a whole new transaction. By changing the check boxes you can change that behavior. --Steve ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Importing causes 'y' in reconciliation?
Helping someone out with their new GnuCash experience, regarding importing and reconciliation. He reports that after an import, the reconciliation balances are off, and the account balances are off. I looked at his register, and he had reconciled 5 months or so, and then following those reconciled transaction, were 'c' and 'n' type transaction, and then intermixed with those were some also 'y' transactions. We're not sure how that happened. Does importing set the reconciliation status to 'y' at any time for any reason? -- ~mark petryk ~w:http://www.lorimarksolutions.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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Example of importing Stock transactions from CSV
This post is from the https://lists.gnucash.org/pipermail/gnucash-user/2024-July/112463.html thread with discussion moving in a different direction. https://lists.gnucash.org/pipermail/gnucash-user/2024-July/112470.html Greg Julius wrote: > FWIW, I really struggled with this to figure out what was wrong with my > imports. There is a Commodity field and there is a Currency field. I had > to repeatedly fill in fields until I found the issue was Currency. Greg, Are you suggesting this is a Commodity/Currency field issue? I've added the full process from the linked bug report - see RIO near the end. My GnuCash file has transactions from previous years that were imported properly. https://lists.gnucash.org/pipermail/gnucash-user/2022-August/102562.html > >> The three lines below *work* using a Multi-split import - based on >> https://bugs.gnucash.org/show_bug.cgi?id=797450 >> Save *PP-Demo_Transactions_Minimal_Priced2.csv*: >> Date,Description,Action,Account,Deposit,Rate/Price >> 01/02/2021,RIO,,Assets:Broker:Funds,-9912.53 >> ,,Buy,Assets:Broker:Shares:RIO,89,8900/991253 > > GnuCash (brackets at end of line show changes for V5.8) > File, New > Cancel > Tools, Security Editor > Securities: Add > New security > Full Name: RIO > Symbol: RIO > Type: ASX (Namespace) > OK > Close > File, Import, Transactions from CSV > Next, PP-Demo_Transactions_Minimal.csv, Next > Multi-split, DateFormat, Leading Lines to Skip 1, > Date, Description, Action, Account, Deposit, Price (Amount instead of > Deposit) > Next > Map Account ID to Account Name > Change GnuCash Account, New Account > > Manually parse the accounts at ":" Creating new accounts until they are > done. > RIO is Account Type: Stock, Security: RIO, OK (Note security Namespace: > ASX) > Next (If New Book Options is displayed just Close), Next > Ignore UNBALANCED, Apply, Close > If it was UNBALANCED then Import was not successful. Interestingly, this previously working file now has three field errors (Date, Amount, Price): > Save PP-Demo_Transactions_Minimal_Priced.csv > Date,Description,Action,Account,Deposit,Rate/Price > 01/02/2021,RIO,,Assets:Broker:Funds,-9912.53 > ,,Buy,Assets:Broker:Shares:RIO,89,111 + 3353/8900 Regards ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 to Gnucash
When you are at the 'Import Preview' window/step, you can click on the arrow pointing downward next to label of each column which will expand to all available assignments that can be done for that column. You can select from that drop down list. Each column is individually controlled so that you can assign it however you like. Additionally, after you are satisfied with setting up the import how you like it to be, you can type in a name underneath the 'Load and Save Setting' and then clicking button that looks like arrow pointing down on top of a underscore right of the input field. Next time you can click the down arrow button in the same area to select and recall back previously saved setting. -Original Message- From: Ronald Solomon Sent: Friday, July 05, 2024 12:09 PM To: Users GnuCash Subject: [GNC] Importing to Gnucash I want to import from a CSV file It has both debit and credit transactions. When I am labeling the CSV columns I don't see where I label Withdrawal and deposit. My deposits are in one column and withdrawals are in another column. I have set up a test GNUCash file and am running test data. It sees the transactions however, it negates the amount to 0 -- Ron Solomon DC Integrative Health PHMA PA Phone 252 671 2306 Fax 252 69310684 The reason you have a headache is not that you need more aspirin. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 to Gnucash
> On Jul 5, 2024, at 09:09, Ronald Solomon wrote: > > I want to import from a CSV file It has both debit and credit transactions. > When I am labeling the CSV columns I don't see where I label Withdrawal and > deposit. My deposits are in one column and withdrawals are in another > column. > I have set up a test GNUCash file and am running test data. It sees the > transactions however, it negates the amount to 0 Assuming that both columns are unsigned and you’re importing into an asset account use Amount for the debit column and Amount (Negated) for the credit column. If you’re importing into a liability account (e.g. credit card) then you may need to flip that depending on your choice for reverse-balance accounts in Preferences>Accounts. If it comes in backwards, meaning that an amount you intend as a debit imports as a credit then reverse the column types. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Importing to Gnucash
I want to import from a CSV file It has both debit and credit transactions. When I am labeling the CSV columns I don't see where I label Withdrawal and deposit. My deposits are in one column and withdrawals are in another column. I have set up a test GNUCash file and am running test data. It sees the transactions however, it negates the amount to 0 -- Ron Solomon DC Integrative Health PHMA PA Phone 252 671 2306 Fax 252 69310684 The reason you have a headache is not that you need more aspirin. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 a QIF file
Kitty, Read the other thread *[GNC] Error Importing Quicken Files Mac OSX* at https://lists.gnucash.org/pipermail/gnucash-user/2024-June/112157.html - you'll see it's a known issue and will be fixed in the next release in a couple of weeks time. Bug report link thanks to Dae Reiser below >> fixed https://bugs.gnucash.org/show_bug.cgi?id=799262 >> wait 2 weeks and the new version of gnucash will be out >> -- >> Dave Reiser In the meantime you can go back to the previous version (5.5) which it seems doesn't have the issue. Instructions for downloading the previous version courtesy of Fred B in the other thread. If you follow the link "More downloads" (4th bullet-point under "Download GnuCash 5.6") the bottom link on the resulting page is "View all GnuCash downloads" giving https://sourceforge.net/projects/gnucash/files/ which should get you what you want Cheers David H. On Fri, 21 Jun 2024 at 02:06, David Carlson wrote: > Kitty, > > Which version of GnuCash are you using? I have not tried QIF imports in a > few years but in earlier releases they did not choke on nonexistent > investments. It may also be necessary to make sure that Quicken did not > create a bad QIF export. Someone here can help but we do need more info to > be effective. > > > > On Wed, Jun 19, 2024 at 11:51 PM Kitty Werner wrote: > > > I'm on Win11, currently using Quicken Home & Business. I have no > > investments which seems to be the problem. When I import the QIF file, > > all works well until I get to the Import the Investments. Since there is > > nothing to import, it gives an error and stops with the only choice to > > Close. Nothing is saved. > > > > Having been unsuccessful with the QIF, I tried a QDF. Nothing happens. > > > > Is this something I'm doing incorrectly? > > > > Thank you for any help! > > > > Kitty Werner > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > > > -- > David Carlson > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Error Importing Quicken Files Mac OSX
bug https://bugs.gnucash.org/show_bug.cgi?id=799262 fixed wait 2 weeks and the new version of gnucash will be out -- Dave Reiser dbrei...@icloud.com > On Jun 20, 2024, at 11:50, Jim Johnson wrote: > > Hi! > > I’m new to GnuCash (terrific experience so far!) and am trying to import my > old Quicken 2007 Mac OS X files. > > I used Quicken only as a check register, nothing else (no investments, > pie-charts, financial overviews, whatever), so it’s just one single big > checkbook register covering about 15 years. > > That and a few other (very small!) checkbook registers that show income for > each year. > > The import fails from some sort of “Investment Transaction Dated xx/xx/ > Unreconciled” (not the exact language but similar). > > I did a Google GnuCash search for the problem, and see that other people have > had the same issue. > > One post recommended returning to GnuCash 5.5, others recommended other ideas. > > I tried exporting each Quicken account file one by one, but that did not help. > > It actually seemed to give me everything in each import, not separate files. > > I have been looking for GnuCash 5.5 (5.6 is the current one on the website) > but was unable to find it on the website. > > Does anyone have any ideas? > > Thanks!! > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Error Importing Quicken Files Mac OSX
On 20 June 2024 at 11:50, Jim Johnson said: [...] > I have been looking for GnuCash 5.5 (5.6 is the current one on the > website) but was unable to find it on the website. > > Does anyone have any ideas? If you follow the link "More downloads" (4th bullet-point under "Download GnuCash 5.6") the bottom link on the resulting page is "View all GnuCash downloads" giving https://sourceforge.net/projects/gnucash/files/ which should get you what you want ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 a QIF file
Kitty, Which version of GnuCash are you using? I have not tried QIF imports in a few years but in earlier releases they did not choke on nonexistent investments. It may also be necessary to make sure that Quicken did not create a bad QIF export. Someone here can help but we do need more info to be effective. On Wed, Jun 19, 2024 at 11:51 PM Kitty Werner wrote: > I'm on Win11, currently using Quicken Home & Business. I have no > investments which seems to be the problem. When I import the QIF file, > all works well until I get to the Import the Investments. Since there is > nothing to import, it gives an error and stops with the only choice to > Close. Nothing is saved. > > Having been unsuccessful with the QIF, I tried a QDF. Nothing happens. > > Is this something I'm doing incorrectly? > > Thank you for any help! > > Kitty Werner > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Error Importing Quicken Files Mac OSX
Hi! I’m new to GnuCash (terrific experience so far!) and am trying to import my old Quicken 2007 Mac OS X files. I used Quicken only as a check register, nothing else (no investments, pie-charts, financial overviews, whatever), so it’s just one single big checkbook register covering about 15 years. That and a few other (very small!) checkbook registers that show income for each year. The import fails from some sort of “Investment Transaction Dated xx/xx/ Unreconciled” (not the exact language but similar). I did a Google GnuCash search for the problem, and see that other people have had the same issue. One post recommended returning to GnuCash 5.5, others recommended other ideas. I tried exporting each Quicken account file one by one, but that did not help. It actually seemed to give me everything in each import, not separate files. I have been looking for GnuCash 5.5 (5.6 is the current one on the website) but was unable to find it on the website. Does anyone have any ideas? Thanks!! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Importing a QIF file
I'm on Win11, currently using Quicken Home & Business. I have no investments which seems to be the problem. When I import the QIF file, all works well until I get to the Import the Investments. Since there is nothing to import, it gives an error and stops with the only choice to Close. Nothing is saved. Having been unsuccessful with the QIF, I tried a QDF. Nothing happens. Is this something I'm doing incorrectly? Thank you for any help! Kitty Werner ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 bank data, sending instructions.
> On May 15, 2024, at 17:58, Chris Miller wrote: > > Hi Folks, > > GnuCash will import bank data in OFX format. OFX imports advise me of > activity that originates with the bank, so I can "sync" my books with the > bank. So far; so good. > > Wells Fargo produces an OFX import file with "WebConnect", but I have been > using Wells Fargo "Direct Connect" for thirty years. "Direct Connect" allows > me to write checks and transfer funds from QuickBooks, but "OFX Import" does > not, which makes sense, because it is an import, not a dialog. > > I see that there is a way to send instruction to the bank and it is > AQBanking, which is an open source library that comes with GnuCash. I suspect > that AQBanking will be tricky to configure, so I'm looking for advice, > specifically advice on configuring AQBanking to run with Wells Fargo. > Reference to a specific AQBanking monograph for Wells Fargo would be > outstanding. > > Thanks for the help, > -- > Chris. I’m sorry to say that sending instructions via AQbanking will never happen. Even before Quicken (and even Intuit before them) started actively trying to deep six DirectConnect, it was highly impractical for anyone on the outside to handle sending instructions. The costs of gaining access to a DirectConnect test server made it unthinkable for an open source programmer to attempt to include sending instructions via DirectConnect. Add to that the fact that sending instructions essentially means moving money out of someone’s account, the risks to an independent developer become enormous. All but 2 of my financial institutions have ceased supporting DirectConnect even for downloading transaction data. And one of them has crippled the content of the description field so badly that I’ve bailed to CSV. That leaves 1 out of what used to be 8 institutions that I could use with AQbanking. The end is near (though a few banks may hold out for a few more years). -- 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Importing bank data, sending instructions.
Hi Folks, GnuCash will import bank data in OFX format. OFX imports advise me of activity that originates with the bank, so I can "sync" my books with the bank. So far; so good. Wells Fargo produces an OFX import file with "WebConnect", but I have been using Wells Fargo "Direct Connect" for thirty years. "Direct Connect" allows me to write checks and transfer funds from QuickBooks, but "OFX Import" does not, which makes sense, because it is an import, not a dialog. I see that there is a way to send instruction to the bank and it is AQBanking, which is an open source library that comes with GnuCash. I suspect that AQBanking will be tricky to configure, so I'm looking for advice, specifically advice on configuring AQBanking to run with Wells Fargo. Reference to a specific AQBanking monograph for Wells Fargo would be outstanding. Thanks for the help, -- Chris. V:916.799.9461 F:916.974.0428 A: Because we read from top to bottom, left to right. Q: > Why should I start my reply below the quoted text? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 historical stock prices to GnuCash in Windows
You may want to look at https://github.com/ka-patel/dl_quotes/tree/main/yfinance which is Python based... -Original Message- From: sunfis...@yahoo.com Sent: Friday, May 10, 2024 2:59 AM To: Leung Wing Cheong Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing historical stock prices to GnuCash in Windows Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a number of online sources, but those days are gone, sadly. At one point in the past, I used a perl module to retrieve monthly prices for all my commodities and put them into the GnuCash price history, but the module depended on Yahoo!, which no longer allows that level of data gathering. David T. On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong wrote: >Hi, >Is there any way to import historical stock prices to GnuCash in >Windows? >Thanks, >Wing >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >- >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 - 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 historical stock prices to GnuCash in Windows
Further to the point, I've used Google Sheets financial functions to retrieve stock prices pretty quickly. Those functions can pull prices for any given date, so you could set some dates and import them that way. It's not ideal, but it could get things done in a pinch. David T. On May 10, 2024, 11:31 AM, at 11:31 AM, Leung Wing Cheong wrote: >Got it, many thanks! >Wing > >-Original Message- >From: sunfis...@yahoo.com >Sent: Friday, May 10, 2024 2:59 PM >To: Leung Wing Cheong >Cc: gnucash-user@gnucash.org >Subject: Re: [GNC] Importing historical stock prices to GnuCash in >Windows > >Of course there is. The csv importer can handle any price data, >including historical data, as long as you supply the proper dates along >with the other data elements. > >The challenge is gathering that price data in the first place. It used >to be possible to retrieve unlimited price quotes from a number of >online sources, but those days are gone, sadly. > >At one point in the past, I used a perl module to retrieve monthly >prices for all my commodities and put them into the GnuCash price >history, but the module depended on Yahoo!, which no longer allows that >level of data gathering. > >David T. > >On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong > wrote: >>Hi, >>Is there any way to import historical stock prices to GnuCash in >>Windows? >>Thanks, >>Wing >>___ >>gnucash-user mailing list >>gnucash-user@gnucash.org >>To update your subscription preferences or to unsubscribe: >>https://lists.gnucash.org/mailman/listinfo/gnucash-user >>- >>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 - 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 historical stock prices to GnuCash in Windows
Got it, many thanks! Wing -Original Message- From: sunfis...@yahoo.com Sent: Friday, May 10, 2024 2:59 PM To: Leung Wing Cheong Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing historical stock prices to GnuCash in Windows Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a number of online sources, but those days are gone, sadly. At one point in the past, I used a perl module to retrieve monthly prices for all my commodities and put them into the GnuCash price history, but the module depended on Yahoo!, which no longer allows that level of data gathering. David T. On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong wrote: >Hi, >Is there any way to import historical stock prices to GnuCash in >Windows? >Thanks, >Wing >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >- >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 - 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 historical stock prices to GnuCash in Windows
Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a number of online sources, but those days are gone, sadly. At one point in the past, I used a perl module to retrieve monthly prices for all my commodities and put them into the GnuCash price history, but the module depended on Yahoo!, which no longer allows that level of data gathering. David T. On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong wrote: >Hi, >Is there any way to import historical stock prices to GnuCash in >Windows? >Thanks, >Wing >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >- >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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Importing historical stock prices to GnuCash in Windows
Hi, Is there any way to import historical stock prices to GnuCash in Windows? Thanks, Wing ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble importing .qif into Guncash
Yes, use a recent nightly build from https://code.gnucash.org/builds/flatpak/stable. Regards, John Ralls > On May 4, 2024, at 22:04, David Wasserman via gnucash-user > wrote: > > Recently upgraded to 24.04 LTS. Gnucash Version: 5.6. Build ID: Flathub > 5.6-2. > Gnucash Import fails at final screen with error message. Is there a fix? > > David W > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble importing .qif into Guncash
On 5/5/24 3:04 pm, David Wasserman via gnucash-user wrote: Recently upgraded to 24.04 LTS. Gnucash Version: 5.6. Build ID: Flathub 5.6-2. Gnucash Import fails at final screen with error message. Is there a fix? David W ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Trouble importing .qif into Guncash
Recently upgraded to 24.04 LTS. Gnucash Version: 5.6. Build ID: Flathub 5.6-2. Gnucash Import fails at final screen with error message. Is there a fix? David W ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 or pasting reports into spreadsheets
I do this using the "Export" choice in GnuCash, saving the report as an html file on the desktop, then right-click + open with LibreOffice Calc. In addition to what Hop said below about ticking the box for: "Detect special numbers (such as dates)" in the import ... I also need to do this step: - Select the entire column of numbers that aren't numerical values, by clicking on the letter at the column header) - In the "Data" menu dropdown, select "Text to Columns", then click OK. Hope that helps too. Chris (Xubuntu 22.04, Xfce desktop, GnuCash 5.4 flatpak, LibreOffice 7.3.7.2) On 4/14/24 02:01, gnucash-user-requ...@gnucash.org wrote: Date: Sat, 13 Apr 2024 20:53:32 -0500 From: David Carlson To: "gnucash-user@gnucash.org" Subject: [GNC] importing or pasting reports into spreadsheets I have found that I can select the text of reports directly in GnuCash, then paste it into a Libre Office Calc spreadsheet. The problem then is that values are preceded with a dollar sign in the US and it seems that they are not currency numbers but some form of text, as numeric operators do not recognize them. It also looks like dates are in some form of text as they have a format code "@" whatever that means. I am not very proficient with these format issues. Does someone know of an elementary reference that is easier to understand than the spreadsheet help file? Just in case it makes a difference I am using GnuCash release 4.8 in Lubuntu 22.04 with a LXQT desktop. -- David Carlson -- Date: Sun, 14 Apr 2024 12:20:35 +1000 From: Alan Hopkins To: David Carlson Cc: GnuCash users group Subject: Re: [GNC] importing or pasting reports into spreadsheets Hi David When you paste into Calc (I'll assume you are using Ctrl-v), you should get an Import options screen pop up in which you can tick a box "Detect special numbers (such as dates). I find this works for me (using different versions of Linux on differing hardware) I hope that helps! Cheers Hop ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 or pasting reports into spreadsheets
Hello David, I do the same for my reports but paste it into Excel and whenever I had that issue I either use powerquery for the clean up or more quick and dirty approach of using functions to extract the correct figures, some MID/RIGHT function, within the CLEAN one wrapping the result and if you still have issues maybe using the VALUE formula to convert the final output (I would try this one first as it might work out with the previous ones) In any case I think not all the reports cause the issue of being pasted as text, so maybe if you try to play with formatting options to number first and set those setting by default in the file it might help you. Thanking you. Regards, Inma On Sun, 14 Apr 2024 at 02:54, David Carlson wrote: > I have found that I can select the text of reports directly in GnuCash, > then paste it into a Libre Office Calc spreadsheet. The problem then is > that values are preceded with a dollar sign in the US and it seems that > they are not currency numbers but some form of text, as numeric operators > do not recognize them. It also looks like dates are in some form of text > as they have a format code "@" whatever that means. > > I am not very proficient with these format issues. Does someone know of an > elementary reference that is easier to understand than the spreadsheet help > file? > > Just in case it makes a difference I am using GnuCash release 4.8 in > Lubuntu 22.04 with a LXQT desktop. > > -- > David Carlson > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - 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 or pasting reports into spreadsheets
Hi David When you paste into Calc (I'll assume you are using Ctrl-v), you should get an Import options screen pop up in which you can tick a box "Detect special numbers (such as dates). I find this works for me (using different versions of Linux on differing hardware) I hope that helps! Cheers Hop On Sun, 14 Apr 2024, 11:54 am David Carlson, wrote: > I have found that I can select the text of reports directly in GnuCash, > then paste it into a Libre Office Calc spreadsheet. The problem then is > that values are preceded with a dollar sign in the US and it seems that > they are not currency numbers but some form of text, as numeric operators > do not recognize them. It also looks like dates are in some form of text > as they have a format code "@" whatever that means. > > I am not very proficient with these format issues. Does someone know of an > elementary reference that is easier to understand than the spreadsheet help > file? > > Just in case it makes a difference I am using GnuCash release 4.8 in > Lubuntu 22.04 with a LXQT desktop. > > -- > David Carlson > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] importing or pasting reports into spreadsheets
I have found that I can select the text of reports directly in GnuCash, then paste it into a Libre Office Calc spreadsheet. The problem then is that values are preceded with a dollar sign in the US and it seems that they are not currency numbers but some form of text, as numeric operators do not recognize them. It also looks like dates are in some form of text as they have a format code "@" whatever that means. I am not very proficient with these format issues. Does someone know of an elementary reference that is easier to understand than the spreadsheet help file? Just in case it makes a difference I am using GnuCash release 4.8 in Lubuntu 22.04 with a LXQT desktop. -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] View Transactions After Importing from CSV
Thank you. I filed the bug at https://bugs.gnucash.org/show_bug.cgi?id=799269 On Thu, Apr 4, 2024 at 9:06 PM Christopher Lam wrote: > Hi, enhancements should be logged in bugs.gnucash.org > > On Fri, 5 Apr 2024, 8:56 am Tom Balazs, wrote: > >> >I think it already does that for the Scheduled Transactions. It says >> something like, oh some time has passed, would you like me to create these >> transactions which you created in the Scheduled Transaction window. Okay, >> here is a register page showing the transactions I just created. >> >> I have already set up some Scheduled Transactions. So often when I open >> GnuCash it gives me a "Since Last Run" window. That gives me some >> information about the transactions it is going to create. At the bottom of >> that window is a checkbox which says, "Review Created Transactions". If I >> check that box, then GnuCash will take me to the main app and there is a >> tab named "Created Transactions". There I can see the transactions which >> were just created. >> >> That is what I want to see for Imported Transactions. >> >> >> >> >> On Tue, Apr 2, 2024 at 12:45 PM Tom Balazs >> wrote: >> >> > Yes, I see that. >> > But I mean that GnuCash should take me to a tab that looks like how it >> > displays the results of a Find Transaction. It opens a Register page and >> > shows only the matching transactions. >> > I think it already does that for the Scheduled Transactions. It says >> > something like, oh some time has passed, would you like me to create >> these >> > transactions which you created in the Scheduled Transaction window. >> Okay, >> > here is a register page showing the transactions I just created. >> > >> > >> > >> > On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel >> > wrote: >> > >> >> During the actual importation process, GNC always shows a confirmation >> >> dialogue box to take an action on all transaction it found. This is >> where >> >> you get a chance to select 'A' to add transaction, 'U+C' to update and >> >> clear matched one, 'C' to clear existing matched one, or select >> nothing and >> >> do nothing with that transaction. This is automatic -- ie there is >> nothing >> >> needs to be done, either via setting or manually, to trigger it to >> come up >> >> during every import. Note that if a transaction is matched >> incorrectly, you >> >> can check either 'U+C' or 'C" and then double clicking on it will >> bring up >> >> another dialogue box with a list of transactions it believe matches or >> are >> >> similar from which you can select on that it should match with. >> >> >> >> -Original Message- >> >> From: Tom Balazs >> >> Sent: Friday, December 22, 2023 7:02 AM >> >> To: Post to GnuCash User >> >> Subject: [GNC] View Transactions After Importing from CSV >> >> >> >> I'm using Financisto+ on my Android phone. So I am often exporting >> >> transactions from that, and importing them into GnuCash. Is there an >> option >> >> where I can view the transactions I just imported? So they appear on >> one >> >> page, as if I did a Find in GnuCash. I think I came across that once, >> but I >> >> can't find it again. >> >> >> >> Tom >> >> >> >> >> >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] View Transactions After Importing from CSV
Hi, enhancements should be logged in bugs.gnucash.org On Fri, 5 Apr 2024, 8:56 am Tom Balazs, wrote: > >I think it already does that for the Scheduled Transactions. It says > something like, oh some time has passed, would you like me to create these > transactions which you created in the Scheduled Transaction window. Okay, > here is a register page showing the transactions I just created. > > I have already set up some Scheduled Transactions. So often when I open > GnuCash it gives me a "Since Last Run" window. That gives me some > information about the transactions it is going to create. At the bottom of > that window is a checkbox which says, "Review Created Transactions". If I > check that box, then GnuCash will take me to the main app and there is a > tab named "Created Transactions". There I can see the transactions which > were just created. > > That is what I want to see for Imported Transactions. > > > > > On Tue, Apr 2, 2024 at 12:45 PM Tom Balazs wrote: > > > Yes, I see that. > > But I mean that GnuCash should take me to a tab that looks like how it > > displays the results of a Find Transaction. It opens a Register page and > > shows only the matching transactions. > > I think it already does that for the Scheduled Transactions. It says > > something like, oh some time has passed, would you like me to create > these > > transactions which you created in the Scheduled Transaction window. Okay, > > here is a register page showing the transactions I just created. > > > > > > > > On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel > > wrote: > > > >> During the actual importation process, GNC always shows a confirmation > >> dialogue box to take an action on all transaction it found. This is > where > >> you get a chance to select 'A' to add transaction, 'U+C' to update and > >> clear matched one, 'C' to clear existing matched one, or select nothing > and > >> do nothing with that transaction. This is automatic -- ie there is > nothing > >> needs to be done, either via setting or manually, to trigger it to come > up > >> during every import. Note that if a transaction is matched incorrectly, > you > >> can check either 'U+C' or 'C" and then double clicking on it will bring > up > >> another dialogue box with a list of transactions it believe matches or > are > >> similar from which you can select on that it should match with. > >> > >> -Original Message- > >> From: Tom Balazs > >> Sent: Friday, December 22, 2023 7:02 AM > >> To: Post to GnuCash User > >> Subject: [GNC] View Transactions After Importing from CSV > >> > >> I'm using Financisto+ on my Android phone. So I am often exporting > >> transactions from that, and importing them into GnuCash. Is there an > option > >> where I can view the transactions I just imported? So they appear on one > >> page, as if I did a Find in GnuCash. I think I came across that once, > but I > >> can't find it again. > >> > >> Tom > >> > >> > >> > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] View Transactions After Importing from CSV
>I think it already does that for the Scheduled Transactions. It says something like, oh some time has passed, would you like me to create these transactions which you created in the Scheduled Transaction window. Okay, here is a register page showing the transactions I just created. I have already set up some Scheduled Transactions. So often when I open GnuCash it gives me a "Since Last Run" window. That gives me some information about the transactions it is going to create. At the bottom of that window is a checkbox which says, "Review Created Transactions". If I check that box, then GnuCash will take me to the main app and there is a tab named "Created Transactions". There I can see the transactions which were just created. That is what I want to see for Imported Transactions. On Tue, Apr 2, 2024 at 12:45 PM Tom Balazs wrote: > Yes, I see that. > But I mean that GnuCash should take me to a tab that looks like how it > displays the results of a Find Transaction. It opens a Register page and > shows only the matching transactions. > I think it already does that for the Scheduled Transactions. It says > something like, oh some time has passed, would you like me to create these > transactions which you created in the Scheduled Transaction window. Okay, > here is a register page showing the transactions I just created. > > > > On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel > wrote: > >> During the actual importation process, GNC always shows a confirmation >> dialogue box to take an action on all transaction it found. This is where >> you get a chance to select 'A' to add transaction, 'U+C' to update and >> clear matched one, 'C' to clear existing matched one, or select nothing and >> do nothing with that transaction. This is automatic -- ie there is nothing >> needs to be done, either via setting or manually, to trigger it to come up >> during every import. Note that if a transaction is matched incorrectly, you >> can check either 'U+C' or 'C" and then double clicking on it will bring up >> another dialogue box with a list of transactions it believe matches or are >> similar from which you can select on that it should match with. >> >> -Original Message- >> From: Tom Balazs >> Sent: Friday, December 22, 2023 7:02 AM >> To: Post to GnuCash User >> Subject: [GNC] View Transactions After Importing from CSV >> >> I'm using Financisto+ on my Android phone. So I am often exporting >> transactions from that, and importing them into GnuCash. Is there an option >> where I can view the transactions I just imported? So they appear on one >> page, as if I did a Find in GnuCash. I think I came across that once, but I >> can't find it again. >> >> Tom >> >> >> ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] View Transactions After Importing from CSV
It is set to: QIF import: Default Transaction Status: Not Cleared On Tue, Apr 2, 2024 at 6:59 PM David Carlson wrote: > Tom, > > Take a look at your setting for Edit > Preferences > Import > Default > transaction status. In earlier releases (Release 4.x) the explanation > suggested that only came into play for QIF imports but it may apply to CSV > imports as well in the new CSV importer, I am not sure. > > On Tue, Apr 2, 2024 at 11:46 AM Tom Balazs wrote: > >> Yes, I see that. >> But I mean that GnuCash should take me to a tab that looks like how it >> displays the results of a Find Transaction. It opens a Register page and >> shows only the matching transactions. >> I think it already does that for the Scheduled Transactions. It says >> something like, oh some time has passed, would you like me to create these >> transactions which you created in the Scheduled Transaction window. Okay, >> here is a register page showing the transactions I just created. >> >> >> >> On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel >> wrote: >> >> > During the actual importation process, GNC always shows a confirmation >> > dialogue box to take an action on all transaction it found. This is >> where >> > you get a chance to select 'A' to add transaction, 'U+C' to update and >> > clear matched one, 'C' to clear existing matched one, or select nothing >> and >> > do nothing with that transaction. This is automatic -- ie there is >> nothing >> > needs to be done, either via setting or manually, to trigger it to come >> up >> > during every import. Note that if a transaction is matched incorrectly, >> you >> > can check either 'U+C' or 'C" and then double clicking on it will bring >> up >> > another dialogue box with a list of transactions it believe matches or >> are >> > similar from which you can select on that it should match with. >> > >> > -Original Message- >> > From: Tom Balazs >> > Sent: Friday, December 22, 2023 7:02 AM >> > To: Post to GnuCash User >> > Subject: [GNC] View Transactions After Importing from CSV >> > >> > I'm using Financisto+ on my Android phone. So I am often exporting >> > transactions from that, and importing them into GnuCash. Is there an >> option >> > where I can view the transactions I just imported? So they appear on one >> > page, as if I did a Find in GnuCash. I think I came across that once, >> but I >> > can't find it again. >> > >> > Tom >> > >> > >> > >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > > -- > David Carlson > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] View Transactions After Importing from CSV
Tom, Take a look at your setting for Edit > Preferences > Import > Default transaction status. In earlier releases (Release 4.x) the explanation suggested that only came into play for QIF imports but it may apply to CSV imports as well in the new CSV importer, I am not sure. On Tue, Apr 2, 2024 at 11:46 AM Tom Balazs wrote: > Yes, I see that. > But I mean that GnuCash should take me to a tab that looks like how it > displays the results of a Find Transaction. It opens a Register page and > shows only the matching transactions. > I think it already does that for the Scheduled Transactions. It says > something like, oh some time has passed, would you like me to create these > transactions which you created in the Scheduled Transaction window. Okay, > here is a register page showing the transactions I just created. > > > > On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel > wrote: > > > During the actual importation process, GNC always shows a confirmation > > dialogue box to take an action on all transaction it found. This is where > > you get a chance to select 'A' to add transaction, 'U+C' to update and > > clear matched one, 'C' to clear existing matched one, or select nothing > and > > do nothing with that transaction. This is automatic -- ie there is > nothing > > needs to be done, either via setting or manually, to trigger it to come > up > > during every import. Note that if a transaction is matched incorrectly, > you > > can check either 'U+C' or 'C" and then double clicking on it will bring > up > > another dialogue box with a list of transactions it believe matches or > are > > similar from which you can select on that it should match with. > > > > -Original Message- > > From: Tom Balazs > > Sent: Friday, December 22, 2023 7:02 AM > > To: Post to GnuCash User > > Subject: [GNC] View Transactions After Importing from CSV > > > > I'm using Financisto+ on my Android phone. So I am often exporting > > transactions from that, and importing them into GnuCash. Is there an > option > > where I can view the transactions I just imported? So they appear on one > > page, as if I did a Find in GnuCash. I think I came across that once, > but I > > can't find it again. > > > > Tom > > > > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Segmentation fault while importing invoice data
Thanks a lot! I've been able to fix the issue by debugging it. Turns out missing fields like: date, notes, and date_posted make validations crash when they are null and that's the segmentation fault origin. I'll fill the bug report later, but I hope this helps others while validations are fixed at the core. Greetings. P.S. I use Arch BTW On Sat, Mar 30, 2024 at 10:30 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > See the wiki about crashes and bug reports. Take a look there as well > about getting a Tracefile, then file a bug with the crash report and > tracefile as attachments. (The Tracefile may or may not contain relevant > info) > > You don't mention your OS by the way. > > Regards, > Adrien > > On 3/30/24 10:56 AM, Emir Herrera wrote: > > Anyway, if I click on "continue" to make the importation, after a couple > > seconds the system crashes and I get a "Segmentation fault" message on > the > > terminal, and no detailed information if runned with the "debug" flag... > > so... I'm stuck and I need help to import this data. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- Emir Herrera ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] View Transactions After Importing from CSV
Yes, I see that. But I mean that GnuCash should take me to a tab that looks like how it displays the results of a Find Transaction. It opens a Register page and shows only the matching transactions. I think it already does that for the Scheduled Transactions. It says something like, oh some time has passed, would you like me to create these transactions which you created in the Scheduled Transaction window. Okay, here is a register page showing the transactions I just created. On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel wrote: > During the actual importation process, GNC always shows a confirmation > dialogue box to take an action on all transaction it found. This is where > you get a chance to select 'A' to add transaction, 'U+C' to update and > clear matched one, 'C' to clear existing matched one, or select nothing and > do nothing with that transaction. This is automatic -- ie there is nothing > needs to be done, either via setting or manually, to trigger it to come up > during every import. Note that if a transaction is matched incorrectly, you > can check either 'U+C' or 'C" and then double clicking on it will bring up > another dialogue box with a list of transactions it believe matches or are > similar from which you can select on that it should match with. > > -Original Message- > From: Tom Balazs > Sent: Friday, December 22, 2023 7:02 AM > To: Post to GnuCash User > Subject: [GNC] View Transactions After Importing from CSV > > I'm using Financisto+ on my Android phone. So I am often exporting > transactions from that, and importing them into GnuCash. Is there an option > where I can view the transactions I just imported? So they appear on one > page, as if I did a Find in GnuCash. I think I came across that once, but I > can't find it again. > > Tom > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Segmentation fault while importing invoice data
See the wiki about crashes and bug reports. Take a look there as well about getting a Tracefile, then file a bug with the crash report and tracefile as attachments. (The Tracefile may or may not contain relevant info) You don't mention your OS by the way. Regards, Adrien On 3/30/24 10:56 AM, Emir Herrera wrote: Anyway, if I click on "continue" to make the importation, after a couple seconds the system crashes and I get a "Segmentation fault" message on the terminal, and no detailed information if runned with the "debug" flag... so... I'm stuck and I need help to import this data. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Segmentation fault while importing invoice data
Hello everyone. So, I'm trying to load some billing data from Google Cloud into GNUCash. I had made a script to get the data and parse it into a CSV. based on the documentation ( https://code.gnucash.org/docs/C/gnucash-guide/import-invoices.html) I have formatted it like this: GCP-202308,2023-08-31,GOOGLE,ea,E2 Instance Ram running in Americas,Expenses:Cloud Services:Compute Engine,17.00167,0.048897736 GCP-202308,2023-08-31,GOOGLE,ea,E2 Instance Ram running with free tier discount,Expenses:Cloud Services:Compute Engine,12.56861,-0.048899277 GCP-202308,2023-08-31,GOOGLE,ea,E2 Instance Core running free tier discount,Expenses:Cloud Services:Compute Engine,13,-0.091205385 GCP-202308,2023-08-31,GOOGLE,ea,Network Internet Egress from Americas to Australia,Expenses:Cloud Services:Compute Engine,0.28376,2.960248097 GCP-202308,2023-08-31,GOOGLE,ea,Rounding Error,Expenses:Cloud Services:Invoice,4,0.000258 GCP-202308,2023-08-31,GOOGLE,ea,Network Inter Zone Egress,Expenses:Cloud Services:Compute Engine,0.40337,0.148746808 GCP-202308,2023-08-31,GOOGLE,ea,Network Egress via Carrier Peering Network - Americas Based,Expenses:Cloud Services:Compute Engine,0.60274,0.497727046 GCP-202308,2023-08-31,GOOGLE,ea,E2 Instance Core running in Americas,Expenses:Cloud Services:Compute Engine,4.25056,0.364815371 GCP-202308,2023-08-31,GOOGLE,ea,Network Inter Region Egress from Americas to Jakarta,Expenses:Cloud Services:Compute Engine,0.21752,2.482530342 GCP-202309,2023-09-30,GOOGLE,ea,Rounding Error,Expenses:Cloud Services:Invoice,4,-0.00047925 and I use this REGEX to select the fields: ^(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*)$ So I have my CSV, open the import window, load the file, set the regex expression and the sample data is displayed. So far, so good. Anyway, if I click on "continue" to make the importation, after a couple seconds the system crashes and I get a "Segmentation fault" message on the terminal, and no detailed information if runned with the "debug" flag... so... I'm stuck and I need help to import this data. What could be done? Where is the problem? P.S. I upgraded to 5.5 last night, just to be up to date and the problem is there. Thanks in advance -- Emir Herrera ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 Reports into LO Calc
You can certainly set that as a style in Calc. Regards, Adrien On 3/9/24 9:01 PM, Robert Heller wrote: I think the OP's issue is the fact that Calc does not preserve the red coloring of the negative numbers. The red coloring of the negative numbers is something *GnuCash* is doing as a "good accounting practice", but the Calc is not doing. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 Reports into LO Calc
Hi Robert, If I copy and paste a Gnucash report directly into LibreOffice Calc (version 7.6.4.1 on Win10) everything is black as expected except for the negative numbers that are red which is what I also expected to happen ? Not sure what's happening with OP's calc. Cheers David H. On Sun, 10 Mar 2024 at 13:02, Robert Heller wrote: > I think the OP's issue is the fact that Calc does not preserve the red > coloring of the negative numbers. The red coloring of the negative > numbers is > something *GnuCash* is doing as a "good accounting practice", but the Calc > is > not doing. > > At Sat, 9 Mar 2024 18:13:04 -0600 adrien.montele...@lusfiber.net wrote: > > > > > 1. Export Report > > 2. Open Calc > > 3. Open the report file in Calc. Result is the report imported into > > cells based on the html table. > > > > or > > > > 1. Export Report > > 2. Open Calc > > 3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the > > exported report file. Answer the dialogs, result is same as above. > > > > or > > > > 1. Run Report in GnuCash > > 2. Select All > > 3. Copy > > 4. Open Calc > > 5. Paste, result is same as above > > > > In none of these cases is a web browser involved. (save for the Webkit > > rendering within GnuCash, if you want to be pedantic about browser > engines) > > > > I just tried all three, and in each case, there is no change in font or > > alignments. > > > > Perhaps your issues involve whatever intermediary (browser) you are > > involving that is unnecessary. > > > > Regards, > > Adrien > > > > On 3/9/24 10:41 AM, Abe Sternberg wrote: > > > I guess I am a bit dense - old age will do that to you. Let me try > and > > > be a bit more specific on my actions and the errors I get. Below is a > > > screenshot of a budget performance report in GnuCash. > > > > > > > > > > > > Next, I export it to the folder I want it in and open it in Calc. The > > > file opens in a browser tab, and I cut and paste the data into Calc. > > > Notice the different colors used. > > > > > > > > > > > > I wonder why the colors are there in the first place instead of the > > > expected black. The negative numbers being in red is good > accounting > > > practice. Look at what happens when I copy them into Calc. > Once again > > > I get a shift in colors and the negative numbers are not in red and > > > cannot be changed using cell format. Is the problem in GnuCash or > in Calc? > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > > > > -- > Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364 > Deepwoods Software-- Custom Software Services > http://www.deepsoft.com/ -- Linux Administration Services > hel...@deepsoft.com -- Webhosting Services > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - 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 Reports into LO Calc
I think the OP's issue is the fact that Calc does not preserve the red coloring of the negative numbers. The red coloring of the negative numbers is something *GnuCash* is doing as a "good accounting practice", but the Calc is not doing. At Sat, 9 Mar 2024 18:13:04 -0600 adrien.montele...@lusfiber.net wrote: > > 1. Export Report > 2. Open Calc > 3. Open the report file in Calc. Result is the report imported into > cells based on the html table. > > or > > 1. Export Report > 2. Open Calc > 3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the > exported report file. Answer the dialogs, result is same as above. > > or > > 1. Run Report in GnuCash > 2. Select All > 3. Copy > 4. Open Calc > 5. Paste, result is same as above > > In none of these cases is a web browser involved. (save for the Webkit > rendering within GnuCash, if you want to be pedantic about browser engines) > > I just tried all three, and in each case, there is no change in font or > alignments. > > Perhaps your issues involve whatever intermediary (browser) you are > involving that is unnecessary. > > Regards, > Adrien > > On 3/9/24 10:41 AM, Abe Sternberg wrote: > > I guess I am a bit dense - old age will do that to you.ÃÂ Let me try and > > be a bit more specific on my actions and the errors I get. Below is a > > screenshot of a budget performance report in GnuCash. > > > > > > > > Next, I export it to the folder I want it in and open it in Calc. The > > file opens in a browser tab, and I cut and paste the data into Calc. > > Notice the different colors used. > > > > > > > > I wonder why the colors are there in the first place instead of the > > expected black.ÃÂ The negative numbers being in red is good accounting > > practice.ÃÂ Look at what happens when I copy them into Calc.ÃÂ Once > > again > > I get a shift in colors and the negative numbers are not in red and > > cannot be changed using cell format.ÃÂ Is the problem in GnuCash or in > > Calc? > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > -- Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364 Deepwoods Software-- Custom Software Services http://www.deepsoft.com/ -- Linux Administration Services hel...@deepsoft.com -- Webhosting Services ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 Reports into LO Calc
1. Export Report 2. Open Calc 3. Open the report file in Calc. Result is the report imported into cells based on the html table. or 1. Export Report 2. Open Calc 3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the exported report file. Answer the dialogs, result is same as above. or 1. Run Report in GnuCash 2. Select All 3. Copy 4. Open Calc 5. Paste, result is same as above In none of these cases is a web browser involved. (save for the Webkit rendering within GnuCash, if you want to be pedantic about browser engines) I just tried all three, and in each case, there is no change in font or alignments. Perhaps your issues involve whatever intermediary (browser) you are involving that is unnecessary. Regards, Adrien On 3/9/24 10:41 AM, Abe Sternberg wrote: I guess I am a bit dense - old age will do that to you. Let me try and be a bit more specific on my actions and the errors I get. Below is a screenshot of a budget performance report in GnuCash. Next, I export it to the folder I want it in and open it in Calc. The file opens in a browser tab, and I cut and paste the data into Calc. Notice the different colors used. I wonder why the colors are there in the first place instead of the expected black. The negative numbers being in red is good accounting practice. Look at what happens when I copy them into Calc. Once again I get a shift in colors and the negative numbers are not in red and cannot be changed using cell format. Is the problem in GnuCash or in Calc? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 Reports into LO Calc
Thanks. It may be best if I start this thread again. I sincerely appreciate your taking the time to get me knowledgeable. Abe On 3/9/2024 15:35, David H wrote: Abe, You can't include/paste pictures inline on the Gnucash mailing list so they didn't show up :-( You have to either save each pic as a file and attach them to your email or I've found that you can get away with pasting 1 pic as the very last thing in your email and it makes it. Cheers David H. On Sun, 10 Mar 2024 at 02:42, Abe Sternberg wrote: I guess I am a bit dense - old age will do that to you. Let me try and be a bit more specific on my actions and the errors I get. Below is a screenshot of a budget performance report in GnuCash. Next, I export it to the folder I want it in and open it in Calc. The file opens in a browser tab, and I cut and paste the data into Calc. Notice the different colors used. I wonder why the colors are there in the first place instead of the expected black. The negative numbers being in red is good accounting practice. Look at what happens when I copy them into Calc. Once again I get a shift in colors and the negative numbers are not in red and cannot be changed using cell format. Is the problem in GnuCash or in Calc? Thanks for your help. Abe On 3/8/2024 21:47, Adrien Monteleone wrote: > Abe, next time, please start a new thread by sending a new message to > the list rather than replying to someone else's. > > As for how to get reports into Calc, I usually copy/paste, but you can > also just 'open' the exported report, or you can 'insert sheet from > file' into an existing workbook. (again, choosing the exported report) > When exporting, it probably wouldn't hurt to use an .html filename > extension. > > I have in a few reports seen some alignment issues, but that was due > to special padding used by that particular report rather than a > cleaner HTML. I think I filed a bug on it. > > Otherwise, I've had no issues bringing them into Calc. > > Regards, > Adrien > > On 3/8/24 1:45 PM, Abe Sternberg wrote: >> After a long hiatus from GnuCash and preparing reports, I find that I >> am back in that business. The good news is that I am good to go on >> getting my reports structured the way I want. The bad news is that >> now I can't figure out how to import the HTML report into Calc. I >> have tried everything I can think of, including cutting and pasting. >> >> The error is that some fields are imported in a different colored >> font, this seems to be limited to numeric fields. I have another >> situation where totals in a table do not cross-foot - they are not >> equal when adding row totals across and column totals going down. >> >> I had this correct, but have forgotten what to do. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - 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 - 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 Reports into LO Calc
Abe, The default colors which come up in Calc are going to depend upon its preference settings and any formatting already set in Calc before importing. GnuCash has no control over that. Cal's cell "currency" setting has the option of negative numbers appearing in red. If you format all cells containing numerical currency data to "Currency" this will work. ALl that is imported into Calc is the data , not any formatting The benefit of importing to Calc is that youthen have complete control over how it is formatted within the constraints of Calc's formatting capabilities but that comes at the cost of having to manually set that formatting. AFAIK it should be possible to create a formatted template in Calc so that you can import the data into the template and have it appear as you desire. On Sat, 2024-03-09 at 11:41 -0500, Abe Sternberg wrote: > I guess I am a bit dense - old age will do that to you. Let me try > and > be a bit more specific on my actions and the errors I get. Below is a > screenshot of a budget performance report in GnuCash. > > > > Next, I export it to the folder I want it in and open it in Calc. The > file opens in a browser tab, and I cut and paste the data into Calc. > Notice the different colors used. > > > > I wonder why the colors are there in the first place instead of the > expected black. The negative numbers being in red is good accounting > practice. Look at what happens when I copy them into Calc. Once > again > I get a shift in colors and the negative numbers are not in red and > cannot be changed using cell format. Is the problem in GnuCash or in > Calc? > > > > Thanks for your help. > > Abe > > > > On 3/8/2024 21:47, Adrien Monteleone wrote: > > Abe, next time, please start a new thread by sending a new message > > to > > the list rather than replying to someone else's. > > > > As for how to get reports into Calc, I usually copy/paste, but you > > can > > also just 'open' the exported report, or you can 'insert sheet from > > file' into an existing workbook. (again, choosing the exported > > report) > > When exporting, it probably wouldn't hurt to use an .html filename > > extension. > > > > I have in a few reports seen some alignment issues, but that was > > due > > to special padding used by that particular report rather than a > > cleaner HTML. I think I filed a bug on it. > > > > Otherwise, I've had no issues bringing them into Calc. > > > > Regards, > > Adrien > > > > On 3/8/24 1:45 PM, Abe Sternberg wrote: > > > After a long hiatus from GnuCash and preparing reports, I find > > > that I > > > am back in that business. The good news is that I am good to go > > > on > > > getting my reports structured the way I want. The bad news is > > > that > > > now I can't figure out how to import the HTML report into Calc. > > > I > > > have tried everything I can think of, including cutting and > > > pasting. > > > > > > The error is that some fields are imported in a different colored > > > font, this seems to be limited to numeric fields. I have another > > > situation where totals in a table do not cross-foot - they are > > > not > > > equal when adding row totals across and column totals going down. > > > > > > I had this correct, but have forgotten what to do. > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > 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 > - > 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 - 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 Reports into LO Calc
Abe, You can't include/paste pictures inline on the Gnucash mailing list so they didn't show up :-( You have to either save each pic as a file and attach them to your email or I've found that you can get away with pasting 1 pic as the very last thing in your email and it makes it. Cheers David H. On Sun, 10 Mar 2024 at 02:42, Abe Sternberg wrote: > I guess I am a bit dense - old age will do that to you. Let me try and > be a bit more specific on my actions and the errors I get. Below is a > screenshot of a budget performance report in GnuCash. > > > > Next, I export it to the folder I want it in and open it in Calc. The > file opens in a browser tab, and I cut and paste the data into Calc. > Notice the different colors used. > > > > I wonder why the colors are there in the first place instead of the > expected black. The negative numbers being in red is good accounting > practice. Look at what happens when I copy them into Calc. Once again > I get a shift in colors and the negative numbers are not in red and > cannot be changed using cell format. Is the problem in GnuCash or in Calc? > > > > Thanks for your help. > > Abe > > > > On 3/8/2024 21:47, Adrien Monteleone wrote: > > Abe, next time, please start a new thread by sending a new message to > > the list rather than replying to someone else's. > > > > As for how to get reports into Calc, I usually copy/paste, but you can > > also just 'open' the exported report, or you can 'insert sheet from > > file' into an existing workbook. (again, choosing the exported report) > > When exporting, it probably wouldn't hurt to use an .html filename > > extension. > > > > I have in a few reports seen some alignment issues, but that was due > > to special padding used by that particular report rather than a > > cleaner HTML. I think I filed a bug on it. > > > > Otherwise, I've had no issues bringing them into Calc. > > > > Regards, > > Adrien > > > > On 3/8/24 1:45 PM, Abe Sternberg wrote: > >> After a long hiatus from GnuCash and preparing reports, I find that I > >> am back in that business. The good news is that I am good to go on > >> getting my reports structured the way I want. The bad news is that > >> now I can't figure out how to import the HTML report into Calc. I > >> have tried everything I can think of, including cutting and pasting. > >> > >> The error is that some fields are imported in a different colored > >> font, this seems to be limited to numeric fields. I have another > >> situation where totals in a table do not cross-foot - they are not > >> equal when adding row totals across and column totals going down. > >> > >> I had this correct, but have forgotten what to do. > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > 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 > - > 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 - 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 Reports into LO Calc
At Sat, 9 Mar 2024 11:41:31 -0500 Abe Sternberg wrote: > > I guess I am a bit dense - old age will do that to you.ÃÂ Let me try and > be a bit more specific on my actions and the errors I get. Below is a > screenshot of a budget performance report in GnuCash. > > > > Next, I export it to the folder I want it in and open it in Calc. The > file opens in a browser tab, and I cut and paste the data into Calc.ÃÂ > Notice the different colors used. > > > > I wonder why the colors are there in the first place instead of the > expected black. The negative numbers being in red is good accounting > practice. Look at what happens when I copy them into Calc. Once again > I get a shift in colors and the negative numbers are not in red and > cannot be changed using cell format. Is the problem in GnuCash or in Calc? It is the spreadsheet program (calc). Spreadsheet programs are not accounting programs and don't know anything about "good accounting practice". GnuCash is an accounting program and does know all about "good accounting practice". *I* don't know how to fix this. What are you trying to do with the spreadsheet program? > > > > Thanks for your help. > > Abe > > > > On 3/8/2024 21:47, Adrien Monteleone wrote: > > Abe, next time, please start a new thread by sending a new message to > > the list rather than replying to someone else's. > > > > As for how to get reports into Calc, I usually copy/paste, but you can > > also just 'open' the exported report, or you can 'insert sheet from > > file' into an existing workbook. (again, choosing the exported report) > > When exporting, it probably wouldn't hurt to use an .html filename > > extension. > > > > I have in a few reports seen some alignment issues, but that was due > > to special padding used by that particular report rather than a > > cleaner HTML. I think I filed a bug on it. > > > > Otherwise, I've had no issues bringing them into Calc. > > > > Regards, > > Adrien > > > > On 3/8/24 1:45 PM, Abe Sternberg wrote: > >> After a long hiatus from GnuCash and preparing reports, I find that I > >> am back in that business.ÃÂ The good news is that I am good to go on > >> getting my reports structured the way I want. The bad news is that > >> now I can't figure out how to import the HTML report into Calc.ÃÂ I > >> have tried everything I can think of, including cutting and pasting. > >> > >> The error is that some fields are imported in a different colored > >> font, this seems to be limited to numeric fields.ÃÂ I have another > >> situation where totals in a table do not cross-foot - they are not > >> equal when adding row totals across and column totals going down. > >> > >> I had this correct, but have forgotten what to do. > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > 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 > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > -- Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364 Deepwoods Software-- Custom Software Services http://www.deepsoft.com/ -- Linux Administration Services hel...@deepsoft.com -- Webhosting Services ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 Reports into LO Calc
I guess I am a bit dense - old age will do that to you. Let me try and be a bit more specific on my actions and the errors I get. Below is a screenshot of a budget performance report in GnuCash. Next, I export it to the folder I want it in and open it in Calc. The file opens in a browser tab, and I cut and paste the data into Calc. Notice the different colors used. I wonder why the colors are there in the first place instead of the expected black. The negative numbers being in red is good accounting practice. Look at what happens when I copy them into Calc. Once again I get a shift in colors and the negative numbers are not in red and cannot be changed using cell format. Is the problem in GnuCash or in Calc? Thanks for your help. Abe On 3/8/2024 21:47, Adrien Monteleone wrote: Abe, next time, please start a new thread by sending a new message to the list rather than replying to someone else's. As for how to get reports into Calc, I usually copy/paste, but you can also just 'open' the exported report, or you can 'insert sheet from file' into an existing workbook. (again, choosing the exported report) When exporting, it probably wouldn't hurt to use an .html filename extension. I have in a few reports seen some alignment issues, but that was due to special padding used by that particular report rather than a cleaner HTML. I think I filed a bug on it. Otherwise, I've had no issues bringing them into Calc. Regards, Adrien On 3/8/24 1:45 PM, Abe Sternberg wrote: After a long hiatus from GnuCash and preparing reports, I find that I am back in that business. The good news is that I am good to go on getting my reports structured the way I want. The bad news is that now I can't figure out how to import the HTML report into Calc. I have tried everything I can think of, including cutting and pasting. The error is that some fields are imported in a different colored font, this seems to be limited to numeric fields. I have another situation where totals in a table do not cross-foot - they are not equal when adding row totals across and column totals going down. I had this correct, but have forgotten what to do. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - 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 Reports into LO Calc
Abe, next time, please start a new thread by sending a new message to the list rather than replying to someone else's. As for how to get reports into Calc, I usually copy/paste, but you can also just 'open' the exported report, or you can 'insert sheet from file' into an existing workbook. (again, choosing the exported report) When exporting, it probably wouldn't hurt to use an .html filename extension. I have in a few reports seen some alignment issues, but that was due to special padding used by that particular report rather than a cleaner HTML. I think I filed a bug on it. Otherwise, I've had no issues bringing them into Calc. Regards, Adrien On 3/8/24 1:45 PM, Abe Sternberg wrote: After a long hiatus from GnuCash and preparing reports, I find that I am back in that business. The good news is that I am good to go on getting my reports structured the way I want. The bad news is that now I can't figure out how to import the HTML report into Calc. I have tried everything I can think of, including cutting and pasting. The error is that some fields are imported in a different colored font, this seems to be limited to numeric fields. I have another situation where totals in a table do not cross-foot - they are not equal when adding row totals across and column totals going down. I had this correct, but have forgotten what to do. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Importing Reports into LO Calc
After a long hiatus from GnuCash and preparing reports, I find that I am back in that business. The good news is that I am good to go on getting my reports structured the way I want. The bad news is that now I can't figure out how to import the HTML report into Calc. I have tried everything I can think of, including cutting and pasting. The error is that some fields are imported in a different colored font, this seems to be limited to numeric fields. I have another situation where totals in a table do not cross-foot - they are not equal when adding row totals across and column totals going down. I had this correct, but have forgotten what to do. Thanks for your help. Abe ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble importing bills via csv
Yes, if your field contains the separator character you should double-quote it, but *only* in that case. Id's, dates, et cetera will not, so no reason to quote them. The OP had quotes on most if not all fields and none of them were necessary. Regards, Adrien On 2/26/24 8:23 AM, Kalpesh Patel wrote: Some financial orgs include commas as thousands, hundreds thousands, etc., separator in CSV to beautify the display. They treat it as a free format string value... A single opening and a single closing double quotes, I believe, are ignored by the importer ... correct me if I am wrong. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble importing bills via csv
Some financial orgs include commas as thousands, hundreds thousands, etc., separator in CSV to beautify the display. They treat it as a free format string value... A single opening and a single closing double quotes, I believe, are ignored by the importer ... correct me if I am wrong. -Original Message- From: David H Sent: Saturday, February 24, 2024 7:02 PM To: Alan Johnson Cc: Adrien Monteleone ; gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Trouble importing bills via csv Alan, Your file imports fine here after I add the vendor, create the Accounts Payable liability, remove the header line and remove the double quotes that you have plastered around every field for some reason which probably causes the other errors. It might pay to read up on Gnucash Bills Importing at https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html and the examples therein :- You'll note a complete absence of double quotes in the following example and no header line. Hope this helps, Cheers David H. Note on double quotes If you use the field separator character within a field, the field value should be enclosed in double quotes. Only for the fields description (desc) and notes, can you also include a double quote within a quoted field value, by doubling the double quote. E.g. "This field value uses the separator, and a ""quoted"" word", would be imported as This field value uses the separator, and a "quoted" word. Example content for two bills; one of 2 entries, and one of 3 entries. The first is saved and posted, the second only saved. Using comma field separator, decimal point and dd/mm/ date format. 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride and Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts Payable;;X 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Electronic principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts Payable;;X 1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate Guide;pc;Expenses:Books;1;10.01;;; 1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner & drinks;pc;Expenses:Dining;1;10.01;;; 1205;15/12/2018;2044;PO 21099;;16/12/2018;UG course;pc;Expenses:Education;1;10.01;;; On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user < gnucash-user@gnucash.org> wrote: > I tried that with the same result. GNC says it ignored that line, and > that's fine. > > I'm concerned with the error messages indicating that the vendor and > accounts don't exist. Have I input that data incorrectly? > > Feb 24, 2024 13:00:20 Adrien Monteleone : > > > Although you should be able to have header row(s), perhaps remove it > > and > try again. > > > > The Documentation for this is worded oddly, but the samples provided > don't show header info at all. > > > > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoi > ces.html > > > > Regards, > > Adrien > > > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: > >> Hello, > >> I'm having some issues importing a bill via CSV. I set up a trial > >> run and I'm getting the below errors. Vendor "05" does not > >> exist, however that is the vendor ID for Amazon in my file. It > >> says account "Liabilities:Accounts Payable" does not exist (but it > >> does). It says the Expense account also does not exist (but it > >> does) and then it proceeds to ignore the line. > >> How do I correct this for proper import? I've had the same issue on > >> the Customer invoice import side as well. > >> This is on Ubuntu with Flatpak 5.5 > >> Here is the raw CSV import: > >> "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"ac > >> tion > >> ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"t > >> axab > >> le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted" > >> ;"memo_posted";"accu_splits" > >> "111-7425790-5888250";05/11/23;"05"05/11/23;"Low Profile > >> Fuse > >> Kit";;"Expenses:Auto:2016 Big > >> Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabil > >> itie > >> s:Accounts Payable";;"N" > > > > ___ > > gnucash-user mailing list > > gnu
Re: [GNC] Trouble importing bills via csv
So basically you got rid of the quotes around everything as I suggested :-) Cheers David H. On Sun, 25 Feb 2024 at 11:17, Alan Johnson via gnucash-user < gnucash-user@gnucash.org> wrote: > So, I was working on it and here was that worked as I was playing with > it. I'm using LibreOffice to edit the CSVs. > > Edit the filter on the "save as" dialog, then I set the field delimiter > and deleted the string delimiter and unchecked 'quote all text cells'. > > Then I was able to successfully able to import the bills. > > Alan > > On Sat, 2024-02-24 at 19:10 -0500, Alan Johnson via gnucash-user wrote: > > I did read the manual, hence my usage of the quotes. I had done it > > before without. > > > > I'll make a video and send it out shortly. > > > > Alan > > > > On Sun, 2024-02-25 at 10:02 +1000, David H wrote: > > > Alan, > > > > > > Your file imports fine here after I add the vendor, create the > > > Accounts Payable liability, remove the header line and remove the > > > double quotes that you have plastered around every field for some > > > reason which probably causes the other errors. > > > > > > It might pay to read up on Gnucash Bills Importing > > > at > > > > https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > > and the examples therein :- > > > > > > You'll note a complete absence of double quotes in the following > > > example and no header line. > > > > > > Hope this helps, > > > > > > Cheers David H. > > > > > > > > > Note on double quotes > > > If you use the field separator character within a field, the field > > > value should be enclosed in double quotes. Only for the fields > > > description (desc) and notes, can you also include a double quote > > > within a quoted field value, by doubling the double quote. > > > E.g. "This > > > field value uses the separator, and a ""quoted"" word", would be > > > imported as This field value uses the separator, and a "quoted" > > > word. > > > > > > Example content for two bills; one of 2 entries, and one of 3 > > > entries. The first is saved and posted, the second only saved. > > > Using > > > comma field separator, decimal point and dd/mm/ date format. > > > 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride > > > and > > > Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;L > > > ia > > > bilities:Accounts Payable;;X > > > 1204;15/12/2018;2001;PO 210220;Special > > > delivery;16/12/2018;Electronic > > > principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019; > > > Li > > > abilities:Accounts Payable;;X > > > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate > > > Guide;pc;Expenses:Books;1;10.01;;; > > > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner & > > > drinks;pc;Expenses:Dining;1;10.01;;; > > > 1205;15/12/2018;2044;PO 21099;;16/12/2018;UG > > > course;pc;Expenses:Education;1;10.01;;; > > > > > > > > > On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user > > > wrote: > > > > I tried that with the same result. GNC says it ignored that line, > > > > and that's fine. > > > > > > > > I'm concerned with the error messages indicating that the vendor > > > > and accounts don't exist. Have I input that data incorrectly? > > > > > > > > Feb 24, 2024 13:00:20 Adrien Monteleone > > > > : > > > > > > > > > Although you should be able to have header row(s), perhaps > > > > > remove > > > > it and try again. > > > > > > > > > > The Documentation for this is worded oddly, but the samples > > > > provided don't show header info at all. > > > > > > > > > > > > > > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > > > > > > > > > Regards, > > > > > Adrien > > > > > > > > > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: > > > > > > Hello, > > > > > > I'm having some issues importing a bill via CSV. I set up a > > > > trial run > > > > > > and I'm getting the b
Re: [GNC] Trouble importing bills via csv
So, I was working on it and here was that worked as I was playing with it. I'm using LibreOffice to edit the CSVs. Edit the filter on the "save as" dialog, then I set the field delimiter and deleted the string delimiter and unchecked 'quote all text cells'. Then I was able to successfully able to import the bills. Alan On Sat, 2024-02-24 at 19:10 -0500, Alan Johnson via gnucash-user wrote: > I did read the manual, hence my usage of the quotes. I had done it > before without. > > I'll make a video and send it out shortly. > > Alan > > On Sun, 2024-02-25 at 10:02 +1000, David H wrote: > > Alan, > > > > Your file imports fine here after I add the vendor, create the > > Accounts Payable liability, remove the header line and remove the > > double quotes that you have plastered around every field for some > > reason which probably causes the other errors. > > > > It might pay to read up on Gnucash Bills Importing > > at > > https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > and the examples therein :- > > > > You'll note a complete absence of double quotes in the following > > example and no header line. > > > > Hope this helps, > > > > Cheers David H. > > > > > > Note on double quotes > > If you use the field separator character within a field, the field > > value should be enclosed in double quotes. Only for the fields > > description (desc) and notes, can you also include a double quote > > within a quoted field value, by doubling the double quote. > > E.g. "This > > field value uses the separator, and a ""quoted"" word", would be > > imported as This field value uses the separator, and a "quoted" > > word. > > > > Example content for two bills; one of 2 entries, and one of 3 > > entries. The first is saved and posted, the second only saved. > > Using > > comma field separator, decimal point and dd/mm/ date format. > > 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride > > and > > Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;L > > ia > > bilities:Accounts Payable;;X > > 1204;15/12/2018;2001;PO 210220;Special > > delivery;16/12/2018;Electronic > > principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019; > > Li > > abilities:Accounts Payable;;X > > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate > > Guide;pc;Expenses:Books;1;10.01;;; > > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner & > > drinks;pc;Expenses:Dining;1;10.01;;; > > 1205;15/12/2018;2044;PO 21099;;16/12/2018;UG > > course;pc;Expenses:Education;1;10.01;;; > > > > > > On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user > > wrote: > > > I tried that with the same result. GNC says it ignored that line, > > > and that's fine. > > > > > > I'm concerned with the error messages indicating that the vendor > > > and accounts don't exist. Have I input that data incorrectly? > > > > > > Feb 24, 2024 13:00:20 Adrien Monteleone > > > : > > > > > > > Although you should be able to have header row(s), perhaps > > > > remove > > > it and try again. > > > > > > > > The Documentation for this is worded oddly, but the samples > > > provided don't show header info at all. > > > > > > > > > > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > > > > > > > Regards, > > > > Adrien > > > > > > > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: > > > > > Hello, > > > > > I'm having some issues importing a bill via CSV. I set up a > > > trial run > > > > > and I'm getting the below errors. Vendor "05" does not > > > exist, > > > > > however that is the vendor ID for Amazon in my file. It says > > > account > > > > > "Liabilities:Accounts Payable" does not exist (but it does). > > > > > It > > > says > > > > > the Expense account also does not exist (but it does) and > > > > > then > > > it > > > > > proceeds to ignore the line. > > > > > How do I correct this for proper import? I've had the same > > > > > issue > > > on the > > > > >
Re: [GNC] Trouble importing bills via csv
Aha I read that as you'd tried it with and without the header line nothing was said about the quotes :-) On Sun, 25 Feb 2024 at 10:11, Alan Johnson wrote: > I did read the manual, hence my usage of the quotes. I had done it before > without. > > I'll make a video and send it out shortly. > > Alan > > On Sun, 2024-02-25 at 10:02 +1000, David H wrote: > > Alan, > > Your file imports fine here after I add the vendor, create the Accounts > Payable liability, remove the header line and remove the double quotes that > you have plastered around every field for some reason which probably causes > the other errors. > > It might pay to read up on Gnucash Bills Importing at > https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html and > the examples therein :- > > You'll note a complete absence of double quotes in the following example > and no header line. > > Hope this helps, > > Cheers David H. > > > Note on double quotes > > If you use the field separator character within a field, the field value > should be enclosed in double quotes. Only for the fields description (desc) > and notes, can you also include a double quote within a quoted field value, > by doubling the double quote. E.g. "This field value uses the separator, > and a ""quoted"" word", would be imported as This field value uses the > separator, and a "quoted" word. > > Example content for two bills; one of 2 entries, and one of 3 entries. The > first is saved and posted, the second only saved. Using comma field > separator, decimal point and dd/mm/ date format. > > 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride and > Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts > Payable;;X > 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Electronic > principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts > Payable;;X > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate > Guide;pc;Expenses:Books;1;10.01;;; > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner & > drinks;pc;Expenses:Dining;1;10.01;;; > 1205;15/12/2018;2044;PO 21099;;16/12/2018;UG > course;pc;Expenses:Education;1;10.01;;; > > > > On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user < > gnucash-user@gnucash.org> wrote: > > I tried that with the same result. GNC says it ignored that line, and > that's fine. > > I'm concerned with the error messages indicating that the vendor and > accounts don't exist. Have I input that data incorrectly? > > Feb 24, 2024 13:00:20 Adrien Monteleone : > > > Although you should be able to have header row(s), perhaps remove it and > try again. > > > > The Documentation for this is worded oddly, but the samples provided > don't show header info at all. > > > > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > > > Regards, > > Adrien > > > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: > >> Hello, > >> I'm having some issues importing a bill via CSV. I set up a trial run > >> and I'm getting the below errors. Vendor "05" does not exist, > >> however that is the vendor ID for Amazon in my file. It says account > >> "Liabilities:Accounts Payable" does not exist (but it does). It says > >> the Expense account also does not exist (but it does) and then it > >> proceeds to ignore the line. > >> How do I correct this for proper import? I've had the same issue on the > >> Customer invoice import side as well. > >> This is on Ubuntu with Flatpak 5.5 > >> Here is the raw CSV import: > >> "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"action > >> ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"taxab > >> le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted" > >> ;"memo_posted";"accu_splits" > >> "111-7425790-5888250";05/11/23;"05"05/11/23;"Low Profile Fuse > >> Kit";;"Expenses:Auto:2016 Big > >> Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabilitie > >> s:Accounts Payable";;"N" > > > > ___ > > gn
Re: [GNC] Trouble importing bills via csv
I did read the manual, hence my usage of the quotes. I had done it before without. I'll make a video and send it out shortly. Alan On Sun, 2024-02-25 at 10:02 +1000, David H wrote: > Alan, > > Your file imports fine here after I add the vendor, create the > Accounts Payable liability, remove the header line and remove the > double quotes that you have plastered around every field for some > reason which probably causes the other errors. > > It might pay to read up on Gnucash Bills Importing > at > https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > and the examples therein :- > > You'll note a complete absence of double quotes in the following > example and no header line. > > Hope this helps, > > Cheers David H. > > > Note on double quotes > If you use the field separator character within a field, the field > value should be enclosed in double quotes. Only for the fields > description (desc) and notes, can you also include a double quote > within a quoted field value, by doubling the double quote. E.g. "This > field value uses the separator, and a ""quoted"" word", would be > imported as This field value uses the separator, and a "quoted" word. > > Example content for two bills; one of 2 entries, and one of 3 > entries. The first is saved and posted, the second only saved. Using > comma field separator, decimal point and dd/mm/ date format. > 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride and > Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;Lia > bilities:Accounts Payable;;X > 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Electronic > principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019;Li > abilities:Accounts Payable;;X > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate > Guide;pc;Expenses:Books;1;10.01;;; > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner & > drinks;pc;Expenses:Dining;1;10.01;;; > 1205;15/12/2018;2044;PO 21099;;16/12/2018;UG > course;pc;Expenses:Education;1;10.01;;; > > > On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user > wrote: > > I tried that with the same result. GNC says it ignored that line, > > and that's fine. > > > > I'm concerned with the error messages indicating that the vendor > > and accounts don't exist. Have I input that data incorrectly? > > > > Feb 24, 2024 13:00:20 Adrien Monteleone > > : > > > > > Although you should be able to have header row(s), perhaps remove > > it and try again. > > > > > > The Documentation for this is worded oddly, but the samples > > provided don't show header info at all. > > > > > > > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > > > > > Regards, > > > Adrien > > > > > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: > > >> Hello, > > >> I'm having some issues importing a bill via CSV. I set up a > > trial run > > >> and I'm getting the below errors. Vendor "05" does not > > exist, > > >> however that is the vendor ID for Amazon in my file. It says > > account > > >> "Liabilities:Accounts Payable" does not exist (but it does). It > > says > > >> the Expense account also does not exist (but it does) and then > > it > > >> proceeds to ignore the line. > > >> How do I correct this for proper import? I've had the same issue > > on the > > >> Customer invoice import side as well. > > >> This is on Ubuntu with Flatpak 5.5 > > >> Here is the raw CSV import: > > >> > > "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"ac > > tion > > >> > > ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"t > > axab > > >> > > le";"taxincluded";"tax_table";"date_posted";"due_date";"account_pos > > ted" > > >> ;"memo_posted";"accu_splits" > > >> "111-7425790-5888250";05/11/23;"05"05/11/23;"Low Profile > > Fuse > > >> Kit";;"Expenses:Auto:2016 Big > > >> > > Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabil > > itie > &g
Re: [GNC] Trouble importing bills via csv
There is the caveat, noted in that link, that if you use the same delimiter for your account tree as the CSV, then (and only then) do you need to enclose account references in double-quotes. (this is generally a CSV thing, not something specific to GnuCash) Regards, Adrien On 2/24/24 6:02 PM, David H wrote: Your file imports fine here after I add the vendor, create the Accounts Payable liability, remove the header line and remove the double quotes that you have plastered around every field for some reason which probably causes the other errors. It might pay to read up on Gnucash Bills Importing at https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html and the examples therein :- You'll note a complete absence of double quotes in the following example and no header line. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble importing bills via csv
Alan, Your file imports fine here after I add the vendor, create the Accounts Payable liability, remove the header line and remove the double quotes that you have plastered around every field for some reason which probably causes the other errors. It might pay to read up on Gnucash Bills Importing at https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html and the examples therein :- You'll note a complete absence of double quotes in the following example and no header line. Hope this helps, Cheers David H. Note on double quotes If you use the field separator character within a field, the field value should be enclosed in double quotes. Only for the fields description (desc) and notes, can you also include a double quote within a quoted field value, by doubling the double quote. E.g. "This field value uses the separator, and a ""quoted"" word", would be imported as This field value uses the separator, and a "quoted" word. Example content for two bills; one of 2 entries, and one of 3 entries. The first is saved and posted, the second only saved. Using comma field separator, decimal point and dd/mm/ date format. 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride and Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts Payable;;X 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Electronic principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts Payable;;X 1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate Guide;pc;Expenses:Books;1;10.01;;; 1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner & drinks;pc;Expenses:Dining;1;10.01;;; 1205;15/12/2018;2044;PO 21099;;16/12/2018;UG course;pc;Expenses:Education;1;10.01;;; On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user < gnucash-user@gnucash.org> wrote: > I tried that with the same result. GNC says it ignored that line, and > that's fine. > > I'm concerned with the error messages indicating that the vendor and > accounts don't exist. Have I input that data incorrectly? > > Feb 24, 2024 13:00:20 Adrien Monteleone : > > > Although you should be able to have header row(s), perhaps remove it and > try again. > > > > The Documentation for this is worded oddly, but the samples provided > don't show header info at all. > > > > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > > > Regards, > > Adrien > > > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: > >> Hello, > >> I'm having some issues importing a bill via CSV. I set up a trial run > >> and I'm getting the below errors. Vendor "05" does not exist, > >> however that is the vendor ID for Amazon in my file. It says account > >> "Liabilities:Accounts Payable" does not exist (but it does). It says > >> the Expense account also does not exist (but it does) and then it > >> proceeds to ignore the line. > >> How do I correct this for proper import? I've had the same issue on the > >> Customer invoice import side as well. > >> This is on Ubuntu with Flatpak 5.5 > >> Here is the raw CSV import: > >> "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"action > >> ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"taxab > >> le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted" > >> ;"memo_posted";"accu_splits" > >> "111-7425790-5888250";05/11/23;"05"05/11/23;"Low Profile Fuse > >> Kit";;"Expenses:Auto:2016 Big > >> Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabilitie > >> s:Accounts Payable";;"N" > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > 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 > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble importing bills via csv
I tried that with the same result. GNC says it ignored that line, and that's fine. I'm concerned with the error messages indicating that the vendor and accounts don't exist. Have I input that data incorrectly? Feb 24, 2024 13:00:20 Adrien Monteleone : > Although you should be able to have header row(s), perhaps remove it and try > again. > > The Documentation for this is worded oddly, but the samples provided don't > show header info at all. > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > Regards, > Adrien > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: >> Hello, >> I'm having some issues importing a bill via CSV. I set up a trial run >> and I'm getting the below errors. Vendor "05" does not exist, >> however that is the vendor ID for Amazon in my file. It says account >> "Liabilities:Accounts Payable" does not exist (but it does). It says >> the Expense account also does not exist (but it does) and then it >> proceeds to ignore the line. >> How do I correct this for proper import? I've had the same issue on the >> Customer invoice import side as well. >> This is on Ubuntu with Flatpak 5.5 >> Here is the raw CSV import: >> "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"action >> ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"taxab >> le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted" >> ;"memo_posted";"accu_splits" >> "111-7425790-5888250";05/11/23;"05"05/11/23;"Low Profile Fuse >> Kit";;"Expenses:Auto:2016 Big >> Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabilitie >> s:Accounts Payable";;"N" > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. smime.p7s Description: S/MIME cryptographic signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Trouble importing bills via csv
Although you should be able to have header row(s), perhaps remove it and try again. The Documentation for this is worded oddly, but the samples provided don't show header info at all. https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html Regards, Adrien On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: Hello, I'm having some issues importing a bill via CSV. I set up a trial run and I'm getting the below errors. Vendor "05" does not exist, however that is the vendor ID for Amazon in my file. It says account "Liabilities:Accounts Payable" does not exist (but it does). It says the Expense account also does not exist (but it does) and then it proceeds to ignore the line. How do I correct this for proper import? I've had the same issue on the Customer invoice import side as well. This is on Ubuntu with Flatpak 5.5 Here is the raw CSV import: "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"action ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"taxab le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted" ;"memo_posted";"accu_splits" "111-7425790-5888250";05/11/23;"05"05/11/23;"Low Profile Fuse Kit";;"Expenses:Auto:2016 Big Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabilitie s:Accounts Payable";;"N" ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Issues importing transactions (not matching)
Hello, I'm attempting to import transactions from a credit card QFX file / Quicken format. I have the pre-entered transaction as 'LEGO' in the amount of 45.14. The imported transaction is "LEGO Enfeild CT" in the amount of 45.14. Gnucash thinks these are not the same - and there are a number of other transactions that are the same way. How can I manually match these? or adjust it so they match? Thanks, Alan smime.p7s Description: S/MIME cryptographic signature ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 from one gnucash file to another
It's part of CSV import. It has been there for a long time but didn't work very well until Geert rewrote the CSV importer for GnuCash 4. Use File>Export>Transactions to CSV to create a CSV file then File>Import>Import Transactions from CSV and click the Multi-Split box under File Format on the Import Preview page. Regards, John Ralls > On Jan 16, 2024, at 10:38 AM, Adrien Monteleone > wrote: > > I've never used it myself, but I recall a discussion when the feature was > added, I think for 4.x but it could have been earlier. > > Regards, > Adrien > > On 1/16/24 5:16 AM, David H wrote: >> James, >> I may be mis-remembering but I seem to recall when importing txns some time >> ago there was a checkbox or option to specify the file to be imported was >> in Gnucash format ? Do you see this? Have you selected it ? > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - 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 from one gnucash file to another
I've never used it myself, but I recall a discussion when the feature was added, I think for 4.x but it could have been earlier. Regards, Adrien On 1/16/24 5:16 AM, David H wrote: James, I may be mis-remembering but I seem to recall when importing txns some time ago there was a checkbox or option to specify the file to be imported was in Gnucash format ? Do you see this? Have you selected it ? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 from one gnucash file to another
James, I may be mis-remembering but I seem to recall when importing txns some time ago there was a checkbox or option to specify the file to be imported was in Gnucash format ? Do you see this? Have you selected it ? Regards David H. On Tue, 16 Jan 2024 at 06:33, James Wilde wrote: > I am rationalising my accounting in Gnucash and have previously had one > instance of Gnucash for each year. I now would like to load an eyara > into the current year. I have exported the earlier year as a csv file > (I have used semi-colons instead of commas) but when I go to the current > year to import it does not seem to be a possibility. It appears as > though I must in some way edit the exported file in order to import it. > > Both the earlier year and the current year have the same account list. > I am using Build ID: 4.12+(2022-09-24). > > I'd appreciate a hint on what I might be missing. > > Regards > > James Wilde > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - 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 from one gnucash file to another
James: On 2024-01-15 03:59, James Wilde wrote: I am rationalising my accounting in Gnucash and have previously had one instance of Gnucash for each year. I now would like to load an [earlier year's data] into the current year. I have exported the earlier year as a csv file (I have used semi-colons instead of commas) but when I go to the current year to import it does not seem to be a possibility. It appears as though I must in some way edit the exported file in order to import it Interesting. I imagine that some more specifics about what you are observing might help others on the list get you through the next step. You say, "when I go to the current year to import it does not seem to be a possibility." You have run GnuCash and opened the book file for the current year, the file which will receive the earlier file's data, correct? You are selecting the menu item, File -- Import -- Import Transactions from CSV, correct? Does the Transaction Import Assistant appear? Are you able to get past the first page of the Assistant? Does the "Select File for Import" page appear? In the "Select File for Import" page, are you able to locate the CSV file which has the earlier data? Is the name of that CSV file displayed as regular (black) text, or is it greyed-out text? If you click on the name of the CSV, and click the "Next" button? Does the "Import Preview" page appear? Do you encounter any problems on the "Import Preview" page? Are you able to click "Next"? Does the "Match Import and GnuCash accounts" page appear? (and so on…) I am using GnuCash in English. If you are using GnuCash in Swedish, and my English-language names do not translate easily to yours, I apologise for the confusion. Both the earlier year and the current year have the same account list. I am using Build ID: 4.12+(2022-09-24). Thank you for supplying those important facts. What computer OS are you using? Windows 11? Best regards, —Jim DeLaHunt ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Importing from one gnucash file to another
I am rationalising my accounting in Gnucash and have previously had one instance of Gnucash for each year. I now would like to load an eyara into the current year. I have exported the earlier year as a csv file (I have used semi-colons instead of commas) but when I go to the current year to import it does not seem to be a possibility. It appears as though I must in some way edit the exported file in order to import it. Both the earlier year and the current year have the same account list. I am using Build ID: 4.12+(2022-09-24). I'd appreciate a hint on what I might be missing. Regards James Wilde ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] View Transactions After Importing from CSV
During the actual importation process, GNC always shows a confirmation dialogue box to take an action on all transaction it found. This is where you get a chance to select 'A' to add transaction, 'U+C' to update and clear matched one, 'C' to clear existing matched one, or select nothing and do nothing with that transaction. This is automatic -- ie there is nothing needs to be done, either via setting or manually, to trigger it to come up during every import. Note that if a transaction is matched incorrectly, you can check either 'U+C' or 'C" and then double clicking on it will bring up another dialogue box with a list of transactions it believe matches or are similar from which you can select on that it should match with. -Original Message- From: Tom Balazs Sent: Friday, December 22, 2023 7:02 AM To: Post to GnuCash User Subject: [GNC] View Transactions After Importing from CSV I'm using Financisto+ on my Android phone. So I am often exporting transactions from that, and importing them into GnuCash. Is there an option where I can view the transactions I just imported? So they appear on one page, as if I did a Find in GnuCash. I think I came across that once, but I can't find it again. Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] View Transactions After Importing from CSV
I'm using Financisto+ on my Android phone. So I am often exporting transactions from that, and importing them into GnuCash. Is there an option where I can view the transactions I just imported? So they appear on one page, as if I did a Find in GnuCash. I think I came across that once, but I can't find it again. Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Issues Recognizing Account Names When Importing CSV into GnuCash
Thank you On Sat, Oct 7, 2023 at 3:35 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > If I'm not mistaken, you should only have to do this once per account. > Now, combining this with your other question, there is reason #2 to > break this into smaller import chunks. You don't want to have to > manually assign those in a large quantity in a single pass. > > Regards, > Adrien > > On 10/7/23 12:01 AM, Gio Bacareza wrote: > > I'm experiencing difficulties when importing a CSV file into GnuCash, > > particularly when the file contains both "Account" and "Target Account" > > columns. Despite meticulously encoding the account names in the CSV to > > match the exact account names as they appear in GnuCash (e.g., > > “Asset:Cash”), the software does not seem to automatically recognize and > > match these names during the import process. > > > > Instead, GnuCash prompts me to manually match the account names through > its > > import wizard every time, which is unexpected and inconvenient. For > > instance, even if the CSV file contains the precise name “Asset:Cash”, > > GnuCash still requires manual intervention to match the names correctly. > > > > Is there a specific reason for this issue, or am I possibly making an > error > > during the import process? I would appreciate any insight or advice on > how > > to streamline this process and ensure GnuCash recognizes account names > from > > the CSV file automatically. > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Issues Importing a Large CSV with Multiple Accounts into GnuCash: Is Duplicated Transactions Normal?
Thank you, Adrien. I get it now. On Sat, Oct 7, 2023 at 3:33 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > This is one of the reasons why it is not recommended to import a large > file, especially one containing transactions from more than a single > account on one side of each transaction. > > Read over the Help Manual & the Tutorial & Concepts Guide concerning > imports. > > The usual recommended procedure is to break the import into smaller > chunks depending on how many transactions you have in a month/year, etc. > > So for example, you might import January 2023 of your checking account. > (from whatever other app, or from a bank download) Then reconcile, and > repeat for February, then March, etc. > > As you go, you are training the matcher, so the imports speed up, and > duplicates are detected. > > It is up to you, how big the import chunks are, but bigger is not > necessarily faster, and maybe rarely is. > > Regards, > Adrien > > On 10/6/23 11:57 PM, Gio Bacareza wrote: > > I've been attempting to import a large, consolidated CSV file containing > > multiple accounts into GnuCash. Previously, I used to import transaction > > logs from various accounts individually, which I thought was a cumbersome > > process. To simplify this, I’ve created scripts to compile all > transactions > > into one comprehensive CSV file for what I thought would be a more > > straightforward import process. > > > > However, I've encountered an issue where GnuCash duplicates certain > > transactions during the import. Specifically, this happens when a > > transaction represents a withdrawal from one account and a deposit into > > another, which are naturally recorded as two separate entries in the CSV. > > For instance, when money is withdrawn from a bank account and deposited > > into a cash account, the consolidated CSV file includes one row showing > the > > bank account debit and another showing the cash account credit. > > > > I assumed that GnuCash’s import algorithm would recognize and eliminate > > these duplicate transactions during the import process as it typically > does > > with other duplicates. Unfortunately, my tests indicate that it imports > > both transactions, resulting in duplicated entries. > > > > Is this a mistake on my part, or is this behavior expected from GnuCash > > when importing a large CSV with multiple accounts? Any insights or > > solutions to prevent these duplicates would be greatly appreciated. > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- cheers, Gio ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Issues Recognizing Account Names When Importing CSV into GnuCash
If I'm not mistaken, you should only have to do this once per account. Now, combining this with your other question, there is reason #2 to break this into smaller import chunks. You don't want to have to manually assign those in a large quantity in a single pass. Regards, Adrien On 10/7/23 12:01 AM, Gio Bacareza wrote: I'm experiencing difficulties when importing a CSV file into GnuCash, particularly when the file contains both "Account" and "Target Account" columns. Despite meticulously encoding the account names in the CSV to match the exact account names as they appear in GnuCash (e.g., “Asset:Cash”), the software does not seem to automatically recognize and match these names during the import process. Instead, GnuCash prompts me to manually match the account names through its import wizard every time, which is unexpected and inconvenient. For instance, even if the CSV file contains the precise name “Asset:Cash”, GnuCash still requires manual intervention to match the names correctly. Is there a specific reason for this issue, or am I possibly making an error during the import process? I would appreciate any insight or advice on how to streamline this process and ensure GnuCash recognizes account names from the CSV file automatically. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Issues Importing a Large CSV with Multiple Accounts into GnuCash: Is Duplicated Transactions Normal?
This is one of the reasons why it is not recommended to import a large file, especially one containing transactions from more than a single account on one side of each transaction. Read over the Help Manual & the Tutorial & Concepts Guide concerning imports. The usual recommended procedure is to break the import into smaller chunks depending on how many transactions you have in a month/year, etc. So for example, you might import January 2023 of your checking account. (from whatever other app, or from a bank download) Then reconcile, and repeat for February, then March, etc. As you go, you are training the matcher, so the imports speed up, and duplicates are detected. It is up to you, how big the import chunks are, but bigger is not necessarily faster, and maybe rarely is. Regards, Adrien On 10/6/23 11:57 PM, Gio Bacareza wrote: I've been attempting to import a large, consolidated CSV file containing multiple accounts into GnuCash. Previously, I used to import transaction logs from various accounts individually, which I thought was a cumbersome process. To simplify this, I’ve created scripts to compile all transactions into one comprehensive CSV file for what I thought would be a more straightforward import process. However, I've encountered an issue where GnuCash duplicates certain transactions during the import. Specifically, this happens when a transaction represents a withdrawal from one account and a deposit into another, which are naturally recorded as two separate entries in the CSV. For instance, when money is withdrawn from a bank account and deposited into a cash account, the consolidated CSV file includes one row showing the bank account debit and another showing the cash account credit. I assumed that GnuCash’s import algorithm would recognize and eliminate these duplicate transactions during the import process as it typically does with other duplicates. Unfortunately, my tests indicate that it imports both transactions, resulting in duplicated entries. Is this a mistake on my part, or is this behavior expected from GnuCash when importing a large CSV with multiple accounts? Any insights or solutions to prevent these duplicates would be greatly appreciated. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Issues Recognizing Account Names When Importing CSV into GnuCash
I'm experiencing difficulties when importing a CSV file into GnuCash, particularly when the file contains both "Account" and "Target Account" columns. Despite meticulously encoding the account names in the CSV to match the exact account names as they appear in GnuCash (e.g., “Asset:Cash”), the software does not seem to automatically recognize and match these names during the import process. Instead, GnuCash prompts me to manually match the account names through its import wizard every time, which is unexpected and inconvenient. For instance, even if the CSV file contains the precise name “Asset:Cash”, GnuCash still requires manual intervention to match the names correctly. Is there a specific reason for this issue, or am I possibly making an error during the import process? I would appreciate any insight or advice on how to streamline this process and ensure GnuCash recognizes account names from the CSV file automatically. -- cheers, Gio ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Issues Importing a Large CSV with Multiple Accounts into GnuCash: Is Duplicated Transactions Normal?
I've been attempting to import a large, consolidated CSV file containing multiple accounts into GnuCash. Previously, I used to import transaction logs from various accounts individually, which I thought was a cumbersome process. To simplify this, I’ve created scripts to compile all transactions into one comprehensive CSV file for what I thought would be a more straightforward import process. However, I've encountered an issue where GnuCash duplicates certain transactions during the import. Specifically, this happens when a transaction represents a withdrawal from one account and a deposit into another, which are naturally recorded as two separate entries in the CSV. For instance, when money is withdrawn from a bank account and deposited into a cash account, the consolidated CSV file includes one row showing the bank account debit and another showing the cash account credit. I assumed that GnuCash’s import algorithm would recognize and eliminate these duplicate transactions during the import process as it typically does with other duplicates. Unfortunately, my tests indicate that it imports both transactions, resulting in duplicated entries. Is this a mistake on my part, or is this behavior expected from GnuCash when importing a large CSV with multiple accounts? Any insights or solutions to prevent these duplicates would be greatly appreciated. -- cheers, Gio ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 stock prices from a CSV file
> On Oct 2, 2023, at 01:46, flywire wrote: > > While importing csv files is only really explained in the manual > (not the guide) in terms of transactions, there is a lot of supporting https://www.gnucash.org/docs/v5/C/gnucash-manual/trans-import.html#trans-import-csv > > > information for the Price Import Assistant in > https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-price.html and > https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-security-edit.html > > The term security seems to be used interchangeably (ie it's not a subset) > with commodity and a symbol is a property of a commodity. > > - > > *Commodity: *A commodity is something of value that is easily tradeable > or sellable; for example, currencies, stocks, bonds, grain, copper, and oil > are all commodities. > > https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-security-edit.html > clearly describes Securities types are currency, fund, listing stock > exchange, or a user defined type. It seems some user defined types, for > example grain, would turn this into a commodity. It conflicts with the > second sentence below: > > - > > > *Security: The Security/commodity being priced. The display is sorted by > the Namespace that the individual securities are listed on. * > - > > *Symbol:* Indicates the symbol or abbreviation for the commodity. This > is usually the ticker symbol (for stocks) or other unique abbreviation for > the commodity. If the commodity is traded on any public exchange, it is > important to use the same identifier used on that exchange. For national > currencies the symbol is the ISO-4217 currency code. > - > > *Namespace:* What is a reasonable description of this group [of > commodities ??] ? The only reference to Namespace in the documentation is > quoted above but referring to a group of stock by listing exchange is too > restrictive. Namespace is the better name for security type. The Security Editor manual page is out of date, we've removed the hard-coded namespaces FUND, AMEX, ASX, EUREX, NASDAQ, and NYSE from the program; they seemed to be more confusing than helpful because they obscured that users could create their own. 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 - 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 stock prices from a CSV file
While importing csv files is only really explained in the manual https://www.gnucash.org/docs/v5/C/gnucash-manual/trans-import.html#trans-import-csv (not the guide) in terms of transactions, there is a lot of supporting information for the Price Import Assistant in https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-price.html and https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-security-edit.html The term security seems to be used interchangeably (ie it's not a subset) with commodity and a symbol is a property of a commodity. - *Commodity: *A commodity is something of value that is easily tradeable or sellable; for example, currencies, stocks, bonds, grain, copper, and oil are all commodities. https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-security-edit.html clearly describes Securities types are currency, fund, listing stock exchange, or a user defined type. It seems some user defined types, for example grain, would turn this into a commodity. It conflicts with the second sentence below: - *Security: The Security/commodity being priced. The display is sorted by the Namespace that the individual securities are listed on. * - *Symbol:* Indicates the symbol or abbreviation for the commodity. This is usually the ticker symbol (for stocks) or other unique abbreviation for the commodity. If the commodity is traded on any public exchange, it is important to use the same identifier used on that exchange. For national currencies the symbol is the ISO-4217 currency code. - *Namespace:* What is a reasonable description of this group [of commodities ??] ? The only reference to Namespace in the documentation is quoted above but referring to a group of stock by listing exchange is too restrictive. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 stock prices from a CSV file
Can we focus this back on improving the clarity of the Price Import Assistant? The first page is essentially the full documentation of the process. https://github.com/Gnucash/gnucash/blob/5.4/gnucash/gtkbuilder/assistant-csv-price-import.glade#L55 uses the column labels: Date, Amount, From Namespace, From Symbol and Currency To, irrespective of the labels used elsewhere for this data. A csv file can use any column order, a header is optional, and the Import Assistant doesn't use the header names. Various options exist for specifying the delimiter as well as a fixed width option. Double quotes are not required as shown in other examples. I am confused by seemingly different labels being used within GnuCash for the same data and I highlighted Commodity, Security, Namespace and Symbol. How exactly is "CURRENCY" used in that example? Does it refer to the default for the security or user/file? It also seems From Symbol for https://www.vanguard.com.au/personal/invest-with-us/etf?portId=8205 could be VAS, VAS.ASX, or VAS.AX (ie custom Yahoo exchange code). I understand >From Namespace is any convenient label the user chooses for the group of Securities [??], not necessarily the Stock Exchange which could form part of the From Symbol. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 stock prices from a CSV file
Attached is a file of what it would look like with same security prices for different day and with multiple of these examples repeated for other securities and/or indexes ... -Original Message- From: Kalpesh Patel Sent: Sunday, October 01, 2023 7:49 PM To: 'flywire' ; 'Ove Grunnér' Cc: 'Gnucash Users' Subject: RE: [GNC] Importing stock prices from a CSV file Just to remove any confusion, the CSV format of the importing stock prices as of GNC v4.18 is as follows (which I don’t believe has changed in later and 5.x version)... "NAME_SPACE","TICKER_SYMBOL",date,"PRICE","QUOTE_CURRENCY" One line per record each formatted as denoted above. Double quotes around NAME_SPACE, TICKER_SYMBOL, PRICE and QUOTE_CURRENCY are required. Date format I've utilized and has worked flawlessly has been mm/dd/. NAME_SPACE corresponds to the top level name given in the 'Security' column in the 'Price Database' window and corresponds to 'From Namespace' heading in the 'Import Preview' window. I normally set this to what Yahoo Finance reports as the exchange where the security trades. This also is same thing as 'Namespace" in the 'Securities' window. See code at https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/get_historic_quotes.py for details if you are knowledged in Python. https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/README.md has additional details... -Original Message- From: flywire Sent: Saturday, September 30, 2023 6:46 PM To: Ove Grunnér Cc: Gnucash Users Subject: Re: [GNC] Importing stock prices from a CSV file Yes Ove, clearly there is more to it as demonstrated by your example. I can see the importer is using Commodity, Price Database uses Security, and Security Editor uses Namespace and Symbol. https://www.gnucash.org/docs/v5/C/gnucash-guide/gnc-gloss.html doesn't help much. gnucash_quotes.csv Description: MS-Excel spreadsheet ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 stock prices from a CSV file
Just to remove any confusion, the CSV format of the importing stock prices as of GNC v4.18 is as follows (which I don’t believe has changed in later and 5.x version)... "NAME_SPACE","TICKER_SYMBOL",date,"PRICE","QUOTE_CURRENCY" One line per record each formatted as denoted above. Double quotes around NAME_SPACE, TICKER_SYMBOL, PRICE and QUOTE_CURRENCY are required. Date format I've utilized and has worked flawlessly has been mm/dd/. NAME_SPACE corresponds to the top level name given in the 'Security' column in the 'Price Database' window and corresponds to 'From Namespace' heading in the 'Import Preview' window. I normally set this to what Yahoo Finance reports as the exchange where the security trades. This also is same thing as 'Namespace" in the 'Securities' window. See code at https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/get_historic_quotes.py for details if you are knowledged in Python. https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/README.md has additional details... -Original Message- From: flywire Sent: Saturday, September 30, 2023 6:46 PM To: Ove Grunnér Cc: Gnucash Users Subject: Re: [GNC] Importing stock prices from a CSV file Yes Ove, clearly there is more to it as demonstrated by your example. I can see the importer is using Commodity, Price Database uses Security, and Security Editor uses Namespace and Symbol. https://www.gnucash.org/docs/v5/C/gnucash-guide/gnc-gloss.html doesn't help much. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 stock prices from a CSV file
Yes Ove, clearly there is more to it as demonstrated by your example. I can see the importer is using Commodity, Price Database uses Security, and Security Editor uses Namespace and Symbol. https://www.gnucash.org/docs/v5/C/gnucash-guide/gnc-gloss.html doesn't help much. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 stock prices from a CSV file
Hi, if it helps, this is what an import file can look like when importing stock prices. the name space for stocks is the same name space you see in the security editor Menu -> Tools:Security Editor. So if you call the namespace for a stock e.g. NASDAQ when you create the stock, then that will be the name space you need when importing stock prices. file example Account_Name,Rate,Balance Currency,Date,Name Space ALV.DE,207.95,EUR,2023-06-10,Euronext AMZN,123.43,USD,2023-06-10,NASDAQ ASML.AS,666.6,EUR,2023-06-10,Euronext AZN.ST,1598,SEK,2023-06-10,StockholmsBorsen BAS.DE,46.02,EUR,2023-06-10,Euronext CA.PA,26.52,EUR,2023-06-10,Euronext Kind Regards, Ove. On Sat, 30 Sept 2023 at 22:31, flywire wrote: > The process works but the Price Import Assistant Summary description and > poor user interface labels are confusing. I use csv import all the time but > this is so bad I can't understand it. > > [the minimum columns] are Date, Amount, From Namespace, From Symbol and > Currency To. If all entries are for the same Commodity / Currency then you > can select them and then the columns will be Date and Amount... > > Examples are "FTSE","RR.L","21/11/2016",5.345,"GBP” and > CURRENCY:USD;2016-11-21;1.56;GBP > > Isn't FTSE an index and what is the .L ? So currency can be prefixed with > CURRENCY: ? > > I don't understand the data (except date and amount) which means I can't > understand the column format example. It would be a lot clearer if the > columns were in the same order as the description, and even better with a > header line, so the data didn't have to be understood to understand > the columns. > > I still have no idea what the file would look like when all entries are > the same commodity... > > Surely this process should support the default currency like elsewhere in > GnuCash and the column names are absurd. > > Thanks Ken. That link had a nice clear example but it will not work now > without the From Namespace (coder jargon for Stock Exchange). > > I just tested with the following CSV: > AAPL,23/8/2018,USD,255.37 > ABF.L,23/8/2018,GBP,25 > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - 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 stock prices from a CSV file
The process works but the Price Import Assistant Summary description and poor user interface labels are confusing. I use csv import all the time but this is so bad I can't understand it. [the minimum columns] are Date, Amount, From Namespace, From Symbol and Currency To. If all entries are for the same Commodity / Currency then you can select them and then the columns will be Date and Amount... Examples are "FTSE","RR.L","21/11/2016",5.345,"GBP” and CURRENCY:USD;2016-11-21;1.56;GBP Isn't FTSE an index and what is the .L ? So currency can be prefixed with CURRENCY: ? I don't understand the data (except date and amount) which means I can't understand the column format example. It would be a lot clearer if the columns were in the same order as the description, and even better with a header line, so the data didn't have to be understood to understand the columns. I still have no idea what the file would look like when all entries are the same commodity... Surely this process should support the default currency like elsewhere in GnuCash and the column names are absurd. Thanks Ken. That link had a nice clear example but it will not work now without the From Namespace (coder jargon for Stock Exchange). I just tested with the following CSV: AAPL,23/8/2018,USD,255.37 ABF.L,23/8/2018,GBP,25 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 stock prices from a CSV file
I'll refer you to a process I sent in to the lists a while back. https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079430.html David T. On Sep 30, 2023, 1:38 AM, at 1:38 AM, flywire wrote: >I'll work with the Price Import Assistant druid. Is it actually >documented? >I found >https://wiki.gnucash.org/wiki/CSV_Import/Export#Importing_Prices > >> >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >- >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 - 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 stock prices from a CSV file
I'm not sure about the process. I'm led to believe it's built into GnuCash and relatively simple to use? Here's a past discussion prompted by someone having difficulties and eventually figuring it out: https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079372.html Hopefully this will be helpful, at least it gives some examples of correct format, etc. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 stock prices from a CSV file
Here's a couple of examples: https://wiki.gnucash.org/wiki/Importing_fund_or_stock_prices_from_an_OFX_file https://wiki.gnucash.org/wiki/Stocks/get_prices On 9/29/23 16:33, flywire wrote: I'll work with the Price Import Assistant druid. Is it actually documented? I found https://wiki.gnucash.org/wiki/CSV_Import/Export#Importing_Prices ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
