date:20211107

Re: [GNC] Gnucash 3.7 - flatpak cannot recognize second internal HDD & USB Flashdrive

2021-11-07 Thread parag puranik via gnucash-user

 I am new to Linux shell commands. Please advise on how to use the filesystem 
command :--filesystem=$PATH_TO_USB_DRIVEAssuming my device name is 
/media/John/JETFLASH
--filesystem=$PATH_TO_USB_DRIVE



On Monday, 8 November, 2021, 12:09:02 pm IST, David H  
wrote:  
 
 Hi Parag,
You should read the wiki re flatpak - https://wiki.gnucash.org/wiki/Flatpak, 
specifically the following :-
How did you go with your csv file ?
Cheers David H.


Configuration

Granting Access to Other Resources

As each Flatpak app runs in a sandbox, you have to unlock additionally required 
resources like
   
   - USB Drive
  -sudo flatpak override org.gnucash.GnuCash 
--filesystem=$PATH_TO_USB_DRIVE

   - Smartcard Reader
  - To use smart cards in AqBanking  
  - on the host—your Linux PC—the demon pcscd must be running,
  - the related socket must become unlocked for your GnuCash-Flatpak once:  
sudo flatpak override org.gnucash.GnuCash --socket=pcsc



sudo may be required depending on the rest of your installation.
   
   - See also
  - https://docs.flatpak.org/en/latest/sandbox-permissions.html

On Mon, 8 Nov 2021 at 16:28, parag puranik via gnucash-user 
 wrote:

My existing system : Mint 19.3 Cinnamon -32 bit with latest updates - 
(installed on internal SSD) and Gnucash default version 2.6.19. I upgraded 
Gnucash through Software manager to Build : 3.7+(2019-09-07) -Flatpak. It was 
successfully installed while keeping my existing default version 2.6.19 intact. 
My Gnucash working files are stored on attached USB flash drive which I want to 
open and work upon through Menu>File>open . . . However on doing so my attached 
(i) second internal HDD and (ii) USB flash drive are not visible at all (even 
in "+other locations"). Only files in Home folder are visible.  On the other 
hand, on opening through the earlier ver 2.6.19 these devices are still very 
well visible. Why this anomaly ? and what is the solution ?
___
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] Gnucash 3.7 - flatpak cannot recognize second internal HDD & USB Flashdrive

2021-11-07 Thread David H

Hi Parag,

You should read the wiki re flatpak - https://wiki.gnucash.org/wiki/Flatpak,
specifically the following :-

How did you go with your csv file ?

Cheers David H.

ConfigurationGranting Access to Other Resources

As each Flatpak app runs in a sandbox, you have to unlock additionally
required resources like
USB Drive

sudo flatpak override org.gnucash.GnuCash --filesystem=$PATH_TO_USB_DRIVE

Smartcard ReaderTo use smart cards in AqBanking


   1. on the host—your Linux PC—the demon pcscd must be running,
   2. the related socket must become unlocked for your GnuCash-Flatpak once:

   sudo flatpak override org.gnucash.GnuCash --socket=pcsc


sudo may be required depending on the rest of your installation.
See alsohttps://docs.flatpak.org/en/latest/sandbox-permissions.html

On Mon, 8 Nov 2021 at 16:28, parag puranik via gnucash-user <
gnucash-user@gnucash.org> wrote:

> My existing system : Mint 19.3 Cinnamon -32 bit with latest updates -
> (installed on internal SSD) and Gnucash default version 2.6.19. I upgraded
> Gnucash through Software manager to Build : 3.7+(2019-09-07) -Flatpak. It
> was successfully installed while keeping my existing default version 2.6.19
> intact. My Gnucash working files are stored on attached USB flash drive
> which I want to open and work upon through Menu>File>open . . . However on
> doing so my attached (i) second internal HDD and (ii) USB flash drive are
> not visible at all (even in "+other locations"). Only files in Home folder
> are visible.  On the other hand, on opening through the earlier ver 2.6.19
> these devices are still very well visible. Why this anomaly ? and what is
> the solution ?
> ___
> 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.

[GNC] Gnucash 3.7 - flatpak cannot recognize second internal HDD & USB Flashdrive

2021-11-07 Thread parag puranik via gnucash-user

My existing system : Mint 19.3 Cinnamon -32 bit with latest updates - 
(installed on internal SSD) and Gnucash default version 2.6.19. I upgraded 
Gnucash through Software manager to Build : 3.7+(2019-09-07) -Flatpak. It was 
successfully installed while keeping my existing default version 2.6.19 intact. 
My Gnucash working files are stored on attached USB flash drive which I want to 
open and work upon through Menu>File>open . . . However on doing so my attached 
(i) second internal HDD and (ii) USB flash drive are not visible at all (even 
in "+other locations"). Only files in Home folder are visible.  On the other 
hand, on opening through the earlier ver 2.6.19 these devices are still very 
well visible. Why this anomaly ? and what is the solution ?
___
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] My MacOS Finance::Quote Successful Tweaks

2021-11-07 Thread prl


Ken, thanks from me for that, too.

I'd been able to get Finance::Quote to install from other installation 
instructions for macOS, but when I tried to use it I was getting 
authentication failures when F::Q tried to connect to a server using 
HTTPS. I think it was installing/updating Mozilla::CA that fixed that 
problem for me, probably something to do with the issues around the 
expiry of the DST_Root_CA_X3 certificate.


However, to follow your suggestions, I still needed to use cpan -if for 
B:Keywords, because it failed its installation tests.


Intel Mac, Monterey 12.0.1.

Thanks again,
Peter

On 5/11/21 13:57, Ken Farley wrote:
Not a question, just my notes on how I got Finance::Quote to work on a 
new Mac Mini M1.


Operating system is OS X 11.6 (Big Sur)

GnuCash Version is 4.8 (from the -2.dmg)

My initial install left me unable to download quotes (via 
Finance::Quote). Research online eventually led to a Reddit discussion 
about similar problems. Apparently the root cause of the trouble was 
that module Mozilla::CA provides certificates for inquiries, but was 
not installed with the  default Perl. Sequence of installs necessary 
for success was:


sudo cpan -i B::Keywords
sudo cpan -i Test2
sudo cpan -i DateTime
sudo cpan -i DateTime::Locale
sudo cpan -i DateTime::Format::Strptime
sudo cpan -i Mozilla::CA

Once those are all done then go to:

