[GNC] Saving Data

2020-04-12 Thread Andrew Ralph via gnucash-user
Hi Team really struggling to save and or find any of my files, have been following instructions over and over in the user guide and have lost a lot of data and time, really frustrating. I am trying to set up multiple Files/accounts Linking 5 different banking accounts (importing data) to

Re: [GNC] ANNOUNCE: GnuCash 3.10 Released

2020-04-12 Thread Thomas Klausner
Hi! I see the following build problem when building gnucash-3.10 (in a clean environment where 3.9 builds): gmake[2]: *** No rule to make target 'bindings/python/tests/swig-app-utils-python', needed by 'bindings/python/tests/CMakeFiles/test-python-bindings'. Stop. gmake[1]: ***

Re: [GNC] Keeping Imported Transactions from Overwriting Data?

2020-04-12 Thread D. via gnucash-user
David, Thanks for taking this on. I'd noticed as well that the Guide was rather limited in its explanation for these settings. Explaining what each option does as will as offering some ideas why a user might want one setting over another would be advisable. Frank, As I mentioned, I no

Re: [GNC] UK. Value added tax.

2020-04-12 Thread Christopher Lam
Hi Maf, any gossip about the treatment of VAT and EU displacement of VAT post Brexit? Is it worth merging the UKVAT report into 4.x series? The 4.x series plan to upgrade the Income-GST-Statement report to (1) output UK & Australia specific fields as well as the current generic report (2) allow

Re: [GNC] Strange reconciliation behavior

