[GNC] QIF import - set default Transfer account

2020-01-15 Thread malam via gnucash-user
QIF import correctly imports data into the database.During import it sets all transactions as *'/Unspecified/'*.Is it possible to set a different Transfer account for ALL imported transactions ?BackroundAt the moment I am interested in just few types of expenses,95% of all imported transactions sho

Re: [GNC] Handling of Equity and Retained Earnings

2020-01-15 Thread David Cousens
Adrien That is only true if in the new book all the transactions into Income and Expense accounts (to and from Asset and Liability accounts) are also brought into the new book (but why would you want to do that?) but if just the balances of the Asset and Liability accounts are transferred to the n

Re: [GNC] Handling of Equity and Retained Earnings

2020-01-15 Thread Adrien Monteleone
Someone moving from another application or from paper *would* have a non-zero Retained Earnings account that would *not* be reflected in the opening balances of the Asset or Liabilities accounts. The balance of that account would have been the result of closing Income and Expenses in previous y

[GNC] Problem with colons in account names

2020-01-15 Thread gnucash . dgr9z
Hi, all. First, thanks for the continuing excellent work on Gnucash in the Dec. release. I know it is a lot of work for the team; it is not thankless work. I recently set up some stock stocks in the Security editor and created corresponding asset accounts as described in the documentation. Th

Re: [GNC] budget reports 'YTD' vs 'use accumulated amounts'

2020-01-15 Thread Christopher Lam
The updated budget report in 3.8 aims to display the YTD budget amounts. If it does not perform well then you'll need to file a bug. On Wed, 15 Jan 2020 at 23:48, larry johnston wrote: > Peter, > > I am still running 2.6.15. I am running Windows 10. Phil's report still > runs well in Wndows 10.

Re: [GNC] budget reports 'YTD' vs 'use accumulated amounts'

2020-01-15 Thread larry johnston
Peter, I am still running 2.6.15. I am running Windows 10. Phil's report still runs well in Wndows 10. I have not upgraded because I do not want to lose the functionality of Phil's report. I do not download financial information from institution as I do manual entry so have not seen any reason to

Re: [GNC] Handling of Equity and Retained Earnings

2020-01-15 Thread Michael or Penny Novack
On 1/15/2020 10:56 AM, Christian Lynbech wrote: Inspired by a recent discussion I would like to understand better how to handle the Retained Earnings equity sub account, as I am new to both Gnucash and accounting. In a world where books are closed at year end, I would understand Retained Earn

Re: [GNC] Handling of Equity and Retained Earnings

2020-01-15 Thread David Cousens
Adrien and Christian, Just a comment on Adrien's last post. There is no need to have an opening balance for Retained Earnings. Any opening balance would be reflected in the Equity entries when you enter the opening balances for the Asset and Liability accounts (in a new book the Income and Expense

Re: [GNC] import export of transactions

2020-01-15 Thread David Cousens
John, The default delimiter is the comma but you can export data with any delimiter you choose and similarly import with any delimiter. If your data uses a comma as part of the data field, e.g. the comma used as a decimal separator, then the importer will incorrectly parse the data. Did your data

Re: [GNC] import export of transactions

2020-01-15 Thread John Griessen
On 1/15/20 1:27 PM, John Griessen wrote: What delimiter to use? semicolon worked where comma failed. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/li

[GNC] import export of transactions

2020-01-15 Thread John Griessen
What delimiter to use? I try comma and get that it can't parse, please add a date column, but I see no place to add that on the form... ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: ht

Re: [GNC] Formatting the Register header?

2020-01-15 Thread Adrien Monteleone
A transaction isn’t limited to only two splits, so there is no need to do ‘2 things’ each time. You can just make one transaction. With auto-fill or Duplicate Transaction you’re just going to be adjusting dates, check #s and maybe amounts. (and any notes/memos like “February Donation” or whateve

Re: [GNC] Handling of Equity and Retained Earnings

2020-01-15 Thread Adrien Monteleone
Christian, Welcome to GnuCash! > On Jan 15, 2020 w3d15, at 9:56 AM, Christian Lynbech > wrote: > > Inspired by a recent discussion I would like to understand better how to > handle the Retained Earnings equity sub account, as I am new to both Gnucash > and accounting. > > In a world where b

Re: [GNC] Formatting the Register header?

2020-01-15 Thread David Klassen
Thank you for your response. The mechanics was what I was trying to wrap my head around. Because, yes, for tax purposes I want to show that I'm paying a charity expense. But I also didn't want to have to do two things every time I wrote a check but I couldn't see any way around it. I guess you'

Re: [GNC] AR problems

2020-01-15 Thread Adrien Monteleone
> On Jan 15, 2020 w3d15, at 9:42 AM, Bruce Irving via gnucash-user > wrote: > > Thank you Adrien for your detailed reply. And my BP has dropped - I should > have waited another day before I made my "rant". My apologies. > >> Win10, GC 3.8, SQLLiteI am very disappointed - to the extent that

[GNC] Handling of Equity and Retained Earnings

2020-01-15 Thread Christian Lynbech
Inspired by a recent discussion I would like to understand better how to handle the Retained Earnings equity sub account, as I am new to both Gnucash and accounting. In a world where books are closed at year end, I would understand Retained Earnings as sort of the surplus of the year that is th

Re: [GNC] AR problems

2020-01-15 Thread Bruce Irving via gnucash-user
Thank you Adrien for your detailed reply.  And my BP has dropped - I should have waited another day before I made my "rant".  My apologies. > Win10, GC 3.8, SQLLiteI am very disappointed - to the extent that I'm angry!  > I have tried all the reports in Business and Experimental and I could find

Re: [GNC] storing password when using mysql backend

2020-01-15 Thread Geert Janssens
Op woensdag 15 januari 2020 05:15:07 CET schreef Fourhundred Thecat: > Hello, > > I am using Gnucash 3.4 with Mysql (MariaDB) backend. > > Every time I start Gnucash, I have to type in the mysql password. > > The way I see it, this seems more like a security theater than a real > security. Norma

Re: [GNC] General accounting question about Assets = Liabilities + Equity

2020-01-15 Thread Adrien Monteleone
Brandon, Continuing on what David noted... Income and Expenses are traditionally considered temporary accounts that are ‘closed’ to Equity at the end of an accounting period, generally, one year. Therefore, the expanded equation would be: Assets = Liabilities + (Income - Expenses) After the f

Re: [GNC] storing password when using mysql backend

2020-01-15 Thread Colin Law
If you don't want password protection on the db then you can set it to empty. Colin On Wed, 15 Jan 2020 at 04:18, Fourhundred Thecat <400the...@gmx.ch> wrote: > > Hello, > > I am using Gnucash 3.4 with Mysql (MariaDB) backend. > > Every time I start Gnucash, I have to type in the mysql password.

Re: [GNC] General accounting question about Assets = Liabilities + Equity

2020-01-15 Thread D via gnucash-user
Brandon, The Guide at section 2.2 says: "Assets - Liabilities = Equity + (Income - Expenses)" In your case: 209.01 - 1497.72 = -18818.74 + (22975.27 - 5445.24) Or: -1288.71 = -1288.71 Yay! HTH, David On Jan 15, 2020, 13:13, at 13:13, Brandon Captain wrote: >Hello, > >I have a rather gener