/Applications/Gnucash/Contents/Resources/bin

and run the Finance::Quote fixing script:

sudo ./gnc-fq-update

After all the above, all the wonderful quotes were downloaded 
beautifully. Now, if I could only get the courage to "upgrade" to 
Monterey...


___
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] Black Screen

2021-11-07 Thread Chris Rumney

Derek,

Just upgraded and now works fine.  Clearly an issue with Monteray that the 
latest version resolves.
Many thanks

Chris

From: Derek Atkins 
Date: Sunday, 7 November 2021 at 13:12
To: Chris Rumney , gnucash-user@gnucash.org 

Subject: Re: [GNC] Black Screen
Upgrade to 4.8-2

-derek
Sent using my mobile device. Please excuse any typos.

On November 7, 2021 7:58:58 AM Chris Rumney  wrote:

Hello,

For the last few days every time I open up Gnucash all I see is a black screen.
I am running it on a Mac, have closed the system down and restarted but this 
has no effect.
There is a lot of data there so am wary of just deleting and reinstalling.
All other programmes are working fine.
Has anyone had this problem and know how to resolve?

Many thanks

Chris
___
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] Problem with PayPal statements?

2021-11-07 Thread Frank H. Ellenberger

Hi Jean,

to understnad where to search I have aa few questions:

Am 07.11.21 um 16:36 schrieb Jean D. Boyle via gnucash-user:
> Hello fellow users of GNUCash,
> 
> Currently I am running GNUCash 4.8 with Flatpak on M20.2, and I have
> some troubles with GNUCash that i had not before:

and before you have been using an older Flatpak or a pristine GnuCash?

> When importing my statements from PayPal (*.csv), GNUCash starts to
> behave a bit strange.

Are you downloding the files manually and use then the CSV-Import or
have you setup Aqbanking to manage it for you?

> Although everything is correct in the /import
> preview/ -including the amount of deposit/withdrawal-, all amounts are
> doubled in the /Match Transaction; the rest is correct/.
> When opening this *.csv-file from PayPal, everything is correct,
> including all of the amounts; none are doubled. Therefore I think
> GNUCash seems to double the amounts.
> 
> Is this just on my M20.2, or do I something weird, or is it a bug? If
> the latter, I will fill in a proper bug report.

Regards
Frank
___
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] Report printing of annual transactions

2021-11-07 Thread Michael or Penny Novack






So how do I print a report that has every transaction for the yearly
accounting period January 01 through December 31 of any given year by
account number?



If new to gnucash, I strongly suggest looking at all of the reports you 
think you might want/need. Not just by the names gnucash gives them but 
actually look at the report to see what it does. Personally, I consider 
in a couple cases, the names given the reports slightly at odds with the 
names used in traditional accounting. Then when you have identified the 
ones you want, play around with the report options, keeping in mind that 
with gnucash you first run the report (create it) with default options 
and then tailor it to what you want.


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] Double entry bookkeeping for purchases to be paid at later date

2021-11-07 Thread Michael or Penny Novack


On 11/7/2021 10:36 AM, Stan Brown wrote:

On 2021-11-07 07:11, Sharon Sydnor wrote:

I am only experienced in basic bookkeeping but irrespective of what type of 
payment you intend to make, you have bought something you intend to pay for 
later hence IT IS a LIABILITY -so your second account WILL NOT  be a 
checking/payment account.

I would agree if the purchase was put on account ("charged"). But when I
write a check, I have paid for the purchase. That the check is postdated
is immaterial: legally I am obliged to have funds in my account and
maintain them there till the check is paid.


If we are being technical, the legal date is when we have made 
"constructive delivery" (mailed the check off). But more usual to use 
the date written under the assumption that this is known and the 
intention is that they will be mailed right out.


That there will almost always be a delay before the checks return to our 
bank is why at the end of a statement period we reconciled our checking 
account against the bank statement after adjusted for all checks 
outstanding. In other words, we expect the account in our books and on 
the bank statement will not agree because thew bank doesn't know about 
checks we have written but that they have not gotten back yet.


And spot on about the legality. It is not strictly legal to take 
advantage of "float". At least not here. Not unless you have an 
arrangement with the bank allowing overdrafts. If you do have an 
overdraft arrangement, then would be legal to use float up to that limit.


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] Report printing of annual transactions

2021-11-07 Thread Michael Hendry

On 7 Nov 2021, at 17:37, sydnorbill...@bellsouth.net wrote:

> 
> I had posted previously in trying to print a volume of year/y transactions
> for a reference compilation in black and white of all entries in account
> number order for any given year, I couldn't get the amounts to be included,
> and what had worked previously I can't find a way back to as the amounts do
> not appear in the line item results.  What I had gotten previously was a
> report with columns of:  Date, Description, Account, Transfer from/to, debit
> [amount], credit, [amount] Running balance [amount].  It listed pages of the
> many line item entries ending in totals by account with a bold line of text
> stating Total for [account number, account name]  TOTAL.   Trying to set up
> under General Ledger, General Journal, Transaction Report doesn't come close
> and I make my Options selections and put in the date range desired, and
> Select all in the Accounts and have program preferences set to the proper
> accounting range. 
> 
> 
> 
> So how do I print a report that has every transaction for the yearly
> accounting period January 01 through December 31 of any given year by
> account number?

Here’s how I produce a General Journal ordered by Account NAME.

Open the Transaction Report.

Click on Options

Click the “General” tab.

Choose the start and end dates.

Click the “Sorting” tab.

Choose Account Name as your Primary Key

This doesn’t quite deliver for you, as want to order by account NUMBER, but it 
should give you a start.

Hope that helps,

Michael

___
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] Report printing of annual transactions

2021-11-07 Thread sydnorbilling

I had posted previously in trying to print a volume of year/y transactions
for a reference compilation in black and white of all entries in account
number order for any given year, I couldn't get the amounts to be included,
and what had worked previously I can't find a way back to as the amounts do
not appear in the line item results.  What I had gotten previously was a
report with columns of:  Date, Description, Account, Transfer from/to, debit
[amount], credit, [amount] Running balance [amount].  It listed pages of the
many line item entries ending in totals by account with a bold line of text
stating Total for [account number, account name]  TOTAL.   Trying to set up
under General Ledger, General Journal, Transaction Report doesn't come close
and I make my Options selections and put in the date range desired, and
Select all in the Accounts and have program preferences set to the proper
accounting range. 

 