2020-04-12 Thread Christopher Lam
As others have reported, this change was *meant* to be more strict in interpretation of reconcile *statement_date* (which eventually becomes the split's *reconciled date*). My suspicion is that your first successful reconciliation used an incorrect *statement_date* which led to the second

Re: [GNC] QIF Importer does not work

2020-04-12 Thread Christopher Lam
This would need a bug report. The QIF importer isn't very good at logging errors, and would some hacking to log errors. On Thu, 9 Apr 2020 at 22:41, wrote: > Hi, > > > > I'm using > > https://code.gnucash.org/builds/win32/maint/gnucash-3.9-2020-04-03-git-3.9-5 > -gbedc9631f+.setup.exe >

Re: [GNC] Strange reconciliation behavior

2020-04-12 Thread David Carlson
Please reply to the list or use reply all On Sun, Apr 12, 2020, 5:22 PM Art Chimes wrote: > David, > Thanks for the quick reply. I will see what others have to say before > I decide whether to go forward or revert! > > Meantime, I'll peruse the developers' mailing list to see what I can learn.

Re: [GNC] After a long hiatus I'm trying to restart using GNC for my accounting/tax needs. I have some old GNC files, but can't open them correctly.

2020-04-12 Thread David Cousens
John, To replay the log files you have to open one of the previous backup files identified as Adrien described them and then import one by one all logfiles with a timestamp forward from that backup file. See https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html David Cousens

Re: [GNC] Strange reconciliation behavior

2020-04-12 Thread David Cousens
Art, Are you using GnuCash V3.9 If you are please either revert to 3.8 or upgrade to the newly released 3.10 version which reverts changes in 3.9 if the following is causing your problem. The problem I encountered in 3.9 was that the starting balance did not include reconciled transactions

Re: [GNC] After a long hiatus I'm trying to restart using GNC for my accounting/tax needs. I have some old GNC files, but can't open them correctly.

2020-04-12 Thread Adrien Monteleone
The file that ends in .gnucash is your data file. Also, that file name should generally not have a long string of numbers in it preceding the .gnucash. (this would be a date stamp) Such a named file will be a backup file not the main one. You can ‘replay’ the log files, but I’ve never used it

Re: [GNC] Keeping Imported Transactions from Overwriting Data?

2020-04-12 Thread David Cousens
Frank The help manual really doesn't include any information on what happens with the description information with the A, U+C or C options during import. When I updated that last year I was primarily thinking about the effects on the Date and Amount but I don't remember seeing what happened with

Re: [GNC] How to Realized Gain/Loss when turned on trading account ?

2020-04-12 Thread Adrien Monteleone
Although the Trading Accounts section and total are selected to be included by default, the accounts are not. When I run an Income Statement, they do not appear and are not included in my bottom line Profit/Loss net. If I want them to appear, I simply select them in the Options > Accounts tab.

Re: [GNC] Strange reconciliation behavior

2020-04-12 Thread David Carlson
There is a big discussion going on in the developer arena about what is wrong with the reconciliation process in release 3.9 I suspect that you may being an artifact of that. They have released 3.10 in an attempt to fix that, but if you are conservative you may want to revert to 3.8 instead.

[GNC] Strange reconciliation behavior

2020-04-12 Thread Art Chimes
Strange to me, anyway. I have a long-closed U.S. mutual fund account (call it ABCDX) that was never reconciled since I started using GnuCash a year ago. Now I want to reconcile it, and I'm tackling it year-by-year. I reconciled the first year closing balance, 5,898.936 shares, without issue.

[GNC] After a long hiatus I'm trying to restart using GNC for my accounting/tax needs. I have some old GNC files, but can't open them correctly.

2020-04-12 Thread John Clark via gnucash-user
I had tediously entered in my checking account transactions, into a 2016 file, save it with the ‘log’ files, etc. but now when I open Gnucash, I only see a 2018 file, which I only had a few entries, I tried ‘importing’ from *.log, but that only did one limited thing, resulting in ‘orphan’

Re: [GNC] How to Realized Gain/Loss when turned on trading account ?

2020-04-12 Thread David Cousens
Long, The original balance sheet screen shot was taken with an attempt to transfer the AUD trading account Balance to a REALIXED GAINS Income account. It was at that point I realized that transactions to and from the trading accounts are blocked. I then forgot to delete it before taking the

Re: [GNC] How to Realized Gain/Loss when turned on trading account ?

2020-04-12 Thread David Cousens
Hi Adrien, But it does include the gains and losses from the trading account as realized gains and losses and in this case they also appear in the Balance Sheet in this case as Trading Losses. The Imbalance AUD of -0.26 resulted because i tried to create a Realized gains Transaction from the

Re: [GNC] How to Realized Gain/Loss when turned on trading account ?

2020-04-12 Thread David Cousens
Hi Long, Test_trading.gnucash David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list

Re: [GNC] Which file contains the account name map for the CSV import tool?

2020-04-12 Thread Patrick
Thank you, sir. I appreciate the help. Regards, Patrick On Sun, Apr 12, 2020 at 11:45 AM John Ralls wrote: > > > > On Apr 12, 2020, at 9:31 AM, Patrick wrote: > > > > I'd like to work on a gnucash file on a new machine. I'd like to transfer > > the account name map that is used by the CSV

Re: [GNC] Keeping Imported Transactions from Overwriting Data?

2020-04-12 Thread Frank H. Ellenberger
David, Am 12.04.20 um 16:17 schrieb D.: > Frank, > > On the first point, I'd note that the books in question are mine; changing > the transaction date from MY date to the bank's date would seem to contradict > that. > > I was unaware that the matcher would match transactions that have

Re: [GNC] cMakeError.log errors - building Gnucash 3.10

2020-04-12 Thread Finfort
Ofx lib is installed by instructions, anyway... > > On Apr 12, 2020 at 19:40, mailto:jra...@ceridwen.us)> wrote: > > > > > On Apr 12, 2020, at 4:25 AM, finf...@gmail.com wrote: > > I have > these errors in cMakeError.log after cmake: > > Can

Re: [GNC] Which file contains the account name map for the CSV import tool?

2020-04-12 Thread John Ralls
> On Apr 12, 2020, at 9:31 AM, Patrick wrote: > > I'd like to work on a gnucash file on a new machine. I'd like to transfer > the account name map that is used by the CSV import tool (see the bullet > "Match Import and GnuCash accounts") from the old machine to the new > machine. Is this

Re: [GNC] cMakeError.log errors - building Gnucash 3.10

