Re: [GNC] Ubuntu 24.04 update -- problems

[Stephen M. Butler]

1.  Somehow, after the update, I had two PPA entries for mozilla team.  
Kenetic and mantic.  Kept the mantic:
    -rw-r--r-- 1 root root 10127 May 22 14:07 
mozillateam-ubuntu-ppa-kinetic.sources
    -rw-r--r-- 1 root root 9908 May 22 14:07 
mozillateam-ubuntu-ppa-mantic.sources


    That fixed the problem with software updater and also allowed sudo 
apt update work.


2.  Had to install the following packages after the upgrade (before I 
could rebuild GnC):

    libwebkit2gtk-4.0-37
    libwebkit2gtk-4.1
    libsecret-1-0
    libsecret-1-dev
    libboost-all-dev

    Took several attempts to get all the missing packages loaded back 
(and a lot of research to get the right names).


3.  I did a git pull before doing the rebuild so moved from 5.6-87 to 
5.6-150.


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

On 5/22/24 14:32, Stephen M. Butler wrote:

Anybody on Ubuntu may want to wait a bit before upgrading o 24.04 LTS.

I just did the upgrade and GnuCash now fails to start with err:

gnucash: error while loading shared libraries:
libboost_locale.so.1.74.0: cannot open shared object file: No such
file or directory


Did a find command:

sudo find / -name libboost_locale.so.*
/usr/lib/x86_64-linux-gnu/libboost_locale.so.1.83.0


Attempted to rebuild gnucash and having make problems for webkit. The 
software updater is also broken (won't start).  So BEWARE, don't do 
the upgrade yet.


--Steve
--
Stephen M Butler
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Ubuntu 24.04 update -- problems

[Stephen M. Butler]

Anybody on Ubuntu may want to wait a bit before upgrading o 24.04 LTS.

I just did the upgrade and GnuCash now fails to start with err:

   gnucash: error while loading shared libraries:
   libboost_locale.so.1.74.0: cannot open shared object file: No such
   file or directory


Did a find command:

   sudo find / -name libboost_locale.so.*
   /usr/lib/x86_64-linux-gnu/libboost_locale.so.1.83.0


Attempted to rebuild gnucash and having make problems for webkit. The 
software updater is also broken (won't start).  So BEWARE, don't do the 
upgrade yet.


--Steve

--
Stephen M Butler
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Multiple Currencies with Balance Sheet not balanced

[Stephen M. Butler]

Tried that and tried last before date.  Both had same results.  Only PHP 
rates are in the price database and the entry for 7/5/23 is correct.


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

On 4/22/24 22:41, Fred Tydeman wrote:

A guess on my part.

In the Balance sheet:
  Click on Options
     Click on Commodities
        Click on Price Source
          Try Closet to Report Date

You might also check if the conversion rate between PHP and USD was 
recorded:

Tools
   Price Database
      Currencies
        Look in both USD and PHP for the date in question.

On Mon, Apr 22, 2024 at 3:52 PM Stephen M. Butler  wrote:

This has been a thorn in my flesh for some time but I've been too
busy
to deal with it.  The non-profit where I volunteer works in two
currencies:  PHP and USD.  The main currency is set to USD.

Chapter 12 of the Guide implies two ways of tracking multiple
currencies:  Manually (without trading accounts) and Automatically
(with
trading accounts).  I do not have trading accounts activated.

Every time I exchange USD into PHP I enter the exact number of PHP
received for he exact USD value.

Today I tracked down the first instance of the Balance Sheet going
out
of balance.  On July 4, 2023, Assets = Liabilities + Equity.
[$6562.90]
On July 5 there is a single transaction moving $626.80 USD to 34,250
PHP.  But the Balance Sheet for that date shows Assets of $6518.06 vs
Liabilities + Equity of $6516.45

There is only one price entry for 7/5/2023 in the price database. 
I did
click on the transaction to verify the $626.80 to 34,250 PHP was
entered
correctly.

This transaction was between two asset accounts.  One in USD and the
other in PHP.  So why did my Asset value drop?  And why is the
Balance
Sheet out of balance?  I suspect I'll find more of these as I move
forward toward today.

--Steve

-- 
Stephen M Butler

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
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Multiple Currencies with Balance Sheet not balanced

[Stephen M. Butler]

This has been a thorn in my flesh for some time but I've been too busy 
to deal with it.  The non-profit where I volunteer works in two 
currencies:  PHP and USD.  The main currency is set to USD.


Chapter 12 of the Guide implies two ways of tracking multiple 
currencies:  Manually (without trading accounts) and Automatically (with 
trading accounts).  I do not have trading accounts activated.


Every time I exchange USD into PHP I enter the exact number of PHP 
received for he exact USD value.


Today I tracked down the first instance of the Balance Sheet going out 
of balance.  On July 4, 2023, Assets = Liabilities + Equity. [$6562.90]
On July 5 there is a single transaction moving $626.80 USD to 34,250 
PHP.  But the Balance Sheet for that date shows Assets of $6518.06 vs 
Liabilities + Equity of $6516.45


There is only one price entry for 7/5/2023 in the price database.  I did 
click on the transaction to verify the $626.80 to 34,250 PHP was entered 
correctly.


This transaction was between two asset accounts.  One in USD and the 
other in PHP.  So why did my Asset value drop?  And why is the Balance 
Sheet out of balance?  I suspect I'll find more of these as I move 
forward toward today.


--Steve

--
Stephen M Butler
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] ANNOUNCE: gnucash-5.5-1.setup.exe

[Stephen M. Butler]

There are too many Linux variants to provide a pre-compiled version 
outside of the standard package distribution channels.


I just did a pull to get v5.5-87 and am compiling it on my Ubuntu 23.10 
box as I type this response.  I can share my script if you want to try 
building it on your box.


--Steve

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

On 2/21/24 02:50, hc.stoellinger wrote:

How is a Linux version doing? I suppose you don't  plan a pre-compiled 
version?Von meinem/meiner Galaxy gesendet
 Ursprüngliche Nachricht Von: John Ralls  Datum: 
21.02.24  06:46  (GMT+01:00) An: gnucash-annou...@lists.gnucash.org Cc: Gnucash-devel 
, Gnucash Users  Betreff: 
ANNOUNCE: gnucash-5.5-1.setup.exe Having finally beaten WebKitGtk on Windows into submission so 
that it runs JavaScript without crashing, at least in my not very extensive tests, I've built a 
new Windows gnucash-5.5-1.setup.exe and uploaded it to the usual places.The sea-256 is 
720a60dca57e4199f28b5449158ddc89e62012f042a62c43b16c569fa0890275.Regards,John 
Ralls___gnucash-announce mailing 
listgnucash-announce@gnucash.orghttps://lists.gnucash.org/mailman/listinfo/gnucash-announce
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Invoking Vendors report causes closure of GNU Cash V5.5

[Stephen M. Butler]

5.5 has problems in multiple areas as noted previously in this list.  
I'm staying on 5.4 at least until 5.6 is out.


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

On 2/7/24 09:03, Richard Gaede via gnucash-user wrote:

Hi,

I have used V5.4 satisfactorily for some while. I then recently 
installed V5.5 on an Asus notebook operating under Win 11. From the 
first time of use whenever I used the Vendor's Report GNU Cash closed. 
It simply exited with no invitation to save, or other warning. It did 
not close the lock file.


To check this I ran GNU Cash with no other apps running. The behaviour 
was repeated irrespective of the specific vendor, or style sheet used.


I have reverted to V5.4. Has anyone else experienced this.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Automatic account match doesn't work when import transactions

[Stephen M. Butler]

I volunteer for a non-profit that maintains a clinic in the 
Philippines.  The local treasurers send me a spreadsheet that I 
manipulate into a CSV file for importing their transactions into GnuCash.


The sequence of events for a CSV transaction import is different that 
for the OFX that I prefer for my personal CC/Bank company.  One 
advantage I have with the file from overseas is that they include a code 
for each type of expense.  I've told GnC to use that code as the "other" 
account (the base account is their "cash" asset account).  So if any new 
codes show up, GnC has me map them to the actual account (usually 
expense).  During that portion you can look at the other mappings and 
make any needed changes.  Then it shows you all the transactions that 
will be imported.  I have never tried to change the mappings at this stage.


For OFX/QFX, the import will allow you to click on a line (double click) 
and adjust the "other" account.  That is the way it learns how to make 
the mappings.  If you make a wrong entry and don't correct it, then 
future imports will go wrong until you have made enough corrections to 
override the initial mapping.  The new mappings are updated toward the 
end of the import.  If you see a line with a wrong mapping you must fix 
it before finishing the import.  Otherwise, that will strengthen the 
wrong mapping.


You can edit the mappings to remove wrong entries.  I think the only way 
to add entries is by making the corrections line-by-line during the 
import process.


--Steve


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

On 2/5/24 13:06, Jediator wrote:

Mostly CSV files, but other file formats as well.

On 2/3/24 9:26 PM, Steve Butler wrote:

Which import?  CSV?

On Sun, Feb 4, 2024, 13:04 Jediator  wrote:

    I couldn't get the automatic account match to work when importing
    bank/credit card transactions to GC.  Is there anyway to manually
    create
    the matching rules?  Thanks!  -- JC
    ___
    gnucash-user mailing list
    gnucash-user@gnucash.org
    To update your subscription preferences or to unsubscribe:
    https://lists.gnucash.org/mailman/listinfo/gnucash-user
    -
    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
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Intermittent Crash when using recent File dropdown list. Filed as bug # 799215

[Stephen M. Butler]

On 1/10/24 16:59, Adrien Monteleone wrote:
Have you tried opening the (other) desired book directly via command 
line?


It may be the book you are attempting to switch to has an issue, and 
not saving the current one.


It works the second time I try.  So, not the book.  And yes, I've opened 
it multiple times after each crash.  It isn't the same book each time 
either.
Also, since it is prompting you to save, that tells me something was 
edited without a save. Perhaps manually save, then attempt to switch. 
At least that should determine if the crash is happening on save, or 
upon opening the other book.


Oh, I definitely did work.  The fact that when I restart GnC it doesn't 
complain about a lock file on the "old" book tells me that the save 
worked.  The lock file was on the "new" book.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Intermittent Crash when using recent File dropdown list. Filed as bug # 799215

[Stephen M. Butler]

Ubuntu 23.10
GnC Build ID: git 5.4-117-gabb4a01ac8+(2023-12-01)

Intermittent when changing books using the recent file dropdown list.

I pick the book I want next from the File recent dropdown list.
GnC asks if I want to save the existing opened book.  I say yes.
Soon thereafter the program goes away.  No stacktrace that I can find.

Start GnC again and it opens the book I was in.  Again I pick from the 
recent file dropdown.  I don't think it asks if I want to save. But I do 
get the Lock File dialogue.  I tell it to open anyway.  It opens.


This happens infrequent and I can't predict when it will happen.

Apparently happens after the lock file is created for the new book but 
before it is read into memory.


What steps do I need to take to get additional information the next time 
this (apparently random) happens?


--
Stephen M Butler
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Starting a new year

[Stephen M. Butler]

GnC will handle multiple years worth of accounting information so no 
need to "start" a new year.  Just keep using the same data file(s) and 
enter the appropriate dates.   That's the easiest way.  If you really 
want separate files (books), then you will have to export the accounts 
(last time I tried that I think it exported as a file the GnC could 
open).  However, you will have to enter a transaction to setup the 
beginning account balances.  More work than I want to do.


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

On 1/9/24 11:14, Grace wrote:

Hello,

I am just wondering how folks are dealing with starting a new year?

Finishing 2023 I think is easy. You just stop using it.

However, how do I start 2024 with the finishing balances of 2023? Do I 
have set up a brand new set of accounts, or is there a way of doing 
this that I have not found?


Grace

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
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 I print an account?

[Stephen M. Butler]

Check out the Transaction Report.  You will have to configure it to get 
any useful information.  One or more accounts, date range, etc.


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

On 12/18/23 15:58, Simon Roberts wrote:

Hi all, I'd like to be able to print a range of transactions in a single
account. Essentially just a dump of what I see on the screen, though I
suppose I would need to select a range of rows and the columns that should
be in the output.

Can this be done? Is it one of the business reports? My accounting
background is essentially nothing, so it's entirely possible I don't know
what one of them might do, though I believe I've tried all the options.

Thanks for any input!
Cheers,
Simon



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report Options menu bug report

[Stephen M. Butler]

Was there in 5.4-62 but fixed by 5.4-117.  I did a git pull and then a 
local build.


Guess I should have tried that first.

On 12/1/23 13:31, Glenn Fowler wrote:

Hi,

This has been fixed since the 5.4 release if you want to try a daily 
build: https://code.gnucash.org/builds/flatpak/stable/


On Fri, Dec 1, 2023 at 3:27 PM Stephen M. Butler  wrote:

799149 <https://bugs.gnucash.org/show_bug.cgi?id=799149> filed. 
After
initial set of options for Transaction Report, then the Options,
Print
and Make PDF menu options are greyed out on the menu bar.

Screenshot attached to bug report.

Ubuntu 23.10 and GnuCash Version: 5.4  Build ID: git
5.4-62-g2ca6cb2a34+(2023-11-03)
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report Options menu bug report

[Stephen M. Butler]

I will update the bug report as I did a git pull for 5.4-117, did the 
build and all works as expected.

I'm going to presume fixed between patch 62 and 117.

On 12/1/23 13:34, Adrien Monteleone wrote:

Might be something in a dependency in 23.10.

I can report it also works fine on MacOS.

Regards,
Adrien

On 12/1/23 2:52 PM, Murugan Muruganandam wrote:

i am able to print and make pdf


Gnucash 5.4 Build Flathub 5.4.1 Ubuntu 22.04.3


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transaction Report Options menu bug report

[Stephen M. Butler]

799149  filed.  After 
initial set of options for Transaction Report, then the Options, Print 
and Make PDF menu options are greyed out on the menu bar.


Screenshot attached to bug report.

Ubuntu 23.10 and GnuCash Version: 5.4  Build ID: git 
5.4-62-g2ca6cb2a34+(2023-11-03)
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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 I find transactions into an account that has only one split?

[Stephen M. Butler]

My client provides a whole range of options:  Reply; Reply List; Reply 
All.  No default.


It must be up to the email software the recipient is using.  If they 
want a new default then they need to get a new client with the the 
default they want.



On 11/24/23 11:16, R Losey wrote:

I was not aware that the admins could do anything; I thought it was the web
page or the email client being used.


On Fri, Nov 24, 2023 at 9:28 AM David Kirkby 
wrote:


Apologies for not sending to the list. Have the admins considered making
that the default behaviour, which is the case with other mailing lists I am
on.
On Wed, 22 Nov 2023 at 18:25, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


Also, please remember to copy the list on all replies.

Regards,
Adrien


On 11/22/23 3:53 AM, David Kirkby wrote:

Unfortunately that's a bit difficult, as a lot of times I buy things
with PayPal, so there's an entry in the PayPal account where no fees
need to be paid, as the seller pays the fees, not the buyer. So not
every transaction in the PayPal account needs 3 splits - most need 2.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Dealing with escrow account

[Stephen M. Butler]

I treat it like another asset account.  The monthly escrow amount goes 
in and when the escrow pays out it comes out as an expense.


So your monthly payment out of your checking account ends up in three 
places:

1.  Interest Expense.
2.  Liability reduction (the mortgage).
3.  Escrow asset account.

Then when you get the statements you can reconcile/verify the Interest 
Expense (YTD), the Mortgage balance, and the escrow balance with any 
related transactions.


On 10/31/23 21:03, Edwin Booth wrote:

Hi. How do y’all deal with a mortgage escrow account? Specifically, each
month I pay into the escrow account along with my monthly PMI payment. It
is all an expense. But when the mortgage company pays out money from that
escrow account (for taxe and insurance payments) how do you account for
them in GnuCash? Or do you just wait until tax time and record it on your
return w/o even putting into GC?

Thanks, Edwin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Having issues with gsettings, dconf, gsettings-dconf-backend and GnuCash

[Stephen M. Butler]

I am on Ubuntu 23.04.  My settings allow for the most recent version and 
I have not seen 23.10 as an optional update to apply.


But, on 23.04 I have had not problems building the most recent versions 
of GnuCash from the GIT repository.  A number of releases back a script 
was made available that showed all the dependencies for Ubuntu.  I just 
grepped it and these are the sudo apt statements:


sudo apt install build-essential
sudo apt install cmake
sudo apt install ninja-build
sudo apt install libglib2.0 libglib2.0-dev
sudo apt install libxml2 libxml++2.6-dev libxml2-utils
sudo apt install libxslt1.1 libxslt1-dev
sudo apt install libwebkit2gtk-4.0-37 libwebkit2gtk-4.0-dev
sudo apt install gtk+3.0 libgtk-3-dev
sudo apt install zlib1g zlib1g-dev
sudo apt install guile-2.0 guile-2.0-dev
sudo apt install swig
sudo apt-get install libboost-all-dev
sudo apt-get install libsecret-1-0 libsecret-1-0-dev
sudo apt-get install aqbanking-tools libaqbanking-dev
sudo apt-get install gwenhywfar-tools libgwenhywfar60 libgwenhywfar60-dev
sudo apt-get install ktoblzcheck libktoblzcheck1-dev
sudo apt-get install libofx-dev
sudo apt-get install xsltproc
sudo apt-get install libdbi1 libdbi-dev libdbd-pgsql libdbd-mysql 
libdbd-sqlite3

sudo apt-get install python3-pytest
sudo apt install googletest

Now, some of those might have been updated  with the various Ubuntu 
updates over the years.


--Steve

On 10/22/23 09:28, Adrien Monteleone wrote:
Considering the timing of the GnuCash release and the Ubuntu 23.10 
release, your build issues are likely due to dependency hell. I've had 
a few frustrating build sessions where GnuCash needed an ever so 
slightly older version of a library that wasn't in the new repos. (and 
this cascaded to some of their dependencies as well) Your build errors 
should be informative enough to figure out if that is the case here. 
(note, when I had that problem it was also on a non-LTS .10 release) 
Sometimes, this is resolvable with a bit of effort. Sometimes, it 
isn't worth the effort.


I see you switched from Pop_OS! 22.04 to Ubuntu 23.10. Any reason not 
to stick with Ubuntu 22.04? Maybe try that in a VM and see if you get 
the same build issues. (you could just keep that VM for GnuCash until 
you resolve the build problems in the host)


There is always flatpak. Of course, be aware of a few workarounds for 
printing and file locations for settings. These should all be 
documented on the GnuCash wiki.