So how do I print a report that has every transaction for the yearly
accounting period January 01 through December 31 of any given year by
account number?

 

 

___
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] gnucash-user Digest, Vol 224, Issue 15

2021-11-07 Thread sydnorbilling

Stan, yes understand your point under the circumstances as you understood
them.  I misunderstood - still don't know what a head check is but it didn't
conjure up Bill Pay for me - and I oversimplififed the inquiry.

-Original Message-
From: gnucash-user
 On Behalf Of
gnucash-user-requ...@gnucash.org
Sent: Sunday, November 7, 2021 12:00 PM
To: gnucash-user@gnucash.org
Subject: gnucash-user Digest, Vol 224, Issue 15

Send gnucash-user mailing list submissions to
gnucash-user@gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
gnucash-user-requ...@gnucash.org

You can reach the person managing the list at
gnucash-user-ow...@gnucash.org

When replying, please edit your Subject line so it is more specific than
"Re: Contents of gnucash-user digest..."

Today's Topics:

   1. Re:  Double entry bookkeeping for purchases to be paid at
  later date (Stan Brown)
   2.  Problem with PayPal statements? (Jean D. Boyle)

--

Message: 1
Date: Sun, 7 Nov 2021 07:36:28 -0800
From: Stan Brown 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Double entry bookkeeping for purchases to be paid
at later date
Message-ID: <53814a15-5da0-3f42-1119-089e1f582...@fastmail.fm>
Content-Type: text/plain; charset=utf-8

On 2021-11-07 07:11, Sharon Sydnor wrote:
> I am only experienced in basic bookkeeping but irrespective of what type
of payment you intend to make, you have bought something you intend to pay
for later hence IT IS a LIABILITY -so your second account WILL NOT  be a
checking/payment account. 

I would agree if the purchase was put on account ("charged"). But when I
write a check, I have paid for the purchase. That the check is postdated is
immaterial: legally I am obliged to have funds in my account and maintain
them there till the check is paid.

When I write a check for a future date, or schedule a bill payment on my
bank's website for a future date, I book the debit to whatever account and
the credit to the bank account right away, dated with the current date.
Include the expected payment date in the Description field, e.g.
"State Farm Auto pays 11 Dec".

Some people choose to record the transaction right away, but as a future
transaction. I do it the way I do so that my account balance on my books is
decreased immediately, and therefore I never run the risk of being
accidentally overdrawn.

-- 

Stan Brown

Tehachapi, CA, USA

https://BrownMath.com

https://OakRoadSystems.com

--

Message: 2
Date: Sun, 7 Nov 2021 16:36:51 +0100
From: "Jean D. Boyle" <8...@vivaldi.net>
To: gnucash-user@gnucash.org
Subject: [GNC] Problem with PayPal statements?
Message-ID: 
Content-Type: text/plain; charset=utf-8; format=flowed

Hello fellow users of GNUCash,

Currently I am running GNUCash 4.8 with Flatpak on M20.2, and I have some
troubles with GNUCash that i had not before:

When importing my statements from PayPal (*.csv), GNUCash starts to behave a
bit strange. Although everything is correct in the /import preview/
-including the amount of deposit/withdrawal-, all amounts are doubled in the
/Match Transaction; the rest is correct/.
When opening this *.csv-file from PayPal, everything is correct, including
all of the amounts; none are doubled. Therefore I think GNUCash seems to
double the amounts.

Is this just on my M20.2, or do I something weird, or is it a bug? If the
latter, I will fill in a proper bug report.

--
86ul

--

Subject: Digest Footer

___

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.

--

End of gnucash-user Digest, Vol 224, Issue 15
*

___
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] Problem with PayPal statements?

2021-11-07 Thread Jean D. Boyle via gnucash-user


Hello fellow users of GNUCash,

Currently I am running GNUCash 4.8 with Flatpak on M20.2, and I have 
some troubles with GNUCash that i had not before:


When importing my statements from PayPal (*.csv), GNUCash starts to 
behave a bit strange. Although everything is correct in the /import 
preview/ -including the amount of deposit/withdrawal-, all amounts are 
doubled in the /Match Transaction; the rest is correct/.
When opening this *.csv-file from PayPal, everything is correct, 
including all of the amounts; none are doubled. Therefore I think 
GNUCash seems to double the amounts.


Is this just on my M20.2, or do I something weird, or is it a bug? If 
the latter, I will fill in a proper bug report.


--
86ul

___
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] Double entry bookkeeping for purchases to be paid at later date

2021-11-07 Thread Stan Brown

On 2021-11-07 07:11, Sharon Sydnor wrote:
> I am only experienced in basic bookkeeping but irrespective of what type of 
> payment you intend to make, you have bought something you intend to pay for 
> later hence IT IS a LIABILITY -so your second account WILL NOT  be a 
> checking/payment account. 

I would agree if the purchase was put on account ("charged"). But when I
write a check, I have paid for the purchase. That the check is postdated
is immaterial: legally I am obliged to have funds in my account and
maintain them there till the check is paid.

When I write a check for a future date, or schedule a bill payment on my
bank's website for a future date, I book the debit to whatever account
and the credit to the bank account right away, dated with the current
date. Include the expected payment date in the Description field, e.g.
"State Farm Auto pays 11 Dec".

Some people choose to record the transaction right away, but as a future
transaction. I do it the way I do so that my account balance on my books
is decreased immediately, and therefore I never run the risk of being
accidentally overdrawn.

-- 

Stan Brown

Tehachapi, CA, USA

https://BrownMath.com

https://OakRoadSystems.com
___
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] My MacOS Finance::Quote Successful Tweaks

2021-11-07 Thread Ken Farley

Hope it works out for you. I noticed there are sporadic questions
about this kind of thing and thought it might be nice to have a place
where all the stuff that worked for someone (me, in this case) is
spelled out in a straightforward fashion, rather than spread over a
whole heap of messages.
So glad the GTK-3 stuff I figured out for 3.11 is still okay for 4.8.
Also, the speed of loading on the M1 is really remarkable. What used
to take a bit of time is almost a blink and you miss it.

On Thu, Nov 4, 2021 at 11:36 PM David H  wrote:
>
> Ken,
>
> Thanks for that, I haven't had FQ running on Big Sur since I upgraded to it 
> during the beta's :-)  Will try that on my iMac running Big Sur in a moment.  
> It came good on my MacBook Pro after upgrading to Monterey and running 
> gnc-fq-update I think it was but I still haven't got it running on BS.  The 
> modules you listed are all ones that FQ Update had issues with when I tried 
> to update on BS so here goes :-)
>
> Cheers David H.
>
>
> On Fri, 5 Nov 2021 at 12:58, Ken Farley  wrote:
>>
>> Not a question, just my notes on how I got Finance::Quote to work on a
>> new Mac Mini M1.
>>
>> Operating system is OS X 11.6 (Big Sur)
>>
>> GnuCash Version is 4.8 (from the -2.dmg)
>>
>> My initial install left me unable to download quotes (via
>> Finance::Quote). Research online eventually led to a Reddit discussion
>> about similar problems. Apparently the root cause of the trouble was
>> that module Mozilla::CA provides certificates for inquiries, but was not
>> installed with the  default Perl. Sequence of installs necessary for
>> success was:
>>
>> sudo cpan -i B::Keywords
>> sudo cpan -i Test2
>> sudo cpan -i DateTime
>> sudo cpan -i DateTime::Locale
>> sudo cpan -i DateTime::Format::Strptime
>> sudo cpan -i Mozilla::CA
>>
>> Once those are all done then go to:
>>
>> /Applications/Gnucash/Contents/Resources/bin
>>
>> and run the Finance::Quote fixing script:
>>
>> sudo ./gnc-fq-update
>>
>> After all the above, all the wonderful quotes were downloaded
>> beautifully. Now, if I could only get the courage to "upgrade" to
>> Monterey...
>>
>> ___
>> 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.

[GNC] Double entry bookkeeping for purchases to be paid at later date: LIABILITIES Re: gnucash-user Digest, Vol 224, Issue 13

2021-11-07 Thread Sharon Sydnor

re problems with the way I view this!
> 
> Michael
> 
> 
> 
> --
> 
> Message: 4
> Date: Sun, 7 Nov 2021 22:12:11 +1100
> From: Doug 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] question from newbie
> Message-ID: <20211107221211.103d6...@internode.on.net>
> Content-Type: text/plain; charset=UTF-8
> 
> Similar comment, by a non-accountant. What I do with transactions that are 
> planned is to enter them when I place
> the forward transaction with the bank, & set the date as when the account 
> will be paid (or transferred). 
> I can always see the current day balance by looking at the dividing line on 
> the account at todays date.
> Recurring expenses such as loan payments, periodical payments etc are copied 
> using the duplicated transaction,
> then edited if required. This is handy for transactions with multiple splits 
> (such as your pay if employed), 
> where the amounts might change, but the splits remain fairly consistent 
> (albeit with changed amounts).
> eg in my case for deposited weekly pay (before I retired!) I had (to give an 
> idea) Total pay> Income; Tax> Tax; Superannuation> Super; 
> various benefits & payments such as Union fees> relevant accounts. By using a 
> duplicated transaction, it is 
> easier to remember exactly how the splits are distributed.
> Hope that helps Mr Newbie!
> regards, Doug 
> 
> On Sun, 7 Nov 2021 10:42:10 +
> Michael Hendry  wrote:
> 
>>> On 6 Nov 2021, at 21:40, Shevach Pepper  wrote:
>>> 
>>>  Hello there,
>>>  'I'm having trouble on how to record buying groceries on Jan. 1  with a
>>>  head check for Feb. 1
>>>  What I understood from the manual that this is not an expense but a
>>>  liablity but I don't understand if I should make two accounts one
>>>  expense: grocery and one "liability: grocery" or some easier way to
>>>  record this.
>>>  Thank you very much for the help
>>>  Shevach
>>>  gif  
>> 
>> I?m assuming a ?head check? is what we in the UK would call a post-dated 
>> cheque - a cheque which can?t be cashed until a stated date; for what it?s 
>> worth, I understand that banks in the UK will often make the payment if the 
>> cheque is presented early.
>> 
>> I would suggest recording the expense on the date of the purchase as a 
>> transaction between your checking account and the grocery store. If you 
>> wish, you could add a note to indicate that the check can?t be presented 
>> until 1st Feb to avoid confusion when reconciling the bank account.
>> 
>> It?s a similar situation to making a postal payment by check - you know that 
>> the payee won?t receive it for several days and may not take it to the bank 
>> for several days after that, but you?re recording your commitment to the 
>> payee rather than the date on which the bank transfers the money to his 
>> account.
>> 
>> I am not an accountant, but there are those on the list who will no doubt 
>> correct me if there are problems with the way I view this!
>> 
>> Michael
>> 
>> ___
>> 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.
> 
> 
> -- 
> 
> 
> --
> 
> Message: 5
> Date: Sun, 7 Nov 2021 15:08:42 +0300
> From: Platon Pronko 
> To: gnucash-user@gnucash.org
> Subject: [GNC] difficulties with managing accounts with lots of split
>transactions
> Message-ID: <3a2924a2-4048-d0cb-663a-cac036f75...@gmail.com>
> Content-Type: text/plain; charset="utf-8"; Format="flowed"
> 
> Hi!
> 
> I currently find it a bit difficult to handle multi-split transactions that 
> include several "splits" going to the same account. For example, if I'm 
> buying some computer hardware I want to record the prices of each part for 
> later reference, but all those parts are recorded in "Hardware" account - 
> thus several splits go into the same account.
> 
> In default "Basic Ledger" view this is shown in a confusing way - each split 
> gets its own row, but each row displays the same transaction description (not 
> the name of the individual part).
>

Re: [GNC] question from newbie

2021-11-07 Thread Jean-David Beyer via gnucash-user


On 11/7/21 05:42, Michael Hendry wrote:

I’m assuming a “head check” is what we in the UK would call a post-dated cheque 
- a cheque which can’t be cashed until a stated date; for what it’s worth, I 
understand that banks in the UK will often make the payment if the cheque is 
presented early.


As far as I can tell, here in the USA, checks are seldom seen by human 
eyes. The MICR scanner reads the account number and a 
character-recognitian scanner tries to read the amount. Only if that 
faiul does a human being try to read the amount. Consequently, 
post-dating a check is usually ignored.


It also was a custom for a bank not to cash a check over 90 days old, 
but that is not always happens either.


With a post office as bad as here in USA, more and more checks do not 
make it to their destination. The worst recent case for me was a check 
mailed inside the post office to a post office box in the same post 
office that was returned months later from another post office, saying 
there was no such post office box.


