Re: [GNC] Share Values recording

[davidcousens49]

Finbar,

This is likely as specific as it gets or can get
https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_invest.html.

As others have mentioned the exact accounting treatment depends on the tax rules
in your jurisdiction and likely business regulations if you are conducting
investment as a business operation. 

From there you specify what information you need for:
a) tax purposes;
b) your management of your investments;
c) reporting purposes if your investment can be classed as a business activity.

This in turn defines what your account structure should be for investments. 

The examples in the guide will reflect fairly common practice in many
jurisdictions but the devil is always in the local detail. For that you either
need a local accountant/financial adviser you trust or you need to acquire the
skills to research the legislation and regulation in your jurisdiction and turn
that into accounting methodology.

David Cousens

On Thu, 2022-08-11 at 15:30 +0100, Mahon Finbar wrote:
> Hello,
> 
> I am trying to rationalise my shares (or things that have a moving 
> value) holdings.
> 
> I understand the basics of GNU,  in that I have been a user for some 
> time and have been able to record transactions, create reports to 
> satisfy the taxman, etc., but I keep getting bits and pieces of 
> information from the various places where my shares are registered, 
> mostly about values and dividends and the like.
> 
> I have a somewhat random selection of 'accounts' with information about 
> my (relatively small number) of holdings (a word that is a bit strong 
> for my situation)
> 
> What I am aiming to do is get a simple account or accounts where I can 
> just register what I paid, what dividends and other income stuff I may 
> have had and items such as current value.
> 
> Is there a simple source in the 'help' for creating that and what is it 
> called and what does it contain?? If not where should I start??
> 
> Sorry to be a neophyte, but I am a bit frustrated.
> 
> Finbar (located in Europe, but only really dealing in €)
> 
> ___
> 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-user Digest, Vol 233, Issue 34

[davidcousens49]

Adrien,

It does indeed  Menu->Administration->Backup Tool. I don't usually make use of
it as my NAS initiates and carries out my main backups for me and a couple of
crons do the rest. It looks like it can access network locations too. I have a
mixed Linux/Windows (can't convert the wife) setup which the NAS handles for me

David

On Thu, 2022-08-11 at 00:35 -0500, Adrien Monteleone wrote:
> If I'm not mistaken, Mint has a backup utility. So you can just set it 
> up and make sure the GnuCash locations noted in the Wiki and Guide are 
> included in the paths to be backed up.
> 
> Regards,
> Adrien
> 
> On 8/10/22 9:29 PM, davidcousen...@gmail.com wrote:
> > James
> > 
> > https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-backup1.html
> > 
> > The info https://wiki.gnucash.org/wiki/Configuration_Locations is also
> > useful
> > for backing up user preferences and things like customized reports.
> > 
> > To back up to a USB drive on Linux Mint, the drive should appear in the file
> > manager (icon that looks like a filing cabinet folder in the LH panel of the
> > Menu) once you have plugged it in and it is mounted. Navigate to andelect
> > the
> > folder containing the data file Ctr-c to copy it. Navigate to the USB hard
> > drive
> > and select a suitable directory to keep your backups in on the Hard drive
> > and
> > Ctrl-v to paste a copy there (or use the Edit items in the menu).
> > 
> > How to do actually backups is an operating system issue and not really a
> > GnuCash
> > issue. Gnucash's internal backup, logfiles and restore capability are
> > primarily
> > about recovering from a datafile corrupted by a GnuCash program crash,
> > rather
> > than general computer failures like a hard disk failure.  There are any
> > number
> > of articles on general computer backup strategies on the internet depending
> > on
> > the facilities you have available and how much you want to spend setting it
> > up.
> > A good practice is at least a backup to another local device in your
> > home  (USB
> > disk, NAS, another computer) and a backup to an offsite facility to protect
> > you
> > if your house burns down for example (USB stick kept by a relative ot cloud
> > facility)
> > 
> > On Linux you can create "cron" jobs to schedule automatic backups if this is
> > useful. For example I backup critical files to a cloud storage as well as
> > local
> > network storage on my LAN automatically daily and synchronize files between
> > my
> > laptop and desktop with Unison whenever they are connected so there are
> > always
> > multiple copies of my most recent datafile. My NAS is separately backedp up
> > to
> > cloud storage.
> 
> ___
> 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-user Digest, Vol 233, Issue 34

[davidcousens49]

James

https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-backup1.html

The info https://wiki.gnucash.org/wiki/Configuration_Locations is also useful
for backing up user preferences and things like customized reports.

To back up to a USB drive on Linux Mint, the drive should appear in the file
manager (icon that looks like a filing cabinet folder in the LH panel of the
Menu) once you have plugged it in and it is mounted. Navigate to andelect the
folder containing the data file Ctr-c to copy it. Navigate to the USB hard drive
and select a suitable directory to keep your backups in on the Hard drive and
Ctrl-v to paste a copy there (or use the Edit items in the menu).

How to do actually backups is an operating system issue and not really a GnuCash
issue. Gnucash's internal backup, logfiles and restore capability are primarily
about recovering from a datafile corrupted by a GnuCash program crash, rather
than general computer failures like a hard disk failure.  There are any number
of articles on general computer backup strategies on the internet depending on
the facilities you have available and how much you want to spend setting it up.
A good practice is at least a backup to another local device in your home  (USB
disk, NAS, another computer) and a backup to an offsite facility to protect you
if your house burns down for example (USB stick kept by a relative ot cloud
facility)

On Linux you can create "cron" jobs to schedule automatic backups if this is
useful. For example I backup critical files to a cloud storage as well as local
network storage on my LAN automatically daily and synchronize files between my
laptop and desktop with Unison whenever they are connected so there are always
multiple copies of my most recent datafile. My NAS is separately backedp up to
cloud storage.

David Cousens



On Wed, 2022-08-10 at 23:07 +, James Baxter via gnucash-user wrote:
>  
> Does anybody know how to make a backup of your hard drive. I am looking to
> back up Gnucash for the most part. I have a drive that i can plug into the USB
> port.
> ThanksJames baxterkangaro...@yahoo.com
> On Wednesday, August 10, 2022, 12:00:27 PM EDT, 
> 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.  Build From Source Near Impossible (flywire)
>   2. Re:  Banks with OFX or CSV account data downloads (Tom Browder)
>   3.  Possible Bug in Credit Note Display (Robert Simmons)
>   4.  Monthly period in charts should use end-of-month values, not
>   start (Colin Arndt)
> 
> 
> --
> 
> Message: 1
> Date: Wed, 10 Aug 2022 16:58:46 +1000
> From: flywire 
> To: Gnucash Users 
> Subject: [GNC] Build From Source Near Impossible
> Message-ID:
> 
> Content-Type: text/plain; charset="UTF-8"
> 
> Re: https://lists.gnucash.org/pipermail/gnucash-user/2022-July/102045.html
> > You're correct that the Python bindings aren't included.
> 
> I'd be happy with a non-standard download available that included the
> bindings. It wouldn't need gui support.
> 
> 
> --
> 
> Message: 2
> Date: Wed, 10 Aug 2022 05:19:27 -0500
> From: Tom Browder 
> To: Tracy 
> Cc: "gnucash-user@gnucash.org" 
> Subject: Re: [GNC] Banks with OFX or CSV account data downloads
> Message-ID:
> 
> Content-Type: text/plain; charset="UTF-8"
> 
> On Wed, Aug 10, 2022 at 00:00 Tracy  wrote:
> 
> > As with so many things, your mileage may vary, but...
> 
> Thanks so much, Tracy?that?s very helpful. Some of those banks are in my
> area.
> 
> -Tom
> 
> 
> --
> 
> Message: 3
> Date: Wed, 10 Aug 2022 11:18:42 -0400
> From: Robert Simmons 
> To: Mailing List Gnucash 
> Subject: [GNC] Possible Bug in Credit Note Display
> Message-ID:
> 
> Content-Type: text/plain; charset="UTF-8"
> 
> In the Entries part of an open credit note tab, the row focus can be
> assigned by clicking on a row. This changes the selected row from green to
> yellow. Also, it changes the value in the Subtotal column to zero. This
> appears to just be a software defect in the display: there are no changes
> made to the underlying data in the database. If you select a different row,
> the previously selected row's subtotal returns to normal and the newly
> selected row's subtotal changes to zero.
> 
> 
> --
> 
> Message: 4
> Date: Wed, 10 Aug 2022 11:57:56 -0400
> From: Colin Arndt 
> To: gnucash-user@gnucash.org

Re: [GNC] Banks with OFX or CSV account data downloads

[davidcousens49]

Tom,
There is another issue with putting up a list of banks known not to supply
OFXQFX or CSV downloads. The banks can up date there procedure and if the
information put up is wrong or becomes wrong, they may take issue with an
independent site posting that information particularly without some disclaimer
given the wide distribution of GNuCash. 

The best place to find out what a bank website can or can't do is usually from
their IT department, as they will be aware of such facilities even where teller
staff aren't. My bank in Australia has a general enquiry email to which I have
put this question in the past but asked that it be directed specifically to
their IT staff. I received an email back from the manager in charge of the IT
department who talked to me about my requirements, explained what was available
and how to use it as well as more general discussion of requirements. They still
don't have DirectConnectOFX (this was a security policy issue the IT department
could not bypass) but they did widen the range of export options and have
simplified export. 

David Cousens

On Tue, 2022-08-09 at 16:33 -0500, Tom Browder wrote:
> On Tue, Aug 9, 2022 at 16:11 David Carlson 
> wrote:
> 
> > Tom,
> > 
> > As Gyle mentioned,  the vast majority of banks, credit card companies and
> > even online
> > 
> 
> David, that the "vast majority" allegedly provide such capability doesn't
> help someone looking for a local bank providing such. Why do GnuCash users
> not want  to at least name banks they use and state whether or not they
> provide downloadable tranactions and in what format?
> 
> Is it a private issue?
> 
> -Tom
> ___
> 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-user Digest, Vol 233, Issue 22

[davidcousens49]

James,

If you are not seeing the transactions you have already entered and the 
accounts in the account tab it is possible that you have not saved the 
datafile. To do this use the File-Save As menu item immediately after starting 
GnuCash up. It will then automatically open the same file next time you 
startup. You are usually prompted to save the data file when a new file is 
opened however I have had the prompt dialogue get lots behind other windows on 
Linux Mint.
It is best if you create a directory in your home directory for the GnuCash data
file and then save it with a suitable filename in that directory. Gnucash
creates backup and log files each time it is run in the same directory as the
data files is located  and it is much neater to have all of these in a single
directory and it makes backup of your files simpler. There are also preferences
for autosaving the file periodically which AFAIK is set at ~20min by default. It
is best to exit by the File->Quit  (File ->Close only closes the account
register which is open) menu item to ensure the data you have entered is saved,
although recent changes ensure closing the window by other means will also force
a data save.

David Cousens

On Mon, 2022-08-08 at 19:11 +, James Baxter via gnucash-user wrote:
> David.Thanks for the email. I am not shore about data file. I did get a
> transfee going. But I should know next month if it works.
> ThanksJames Baxter kangaro...@yahoo.com 
> 
> Sent from Yahoo Mail on Android 
>  
>   On Mon, Aug 8, 2022 at 2:16 PM, David Carlson
> wrote:   James,Have you been able to create a test data file and enter a few
> transactions modelled on the information in the help manual?
> 
> On Mon, Aug 8, 2022 at 10:01 AM Fred Bone  wrote:
> 
> On 08 August 2022 at 13:54, James Baxter said:
> 
> >   I am looking for something that I may have already. I have had Linux Mint
> >   loaded on this laptop for about a month. also have been playing with
> >   Gnucash about 3 weeks. still getting us to this, As I find it very nice
> >   program.
> > As i dont know if I have a problem with the two of them, I don't know. So
> > if anybody know if Gnucash will bring down the items it needs to work
> > with. I am looking to do a schooling on Linux, go from there. thanksJames
> > baxterkangaro...@yahoo.com
> 
> Kindly pay attention to:
> 
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of gnucash-user digest..."
> 
> and please trim your posts.
> 
> ___
> 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] transfe money from one account to another

[davidcousens49]

James,

Have you read the help Manual sections on Accounts and Common Transaction
Operation https://code.gnucash.org/docs/C/gnucash-help/help.html- much more
useful than YouTube videos. Most of the Youtube videos dealing with GnuCash are
AFAIK not produced by any of the documentation team or the developers. You also
usually have no idea which version they are using. Transaction operations in
GnuCash are performed in the account register which opens in a separate tab in
the main window when you double click on the account in the chart of accounts
display in the Accounts tab (left hand side).

The GnuCash tutorial and concepts guide, particularly the introductory sections
has useful information about double entry accounting and some accounting basics
https://www.gnucash.org/docs/v4/C/gnucash-guide/index.html

David Cousens

On Sun, 2022-08-07 at 21:43 +, James Baxter via gnucash-user wrote:
> Yes, I see some people show yooou how to transfee money from one acc (Checking
> acc to Saving Acc)so when in that place. i am watching one person do that, but
> I dont see all of what he is doing. 
> the same page where you place your spending, but I dont see how you get the
> account on the page. 
> 
> I start with the checking acc, as i wish to place $25.00 into my saving
> account to keep the bank from charging me .so am I missing something. you need
> an account in there, But where.
> ThanksJames baxterkangaro...@yahoo.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] Request for two new features in GnuCash

[davidcousens49]

Eric

AFAIK you can do this by making a payment of less than the due amount from one
account and then makea second (or more) payment from another account to the same
invoice - just cant do it in a single step.

David Cousens



On Sun, 2022-08-07 at 19:17 +, Eric Hammond wrote:
> Thanks again to all who answered my two part question (next time I will make
> it two separate questions...)
> 
> Frank, I already have that selected. The problem is not how transactions are
> entered or displayed.
> If I am entering a manual transaction, I can add any number of splits no
> problem.
> The issue is specifically with the Bill, or Invoice, "Process Payment" form
> which only allows one payment amount, and one transfer account (from the
> account tree).
> If I bypass the "Process Payment" by using manual transactions the Bill or
> Invoice is not closed.
> 
> All the best,
> Eric Hammond
> 
> 
> Message: 6
> Date: Sun, 7 Aug 2022 06:19:40 +0200
> From: "Frank H. Ellenberger" 
> To: Eric Hammond , "gnucash-user@gnucash.org"
>   
> Subject: Re: [GNC] Request for two new features in GnuCash
> Message-ID: <1e0d8ed8-6ba0-b5b8-4190-8664b349f...@gmail.com>
> Content-Type: text/plain; charset=UTF-8
> 
> 
> 
> Am 07.08.22 um 03:04 schrieb Eric Hammond:
> > The second is the ability to pay bills from more than one source. Example I
> > purchase an oscilloscope and pay for it with a cash incentive from the
> > company and a bank transfer for the rest. My solution at the present is not
> > pretty, nor helpful if I look at it next year.
> 
> Then it's time to claim your easter egg ;-):
> Edit->Peeferences->Register Defaults,
> select Default Style: "Auto-Split ledger" or "Transaction Journal"
> 
> More details in
> https://www.gnucash.org/docs/v4/C/gnucash-help/set-prefs.html#prefs-reg-def
> 
> Then you can easily enter the differnt amounts.
> 
> Regards
> Frank
> 
> 
> 
> --
> 
> Message: 7
> Date: Sun, 7 Aug 2022 17:44:36 +1000
> From: flywire 
> To: Gnucash Users 
> Subject: [GNC] Request for two new features in GnuCash
> Message-ID:
>   
> Content-Type: text/plain; charset="UTF-8"
> 
> More cat skinning:
> 
> > * the ability to have two separate (at least) GnuCash file systems:
> *
> 
> In Windows (or probably any GUI) double-click file in data folder and it
> will use file association to open the file (in GnuCash).
> 
> Alternatively, for each file: right-click file, create a shortcut, drag
> shortcut to desktop. Same as above from desktop.
> 
> 
> --
> 
> Message: 8
> Date: Sun, 7 Aug 2022 06:28:50 -0500
> From: Tom Browder 
> To: Chris Good 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Third party OFX/CVS providers
> Message-ID:
>   
> Content-Type: text/plain; charset="UTF-8"
> 
> On Sat, Aug 6, 2022 at 21:25 Chris Good  wrote:
> > From: Tom Browder 
> > Sent: Sunday, 7 August 2022 12:37 AM
> > To: Chris Good 
> > Cc: gnucash-user@gnucash.org
> > Subject: Re: [GNC] Third party OFX/CVS providers
> > 
> > 
> > 
> > On Sat, Aug 6, 2022 at 08:51 Chris Good  wrote:
> > 
> > ..,
> > 
> > Can you copy the text out of the pdf statement?
> > 
> > 
> > 
> > Getting "organized" text programmatically out of PDF is a giant pain. My
> > current approach is almost completely programmatic. BTW, Raku is the
> > "sister" language of Perl, and it is a "scripting" language.
> > 
> > 
> > 
> > Raku can also use Perl modules so I can use Finance::Quote with it if need
> > be. But, until I can get the bank data working, I won't be needing it.
> > 
> > 
> > 
> > Thanks, Chris.
> > 
> > 
> > 
> > -Tom
> > 
> > 
> > 
> > Hi Tom,
> > 
> > 
> > 
> > I was actually suggesting you just highlight the transactions in the pdf
> > statement and copy/paste them into a
> > 
> > spreadsheet or text file before using a scripting language to reformat them
> > but if you can programmatically
> > extract the text that would be better long term.
> 
> But I did see Peter West's warning about checking results
> carefully--it's not always the expected result. Although I hope the
> products from the same source are consistent enough to make it
> reasonably fool proof. (See my comments below.)
> 
> > I notice with my PDF statement that (free) Adobe Acrobat DC no longer allows
> > me to select text (as they want me to pay for a fancy tool - BOO) but if you
> > send the pdf to Edge or Chrome you can select just the transaction text.
> 
> Yes, I now see my "PDF COmplete" on Windows can do that--I never
> thought of doing that until now.
> 
> > Thanks for the info re Raku.
> 
> You're welcome! I'm always happy for programmers to learn about Raku
> 
> > Finance::Quote is just for getting stock prices from websites (usually) so
> > not useful for this task.
> 
> Right, but good to know for later.
> 
> > Are you sure you cannot export transactions from your bank? All mine do
> > although sometimes it is hard to find.
> 
> Yes, and I agree it's sometimes hard to find. Yesterday I did find one
> bank 

Re: [GNC] Request for two new features in GnuCash

[davidcousens49]

Eric,

This is already possible, at least on Linux but I suspect also  in Windows too (
this link may provide a way 
https://support.microsoft.com/en-us/windows/add-an-app-to-run-automatically-at-startup-in-windows-10-150da165-dcd9-7230-517b-cf3c295d89dd
). On Linux Mint I can create multiple launchers for the GNuCash app and in the
launcher, which executes a terminal command of the form "gnucash " without opening a terminal, I specify different filenames. The only
difficucly is that the user and gnucash preferences will be the same with all
data files, which may or may not be a problem.

David Cousens


On Sun, 2022-08-07 at 01:04 +, Eric Hammond wrote:
> As I am getting more of my accounts completely into GnuCash I find the need
> for two things:
> The first is the ability to have two separate (at least) GnuCash file systems:
> one for my business and one for personal.
> My business is an LLC, and one legal requirement for that is there is no co-
> mingling of money. 
> This gives me some protection from certain law suites and tax issues.
> 
> I found an almost-work-around: two folders for Gnucash accessed with shortcuts
> that specified the target folder. It mostly worked, but was unstable and
> unreliable.
> 
> The second is the ability to pay bills from more than one source. Example I
> purchase an oscilloscope and pay for it with a cash incentive from the company
> and a bank transfer for the rest. My solution at the present is not pretty,
> nor helpful if I look at it next year.
> 
> Thank you for the great work!
> 
> 
> ___
> 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] Build From Source Near Impossible

[davidcousens49]

Rob 
There were originally breakout pages from the building on Linux for specific
information related to various Linux distributions including one for Ubuntu.
That seems to have now morphed into a general installation page for Ubuntu 
https://wiki.gnucash.org/wiki/Ubuntu and the Ubuntu specific build instructions
seem to have diasappeared completely and what is there is now useless as it
points back to the general build instructions for Linux (they were largely done
on Linux Mint but I tried to make them as generic as possible). I think the
intention was to collect all the Ubuntu related stuff in one point but that
somewhat defeats the point of a breakout page for build stuff specific to a
distribution,

david Cousens