Otherwise, some VM testing would be my approach, though considering 
how you've described your OS transition and upgrades, as well as other 
OS issues, I'd consider the nuclear option if I wasn't too far 
invested in the current installation. A clean install has saved me 
weeks of continued frustration more than once.


Regards,
Adrien

On 10/21/23 10:43 AM, Bryan B. wrote:

That is a good idea.

To give some context, without explaining everything: One week ago, I was
running the Ubuntu-based Pop_OS! 22.04. On that system, I had GnuCash 
built

using the "Building on Ubuntu" gnucash-wiki 22.04 script. I did not have
that issue at that time, nor the other GnuCash issue that I encountered
here:
https://lists.gnucash.org/pipermail/gnucash-devel/2023-October/046795.html 



I was having other issues with Pop_OS! (network issues that were 
needed on

my previous job), and at the recommendation of my previous employer I
decided to switch to mainstream Ubuntu.

When I switched to Ubuntu 23.10, this issue appeared, along with the 
issue

with gsettings.

Another issue that is worth mentioning, in case this happens to anyone
else, is that I got unlucky with the .iso file I used to install 
mainstream
Ubuntu. I somehow Googled my way into creating an .iso based off of 
22.10,

which is a version of Ubuntu that is no longer supported. I installed on
22.10, then discovered my error. At that point, I upgraded to 23.10.

I also should mention another thing I just remembered. Whenever I open
dconf, even if I don't click anything, Terminator, a terminal app I 
use for
coding, stops working correctly: when I type text and approach the 
side of
the app window, three characters proceed off the edge of the screen 
before
the app's autowrapping feature kicks in and the following characters 
appear

on the next line down.

Also worth mentioning is that the issue with being unable to switch
gsettings background image on the desktop existed before installing the
dconf gui app.

Based on the feedback I am getting, it does seem that something deep 
within
ubuntu is likely broken and a complete reinstall from scratch is the 
only

reasonable way to fix this.

I do like the idea of rebuilding using a virtualbox 23.10 iso and 
getting

the system working first, before redoing everything. Thank you!


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-

Re: [GNC] I need basic help

[Stephen M. Butler]

Edwin,

I routinely download my CC transactions using OFX.  I think you missed a 
very important step.


It sounds like you did tie this OFX file to your CC Liability Account.  
That will be remembered for all future imports from this CC.


It also sounds like you may not have set up all the various expense 
accounts (Groceries, Fuel, Hardware, etc).  Those need to be setup as 
accounts under the Expense top-level account.


Then, during the import process, after you pick the file but before 
doing the actual import step you will see a list of all the 
transactions.  During this first import none of them will show the 
corresponding expense account.  You will need to click on each line and 
indicate to which account that expense should be assigned.  In some 
cases you will have a payment so up.  For the first time you will need 
to assign this to your Asset/Checking account.


This process of assigning accounts to each transaction will teach the 
import process how to automatically assign them in the future. As the 
importer learns each transaction (based on the description), it will 
begin to automatically assign the proper accounts. Occasionally you may 
need to correct the account assignment or it may see a new description 
and not know leaving it assigned to the Invalid Account.  This is your 
clue to click on that line (perhaps double click) and make the 
appropriate assignment.


Hopefully this helps you on future imports.

--Steve

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

On 10/18/23 11:09, Edwin Booth wrote:

Hi. New to this. I just downloaded an OFX file for a credit card I have. I
imported it into my “Unsaved Book.” That worked. It is now on the Accounts
Page with an amount under the “Total” column. But there is also a line that
says “Imbalance-USD” with the same same amount under Total. I understand (I
think) that that Imbalance is due to the fact that I have no other account
in there and so there is nothing to balance my CC account with.

So, I obviously need to enter some new accounts. I haven’t paid off all of
that CC account, but I have paid some of it. The unpaid portion would be
under “Liability” I assume, and the paid part under “Expense.”

Not sure what to do next. I’m running GnuCash on a MacBook Pro, which I’m
also pretty new at.

Thanks,

Edwin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Bad date not caught

[Stephen M. Butler]

The parser should know the local date format for the user.  That would 
resolve the M/D/Y, D/M/Y, and Y/M/D format issue.


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

On 10/12/23 16:27, john wrote:

Rather than banging on about the validity or lack thereof of 31 December 1999, 
which isn't really Fred's complaint, it would be more useful to explain that 
the date parser fires on every keystroke when typing a date in the Date Edit 
text box. That makes it unhelpful to raise a dialog every time the entered date 
isn't valid because that will be true on most of the keypresses when entering a 
date. Not to say that it's not feasible to do so, just that that's how it works 
now. There's already an event handler for when the GncDateEdit loses focus, 
that just needs to be wired up to know that the entered date wasn't used so it 
can put up a message box warning the user.

As I was looking through the code I saw that the intent was to use *today's* 
date,  not time 0, when the date didn't parse correctly. That at least will 
keep the duplicated transaction in view and was an easy fix, so I fixed it.

Another more involved fix would be to make the date parser a bit more liberal 
about delimiters and formats; the only slightly minor difficulty is ordering 
ambiguous sequences: for example 21-10-23 could be 21 October 2023 or 23 
October 2021 and 5/7/9 could be the 9 July 2005, 7 May 2009, or 5 July 2009.

Regards,
John Ralls


On Oct 12, 2023, at 09:51, Michael or Penny Novack  
wrote:

On 10/12/2023 10:40 AM, Fred Tydeman wrote:

In an account, I clicked on Duplicate of a transaction.
I got a small popup with the date field highlighted.
I typed in 5.19.21  (instead of the correct 5/19/21) and pressed enter.
That got me the transaction duplicated, but with the
date of 12/31/1969.
Seems like the code should warn me about bad date.

LOL --- it did, sort of.

The problem is that you didn't know the special meaning of 12/31/1969Now if 
the program had returned 00/00/ you would have understood that you had a 
bad date. In other words, ZERO

By a convention adopted long ago, computers measure time in microseconds since "time 
zero" which was chosen to be midnight, 12/31/69 (before Y2K we tended to write years two digit 
if we meant in the 1900's). That makes the "zero date" a VALID date (00/00/ would not 
be valid in a field expecting a date)

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
-
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
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] 5.4 build on linux

[Stephen M. Butler]

Mike,

I'm running Ubuntu 23.04.  In my GnuCash folder I have a sub-folder 
called gnucash that is a git clone.  From that folder I do a git pull 
and git describe so I know what the latest is.


Then I run a script in the GnuCash folder called build-gnucash that is 
listed below.  That generates a folder called Build-gnucash_5.4-8 (so 
the 8th patch since 5.4).  It built clean.  So now I go into the old 
Build-gnucash-5.3-12 folder and do a sudo make uninstall.  Move to the 
Build-gnucash_5.4-8 folder and do a sudo make install. Upgrade completed.


After a few days in 5.4-8 I'll remove the 5.3-12 folder.  But it is 
there in case I need to fall back


Here is the script that sits in the GnuCash folder.

#!/bin/bash
#
#  build-gnucash
#
# NOte:  do a git pull followed by git checkout of version desired 
before starting script


cd $HOME/Projects/GnuCash/gnucash

GITVER=$(git describe)
MYVER=${GITVER%-*}
MYRPR=Build-gnucash_${MYVER}
echo $MYVER

cd ..

rm -rf $MYRPR  > /dev/null

mkdir $MYRPR

cd $MYRPR

cmake -DCMAKE_INSTALL_PREFIX=/usr/local  ../gnucash

make

echo  ##  sudo make install

--Steve

On 9/25/23 15:10, Mike Commissaris wrote:

Downloaded the file from both Sourceforge and Git and when I tried to build
I failed with:
make: *** No targets specified and no makefile found.  Stop.
Thinking the build instructions may have changed I tried to look at the
Wiki and it appears the
Wiki is down.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction inconsistency when deleting account

[Stephen M. Butler]

Yup.  If you messed up an import then you definitely want to delete 
those transactions in all accounts.  If you left those entries hanging 
out there then a new import will also really mess up everything even 
more royally than what Gyle is suggesting.


On 9/5/23 14:00, Gyle McCollam wrote:

John,
for the 1st time, I have to disagree with you.  If you delete the transactions 
when you delete an account it is not only an accounting issue, but will 
seriously mess up your other accounts.  Say there are debits (deposits) and 
credits (withdrawals) from your checking account.  If the account your deleting 
has been around for years, good luck trying to get your bank account to balance 
after those entries are gone.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: john 
Sent: Tuesday, September 5, 2023 11:44 AM
To: Gyle McCollam 
Cc: Maf. King ; Mark ; 
gnucash-user@gnucash.org 
Subject: Re: [GNC] Transaction inconsistency when deleting account

Yeah, it's a bug. It's supposed to delete the transactions, not just the splits 
in that account only to recreate them in an imbalance account. Otherwise it's 
the same as the move to account option.

The fact that it's poor accounting practice is beside the point. If the user 
wants to follow good accounting practice they can choose to move the splits to 
another account.

Regards,
John Ralls


On Sep 5, 2023, at 08:18, Gyle McCollam  wrote:

No Mark, it is not a bug.  If you made credit card purchases and subsequent 
payments to that card, those transactions have already been made and if you 
were to delete an account and the transaction within, it would be the same as 
if the transactions had never happened and they did.  Gnucash, offering to move 
them to another account is the only way not to screw up all the account 
affected by the account you are deleting.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on behalf of 
Mark via gnucash-user 
Sent: Tuesday, September 5, 2023 11:04 AM
To: Maf. King 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Transaction inconsistency when deleting account


Sep 5, 2023 08:33:44 Maf. King :


I just tried deleting an account.   As expected, I was presented with the
choice to "move transactions to..." or "Delete all transactions" (see
screenshot - this is GC 4.x, maybe the wording is different in v5)

Deleting the transactions does not really seem to delete anything, the
transaction splits effectively moved to Imbalance-GBP.

One could argue that "splits" in the deleted account have been deleted, and
GC has auto-created new splits to the Imbalance account - I don't know what
the internal process is- but it "feels" to the end user like a move, not a
delete.

Given a "transaction" is a collection of "at least 2 splits",  then I think I
agree with the OP, (whatever the validity of the reason for wanting to delete
an account), being told that "transactions" will be deleted and them still
existing seems a bug (maybe only in wording in the dialog box)

Ah, it's been a while since I deleted an account, and I don't remember the 
option to delete all transactions being there (maybe I just forgot). I agree 
that is confusing at least, and maybe a bug.

I don't think I would ever use that option, though. That seems like a confusing 
side effect to have transactions deleted by deleting an account. Maybe I'm just 
used to the way GnuCash has done things.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
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
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV Import

[Stephen M. Butler]

I presume that you will not have 100s of expense accounts.  You would 
have to do the mapping once per code word.  Just once.


On 8/24/23 16:21, jackielou wong wrote:
You mean ill do it manual for 100s transaction. Is that correct? How 
can i transfer in fastest way


On Fri, Aug 25, 2023, 7:01 AM Stephen M. Butler  wrote:

I have used the CSV importer several times to great advantage.  At a
minimum you need the following columns:

1.  Date -- be sure that you set the importer to the date format you
used.  I use MM/DD/.
2.  Description -- What you want in the transaction description.
3.  Account Code -- Something that will uniquely identify the "other
account".  I tend to use 3-4 character (sometime just 2) codes
easy for
me to remember.  These will get mapped (by you) to the real GnC
account
during the import process.
4.  Amount -- I sometimes have to specify that this is a negative
amount
(even though the file has positive values).

During the import you will have to specify the base account. This
will
be the checking account.  This is a field on the import screen --
not in
your file.
At some point you will map the above fields to tell the imported
which
one is the date, which one is the Other Account, which one is the
description and which one is the amount (or negative amount).

Test this out in a test environment first.

Save all your mapping to a file name so you can pull it back up
for real
(or for future use).  It is there on the setup screen.

At some point you will have the setup all done and will go NEXT.  At
this point it will list all the codes you used and ask you to map
those
to the real accounts (I presume expenses).

Good luck.

On 8/24/23 15:00, Stan Brown (using GC 4.14) wrote:
> On 2023-08-24 14:15, jackielou wong wrote:
>> I have 500 transactions under checking account for importing
files... how
>> can i put this all in linked accounts...
>>
>> Everytime i do that they fall to imbalance usd.. can you help
to fix it. So
> Jackielou,
>
> This suggestion may seem inefficient, but I think you might get
the job
> done faster by just entering the 500 transactions manually, which I
> imagine you know how to do.
>
> I've never done an import myself, but as I understand it you have to
> teach GnuCash to recognize transactions the way you want. That takes
> time, which you could be using to enter transactions right into
GC, a
> process I assume you are comfortable with. And 500 is really not
many.
>
> That's what I did in early 2018 when I converted my 2011-2017
data to
> GC. It was over 15,000 transactions, but once I got going it
went very
> quickly. Sure, I had to deal with each transaction individually,
but I
> would have had to check each one anyway if I had tried an
import. And
> along the way, I noticed inconsistencies in how I had treated
similar
> events, and fixed them. For me, at least, the process was less
painful
> than spending a lot of time learning and tinkering with a batch
import
> process that I would probably never need to use again.
>
> If you still want to pursue importing, I think it would be
helpful if
> you could be a lot more specific about what process you are
following,
> what results you see in GC, and what error message you get (if any).
> Maybe import _one_ transaction, and provide that information?
>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com/ <https://BrownMath.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
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV Import

[Stephen M. Butler]

I have used the CSV importer several times to great advantage.  At a 
minimum you need the following columns:


1.  Date -- be sure that you set the importer to the date format you 
used.  I use MM/DD/.

2.  Description -- What you want in the transaction description.
3.  Account Code -- Something that will uniquely identify the "other 
account".  I tend to use 3-4 character (sometime just 2) codes easy for 
me to remember.  These will get mapped (by you) to the real GnC account 
during the import process.
4.  Amount -- I sometimes have to specify that this is a negative amount 
(even though the file has positive values).


During the import you will have to specify the base account.  This will 
be the checking account.  This is a field on the import screen -- not in 
your file.
At some point you will map the above fields to tell the imported which 
one is the date, which one is the Other Account, which one is the 
description and which one is the amount (or negative amount).


Test this out in a test environment first.

Save all your mapping to a file name so you can pull it back up for real 
(or for future use).  It is there on the setup screen.


At some point you will have the setup all done and will go NEXT.  At 
this point it will list all the codes you used and ask you to map those 
to the real accounts (I presume expenses).


Good luck.

On 8/24/23 15:00, Stan Brown (using GC 4.14) wrote:

On 2023-08-24 14:15, jackielou wong wrote:

I have 500 transactions under checking account for importing files... how
can i put this all in linked accounts...

Everytime i do that they fall to imbalance usd.. can you help to fix it. So

Jackielou,

This suggestion may seem inefficient, but I think you might get the job
done faster by just entering the 500 transactions manually, which I
imagine you know how to do.

I've never done an import myself, but as I understand it you have to
teach GnuCash to recognize transactions the way you want. That takes
time, which you could be using to enter transactions right into GC, a
process I assume you are comfortable with. And 500 is really not many.

That's what I did in early 2018 when I converted my 2011-2017 data to
GC. It was over 15,000 transactions, but once I got going it went very
quickly. Sure, I had to deal with each transaction individually, but I
would have had to check each one anyway if I had tried an import. And
along the way, I noticed inconsistencies in how I had treated similar
events, and fixed them. For me, at least, the process was less painful
than spending a lot of time learning and tinkering with a batch import
process that I would probably never need to use again.

If you still want to pursue importing, I think it would be helpful if
you could be a lot more specific about what process you are following,
what results you see in GC, and what error message you get (if any).
Maybe import _one_ transaction, and provide that information?

Stan Brown
Tehachapi, CA, USA
https://BrownMath.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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Sort Transactions in Alphabetical Order, For Entering Expense Category (Account)

[Stephen M. Butler]

See if your bank or CC company offers download in OFX format.  In a 
couple of cases I've been forced to use CSV format.  In both cases use 
small batches at first to train the matcher so it learns what 
transactions go to which accounts.


Note that with the CSV you will need to save the format layout for 
future use so you don't have to setup the layout each time.


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

On 8/13/23 07:13, Tom Balazs wrote:

I'm importing a large number of transactions into GnuCash. I want to speed
up entering the expense category (account) of transactions, especially for
credit card transactions. (I know these are called accounts in GnuCash, but
I mean "account" like "auto expenses", and "home repair expenses", not
"account" like "Credit Card #1", and "Checking Account #1".)