--
  .~.  Jean-David Beyer
  /V\  Shrewsbury, New Jersey
 /( )\ Red Hat Enterprise Linux
 ^^-^^ up 2 days, 21 hours, 27 minutes
___
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] Updating from v 2.6.16.

2021-11-07 Thread Mike Stillingfleet

Thank you to All. I am now on 4.8 and all appears to be OK.

On Fri, Nov 5, 2021, at 12:07 AM, David H wrote:
> Gyle,
> 
> That is not correct.  Version 4.8 was an upgrade for ALL OS's not just Mac 
> OS.  Version 4.8.2 was an update for Mac OS only to fix screen issues in 
> Monterey.
> 
> Cheers David H.
> 
> 
> On Fri, 5 Nov 2021 at 09:16, Gyle McCollam  wrote:
>> Mike, I have been using 4.7 for a couple months now on Windows 10 and I have 
>> had zero issues.  Version 4.8 was an update for Mac users, because there was 
>> an issue on Macs with 4.7.  Upgrading the way, you ask would be extremely 
>> time consuming and I could see if it is not done right causing you many 
>> problems that a straight upgrade shouldn't cause.  However, if you want to 
>> go that route you would need to duplicate the program and data files to a 
>> new directory.  Not move, but duplicate, so you could copy them back if 
>> needed.  Then you could upgrade to 3.11, check it out and when satisfied, 
>> duplicate those program and data files to another newly created directory 
>> and repeat the upgrade process to 4.7 or 4.8.  It is a lot of work when the 
>> releases are stable and you shouldn't have a problem with upgrading.  
>> Whatever you choose, good luck.
>> 
>> Another thought, you could create a restore point in Windows, before each 
>> upgrade.  That way you can go back to the previous version.  However, you 
>> couldn't run the 3 versions simultaneously and while you are testing the new 
>> version any other programs you use would go back to that point in time as 
>> well.
>> 
>> 
>> Thank You,
>> Gyle McCollam
>> 
>> Gyle McCollam
>> 
>> 609.680.2326 Mobile
>> 
>> gmccol...@live.com   email
>> 
>> 
>> From: gnucash-user  on 
>> behalf of Mike Stillingfleet 
>> Sent: Thursday, November 4, 2021 4:58 PM
>> To: gnucash-user@gnucash.org 
>> Subject: [GNC] Updating from v 2.6.16.
>> 
>> 
>> Good Evening All,
>> 
>> It would appear that my current version of 2.6.16 is a bit out of date.
>> 
>> I have been looking at a route to updating.
>> 
>> I see that I can download a stable version 3.11 and 4.8.
>> 
>> My question is can I install all 3 versions at the same time so that I can 
>> migrate and check the integrity before moving forward whilst ensuring that I 
>> still have a viable system in 2.6.16.
>> 
>> If so how would I do the install.  I use Windows 10.
>> 
>> T.i.a
>> --
>>   Mike Stillingfleet
>>   mikestillingfl...@fastmail.co.uk
>> ___
>> 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.

-- 
  Mike Stillingfleet
  mikestillingfl...@fastmail.co.uk

___
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] difficulties with managing accounts with lots of split transactions

2021-11-07 Thread Platon Pronko

Thanks for the tip about hotkeys, that's quite useful (I was longing for a way
to toggle splits for a long time).

Best regards,
Platon Pronko

On 2021-11-07 16:16, david whiting wrote:

I've set up hotkeys for the different views that gnucash has and I
find it helpful for this sort of thing. It allows me to quickly switch
between different views.

ctrl+1: basic view
ctrl+2: auto-split view (all splits for current transaction)
ctrl+3: transaction journal view (all splits for all transactions)
ctrl+4: toggle double line view (to see transaction notes)

Here's how to set it up:
https://lists.gnucash.org/pipermail/gnucash-user/2020-August/092757.html

David

On Sun, 7 Nov 2021 at 12:09, Platon Pronko wrote:

Hi!

I currently find it a bit difficult to handle multi-split transactions that include several
"splits" going to the same account. For example, if I'm buying some computer hardware I
want to record the prices of each part for later reference, but all those parts are recorded in
"Hardware" account - thus several splits go into the same account.

In default "Basic Ledger" view this is shown in a confusing way - each split
gets its own row, but each row displays the same transaction description (not the name of
the individual part).

For the moment I explored several different solutions to this situation:

1. Record each item (hardware part in this example) as a separate transaction.
This solves the issue with display since I can now put each item name into the
description field. But now I have multiple transactions my credit card account,
which would make reliable reconciliation almost impossible.

2. Use the "Transaction Journal" view. It handles this situation a bit better than
"Basic Ledger" - the rows are not duplicated. But it show all the splits, even the ones
not related to the currently viewed account, and the simple two-split transactions start taking 3
rows each, which is too verbose, especially since this is a global setting.

3. Show "memo" as a separate column in "Basic Ledger" view (I've attached the
code patch that does it, applies to version 4.8). This works quite nicely - simple transactions
keep using one row, complex transactions display only the splits related to the current register
and each split shows its memo right in the register. However this is a code customization, won't
help anybody else with similar problems, and maintaining it is going to be more difficult than
built-in solutions.

Do you have any suggestions about a better way of handling this?

Best regards,
Platon Pronko___
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] difficulties with managing accounts with lots of split transactions

2021-11-07 Thread Platon Pronko

Storing the info simply in the notes (or in a scan) feels a bit unstructured -
harder to analyze later.
But I didn't know about ability to attach a link to the transaction, that might
be handy later -
thanks for the tip.

Best regards,
Platon Pronko

On 2021-11-07 16:13, Derek Atkins wrote:

Use a vendor invoice to record it.. Or scan the receipt and attach it.. Or put
the info into the notes... Or..

Lots of options.

-derek
Sent using my mobile device. Please excuse any typos.
On November 7, 2021 7:10:42 AM Platon Pronko wrote:

Hi!

In default "Basic Ledger" view this is shown in a confusing way - each split
gets its own row, but each row displays the same transaction description (not the name of
the individual part).

For the moment I explored several different solutions to this situation:

Do you have any suggestions about a better way of handling this?

Best regards,
Platon Pronko

--
___
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] difficulties with managing accounts with lots of split transactions

2021-11-07 Thread david whiting

I've set up hotkeys for the different views that gnucash has and I
find it helpful for this sort of thing. It allows me to quickly switch
between different views.

