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

[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: 4.1+(2020-07-25)
  *   Windows 10

My location/currency is:

  *   GBP, UK Based

My Gnu Cash account setup is:

  *   I have a cheque account
  *   I have a savings account 1
  *   I have a savings account 2
  *   Plus others.

My use case is:

  *   It will be an interest free loan
  *   My family member has borrowed £2000
 *   Loan taken from Savings account 1 into
 *   Cheque Account then electronically bank transfer
 *   To family member bank account.
  *   A repayment is made each month
  *   The family member transfers a set amount, say £100.  This is 
electronically deposited into my bank Cheque account
  *   To date, I have electronically bank transferred monies into Savings 
Account 2 and updated gnu cash
  *   I have no immediate report of monies repaid / outstanding.

My preferred outcome:


  1.  To track the Principal amount of £2000
 *   To track each payment into my Cheque Account from family member - 
normally monthly (once bank transactions have been uploaded into gnu cash)
 *   To understand how much has been paid - to date
 *   To understand how much is outstanding
 *   To transfer each repayment into Gnu cash Savings account 2 and bank 
account
 *   To be able to get reports on the above.


Given the above, I would be most grateful if you can advise what account 
hierarchy / transaction splits etc I need in Gnu cash to support the above?

I thank you for your time and support.

Regards

John Mansfield

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 at the far right
  3.  The vertical scroll bar is visible
  4.  The balance column is no longer visible
  5.  In an attempt to show the 'balance' column I have;
 *   tried reducing the size of other columns

  i.especially the description 
field which seems impossible!?

 *   increased the size of other columns by highlighting the right edge of 
that column
 *   decreased the size of other columns by highlighting the right edge of 
the column - to no avail
 *   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 (more than one?) and it seems impossible to locate the column!
 *   I have closed the screen and reopened - to no avail
 *   I have closed gnu cash and restarted to see if column widths are reset 
- to no avail.

Has anyone got a resolution for this as I have spent so much time in trying to 
resolve.

Is there a column setting I can change?  Or am I missing something?

Many thanks.

Regards

John Mansfield

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 separators. I can drag 
the column separators at the top but when I release them, they the columns 
widths do not change. A related issue is the default width for the description 
column takes up 2/3 of the window, far more than I normally or have ever 
needed. But the real issue is that they can't be adjusted and are sometimes not 
wide enough to see the contents.

Thanks,
Will

On 2020 Sep 23, at 09-23 08:01:23, John Mansfield  
wrote:

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 at the far right
 3.  The vertical scroll bar is visible
 4.  The balance column is no longer visible
 5.  In an attempt to show the 'balance' column I have;
*   tried reducing the size of other columns

 i.especially the description field 
which seems impossible!?

*   increased the size of other columns by highlighting the right edge of 
that column
*   decreased the size of other columns by highlighting the right edge of 
the column - to no avail
*   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 (more than one?) and it seems impossible to locate the column!
*   I have closed the screen and reopened - to no avail
*   I have closed gnu cash and restarted to see if column widths are reset 
- to no avail.

Has anyone got a resolution for this as I have spent so much time in trying to 
resolve.

Is there a column setting I can change?  Or am I missing something?

Many thanks.

Regards

John Mansfield

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 and reverse the 
income recognized, whenever financial reports are to be issued, and 
especially at the end of a reporting year?


If your organization only required ONE financial report a year, doing it 
that way, adjusting "accrual" to cash" would perhaps be the least 
onerous way to proceed.


But all the organizations for which I have been treasurer required MUCH 
more frequent financial reports to be created. You are perhaps referring 
to the YE reports used to fill out the forms submitted to governments. 
And/or used for the annual financial report to the "membership".


To give you some examples:

One organization of which I was treasurer --- reports before each 
quarterly board meeting. And pretty printed YE report to post on website 
(actually use rougher form of YE for government forms as needing details 
uninteresting to membership)


Another, running an event -- before each meeting of the event committee, 
then a final filed with the national organization treasurer.


On organization of which I am not treasurer but on finance committee -- 
two major reports (pretty printed) one for membership annual meeting and 
one for semi-annual meeting (as in the first case, probably using the 
rougher form to fill out government forms). But also a report for every 
monthly meeting of the finance committee.


Still think adjusting before each report a good idea? BTW, two of those 
three examples "churches" << quotes because not Christian churches >>


Michael D Novack


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 (more than one?) and it seems

> 
> Has anyone got a resolution for this as I have spent so much time in trying
> to resolve.
> 

Can you get the mouse onto the thin black line and double click it?

HTH,
Maf.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 or right or 
the mouse pointer overlaps with the vertical bar!

As you are probably aware it is like "splitting" 2 thin lines.  

John

-Original Message-
From: Maf. King  
Sent: 23 September 2020 15:19
To: gnucash-user@gnucash.org
Cc: John Mansfield 
Subject: Re: [GNC] Register columns: The balance column is no longer visible

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 (more than one?) and it 
> seems

> 
> Has anyone got a resolution for this as I have spent so much time in 
> trying to resolve.
> 

Can you get the mouse onto the thin black line and double click it?

HTH,
Maf.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 person to home a loan is made.

For your use case enter the following transactions:
A.  Transfer £2000 from Savings1 to Checking.
B.  Transfer £2000 from Checking to FaF:Family1

Note:  If both happen at the same time, you could combine them into a
multi-split transaction with Checking having two offsetting splits.

 
C.  £100 from Faf:Family1 to Checking
D.  £100 from Checking to Savings2

Note:  Doubtful that the above two transactions happen at the same time
so shouldn't combine.

By looking at the transactions for each of the sub-accounts in FaF you
would see the original loan amount plus all the payments.  The account
balance would be the outstanding balance.

Now, if you should charge interest, the interest portion would be
income.  I presume that you already earn interest on other accounts so
would already have that account setup in the Income area of CoA.

The payment would then be split with FaF:FamilyX and Interest-Income on
one side and Checking as the destination.
 


On 9/23/20 4:27 AM, John Mansfield wrote:
> 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: 4.1+(2020-07-25)
>   *   Windows 10
>
> My location/currency is:
>
>   *   GBP, UK Based
>
> My Gnu Cash account setup is:
>
>   *   I have a cheque account
>   *   I have a savings account 1
>   *   I have a savings account 2
>   *   Plus others.
>
> My use case is:
>
>   *   It will be an interest free loan
>   *   My family member has borrowed £2000
>  *   Loan taken from Savings account 1 into
>  *   Cheque Account then electronically bank transfer
>  *   To family member bank account.
>   *   A repayment is made each month
>   *   The family member transfers a set amount, say £100.  This is 
> electronically deposited into my bank Cheque account
>   *   To date, I have electronically bank transferred monies into Savings 
> Account 2 and updated gnu cash
>   *   I have no immediate report of monies repaid / outstanding.
>
> My preferred outcome:
>
>
>   1.  To track the Principal amount of £2000
>  *   To track each payment into my Cheque Account from family member - 
> normally monthly (once bank transactions have been uploaded into gnu cash)
>  *   To understand how much has been paid - to date
>  *   To understand how much is outstanding
>  *   To transfer each repayment into Gnu cash Savings account 2 and bank 
> account
>  *   To be able to get reports on the above.
>
>
> Given the above, I would be most grateful if you can advise what account 
> hierarchy / transaction splits etc I need in Gnu cash to support the above?
>
> I thank you for your time and support.
>
> Regards
>
> John Mansfield

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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
> > it working.
> 
> Ah, but it's nothing to do with 'building' really.
> 
> > I was lightly following some Wiki Build Instruction discussion on IRC
> > recently and I think that very option (with needed dependency) was pointed
> > out as not being quite obvious.
> > 
> > Check out the Build on Linux pages (along with the sub-pages about
> > dependencies) and read their Talk sections for more current info and state
> > of the edits.
> 
> As above, nothing to do with 'building' IMHO.  It should be in the
> basic 'installation' notes.

Did someone already refer to
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html#basics-storage-comparison-tblsect[1]
 

That's a section in the tutorial about storing your data. And the note on 
availability of the three 
sql backends mentions you may have to install libdbi and the appropriate dbd 
(sql) backends.

Regards,

Geert


[1] 
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html#basics-storage-comparison-tblsect
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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
financial reports are to be issued, and especially at the end of a
reporting year?

The financial statements don't have to be accurate every day, it is only at
closing dates when adjusting entries need to be made.  For an organization
which uses cash accounting on a daily basis, e.g. perhaps recording revenue
only when cash is received to avoid having to create invoices in the
accounting system, the adjusting entry at the end of the year would be to
go in the opposite direction, to recognize some amount of accounts
receivable for work done already in December.  For example there is a
for-profit company i know that doesn't bother to invoice because they
always require payment from the customer before they will hand over their
completed custom product.  And while it might again come across to some as
fraudulent or lying or the like, but it happens to be okay by GAAP to make
this entry dated December 31 at a later true date, after the amounts are
known from the actual payments being received during January, so that the
prior year financial statements give a correct picture.   Others adjusting
entries are to recognize depreciation if any, to recognize any extra
accounts payable or receivable or prepaid expenses or unearned revenues
(where cash has been received from a customer but the work hasn't yet been
done) that one knows about but which haven't been recorded yet.  These
might only be done at quarterly closes or only at end of year.   It simply
is not necessary for invoicing status to be correct at every moment.

About invoicing members of a nonprofit, I hadn't even thought about using
accounting system to ask them for their annual fees.  Possibly it could be
efficient to do that way for some nonprofits, but in nonprofits that I know
the membership info is kept in a separate spreadsheet, with address list
used in a mail-merge (at least I hope they don't handle each new letter
individually), handled by membership person(s) instead of accountant.  So
there is a whole lot of duplication to the accounting system where each
payment received must be entered from scratch, and possibilities for
errors.  "Membership database" softwares exist that allow members to pay
dues at a website in a way that doesn't require separate accounting
entries, and allows them to update their info and allows many reports, and
supports much more.  Including one true freeware package developed under
Gnu Public license or similar that sounded good and I would be interested
to try, but it has warning that its developer-programmer no longer will
provide support (maybe it was one of those reviewed at
https://blog.capterra.com/top-7-free-open-source-membership-management-software-products/
?).  It would be _awesome_ if someone could take over one of these and make
it compatible with GnuCash!

Don
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] MT940 memo being truncated