There are two ways I could do that:
 1. Create a column for account in the CSV file (exported from the
bank's site), sort by payee name and enter account (expense category).
Important, I need this to conform to the expense categories I created in
GnuCash; I don't want GnuCash to automatically create new expense
categories with the expense. That could lead to small typos creating new
categories; e.g. "auto repair" and "auto rpeair".
 2. Or I want to import all the transactions, and then in GnuCash sort
by payee name, and then add expense category to 10-15 transactions at a
time.

How can I do that?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Scheduled Transaction - Loan Amortization

[Stephen M. Butler]

Not sure how GnC does it.  I do nothing.

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

On 7/26/23 12:12, Gyle McCollam wrote:

Stephen,
How does Gnucash update the "i" value each month or do you have to do 
that manually?



Thank You,

*Gyle McCollam*

Gyle McCollam

gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email


*From:* gnucash-user 
 on behalf of 
Stephen M. Butler 

*Sent:* Wednesday, July 26, 2023 2:20 PM
*To:* gnucash-user@gnucash.org 
*Subject:* Re: [GNC] Scheduled Transaction - Loan Amortization
Here are the entries (3 splits) I use on my scheduled transaction:

Split 1:    Assets:Checking:xxx    Credit -- $326.97 (payment
comes from checking account)
Split 2:    Liabilities:Loans:yyy Debit -- 326.97 - ipmt( .04490
/ 12.00 : i -2: 240.00 : 51,630.34 : 0 : 0 )
Split 3:   Expense:Interest Paid  Debit -- ipmt( .04490 / 12.00 : i
-2: 240.00 : 51,630.34 : 0 : 0 )

             Notes:  .04490/12 is the monthly interest
                     i-2 is the month number (found that
adjusting by 2 months gave me numbers that matched the bank much better
-- try with just i)
                         240 is the total number of months for loan
(20 yrs -- RV)
                         51,630.34 is the original loan amount


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

On 7/26/23 07:09, Derek Atkins wrote:
> There are pmt, ppmt, and ipmt functions.
> -derek
> Sent using my mobile device. Please excuse any typos.
> On July 25, 2023 15:41:01 Gyle McCollam  wrote:
>
>> Is there a formula I can enter in SX that will automatically
>> calculate the principal or interest payment on a car loan?  Then is
>> there a way to deduct that from the total payment to get the other
>> value, other than TOTAL PAYMENT-the formula used above?
>>
>>
>> Thank You,
>>
>> Gyle McCollam
>>
>> Gyle McCollam
>>
>> gmccol...@live.com<mailto:gmccol...@gyleshomes.com 
<mailto:gmccol...@gyleshomes.com>> email

>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
> -
> 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
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Scheduled Transaction - Loan Amortization

[Stephen M. Butler]

GnC appears to keep track of the number of months and updates it without 
any intervention on my end.


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

On 7/26/23 12:11, Gyle McCollam wrote:
How does Gnucash update the "i" value each month or do you have to 
adjust manually?


Thank You,

*Gyle McCollam*

Gyle McCollam

gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email


*From:* gnucash-user 
 on behalf of 
Stephen M. Butler 

*Sent:* Wednesday, July 26, 2023 2:20 PM
*To:* gnucash-user@gnucash.org 
*Subject:* Re: [GNC] Scheduled Transaction - Loan Amortization
Here are the entries (3 splits) I use on my scheduled transaction:

Split 1:    Assets:Checking:xxx    Credit -- $326.97 (payment
comes from checking account)
Split 2:    Liabilities:Loans:yyy Debit -- 326.97 - ipmt( .04490
/ 12.00 : i -2: 240.00 : 51,630.34 : 0 : 0 )
Split 3:   Expense:Interest Paid  Debit -- ipmt( .04490 / 12.00 : i
-2: 240.00 : 51,630.34 : 0 : 0 )

             Notes:  .04490/12 is the monthly interest
                     i-2 is the month number (found that
adjusting by 2 months gave me numbers that matched the bank much better
-- try with just i)
                         240 is the total number of months for loan
(20 yrs -- RV)
                         51,630.34 is the original loan amount


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

On 7/26/23 07:09, Derek Atkins wrote:
> There are pmt, ppmt, and ipmt functions.
> -derek
> Sent using my mobile device. Please excuse any typos.
> On July 25, 2023 15:41:01 Gyle McCollam  wrote:
>
>> Is there a formula I can enter in SX that will automatically
>> calculate the principal or interest payment on a car loan?  Then is
>> there a way to deduct that from the total payment to get the other
>> value, other than TOTAL PAYMENT-the formula used above?
>>
>>
>> Thank You,
>>
>> Gyle McCollam
>>
>> Gyle McCollam
>>
>> gmccol...@live.com<mailto:gmccol...@gyleshomes.com 
<mailto:gmccol...@gyleshomes.com>> email

>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
> -
> 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
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Scheduled Transaction - Loan Amortization

[Stephen M. Butler]

Here are the entries (3 splits) I use on my scheduled transaction:

Split 1:    Assets:Checking:xxx    Credit -- $326.97   (payment 
comes from checking account)
Split 2:    Liabilities:Loans:yyy Debit -- 326.97 - ipmt( .04490 
/ 12.00 : i -2: 240.00 : 51,630.34 : 0 : 0 )
Split 3:   Expense:Interest Paid  Debit -- ipmt( .04490 / 12.00 : i 
-2: 240.00 : 51,630.34 : 0 : 0 )


                Notes:  .04490/12 is the monthly interest
                        i-2 is the month number (found that 
adjusting by 2 months gave me numbers that matched the bank much better 
-- try with just i)
                            240 is the total number of months for loan 
(20 yrs -- RV)

                            51,630.34 is the original loan amount


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

On 7/26/23 07:09, Derek Atkins wrote:

There are pmt, ppmt, and ipmt functions.
-derek
Sent using my mobile device. Please excuse any typos.
On July 25, 2023 15:41:01 Gyle McCollam  wrote:

Is there a formula I can enter in SX that will automatically 
calculate the principal or interest payment on a car loan?  Then is 
there a way to deduct that from the total payment to get the other 
value, other than TOTAL PAYMENT-the formula used  above?



Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Two Instances as opposed to two separate files

[Stephen M. Butler]

I saw this in an email exchange a few years back that can be summarized as:

A3: Then you get email chains like this.

Q3: But I prefer to top post to see what was entered last!


A2: So the response makes sense after reading the relevant question.

Q2: Why bottom post?


A1: Please use bottom posting.

Q1: Do we top or bottom post?



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

On 7/14/23 17:56, R Losey wrote:

Is there really a convention for replies? Gmail puts my replies at the top
by default (like this), but if they are supposed to be at the bottom, I can
pretty easily do that as well. But I haven't seen a FAQ or heard that this
is a convention.


On Fri, Jul 14, 2023 at 6:50 AM Paul Feakins  wrote:


With a mailing list such as this, I believe the convention is to put
replies at the bottom?


--

_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Window/Mac Summary Box difference

[Stephen M. Butler]

So I deleted those two transactions and Profits stayed at zero. Ended up 
quitting with saving.  On startup again the Profit was back and correct.


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

On 7/13/23 15:19, Stephen M. Butler wrote:

Based on some experimentation, I suspect:

1.  Grand Total should always be zero (blank).  If ever non-zero it 
means you have an out-of-balance transaction (maybe more than one) 
somewhere.


2.  Net Assets appears to be Assets - Liabilities + Income - 
Expenses.  So, Total Equity including retained earnings/losses.


3.  Profits appear to be Income - Expenses for the current year.

Yes, I do Close the Books each year.  So, I deleted the 2022 entries 
to see if that affected Profits.  It did not.  But it sure changed the 
retained earning on the Balance sheet!


This does not explain why the figures are different on other boxes. I 
have a hard time thinking that the system date on those boxes isn't 
2023!!


That last statement caused me to try setting the Accounting Period 
Preference to an absolute date of 1/1/2019 - 12/31/2019.  My Profit 
went to zero.  The Net Assets is not the same as the Balance Sheet 
shows for 2019.  It was low by $3,544.00.


I changed the Accounting Period Preference to an absolute date of 
1/1/2023 - 12/31/2023 and saw the same (correct) figures as when set 
for a relative period for start/end of current year.


Finally, I closed the books for 2023 (no worries, only 2 transactions 
to delete to reverse that) and saw Profits going to zero.  It left Net 
Assets alone.


--Steve


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

On 7/13/23 13:43, David H wrote:

My Grand Total always just shows as "$, Grand Total:" - hasn't had an
amount in it forever so I just ignore these figures anyway as they're 
quite
meaningless to me :-)  There's a dropdown arrow on the right hand 
side that

you can use to expand the items on that line - shows entries for each
currency etc.  Click on the summary line once, sometimes twice 
(flaky), and
it will also expand the summary row in situ.  On mac os you can also 
double

click the summary line and it opens part way up the screen - it's a bit
flaky the way it does it tho - click somewhere else to close it again.

Cheers David H.

On Fri, 14 Jul 2023 at 01:10, David Carlson 


wrote:


Neil,

If you scroll down in the summary box you will see additional rows
identified by the currencies and securities in that file, if any exist.
Perhaps that would lead to an account and one or more transactions that
contain an incomplete closing transaction where some asset or 
liability was
exchanged without accounting for the loss or gain.  I too have no 
idea how

those numbers are calculated, so I cannot be more specific.

On Thu, Jul 13, 2023 at 9:35 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


I'm not sure exactly how those numbers are calculated and I've never
relied on them.

Perhaps a Balance Sheet would work better. You'd only need to know the
headline numbers:

Total Assets
Total Liabilities
Total Equity

(perhaps, Retained Earnings/Losses, if you like, though that is 
part of

the Equity section)

Regards,
Adrien

On 7/13/23 6:33 AM, Neil Campbell wrote:

I help a friend with their monthly accounting. She has GNUCash

installed
on a PC. I have GNUCash installed on a Mac mini M1 computer. She 
does the

input. I do the month end transactions and check her input. So we send
GNUCash data files backwards and forwards. The way I identify the 
file I
have sent her is to give her the Summary Box values. She must agree 
this

before starting her new month’s input.

This worked well until, for no apparent reason, these figures don’t

match any more.

My Mac mini M1 shows:
Net Assets £9,115.89    Profits £3,075.18
Using the same file that I emailed her, her PC Shows:
Net Assets £9,115.89    Profits £0.00

So I realised that there must be a Preference not set by her.

I downloaded and installed GNUCash on my wife’s PC to see how I could
correct the error. I changed the Setting Accounting period dates to 
the

correct ones. So, on my wife’s PC I have:

Net Assets £9,115.89    Profits £8,803.24
It’s still not right and the Profit figure is now in red.

I now have 3 different Profit Figures, but I cannot find any place on
the Windows version to check why there are these differences, 
because I
don’t know where this Profit figure comes from. The correct figures 
are

the

ones on my Mac mini M1 above.

I must be missing something. Any help would be greatly appreciated.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to un

Re: [GNC] Window/Mac Summary Box difference

[Stephen M. Butler]

Based on some experimentation, I suspect:

1.  Grand Total should always be zero (blank).  If ever non-zero it 
means you have an out-of-balance transaction (maybe more than one) 
somewhere.


2.  Net Assets appears to be Assets - Liabilities + Income - Expenses.  
So, Total Equity including retained earnings/losses.


3.  Profits appear to be Income - Expenses for the current year.

Yes, I do Close the Books each year.  So, I deleted the 2022 entries to 
see if that affected Profits.  It did not.  But it sure changed the 
retained earning on the Balance sheet!


This does not explain why the figures are different on other boxes. I 
have a hard time thinking that the system date on those boxes isn't 2023!!


That last statement caused me to try setting the Accounting Period 
Preference to an absolute date of 1/1/2019 - 12/31/2019.  My Profit went 
to zero.  The Net Assets is not the same as the Balance Sheet shows for 
2019.  It was low by $3,544.00.


I changed the Accounting Period Preference to an absolute date of 
1/1/2023 - 12/31/2023 and saw the same (correct) figures as when set for 
a relative period for start/end of current year.


Finally, I closed the books for 2023 (no worries, only 2 transactions to 
delete to reverse that) and saw Profits going to zero.  It left Net 
Assets alone.


--Steve


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

On 7/13/23 13:43, David H wrote:

My Grand Total always just shows as "$, Grand Total:" - hasn't had an
amount in it forever so I just ignore these figures anyway as they're quite
meaningless to me :-)  There's a dropdown arrow on the right hand side that
you can use to expand the items on that line - shows entries for each
currency etc.  Click on the summary line once, sometimes twice (flaky), and
it will also expand the summary row in situ.  On mac os you can also double
click the summary line and it opens part way up the screen - it's a bit
flaky the way it does it tho - click somewhere else to close it again.

Cheers David H.

On Fri, 14 Jul 2023 at 01:10, David Carlson 
wrote:


Neil,

If you scroll down in the summary box you will see additional rows
identified by the currencies and securities in that file, if any exist.
Perhaps that would lead to an account and one or more transactions that
contain an incomplete closing transaction where some asset or liability was
exchanged without accounting for the loss or gain.  I too have no idea how
those numbers are calculated, so I cannot be more specific.

On Thu, Jul 13, 2023 at 9:35 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


I'm not sure exactly how those numbers are calculated and I've never
relied on them.

Perhaps a Balance Sheet would work better. You'd only need to know the
headline numbers:

Total Assets
Total Liabilities
Total Equity

(perhaps, Retained Earnings/Losses, if you like, though that is part of
the Equity section)

Regards,
Adrien

On 7/13/23 6:33 AM, Neil Campbell wrote:

I help a friend with their monthly accounting. She has GNUCash

installed

on a PC. I have GNUCash installed on a Mac mini M1 computer. She does the
input. I do the month end transactions and check her input. So we send
GNUCash data files backwards and forwards. The way I identify the file I
have sent her is to give her the Summary Box values. She must agree this
before starting her new month’s input.

This worked well until, for no apparent reason, these figures don’t

match any more.

My Mac mini M1 shows:
Net Assets £9,115.89Profits £3,075.18
Using the same file that I emailed her, her PC Shows:
Net Assets £9,115.89Profits £0.00

So I realised that there must be a Preference not set by her.

I downloaded and installed GNUCash on my wife’s PC to see how I could

correct the error. I changed the Setting Accounting period dates to the
correct ones. So, on my wife’s PC I have:

Net Assets £9,115.89Profits £8,803.24
It’s still not right and the Profit figure is now in red.

I now have 3 different Profit Figures, but I cannot find any place on

the Windows version to check why there are these differences, because I
don’t know where this Profit figure comes from. The correct figures are

the

ones on my Mac mini M1 above.

I must be missing something. Any help would be greatly appreciated.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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/listi

Re: [GNC] Gun shy?

[Stephen M. Butler]

I'm running Build ID: git 5.3-12-gaba64c9762+(2023-06-26)

On 6/27/23 10:38, R Losey wrote:

(Heh) I wonder if we are all gun shy about downloading and installing
GnuCash 5.3; I haven't seen anyone on this list say that they have used it
and it is fine.





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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 - Can't Save file

[Stephen M. Butler]

On 6/27/23 7:34 AM, Neil Campbell wrote:
 Unfortunately overnight my computer (Apple Mini M1) rebooted for some 
unknown reason and I lost it all anyway.


Can you replay the logs and apply those changes?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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 5.2 not able to save

[Stephen M. Butler]

Yup.  Been all over the distribution list.  Options:
1.  Upgrade to 5.3
2.  Turn off file compression.
3.  Save to database instead of XML


On 6/26/23 02:14, Robert Spring wrote:

Hi

I have just upgraded to 5.2.1 and followed the usual procedure that I have done 
many times.

I am running on Mac OS Ventura on an M2 Mac Mini.

All went well but I cant save anything.

Message is:


Any idea how to solve this permissions issue?

Robert Spring
b...@wspring.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
-
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
-
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 - Can't Save file

[Stephen M. Butler]

If you turn off compression, you will be able to save the file.

Also, I have pulled down the first 9 patches to 5.2 and can verify that 
on my Ubuntu box the file save to a compressed file does work.


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

On 6/26/23 09:42, Neil Campbell wrote:

The bug has been reported.  Gnucash can't save to a compressed file, the fix is 
due any day now.  However, 5.1 work fine if you want to upgrade now.

Really? Please tell me how I can recover over 2 hours of work on GnuCash ver 
5.2? I mean, is there any way I can recover my changes/input which I will lose 
if I now go back to ver 5.1? I am in limbo at present.

Neil Campbell



On 26 Jun 2023, at 17:00, gnucash-user-requ...@gnucash.org wrote:

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:  Upgraded to v5.2- now can't save (Gyle McCollam)
   2. Re:  Problem saving data file in GNUcash 5.2
  (Michael or Penny Novack)
   3.  Advice before posting a problem (was: Problem saving data
  file in GNUcash 5.2) (Stan Brown)


--

Message: 1
Date: Mon, 26 Jun 2023 12:34:06 +
From: Gyle McCollam 
To: Ira Fuchs , Gnucash 
Subject: Re: [GNC] Upgraded to v5.2- now can't save
Message-ID:



Content-Type: text/plain; charset="us-ascii"

The bug has been reported.  Gnucash can't save to a compressed file, the fix is 
due any day now.  However, 5.1 work fine if you want to upgrade now.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: gnucash-user  on behalf of 
Ira Fuchs 
Sent: Monday, June 26, 2023 8:19 AM
To: Gnucash 
Subject: [GNC] Upgraded to v5.2- now can't save

I just upgraded to v5.2 and I can no longer save changes. I get this error:

Could not write to file /Users/if/Documents/GnuCash folder/ 
gnucash_transactions.gnucash.20181105195638.gnucash.
20211205203910.gnucash. Check that you have permission to write to this file 
and that there is sufficient space to create it.

I have gone back to v4.13.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--

Message: 2
Date: Mon, 26 Jun 2023 11:31:18 -0400
From: Michael or Penny Novack 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Problem saving data file in GNUcash 5.2
Message-ID: <1c54f28d-0f24-4173-6ed0-3d7ac6830...@comcast.net>
Content-Type: text/plain; charset=UTF-8; format=flowed

On 6/26/2023 8:23 AM, geoff.accou...@70torcavenue.net wrote:

Today updated to version 5.2 but now unable to save any changes to my entry
stating that I do not have any permissions to do so.  Have tried changing
location to another folder on the C:\ drive and also an external drive but
does not work.



I do have full permissions and have since saved non-GNUcash files to these
locations.


Sort of general advice for any help list (not specific to gnucash)

Whenever you have a problem, before posting your request for help, LOOK
at recent entries to the list, say the last week or so. You want to see
if there have been a number of people reporting the same problem that
you have and are receiving answers about it. If so, these is no need to
add your plea for help to all the others. Not particularly helpful.

Yes, there is a problem with 5.2

Yes there are suggestion about what to do

Michael D Novack




--

Message: 3
Date: Mon, 26 Jun 2023 08:41:14 -0700
From: Stan Brown 
To: gnucash-user@gnucash.org
Subject: [GNC] Advice before posting a problem (was: Problem saving
data file in GNUcash 5.2)
Message-ID: <505b815b-0bc4-2b73-2fd2-c04950fb5...@fastmail.fm>
Content-Type: text/plain; charset=UTF-8


On 2023-06-26 08:31, Michael or Penny Novack wrote:


Sort of general advice for any help list (not specific to gnucash)

Whenever you have a problem, before posting your request for help, LOOK
at recent entries to the list, say the last week or so. You want to see
if there have been a number of people reporting the same p

Re: [GNC] How to edit pop-up menu when typing transaction descriptions

[Stephen M. Butler]

I like the new method.  But from the comments so far, I think there may 
be a couple option for an enhancement request.


1.  Have a preference setting for account matching on transaction entry 
where the user could set:

        A.  Contains; or,
        B.  Leads with
        [C.  Some may want Trails with]
        [[D.  Perhaps a Match Case option]]

2.  Another preference box for how many days back the user wants to 
match.  Blank entry would be ALL.  Zero would turn the matching off and 
XX days could be set to any number between 1 and some arbitrarily large 
number.  But I think the useful ones would be 30, 60, 90, 180, 360, ALL


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

On 6/6/23 07:32, David Carlson wrote:

The problem with the solution that Adrien suggests is that there is a real
possibility that the existing descriptions may be correct for existing
transactions but inappropriate for new transactions.  I think there is no
solution as long as the current method is used to populate the list, so we
must live with it.

On Tue, Jun 6, 2023 at 9:23 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


This list is populated from the descriptions used in every transaction -
in that register.