ctrl+1: basic view
ctrl+2: auto-split view (all splits for current transaction)
ctrl+3: transaction journal view (all splits for all transactions)
ctrl+4: toggle double line view (to see transaction notes)

Here's how to set it up:
https://lists.gnucash.org/pipermail/gnucash-user/2020-August/092757.html

David

On Sun, 7 Nov 2021 at 12:09, Platon Pronko  wrote:
>
> Hi!
>
> I currently find it a bit difficult to handle multi-split transactions that 
> include several "splits" going to the same account. For example, if I'm 
> buying some computer hardware I want to record the prices of each part for 
> later reference, but all those parts are recorded in "Hardware" account - 
> thus several splits go into the same account.
>
> In default "Basic Ledger" view this is shown in a confusing way - each split 
> gets its own row, but each row displays the same transaction description (not 
> the name of the individual part).
>
> For the moment I explored several different solutions to this situation:
>
> 1. Record each item (hardware part in this example) as a separate 
> transaction. This solves the issue with display since I can now put each item 
> name into the description field. But now I have multiple transactions my 
> credit card account, which would make reliable reconciliation almost 
> impossible.
>
> 2. Use the "Transaction Journal" view. It handles this situation a bit better 
> than "Basic Ledger" - the rows are not duplicated. But it show all the 
> splits, even the ones not related to the currently viewed account, and the 
> simple two-split transactions start taking 3 rows each, which is too verbose, 
> especially since this is a global setting.
>
> 3. Show "memo" as a separate column in "Basic Ledger" view (I've attached the 
> code patch that does it, applies to version 4.8). This works quite nicely - 
> simple transactions keep using one row, complex transactions display only the 
> splits related to the current register and each split shows its memo right in 
> the register. However this is a code customization, won't help anybody else 
> with similar problems, and maintaining it is going to be more difficult than 
> built-in solutions.
>
> Do you have any suggestions about a better way of handling this?
>
> Best regards,
> Platon Pronko___
> 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 Whiting
___
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] difficulties with managing accounts with lots of split transactions

2021-11-07 Thread Derek Atkins

Use a vendor invoice to record it..  Or scan the receipt and attach it..  
Or put the info into the notes... Or..


Lots of options.

-derek
Sent using my mobile device. Please excuse any typos.
On November 7, 2021 7:10:42 AM Platon Pronko  wrote:


Hi!

I currently find it a bit difficult to handle multi-split transactions that 
include several "splits" going to the same account. For example, if I'm 
buying some computer hardware I want to record the prices of each part for 
later reference, but all those parts are recorded in "Hardware" account - 
thus several splits go into the same account.


In default "Basic Ledger" view this is shown in a confusing way - each 
split gets its own row, but each row displays the same transaction 
description (not the name of the individual part).


For the moment I explored several different solutions to this situation:

1. Record each item (hardware part in this example) as a separate 
transaction. This solves the issue with display since I can now put each 
item name into the description field. But now I have multiple transactions 
my credit card account, which would make reliable reconciliation almost 
impossible.


2. Use the "Transaction Journal" view. It handles this situation a bit 
better than "Basic Ledger" - the rows are not duplicated. But it show all 
the splits, even the ones not related to the currently viewed account, and 
the simple two-split transactions start taking 3 rows each, which is too 
verbose, especially since this is a global setting.


3. Show "memo" as a separate column in "Basic Ledger" view (I've attached 
the code patch that does it, applies to version 4.8). This works quite 
nicely - simple transactions keep using one row, complex transactions 
display only the splits related to the current register and each split 
shows its memo right in the register. However this is a code customization, 
won't help anybody else with similar problems, and maintaining it is going 
to be more difficult than built-in solutions.


Do you have any suggestions about a better way of handling this?

Best regards,
Platon Pronko


--
___
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] Black Screen

2021-11-07 Thread Derek Atkins


Upgrade to 4.8-2

-derek
Sent using my mobile device. Please excuse any typos.
On November 7, 2021 7:58:58 AM Chris Rumney  wrote:


Hello,

For the last few days every time I open up Gnucash all I see is a black screen.
I am running it on a Mac, have closed the system down and restarted but 
this has no effect.

There is a lot of data there so am wary of just deleting and reinstalling.
All other programmes are working fine.
Has anyone had this problem and know how to resolve?

Many thanks

Chris
___
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.

[GNC] Black Screen

2021-11-07 Thread Chris Rumney

Hello,

For the last few days every time I open up Gnucash all I see is a black screen.
I am running it on a Mac, have closed the system down and restarted but this 
has no effect.
There is a lot of data there so am wary of just deleting and reinstalling.
All other programmes are working fine.
Has anyone had this problem and know how to resolve?

Many thanks

Chris
___
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] difficulties with managing accounts with lots of split transactions

2021-11-07 Thread Platon Pronko


Hi!

I currently find it a bit difficult to handle multi-split transactions that include several 
"splits" going to the same account. For example, if I'm buying some computer hardware I 
want to record the prices of each part for later reference, but all those parts are recorded in 
"Hardware" account - thus several splits go into the same account.

In default "Basic Ledger" view this is shown in a confusing way - each split 
gets its own row, but each row displays the same transaction description (not the name of 
the individual part).

For the moment I explored several different solutions to this situation:

1. Record each item (hardware part in this example) as a separate transaction. 
This solves the issue with display since I can now put each item name into the 
description field. But now I have multiple transactions my credit card account, 
which would make reliable reconciliation almost impossible.

2. Use the "Transaction Journal" view. It handles this situation a bit better than 
"Basic Ledger" - the rows are not duplicated. But it show all the splits, even the ones 
not related to the currently viewed account, and the simple two-split transactions start taking 3 
rows each, which is too verbose, especially since this is a global setting.

3. Show "memo" as a separate column in "Basic Ledger" view (I've attached the 
code patch that does it, applies to version 4.8). This works quite nicely - simple transactions 
keep using one row, complex transactions display only the splits related to the current register 
and each split shows its memo right in the register. However this is a code customization, won't 
help anybody else with similar problems, and maintaining it is going to be more difficult than 
built-in solutions.

Do you have any suggestions about a better way of handling this?

Best regards,
Platon PronkoAdd a memo column after description column.

