[GNC] What is Unrealized Losses/Gain in Balance Sheet Report ?

2020-04-07 Thread Long
Hello, First, i'm not an accounting, and trying to use GnuCash to manager my finances. I'm managing multiple currency in GnuCash, and i created Bank account for each currency i had. And everytime my currency rate changed, i changed it in "Price Database". And Balance Sheet report show me Unreali

Re: [GNC] Improve imported transaction category matching

2020-04-07 Thread Adrien Monteleone
I’m not certain, maybe someone else can help, but knowing which file format makes a difference to the devs, thanks. Regards, Adrien > On Apr 7, 2020 w15d98, at 7:20 PM, Giuseppe Quinn wrote: > > I’ve been using OFX > > Is there a pfile or something that might be corrupted that I can set aside

Re: [GNC] Improve imported transaction category matching

2020-04-07 Thread Giuseppe Quinn
I’ve been using OFX Is there a pfile or something that might be corrupted that I can set aside to test and or start over? Thanks for the help! > On Apr 7, 2020, at 1:11 PM, Adrien Monteleone > wrote: > > What type of import? QIF, CSV? > > Regards, > Adrien > > p.s. —please be sure to ‘rep

Re: [GNC] GNUCash beginner setup

2020-04-07 Thread David Carlson
Denz, Do you use the 'Basic Ledger View'? In that view you do not see any split lines, only an indication that they exist. Switch to either one of the other views to see the split lines. On Tue, Apr 7, 2020 at 6:02 PM David Carlson wrote: > Maybe I should have mentioned that I do that acciden

Re: [GNC] GNUCash beginner setup

2020-04-07 Thread Adrien Monteleone
I’ve done this many times, but on purpose. (I’m in the middle of such an exercise right now) From time to time, I refactor some expenses to better reflect how I want to keep track of things. I may only need to move a subset of transactions from one account to another. I do a Find to obtain my

Re: [GNC] GNUCash beginner setup

2020-04-07 Thread David Carlson
Maybe I should have mentioned that I do that accidentally all too often...😐 On Tue, Apr 7, 2020 at 5:59 PM David Carlson wrote: > Michael, in fact, you *Can* change the "home' account line. You will know > that it worked when the transaction disappears from the register view. > > I don't recomm

Re: [GNC] GNUCash beginner setup

2020-04-07 Thread David Carlson
Michael, in fact, you *Can* change the "home' account line. You will know that it worked when the transaction disappears from the register view. I don't recommend that because you cannot see what you just did and there is no warning that the transaction will disappear or chance to discard the edi

Re: [GNC] CRIT [gnc_price_unref()] last unref while price in database

2020-04-07 Thread John Ralls
Excellent that you're back in business. What was wrong with the transaction? Regards, John Ralls > On Apr 7, 2020, at 12:15 PM, wrote: > > Many thanks for that, John. > > I'd already got the same error when I opened the last backup file, which is > why I assumed it was more than just a corru

Re: [GNC] GNUCash beginner setup

2020-04-07 Thread Michael or Penny Novack
On 4/7/2020 4:30 PM, jess wrote: The opening balance in the previous message refers to the current balance I have on my bank account in real life. I was able to solve this too. It works for resolution if the imbalanced transactions are assigned an account inside the checking account transaction

Re: [GNC] Australian Foreign Investments Taxation

2020-04-07 Thread David H
Hi Ben, Isn't Libre Office able to highlight a column and change the date format from dd/mmm/ccyy to dd/mm/ccyy for instance ?? Cheers David H. On Wed, 8 Apr 2020 at 00:54, Ben Stanley wrote: > Hello Gnucash Users, > > I have now downloaded the foreign exchange rates from the Reserve Bank > of

Re: [GNC] GNUCash beginner setup

2020-04-07 Thread David Carlson
In any register view you can highlight the account name in a split line if you are in the Auto-split ledger or transduction journal view, right click and select any account name in the drop-down list. If you happen to be in the only split line of a transaction that is the same as the current accou

Re: [GNC] Starting Balance in Reconciliation Window wrong

2020-04-07 Thread David Cousens
Thanks Maf, Yes it does shed a bit of light. Funny when I searched the bug list on reconciliation it didn't throw up Christopher Lam's feature 797640 or the earlier 797040 as well as Dave Reiser's thread. I am in discussion With Christopher Lam about the situation in Bugzilla (bug 797668). David

