Re: [GNC] Shortcuts and Sorts

2020-09-23 Thread Peter West
About auto-fill: I have half a dozen categories for my grocery shopping, plus cleaning and household utensils that I can buy at the same supermarkets. I shop frequently, and I don’t buy big amounts, so there is a lot of variability. Putting the supermarket name into the initial Memo field

Re: [GNC] Register columns: The balance column is no longer visible

2020-09-23 Thread w...@theprescotts.com
Thanks Adrien, After reading this thread, I have experimented with hovering over the dividing lines in the header, then double clicking and it does indeed fix the problem of columns too narrow to show all digits. Also, thanks for the explanation about the description filling the available

Re: [GNC] Shortcuts and Sorts

2020-09-23 Thread Adrien Monteleone
David C. answered your question about sorting. And the others chimed in with personal comments on the auto-fill. You can't turn it off, but you can stifle it as noted with an extra character or so, tab over, then shift-tab to correct the extraneous characters. I too find the autofill a

Re: [GNC] Register columns: The balance column is no longer visible

2020-09-23 Thread Adrien Monteleone
Will, I'm also on Catalina using 4.1 Read my replay to John on the steps to resize. You can double click a column header to auto-size it to contain all digits/text. Then drag the right-hand divider for the description to the LEFT—far more than you need to, and it will snap into place

Re: [GNC] Register columns: The balance column is no longer visible

2020-09-23 Thread Adrien Monteleone
1. Hover the mouse over the column separator to the right of the 'Total Credit' header (or 'Withdrawal' or other, if you are using informal labels) as this is the column just to the left of the Balance column 2. When you have the left-right mouse cursor, drag right. This *should* expand the

Re: [GNC] Import transactions

2020-09-23 Thread Geoff
G'day Michael If you haven't already, I suggest you start with the following sections of the Gnucash Documentation: https://www.gnucash.org/viewdoc.phtml?rev=4=C=help 6.16. Importing Transactions from Files 6.16.5. Import CSV Then have a look at the second last post on this thread where I

Re: [GNC] Shortcuts and Sorts

2020-09-23 Thread pyz01
I was trying to say they keep the program fresh and relevant! Kudos to the developers! -Original Message- From: gnucash-user On Behalf Of py...@cox.net Sent: Wednesday, September 23, 2020 3:15 PM To: 'David Carlson' ; 'Walter Busch' Cc: gnucash-user@gnucash.org Subject: Re: [GNC]

Re: [GNC] Shortcuts and Sorts