On Sat, 2022-08-06 at 09:07 -0400, Robert Simmons wrote:
> First of all, Impish is already EOL. You will need to use a flavor of 22.04
> LTS for the following. The documentation for how to build GnuCash is
> confusing and not all in one place. The following begins with a fresh
> install of Lubuntu 22.04 LTS. I use Vagrant so that everything is
> deterministically built once I have finished figuring out the correct set
> of steps. But, Vagrant is not a requirement; you don't have to use that.
> The patch used below is the following. Put it in your /tmp directory before
> starting.
> https://pastebin.com/qUmxyyLq
> 
> sudo patch /etc/apt/sources.list /tmp/sources_list.patch
> sudo apt-get build-dep gnucash
> mkdir ~/opt
> wget
> https://github.com/Gnucash/gnucash/releases/download/4.11/gnucash-4.11.tar.gz
> mkdir build-gnucash-4.11
> tar -zxvf gnucash-4.11.tar.gz
> cd build-gnucash-4.11/
> cmake -DWITH_PYTHON=ON -DCMAKE_INSTALL_PREFIX=$HOME/opt ../gnucash-4.11
> make
> make install
> 
> 
> I hope this helps.
> 
> On Sat, Aug 6, 2022 at 7:03 AM crusadeon09 via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
> > I'm running Ubuntu, 21.10, Impish Indri.
> > 
> > I downloaded the 4.11 tarball, gnucash-4.11.tar.bz2
> > 
> > I followed these directions:
> > https://wiki.gnucash.org/wiki/Building
> > https://wiki.gnucash.org/wiki/Build_Tools
> > https://wiki.gnucash.org/wiki/Building_On_Linux
> > 
> > I tried changing repositories. I ran "sudo apt update" multiple times. The
> > dependencies for 4.11 simply wouldn't install.
> > 
> > (base) chris@chris-B550-AORUS-ELITE:~$ sudo apt-get build-dep gnucash
> > Reading package lists... Done
> > Reading package lists... Done
> > Building dependency tree... Done
> > Reading state information... Done
> > Some packages could not be installed. This may mean that you have
> > requested an impossible situation or if you are using the unstable
> > distribution that some required packages have not yet been created
> > or been moved out of Incoming.
> > The following information may help to resolve the situation:
> > 
> > The following packages have unmet dependencies:
> > libgtk-3-dev : Depends: gir1.2-gtk-3.0 (= 3.24.30-1ubuntu1) but
> > 3.24.30-1ubuntu1.1 is to be installed
> > Depends: libgdk-pixbuf-2.0-dev (>= 2.40.0) but it is not going to be
> > installed or
> > libgdk-pixbuf2.0-dev (>= 2.40.0) but it is not going to be installed
> > Depends: libgtk-3-0 (= 3.24.30-1ubuntu1) but 3.24.30-1ubuntu1.1 is to be
> > installed
> > libpython3.9-dev : Depends: libpython3.9-stdlib (= 3.9.7-2build1) but
> > 3.9.7-2ubuntu0.1 is to be installed
> > Depends: libpython3.9 (= 3.9.7-2build1) but 3.9.7-2ubuntu0.1 is to be
> > installed
> > libsepol1-dev : Depends: libsepol1 (= 3.1-1ubuntu2) but 3.1-1ubuntu2.1 is
> > to be installed
> > libwebkit2gtk-4.0-dev : Depends: libwebkit2gtk-4.0-37 (=
> > 2.34.6-0ubuntu0.21.10.1) but 2.36.3-0ubuntu0.21.10.1 is to be installed
> > Depends: gir1.2-webkit2-4.0 (= 2.34.6-0ubuntu0.21.10.1) but
> > 2.36.3-0ubuntu0.21.10.1 is to be installed
> > Depends: libsoup2.4-dev (>= 2.40) but it is not going to be installed
> > Depends: libjavascriptcoregtk-4.0-dev (= 2.34.6-0ubuntu0.21.10.1) but it
> > is not going to be installed
> > libxml2-dev : Depends: libxml2 (= 2.9.12+dfsg-4ubuntu0.1) but
> > 2.9.12+dfsg-4ubuntu0.2 is to be installed
> > python3.9-dev : Depends: python3.9 (= 3.9.7-2build1) but 3.9.7-2ubuntu0.1
> > is to be installed
> > Depends: libpython3.9 (= 3.9.7-2build1) but 3.9.7-2ubuntu0.1 is to be
> > installed
> > E: Unable to correct problems, you have held broken packages.
> > 
> > I tried loading them individually, but the names are just slightly off.
> > https://wiki.gnucash.org/wiki/Dependencies
> > 
> > Ubuntu sees them differently I guess. https://packages.ubuntu.com/
> > 
> > After a couple of hours of carefully trying to build from source, I give
> > up. Looks like Ubuntu Software Center has 4.11 in a flatpak.
> > 
> > Does anyone have any better instructions? I'd even submit to watching a
> > video at this point.
> > 
> > Sent with [Proton Mail](https://proton.me/) secure email.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription 

Re: [GNC] Confusing and inconsistent headers in transaction entry and report forms

[davidcousens49]

On Wed, 2022-08-03 at 20:28 -0400, Peter S. Shenkin wrote:
> Adrian,
> 
> I do have full account names turned on. I forget where I did that. I have
> no customized sort that affects the order of accounts within a transaction
> in either register view nor in the transaction report. (I prefer to sort
> the transactions by date in the transaction report, but that's just me.)
> 
> You point out correctly that in the register view, where transactions are
> entered, each line of the transaction (which is shown completely in my
> screen shot) shows the debit first (on the left) and credit second, as is
> customary. I had the labeling of the columns set to the out-of-the-box
> defaults of Increase and Decrease, respectively. This is highly misleading,
> because in fact both of these accounts increase as the result of the
> transaction. I later changed the labels to Debit and Credit, an available
> option, which is less misleading, but other than the labels, the
> transaction looks exactly the same in both the account register and the
> transaction report. That is, the Credit and Debit labels are still reversed
> in the transaction log.

Peter,

This seems to be counter to everyone else's experience with GnuCash and
definitely is not what occurs in the transaction report in GnuCash 4.11 on Linux
Mint 20.3.  I suspect if it was occurring specifically on either a MacOSX or
Windows systems we would have a large number of experienced users (and some of
us are accountants and pretty pedantic about such aspects) complaining pretty
loudly.  So we need to work out why your experience is completely opposite to
everyone else's or whether it is just a misinterpretation of what is being
displayed in the transaction report. In the transaction Report options there is
an option in the Display tab to display one transaction per line or one split
 per line.  Using the second option one split  per line, both debit and credit
entries for the transaction will be displayed  but entries not to the accounts
selected in the transaction report will be in the second(and subsequent lines
for transactions with more than two splits) and the different selected account
entries will be listed in sections with the account name at the head. The
transaction report is possibly the most general of the reports and is highly
customizable from the report options 

> 
> You seemed to express uncertainty about the account register. The way I
> enter transactions is to pick an account (for instance, by clicking on it
> in a balance sheet). That opens the register tab, set to that account. If I
> am remembering correctly, it will always list that account on the first
> line of the transaction, then you can add your currency total in either the
> Debit or the Credit column for that account. For the balancing account or
> accounts (in the case of a split), you similarly enter the currency total
> for each account on a succeeding line, in either the debit or the credit
> column, and select the account from a pulldown you can invoke from that
> line.


While this works, A balance sheet, depending on the report options may not show
all the accounts in your chart of accounts so it is limiting in which accounts
you can choose to open. How you open the register tab for an account does not
affect the order of display of the lines as it invokes the same routine to open
the register. Double clicking on the icon for the account (looks a bit like the
front of a colonial bank) in the Accounts tab will give you access to all non-
hidden accounts (hidden accounts can be found with the Edit->Find Account
dialogue).

> 
> There is no specified order in the register view for the accounts involved
> in a transaction; the account you selected to open the tab will always be
> listed on the first line nd the succeeding lines will appear in the order
> in which you entered them.

This is not necessarily the case. If you open an existing transaction in an
asset register in either Auto-split or Transaction Journal mode if it is a
credit transaction to the asset register (eg a bank account), the entry to the
account for the register which is open will appear on the last line not the
first. On the other hand if it is a transaction which debits an open asset
account register it will appear first. I.e. the debit components of the
transaction is listed in the lines before the credit components in all cases.

When you are entering a new transaction, if you do not specifically select an
account in the Account column where "Account "is displayed in Italics in the
first split entry, GnuCash will assume that it is the account of the register
that is open (but you can explicitly select another account for the first line,
in which case you have to explicitly select the account associate with the
currently open register in another line of the transaction to complete the
transaction. If you leave a subsequent line blank and press enter the
transaction will not be saved in the register.

You can 

Re: [GNC] gnucash-user Digest, Vol 233, Issue 9

[davidcousens49]

James,

>From your earlier posts you are using Linux Mint. I didn't connect with your
post in another thread before. 

If you have successfully installed GnuCash in Linux Mint it will appear in the
desktop menu which is activated by clicking on or hovering over an icon which
looks like LM in a circle in the bottom left hand corner of your screen. That
should bring up the menu. There are three columns in the panel. If you hover
over the icons in the LH column you will see a short description of the icon
function shown at the bottom of the menu panel towards the right. the icons in
this column are usually related to system configuration and software
installation.
The second column are categories/groupings of the installed  applications and
the third column shows the applications which are available in a category when
it is selected in the second column. 
r
GnuCash is normally installed in the Office category so if you click on the
Office icon, it should appear in the thirid column from which you can run it by
clicking on the Gnucash icon. 

The top icon in the second column of the menu lists all applications in
alphabetical order in the third column. If it has somehow been installed under
another menu category/group you should find it in that list. If you can't find
it the All Applications list, then it is likely you have not managed to install
it correctly. 

You can drag icons from the menu to a panel in the Taskbar just to the right of
the LM icon for quick startup of commonly used applications.

GnuCash should open the last data file you had open by default if you had saved
the data or it had been autosaved ( there is a User preference for doing that at
specified intervals (see Edit=>Preferences in the Gnucash menu). If a popup
comes up telling you it is locked, that means you exited the program without
closing the file. Use the Open Anyway button.

You can find online tutorials for Linux Mint and the Cinnamon desktop using a
Google search and there is also a Linux Mint forum you can join for more
difficult problems

David Cousens


On Wed, 2022-08-03 at 08:45 -0400, James Baxter via gnucash-user wrote:
> This is James Baxter, email kangaro...@yahoo.com
> Every time I down load the Gnucash. I lose it. Is there an icon or a dest top
> to click on.
> From what I see of the program. I am more interested in getting it going.
> 
> If working with ? I can click on the dest top item.
> Still getting use to this
> James Baxter
> kangaro...@yahoo.com
> 
> Sent from my iPad
> 
> > On Aug 3, 2022, at 8:37 AM, "gnucash-user-requ...@gnucash.org" <
> > 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:  MacOS - could not complete critical test of libdbi (john)
> >   2.  Gnucash (James Baxter)
> >   3. Re:  MacOS - could not complete critical test of libdbi (David H)
> >   4. Re:  Gnucash (davidcousen...@gmail.com)
> >   5. Re:  Gnucash (David Carlson)
> >   6. Re:  Gnucash (James Baxter)
> >   7. Re:  Gnucash (David Carlson)
> >   8. Re:  Gnucash (Adrien Monteleone)
> >   9. Re:  Gnucash (Mahon Finbar)
> >  10. Re:  Stumped on Mortgage Asst - Screenshots
> >  (steve.schwa...@fastmail.com)
> > 
> > 
> > --
> > 
> > Message: 1
> > Date: Tue, 2 Aug 2022 09:07:19 -0700
> > From: john 
> > To: km22 
> > Cc: Mailing List Gnucash 
> > Subject: Re: [GNC] MacOS - could not complete critical test of libdbi
> > Message-ID: <45d305ee-7f4c-4b64-a869-39510555c...@ceridwen.us>
> > Content-Type: text/plain;charset=utf-8
> > 
> > There may be some useful error messages in the trace file--see 
> > https://wiki.gnucash.org/wiki/Tracefile. If you're also on macOS and using
> > version 11 or later console output is available again after many years of
> > being sent to /dev/null. Open /Applications/Utilities/Console, select your
> > computer from the sidebar, click start streaming in the middle of the
> > window, and run your GnuCash or DBBrowser session. When done return to
> > Console, click the pause button, and use the search bar for terms like
> > gnucash and sqlite.
> > 
> > I've been encountering the DBI error intermittently in the last year or so
> > too. I can't make it happen consistently enough to debug it, and it has
> > never stopped me from being able to open a Sqlite3 file.
> > 
> > Regards,
> > John Ralls
> > 
> > 
> > > On Aug 2, 2022, at 8:47 AM, km22  wrote:
> > > 
> > > I 

Re: [GNC] Gnucash

[davidcousens49]

James 

You haven't really given us much information to go on to help you. What
operating system are you using and what version of Gnucash did you install. If
you run GnuCash it will tell you the version number in the splash window at
startup or as usual Help ->About will list the information. It would appear you
ar using Windows but we can give more specific help if we know what operating
system you are using

GnuCash will create a datafile in memory if you start it up without specifying a
specific file. You will need to use the File->Save As menu item to create an XML
datafile on disk or to save to a database file (sqlite3, mysqletc) if you are
using the database backend ( not a godd idea except perhaps the sqlite3 unless
you are familiar with database management.  GnuCash will place the data file in
your home directory at wahtever location you specify using File->Save As. It is
usually a good idea to create a sub-directory specifically to contain the
GnuCash data files as GnuCash creates backup and log files (these have a
datetime stamp before the .gnucash file extension after the filename you give
it) each time you open it in the same directory as the datafile.

GnuCash is a full double entry accounting system. If you don't know what this
means you really need to read the introductory chapter (Basics ) of the Tutorial
Guide and the Getting Started section of the Help manual. The Help manual will
show you how to setup a chart of accounts and perform the common operations.
GnuCash is not a follow your nose application on a phone. The file Import
instructions in the Guide are out of date and not correct (currently being
replaced) and the Help manual Ch 6 has complete and current instructions on
importing data from other programs and bank downloads.

Where possible try posting a series  screen captures of the problem you are
facing. We them have a better idea of where you are, particularly until you
become familiar with the terminology used in GnuCash to describe the various
components.

Good Luck

David Cousens

On Tue, 2022-08-02 at 15:26 -0400, James Baxter via gnucash-user wrote:
> This is James Baxter, email kangaro...@yahoo.com
> 
> To let you all know, I think I am done with the program. I am looking at a
> screen and it is wear you find all the icons. Not looking good.
> 
> I placed two months of my bank statement in two times. I can’t find where I
> placed.
> 
> Thanks
> James Baxter 
> kangaro...@yahoo.com
> 
> Sent from my iPad
> ___
> 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] Random List Maintenance Question: Regarding Nabble

[davidcousens49]

David  

Since the Nabble interface went down I've been using the mail-archive mirrors 
https://www.mail-archive.com/gnucash-user@gnucash.org/, 
https://www.mail-archive.com/gnucash-devel@gnucash.org/. You can't edit or
submit a postfrom them but I find it helpful when following and replying  a
discussion in a thread to have them open in my browser. I don't know if they are
mentioned in the Wiki or not.

David Cousens



On Tue, 2022-08-02 at 08:14 +0300, David T. via gnucash-user wrote:
> Hello, 
> 
> Since the Nabble mirror of Gnucash lists went down (last year?) and doesn't
> seem to be getting up again, is it time to remove references to it on the wiki
> and in every message filter? 
> 
> TIA,
> David T.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Confusing and inconsistent headers in transaction entry and report forms

[davidcousens49]

Peter,Yes it is working correctly in Gnucash 4.11 on Linux Mint 20.3  and has
always worked that way in the past.  The coding for the transaction reports is
in Scheme and separate from the main GnuCash code so I would not expect a change
in the preferences for the register display to affect the Transaction Report in
any case but it was a simple test.  A bug of that type in the main code will
likely be picked up very quickly  and similarly with the Transaction Report.  It
is hard to think why it would be specific to the MacOSX unless it was perhaps  a
bug in a  library on the Mac b ut John Ralls may have some more  insight..  I
have rechecked both the register and rerun the transaction report again and the
same items show up as debits and credits  in both the register and the
Transaction report on my machine. 
 Can you repost the same transaction in the checking account register using the
formal accounting labels and perhaps then rerun the Transaction Report. The
latter doesn't rerun automatically . You have to edit the report options and
then hit Apply. I usually change a date on the date range , run the report and
change it back and then rerun it to force it to regenerate the report as the
Apply button is greyed out unless you change one of the report options.There
likely is a clever way to do it as well.David
On Mon, 2022-08-01 at 23:08 -0400, Peter S. Shenkin wrote:
> Regarding my question ("Possible GC bug?"), I just reread your response and
> realized that you actually said that in your hands it works correctly; I had
> thought you said the opposite. 
> 
> So though it could possibly be a bug just on MacOS (unless you're also on
> MacOS), I rather suspect that there is something screwy in the settings
> somewhere.
> 
> -P.
> On Mon, Aug 1, 2022 at 11:04 PM Peter S. Shenkin  wrote:
> > Hi, David,
> > 
> > I did try using both Increase/Decrease and Debit/Credit labeling in the
> > register, but the transaction report is unchanged.
> > 
> > I also saw an option in Preferences for Reversing either Credit Accounts, or
> > Income & Expense Accounts, or None. I really have no idea what that is
> > about, but GC seems to have been supplied with Credit Accounts selected, so
> > I thought I'd try with None. It didn't change the transaction report, so I
> > set it back to Credit Accounts.  I'll RTFM on that sometime, but it doesn't
> > appear to have anything to do with this...
> > 
> > Possible GC bug?
> > 
> > -P.
> > On Mon, Aug 1, 2022 at 10:52 PM  wrote:
> > > Peter 
> > > 
> > > I do agree the Debit and Credit column headers appear to be reversed on
> > > the
> > > 
> > > Transaction Report in your original post . I have just run a Transaction
> > > report
> > > 
> > >  (GC 4.11) on one of my bank accounts and it reports my income (payments
> > > into
> > > 
> > > the account)  correctly as debits and expenses (payments from the account)
> > > as
> > > 
> > > credits. I thought it could possibly be related to the use of the non-
> > > accounting 
> > > 
> > > labels which I tend to use rather than the informal headers. I have just
> > > changed
> > > 
> > > to the informal headers in my preferences and rerun the transaction report
> > > and
> > > 
> > > the column headers are still correct so that does not appear to be the
> > > problem.
> > > 
> > > Did that transaction come out with debits and credits correctly in the
> > > account
> > > 
> > > register  when you selected the formal accounting labels preference?
> > > 
> > > David Cousens
> > > 
> > > 
> > > 
> > > On Mon, 2022-08-01 at 19:35 -0400, Peter S. Shenkin wrote:
> > > 
> > > > Hi,
> > > 
> > > > 
> > > 
> > > > I made up the name "transaction entry" because I didn't know what to
> > > call
> > > 
> > > > it.  I didn't know there was such a thing as a transaction entry
> > > window.
> > > 
> > > > 
> > > 
> > > > If I had the Donations account open, I would have had the same kind of
> > > 
> > > > problem. 
> > > 
> > > > 
> > > 
> > > > Per Gyle's suggestion it looks like I can switch to the good old Credit
> > > /
> > > 
> > > > Debit labels.
> > > 
> > > > 
> > > 
> > > > Also, the second part of my question involved the Transaction report.
> > > There
> > > 
> > > > the headings at the top seem backwards. They are labeled Credit and
> > > Debit, but
> > > 
> > > > where I entered a Debit, it appears in the Credit column and vice
> > > versa.  Any
> > > 
> > > > comment on this?
> > > 
> > > > 
> > > 
> > > > -P.
> > > 
> > > > On Mon, Aug 1, 2022 at 6:23 PM  wrote:
> > > 
> > > > > Peter
> > > 
> > > > > 
> > > 
> > > > > 
> > > 
> > > > > 
> > > 
> > > > > The terms Increase and Decrease in the header only apply to the
> > > account
> > > 
> > > > > whose
> > > 
> > > > > 
> > > 
> > > > > register you have open not to the accounts which are the target of the
> > > 
> > > > > 
> > > 
> > > > > individual split(entry) of the transaction and not to the account
> > > which is
> > > 
> > > > > 
> > > 
> > > > > designated in the second 

Re: [GNC] Confusing and inconsistent headers in transaction entry and report forms

[davidcousens49]

Peter 
I do agree the Debit and Credit column headers appear to be reversed on the
Transaction Report in your original post . I have just run a Transaction report
 (GC 4.11) on one of my bank accounts and it reports my income (payments into
the account)  correctly as debits and expenses (payments from the account) as
credits. I thought it could possibly be related to the use of the 
non-accounting 
labels which I tend to use rather than the informal headers. I have just changed
to the informal headers in my preferences and rerun the transaction report and
the column headers are still correct so that does not appear to be the problem.
Did that transaction come out with debits and credits correctly in the account
register  when you selected the formal accounting labels preference?
David Cousens

On Mon, 2022-08-01 at 19:35 -0400, Peter S. Shenkin wrote:
> Hi,
> 
> I made up the name "transaction entry" because I didn't know what to call
> it.  I didn't know there was such a thing as a transaction entry window.
> 
> If I had the Donations account open, I would have had the same kind of
> problem. 
> 
> Per Gyle's suggestion it looks like I can switch to the good old Credit /
> Debit labels.
> 
> Also, the second part of my question involved the Transaction report. There
> the headings at the top seem backwards. They are labeled Credit and Debit, but
> where I entered a Debit, it appears in the Credit column and vice versa.  Any
> comment on this?
> 
> -P.
> On Mon, Aug 1, 2022 at 6:23 PM  wrote:
> > Peter
> > 
> > 
> > 
> > The terms Increase and Decrease in the header only apply to the account
> > whose
> > 
> > register you have open not to the accounts which are the target of the
> > 
> > individual split(entry) of the transaction and not to the account which is
> > 
> > designated in the second split. It would appear that you have the register
> > for
> > 
> > your checking account open and a debit entry is an Increase in that.  If
> > there
> > 
> > was a credit split/entry to your checking account it would appear in the
> > 
> > decrease column. The second line of the transaction is the corresponding
> > credit
> > 
> > entry to the revenue account. This is why we accountants find the headers
> > 
> > Increase/Decrease confusing. 
> > 
> > 
> > 
> > You are not making entries in a "transaction entry" window in GnuCash but
> > you
> > 
> > are performing the transaction entry directly into the register for that
> > account
> > 
> > itself. 
> > 
> > 
> > 
> > David Cousens
> > 
> > 
> > 
> > On Mon, 2022-08-01 at 17:13 -0400, Peter S. Shenkin wrote:
> > 
> > > Hi, I'm using Gnucash 4.11 on MacOS 11.6.8.
> > 
> > > 
> > 
> > > There are two images attached, labeled Transaction entry and Transaction
> > 
> > > report. They are two different views of the same transaction, to a non
> > 
> > > profit that I am doing the books for.
> > 
> > > 
> > 
> > > The transaction involves a deposit to our checking account from Wepay.
> > It's
> > 
> > > a donation, which we account for under Revenue:Donations, which increases
> > 
> > > with a Credit, and the bank account will increase with a Debit, so this
> > 
> > > should be properly balanced.
> > 
> > > 
> > 
> > > However, from the Transaction-entry screen shot, where the column labels
> > 
> > > are Increase and Decrease, I have to enter the Donation as a Decrease in
> > 
> > > order to make the Donation record increase. This is bizarre, is it not?
> > 
> > > 
> > 
> > > You can see in the same image that the checking balance goes up. so it
> > 
> > > seems to be properly recorded as a debit; in addition, though not shown,
> > 
> > > the sum of Donations does goes up, which seems contrary to having to enter
> > 
> > > it as a Decrease.
> > 
> > > 
> > 
> > > Now look at the second screenshot, the Transaction-report view for this
> > 
> > > transaction. What is especially strange here is that the labels of the
> > 
> > > Debit and Credit columns are exactly reversed. It says that the Checking
> > 
> > > side of the transaction is a Credit and the Donation side is a Debit,
> > which
> > 
> > > is exactly backwards.
> > 
> > > 
> > 
> > > Any insight, including any aspect due to my own foolishness and/or
> > 
> > > inexperience, would be appreciated.
> > 
> > > 
> > 
> > > -P.
> > 
> > > ___
> > 
> > > 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 

Re: [GNC] Confusing and inconsistent headers in transaction entry and report forms

[davidcousens49]

Peter

The terms Increase and Decrease in the header only apply to the account whose
register you have open not to the accounts which are the target of the
individual split(entry) of the transaction and not to the account which is
designated in the second split. It would appear that you have the register for
your checking account open and a debit entry is an Increase in that.  If there
was a credit split/entry to your checking account it would appear in the
decrease column. The second line of the transaction is the corresponding credit
entry to the revenue account. This is why we accountants find the headers
Increase/Decrease confusing. 

You are not making entries in a "transaction entry" window in GnuCash but you
are performing the transaction entry directly into the register for that account
itself. 

David Cousens

On Mon, 2022-08-01 at 17:13 -0400, Peter S. Shenkin wrote:
> Hi, I'm using Gnucash 4.11 on MacOS 11.6.8.
> 
> There are two images attached, labeled Transaction entry and Transaction
> report. They are two different views of the same transaction, to a non
> profit that I am doing the books for.
> 
> The transaction involves a deposit to our checking account from Wepay. It's
> a donation, which we account for under Revenue:Donations, which increases
> with a Credit, and the bank account will increase with a Debit, so this
> should be properly balanced.
> 
> However, from the Transaction-entry screen shot, where the column labels
> are Increase and Decrease, I have to enter the Donation as a Decrease in
> order to make the Donation record increase. This is bizarre, is it not?
> 
> You can see in the same image that the checking balance goes up. so it
> seems to be properly recorded as a debit; in addition, though not shown,
> the sum of Donations does goes up, which seems contrary to having to enter
> it as a Decrease.
> 
> Now look at the second screenshot, the Transaction-report view for this
> transaction. What is especially strange here is that the labels of the
> Debit and Credit columns are exactly reversed. It says that the Checking
> side of the transaction is a Credit and the Donation side is a Debit, which
> is exactly backwards.
> 
> Any insight, including any aspect due to my own foolishness and/or
> inexperience, would be appreciated.
> 
> -P.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Gnucash

[davidcousens49]

James,

Please direct replies to the list not to individual list participants. If your
email client has a Reply to List feature  please us that or include the mailing
list address Gnucash Users , in the To: box. This
allows all list participants to see and learn from the posts and also to reply
to them. We often have different backgrounds and experience using GnuCash. We
also live in different jurisdictions around the world  so it allows people with
more experience relevant to your problem to reply.

You can display any account registers you wish. If you double click on icon at
the left of the specific account in the chart of accounts display in the
Accounts tab in the main window you will open the register for that account. You
can have any combination of accounts open in the window and open and open and
close them at will.

The GnuCash Help Manual https://lists.gnucash.org/docs/C/gnucash-help/help.html 
and the Tutorial and Concepts Guide 
https://www.gnucash.org/docs/v4/C/gnucash-guide.pdf also have a lot of detailed
information on working with GnuCash and covers typical operations for bank
acocounts and credit cards. 

David Cousens

On Mon, 2022-08-01 at 16:20 +, James Baxter wrote:
> Sir, 
> As i down loaded Gnucash last night. I manage to get it started. I place about
> 4 months worth of bank statments into it, Only to delite al buy this month. I
> was looking at a large amount in the red. I fixed that.
> 
> I am wondering if I can get all the acounts across the top. One bank acc,
> three Saving, on credit  card)
> 
> thanks
> James Baxter
> Ph,  4044142100

___
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] computer with Linux

[davidcousens49]

Thanks Adrien,

The Software Manager has an image which had 2.2.9 on it. I didn't scroll down to
the details, just assumed the image was of the installed version - my bad.

apt-cache policy gnucash 
also lists it as 3.8 the same package as the Ubuntu archive.

I hadn't realized LM 21 was out. I only checked a couple of weeks ago. 

David 

On Sun, 2022-07-31 at 20:59 -0500, Adrien Monteleone wrote:
> David, I just checked a VM of Mint 20.3 I have and the GnuCash version 
> is 3.8, not 2.2.9. Mint 20.x appears to be based on Ubuntu Focal. (20.04)
> 
> Still, yes, 3.8 is quite aged, but not as ancient as 2.2.9.
> 
> Mint 21 Vanessa was released and I see it has 4.8 in its repo. (based on 
> upstream Ubuntu 22.04, so presumably that's what Ubuntu Jammy users get 
> too, though I haven't checked)
> 
> That's much more reasonably 'recent' if someone doesn't want to tread 
> the Flatpak waters. Though, since it is so easy to install, I'd 
> recommend that route too.
> 
> Regards,
> Adrien
> 
> On 7/31/22 5:44 PM, davidcousen...@gmail.com wrote:
> > James,
> > 
> > I presume you downloaded Linux Mint 20.3. Did you choose the Cinnamon
> > desktop or
> > one of the pther options?
> > 
> > There are several options on Linux Mint to get GnuCash installed. The
> > version
> > supplied by the Software Manager is 2.2.9 which is well out of date with the
> > current version 4.11. If you haven't found it yet, the Software Manager is
> > started from the Menu icon in the lower LH corner of the desktop. It has an
> > icon
> > which is a lime green circle filed with an array of dots in a rounded square
> > icon. Typing GnuCash in the Search bar will bring up the instalation for
> > both
> > the version in the repository and the Flathub version. This is also the
> > version
> > of GNuCash installed when you use the "sudo apt install gnucash" terminal
> > command. If you do use the terminal command it is usualy a good idea to run
> > "sudo apt update" and "sudo apt upgrade" as a matter of course. This will
> > ensure
> > the  apt cache is up to date on your computer before you do the install.
> > 
> > There is also an option to install a Flathub version of GNuCash in the
> > software
> > manager and that will install the current version 4.11. Flathub is a sandbox
> > system which sometimes requires appropriate permissions to access the system
> > resource but should run without any problem. If you do have problems come
> > back
> > to the mailing list. AFAIK the Flathub version is the same as the download
> > of
> > the Flathub version from the GnuCashsite.
> > 
> > 
> > 
> > The final option is to build GnuCash from the source code if you are
> > familiar
> > with building software on computers and like to stay up with the latest
> > version
> > at all times. There are instructions on the Gnucash wiki
> > https://wiki.gnucash.org/wiki/Building_On_Linux
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] computer with Linux

[davidcousens49]

James,

I presume you downloaded Linux Mint 20.3. Did you choose the Cinnamon desktop or
one of the pther options? 

There are several options on Linux Mint to get GnuCash installed. The version
supplied by the Software Manager is 2.2.9 which is well out of date with the
current version 4.11. If you haven't found it yet, the Software Manager is
started from the Menu icon in the lower LH corner of the desktop. It has an icon
which is a lime green circle filed with an array of dots in a rounded square
icon. Typing GnuCash in the Search bar will bring up the instalation for both
the version in the repository and the Flathub version. This is also the version
of GNuCash installed when you use the "sudo apt install gnucash" terminal
command. If you do use the terminal command it is usualy a good idea to run
"sudo apt update" and "sudo apt upgrade" as a matter of course. This will ensure
the  apt cache is up to date on your computer before you do the install.

There is also an option to install a Flathub version of GNuCash in the software
manager and that will install the current version 4.11. Flathub is a sandbox
system which sometimes requires appropriate permissions to access the system
resource but should run without any problem. If you do have problems come back
to the mailing list. AFAIK the Flathub version is the same as the download of
the Flathub version from the GnuCashsite.



The final option is to build GnuCash from the source code if you are familiar
with building software on computers and like to stay up with the latest version
at all times. There are instructions on the Gnucash wiki 
https://wiki.gnucash.org/wiki/Building_On_Linux


Davis Cousens
On Sun, 2022-07-31 at 18:27 +, James Baxter via gnucash-user wrote:
> I have a 15 year old laptop computer. it has Linux Mint. i just down load it
> about 3 weeks ago.I am looking to down load Gnucash, as i am not able to. I
> have been through all the items to do with Gnucash, as i don't see a think on
> the type of computers.
> thanks
> 
> My Name is James Baxter. my email address is kangaro...@yahoo.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
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] Online Help manual CSV import section is out of date

[davidcousens49]

Frank

That sounds like a good way to deal with it. I will try and put an appropriate
patch  in place in the next week or two.

David

On Wed, 2022-07-27 at 10:12 +0200, Frank H. Ellenberger wrote:
> Hi David,
> 
> perhaps you can do it slightly different. I agree to remove all the
> technical details.
> 
> But you should insert a small tutorial with:
> Import in small chunks.
> Assign the proper account while importing to teach teach Bayes.
> Verify your data after each import.
> Save often!
> Other user misunderstandings and mistakes watched here on the list.
> 
> Regards
> Frank
> 
> Am 21.07.22 um 08:34 schrieb davidcousen...@gmail.com:
> > David,
> > 
> > I had a look at both Chapter 3 in the Tutorial and GUide on Importing and
> > Ch6 in
> > the Help Manual. What has happened was the decision was made to move the
> > importing section into the help manual a couple of years ago when I rewrote
> > the
> > Ch6 in the Help manual so I created the rewritten section in the Help manual
> > and
> > the original remains in the  Tutorial and Concepts Guide. It should have
> > been
> > removed but I neglected to do it at the time. There is no reference to
> > category
> > in the Ch6 of the Help manual. 
> > 
> > I will submit a patch to remove Ch3 in the Guide and will simply add a note
> > that
> > information on importing data is now in the Help manual.
> > 
> > Cheers
> > 
> > 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.

Re: [GNC] Trading accounts

[davidcousens49]

Fred,

Not early in the guide, but in the section dealing with multiple currencies
https://www.gnucash.org/docs/v4/C/gnucash-guide/currency_trading_accts.html and
discussed on the wiki (https://wiki.gnucash.org/wiki/Trading_Accounts). 

I don't think anyone has yet written anything about any application to trading
stocks and I don't think they are intended to be applied there. 

It is recommended to read the guide and help manual fully  before using GnuCash.
I didn't, like many other users, but I did have a general accounting background
coming in. You will find a lot of discussion in the mailing list archives re
stock trading and unrealized gains and losses..

If they were mentioned earlier it is likely they would confuse new users with
limited experience of double entry accounting and accounting practice. It is a
compromise to get new users in the door. 

Trading counts are about providing information in the accounts for unrealized
gains and losses involving currency transactions.

It is not normal accounting practice to recognize unrealized gains or losses in
the books as income/expenses and the circumstances under which they may be
recognized in some jurisdictions are likely to be highly variable. They are not
normally taxable until the gains are actually realized in the majority of
jurisdictions. That is why they aren't a default option.

I wouldn't think there is any need to redo past transactions unless the
information re unrealized gains and losses through currency exchange
transactions is necessary for some specific reporting process.

David Cousens

On Tue, 2022-07-26 at 18:46 -0400, Fred Tydeman wrote:
> Over the past several months, I have been importing Quicken data into
> GnuCash.  There is about 6 years of data and lots of transactions.  Besides
> normal income and expenses, that data involved many different stocks and
> many different currencies.  Recently, I saw a reference to "Trading"
> accounts.  I have now enabled that feature.  Based on reading
> https://www.mathstat.dal.ca/~selinger/accounting/tutorial, I believe that
> my old transactions that involve currencies (and maybe stocks and other
> assets whose value varies) were done wrong.
> 
> Do I need to redo old transactions involving currencies?
> Do I need to redo old transactions involving stocks?
> Do I need to redo old transactions involving any assets whose price
> varies?  This probably depends upon the asset, eg. no for Real Estate.
> 
> Is there an easy way to fix the mess I have created?
> 
> Aside:  I do not recall any mention of trading accounts in the Tutorial
> early on when it talked about setting up the Chart of Accounts.

> 
> What is the reason that Trading accounts are not turned on by default?


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

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

Re: [GNC] Another crash

[davidcousens49]

Phyllis,

This message means that the last time you exited, the data file was not closed
properly which would have happened when the program or your computer crashed.
If you select the Open Anyway option and this will clear the lock file and allow
the data file to be opened.  

GC 4.11 on Linux Mint has no problem creating a new account while the Import
Matcher window is open and I don't ever remember having any problem doing it in
earlier versions, i.e. the Import Matcher window is not modal- it doesn't have
to be shut down to allow you to do other operations. How are you trying to
create a new expense account -the easiest is to right click on the parent
account in the Accounts tab and then select New Account? This should bring up a
New Account dialogue and give it the correct position in your chart of accounts.
Behaviour can sometimes subtly different on Windows but the developers usually
make sure it as as close to the same on the different operating systems as is
possible.

One possible cause for a freeze is if the New Account window does not open at
the front of the display and remains hidden behind another window. If your OS
has a taskbar if you can find the window on that clicking on the icon in the
taskbar  will usually bring it to the front. I rarely use Windows but I think an
icon should appear even for a modal window in the taskbar - knaow even less
about Macs.

You can find information on the wiki for getting more complete logging debugging
information from the following wiki pages:
https://wiki.gnucash.org/wiki/Logging
https://wiki.gnucash.org/wiki/Windows_Debugging
https://wiki.gnucash.org/wiki/Tracefile
https://wiki.gnucash.org/wiki/Stack_Trace

David Cousens.

On Sat, 2022-07-23 at 20:05 -0500, Phyllis Bruce wrote:
> [image: image.png]Here is all of it.
> 
> 
> On Sat, Jul 23, 2022 at 8:00 PM Phyllis Bruce  wrote:
> 
> > [image: image.png]
> > 
> > Well, it has happened again but this time I snipped the message.  The
> > database froze while I was in the process of matching CC transactions.
> > Note the "Play file.gnucash"  Not taking chances on my real one anymore.  I
> > went to the task manager and ended the task.  This is the message that
> > appeared when I tried to reopen the program.  I was only a few minutes into
> > the process so it's no big loss.
> > 
> > I imported one month of QFX transactions and was matching them to the
> > expense ledger.
> > The category I wanted did not exist.
> > I needed to create a new category.
> > Freeze
> > 
> > If it's not the program, what can I be doing wrong?
> > 
> > Thanks as always for your support.
> > 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Online Help manual CSV import section is out of date

[davidcousens49]

David,

I had a look at both Chapter 3 in the Tutorial and GUide on Importing and Ch6 in
the Help Manual. What has happened was the decision was made to move the
importing section into the help manual a couple of years ago when I rewrote the
Ch6 in the Help manual so I created the rewritten section in the Help manual and
the original remains in the  Tutorial and Concepts Guide. It should have been
removed but I neglected to do it at the time. There is no reference to category
in the Ch6 of the Help manual. 

I will submit a patch to remove Ch3 in the Guide and will simply add a note that
information on importing data is now in the Help manual.

Cheers

David Cousens


On Mon, 2022-07-18 at 01:36 -0500, David Carlson wrote:
> I had not looked at the Tutorial version on importing transactions
> recently.  I see it is now calling itself obsolete and it really is.  I do
> not want to get into a discussion about which document should contain what
> information, but neither should be obsolete.  One of them should be very
> detailed and could be referenced by the other.
> 
> The help windows included with the import wizards are currently the best
> source of information but they are only available while using the wizards.
> Unfortunately it is a very slow process to complete an import if there are
> more than a dozen or so transactions in the file, and I think even that
> fact should be mentioned in the  help.  There is no help at all for
> importing multi-split line transactions which did work correctly for me
> with a bank account file created by the GnuCash export process.
> 
> The help manual bundled with the Windows version of release 4.11 at least
> contains a couple current illustrations if not good information about the
> various details that are needed to get good results.  It is the third
> import screen which is not illustrated in the help manual that contains the
> word category which has a different meaning to former Quicken users than to
> GnuCash users.
> 
> 
> 
> On Sun, Jul 17, 2022 at 11:45 PM flywire  wrote:
> 
> > I think the GnuCash Tutorial and Concepts Guide is an excellent
> > introduction for Getting Started and Managing Personal Finances. The small
> > dataset demonstrates a lot. The only thing that really looks dated is the
> > checkbook-style transaction descriptions which are very different to modern
> > bank transaction descriptions. I understand from general comments in the
> > mailing list that others have a different view but I don't think those
> > concerns have been clearly described, something that is needed to fix the
> > problems.
> > 
> > How about aligning the Help manual Importing transactions from files with
> > the Concepts guide transactions? IIRC that's how it was when this section
> > was in the guide. I'm happy to contribute.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> > 
> 
> 

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

Re: [GNC] Revising an old Gnucash file

[davidcousens49]

Tom,

You can make accounts hidden. Edit the account in the Account tab and select the
hidden button in the dialogue. You can always then use the right click in the
Accounts tab, select Find Account and unhide them in future. If you delete an
account you can choose another account for any splits to the deleted account to
be redirected to. 

David Cousens

On Tue, 2022-07-19 at 15:27 -0500, Tom Browder wrote:
> I have my original Gnucase file which has been continually used (for about
> 15 years)  mainly as a simple check book app to replace Quicken. I am
> motivated now to (1) improve the account structure and (2) start moving
> toward a properly used double-entry system so I can use the full power of
> Gnucash.
> 
> Is there any way to ignore accounts while incrementally working on tidying
> up my mess? Or should I just give up and start afresh (ugh)?
> 
> Thanks.
> 
> Cheers!
> 
> -Tom
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] New User Oh boy I need an accountant

[davidcousens49]

Phyllis,

The problem with the import is the negative sign on the Debit/Withdrawal column.
GnuCash expects this to be a positive quantity when the debits and credits are
in separate columns, i.e if both columns are specified then both columns are
positive. If the data is in a single column then negative for the debits and
positive for the credits (in the bank's account) will work fine. You would
normally apply only the Deposit header to that single column (if they import in
reverse order, then you would apply the Withdrawal header)

 In the third image, the import matcher window, the background color is yellow
because the second account ( you are importing to the GnuCash account
corresponding to your checking account) and you will need to assign, generally
an income or expense account and occasionally an asset or liability account in
most cases for the second entry (split in GnuCash terminology) for the
transaction. If the reason for this isn't clear, the introductory chapter of the
Gnucash guide (https://code.gnucash.org/docs/C/gnucash-guide/chapter_basics.html
) has a brief outline of the relevant accounting concepts.

David Cousens


On Mon, 2022-07-18 at 17:32 -0500, Phyllis Bruce wrote:
> I am getting too many unanticipated results.  Watched many YouTube videos
> since I cannot make sense of the Help manual.  I have added accounts where
> they appear to belong, added my opening balances, and imported a couple CSV
> files from a bank account.
> 
> Here is the CSV:   Note columns for Withdrawal and Deposit
> [image: 0fb3e81e-c69c-40b2-b876-6cd92092afe4.png]
> 
> [image: image.png]
> 
> Here is the bank journal showing the transactions and transfer accounts:
> Everything a deposit?!
> [image: image.png]
> 
> I'm not so far into this that I can't start over but it has taken me two
> days to create this mess.
> 
> Any help will be greatly appreciated.  Next question will be how can I
> enter my retirement income in a split transaction that shows total benefit,
> deductions and net income?  Of course the bank only records the net.
> 
> Best regards, po   (aka Phyllis Bruce)
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Online Help manual CSV import section is out of date

[davidcousens49]

I think David  Carlson was principally referring to the temrinology using"
category". When I rewrote  the importer section last time there was a major
reorganisation of the guide and help in progress and it was suggestsed that it
was more appropriate to the Help manual as it is largely a button by button
description of the interface, although it is hard to separate that totally from
illustrations of how to use it. I think he intention at that time was that the
help would be basically interface description and explanation and the guide
would be more oriented towards illustrating how to achieve specific accounting
objectives. I haven't caught up with what the current thinking.  I didn't cover
the appending of descriptions/memo and updating in any great detail at the time
as I hadn't been through the code on that section. I likely won't make too much
progress in the next week or two as I have a few other things on over the next
few weeks.  It is always a problem keeping it modernized as the external
technologies used are changing. In some ways I think it is better to keep the
basic stuff as simple as possible. GnuCash is used widely in many different
juridictions with considerable variation in practice in the banking sector.
Europe seems to lead the way and Australia is hanging on to the end of the tail
, at least in some respects. The demands of Digital Rights Management in the
banking sector will bring some improvements there I'm told by my son who works
as a developer in the area. One of the other David's (David Taylor I think ) was
organising the rearrangement of the Help Manual and the Guide around 2020. Feel
free to contribute any changes you think are warranted. 
David Cousens

On Mon, 2022-07-18 at 14:44 +1000, flywire wrote:
> I think the GnuCash Tutorial and Concepts Guide is an excellent
> introduction for Getting Started and Managing Personal Finances. The small
> dataset demonstrates a lot. The only thing that really looks dated is the
> checkbook-style transaction descriptions which are very different to modern
> bank transaction descriptions. I understand from general comments in the
> mailing list that others have a different view but I don't think those
> concerns have been clearly described, something that is needed to fix the
> problems.
> How about aligning the Help manual Importing transactions from files with the
> Concepts guide transactions? IIRC that's how it was when this section was in
> the guide. I'm happy to contribute.
___
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] Online Help manual CSV import section is out of date

[davidcousens49]

David,

That was likely my bad. I rewrote the Importer documentation a couple of years
ago after Geert had completed a major rewrite of the CSV importer and importer
code in general. I was working primarily from experimentation with the program
and only a passing acquaintance with some areas of the code. Unfortunately I
don't make a lot of use of the CSV importer these days as most of my imports are
now OFX. I have been sidetracked on some physics work over the past few years
and haven't revisited it recently. The working of the append feature at that
time wasn't very clear to me but there has been a bit of discussion in the
mailing list I can possibly draw on. I will try to make some time to search out
any recent changes in the append behaviour and update the docs and relook at the
use of category in that context. It may be useful to reference it explicitly to
the use of categories in other programs users may be importing data from, and
again point out explicitly that categories in other programs map onto accounts
in Gnucash. Most people importing from Quicken are unlikely to use CSV though.

David Cousens

On Sun, 2022-07-17 at 12:23 -0500, David Carlson wrote:
> reference:https://gnucash.org/viewdoc.phtml?rev=4=C=help
> 
> I wanted to report that one of the help pages for CSV file imports
> contained the word category, at least in the release 4.8 release, but I
> found that the release 4.11 online Help manual does not have the correct
> information specifically for importing in the GnuCash Export format.
> Specifically, it does not have an image of the third step instructions
> prior to the matching step which has the word category in it and it does
> not cover the new features optionally showing the matched fields or
> explaining what the append feature does.
> 
> I am not sure what is actually bundled with release 4.11
> 
> Unfortunately I do not have the time to try to fix this myself.
> 

___
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] Transaction imports

[davidcousens49]

Christian,

The import data matching information is stored in the individual data file. Not
sure about import configuraion information. See the following for more info.
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html

David Cousens


On Tue, 2022-07-05 at 14:52 +0200, Christian Lynbech wrote:
> Where is the information related to transaction imports saved? I am on a Mac.
> 
> I have my books stored under revision control but when I wanted to do an
> CSV import on a another machine, I did not see the import I have defined
> when running Gnucash on my main computer. I am guessing/fearing that
> this also applies to the learned matching of transactions to accounts.
> 
> How would I replicate such information between computers?
> 
>/Christian
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Uneven line spacing in Accounts list since 4.11

[davidcousens49]

My only experience of this in 4.11 on Linux mint was when I had the Notes field
displayed and had Notes with more than one line associated with an account.
Turning the display of the Note column off left the extra spaces unless I
collapsed and expanded the account tree.


On Sun, 2022-07-03 at 09:05 +, Gyle McCollam wrote:
> I am using 4.11 on windows 11, but not dark theme, and I don't have this issue
> either.
> 
> Gyle
> 
> 
> 
> Sent from Samsung Galaxy smartphone.
> 
> 
> 
>  Original message 
> From: Adrien Monteleone 
> Date: 7/3/22 1:00 AM (GMT-05:00)
> To: gnucash-u...@lists.gnucash.org
> Subject: Re: [GNC] Uneven line spacing in Accounts list since 4.11
> 
> Weird. Definitely not on Mac BigSur as far as I can tell.
> 
> Likely something OS specific.
> 
> Regards,
> Adrien
> 
> On 6/30/22 7:00 PM, dull...@gmail.com wrote:
> > I think since 4.11 (am using Windows 11 and a dark theme), I notice very odd
> > random line spacing in Account list window (the default window when I open
> > Gnucash)
> > 
> > 
> > 
> > I see the lines for each sub-accounts are not evenly distributed - spacing
> > seems completely random (some have space above and below, others do not)
> > 
> > 
> > 
> > I have attached a partial screenshot showing this uneven spacing for the
> > subaccounts  (if the mailing list supports attachments?)
> 
> ___
> 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.

Re: [GNC] Could Not Obtain Lock

[davidcousens49]

Might be time to upgrade to the latest version. This problem now does not exist
in V4.11 on Linux (Mint 20.3) and or Windows. You can close the app either from
the menu or by using the window close icon in the top RH of the window and the
lock is removed. A system restart with the app still open is still going to
leave the lock in place in which case you just select the Open Anyway on the
dialogue when it comes up. If you do upgrade check the wiki for instructions.

On Mon, 2022-06-27 at 10:22 +0200, rsbrux via gnucash-user wrote:
> I am still on GC v 2.6.19 under Ubuntu 18.04, and experience this problem
> frequently, even when I am *absolutely sure* that GnuCash was correctly closed
> after the last use.  At least in GC 2.6.19 it appears that GC does not allow
> for possible delays in mounting volumes in Ubuntu.  The problem has gotten
> worse since I offloaded the GC data file to my NAS.  If I wait to start GC for
> a few minutes after logging in, or start some other applications first, the
> problem does not occur.
> --
> 
> Message: 2
> Date: Sun, 26 Jun 2022 19:53:04 +
> From: Gyle McCollam 
> To: Abe Sternberg , Glenn Fowler
>   
> Cc: GnuCash users group 
> Subject: Re: [GNC] Could Not Obtain Lock
> Message-ID:
>   <
> blapr06mb68027ed731c14ff8d870bccfca...@blapr06mb6802.namprd06.prod.outlook.com
> >
>   
> Content-Type: text/plain; charset="us-ascii"
> 
> Abe,
> I have had this issue as well.  It usually occurs when I forgot to save before
> closing.  It asks if I want to save, but no matter the reply, it doesn't save
> and doesn't close properly.  I was told it was fixed and i am waiting the 4.11
> update as well.  Hope this solves your issue when released.
> 
> 
> Thank You,
> 
> Gyle McCollam
> 
> Gyle McCollam
> 
> gmccol...@live.com   email
> 
> 
> From: gnucash-user  on
> behalf of Abe Sternberg 
> Sent: Sunday, June 26, 2022 3:22 PM
> To: Glenn Fowler 
> Cc: GnuCash users group 
> Subject: Re: [GNC] Could Not Obtain Lock
> 
> I am using Windows 11.  I try to close GnuCash properly, though there have
> been times when I may not have.  Also, I have had some Windows updates while
> GnuCash was left open.  I will look for the update and advise if the error
> continues.
> 
> Thanks,
> Abe
> 
> On Sun, Jun 26, 2022 at 2:30 PM Glenn Fowler  wrote:
> 
> > Hi Abe,
> > 
> > Are you on Windows and how are you closing GnuCash? There was a bug 
> > that would cause this that is fixed in v4.11 being released today
> > 
> > On Sun, Jun 26, 2022 at 2:00 PM Abe Sternberg 
> > 
> > wrote:
> > 
> > > I get this message every time I open GnuCash. It doesn't seem to 
> > > cause any damage but is an annoyance.  Does anyone know what causes 
> > > this and how to correct it?
> > >  [image: image.png]
> > > 
> > > Abe
> > > ___
> > > 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.
> 
> 
> --
> 
> Message: 3
> Date: Sun, 26 Jun 2022 16:39:36 -0400
> From: Michael or Penny Novack 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Could Not Obtain Lock
> Message-ID: 
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> On 6/26/2022 3:22 PM, Abe Sternberg wrote:
> > I am using Windows 11.  I try to close GnuCash properly, though there 
> > have been times when I may not have.  Also, I have had some Windows 
> > updates while GnuCash was left open.  I will look for the update and 
> > advise if the error continues.
> > 
> > Thanks,
> > Abe
> > 
> a) "file in use" << that's what "cannot obtain lock file" means >> if CORRECT
> if you have not closed gnucash properly. This is not unique to gnucash but
> normal for any application using the "lock file" method of preventing multiple
> access to data.
> 
>  ??? IF you are certain the file is not in use (by another instance of
> gnucash) you can override if/when the application provides an easy way to do
> that. Or you can go into the directory (file folder) where the data file lives
> and delete the lock file -- it will always be in the 

Re: [GNC] Combining Method in Chapter 11 and Standalone Security

[davidcousens49]

Bite,

The overall methodology is the same although the calculation of the unrealized
gain or loss is slightly different from the example - there is no external
valuation just recording a stock price. A new valuation of a painting is
essentially the same as a change in an updated stock price stock price etc. To
calculate the unrealized gain or loss over a period it is the number of
securities held over the period x the difference between prices at the start and
end date of the period over which you evaluate the unrealized gains and losses
gain/loss = N*(price at end - price at start). You can choose any period which
is convenient for your purpose so long as you have obtained a price at the end
date of the period - it need not be at a fixed interval. The intervals do have
to be contiguous, i.e. the end date of one period is the start date of the next.
If you sell at a particular point it becomes a realized gain/loss for the number
of securities involved in the sell and the unrealized gain goes to zero for the
securities you have sold, but not for any you continue to hold and a buy
increases the number of securities in the calculation going forward. 
You will need to maintain your cost base for CGT purposes. To do this you would
use sub-accounts of the main stock account (of type stock) one for the recording
of the initial purchase cost and susequent any buy/sell operation and the second
to record the unrealized gains/losses as in Ch11. You will need a corresponding
income account which is not included in your taxable income against which the
unrealized gains and losses are recorded as in the Ch11 example.  A gain will
debit your security's unrealized gains/Losses account and credit your
Income:Unrelaized Gains and Losses account by the amount of the gain while a
loss will reverse the debit and credit accounts. As David T pointed out the
major problem is keeping the cost base evaluation valid if you are buying and
selling only part (lots) of the holding in any given security but this is
independent of the unrealized gains/losses.

David Cousens

On Fri, 2022-06-24 at 08:48 +0800, Gao Bite wrote:
> GnuCash developers & Maintainers:
> 
> Hello! I have found several issues when I am reading your "Tutorial and 
> Concepts Guide". When I reads methods in the 11th chapter,I have found 
> that its example is based on non-fungible asset like painting. However, 
> what I am expecting is that records capital gains for fungible 
> securities (stock, bonds, ETF, etc.). How can I apply method in this 
> chapter to these type of assets?
> 
> Yours,
> 
> Bite Gao
> June 19th, 2022
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Help

[davidcousens49]

Apologies Derek,

I hadn't seen you post before putting up my own reply. I tend to go through my
emails serially. I'll remember to switch the grouping by threads on in my
client.

David 


On Tue, 2022-06-21 at 19:41 -0400, Derek Atkins wrote:
> David,
> 
> On Tue, June 21, 2022 7:20 pm, davidcousen...@gmail.com wrote:
> > Eric,
> > 
> [snip]
> > To record the bad debt you would create a transaction which credited
> > Accounts
> > Receivable and debited Expense:Bad Debts. This will cancel out the amount
> > credited to Income in the original invoice. I had no difficulty creating
> > such an
> > entry in V4.10 with a test account setup for the business features. There
> > was no
> > limitation on the account selection when I created the transaction in the
> > Accounts Receivable register.
> 
> Just creating the transaction directly is not sufficient -- you still have
> to map it to the Customer to "pay" the invoice.
> 
> > The Help manual
> > https://www.gnucash.org/docs/v4/C/gnucash-help/busnss-ar-payment1.html has
> > a
> > description of how to do this using the process payment process which does
> > have
> > a restriction on processing the payment to an expense account. The key is
> > to
> > select an asset account (e.g. cheque account) when creating the
> > transaction in
> > Process payment and then after the transaction is created change the
> > account
> > from the asset account to the Expense:Bad Debt account. It is only the
> > process
> > payment procedure which has a restriction on the type of account you can
> > select
> > for a payment and there is no way that GnuCash could internally
> > differentiate
> > between a payment to an Bad Debts expense account and any other expense
> > account
> >  as there isn't a specific account type for bad debts.
> 
> Yes, which is the process I pointed out several hours ago.  :)
> 
> > David Cousens
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> 

___
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] Help

[davidcousens49]

Eric,

The image you attached did not appear to contain anything. Presumably you raised
an invoice when you billed the client which would have created an entry debiting
Accounts Receivable and crediting the appropriate income account. 

To record the bad debt you would create a transaction which credited Accounts
Receivable and debited Expense:Bad Debts. This will cancel out the amount
credited to Income in the original invoice. I had no difficulty creating such an
entry in V4.10 with a test account setup for the business features. There was no
limitation on the account selection when I created the transaction in the
Accounts Receivable register. 

The Help manual
https://www.gnucash.org/docs/v4/C/gnucash-help/busnss-ar-payment1.html has a
description of how to do this using the process payment process which does have
a restriction on processing the payment to an expense account. The key is to
select an asset account (e.g. cheque account) when creating the transaction in
Process payment and then after the transaction is created change the account
from the asset account to the Expense:Bad Debt account. It is only the process
payment procedure which has a restriction on the type of account you can select
for a payment and there is no way that GnuCash could internally differentiate
between a payment to an Bad Debts expense account and any other expense account 
 as there isn't a specific account type for bad debts.

David Cousens

On Tue, 2022-06-21 at 19:43 +, Eric Hammond wrote:
> I was not paid by a client, and have 'written it off', but how do I book it in
> GnuCash?
> Standard business practice is to post it in to an expense account such as 'Bad
> Debt' or 'Uncollectable'.
> I have created the account 'Expenses:Bad Debt' but GnuCash does not allow me
> to select it, apparently only accepting an asset account.
> 
> Thank you for the help,
> 
> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] rookie question Imbalance-USD

[davidcousens49]

Kevin,

We cannot really tell whether it is correct to remove the transactions to the
Imbalance account or not.  You can really only determine that by examining the
register of the account to which you think you should perhaps change the split
to the imbalance account. Before actually changing it check in that register for
that account and check if it would duplicate a transaction already present. If
so then it would likely be safe to delete. If not and you are reasonably sure it
is the right account you would change it and assign the Imbalance account entry
to it.

Any transactions to Equity:Opening Balance  accounts should be at or near the
date you first created the books and there should be an entry in Equity:Opening
Balances for each Asset or Liability account which existed at that date.

Ultimately your check on all of this will be when you run a reconciliations of
the  credit card account(s) and your bank accounts against the statements
provided by the bank. This should detect if you have incorrectly assigned one
end of a transaction to an asset or liability  account. It is generally not
possible to reconcile Equity ,Income and Expense accounts as there are no
external statements to reconcile them against.

David Cousens





On Mon, 2022-06-20 at 22:30 +, Kevin T via gnucash-user wrote:
> Sorry to have created such a row.
> Yes, clicking the split does indeed show me more information and is helpful to
> a point.
> I have made many blunders during this process that I am likely to pay for in
> time.  I paid little attention to the import account as I figured I would
> properly assign them at a later time.  Yes, I had used quicken many years ago,
> sorry.
> I appreciate the information all of you have provided.
> I have read some more about double entry accounting.  Again thanks.
> That said, I have 3 cases in the Imbalance account.  All are discussed with
> the split line showing.  I hope that you can see the screen shots included.
> a)  ones which are truly involving only one account.
> these I am assuming they are safe to remove as no other accounts are effected.
> 
> ..b)  one in which the transaction is showing two accounts and one of them
> is the imbalance account and one other 'proper' account.
> 
> The above is a credit card transaction.  In the double entry world, and if
> this were a a perfect world, the imbalance would be a different asset
> account.  In the real world, the asset account, not shown, does cover this
> transaction but is done in a single transfer of funds to the source CC
> account.  
> I have reconciled all the CC card accounts.  If done properly, should the
> imbalance account be the source CC account?  
> If I look at the CC accounts that I have made all the corrections, or imported
> more correctly, the transactions contain appropriate double entries, as below.
> 
> I think that these types of entries are also left over from imports not used
> or repeated.  They are almost all involving CC imports.  It would seem that
> these are also OK to remove.  They are double, and at times tripling, the
> expense account entries and values...c) this one involves opening
> balances.
> 
> what should a opening balance be offset with ?  To me, this is a magical
> entry, and its source, whether credit or debit, is of no importance.   There
> is only one Opening balance account in the equity group.  In am starting in
> the middle of the year and the accounts have existed for a while there are
> opening balances for all Equities, Liabilities, and Assets. Should there be
> others ?.
> My background is engineering, the transfer of electrons is well understood. 
> Accounting, and its nuances, are not.
> Again, thanks for all of your insight.
> Kevin 
> 
> On Saturday, June 18, 2022, 05:29:56 PM CDT, David T.  > wrote:  
>  
>  The confusion arises when you use "entry" for both splits and transactions in
> the same paragraph, as you did here. 
> 
> On June 18, 2022 4:57:57 PM EDT, Gyle McCollam  wrote:
> When I say entry, I refer to the entire transaction, but I get your point. 
> 
> 
> Sent from Samsung Galaxy smartphone.
> 
> 
>  Original message From: "David T."  Date:
> 6/18/22 4:24 PM (GMT-05:00) To: gnucash-user@gnucash.org, Gyle McCollam <
> gmccol...@live.com>, David Carlson , Kevin T <
> neviki...@yahoo.com>Cc: gnucash-user@gnucash.org Subject: Re: [GNC] rookie
> question Imbalance-USD 
> Gyle,
> 
> Whether you delete the imbalance account or not once it is empty is a user
> preference. Some dislike seeing the imbalance account in their books, and
> delete it if it is empty. Others (like myself and you) leave that account in
> place. I leave it because it just reappears again later anyways when you miss
> an entry. 
> 
> Also, I'll note that you made a misleading statement late in the first
> paragraph when you said that "If he deletes the entry, he will delete it from
> the other accounts as well." In this instance, I think you meant to say "If 

Re: [GNC] Direct Adjustment of Security's Price

[davidcousens49]

Bite