Re: [GNC] GNUCash beginner setup

2020-04-07 Thread jess
The opening balance in the previous message refers to the current balance I have on my bank account in real life. I was able to solve this too. It works for resolution if the imbalanced transactions are assigned an account inside the checking account transaction list. If you try to assign the acco

Re: [GNC] CRIT [gnc_price_unref()] last unref while price in database

2020-04-07 Thread rgwbruce
Many thanks for that, John. I'd already got the same error when I opened the last backup file, which is why I assumed it was more than just a corrupt data file. I had to go back 3 versions before I found the one that loaded, but I've then been able to import all the subsequent log files. There w

Re: [GNC] Gnucash 3.9 Flathub stucks

2020-04-07 Thread Adrien Monteleone
Geert offered the command(s). Try that first. Regards, Adrien > On Apr 7, 2020 w15d98, at 1:55 PM, Finfort wrote: > > Thank you Adrien. > Maybe it is better to build it myself from the last source? > > >> On Apr 7, 2020 at 21:38, wrote: >> >> That’s why I mentioned ’flatpak specifics’. Sear

Re: [GNC] Improve imported transaction category matching

2020-04-07 Thread Adrien Monteleone
What type of import? QIF, CSV? Regards, Adrien p.s. —please be sure to ‘reply-list’ or ‘reply-all’ so others can benefit from the discussion and/or offer help. > On Apr 7, 2020 w15d98, at 2:01 PM, Giuseppe Quinn wrote: > > Yea, I’ve done them over and over in the import window, to no avail. >

Re: [GNC] Gnucash 3.9 Flathub stucks

2020-04-07 Thread Finfort
Thank you Adrien. Maybe it is better to build it myself from the last source? > > On Apr 7, 2020 at 21:38, (mailto:adrien.montele...@lusfiber.net)> wrote: > > > > That’s why I mentioned ’flatpak specifics’. Search for 'how to launch a > flatpak app f

Re: [GNC] Improve imported transaction category matching

2020-04-07 Thread Adrien Monteleone
Make sure you are doing those assignments within the import window. If you import first, then edit transactions to correct Imbalance-xyz to proper accounts, the importer never gets to learn. Regards, Adrien > On Apr 7, 2020 w15d98, at 1:45 PM, Giuseppe Quinn wrote: > > Is there a way to impro

[GNC] Improve imported transaction category matching

2020-04-07 Thread Giuseppe Quinn
Is there a way to improve category matching of imported transactions? Every session I have to tell GC which category grocery store transactions, CC payments, and every other repeating transaction, which category they go into. ___ gnucash-user mailing

Re: [GNC] Gnucash 3.9 Flathub stucks

2020-04-07 Thread Geert Janssens
Try flatpak run org.gnucash.GnuCash Or even better flatpak run org.gnucash.GnuCash --logto stdout The latter will print all logs to the console rather than to an inaccessible trace file. Regards, Geert Op dinsdag 7 april 2020 20:31:55 CEST schreef Adrien Monteleone: > That’s why I mentioned

Re: [GNC] Inability to import CSV files.

2020-04-07 Thread Geert Janssens
Hi Aixza, It's proper to send your replies to the list (using e-mail address gnucash-user@gnucash.org) rather than sending to individuals. By keeping the conversation on the list others can benefit from the answers given or chime in whenever appropriate. Having said that it's very unlikely "s

Re: [GNC] Gnucash 3.9 Flathub stucks

2020-04-07 Thread Adrien Monteleone
That’s why I mentioned ’flatpak specifics’. Search for 'how to launch a flatpak app from the command line'. Sorry, I don’t use them so I don’t know the syntax right-off. Regards, Adrien > On Apr 7, 2020 w15d98, at 1:26 PM, Finfort wrote: > > Thank you, but what is the command to start it? > J

Re: [GNC] How to record "investment" in gnucash ?

2020-04-07 Thread Adrien Monteleone
Specifically to your example: > On Apr 7, 2020 w15d98, at 4:43 AM, Long wrote: > > Hello, > > First, i'm not accounting, and i don't know what i did is wrong or right. So > please help me. > --- > /Example : this exampl

Re: [GNC] Gnucash 3.9 Flathub stucks