If there are some entries that are errant (such as misspellings) or
variant for the same entity (like a Payee, store name, etc.) the only
way to correct these is to change those descriptions you don't want to
those you do.

The easiest way to do this would be to do a Find for the description you
want to change, which will give you a list of transactions using it.
Then, as you correct them one-by-one, they'll disappear from the search
results and when the results register is empty, it will no longer appear
in the drop down list in account registers which are affected by those
transactions.

Regards,
Adrien

On 6/5/23 11:00 PM, Sebastian Aguilar wrote:

When I type in the description of a transaction, a pop-up menu of

previous entries appears. Is there a way to edit this menu? Sometimes it
feels more cumbersome than helpful.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] cost of goods sold, unsold inventory

[Stephen M. Butler]

For my inventory I assign a cost per unit (looks like yours is 
$100/unit).  That is a valid "expense" and can show up either as an 
expense item or as a reduction of sales.  I assigned mine as a reduction 
against sales (sub-account called COGS).  The other side of that entry 
is against inventory.


So for you, initially your inventory had $1000 in it (an asset 
account).  Each time you make a sale for $140 you also book a 
transaction to COGS of $100 with a reduction against inventory of $100.


After six units sold your inventory should show $400 balance.

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

On 5/21/23 16:26, Jamie Tolbert wrote:
I am slowly wrapping my head around things, kinda stuck on a question 
about accounting for unsold inventory. Say I bought 10 widgets, for 
100 each, my cost of good sold is 1000; I sold 6 for 140 each. My 
sales is 840, but my cost of good sold is only 600, not 1000, How do I 
account for the 4 remaining in inventory.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Ubuntu 23.04 upgrade and GnuCash

[Stephen M. Butler]

Just upgraded to Ubuntu 23.04 from 22.10.  GnuCash is now complaining 
that libicuuc.so.71 can't be found.


I had done a git pull a few days ago and build 5.0-77.  That worked 
great until upgraded Ubuntu to 23.04 this morning.  I did a git pull 
this afternoon and see that 5.0-84 is the current patch level.


Uninstalled the -77 build and installed the -84 build.  It appears to be 
working again.


Just an FYI in case you build on your box and then upgrade.

--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV import crash in 5.0+

[Stephen M. Butler]

I have been running 5.0.77 on Ubuntu and importing CSV transactions 
without problems.  So this may be tied to Windows.



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

On 4/20/23 06:52, Joseph Vernice wrote:

I am using the nightly build 5.0.77 on Windows 11.  Ever since upgrading to
5.0 (and above nightly builds) I am unable to import transactions from
CSV.  The system crashes when I select the CSV import profile or when I try
to create a new one.  The crash accors immediately after selecting the
profile OR after assigning the AMOUNT column. I have resorted to the latest
pre-5.0 build in order to import from CSV.  Unfortunately, my Fidelity
checking account only allows for CSV export, so this is an essential means
for me to import into gnucash. Thank you everyone for all your help.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Building 5.0 on Ubuntu 18.04

[Stephen M. Butler]

Oh, forgot one minor detail.  I did a "git pull" on my gnucash git clone 
and then attempted to apply the commands that John posted a few messages 
back.  Didn't work as expected so I did the extreme and blew my clone 
away and redid it from github.


Then compiled from the most recent patch: 5.0-5-g77cb9c6af4+(2023-03-27)
That may explain why my compiles work.

--Steve

On 3/29/23 16:39, Stephen M. Butler wrote:

It might be easier to upgrade Ubuntu!  I am at 22.10.

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

On 3/29/23 15:39, Tom Weichmann wrote:

So I took a guess and thought that since the README.dependencies doc
required GCC 8.0 that it may also require g++ 8.  Ubuntu 18.04 has 
several
versions available including 6, 7 and 8.  I had them all installed 
but gcc
was linked to gcc7 and g++ was linked to g++7.  I had already changed 
the

link for gcc to gcc-8 but hadn't yet for g++ since the
README.dependencies didn't mentions g++.  However looking at the logs 
I saw

some mentions of c++ 7, so I changed my links in /usr/bin for g++ to now
link to g++-8.

My build got much further, however failed again at a new point:

https://pastebin.com/rAuYe1DM



On Wed, Mar 29, 2023 at 6:14 PM Tom Weichmann  
wrote:



Hi John,

Thanks for the reply.  Yes, the README.dependencies does state:
Libraries/Deps
--
   required  Version
     ___
   cmake 3.10    Build system manager

and I do have 3.10 installed as you suspected.

% cmake --version
cmake version 3.10.2

So, I downloaded, built and installed cmake 3.11 into my /usr/local and
can confirm that I can now complete the cmake operation in the build
process.  Since Ubuntu 18.04 LTS is now 5 years old and is going EOL 
next
month I'd say it's safe to just bump your cmake requirements to 
3.11.  It

looks like 3.11 was released 5 years ago already, but I don't know what
other major distros are on.

However, that being fixed, I am now running into issues building.
Pastebin here:

https://pastebin.com/tBDW6XeY

Any ideas what is going on here?


On Wed, Mar 29, 2023 at 5:51 PM john  wrote:


Ubuntu's 18.04's Cmake is too old. target_compile_definitions for
imported modules was introduced in Cmake 3.11 and Ubuntu 18.04 has 
3,10.1.


Our currently advertised minimum cmake *is* 3.10, but we didn't 
bump it

for 5.0 and we usually do. I'm inclined to bump the minimum Cmake
instead of going back got `pkg_check_modules`.

Regards,
John Ralls


On Mar 29, 2023, at 11:57 AM, Tom Weichmann 

wrote:

Hi All,

I'm still running Ubuntu 18.04 LTS which is still supported by Ubuntu
albeit a bit old.  I've been happily building all of the 4.x versions

from
source since the latest is not in this distro's repositories.  Now 
i'm
trying to build version 5,0 and I'm running into a failure with 
cmake:


---
~/dev/build-gnucash-5.0
% cmake -DCMAKE_INSTALL_PREFIX=/usr/local ../gnucash-5.0
-- The C compiler identification is GNU 8.4.0
-- The CXX compiler identification is GNU 7.5.0
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Detecting C compile features
-- Detecting C compile features - done
-- Check for working CXX compiler: /usr/bin/c++
-- Check for working CXX compiler: /usr/bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Detecting CXX compile features
-- Detecting CXX compile features - done
-- Found UnixCommands: /bin/bash
-- Looking for pthread.h
-- Looking for pthread.h - found
-- Looking for pthread_create
-- Looking for pthread_create - not found
-- Looking for pthread_create in pthreads
-- Looking for pthread_create in pthreads - not found
-- Looking for pthread_create in pthread
-- Looking for pthread_create in pthread - found
-- Found Threads: TRUE
-- Found PkgConfig: /usr/bin/pkg-config (found version "0.29.1")
-- Checking for module 'glib-2.0>=2.56.1'
--   Found glib-2.0, version 2.56.4
-- Checking for module 'gio-2.0'
--   Found gio-2.0, version 2.56.4
-- Checking for module 'gobject-2.0'
--   Found gobject-2.0, version 2.56.4
-- Checking for module 'gmodule-2.0'
--   Found gmodule-2.0, version 2.56.4
-- Checking for module 'gthread-2.0'
--   Found gthread-2.0, version 2.56.4
-- Checking for module 'libxml-2.0>=2.9.4'
--   Found libxml-2.0, version 2.9.4
-- Checking for module 'libxslt'
--   Found libxslt, version 1.1.29
-- Checking for module 'webkit2gtk-4.0>=2.14.0'
--   Found webkit2gtk-4.0, version 2.32.4
-- Checking for module 'gtk+-3.0>=3.22.30'
--   Found gtk+-3.0, version 3.22.30
-- Checking for module 'zlib'
--   Found zlib, version 1.2.11
-- Found Gettext: /usr/local/bin/

Re: [GNC] Building 5.0 on Ubuntu 18.04

[Stephen M. Butler]

It might be easier to upgrade Ubuntu!  I am at 22.10.

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

On 3/29/23 15:39, Tom Weichmann wrote:

So I took a guess and thought that since the README.dependencies doc
required GCC 8.0 that it may also require g++ 8.  Ubuntu 18.04 has several
versions available including 6, 7 and 8.  I had them all installed but gcc
was linked to gcc7 and g++ was linked to g++7.  I had already changed the
link for gcc to gcc-8 but hadn't yet for g++ since the
README.dependencies didn't mentions g++.  However looking at the logs I saw
some mentions of c++ 7, so I changed my links in /usr/bin for g++ to now
link to g++-8.

My build got much further, however failed again at a new point:

https://pastebin.com/rAuYe1DM



On Wed, Mar 29, 2023 at 6:14 PM Tom Weichmann  wrote:


Hi John,

Thanks for the reply.  Yes, the README.dependencies does state:
Libraries/Deps
--
   required  Version
     ___
   cmake 3.10Build system manager

and I do have 3.10 installed as you suspected.

% cmake --version
cmake version 3.10.2

So, I downloaded, built and installed cmake 3.11 into my /usr/local and
can confirm that I can now complete the cmake operation in the build
process.  Since Ubuntu 18.04 LTS is now 5 years old and is going EOL next
month I'd say it's safe to just bump your cmake requirements to 3.11.  It
looks like 3.11 was released 5 years ago already, but I don't know what
other major distros are on.

However, that being fixed, I am now running into issues building.
Pastebin here:

https://pastebin.com/tBDW6XeY

Any ideas what is going on here?


On Wed, Mar 29, 2023 at 5:51 PM john  wrote:


Ubuntu's 18.04's Cmake is too old. target_compile_definitions for
imported modules was introduced in Cmake 3.11 and Ubuntu 18.04 has 3,10.1.

Our currently advertised minimum cmake *is* 3.10, but we didn't bump it
for 5.0 and we usually do. I'm inclined to bump the minimum Cmake
instead of going back got `pkg_check_modules`.

Regards,
John Ralls


On Mar 29, 2023, at 11:57 AM, Tom Weichmann 

wrote:

Hi All,

I'm still running Ubuntu 18.04 LTS which is still supported by Ubuntu
albeit a bit old.  I've been happily building all of the 4.x versions

from

source since the latest is not in this distro's repositories.  Now i'm
trying to build version 5,0 and I'm running into a failure with cmake:

---
~/dev/build-gnucash-5.0
% cmake -DCMAKE_INSTALL_PREFIX=/usr/local ../gnucash-5.0
-- The C compiler identification is GNU 8.4.0
-- The CXX compiler identification is GNU 7.5.0
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Detecting C compile features
-- Detecting C compile features - done
-- Check for working CXX compiler: /usr/bin/c++
-- Check for working CXX compiler: /usr/bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Detecting CXX compile features
-- Detecting CXX compile features - done
-- Found UnixCommands: /bin/bash
-- Looking for pthread.h
-- Looking for pthread.h - found
-- Looking for pthread_create
-- Looking for pthread_create - not found
-- Looking for pthread_create in pthreads
-- Looking for pthread_create in pthreads - not found
-- Looking for pthread_create in pthread
-- Looking for pthread_create in pthread - found
-- Found Threads: TRUE
-- Found PkgConfig: /usr/bin/pkg-config (found version "0.29.1")
-- Checking for module 'glib-2.0>=2.56.1'
--   Found glib-2.0, version 2.56.4
-- Checking for module 'gio-2.0'
--   Found gio-2.0, version 2.56.4
-- Checking for module 'gobject-2.0'
--   Found gobject-2.0, version 2.56.4
-- Checking for module 'gmodule-2.0'
--   Found gmodule-2.0, version 2.56.4
-- Checking for module 'gthread-2.0'
--   Found gthread-2.0, version 2.56.4
-- Checking for module 'libxml-2.0>=2.9.4'
--   Found libxml-2.0, version 2.9.4
-- Checking for module 'libxslt'
--   Found libxslt, version 1.1.29
-- Checking for module 'webkit2gtk-4.0>=2.14.0'
--   Found webkit2gtk-4.0, version 2.32.4
-- Checking for module 'gtk+-3.0>=3.22.30'
--   Found gtk+-3.0, version 3.22.30
-- Checking for module 'zlib'
--   Found zlib, version 1.2.11
-- Found Gettext: /usr/local/bin/msgmerge (found suitable version

"0.21.1",

minimum required is "0.19.6")
-- Found SWIG: /usr/bin/swig3.0 (found suitable version "3.0.12",

minimum

required is "3.0.12")
-- Using guile-2.2.x
-- Using guile SRFI-64
-- Using guile textual-ports
-- Checking for module 'gwenhywfar>=5.6.0'
--   Found gwenhywfar, version 5.9.0
-- Checking for module 'aqbanking>=6.2.0'
--   Found aqbanking, version 6

Re: [GNC] Building 5.0 on Ubuntu 18.04

[Stephen M. Butler]

Tom,
Please respond via the list so everyone is included in the discussion.

On 3/29/23 12:37, Tom Weichmann wrote:

Hi Steven,

I also built on 22.04 (my laptop) successfully.

The README.dependencies in the source lists the following versions for 
GLIB2 and GTK3:


Libraries/Deps
--
  required              Version
                ___
  glib2                 2.56.1
  gtk+3                 3.22.30

I have the following for glib2
% apt list | grep libglib2
libglib2.0-0/bionic-updates,bionic-security,now 
*2.56.4*-0ubuntu0.18.04.9 amd64 [installed,automatic]


This is what I have in 22.10
sudo apt list | grep libglib2
libglib2.0-0/kinetic-updates,now 2.74.3-0ubuntu1 amd64 [installed]
libglib2.0-0/kinetic-updates,now 2.74.3-0ubuntu1 i386 [installed,automatic]
libglib2.0-bin/kinetic-updates,now 2.74.3-0ubuntu1 amd64 [installed]
libglib2.0-bin/kinetic-updates 2.74.3-0ubuntu1 i386
libglib2.0-cil-dev/kinetic,now 2.12.40-3ubuntu1 amd64 [installed]
libglib2.0-cil/kinetic,now 2.12.40-3ubuntu1 amd64 [installed]
libglib2.0-data/kinetic-updates,kinetic-updates,now 2.74.3-0ubuntu1 all 
[installed]

libglib2.0-dev-bin/kinetic-updates,now 2.74.3-0ubuntu1 amd64 [installed]
libglib2.0-dev-bin/kinetic-updates 2.74.3-0ubuntu1 i386
libglib2.0-dev/kinetic-updates,now 2.74.3-0ubuntu1 amd64 [installed]
libglib2.0-dev/kinetic-updates 2.74.3-0ubuntu1 i386
libglib2.0-doc/kinetic-updates,kinetic-updates,now 2.74.3-0ubuntu1 all 
[installed]

libglib2.0-tests/kinetic-updates,now 2.74.3-0ubuntu1 amd64 [installed]
libglib2.0-tests/kinetic-updates 2.74.3-0ubuntu1 i386



For GTK3, I'm wondering if this is the issue: here is everything 
listed for GTK3:

% apt list | grep libgtk3
libgtk3-nocsd0/bionic,now 3-1ubuntu1 amd64 [installed,automatic]
libgtk3-perl/bionic,bionic,now 0.032-1 all [installed,automatic]
libgtk3-simplelist-perl/bionic,bionic 0.17-1 all
libgtk3-webkit2-perl/bionic,bionic 0.06-3 all
libgtk3.0-cil/bionic,now 2.99.3-2 amd64 [installed,automatic]
libgtk3.0-cil-dev/bionic,now 2.99.3-2 amd64 [installed]


And for libgtk3 I have:
sudo apt list | grep libgtk3
libgtk3-imageview-perl/kinetic,kinetic,now 10-1 all [installed,automatic]
libgtk3-nocsd0/kinetic 3-1ubuntu2 amd64
libgtk3-perl/kinetic,kinetic,now 0.038-1 all [installed]
libgtk3-simplelist-perl/kinetic,kinetic,now 0.21-1 all [installed,automatic]
libgtk3-webkit2-perl/kinetic,kinetic 0.06-4 all
libgtk3.0-cil-dev/kinetic,now 2.99.3-4build1 amd64 [installed]
libgtk3.0-cil/kinetic,now 2.99.3-4build1 amd64 [installed]

--Steve

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Building 5.0 on Ubuntu 18.04

[Stephen M. Butler]

On 3/29/23 11:57, Tom Weichmann wrote:


Hi All,

I'm still running Ubuntu 18.04 LTS which is still supported by Ubuntu
albeit a bit old.  I've been happily building all of the 4.x versions from
source since the latest is not in this distro's repositories.  Now i'm
trying to build version 5,0 and I'm running into a failure with cmake:

<>

CMake Error at CMakeLists.txt:776 (target_compile_definitions):
   Cannot specify compile definitions for imported target "PkgConfig::GLIB2".


CMake Error at CMakeLists.txt:782 (target_compile_definitions):
   Cannot specify compile definitions for imported target "PkgConfig::GTK3".
I compiled just fine on Ubuntu 22.10.  Your problem may be older 
versions of GLIB2 and GTK3 (which might be GTK2 on 18.04).


The newer versions needed for those modules may not be compatible with 
18.04.


--Steve

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Schedule transaction for 2 Wednesday?

[Stephen M. Butler]

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Schedule transaction for 2 Wednesday?

[Stephen M. Butler]

Set it on the Frequency tab.

Frequency -- pick Monthly
Every ? months -- (enter 1 into that box)
On the {big drop down list}  -- Pick the '2nd Wed' from the list.

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

On 3/9/23 20:53, Adrien Monteleone wrote:

I don't think you can.

The closest method I can find is to set the first instance to the 
second Wednesday then set frequency to 28 days, or 4 weeks.


But of course, that will sometimes fall on the first Wednesday.

The workaround there is to set it for remind and review without 
auto-creation and adjust as needed.


Regards,
Adrien

On 3/9/23 10:38 PM, ToddAndMargo via gnucash-user wrote:

Hi All,

Fedora 37
gnucash-4.13-1.fc37.x86_64

How do I set up a scheduled transaction to go off
the second Wednesday of the month?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Building Gnucash on Fedora 37 - "No package 'glib-2.0' found" error

[Stephen M. Butler]

This is the package for Ubuntu.

apt --yes --force-yes install libglib2.0 libglib2.0-dev