The transaction to record this, if a profit or increase in value of the security
is to debit the security by the amount of the profit and to credit an income
account by the same amount. For a loss in value creidt the security account and
debit the income amount. The profit or loss is the product of the number of
securites held  and the difference in prices between the date at which you are
recording the unrealized gain/loss and the price at the time you have previously
recorded a gain or loss Ultimately this traces back to the initail purchase
price.

You may find it useful to use a sub-account of the security (of the same type 
account) totalling into the security account to record the unrealized gains and
losses so that you preserve the initial cost basis which you will likely need
for capital gains taxes in most jurisdiction. Unrealized gains and losses are
generally not taxable as income in most jurisdictions, so you would need an
Income account separate from any Income account structure which records income
for taxation purposes.

David Cousens

On Sun, 2022-06-19 at 21:56 +0800, Gao Bite wrote:
> GnuCash developers & Maintainers:
> 
>  Hello! I would like to record the unrealized profit & loss from 
> security investment directly into an income account. Could you please 
> tell me whether I am possible to do as above, and if possible, how I can 
> achieve this?
> 
>  Yours,
> 
>  Bite Gao
> 
> June 19th, 2022
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] importing csv and negative numbers

[davidcousens49]

The difficulty is that the sign convention in a CSV file is normally determined
by the originating bank and there is no guarantee that it is what GnuCash thinks
it should be. 

Some banks will use a signed amount column to represent debits and credits,
others will provide a debit column and a credit column with an unsigned amount.
Most will use a convention where the file is prepared from there point of view,
i.e. deposits you make into the account will be credits and withdrawals from the
bank account will be debits in the file (and on the statement) but there are
always the banks who try to be helpful.

The importer has to be able to handle these combinations and any reversal of the
sign convention so there is some arbitrarinesss to the assignment of the Deposit
and Withdrawal headers to the appropriate columns in the CSV file in the
importer setup.

My bank uses a single signed amount column in which positive amounts are credits
on the statement and negative amounts are debits on the statement. Because the
statement is written from the banks accounting perspective and not yours the
positive amounts become debits and the negative amounts credits in your accounts
in GnuCash so I can assign the Deposit header to the single amount column in the
CSV file and it imports correctly. If I am importing a Credit card statement,
assigning the "Deposit" header also seems to work as GnuCash realizes it is
importing to a liability and not an asset account. If your bank follows the same
convention and has two columns you would assign the "Deposit" header to the
Credit column in the file and the "Withdrawal" header to the Debit column in the
file.

The best bet is to truncate a file to a couple of transactions and experiment to
get the setup right and then use that to import the complete file. Then if it
imports incorrectly you only have 1-2 transactions to delete before try the
other options.

David Cousens

On Mon, 2022-06-13 at 05:00 +, Kevin T via gnucash-user wrote:
> It seems that when importing CSV files, to a CC account, if the 'credit'
> column, which when imported is called the 'deposit' field, has a negative
> value in it, it is imported as a 'debit' transaction.  I have to refer to the
> statement, to find which of these transactions are supposed to be credits. 
>  IE i can't trust the import.
> is there any way to work around this behavior.
> Kevin
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Missing 2nd entry

[davidcousens49]

Fred,

If you go to the Accounts tab in the main window can you see either an Orphan or
Imbalance account with a non-zero balance. The transaction creation process and
the importer have never allowed you to create a transaction in GnuCash which is
unbalanced. I just tested it and tried to force creating an unbalanced
transaction in 4.10 (linux Mint 20.3) and you cannot do it. It automatically
creates the Imbalance account entry. Not sure if the datafile reading mechanism
enforces that condition when data is being read into GnuCash from a file or
database and a transaction record had been corrupted though. Have you manually
edited the datafile by any chance? Can you delete the transaction and if
necessary recreate it in balanced form?

David Cousens


On Wed, 2022-06-08 at 21:58 -0700, Fred Tydeman wrote:
> I just found a transaction that is not a double entry.
> It is just a single entry.  Not sure how that happened.
> When I click on Split to see the other side of the entry,
> there is nothing.  Clicking on Jump does nothing.
> 
> With that strange transaction as the current entry:
> Clicking on Actions->Check>This transaction
> appears to do nothing.  Same for All transactions.
> 
> With all account tabs closed (so only the top level Accounts shows):
> Clicking on Actions->Check>Check all
> runs for a minute or two and does not fix that entry, nor
> make a new account for Unbalanced or similar.
> 
> I wonder if this unusual transaction is the cause of the
> Trial Balance report crashing and giving me a traceback.
> Equity Statement report also crashes with a similar traceback.
> 
> I am running GnuCash 4.10+(2022-03-26) on Linux.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Export as text or CSV

[davidcousens49]

Fred 
Will a balance sheet report do what you want? That has the balances of all
accounts as of a specified date which can be set in the report options as well
as the account depth required.

David Cousens

On Sun, 2022-06-05 at 18:47 -0700, Fred Tydeman wrote:
> On Sun, Jun 5, 2022 at 5:02 PM David H  wrote:
> 
> > Fred,
> > 
> > File >> Export >> Export  to CSV doesn't do it for you ?
> > 
> 
> Already tried that.  It does not have the account values.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Export as text or CSV

[davidcousens49]

Fred 
Will a balance sheet report do what you want? That has the balances of all
accounts as of a specified date which can be set in the report options as well
as the account depth required.

David Cousens

On Sun, 2022-06-05 at 18:47 -0700, Fred Tydeman wrote:
> On Sun, Jun 5, 2022 at 5:02 PM David H  wrote:
> 
> > Fred,
> > 
> > File >> Export >> Export  to CSV doesn't do it for you ?
> > 
> 
> Already tried that.  It does not have the account values.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Transfer Dates

[davidcousens49]

If you import from bank 1 with the transfers to a Funds in transit account as
the transfer account rather than bank 2 and then import the records from bank 2
with the transfer account as funds in transit, the dates will be correct in each
of the bank accounts. The funds in transit account will end up with a zero
balance provided all the imports match up and you should be good to go.  

The Import matcher window only matches to transactions that exist in the account
you are importing to and as long as you don't import to the funds in transit
account, there should be no problem.  The matching in the funds in transit
account should be automatic ( unless there are transfer fees involved). Any non-
zero balance in it after you have imported all transactions will indicate
unmatched transactions. 
You can also use the multiple selection features in the import matcher window to
select all transactions which have the Funds in transit account as the transfer
account and assign that account in a single step.

David Cousens

On Sun, 2022-06-05 at 17:10 -0700, viking...@san.rr.com wrote:
> I am sorry David. I hit “reply” when I should have hit “reply all”, right? I
> sent the previous mail to the group as well.
> 
> I am importing because I am trying to create a new GnuCash file with a lot of
> transactions from different financial institutions; all of them are in CSV
> (xls). When done, I don’t intend to import anymore.
> 
> I am typically only going between two different banks. Most of the
> transactions are between Bank1 and another bank, e.g. Bank2, Bank3, Bank4 etc.
> In that sense a “Funds in Transit account” may work because most (but not all)
> transfers are from/to Bank1. In any case, I would still need to force it to
> not match when importing Bank1.  
> 
> 
> 
> 
> 
>  
> 
> From: David H [mailto:hell...@gmail.com] 
> Sent: 05 June, 2022 16:58
> To: viking...@san.rr.com; Gnucash Users
> Subject: Re: [GNC] Transfer Dates
> 
>  
> 
> Mate, keep it on-list so others can offer suggestions/chip in where relevant.
> Case in point I NEVER import anything so I can't comment on how the matching
> works, others that do obviously can. I ALWAYS manually enter txns that way
> when I reconcile I'm not reconciling the bank's txns against the bank's
> statement :-)
> 
>  
> 
> You have other options - as you say add something to the description column to
> say where the funds are going to in the long run - you didn't say you were
> transferring between more than 2 banks, so you're going from bank1 to bank2 to
> bank3 sort of ? 
> 
>  
> 
> Forget Quicken, you left it for a reason :-)
> 
>  
> 
> Cheers David H.
> 
>  
> 
>  
> 
>  
> 
>  
> 
> On Mon, 6 Jun 2022 at 07:55,  wrote:
> 
> If I use an intermediary “Funds in Transit account”, wouldn’t I run into the
> same issue when importing bank1? It would match the original transfer date of
> bank2 in the “Funds in Transit account”. I would need to force it to not
> match.  
> 
> A disadvantage of using a “Funds in Transit account” is that I wouldn’t easily
> see where the money was going (I am transferring between more than two banks).
> 
> 
> I was hoping that there was maybe some way of using another date column in
> GnuCash (like having a transaction and a post date). 
> 
> If I recall correctly, Quicken actually modified the dates when importing so
> that each bank showed the correct dates.
> 
> I guess that I could modify the CSV file of bank1 to include the bank1 dates
> in the description….
> 
>  
> 
> From: David H [mailto:hell...@gmail.com] 
> Sent: 05 June, 2022 14:15
> To: viking...@san.rr.com
> Cc: Gnucash Users
> Subject: Re: [GNC] Transfer Dates
> 
>  
> 
> If you want to be exact you probably need to use something like a "Funds in
> Transit" account - transfer from bank2 to funds in transit on date 1 and then
> transfer from funds in transit to bank1 3-5 days later.  Effectively you'd be
> splitting each transaction into 2 transactions.
> 
>  
> 
> Cheers David H.
> 
>  
> 
> On Mon, 6 Jun 2022 at 07:03,  wrote:
> 
> I have transferred money back and forth between bank1 and bank2.
> 1. I first imported my transactions from bank2. 
> 
> 2. I then imported my transactions from bank1. 
> 
> The transfers between the accounts are matched and are therefore not
> imported to bank1 (as expected).
> 
> However, the dates of the transfers are correct in bank2 but incorrect in
> bank1 because there is a 3-5 days delay for the transfers (and bank2 was
> imported before bank1). 
> 
> 
> Is there any way to log the correct dates in bank1 (while also retaining the
> correct date in bank2)?
> 
> 
> 
> ___
> 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 

Re: [GNC] Mass Reconcile

[davidcousens49]

Fred,

Ctrl + A Select all content in nearly all computer systems. 

The multiple selection with a mouse is:
Ctrl + Left click   Add the line to the selection;
Shift + Left click  Select all between the current line and the line clicked on;
SHift + Up arrow  Select one line up from current line;
Shift + Down arrow  Select one line down from current line.

This doesn't work in the main menus but does AFAIK in the Reconcile and the
Import Matcher Window. I have usually found with the CTRL-Left Click I have to
use it twice, once to activate the multiple selection mode and again to select
the item. Once it is activated a single ctrl-click seems to work.

Most of these are set in the GTK library and are not GnuCash specific which is
likely why they are not listed in the Wiki or guide. I haven't been able to find
a reference specific to GTK which defines the key combinations they set and
support by default but they do include many of the combinations listed in the
references below. The specific key combinations for a given function are also
sometimes OS and or distribution dependent ( Super is usually the Windows key).

Some common definitions used in many computer systems are defined in the
following:
https://help.gnome.org/users/gnome-help/stable/keyboard-nav.html.en
https://help.gnome.org/users/gnome-help/stable/shell-keyboard-shortcuts.html.en
https://support.microsoft.com/en-us/windows/windows-keyboard-shortcuts-3d444b08-3a00-abd6-67da-ecfc07e86b98

Feel free to add any keyboard combinations you find that work to the wiki. Just
ask for editing privileges.

David Cousens

On Fri, 2022-06-03 at 08:43 -0700, Fred Tydeman wrote:
> I got a private email to me (would have been better if it went to the list),
> telling me that in Reconcile, one can do Ctrl-a to select all items.
> 
> That keyboard shortcut is not mentioned in:
>   Tutorial and Concepts Guide (search for "keyboard shortcut")
>   https://cvs.gnucash.org/docs/C/gnucash-guide/txns-shortcuts1.html
>   https://wiki.gnucash.org/wiki/Keyboard_Shortcuts
> 
> Nor, is there a mention of Shift-Up-Arrow or Shift-Down-Arrow
> 
> On 5/22/22 12:16 AM, Fred Tydeman wrote:
> > > I added over 300 dummy #yymmdd accounts and am using them as tags in
> > splits
> > > in transactions (to simulate Quicken classes).  I now realized that those
> > > splits are not reconciled.  It is a slow process to  reconcile them one
> > by
> > > one.  Is there an easy way to pick many of those #yymmdd accounts and
> > have
> > > them all be reconciled at once?
> > 
> > ___
> > 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.

Re: [GNC] Balance Sheet mismatch

[davidcousens49]

Fred,

The price database is stored in your main datafile for the set of books. You can
edit it from the Tools->Price Database  in the menu.

David Cousens
On Thu, 2022-06-02 at 21:50 -0700, Fred Tydeman wrote:
> I have made a test file with just two transactions:
>   Opening Balance in GBP on 3/13/2011
>   xfer and convert to USD 1/1/2016
> So, those two transactions put two entries in the Price database for GBP.
> I then added a third price between those two dates on 1/11/2013
> The Balance Sheet shows a mismatch if run on 1/11/2013 or any date after
> that date
> but is OK if run on 1/10/2013 or any date earlier
> The value of the GBP (reported in USD) is changing in the Assets section of
> the report,
> but the Equity section is remaining constant.
> Should the Equity section show an Unrealized gain/loss?
> This looks like a bug to me.  I am not sure how to report, or what is
> needed.
> The test2.gnucash file is around 5000 bytes small
> Now sure where the Price history is kept, nor the Report options.
> 
> 
> 
> On Wed, Jun 1, 2022 at 7:56 AM Fred Tydeman  wrote:
> 
> > 
> > On Wed, Jun 1, 2022 at 6:45 AM Fred Tydeman 
> > wrote:
> > 
> > > I am now trying going back in time to see when the first imbalance starts.
> > > How do I get a list of transactions in a specific date range?
> > > Is there a way to find stock/mutual fund prices of zero(0)?
> > > 
> > 
> > First mismatch happens back in 2012.
> > It appears that using Report Options / Commodities / Price Source of
> > Closest to report date   is a problem when the date of the report
> > is between two dates of a Foreign currency exchange rate in Price Database.
> > However, that is not the only problem, as now using
> > Last up through report date for Commodities, I get a mismatch
> > when the Balance sheet report is the same date as a Price Database entry
> > of a foreign currency.
> > 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Import is finding no matching transactions

[davidcousens49]

Aaron,

>From your description it sounds as though you have created sub-accounts of your
checking account to implement a budget process. If this is the case, it is the
opposite of normal accounting proceduress. To account for expenditure in a
specific category the generally accepted procedure is to create sub accounts of
Expenses for specific expense categories. You can get information on the
Budgeting features in the Tutorial and Concepts Guide 
https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_budgets.html and from
the wiki https://wiki.gnucash.org/wiki/Budget_Requirements detailing a bit more
of the background.

David Cousens


On Tue, 2022-05-31 at 15:17 +, Thepwnd via gnucash-user wrote:
> Hi all,
> 
> I wanted to circle back on this issue that I opened a couple weeks ago.  I
> came down with the flu, as did the rest of my family, so I haven't had a
> chance to look at this again until this weekend.  Also, I'm not sure if I'm
> creating the response to the mailing list in the most optimal way, but I can't
> find any specific instructions other than to change the subject line when
> replying, so please let me know if there's something else I should be doing.
> 
> With that out of the way, I was able to figure out what the problem
> was.  Apparently my importer tool wasn't able to find any matches because the
> source account is locked as my "Checking Account," but when I setup my
> accounts initially - and I'm not sure this was the correct way to do it - I
> ended up creating a bunch of subaccounts for all of my expense categories.  My
> intention was to be able to see a running balance in each category, but I also
> don't think I understand how to fully utilize the budget feature in
> GnuCash.  At any rate, I updated one of my transactions to set the source
> account to the main/root checking account, rather than the subaccount, and now
> the importer is able to find a match for it.
> 
> So I guess I have a few follow-up questions: 1) Can I use the budget feature
> in GnuCash to see an active balance for a given expense category, or does the
> budget only tell me how much money I've spent in that category for the given
> time period? 2) Is there a way to either change the source account on an
> import (I'm not sure how it automatically detected the Checking Account in the
> first place) or to perform a mass update to the source account on my
> transactions?
> 
> Thanks,
> -Aaron
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Import Map Editor - accidentally deleted account

[davidcousens49]

Bogdan,  
I have no problem deleting individual match strings in the import map editor in
GC4.10 on Linux mint 20.3.   I used to do it occasionally in  several of the 3.x
versons as well but I have never deleted all the strings for a given account. It
may be that action which is causing the problem. For some reason the Bayesian
editor includes date information in the account matching so the token database
ends up with a lot of entries with a frequency of 1 or 2 which should have
little or no effect on the Bayesian matching.  The matching process is also
different if you have the Bayesian matching disabled although I think it is now
the default matching process. 
David.
On Fri, 2022-05-20 at 10:26 +0200, Bogdan wrote:
> Hi David, 
> Thanks, that's of course how I tried to delete an individual token - by
> highlighting the item and yet it would delete the entire account. That bug
> happened on several accounts but I can't reproduce it on some other accounts
> where I could delete tokens just fine. So I guess this is something to watch
> out for if other users complain.  
> The problem is not so much the loss of the previously created tokens /
> mappings but inability to create new tokens for the account. I've tried to
> start from scratch hoping new imports would create tokens for the account but
> they do not and the account / new mappings simply do not show up in the Import
> Map Editor after new imports. The same is actually true even for 
> newly-created 
> accounts - tokens are not recorded on import. What could be wrong? 
> Thanks! 
> 
> On Fri, May 20, 2022 at 2:39 AM  wrote:
> > Bogdan,
> > When you open the import map editor it normally shows a list of accounts and
> > each of those accounts has an down arrow to the left of it. If you click on
> > the down arrow the list will expand to show the token entries  (match
> > strings) associated with that account. You can then select the specific
> > search strings you want to delete and these will be highlighted. Mmultiple
> > items can be selected using the usual Ctrl-click and Shift-click mechanisms.
> > Only the highlighted strings will then be deleted. If you highlight the
> > account entry at the top of the list then all entries associated with that
> > account get deleted which would appear to be what has happened in your case.
> > Unfortunately there is no undo button so the information is permanently
> > lost.  The documentation is in the help manual at 
> > https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#:~:text=Import%20Match%20Editor,Map%20Editor%20from%20the%20menu
> > . however the above drop-down action is not documented there. I will patch
> > it to add the above.
> > It might be more appropriate to issue a warning that you are going to delete
> > all match information for an account where the item selected is an account
> > entry rather than an individual match string and ask for confirmation that
> > this is what is intended
> > David Cousens
> > On Fri, 2022-05-20 at 00:29 +0200, Bogdan wrote:
> > > Hello,
> > > 
> > > The course of the problem is that I tried to delete a specific mapping for
> > > a specific account in the Import Map Editor and instead it would delete
> > > the entire account with all mappings (that is, in the Map Editor, not the
> > > account itself). That looks like a bug.
> > > 
> > > Anyway, it doesn't seem possible to retrain the system by new importing
> > > (and setting values) i.e. identical transactions are not recognized on
> > > subsequent imports. I assume it's because the account is no longer being
> > > mapped to on import (and is not visible anymore in the Map Editor as
> > > mentioned above). Hence my original question on how to re-instate the
> > > account in the datafile / Map Editor for mapping if possible at all?
> > > 
> > > 
> > > 
> > > On Thu, May 19, 2022, 04:14   wrote:
> > > > Bogdan
> > > > 
> > > > 
> > > > 
> > > > AFAIK the import mapping data is stored in the main data file as is the
> > > > price
> > > > 
> > > > database data. I don't know if the log files record changes to the
> > > > import map
> > > > 
> > > > editor or only transaction changes. I suspect if you have deleted
> > > > something in
> > > > 
> > > > the import map editor your only recourse will be to  retrain the system
> > > > by
> > > > 
> > > > setting the values for unmapped transactions during the import process.
> > > > It
> > > > 
> > > > probably pays to have a very good idea of how the import mapping
> > > > functions
> > > > 
> > > > before editing the map data as it can have some unwanted consequences.
> > > > 
> > > > 
> > > > 
> > > > David Cousens
> > > > 
> > > > 
> > > > 
> > > > On Wed, 2022-05-18 at 23:45 +0200, Bogdan wrote:
> > > > 
> > > > > Hello,
> > > > 
> > > > > 
> > > > 
> > > > > I don't have a "qif-accounts-map" file on my system.  I've been
> > > > importing
> > > > 
> > > > > OFX rather than QIF format. Where else would the mapping for these
> > > > imports
> > > > 
> 

Re: [GNC] How to convert between currency and assets and record change of value

[davidcousens49]

nathan,

This would normally be regarded as a capital gain (or loss) on sale of the item
and whether it is or not depends on the capital gains tax rules as they apply to
this item in your jurisdiction.  As such it may be subject to capital gains tax,
in which case you would need to treat it differently from other income which is
subject to income tax  rather than capital gains taxes. The process is much the
same but you create additional income and expense accounts for use with items
subject to capital gains, which sum separately form your income accounts for
items subject to income tax  ie,e you might have a heirarchy something like

Income:Taxable
Income:Capital_Gains
Income:Noon-Taxable

with a similar heirarchy in your expense accounts.  These can then produce
separate line items for each of these categories in the reports produced ( with
the appropriate choices in the report options settings. It is also a common
practice to use a single account usually under Income for both capital gains and
losses and not have expense accounts for losses. 

GnuCash uses double entry accounting and a purchase transaction will record the 
transfer in value from one asset, your checking account, with a credit entry 
(called one split of the transaction to the GnuCash account representing your 
checking account) to the new asset (with a debit entry/split to the GnuCash 
account representing the asset). The two splits which each affect different 
accounts form a single transaction.
 In accounting we normally distinguish between assets purchased for immediate
use within the current accounting period (current assets) and assets which are
held for longer than a single accounting period (non-current assets). The
purchase of a current asset, e.g. office supplies, is recorded against an
expense account (a temporary equity account in conjunction with income accounts
to record profit and loss in the current accounting period) immediately on
purchase rather than against an asset account ( credit to the checking account
and debit to the expense account, whereas the purchase of a non-current asset,
e.g. land or a building or plant) is normally recorded against an account in
non-current assets (credit to the checking account and debit of the appropriate 
asset account).

I would suggest working through the Tutorial and Concepts Guide 
https://www.gnucash.org/docs/v4/C/gnucash-guide/index.html if you are not
familiar with double entry accounting practice. The introductory chapters give a
brief overview of double entry accounting and subjects like purchases,
sales,capital gains and losses are dealt with in later chapters as are things
like depreciation of assets for which the values is consumed over periods much
larger than a single accounting period.  It is useful to setup a dummy set of
books to do the examples in the guide. The help manual is more of a button by
button description of the interface operation  but is also useful 
https://www.gnucash.org/docs/v4/C/gnucash-help/help.html. These are also
downloadable in PDF format if that is more useful for you.

David Cousens




On Thu, 2022-05-19 at 22:11 +, Nathan Falco wrote:
> I need to set up an account structure to show the flow of transactions for the
> following scenario.
> 
> I use money in a checking account to purchase a physical item. I sell the item
> for more than I paid for it. I put the money back into the checking account.
> 
> I imagine I could record the purchase merely as an expense and record the sale
> merely as income?
> But I would like to show the cost and the income related to each specific item
> I sell. So I imagine another way I could do it would be to convert the money
> used to pay for the purchase into an asset, and then convert it back into
> money when I complete a sale. I hope to be able to show that as the value of
> the checking account decreases the value of the asset account increases and
> vice versa. What kind of transaction would show the increase of value? Should
> I just add a split to the record of the sale and label it income? Because I
> think that would only capture the net. I would want the record to show that
> money received from the sale would be counted as income. I also would want to
> show that any cost related to selling the item was an expense.
> 
> Please reply with which method is the best suggested method. Also please
> include a dummy account structure that shows the basic classifications that I
> should use. 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
> 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] Import Map Editor - accidentally deleted account

[davidcousens49]

Bogdan

AFAIK the import mapping data is stored in the main data file as is the price
database data. I don't know if the log files record changes to the import map
editor or only transaction changes. I suspect if you have deleted something in
the import map editor your only recourse will be to  retrain the system by
setting the values for unmapped transactions during the import process. It
probably pays to have a very good idea of how the import mapping functions
before editing the map data as it can have some unwanted consequences.

David Cousens

On Wed, 2022-05-18 at 23:45 +0200, Bogdan wrote:
> Hello,
> 
> I don't have a "qif-accounts-map" file on my system.  I've been importing
> OFX rather than QIF format. Where else would the mapping for these imports
> be stored?
> 
> 
> On Wed, May 18, 2022 at 1:28 AM Tommy Trussell 
> wrote:
> 
> > I don't regularly import data, so I am not sure...
> > 
> > HOWEVER what happens if you quit GnuCash, move the qif-accounts-map file
> > to another place, then open GnuCash and try the import again?
> > 
> > https://wiki.gnucash.org/wiki/Configuration_Locations
> > 
> > If this is "dangerous" I hope someone jumps in. Since I haven't used the
> > importer on this system I don't even see the file, so I presume it gets
> > automatically created when necessary during the import process.
> > 
> > Please be sure to report back whether thad does or does not work!
> > 
> > 
> > On Sat, May 14, 2022 at 2:26 AM Bogdan  wrote:
> > 
> > > Hello, does anybody have a suggestion how to fix the import map editor?
> > > 
> > > On Wed, May 11, 2022, 12:26 Bogdan  wrote:
> > > 
> > > > Hi,
> > > > 
> > > > I've accidentally deleted several accounts in the Import Map Editor -
> > > > Bayesian (actually, I was trying to delete a match string but it would
> > > > delete the entire source account with all match strings). Now,
> > > obviously,
> > > > matching on import no longer works for these accounts.
> > > > 
> > > 
> > > Is there a way to restore it?
> > > 
> > > Making a new import does not record the missing account in the Import Map
> > > > Editor (and match strings are not recorded).
> > > > 
> > > > Thanks!
> > > > 
> > > ___
> > > 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.

Re: [GNC] unrealized gain / losses for mutual funds

[davidcousens49]

Andrea

The mechanism for recording unrealized gains and losses is basically fairly
simple but the devil is as usual in the detail. 

You need a sub account of your asset account and a corresponding account in
Equity which you could call a revaluation reserve or something similar. This
account can be either in Equity itself or could be an Income or Expense account
(which is included in profit and loss). Which is appropriate to use depends upon
many factors, the asset, the rules that apply to that asset class in your
jurisdiction including tax legislation etc., whether the gains or losses are or
are not taxable (generally not but as Mike points out not always). These sort of
considerations with regard to the reporting requirements will determine exactly
where in an account heirarchy this account should be positioned. This is where
you need accounting advice relevant to your jurisdiction and your personal
situation.

When the asset increases in value the asset sub account is debited and the
corresponding equity account is credited (and vice versa when a decrease in
value occurs). The sub account totals into the asset value. If you are doing
this it would also be common practice to have the purchase value of the asset
also recorded in a separate sub-account so you can track its value for capital
gains purposes in which you would also track events which could affect its cost
basis for CGT if appropriate,. The asset's current value being the total of the
sub-accounts with the asset account itself a placeholder. This will put the
changes in valuation onto the balance sheet. It will also likely affect other
reports (e.g. profit and Loss) depending on where the second account is located.

To automate this would require a process which takes place automatically
whenever the price for the asset recorded in the price database changes which
generates the appropriate debits and credits relative to the last price recorded
in the database and puts then into a transaction affecting the above accounts.
This is not a simple process as this would occur only for certain specific
assets or asset classes, and the appropriate account structures associated with
the asset and its unrealized gains would need to mapped to each asset class for
which this was to apply to. The existing data structures most likely would need
some extension to accommodate this (I haven't looked at this aspect
particularly). This likely means a lot of checking for unwanted and undesirable
effects on the existing functionality during implementation and coding changes
affecting a fair bit of the code base. I'm sure there are other issues which
this would affect I haven't the depth of knowledge about the code base to
appreciate at this point.

You could do the above manually whenever you wish to record a change in
valuation of the asset at whatever period suits your purpose.

David Cousens

On Wed, 2022-05-18 at 08:32 +0200, Andrea Borgia wrote:
> Any ideas? Was my question perhaps not sufficiently clear?
> 
> Il giorno dom 15 mag 2022 alle ore 17:15 Andrea Borgia 
> ha scritto:
> 
> > Hello.
> > 
> > 
> > Trying to improve my book-keeping, I would like to tackle this issue now
> > so I went to the documentation, precisely "11.4.1. Unrealized Gains".
> > 
> > Problem is, the example applies to a painting, that is an object whose
> > value changes, not shares whose number remains constant but whose value
> > changes, thus leading to a change in total valuation.
> > 
> > 
> > Since the end goal is to derive unrealized P and then include those in
> > the economic result for the year, I thought I could record a fake sale,
> > after all at book opening the next year I do a fake purchase (with same
> > price, just one day apart). If this makes sense, how do I compute the
> > P given the new price? Must I do that manually with a split or is
> > there some kind of assistance by GnuCash?
> > 
> > 
> > Thanks,
> > 
> > Andrea.
> > 
> > 
> > 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Am I in business?

[davidcousens49]

It will depend on your email client Arthur. I usually filter on gnucash which
picks up gnucash in the list address and seems to work fairly well. It your
email client also has a group by thread option this makes it easier to follow
conversations.

David Cousens

On Wed, 2022-05-18 at 01:18 +, arthur brogard via gnucash-user wrote:
> You're right.  I get just as many individual emails addressed to  me either
> way, don't I?   
> 
> But what do I use for the filter?  Can't be 'from' if I want to catch both for
> they differ.  Can't be 'subject' for that differs.
> 
> 
> 
> On Wednesday, 18 May 2022, 10:33:16 am ACST, Derek Atkins  > wrote:  
>  
>  Hi,
> 
> On Tue, May 17, 2022 7:07 pm, arthur brogard wrote:
> > Hello and thankyou.
> > I'm 'replying to all' in response to your direct email I just got here. 
> > Great.
> > Hope I'm doing it right.
> > So it seems to me I should run two accounts with the list.  Because I like
> > to see what's being discussed at the same time as I don't like the hassle
> > of responding to those who respond to me in the hassly way we have to do
> > it when using the digests.
> > So I can have the digests to open and peruse whenever I feel like it, no
> > hurry.
> > And I can be running a normal email - email thread about my queries at the
> > same time in the second account.
> > That'd be alright, I guess?
> 
> Yes, you could subscribe twice (with two addresses).  Although I don't
> really see the point of doing that.  You might as well just tell your
> email client to file all the gnucash email into its own folder and then
> you can peruse the subjects that way instead of using a digest AND
> individual emails.  Because you still need to *find* the individual email
> to reply to...
> 
> But hey, whatever works for you.
> 
> -derek
> 

___
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] Am I in business?

[davidcousens49]

Arthur,

When replying to a question it is legitimate to copy the title of the post you 
are replying to "Re: [GNC] Am I in business?" to the subject line of the reply 
where the reply is a continuation of that discussion, particularly when 
replying to a digest.  It normally happens automatically when replying to an 
individual email. As long as the email is addressed to 
"gnucash-user@gnucash.org" it will reach the list. Most email clients have a 
Reply to List function which will copy the list address to the address field of 
the email, other wise you can do that manually. The Reply to All function will 
usually send the reply to all users in the To: and Cc: fields of the message 
you are replying to -  not desirable in many cases when replying to a mailing 
list. 
It is also possible in the mailing list preferences to set them to receive the
individual replies to the list rather than the digest -  ups the emails you get
but I find it easier than having to cut subjects out of the digest and my email
client has some efficient processes for deleting and or archiving all emails
from a given address, sender, subject etc so I am able to manage it easily.

Adding  an individual's private email address will then result in them receiving
two copies, one directly and one via the list which can be mildly annoying. To
address an individual who made a previous comment, I usually use their name  in
my reply. The general protocol on mailing lists is not to respond to an
individual's private email address (unless invited to do so -e.g. where you
might need to disclose information you may not want to make public, but are
prepared to disclose it to an indiviual). The purpose of a list is really the
exchange of information between users and other users, users and developers and
that function is lost in private email exchanges. It also means the exchange is
available to other list users as an educational tool. I often learn new aspects
of the use of Gnucash and accounting, particularly where the latter differs in
different jurisdictions from the list discussions. 

David Cousens
On Tue, 2022-05-17 at 21:20 +, arthur brogard via gnucash-user wrote:
> Just want to thank all  those who responded to my query.  Thanks for the
> substack suggestion.  Thanks for the cautions about advice.  I'm aware of that
> aspect, don't worry.
> With respect to that:  laws against giving financial advice and the danger of
> accepting such from the unqualified,  I think we need a sort of boilerplate
> text we could append to replies and perhaps even queries which satisfactorily
> deals with both aspects.
> It does get tedious constantly running into it whenever you raise a question.
> My queries range across a lot of subjects and finance is only one them.  And
> in each subject the are addressed to many venues - as often as not simply
> found by googling.
> Its obvious that great volumes of financial information is displayed freely on
> thousands,  maybe millions, of webpages by such as solicitors, accountants,
> bookkeepers,  software vendors and I don't know what-all else. Together with
> much, much more from 'authorised' sources like the ATO,  Lands Dept,  Rev SA
> and on and on.All of them issuing disclaimers and caveats without much problem
> at all.
> If they can do it we can all do it.  There's far too  much panicky nervousness
> and caution I think.  There's real dangers and there's real ways of obviating
> them.  All reminiscent of the covid madness.
> That's that.
> I've got this continuing problem with my inability to properly understand how
> to use this list.
> I get an email from a member addressed to me that's fine.  I can respond to it
> and choose 'reply to all' as suggested or requested in the template footnote
> But mainly I just get mailing list updates with a number of subjects listed at
> the top.  I look at that and see if my query is in there.  If it is I go read
> it and then perhaps, like now,  I'd like to respond to that particular person.
> But I don't know how to do that.
> Except perhaps by noting the email address,  noting out subject line, noting
> the text,  writing a new reply email and inputting all that and making the
> reply go to 'reply all' or something.
> Its surely easier than that.  What should I be doing?
> 
> 
>On Sunday, 15 May 2022, 01:30:16 am ACST,  > 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:  Am I in business? (Liz Dodd)
>   2. Re:  Am I in business? (Nathan Ellery)
>   

Re: [GNC] Am I in business?

[davidcousens49]

Arthur,

While forums may be useful to gain some understanding of financial matters and
accounting for them, you always need to check carefully that any
advice/procedures provided on a website or forum (including anything said in
this forum) is actually applicable to your situation and in your jurisdiction.

You are operating a business a business and possibly are in a partnership with 
your ex if you both own the properties. 
Setting this up is really going to require professional legal and accounting
advice to ensure proper legal protection for you and your ex and compliance with
tax legislation on both your parts. Apart from that, those of us also in
Australia, would likely be breaking the law, if we provided such advice.

David Cousens.

On Sat, 2022-05-14 at 15:05 +0800, Bret Busby wrote:
> On 14/5/22 10:31 am, arthur brogard via gnucash-user wrote:
> > Hope this is the right way to introduce a new question/thread.
> > 
> > I and my ex jointly own four properties two of which are rented out.
> > We are not registered for gst and are not in business though I have an ABN
> > leftover from when I attempted an online business.
> > Are we conducting an enterprise?  Will be be eligible to pay GST when we
> > sell any of those properties?
> > Should we be keeping certain records?
> > Should the arrangement be formalised as a partnership or something?
> > What should we be aware of?
> > I'm putting my personal household expenses etc. into gnucash but not in any
> > really strict or serious way.  Should I be getting that more properly
> > organised?
> > This is the only forum I know of where I can ask such questions.  If it's
> > misuse of this forum and anyone knows a more fitting place please let me
> > know.
> > :)
> > ab
> > 
> 
> This is a software users list, for seeking assistance in using the 
> particular software.
> 
> Asking what you have, is like going and sitting in the waiting area of a 
> medical practice or a hospital, and seeking qualified medical advice 
> from  the people waiting to get medical advice and treatment.
> 
> If you want to get brain surgery, or, your house built and maintained, 
> or, your car serviced, by a layman, who might not have relevant skills 
> or experience, then, okay, do it that way.
> 
> As an unqualified layman, my personal opinion, of no consequence, being 
> not a qualified professional, is quite simple - you are renting out at 
> least one property - you are obtaining income by other than direct 
> payment for your labour (wages); therefore, you are operating a business.
> 
> Go to a qualified and accredited, practising accountant.
> 
> Whilst you conspicuously omitted the information of where you are 
> located, with the use of the terms GST and ABN, in combination, you 
> appear to be in Australia.
> 
> Therefore, you would be subject to Australian taxes and tax laws.
> 
> Which means that, ever since you started renting out your properties, 
> you are supposed to have been declaring all income and expenditure, 
> related to them, and, possibly your residence.
> 
> In Australia, I believe that the applicable term for whom you need to 
> see, is a CPA - a Certified Practising Accountant.
> 
> You need to consult with one, as soon as possible. Find one in your 
> area, and, make an appointment, and explain all of your sources of 
> income, and, seek CERTIFIED, QUALIFIED, advice, as soon as possible.
> 
> Fines for not having met obligations regarding tax laws, can be 
> expensive, and, provide no benefits (other than an expensive learning 
> experience) for the individual.
> 
> Lack Of Knowledge is no defence (people often quote the malapropism 
> "Ignorance is no defence", but, ignorance involves a deliberate act to 
> ignore knowledge, which is different to lacking the knowledge).
> 
> Asking here, for the advice that you have asked, is the same as getting 
> sex education from a group of idiots hiding somewhere, inhaling toxic 
> smoke, for the fun of it (mostly, purely because it is forbidden and 
> unhealthy, making them, more the idiots) - you might get someone who 
> knows what they are talking about, and, you may not.
> 
> This is a software users mailing list, not a forum for getting the 
> advice that should be available from a Certified Practising Accountant, 
> and, a Certified Practising Accountant, of Australia, familiar with 
> Australian tax law, is the only kind of person, from whom you should be 
> seeking the advice that you are seeking, and, the only source of advice 
> of which you should heed, other than the advice to go and consult with one.
> 

___
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 

Re: [GNC] Am I in business?

[davidcousens49]

Arthur,

You appear to be in Australia or somewhere that has a similar tax system.

Short answer - you derive income from the properties you rent out - you are
conducting a business.

If you are in Australia you will be subject to capital gains tax on all the
properties apart from your main residence - the one you live in.

You will need to maintain records for both income tax and capital gains tax
purposes. Some costs associated with the properties will be allowable deductions
for income tax purposes  and there may be costs associated with improvements
 which may be addable to the cost basis for capital gains tax purposes.

THIS IS NOT SPECIFIC ACCOUNTING ADVICE AND IS NOT NECESSARILY APPROPRIATE TO
YOUR CIRCUMSTANCES. Consult an accountant for specific advice relevant to your
circumstances. The ATO website  can provide a lot of information.

David Cousens

On Sat, 2022-05-14 at 02:31 +, arthur brogard via gnucash-user wrote:
> Hope this is the right way to introduce a new question/thread.  
> 
> I and my ex jointly own four properties two of which are rented out.
> We are not registered for gst and are not in business though I have an ABN
> leftover from when I attempted an online business.
> Are we conducting an enterprise?  Will be be eligible to pay GST when we sell
> any of those properties?
> Should we be keeping certain records?
> Should the arrangement be formalised as a partnership or something?
> What should we be aware of?
> I'm putting my personal household expenses etc. into gnucash but not in any
> really strict or serious way.  Should I be getting that more properly
> organised?
> This is the only forum I know of where I can ask such questions.  If it's
> misuse of this forum and anyone knows a more fitting place please let me know.
> :)
> ab
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Configuration dilemma -- How best to share Gnucash between 2 users

[davidcousens49]

John, 

I achieve this by keeping my GnuCash files in a Dropbox account accessible from
my desktop at home, my laptop while travelling and my wife's laptop.  I backup
to an NAS (full once a month with daily incrementals) which is in turn backed up
to an offsite online cloud storage and a local directory on the desktop once or
twice a week  Provided you respect the lockfile, no problems. It generally takes
no more than a minute or two to sync automatically between the two machines via
the Dropbox account (\ I'm on a broadband 100Mbps connection - may be a bit more
limited on slower connections). Just have to remember to exit GnuCash on the
desktop before going out with the laptop and vice versa. In my case only I work
on the files so there is no problem coordinating multiple users.

David Cousens

On Tue, 2022-05-10 at 14:06 -0600, John Griessen wrote:
> On 5/10/22 11:46, Chris Mitchell wrote:
> Keeping the data files on shared network storage ("Windows network
> share", Samba, NFS, sshfs, etc) and accessing them directly has the
> advantage of real-time file locking:
> > I much prefer this setup, because it effectively prevents the
> > "accidentally edit both" scenario.
> 
> That sounds great for two people in an office.   How would you get the benefit
> of doing bookkeeping on a laptop and then at a 
> desktop machine alternating
> back and forth?
> 
> I get a flexibility benefit using unison to sync files.  I don't share use of
> bookkeeping files
> with another person, just me with laptop and me with desktop.  So far no
> troubles for a year.
> This method does not expose my bookkeeping to internet server attacks either
> -- it all stays behind a firewall.
> 
> I've not used the lock files very much, usually "opening anyway" since there
> have been occasional lock ups of x-windows as the 
> ubuntu distro I run with has been shifting to Wayland, and sometimes I get to
> power off running processes and have stale lock 
> files to ignore.  And since there is only me, lock files are always wrong if
> they say locked, since I don't have both laptop and 
> desktop running gnucash at once.
> 
> I find it worth being careful not to edit two different .gnucash files so I
> can do some bookkeeping at odd hours with laptop, and 
> yet normally use desktop with scanner on my LAN for prcessing paper receipts
> to images.  There is a side benefit to using a sync 
> program methodically:  it's always making a backup of what your are doing by
> copying any newer files to the other machine.  Unison 
> syncs all my data, not just gnucash files.  If somehow unison garbled
> something, there are 30 older .gnucash files and every 
> single .log file saved in a dir called logs to reconstruct lost data entering
> from.
> 
> John Griessen
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

[GNC] Errors after restarting GnuCash 4.10 from terminal or bash script

[davidcousens49]

I have just setup getting finance quotes for Gnucash for the first time for GC
4.10 on Linux Mint 20.3. I was setting up a shell script to shutdown GnuCash,
update the finance quotes and restart GnuCash after the quotes had been written
to the datafile. The finance quote seems to work ok but when I restarted GnuCash
from the script, the following appeared in the terminal after the script exited.

$ Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/gnucash/gnucash_core_c.py", line 14, in
swig_import_helper
return importlib.import_module(mname)
  File "/usr/lib/python3.8/importlib/__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
  File "", line 1014, in _gcd_import
  File "", line 991, in _find_and_load
  File "", line 975, in _find_and_load_unlocked
  File "", line 657, in _load_unlocked
  File "", line 556, in module_from_spec
  File "", line 1166, in create_module
  File "", line 219, in _call_with_frames_removed
ImportError: libgncmod-app-utils.so: cannot open shared object file: No such
file or directory

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/share/gnucash/python/init.py", line 2, in 
from gnucash import *
  File "/usr/lib/python3/dist-packages/gnucash/__init__.py", line 6, in 
from gnucash.gnucash_core import *
  File "/usr/lib/python3/dist-packages/gnucash/gnucash_core.py", line 31, in

import gnucash.gnucash_core_c as gnucash_core_c
  File "/usr/lib/python3/dist-packages/gnucash/gnucash_core_c.py", line 17, in

_gnucash_core_c = swig_import_helper()
  File "/usr/lib/python3/dist-packages/gnucash/gnucash_core_c.py", line 16, in
swig_import_helper
return importlib.import_module('_gnucash_core_c')
  File "/usr/lib/python3.8/importlib/__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
ModuleNotFoundError: No module named '_gnucash_core_c'
Found Finance::Quote version 1.51.

I get the same error with no additional info restarting GnuCash from the command
line with --debug. It seems to be more associated with the python bindings than
anything to do with getting online quotes. I do compile  with -D WITH_PYTHON+ON
when I build it. Haven't ever started GC from a script or terminal recently but
I presume this happens from the desktop launcher as well, just isn't visible.

Has anyone struck this before?

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

[davidcousens49]

Richard,

Just installed GnuCash 4.10 on my wife's Windows 11 laptop with no problems at
all using the msi installer from Sourceforge following the download link from
the GnuCash website. Starts, creates a new datafile and opens a copy of my
datafile from my Linux system without any problem.

It has to be something specific to your setup or a problem with the download.
Did you perhaps download the flatpak version and not have the flatpak setup. 
It will help if you can provide us details of which version you downloaded and
from whay site.

David Cousens

On Sun, 2022-05-08 at 14:40 +0100, Richard Clarkson via gnucash-user wrote:
> Have just updated from previous version to GnuCash 4.10 on Windows 11.
> 
>  
> 
> GnuCash now refuses to open (have tried from PowerShell too). I have tried
> reinstalling but no change.
> 
>  
> 
> Any idea how I can rectify this issue?
> 
> Many thanks
> 
>  
> 
> Richard 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Fwd: Double entry directly to Equity

[davidcousens49]

Bogdan

That's easy. In the Accounts Tab, right click on the top level Equity account to
select it and then right click anywhere in the pane and select New Account from
the popup menu  or use Actions->New Account from the mainmenu. This should start
the dialogue with Equity as the parent account, enter the name "Revaluation
Reserve", select the account currency and add any other detail (opening balance
if non zero etc.) . At the bottom the Parent account should show as Equity. (You
can select any other Equity account as parent depending upon your heirarchy in
Equity). Click OK and you have an equity account which you can the use as the
other split in transactions recording the changes in asset value.

David


On Sun, 2022-05-08 at 10:37 +0200, Bogdan wrote:
> Well, actually my question is not an accounting question but rather a
> technical one on how to set up and use equity accounts in Gnucash, if at
> all possible (I'm a qualified accountant by the way). I took a revaluation
> reserve just as an example.
> 
> In many accounting frameworks you can find items that affect equity
> directly rather than through Profit and Loss / Retained Earnings.
> 
> For example, if you account for Property at fair value through P (so
> called "investment property") you would reflect an unrealized gain in
> market value as :
> 
> Dr Asset Cr Income (you equity increases because your net income / retained
> earnings increase)
> 
> However, if you use a revaluation model for the Property and mark it to
> market you would do:
> 
> Dr Asset Cr Reserve account
> 
> A Reserve account is an equity account (as much as Retained Earnings is an
> equity account). This gain doesn't go through P  and doesn't affect your
> income and expenses but it does increase your equity / capital directly
> through the reserve account (where it's reflected on the asset side - the
> property account or counter-account is beyond the point).
> 
> So I guess I am just wondering how to create an equity account in Gnucash.
> I used to set up these accounts as sub-accounts in the Trading account but
> now when I'm trying to make an entry directly to such a sub-account in
> Trading (e.g. Dr Asset Cr Trading) the Trading account changes to Imbalance
> automatically. Is there a workaround or is there a way to fix it?
> 
> Thanks!
> 
> On Sun, May 8, 2022 at 2:39 AM Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
> 
> > > This Investopedia page (
> > > 
> > https://www.investopedia.com/terms/r/revaluationreserves.asp#:~:text=Revaluation%20reserve%20is%20an%20accounting,of%20the%20asset%20has%20changed
> > > .) might provide some insights into how to setup revaluation reserves. My
> > > reading of this is that the Reserve account is a contra account to the
> > asset
> > > value and it is recorded against a specific Expense account to account
> > for short
> > > term variations in the asset value.  Find the section on recording
> > revaluation
> > > reserves a bit down the page.  Most jurisdictions don't tax unrealized
> > gains or
> > > give you exemptions for unrealized losses, so you would likely want to
> > record it
> > > under an Expense account category for non-deductible expenses.
> > > 
> > > You should seek specific accounting advice from a qualified accountant
> > for your
> > > jurisdiction and specific situation and not rely on this
> > > 
> > > David Cousens
> > 
> > Listen to David.
> > 
> > This is a house. Ordinary expenses fore most repairs are non-deductible.
> > But certain "improvements", while also non-deductible at the time, are
> > allowed to be added to the basis, and so can reduce capital gains
> > when/if the house is sold << and you might not be required to report
> > these gains if buying another house for more within a certain amount of
> > time >> BUT (and this is why I am not being more specific, though I know
> > some of the details) I am NOT "qualified" to give such advice. Seek a
> > qualified professional.
> > 
> > Michael D Novack
> > 
> > 
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> > 
> ___
> 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] Fwd: Double entry directly to Equity

[davidcousens49]

Bogdan,

This Investopedia page (
https://www.investopedia.com/terms/r/revaluationreserves.asp#:~:text=Revaluation%20reserve%20is%20an%20accounting,of%20the%20asset%20has%20changed
.) might provide some insights into how to setup revaluation reserves. My
reading of this is that the Reserve account is a contra account to the asset
value and it is recorded against a specific Expense account to account for short
term variations in the asset value.  Find the section on recording revaluation
reserves a bit down the page.  Most jurisdictions don't tax unrealized gains or
give you exemptions for unrealized losses, so you would likely want to record it
under an Expense account category for non-deductible expenses.  

You should seek specific accounting advice from a qualified accountant for your
jurisdiction and specific situation and not rely on this

David Cousens


On Sat, 2022-05-07 at 17:55 +0200, Bogdan wrote:
> Any suggestions there?
> 
> -- Forwarded message -
> From: Bogdan 
> Date: Wed, May 4, 2022, 12:04
> Subject: Double entry directly to Equity
> To: 
> 
> 
> Hi,
> 
> I am trying to figure out how to set up a  revaluation reserve account
> directly in Equity so that I could do e.g. Dr Asset a/c Cr Equity.
> 
> About a year ago I was able to create an account in Trading and debit /
> credit it directly from Asset and Liability accounts. However, now when I
> enter a similar transaction the Trading account (second leg of the entry)
> simply disappears and is replaced by Imbalance.
> 
> What is the appropriate way to make accounting entries directly to Equity
> accounts (not retained earnings through PL)? Any idea why the above
> approach no longer works?
> 
> Thanks!
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] QIF import error

[davidcousens49]

Adrien,

There is a bit of recent correspondence on the github site with a possible new
project manager interested. I gather the main problem is in getting Ngewi Fet
the original developer to communicate/cooperate/hand over the reins on the
project to allow that to happen.

David Cousens


On Fri, 2022-05-06 at 22:19 -0500, Adrien Monteleone wrote:
> GnuCash for Android is a separate project.
> 
> Last I heard, it isn't even an active one. (no commits since mid-2018)
> 
> You can try their GitHub page: https://github.com/codinguser/gnucash-android
> 
> Regards,
> Adrien
> 
> On 5/6/22 11:15 AM, Shaun Parsons wrote:
> > Hi
> > I have recently come across GnuCash which I have installed on my Samsung J6
> > android phone.
> > 
> > I am trying to sync transactions between my Quicken 2016 install on my
> > Windows 11 desktop with GnuCash on my android device using an exported QIF
> > file. Each time I attempt to import the file I get the following error
> > 
> > “An error occurred while importing the GnuCash accounts at line 1, column 0:
> > not well-formatted (invalid token)”
> > 
> > I am unable to find an example of a valid example of a file that works?
> > 
> > The first few lines are
> > 
> > !Option:AutoSwitch
> > !Account
> > NLloyds Linda ISA (Cash)
> > TBank
> > ^
> > 
> > I have tried removing the !option:AutoSwitch which makes no difference.
> > 
> > Long term I am trying to write a vbnet app to massarge the qif files to the
> > correct format, any clues what I am 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.

___
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] QIF import error

[davidcousens49]

Shaun,

The android GnuCash app is not a part of the GnuCash application which is a 
desktop app. I don't know if it is still being supported by its original 
developer but it AFAIK was a totally separate development in Java. 
The QIF format is defined in the following web pages to the extent it is defined
at all  
https://www.respmech.com/mym2qifw/qif_new.htm#:~:text=A%3A%20The%20Quicken%20interchange%20format,that%20supports%20the%20QIF%20format
 and possible more definitively by W3 
https://www.w3.org/2000/10/swap/pim/qif-doc/QIF-doc.htm or 
http://moneymvps.org/articles/qifspecification.aspx. There is no standardized
format defined by and maintained by any organization.

David Cousens


On Fri, 2022-05-06 at 16:15 +, Shaun Parsons wrote:
> Hi
> I have recently come across GnuCash which I have installed on my Samsung J6
> android phone.
> 
> I am trying to sync transactions between my Quicken 2016 install on my Windows
> 11 desktop with GnuCash on my android device using an exported QIF file. Each
> time I attempt to import the file I get the following error
> 
> “An error occurred while importing the GnuCash accounts at line 1, column 0:
> not well-formatted (invalid token)”
> 
> I am unable to find an example of a valid example of a file that works?
> 
> The first few lines are
> 
> !Option:AutoSwitch
> !Account
> NLloyds Linda ISA (Cash)
> TBank
> ^
> 
> I have tried removing the !option:AutoSwitch which makes no difference.
> 
> Long term I am trying to write a vbnet app to massarge the qif files to the
> correct format, any clues what I am missing?
> 
> Regards Shaun Parsons
> 
> 
> 
> Sent from Mail for Windows
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] How to copy a GnuCash 'installation'?

[davidcousens49]

Chris

https://wiki.gnucash.org/wiki/Configuration_Locations
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html
https://wiki.gnucash.org/wiki/User_Configuration_Files

David Cousens

On Fri, 2022-05-06 at 18:58 +0100, Chris Green wrote:
> If one wants to copy a GnuCash 'installation' from one place to
> another, in particular from one computer to another what needs to be
> copied?  I'm really only interested in copying from one Linux system
> to another, both running the same GnuCash version.
> 
> Obviously one needs to copy:-
> 
> The GnuCash 'data' file, either XML or sql
> 
> Any log files (though not strictly necessary I guess)
> 
> However there are other files one needs to copy if you want reports
> and screen layout and things like that to be the same.  Is this
> documented anywhere?
> 
> I'm particularly interested in copying reports across as I run GnuCash
> on both my desktop machine and my laptop.  Just copying the GnuCash
> data file means that I get the same accounts on both systems but not
> reports and connected files ('experimental' CSS for reports, that sort
> of thing).
> 

___
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] QFX file for Bank of American business account not

[davidcousens49]

The other possibility if libofx supports the credit card tags  would be to give
users the option of having the different card numbers recognized as subaccounts
of the main credit card account .  If libofx doesn't support it it is unlikely
much can be done other than raising it as an issue with the libofx developer(s).
Once it is in libofx then GnuCash can be modified to recognize the situation.

David Cousens

On Wed, 2022-05-04 at 20:01 -0500, David Carlson wrote:
> Perhaps there should be a GnuCash error message if libofx fails.
> 
> On Wed, May 4, 2022, 4:41 PM Jean Laroche  wrote:
> 
> > Don't know if my last messages went through. Here they are again:
> > 
> > Running gnucash with --debug shows what the issue is.
> > 
> > Removing the lines that contain the CARDNUM, CARDNAME and MCC elements
> > makes the file import correctly.
> > I'm not sure why ofxlib does not just ignore the unrecognized elements,
> > but that's the way it is.
> > Perhaps file a bug with libofx?
> > 
> > In the meantime, if you're on a linux box or a mac and you're familiar
> > with linux commands, you can use the command line to strip the ofx file
> > from the offending lines using sed, for example on the mac:
> > 
> > cat stmt.qfx | sed -E "/ stmt_fixed.qfx
> > 
> > I'm not a sed guru, so maybe there's a better/more robust way to do it.
> > But this should give you a temporary solution?
> > 
> > Jean
> > 
> > LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> > /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E:
> > element "CARDNUM" undefined
> > 
> > (Above message occurred on Line 39, Column 14)
> >   X ERROR: startElement: incoming_data should be empty! You are
> > probably using OpenSP <= 1.3.4.  The following data was lost: -50.00
> > (Above message occurred on Line 39, Column 6)
> > LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> > /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E:
> > element "CARDNAME" undefined
> > 
> > (Above message occurred on Line 40, Column 15)
> >   X ERROR: startElement: incoming_data should be empty! You are
> > probably using OpenSP <= 1.3.4.  The following data was lost: 9767
> > (Above message occurred on Line 40, Column 6)
> > LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> > /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E:
> > element "MCC" undefined
> > 
> > 
> > 
> > 
> > On 5/4/22 2:24 PM, Kalpesh Patel wrote:
> > > I did experimented with the file he has attached and I can concur that
> > OFX
> > > matcher is bailing out, or more likely silently exiting as if it was NOP.
> > > This is most likely an OFX import bug.
> > > 
> > > 
> > > 
> > > If you start a fresh new file with just the 'Common Accounts' and then
> > > import the ofx file that was originally attached to the e-mail, GNC 4.10
> > on
> > > Windows 10 prompts to create a new account which it does with 'Unknown
> > OFX
> > > credit card account "Credit card 4003901016729673"' account name and then
> > > there is no subsequent dialogue box to import the single transaction
> > that is
> > > in that file. It exit with the effect that you cancelled the import after
> > > creating the account. If I reimport the file again then there is nothing
> > > displayed, -- nothing;  nada --,  such as error messages or the
> > notification
> > > windows that one transaction was found and that it was a duplicate. It
> > once
> > > again simply silently exits and goes back if like no "import" was
> > performed
> > > at all or cancelled. I don't see the transaction getting added to the
> > > register either.
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > --
> > > 
> > > 
> > > 
> > > Message: 12
> > > 
> > > Date: Wed, 4 May 2022 03:25:25 +
> > > 
> > > From: Peter Wu mailto:peter_cd...@hotmail.com>
> > > 
> > > 
> > > To: "gnucash-user@gnucash.org  "
> > > mailto:gnucash-user@gnucash.org> >
> > > 
> > > Subject: [GNC] QFX file for Bank of American business account not
> > > 
> > >  invoking Import Matcher
> > > 
> > > Message-ID:
> > > 
> > > 
> > > 
> >  > > OM
> > >  > dm8p221mb05727f95859d29b4d429f0a4c2...@dm8p221mb0572.namp221.prod.ou
> > > TLOOK.COM> >
> > > 
> > > 
> > > 
> > > Content-Type: text/plain; charset="windows-1252"
> > > 
> > > 
> > > 
> > > Hello,
> > > 
> > > Gnucash community.  Hope everyone is doing well and having a good time.
> > Two
> > > questions:
> > > 
> > > 
> > > 
> > > 
> > > 
> > >1.  Beside the mailing-list.  Does anyone know a forum where we can
> > ask
> > > and discuss issues?  I feel it may be easier to search/discuss/answer
> > > questions than a mailing list.
> > > 
> > >2.  As the email subject says.  Attached qfx file does not work.  I
> > have
> > > personal Bank of American checking and credit card.  They all work.  I
> > > downloaded the file by using the ?Web Connect for Quicken 

Re: [GNC] Change account in Transfer column - how?

[davidcousens49]

Chris,
You have created a chart of accounts which has more than a single account in it?
One other point. Do you have the View->Autosplit ledger option checked. IF you
do then the first line is the transaction summary line and it remains balnk
until you create the transaction splits. You have to move to the second line to
enter the first account for the split and then tab to the third line to enter
the account for the second split second split for the transaction.

David

On Wed, 2022-05-04 at 09:04 +0100, Chris Green wrote:
> On Wed, May 04, 2022 at 06:55:05AM +1000, davidcousen...@gmail.com wrote:
> > Chris,
> > 
> > The behaviour of the account selection in the transfer column in GC 4.10 on
> > Linux Mint is as follows:
> > 
> > When you first click on the split of the transaction a down arrow appears at
> > thr
> > right of the column.
> > 
> > If you click on the down arrow, the list of transaction is displayed and its
> > window overlays the transfer debit,credit and balance columns and the column
> > borders are no longer present and there is a scroll bar to the right which
> > you
> > can use to scroll through the accounts. 
> > 
> I get the down arrow but no list of accounts, no scroll bar, nothing.
> Occasionally it works but, just at the moment, not very often.
> 
> 
> > The arrow to the right will now appear as an up arrow and clicking on it
> > will
> > close the account selection window without making a selection.
> > 
> I get the change to the up arrow, but (as I said) there's no list to
> be closed.
> 

___
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] Change account in Transfer column - how?

[davidcousens49]

Chris,

The behaviour of the account selection in the transfer column in GC 4.10 on
Linux Mint is as follows:

When you first click on the split of the transaction a down arrow appears at thr
right of the column.

If you click on the down arrow, the list of transaction is displayed and its
window overlays the transfer debit,credit and balance columns and the column
borders are no longer present and there is a scroll bar to the right which you
can use to scroll through the accounts. 

The arrow to the right will now appear as an up arrow and clicking on it will
close the account selection window without making a selection.

At this point, if you click on one of the entries in this window, it will become
the transfer account for the transaction and the account and  selection window
will close and that selection will be shown in the transfer entry.  

I use a dark theme on my desktop and in GnuCash normally and at first glance, it
is very difficult to tell the difference between the account selection pop-up
and the window behind it in that theme.
I'm not sure whether it is more distinguishable in the normal GnuCash default
colour scheme  as if I change the preference the popup still comes up in the
dark theme. I don't know if it is possible in GTK but maybe a border or border
of a different colour or slightly different background colour may be of
assistance to emphasize which window is the popup as it overlays the last 4
columns exactly.

Hope this helps clarifies how the window works. I don't remember any problems
with this when i was using GC4.4. Can you confirm if you get it to work this way
and if my experience is general I will update the help on the window to make it
clearer

David Cousens 

On Tue, 2022-05-03 at 15:41 +0100, Chris Green wrote:
> On Tue, May 03, 2022 at 02:24:52PM +, Gyle McCollam wrote:
> >Chris,
> > 
> >Yes, you can.  On my GnuCash, if you click on the "^" (actually it
> >points down) you get the chart of accounts from which you can choose a
> >different account.  It's worked that way as long as I can remember, but
> >I will say that I am using windows 11 and GnuCash 4.10.
> > 
> I thought so, it's a bug that I have reported before (27 Nov 2021).
> When I click on the arrow-up or arrow-down nothing happens.
> 
> My original problem (in November 2021) was that I didn't get the list
> of accounts to select from when entering a new tranaction:-
> 
> I've probably doing something silly somewhere but I can't spot what it
> is at the moment.
> 
> While entering transactions into GnuCash today it sometimes offers no
> account in the 'Transfer' column so anything I do ends up in an
> 'Imbalance' account.
> 
> The up arrow and down arrow do nothing when it's in this state.
> 
> The issue comes and goes and I can't see any pattern to it, I've never
> seen this problem before though.
> 
> I'm running GnuCash version 4.4 on xubuntu Linux version 21.10.
> 
> 
> 
> What I am seeing now is essentially the same problem, the drop-down
> list (or up) of accounts doesn't appear.
> 
> 

___
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] GNC Fails to load Data File

[davidcousens49]

David, Bruce
The type Spreadsheet is the same independent of whether the data file is stored
in sqlite3  or xml format on Linux. I can't test the other database formats at
this point.

David Cousens

On Sun, 2022-05-01 at 06:42 +1000, David H wrote:
> Bruce,
> 
> To me the screenshot of your file name "AL.gnucash" with a type
> of "Spreadsheet" implied that you were just using the standard default
> GnuCash xml backup - is this not the case ?
> 
> Cheers David H,
> 
> On Sun, 1 May 2022 at 04:54, Bruce Irving  wrote:
> 
> > Thank you, Derek.
> > That is another thing I will check Monday
> > Bruce
> > 
> > On Sat, Apr 30, 2022 at 7:16 AM Derek Atkins  wrote:
> > 
> > > Most likely you're using the SQL backend, and it sounds like you might not
> > > have the right SQL Drivers installed on Debian.  If you're using SQLite,
> > > then make sure you have the dbi dbd sqlite driver installed.
> > > 
> > > -derek
> > > 
> > > On Sat, April 30, 2022 8:56 am, Bruce Irving wrote:
> > > > David H.:  Thank you.  I'll try that when I get back to the office
> > > Monday.
> > > > I had tried a Reinstall from Synaptic but that didn't help.  I've tried
> > > > several times to compiling but always hit some snag that my inexperience
> > > > couldn't overcome.  While flatpaks have improved, it still has still a
> > > few
> > > > annoying idiosyncrasies.  If this doesn't work, I'll probably return to
> > > > flatpak.
> > > > 
> > > > David Cousins:  The first time, I did navigate to the data file and
> > > double
> > > > clicked it as was my usual method of opening it.  When that didn't
> > > work, I
> > > > stated gnucash and used file/open.  Both ways gave the same error.
> > > > 
> > > > I do appreciate your suggestions.
> > > > 
> > > > Bruce
> > > > 
> > > > On Fri, Apr 29, 2022 at 2:54 PM David H  wrote:
> > > > 
> > > > > Bruce,
> > > > > 
> > > > > Did you have a previous Debian install of gnucash - maybe try
> > > > > uninstalling and re-installing the debian version - perhaps following
> > > > > the
> > > > > uninstall instructions at
> > > > > https://wiki.gnucash.org/wiki/Uninstall_Gnucash_Linux ...  You could
> > > > > also
> > > > > see if restarting solves anything.
> > > > > 
> > > > > Why would you go back from probably the latest version available in
> > > > > Flatpak
> > > > > (4.10) to a version that's almost 18 months old (4.4) and 6 major
> > > > > releases
> > > > > ago with a lot of bug fixes and enhancements in between ?  Personally
> > > > > I
> > > > > would have stuck with the Flatpak version which obviously worked.  If
> > > > > the
> > > > > Flatpak sandboxing is causing an issue for you perhaps you should
> > > > > consider
> > > > > compiling it yourself ?
> > > > > 
> > > > > Cheers David H.
> > > > > 
> > > > > 
> > > > > On Sat, 30 Apr 2022 at 04:52, Bruce Irving 
> > > wrote:
> > > > > > I have been using Flatpak for GNC when I discovered that a version
> > > > > > is
> > > > > in
> > > > > > the Debian which I installed. and removed the flatpak files.  when I
> > > > > went
> > > > > > to open my data file either by double clicking the data files or
> > > > > > Open
> > > > > from
> > > > > > GNC: No suitable backend was found for ... (See attached)
> > > > > > This is Version: 4.4
> > > > > > Build ID: 4.4+(2020-12-28)
> > > > > > 
> > > > > > The file did open in latest flatpak
> > > > > > 
> > > > > > Bruce
> > > > > > ___
> > > > > > 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 

Re: [GNC] GNC Fails to load Data File

[davidcousens49]

Bruce use your file explorer to locate your data file then use File Open from
the menu inside GnuCash to navigate to that position, select the data file. The
newly installed version has no memory of where Flatpak kne
the file was located us the config/user preference information where the last
file location is stored is likely in a different location when using Flatpak.

David Cousens

On Fri, 2022-04-29 at 12:50 -0600, Bruce Irving wrote:
> I have been using Flatpak for GNC when I discovered that a version is in
> the Debian which I installed. and removed the flatpak files.  when I went
> to open my data file either by double clicking the data files or Open from
> GNC: No suitable backend was found for ... (See attached)
> This is Version: 4.4
> Build ID: 4.4+(2020-12-28)
> 
> The file did open in latest flatpak
> 
> Bruce
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

[davidcousens49]

Chris,

If you start multiple programs from the directory a set of bash scripts which
change to the appropriate directory and run the set of programs for each set of
books you work on  might be useful. You could launch the scipts from either the
Ubuntu menu or from desktop launchers.

David Cousens

On Wed, 2022-04-27 at 09:13 +0100, Chris Green wrote:
> On Tue, Apr 26, 2022 at 07:49:02PM -0600, brad wrote:
> > On 4/26/22 09:25, Chris Green wrote:
> > > I have several gnucash accounts files (sqlite databases in my case)
> > > spread around my system.  When I go to a specific directory and run
> > > GnuCash I just want it to see only the database[s] in that directory.
> > > 
> > > Is there a way I can tell gnucash to forget about all previous files
> > > it has opened?  As it is I get presented with a 'memory' of other
> > > accounts which can be very confusing unless I'm very careful with file
> > > naming.
> > > 
> > > The --nofile option tells gnucash not to open the last accounts
> > > database, it helps a little, but I really want it to forget more!
> > > 
> > I'm not clear on what the problem is (unless you're on a Mac).
> > On my system (linux), In the file manager, navigate to the folder, find the
> > file you want to open, and double click it.  It only opens that database. 
> > What's confusing?
> > 
> I don't use GUI file manager (well, very rarely), I tend to 'cd' in a
> terminal window to the directory where the files I want to use are and
> then run the various programs I need to do things to those files.  The
> GnuCash file is just one of those files.
> 

___
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] Help with GnuCash's 'help'

[davidcousens49]

Chris 

The online version of Help and the Tutorial and Concepts Guide are not really
searchable in any meaningful sense from within the HTML page. Other versions may
be I have more luck using Google directly to find specific topics and info.

The section you are likely looking for comes under "Setting Up, Editing and 
Working with Accounts" in the Help Manual. 
Basic procedure is to locate an account in the chart of accounts in the Account
Tab in the main window and then double click on the line for the account to open
the account register in a new tab.

It could be better but is likely limited by technological limitations and/or the
availability of documenters to improve it further. 

David Cousens




On Tue, 2022-04-26 at 16:35 +0100, Chris Green wrote:
> Maybe I'm missing something obvious but when I search for something in
> GnuCash's help I often can't see what I've searched for.
> 
> For example I just searched for 'open account' and it returns five
> headings - but when I open one of them (for example General
> Information Tab) I can't find the string 'open account' anwhere in
> there. 
> 

___
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)?

[davidcousens49]

Unfortunately GnuCash doesn't work that way AFAIK. Depending on your OS you may
be able to create separate launchers in the Desktop menufor each specific file
and name them accordingly. I know this will work on Linux Mint and likely Ubuntu
variants but not sure on other OS.  The command issued by the launcher is
"gnucash %f". If you change the "%f" to a specific path/filename it will open
that specific file or at least it did several years ago when I used to work on
multiple files.
Then you just choose the launcher for the file you want to work on. If you are a
terminal user you could create separate  aliases for the commands with different
filenames.

David Cousens






On Tue, 2022-04-26 at 16:25 +0100, Chris Green wrote:
> I have several gnucash accounts files (sqlite databases in my case)
> spread around my system.  When I go to a specific directory and run
> GnuCash I just want it to see only the database[s] in that directory.
> 
> Is there a way I can tell gnucash to forget about all previous files
> it has opened?  As it is I get presented with a 'memory' of other
> accounts which can be very confusing unless I'm very careful with file
> naming.
> 
> The --nofile option tells gnucash not to open the last accounts
> database, it helps a little, but I really want it to forget more!
> 

___
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] Reinstall GnuCash after Ubuntu upgrade to 22.04

[davidcousens49]

David Tommy etal

As Ubuntu and Linux Mint are ultimately Debian based it should be possible to
install using dpkg or the Gdebi installer (you may need to install this on
Ubuntu -in terminal - "sudo apt install gdebi - but it is the default installer
in Linux Mint) from http://ftp.us.debian.org/debian/pool/main/g/gnucash/ which
has versions up to 4.10-2 available usually for a range of processor types.
 Click on a version link to download the appropriate .deb file  and then at
terminal prompt type  "sudo gdebi .deb" and return.

David Cousens
 
On Sun, 2022-04-24 at 14:17 -0500, David Carlson wrote:
> Thank you David W.  Now for myself and other users that are not comfortable
> with Flatpak or with DIY solutions but willing to accept backports, what is
> the probability of seeing more recent 4.x releases as backports to the
> Ubuntu distro?
> 
> On Sun, Apr 24, 2022 at 2:06 PM david whiting  wrote:
> 
> > You have at least three options:
> > 
> > 1) Install version 4.8a that ships with Ubuntu 22.04: sudo apt install
> > gnucash
> > 
> > 2) Use flatpack, this will get you a more recent version. See
> > https://wiki.gnucash.org/wiki/Flatpak
> > 
> > 3) Build it yourself, and get 4.9 or the maintenance release (or other
> > releases). See
> > https://wiki.gnucash.org/wiki/Building_On_Ubuntu#Build_Instructions
> > 
> > David
> > 
> > On Sun, 24 Apr 2022 at 17:59, Steve Cohen  wrote:
> > > I just upgraded my system to Ubuntu 22.04 (from 21.10). As a non-official
> > > application, GNUcash seems to have been removed from the system or
> > rendered
> > > non-functional though a launch icon remains and does nothing.  Prior to
> > > install, I was running GNC 4.9.
> > > 
> > > Can someone please point me in the right direction for building or
> > > installing the best version of GNUcash on my new system?
> > > 
> > > Thanks.
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > 
> > 
> > --
> > David Whiting
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> > 
> 
> 

___
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] Whole life insurance

[davidcousens49]

Fred,

You will need a statement from the insurance company which details what
component of the premium  credited to your bank account when you pay it) is a
contribution/increase to the capital value of the asset which is the insurance
policy (debited to the account representing the policy and which is a fee to
cover their cost of operations/profits (debited to an expense account). 

They will have invested the funds you put into the policy and will pay bonuses
which add to the value of the policy (you debit the policy value by the amount
of the bonus and credit an income account by the same amount) Depending on the
tax rules for your jurisdication, that may or may not be taxable income.
Commonly this is taxed in the hands of the insurance company and not the
individual, but this may vary between jurisdictions. 

Most companies will send you periodic statements detailing the increase in value
of your policy, the premiums paid, and bonuses paid from which you can calculate
the required quantities.

The easiest way to handle this is to use an asset account for the policy with
individual subaccounts for the premiums paid, administrative charges and the
bonus payments.

When you pay the premiums you credit your bank account and debit the premium
subaccount,

when you receive a statement work out the difference between the increase in
poliycvalue (bfeore bonuses) and the premiums paid and credit the sub account
for administrative costs and debit an appropriate expense account for that
amount.

Similarly with te bonus amounts debit the account for bonuses and credit
theincome account ( taxable or not as appropriate).


david Cousens


On Sat, 2022-04-23 at 10:40 -0700, Fred Tydeman wrote:
> Suggestions on how to record for whole life insurance:
>   Premiums paid
>   Increase in cash value
>   Future death benefit
> 
>  I think some of that is like the Degas painting example in the Tutorial in
> that the increase in cash value is an Unrealized Gain.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Why does an Equity account have to be of Currency type?

[davidcousens49]

Ken

All accounts have a currency associated with them. When you hold an asset, you
hold it at a value in a particular currency, not as an item of indeterminate
value. You would require an inventory (which GnuCash does not have to hold the
items and in inventory accounting each item still has a value, usually its cost
to either buy or produce which is used to calculate the value of the items held
in the corresponding inventory account. An inventory account would not
dissimilar to a stock account.

David Cosuens

On Sat, 2022-04-23 at 17:46 +0800, km22 wrote:
> Hi,
> 
> I am starting a new Gnucash file for a simple "mock" trust.  The trust
> holds physical assets (like stamps and coins and other collectibles).  I
> want to represent the contributions to this trust in the form of these
> assets.  However, when I try to create new Equity accounts for the
> contributions it only allows me to use "Currency" type assets.  I don't
> understand why Gnucash would force this limitation.  Why wouldn't a user
> be allowed to use any asset type they wish (stocks, bitcoin,
> collectables) and not solely the ISO cash types?
> 
> A screenshot of the issue is attached.
> 
> Thanks,
> 
> Ken
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

[davidcousens49]

Chris,

In around 12 years of using GnuCash on Linux, I could probably count on one hand
the number of times I have had to type in the full filename and extension or
even search for the location of GnuCash data files. At least with the ".gnucash"
extension there is little chance of a clash with another developers use of the
same 2-3 letter extension. Compared with the datetime stamp on the log and
backup files its not too much of a problem, just stretch the terminal or file
manager window out to the right. I am spoiled for screen real estate with 2x27"
screen side by side which might be a mitigating factor for me.

David Cousens





On Thu, 2022-04-21 at 08:45 +0100, Chris Green wrote:
> On Wed, Apr 20, 2022 at 05:54:31PM -0700, john wrote:
> > 
> > > On Apr 20, 2022, at 1:58 AM, Liz  wrote:
> > > 
> > > On Wed, 20 Apr 2022 09:02:16 +0100
> > > Chris Green  wrote:
> > > 
> > > > On Tue, Apr 19, 2022 at 09:20:56PM -0400, Derek Atkins wrote:
> > > > > > 1. Is there any way to get GnuCash to save its file, by default,
> > > > > > with an appropriate suffix other than "gnucash?"  
> > > > > 
> > > > > Sure, tell it to do that.  It only adds ".gnucash" by default, but
> > > > > it won't override what you tell it.
> > > > > 
> > > > Where do you tell it that?
> > > > 
> > > 
> > > "Save As" in the menu should do it.
> > 
> > Be careful to switch back to the "primary" file after doing that, otherwise 
> > the primary will become the snapshot and new work will go into the new 
> > file. 
> > 
> But that's the ultimate aim! :-
> 
> Instead of having the long, clumsy, "gnucash" suffix one wants
> something tidier like "gc".
> 
> Remember on Linux the whole filename is always displayed so all those
> "gnucash" suffixes get a bit wearing after a while.
> 

___
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] Unusual book need

[davidcousens49]

Jeff
Someonelse suggested using the find transaction search if there is some common
string you can search for.

David


On Sat, 2022-04-16 at 00:32 -0500, Jeff wrote:
> David, I like your approach the best. Even though the transactions are 
> in a joint account between my son and father, I am legally responsible 
> for my sons activities.  And all of the transactions apply to my farm, 
> not Dads.
> 
> Now for the fun part, I have to find all of them and get them moved.  
> The IRS waits for no one and I am in a serious time crunch.  3 
> abandoned/orphaned bottle calves and trying to save an abandoned newborn 
> that refuses both bottle and standing up (I definitely do not need a 
> quadriplegic calf right now.  I don't even know where to purchase a 
> wheel chair for a calf). Oh, the joys of being a farmer!
> 

___
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] Unusual book need

[davidcousens49]

Jeff 

Another approach you could try would be to create  a temporary account in your
dad's books and move the transactions that should have gone into your account
into it.  Should work if all of the transactions have at least one account in
common , e.g. an Asset; bank account or similar.  if not you may need to create
more than one temp account.

You could then export the transactions in that temp accountas an OFX or CSV file
which you could then import into your own books. If the target accounts are the
same in yours and your dad's books they should import  but if not edit those
that aren't. CSV may be more appropriate if you need to edit the transactions
before importing If you then delete the temporary account in your dad's books
and choose to discard the transactions in it you should be good.

David Cousens




On Fri, 2022-04-15 at 04:00 -0500, Jeff wrote:
> I need to move transactions from from one set of books to another one.
> 
> I didn't realize while entering transactions in my dads books that they 
> should have gone into mine.  My dad opened a bank account that I did not 
> know about until I started entering charges that my son made with feed 
> stores (debit card).  I had not been informed about the bank account 
> that grandpa opened in my sons name, and I am responsible for all of his 
> income/debits until he is 21.  And many of these transactions affect my 
> income/loss.
> 
> Is there an easy way to move those entries from one journal to the other 
> or will I have to find all of them and manually delete them from one 
> journal and reenter them in mine?  These are separate journal files.
> 

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

Re: [GNC] Can't find the file sometimes

[davidcousens49]

Heide,

The recommended procedure when updating GnuCash from an old version to a newer
version is to first update to the last minor version of the major series number
, e.g. for 2.6 this is I think either 2.6.19 or 2.6.21 before up grading to the
3.x series. If you are up grading to version 4.xyou would upgrade to the last V3
minor version which was 3.11 before upgrading to the current version 4 minor
version.
 
After each upgrade to the next major version run the Actions->Check and Repair
procedure from the menu.  This will fix any data file problems  The reason for
this is that any changes in the datafile only occur at changes of the major
version. Each new major version will correct the data file from the previous
major version for any changes in format that have been made with a run once
procedure the first time the new version of GnuCash is run.

Your datafile location will remain at whatever location you saved it to
originally during any upgrades. You may have to use the File->Open procedure
from the menu to relocate it, if the location of the file is not automatically
rememberd by GnuCash following the upgrade.

That may not be the case for any stored or custom reports and user preferences.
The locations of these have sometimes had to be changed as a result of changes
to the underlying libraries that GnuCash uses and changes to the OS conventions.

Documentation on this can be found at 
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html#:~:text=GnuCash%20preferences%20are%20stored%20in,machine%20to%20migrate%20your%20preferences.=On%20Unix%20and%20macOS%20%2C%20these,display%20in%20the%20file%20manager
with more detail on the location changes for configuration, reports  and user
preference data at
https://wiki.gnucash.org/wiki/Configuration_Locations  for each GnuCash version
on each of the operating systems it is used on. There are some diagrammatic
representations for Linux, Windows and MacOSX linked about halfway down the page
which you may find easier to follow than the more formal definitions of the
locations on the page.

For the stored and custom reports you may need to copy any that you have saved
from the location specified for the previous version to the location specified
for the newer version for your operating system. 
Once you are confident you have access to all your saved or custom reports you
can usually delete the locations the data was stored in in the previous version
you have just updated from. 

David Cousens





On Tue, 2022-04-12 at 11:59 -0700, Heide Wang wrote:
> I just updated from my Gnucash 2.6 to 4.9. Where can I find the update
> instruction for 4.9? I know the basic is same as the old 2.6.  I kept two set
> of account on Gnucash, sometime I can go to the file to switch account, but
> sometime when I switch, it said " the file xx.Guncash file could not be
> found, the file is in the history list, do you want to remove it?” I never
> remove the file. I want to find out what did I do wrong?
> I am using MOS Catelina 10.15.7
> 
> Thanks for the advise as always.
> 
> Heide
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Reconciliation discrepancies

[davidcousens49]

Rich,

One possible cause for this is a transaction (or more) accidentally entered
since the time you were last getting correct reconciliations at a date sometime
in the past. This has occurred for me sometimes when I have mistyped a date
entry, particularly the year, on entry. e.g date went in as 2020 not 2022.

If this were the case it will throw the account balances out wrt to any
statement. It is very unlikely for a bank to have an error in a statement (if
they did it would likely be a programming error which would produce errors in a
large number of customers statements which would normally be reported to them
fairly quickly, corrected and corrected statements reissued). Similarly an error
in GnuCash would likely cause a large number of people to be simultaneously
reporting reconciliation problems although since my bank only issues statements
every 6 months for personal accounts reconciliation is now a lot less frequent
for me than it was in the past when I still had business accounts.
 
