Re: [GNC] Register column sizing

2023-01-05 Thread David Carlson
I feel that the register column sizing is complicated by the fact that the register view is constrained by the requirement that the data input window has to appear to blend in to the rest of the register view. If the data input area was separated from the register view each of the areas could be

Re: [GNC] QIF format for StkSplit

2023-01-05 Thread john
gnc_numeric_create is a C function implemented in libgnucash/engine/gnc-numeric.cpp and made available to Scheme by SWIG which changes its name to gnc-numeric-create. It takes two int64_t arguments, numerator and denominator. There's a general convention that public functions defined in Scheme

Re: [GNC] Register column sizing

2023-01-05 Thread Glenn Fowler
Hi, I think it would be an improvement to get rid of autosizing because of the recurring issues people have with it and it wouldn't affect those users that do know how autosizing works by taking it away. On Thu, Jan 5, 2023 at 10:40 PM john wrote: > Users, > > There have been occasional

[GNC] Register column sizing

2023-01-05 Thread john
Users, There have been occasional complaints for many years about column width sizing. See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588. Most users seem to eventually get used to it, but I wonder if anybody really likes it. The problem boils down to the auto-sizing behavior of the

Re: [GNC] NEw user assistance

2023-01-05 Thread Geoff
Welcome to GnuCash Karl! > Specifically, I am trying to set-up the online pricing list for stock > quotes. Have a read of these topics: https://wiki.gnucash.org/wiki/Stocks/add_stock https://wiki.gnucash.org/wiki/Online_Quotes Regards Geoff = On 6/01/2023 12:30 pm, Karl wrote: Hello

Re: [GNC] Request for Automatic Reconciliation Function

2023-01-05 Thread David Cousens
Bite, Another difficulty is that most banks currently provide statements (as distinct from OFX or CSV transactional records which are not necessarily certified by the bank to be correct) in a pdf form and not a digital form.  These are not easily imported into GnuCash for use in reconciliation

Re: [GNC] beginner bookkeeping question

2023-01-05 Thread Michael or Penny Novack
On 1/5/2023 7:19 PM, Simon Roberts wrote: Can I check an understanding? I have an account "Liabilities:CreditCard" Assuming I owe them money, the balance of this would be positive, am I correct? Thanks! Simon The "senses" in double entry bookkeeping are "debit" and "credit" (as opposed to

Re: [GNC] NEw user assistance

2023-01-05 Thread David H
Welcome to gnucash Karl. I think from memory Nabble went away during the pandemic about 12 months ago, so maybe forget that one :-) If you have any questions, post them here to the gnucash user list (gnucash-user@gnucash.org) and you'll get all the help you need. Also just a heads up do NOT use

Re: [GNC] QIF format for StkSplit

