[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] Reports exist but display blank?
The easy way to determine if it is a CSS issue is to try to select anything, or select-all and then copy/paste to anything else like a spreadsheet or text file. But usually just trying to select will produce a highlight and reveal text that matches the background. Regards, Adrien On 10/6/23 6:27 PM, Elmar wrote: I'm running Version: 5.4 Build ID: Flathub 5.4.1 Finance::Quote: 1.58 of GC under Linux Mint 21.2 All reports, not only my saved ones, but all of them under the reports tab, now display a blank window. All the options are still set as I had them when I look at the report's options (accounts reported, etc.), but nothing is displayed. Is this a white on white font problem, and if so, where do I correct 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] Custom Multicolumn Report - Win 10
When I make changes to a report settings, then go back to the report I click the reload button and the changes take effect; also if I make changes to a transaction, for example changing the Reconciled from 'n' to 'c'. Have you tried using the reload button? On Fri, 6 Oct 2023 at 22:46, David H wrote: > Hi Nigel, > > Clicking the apply button applies the changes within a second or two for me > in the displayed report. Obviously saving the report will save the options > currently selected as the default options for the report so when you > re-open it the saved options will be used. > > I'm just using the Account Summary and Cash Flow reports in my testing with > columns initially set to 1 then changed to 2, click apply and the report > updates from 1 column to 2 columns side by side. So working as > expected for me here, when I click apply the report updates. > > Perhaps you can provide details of exactly what reports you are > displaying and the options you are setting then I can try an exact match > here. I would point out that if you are displaying a Transaction type > report it does take a while to refresh the display because of the number of > txns, > > Cheers David H. > > > On Sat, 7 Oct 2023 at 06:22, Nigel Stapley wrote: > > > Hi Again > > > > Having looked at this further. I can make changes to the options on a > > report but the change is not reflected in the display. This appears to be > > true for any change. However if I save the report, close the display and > > then reopen it the changes are present. This seems to imply it is > program > > rather than machine related. > > Nigel > > > > On Fri, 6 Oct 2023 at 00:33, kirk abbott wrote: > > > >> This worked fine for me as well. It could be the result of a transitory > >> glitch error. I sometimes run into locked file issues when using > Gnucash. > >> Normally I can still make the entries that I want, but if not, reloading > >> Gnucash usually fixes whatever it is going on. > >> > >> On Thursday, October 5, 2023 at 02:22:54 PM PDT, David H < > >> hell...@gmail.com> wrote: > >> > >> > >> Hi Nigel, > >> > >> Working fine here on Win 10 (x2) and Win 11. Never used this report > >> before > >> but it came up initially with the usual blank report, then went into > >> options and added "Account Summary" and "Cash Flow" Reports which seemed > >> to > >> display ok using all available stylesheets. > >> > >> Cheers David H. > >> > >> > >> On Wed, 4 Oct 2023 at 05:27, Nigel Stapley > wrote: > >> > >> > Hi > >> > Just installed Gnucash Build ID: 5.4+(2023-09-23) on Win 10. > >> > > >> > Using Custom Multicolumn Report produces reports that are locked. No > >> > options can be changed as far as I am able to determine. Can anyone > >> else > >> > confirm this? > >> > > >> > Nigel > >> > ___ > >> > 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. > ___ 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] Reports exist but display blank?
Elmar, Read the other thread in the mailing list re "Reports not displaying" for a work around - https://lists.gnucash.org/pipermail/gnucash-user/2023-October/109024.html Cheers David H. On Sat, 7 Oct 2023 at 09:28, Elmar wrote: > I'm running Version: 5.4 Build ID: Flathub 5.4.1 Finance::Quote: 1.58 of > GC under Linux Mint 21.2 > > All reports, not only my saved ones, but all of them under the reports > tab, now display a blank window. All the options are still set as I had > them when I look at the report's options (accounts reported, etc.), but > nothing is displayed. Is this a white on white font problem, and if > so, where do I correct it? > > - Elmar > > ___ > 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] Custom Multicolumn Report - Win 10
On 2023-10-06 13:21, Nigel Staples wrote: > Having looked at this further. I can make changes to the options on a > report but the change is not reflected in the display. This appears to be > true for any change. However if I save the report, close the display and > then reopen it the changes are present. This seems to imply it is program > rather than machine related. Always press Ctrl+R after changing report options or changing the underlying data. Sometimes it's not necessary, but it never hurts. Stan Brown Tehachapi, CA, USA https://BrownMath.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] Reports exist but display blank?
I'm running Version: 5.4 Build ID: Flathub 5.4.1 Finance::Quote: 1.58 of GC under Linux Mint 21.2 All reports, not only my saved ones, but all of them under the reports tab, now display a blank window. All the options are still set as I had them when I look at the report's options (accounts reported, etc.), but nothing is displayed. Is this a white on white font problem, and if so, where do I correct it? - Elmar ___ 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] Custom Multicolumn Report - Win 10
Hi Nigel, Clicking the apply button applies the changes within a second or two for me in the displayed report. Obviously saving the report will save the options currently selected as the default options for the report so when you re-open it the saved options will be used. I'm just using the Account Summary and Cash Flow reports in my testing with columns initially set to 1 then changed to 2, click apply and the report updates from 1 column to 2 columns side by side. So working as expected for me here, when I click apply the report updates. Perhaps you can provide details of exactly what reports you are displaying and the options you are setting then I can try an exact match here. I would point out that if you are displaying a Transaction type report it does take a while to refresh the display because of the number of txns, Cheers David H. On Sat, 7 Oct 2023 at 06:22, Nigel Stapley wrote: > Hi Again > > Having looked at this further. I can make changes to the options on a > report but the change is not reflected in the display. This appears to be > true for any change. However if I save the report, close the display and > then reopen it the changes are present. This seems to imply it is program > rather than machine related. > Nigel > > On Fri, 6 Oct 2023 at 00:33, kirk abbott wrote: > >> This worked fine for me as well. It could be the result of a transitory >> glitch error. I sometimes run into locked file issues when using Gnucash. >> Normally I can still make the entries that I want, but if not, reloading >> Gnucash usually fixes whatever it is going on. >> >> On Thursday, October 5, 2023 at 02:22:54 PM PDT, David H < >> hell...@gmail.com> wrote: >> >> >> Hi Nigel, >> >> Working fine here on Win 10 (x2) and Win 11. Never used this report >> before >> but it came up initially with the usual blank report, then went into >> options and added "Account Summary" and "Cash Flow" Reports which seemed >> to >> display ok using all available stylesheets. >> >> Cheers David H. >> >> >> On Wed, 4 Oct 2023 at 05:27, Nigel Stapley wrote: >> >> > Hi >> > Just installed Gnucash Build ID: 5.4+(2023-09-23) on Win 10. >> > >> > Using Custom Multicolumn Report produces reports that are locked. No >> > options can be changed as far as I am able to determine. Can anyone >> else >> > confirm this? >> > >> > Nigel >> > ___ >> > 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] Custom Multicolumn Report - Win 10
Hi Again Having looked at this further. I can make changes to the options on a report but the change is not reflected in the display. This appears to be true for any change. However if I save the report, close the display and then reopen it the changes are present. This seems to imply it is program rather than machine related. Nigel On Fri, 6 Oct 2023 at 00:33, kirk abbott wrote: > This worked fine for me as well. It could be the result of a transitory > glitch error. I sometimes run into locked file issues when using Gnucash. > Normally I can still make the entries that I want, but if not, reloading > Gnucash usually fixes whatever it is going on. > > On Thursday, October 5, 2023 at 02:22:54 PM PDT, David H < > hell...@gmail.com> wrote: > > > Hi Nigel, > > Working fine here on Win 10 (x2) and Win 11. Never used this report before > but it came up initially with the usual blank report, then went into > options and added "Account Summary" and "Cash Flow" Reports which seemed to > display ok using all available stylesheets. > > Cheers David H. > > > On Wed, 4 Oct 2023 at 05:27, Nigel Stapley wrote: > > > Hi > > Just installed Gnucash Build ID: 5.4+(2023-09-23) on Win 10. > > > > Using Custom Multicolumn Report produces reports that are locked. No > > options can be changed as far as I am able to determine. Can anyone else > > confirm this? > > > > Nigel > > ___ > > 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] OFX Import Mappings
I've already searched all the tabs for any occurence of the disabled account...there were none. I'm pretty sure that I've previously deleted all my Vanguard online mappings to get a clean slate, but still ended up with GC importing transactions to the placeholder account. I'll try deleting the online mapping again to make sure that I really have tried that approach to see if it will reset, FYI... GC has behaved this way for quite a while now, but frequently I just manually enter if there are just a few transactions. I only think about it when I do an import (like for an end-of-quarter) On Sun, Oct 1, 2023 at 8:04 PM Kalpesh Patel wrote: > Rob - It is Import Map Editor. What you want to select is the 'Online' at > the top where you will see three total choices - Bayesian (selected by > default), Non-Bayesian and Online. Unfortunately you can only delete > entries here in the Import Map Editor so find the one that is errant as > mentioned below and delete it. Next time you import it, GNC will ask you to > map the account which is the opportunity you want to take to wire it up > correctly. > > Hope this helps. > > -Original Message- > From: Rob LaRose > Sent: Saturday, September 30, 2023 11:54 AM > To: gnucash-user@gnucash.org > Subject: [GNC] OFX Import Mappings > > Sometime ago, Vanguard replaced one of their Money Market funds with a new > Money Market fund. > In GC, I created a new fund account to handle the change. > Once all the transfer transactions for the old fund account were complete, > I: > - Renamed the account: to move it to the bottom of any acct list as well > as identify it as an inactive account > - Set the account as a placeholder: to prevent accidentally creating > transactions > - Hid the account: so that I wouldn't have to look at it all the time. > > However, now when I import an OFX file from Vanguard, income transactions > for the new fund account are entered as being sourced from the renamed, > placeholder account instead of the appropriate income account for the new > fund. > > I figured this had something to do with the Import Map Editor. I searched > for the renamed account that GC was using and found no matches. > I even deleted all the mappings figuring I would just rebuild the account > matches but for some reason, it keeps using the old account. > > There must be some other location where GC has stored this association. > How do I resolve the mapping issue so that transactions get associated to > the correct income account? > > GnuCash: Flatpak v5.4.1 > OS: Ubuntu 23.04 > > Thanks > Rob > > > ___ 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] GnuCash_user: rounding errors and significant digits
> On Oct 6, 2023, at 9:39 AM, Bruce McCoy via gnucash-user > wrote: > > Hi Everyone, > On Tue, Sep 26 at 12:50 PM John Ralls wrote:>GnuCash uses a pair of > stack-allocated 128-bit integers (see. . . > > Thanks. Well done. > > > What are the plans to help our users whose books are out of balance by a cent > or so? GnuCash's rounding isn't likely to put books out of balance because GnuCash forces transactions to be balance in the transaction currency. Book out of balance, meaning that the trial balance report doesn't balance with the Average Cost price source, nearly always results from not computing capital gains/losses correctly. Interpret that broadly: Computing cost of goods sold is the same calculation by a different name and often crossing more transaction steps. GnuCash automates only the simplest case via the lot scrubber so it's pretty much up to the user to be meticulous when creating those splits/transactions. 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] W11-Installing Gnucash to D Drive
It does, but only if you don't have GnuCash already installed: If you do it replaces the existing installation. So if you want to change where GnuCash is installed you have to uninstall GnuCash first. Right-click on the Start icon, select Apps & Features, scroll down to GnuCash and click it, click Uninstall, approve the User Authorization Escalation, and click through the dialogs. Regards, John Ralls > On Oct 6, 2023, at 9:31 AM, kschneider bout-tyme.net > wrote: > > It’s been awhile since I installed GNC. Does the installer ask for an > installation path? > Ken Schneider > >> On Oct 6, 2023, at 12:25 PM, Veli Izzet wrote: >> >> Hi, >> >> I want to install Gnucash to D: drive, not to c: drive. Installer does not >> ask for the installation drive though. >> >> Any help? >> >> 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. ___ 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] GnuCash_user: rounding errors and significant digits
Hi Everyone, On Tue, Sep 26 at 12:50 PM John Ralls wrote: >GnuCash uses a pair of stack-allocated 128-bit integers (see. . . Thanks. Well done. What are the plans to help our users whose books are out of balance by a cent or so? Best Regards, Bruce | | Virus-free.www.avast.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] W11-Installing Gnucash to D Drive
It’s been awhile since I installed GNC. Does the installer ask for an installation path? Ken Schneider > On Oct 6, 2023, at 12:25 PM, Veli Izzet wrote: > > Hi, > > I want to install Gnucash to D: drive, not to c: drive. Installer does not > ask for the installation drive though. > > Any help? > > 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] W11-Installing Gnucash to D Drive
Hi, I want to install Gnucash to D: drive, not to c: drive. Installer does not ask for the installation drive though. Any help? Thanks -- Veli İzzet Çığırgan ___ 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] GnuCash_user: rounding errors and significant digits
Hi, On9/25/2023 9:50 PM, Adrien Monteleone wrote: >you likely can't send zip files through this >mailman instance. OK.I wondered about that. Thanks. >postthem on a hosting site and simply >paste the links in another reply. OK.230925__to_Jim_DeLaHunt_gnucash-users.zip is just the post of Sept 25with graphics. It is at https://tempsend.com/juqkx >textspacing Thankyou for telling me. Using a mono-spaced font corrected the situation. OnTue, Sep 26 at 9:16 AM Michael Novack wrote: >Whenperforming arithmetic operations with >EXACT values we can expect to >getthe same final result regardless of the >order in which the operationsare performed >(as long as a legal order). > >Whenperforming arithmetic operations with >ROUNDED values we can NOT expectto get the >same final result. Wellsaid. That is the point which was to be made. Changing the order ofrounding, as you said, can change the rounded results. Also, I havefaced similar government forms, as you have. I am glad to know youwere successful in completing them. BestRegards. Bruce | | Virus-free.www.avast.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.
