Re: [GNC] Anomalous behaviour of a Bank Account Register
It seems you have inadvertently expanded the hidden Rate column beyond its usual 1 pixel width - see this thread for details - https://lists.gnucash.org/pipermail/gnucash-user/2021-January/095003.html Judging by the thick line to the left of the "R" (Reconcile) column you perhaps have reduced that to a 1 pixel width at some tome. Cheers, the other David. On Fri, 1 Sept 2023 at 21:52, Peter Jackson wrote: > Hello, > I am using Gnucash 5.3 on Windows 11. > I noticed today that the balances on this account were not arithmetically > correct so I ran Check and Repair on all transactions in this account, > which then agreed with my actual bank balance. > I then noticed that this account does not show the Transfer column, but > does have an additional column to the right of Balnce, headed Rate. > Screenshot attached. > I can find no way to remedy this so that it looks like my other Bank > registers. > Can you help please? > Peter > [image: 2023-09-01 Smile.png] > ___ > 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] Anomalous behaviour of a Bank Account Register
Peter, Use the Edit Account dialogue and check the account type of the account. To get the Rate column it is likely that it is of type "Asset" but one of the subtypes of "Asset", "Stock" etc. If it is a bank account it should be of type "Bank" as this will enable some features specific to bank accounts. David Cousens On Fri, 2023-09-01 at 12:47 +0100, Peter Jackson wrote: > Hello, > I am using Gnucash 5.3 on Windows 11. > I noticed today that the balances on this account were not arithmetically > correct so I ran Check and Repair on all transactions in this account, > which then agreed with my actual bank balance. > I then noticed that this account does not show the Transfer column, but > does have an additional column to the right of Balnce, headed Rate. > Screenshot attached. > I can find no way to remedy this so that it looks like my other Bank > registers. > Can you help please? > Peter > [image: 2023-09-01 Smile.png] > ___ > 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] Import question
Did you try toggling the currency format you wanted to input. also check if your csv is reflecting the right format Saludos Cordiales Murugan From: gnucash-user on behalf of Nicolas de La Chaise via gnucash-user Sent: Thursday, August 31, 2023 5:07 PM To: gnucash-user@gnucash.org Subject: [GNC] Import question Hello all, First of all, I want to take this opportunity to thank all the posters and developers who dedicate so much of their time to help the ungrateful mass I belong to. You guys rock. Now, my silly problem... My bank only offers 2 formats when exporting transactions: either QIF or CSV. If I choose to import in QIF, there is no way to see the amount of the transaction that is being imported. I find it quite useful as some online shopping transactions can fall into many different accounts. Would it be possible to see it added in an upcoming version? Now, to go around this I was hoping to use the csv format. Only to hit a different problem. The CSV I import has French number formatting (decimal separator is ','). And when the import tool runs it seems to get awfully confused by it. In the screenshot below, amounts should be (for UK/US readers) -50.8 / -40.0 / -5.7 / -1.6 I already poked around with encoding and currency format to no avail. The amount is split in two and cannot be glued back together. Do anyone has a workaround? Note: GNC 4.4 Debian 10 Thanks a lot! 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.
Re: [GNC] Import question
Hello Nicolas, I'm on GnuCash 5.3 already. Here you can freely choose the currency format in the import dialogue, i.e. the decimal separator can be changed from comma to point or vice versa. So updating your GnuCash could be very easy solution to your issue. Greetings Carsten Am 31.08.2023 um 23:07 schrieb Nicolas de La Chaise via gnucash-user: Hello all, First of all, I want to take this opportunity to thank all the posters and developers who dedicate so much of their time to help the ungrateful mass I belong to. You guys rock. Now, my silly problem... My bank only offers 2 formats when exporting transactions: either QIF or CSV. If I choose to import in QIF, there is no way to see the amount of the transaction that is being imported. I find it quite useful as some online shopping transactions can fall into many different accounts. Would it be possible to see it added in an upcoming version? Now, to go around this I was hoping to use the csv format. Only to hit a different problem. The CSV I import has French number formatting (decimal separator is ','). And when the import tool runs it seems to get awfully confused by it. In the screenshot below, amounts should be (for UK/US readers) -50.8 / -40.0 / -5.7 / -1.6 I already poked around with encoding and currency format to no avail. The amount is split in two and cannot be glued back together. Do anyone has a workaround? Note: GNC 4.4 Debian 10 Thanks a lot! 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.
[GNC] Advance portfolio report between two dates
Hello friends Greetings. I wish to understand, if I can run advance portfolio report between two dates. The needs arises from the fact that I wish to monitor, as how my investment is doing between two dates (for example between August 1, 2023 and August 31, 2023) I tried to select dates in General options, but it shows report till date or till period, but does not show from date. Thanking you Paras ___ 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.