If they haven't been marked as reconciled, any such transactions should appear
at the top of the debit or credit panes of the reconciliation dialogue and have
a date outside the range of the current reconciliation and they will not be
included in the sum for the starting balance for the present reconciliation
which could therefore appear to be correct but the closing balances in your
GnuCash account will be thrown out. 

If somehow they had been marked as reconciled, they are not going to appear in
the debit and credit panes of the dialogue, but the starting balance should not
match the starting balance on the statement in this case. 

Locating any transactions of this sort can be a time consuming business when and
if it does occur.

David Cousens

On Tue, 2022-04-12 at 05:49 -0700, Rich Shepard wrote:
> On Tue, 12 Apr 2022, Liz wrote:
> 
> > By looking at such a small number of transactions it is possible to find
> > whatever the errors are. I too have been on Gnucash for a couple of
> > decades, but still found 4 errors in one file this March, payments not
> > entered as received, and digit transposition.
> 
> Liz,
> 
> The reason I started this thread is all transactions for the month match. No
> switched digits, no missing GnuCash transactions. And, now and then during
> the month I check the accounts on the bank's web site and marked GnuCash
> transactions as cleared as they appear on the bank's web page.
> 
> > I hope you find what is happening and let us know.
> 
> Based on everyone's response my assumption that it's something unknowable at
> the bank's side seems to be confirmed.
> 
> Thanks,
> 
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Reconciliation discrepancies

[davidcousens49]

Rich

Have been using GnuCash for a similar period of time and have not noticed any
reconciliation problems (other than those reported as bugs on the list - any
that are are generally fixed pretty quickly) up to v4.9, particulaarly in recent
versions.  Haven't yet done a reconciliation with 4.10.  

Anytime I have had a problem it has usually been a transposition, date errors
and or missing transaction from the reconciliation period and different ordering
in GnuCash and in the banks record leading to me missing a transaction.
Scheduled transactions if you have them might have different values from the
bank's as might interest calculations if you calculate them yourself. I have had
problems where the bank has a completely different order from my own entries and
even the imported OFX entries because of clearance requirements for entry into
the statement at the bank end.

Have you tried checking the bank's balance by importing their opening and
closing balances and transactions into a spread sheet and summing them?
Unfortunately most pdfs will not import tables cleanly into most spreadsheets
but I have resorted to entering the numbers by hand (individually cut and paste)
to check. Only once have I discovered a bank error and they were most
apologetic.

David Cousens

On Mon, 2022-04-11 at 16:09 -0700, Rich Shepard wrote:
> On Mon, 11 Apr 2022, Gyle McCollam wrote:
> 
> > These may not apply, but check that your reconciliation date is the same
> > as the bank's. Also, check the dates of the transactions as GC shows
> > transaction past the reconciliation date, that you don't want to
> > reconcile. The ending balance that GC shows for the reconciliation can be
> > changed, so put in the bank's balance and see if you get a zero
> > difference.
> 
> Gyle,
> 
> I check both the reconciliation date and that date's balance. There are
> discrepancies between the purchase date entered in GnuCash and when the
> transaction cleared the bank but those are immaterial.
> 
> As an aside, I've used GnuCash for more than two decades, starting in 1997.
> These large, sporatic discrepancies appeared only a few years ago, long
> after I moved my business and personal accounts to my current bank. I did
> catch the bank several years ago for charging me twice for the same Amazon
> purchase and my banker had that quickly fixed. That was the only obvious
> error I've seen.
> 
> Thanks,
> 
> Rich
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] how to put loan downpayments in budgets

[davidcousens49]

Karin
It is not an expense but a liability. When you open the Budget you can expand
the liability accounts and enter budget amounts against the liability account
for the loan/mortgage at the period the  payments are due. If necessary you can
change the budget interval to suit. 

A reduction in the balance of a liability account is a debit to it and a credit
to your bank account just as when you enter an expense the increase in expenses
is recorded as a debit and credit to the bank account. 

David Cousens

On Tue, 2022-03-29 at 20:56 +0200, Karin Lagesen wrote:
> Hi!
> 
> I am trying to figure out how to put my mortgage downpayment into my
> budget. It is not exactly an expense, but I do need to have income enough
> each month to cover that in addition to expenses. I've tried googling to
> see how to do this, but the parts of the manual I manage to find (and other
> things) do not seem incredibly helpful on this, so any pointers are much
> appreciated.
> 
> Thanks!
> 
> Karin

___
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] Fw: Re: Upgrade problem

[davidcousens49]

On Tue, 2022-03-29 at 09:40 +, avigr...@juno.com wrote:
> What is the filename that GnuCash uses to store the data?  I need to know what
> filename I am looking for when I do my search for it.

Whatever name you gave it when you created it. It will have the file extension
".gnucash" so look for "*.gnucash". First place to look will likely be in your
home directory and then its sub directories. Use the Search box next to the
Start button and type that in.

David Cousens
> 
> -- Forwarded Message --
> From: David Carlson 
> To: "avigr...@juno.com" 
> Cc: Gnucash Users 
> Subject: Re: [GNC] Upgrade problem
> Date: Mon, 28 Mar 2022 17:42:29 -0500
> 
> 
> While Windows is not the only OS that suddenly develops amnesia regarding
> identification of USB memory keys, it is often a prime suspect.  The recovery
> method is to use your file manager to locate the correct USB device, find the
> correct folder within, then right click or double click the correct
> filename.  As long as the OS knows (or remembers) that GnuCash is the default
> program to work with those files your Gnucash will update things so that it
> should be good again next time. 
> On Mon, Mar 28, 2022 at 5:10 PM avigr...@juno.com  wrote:I
> am using Windows 10.  I installed the new version of GnuCash that was
> recommended below.  Now, when I try to open GnuCash, it can not find my
> files.  I get a box that opens that is titled Unsaved Book - GnuCash.  Please
> tell me what I need to do to be able to access my data again.
>  
>  -- Forwarded Message --
>  From: john 
>  To: Courtney Perry 
>  Cc: "gnucash-user@gnucash.org" 
>  Subject: Re: [GNC] gnucash-user Digest, Vol 228, Issue 50
>  Date: Sun, 27 Mar 2022 19:58:59 -0700
>  
>  Please don't start a new thread by replying to an existing one, especially
> not a digest. When you *do* reply to a digest, please change the subject to
> match the message that you're replying to and trim the quote to only that
> message.
>  
>  As for your question, see 
> https://wiki.gnucash.org/wiki/FAQ#Q:_I_just_got_a_new_computer._What_should_I_copy_over_from_my_old_one.3F
> <
> https://wiki.gnucash.org/wiki/FAQ#Q:_I_just_got_a_new_computer._What_should_I_copy_over_from_my_old_one.3F
> >
>  
>  Regards,
>  John Ralls
>  
>  
>  > On Mar 27, 2022, at 7:47 PM, Courtney Perry via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>  > 
>  > Hello Guncash'
>  > I have my Guncash accounts on an external harddrive and would like to
> transfer it to a new computer I have. Please for your help in doing this
> without losing my data. Thank you.
>  > Regards,Courtney
>  > 
>  > 
>  >On Saturday, March 26, 2022, 04:27:44 AM GMT-4, 
> 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:  Unable to obtain Price data (Les)
>  >   2. Re:  gnucash-user Digest, Vol 228, Issue 49 (Dr. Timothy B. Jones)
>  >   3. Re:  change default behavior of ctrl-PgDn (Adrien Monteleone)
>  >   4. Re:  create desktop icons for GNC 4.9 Flatpak on Ubuntu
>  >   (Adrien Monteleone)
>  >   5. Re:  change default behavior of ctrl-PgDn (John Ralls)
>  >   6. Re:  create desktop icons for GNC 4.9 Flatpak on Ubuntu (Jeff)
>  >   7. Re:  change default behavior of ctrl-PgDn (Adrien Monteleone)
>  >   8. Re:  create desktop icons for GNC 4.9 Flatpak on Ubuntu
>  >   (Adrien Monteleone)
>  >   9. Re:  create desktop icons for GNC 4.9 Flatpak on Ubuntu
>  >   (davidcousen...@gmail.com)
>  >   10. Re:  create desktop icons for GNC 4.9 Flatpak on Ubuntu (Jeff)
>  > 
>  > 
>  > --
>  > 
>  > Message: 1
>  > Date: Fri, 25 Mar 2022 11:05:46 -0500
>  > From: Les 
>  > To: gnucash-user@gnucash.org
>  > Subject: Re: [GNC] Unable to obtain Price data
>  > Message-ID: 
>  > Content-Type: text/plain; charset=UTF-8; format=flowed
>  > 
>  > Thanks for the feedback Adrien.
>  > 
>  > On 3/24/22 20:41, Adrien Monteleone wrote:
>  >> Les,
>  >> 
>  >> Could be. I was having trouble with a freeze condition trying to Get 
>  >> Quotes two days ago. Sometimes gnc-fq-dump would return 'unknown' for 
>  >> currencies.
>  >> 
>  >> Then it would work, then it wouldn't. (GnuCash would always freeze 
>  >> though)
>  >> 
>  >> I just tried gnc-fq-dump again for several currencies and it worked, 
>  >> now it just hangs, even for currencies I just tried.
>  >> 
>  >> 

Re: [GNC] How To Account For Mortgages With Redraw Amounts?

[davidcousens49]

Arthur,

The properties themselves will be recorded as asset account and the mortgages as
liability accounts in GnuCash and as they are generally long term assets would
not be recorded as current assets (unless you trade in properties). An account
of the form Asset:Non-current:Properties:property1 where the ":" denotes a
parent-child account relationship.

You would normally record the property values at their purchase prices in your
books until the point of future sale. There may be exceptions to this. I would
seek a local accountant's advice if you are unsure whether this is appropriate
or not. 

To enter this into Gnucash you would create a transaction debiting the asset
account for the property and crediting an Equity:Opening Balances account for
the value of the property.
 
The loan for the mortagage will be a Liability account, e.g Liability:Property1.
A common approach is to use sub-accounts of this account to record specific
details so you could use sub-accounts of this to record the initial principal
value of the loan, interest added to the loan, regular loan repayments and
additional payments above the required loan repayments (which you can redraw),
depending on your requirements for the detail.

For an existing mortgage, you could record the mortgage balance at the time you
open your books as the principal with a transaction which credits the
Liability:Property1:Principal account with the current mortgage account balance
and debits Equity:Opening Balances with the same amount and then record future
interest accumulation and payments in the respective accounts. 

Interest would credit the Interest sub account and debit an Expense:Interest
account to record the interest paid. Payments against the mortgage would debit
either the regular payment sub-account or the sub account created to record
additional payments and credit whatever Asset:Bank account they were paid from.

If you know the totals of the interest accumulated and the respective regular
and extra payments made at the time of opening the books, you could record the
original principal value as the principal in the opening balance transaction
 and then create transactions which credit the interest sub-account and debit
Equity:Opening Balances for the interest total, debit the respective payment sub
accounts for the respective payment totals with a corresponding credit to the
Equity:Opening Balances account.  This would then preserve the totals for the
interest, payments and regular and additional payments.

Hope this gives you an idea of how you could go about setting the mortgages up
but does not constitute accounting advice as to what may be most appropriate for
your jurisdiction and circumstances. 

David Cousens


On Mon, 2022-03-28 at 02:42 +, arthur brogard via gnucash-user wrote:
> We have two places and two mortgages already a few years in place.
> Starting using gnucash now.
> How to put the places and the mortgages on the books?
> And how to record the 'redraw' amounts we have paid in?
> 
>  
> 
> On Monday, 28 March 2022, 02:30:16 am ACDT, 
> 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:  Report - Income Statement - Layout problem
>   (Carl-Kensaku HERBORT)
>   2. Re:  Report - Income Statement - Layout problem (Liz)
>   3. Re:  Report - Income Statement - Layout problem
>   (Adrien Monteleone)
>   4. Re:  Report - Income Statement - Layout problem (john)
> 
> 
> --
> 
> Message: 1
> Date: Sat, 26 Mar 2022 23:58:16 +0100
> From: Carl-Kensaku HERBORT 
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] Report - Income Statement - Layout problem
> Message-ID: <01221b84-d5f9-b804-dfdf-5df0d8503...@digiene.ch>
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> Hello,
> 
> That's great news ! Big thanks to the developers !
> 
> My next income statement report is not due for a year (or 3 months at 
> earliest).
> 
> But I will test it with my current one as soon as the 4.10 version comes 
> to Ubuntu (or if it takes too long, I will download it manually) and let 
> you know if it works on my end.
> 
> Have a nice week-end !
> 
> Best regards
> 
> Carl-Kensaku HERBORT
> DIGIENE
> Case postale
> CH-1002 Lausanne
> Suisse
> 
> +41 (0) 21 320 22 66
> 
> Le 26.03.22 ? 13:09, Adrien Monteleone a ?crit?:
> > Carl-Kensaku,
> > 
> > It looks like the fix has been implemented for v4.10 due out tomorrow.
> 

Re: [GNC] create desktop icons for GNC 4.9 Flatpak on Ubuntu

[davidcousens49]

Jeff,

Follow David Whitings suggestion creating multiple desktop entries in the file,
one for each separate datafile you need to open, changing the name in the Name
entry and the filepath in the Exec entry as appropriate.

You can locate/put the desktop file in your home directory at
/home//.local/share/applications/gnucash.desktop.

If you need it available to all users on the system you can similarly modify the
gnucash.desktop file at /usr/local/share /applications/gnucash.desktop to append
the additional entries to the file there but you will need sudo privileges to do
that. (There are a lot of multilanguage entries in the system file so it will be
simpler to create the single user entry in your home directory.

David Cousens

On Fri, 2022-03-25 at 18:24 -0500, Jeff wrote:
> I would like to have individual icons that execute GNC for a specific 
> set of books.
> 
> IE: icon (GNC parents books)icon (GNC personal books) icon (GNC 
> company books) etc.
> 
> 

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

Re: [GNC] new subaccounts and updating saved reports

[davidcousens49]

George

Have you tried changing the number of sub-account levels in the report options?
(Edit->Report Options with the report open). It may be possible that changing
from the default level of 3 and/or changing the option to flatten the account
structure (you can always change it back again if the result is not desirable)
may force a reevaluation of the included accounts. Not sure if this will work
but it may be worth a try. If you get the report showing the added accounts then
resave the report.

David Cousens


 On Tue, 2022-03-22 at 11:53 -0700, George Riner wrote:
> I am learning that when I add another subaccount to an account already 
> has subaccounts and the account is already in several "saved report 
> configurations" that I now have to go back through each and every one of 
> my "saved report configurations" and update its Options to include that 
> new subaccount.  It won't automatically include that new subaccount just 
> because it's a subaccount of an account that's already selected in the 
> options for those saved report configurations.
> 
> Is there a way to make it work that way?
> 
> :George
> Platform: Windows 10 (64-bit) build 19044.1586 (32Gb RAM)
> Gnucash: 4.9+(2021-12-18) English
> Finance Quote: 1.51a
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] gnucash-user Digest, Vol 228, Issue 33

[davidcousens49]

Frederick

GnuCash also does not have support for full cost management accounting as well
as not having inventory accounting which is just one component of cost
management accounting. It requires a different form of jobs from that
implemented in the business features. It can be done manually with the kludges
others have mentioned. If your manufacturing is on any significant scale you may
be better served getting a commercial accounting package which has that support.
It will cost but it will likely save you money and time in the long run.

David Cousens



On Thu, 2022-03-17 at 16:50 +, davidvernonl...@gmail.com wrote:
>2.  Question about Assemblies (Frederick)
> There is no inventory accounting in GnuCash, so if you need to hold parts in
> inventory in numbers of units together with their cost per until, whether on
> average cost or on FIFO basis, which then build assemblies, I cannot see how
> this would be possible.
> David
> 
> -Original Message-
> From: gnucash-user
>  On Behalf Of
> gnucash-user-requ...@gnucash.org
> Sent: Thursday, 17 March, 2022 4:00 PM
> To: gnucash-user@gnucash.org
> Subject: gnucash-user Digest, Vol 228, Issue 33
> 
> 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:  IRA/401K income detection (Michael or Penny Novack)
> 
> 
> --
> 
> Message: 1
> Date: Thu, 17 Mar 2022 10:29:14 -0400
> From: Michael or Penny Novack 
> To: "D." 
> Cc: Gnucash Users 
> Subject: Re: [GNC] IRA/401K income detection
> Message-ID: 
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> On 3/16/2022 8:49 PM, D. wrote:
> > Michael,
> > 
> > I think I get what you're saying. In my own case, I've taken to 
> > separating the pretax streams into their own income accounts, which 
> > seemingly addresses some of your points.
> > 
> > But one of the big selling points of IRA/401Ks is that they earn money 
> > tax deferred (which I've also isolated into their own income 
> > accounts). How does Joe allocate the distributions-- or does it even 
> > matter? Each distribution is going to include a portion of deferred 
> > income and a portion of untaxed dividends (at least how I've captured 
> > the txns thus far). Is there a different way to manage those dividends?
> 
> If the contributions are all "pre-tax" then they are "deferred income" . 
> The "deferred income" account would have been used when you entered the
> transaction for a contribution.
> 
> What the account has earned is also all "deferred income". If you were
> entering transactions to record the increase in value of your 401K, that
> would have been the other side of the transaction. Note that it is "deferred
> ordinary income? and not "deferred capital gains"
> 
> If the 401k existed before you began with gnucash, the probable cause was
> entering the starting balance using the "tool" (so other side "starting
> equity"). It should have been "deferred income" << you could still use the
> tool -- when you created "deferred income" (probably under
> equity) with the same starting value that would have taken it out of
> "starting equity". Understand? Yes "deferred income" is part of your equity
> but it is different than your other equity because it has an attached tax
> liability.
> 
> Michael D Novack
> 
> PS? --- Bears repeating, but a "manual" is not a "user guide". We really
> should not be advising users about things like this. In other words, the
> question isn't "how do I enter transactions related to a 401k" but "what
> accounts, what transactions, would I be using when accounting for a 401k".
> That's for a tax accountant to tell you, or you look it up. I am not legally
> qualified to answer "tax accountant" sorts of questions.
> 
> 
> 
> --
> 
> Subject: Digest Footer
> 
> ___
> 
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> 
> --
> 
> End of gnucash-user Digest, Vol 228, Issue 33
> *
> 
> ___
> 

Re: [GNC] How To Put Opening Balance in Acc Rev Account?

[davidcousens49]

Arthur,

The Accounts Receivable account is an asset account which means it is debited 
to increase its balance and credited to decrease its balance. You want to it to 
have a negative balance by the amount your tenant is in credit. 
Manually nter a transaction at the date you opened the books with the following
entries/splits to create the negative opening balance xxx. You can do this
either from the Acounts Receivable or the Opening balances register.

Asset:Accounts RecievableCredit xxx
Equity:Opening Balances  Debit  xxx

David Cousens

On Tue, 2022-03-15 at 03:07 +, arthur brogard via gnucash-user wrote:
> I've opened an account receivable account for my rental place.  The tenant is
> in credit.  He's overpaid.  I need to open it with that balance.  I don't seem
> to be able to put in an opening balance at all.
> What to do?
> :)
>  
> 
> On Tuesday, 15 March 2022, 02:30:17 am ACDT, <
> 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:  dit not run (Geoff)
> 
> 
> --
> 
> Message: 1
> Date: Mon, 14 Mar 2022 19:26:44 +1100
> From: Geoff 
> To: "xuhengx...@outlook.com" ,
> "gnucash-user@gnucash.org" 
> Subject: Re: [GNC] dit not run
> Message-ID: <62bc2f4d-00d0-8682-527e-3603556f0...@gmail.com>
> Content-Type: text/plain; charset=UTF-8; format=flowed
> 
> Hi Kerwin
> 
> You appear to have 2, or possibly 3, versions of Perl installed - is 
> that for a specific reason?
> 
> (1) An Activestate installation - what are the contents of your perl.bat 
> file?
> 
> (2) One or two mingw versions in slightly different locations - why?
> 
> You need to determine which version of Perl that GnuCash is seeing when 
> it runs - from a *WINDOWS* Command prompt (not a mingw shell) type in 
> "SET PATH"
> 
> Regards
> 
> Geoff
> =
> 
> On 13/03/2022 12:07 pm, xuhengx...@outlook.com wrote:
> > Dir Sir / Madam,
> > 
> > Finance::Quote module is installed and working
> > 
> > kerwin@KERWIN-PC D:\Program Files (x86)\gnucash\bin
> > $ perl gnc-fq-check
> > ("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx"
> > "aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "bse"
> > "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch"
> > "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
> > "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france"
> > "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney"
> > "greece" "hex" "hu" "hufund" "hungary" "hustock" "iexcloud" "indiamutual"
> > "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarau"
> > "morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx"
> > "platinum" "romania" "seb_funds" "sixfunds" "sixshares"
> > "stockhousecanada_fund" "tdefunds" "tdwaterhouse" "tiaacref" "tnetuk"
> > "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts"
> > "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo_json"
> > "yahoo_yql" "za" "za_unittrusts")
> > 
> > kerwin@KERWIN-PC D:\Program Files (x86)\gnucash\bin
> > $ where perl
> > C:\Users\kerwin\AppData\Local\activestate\cache\bin\perl.bat
> > D:\msys64\mingw64\bin\perl.exe
> > D:\msys64\usr\bin\perl.exe
> > 
> > perl gnc-fq-dump -v alphavantage 600725.
> > nance::Quote fields Gnucash uses:
> > symbol: 600725.SS <=== requ
> > date: 03/11/2022 <=== reco
> > currency: CNY <=== requ
> > last: 3.8400 <=\
> > nav: <=== one
> > price: <=/
> > timezone: <=== opti
> > l fields returned by Finance::Quote for
> > ock field value
> > 
> > 0725.SS close: 3.8400
> > 0725.SS currency: CNY
> > 0725.SS currency_set_by_fq: 1
> > 0725.SS date: 03/11/2022
> > 0725.SS high: 3.9800
> > 0725.SS isodate: 2022-03-11
> > 0725.SS last: 3.8400
> > 0725.SS low: 3.7600
> > 0725.SS method: alphavantage
> > 0725.SS open: 3.9800
> > 0725.SS success: 1
> > 0725.SS symbol: 600725.SS
> > 0725.SS volume: 52256390
> > 
> > But gnucash did not run , it always check Finance::Quote .
> > 
> > [cid:image001.png@01D836B9.B832B450]
> > 
> > Thanks & Best Regards / kerwin
> > 
> > 
> > ___
> > 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 
> 

Re: [GNC] MySQL

[davidcousens49]

Henrik,

I doubt if the reliability problem you are experiencing is intrinsically in
GnuCash itself although it may be associated with the library used to connect to
MMySQL.
  
GnuCash is not designed for multiple access in particular, i.e. multiple users
cannot simultaneously access the same data file without significant risk of
error. The libraries and routines for SQL access currently do not have the
record locking capability to support multiple simultaneous use. You will need to
establish administrative protocols, if using several computers to access
GNuCash, to ensure such access is not simultaneous.

I would initially trial testing on a single computer which is also running the
MySQL server supplying the data, to ensure there are no server installation
problems before trying to access the server remotely.  Once this is functioning
you can then be reasonably sure that any remote access problems are
communication/permissions issues and not intrinsic issues within GnuCash.
David Cousens

On Sun, 2022-03-13 at 18:37 +, Henrik Morsing wrote:
> Hi,
> 
> I'm new to GnuCash but really wanted it to save to MySQL so I could easily
> access it form different locations. It seems extremely un-reliable though, is
> this expected? Half the time is just hangs and says "The server experienced
> and error..." even though I can connect and log in manually with no issues.
> 
> Thanks for any tips

___
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] Is the directory .gnucash still used by v4.9?

[davidcousens49]

AFAIK it has not been used since V2.6. 
https://wiki.gnucash.org/wiki/Configuration_Locations

David Cousens

On Wed, 2022-03-09 at 13:04 -0800, Dean Gibson wrote:
> Is the directory .gnucash still used by v4.9?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Subject: Re: Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

[davidcousens49]

Arthur,

The option of using cash or accrual accounting is not necessarily totally a
choice on your part. It will likely depend upon the taxation legislation in your
jurisdiction. Many jurisdictions have a threshold on either turnover or income
below which the individual business has the option of either cash or accrual
accounting and above which you are obliged to use accrual accounting.  In
Australia the current threshold is an aggregated turnover of $10,000,000 but
your local jurisdiction may be very different. You should seek advice from a
local accountant.

In GnuCash, the Business Features assume and use accrual accounting principles.
You could circumvent that to some extent by creating and posting the
invoice/bill at the date  when you receive or make the payment.  The accounts
receivable/payable can be setup and operated manually if you do not or cannot
use the business features.

If you are not using the Business features then the major difference is in when
you recognize (i.e. the date at which you record the event in your books) income
or expenses. In accrual accounting this is when the income is deemed to be
earned or when the expense is incurred and may be different from the receipt or
payment of monies. In cash accounting it is simply when you make or receive the
payment.

If you have an existing spreadsheet system working, I would suggest running the
two in parallel for a while until you are confident that GnuCash is giving what
you want and need and you can duplicate the functionality. 

The main thing is to clearly identify what you need for your own tax purposes,
any business reporting required of you, reporting to the tenant and whether this
is a routine statement or ad hoc as required and what you need for your own
management purposes. This will help to define the required Chart of Accounts
structure.

Not sure what the "other" covers in your case but presumably this is the
provision of some sort of services to the tenant/property. You could deal with
this in GnuCash by having separate income sub-accounts for rent and any other
services you provide to the tenant. Using the description field for a
transaction and the memo fields for each split of the transaction appropriately
can allow you to use the various filter and search capabilities in GnuCash and
the reports/report options. 

David Cousens

On Mon, 2022-03-07 at 19:35 +, arthur brogard via gnucash-user wrote:
> Thanks for these inputs.  Hope I haven't done anything wrong.  I'm still
> blundering around trying to understand how to work the mailing list thing.
> It all looks too complicated to me.  Not worth the hassle. 
> 
> I'll tell you what I"ve got right now:
>   I have a spreadsheet that I enter money received,  date received,  payer
> into. It shows me then immediately which weeks rents have been pad and what
> the balance is at that rent day.
> If they've paid money for 'other', i.e. not rent money, I enter that amount
> into 'other' and only the rent amount into rent.
> The 'other' bit is not automated at all.  I have to eyeball it and calculate
> balance each time.  
> 
> So I enter their payment in there and see what balances I've got.
> Then I go to Word and pick up the last receipt I sent them and I modify it to
> suit this week's numbers.  And save it with the date of it.  Hence I've got a
> record of every receipt sent and I've got the spreadsheet.
> The receipts, I know, are not required by law because they pay by direct
> deposit.  But I prefer to do it that way.  
> 
> Now the pain is modifying that receipt.
> If I could have an account where I simply enter the receipt and it shows me
> the balance and I print that out as a receipt that'd be great.
> That account would have to have automatically incremented the 'amount due' as
> the real life dates passed. 
> 
> Well, two balances:  the rent and the 'other'.
> That's all I'm after.
> When I asked I really thought I'd get a reply saying that all such cases of
> meeting period payments, recording them, printing out statements of account
> and receipts are done by 'such and such' software or 'this and that' feature
> of gnucash.
> I realise (now) I'm making things abnormal in that my 'receipt' is really a
> receipt AND a statement, isn't it?  
> 
> A plain receipt would be easy as pie.  
> 
> No.  I need more than that.  Everything has to be crystal clear to this
> tenant. What he's paid for rent, what for other, what the balances are when
> the next payment is due,  which weeks have been paid for.
> What I will do is start using gnucash with my present state of knowledge and
> just find out what happens.  See how I go.
> I'll use cash accounting I guess.  See no need for accrual as best I hazily
> remember my accounting. (It was over 20 years ago).  
> 
> Do we have to tell gnucash which we're using or its all in how we enter
> things?
> Thanks for all the interest and help.
> 
> ___
> gnucash-user mailing list
> 