[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!



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Import transactions

[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

   deposit

   withdrawal



   and I need to place transactions in various other accounts say:

   INCOME:Sales

   &

   EXPENSES:Purchases



   My confusion comes with understanding drop down list headings:

   ACTION

   TRANSFER ACCOUNT

   TRANSFER ACTIONetc.



   What are the Column Headings for the above scenario?



   Thank you



   Michael Middleton
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Shortcuts and Sorts

[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 for exactly the same price each time.  Or 
that my electric bill is the same every month.  It takes me more time to 
correct the autofilled amounts.  How do I turn this off?  I can’t find that in 
the help.

Otherwise, I really like the program over Quicken.  I was using an older 
version of it and they now want to charge every year for personal use if I 
update the program.  I don’t want to pay money each year for any program for 
personal use.  One time, yes.

Thank you for the program and please help.  If these aren’t options, can they 
be in a future release?
Walt

Sent from Mail for Windows 10

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Shortcuts and Sorts

[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 pattern, so I don't recall the best
way to trick it into submission.

On Wed, Sep 23, 2020 at 4:02 PM Walter Busch  wrote:

> 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 for exactly the same price each
> time.  Or that my electric bill is the same every month.  It takes me more
> time to correct the autofilled amounts.  How do I turn this off?  I can’t
> find that in the help.
>
> Otherwise, I really like the program over Quicken.  I was using an older
> version of it and they now want to charge every year for personal use if I
> update the program.  I don’t want to pay money each year for any program
> for personal use.  One time, yes.
>
> Thank you for the program and please help.  If these aren’t options, can
> they be in a future release?
> Walt
>
> Sent from Mail for
> Windows 10
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Shortcuts and Sorts

[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 you type in the current amount it 
replaces whatever was there.

I think they are great, but if they don't work for you, I can't tell you how to 
turn it off.

Will

On 2020 Sep 23, at 09-23 13:48:24, Walter Busch  wrote:

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 for exactly the same price each time.  Or 
that my electric bill is the same every month.  It takes me more time to 
correct the autofilled amounts.  How do I turn this off?  I can’t find that in 
the help.

Otherwise, I really like the program over Quicken.  I was using an older 
version of it and they now want to charge every year for personal use if I 
update the program.  I don’t want to pay money each year for any program for 
personal use.  One time, yes.

Thank you for the program and please help.  If these aren’t options, can they 
be in a future release?
Walt

Sent from Mail for Windows 10

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 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
> > it working.
> 
> Ah, but it's nothing to do with 'building' really.
> 
> > I was lightly following some Wiki Build Instruction discussion on IRC
> > recently and I think that very option (with needed dependency) was pointed
> > out as not being quite obvious.
> > 
> > Check out the Build on Linux pages (along with the sub-pages about
> > dependencies) and read their Talk sections for more current info and state
> > of the edits.
> 
> As above, nothing to do with 'building' IMHO.  It should be in the
> basic 'installation' notes.

Did someone already refer to
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html#basics-storage-comparison-tblsect[1]
 

That's a section in the tutorial about storing your data. And the note on 
availability of the three 
sql backends mentions you may have to install libdbi and the appropriate dbd 
(sql) backends.

Regards,

Geert


[1] 
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html#basics-storage-comparison-tblsect
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Shortcuts and Sorts

[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 potential to be the 
same every month.  If you have a landscaper, pool maintenance person, pest 
control service, etc., those are usually the same every month.   And it is not 
just the amount - it is the contra-account that they go to as well (being 
pre-filled).

Finally, with respect to the reconciliation, many people write very few checks 
anymore (I think I wrote one check last month).  So to me, (though many 
disagree), the R and n usage is moot (I don’t use it and don’t care to).  My 
bank balance and my GnuCash balance are almost always the same.  But even in 
the case where you write many checks and need the recon feature, sorting would 
not be something I would do -- I prefer having everything in date order as the 
program has it natively. 

Regardless of all of that -- I moved away from Quicken 3 years ago and it was 
the best move I ever did.  This program is a gem -- and beats the hell out of 
paying $70 or $80 or more every year just to do what this one does for free 
(and does a better job I might add!).  And the developers are pretty darn good 
- keep the 

Ken

-Original Message-
From: gnucash-user  On Behalf 
Of David Carlson
Sent: Wednesday, September 23, 2020 2:40 PM
To: Walter Busch 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Shortcuts and Sorts

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 pattern, so I don't recall the best way 
to trick it into submission.

On Wed, Sep 23, 2020 at 4:02 PM Walter Busch  wrote:

> 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 for exactly the same 
> price each time.  Or that my electric bill is the same every month.  
> It takes me more time to correct the auto filled amounts.  How do I 
> turn this off?  I can’t find that in the help.
>
> Otherwise, I really like the program over Quicken.  I was using an 
> older version of it and they now want to charge every year for 
> personal use if I update the program.  I don’t want to pay money each 
> year for any program for personal use.  One time, yes.
>
> Thank you for the program and please help.  If these aren’t options, 
> can they be in a future release?
> Walt
>
> Sent from Mail for 
> Windows 10
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


--
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Shortcuts and Sorts

[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 permanently) hide all reconciled transactions, or do a lot of other
things as well.

When you use the reconcile feature, no reconciled items will appear, so
they are not cluttering up that process.


On Wed, Sep 23, 2020 at 5:14 PM  wrote:

> 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
> potential to be the same every month.  If you have a landscaper, pool
> maintenance person, pest control service, etc., those are usually the same
> every month.   And it is not just the amount - it is the contra-account
> that they go to as well (being pre-filled).
>
> Finally, with respect to the reconciliation, many people write very few
> checks anymore (I think I wrote one check last month).  So to me, (though
> many disagree), the R and n usage is moot (I don’t use it and don’t care
> to).  My bank balance and my GnuCash balance are almost always the same.
> But even in the case where you write many checks and need the recon
> feature, sorting would not be something I would do -- I prefer having
> everything in date order as the program has it natively.
>
> Regardless of all of that -- I moved away from Quicken 3 years ago and it
> was the best move I ever did.  This program is a gem -- and beats the hell
> out of paying $70 or $80 or more every year just to do what this one does
> for free (and does a better job I might add!).  And the developers are
> pretty darn good - keep the
>
> Ken
>
> -Original Message-
> From: gnucash-user  On
> Behalf Of David Carlson
> Sent: Wednesday, September 23, 2020 2:40 PM
> To: Walter Busch 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Shortcuts and Sorts
>
> 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 pattern, so I don't recall the best
> way to trick it into submission.
>
> On Wed, Sep 23, 2020 at 4:02 PM Walter Busch  wrote:
>
> > 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 for exactly the same
> > price each time.  Or that my electric bill is the same every month.
> > It takes me more time to correct the auto filled amounts.  How do I
> > turn this off?  I can’t find that in the help.
> >
> > Otherwise, I really like the program over Quicken.  I was using an
> > older version of it and they now want to charge every year for
> > personal use if I update the program.  I don’t want to pay money each
> > year for any program for personal use.  One time, yes.
> >
> > Thank you for the program and please help.  If these aren’t options,
> > can they be in a future release?
> > Walt
> >
> > Sent from Mail for
> > Windows 10
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>

-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on al

Re: [GNC] Shortcuts and Sorts

[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] Shortcuts and Sorts

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 potential to be the 
same every month.  If you have a landscaper, pool maintenance person, pest 
control service, etc., those are usually the same every month.   And it is not 
just the amount - it is the contra-account that they go to as well (being 
pre-filled).

Finally, with respect to the reconciliation, many people write very few checks 
anymore (I think I wrote one check last month).  So to me, (though many 
disagree), the R and n usage is moot (I don’t use it and don’t care to).  My 
bank balance and my GnuCash balance are almost always the same.  But even in 
the case where you write many checks and need the recon feature, sorting would 
not be something I would do -- I prefer having everything in date order as the 
program has it natively. 

Regardless of all of that -- I moved away from Quicken 3 years ago and it was 
the best move I ever did.  This program is a gem -- and beats the hell out of 
paying $70 or $80 or more every year just to do what this one does for free 
(and does a better job I might add!).  And the developers are pretty darn good 
- keep the 

Ken

-Original Message-
From: gnucash-user  On Behalf 
Of David Carlson
Sent: Wednesday, September 23, 2020 2:40 PM
To: Walter Busch 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Shortcuts and Sorts

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 pattern, so I don't recall the best way 
to trick it into submission.

On Wed, Sep 23, 2020 at 4:02 PM Walter Busch  wrote:

> 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 for exactly the same 
> price each time.  Or that my electric bill is the same every month.
> It takes me more time to correct the auto filled amounts.  How do I 
> turn this off?  I can’t find that in the help.
>
> Otherwise, I really like the program over Quicken.  I was using an 
> older version of it and they now want to charge every year for 
> personal use if I update the program.  I don’t want to pay money each 
> year for any program for personal use.  One time, yes.
>
> Thank you for the program and please help.  If these aren’t options, 
> can they be in a future release?
> Walt
>
> Sent from Mail for 
> Windows 10
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


--
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists fo

Re: [GNC] Import transactions

[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&lang=C&doc=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 included 
a working CSV file and matching screenshots of the import process:


http://gnucash.1415818.n4.nabble.com/GNC-Tracking-cash-flows-with-balanced-transactions-tc4721056.html

The purpose of the drop down headings is to tell Gnucash what data you 
have in each column of your CSV file.


Another useful technique is to *export* some similar transactions to 
CSV, examine the structure of the CSV file produced by Gnucash, then try 
and import that file.


Hope this helps.

Regards

Geoff
=


On 23/09/2020 12:39 pm, Michael Middleton wrote:

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

deposit

withdrawal



and I need to place transactions in various other accounts say:

INCOME:Sales

&

EXPENSES:Purchases



My confusion comes with understanding drop down list headings:

ACTION

TRANSFER ACCOUNT

TRANSFER ACTIONetc.



What are the Column Headings for the above scenario?



Thank you



Michael Middleton
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 Balance column. (there is another hidden column to the right 
of Balance, but it would be odd to be able to show it)


3. Grab the right-hand divider for the Description Column and drag it to 
the LEFT - more than you think you need to. It will snap back to the 
right, taking up only the space not assigned to the other columns.


This should also get rid of the horizontal scroll bar.

*note—register widths are *per account register*. If you are in the 
Checking account and set these widths, then open a different account, 
the same widths will *not* carry over. (the devs are working on this, 
but this is the current situation)


Regards,
Adrien

On 9/23/20 8:01 AM, John Mansfield wrote:

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 at the far right
   3.  The vertical scroll bar is visible
   4.  The balance column is no longer visible
   5.  In an attempt to show the 'balance' column I have;
  *   tried reducing the size of other columns

   i.especially the description 
field which seems impossible!?

  *   increased the size of other columns by highlighting the right edge of 
that column
  *   decreased the size of other columns by highlighting the right edge of 
the column - to no avail
  *   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 (more than one?) and it seems impossible to locate the column!
  *   I have closed the screen and reopened - to no avail
  *   I have closed gnu cash and restarted to see if column widths are 
reset - to no avail.

Has anyone got a resolution for this as I have spent so much time in trying to 
resolve.

Is there a column setting I can change?  Or am I missing something?

Many thanks.

Regards

John Mansfield


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 taking up only the 
width *not* assigned to the other columns.


And again, these widths are *per account*, for now. (Bills and Invoices 
can now carry over your column widths but account registers are still 
one-at-a-time.)


For all columns *other* than Description, drag to the RIGHT, or 
double-click for auto sizing. For the Description, drag far LEFT and 
release.


Regards,
Adrien

On 9/23/20 8:32 AM, w...@theprescotts.com wrote:

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 separators. I can drag 
the column separators at the top but when I release them, they the columns 
widths do not change. A related issue is the default width for the description 
column takes up 2/3 of the window, far more than I normally or have ever 
needed. But the real issue is that they can't be adjusted and are sometimes not 
wide enough to see the contents.

Thanks,
Will


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Shortcuts and Sorts

[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 massive time saver. I record every single 
receipt, line by line. Certainly, it is rare for many of my receipts to 
be the exact same. The advantage is in filling in the splits for each 
line item.


If you end up with splits you don't need, you can right-click them and 
choose 'Delete Split'. There is also the option to 'Delete other splits' 
so you can keep just the one you want.


I think there is a bug report and maybe even work being done on 
multi-selecting splits for deletion, but I don't know when that will 
make its way to us. It would be another huge time saver.


Another advantage to autofill is that I put lots of detail in my split 
memos. Some of that stuff like grocery items is recurring from time to 
time, even though not every trip, and I have quite a nested tree of 
accounts for tracking that stuff. When I start typing for example, 
"Beef"... the previously assigned account automatically is populated for 
me. If I start typing "Beer"..., I get the same.


For nearly exactly recurring stuff (like a cable bill) the amounts may 
need to be changed, but the account assignments are done for you. That 
is not only a big time saver, but it also removes occasion for error in 
selecting the wrong one by mistake.


It took some getting used to at first, but I am much faster with it than 
without.




Regards,
Adrien

On 9/23/20 1:48 PM, Walter Busch wrote:

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 for exactly the same price each time.  Or 
that my electric bill is the same every month.  It takes me more time to 
correct the autofilled amounts.  How do I turn this off?  I can’t find that in 
the help.

Otherwise, I really like the program over Quicken.  I was using an older 
version of it and they now want to charge every year for personal use if I 
update the program.  I don’t want to pay money each year for any program for 
personal use.  One time, yes.

Thank you for the program and please help.  If these aren’t options, can they 
be in a future release?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 space. I see that now, but didn't realize 
that is what it was doing.

Will

On 2020 Sep 23, at 09-23 21:31:49, Adrien Monteleone 
 wrote:

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 taking up only the width *not* 
assigned to the other columns.

And again, these widths are *per account*, for now. (Bills and Invoices can now 
carry over your column widths but account registers are still one-at-a-time.)

For all columns *other* than Description, drag to the RIGHT, or double-click 
for auto sizing. For the Description, drag far LEFT and release.

Regards,
Adrien

On 9/23/20 8:32 AM, w...@theprescotts.com wrote:
> 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 separators. I can 
> drag the column separators at the top but when I release them, they the 
> columns widths do not change. A related issue is the default width for the 
> description column takes up 2/3 of the window, far more than I normally or 
> have ever needed. But the real issue is that they can't be adjusted and are 
> sometimes not wide enough to see the contents.
> Thanks,
> Will

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Shortcuts and Sorts

[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 brings up the last split, which is 
always wrong. So now, I just put a dummy value in there, and start with the 
total credit amount and account. If I’m disciplined about my descriptions, I 
get the split account filled out for me, which is handy, and I then just have 
to change the amount if necessary.

Some time after entering the credit, I can correct the memo entry. For example, 
my local supermarket is “Coles F.G.”. I just enter “Coles”, and I can go back, 
inset a space after “Coles”, and “F.G.” is auto-filled. Tab, Enter.

So, it’s a mixed blessing, but overall a time saver.

Peter

--
Peter West
p...@pbw.id.au
“For what will it profit a man if he gains the whole world and forfeits his 
soul?”

> On 24 Sep 2020, at 4:48 am, Walter Busch  wrote:
> 
> 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 for exactly the same price each time.  Or 
> that my electric bill is the same every month.  It takes me more time to 
> correct the autofilled amounts.  How do I turn this off?  I can’t find that 
> in the help.
> 
> Otherwise, I really like the program over Quicken.  I was using an older 
> version of it and they now want to charge every year for personal use if I 
> update the program.  I don’t want to pay money each year for any program for 
> personal use.  One time, yes.
> 
> Thank you for the program and please help.  If these aren’t options, can they 
> be in a future release?
> Walt
> 
> Sent from Mail for Windows 10
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.