diff --git a/gnucash/register/ledger-core/split-register-layout.c b/gnucash/register/ledger-core/split-register-layout.c
index 6f7f2bef9..6fbc14789 100644
--- a/gnucash/register/ledger-core/split-register-layout.c
+++ b/gnucash/register/ledger-core/split-register-layout.c
@@ -93,20 +93,21 @@ gnc_split_register_set_cells (SplitRegister* reg, TableLayout* layout)
 gnc_table_layout_set_cell (layout, curs, DATE_CELL,  0, 0);
 gnc_table_layout_set_cell (layout, curs, NUM_CELL,   0, 1);
 gnc_table_layout_set_cell (layout, curs, DESC_CELL,  0, 2);
-gnc_table_layout_set_cell (layout, curs, MXFRM_CELL, 0, 3);
-gnc_table_layout_set_cell (layout, curs, RECN_CELL,  0, 4);
+gnc_table_layout_set_cell (layout, curs, MEMO_CELL,  0, 3);
+gnc_table_layout_set_cell (layout, curs, MXFRM_CELL, 0, 4);
+gnc_table_layout_set_cell (layout, curs, RECN_CELL,  0, 5);
 if (reg->is_template)
 {
-gnc_table_layout_set_cell (layout, curs, FDEBT_CELL, 0, 5);
-gnc_table_layout_set_cell (layout, curs, FCRED_CELL, 0, 6);
+gnc_table_layout_set_cell (layout, curs, FDEBT_CELL, 0, 6);
+gnc_table_layout_set_cell (layout, curs, FCRED_CELL, 0, 7);
 }
 else
 {
-gnc_table_layout_set_cell (layout, curs, DEBT_CELL,  0, 5);
-gnc_table_layout_set_cell (layout, curs, CRED_CELL,  0, 6);
+gnc_table_layout_set_cell (layout, curs, DEBT_CELL,  0, 6);
+gnc_table_layout_set_cell (layout, curs, CRED_CELL,  0, 7);
 }
-gnc_table_layout_set_cell (layout, curs, BALN_CELL,  0, 7);
-gnc_table_layout_set_cell (layout, curs, RATE_CELL, 0, 8);
+gnc_table_layout_set_cell (layout, curs, BALN_CELL,  0, 8);
+gnc_table_layout_set_cell (layout, curs, RATE_CELL, 0, 9);
 
 curs_last = curs;
 curs = gnc_table_layout_get_cursor (layout,
@@ -135,10 +136,10 @@ gnc_split_register_set_cells (SplitRegister* reg, TableLayout* layout)
 gnc_table_layout_set_cell (layout, curs, DATE_CELL,  0, 0);
 gnc_table_layout_set_cell (layout, curs, NUM_CELL,   0, 1);
 gnc_table_layout_set_cell (layout, curs, DESC_CELL,  0, 2);
-gnc_table_layout_set_cell (layout, curs, TDEBT_CELL, 0, 5);
-gnc_table_layout_set_cell (layout, curs, TCRED_CELL, 0, 6);
-gnc_table_layout_set_cell (layout, curs, TBALN_CELL, 0, 7);
-gnc_table_layout_set_cell (layout, curs, RATE_CELL, 0, 8);
+gnc_table_layout_set_cell (layout, curs, TDEBT_CELL, 0, 6);
+gnc_table_layout_set_cell (layout, curs, TCRED_CELL, 0, 7);
+gnc_table_layout_set_cell (layout, curs, TBALN_CELL, 0, 8);
+gnc_table_layout_set_cell (layout, curs, RATE_CELL, 0, 9);
 
 curs_last = curs;
 curs = gnc_table_layout_get_cursor (layout,
@@ -165,19 +166,19 @@ gnc_split_register_set_cells (SplitRegister* reg, TableLayout* layout)
 
 gnc_table_layout_set_cell (layout, curs, ACTN_CELL, 0, 1);
 gnc_table_layout_set_cell (layout, curs, MEMO_CELL,

Re: [GNC] question from newbie

2021-11-07 Thread Doug

Similar comment, by a non-accountant. What I do with transactions that are 
planned is to enter them when I place
 the forward transaction with the bank, & set the date as when the account will 
be paid (or transferred). 
I can always see the current day balance by looking at the dividing line on the 
account at todays date.
 Recurring expenses such as loan payments, periodical payments etc are copied 
using the duplicated transaction,
 then edited if required. This is handy for transactions with multiple splits 
(such as your pay if employed), 
where the amounts might change, but the splits remain fairly consistent (albeit 
with changed amounts).
eg in my case for deposited weekly pay (before I retired!) I had (to give an 
idea) Total pay> Income; Tax> Tax; Superannuation> Super; 
various benefits & payments such as Union fees> relevant accounts. By using a 
duplicated transaction, it is 
easier to remember exactly how the splits are distributed.
Hope that helps Mr Newbie!
regards, Doug 

On Sun, 7 Nov 2021 10:42:10 +
Michael Hendry  wrote:

> On 6 Nov 2021, at 21:40, Shevach Pepper  wrote:
> > 
> >   Hello there,
> >   'I'm having trouble on how to record buying groceries on Jan. 1  with a
> >   head check for Feb. 1
> >   What I understood from the manual that this is not an expense but a
> >   liablity but I don't understand if I should make two accounts one
> >   expense: grocery and one "liability: grocery" or some easier way to
> >   record this.
> >   Thank you very much for the help
> >   Shevach
> >   gif  
> 
> I’m assuming a “head check” is what we in the UK would call a post-dated 
> cheque - a cheque which can’t be cashed until a stated date; for what it’s 
> worth, I understand that banks in the UK will often make the payment if the 
> cheque is presented early.
> 
> I would suggest recording the expense on the date of the purchase as a 
> transaction between your checking account and the grocery store. If you wish, 
> you could add a note to indicate that the check can’t be presented until 1st 
> Feb to avoid confusion when reconciling the bank account.
> 
> It’s a similar situation to making a postal payment by check - you know that 
> the payee won’t receive it for several days and may not take it to the bank 
> for several days after that, but you’re recording your commitment to the 
> payee rather than the date on which the bank transfers the money to his 
> account.
> 
> I am not an accountant, but there are those on the list who will no doubt 
> correct me if there are problems with the way I view this!
> 
> Michael
> 
> ___
> 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] question from newbie

2021-11-07 Thread Michael Hendry

On 6 Nov 2021, at 21:40, Shevach Pepper  wrote:
> 
>   Hello there,
>   'I'm having trouble on how to record buying groceries on Jan. 1  with a
>   head check for Feb. 1
>   What I understood from the manual that this is not an expense but a
>   liablity but I don't understand if I should make two accounts one
>   expense: grocery and one "liability: grocery" or some easier way to
>   record this.
>   Thank you very much for the help
>   Shevach
>   gif

I’m assuming a “head check” is what we in the UK would call a post-dated cheque 
- a cheque which can’t be cashed until a stated date; for what it’s worth, I 
understand that banks in the UK will often make the payment if the cheque is 
presented early.

I would suggest recording the expense on the date of the purchase as a 
transaction between your checking account and the grocery store. If you wish, 
you could add a note to indicate that the check can’t be presented until 1st 
Feb to avoid confusion when reconciling the bank account.

It’s a similar situation to making a postal payment by check - you know that 
the payee won’t receive it for several days and may not take it to the bank for 
several days after that, but you’re recording your commitment to the payee 
rather than the date on which the bank transfers the money to his account.

I am not an accountant, but there are those on the list who will no doubt 
correct me if there are problems with the way I view this!

Michael

___
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] Price editor uses old entry

2021-11-07 Thread Rainer Dorsch via gnucash-user

Am Samstag, 6. November 2021, 03:51:55 CET schrieb john:
> > On Nov 5, 2021, at 1:48 PM, Rainer Dorsch  wrote:
> > 
> > Am Freitag, 5. November 2021, 16:39:28 CET schrieben Sie:
> >>> On Nov 5, 2021, at 4:22 AM, Rainer Dorsch via gnucash-user
> >>>  wrote:
> >>> 
> >>> Hi,
> >>> 
> >>> I noticed that if the price editor has an entry in EUR and an entry in
> >>> USD, it used the EUR entry, even if the USD entry has a newer date. My
> >>> account currency is EUR.
> >>> 
> >>> Is that intended and is there an option to change this behavior?
> >>> 
> >>> I usually get the EUR entry, if I buy or sell stock or funds, which are
> >>> accounted in USD.
> >> 
> >> GnuCash always prefers a direct conversion over an indirect one
> >> regardless
> >> of the date. It's not optional. I suppose the problem arises because
> >> you're
> >> trading USD-priced stocks from an EUR-denominated brokerage account and
> >> the
> >> trades create the EUR prices. The simplest work around is to remove those
> >> EUR prices from the pricedb; it won't affect the transaction or reports
> >> using the average-cost price source. To avoid the problem going forward
> >> create an intermediary USD bank account in your brokerage account
> >> hierarchy
> >> and when recording the trade make separate splits for USD<->EUR and
> >> stock<->USD. Chris Lam is working on a stock trading assistant to make
> >> this
> >> a bit less cumbersome; we hope it will be finished in time for GnuCash 5.
> > 
> > Thanks John for your quick reply.
> > 
> > The scenario you describe matches well my use case.
> > 
> > Yes, I manually delete the EUR entries in the pricedb
> > 
> > I am looking forward to the stock trading assistant.
> > 
> > Can you tell why GnuCash always prefers a direct conversion over an
> > indirect one regardless of the date? Is this a bug or a feature :-) ?
> 
> Please remember to copy the list on all replies.