2020-04-12 Thread John Ralls
> On Apr 12, 2020, at 4:25 AM, finf...@gmail.com wrote: > > I have these errors in cMakeError.log after cmake: > > Can anybody explain how to fix that? > > > > Performing C++ SOURCE FILE Test HAVE_OFX_BUG_39 failed with the following > output: > Change Dir:

[GNC] Which file contains the account name map for the CSV import tool?

2020-04-12 Thread Patrick
I'd like to work on a gnucash file on a new machine. I'd like to transfer the account name map that is used by the CSV import tool (see the bullet "Match Import and GnuCash accounts") from the old machine to the new machine. Is this mapping stored in a file that I can transfer to the new machine?

Re: [GNC] Keeping Imported Transactions from Overwriting Data?

2020-04-12 Thread D. via gnucash-user
Christopher, Unfortunately, my use model no longer includes any imports, whether QIF, OFX, or csv-- in part because the work of importing was greater than simply entering in the transactions myself, and in part because my institutions blocked or obscured these features. So, I won't be able to

Re: [GNC] Keeping Imported Transactions from Overwriting Data?

2020-04-12 Thread Christopher Lam
David please check out https://bugs.gnucash.org/show_bug.cgi?id=797678. The importer *can* be taught to not overwrite existing data. There are win32 builds; do try a master release. More features are upcoming, and all need beta testing. On Sun, 12 Apr 2020, 10:21 pm D. via gnucash-user, wrote:

Re: [GNC] Keeping Imported Transactions from Overwriting Data?

2020-04-12 Thread Eric H. Bowen via gnucash-user
Especially since my understanding of US IRS rules for paper checks is that the payment is made when the check is written and mailed, not when it clears. If I write a check for my mortgage payment and mail it on December 31st of 2019, it arrives at my bank on January 2nd and clears

Re: [GNC] Keeping Imported Transactions from Overwriting Data?

2020-04-12 Thread D. via gnucash-user
Frank, On the first point, I'd note that the books in question are mine; changing the transaction date from MY date to the bank's date would seem to contradict that. I was unaware that the matcher would match transactions that have different amounts. That seems worrying. Generally

Re: [GNC] How to Realized Gain/Loss when turned on trading account ?

2020-04-12 Thread Adrien Monteleone
The Income Statement will not show Unrealized Gains or Losses. The net total at the bottom of the Income Statement is that period’s net realized gain or loss across the entire book. Regards, Adrien > On Apr 12, 2020 w16d103, at 4:09 AM, Long wrote: > > I tried, but there are no ways to have

Re: [GNC] Keeping Imported Transactions from Overwriting Data?

2020-04-12 Thread David Carlson
Frank, Thanks for the clarification of use cases where update might be preferred. As to the case where the description is preferred to be kept was stated in the original email starting this thread. In the days when paper checks were common, and it was common to have a niece or nephew that took

Re: [GNC] Keeping Imported Transactions from Overwriting Data?

2020-04-12 Thread Frank H. Ellenberger
Hi, Am 11.04.20 um 19:49 schrieb David Carlson: > David T, > > You are right. I too am not sure why the (U)pdate option overwrites the > text of the existing transaction, but I think that it usually is offered as > the default when the date of the matched transaction is not the same as the >

Re: [GNC] How to Realized Gain/Loss when turned on trading account ?

2020-04-12 Thread Long
I tried, but there are no ways to have like your result. 1 - i check "trading account" 2 - transfer with "Ctrl+T" like you said 3 - i transferred from VND to USD. 4 - then get back VND from USD => Balance Sheet will show me LOSS if the amount i get back are smaller. => Income Statement Report show

Re: [GNC] How to Realized Gain/Loss when turned on trading account ?

2020-04-12 Thread Long
Please, can you upload your .gnucash file here. It's more clearly for me if i watch ledge journal. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] How to Realized Gain/Loss when turned on trading account ?

2020-04-12 Thread David Cousens
Long, Balance Sheet and Income Statement are attached for a simple test which involved a currencytransfer of 100 AUD to a USD account and then a transfer back from the USD account to the AUD with a different exchange rate that created a loss of 0.26 using trading accounts to record. I used the