2020-04-07 Thread Finfort
Thank you, but what is the command to start it? Just "gnucash" does not work... > > On Apr 7, 2020 at 19:36, (mailto:adrien.montele...@lusfiber.net)> wrote: > > > > Not sure about Flatpak specifics, but I would start it from the command line > and se

Re: [GNC] How to record "investment" in gnucash ?

2020-04-07 Thread Adrien Monteleone
I meant ‘investment’ in general terms, but the idea with regard to physical assets is the same. Your local laws will determine when you book increases or decreases in value. *Generally* this is only done at the sale, when the gain or loss is realized. Before a sale, you’re just guessing and est

Re: [GNC] How to record "investment" in gnucash ?

2020-04-07 Thread Long
Hello, Now, i am confusing, i'm talking about "Gold", maybe it look like "House" or "Painting", not "Stock". And GnuCash documents had talk about that. And i am doing in difference way (easier) to manager that. And i am new and not an accounting. So please help me by guide me more if you can. Tha

Re: [GNC] GNUCash beginner setup

2020-04-07 Thread Adrien Monteleone
By ‘opening balance’ do you mean in the account register (1st transaction) or when doing a reconciliation? Regards, Adrien > On Apr 7, 2020 w15d98, at 10:14 AM, denz wrote: > > Thanks David and Adrian. I have an update for you. > > I was able to get things working now and categorisation work

Re: [GNC] CRIT [gnc_price_unref()] last unref while price in database

2020-04-07 Thread John Ralls
> On Apr 7, 2020, at 9:56 AM, RobBruce wrote: > > I'm running 3.4 on Windows 10. > > Until this afternoon, it's been running very smoothly. > > On trying to load GnuCash, I got a message that there was an error parsing > the file E:\Documents\gnucash-rob\rob-gnucash.gnucash > > I did look

Re: [GNC] How to record "investment" in gnucash ?

2020-04-07 Thread Adrien Monteleone
Also, GnuCash can show you what your investment is valued without booking actual transactions. Those are generally only done when the actual sale goes through. Regards, Adrien > On Apr 7, 2020 w15d98, at 6:36 AM, Ben Stanley wrote: > > Hello, > > Please check this page of the manual. It expl

[GNC] CRIT [gnc_price_unref()] last unref while price in database

2020-04-07 Thread RobBruce
I'm running 3.4 on Windows 10. Until this afternoon, it's been running very smoothly. On trying to load GnuCash, I got a message that there was an error parsing the file E:\Documents\gnucash-rob\rob-gnucash.gnucash I did look for solutions, and opened the trace log, which contains: * 12:49:21

Re: [GNC] Gnucash 3.9 Flathub stucks

2020-04-07 Thread Adrien Monteleone
Not sure about Flatpak specifics, but I would start it from the command line and see if there is any output that lends some clues. Regards, Adrien > On Apr 7, 2020 w15d98, at 6:28 AM, Finfort wrote: > > > > > Gnucash 3.9 Flathub stucks for about 5 minutes on Ubuntu 18.04, 19.10 when > star

Re: [GNC] Inability to import CSV files.

2020-04-07 Thread Adrien Monteleone
Can you provide a screenshot? (attach, don’t paste in-line, or maybe just link to a hosting site) The Help manual shows the import screen with drop downs to define each column. See § "6.15.4 Import CSV” : https://www.gnucash.org/docs/v3/C/gnucash-help/trans-import.html#trans-import-csv Regards

Re: [GNC] [GNC-dev] About 3.9 and reconciliation balances

2020-04-07 Thread Adrien Monteleone
I concur with this part. Rather than change the calculation, do a check for an errant ending date. Introduce some means to do a check on the whole file as a ‘first run’ event on upgrading. Provide a means to edit the errant data directly rather than revert and re-reconcile. Reconciliation data s

Re: [GNC] Inability to import CSV files.

2020-04-07 Thread Geert Janssens via gnucash-user
Hi Aixza, Did you try to click on the column headings for each column ? That is the way to define the type of each column. Regards, Geert Op dinsdag 7 april 2020 09:46:45 CEST schreef Aixza Gonzalez via gnucash-user: > Although I am new to this program it is evident that something is missing

Re: [GNC] GNUCash beginner setup

2020-04-07 Thread denz
Thanks David and Adrian. I have an update for you. I was able to get things working now and categorisation works better and closer to my desirable behaviour. The only difference between earlier and now was the time sequence on how I imported the transactions.Earlier, I imported the statements in