In fact, here are all the dependencies needed:
apt --yes --force-yes install build-essential
apt --yes --force-yes install cmake
apt --yes --force-yes install ninja-build
apt --yes --force-yes install libglib2.0 libglib2.0-dev
apt --yes --force-yes install libxml2 libxml++2.6-dev libxml2-utils
apt --yes --force-yes install libxslt1.1 libxslt1-dev
apt --yes --force-yes install libwebkit2gtk-4.0-37 libwebkit2gtk-4.0-dev
apt --yes --force-yes install gtk+3.0 libgtk-3-dev
apt --yes --force-yes install zlib1g zlib1g-dev
apt --yes --force-yes install guile-2.0 guile-2.0-dev
apt --yes --force-yes install swig
apt-get install libboost-all-dev
apt-get install libsecret-1-0 libsecret-1-0-dev
apt-get install aqbanking-tools libaqbanking-dev
apt-get install gwenhywfar-tools libgwenhywfar60 libgwenhywfar60-dev
apt-get install ktoblzcheck libktoblzcheck1-dev
apt-get install libofx-dev
apt-get install xsltproc
apt-get install libdbi1 libdbi-dev libdbd-pgsql libdbd-mysql libdbd-sqlite3
apt-get install python3-pytest
apt --yes --force-yes install googletest



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

On 3/9/23 14:52, Vivek Gani wrote:

Hi,

I'm trying to build gnucash from source (rather than the rpm package or
flatpak for python bindings) on Linux (Fedora 37) and keep running into an
issue where on build I get the error:

```
-- Checking for module 'glib-2.0>=2.56.1'
--   No package 'glib-2.0' found
```

What I've tried so far:
- I've installed glib2.0-devel via `sudo dnf install glib2-devel`
- I've checked via `yum provides */glib2.0.pc` which shows it is in the
`/usr/lib64/pkgconfig` directory.
- I've checked the contents of `echo $PKG_CONFIG_PATH` which shows
directories like `/usr/lib64/pkgconfig` are listed.
- I've tried building gnucash with various different arguments, but similar
to the directions in
https://wiki.gnucash.org/wiki/CMake#GnuCash_Configuration_Variables &
https://wiki.gnucash.org/wiki/Building_On_Linux#Build_using_CMake_and_Ninja
I've tried in my build directory:
`cmake -DCMAKE_INSTALL_PREFIX=$HOME/opt
-DCMAKE_PREFIX_PATH=$PKG_CONFIG_PATH  -DCMAKE_VERBOSE_MAKEFILE=on
../gnucash-4.13`

and get the glib error. It happens also without the CMAKE_PREFIX_PATH, just
running plain `cmake .` in the gnucash source directory, etc.

Any idea what I'm missing to get things to build?

Thanks in advance,
Vivek
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to force y in reconcile field

[Stephen M. Butler]

On 2/2/23 10:14, Xe Roy wrote:

I am new user who made a mistake in a previous reconcile.
To correct the mistake, I need to change 2 transactions from n to y in the 
reconcile field.
I see that is not possible via the program, so do I have to edit the .gnucash 
file or is there a better way?

When that happens to me (or I do an edit that turns off the reconcile 
flag), I just include them (check the box) on the next reconciliation 
cycle (which mostly happens right then since I have online access to the 
bank's information).

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Start up cost in GnuCash

[Stephen M. Butler]

This is a discussion you need to have with your CPA.  Involved are the 
following questions:


1.  Is this a sole proprietorship?  Partnership?  LLC?  Corporation?
2.  If a sole proprietorship, will the accounting be done in your 
personal books?  Or do you need a separate set of books for the business?

3.  Will the business refund you or are these your own expenses?

Only your CPA can guide you correctly.

--Steve

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

On 1/24/23 11:18, Joel via gnucash-user wrote:

Hello Gnucash, We are trying to figure out how to enter into gnucash the 
initial expenses or startup cost for the business we have been putting on our 
personal credit card to start this new business.
Thank you in advance for your help.
Taneshia and Joel
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Merge two pairs -> one 4-way split

[Stephen M. Butler]

On 1/15/23 11:50, Fred Tydeman wrote:

I have one transaction moving money from A to B (one pair)
I have another transaction moving money from C to D (another pair)
I now realize I should have one transaction with 4 splits.
Is there an easy way to merge the two pairs into one 4-way split?
Or, do I have to manually re-enter 40 transactions?

I do not know of a way to easily merge transactions.

On a practical note.  Why make the change retroactive?  My solution is 
to let the past be and make the change going forward.


--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Stephen M. Butler]

On 1/3/23 17:43, Dr. David Kirkby wrote:


multi-page Q his office provides.


Do you not provide details of what the individual transactions to your 
accountant? If you do provide that, do you just use the unedited CSV 
files exported from GnuCash?


Dave


I do print off a detailed transaction report by account/date.  So far 
they haven't asked for it.


--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Stephen M. Butler]

My CPA accepts the Balance Sheet and Profit/Loss Statement along with a 
multi-page Q his office provides.


On 1/2/23 13:30, Dr. David Kirkby wrote:

I asked my accountant about using GnuCash. He doesn’t know it, but said if
can export a CSV file that will be okay.

Previously I have used LibraOffice, with multiple tabs for different
things. Something like the following - he provided me with this as a
suggestion when I first contacted him.


1) PayPal account
2) Bank Account
3) Expenses
4) Assets
5) Stock - just a list of what I have at the end of the financial year.
6) Electricity usage

He can export that as a CSV file. It will have a list of expenses something
like

2/1/2023, widgets, £12.34
1/1/2023, things, £178.12

All values are positive, and the sum of those is the sum of the expenses.
That’s quite different from the CSV export from GnuCash, where each line
has either a positive value or negative, and the sum is zero.

Do people get any complaints from accountants about the format of the
files, or are they happy with them?

I could write my own post-processor using Linux command line tools to get
data in a format that more resembles what he had before.

Normally I get my accounts to my accountant near the end of the month they
need to be submitted, which is 6 months after the end of the financial
year. Next time I hope to get them to him *much* earlier so if he has any
problems with the exported files, I can manipulate them.

It would be nice if one could export all the expenses without the dates
being in a random order. The only way I can find to get dates in a
chronological order is to export every single account separately, so there
are no sub accounts. I thought about trying to write some code that would
allow all the expenses to be exported in one file in chronological order.
That’s not an impossible task, but would take me quite a bit of coding. If
I did it, I would just create something that’s command line driven, using
as many as the unix tools as possible to cut down the work. It might be
possible to just make a fairly complex shell script.

Dave





--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Bank account reconciled, will this change screw things up?

[Stephen M. Butler]

On 12/30/22 14:48, Adrien Monteleone wrote:
How do you do that for a posted bill/invoice? Mine is immutable. (and 
should be)


Regards,
Adrien

On 12/30/22 4:32 PM, Stephen M. Butler wrote:
I just modify the account on that one line to point to Postage.  It 
doesn't seem to hurt any and is a whole lot simpler than trying to 
enter the whole transaction all over again.


OK.  Mine are not tied to the business features.

--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Bank account reconciled, will this change screw things up?

[Stephen M. Butler]

On 12/30/22 12:43, Dr. David Kirkby wrote:

I paid for some postage for £12.54, but instead  of sticking the expense
account as Postage, I put Payroll - well, then do both begin with P. Given
I have reconciled the bank account, is it dangerous to change the account
this transaction is debited to, from Payroll to Postage? I was thinking of
unposting it, changing the expense account, then paying the invoice again.
The amount of money is unchanged.
I just modify the account on that one line to point to Postage.  It 
doesn't seem to hurt any and is a whole lot simpler than trying to enter 
the whole transaction all over again.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Changing registers in the middle of entering or editing a transaction

[Stephen M. Butler]

On 12/28/22 14:05, Stan Brown wrote:

It's a bit irritating to be told that something is preventing save, but
not told what that something is. (Reminds me of the story, hopefully
apocryphal, of a C compiler that had only one error message, "Syntax
Error", with no indication of where.)


Saw that multiple times on a Mod 1 MSR COBOL compiler on a Honeywell 115.

My wife was doing data entry at the time and saved my butt on a number 
of occasions (my programs where keyed onto cards from a coding sheet).  
"Is this supposed to be a period here?"


"Nope.  Just a defect in the coding sheet paper."

"I thought so but Carla punched a period there.  I'll fix it."

Still love that woman.  48 years tomorrow!

PS.  Had a student once ask what was "Syntax".  Told her it was the tax 
the government applied for her sins!


--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to handle inventory assets in GnuCash?

[Stephen M. Butler]

Eric,

As you noted, they are an Asset.  Now, I'm not a CPA or even a book 
keeper (though my wife did that job for a number of years for an 
architect).  Here is how I am doing it.


1.  Setup an Asset account for Inventory (or whatever you want to name it).
2.  Setup an account for Cost of Goods Sold.  (Mine is a contra account 
in Income -- your CPA might want it as an Expense).
3.  Divide your inventory value by the number of items (if only one type 
of item or break out a similar Cost/Item for each type of item).
4.  When you make a sale, reduce Inventory by the COGS for that item and 
increase the appropriate account from step 2.


Note, I didn't use Credit/Debit as I forget which one is supposed to be 
closest to the window.  I think that changed recently when I switched my 
desk around and the other side of the monitor is now nearest the window.


--Steve

On 12/20/22 06:55, Eric Chapman wrote:
I am wondering how, in GnuCash, to account for assets bought to resell 
or other assets that will later be expensed as used.


I'm in the USA context. As far as terminology goes, I think UK and 
other English speaking locales use the word "stock" to refer to 
inventory, but, in my experience, that is not common in the USA 
(indeed, the first definition of "stock" from Apple Dictionary: "the 
goods or merchandise kept on the premises of a business or warehouse 
and available for sale or distribution"; that is basically the 
definition of "inventory" at the bottom of the wiki article referred 
to below). I will try to use the word "inventory" so I do not confuse 
the term I'm talking about with the one meaning ownership securities 
of a company ("He owns 100 shares of XYZ Company stock.").


I found something relevant in the wiki: 
https://wiki.gnucash.org/wiki/Inventory_Handling. Best I can tell, 
GnuCash does not have any dedicated way to handle inventory flows: 
purchases, sales, revaluations for market fluctuations, identification 
of lots/batches).


If I want to deal with inventory now in GnuCash v. 4.13, any best 
practices? I'm not talking about massive amounts of items or quantities.


Thank you!
Eric


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Roth IRA conversion

[Stephen M. Butler]

On 12/19/22 14:53, Michael or Penny Novack wrote:

On 12/19/2022 2:49 PM, David T. wrote:

Michael,

While I fully respect your answer, with over 45 million IRA accounts 
in the US (according to one source I found online), this is a pretty 
common circumstance. It should be possible for basic guidance to be 
given by *someone*, without all 45 million consulting an accountant. 
I personally don't know the answer.


The question was not about basic IRA accounting (or 401k accounting, 
which was your example)


Usually people choose regular IRA or Roth IRA depending on whether 
they wanted to pay the income tax now (contribution time) or later 
(distribution time). So it is NOT "all the people with IRAs" but only 
"those few whose changed circumstances mean they now want Roth rather 
than regular". << this is one of the few "changed your mind" that the 
IRS allows >>


For example, I might want to do this if I had regular IRAs and a huge 
loss of some kind that could be used to offset the imputed income of 
the conversion to Roth.


And I am doing the IRA to Roth conversion now that I'm on Social 
InSecurity and paying no taxes.  So it is tiny bytes each year!!


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Is there a way to find date & time a transaction was entered?

[Stephen M. Butler]

On 12/18/22 17:14, Dr. David Kirkby wrote:

I have a transaction that I entered incorrectly. Is there a way to
determine the date & time that the transaction was entered? If so, I could
just load a backup file created just before I screwed up.

It is easier to just correct the original transaction.

I know that in formal accounting one should not delete transactions, but
apply a reversing transaction. But I think that will just confuse me, and
my accountant more. I don’t need to be too formal - previously I have
submitted my accounts to my accountant on a spreadsheet, but that’s too
error-prone for my liking.


If you were doing this for somebody else then that would be the "proper" 
route.  But, if this is just personal or for your own business, then 
just erase the bad part and make the correction. It's digital and nobody 
will know you made a mistake (unless the look at all the log files that 
you failed to delete).



  If I delete the transaction, would that put things back exactly as they
were before the transaction was entered?


Yup, by why be that hard on yourself?


I spent about 20 minutes last night trying to understand how £14 had
disappeared from the company bank account, clearly marked in the bank
account that the money went to PayPal, but there was no record of the
transaction on the company PayPal account.  I eventually found what had
happened - it had gone to my personal PayPal account. There’s no way I
would have spotted that error using spreadsheets. The double entry
accounting does make finding errors easier than using a spreadsheet.


Personally, I would just go to that one line and change the account from 
paypal personal to paypal company.

I must admit, I am quite impressed with GnuCash.

Dave


Me too.  And I'm also lazy so I just do the minimum needed to fix my 
mistakes.


--
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
-
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 PC

[Stephen M. Butler]

I can help with (b)  and (c).

On 12/14/22 11:51, Deborah Millington wrote:

Hello, I'm looking for a bit of help please.  I've used GnuCash for many
years on a laptop which is now struggling to keep going.  I've got a newer
(second hand) laptop and need to do a one off transfer of my GnuCash files
to it so I can use it instead in future.  I'm familiar with backing up my
files, so I know I can locate them on my old laptop.  I've also installed
GnuCash on my new laptop.  Here are the things I need help with:
(a) I should be able to copy my data files to my new laptop and open them
using GnuCash.  However, I'm sure I've seen something saying that there are
lots of other settings/config which aren't transferred this way.  Can you
tell me what these are & how I update them on the new laptop to match what
is one the old one please?
(b) In doing the installation, I've discovered that I have been using an
old version of GnuCash.  Is it worth me backing up my current data file on
the old version, then installing the new version on the old laptop &
updating the data file before transferring it, or if I just put the data in
its existing format onto the new computer will it open the old version data
in the new version of software OK & allow me to save the data against the
new software version?


Depends on how old.  If you have a v2 series, then you need to upgrade 
some on the old machine.  See how old of a version you can load on your 
new machine and get updated to that version on the old box first.  Then 
you can do the remainder of the upgrades on the new box.  If you tell 
the list the version you have on the old laptop along with the O/S and 
that version, then the list can be more specific in the upgrade path.  
Also give the O/S and version on the new computer.