Re: [GNC] reports

[davidcousens49]

On Sat, 2022-03-05 at 19:29 -0700, Charles Simcox wrote:
> What report & how do I use reports o generate a report by selecting
> specific accounts & some of their daughters not necessarily he whole
> account?

By first opening the report by selecting the required report from the Reports
menu then selecting the menu Item Edit-> Report Options once it is open and
selecting the desired options to display what you want.

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.

___
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] don't know..

[davidcousens49]

On Sat, 2022-03-05 at 20:26 +, arthur brogard via gnucash-user wrote:
> Not sure if I'm doing this right.  Hitting 'reply' on the email address of a
> poster that I want to respond to and putting a 'cc' in for 
> gnucash-user@gnucash.org
Arthur
If you put gnucash-user@gnucash.org in the To: field, there is no need to
include the specific person you are replying to in the addressing of the
message, Just use their name within your message.
> I see some people's posts seem to have been made to 'list gnucash' or
> something.
> And that advice to 'reply to list' etc. - what's that?  I see no such options
> on my yahoo email.  It's referring to choosing for yourself which email
> address to send to or its an actual menu choice somewhere?
> And when I do 'reply' yahoo want me to give a subject.  Well what? Anything I
> 'should' put there to suit the list?
> Okay. That's that.
> Back to the question.
> Thanks to everyone for their input.  It's got me pretty well fazed.  Look like
> I'm going to have to do a bit of reading and learning on gnucash and
> accounting/book keeping on the one hand and on the other: it looks like
> gnucash might not be what I want for this little problem.
> Overkill or something.

If you need to prepare standard business type reports it won't be. Most other
accounting programs tend to hide the accounting in the bookkeeping from the
user, particularly some of the fundamental relationships. In GnuCash it is up
front and very close to the basics of standard accounting. I started using
GnuCash to prepare assignments, when I was doing a master's degree in accounting
many years ago now.

David

> But I might as well do the reading etc. and get into gnucash anyway so I'll
> have a stab.
> I feel that advice to use the business features might be the way to go so I'll
> stumble along that road if I can find it, for a while.
> And I'll haphazardly throw in some posts of our normal household expenses as
> they come to mind and see how it all works out.
> You won't believe this but I'm supposed to know book-keeping.  I once worked
> as a book-keeper. Used a couple of proprietary packages.  Don't even remember
> their names now.  Was so capable back then I converted the shambolic original
> system for the community onto the new package.
> Hard to believe now, eh?  Perhaps it'll start coming back to me if I do as I
> say and start making postings...
> :) 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] accounts receivable for rent..

[davidcousens49]

Arthur,

If you have the Accounts tab showing in the GnuCash interface, the menu item
Actions->New Account Heirarchy will run a dialogue which allows you to choose
specific account options. 

The first step selects the currency for the accounts you are going to add which
will be your local currency. The second step allows you to select check boxes to
include certain types of account in your heirarchy. Ensure the box against
business features is checked then click the next button. .  The next step allows
you to setup opening balances for the account you are adding to the heirarchy  (
you can do this later manually  if you are not sure what they should be at this
stage). 
Step through the rest of the dialog and select the Finish button and the
required accounts to support the business Features will be added. 

You can run this dialog at any time to add accounts to support other features of
GnuCash.

if you have not already done so i would recommend reading the basics chapter of
the GnuCash Tutorial and Concepts Guide (
https://www.gnucash.org/docs/v4/C/gnucash-guide/index.html) which will give you
an introduction to the basic accounting concepts. The following chapters will
introduce the specific features.

You can easily create a test setup of books you can use to explore the GnuCash
features before using them on the actual books for your business. Just keep each
set of books in its own sub-directory of an appropriate location in your home
directory (this simplifies managing the backup and log files created each time
GnuCash is run).  If you have an existing file not in its own directory just
create and copy it into a directory then use File->Open in GnuCash to navigate
and open it.

David Cousens

On Sat, 2022-03-05 at 06:50 +, arthur brogard via gnucash-user wrote:
> I'm sorry to say that I'm immensely ignorant.I have a totally blank gnucash
> open before me.No 'accounts receivable'.Could you spell it out for me or
> direct me to where it is spelled out what I should do?We have only one
> property.  Only one tenant.  Simplest possible case I guess.
> I'm thinking I must:
> . Create an 'accounts receivable'  account.That would be an income account I
> guess.  'Other income' ?
> 
> Every week I put the rent amount in there.  (that's what I"d like to have
> happen automatically)  Then I can print out that balance and show it to him:
> that's what you owe today.
> Somehow what he pays has to go into that account to reflect that he's paid.
> 
> They pay by direct deposit to my bank account.
> So what do I do?  Credit his AR account and debit cash at bank?
> When I become aware he's paid into my bank account.  Then print out  a
> statement showing his balance.
> That's  how it goes?
>  sorry to be so thick.  I'm working on it.
> ab
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Eliminate Manual Download of Transaction

[davidcousens49]

Jesse,

That is exactly what the Aqbanking interface does. It depends upon your bank
allowing OFXDirectConnect. Some banks in some countries do not allow this. There
is a lot of dscussion about setting up the aqbanking For setting this up see
https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect

https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings

https://wiki.gnucash.org/wiki/AqBanking

David Cousens

On Tue, 2022-03-01 at 18:19 -0800, Jesse MacDougall wrote:
> I have downloaded OFX file from my bank and credit cards.
> Is there a way I can automate manually downloading these files? I only File
> - Import - Import options.  The Objective is to have to download the QFX
> files each month and auto import them.
> 
> I see Tools - Online Banking Setup - and see Start AqBanking Wizard. I
> select OFX-DirectConnect backend. I type in Royal Bank.  Royal Bank America
> shows.
> 
> Am I on the right track?
> 
> Merci
> 
> [image: ofrxDirect.png][image: aqBanking.png]
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Close books or start over?

[davidcousens49]

Leo

Just export your account tree (File_>Export_>Export Account Tree to CSV) and
reimport it into your new set of books.

David cousens

On Tue, 2022-03-01 at 22:14 +, Leo Bolta via gnucash-user wrote:
> Hello, I moved from my home country about 4 months ago and did keep track of
> expenses from the day that I left. Would now like to start tracking again
> using the program but wondering what would be the most practical way to begin
> again. If starting from a clean slate, how can I keep the same account files
> as already established in my idle account? Thanks!
> 
> Sent from ProtonMail mobile
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] reconcile problem?

[davidcousens49]

When importing your checking account, if the item has already been imported as a
transaction to your credit card, then if GnuCash recognizes it the "A" column
will be unchecked and the record will not be imported and either the "U" column
will be checked  if the record being imported has additional information in
addition to that in the already imported record which will be updated with the
imported data or the "C" column will be checked which will mark the existing
record as "cleared" but otherwise will not import it. (Note: The "C" column was
labelled as "R" in older GnuCash versions).

GnuCash's automatic settings of these  3 flags should be overridden if the
matching procedure has made an incorrect decision. GnuCash gets about 80% of
these decisions right on most of my imports to my credit card. Unless the
checking account record has identifying information as to which credit card a
payment is made to, GnuCash has no way of making that decision. You will have to
do it manually. I would manually make a note of the dates, payment amounts and
the credit card they are for when I authorized the payments and then use that to
correctly assign the payments to the appropriate credit card account on import
if you can't persuade your bank to include that information.




On Sun, 2022-02-27 at 02:29 -0500, scum buster wrote:
> I understand no piece of software "thinks for you" 100% (maybe you did not
> intend it, but that comment feels condescending to me, but I
> digress)though I would argue that GC does indeed do just that in many
> ways...
> 
> I am just asking for help in dealing with this problem.problem being that
> the bank doesn’t differentiate between cards when posting the payment,
> therefore leading to GC not being able to differentiate.
> 
> How does deleting them help?  So you manually enter the payments transactions
> and also delete all the bank transactions from that bank during the import?
> 
> My concern is then you have to basically go out and double check you have them
> manually entered so they do appear.which basically I have done...
> 
> You said " when I import payments from by checking account, I allocate the
> payments to the correct card account." That is exactly what I am doing and
> where the problem arises.  I do not use the import function for the credit
> card accounts, I enter them manually in the credit card accounts.  I even use
> the same description as the bank does in my checking account"bankname
> payment".
> 
> It is when I am importing my checking account info that the issue comes
> up..there are three choices on import on what to do with the itemand
> none of them seem to do the trick.one option imports the item and ends up
> being aduplictaeanother doesn’t import it at allthe third I cant
> recall what it does but it messes up..and again I assume that is because
> GC cannot differentiate.  The SAME payment sometimes duplicates and also
> DIFFERENT payments to the same bank post to seemingly random accounts in GC
> for that bank.
> 
> Was just hoping that as powerful as GC seems to be (I haven’t tapped into more
> than 40% of what it can do I would guess.) there was a more elegant
> solution so GC routes the imported payment to the right bank card account and
> doesn’t duplicate the same ones.
> 
> 
> -Original Message-
> From: Dean Gibson [mailto:gnucash.st...@mailpen.com] 
> Sent: Friday, February 25, 2022 12:08 PM
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] reconcile problem?
> 
> Well, I have multiple multiple cards with the same bank, & it's no 
> trouble to detect the payments during import & deal with them in an 
> appropriate manner.  I n my case, I delete them from the import.  That 
> makes the reconciliation balance to the amount that was due.  Then, when 
> I import payments from by checking account, I allocate the payments to 
> the correct card account.
> 
> GNUcash is reasonable accounting software.  It just doesn't do thinking 
> for each individual's particular situation.
> 
> 
> On 2022-02-25 08:20, David Carlson wrote:
> > That came up in another thread a couple of weeks ago.  As far as I know,
> > the only solution is to be very careful in the matching step of the import.
> >You can help yourself when making the payments to be sure they have
> > different dates or amounts, or even paying out of different checking
> > accounts.
> > 
> > On Fri, Feb 25, 2022 at 8:11 AM scum buster  wrote:
> > 
> > > Sidebar question --- do any of you have more than one credit card with the
> > > same bank?   That is where I am running into issues when I import and
> > > "clear" (I have always called this "reconciling" but I guess there is a
> > > difference?)
> > > 
> > > The bank just has a line item "bankname payment"  , same for each card
> > > account.
> > > 
> > > That is where I run into issues trying to manually "clear" and that throws
> > > my account balances in GC off
> > > 
> > > 

Re: [GNC] Report question

[davidcousens49]

Paul

You can copy the report to a spreadsheet by selecting the report tab, selecting
all the content using Ctrl-A, copy it with Ctrl-C and paste it into your
favourite spreadsheet. Works into LibreOffice Calc and should work equally with
Excel. You can then save it either as CSV or in the spreadsheet format.

Works for GnuCash 4.9 on Linux Mint 20.2 

Alternatively the menu item File->Export->Export Report will export the report
as HTML and you can open it in a browser, Ctrl-A, Ctrl_C and then paste to a
spreadsheet. Save in desired format

These are fairly simple to do and avoid having to write a lot of code.

David Cousens

On Sat, 2022-02-26 at 09:56 -0700, Paul Kinzelman wrote:
> Thank you for the detailed instructions.
> I found that 'Transaction Report' will do what I want, but then
> I can't export to CSV.
> 
> I can export to HTML by Export Report
> I can 'Export as PDF' but not CSV. That's what I'm missing.
> This would be really nice to add.
> 
> I can Export Transactions, but that does not export the transactions
> of the transaction report which is what I wanted to do.
> 
> On 2/25/2022 6:08 PM, Tommy Trussell wrote:
> > On Fri, Feb 25, 2022 at 9:27 AM Paul Kinzelman  wrote:
> > 
> > Do you mean Account Report? But when I go to File | Export, it asks
> > me which accounts again, it doesn't export the actual report.
> > 
> > When I export the transactions I want, it exports both sides of the
> > transaction, so the column sum is always zero whereas I want the
> > sum of the transactions.
> > 
> > In other words, each transaction takes two lines, the line I want
> > (the expense of what I bought), and the next line which is the
> > account that paid it (like a charge card).
> > 
> > How do I get rid of the double-lines on the export?
> > 
> > 
> > We're apparently not seeing the same thing you are.
> > 
> > Here's a way to get an Account Report for your credit card 
> > transactions. (This is using GnuCash 4.9.)
> > 
> > 1) Open the account
> >Accounts tab --> open Liabilities : Credit Cards : BigBankTwo VISA  
> > (yours will differ)
> > 
> > 2) Use Filter By to select the transactions you want [while the 
> > register is active]
> >View --> Filter By (choose parameters such as date, number of days, 
> > reconciled, etc.)
> > 
> > 3) Open Account Report [while the filtered register is active]
> > Reports --> Account Report
> > 
> > 4) Adjust the options on the report
> >Edit --> Report Options
> >(here you can adjust specific columns, single or double amount 
> > columns, totals or running total, style, report name, etc.)
> > 
> > 5) Export the report
> > You can copy what's on your screen and paste it into a word 
> > processor or spreadsheet
> > OR
> > File --> Export --> Export Report  (give it a name -- it will save 
> > an .html file you can open with a web browser or a spreadsheet program)
> > 
> > -
> > 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.

Re: [GNC] (no subject)

[davidcousens49]

On Tue, 2022-02-22 at 10:49 -0700, Mario Nigrovic wrote:
> Many years ago, I had used gnucash, and was pretty happy with it. I was
> very careful to make regular backups of my data, and so, when my disk
> inevitably crashed, I was not too worried. However, I was mortified to
> discover that, although all my transaction data had been saved, all my
> custom reports were lost, as they had been stored separately in a secret
> undisclosed location, I later discovered to be elsewhere in my home
> directory.
Mario, 

The locations are neither secret or undisclosed 
https://wiki.gnucash.org/wiki/Configuration_Locations although they may not have
been documented when you last used GnuCash.  

User preference settings however are stored in a different manner on the various
OSs that GNucash runs on. 
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html#:~:text=GnuCash%20preferences%20are%20stored%20in,machine%20to%20migrate%20your%20preferences.=On%20Unix%20and%20macOS%20%2C%20these,display%20in%20the%20file%20manager
.

The location of the data file is a matter of your own choice. Would suggest a
directory/folder for each separate data file/set of books you operate keeping
the backups and log files in the same directory. I have a directory which is the
parent of the separate directories for each set of books which simplifies
backups to NAS and cloud and synchronizing desktop and laptop without having to
specify the individual sub directories.

A full backup would also need to backup the above locations as well as the data
file. Easily done with bash scripts run by cron jobs in Linux.
> 
> Recently, I have decided to try again to use gnucash, but I would like very
> much to ensure ALL my data is backed up. So I hit upon the idea of running
> the tool under a custom value of $HOME, but I was then shocked to discover
> that even with this method, gnucash was able to remember previous locations
> of my database file, which suggests that the tool is also using some kind
> of other mechanism to save historical data, and that makes me very nervous
> about actually being able to do proper backups of everything related to the
> tool.
GnuCash remembers the last location of the last data file opened. This is
intentional behaviour primarily for the convenience of the majority of users. It
is stored as a path to the last file opened and no financial data is stored
anywhere else but in the data file.  You can always use the menu File->Open
dialogue to override and change between different sets of books if you deal with
multiple financial entities.  If you backup the datafile and its local backups
and log files, you can restore to any point in the date range covered. I also
backup to an onsite NAS and off site cloud storage periodically as well as
synchronizing between several computers. This is fairly easy to setup either
with utilities like Unison or with cron jobs running Bash scripts in Linux and
likely with similar utilities on Windows and MacOSX.

> Doing some sleuthing using strace, I was able to find the previous database
> location delivered through some socket connection, and that really scares
> me, since it is now possible critical data is stored via some other Linux
> service and I will have no way to trace out where this may be to avoid
> future nasty surprises.
> I have not seen any documentation about backup strategies other than the
> aromatic saving of previous data files, yet I do see that there was data
> being stored at least in ~/.local, so I'm hoping someone on this list may
> be able to point me to some more thorough discussion of ALL the places user
> data from gnucash may be stored.
See the above links.

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

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

Re: [GNC] Directly posting payments

[davidcousens49]

Jim,

You only need to create an invoice where you are extending credit to a vendor -
i.e. time to pay. if the item is a cash purchase you could simply open a
transaction from the appropriate asset account register and credit the amount of
the purchase to the appropriate asset bank account and debit the amount to the
appropriate expense account as long as you have no need to track the purchase
back to a specific vendor as this is really only available using the business
features which include the customer/vendor and invoice/bill features amongst a
few others. By including vendor specific information in the transaction
description field there are some features which allow filtering in reports.
There has been some considerable recent discussion on the mailing list about
these features some aspects of which are still under development.

David Cousens

On Mon, 2022-02-21 at 17:10 -0500, j...@paradisepro.com wrote:
> I am a newbie on GnuCash, currently running it side-by-side with my previous
> software which I can't install on Win10 without a very expensive upgrade
> [currently logging into my old Win7 machine using Remote Desktop but old
> machine is becoming unreliable].
> 
> In my old software, I could directly post incidental payments without first
> creating an invoice. In GnuCash, it appears I need to create an invoice prior
> to posting a payment. For a simple transaction like a store or restaurant
> purchase, this seems somewhat cumbersome.
> 
> I can create the transaction directly in the General Journal; however, then I
> don't have a vendor summary.
> 
> What am I overlooking?
> 
> Regards,
> 
> Jim
> 
> James E. Gochnauer
> Independent Claims Adjuster
> Licensed/bonded/Xactimate certified
> 132 Cleveland St. Flr 1
> Brooklyn, NY  11208
> CELL & TXT:  646-465-4800
> j...@paradisepro.com
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
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] Accounting Working with multiple currencies

[davidcousens49]

There are a number of issues with your bookkeeping.  

The first major one is that when a book is sold you are debiting a Revenue
account and crediting an A/R (accounts receivable) account. This is incorrect
When you sell a book you are increasing the balance of the revenue/income
account and simulataneously increasing the balance of the A?R account.  An
income/revenue account requires a credit entry to increase its balance and an
asset account like A/R will require a debit entry to increase its balance. If
this is unclear read the chapter on the basics in the Tutorial and Concepts and
Guide(https://www.gnucash.org/docs/v4/C/gnucash-guide/part.getting_started.html)
.  Both of these accounts would appear to be in CAD yet you have entries in USD
to both of the CAD accounts.  That won't work. The currency conversion works
when one entry in a transaction is to an account which has a base currency in
USD and the other entry/entries of the transaction is to an account in CAD 

Similarly when the money is paid into your paypal account which you are treating
as an asset, then it is a debit entry in USD to the Paypal (USD) account not a
credit entry. This is again a reversal of normal accounting practice.

Does Paypal operate the account as a CAD account and convert the transactions
from USD to CAD for you or is the base currency of the PayPal account as
operated by Paypal in USD? Does Paypal report to you in CAD or USD?. Is the
payment into the Paypal account from IS/IL itemized by each sale or simply a
total USD amount. 
 
Is your Sales report from IS in USD? The timing of the currency conversion is
going to be important and which accounts it takes place in. That detremines the
currency conversion rate which applies and the date at which it applies.

You really need to get professional advice on how best to handle the currency
conversions and accounting for them from a local accountant in Canada and
particularly with how to deal with the relationship between publisher and
retailer in the US. The details of how you handle this will also depend on the
contractual arrangements you have  with IS and IL ( and Paypal) and the authors.


It will also depend on when under Canadian law, your revenue is considered to be
earned (at the time of the sale, when IS/IL reports the sale to you, or when you
get paid?) which may also depend whether your business operates under Canadian
tax law as an accrual or cash accounting business. Similar considerations will
likely arise as to when your liability to the author is incurred and when it
should be recorded.

David Cousens


On Sun, 2022-02-20 at 18:17 -0700, Tinker Books wrote:
> I have been struggling with this for three years and have managed to make
> one transaction/transfer form a USD account to the default currency.
> I am a publisher in Canada, so my default currency has to be CAD for income
> tax etc. and I sell books via a Print-on-Demand wholesale distributor in
> the US, IngramSpark [IS] which distributes my books to a multitude of
> retailers worldwide, [IS] , which reports sales in multiple currencies,
> primarily USD and because I receive the payment directly to my PayPal
> account in USD 3 months after the date of the sale, which is how long the
> retail customer has to return books. Print books are printed and shipped by
> LightningSource [LS] which has printing facilities in various locations
> around the globe.
> 
> So the sales path is:
> 
>1. Retailers order Print books from [IS] or sell an ebook. If they sell
>an ebook they at some point report the sale to [IS] who then report the
>sale to me.
>If a print book is ordered by a retailer then [IS] has the book(s)
>printed and shipped from the nearest location.
>At the end of each month I get a monthly sales report which tells me how
>many books were sold and how much money they owe me after the wholesale
>discount, printing and shipping costs have been deducted from the retail
>price which can vary depending on the retailer and the country a book is
>printed in.
>2. Ninety days after the end of the month the sale was made, either [IS]
>or [LS] direct deposits my proceeds in my PayPal (USD) account.
>3. Upon receiving payment I owe the author their percentage AKA royalty
>of the profit. So when I get paid $10 (USD)for Book Title1 then I owe the
>Author $5 (USD) as per contract.
> 
> 
> So when I receive a monthly sales report I enter the amount of the sales
> (for each author/book title) under:
> Revenue (CAD)
> ^Book Sales
> ^:Authors
> ^Author 1:
> ^Book title 1 (USD) Debit entry
> 
> Credit entry
> Accounts Receivable (CAD)
> ^[IS] USD Credit entry
> 
> When I receive the payment for a sale Eg. $10 USD it is paid to my PayPal
> in USD, then I need to enter a split transaction:
> 
>- Assets>Paypal (CAD)>Paypal (USD) -Credit entry $10 (USD)
>- AccountReceivable (Cad)> [IS] (USD) -Debit Entry $10 (USD)
>- Expenses (CAD)> Cost of books sold 

Re: [GNC] Can't play log files

[davidcousens49]

Don
There sould be no need to play the logfiles on simply moving to a new system.
All that should really be necessary is to copy the data file from one system to
the other.  If you were using any save reports, these can also be copied.  the
data file has the format .gnucash.  if you copy that to a suitable
location on your new system and then start GnuCash and then use File->Open from
the menu to open the datafile you should be good to go.

You should only need to use the backups and restore from the logfiles if GnuCash
crashes during operation (very rare on Linux) and corrupts your main data file.

David Cousens

On Sun, 2022-02-20 at 15:39 -0500, Donald R Slaughter via gnucash-user wrote:
> I changed my laptop from Linux to Windows and reinstalled GnuCash.
> I am unable to import and play my log files. I saved them on my Mac computer’s
> external hard drive (formatted Ex-Fat).  It looks like I will have to start
> from scratch and rebuild my  Bookkeeping system unless I can learn what I am
> doing wrong.
> Sent from Mail for Windows
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Automatic sales tax

[davidcousens49]

The thing is Don all those other software packages charge you an arm and a leg
in most cases for their software. This allows them have paid development teams
who customize their products for each specific jurisdictions in which they
operate. 

GNuCash does not.  GnuCash is used internationally in a wide variety of
countries, maintained totally by volunteer effort by a relatively small core
team with a lot of us hangng around the edges. The customisation depends on
demand and the availability of someone with the necessary skills and knowledge
of the software and software development as well as the interest to carry out
and test the changes.

If KMyMoney does better meet your needs, then by all means use it.

Good luck

David Cousens



On Mon, 2022-02-21 at 10:33 +1300, Don Robertson wrote:
> Seems most other software will do this - Xero, MYOB etc. For open source 
> fans, Kmymoney seems pretty good.
> 
> And before you start mailing me personally, if you don't want to hear 
> what people think of your software, perhaps you should consider removing 
> this from all your posts:
> 
>  >>> Please remember to CC this list on all your replies.
>  >>> You can do this by using Reply-To-List or Reply-All.
> 
> And maybe check your reply to addresses.
> 
> Anyway - it has been fun. Good luck.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] reconciling specific credit cards in an account

[davidcousens49]

The only way GnuCash can possibly know which of multiple cards a transaction is
from is if that information is somehow contained in the data fields of the
record that is being imported, usually something in the description field.
GnuCash tokenizes the information in a number of fields including the
description so it will attempt to match but unless there is a token or
combination of tokens which is unique for each credit card it is not likely to
be successful. You could try downloading and importing the files as OFX files.
This has a service provider field which may contain useful information if the
credit cards were with different providers. GnuCash may or may not utilize
information from this field however. The only other thing you could do is
request the bank to include the credit card number associated with the
transaction in the description field in which case the Bayesian matching should
assign correctly once it has been initially trained to map a given credit card
number onto a specific account.

Does your credit card provider not supply downloads of the transactions
associated with each credit card separately? My bank (also the credit card
issuer) does this for each of the credit cards issued to me and I am able to
import these separately for each card. The transactions between my bank account
and credit card liability account are only for the payments to the credit card
account.

David Cousens

On Wed, 2022-02-16 at 20:02 -0500, scum buster wrote:
> I have been using Gnucash for years..currently version 3.7.  I very much
> appreciate the program.I used quicken for years til I started using
> Gnucash.
> 
> Have never used this forum before, so I hope I don't screw this up. LOL
> 
> I am not a Gnucash expertI know I do some things wrong but I get by
> 
> One thing I always seem to have issues with (I am sure it is user
> error).is with my checking account and credit card charges that come
> through that account
> 
> I download my checking account data as a quicken file and "import" that.
> 
> I have a few credit cards with one company.  The charges come through as "
> bankname online payment" when they hit my checking account.
> 
> That would be fine if I had only one credit card with that bank.
> 
> But with a few different cards, I have issues trying to get them to
> auto-reconcile correctly and end up having to manually add the items and
> manually pick the right account..and that ends up making duplicate
> charges somehow.
> 
> What is the right way to set things up so that Gnucash knows what credit
> card account is being referenced when the charges hit my checking account?
> 
> Thanks for your help!
> 
> 
> -Original Message-
> From: gnucash-user
> [mailto:gnucash-user-bounces+scumbuster=comcast@gnucash.org] On Behalf
> Of gnucash-user-requ...@gnucash.org
> Sent: Wednesday, February 16, 2022 12:00 PM
> To: gnucash-user@gnucash.org
> Subject: gnucash-user Digest, Vol 227, Issue 32
> 
> 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..."
> 
> 

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

Re: [GNC] report of accounts receivable

[davidcousens49]

David 

Does Reports->Business->Customer Summary from the menu (GC4.9) not meet your 
requirements or is it specificaly a listing of the customer contact information 
you need. Unfortunately that is not currently available.  
David Cousens


On Sun, 2022-02-13 at 13:08 +, davidvernonl...@gmail.com wrote:
> I am using The GnuCash accounting system for a sailing club. Customers are
> the sailing club members. I bill them for membership, chartering  and
> services etc.
> 
>  
> 
> At the moment I maintain 2 membership files, one in Excel and another as
> customers in GnuCash.
> 
>  
> 
> I would like to maintain only one, which would be in GnuCash, and use that
> to generate a report which I can either print to a PDF file, or Download to
> an Excel file and share with members.
> 
>  
> 
> However, I cannot find such a report in GnuCash.  The report would be very
> similar to what I see if I click on Business, then Customer, then Customer
> Overview. However that is just a screen which I cannot edit, print or
> download.
> 
>  
> 
> How can I create such a report or any other idea?
> 
>  
> 
> David
> 
> ___
> 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.