Re: [GNC] Inability to import CSV files.

2020-04-07 Thread Ben Stanley
What version of GnuCash are you using? On 7 April 2020 7:16:54 pm Aixza Gonzalez via gnucash-user wrote: Although I am new to this program it is evident that something is missing in the program to attain the import of the CSV files. There is no way to access and define the columns, special

Re: [GNC] Australian Foreign Investments Taxation

2020-04-07 Thread Ben Stanley
Hello Gnucash Users, I have now downloaded the foreign exchange rates from the Reserve Bank of Australia: https://rba.gov.au/statistics/historical-data.html#exchange-rates Note that the exchange rate data is published in an Excel .xls file. I used LibreOffice to save it as a .csv for import i

Re: [GNC] How to record "investment" in gnucash ?

2020-04-07 Thread Ben Stanley
Hello, Please check this page of the manual. It explains what you need to know here. https://www.gnucash.org/docs/v3/C/gnucash-guide/invest-buy-stock1.html I hope that helps! On 7 April 2020 7:45:17 pm Long wrote: Hello, First, i'm not accounting, and i don't know what i did is wrong or ri

[GNC] Gnucash 3.9 Flathub stucks

2020-04-07 Thread Finfort
Gnucash 3.9 Flathub stucks for about 5 minutes on Ubuntu 18.04, 19.10 when starting. After that shows it’s logo,boots and works normally. Sometimes it freezes all the system when starting and all you can do is only cold restart. Does anybody have the same problem?

Re: [GNC] Australian Foreign Investments Taxation

2020-04-07 Thread pobox . deva
Ben, I use the CSV Price Importer for loading stock/mutual fund prices every month (all in INR). Though I haven’t used this in the context of currency exchange rates, I think it should be possible because you are essentially converting price from one commodity to another in both scenarios. Th

[GNC] How to record "investment" in gnucash ?

2020-04-07 Thread Long
Hello, First, i'm not accounting, and i don't know what i did is wrong or right. So please help me. --- /Example : this example is just assumed./ - Jan : I bought a kg* "gold" *cost me *100$*. - Feb : My *"gold"* are decre

Re: [GNC] Australian Foreign Investments Taxation

2020-04-07 Thread Christopher Lam
Yes, you can do that. File import prices from CSV. On Tue, 7 Apr 2020, 5:22 pm Ben Stanley, wrote: > I can get a CSV file of daily exchange rate data. Is there a way of > importing it into the price database? > > On 7 April 2020 7:17:54 pm Christopher Lam > wrote: > >> The only report which is

Re: [GNC] Australian Foreign Investments Taxation

2020-04-07 Thread Ben Stanley
I can get a CSV file of daily exchange rate data. Is there a way of importing it into the price database? On 7 April 2020 7:17:54 pm Christopher Lam wrote: The only report which is capable of using closest-to-date conversion is the Transaction Report from the Income:Dividends(USD) and Income:C

Re: [GNC] Australian Foreign Investments Taxation

2020-04-07 Thread Christopher Lam
The only report which is capable of using closest-to-date conversion is the Transaction Report from the Income:Dividends(USD) and Income:CapGains(USD) accounts, using a Report Currency of AUD. It will choose the USD/AUD price from the price editor list closest to each transaction's posting date. Y

Re: [GNC] invisible checkboxes [Solved]

2020-04-07 Thread Graham Menhennitt
On /Apr 6 04:58:58 EDT 2020, Richard Ullger wrote: / On 05/04/2020 06:14, Graham Menhennitt wrote: >>/Something very strange has happened to my GnuCash installation - I no />>/longer have any checkboxes. In dialogs where I'd expect to see them, />>/there is just blank space. In the reconcile win

[GNC] Inability to import CSV files.

2020-04-07 Thread Aixza Gonzalez via gnucash-user
Although I am new to this program it is evident that something is missing in the program to attain the import of the CSV files. There is no way to access and define the columns, specially in the transactions import. The manual instructions cannot be implemented. Sent from Mail for Windows 10

[GNC] Australian Foreign Investments Taxation

2020-04-07 Thread Ben Stanley
Hello Gnucash people, This question may be more suited to Gnucash developers, but lets try it here first. I need to perform a tax calculation in accordance with instructions from the Australian Taxation Office. All foreign income, deductions and foreign tax paid must be converted to Australi