2020-09-23 Thread David Carlson
I missed the question about sorting by the reconciliation status. After you have several months data reconciled, there is little need to sort that way, as almost all the unreconciled items will be near the end anyway. GnuCash has a View > Filter by > Status which you can use to (temporarily or

Re: [GNC] Shortcuts and Sorts

2020-09-23 Thread pyz01
I have to say that I am with David on this one. The autocomplete is one of the most handy items that GnuCash has - IMO. Your rent or mortgage are usually the same amount each month. If you are on any kind of budget plan - your electric, phone, gas bill, garbage bill, water bill, all have the

Re: [GNC] Can't "Save As" to sqlite, is it a compile option?

2020-09-23 Thread D. via gnucash-user
Yes. I did. Original Message From: Geert Janssens Sent: Wed Sep 23 16:10:11 EDT 2020 To: gnucash-user@gnucash.org Subject: Re: [GNC] Can't "Save As" to sqlite, is it a compile option? Op dinsdag 22 september 2020 10:13:37 CEST schreef Chris Green: > On Mon, Sep 21, 2020 at

Re: [GNC] Shortcuts and Sorts

2020-09-23 Thread w...@theprescotts.com
Walter, In my opinion the advantage of the auto-filled transactions is not the amounts but that it adds lines for the required accounts. When you tab into the amount columns it doesn't matter whether it is blank or filled with something from the previous transaction. It is selected and when

Re: [GNC] Shortcuts and Sorts

2020-09-23 Thread David Carlson
I would say that it takes very little more time to type Ctrl-A in the amount field before typing the desired amount. If you really don't want any fields pre-populated, type some bogus character before the autocomplete kicks in to prevent it from acting. I don't have that issue in my workflow

[GNC] Shortcuts and Sorts

2020-09-23 Thread Walter Busch
Have two questions. In Quicken I could sort by the reconcile column, but don’t find that in this program. In Quicken I could stop autofill (shortcuts) I don’t write checks or entries for the same amount all the time. It is stupid to think that I go to the grocery store and I buy something

[GNC] Import transactions

2020-09-23 Thread Michael Middleton
I need to import bank data csv into Gnucash accounts. So far with some limited success. I am unsure from the user manual of the required column headings in the import wizard screen. If the data to be imported is say: into account ASSET: BankXYZ date description

Re: [GNC] MT940 memo being truncated

2020-09-23 Thread Gordonjackson75
Thanks Derek, yes I've tried that. Unfortunately the data is just not there. I think I'll go back and just dump the transactions, and do the tab delimited file import instead. A few hours lost unfortunately. Cheers - ABN Amro do not make it easy for customers to manage their own transactions!

Re: [GNC] New user - anyone else using GnuCash for PCC (church) accounts? Advice?

2020-09-23 Thread doncram
About invoicing making GnuCash show assets (accounts receivable) when the dues are billed (or pledges receivable), I don't see why that would be much of a problem. Couldn't that be addressed by your entering a journal entry to zero out the asset balance and reverse the income recognized, whenever

Re: [GNC] Can't "Save As" to sqlite, is it a compile option?

2020-09-23 Thread Geert Janssens
Op dinsdag 22 september 2020 10:13:37 CEST schreef Chris Green: > On Mon, Sep 21, 2020 at 01:12:38PM -0500, Adrien Monteleone wrote: > > I'm pretty sure that *is* documented on the Wiki build pages, or at least > > used to be. I once built on Ubuntu and found that option on the Wiki to > > get > >

Re: [GNC] Loan to family member: How do i setup the account structure

2020-09-23 Thread Stephen M. Butler
I presume that you currently "expense" the loans.  They really are not an "expense" but a change of asset (from your savings account to a receivable. 1.  Add a new Asset account called "FaF Loans"  (Friends and Family Loans).  Mark it as a placeholder. 2.  Under FaF add a new account for each

Re: [GNC] Register columns: The balance column is no longer visible

2020-09-23 Thread John Mansfield
Maf, thank you for your email. The column lines are so close to the vertical bar the column (Charge and Balance) lines just seem to blur together as one. There appears to be no opportunity to "highlight" the balance column line If I touch the line(S) I either get the symbol for expanding left

Re: [GNC] Register columns: The balance column is no longer visible

2020-09-23 Thread Maf. King
On Wednesday, 23 September 2020 14:01:23 BST John Mansfield wrote: > The 'balance' column is no longer visible on one of my accounts. > ... > double clicked each column to > maximise the width - to no avail * I am unable to view the balance column > as it appears to be a very thin black line

Re: [GNC] New user - anyone else using GnuCash for PCC (church) accounts? Advice?

2020-09-23 Thread Michael or Penny Novack
On 9/22/2020 11:20 PM, doncram wrote: About invoicing making GnuCash show assets (accounts receivable) when the dues are billed (or pledges receivable), I don't see why that would be much of a problem.  Couldn't that be addressed by your entering a journal entry to zero out the asset balance

Re: [GNC] Register columns: The balance column is no longer visible

2020-09-23 Thread w...@theprescotts.com
To reinforce what John said. I am also occasionally having issues with column widths. Running 4.1.4 on MacOS 10.15.6. Sometimes the columns are not wide enough to display all of the digits. Yesterday the cleared/reconciled column was too narrow to see anything, just two vertical column

[GNC] Register columns: The balance column is no longer visible

2020-09-23 Thread John Mansfield
The 'balance' column is no longer visible on one of my accounts. I have reviewed the questions / suggestions around this subject - there seem to be many! I have attempted to perform the following to no avail; 1. My register is at full width of my screen 2. The horizontal scroll bar is

[GNC] Loan to family member: How do i setup the account structure

2020-09-23 Thread John Mansfield
I have lent monies to a family member and now wish to track the balances on an ongoing basis. I have been looking at the guides etc but just cannot understand the concept / account hierarchy given my circumstances. The software I am using is: * Version: Version: 4.1, Build ID: