Re: [GNC] QIF import - set default Transfer account

2020-01-17 Thread malam via gnucash-user
Thanks, this solves my problem. It seems that changing all at once works. I can select all transactions during import and then change the Transfer_account for all. In the final step I click Apply to finish the import process. The transactions went to the correct account (the selected one at the b

Re: [GNC] Handling of Equity and Retained Earnings

2020-01-17 Thread Michael or Penny Novack
On 1/16/2020 7:13 PM, David Cousens wrote: A Retained earnings account will be created under Equity and at the start of a new book/file it is appropriate that its value is zero until transactions from the Asset and Liability accounts to the Income and Expense accounts have been made. I'm going

[GNC] Handling reimbursements?

2020-01-17 Thread Nate Bargmann
What is everyone's thoughts on handling reimbursements received for ongoing expenses? In our church arrangement our congregation pays various expenses through the month and then at the end of the month the other congregation is given an invoice and the payment is received. Conceptually easy. I'll

Re: [GNC] Handling reimbursements?

2020-01-17 Thread Adrien Monteleone
Nate, Here’s how I’d approach this. If it doesn’t already exist, create an AR account as type ‘accounts receivable’. This is important, as assigning it that type, the Business Features will recognize and use it. (as opposed to just an ordinary Asset type account) Note, you can only have *one*

Re: [GNC] Handling reimbursements?

2020-01-17 Thread Nate Bargmann
Thank you very much Adrien. That is quite comprehensive and I'll be studying it a few times! Having been on this list for a few months, the contributions are outstanding and among the best of the Free Software Community. Thanks again. - Nate -- "The optimist proclaims that we live in the bes

[GNC] Owner Contributions & Distributions

2020-01-17 Thread Don Ireland
I'm having trouble figuring out the best way to handle owner contributions and distributions in gnucash. I understand them in concept but I'm just confused as to how the accounts get set up. My 1st thought was to create an asset account called Owner Contributions and another called Distributio

Re: [GNC] Owner Contributions & Distributions

2020-01-17 Thread Adrien Monteleone
Speak to a local CPA for details for your situation and jurisdiction, but from what you can find in a basic accounting text book, generally both contributions (capital investments) and distributions (draws) are equity accounts. The tree would look something like this: Equity |_Opening Balances

Re: [GNC] Owner Contributions & Distributions

2020-01-17 Thread Don Ireland
What I was referring to is the checking account I use for my business. When I make what the bank sees as a deposit, I need to account for it in my books. My books includes an asset account called Business Checking. Wouldn't that deposit be considered a credit? Based on what you've described, i

Re: [GNC] Owner Contributions & Distributions

2020-01-17 Thread Stephen M. Butler
Are you mixing your personal and business in the same GnuCash file? On 1/17/20 2:07 PM, Don Ireland wrote: > What I was referring to is the checking account I use for my business. When I > make what the bank sees as a deposit, I need to account for it in my books. > > My books includes an asset

Re: [GNC] Owner Contributions & Distributions

2020-01-17 Thread Adrien Monteleone
Deposits into a checking accounts are debits in the books of the entity that holds the account as an asset. (to your bank, your account is their liability) Debits increase assets. Credits decrease them. (same goes for Expenses, but reverse for Liabilities, Income & Equity) Single Transaction

[GNC] Minimum window width

2020-01-17 Thread Tim Kallmer
Using 3.6 on Ubuntu 19.04. Is there some setting that sets the minimum width the Gnucash window uses? I like to snap GC on one half of the screen and have a browser with my bank website on the other half while I am recording transactions. This works fine on my desktop with 1920x1080 resolution. But

Re: [GNC] Handling of Equity and Retained Earnings

2020-01-17 Thread David Cousens
Michael I don't think we are attempting to give accounting advice per se. GnuCash has two ways of dealing with retained earnings: 1 Formal book closure operation in which income and expenses are closed to an equity account which is most often referred to as Retained Earnings and from which disbur

Re: [GNC] Owner Contributions & Distributions

2020-01-17 Thread Stephen M. Butler
I do both.  I have a sole proprietorship that shares the same books with my personal activities.  At least in this state (Washington, USA), it is just me doing business using a trade name.  But, the trade name and I are the same legal entity.  In that case I just opened another checking account at

Re: [GNC] Scripted price editing and adding

2020-01-17 Thread Jon Schewe
On 1/14/20 10:28 PM, Raymond Smith wrote: Hi, Gnucash list. I'm interested in using a script to add and edit prices in my Gnucash file. For example, I'd like to (a) loop over a file containing historical price data and add prices for dates where the price is missing because I didn't do a quote r

Re: [GNC] Minimum window width

2020-01-17 Thread David Carlson
Tim, I usually run GnuCash on Ubuntu 18.04, but I use four desktops, one for GnuCash, one for a web browser and password manager, one for a pair of spreadsheets, and one for everything else. While I cannot see everything at once, it is trivial to use the task bar (or alt-tab) to switch from o

Re: [GNC] Minimum window width

2020-01-17 Thread Adrien Monteleone
Tim, I’m replying from a memory many moons ago, but I seem to recall a few discussions on this list (and bug reports) around the issue of minimum targeted width. I think it used to be 800. I’m not sure if that was increased. (960 would easily sit side by side on a 1920 screen) It seems from yo

Re: [GNC] Scripted price editing and adding

2020-01-17 Thread Peter West
I’m curious about using sql scripts for read and update operations on Gnucash data when that data is maintained in such a database. For XML, similar things could be accomplished using XSLT or XQuery. Has anything along these lines been done? -- Peter West p...@pbw.id.au Moved with pity, he stre

Re: [GNC] Scripted price editing and adding

2020-01-17 Thread Adrien Monteleone
If I recall, the general advice is you can read, but don’t write. GnuCash is not yet a true database app. (that is a long term goal) Until then, writing could be potentially very destructive. There are some projects out there designed specifically to query an sqlite backend of GnuCash for custo

Re: [GNC] Scripted price editing and adding

2020-01-17 Thread D via gnucash-user
A few versions back, I pieced together a Perl script that rebuilt the price history for a Gnucash SQL file, replacing the existing history table with monthly prices for the duration that a given commodity was held. It worked fine for me, and cleaned up years of erratic pricing info, although it