2023-01-05 Thread David Reiser via gnucash-user
bug, maybe? import-export/qif-imp/qif-to-gnc.scm says: ((stksplit) (let* ((splitratio (n/ num-shares (gnc-numeric-create 10 1))) (in-shares (xaccAccountGetBalance near-acct)) (out-shares (n* in-shares splitratio)))

Re: [GNC] Request for Automatic Reconciliation Function

2023-01-05 Thread Bite Gao
GnuCash Developers and Maintainers: Hello! While you have mentioned the requirement of human intervene in the reconciliation process, I do not see it contradicts with the presence of automatically reconciliation system. In a reconcile process, the accountant check the record in the account

Re: [GNC] beginner bookkeeping question

2023-01-05 Thread Adrien Monteleone
That depends on your setting for Preferences > Accounts > Reversed balanced accounts. The default is 'Credit Accounts' if I'm not mistaken. So in that case, the more you owe, the more positive the liability balance will be. If you set the preference to Income & Expense or None, then

[GNC] NEw user assistance

2023-01-05 Thread Karl
Hello there! I am a new user to GnuCash and am looking for some assistance. I have subscribed to the mailing list and am attempting to access the Web Forum (Nabble) for further assistance from other users. Specifically, I am trying to set-up the online pricing list for stock quotes. Please

Re: [GNC] QIF format for StkSplit

2023-01-05 Thread Ken Farley
When I was doing a bunch of Quicken conversions using QIF files, what happened was pretty much what you described here, I think. My original shares were removed in one transaction, while the split amount was added back. For example, 200 shares that needed at 2 for 1 resulted in a 200 share

Re: [GNC] beginner bookkeeping question

2023-01-05 Thread Dr. David Kirkby
On Fri, 6 Jan 2023 at 00:19, Simon Roberts wrote: > Can I check an understanding? I have an account "Liabilities:CreditCard" > > Assuming I owe them money, the balance of this would be positive, am I > correct? > > Thanks! > Simon Yes. Table 2.1 here

[GNC] A “Vendor Summary” would compliment the “Customer Summary”

2023-01-05 Thread Dr. David Kirkby
On the business menu there’s several things including Customer Report Customer Summary Vendor Report but there’s no Vendor Summary. It would be quite nice to compliment the Customer Summary, and I would assume that the code to add that would not be huge, given the close relationship between

Re: [GNC] another beginner question

2023-01-05 Thread Derek Atkins
Well, if you put your O-B on all your Assets and Liabilities, then yes, that *IS* your current equity in the company. If you think the balance is too big, then most likely you haven't added all your liabilities. Keep in mind that Income and Expense are actually Equity-type accounts, in the sense

[GNC] another beginner question

2023-01-05 Thread Simon Roberts
Right now I have set up my transition from quickbucks to Gnc such that all the bank accounts have an opening balance, which is drawn from "Equity:Opening Balances". However, I think that's ... wrong/misleading, in that this is most definitely not money I just handed over to create the business.

[GNC] beginner bookkeeping question

2023-01-05 Thread Simon Roberts
Can I check an understanding? I have an account "Liabilities:CreditCard" Assuming I owe them money, the balance of this would be positive, am I correct? Thanks! Simon -- Simon Roberts (303) 249 3613 ___ gnucash-user mailing list

Re: [GNC] QIF format for StkSplit

2023-01-05 Thread ml
So, the ratio * 10 does seem to be working. :man_shrugging: For example, if it is a 4 for 1 split, 40 If it is a 1 for 10 split, 1 > On Jan 5, 2023, at 14:17, m...@tgr66.me wrote: > > Yes. I missed adding that to the list I’ve tried. > > In the full work minimal example below, the share

Re: [GNC] Scheduled transactions

2023-01-05 Thread John Layman
I find variables to be extremely useful, and even use them in simple math expressions. There is, however, a UI quirk that might cause people to assume they don't work. In the simple case where the transaction includes a variable, let's say 'amt', the Since Last Run panel will prompt for the

Re: [GNC] Are accountants happy with CVS exports?

2023-01-05 Thread Michael or Penny Novack
I would expect that the .csv file could be imported in a "modern" spreadsheet program (Excel, localc, etc.) by the accountant. If there is a header row, the columns would be labeled. I expect most modern spreadsheet programs can re-order columns. No offense, but this sort of thing is what I

[GNC] Window size/position not remembered

2023-01-05 Thread timothy.b via gnucash-user
Hello Gnucash user list. I'm having a problem with the window settings and positions not being remembered. The window position and settings for the main Accounts window is remembered, but the window position/size and view options for individual registers are not remembered. I am using the

Re: [GNC] Budget report fails in multiple currencies

2023-01-05 Thread ml enquirer
Hi! Any clues as to where to start to understand this odd budget report behaviour? Browsing the code, I wondered if I should start pulling the code apart here: https://github.com/Gnucash/gnucash/blob/master/gnucash/gnome/gnc-budget-view.c#L1011 to understand why the totals would be combined in

Re: [GNC] QIF format for StkSplit

2023-01-05 Thread ml
Yes. I missed adding that to the list I’ve tried. In the full work minimal example below, the share balance ends up at 1.2 !Account NAssets:Investments:Brokerage Account:Joint Brokerage TInvst ^ !Type:Bank D01/11/2020 NPayment/Deposit PTrf My Bank CX T1,000.00 MDeposit LAssets:Current Assets:My

[GNC] USAA Direct Connect Issue - again.

2023-01-05 Thread smada46
A couple of weeks ago I attempted to download my USAA transactions using Direct Connect for OFX through GnuCash. It failed several times over a couple of days with the error: “The user cannot sign on because he or she entered an invalid user ID or password.” I then followed the procedures to

Re: [GNC] QIF format for StkSplit

2023-01-05 Thread David Reiser via gnucash-user
I’ve never used QIF for stock splits, but the obvious question is “Have you tried Q4?” After all, 4/1 is numerically equal to 4 (a ratio reduced to a single number). -- Dave Reiser dbrei...@icloud.com > On Jan 5, 2023, at 2:51 PM, m...@tgr66.me wrote: > > I’ve searched considerably, but if

[GNC] QIF format for StkSplit

2023-01-05 Thread ml
I’ve searched considerably, but if I missed it, I apologize. Docs for QIF say the Q field should contain the split ratio. I’ve tried various options, but I’m not getting the expected results after import. !Type:Invst D8/31/2020 NStkSplit PAPPLE INC YAAPL CR M4 for 1 split; Q36 // Have also

Re: [GNC] Scheduled transactions

2023-01-05 Thread R Losey
The biggest "variable" I need that I haven't been able to do is that I want a check to "use the next check number" - I haven't been able to figure out how to make that happen. I assume that using "amt" (without quotes) for the amount stops things because the amount should be numerical. On Thu,

Re: [GNC] Are accountants happy with CVS exports?

2023-01-05 Thread Robert Heller
At Thu, 5 Jan 2023 11:52:04 -0500 stepbystepf...@comcast.net wrote: > > This discussion merits a comment. > > ALL .csv means is an indication that the data is in a file of "records" > each of which contains data fields separated by commas. It does not mean > ANYTHING about what the fields

Re: [GNC] Are accountants happy with CVS exports?

2023-01-05 Thread Michael or Penny Novack
This discussion merits a comment. ALL .csv means is an indication that the data is in a file of "records" each of which contains data fields separated by commas. It does not mean ANYTHING about what the fields mean (what sort of data is there) or what is the logical order of the fields.

Re: [GNC] Variables in Scheduled transactions

2023-01-05 Thread Stan Brown
On 2023-01-05 02:17, Adrien Monteleone wrote: > Are you using GnuCash 4.13? > > I just tested this and I only get one prompt. > > Regards, > Adrien > > On 1/4/23 10:53 PM, Stan Brown wrote: >> Debit: Liabilities:Mortgage Principal  900-intamt >> Debit: Expenses:Mortgage Interest  intamt >>

Re: [GNC] Reports suddenly not working - found it

2023-01-05 Thread Chris Skudder
Found the problem + fix here - [1]https://askubuntu.com/questions/1398945/why-have-my-gnucash-reports- stopped-working Caused by flatpak not updating correctly. Fix = $flatpak update thanks all the same - - Chris

[GNC] Reports suddenly not working at all

2023-01-05 Thread Chris Skudder
I'm on Build ID: Flathub 4.13, on Lubuntu 18.04, been using it for years without any issue. Today reports simply do not work: it returns a blank screen, whether I call up a standard report or a custom; and regardless of what options I select (dates, accounts, etc). Last time I

Re: [GNC] Scheduled transactions

2023-01-05 Thread Tommy Trussell
When I use scheduled transactions, I always tell it to let me review all the created transactions. This is useful because, as you surmise, it generates the transactions on the dates as scheduled, even if I create them in advance. So, if the Since Last Run druid is prompting me to write a check

Re: [GNC] Are accountants happy with CVS exports?

2023-01-05 Thread R. Victor Klassen
I do my own taxes (by hand). > On Jan 4, 2023, at 8:33 PM, Dr. David Kirkby > wrote: > > On Wed, 4 Jan 2023 at 22:29, R. Victor Klassen > wrote: > I generally export a transaction report with all (relevant) accounts > selected. I generally do a select-all from

Re: [GNC] Variables in Scheduled transactions

2023-01-05 Thread Adrien Monteleone
Are you using GnuCash 4.13? I just tested this and I only get one prompt. Regards, Adrien On 1/4/23 10:53 PM, Stan Brown wrote: My mortgage payment (say 900.00) is the same each month, but of course every month interest (intamt) is a few cents less and principal (900-intamt) the same few