(c) What do I need to do to ensure I get notifications of future updates?
Sign up to this mailing list (gnucash-user).  If this has too much 
traffic, then gnucash-announce 
<https://lists.gnucash.org/mailman/listinfo/gnucash-announce> has much 
less traffic but does so the announcements (or so I'm told).




I have checked the help as much as I can before posting this.  I've seen a
few related posts, but nothing which has specifically addressed all aspects
of my query.  All help appreciated.  Thank you.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How can I enter all fixed assets?

[Stephen M. Butler]

On 11/30/22 15:39, Dr. David Kirkby wrote:

Having given this more consideration I think the following is my best bet.
Comments welcome, but I am not expecting to get definitive professional
advice.

I am considering to lump them all together under Assets -> Fixed Assets,
with an opening balance equal to the value at the start of the financial
year, taking into account the depreciation. That value is given to me by my
accountant.

This will mean that I can not work out the depreciation on an individual
item, but my accountant does that each year to submit the accounts. I pay a
professional to do that.

He can tell me at the end of the year how much the sum of all items have
depreciated, and I can just enter that sum once per year. He can also give
me the exact amount of depreciation on every item, but I will just ignore
that, and record the sum. He doesn’t normally give me the individual items
- only the sum. He did give them to me this year as I asked for them, but
normally he doesn’t give me a detailed breakdown.

In previous years my accountant has never expected me to work out the
depreciation - he does it once per year.

If I was inspected by HMRC, I doubt that they are going to quibble about
the fact I don’t know the depreciation of assets on a particular day. If
they do, my accountant would be able to supply them.

The HMRC website lists what is inspected of directors - I put a copy below.
It mentions “Details of assets owned by the company” but does not actually
define what details they are.

Does changing the total value once/year in GnuCash under

Assets -> Fixed assets

seem reasonable given that is all my accountant ever gives me?

Dave
Accounting records


Seems reasonable to me.  I would ask the CPA/Accountant if that 
satisfies the below that you referenced.

You must keep accounting records that include:

- all money received and spent by the company, including grants and
payments from coronavirus (COVID-19) support schemes

<https://www.gov.uk/guidance/reporting-coronavirus-covid-19-grants-and-support-payments>
- details of assets owned by the company
- debts the company owes or is owed
- stock the company owns at the end of the financial year
- the stocktakings you used to work out the stock figure
- all goods bought and sold
- who you bought and sold them to and from (unless you run a retail
business)

You must also keep any other financial records, information and
calculations you need to prepare and file your annual accounts and Company
Tax Return
<https://www.gov.uk/prepare-file-annual-accounts-for-limited-company>. This
includes records of:

- all money spent by the company, for example receipts, petty cash
books, orders and delivery notes
- all money received by the company, for example invoices, contracts,
sales books and till rolls
- any other relevant documents, for example bank statements and
correspondence




--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How can I enter all fixed assets?

[Stephen M. Butler]

On 11/29/22 18:24, Michael or Penny Novack wrote:

On 11/29/2022 8:18 PM, Dr. David Kirkby wrote:
I want to start using GnuCash for a company I set up several years 
ago. The

company has some assets - mainly electronic test equipment. Let’s
hypothetically assume

VNA £1000
Signal generator £500
Frequency counter £250
Calibration kit £2000

Total is £3750


Is there a way of entering the individual items into GnuCash? I realise
that I can create an account

Assets -> Test equipment

with an opening balance of £3750, but that doesn’t itemise individual
items.

It would be a bit tedious to create accounts for every item individually

Assets -> Test equipment -> VNA
Assets -> Test equipment -> Signal generator
Assets -> Test equipment -> Frequency counter

and set each to have an appropriate opening balance.


Normally under "assets" one might have a number of high level 
sub-accounts. For example "current assets" (cash and cash equivalents, 
bank accounts, A/R (could  be "factored), negotiable instruments, etc. 
Then there might be "inventory" if the business bought and sold 
widgets. But the sub-category you are asking about is "fixed assets". 
HOW you subdivide further probably best dictated by how you depreciate 
them and I haven't a clue about "depreciation" rules in the UK.


a) If your gnucash books already exist I would create the accounts 
with zero balance and add the current BOOK VALUE* with a transaction.


b) HERE I would need to know the year purchased, original basis, and 
total depreciated so far. For that reason I probably would have 
assets:fixed assets:test equipment: (and then each because the 
depreciation history for each likely different.


I will stop here because you aren't so much asking a gnucash question 
as a "fundamentals of accounting" question and you need to look up 
"accounting for/depreciating the fixed assets of a business" and 
"adjustments upon disposal of a fixed asset" in accordance with the 
rules of your jurisdiction. In other words, THAT would be the same as 
in the old days of keeping you books by hand pen and ink on paper.  
Those rules will affect your choices with regard to "keep all 
together" vs "have each separate", etc.


Michael D Novack


The short answer implied by previous responders is:  There is no Fixed 
Assets module in GnuCash!


Given Michaels comments above, you find it better to keep a spread-sheet 
for each class of asset (depreciation rate/age) and keep the sub-totals 
in GnuCash.


--
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
-
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 find gnucash on my computer

[Stephen M. Butler]

What O/S?  Windows, Mac, Linux (flavor)?  Which version of O/S?

Which version of GnuCash did you download?

On 11/20/22 11:29, Sally Abrams via gnucash-user wrote:

I downloaded gnucash.  Ran the set up, even tried restarting my computer but no 
icon and when I search my computer only the setup file shows up.  Its not 
showing up in programs.  When I ran set up again, it told me program was on my 
computer and it uninstalled it so it could reinstall it but my computer still 
can't find it.  i'm on windows 7.  I'm planning on upgrading my computer but 
first want to move my data from quicken to gnucash.  thanks for any help.


--

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Won't Start on Upgraded Ubuntu 22.10

[Stephen M. Butler]

Upgraded Ubuntu overnight to 22.10.

GnC won't start this morning.  CI attempt shows "error while loading 
shared libraries: libicuuc.so.70: cannot open shared object file: No 
such file or directory"


Indeed, it appears that libicuuc.so.71 was installed during the upgrade.

GnC version 4.11-136 had been locally compiled so suspect it didn't get 
libraries updated.


Did a git pull, found that 4.12.28 was current in maint, compiled and 
installed.  That fixed the issue (plus forced me to upgrade to the latest).


Just a notice to anyone else who may be upgrading Ubuntu this week.

--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Sub-Accounting (Was: Problem with missing balance in a parent account **FINAL POST**)

[Stephen M. Butler]

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Import CSV transactions into GC

[Stephen M. Butler]

https://lists.gnucash.org/mailman/listinfo/gnucash-user
    >> >> -
    >> >> 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
    >> > -
    >> > 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
    >> -
    >> Please remember to CC this list on all your replies.
    >> You can do this by using Reply-To-List or Reply-All.
    >>
    >
    >
    > --
    > David Carlson
    >
    >
    >

    --     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
    -
    Please remember to CC this list on all your replies.
    You can do this by using Reply-To-List or Reply-All.



    --     _
    Richard Losey
    rlo...@gmail.com
    Micah 6:8





--
_
Richard Losey
rlo...@gmail.com
Micah 6:8




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciling subaccounts

[Stephen M. Butler]

For  me the parent placeholder account in GnC is the bank account that 
is being reconciled.  The sub-accounts in GnC are just my way of 
delegating the funds within that account for certain  purposes.


I'm not sure about the use case of using the placeholder as a grand 
total for all accounts held at the bank and then reconciling all of them 
in one step (checking, saving, CD, money market).  I suppose if they 
were all reported on a single statement



On 10/7/22 10:41, R Losey wrote:

I kind of like it the way it is currently, for what it's worth.

On Thu, Oct 6, 2022 at 1:20 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


Thanks for the details.

I'd say this is a bug, as the expected result would be to have the
reconcile status of sub-accounts updated.

You should file that on bugs.gnucash.org

It *might* be designed that way however. I could be wrong, but I think
the idea for this feature is to be used for 'virtual' sub-accounts that
are used for segregating funds in your own books, but not actual
multiple real-world accounts with an institution.

The parent is the real account in such a case, so that might be why it
is the only one marked reconciled with a date. (it is the only one with
a statement to reconcile against)

In your case, you seem to be trying to reconcile multiple real accounts
through a placeholder parent. But GnuCash doesn't know that. (or
'reconciling' non-institution accounts, such as Expenses.)

Until it is 'fixed' or changed, I guess your option is to continue to
reconcile-finish the sub-accounts to update them, or else just reconcile
them all individually rather than together as sub-accounts.

Regards,
Adrien

On 10/3/22 4:56 PM, Uttam Chakravorty wrote:

My apologies Adrien, I will be more specific.  Line 2 - >Sales -> A/c No

01: all the subsequent lines starting '01-' are the subaccounts.
Reconciling 01 with subaccounts ticked will reconcile all of them, but only
update 01's date field.  I then step through the subaccounts and as they
are all already reconciled I just press 'Finish' to update their date.


Line 11 is a single entry with no subaccounts.


Line 12 is similar to Line 2, a Placeholder with three subaccounts.


I have tried to indicate the above in Column E, however I have made a

mistake with Lines 64, 71 and 77.  They have no subaccounts, I annotated
them in error as all the top level accounts are reconciled.  In terms of
consistency I failed to annotate Lines 12, 17 and 59.  Looking back this is
a scrappy piece of work put together in haste.  I hope you will be able to
extract something useful, or I will happily do it again.  Please advise.



Line 18 (A/c code 5 (should be 05)) is particularly interesting.  This

has subaccounts and they have Placeholders which have subaccounts i.e.
three levels deep.  Reconciling the top level reconciles all the other
levels, however once more it only updates the date at the top level.


I do not find it too onerous to live with this little extra keyboard

activity.  I just wondered if I was doing something wrong again.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.






--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Compiling under Ubuntu 18 thru 22

[Stephen M. Butler]

Someone on this list shared the following script with me to load the 
build dependencies.


I ran it back around Ubuntu 18.? and now am up on 22.04 with GnuCash 4.x

Come to think, there may have been a module update since then, but that 
will become obvious if you compile.


#!/bin/bash
clear
# this script was developed to install a basic development environment
# for GnuCash > V3 on a Linux Mint 19 OS
echo "Script to install development environment for GnuCash ~V3.0"
echo ""
echo "Installing build environment:"
echo "   build-essential"
sudo apt install build-essential
echo "   cmake"
sudo apt install cmake
echo "   ninja-build"
sudo apt install ninja-build
echo ""
echo "Installing GnuCash dependencies and development headers:"
echo "   libglib2.0 and dev headers"
sudo apt install libglib2.0 libglib2.0-dev
echo "   libxml2 libxml++2.6-dev libxml2-utils"
sudo apt install libxml2 libxml++2.6-dev libxml2-utils
echo "   libxslt1.1 libxslt1-dev"
sudo apt install libxslt1.1 libxslt1-dev
echo "   libwebkit2gtk-4.0-37 libwebkit2gtk-4.0-dev"
sudo apt install libwebkit2gtk-4.0-37 libwebkit2gtk-4.0-dev
echo "   gtk+3.0 libgtk-3-dev"
sudo apt install gtk+3.0 libgtk-3-dev
echo "   zlib1g zlib1g-dev"
sudo apt install zlib1g zlib1g-dev
echo "   guile-2.0 guile-2.0-dev"
sudo apt install guile-2.0 guile-2.0-dev
echo "   swig   3.0 on LM19  2.0 on Lm18?"
sudo apt install swig
echo "   sudo apt-get install libboost-all-dev"
sudo apt-get install libboost-all-dev
echo "   libsecret-1-0 libsecret-1-0-dev"
sudo apt-get install libsecret-1-0 libsecret-1-0-dev
echo " AqBanking Tools"
echo "   aqbanking-tools libaqbanking-dev"
sudo apt-get install aqbanking-tools libaqbanking-dev
echo "   gwenhywfar-tools libgwenhywfar60 libgwenhywfar60-dev"
sudo apt-get install gwenhywfar-tools libgwenhywfar60 libgwenhywfar60-dev
echo "   ktoblzcheck libktoblzcheck1-dev"
sudo apt-get install ktoblzcheck libktoblzcheck1-dev
echo " OFX support"
echo "   libofx libofx-dev"
sudo apt-get install libofx-dev
echo "   xsltproc"
sudo apt-get install xsltproc
echo " Database backend support"
echo "   libdbi1 libdbi-dev libdbd-pgsql libdbd-mysql libdbd-sqlite3"
sudo apt-get install libdbi1 libdbi-dev libdbd-pgsql libdbd-mysql 
libdbd-sqlite3

echo " Python support"
sudo apt-get install python3-pytest
echo " Google Test"
sudo apt install googletest
=

I do compile from a git repository located on my box at 
/home/steve/Projects/GnuCash/gnucash


The below script is run from /home/steve/Projects/GnuCash  (one level up 
from the git repository).  I just pulled the latest commits from the 
master and ran this script to compile:


#!/bin/bash
#
#  build-gnucash
#
# NOte:  do a git pull followed by git checkout of version desired 
before starting script


cd $HOME/Projects/GnuCash/gnucash

GITVER=$(git describe)
MYVER=${GITVER%-*}
MYRPR=Build-gnucash_${MYVER}
echo $MYVER

cd ..

rm -rf $MYRPR  > /dev/null

mkdir $MYRPR

cd $MYRPR

cmake -DCMAKE_INSTALL_PREFIX=/usr/local  ../gnucash

make

echo  ##  sudo make install
---

--Steve

--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Build From Source Near Impossible

[Stephen M. Butler]

Last build I did was on 21.10 (for 4.10-65-g7e4fcc7af+(2022-04-29)).

Now running 22.04 but haven't built the latest release yet -- may be a 
bit before I do.  Maybe 5.0 will come out first <>.

--Steve

On 8/9/22 11:37, Adrien Monteleone wrote:

Seems reasonable to me.

I'd think the only versions with instructions that are useful are 
those still supported by Canonical, namely, these LTS releases:


14.04 - EOL 4/24 (ESS 4/19)
16.04 - EOL 4/26 (ESS 4/21)
18.04 - EOL 4/28 (ESS 4/23)
20.04 - EOL 4/30 (ESS 4/25)
22.04 - EOL 4/32 (ESS 4/27)

Plus:

22.10, 23.04 & 23.10 (and other future non-LTS versions) when they are 
released and nuances are determined to need special instructions. 
(with those to be deprecated as they reach EOL)


Or maybe just only provide instructions for LTS and make a note that 
non-LTS versions aren't supported for long enough by Canonical to 
warrant their own documentation.


Note, the above EOL dates are based on Canonical's ESM (Extended 
Security Maintenance) available for both Enterprise and Personal Use. 
(free for the latter) See: https://wiki.ubuntu.com/Releases


That is 5 years beyond 'standard support'. (indicated as ESS above)

If the dev team wants to stick with the standard support window, then 
of course 14.04 & 16.04 can also be dropped.


Though, 16.04 was a breakpoint with respect to support for physical 
32-bit systems. At least some derivatives are still based on 16.04 for 
that reason. (a recent thread from a user described some difficulty 
getting a 4.x version to work on an older Linux Lite release.)


If someone can report their various results & mileage, maybe those 
older LTS releases can be sent to a sort of 'archive' page along with 
a note on the last version of GnuCash that could successfully build on 
them.


Of course, the recommendation can also be to advise the user to switch 
to a current distribution still actively supporting 32-bit hardware. 
(Debian/Devuan & Q4OS at least come to mind, I'm sure Distrowatch can 
inform concerning others.)


Regards,
Adrien

On 8/9/22 12:49 PM, david whiting wrote:

I think we should remove the instructions from
https://wiki.gnucash.org/wiki/Building_On_Ubuntu for 21.10. Anyone
have any objections to that?



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
.



--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Stumped on Mortgage Asst - Screenshots

[Stephen M. Butler]

want to see something else, sing out. Somewhere 
I am
missing a very basic concept. I'm trying to use the assistant to 
create a
scheduled transaction. The file names describe each step. The file 
and CoA
are dummies until I grasp this concept and move on to putting my 
401kk of

MUFUs into the tool.
- I've used my current statement, due 1 July to match up a 
amortization

website to show the P due on 1 July. Amounts and start dates in the
assistant are configured to match those amounts. Curiously, the 
website and
my statement show a different remaining balance, but that is outside 
the

scope.

- I step you through my assistant.

- In the end I show you the result of the assistant, which shows the
correct P Escrow is wrong, but I'm sure I can fix that in the 
editor.
I'll accumulate escrow each month and then schedule a payment from 
escrow

asset to tax and insurance expenses once all the above works.

- I let GnuCash enter the created transaction (ignoring from birth of
the loan) and the transaction for 1 July 2022 is actually the P 
for 1 May

2035.


TIA




--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Single Account Expenses For Current Year Only

[Stephen M. Butler]

In which case, the transaction report option would be the best way to 
get what he wants.


On 7/27/22 13:21, Gyle McCollam wrote:

Stephen,
He could have one account, but he could also have accounts for 
Hospital, Doctors, Dentists, Prescription, Medical Travel, etc. These 
could all be under a parent account, Medical, but everyone is 
different and they may not be.


Thank You,

*Gyle McCollam*

Gyle McCollam

gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email


*From:* gnucash-user 
 on behalf of 
Stephen M. Butler 

*Sent:* Wednesday, July 27, 2022 4:10 PM
*To:* gnucash-user@gnucash.org 
*Subject:* Re: [GNC] Single Account Expenses For Current Year Only
On 7/27/22 12:15, Jack Frillman via gnucash-user wrote:
>
> I want add up all my medical expenses from Jan. 1, 2022 up to today.
> How do I do that?
> I tried several different reports and all they gave me was the account
> balance as of today. I just want what was spent so far for this year.
> And before you ask I set the date range from 1/1/2022 to "today" in
> the drop down boxes.
>
> Thanks!
>

I presume you have an expense account just for the medical expenses?  If
not, why not?

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



--
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] Single Account Expenses For Current Year Only

[Stephen M. Butler]

On 7/27/22 12:15, Jack Frillman via gnucash-user wrote:


I want add up all my medical expenses from Jan. 1, 2022 up to today.
How do I do that?
I tried several different reports and all they gave me was the account 
balance as of today. I just want what was spent so far for this year.
And before you ask I set the date range from 1/1/2022 to "today" in 
the drop down boxes.


Thanks!



I presume you have an expense account just for the medical expenses?  If 
not, why not?


--
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] Single Account Expenses For Current Year Only

[Stephen M. Butler]

I can think of three ways:

1.  On the Accounts tab use the down arrow on the far right to add the 
"Total (Period)" column (and any others you want such as "Present").


2.  Run the Profit/Loss statement for the period of time desired and the 
account values will show for the period.


3.  Use the transaction report to pull up just the transactions you want 
and get the grand total of that report.



On 7/27/22 12:58, Gyle McCollam wrote:

Jack,
That is the advantage of "Tools/Close Book".  If you do that each year, the 
account balances are the YTD totals.  If you have grouped all your medical expenses under 
a parent account that will be the grand total as well.  This way you don't even need a 
report.  It's probably to late now, because if you did close your books each year, I 
guess you wouldn't even be asking this question.

Hopefully, someone that uses reports will be able to help you with the current situation. 
 Or you could close your books "as of" 12/31/2021 and you will then have the 
totals you are looking for.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: gnucash-user  on behalf of 
Jack Frillman via gnucash-user 
Sent: Wednesday, July 27, 2022 3:15 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Single Account Expenses For Current Year Only


I want add up all my medical expenses from Jan. 1, 2022 up to today.
How do I do that?
I tried several different reports and all they gave me was the account
balance as of today. I just want what was spent so far for this year.
And before you ask I set the date range from 1/1/2022 to "today" in the
drop down boxes.

Thanks!

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

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



--
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] Duplicate Transactions

[Stephen M. Butler]

On 6/27/22 13:43, Jesse MacDougall wrote:

Hi there, I am doing some bookkeeping and I went to add two new
transactions by right clicking a current transaction and selecting
duplicate traction.


This usually works rather well.

I changed the date and added amount but do not see the transactions in the
account GL.  However, the amounts did get posted as I see the total dollar
amount has changed.


Question:
1) how do I find the two transactions so I can delete them?


Look for a transaction with a really early date (you entered 2 digit 
year rather than 4 digit year).  Or, attempt to reconcile on of the 
involved accounts and look for an entry with a strange date.


2) Is there a better way to make a new transaction in an account GL
instead of duplicating a transaction and changing the data?


I usually just start typing an entry and if the system sees one with 
exact same leading portion it will offer that up as an easy to accept 
completion.  This will generally give me the additional line items 
(splits) and I just have to change the amounts.  This also allows me to 
then edit the initial description (such as an order #) after I've 
accepted all the splits.


Merci,






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

[GNC] Import importing duplicate trans

[Stephen M. Butler]

Today I tracked down a problem I've had with OFX import from Citi CC 
(Costco).


I did a partial month import a couple weeks ago.  Today I imported the 
entire statement period (so had several transactions already present).  
The import "lost" a new entry and "duplicated" an entry already imported.


The import bypassed the first fourteen (14) IDs in the file. However, 
the 14th transaction had not been previously loaded.  The 15th 
transaction (which it loaded) was already loaded by the prior import.  
Starting with the 16th transaction all the remainder loaded correctly.


Looking at the FTID numbers, I suspect that Citi assigns them by 
MMDD where the MMDD is the transaction date and  is a 
sequential number for this file.


I've seen transactions for the same date appearing in random order (not 
the order in which I remember the charges happening).


In this particular case, a couple more transactions for the last date 
previously downloaded (partial statement period) appeared and were 
assigned numbers earlier in the file than transactions already downloaded.


Hence, Citi assigned FTIDs do not stay with the transaction but are 
assigned at download time.


The lesson for me is to not download a partial statement period.

The implication is that the FTID from Citi is not trustworthy for match 
purposes.


--Steve

--
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] Fails under newest Ubuntu

[Stephen M. Butler]

On 4/30/22 15:40, David H wrote:

Steve FYI,

Re-compiled and working now although I did have to add the following 
to my build script..


sudo git config --global --add safe.directory $SOURCEDIR

Cheers David H.



Cmake was building files in my gnucash git clone directory.  I ended up 
having to destroy and download a whole new clone.  That seems to have 
fixed whatever strange problem cmake was having.   Make is currently 
compiling and I hope that finishes here in the next few minutes.


I'll have to pull up the git docs and figure out what your command line 
does and why it might be needed.


--Steve

--
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] Fails under newest Ubuntu

[Stephen M. Butler]

Thanks.  I saw last night that it was v70.  Will compile this afternoon 
(other higher priority items on my list so far today).


--Steve

On 4/29/22 03:39, Frank H. Ellenberger wrote:

Hi Steve,

if this is your self-build GnuCash, you will have to rebuilt it after
updating your -devel packages.

According https://repology.org/project/icu/versions Ubuntu updated to
70.1 while older versions used 67.1.

Regards
Frank