I remembered immediately and resent it also to the list.

The current implementation works well for me, just have to remember that for 
each new transaction (could also be earnings), I need to delete the "new 
price" from the price editor otherwise I lose my quote updates silently. I 
just wanted to find out if I am doing something wrong.

But I have to admit: from a pure user perspective, all the arguments given so 
far, do not convince me at all. I thought it might be useful to share it since 
there might be more users which have by far not the experience with accounting 
tools and insight in the gnucash implementation, which you have.

> I don't think it's either a bug or a feature that GnuCash prefers direct
> conversion, it's just a more efficient way to find a price given the way
> price database is arranged in a sort of tree structure of linked lists.

Frank worte:
> you will end in very complex scenarios of the graph theory:
> multiple pathes with different costs.

When I read this first, I was not sure if the comment was pure irony or if it 
was serious. Since Johns argument is similar, I assume it is serious:

The price editor manages to sort the quotes by date, so there must be already 
code which does that :-)

David wrote:
> When a transaction has an embedded price Gnucash assumes that it is a
> purchase or sale and the price is exact for that trade.   Quotes are
> generally assumed to be estimates, therefore somewhat soft like newspaper
> quotes.

I which usecase would I be more interested in an exact historic price than in 
a current estimate?

As written before, with the current implementation there are workarounds for 
me, just wanted to give my humble user perspective.

Thanks for keeping gnucash up to date and running for so many years!
Rainer

-- 
Rainer Dorsch
http://bokomoko.de/

___
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] Gnucash 3.7 - flatpak cannot recognize second internal HDD & USB Flashdrive

Re: [GNC] Gnucash 3.7 - flatpak cannot recognize second internal HDD & USB Flashdrive

[GNC] Gnucash 3.7 - flatpak cannot recognize second internal HDD & USB Flashdrive

Re: [GNC] My MacOS Finance::Quote Successful Tweaks

Re: [GNC] Black Screen

Re: [GNC] Problem with PayPal statements?

Re: [GNC] Report printing of annual transactions

Re: [GNC] Double entry bookkeeping for purchases to be paid at later date

Re: [GNC] Report printing of annual transactions

[GNC] Report printing of annual transactions

Re: [GNC] gnucash-user Digest, Vol 224, Issue 15

[GNC] Problem with PayPal statements?

Re: [GNC] Double entry bookkeeping for purchases to be paid at later date

Re: [GNC] My MacOS Finance::Quote Successful Tweaks

[GNC] Double entry bookkeeping for purchases to be paid at later date: LIABILITIES Re: gnucash-user Digest, Vol 224, Issue 13

Re: [GNC] question from newbie

Re: [GNC] Updating from v 2.6.16.

Re: [GNC] difficulties with managing accounts with lots of split transactions

Re: [GNC] difficulties with managing accounts with lots of split transactions

Re: [GNC] difficulties with managing accounts with lots of split transactions

Re: [GNC] difficulties with managing accounts with lots of split transactions

Re: [GNC] Black Screen

[GNC] Black Screen

[GNC] difficulties with managing accounts with lots of split transactions

Re: [GNC] question from newbie

Re: [GNC] question from newbie

Re: [GNC] Price editor uses old entry

27 matches

Site Navigation

Mail list logo

Footer information