Am 28.04.22 um 23:06 schrieb Stephen M. Butler:

Just upgraded to Ubuntu 22.04.  Gnucash will not load:

gnucash: error while loading shared libraries: libicuuc.so.67: cannot
open shared object file: No such file or directory

I will have to track down what happened with that library.  May have to
compile again.

--Steve




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

[GNC] Fails under newest Ubuntu

[Stephen M. Butler]

Just upgraded to Ubuntu 22.04.  Gnucash will not load:

gnucash: error while loading shared libraries: libicuuc.so.67: cannot 
open shared object file: No such file or directory


I will have to track down what happened with that library.  May have to 
compile again.


--Steve

--
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] How to manage multiple accounts (as in separate gnucash?? databases)?

[Stephen M. Butler]

On 4/26/22 11:33, Robert Heller wrote:

At Tue, 26 Apr 2022 19:21:46 +0100 Chris Green  wrote:

On Tue, Apr 26, 2022 at 02:00:22PM -0400, Robert Heller wrote:

Under Linux, gnucash's "recent file memory" is in ~/.gnucash/books/. Maybe if
that directory is removed or made to be an empty "read-only" directory, you
might be able to "enforce" gnucash to have a memory loss...

rm ~/.gnucash/books/*
chmod -w ~/.gnucash/books


Yes, it seems a bit drastic though! :-)

It's actually /home/chris/.local/share/gnucash/books (or, strictly,
some system variable specifies the directory I believe).

Probably depends on the version.  I'm still using 2.6.19-1 on my Ubuntu 18.04
system.

Even opening GnuCash from a menu or icon (rather than the command
line) I'd really prefer that it didn't default to the last set of
accounts opened.
Yeah, that is unfortunate.  And really unfriendly.



I happen to really like that it opens the last set of books.  Yes, I 
have three (3) separate sets of books with each in a different folder 
(directory).


And having the list of recent opened files makes it really handy to 
switch between the three sets as desired.


--Steve

--
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] Scheduled transactions feature or bug?

[Stephen M. Butler]

On 4/12/22 11:59, Glenn Fowler wrote:

Thanks Gyle, that saves some steps.
However, I do agree with the OP in that you would think the expected
behavior would be to pause when disabled, and then when reenabled to not go
back to prior to that point.


How far back?  How far in the future?  That's why there are dates 
there.  If you want it to start this month, then change the start date.  
If next month then enter that date.  If last month or two months ago 
(because you are late restarting) then that date.


If all you do is remove the disable flag and you leave the dates as they 
were then the application is doing as instructed.


Many times as a developer I've wished for the DWIM hardware instruction 
to be active -- Do What I Mean (and not as I said).


--Steve



On Tue, Apr 12, 2022 at 1:34 PM Gyle McCollam  wrote:



You don't have to delete and create a new one,  just change the start date
in the one you have.

Sent from Samsung Galaxy smartphone.



 Original message 
From: Glenn Fowler 
Date: 4/12/22 1:03 PM (GMT-05:00)
To: Dale Alspach 
Cc: GnuCash-User 
Subject: Re: [GNC] Scheduled transactions feature or bug?

I'm glad I saw this post as I have a disabled scheduled transaction that I
was getting ready to renable myself. I guess the solution would be to
delete the recurring and enter a new one.

I would have also expected that enabling would start that day time
otherwise what would a disable button really be used for if it goes back
and enters transactions as if it was never disabled?

On Tue, Apr 12, 2022, 10:55 AM Dale Alspach  wrote:


I had a scheduled transfer to savings that I disabled for a few months.
When I re-enabled the scheduled transfer I did not change the start

date. I

was very surprised to find that when it ran that it entered transactions
for all of the months when it was disabled.
Automatically altering the past seems extremely dangerous. It  seems to

me

a warning should be given or scheduled transactions should only insert
future transactions.
Dale
___
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 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.



--
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] reconcile problem?

[Stephen M. Butler]

On 2/23/22 07:23, Paul Kinzelman wrote:

The latter is certainly possible, but it's strange that this started with
gnucash, didn't happen with Quicken. But if nobody else has noticed
this, then maybe it is the latter. :-)

And I have NEVER connected it to my account, as you suggested,
I ALWAYS enter everything by hand.

Oh, and I'm using the Windows latest version.

A while ago, I remember seeing a number of transactions which were
marked as reconciled become unreconciled as well, and it balanced after
I checked them as reconciled again the next month.

The real kicker was the one item I noticed that came up reconciled
this month as tho I had done it last month. And I couldn't have done it
last month or else it would have been unbalanced. And the charge
was not on last month's statement.

But if nobody else has seen anything like this, maybe it is something
I'm doing. But it's strange that I never saw it with Quicken, thus my 
post.


On 2/23/2022 7:51 AM, Derek Atkins wrote:

HI,

On Wed, February 23, 2022 9:35 am, Paul Kinzelman wrote:

I always balance my accounts every month. I used to use Quicken before
they went to a rental model. Credit cards always balanced every month
for me.

I've been using GC for several years now, and notice that I sometimes
can't
get cards to balance, I have to add an imbalance amount. Then this
month, I noticed that a charge that was on this month's statement
and not last month's statement was already marked as reconciled in GC.

Has anybody else noticed anything like this?

I don't even know how to track this kind of thing down, whether it's
a bug, or I'm just getting older and senile. :-)

without being rude, I would suggest the latter.
How are you entering your transactions?
I always enter them manually (I NEVER import), and when I have a problem
balancing I find it's *ALMOST ALWAYS* an error on my part (especially 
with
my wife's card, because I don't get receipts from any online shopping 
she

does).  When entering I find I sometimes swap digits, which causes the
result to be off.
Every once in a while I have to cancel the reconcile and start over and
CAREFULLY watch the numbers to find where I entered something 
incorrectly.


If you find you're off, then check again -- most likely something was
entered wrong.  Either that or you modified an existing, reconciled
transaction (from the other side) which caused a break in that starting
balance.


Ideas?

TIA!
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-derek


For my CC purchases I do an OFX download of the transactions for the 
most recent statement once a month.  It automatically marks the 
transactions as cleared for me (so I don't have to check them off at 
reconcile time) and almost always balances.


This month was one of the rare exceptions and it appears that one of the 
transactions to which I had to assign an account was duplicated with the 
following transaction removed.  Can't prove it at this time so I'll be 
watching to see if I can catch it happening again (and this time I'll 
keep the import file around!)


--
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] (no subject)

[Stephen M. Butler]

On 2/22/22 11:24, Thomas Boerner wrote:

Mario,

under Linux Gnucash stores its settings using dconf. You can view them with the 
dconf-editor). Inside dconf you will find your gnucash settings, including the 
file history, under org/gnucash/GnuCash (Older versions of GNC used 
org.gnucash).
In the filesystem it's in ~/.config/dconf/user, so this is the file you are looking for. 
Since nearly all applications store their user related settings under ~/.config/, it's 
worth a thought to backup this folder entirely (including "hidden" files with 
names starting with a period).
But I agree Steve that it's an even better idea to backup your whole home 
directory on a regular base.

Thomas

I added these commands to my .profile file so the backup will even get a 
list of current installed packages:


dpkg --get-selections > .BackupInfo/Package.list
rm -rf .BackupInfo/etc-apt/*
cp -R /etc/apt/* .BackupInfo/etc-apt
apt-key exportall > .BackupInfo/Repo.keys 2> /dev/null

So those run every time I log into my user account.  The nightly backup 
(deja vu) sends it's output to a NAS sitting on the network. That NAS is 
backed up regularly to off-line storage in one of my out-buildings.



--
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] Automatic sales tax << slightly off topic (but mail related) >>

[Stephen M. Butler]

On 2/21/22 10:52, Michael or Penny Novack wrote:

On 2/21/2022 1:09 PM, Stephen M. Butler wrote:

Here in Washington state the state does post an address file to 
assigns rate codes by address.  In at least one case two houses with 
the same zip+4 are in different location codes.  Most web hosts POS 
systems can only go down to the zip code level.  Thankfully I don't 
have enough sales outside the state to worry about taxes in the other 
states!


--Steve  (www.hamflags.com)


Do you know how they get the mail to the folks who live on Pt Roberts?

For those who don't know this, there are two little bits of the US 
(lower 48) that though not islands have no land connection to the US 
and this is one of them. Have to go through Canada. I guess since 
Puget Sound doesn't freeze they could use boats. Northwest Angle (MN) 
is the other and during the time Lake of the Woods is neither open nor 
frozen solid, boats would be out.


The only time I ever discussed this with PO "experts" they said they 
couldn't imagine sent in sealed bags through Canada << I didn't tell 
then that once upon a time Canada  had that sort of arrangement with 
us for mail to the Yukon -- Before the highway, the only way in was 
the railroad from Skagway Alaska to Whitehorse and mail came up from 
Vancouver by ship and then the railroad over the pass back into 
Canada. So why not reciprocal arrangements >>


Michael D Novack



According to an Internet search it appears they send mail via boat 
to/from Seattle.  Mail sent from Pt Roberts is post-marked Seattle. I 
presume incoming mail is sent out from Seattle by boat.


You're right, Puget Sound does not freeze -- but there are days that it 
feels that way!


--Steve

--
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] Automatic sales tax

[Stephen M. Butler]

On 2/21/22 07:00, Michael or Penny Novack wrote:

On 2/20/2022 7:58 PM, David Carlson wrote:
Here in Illinois it varies by county, city, merchandise category, 
service category, seller category and sometimes by such arcane 
variables as library district (well, that last one may be a slight 
exaggeration).


And not only is it that complex, but the DATA (what IS the 
jurisdiction that applies) is typically not available. Almost always  
the information by the vendor, just the postal address.


For example, while my town (township) does indeed have a PO with zip 
code 01338 that post office delivers no mail (just for PO boxes inside 
that post office). On the other hand, four different post office with 
zip codes 01330, 01339, 01340, and 01370 do deliver mail to addresses 
located in my town. So EVERY street address in my town has some other 
town in the address << well one of those isn't a "town" but a village 
on the boundary of two towns (townships) >>


There was a period during which when writing a letter to my 
Congressman I had to make it very clear, "Yes, I AM a constituent 
living in your district in spite of appearances" (the "town" on my 
address was outside his district)


And I can think of a merchandise category/seller category tax 
difference in my state. Buy a pair of gloves (clothing, not taxed) in 
a clothing store/department store vs buy the SAME pair of gloves 
(protective gear, taxed) in a hardware store.


BTW --- usually responsibility for figuring sales tax is in the POS 
system, not the accounting package being fed by POS (POS would also 
interact with the Inventory system). The accounting package is just 
one part of an "integrated business system".


Michael D Novack


Here in Washington state the state does post an address file to assigns 
rate codes by address.  In at least one case two houses with the same 
zip+4 are in different location codes.  Most web hosts POS systems can 
only go down to the zip code level.  Thankfully I don't have enough 
sales outside the state to worry about taxes in the other states!


--Steve  (www.hamflags.com)

--
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] mortgage calculator

[Stephen M. Butler]

You can do this by using Reply-To-List or Reply-All.

-derek




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

[GNC] Reconciliation conflict while editing split in account/sub-account being reconciled.

[Stephen M. Butler]

I just filed bug 798444 
<https://bugs.gnucash.org/show_bug.cgi?id=798444> describing a 
non-detected conflict between editing a split (setting the cleared flag) 
and reconciliation on that account (or it's parent) where the reconcile 
status was cleared after reconciliation finished.


I didn't realize that setting flag hadn't been committed before starting 
reconciliation.  This may catch users off guard and be the cause of why 
some splits "lose" their reconciliation flag.


--Steve

--
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] Adding late charges to a vendor bill after posting?

[Stephen M. Butler]

I setup an Asset account as a sub-account to the Bank's Saving account 
called "Sinking Fund". In a spreadsheet I list all the "one-time" 
[quarterly, semi-annual, annual] payments that need to be made.  Add 
these up then divide by 12.  This is how much you MUST move from 
checking to savings each month in order to have funds available as 
needed. You may need to preload an amount to keep from going negative 
sometime during the year.


I then setup an automated monthly transfer at the bank to fire each 
month to move that amount each month from checking to savings.


I also setup a monthly scheduled transaction in GnC to fire on the same 
day as the automated bank transfer.   This transaction is set to load 15 
days before the scheduled date so I can watch the checking account 
register to be sure the funds will be there for the automated transaction.


Then as each of these amounts come due, I move the funds from savings 
back to checking and then write the check to make the payment (in my 
account I setup the payment on the bank's system for them to draw the 
funds from checking).  Be sure to enter both transactions in GnC:

1.  Move the funds from Sinking to Checking.
2.  Make the payment on the date the bank says the check will arrive at 
the payee.





On 1/29/22 17:57, Eric H. Bowen via gnucash-user wrote:
Property taxes are due. Actually, by the time you read this, they will 
be past due... I used the "vendor bill" Payables system to track this 
when I got the tax bill in November and I've made a partial payment, 
but the funds just are not there to choke down the whole thing. So I'm 
going to get gigged for a late fee, and possibly even more if I can't 
settle up by the end of February.


What's the proper way to track this? If it gets to the point where I 
need to make a monthly payment arrangement (basically a 12 month note) 
I was going to enter the note as a new liability and credit that 
towards the tax payment due. But if I can get this cleared up by late 
February or mid-March then I'll just have a month or two of late 
fees/interest due. Is there a way to associate that with the tax 
payment after the bill has been posted? How should it properly be 
handled?


Asking for a friend

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



--
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] Printing reports

[Stephen M. Butler]

You have to open the "saved configuration" rather than the normal report.

When you click on the REPORTS main menu item, scan down and click on 
"Saved Report Configurations", then pick the one you saved.


--Steve


On 1/26/22 10:06, One-time queries wrote:

Back to using Gnucash after many years absence.  It seems to have changed from 
what I remember.

My  problem is that I want to set ‘Print to File’ as my default on the Print 
window.

Additionally I want to save the choices for a report so that I can print that 
report again without having to set in all the variables.  I want, for example, 
all accounts to be selected.  I want the default dates to be from the beginning 
of the previous year to the end of the previous year-  I have tried to save 
these using both Save Config and Save Config As… but when I try to open the 
report it is back to default, that is no accounts, beginning of this year and 
end of this year.

What am I missing?
___
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.



--
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] CSV Price Import: Saving Colum Assignments

[Stephen M. Butler]

I used to use the csv file import in version 3.8.  That remembered the 
column assignments, date format, and the main account (a liability account).


Sounds like this is a bug.

--Steve


On 1/25/22 13:40, Thomas wrote:

Dear list,

I have a fixed format of CSV-files to import prices for securities and 
I saved the respective preset in the CSV import wizard.
Unfortunately, only the assignment for the date is "remembered", while 
the other column assignments (e.g., namespace, symbol, value) are 
always set to none when I load the said preset.


Is this normal behavior and/or is there a way to also save the other 
assignments?


GnuCash
Version: 4.9
Version-ID: 4.9+(2021-12-18)
on ArchLinux


Thanks a lot in advance!

Best,
Thomas



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



--
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] Split transaction

[Stephen M. Butler]

Heidi,

Also, this sounds like a credit card being used for several purchases 
throughout the month.  In which case it is better to record the 
individual purchases as they occur.  Or, download the individual lines 
to import.


In that case, you will have a Liability:Credit Card:nameofcc account 
against which all the transactions will post with the other side of the 
post (the other split) being the relevant expense account.


When you pay the credit card off, you record the payment against the 
checking account on the one side and the Liability account on the other.


Otherwise, if you have a lot of purchases throughout the month there 
would be one humongous transaction with gobs of splits and you would 
lose the date for each purchase.




On 1/21/22 20:59, davidcousen...@gmail.com wrote:

heidi,

It would appear you don't understand the basis of double entry accounting which
is what is used in accounting practice generally and by GnuCash.

The Tutorial and Concepts Guide for GnuCash,
https://www.gnucash.org/docs/v4/C/gnucash-guide/index.html, has a brief outline
of the basis of this in Part I Chapter 2 as well as specific exaamples of
typical transactions for checkbooks and credit cards in Part II. Wikipeiad also
has entries for double entry accounting. There is also a detailed help manual
which explains the interface operations
https://www.gnucash.org/docs/v4/C/gnucash-help/help.html.

If you could read through the first part of the Tutorial and concepts guide, how
to use GnuCash may be a little clearer and make more sense.

Just a little bit on nomenclature. A single transaction always affects at least
two accounts (sometimes more) and the sum of the debits and the sum of the
credits for a single transaction must always be equal.

When you buy something using a debit card, to record the purchase you generally
reduce ( Withdraw or Credit) the balance of your bank account (an asset account)
and increase the balance of an expense account (Deposit or Debit) associated
with the type of item you are  buying. ( the above heading names are appliacble
for an account of type Asset but may be different for Liability,Income Equity
and Expense accounts) The names in brackets are the headings of the last two
columns in an account register display, the first in each  being the informal
headings many people use  and the second the formal accounting headings used  in
accounting practice. Which labels you use is a used preference set in the
dialogue opened with Edit->Preferences from the menu.

You would generally enter such a transaction from the register for your bank
account and it will have at least two lines. You can see the two lines for a
transaction (normally only a summary line is displayed) by selecting the View-

Autosplit Ledger option from the menu while you have the tab for the relvant

account register open. Clicking on a transaction to select it will open it as a
summary line folowed by each split line. You will see that each line of a simple
transaction has an entry in either the or DepositDebit or Credit Column (it is
possible for more complex transactions e.g. where tax is involved to have more
than two lines) and that the amount in one column equals the amount in the
other.

Hope this helps make things a little clearer. Come back if you have further
questions after reading the tutorial and Concepts introductory material.

David Cousens


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



--
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] Advice on restarting use of GnuCash

[Stephen M. Butler]

On 1/21/22 08:45, Derek Atkins wrote:

Hi,

On Fri, January 21, 2022 11:04 am, Peter Coleman wrote:

I used GnuCash for our household finances up until about two years ago. I
now want to start using it again with effect from 1.1.22. The version of
my software is 2.6.19 (probably about 5 years old).

I would like to keep the existing account structure, as I have saved lots
of detail there, but I want to enter a whole new set of opening balances.

Can anyone advise how I can best achieve this AND how I can install the
latest version of the software without losing the data that I want to
retain?

Thank you in advance for any assistance you might offer.

Use File -> Export Accounts

Save that as your new data file, and then File -> Open that new file.

I will also add that your version is WAY out of date.  We're already late
in the 4.x series!  You really should update.


Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-derek



I would recommend doing the update just after the export and before 
importing the account structure.  You should be able to jump to the 
newest version without having to install all the intermediate major updates.


As a safety backup plan, print out the Balance Sheet and P statements 
from the old data files before doing the export.  That way, if the 
import fails you at least have a list of the accounts with balances to 
do a manual setup.  That would be a last resort.


--
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] gnucash-user Digest, Vol 226, Issue 60

[Stephen M. Butler]

On 1/21/22 08:01, bonoposo007 wrote:

HELP!!! How can I print my profit/loss for 2021…reports only wants to print 
current year.I have googled and looked at manual, tells me to go to option in 
reports but there is no such tab in my file.

The system says I have 4.8



The Top row should end with the "HELP" menu item.  Just below that 
should be a box labelled STOP.  To the right of STOP is OPTIONS. Click 
on OPTIONS.  Note that this is on the second row that ends with PRINT.

___
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] Closing Books - Pros & Cons

[Stephen M. Butler]

On 1/3/22 14:50, Jesse MacDougall wrote:

Hi Ryan I am pro accountant.

Closing books means no one can post for that period anymore. So u close


GnC will let you continue to post transactions to prior years even 
though you may have executed the "Close Books" for that year.

books once your have completed your final review and maybe got some entries
from an accounting firm like me. You probs dont need an accounting firm
though so once all your transactions are in and your cash account agrees to
your bank account you now make your year end entries. Then close.


You dont create a new set of chart of accounts. They roll forward each
year. I think of chart of accounts as the framework of a skyscraper
building being built. Chart of accounts are your financial infastructure.

On Mon., Jan. 3, 2022, 10:31 Ryan Carver,  wrote:


Hi All,



I am using Gnucash for my small business (a design consultancy) and I have
no experience or knowledge of accounting.



Could someone please explain the PROs & CONs of using the “Close Books”
feature in layman’s terms?



The online database states that using the “Close Books” tool will result in
some report inaccuracies.  Could someone elaborate on which reports would
result in inaccurate reports?  I ran a few test reports after using the
“Close Book” tool and I did not notice any report inaccuracies.



Given my limited accounting knowledge it only seems intuitive that one
would always want to reset their chart of accounts for each fiscal year so
you can quickly see the correct period totals for each account.



I don't.  Closing the books for me just means I get to create an account 
in the Equities section that I get to label "Retained Earnings for 2021" 
(or whichever year I was closing).
It's not needed -- just my preference.  So, only the Income and Expense 
accounts and this one Equity account have entries made against them.  
Otherwise, everything else remains the same.


If you don't close the books, the Life-to-Date retained earnings will 
show up in that portion of the P  If you close the books, then there 
will be no retained earnings on that portion of the P (until you have 
transactions in the non-closed year). This will be because you booked 
them via the closing transactions to your own retained earnings account.







What does everyone else do when starting a new fiscal year?


As little as possible.







Thanks,

Ryan Carver
___
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.



--
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] Closing Books - Pros & Cons

[Stephen M. Butler]

On 1/3/22 14:23, Adrien Monteleone wrote:

The list archive is littered with such questions and answers.

I'm not sure if anyone put any definitive Pro-Con write up together.

The short answer is, you don't ever *need* to close because you don't 
*need* to reset your CoA.


GnuCash dutifully reports both 'from the beginning' and 'this 
year/period' just fine without doing so. (there are selectable columns 
on the CoA tab to do just that)


All reports default to 'this year' unless you've saved customized 
reports otherwise. (the exception being the Balance Sheet, which is 
always in any software 'since the beginning')


This saves you the need to make closing and then reversing entries 
each year. (and if you use the Business Features, you'll have to 
manually do your accrual transactions)


By not closing, you can run reports that cross annual boundaries with 
no issues should you ever find the utility in doing so.


If you do close, your P will be zero afterwards for that prior year. 
(because the closing entries zero out all expenses and revenue to 
equity as of the last day of the year.)


Not in my experience.  The P knows about the closing entries and will 
ignore them (unless you tell it not to).




So you'd have to run that report, save a copy, then close, then 
ideally save a backup of your file, then continue on. By not closing, 
you just continue on. You can run that report at any time with the 
same accuracy.


If you ever need to re-run that P (say after making edits or 
adjustments) you'd have to do so from within that backup copy, or else 
delete/reverse the closing entries, and go from there.


I've been known to delete the closing entries (just 2 transactions), 
make a change, and re-close.  It is a pain but if your wife is an 
accountant you mirror paper as much as possible!




In short, whatever the reason for having to 'close' in the past due to 
the limitations of number of pages in a physical book, or for 
organizational purposes relating to that, computers don't require the 
same. You can just keep going, and going, and going.


Personally, I don't close. I have no compelling reason to add work for 
myself or complicate my accounting life.


Regards,
Adrien


I do close.  Personal preference (so my spouse informs me).  YMMV

--Steve

--
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] Exporting Data

[Stephen M. Butler]

I have never used the opening balances from the wizard.  I setup the COA 
and then enter one multi-split transaction to load all the balances as 
the first transaction in the file.  Looks like you would only have 8 
splits (I have 30-50 in my initial transaction).  Since the transaction 
balances all is good.


Sorry I can't help with the Wizard.
--Steve

PS.  This also let's me adjust the opening transaction later if I messed 
up and missed an item or later decided to split an account retroactively.


On 12/30/21 14:07, Rogier F. van Vlissingen wrote:

in the 3.8 version I had:

My Opening balances transaction on 1/1/20 was
   Debit
Credit
Assets: Current Assets Checking:$A
Assets: Current Assets Advance/Loan:$B
Equity: Opening Balances:   $C
Equity: Retained Earnings:   $D
Liabilities: Credit Card:   $E
Liabilities: Officer Loan 1:   $F
Liabilities: Officer Loan 2:   $G
Liabilities: Officer Loan 3:   $H
---

And it all balanced. That is just exactly how simple it is.

in 4.9 I have not been able to recreate anything similar. for when you edit
the accounts, you can enter the opening balance, but not for Retained
Earnings.





On Thu, Dec 30, 2021 at 4:54 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


There is nothing special about opening balances. They are just regular
transactions that the fresh start wizard makes for you.

You should be able to edit those transactions just like any other.

But I don't understand what the problem is. Even the Retained Earnings
account would have an 'opening balance' entry if you didn't start your
books at zero. Thus the Opening Balance account would very likely
include Retained Earnings. Why do you think it shouldn't?

Regards,
Adrien

On 12/30/21 6:01 AM, Rogier F. van Vlissingen wrote:


However, now I end up with another problem to which I have yet to

receive a

satisfactory solution. When setting up the opening balances, the retained
earnings is not allowing editing, so it ends up that the Opening Balance
account now holds the total of the actual opening balances plus an amount
that should be retained earnings. In 3.8 I was able to set this up

properly

with one opening transaction, but in 4.9 I have not found the way. I

posted

about it on the list, but so far no usable suggestions. Only another user
having the same problem.

I used gnucash years ago without a problem for some small project, but at
this point , I feel like I am in a total Catch-22. I don't trust 3.8
anymore and so far 4.9 is letting me down.


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



--
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] Advancing scheduled transactions

[Stephen M. Butler]

Roger,

That would be nice.  Need to enter an enhancement request to have that 
added during the copious amounts of free time the developers have!


But, to get around that limitation, I do use the "Create in Advance" so 
it is in the register early (but for the scheduled date).  That way I 
can just adjust the date on the transaction that is already waiting.


That's the only way now to move a scheduled transaction earlier. Now, if 
you want an extra one, duplicate it from the prior month.


--Steve

On 12/29/21 16:15, rmom...@gmail.com wrote:


Steve,

Just want the option to trigger a post manually, not a permanent 
change in the schedule. As you do, I set up my scheduled transactions 
to post on the 1^st of the month regardless of the date of the 
transaction. I usually wait till the first to pay and post my bills to 
accommodate the scheduled transactions limitations. It would be like 
skipping a scheduled transaction for one month only the opposite, 
activating it early. Pick a scheduled transaction and tell the program 
to go ahead and post it today, on the 30^th of month prior to the next 
scheduled transaction date. Hope that explains what I’m looking for.


Thanks,

Roger

*From:* Steve Butler 
*Sent:* Wednesday, December 29, 2021 10:47 AM
*To:* rmom...@gmail.com
*Subject:* Re: [GNC] Advancing scheduled transactions

Not sure what you are asking.  Do you want to permanently change the 
date the transaction fires?


Or is this just a random change because it came early that month?

Note:  I generally have scheduled transactions automatically post 
15-20 days early so I can see their effect in the registers of 
interest.  If I note that the transaction posted on a date different, 
it is easy to change the date in that register.


I haven't tried editing the general/overview panel on a scheduled 
transaction to see if the scheduled date could be permanently changed.


On Wed, Dec 29, 2021, 08:24  wrote:

Is there a way to advance a specific scheduled transaction in
Version: 4.6
Build ID: 4.6+(2021-06-26). Be nice to have an option of advancing a
scheduled transaction for example when I get paid before the end
of the
month. I don't see a way to do that. Hasn't been one as far as I
know in
previous versions. Just be a handy feature.



Happy New Year,

Roger




--
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] how to remove both GNC 4.2 and Flathub version 4.8 so can upgrade to 4.9 on Ubuntu 20.04lts

[Stephen M. Butler]

On 12/24/21 11:58, davidcousen...@gmail.com wrote:

Stephen, Jeff

Try
$apt-cache search libboost


Found these:
libboost-program-options-dev - program options library for C++ (default 
version)

libboost-program-options1.74-dev - program options library for C++
libboost-program-options1.74.0 - program options library for C++


This will list the libboost options available to install from apt. If libboost-
program-options1.71-dev is not listed it is possible that there will be a
generic version libboost-program-options-dev  or libboost-program-options1.67-
dev or possibly even a more recent version if one exists. AFAIK the libboost-
program-options-dev will load the most recent available version of the library.
GC will work with v1.67 or 1,71 of libboost. Once you have identified a
candidate for libboost to install use
$sudo apt -y install libboost-program-options-dev


So did:
sudo apt -y install libboost-program-options-dev

and got:

Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
libboost-program-options-dev is already the newest version 
(1.74.0.3ubuntu6).

libboost-program-options-dev set to manually installed.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

21.10 must have the 1.74 version.

--Steve


--
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] last reconcilliation

[Stephen M. Butler]

On 12/19/21 10:20, Billie-Internet wrote:

Good Evening.
I am running gnucash 4.4 on win 10.
I have to admit, I have a  personal account that I have not reconcilled in
months.

Please tell me how to find the last reconcile.
I have looked at reports and seem lost.
Thanks,
Billie
706-383-9057


I see others have responded on how to get that date.  I'll just mention 
that I never worry about that date.  Could be a month ago or a year 
ago.  I just check that the everything listed on the intervening 
statements has been checked off in GnC and that the outstanding balance 
is at $0.  For me, online access to the account replaces the multiple 
statements.  Can be a long process if its been awhile,


If not zero then I either checked off something as being received that 
shouldn't have been or I don't have an entry in GnC that should be there.


--
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] Coloring the Action field

[Stephen M. Butler]

On 12/16/21 10:05, Michael or Penny Novack wrote:
It might perhaps be better to describe WHAT you want to accomplish 
instead of asking about possibilities for the first HOW that came to 
your mind. Why? Because there might be other "hows" even simpler.



On 12/16/2021 2:25 AM, AC wrote:


For example, I have a couple loans that are paid fixed amounts each 
month but the split of principal and interest varies (of course). I 
have automatic payments at the bank set up to pay those fixed amounts 
regularly and I have a matching scheduled transaction in GnuCash that 
is a placeholder for it so I know how much comes out of my checking 
account. What I don't know at that moment is the split between 
principal and interest.
I'll reword that -- you don't have access (in advance) to the 
amortization schedule and even if you did, would not help with an 
automated transaction (but would if a manual transaction_


  When the payment has gone through I will check the loan records 
wherever the loan is held to see how they distributed the payment and 
then go back and update the splits to reflect that.


I do a similar thing for my paychecks, setting up a scheduled 
transaction with an estimated amount across splits and then go back 
to update the splits with the various amounts withheld from the check 
(I mark these as "Deposit"). 


Let's stop here for a second to describe your PROCESS. In either case, 
you first need to be able to have an automatic transaction (unsplit) 
that you later need to go back to in order to split once you have the 
information to do that. You think you need a "marker" of some sort to 
find the transaction later, to mark the ones you have not yet done.


But what was the other side of the transaction?. Let's do the loan one 
first. That was an automatic (scheduled) transaction, credit to your 
bank account and debit to (there are always tow sides in double entry 
bookkeeping) what? Let's say for am moment you had an account under 
Expense with a name like "unallocated loan payments".


Every so often you look. Is the balance of this account zero? No, then 
you have a loan payment you have not yet allocated to principle and 
interest. Assuming enough time has passed that you have that 
information, Enter split mode. Change the account "unallocated loan 
payments" to "interest" and the amount to what that portion is. The 
remainder will now have an account Imbalance which you change to "loan 
principle".


Now THAT transaction will no longer appear in "unallocated loan 
payments" << and if there are no other payments still not allocated 
the balance of the account  will be zero >>


In  other words, the very presence of a transaction in "unallocated 
loan balance" can serve as your "marker" and is the transaction you 
want to split. You can do the same for your paychecks, except you 
would use an account under Income "unallocated paychecks".


Michael D Novack



Why not point to the loan wizard and how it can setup an automated 
transaction schedule?  Sure, it is off a few pennies every so often but 
if a person is looking at the loan details a their bank (or get a 
monthly statement) it is easy to adjust the existing transactions.


Once you understand the resulting schedule formula, you can modify for 
extra monthly payments and won't need the wizard to setup the next loan.


--
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] Directors loan - do I need an expense account?

[Stephen M. Butler]

On 12/9/21 19:38, Stan Brown wrote:

On 2021-12-09 11:04, Gyle McCollam wrote:

If the loan is to the company, as stated in your original email, it is a 
liability of the company.  Stan is incorrect, but if the company makes a loan 
TO the director, then it would be an asset of the company and he would be 
correct.


But the OP said:


... as I thought that was the closest thing to allowing money to be
moved out of the company, into my personal bank account.
When I tried to pay myself using GnuCash, I was expecting money to go
out of the company bank account,into my personal account, and reduce
the company's liability. However when I set up a bill, I could see it
was only possible to bill this as assets or expenses - *not as a
liabilitiy*. Does this mean I need to set up another account for
expenses?


"money out of the company into my personal bank account" -- that seems
pretty clear to me that the company is lending the director money, not
the other way round.


1.  Lending money.
2.  Paying a Dividend.
3.  Reimbursement for expense paid by individual.
4.  Reduction of equity share (stock buy-back).

All of those could be "money out of the company into my personal bank 
account".


--
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] An automated depreciation calculator would be really helpful.

[Stephen M. Butler]

 needs to start depreciating it from
then. It's not true to say this is just done once per year.

Of course, I'm well aware that many people will have suggestions on how to
improve the software, and the developer's time is limited. But some
automated way of depreciating items would be very useful. As they say, if
you don't ask you will not get, so there's no harm in asking!

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



--
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] Using Gnucash to access file over flaky network

[Stephen M. Butler]

On 11/24/21 07:54, Chris Green wrote:

On Wed, Nov 24, 2021 at 11:24:21AM -0400, Chris Mitchell wrote:

Hi all,

For reasons that are complicated but not especially interesting, I
would like to run Gnucash on one machine, with the data file located on
a remote machine — with the added challenge that the network access
available to the Gnucash "client" machine is a terrible cellular data
connection that sometimes drops without warning.

I have daily backups, so I don't need strong guarantees against data
loss, but if it's possible, I'd like to set things up so there's
reasonable resilience against a network dropout corrupting the remote
Gnucash data. I'm not the only user with access to the data, so (given
that multi-user is still a long way off), I need file locking to work.
Having to manually delete an orphaned lock file after a network dropout
is acceptable.

I assume that any of the database server backends would include this
kind of resilience "out of the box", and I'm not entirely unwilling to
try my hand at setting that up, but I am by no means a qualified
database administrator. If I can get sufficient resilience by easier
means, I'd prefer to stay away from the whole database server thing.

What about Sqlite over sshfs?  I realize Sqlite is not designed for
access to a database residing on a different machine, but my inexpert
impression is that its "atomic commit" implementation should protect
against sudden disconnection between the program and the storage medium
just like it protects against sudden power loss. (IE the transaction
that's in the midst of being written will be lost, but the database
should be fine.)

Can anyone confirm whether it's reasonable to expect that Gnucash with
Sqlite backend over sshfs would have working locking and decent
resilience against data corruption in this scenario? Or point out any
obvious "gotcha" I'm missing?


I think a better approach might be to simply copy the database to the
machine you're working on when you start GnuCash and then copy the
database back again afterwards.

Go so far as to create a script that would check for your own lock file 
before making the copy.  If lock file not present, then create it and 
copy the database.  Lock file could be as simple as renaming file with 
an extension of "xxx.IhaveIT".


Then the reverse script would remove the lock after copying the updated 
file back to the original name.


That way anybody else trying to update the file would know it was 
already "checked out".


--
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] Account setupI

[Stephen M. Butler]

On 9/28/21 10:16 AM, Rogier F. van Vlissingen wrote:

Thanks to everyone for helping out.

What worked for me in the end was

1. to set up the COA first, without attempting any opening balances, and
then
2. to create a single transaction to set up the opening balances on
1/1/2020.

As it was, I had an ending trial balance on 12/31/2020, but there were a
few mistakes floating around, so in my setup, I made those corrections, and
settled it against retained earnings, by making that the final line item in
my opening transaction.


- One thing I was not able to figure out. If I do set up this way, and I
made a mistake in my initial g/l transaction is there a way to edit that
transaction, or am I doomed to simply start over and do it the right way?
- And since I made a false starts, I now have a couple of sets of books
that I want to get rid of, but I wasn't sure how to do it, other than just
deleting the file in the file system.



<>

Rogier,  (my apology for not spelling it correctly on my last reply)

I have been able to edit that transaction even years later as I recently 
found some additional items that should have been entered -- but 
weren't.  I know the purist will say that you should just create an 
additional transaction for that date with the adjustments.  I am not a 
purist!  This works for me.


Yes, I am able to add new lines to the original transaction, change 
existing amounts, even delete a line that turned out to be a duplicate.


You can always edit a transaction.  This is a nice thing.  This is a bad 
thing.  This will help get you out of trouble.  This will get you into 
trouble.  Beware!  Your books are only as good as you make them.


--Steve

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