Re: [GNC] Owning stocks which are not publicly quoted - which account type suits better?

[Christopher Lam]

Interesting question... as someone who's been intimately involved in some
gnucash code improvements, I have no idea how to account for "my own
company stock share".

Could anyone more qualified (and with knowledge of double-entry as it
applies to personal *and* own company (cf publicly traded company as
investment vehicle) books?

How would the usual company shares activity (eg stock split, dividend,
return of capital, notional distribution, etc) be recorded as?

On Wed, 25 Sept 2024 at 04:57, Boniforti Flavio 
wrote:

> Hi.
> I'm partner and own stocks of the company I work for. This company is not
> on the public market.
> The stock value is defined once per year and dividends are then paid out.
>
> Do I understand correctly, that I don't have to set up a "stock" type
> account for this, as those stocks are not publicly traded?
>
> And the dividends are an account of type "income" - right?
>
> Thanks,
> F.
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.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] How to treat a sale which involves more accounts?

[Christopher Lam]

If your instrument is a valuable item, I'd personally insert it into its
own account, exactly as you'd record purchase of a property:

Purchase: 1/1/2020
Asset:Bank -$1
Asset:Stradivarius +$1

Sale: 1/1/2024
Asset:Stradivarius +$4000
Income:CapGain -$4000

Asset:Bank +$14000
Asset:Stradivarius -$14000

On Wed, 25 Sept 2024, 4:28 am Boniforti Flavio, 
wrote:

> Hi David.
>
> In fact I don't buy instruments with the goal of making profit out of them.
> I collect and play them too. In fact, for this situation I would simply
> account for both purchase and sale as you described.
>
> So there's no tax implication whatsoever in my case.
>
> But then...
>
> I look at my collection of instruments as an asset, not as an expense. I do
> own a bunch of vintage instruments, which have the value corresponding to
> what I've paid for them. So if I consider this collection to be an asset,
> then the suggested accounts you proposed won't work anymore (please correct
> me if I'm wrong).
> I was thinking more of something like this:
>
> PURCHASE:
> "Asset:Bank Account" decrease
> "Asset:Musical Instruments Collection" increase
>
> It becomes for me more difficult to understand how a sale would have to be
> registered, as it not only increases my bank account, but it also decreases
> the musical instruments collection - but only of the value I paid for it
> when I bought it. Given the fact that many items will increase their value
> over time, there might be a surplus. The easy example is: I bought item A
> in 2002 for 1000 and I sell it now in 2024 for 2000 --> my collection
> account would decrease by 1000, my bank account would increase by 2000 but
> where do I put the surplus? I thought of something like this:
>
> SALE:
> "Asset:Bank Account" increase +2000
> "Asset:Musical Instrument Collection" decrease -1000
> "Income:Musical Instrument Sales" increase +1000
>
> If the above is correct and feasible, how would I enter it in GC?
>
> F.
>
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.com
>
>
> Am Di., 24. Sept. 2024 um 06:48 Uhr schrieb David Cousens <
> davidcousen...@gmail.com>:
>
> > Flavio,
> >
> > If you were just buying musical instruments with no intention of earning
> > income with them or in the future, you would simply record the purchase
> > transaction as
> >
> > Asset :Bank account credit  xxx
> > Expenses: Musical Instruments   debit   xxx
> >
> > and any subsequent sale is
> >
> > Asset:bank debit yyy
> > Income:Musical Instrument Sales credit  yyy
> >
> > and you may or may not be required to pay tax on that income depending on
> > your jurisdictions tax rules (in most cases probably not if below some
> > legislated threshold for business activity), and that would be the end of
> > it.  In most jurisdictions you will also likely be below the threshold
> > where any such activities are treated on a cash accounting basis, i.e.
> they
> > are recorded at the point where the money changes hands.
> >
> > When you purchase instruments where the intention is to either resell
> them
> > or otherwise use them to generate income usually on some form of fairly
> > regular basis, then when they are purchased, they are an asset to your
> > enterprise, whether that is simply personal or a business, so the
> purchase
> > becomes an asset rather than an expense. For business usually where
> > turnover is above a specified threshold set by taxation legislation, you
> > will be required to record transactions on an accrual timing basis and
> for
> > purchases, this is generally at the time when the agreement to make a
> > specific purchase is entered into, not when the actual; cash changes
> > hands.  Similarly on sales, when you agree to sell an item, the receipt
> of
> > income is recorded at the time you agree to do so not necessarily when
> you
> > actually receive the funds.
> >
> > There is another accounting principle which requires that the recording
> of
> > expense of items sold should be matched in timing to the recording of the
> > income. recording purchases as an asset class inventory meets the first
> > requirement and recording it as an expense against the Cost of Goods Sold
> > at the timing of the sale meets the second. The Cost of Goods Sold title
> > just arises because most businesses will sell many different types of
> > items. If the expense were recorded at the time of purchase, then the
> > calculation of profit   is thrown out of whack and if you do that your
> > taxation authorities tend to start accusing you of trying to avoid tax.
> >  Such Inventory and CoGS accounts can have subaccounts for specific items
> > or classes of items where knowing that information is  material to the
> > management of the business.  There are also sales taxes, VAT, GST type
> > taxes to deal with as well in some jurisdictions.
> >
> > On Mon, 2024-09-23 at 17:26 +0200, Bonif

Re: [GNC] Report stock price history

[Christopher Lam]

On Mon, 2 Sept 2024 at 21:36, David Houlden  wrote:

> Thank you Martin. That is just about perfect and I think it is probably
> close enough for me.
>
> There are two things that would be really nice to have but I can live
> without them.
>
> 1. Display dates along X axis instead of numbers.
>

Like this? https://github.com/Gnucash/gnucash/pull/2012
___
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] I need Feature Request format help

[Christopher Lam]

Unfortunately the transactions created via Scheduled Transactions are
indistinguishable from regular transactions. There's no way to search for
them specifically*.

*However you could run a Transaction Report, select all accounts, like
start and end dates as "today", and set the General>Date Filter to "date
entered" and you should find all transactions entered today, whether
scheduled or manual.

On Sat, 3 Aug 2024, 4:29 am David Carlson, 
wrote:

> I have run into a situation that got me thinking and it is making my head
> hurt.
>
> I accidentally ran a search on a result register from the Since Last Run
> Druid before I was done reviewing those results.  Now there is no way that
> I can find to recover the list of transactions that were created.
>
> Should I request an improvement to Since Last Run or to the search
> function?  Or to both?
>
> --
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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] Autocomplete only searches displayed entries

[Christopher Lam]

This is fixed in 5.8 -- please get a newer release

https://bugs.gnucash.org/show_bug.cgi?id=799047

On Wed, 10 July 2024, 2:59 pm Keith Edmunds,  wrote:

> I've just upgraded vrom v4.13 to v5.6. I have my ledgers filtered to hide
> reconciled transactions. With 4.13 the autocomplete would search all
> transactions in the ledger, hidden or not. With 5.6, the autocomplete
> doesn't seem to search hidden transactions.
>
> Being able to autoccomplete using previous, albeit hidden, transactions
> was very helpful.
>
> Have I missed a setting some setting somewhere?
>
> Thanks,
> Keith
> --
> "For a list of all the ways technology has failed to improve the quality
> of life, please press three." -Alice Kahn
>
>
> ___
> 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] Consolidated billing of two credit cards

[Christopher Lam]

No one's replied with a direct answer to your query.

On Sun, 7 July 2024, 11:55 pm rsbrux via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> This has led me to consider merging the two credit card accounts in
> GnuCash.  How easy is this?


Easy-- just delete one of the credit card accounts and it'll ask you to
nominate the account to receive all the splits. Just don't do this from
5.7, use 5.6 or 5.8 just released.

Note this operation is irreversible.
___
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] Bug Version 5.7

[Christopher Lam]

Please file all bugs in bugs.gnucash.org

On Mon, 1 July 2024, 2:16 pm Jan Lubach,  wrote:

> LS,
> I encountered the following bug in the new version GnuCash 5.7
> The import qif file procedure has a bug. After trying to apply the qif
> file, the application closes. After trying to open it again, it says
> that the application is still in use. After clicking on "open anyway" the
> qif file has not been imported.
> I downgraded to vs 5.6 again and the qif file was imported as it should be
> Greeting, Jan Lubach
>
___
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] Account export corruption (GnuCash 5.5)

[Christopher Lam]

Hello
Please file a bug on https://bugs.gnucash.org/

On Tue, 25 Jun 2024 at 16:39, David Sumbler  wrote:

> I am using GnuCash 5.5 on xubuntu 24.04.
>
> Every couple of months or so I need to export about 30 accounts, all of
> which are members of the same placeholder account.  I export them using
> the "Export Transactions to CSV" option.  (I then process the
> information further using Python, LibreOffice and Evolution mail.)
>
> However, when I did this last night, I found that only the first
> account is exported correctly: all the subsequent accounts are either
> hopelessly corrupted or missing altogether.  The previous time that I
> did this was before I started using xubuntu 24.04, and presumably I was
> then using a different version of GnuCash.
>
> Is this a known bug?  Do other users find the same problem?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report Shortcomings

[Christopher Lam]

Hi, yes, that is correct.

On Sat, 4 May 2024 at 21:05, Paul Kroitor  wrote:

> So if I understand correctly, you’re saying the there’s already a setting
> (Sorting/Show Account Description) that is supposed to address this, but it
> doesn’t currently work properly. And that the bug was recently or is about
> to be fixed.
>
>
>
> Also, I should look for the fixed version in the nightly builds, right?
>
>
>
> Is that right?
>
>
>
> Sorry for double-checking, I just want to be sure I understand,
>
> Paul
>
>
>
> *From:* Christopher Lam 
> *Sent:* Thursday, May 2, 2024 1:09 AM
> *To:* Paul Kroitor 
> *Cc:* Gnucash Users 
> *Subject:* Re: [GNC] Transaction Report Shortcomings
>
>
>
> Hi,
>
> See Sorting/Show Account Description. This is a bug which will be fixed
> tomorrow.
>
> https://code.gnucash.org/builds/win32/stable/
>
> HTH
>
>
>
> On Wed, 1 May 2024 at 22:07, Paul Kroitor  wrote:
>
> Is there a way to get the Transaction Report to show Account Description
> rather than Account Name in the group header lines (not the detail lines)?
>
>
>
> I have a number of expense accounts that have identical subaccounts, for
> example House-1:Property Tax and House-2:Property Tax. In the CoA, the Name
> for these sub-accounts is just Prop Tax, but the Description is House-1
> Property Tax.
>
>
>
> The problem is that Transaction Reports (when set to primary key = Account
> Name) become confusing because there become several groups simply titled
> Prop Tax with no further distinction. It would be better if it could
> somehow
> more clearly show the account hierarchy - Quicken's Itemized Categories
> report is great at this with it's collapsable tree design - but just
> showing
> the full account name would be a good start.
>
>
>
> In some reports I can choose to show the Account Description (full name),
> but the Transaction Report doesn't seem to have this option.
>
>
>
> Or perhaps I should look at approaching this from the other direction and
> look for an Income / Expense report showing full detail lines?
>
>
>
> Paul
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Report Shortcomings

[Christopher Lam]

Hi,
See Sorting/Show Account Description. This is a bug which will be fixed
tomorrow.
https://code.gnucash.org/builds/win32/stable/
HTH

On Wed, 1 May 2024 at 22:07, Paul Kroitor  wrote:

> Is there a way to get the Transaction Report to show Account Description
> rather than Account Name in the group header lines (not the detail lines)?
>
>
>
> I have a number of expense accounts that have identical subaccounts, for
> example House-1:Property Tax and House-2:Property Tax. In the CoA, the Name
> for these sub-accounts is just Prop Tax, but the Description is House-1
> Property Tax.
>
>
>
> The problem is that Transaction Reports (when set to primary key = Account
> Name) become confusing because there become several groups simply titled
> Prop Tax with no further distinction. It would be better if it could
> somehow
> more clearly show the account hierarchy - Quicken's Itemized Categories
> report is great at this with it's collapsable tree design - but just
> showing
> the full account name would be a good start.
>
>
>
> In some reports I can choose to show the Account Description (full name),
> but the Transaction Report doesn't seem to have this option.
>
>
>
> Or perhaps I should look at approaching this from the other direction and
> look for an Income / Expense report showing full detail lines?
>
>
>
> Paul
>
> ___
> 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] Identify error transaction in QIF import

[Christopher Lam]

Please pick a recent build from
https://code.gnucash.org/builds/win32/stable/

On Sun, 28 Apr 2024 at 21:54, Hao Huang  wrote:

> Hi,
>
> The original problem was "The erroneous transaction seems to be the last
> of those imported". If that's the case, it won't apply. What is shown in my
> case is there is no investment transaction on that day and it's somewhere
> in the middle of all the dates.
>
> Also, in Quicken I can't find any transaction on any investment accounts.
>
> Is there an experiment build available to test the theory?
>
> Thanks
>
> Apr 28, 2024 09:35:40 Geoff :
>
> > Hello HH
> >
> > Please read this:
> >
> > https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111431.html
> >
> > Regards
> >
> > Geoff
> > =
> >
> > On 28/04/2024 9:43 pm, hh8...@gmail.com wrote:
> >> Hi,
> >>
> >> Thanks for the advice.  I run Quicken -> Validate and Repair File and
> it reported a few errors that I fixed.
> >>
> >> However, I still get the same error message
> >>
> >> Missing QIF investment action for transaction dated 9/19/2019
> >>
> >> I opened the QIF in text editor and searched for 9/19’19.  There are
> about 10 instances in a few banking accounts.  Then all others are
> !Type:Prices
> >>
> >> I have more than 20 years of records and more than 100 accounts.  It
> will be very difficult to do this one by one.
> >>
> >> Is it possible for the error message to be more specific and pointing
> to exact transaction?
> >>
> >> 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
> -
> 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] Recommend Accounting Books

[Christopher Lam]

Welcome to Gnucash userlist.

GnuCash will happily handle most of your bookkeeping needs.

IMHO Learning double-entry is an important business skill that you can
acquire via the GnuCash Tutorial & Concepts guide, or
https://www.dwmbeancounter.com/bookkeeping-course.html is another that I've
used.

Please be aware that the inventory part won't be handled via GnuCash: while
you can record your purchases and sales easily (e.g. buy $1000 worth of raw
materials, sell $2000 worth of products), it's difficult to account for the
raw materials inventory levels and products waiting to be sold, calculating
profit margin etc. Other (expensive) products would likely be more suitable
for your needs.

HTH

On Sun, 21 Apr 2024 at 13:11, Jonathan Drews  wrote:

> Hi Folks:
>
>  I am complete novice to double entry accounting. I have GnuCash
> successfully installed:
>
> $ gnucash --version
> GnuCash 5.5
> Build ID: 5.5+(2023-12-16)
>
> on:
>
> OpenBSD 7.5 GENERIC.MP#82 amd64
>
> Can anyone recommend some good books or tutorials on double entry
> acoounting? I searched the arcchives but did not find any posts on
> recommended books. I have ordered this book:
>
> Accounting QuickStart Guide : The Simplified Beginner's Guide by Josh
> Small.
>
> I am opening a fabric store in early May and want to use GnuCash to
> keep track of my sewing fabric sales and inventory. It's pretty
> modest. About 280 individual items. Are there any examples of
> *.gnucash files I can use as a template?
>
>
> --
> Kind regards,
> Jonathan
>
> ___
> 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] Use same transfer column info for identical description

[Christopher Lam]

Glad it went well. If there are improvement ideas please file in
bugs.gnucash.org

On Tue, 16 Apr 2024, 5:59 pm Adrien Laveau,  wrote:

> Hello!
> I went deeper into the importer yesterday night. I sorted 1400 transaction
> in 2h. It could be of course improved but honestly the experience was
> great.
> I have done the hard work and quicker than expected.
>
> Let's see for future updates how the automatic detection works.
>
> Thanks everyone
>
> El mar., 16 abr. 2024 5:19, Christopher Lam 
> escribió:
>
>> The importer has had some upgrades in the past couple years. You can sort
>> by description in the importer, select multiple transactions with similar
>> descriptions, mass assign to a particular account, mass rename the
>> description too, via the right click menu.
>>
>> On Tue, 16 Apr 2024, 4:14 am Adrien Laveau, 
>> wrote:
>>
>>> Hello,
>>>
>>> Thank you both for your time answering my question.
>>>
>>> At the moment my data being in GNC or not is not a big deal.
>>> I have the CSV/XLS fiel extracts (sadly my banks do not connect with GNC
>>> online systems).
>>> It is of the following form :
>>> Description Amount Date
>>> DescA xx 2024/03/12
>>> DescB yy ...
>>> DescC zz
>>> DescB ii
>>> DescB aa
>>> DescC rr
>>> ...
>>>
>>> And I want DescA to go in one transfer, DescB to go in another one and C
>>> in
>>> another one.
>>> I have understood your method and remember it, but for the moment I
>>> cannot
>>> use it as the "initial répartition" is not done.
>>>
>>> And also it does not seem to solve the problem of future transaction witj
>>> the same description.
>>> Indeed I plan to regularly get the CSV from sll my accountd and import
>>> them
>>> in GNC and I would have expected those new transaction to take the
>>> correct
>>> transfer action.
>>>
>>> The best guess I have now is to do it in Excel before importing and
>>> having
>>> the mapping I am looking for, directly in Excel.
>>>
>>> Thanks again
>>>
>>> El lun., 15 abr. 2024 14:12, Kevin Buckley via gnucash-user <
>>> gnucash-user@gnucash.org> escribió:
>>>
>>> > On Monday, April 15th, 2024 at 04:40, Jim DeLaHunt <
>>> list+gnuc...@jdlh.com>
>>> > wrote:
>>> > >
>>> > > Hello, Adrien, and welcome to MusicBrainz!
>>> >
>>> > Surely: "... welcome to GnuCash!" ?
>>> >
>>> > >
>>> > > On 2024-04-14 13:03, Adrien Laveau wrote:
>>> > >
>>> > > > Hello community,
>>> > > >
>>> > > > I uploaded 5 years worth of bank account transaction to gnu-cash.
>>> > > >
>>> > > > I would like the apply the same transfer information to all the
>>> > > > transactions having the same description and keep applying it
>>> > > > automatically to all future transaction.
>>> > >
>>> > >
>>> > > It sounds like you want to do two different things:
>>> > >
>>> > > 1. Change the details ("transfer column info") which you have already
>>> > > imported into your book file to match your desired contents.
>>> > > 2. Ensure that GnuCash uses your desired contents for future
>>> > > transactions which you enter into GnuCash using the "same
>>> description".
>>> > >
>>> > > I don't have easy suggestions for #1, except to go through
>>> transactions
>>> > > one by one and correct them. It may be tedious, but you only have to
>>> do
>>> > > it once. (I have a difficult suggestion: to edit the GnuCash XML book
>>> > > file. This is dangerous but sometimes effective. It requires skills
>>> in
>>> > > working with XML and file formats.)
>>> > >
>>> >
>>> > As someone who's not completely unfamiliar with editing GnuCash's
>>> > XML, I would like to say that doing what you are suggesting you
>>> > want to do here, by editing the XML, is going to be a large task,
>>> > because you would have to identify the various GUIDs (32 character
>>> > strings of text that give you no clue as to what each one is) that,
>>> > in the XML file, take the place of what you see, as 

Re: [GNC] Use same transfer column info for identical description

[Christopher Lam]

The importer has had some upgrades in the past couple years. You can sort
by description in the importer, select multiple transactions with similar
descriptions, mass assign to a particular account, mass rename the
description too, via the right click menu.

On Tue, 16 Apr 2024, 4:14 am Adrien Laveau,  wrote:

> Hello,
>
> Thank you both for your time answering my question.
>
> At the moment my data being in GNC or not is not a big deal.
> I have the CSV/XLS fiel extracts (sadly my banks do not connect with GNC
> online systems).
> It is of the following form :
> Description Amount Date
> DescA xx 2024/03/12
> DescB yy ...
> DescC zz
> DescB ii
> DescB aa
> DescC rr
> ...
>
> And I want DescA to go in one transfer, DescB to go in another one and C in
> another one.
> I have understood your method and remember it, but for the moment I cannot
> use it as the "initial répartition" is not done.
>
> And also it does not seem to solve the problem of future transaction witj
> the same description.
> Indeed I plan to regularly get the CSV from sll my accountd and import them
> in GNC and I would have expected those new transaction to take the correct
> transfer action.
>
> The best guess I have now is to do it in Excel before importing and having
> the mapping I am looking for, directly in Excel.
>
> Thanks again
>
> El lun., 15 abr. 2024 14:12, Kevin Buckley via gnucash-user <
> gnucash-user@gnucash.org> escribió:
>
> > On Monday, April 15th, 2024 at 04:40, Jim DeLaHunt <
> list+gnuc...@jdlh.com>
> > wrote:
> > >
> > > Hello, Adrien, and welcome to MusicBrainz!
> >
> > Surely: "... welcome to GnuCash!" ?
> >
> > >
> > > On 2024-04-14 13:03, Adrien Laveau wrote:
> > >
> > > > Hello community,
> > > >
> > > > I uploaded 5 years worth of bank account transaction to gnu-cash.
> > > >
> > > > I would like the apply the same transfer information to all the
> > > > transactions having the same description and keep applying it
> > > > automatically to all future transaction.
> > >
> > >
> > > It sounds like you want to do two different things:
> > >
> > > 1. Change the details ("transfer column info") which you have already
> > > imported into your book file to match your desired contents.
> > > 2. Ensure that GnuCash uses your desired contents for future
> > > transactions which you enter into GnuCash using the "same description".
> > >
> > > I don't have easy suggestions for #1, except to go through transactions
> > > one by one and correct them. It may be tedious, but you only have to do
> > > it once. (I have a difficult suggestion: to edit the GnuCash XML book
> > > file. This is dangerous but sometimes effective. It requires skills in
> > > working with XML and file formats.)
> > >
> >
> > As someone who's not completely unfamiliar with editing GnuCash's
> > XML, I would like to say that doing what you are suggesting you
> > want to do here, by editing the XML, is going to be a large task,
> > because you would have to identify the various GUIDs (32 character
> > strings of text that give you no clue as to what each one is) that,
> > in the XML file, take the place of what you see, as the transfer
> > account, in the Register.
> >
> > As Jim implies, it could be done, but I'm not sure you would want
> > to.
> >
> > There may, depending on how cleanly your old data was imported,
> > be a bit of a "saving grace", as to what you are trying to do,
> > via an approach that doesn't mean you need to go through ALL
> > your TXNs one by one. You might still need to address a small
> > number of outliers.
> >
> > It does, however, mean "Deleting" some things, but don't stop
> > reading yet, as it's not as bad as it sounds.
> >
> > As I understand things, you have ended up with a lot of TXNs that
> > look like, where Desc1 is the same string every time
> >
> > Description:  Desc1,   Transfer account:  XFR1
> > Description:  Desc1,   Transfer account:  XFR2
> > Description:  Desc1,   Transfer account:  XFR1
> > Description:  Desc1,   Transfer account:  XFR3
> > Description:  Desc1,   Transfer account:  XFR3
> > Description:  Desc1,   Transfer account:  XFR2
> > Description:  Desc1,   Transfer account:  XFR1
> >
> > scattered across any number of accounts, whereas you want all
> > those TXNs to be going into a single Transfer account: let's
> > say, XFR1.
> >
> > So, I need to assume that, after you imported them, you have a
> > chart of accounts (and let's assume the transfer accounts are
> > all Expenses, so as to have a top-level account to work with)
> > something akin to the following, where all of your imported
> > TXNs are in one of three NEW transfer accounts, so
> >
> > Expenses
> >+- XFR1
> >+- XFR2
> >+- XFR3
> >
> > and that there's nothing but your imported TXNs that have those
> > new transfer accounts associated with them.
> >
> > If you ended up importing your old data so that your old TXNs
> > ended up associated with existing transfer accounts, then stop
> > reading, as you are going to have to do 

Re: [GNC] Recording transactions (date)

[Christopher Lam]

This is the formal terminology that the accountancy expert bodies deem
"revenue recognition". Numerous formal (see IFRS and GAAP) publications
exist, with a much better supporting evidence than our informal discussions
here.

On Tue, 9 Apr 2024, 6:12 am R Losey,  wrote:

> Since I first learned about recording transactions, I have always dated a
> transaction on the date I wrote the check; similarly, when entering credit
> card transactions, I use the date that I actually used the credit card.
>
> Recently, however, I was having a discussion with a friend and he said that
> he uses the bank or credit card date of entry for all of his transactions.
>
> I thought this was strange - probably because it is different from the
> method I've used all of my life. Perhaps I am the odd one... or perhaps
> it's merely a matter of choice, so I thought I'd bring it up to this list
> to see what people think about it.
>
> From (a very brief) research about this topic, perhaps this is the
> difference between cash basis accounting and accrual accounting?
>
>
> After thinking about it for a bit, one issue with using the date that the
> transactions occur is the reports, especially if one has repeating
> transactions.  For example, if the satellite service bill is paid each
> month on the 28th, using my method, I record a transaction on the 28th. My
> friend will see it on the 29th or 30th, but if the weekend or holiday hits
> just right, it can be the 1st or 2nd before he sees it. In the long run
> everything should be the same, but the monthly sub-totals can look odd.
> Checks can be even worse... someone may hang onto one for weeks.
>
> I'd appreciate thoughts on the topic.
> --
> _
> Richard Losey
> rlo...@gmail.com
> Micah 6:8
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Can't import .qif files from quicken since latest update

[Christopher Lam]

Correct Geoff, and the latest nightlies will have the correct fix.

 https://code.gnucash.org/builds/win32/stable/

On Sun, 7 Apr 2024, 12:10 pm Geoff,  wrote:

> I suspect this bug fix in the 5.6 release notes is the cause:
>
> Bug 799225 - QIF Importer Crashes Silently after "Start Import" Button:
> Don't allow a QIF investment transaction without an action (buy/sell/etc)
>
> I *think* it was intended to block *investment* transactions but it
> appears to have blocked *banking* transactions too?
>
> Geoff
> =
>
> On 7/04/2024 11:44 am, Ian Cuthbertson wrote:
> > Bryan
> > This problem seems to be caused by the latest update (5.6) .I import
> > direct from a bank and got the same error message but when I used an
> > earlier version (5.4) transactions imported OK. Problem has been reported
> > in another thread.
> > Ian
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] View Transactions After Importing from CSV

[Christopher Lam]

Hi, enhancements should be logged in bugs.gnucash.org

On Fri, 5 Apr 2024, 8:56 am Tom Balazs,  wrote:

> >I think it already does that for the Scheduled Transactions. It says
> something like, oh some time has passed, would you like me to create these
> transactions which you created in the Scheduled Transaction window. Okay,
> here is a register page showing the transactions I just created.
>
> I have already set up some Scheduled Transactions. So often when I open
> GnuCash it gives me a "Since Last Run" window. That gives me some
> information about the transactions it is going to create. At the bottom of
> that window is a checkbox which says, "Review Created Transactions". If I
> check that box, then GnuCash will take me to the main app and there is a
> tab named "Created Transactions". There I can see the transactions which
> were just created.
>
> That is what I want to see for Imported Transactions.
>
>
>
>
> On Tue, Apr 2, 2024 at 12:45 PM Tom Balazs  wrote:
>
> > Yes, I see that.
> > But I mean that GnuCash should take me to a tab that looks like how it
> > displays the results of a Find Transaction. It opens a Register page and
> > shows only the matching transactions.
> > I think it already does that for the Scheduled Transactions. It says
> > something like, oh some time has passed, would you like me to create
> these
> > transactions which you created in the Scheduled Transaction window. Okay,
> > here is a register page showing the transactions I just created.
> >
> >
> >
> > On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel 
> > wrote:
> >
> >> During the actual importation process, GNC always shows a confirmation
> >> dialogue box to take an action on all transaction it found. This is
> where
> >> you get a chance to select 'A' to add transaction, 'U+C' to update and
> >> clear matched one, 'C' to clear existing matched one, or select nothing
> and
> >> do nothing with that transaction. This is automatic -- ie there is
> nothing
> >> needs to be done, either via setting or manually, to trigger it to come
> up
> >> during every import. Note that if a transaction is matched incorrectly,
> you
> >> can check either 'U+C' or 'C" and then double clicking on it will bring
> up
> >> another dialogue box with a list of transactions it believe matches or
> are
> >> similar from which you can select on that it should match with.
> >>
> >> -Original Message-
> >> From: Tom Balazs 
> >> Sent: Friday, December 22, 2023 7:02 AM
> >> To: Post to GnuCash User 
> >> Subject: [GNC] View Transactions After Importing from CSV
> >>
> >> I'm using Financisto+ on my Android phone. So I am often exporting
> >> transactions from that, and importing them into GnuCash. Is there an
> option
> >> where I can view the transactions I just imported? So they appear on one
> >> page, as if I did a Find in GnuCash. I think I came across that once,
> but I
> >> can't find it again.
> >>
> >> 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] (Multicolumn) Reports no longer sort accounts by account code after date change

[Christopher Lam]

Please file a bug in https://bugs.gnucash.org/ and include relevant
screenshots.

On Sun, 21 Jan 2024 at 08:17, Paul Bente via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Specifically, Income Statement (Multicolumn) and Balance Sheet
> (Multicolumn) Reports
>
> I’m currently using GnuCash 5.5 on Mac OS Sonoma 14.2.1. As I have done
> for years now, I’m preparing year-end reports using Income Statement
> (Multicolumn) and Balance Sheet (Multicolumn) from the Reports menu. I have
> assigned Account Codes to Placeholder accounts so they sort in an
> informative order instead of alphabetically by account name. I’m seeing
> new, strange behavior this year. When I open the Income Statement
> (Multicolumn) report it defaults to the current period 2024 (income and
> expenses from 1/1/2024 to current date) and the Placeholder accounts sort
> by Account Codes as expected. When I use “Options” to edit the start and
> end of period to 1/1/2023 and 12/31/2023 and “Apply”, the sort order of
> Placeholders changes to alphabetical. A similar thing happens with the
> Balance Sheet (Multicolumn) report.
>
> This is new behavior. I have been using these reports for years including
> when they were under the Experimental heading. I was using Gnucash 4 last
> January (probably 4.13 as I usually keep up to date) without this problem.
> Curiously, when I open a saved report configuration from last year, the
> Placeholders sort by Account Code but if I edit the dates using Options,
> that report also changes to alphabetical sorting.
> Additional experimenting shows that any change to report dates triggers
> this behavior. This behavior does not occur with the non-Multicolumn Income
> Statement or Balance Sheet in my limited testing.
>
> Has anyone else seen this or is there a configuration parameter somewhere
> that I am missing? I suspect this may be a bug in Gnucash 5.
>
> Best Regards,
> Paul
>
> ___
> 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] Feature request: Import assistant, room for big improvements

[Christopher Lam]

On Tue, 16 Jan 2024, 2:13 pm David Cousens, 
wrote:

>
> I haven't yet imported anything under v5.5. but will be catching up in a
> few
> days. Being able to edit/add data to the description and or memo fields
> would be
> something I would find useful too as the imported bank data often has
> limited
> info about what the purchase was for


(Bis) have you tried right click the transaction(s) during the import
matching process?


>
>
> David Cousens
>
>
>
>
> On Mon, 2024-01-15 at 22:48 -0600, David Carlson wrote:
> > Which import assistant is being discussed here?  The Generic assistant
> > behind the OFX and QIF imports is quite limited in placing new
> transactions
> > into the desired account or in matching incoming transactions to correct
> > pre-existing transactions, but the new CSV transaction importer is
> better,
> > if harder to configure optimally.  Also, I think they all have changed in
> > recent GnuCash releases, so tell us which release you are currently
> using.
> >
> > I doubt that the Generic assistant can be improved very much unless it is
> > completely rewritten.
> >
> >
> > On Mon, Jan 15, 2024 at 10:26 PM Phyllis Bruce 
> wrote:
> >
> > > 👍
> > >
> > >
> > > > On Jan 15, 2024, at 10:17 PM, Derek Atkins  wrote:
> > > >
> > > > 
> > > > No, I would call that the description.
> > > > -derek
> > > > Sent using my mobile device. Please excuse any typos.
> > > >
> > > > > On January 15, 2024 23:06:07 Phyllis Bruce 
> wrote:
> > > > >
> > > > > Thanks, David.  I think I am being unclear.  My research provides
> what
> > > you
> > > > > call the transfer account for unmatched items.  That's all good.
> It is
> > > the
> > > > > memo field which I use to remind me of what I did that is not
> available
> > > in
> > > > > the reconciliation screen.  For instance I want to remember that I
> paid
> > > > > Amazon for *smart plugs*, or Sandi paid me $70 for *her share of
> > > groceries
> > > > > at Christmas*.  Would you call that the "action"?
> > > > >
> > > > > On Mon, Jan 15, 2024 at 3:21 PM David Cousens <
> davidcousen...@gmail.com
> > > >
> > > > > wrote:
> > > > >
> > > > > > Ulrich,
> > > > > >
> > > > > > There is nothing to stop you supplying the transfer account
> > > information in
> > > > > > an
> > > > > > import record if it is available. There is a header which can be
> > > assigned
> > > > > > to the
> > > > > > appropriate column of your input file for the transfer account.
> > > > > >
> > > > > > The first time you import with a given account name in he record
> you
> > > will
> > > > > > be
> > > > > > asked to specify the internal GnuCash account to which it
> corresponds.
> > > > > > After
> > > > > > that it will be matched to that account.
> > > > > >
> > > > > > The Bayesian process only assigns a probable account in cases
> where
> > > > > > the
> > > > > > import
> > > > > > record does not specify the  transfer account.
> > > > > >
> > > > > > David Cousens
> > > > > >
> > > > > > > On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> > > > > > > Hello fellow GnuCash users,
> > > > > > >
> > > > > > > I wonder if there are plans on improving the import filter, for
> > > importing
> > > > > > > bank transfers.
> > > > > > > The situation now is, that some hidden engine tries to learn
> from
> > > doing.
> > > > > > > But the truth is, that even after one year of importing bank
> > > transfers, I
> > > > > > > have to check every single transaction, since errors keep
> occurring.
> > > If I
> > > > > > > miss an error, this transaction is put in the wrong ledger
> account.
> > > > > > >
> > > > > > > E-boekhouden.nl uses an import assistant where you can specify
> a
> > > ledger
> > > > > > > account number, other keywords and/or amounts of money. The
> import
> > > > > > > assistant puts the transactions into the right ledger account,
> with
> > > far
> > > > > > > less errors than with GnuCash. In fact, only where a specific
> > > > > > > keyword,
> > > > > > > leger number or amount is missing, or where no import rule is
> made
> > > for a
> > > > > > > specific payment, the transaction has to be placed into the
> right
> > > general
> > > > > > > ledger by hand.
> > > > > > >
> > > > > > > Have a nice day!
> > > > > > >
> > > > > > > --
> > > > > > > नमस्ते (Namasté),
> > > > > > > Ulrich
> > > > > > >
> > > > > > >
> > > > > >
> > >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸
> > > ,ø
> > > > > > > ¤º°`°º¤ø
> > > > > > >
> > > > > > > " Can't talk to you without talking to me; we're guilty of the
> same
> > > old
> > > > > > > thing.
> > > > > > >   Thinking a lot about less and less, and forgetting the Love
> we
> > > > > > > bring "
> > > > > > >[Grateful Dead, in: 'Althea']
> > > > > > >
> > > > > > >
> > > > > >
> > >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸
> > > ,ø
> > > > > > > ¤º°`°º¤ø
> > > > > > >  Mijn blog: ✡ theskepticalthei

Re: [GNC] Feature request: Import assistant, room for big improvements

[Christopher Lam]

Has anyone tried right click the relevant transaction(s) in the ofx or csv
import assistant?

On Tue, 16 Jan 2024, 12:49 pm David Carlson, 
wrote:

> Which import assistant is being discussed here?  The Generic assistant
> behind the OFX and QIF imports is quite limited in placing new transactions
> into the desired account or in matching incoming transactions to correct
> pre-existing transactions, but the new CSV transaction importer is better,
> if harder to configure optimally.  Also, I think they all have changed in
> recent GnuCash releases, so tell us which release you are currently using.
>
> I doubt that the Generic assistant can be improved very much unless it is
> completely rewritten.
>
>
> On Mon, Jan 15, 2024 at 10:26 PM Phyllis Bruce 
> wrote:
>
> > 👍
> >
> >
> > > On Jan 15, 2024, at 10:17 PM, Derek Atkins  wrote:
> > >
> > > 
> > > No, I would call that the description.
> > > -derek
> > > Sent using my mobile device. Please excuse any typos.
> > >
> > >> On January 15, 2024 23:06:07 Phyllis Bruce 
> wrote:
> > >>
> > >> Thanks, David.  I think I am being unclear.  My research provides what
> > you
> > >> call the transfer account for unmatched items.  That's all good.  It
> is
> > the
> > >> memo field which I use to remind me of what I did that is not
> available
> > in
> > >> the reconciliation screen.  For instance I want to remember that I
> paid
> > >> Amazon for *smart plugs*, or Sandi paid me $70 for *her share of
> > groceries
> > >> at Christmas*.  Would you call that the "action"?
> > >>
> > >> On Mon, Jan 15, 2024 at 3:21 PM David Cousens <
> davidcousen...@gmail.com
> > >
> > >> wrote:
> > >>
> > >>> Ulrich,
> > >>>
> > >>> There is nothing to stop you supplying the transfer account
> > information in
> > >>> an
> > >>> import record if it is available. There is a header which can be
> > assigned
> > >>> to the
> > >>> appropriate column of your input file for the transfer account.
> > >>>
> > >>> The first time you import with a given account name in he record you
> > will
> > >>> be
> > >>> asked to specify the internal GnuCash account to which it
> corresponds.
> > >>> After
> > >>> that it will be matched to that account.
> > >>>
> > >>> The Bayesian process only assigns a probable account in cases where
> the
> > >>> import
> > >>> record does not specify the  transfer account.
> > >>>
> > >>> David Cousens
> > >>>
> >  On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> >  Hello fellow GnuCash users,
> > 
> >  I wonder if there are plans on improving the import filter, for
> > importing
> >  bank transfers.
> >  The situation now is, that some hidden engine tries to learn from
> > doing.
> >  But the truth is, that even after one year of importing bank
> > transfers, I
> >  have to check every single transaction, since errors keep occurring.
> > If I
> >  miss an error, this transaction is put in the wrong ledger account.
> > 
> >  E-boekhouden.nl uses an import assistant where you can specify a
> > ledger
> >  account number, other keywords and/or amounts of money. The import
> >  assistant puts the transactions into the right ledger account, with
> > far
> >  less errors than with GnuCash. In fact, only where a specific
> keyword,
> >  leger number or amount is missing, or where no import rule is made
> > for a
> >  specific payment, the transaction has to be placed into the right
> > general
> >  ledger by hand.
> > 
> >  Have a nice day!
> > 
> >  --
> >  नमस्ते (Namasté),
> >  Ulrich
> > 
> > 
> > >>>
> >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> >  ¤º°`°º¤ø
> > 
> >  " Can't talk to you without talking to me; we're guilty of the same
> > old
> >  thing.
> >    Thinking a lot about less and less, and forgetting the Love we
> >  bring "
> > [Grateful Dead, in: 'Althea']
> > 
> > 
> > >>>
> >
> ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø
> >  ¤º°`°º¤ø
> >   Mijn blog: ✡ theskepticaltheist.eu ✡
> >  ___
> >  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] Train (or Configure?) Bayesian Mapping

[Christopher Lam]

Unfortunately there's no mechanism to retrain the Bayesian matcher based on
past ofx files. The old ofx textual fields description/notes etc are
discarded when ofx import completes.

On Sun, 3 Dec 2023, 9:18 am Matt Wise,  wrote:

> Hi GnuCash users!
>
> I've been using GnuCash for the last ~3 years and have slowly been
> improving my use of various automation tools.  I'm fetching transactions
> from my bank with aqbanking, but I still need to manually map transactions
> to an account (such as Expenses:Grocery).  For a little while, it seemed
> like Bayesian mapping was enabled for one of my bank accounts, but it did a
> terrible job.  Reading the docs, I found I could delete the existing
> mappings (tools -> import map editor).  However I would really like to
> generate new mappings based on the past years' manually mapping I've done.
> Is there a way to do that?
>
> Alternatively, is there a way to map based on previous transactions that
> have the exact same description?
>
> Thanks so much!
>
> Matt
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Can I find transactions into an account that has only one split?

[Christopher Lam]

Check the Transaction Report's Account tab.

On Wed, 22 Nov 2023, 2:36 pm Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> Yeah, that's why I started off with this would be trial and error level
> effort.
>
> The OP wants transactions where at least one split appears in set A, but
> excludes any such transactions when *other splits* also appear in set B.
>
> I *think* this is possible, but I have to admit, I've never tried.
>
> I'm guessing that running two separate Finds, one from the Accounts
> page, and one from the Find results register is the way to go, but I
> could be mistaken.
>
> I'm guessing that trying it all in one go will fall into the trap you
> mention.
>
> But if the result register is somehow 'fixed' to the original splits
> found, this entire endeavor may not be possible.
>
> Regards,
> Adrien
>
> On 11/22/23 12:00 AM, Derek Atkins wrote:
> > Keep in mind that, GENERALLY, the search is on a SPLIT basis, not a
> > TRANSACTION basis.  So if you do a search on "Account == X AND Account ==
> > Y" you will get an empty set, because it is impossible to find anything
> > where Split.account == X and Split.account ALSO equals Y.
>
> ___
> 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] Reconciliation with a strange opening balance

[Christopher Lam]

A bit tangential to the issue of reconciliation is that fundamentally IMV
reconciliation means to marry up (aka reconcile) the physical periodic
(monthly/quarterly/annually) bank statements *against* your own books which
carry the canonical data which hopefully supports your financial activity.

Gnucash reconciliation only stores, for each reconciliation:

   - an account's last Reconciliation date
   - each split's reconciliation status n/c/y,
   - each split's reconciliation date (which is the same as the last
   Reconciliation date).

It doesn't store other info such as: starting balance, statement number;
and doesn't store the reconciled starting and ending balances.

It *could* be transformed to store all these additional data:

   - statement ID number
   - statement's start and ending date
   - statement's start and ending balance
   - list of splits identified within the statement

And would be somewhat more robust (ie you could ask gnucash to display the
contents of the feb2014 statement), and we would potentially be able to
re-reconcile a previous statement (e.g. I deleted an old reconciled split
in error and wish to re-reconcile its statement) but this would require a
complete backward-incompatible upgrade in the internal data schema, there
doesn't seem to be a demand of it, nor manpower to implement it, and I
think it's simply overkill.

Thus the reconciliation is currently limited to the state that exists
currently.

E&OE

On Mon, 13 Nov 2023, 11:21 pm Mahon Finbar via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> Hello,
>
> The recent discussion on reconciliation was helpful in trying to sort
> out some anomalies I have.
>
> When I do the latest reconciliation of one of my accounts the opening
> balance is 10,448.43 and gives me an amount of inbalance which is way off.
>
> Following the advice in the recent posts I tried working backwards to
> see if I could find any errors.
>
> I got close to 0.00 from time to time and was satisfied enough to
> consider a balancing entry, but was intrigued on where the 'error' might
> have been.
>
> I set off to see where, but, in the course of my search, I tried to find
> the number 10,443.43 in the account, as a baseline, but didn't find one.
>
> If I understand the process of reconciliation the number should be
> somewhere in the account, should it not??
>
> Just tell me I am barking up the wrong tree, if I am making an error.
>
> Finbar
>
> ___
> 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] New Balance entry

[Christopher Lam]

It's poorly documented.
https://bugs.gnucash.org/show_bug.cgi?id=563565
___
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] I need basic help

[Christopher Lam]

As a non-accountant (although I pretend to be one sometimes) I can't figure
out Dr/Cr except that Dr=left,Cr=right.

But I do understand numbers (referring to dollars, or, a hot potato).

My 4 Rules:
1. Each transaction must total to zero (i.e. after a transaction is
complete, no hot potato burning my hand)
2. A positive balance in my bank account is reassuring (lots of hot
potatoes in my bank)
3. An income amount is usually negative, because it denotes the world.
(i.e. when I receive income, the world loses some potatoes).
4. No potatoes are created or destroyed

Example. I offer labour, I get paid in dollars
Income:Salary -$200
Asset:Bank +$200

I purchase from the shops
Asset:Bank -$50
Expenses:Groceries +$50

I invest some of my dollars, and borrow a lot of dollars to buy a house.
Asset:Bank -$100
Liability:Loan -$99,900
Asset:House +$100,000

etc.

Note within a transaction the total must always be zero. Incidentally
Gnucash stores amounts exactly like these potatoes above.

On Mon, 23 Oct 2023 at 01:37, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Edwin,
>
> Debit/Credit is just Left/Right.
>
>
>
> Maybe this will help...
>
> The Accounting Equation:
>
> Assets - Liabilities = Equity
>
> (let's make all terms 'positive')
>
> Assets = Liabilities + Equity
>
> (now, we'll split off a subset of Equity)
>
> Assets = Liabilities + Equity + Retained Earnings
>
> (now, we'll substitute temporary accounts for Retained Earnings)
>
> Assets = Liabilities + Equity + (Income - Expenses)
>
> (now, we'll once again, make all terms 'positive')
>
> Assets + Expenses = Liabilities + Equity + Income
>
>
> And there, you have the full Accounting Equation with the five major
> account types that GnuCash uses.
>
> -
>
> In double-entry accounting, ALL transactions are in the form of:
>
> Debit = Credit
>
> Left = Right
>
>
> The 'Debit' accounts (those that are normally (positive) a Debit
> balance, and increase with a Debit, decrease with a Credit) are on the
> left of the equation:
>
> Assets
> Expenses
>
> The 'Credit' accounts (those that are normally (positive) a Credit
> balance, and increase with a Credit, decrease with a Debit) are those on
> the right of the equation:
>
> Liabilities
> Equity
> Income
>
> A negative balance in any account would indicate either an entry error
> or a contra-balance situation. (rare for individuals)
>
> -
> You can move funds from the left to the right, or vice versa, or between
> any accounts or types on the same side of the equation. (I will use the
> abbreviations Dr. and Cr. here)
>
> Most texts will write transactions Debit first, then Credit as shown
> below. The amounts are not shown, because they *must* be equal.
>
>
> Example Left to Right - Asset to Liability (paying down a debt)
>
> Dr. Liabilities:Loan
>Cr. Assets:Cash
>
> result: decreased Loan owed, decreased Cash on hand, Assets decreased,
> Liabilities decreased - equation still in balance
>
>
>
> Example Right to Left - Income to Asset (receipt of income)
>
> Dr. Assets:Cash
>Cr. Income:Salary
>
> result: increased Cash on hand, increased Salary earned, Assets
> increased, Income increased - equation still in balance
>
>
>
> Example Left to Left(same type) - Asset to Asset (buying land outright)
>
> Dr. Assets:Land
>Cr. Assets:Cash
>
> result: increased Land owned, decreased Cash on hand, Assets shifted -
> equation still in balance
>
>
>
> Example Left to Left(different type) - Asset to Expense (buying groceries)
>
> Dr. Expenses:Food
>Cr. Assets:Cash
>
> result: increased Food expense, decreased Cash on hand, Expenses
> increased, Assets decreased - equation still in balance
>
>
>
> Example Right to Right(same type) - Liability to Liability (paying down
> a loan with a credit card)
>
> Dr. Liabilities:Loan
>Cr. Liabilities:Credit Card
>
> result: decreased Loan owed, increased Credit Card owed, Liabilities
> shifted - equation still in balance
>
>
>
> Example Right to Right(different type) - Equity to Liability
> (recognition of dividends to be paid - business transaction)
>
> Dr. Equity:Retained Earnings
>Cr. Liabilities:Dividends Payable
>
> result: decreased Retained Earnings, increased Dividends owed to
> shareholders, Equity decreased, Liability increased - equation remains
> in balance.
>
>
>
> *it is rare and unusualy for an individual to shift Equity to
> Liabilities and vice versa. Forgiveness of Debt may in some
> jurisdictions be a transfer from Liabilities to Income.
>
>
> Regards,
> Adrien
>
> On 10/20/23 12:02 AM, Edwin Booth via gnucash-user wrote:
> > I need to wrap my head around the whole “debit/credit” concept.
>
> ___
> 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

Re: [GNC] GnuCash 5.4 Repackaged

[Christopher Lam]

There's no known change affecting clean up upon exit. It would be nice if
the bug hunt could be crowd sourced to identify the exact daily build which
introduced this issue

https://code.gnucash.org/builds/win32/stable/


On Fri, 29 Sept 2023, 7:08 pm Ian Keiller via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> Odd thing happens when trying to update from 5.4 to 5.4.1 on Windows.
> Setup shows an error:
> The following applications are using files that need to be updated by
> Setup. It is recommended that you allow Setup to automatically close
> these applications. After the installation has completed, Setup will
> attempt to restart the applications.
>
> GnuCash Program File.
>
> On cancelling, I noticed in Task Manager there is an instance of GnuCash
> still running even though I had exited the the application.
> I have never seen this behaviour before, so could it be a bug introduced
> in 5.4?
>
> ___
> 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] Using GnuCash as an Accounting Tutor

[Christopher Lam]

Addendum to excellent advice given already. If you're offering a pedagogic
approach to accounting principles, it's very likely that you'll have
valuable and useful feedback about the usability of the software for
learners, the correctness of its tools and reports.

The software has improved a lot from previous educators and accounting
professionals alike.

On Sun, 10 Sept 2023, 10:45 am ,  wrote:

> Dear all,
>
> I teach a course in Corporate Valuation Theory that is taken by students
> from a variety of disciplines. Many of them have not studied accounting,
> and
> while I devote two lectures and two homework assignments to the subject, it
> is impossible to convey the depth of this vast subject and for students to
> internalize why double-entry accounting is so extraordinarily powerful.
>
>
>
> I currently use examples built in Excel but am exploring the possibility of
> moving to GnuCash, which allows its users to think in terms of double-entry
> accounting using debits and credits, and to make entries using these terms.
> It allows students to create different types of accounts
> (asset/liability/equity), make journal entries for them using proper
> accounting terminology, and then create financial statements.
>
>
>
> Question: Do you know of a simple accounting primer that uses GnuCash and
> has many examples and some problem sets as well? If so, I would be very
> appreciative if you would share it with me.
>
>
>
> Sincerely and with many thanks in advance
>
>
>
> Thomas Philips
>
> ___
> 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] Budgeting glitch after upgrading to 4.14

[Christopher Lam]

Please upgrade to 5.3 which should have fixed most of these budget issues

On Fri, 28 July 2023, 12:24 pm larry johnston, 
wrote:

> We just finished upgrading from 2.6.15 to 4.14 in Windows 10. Our budget
> has a glitch. In the bottom rows the Income, Expenses, Transfer and
> Remaining to Budget rows all read zeros. In 2.6.15 they totalled Income and
> Expenses and showed if there was something over or under budgeted in the
> Total row (now Remaining to Budget). I can't see any way to get these
> totals into the bottom rows. When we enter new numbers into the budget
> nothing happens in these rows either. The Income and Expense totals in the
> upper rows of the budget are equal so we know the budget is balanced but it
> would be nice to have this confirmed in the bottom rows.
>
> Was something lost in the upgrade? We did run Check and Repair. Or is there
> something else we should be doing?
>
> TIA,
>
> Larry
> ___
> 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] Upgrading to 5.3 from 2.6.15

[Christopher Lam]

On Wed, 26 Jul 2023 at 11:32, john  wrote:

> Yeah, it's gotten a lot faster since Chris Lam figured out it was checking
> every transaction for every split in the transaction and fixed it to only
> traverse the transactions once.
>

This was only 1 part of the speedup: each typical (2 or more splits)
transaction was being scrubbed as many times as they have splits. This was
PR 1651.
The more significant speedup was to eliminate the xaccTransBegin/CommitEdit
before the scrub, and only call them if the transaction needed to be
scrubbed. PR 1654.
Benchmarks:
https://github.com/Gnucash/gnucash/pull/1654#issuecomment-1573876944
___
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] Transferring mutual funds

[Christopher Lam]

Oops forward to user list.

On Fri, 7 July 2023, 12:24 pm AC,  wrote:

> On 2023-07-06 20:46, Christopher Lam wrote:
> > On Fri, 7 July 2023, 11:31 am AC,  wrote:
> >
> >>
> >> I'm able to log into the new broker's website and see the entire history
> >> of each fund since I first purchased shares even though I've only been
> >> with the broker for a week. There just doesn't seem to be a good method
> >> for handling something like this or at least not one that is obvious.
> >>
> >
> > The obvious answer/hack is to simply reparent the stock account from
> > BrokerA:STOCK to BrokerB:STOCK.
> >
> >>
> >
> Yeah, that just makes things strange because inside the account are
> transactions with the old brokerage that would then disagree with the
> account tree.
>
___
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] Transferring mutual funds

[Christopher Lam]

On Fri, 7 Jul 2023 at 05:16, AC  wrote:

> I just took a look at the Advanced Portfolio report to see what GC
> thought about what I had done. It does appear that the basis was lost as
> part of the transfer because for each of the funds that transferred over
> the new basis is exactly the value at the time of the transfer instead
> of the original basis.
>

I believe the advanced portfolio, portfolio, and IFRS weighted-average cost
basis reports all analyze a stock *account'*s old transactions to determine
basis.

Therefore, if you create a lateral transfer from BrokerA:STOCK to
BrokerB:STOCK, it is not surprising that the basis is lost.

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

Re: [GNC] GnuCash 5.0 Budget Reporting on select reports are wrong

[Christopher Lam]

https://bugs.gnucash.org/

On Sat, 15 Apr 2023, 5:49 pm Richard Lindgren, 
wrote:

> How do I file a Bugzilla report?
>
>
>
> Richard
>
>
>
> *From:* Christopher Lam 
> *Sent:* Saturday, April 15, 2023 5:37 AM
> *To:* Richard Lindgren 
> *Cc:* GnuCash users group 
> *Subject:* Re: [GNC] GnuCash 5.0 Budget Reporting on select reports are
> wrong
>
>
>
> It's true that only the "Budget report" has been scrutinized for bugs.
> Please file in Bugzilla.
>
>
>
> On Sat, 15 Apr 2023, 4:38 pm Richard Lindgren, 
> wrote:
>
> I have upgraded my GnuCash program 4.13 to 5.0 (Build ID:
> 5.0+(2023-03-25)) after realizing that the budget expense calculations were
> not correct. Not all the budget reports are wrong, but of the reports that
> I choose to use that are wrong are:
>
>   1.  Budget Income Statement
>   2.  Budget Profit & Loss Statement.
>
> It appears that both the income and expense values(Data) for the above
> listed reports show the values in black (signifying that they are positive
> numbers for each income and expenses?). The other reports that I use (not
> listed) have their values for the income and expenses in black(income) and
> red(expenses). Those calculations appear to be working fine. The reports
> listed above show the calculations incorrect. In my preferences, I have
> checked the box to have all negative amounts to be in "Red".
>
> In addition to accessing the reports menu for my saved reports, the
> program often crashes. I then am required to reopen the program and are
> given five (5) options before being allowed to continue. They are:
>
>   1.  Open Read Only
>   2.  Create a new file
>   3.  Open anyway
>   4.  Open Folder
>   5.  Quit
>
> I choose option # 3 "Open anyway". After doing that, I save the file and
> then I continue with my reports.
>
> If I am doing something wrong, please forgive me and show me the error of
> my ways.
>
> Thank you in advance for your help. I look forward to hearing from you.
>
> Richard Lindgren
> rlindgr...@outlook.com<mailto:rlindgr...@outlook.com>
> 269-876-9100
> ___
> 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 5.0 Budget Reporting on select reports are wrong

[Christopher Lam]

It's true that only the "Budget report" has been scrutinized for bugs.
Please file in Bugzilla.

On Sat, 15 Apr 2023, 4:38 pm Richard Lindgren, 
wrote:

> I have upgraded my GnuCash program 4.13 to 5.0 (Build ID:
> 5.0+(2023-03-25)) after realizing that the budget expense calculations were
> not correct. Not all the budget reports are wrong, but of the reports that
> I choose to use that are wrong are:
>
>   1.  Budget Income Statement
>   2.  Budget Profit & Loss Statement.
>
> It appears that both the income and expense values(Data) for the above
> listed reports show the values in black (signifying that they are positive
> numbers for each income and expenses?). The other reports that I use (not
> listed) have their values for the income and expenses in black(income) and
> red(expenses). Those calculations appear to be working fine. The reports
> listed above show the calculations incorrect. In my preferences, I have
> checked the box to have all negative amounts to be in "Red".
>
> In addition to accessing the reports menu for my saved reports, the
> program often crashes. I then am required to reopen the program and are
> given five (5) options before being allowed to continue. They are:
>
>   1.  Open Read Only
>   2.  Create a new file
>   3.  Open anyway
>   4.  Open Folder
>   5.  Quit
>
> I choose option # 3 "Open anyway". After doing that, I save the file and
> then I continue with my reports.
>
> If I am doing something wrong, please forgive me and show me the error of
> my ways.
>
> Thank you in advance for your help. I look forward to hearing from you.
>
> Richard Lindgren
> rlindgr...@outlook.com
> 269-876-9100
> ___
> 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] Is it reasonable to have sub-accounts under Equity:Fixed Assets?

[Christopher Lam]

If your company was operating for a while before 01/03/22, you'll want your
balance sheet (aka "Statement of Financial Position") to reflect accurately
the value of your assets on 28/02/22. You could input your depreciated
asset values on that date.

However I also like to record the original purchase date of fixed assets,
which helps me tremendously plan ahead wrt warranty determination,
remembering how much and when I paid for something. So, I'd record the
original purchase price on the original purchase date too.

My starting book could look like:

* 01/03/2014 Initial purchase machinery, effective life of 10 years, EOL on
01/03/2024
Equity:Opening Balance -$10,000
Asset:Fixed +$10,000

* 28/02/2022 Accumulated Depreciation (2014 to 2021)
Asset:Fixed -$7,000
Equity:Depreciation +$7,000

* 01/03/2022 Annual Depreciation
Asset:Fixed -$1,000
Expense:Depreciation +$1,000

* 01/03/2023 Annual Depreciation
Asset:Fixed -$1,000
Expense:Depreciation +$1,000

* 01/03/2024 Annual Depreciation
Asset:Fixed -$1,000
Expense:Depreciation +$1,000

Thus, on 01/03/2024 the balance in Asset:Fixed is now $0.

On Mon, 16 Jan 2023 at 20:30, Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:

> Apologies if this is too much an accounting question, but I'm stuck, and am
> trying to work out how GnuCash will handle this.
>
> I'm trying to enter into GnuCash my company accounts for this financial
> year only - I'm not going to bother trying to enter every transaction since
> the company started. So the opening balances should reflect the company's
> financial position on 28/2/2022, and transactions from 1/3/22 being
> recorded.
>
> I have the account
>
> Assets:Fixed Assets
>
> All that contains is test equipment and computer equipment, all of which
> will be depreciated - there's no land, or other things that don't
> depreciate.
>
> I initially set Assets:Fixed Assets to have an opening balance of £x, as
> that's what my accountant told me the total of all thef fixed assets was
> worth. I see that is reflected in the account
>
> Equity:Opening Balances
>
> However, after I asked him, my accountant gave me a breakdown of the net
> value of the individual fixed assets, which have obviously depreciated over
> time.  I thought it would be useful to have their individual net values on
> 28/2/2022 recorded in GnuCash, so when I depreciate them next year, I can
> keep a track of the depreciation. (I also thought of depreciating them
> monthly, which I could probably do with the scheduled transactions, as my
> accountant is using linear depreciation).
>
> That brings me to the problem that my initial entry for the opening
> balance of these fixed assets would be wrong, and should possibly set to
> zero.
>
> Can I set that balance to zero, then delete the appropriate Equity:Opening
> Balances entry?
> Would it be sensible to have a sub-account under  Equity:Fixed Assets, or
> is that just not sensible?
>
> Obviously by the very nature of a double-entry system, in order to debit
> the Fixed Assets, I need to credit somewhere else.
> ___
> 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 4.900 Released

[Christopher Lam]

Note also this release will perform a one-time change to the internal
representation of budget amounts to fix a class of bugs. The budget amounts
will hopefully be more stable and reliable, and reflect the reverse
balanced accounts global preference closely.

Beta testers are needed to verify the behaviour of the budget editor and
reports.

On Tue, 10 Jan 2023, 1:03 pm John Ralls,  wrote:

> The GnuCash development team announces GnuCash 4.900, the first unstable
> release leading to GnuCash 5.0.
>
> This is an unstable release for testing purposes. Do not use it with
> production data! Make a copy of your book to test this release.
>
> New Features
>
> A new Stock Transaction Assistant to guide you through entering most
> investment transactions for stocks, bonds, and mutual funds. You can access
> it from Actions>Stock Assistant when you have the Accounts page ora Stock
> or Fund account register open.
> A new Investment Lots report showing a graph of capital gains and
> losses in a period by investment lot. Note that if you don't use the View
> Lots dialog to manage capital gains and losses this report won't have
> anything to show you. Use Reports>Assets & Liabilities>Investment Lots to
> see the report.
> A new tab on the New/Edit Account dialog called More Properties
> includes entries to set a high and low limit on an account. That's coupled
> to a new column that's available on the Accounts Page, Balance Limit. If
> you set a high or low limit and the account balance falls above or below
> the respective limit an indicator will be shown in the Balance Limit column.
> The description field quickfill in the register now displays a
> drop-down list of possible completions instead of just one inline
> completion.
> File import menu items for the MT940, MT942, and DTAUS formats is
> replaced with a single Import from AQBanking that supports importing any
> file format supported by AQBanking, including the frequently requested CAMT.
>
> Between 4.13 and 4.900, the following bugfixes were accomplished:
> The following fixes will also appear in GnuCash 4.14:
>
> Bug 798588 - sx scrubbing was using incorrect free function
> Bug 798625 - "Last up through report date" changed in 4.12
> Bug 798679 - Unicode normalization should be used for comparison but
> not stored.
> Bug 798702 - Crash in gnc_plugin_page_focus_idle_destroy() closing a
> report before it completes.
> Bug 798705 - New: UI string mismatch: OK vs. Next
> Bug 798717 - Reports > Business > Fancy Invoice duplicates company
> details
>
> The following additional bug fixes are in unstable only:
>
> Bug 403979 - Balance column shows only low order digits when too narrow
>
> If the column is too narrow to display the whole number it will
> display the leading digits with an ellipsis (…).
> Bug 769256 - Change New Account Dialog
>
> Rearrange the New and Edit Account dialog to move the parent selector
> under the description field followed by the account type as a combo (i.e.
> drop down) list.
>
> The following fixes and improvements were not associated with bug reports:
>
> Unicode normalization for string matches is changed from NFKC to NFC.
> This means that font and positional variants will no longer match and is
> unlikely to affect most users. See Unicode Normalization Forms:Canonical
> and Compatibility Equivalence for the technical details.
> The Gtk menu structure has been rewritten to use the newer
> GMenu/GMenuModel system. This change is mostly invisible to users, except
> that to keep menu accelerators (like Q to quit) working on macOS we
> had to let macOS handle the events. That will affect using cut, copy, and
> paste in dialog boxes because the menu will intercept them. That's
> temporary, we hope to have it fixed for GnuCash 4.901.
> The Finance::Quote interface is rewritten in C++. This new design will
> allow much better capture of diagnostics from Finance::Quote making
> troubleshooting problems much easier.
> The perl Finance::Quote utilities gnc-fq-check, gnc-fq-dump, and
> gnc-fq-helper are removed and new commands added to gnucash-cli: --quotes
> info replaces gnc-fq-check and --quotes dump replaces gnc-fq-dump.
>
> New API: The options system has been rewritten in C++ with Scheme wrappers
> for report options. While this is invisible to most users, those who have
> written custom reports should look for deprecation warnings when the custom
> reports are reconciled. The main difference is that option creation and
> registration is now done in a single function call. Nearly all standard
> code defined a local convenience function that wrapped the two steps, for
> example
>
> (let* ((options (gnc:new-options))
>(add-option
>  (lambda (new-option)
>   (gnc:register-option options new-option)
>
>
> called as
>
> (add-option
> (gnc:make-string-optionpagename title key docstring defa

Re: [GNC] NEw user assistance

[Christopher Lam]

I would think that if your home currency is CAD and you buy some USD
stocks, you'd first transfer some cash from your CAD bank into your
brokerage account in USD, then immediately use the latter to purchase your
AAPL.

On Sat, 7 Jan 2023, 5:46 am Karl,  wrote:

> Hi there John,
>
> Thanks for the information. Very helpful! Perhaps I am setting up my
> foreign (USD) investment accounts all wrong. I'm trying to follow the
> instructions and examples in Chapters 9.5 and 9.6, but I can't
> reconcile the instructions with your explanation.
>
> So if I set-up the account structure as you described:
>
> Assets
> Investments
> Stocks
> Stocks-USD
> AAPL
>
>  ... when I go to make an initial purchase of AAPL shares/stock, do I enter
> the transaction in CAD or USD? For example, AAPL closed at $129.62 USD
> today, so if I bought 10 stocks, should my entry be:
>
> DR AAPL stock  1,296.20 (USD)
>   CR Cash 1,296.20 (USD)
>
> or should it be:
>
> DR AALP stock  1,736.91 (CAD)
>   CR Cash  1,736.91 (CAD)
>
> ???
>
> CAD-USD was at $1.00 USD = $1.34 CAD.
>
>
> Ideally, when I run the "Advanced Portfolio" Report, I would like for what
> I'm seeing to be in CAD. Is this possible?
>
> Thanks again for your help. As you can probably tell, I'm terrible with
> computers, but not too bad with accounting! haha
>
> Regards,
>
> *Karl*
>
>
> On Fri, 6 Jan 2023 at 13:12, john  wrote:
>
> > That's a very long-running discussion with another Canadian CPA, see
> > https://bugs.gnucash.org/show_bug.cgi?id=797796
> > and https://bugs.gnucash.org/show_bug.cgi?id=798004.
> >
> > The simplest workaround is to set up an account structure that looks like
> > Assets
> > Investments
> > Stocks
> > Stocks-USD
> > AAPL
> >
> > As long as you keep the priceDB updated with both CAD-USD exchange rates
> > and AAPL prices the Stocks account will show the value of the AAPL shares
> > in CAD. Unfortunately if you have several USD stocks and want to track
> them
> > individually you'd need to do something like
> > Stock-AAPL-CAD
> > Stock-AAPL-USD
> > AAPL
> > Stock-GOOG-CAD
> > Stock-GOOG-USD
> > GOOG
> >
> > Which could be a bit tiresome. An alternative is to set things up as you
> > would normally, i.e.
> > Assets
> > Investments
> > Cash
> > Stocks-USD
> > AAPL
> > GOOG
> >
> > and use the Advanced Portfolio Report to show the values in CAD.
> >
> > I don't understand what you mean by "the currency exchange function", but
> > if you want to retrieve the CAD-USD exchange rate you need to get an
> > Alphavantage API key. The issue in bug 798599 is resolved because
> > Alphavantage put currency exchange rates back to being available with a
> > free API key. F::Q version 1.53 switched to a different retrieval method
> > that broke retrieving precious metal rates (e.g. XAU-CAD) so if that's
> your
> > concern you need a F::Q version that isn't 1.53; the current release is
> > 1.54.
> >
> > Regards,
> > John Ralls
> >
> >
> > On Jan 6, 2023, at 6:05 AM, Karl  wrote:
> >
> > Hello David and everyone,
> >
> > Thank you for your messages. A little background about myself: I'm a
> > Canadian (born and raised), and a CPA. I have been using GnuCash for a
> > while now, but am interested in delving deeper into its functions that
> can
> > be useful to me. I use GnuCash only for personal and private use for my
> > household, not for business purposes in any way.
> >
> > I am currently running Microsoft Windows 10 Pro (Build 19045) on my main
> > machine at home, and am using GnuCash Version 4.10 with "Finance::Quote
> > 1.54" and perl (v5.32.1).
> >
> > I am enjoying the Chapter 9 - Investments part of GnuCash and have
> > successfully set up the Automatic Online Retrieval of Stock Quotes. What
> a
> > great function!
> >
> > The trouble is, I can't figure out a way to have any foreign investments
> > denominated in my local currency (CAD). For example, if I invest in,
> let's
> > say, Apple Inc (NASDAQ: AAPL), which is traded on the NASDAQ (a foreign
> > market for me), the share(s) value only shows up in the currency of the
> > market in which it is being traded (in this case, USD). How do I get
> > GnuCash to denominate and show me my foreign investments in my local
> > currency (CAD)?
> >
> > Not sure if this is related but, I also tried to set-up the currency
> > exchange function, but it appears that this is no longer functional due
> to
> > the API Key from Alphavantage. Is this true?
> > https://bugs.gnucash.org/show_bug.cgi?id=798599
> >
> > Thank you everyone. Happy to see that there is a supportive and
> > collaborative community here!
> >
> > Regards,
> >
> > *Karl*
> >
> >
> > On Thu, 5 Jan 2023 at 20:07, David H  wrote:
> >
> > Welcome to gnucash Karl.
> >
> > I think from memory Nabble went away during the pandemic about 12 months
> > ago, so maybe forget that one :-)  If you have any questions, post them
> > here to the gnucash user list (gnucash-user@gnucash.org) and

Re: [GNC] Feature request - prevent a transaction with todays date

[Christopher Lam]

On Tue, 27 Dec 2022, 8:44 pm Stan Brown,  wrote:

>
>
> A related feature I _would_ like to see is the ability to specify a date
> range within which no new transactions could be entered. I would use
> that to prevent myself from unintentionally changing transactions from
> prior years. The existing mechanism, where the only form of date range
> is N days before today, doesn't seem very helpful to me, since I have to
> change the value of N every day.
>

Among this discussion, this is one feature request that looks interesting:
if the user inputs a transaction dated *before* the last reconciliation
date, there could/should be a warning that the user should reconsider the
date, because the new transaction would likely affect the previous
reconciliations. Any thoughts from long term users?


>
___
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] What accounts should I reconcile?

[Christopher Lam]

These are nice examples but I think are still formally assets and
liabilities. e.g. I buy dinner for myself and sibling

Asset:Bank -$50
Asset:Sibling $25
Expense:Restaurant $25

Later hopefully sibling pays back

Asset:Sibling -$25
Asset:Bank +$25

The original question was IIUC about reconciling Income & Expense accounts.
It's perfectly fine to reconcile expense accounts, e.g. we could reconcile
the Expenses:Fuel against Fuel card statements.

FWIW the first example (temporary loans, or suspense accounts) aim to have
zero balance, and there's upcoming work to better highlight them.
https://github.com/Gnucash/gnucash/pull/1480 -- the highlight is a warning
to show the balance is outside a user specified range. It can also be
useful to highlight e.g. credit card or HELOC balance is exceeding a limit.

On Tue, 20 Dec 2022 at 11:53, Paul Kroitor  wrote:

> I use the reconcile feature in at least two other ways:
>
> 1. I keep current accounts with a lot of other parties -- four adult
> children, parents, in-laws, my sister's farm operation, our condo
> association, and at least a half-dozen more. Most of them don't do formal
> accounting and rely on me to know how much they owe me (or occasionally I
> owe them). Things go in and out in various ways, but either way they repay
> me (using Canadian Interac transfers, an email thing) item for item, or I
> print them a list of open transactions and ask them to pay me the balance.
> In either case the account should total zero, but because of timing it
> often doesn't actually come to zero (for example, when more debits are
> entered before their payment arrives).
>
> In this case, some entries must be reconciled to zero, and it's often not
> trivial to see which. So I start Gnucash's reconcile and enter a balance of
> zero. Then I can simply tick off debits and credits that add to zero and
> I'm done. Much easier and more verifiable than manually changing reconcile
> status line by line.
>
> 2. For those of the above parties that do have their own formal accounting
> -- done, invariably, by me -- I have to reconcile my version of what they
> owe me with their version of what I owe them. For example, they might have
> sent 12 organic chickens over the last few months and I might have bought
> them a new microwave, phone battery, and furnace filters (they're not very
> technical -- I order these things for them with delivery there). For these
> current accounts I reconcile one against the other, starting from a
> situation where neither is complete. Easier to do than explain, but the
> idea is that you have two Gnucashs open side by side (one in a VM) and tick
> off matching entries, leaving entries only in one set of books. You enter
> those in the opposite books and repeat until everything is reconciled. Not
> the original intension of the system, but it's far faster than other ways
> I've tried (and I've been using variations of this for 25+ years).
>
> Paul
>
> -Original Message-
> From: gnucash-user  On
> Behalf Of David Cousens
> Sent: December 19, 2022 9:27 PM
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] What accounts should I reconcile?
>
> Dave
>
> Reconiliation requires an independent statement of the account (e.g. from
> the bank's perspective) against which to reconcile the account. You
> generally don't have that with an expense account. I have had to
> investigate discrepancies between  what I thought I owed a vendor and what
> they claimed I owed them which involved them supplying a statement of
> account detailing all purchases from and all payments I had made from them
> for a specific period against which I coud perform a partial reconciliation
> This wa s before the business customer /vendor reports existed
>
> David Cousens
> On Tue, 2022-12-20 at 01:21 +, Dr. David Kirkby wrote:
> > For simplicity assume that I havé the following two accounts, all in GBP.
> >
> > Assets -> Bank
> > Assets > PayPal
> >
> > I can reconcile those, and I find the process useful.
> >
> > However, I noticed that it is possible to reconcile most, if not all
> > other accounts. Is there any point in reconciling the other accounts,
> > such as
> >
> > Expenses > Office supplies?
> >
> >
> > Dave
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash

Re: [GNC] Net Worth Barchart

[Christopher Lam]

Hi Liz; I guess we should do similar activities in tracking GSTs, except I
don't handle company tax.

I have an account structure:
GST
GST:GST Sales [L]
GST:GST Purchases [A]
GST:GST BAS [A]

My sales are recorded as:
Income:Sales -$1000
GST:GST-Sales -$100
Asset:Bank +$1100

My purchases are recorded as:
Expenses:Purchase +$200
GST:GST-Purchase +$20
Asset:Bank -$220

Every end-quarter I'll transfer the balance of [GST Sales] and [GST
Purchases] into [GST BAS], so that GST Sales & Purchase now have a balance
of zero.

30/09/12 Accumulated GST on Sales
GST:GST Sales +$2,345.67
GST:GST BAS -$2,345.67

30/09/12 Accumulated GST on Purchases
GST:GST Purchases -$2,000
GST:GST BAS +$2,000

The [GST BAS] account will then be settled via ATO transfer.

30/10/12 ATO BAS and PAYG
GST:GST BAS -$345.67
Expenses:Income Tax +$(TOO_MUCH + 345)
Asset:Bank -$TOO_MUCH

and because the ATO doesn't care about GST cents, I create a rounding
transfer:

30/09/12 GST Rounding
GST:GST BAS +$0.67
Equity:Rounding -$0.67

As a result, all these GST accounts are regularly reset to zero, and the
equity rounding account hovers around zero.

On Tue, 6 Dec 2022 at 16:56, Liz  wrote:

> On Tue, 6 Dec 2022 00:57:44 -0600
> Adrien Monteleone  wrote:
>
> > Liz,
> >
> > I just ran the chart for myself and indeed, it appears your
> > Liabilities are backwards. That is, if you owe money, they should
> > have a Credit balance, but yours show as Debit balance. (The *normal*
> > balance of a Liability account is Credit, not Debit)
> >
> > What is your preference setting for Accounts > Reversed Balanced
> > Accounts?
> >
> > If it is "none" or "Income & Expense" then your Liability accounts
> > will show as negative amounts in the Accounts tab if they are a
> > Credit balance.
> >
> > If it is "Credit accounts" then they will show as positive on the CoA.
> >
> > If your balances are opposite of that, then your balances are
> > reversed. (they are 'contra balances' from what is normally expected)
> >
>
___
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] User-defined commands

[Christopher Lam]

On Wed, 30 Nov 2022 at 15:55, Helmut Eller  wrote:

On Tue, Nov 29 2022, john wrote:
> See the definition of gnc:add-report-template-menu-item at https://
> github.com/Gnucash/gnucash/blob/maint/gnucash/gnome/report-menus.scm#
> L42 for example code. It's all specialized for report templates so
> you'll have to copy and modify a lot of code. Note the convention
> that functions starting with gnc: are written in Scheme and those
> starting with gnc- or xacc are written in C and exposed to Guile via
> SWIG.

Thank you.  With this I was able to add a command to the Tools
menu. (See the attached file, in case somebody is interested.)


This is indeed interesting... I'd previously experimented with a repl
server[1], using nc to connect. Yours is much more elegant. Would you care
to add to the wiki?

[1]
https://wiki.gnucash.org/wiki/Custom_Reports#Command_line_access_to_the_API

With yours, one can launch via Tools > Scheme REPL, then (use-modules
(gnucash engine)) to import the whole engine api.


Can the same strategy also be used to add items to the popup menu?

I'm mostly asking if I should look harder or if it is not possible
because there are no Scheme bindings for the popup menu.  Similarly, is
there a Scheme binding for
gnc_plugin_page_account_tree_get_current_account?


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

Re: [GNC] CSV transaction import settings

[Christopher Lam]

In release 4.12 - try Help > About

On Fri, 7 Oct 2022 at 05:26, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> David,
>
> It looks like you want the chart here:
>
> https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux
>
> 1. /home//.local/share/gnucash
> 2. /home//.local/share/gtk-3.0
> 3. /home//.config/gnucash
> 4. /home//.config/gtk-3.0
>
> One of those four directories should have the file you are looking for.
>
> Based on the expected files listed in that chart, I'd hazard that either
> #1 or #3 is the proper location.
>
> Regards,
> Adrien
>
> On 10/6/22 3:16 PM, David Carlson wrote:
> > I went through that part of the FAQ  and I got lost with locations  and
> > paths and relative paths but no hard filename to search for with my
> > filemanager. If it is there I gave up in frustration before I found it.
>
>
> ___
> 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] Lots report?

[Christopher Lam]

No such report exists. Please feel free to relearn scheme and submit as a
PR on GitHub.

You may find the Lot Viewer report (exposed only when running GnuCash with
--extra) a useful starting point.

Good luck!

On Sun, 4 Sept 2022, 12:27 pm Brent McBride,  wrote:

> Hi GnuCash experts,
>
> Does GnuCash have a report that shows the current unrealized gain/loss of
> open lots?
>
> Such a report would help answer questions such as:
>
>   *   Which lots held longer than one year have the largest unrealized
> gains, and would therefore be most advantageous (tax-wise) if donated to
> charity?
>   *   Which lots would be the best candidates for tax loss/gain harvesting?
>
> The Lots UI has almost everything needed to answer these questions: Date
> opened, balance, realized gains. But it is missing one key piece of info:
> Unrealized gains (what would the gain/loss be if the remaining balance was
> sold at the most recent price?).
>
> Further, the Lots UI only shows a single commodity. The ideal would be a
> report that shows open lots in all accounts (perhaps configurable by date,
> accounts, gain/loss amount, etc). I thought maybe one of the existing
> reports would have this info, but haven't yet found one.
>
> The "Investment Portfolio" report seems close. It shows accounts, but not
> lots within the accounts.
>
> Any suggestions?
>
> My background:
> I recently moved ~20 years of data from Quicken to GnuCash, and am still
> learning the ropes.
>
> I've written some scripts using the super-useful piecash and openpyxl
> tools to update/create various Excel docs from my GnuCash db. I suppose I
> could write a similar script to generate a Lots report in Excel.
>
> Or if I'm in the mood for pain, I could relearn Scheme enough to create a
> custom GnuCash report (I briefly taught Scheme as a TA in college over 20
> years ago—all I remember now is it uses lots of parentheses 🙂).
>
> But before going either route, I want to verify with you experts that
> there is no preexisting report.
>
> Thanks for your help!
>
> -Brent
> ___
> 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] Crash in Trial Balance report

[Christopher Lam]

May I suggest that any report crash of this sort should be logged in
Bugzilla?

On Sat, 13 Aug 2022, 9:13 pm Fred Tydeman,  wrote:

> I am running Linux and GnuCash 4.11
> When I try to do a Trial Balance report, I get a crash.
> Screenshot attached.
> I assume it is due to bad data somewhere,
> but I have no idea where or what it is.
> ___
> 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

[Christopher Lam]

AdrienM: You may have seen my successful experiment in building on Linux
(or WSL2) using Nix to load the dependencies into a temporary shell for
building. Note this is not considered canon.

https://github.com/christopherlam/gnucash-on-nix

On Wed, 10 Aug 2022 at 04:36, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Aha, thanks John. I wonder how much trouble it would be for a user to
> update their compiler or if that is just a mess for the rest of the
> system. (all else being equal, which I'm sure it isn't)
>
> Regards,
> Adrien
>
> On 8/9/22 3:06 PM, John Ralls wrote:
> > Caveat: Check the dependency requirements in README.dependencies for the
> GnuCash version you're trying to build against what a particular OS release
> provides. Pay particular attention to the C++ standard level supported by
> the compiler, Boost, Cmake, and GLib. You can't build GnuCash 4.x on Ubuntu
> 14.04 or 16.04 because the compilers in those releases don't support C++17
> and that's required for GnuCash 4.x and later.
>
>
> ___
> 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] Third party OFX/CVS providers

[Christopher Lam]

You may try this service which is free for personal use. (Not mine)

https://bankstatementconverter.com/

On Thu, 4 Aug 2022, 6:40 am Tom Browder,  wrote:

> My current bank (US, Hancock Whitney) unfortunately does not provide
> account data in a digital format other than monthly PDF statements for
> personal accounts. I know third-party programs, such as YNAB (ynab.com),
> can get access my bank while I can't, but I don't want the baggage that
> comes with it.
>
> Does anyone know of a third-party entity I could use just to get access to
> the raw data for my personal accounts?
>
> Thanks.
>
> -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] more integrated lots features

[Christopher Lam]

This use of lots sounds harmless and unlikely to break anything. You can
find a handy Lot Viewer report in the Experimental reports, only visible by
running GnuCash with --extra cli option.

On Tue, 12 July 2022, 1:29 am Mattia Rizzolo,  wrote:

> Hi people!
>
> Recently I've been noticing and using the "lots" feature a bit more,
> and I'm finding it quite handy after all.
>
>
> For example, as a FOSS contributor I find myself attending some events
> and being sponsored for it, or have some expenses on behalf of projects
> (say, I could buy promotional items (stickers, shirts, etc)) and later
> be reimbursed for them.
>
> In those cases I don't really want to use an invoice (in which case I
> could record a bill for the expense and "charge" it toward a given
> client), as I'm not actually invoicing any clients and I don't really
> want to have invoices in gnucash that don't actually exist also by the
> national revenue agency
>
> So, I created an account Assets:AR:ToBeReimbursed where I charge all the
> expenses that I plan to ask reimbursement for.  In that account I create
> a lot for each reimbursement request collecting all related expenses (for
> example, all expenses that I incur while going attending and coming back
> from an event) and a final transaction crediting this account and
> debiting a different AR account when sending off the actual
> reimbursement ticket to whatever organization.  The goal is that making
> sure that the lot is zero-ed out.
>
>
> Now, I suspect I could create a new account for each event (or whatever
> I have to do), but I found that this "lots" feature makes more sense in
> my mind, as its own goal is exactly to link together related expenses.
>
>
> So, concluding: I'm not sure if I'm doing justice to the feature by
> using it this way, but if I am, I can likely find more uses for it.  As
> such, I wonder if any of the developers have any further plan for it?  I
> don't really have any particular UX/UI in mind, besides some kind of
> sign (colour?) in the transaction ledger that highlight how a particular
> transaction is related to another.  Perhaps with some extra report also
> highlighting them?
>
> --
> regards,
> Mattia Rizzolo
>
> GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
> More about me:  https://mapreri.org : :'  :
> Launchpad user: https://launchpad.net/~mapreri  `. `'`
> Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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 reorganize the account tree

[Christopher Lam]

On Tue, 14 Jun 2022 at 15:07, Christopher Lam 
wrote:

> Some users have intuitively suggested using Account Codes, which is the
> right answer: the default sorting within the account tree has *always*[1]
> prioritised account codes over other fields e.g. account type and name.
> However there was an undocumented base-36 sort[2] which was removed without
> fanfare a few years ago, causing unexpected sorting.
>

^ clarification of unexpected sorting caused by base-36 sort:
https://bugs.gnucash.org/show_bug.cgi?id=797573#c6
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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 reorganize the account tree

[Christopher Lam]

Some users have intuitively suggested using Account Codes, which is the
right answer: the default sorting within the account tree has *always*[1]
prioritised account codes over other fields e.g. account type and name.
However there was an undocumented base-36 sort[2] which was removed without
fanfare a few years ago, causing unexpected sorting.

[1] current sorting of account codes
https://github.com/Gnucash/gnucash/blob/65eae554bec2d360600c7ff62ac72d92665c1f59/libgnucash/engine/Account.cpp#L2362

[2] base-36 account code sorting
https://github.com/Gnucash/gnucash/blob/f47b53a310d9e40020846043c31f0400a79b6308/src/engine/Account.c#L1259
results
in: 0010..0019, 001A-001Z, 0020 etc.

On Tue, 14 Jun 2022 at 08:45, john  wrote:

> Account type is a number, not a string. You can see what number goes with
> what type at
> https://github.com/Gnucash/gnucash/blob/65eae554bec2d360600c7ff62ac72d92665c1f59/libgnucash/engine/Account.h#L105
> .
>
> That shouldn't have anything to do with anything if you assign codes to
> accounts, display the account code column in the Accounts tab, and click on
> its header to sort by it. You can easily tell which column is used for
> sorting and in which direction by the arrow icon that appears on the right
> of the column's header.
>
> Regards,
> John Ralls
>
>
> > On Jun 13, 2022, at 12:09 PM, Gyle McCollam  wrote:
> >
> > Alan,
> > I noticed that the accounts under assets are not sorted in alpha order
> when I assign account codes to the major cats, namely the Assets (1),
> Liabilities (2), Equity (3), Income (4), and Expense (5).  I have
> determined this is due to the Asset account type being broken down into
> Assets, Bank, and Cash.  For some reason Cash comes before Asset, which
> comes before Bank.  I was thinking it was sorting on Type even though I
> didn't have "Type" displayed, but having Cash before Asset types negates
> that reasoning.
> >
> > Also, wanted to let you know that sorting this way also put the
> Imbalance and Orphaned account as the first 2 entries.  I have my accounts
> filtered by View/Filter By.../Other and I removed all the check marks.  The
> accounts only display when they have a balance, which since they are at the
> top of the list really makes them stand out.
> >
> >
> > Thank You,
> > Gyle McCollam
> >
> > Gyle McCollam
> >
> > 609.680.2326 Mobile
> >
> > gmccol...@live.com   email
> >
> > 
> > From: gnucash-user 
> on behalf of Alan A Holmes 
> > Sent: Sunday, June 12, 2022 3:12 AM
> > To: ja...@comcast.net ; gnucash-user@gnucash.org <
> gnucash-user@gnucash.org>
> > Subject: Re: [GNC] How to reorganize the account tree
> >
> > As Adrien said in his reply if you sort on the Account Name column it
> should
> > be okay.
> >
> > Personally, I sort on the Hidden column which I have displayed, mainly
> > because it puts the Imbalance and Orphan accounts together at the bottom
> of
> > the list and enables me to find errors in transactions quickly.
> > What I do notice sorting this way is that within the top level accounts
> > (Assets, Expenses, Income, etc.) that the 2nd and subsequent level
> Accounts
> > under Assets AREN'T sorted alphabetically, while those under Expenses and
> > Income ARE. I have insufficient sub-accounts under Equity and
> Liabilities to
> > be able to say.
> >
> >
> > Alan A Holmes
> >
> > -Original Message-
> > From: gnucash-user
> >  On Behalf
> Of
> > ja...@comcast.net
> > Sent: 11 June 2022 12:29
> > To: gnucash-user@gnucash.org
> > Subject: [GNC] How to reorganize the account tree
> >
> > I have been using gnucash for nearly 20 years. My account lists were a
> mess
> > until this spring when somehow I spent a day or two reorganizing
> everything
> > into a new and very well organized account tree.  For the life of me, I
> > don't remember how I was able to do that without losing the 20 years of
> data
> > stored in my accounts.  I would like to reorganize the order in which my
> > bank accounts are listed to make them in alphabetical order but I cannot
> > find a way to move the accounts in the account tree. I can go to the
> parent
> > account but that does not give me control to move the accounts around.
> >
> >Can someone tell me how to move accounts around in the
> > account list.  Thank you.  Chin00kie
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > 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 yo

Re: [GNC] Missing 2nd entry

[Christopher Lam]

It's possible to create a single split transaction. The only requirement is
that the transaction must be balanced i.e. the total is zero. Therefore,
create a zero-amount split and leave the "other account" field blank. If
this is not the case, then you'll have found a quantum anomaly in the
engine; a screenshot of the expanded (multi line) transaction will be
interesting to see...

On Thu, 9 June 2022, 12:59 pm 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&Repair->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&Repair->Check&repair 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] GST Report - not showing tax amounts - got it!!!

[Christopher Lam]

You're welcome. Please reply to the user list directly.

On Sun, 5 Jun 2022 at 21:19, Nora  wrote:

> HI Christopher
>
>
>
> I checked on my accounts and yes they’re set up correctly and there is a
> total amount in each, however, I also checked my report options and didn’t
> realize I could pick more than one account to include and after a few tries
> I got it to work – sale transaction plus tax or purchases plus tax.
>
> Thanks for taking the time to respond.
>
> I appreciate it.
>
> Nora
>
>
>
>
>
>
>
>
>
> *From:* Christopher Lam [mailto:christopher@gmail.com]
> *Sent:* June 5, 2022 10:14 AM
> *To:* Nora
> *Cc:* GnuCash users group
> *Subject:* Re: [GNC] GST Report - not showing tax amounts
>
>
>
> Did you set the Tax accounts correctly as suggested in the report?
>
>
>
> On Sat, 4 June 2022, 3:14 am Nora,  wrote:
>
> Hi Gnucash Users,
>
> I'm trying to get a report that shows my last 6 months  of GST/HST amounts
> for both sales and expenses.
> I've used the GST report - the headings are correct - listing the
> customer/vendor, base sales amount, tax on sale or purchase BUT only prints
> out the sales/purchase amounts with no tax amounts???
> I'm not sure what options I need to include to show the tax amounts as well
> on the report.  I need this for my GST/HST filing. Maybe there's a better
> report??
>
> Your assistance would be appreciated.
> Thanks!
> Nora
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] GST Report - not showing tax amounts

[Christopher Lam]

Did you set the Tax accounts correctly as suggested in the report?

On Sat, 4 June 2022, 3:14 am Nora,  wrote:

> Hi Gnucash Users,
>
> I'm trying to get a report that shows my last 6 months  of GST/HST amounts
> for both sales and expenses.
> I've used the GST report - the headings are correct - listing the
> customer/vendor, base sales amount, tax on sale or purchase BUT only prints
> out the sales/purchase amounts with no tax amounts???
> I'm not sure what options I need to include to show the tax amounts as well
> on the report.  I need this for my GST/HST filing. Maybe there's a better
> report??
>
> Your assistance would be appreciated.
> Thanks!
> Nora
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] Is there a report with transactions by date and accounts in columns?

[Christopher Lam]

I guess the report intends to show the inputs and outputs into the company,
you could use the income and GST statement report. Inputs and sales, and
outputs are purchases. You can ignore the tax accounts. Then select
detailed sales and purchase accounts in the display options.

On Tue, 3 May 2022, 11:53 pm Chris Green,  wrote:

> My auditor wants a transaction report showing transactions in date
> order one per line with the transaction amounts in columns according
> to account name.
>
> Is there anything in GnuCash that can do this?
>
> The closest I can find is the Income Statment (Multicolumn) in the
> Experimental Reports section.  However it's the wrong way round, I
> want dates down the page and accounts across the page.
>
> --
> Chris Green
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] Feature Request/Workaround Info: Preserve "Notes" Field?

[Christopher Lam]

There's a global preference that you can toggle which removes the update
option.

On Sat, 30 Apr 2022, 9:52 am Eric H. Bowen via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> Gyle,
>
> I do this when I remember, especially with regard to checks. But I've
> still had data overwritten later when I imported data, the import
> brought in data which I had already entered, and I neglected to go
> through the whole list and change everything to 'c'. I still think that
> a settings switch which preserves the 'Notes' field by default when
> importing data would be a worthwhile additionEric.
>
> On 4/29/22 20:18, Gyle McCollam wrote:
> > Eric,
> > I know you probably tried this , but when you are importing Are you
> > checking the "c" box and not the "u+c" box.  The "c" only clears,
> > whereas the "u+c" UPDATES and clears.
> >
> > Thank You,
> > *Gyle McCollam*
> >
> > Gyle McCollam
> >
> > 609.680.2326Mobile
> >
> > gmccol...@live.com email
> >
> > 
> > *From:* gnucash-user
> >  on behalf of Eric
> > H. Bowen via gnucash-user 
> > *Sent:* Friday, April 29, 2022 8:09 PM
> > *To:* gnucash-user@gnucash.org 
> > *Subject:* [GNC] Feature Request/Workaround Info: Preserve "Notes" Field?
> > There is an issue which has been bugging me for some time with regard to
> > OFX/QFX imports: At least from my credit cards/financial institution,
> > when data is imported it overwrites the existing data in both the
> > "Description" and the "Notes" field...and, nine times out of ten, the
> > QFX "Notes" field is essentially a rehash of the "Description" field.
> >
> > I like to leave transaction identification information in the "Notes"
> > field so that months later (Tax time!) I can recall the exact purpose of
> > a purchase without having to do a search through my email logs or PayPal
> > transactions in order to identify what that eBay purchase was actually
> > for. But at present any information I put there gets overwritten unless
> > I remember to manually re-enter it after the transaction clears when I
> > do an import from my financial institution.
> >
> > I'd like to have a switch somewhere in "Settings" where you could
> > customize the QFX (and possibly QIF, although I don't use that much)
> > import so that if the Notes field is non-blank it does not get
> > overwritten by the imported data. Perhaps there already is such a switch
> > and I've just missed it; if so could someone enlighten me? Otherwise I'd
> > like to make this a formal feature request; how do I go about doing that?
> >
> > Eric H. Bowen
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > 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] Some questions about reports

[Christopher Lam]

On Wed, 6 Apr 2022, 9:43 pm Chris Green,  wrote:

> On Wed, Apr 06, 2022 at 09:24:20AM -0400, Michael or Penny Novack wrote:
> > On 4/6/2022 8:15 AM, Chris Green wrote:
> >
> > >
> > > The auditor wants a report which looks pretty much like the profit and
> > > loss report but with the underlying bank account balances at the
> bottom.
> > > Is there any simple way to get this?  ... or if getting it all on one
> > > report isn't easy (I'm not going to learn Scheme just to do this!)
> > > then is there a report which will provide the basic bank account
> > > balances, e.g.:-
> > >
> > >  Bank account at start of year   .xx
> > >  Less excess of expenses over income .yy
> > >
> > >  Bank account at 31st December   .zz
> >
> > Yes, I have seen this format presented (and the person who took over as
> > Treasurer with one of my organizations does this -- also showing quarters
> > side by side)
>

The closest you'll get to this is by using the transaction report, select
the bank accounts, enable display Running balance. This will show "balance
b/f" in the account name header. The last split in the account section will
show the Running balance, aka "balance c/f"

HTH
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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 - Income Statement - Layout problem

[Christopher Lam]

Please be aware that GnuCash is a volunteer effort. In so many (20+) years
of users there have been no complaints about this particular layout issue
in the Income Statement. A fresh pair of eyes, however, found this genuine
layout issue. The Multicolumn Income Statement report in the Experimental
menu may be more suitable; it is much more capable and has a more
conventional layout.

Meanwhile, now that this is now known, and Adrien has kindly found the root
cause, it is likely that the developers will be able to fix the Income
Statement.

On Wed, 23 Mar 2022 at 13:49, Carl-Kensaku HERBORT  wrote:

> Hello,
>
> Thanks to everyone for your help and time.
>
> It is a shame that it is so complicated to make the Income Statement
> report look normal, like the Balance Sheet report, which also has two
> sections (Assets and Liabilities) that have no problem at all.
>
> I already have to use two separate software: an ERP/CRM for invoicing
> and daily accounting and GnuCash for heavier monthly/yearly accounting,
> mainly to produce the Income Statement Report and Balance Sheet report
> (or so was my plan). I didn't know that GnuCash was not made for that
> and that a third software (or SCHEME/HTML coding & modifications) was
> needed just to get even basic reports that all SME business need.
>
> I guess there is a first for everything: I am giving up.
>
> Again, thanks a lot to everyone who took on their free time to answer my
> questions.
>
> Have a nice day
>
> Best regards
>
> --
> Carl-Kensaku HERBORT
> DIGIENE
> Case postale
> CH-1002 Lausanne
> Suisse
>
> +41 (0) 21 320 22 66
>
> Le 22.03.22 à 05:24, Adrien Monteleone a écrit :
> > I stand corrected, this can happen regardless of the depth preference.
> >
> > The issue is entirely caused (best I can tell) by using separate tables
> > for the Income & Expense sections.
> >
> > Since the browser will adjust the label column to fit the content, if
> > those content widths differ, you'll see misalignment.
> >
> > In my case, due to some long account names, my Income section was
> > slightly wider than the Expense section despite being depth limited to
> > 4. (the reverse of the OP's image and what I found at depth > 4)
> >
> > The quickest solution is simply to put the Income & Expense sections in
> > one HTML table element. This will cause the browser to size all 1st 
> > elements on each row to the same maximum to fit the widest content.
> > (effectively sizing the first column all the same)
> >
> > There might be a complication with the ordering since there is a report
> > option to turn off 'default Income section first' in the report.
> >
> > One small additional issue, is that this approach provides no spacing
> > between sections.
> >
> > This can be solved by adding:
> >
> > 
> >  
> >   
> >  
> > 
> >
> > after the first section's total row. (this generates a blank table row
> > with content height as a visual spacer, which can be adjusted with a
> > font-size declaration if desired.)
> >
> > I don't like that approach, but it is quick and easy. (the report HTML
> > is full of presentation hacks, and one such hack, possibly causing this
> > problem, is the use of   being inserted as an account label
> > indention mechanism rather than generating additional columns.)
> >
> > I'm not sure of the table semantics with this approach either.
> >
> > Technically, the report is a single entity, so perhaps a single table is
> > better in that regard even though each section has its own subtotal.
> >
> > I did play with adding cell padding-right to the first label-cell and it
> > worked, but that requires some calculation based on which column will
> > end up wider, and very likely a magic number or two for refinement, so
> > that's likely out as a solution.
> >
> > It might also be possible to calculate and add em-based padding-left to
> > the account label cells, (rather than multiple   entities) but that
> > doesn't really solve the variable overall column-width problem. (it just
> > changes how the indention is accomplished)
> >
> > Fixed-width would very likely be a mess too. (and still have to be
> > calculated, and that might break on a per-browser basis)
> >
> > There might still be an out playing with box-sizing and/or display
> > properties but I don't really see any magic happening since the widths
> > are calculated independently.
> >
> > One final stretch might be to play with the size of the containers of
> > the two tables, but I seriously doubt it as that affects overflow
> > usually, not expanding something smaller.
> >
> > Regards,
> > Adrien
> >
> > On 3/21/22 9:47 PM, Adrien Monteleone wrote:
> >> For me, this only happens at depths 5,6, & 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
>

Re: [GNC] How to apply overpayment to new invoice?

[Christopher Lam]

Find the prepayment in the AP or bank register, right click, edit payment,
and use it to clear the later invoice.

On Wed, 23 Mar 2022, 6:45 pm Eric H. Bowen via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> I was late with my property taxes this year and incurred a penalty. I
> had earlier entered the billed amount as an invoice payable to the tax
> collector. I finally got the funds together to pay the amount, including
> penalty, in full. I entered it as one payment transaction, of course,
> since it was one e-check, and now it's showing up in my "Accounts
> Payable" as two transactions, one for the remaining billed amount (I had
> made partial payments earlier), and a separate transaction for $136.63
> representing the penalty and interest which appears as an unassigned
> pre-payment.
>
> OK so far. Well, now that I know the total penalty I entered another
> invoice for that amount. Fine. Now I want to pay the invoice with the
> pre-payment. I go to the payment screen and the pre-payment shows up
> there. But I can find no way to apply it to the new invoice. How do I
> close this [expletive!] out?
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] Have you abandoned gnuCash email list? U were so helpful!

[Christopher Lam]

On Sun, 20 Mar 2022 at 14:34, Fran_3  wrote:

> (snip).
>
Now I don't see you participating and it seems traffic on the list is way
> down.
> Have the developers abandoned the project?
>

Thank you Fran; no, the project is alive as long as there is interest in
it. The number of live bugs seems to be decreasing, hence the slow decline
in traffic. It seems the community is being very helpful, thus there's
little need to intervene.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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 - Income Statement - Layout problem

[Christopher Lam]

You can do Edit > Stylesheet > (choose stylesheet - technicolor?) > Tables
> Table Border Width to 1px or more.
then OK > Close > Reload report to draw the table lines, which will help
show layout errors.
I wonder if you have an unusual account tree hierarchy.
Maybe file a bug and attach File > Export > Export account tree to CSV file
and the screenshots with layout.

On Fri, 18 Mar 2022 at 10:44, Carl-Kensaku HERBORT  wrote:

> Hello,
>
> As promised in my previous e-mail below, here are two screen captures:
> 1. the balance sheet report: working perfectly
> 2. the income statement report: with width problem and alignment problem
>
> I hope the pictures are allowed on the mailing list.
>
> Thank you for your help
>
> Best regards
>
> --
> Carl-Kensaku HERBORT
> DIGIENE
> Case postale
> CH-1002 Lausanne
> Suisse
>
> +41 (0) 21 320 22 66
>
> Le 18.03.22 à 11:31, Carl-Kensaku HERBORT a écrit :
> > Hello,
> >
> > A. TITLE TRANSLATION PROBLEM
> >
> > I have already tried changing the title line. The title line is divided
> > in four parts, the first two of which can be customized:
> > 1. Company name (by default: blank) - customizable at will
> > 2. Core title (by default: "Income statement") - customizable at will
> > 3. A fixed string ("For Period Covering") - not customizable
> > 4. Start and end dates ("01.01.2021 to 31.12.2021") - defined by the
> > dates you choose
> >
> > I left the company name blank, so in my case the entire title line is:
> > "Compte de résultat For Period Covering 01.01.2021 to 31.12.2021"
> >
> > The only problem is that the third part ("For Period Covering") is not
> > translated and I cannot find where is the option to change or remove it.
> >
> >
> > B. WIDTH AND COLUMNS ALIGNMENT
> >
> > Maybe I didn't use the right words: I don't care about things being
> > pretty (color, lines, etc). The report is messed up in its basic
> > structure. Maybe showing you is better. I don't know if I can send a
> > picture as attachment on the mailing list. I will try sending it in the
> > next e-mail.
> >
> > Thank you for your help
> >
> > Best regards
> >
> > Carl-Kensaku HERBORT
> > DIGIENE
> > Case postale
> > CH-1002 Lausanne
> > Suisse
> >
> > +41 (0) 21 320 22 66
> >
> > Le 18.03.22 à 03:23, Michael or Penny Novack a écrit :
> >> On 3/17/2022 5:49 PM, Carl-Kensaku HERBORT wrote:
> >>> Dear everyone,
> >>> Thank you all for being here to help new users like me.
> >>> I am having problems with the "income statement" report ("compte de
> >>> resultat" in french).
> >>>
> >>> The columns of the revenue part and the columns of the expense part
> >>> are not aligned. In fact, the entire layout of these two parts
> >>> (including the width) seem to be independently managed from each
> >>> other (contrary to what happens with the parts making up the "balance
> >>> sheet"/"bilan" report, perfectly aligned and with an identical width).
> >>> The result is quite ugly. Changing the stylesheet or making accounts
> >>> name shorter or longer doesn't solve the problem. Could you please
> >>> help me out ?
> >>>
> >>> An other problem is that there is an untranslated string in the
> >>> middle of the title of the income statement report: "For Period
> >>> Covering". As I am creating the report in french, it is a bit of a
> >>> problem. Is there a way to replace this string by a translation or
> >>> get rid of this string completely (whatever is easiest) ?
> >>
> >> The second question helps with the first because it makes me think
> >> that you have not yet investigated all the report options available to
> >> you. The process is, run the report (open it) and then use
> >> edit=>report options to change various things about the report. Though
> >> how you could be running an income statement without setting the
> >> effective date range is beyond me.
> >>
> >> Report title is one of the things you can make whatever your heart
> >> desires. I had been keeping books for non-profits so "Statement of
> >> Revenues and Expenses"
> >>
> >> HOWEVER -- if your "not lining up" is a matter of different levels of
> >> nesting in your CoA << income accounts vs expense accounts >> the
> >> report might need prettying up. It is a waste of time to try to do
> >> pretty printing INSIDE the accounting package. You want a full service
> >> editor for that. Run the report, export the raw report, and then edit
> >> THAT with your favorite editor.
> >>
> >> 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

Re: [GNC] Directly posting payments

[Christopher Lam]

If you're so inclined, you are very welcome to create a transaction from
Bank to A/Payable, then assign as payment to the vendor eg restaurant or
grocery store. You can use the Vendor Report to show all payments. To be
useful you'll want to create Bill from Vendor which then posts from A/P to
the appropriate expense account eg Expenses:Restaurant. You'll be able to
match the payments to the bills. Ideally you'll create the bill first then
the payment afterwards.

But most of us wouldn't do this: we'd create payment from Bank to
Expense:Restaurant directly. If we want to report all restaurant purchases,
simply open the restaurant register and run an account report.

On Tue, 22 Feb 2022, 6:10 am ,  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] Stock Merger

[Christopher Lam]

Although the UI allows 1 transaction with splits in >1 stock, I believe
that there's zero likelihood that portfolio reports are written to handle
them. Therefore I would recommend that a stock merger is recorded as two
separate transactions -- (1) original stock sale as cash into the broker
account, recording capital gains in the process. (2) using the cash to
purchase new stock. This is very likely the cleanest record of a stock
merger. There's an upcoming stock-transaction assistant being worked on
which will assist creating stock transactions, and will *not* be able to
handle a stock merge in 1 step.

On Sat, 19 Feb 2022 at 04:16, Al  wrote:

> Geoff wrote:
> > Hi Al
> >
> > We need to tweak your transactions to fix the cost basis on the Advanced
> > Portfolio Report.
> >
> > Also from a tax accounting perspective, there are two ways to treat this
> > merger, depending whether it realised a capital gains event or not. I'll
> > cover both scenarios from a GnuCash perspective, but please note that I
> > am not an accountant.
>
> Many thanks Geoff, the information that you provided will be quite helpful.
>
> I'm waiting a bit on tweaking the transaction until I find out the
> capitol gain status, although I am fairly sure that there is no capitol
> gain other than the .72 fractional share amount. I'd just like to see
> that in writing before committing the transaction.
>
> Al
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] Focus on international standards

[Christopher Lam]

3. Only the transaction report has the ability to convert transaction
amounts into target currency using price at transaction date. Other reports
will aggregate the amounts in original currency then convert using price at
report date.

On Sat, 5 Feb 2022, 8:36 pm Fiable.biz via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> Hello.
>
> I'm very grateful to GnuCash developers. Nevertheless, it seems to me that
> they are not very interested in international standards, possibly because
> many of them are Americans, and Americans are not fond of international
> standards. I use GnuCash 4.9 on Fedora.
>
> 1) Former bug 622778 was opened 12 years ago and is very similar to
> current bug 797093 ("Miscalculation in cashflow reports"), reported in 2019
> and still unfixed.
>
> 2) Bug 796811 ("Allowing ISO number formats (both decimal separators,
> spaces) and currency symbol as input"), reported in 2018, has not been
> fixed.
>
> 3) When using multiple currencies, after having filled the price database
> with the exchange rate of all days with transactions in the foreign
> currency, I found no way to get a correct income statement based on the
> exchange rate of each transaction day, which is an IFRS requirement. IFRS
> for SMEs n°30.7: "An entity shall record a foreign currency transaction, on
> initial recognition in the functional currency, by applying to the foreign
> currency amount the spot exchange rate between the functional currency and
> the foreign currency at the date of the transaction." I tried the 5 options
> of "Price source": "Average cost of purchases weighted by volume",
> "Weighted average of all transactions in the past", "Last up through report
> date" (which is incomprehensible to me, whose mother tongue is not
> English), "Closest to report date" and "Most recent".
>
> These 3 defects have poisoned my life for long. I guess there are other
> non standard behaviours which don't bother me. Does anyone know of another
> openSource project more focused on international standards?
>
> Thank you very much in advance.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] Warning account contains splits whose reconcile date is after statement date

[Christopher Lam]

In more recent builds (4.9 onwards I think) you can view the reconciled
date in the transaction report display options.

On Tue, 1 Feb 2022, 3:39 am Cricket Onebit, 
wrote:

> I get this warning each time I reconcile my credit card statement. It's
> happened for several months now.
>
> The balance is fine. There was a bit of confusion over similar lines, but
> the balances are now fine. (it was a really good series of $10.19 books.)
>
> The latest statement was Jan 10. The last transaction was Jan 9, and I
> double-checked the years.
>
> Is there any way I can find out which transactions are the problem, or
> clear the error going forward?
>
> Thanks,
>
> Cricket / Sandy
>
> --
> +++
>
> Not as a ladder from earth to Heaven, not as a witness to any creed,
> But simple service simply given to his own kind in their common need.
> -- Rudyard Kipling
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] Budget calculation possible bug

[Christopher Lam]

Please file a bug report on Bugzilla?

On Mon, 17 Jan 2022, 5:42 pm Peter Jackson,  wrote:

> I am using the Budget routine with Expenses and Income selected, set to
> range, manual periods, with 1 selected in both cases.
> In the January ie first column only for Income, the Total does not equal
> the sum of the components in both the Budget, and Budget report. In fact,
> if I enter zero in each income component, the total stays the same.
> Regards
> Peter
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] Incorrect QFX Import

[Christopher Lam]

   It would be nice to have visibility of these imported transactions?
   Checkbox at the bottom would reveal them, all grayed out, and clicky
   link to the matched split in the register?


   From: [1]Jean Laroche
   Sent: Thursday, 30 December 2021 6:18 AM
   To: [2]gnucash-user@gnucash.org
   Subject: Re: [GNC] Incorrect QFX Import


   GC will not import an ofx transaction it thinks it already has
   imported.

   To determine whether a transaction has been imported GC looks at the

   FITID. So if two transactions in your OFX file have the same FITID, the

   second one won't be imported.


   Can you check that the transactions that are missing don't have the
   same

   FITID as some of the transactions that were imported?

   Some banks are not good at assigning unique FITID to transactions, and

   that can cause a problem for GC.

   Jean


   On 12/29/21 2:13 PM, Steve Cohen wrote:

   > Additionally, I tried exiting GnuCash and trying the import again.
   This

   > made no difference.

   >

   > On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen 
   wrote:

   >

   >> I downloaded all of 2021's transactions from my bank in QFX format
   and

   >> tried to import the file.

   >>

   >> As I was doing so, I noticed an anomaly.  I receive monthly direct

   >> deposits from a pension, all arrive on or shortly after the first of
   each

   >> month, the same amount every month. But on the QFX import screen,
   only 5 of

   >> the months showed the deposit,

   >> for January, May, August, September and December.  The other seven
   months

   >> were not on the import screen. I tried sorting by date, by amount,
   by

   >> description - they aren't there.

   >>

   >> In an attempt to learn what was going on, I first checked my bank

   >> statements.  Was the pension not being deposited?  No, that wasn't
   it, the

   >> deposits came in every month as they were supposed to. I then opened
   the

   >> QFX file in a text editor to see if the deposits were listed in the
   QFX.

   >> They all were.  So I am trying to understand if there's a bug in the
   import

   >> function that would throw these transactions away.

   >>

   >> Here are the QFX entries from December and November. Perhaps someone

   >> looking at them can tell me why the first one was accepted and the
   second

   >> not? I see no important difference.

   >>

   >> 

   >> CREDIT

   >> 2021120112[0:GMT]

   >> 1772.79

   >> 202112010

   >> COOK COUNTY PENS PENSIONS

   >> PPD ID: 3660023021

   >> 

   >>

   >> 

   >> CREDIT

   >> 2021110112[0:GMT]

   >> 1772.79

   >> 202111010

   >> COOK COUNTY PENS PENSIONS

   >> PPD ID: 3660023021

   >> 

   >>

   > ___

   > gnucash-user mailing list

   > gnucash-user@gnucash.org

   > To update your subscription preferences or to unsubscribe:

   > https://lists.gnucash.org/mailman/listinfo/gnucash-user

   > If you are using Nabble or Gmane, please see
   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.

References

   1. mailto:rip...@gmail.com
   2. mailto:gnucash-user@gnucash.org
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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] Search Results

[Christopher Lam]

Hi David-- You cannot, from the UI, explore the search criteria, however if
you launch with enhanced logging: "gnucash --log qof.query=debug --logto
stdout" then the search parameters will be shown on console. HTH

On Mon, 20 Dec 2021 at 20:12, David Carlson 
wrote:

> How can I find our what the search criteria are for a particular search
> results window and how can I re-open the search to modify the criteria?
> I know that is not under the tools menu, but perhaps it should be?
>
> --
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Stock data export to Portfolio Performance

[Christopher Lam]

Imnsho, portfolio "performance" is a popular term, and I'm not sure it has
an official definition.

There's an IFRS report in the experimental menu to analyse a single stock
activity. It aims to calculate a mathematical average cost price of the
stock. You can then compare it with the stock latest price to generate a
performance metric.

 (Not an accountant).

On Fri, 10 Dec 2021, 6:53 pm Thomas, 
wrote:

> Hello everybody,
>
> in order to have a detailed and interactive overview of all my stock
> portfolio, I would like to export the data I have in gnucash (e.g.,
> when I bought how many stocks at what price) and import it into
> Portfolio Performance. It is a rather stock-focused tool, which is why
> I want to stick with gnucash, but would love to have some of the
> visualization and calculation tools of Portfolio Performance.
>
> Does anybody do this in any way already or could give a hint how that
> could be doable?
> If there are other (more compatible) tools of the type of Portfolio
> Performance that are freely available, I'd also be interested in
> hearing about how you do it with these tools.
>
> Thanks a lot in advance!
>
> Best,
> Thomas
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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] clearing reconciled transactions

[Christopher Lam]

Even faster: [Ctrl-A], and [space] to select/deselect 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] Budget Report Liability "Act" VS Liability Report "Delta"

[Christopher Lam]

If this is the case, then this is very likely a genuine bug and would need
a test data file, sample reports in Bugzilla.

On Mon, 29 Nov 2021, 9:58 pm Charles Crossan,  wrote:

> I believe I found the answer to this.
>
> The Budget report (and the Transaction Report) are showing the "expected"
> values for changes to liability account balances - how much debt I actually
> paid off this month.
>
> The Net Worth Report (and Liabilities Over Time Report) also show "arguably
> correct" values for changes to liability account balances - How much debt I
> added this month; ignoring any payments I made on the first day of the
> month.
>
> The discrepancy arises when transactions occur on the reporting boundary
> days.  For instance, If I apply a $2,000 payment to a credit card on the
> first of the month, and then spend $500 on that card throughout the month,
> the Budget Report (and the Transaction Report) will show that a decrease of
> that credit card account by $2,000; however, the Net Worth (and Liabilities
> Over Time) report will show a Liability increase of $500.
>
> It would seem that the Time-series reports use the balance of the accounts
> at the "end of the day" for the reporting period boundaries(i.e. including
> transactions from the beginning boundary day); whereas the
> transaction-tracking reports use actual ingress and egress values from
> transactions against the account during the reporting periods.
>
> Is there a way to adjust the behavior of Time-Series reports so that they
> choose the balance from before the first transaction of the reporting
> period (and after the last transaction of the end of the reporting period)?
>
> On Sun, Nov 28, 2021 at 8:47 PM Charles Crossan 
> wrote:
>
> > Hello!
> >
> > I've been using GNUCash (gratefully, and happily) for 10 years, and this
> > is my first time reaching out to the mailing list.
> >
> > I recently noticed that the "Budget Report" for the current period shows
> a
> > different "Act" value for "changes in Liabilities" than the
> > manually-calculated liability delta from the "Net Worth Report" or the
> > "Liability report" (using the same set of accounts) for the same
> one-month
> > period.
> >
> > For instance, budget report "act" says "Liabilities Decreased by $1500",
> > but the liabilities report says " Liabilities  increased by $3500"
> >
> > I feel like my comprehension of accounting is betraying me.  How is this
> > possible?  Has anyone else seen something like this before?
> >
> > --
> > Thanks,
> >
> >
> > Charles Crossan
> > @crossan007 
> > 215-804-9851
> > https://www.ccrossan.com
> >
> >
>
> --
> Thanks,
>
>
> Charles Crossan
> @crossan007 
> 215-804-9851
> https://www.ccrossan.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] Stock transaction research

[Christopher Lam]

I believe gnucash can record all your detailed stock accounting accurately,
however, the data entry is (imho) difficult to do correctly. Additionally,
to extract data from your stock accounts is also not obvious-- from
dividends to notional distributions to stock splits, or reinvesting
dividends into stock. I do not know if the portfolio reports can understand
all possible legal combinations. I'm certain they do not handle shorting.

There will be hopefully an accurate
Stock assistant which helps create correct transactions. But it's not
ready: https://github.com/Gnucash/gnucash/pull/818

On Sun, 28 Nov 2021, 9:40 am Tom Browder,  wrote:

> On Sat, Nov 27, 2021 at 18:17 Geoff  wrote:
>
> > Hi Tom
> >
> > I suggest you read Chapter 9 Investments:
> > https://www.gnucash.org/docs/v4/C/gnucash-guide/invest_concepts1.html
>
> ...
>
> Thanks, Geoff, will do.
>
> Blessings,
>
> -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] Accounts Payable payment entry is marked as an Invoice

[Christopher Lam]

Agree, however we could argue that the software allowed the data file to be
damaged and should handle its own mess!

On Tue, 23 Nov 2021, 9:57 am Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> I wouldn't advocate for such a change, and at least in this case, it
> really is/was a payment. (I made the invoice when I received the bill,
> then entered the payment when I physically paid it)
>
> And had that band-aid been in place, I would have been unlikely to
> discover this discrepancy.
>
> Regards,
> Adrien
>
> On 11/22/21 7:37 PM, Christopher Lam wrote:
> > The report could also be amended to silently handle these "invoice" type
> > transactions without an attached invoice, and handle them as payment type
> > instead. But this is a bad band aid.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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 Payable payment entry is marked as an Invoice

[Christopher Lam]

The report could also be amended to silently handle these "invoice" type
transactions without an attached invoice, and handle them as payment type
instead. But this is a bad band aid.

On Tue, 23 Nov 2021, 9:29 am Derek Atkins,  wrote:

> Adrien,
> The "I" means "Invoice" (which internally can mean Customer Invoice,
> Vendor Bill, etc).  It is in both AR and AP accounts, and it is labled "I"
> in there in either case.
> NORMALLY when you make a payment it gets a P.
> If you post and Invoice (or Bill/Credit Note/etc) it gets an I.
>
> When it has an I, the transaction is immutable from the register --
> because you are supposed to edit it by unposting the Invoice/Bill/etc and
> then re-posting it.
>
> HOWEVER, the I/P/? column can be "clicked on" by a user, which will
> transition it to the "next" type, and, if you do this *manually* and it
> transitions to an I --- it becomes immutable... and there is no way in the
> UI to undo that.
>
> So Chris was basically saying "don't do that".
>
> MOST likely this is the cause of your issue.  The only fix is to go into
> the data file and remove the flag from the transaction under the covers.
> There is no UI way to fix it, because you're not supposed to go into AR/AP
> accounts.
>
> -derek
>
> On Mon, November 22, 2021 8:05 pm, Adrien Monteleone wrote:
> > I'll add that I'm not totally dense, and it seems like you're offering a
> > fix, but either some important details are missing, or, we are
> > misunderstanding one another.
> >
> > Regards,
> > Adrien
> >
> > On 11/22/21 6:04 PM, Christopher Lam wrote:
> >> You must have opened the AR register, and clicked on the Transaction
> >> type
> >> "I" payment split. This stupidly changes it to "P".
> >> The official fix is to not click on the AP/AR register.
> >>
> >> On Tue, 23 Nov 2021, 5:45 am Adrien Monteleone, <
> >> adrien.montele...@lusfiber.net> wrote:
> >>
> >>> I was entering annual property tax bills, and noticed for one from last
> >>> year, that it has a notation on the Vendor Report of:
> >>>
> >>> "Please note some transactions were not processed
> >>> 1. Transaction has type invoice but no owner or lot"
> >>>
> >>> Viewing the AP register shows the payment entry, but marked with an "I"
> >>> instead of a "P".
> >>>
> >>> Jumping to the Invoice shows it as PAID, and viewing lots shows both
> >>> invoice and payment with a zero balance. (no balance really)
> >>>
> >>> Any ideas on what caused this and how to fix it?
> >>>
> >>> (using 4.7 on BigSur)
> >>> --
> >>> Regards,
> >>> Adrien
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > 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.
> >
>
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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 Payable payment entry is marked as an Invoice

[Christopher Lam]

No, the way around, P changes to I.
Same fix.

On Tue, 23 Nov 2021 at 00:04, Christopher Lam 
wrote:

> You must have opened the AR register, and clicked on the Transaction type
> "I" payment split. This stupidly changes it to "P".
> The official fix is to not click on the AP/AR register.
>
> On Tue, 23 Nov 2021, 5:45 am Adrien Monteleone, <
> adrien.montele...@lusfiber.net> wrote:
>
>> I was entering annual property tax bills, and noticed for one from last
>> year, that it has a notation on the Vendor Report of:
>>
>> "Please note some transactions were not processed
>> 1. Transaction has type invoice but no owner or lot"
>>
>> Viewing the AP register shows the payment entry, but marked with an "I"
>> instead of a "P".
>>
>> Jumping to the Invoice shows it as PAID, and viewing lots shows both
>> invoice and payment with a zero balance. (no balance really)
>>
>> Any ideas on what caused this and how to fix it?
>>
>> (using 4.7 on BigSur)
>> --
>> Regards,
>> Adrien
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> 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 Payable payment entry is marked as an Invoice

[Christopher Lam]

You must have opened the AR register, and clicked on the Transaction type
"I" payment split. This stupidly changes it to "P".
The official fix is to not click on the AP/AR register.

On Tue, 23 Nov 2021, 5:45 am Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> I was entering annual property tax bills, and noticed for one from last
> year, that it has a notation on the Vendor Report of:
>
> "Please note some transactions were not processed
> 1. Transaction has type invoice but no owner or lot"
>
> Viewing the AP register shows the payment entry, but marked with an "I"
> instead of a "P".
>
> Jumping to the Invoice shows it as PAID, and viewing lots shows both
> invoice and payment with a zero balance. (no balance really)
>
> Any ideas on what caused this and how to fix it?
>
> (using 4.7 on BigSur)
> --
> Regards,
> Adrien
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] Budget Report Questions

[Christopher Lam]

Hello, does the budget report option "Use accumulated amounts" help? If
not, please file a bug.

On Mon, 11 Oct 2021, 6:21 am Steve Welch via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> I apologize in advance if the answers to these questions are painfully
> obvious.  I have tried to read the resources provided but no luck so far.
> I set up my budget with 12 periods (months) - each item is simply 1/12th
> of the annual total.
> What I am used to using (Moneydance, Quicken) are two basic reports:
> 1.  Budget vs. Actual - year to date (YTD budget vs. YTD actuals)
> 2.  Budget vs. Actual - annual (full year budget vs. YTD actuals)
> When I view the GNC “Budget Report” it looks like I’m seeing #2 above.
> How can I view a report that shows #1 - YTD budget vs. YTD actuals?
> Also, is there a way to collapse or hide the monthly columns so that I can
> see the totals (far right) next to the account names?  With 12 months
> displayed, I have to constantly scroll left - right to see the name and
> then the totals.
> Finally, is “Budget Report” the only one that shows budgeted figures next
> to actuals?  I haven’t found any others but wanted to be sure.
>
> Again, sorry if I’m missing something simple here.  And thanks!
>
> Steve
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] Split Transaction Confusion Again

[Christopher Lam]

I think you're recording the dividend into the Brokerage cash account only.
Beware the Advanced portfolio report (and upcoming IFRS average cost
report) will not recognise this dividend because it has no split into the
stock account. So, you'll want to record as follows:

Asset:Broker:Stock 0 STOCK
Asset:Broker:Cash +$8.61
Income:Dividend -$10.13
Expenses:Taxes:Tax Withheld +$1.52


On Sun, 10 Oct 2021 at 02:13, Jack Frillman via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
> I just bought the stock and I got a dividend and I don't know how often
> I will get them. So setting up a scheduled transaction for it is not
> practical.
>
> The response Gyle sent was the solution what I was trying to do.
>
> Thanks.
>
> On 10/9/21 8:59 PM, Liz Dodd wrote:
> > On Sat, 9 Oct 2021 11:46:14 -0400
> > Jack Frillman via gnucash-user  wrote:
> >
> >> Yes it was a big help.
> >> Thanks.
> >>
> >> On 10/9/21 10:23 AM, Gyle McCollam wrote:
> >>> This would be your entry:
> >>>
> >>> Parent Brokerage Account$8.61
> >>> Tax Account  $1.52
> >>> Dividend Income Account   $10.63
> >>>
> >>> Hope this helps you and is clear.
> >>>
> >>> Thank You,
> >>> *Gyle McCollam*
> >
> > To avoid having to work this out every year, try making a shceduled
> > transaction.
> > Edit out the numbers and put the the instructions in place.
> >
> > Attached is how I get my electricity account recorded faster.
> > Liz
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> 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.
>
> --
> Old Unix programmers never die, they just mv to /dev/null
> - Anonymous
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] table header alignment in easy invoice and customer reports

[Christopher Lam]

You could edit the "CSS-based stylesheet (experimental)" and use this
instead of "Easy", Then add somewhere

body > table:nth-child(5) > thead > tr > th {text-align:left;}


On Thu, 30 Sept 2021 at 15:44, James Thorpe 
wrote:

> I've just migrated from an old 3.5x version to 4.8 and copied across my
> saved report configurations.
>
> I have two - my invoice and customer report based on the "Easy Invoice"
> report with "Easy" stylesheet and "Customer Report" also with "Easy"
> stylesheet.
>
> The problem is that for some reason the customer information in the
> report which is in the header in the left hand column, is not left
> aligned any more.
>
> I exported to HTML to see what was going on and the problem is that the
> table containing the customer information has its margins set to "auto".
> This means that it is effectively centred in the table cell that wraps it.
>
> On the Easy Invoice report I can add some custom css:
>
> .client-table > table {width:100%;}
>
> This fixes it there but there is no custom css option for the "Customer
> Report".
>
> That one also exports with the table definition as follows:
>
>  style="margin-left:auto;margin-right:auto;">
>
> Does anyone know where I can hack the source somewhere that causes this
> table to be given these auto margin properties?
>
> (or if there's a cleaner way of doing it, I'm all ears)
>
> Thanks
>
> --
> --
> James Thorpe
> 061 476 2775
> ja...@fusionsystems.co.za
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] Set up GnuCash to track monthly net income considering taxes and pension fund contributions

[Christopher Lam]

The only mechanism that really exists to have "templated arbitrary
formulas" is to use the periodic Scheduled Transactions. It would be nice
to have them created ad-hoc (ie menu item Create Transaction from Template
which pops up a list of available templates)  instead of periodically...

On Sat, 25 Sep 2021, 5:34 pm Simone Gaiarin,  wrote:

> Thanks for the reply Rich.
>
> My main question is: is there a way to automate these calculations in
> GNUCash or for each transaction I need to compute and input each component
> of the income by hand?
> I have read the GNUCash documentation but I was not able to figure out if
> this is possible or not.
>
> On Sun, Sep 19, 2021 at 8:32 AM Simone Gaiarin  wrote:
>
> > Hi all,
> > I need help in setting up GnuCash to achieve the following goal:
> > - Track my monthly net income (after taxes and pension fund contribution)
> >
> > Situation:
> > I give a service that I invoice per hour and the cost paid by the
> customer
> > consists of the following components:
> >
> > x: Cash payment = y + p1
> > y: Service gross cost
> > p1: 1st pension fund contribution = 0,02 * y
> >
> > On y I have to pay also:
> > t1: tax I have to pay = 0,05 * y
> > p2: 2nd pension fund contribution = 0,10 * (y - t1)
> >
> > Accounts:
> >
> > - Income
> >
> > - Bank Account
> >
> > - Tax
> > - Pension fund
> >
> > Given that I pay out of my bank account the taxes twice a year and the
> > contribution to the pension fund twice a year, the 'Income chart' report
> > does not give me a clear view of my net income over the month.
> >
> > I tried to set up a tax table where I used some equivalent coefficients
> in
> > order to automatically assign t1 to Tax account and p1, p2 to the Pension
> > fund account (rather difficult given that here the tax and pension fund
> are
> > computed in cascade), but I wonder if this is the correct strategy (the
> > Pension fund account goes negative instead of positive for example).
> >
> > What is the correct way to proceed in order to obtain a monthly net
> income
> > chart considering the taxes and pension fund contribution percent over
> each
> > customer payment?
> >
> > 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] Report Question

[Christopher Lam]

Yes it will use 2022 year if the report is launched in 2022.

This report is stable and will not be removed from gnucash. The only known
blocker against it moving out of experimental is that the valuation into
target currency is known to be slightly* flawed when multiple columns are
involved. To fix it would cause the report to be much slower. If the book
is single currency only then there are no known bugs on this report.

* Consider a book with multiple foreign or stock transactions at various
dates; the weighted average / average cost pricing will attempt to value
the conversion at a "reasonable" average price into the report currency.
The mechanism to obtain price at multiple dates in this report will
slightly differ from the single-date balance sheet or income statement
report.

On Thu, 23 Sep 2021, 5:25 am Jack Frillman via gnucash-user, <
gnucash-user@gnucash.org> wrote:

>
> Using GNUC 4.4
>
> I setup a Income Statement report from the Reports-->Experimental report
> options.
> I have the Start Date set to "Start of this Year" and the End Date to
> "End of this Year".
>
> Will the date range of the report automatically switch to Jan 1 2022 to
> Dec 31 2022 when the new year actually arrives?
>
>
> Are these Experimental reports stable?
>
> --
> Old Unix programmers never die, they just mv to /dev/null
> - Anonymous
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Redo account reconciliations

[Christopher Lam]

 > I guess it depends on how fussy you are about details. Since there is no
way to see the reconciliation date there is little reason to insist on that
date being correctly recorded (...)

Yes, some users may be fussy. After all the reconcile_date *is* visible in
the UI -- you need to hover on the 'y' reconcile status. It's also visible
in the 'Reconciliation Report' and is used as the date filter.

Adding UI to reset the reconciliation status will allow fastidious users to
'redo' reconciliation piecemeal and record statement dates accurately.
Otherwise they'll need to reset reconcile status one by one by clicking on
'y'. I've done this a couple of times while searching for errors.

On Sat, 4 Sept 2021 at 15:01, David Carlson 
wrote:

> I guess it depends on how fussy you are about details.  Since there is no
> way to see the reconciliation date there is little reason to insist on that
> date being correctly recorded. The GnuCash code displays an incorrect
> starting balance in the Reconciliation window.  When you follow Derek's
> suggestion and just ignore the starting balance error in the current
> month's reconciliation, the old transaction is recorded as being reconciled
> in the current month.
>
> If you really do want to record the correct reconciliation month for every
> transaction, you need to unreconcile all transactions after the date of the
> statement* before* the month that is not correct before starting the
> rereconciliation.
>
> On Sat, Sep 4, 2021 at 9:19 AM Derek Atkins  wrote:
>
>> Ah... But that's NOT how you are supposed to recover from that.
>> If you reconciled up for 31 Aug 2021, and you un-reconcile a transaction,
>> it doesn't matter what date the transaction has -- you should re-reconcile
>> 31 August!  You just need to re-check the February transaction.
>>
>> -derek
>>
>> On Sat, September 4, 2021 9:10 am, Christopher Lam wrote:
>> > Derek,
>> > Consider a well-used bank account. You reconcile every end of the month
>> > successfully up to 31 Aug 2021.
>> > Accidentally you unreconcile a Feb 2021 split.
>> > You retrieve your 28 Feb 2021 bank statement, try to re-reconcile and
>> fail
>> > because the reconciliation end balance also tallies splits from March
>> 2021
>> > onwards.
>> > C
>> >
>> > On Sat, 4 Sept 2021 at 13:01, Derek Atkins  wrote:
>> >
>> >> Chris,
>> >>
>> >> On Sat, September 4, 2021 8:36 am, Christopher Lam wrote:
>> >> > I agree that if an account reconciliation is done periodically
>> >> correctly
>> >> > every time, then it works well. If an old reconciled split is
>> >> unreconciled
>> >> > and we need to re-reconcile a previous reconciliation date, then the
>> >> code
>> >> > falls apart.
>> >>
>> >> I'm curious why you say it falls apart?
>> >>
>> >> > It may be an idea to allow batch unreconciliation of all splits whose
>> >> > reconcile date is after the reconciliation date in the Reconciliation
>> >> > dialog, thereby allowing the user to re-do reconciles.
>> >>
>> >> That could be a good idea.
>> >>
>> >> -derek
>> >>
>> >> > On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
>> >> > gnucash-user@gnucash.org> wrote:
>> >> >
>> >> >>
>> >> >>
>> >> >> > The starting balance is computed from all the reconciled
>> >> transactions
>> >> >> "to
>> >> >> > date".  It *can* be safe to ignore the starting balance if, for
>> >> >> example,
>> >> >> a
>> >> >> > transaction became unreconciled.  For example, let's say you
>> >> reconcile
>> >> >> > from some starting balance X to a final balance of $1000.  Then
>> you
>> >> >> > accidentally unreconcile a $100 transactions.  If you try to
>> >> >> re-reconcile
>> >> >> > that same statement/date/ending-balance of $1000, it won't show X
>> >> as
>> >> >> the
>> >> >> > starting balance, but something else (PROBABLY $900, but I'm not
>> >> 100%
>> >> >> > sure).  But that's okay -- just ensure the ending balance is
>> >> correct
>> >> >> and
>> >> >> > all the transacti

Re: [GNC] Redo account reconciliations

[Christopher Lam]

Derek,
Consider a well-used bank account. You reconcile every end of the month
successfully up to 31 Aug 2021.
Accidentally you unreconcile a Feb 2021 split.
You retrieve your 28 Feb 2021 bank statement, try to re-reconcile and fail
because the reconciliation end balance also tallies splits from March 2021
onwards.
C

On Sat, 4 Sept 2021 at 13:01, Derek Atkins  wrote:

> Chris,
>
> On Sat, September 4, 2021 8:36 am, Christopher Lam wrote:
> > I agree that if an account reconciliation is done periodically correctly
> > every time, then it works well. If an old reconciled split is
> unreconciled
> > and we need to re-reconcile a previous reconciliation date, then the code
> > falls apart.
>
> I'm curious why you say it falls apart?
>
> > It may be an idea to allow batch unreconciliation of all splits whose
> > reconcile date is after the reconciliation date in the Reconciliation
> > dialog, thereby allowing the user to re-do reconciles.
>
> That could be a good idea.
>
> -derek
>
> > On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> >
> >>
> >>
> >> > The starting balance is computed from all the reconciled transactions
> >> "to
> >> > date".  It *can* be safe to ignore the starting balance if, for
> >> example,
> >> a
> >> > transaction became unreconciled.  For example, let's say you reconcile
> >> > from some starting balance X to a final balance of $1000.  Then you
> >> > accidentally unreconcile a $100 transactions.  If you try to
> >> re-reconcile
> >> > that same statement/date/ending-balance of $1000, it won't show X as
> >> the
> >> > starting balance, but something else (PROBABLY $900, but I'm not 100%
> >> > sure).  But that's okay -- just ensure the ending balance is correct
> >> and
> >> > all the transactions that SHOULD be reconciled ARE reconciled.
> >> >
> >> > There is no way to get a transaction to reconciled status (y) manually
> >> --
> >> > the only way is through a reconcile process.  So if you have
> >> reconciled
> >> > transactions, that must've happened through a reconcile.
> >> >
> >> > I would recommend you just go ahead with March, ignore the starting
> >> > balance, enter the correct March ending balance, and see if the
> >> > reconciliation works (ensure you re-reconcile anything from earlier
> >> that
> >> > might have become unreconciled).
> >> >
> >> So I just want to build a bit on this answer. GNUCash doesn't have QBs
> >> reconciliation system - so don't equate the two. As an accountant who
> >> doesn't need to be handheld or leashed, I  find GNUCash's system better
> >> than QBs - albeit there is room for improvement. However, I wouldn't
> >> recommend GNUCash to someone less comfortable with bare-ledger
> >> accounting -
> >> controls exist for a reason.
> >>
> >> I don't know how the backend works, but my experience is that the
> >> "Opening
> >> balance" is basically a running total of all the transactions marked
> >> "Reconciled" in that account. Whereas QB will _prevent_ you from
> >> attempting
> >> to reconcile August if July's reconciled balance differs from what it
> >> previously reconciled, GNUCash doesn't care - it just says "The
> >> transactions marked 'Reconciled' for this account total to $X." And
> >> that's
> >> good for when you have to go back and fix things... and know what you're
> >> doing.
> >>
> >> When you reconcile a transaction, again based on  my experience, GNUCash
> >> toggles the "Reconciled" flag on the account _and_ inserts the
> >> reconciliation date. I personally like this because  I can, say, start a
> >> fresh reconciliation for March having reconciled through August  to pick
> >> up
> >> the transactions that _should_ have been in the March reconciliation but
> >> weren't because I readded them (or whatever). However, I need  my
> >> calculator with me because I need to adjust the "closing balance" to
> >> reflect not the statement balance but what GNUCash's "running total"
> >> balance should be. Contrast this to having to undo every rec in QB back
> >> to
> >> March and redo every rec again.
> >>
&

Re: [GNC] Redo account reconciliations

[Christopher Lam]

I agree that if an account reconciliation is done periodically correctly
every time, then it works well. If an old reconciled split is unreconciled
and we need to re-reconcile a previous reconciliation date, then the code
falls apart.

It may be an idea to allow batch unreconciliation of all splits whose
reconcile date is after the reconciliation date in the Reconciliation
dialog, thereby allowing the user to re-do reconciles.

On Sat, 4 Sept 2021 at 06:34, Borden via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
>
> > The starting balance is computed from all the reconciled transactions "to
> > date".  It *can* be safe to ignore the starting balance if, for example,
> a
> > transaction became unreconciled.  For example, let's say you reconcile
> > from some starting balance X to a final balance of $1000.  Then you
> > accidentally unreconcile a $100 transactions.  If you try to re-reconcile
> > that same statement/date/ending-balance of $1000, it won't show X as the
> > starting balance, but something else (PROBABLY $900, but I'm not 100%
> > sure).  But that's okay -- just ensure the ending balance is correct and
> > all the transactions that SHOULD be reconciled ARE reconciled.
> >
> > There is no way to get a transaction to reconciled status (y) manually --
> > the only way is through a reconcile process.  So if you have reconciled
> > transactions, that must've happened through a reconcile.
> >
> > I would recommend you just go ahead with March, ignore the starting
> > balance, enter the correct March ending balance, and see if the
> > reconciliation works (ensure you re-reconcile anything from earlier that
> > might have become unreconciled).
> >
> So I just want to build a bit on this answer. GNUCash doesn't have QBs
> reconciliation system - so don't equate the two. As an accountant who
> doesn't need to be handheld or leashed, I  find GNUCash's system better
> than QBs - albeit there is room for improvement. However, I wouldn't
> recommend GNUCash to someone less comfortable with bare-ledger accounting -
> controls exist for a reason.
>
> I don't know how the backend works, but my experience is that the "Opening
> balance" is basically a running total of all the transactions marked
> "Reconciled" in that account. Whereas QB will _prevent_ you from attempting
> to reconcile August if July's reconciled balance differs from what it
> previously reconciled, GNUCash doesn't care - it just says "The
> transactions marked 'Reconciled' for this account total to $X." And that's
> good for when you have to go back and fix things... and know what you're
> doing.
>
> When you reconcile a transaction, again based on  my experience, GNUCash
> toggles the "Reconciled" flag on the account _and_ inserts the
> reconciliation date. I personally like this because  I can, say, start a
> fresh reconciliation for March having reconciled through August  to pick up
> the transactions that _should_ have been in the March reconciliation but
> weren't because I readded them (or whatever). However, I need  my
> calculator with me because I need to adjust the "closing balance" to
> reflect not the statement balance but what GNUCash's "running total"
> balance should be. Contrast this to having to undo every rec in QB back to
> March and redo every rec again.
>
> Still, as I said, there's room for improvement in GNUCash:1) Since the rec
> date gets stored with the Rec flag, GNUCash can  have a function that
> unreconciles every transaction before a given rec date. This would be
> analogous to QB's batch rec undo.
> 2) One should be able to rec from the ledger  as QB lets you do - and
> prompt for a rec date. Yes it's dangerous, poor practice, etc., but the GNU
> philosophy is not to leash the user. If a user wants to sudo rm -rf / their
> installation, GNU warns them first, but ultimately lets them. User knows
> best. If you want your computer to dictate what you're allowed to do with
> it, that's what Apple's for.
>
> I hope that helps a bit
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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-cli options - accounts, dates and other settings

[Christopher Lam]

There's no mechanism to modify report options from the command line. The
gnucash-cli is meant mainly to run reports with sensible defaults (eg
balance sheet) and saved reports (eg transaction report with modified
options).

On Tue, 31 Aug 2021, 5:53 pm flywire,  wrote:

> This report needs accounts and dates to be specified in Win10 and I'd like
> to tweak some other settings. "A datafile may be specified to describe some
> saved options." Where is the documentation for gnucash-cli ?
>
> 
>
> E:\>"C:\Program Files (x86)\gnucash\bin\gnucash-cli" --report run --name
> "2fe3b9833af044abb929a88d5a59620f" --output-file arg.html demo.gnucash
>
> In Browser:
> > Transaction Report:
> > No accounts selected
> > This report requires accounts to be selected in the report options.
> >
> > Edit report options
>
> E:\>"C:\Program Files (x86)\gnucash\bin\gnucash-cli" --report show --name
> "2fe3b9833af044abb929a88d5a59620f"
>
> * name: Transaction Report
>   guid: 2fe3b9833af044abb929a88d5a59620f
>
> E:\>"C:\Program Files (x86)\gnucash\bin\C"
> Missing command or option
>
> C:\Program Files (x86)\gnucash\bin\gnucash-cli [options] [datafile] -
> GnuCash, accounting for personal and small business finance:
>
> Common Options:
>   -h [ --help ]   Show this help message
>   -v [ --version ]Show GnuCash version
>   --debug Enable debugging mode: provide deep detail in the
>   logs.
>   This is equivalent to: --log "=info" --log
> "qof=info"
>   --log "gnc=info"
>   --extra Enable extra/development/debugging features.
>   --log arg   Log level overrides, of the form
>   "modulename={debug,info,warn,crit,error}"
>   Examples: "--log qof=debug" or "--log
>   gnc.backend.file.sx=info"
>   This can be invoked multiple times.
>   --logto arg File to log into; defaults to
> "/tmp/gnucash.trace";
>   can be "stderr" or "stdout".
>   --gsettings-prefix arg  Set the prefix for gsettings schemas for
> gsettings
>   queries. This can be useful to have a different
>   settings tree while debugging.
>
> Price Quotes Retrieval Options:
>   -Q [ --quotes ] arg Execute price quote related commands. Currently
> only
>   one command is supported.
>
> get: Fetch current quotes for all foreign
>  currencies and stocks in the given GnuCash
>  datafile.
>
>   --namespace arg Regular expression determining which namespace
>   commodities will be retrieved for
>
> Report Generation Options:
>   -R [ --report ] arg Execute report related commands. The following
>   commands are supported.
>
> list: Lists available reports.
> show: Describe the options modified in the
> named
>   report. A datafile may be specified to
>   describe some saved options.
> run: Run the named report in the given GnuCash
>  datafile.
>
>   --name arg  Name of the report to run
>
>   --export-type arg   Specify export type
>
>   --output-file arg   Output file for report
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] piecharts/linecharts turned blank in reports after upgrade

[Christopher Lam]

Try exporting the report to HTML and view source to determine where it's
trying to find chartjs sources.

On Sun, 25 Jul 2021, 9:06 am Dong Lin via gnucash-user, <
gnucash-user@gnucash.org> wrote:

>
> I created a fresh VM using ubuntu 21.04, minimal install with no gnucash
> installed.
>
> $ sudo apt-get build-dep gnucash
> $ git clone https://github.com/Gnucash/gnucash.git
> $ cd gnucash
> $ git reset --hard 4.6
> $ mkdir ../build && cd ../build
> $ cmake ../gnucash
> $ make -j8
> $ ./bin/gnucash
>
> the resulting gnucash produced blank charts.  tables are visible when
> enabled.
>
>
> > No, that switches only the libgnc*.so libs in lib/gnucash. There are
> > others in lib/.
> >
> > You cannot build GnuCash with an installed GnuCash. You must `sudo
> apt-get
> > remove gnucash` then `rm -rf *` your build directory and re-run cmake &&
> > ninja.
> >
> > Regards,
> > John Ralls
> >
> >
> >> On Jul 20, 2021, at 9:16 PM, Dong Lin  wrote:
> >>
> >>
> >> vm-ubuntu-1:~/src/build-gnucash$ mv lib lib-local-build
> >> vm-ubuntu-1:~/src/build-gnucash$ ln -s /usr/lib/x86_64-linux-gnu/gnucash
> >> lib
> >>
> >> this only switches the libgnc-*.so libs only.  all other libs continue
> >> to
> >> point to /usr/lib.
> >>
> >> vm-ubuntu-1:~/src/build-gnucash$ ./bin/gnucash
> >> ./bin/gnucash: symbol lookup error: ./bin/gnucash: undefined symbol:
> >> gnc_run_report_with_error_handling
> >>
> >>
> >>> Switched how? What libwebkit2gtk.so and libjavascriptcoregtk.so was
> >>> libgnc-html.so linked to if not the ones in /usr/lib?
> >>>
> >>> Regards,
> >>> John Ralls
> >>>
>  On Jul 20, 2021, at 7:55 PM, Dong Lin  wrote:
> 
> 
>  On a freshly installed Ubuntu 21.04 VM with apt installed GNC 4.4. the
>  apt
>  installed GNC runs fine with charts visible.
> 
>  But locally built GNC (tip of the latest maint branch) has the same
>  issue.
>  I tried switching the libs in build_dir to point to
>  /usr/lib/x86_64-linux-gnu/gnucash,  but the local gnucash encountered
>  an
>  undefined symbol gnc_run_report_with_error_handling and couldn't
>  start.
> 
>  apt removed the system gnucash, purged ~/.cache. reran the local gnc,
>  same
>  problem, blank charts.
>  only the table is visible.
> 
>  the build environment was prepared with apt-get build-dep gnucash as
>  instructed.
> 
> >
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] Finding sales tax liability

[Christopher Lam]

The Income GST report has undergone only one significant change: the
"accounts" option replaced with "sales" and "purchases".

It would be useful if you would disclose your book account structure, and
the options changed in the report.

Maybe you had included "interest income" in your sales and need to deselect
it.

On Sat, 10 Jul 2021, 10:36 am Paul Kinzelman,  wrote:

> Thank you, but that doesn't really work because it looks like it
> lumps sales (which requires Gross Receipts Tax) and interest on
> the bank account (which does not). Is there some way to
> differentiate this, like some way for interest and any
> other income to be separated from actual sales?
>
> It seemed to work just fine previously, was the capability
> removed for some reason?
>
> Thanks!
> -Paul Kinzelman
>
> On 7/9/2021 4:46 PM, Christopher Lam wrote:
>
> It's likely the Income and GST statement report can be used for your
> purposes.
>
> On Tue, 6 Jul 2021, 10:47 pm Paul Kinzelman,  wrote:
>
>> This is for a business that sells stuff and keeps track of sales tax.
>> At the end of the reporting period, I need a report of the sales
>> tax owed to the state.
>>
>> With previous versions it was easy, there was a pull-down item
>> for getting a report of the sales tax but I can't remember where
>> exactly it was, I think it was under Business | Vendor or
>> maybe Actions? But in any event, I can't find it anywhere now,
>> nor does the documentation seem to help.
>>
>> How do I find the sales tax accumulated during the reporting
>> period? And is it in the docs anywhere?
>>
>> 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] Finding sales tax liability

[Christopher Lam]

It's likely the Income and GST statement report can be used for your
purposes.

On Tue, 6 Jul 2021, 10:47 pm Paul Kinzelman,  wrote:

> This is for a business that sells stuff and keeps track of sales tax.
> At the end of the reporting period, I need a report of the sales
> tax owed to the state.
>
> With previous versions it was easy, there was a pull-down item
> for getting a report of the sales tax but I can't remember where
> exactly it was, I think it was under Business | Vendor or
> maybe Actions? But in any event, I can't find it anywhere now,
> nor does the documentation seem to help.
>
> How do I find the sales tax accumulated during the reporting
> period? And is it in the docs anywhere?
>
> 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] Accounting for GST in Australia

[Christopher Lam]

That's exactly how I'd record the RCTI. Auto calculation of GST is only
available when using Invoices and Bills, or when using the Scheduled
Transactions feature.


On Wed, 7 Jul 2021 at 10:53, flywire  wrote:

> Let's just enter that transaction.
>
> Following:
> * https://wiki.gnucash.org/wiki/Quickstart_Australian_BAS#My_Tax_Tables
> *
> https://wiki.gnucash.org/wiki/Quickstart_Australian_BAS#How_do_I_record_complex_business_transactions.3F
>
> It's always fiddly and there's no free ride. It's similar for grain sales
> too.
>
> Are auto-generated GST calculations available for cash accounting without 
> Accounts
> Payable/Receivable?
>
> 09/10/2020Complex Sales
> Asset:Bank  1808.20
> Income:Sales:Ewes  -1050.00
> GST:GST on Sales-105.00
> Income:Sales:Lambs  -922.00
> GST:GST on Sales -92.20
> Expense:Sales Fee:Commission  98.60
> GST:GST on Purchases   9.86
> Expense:Sales Fee:Transaction Levy10.00
> GST:GST Free   0.00
> Expense:Sales Fee:Yard Dues Sheep 18.00
> GST:GST on Purchases   1.80
> Expense:Sales Fee:Yard Dues Lambs 23.05
> GST:GST on Purchases   2.31
> Expense:Sales Fee:Cartage140.00
> GST:GST on Purchases  14.00
> Expense:Sales Fee:Insurance   39.44
> GST:GST on Purchases   3.94
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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 for GST in Australia

[Christopher Lam]

Maybe you can paste an example of a complex RCTI?
In Australia only 2 TaxTables would be useful.
In some jurisdictions you may need more, eg UK has standard 20% and reduced
5% VAT rates.

On Tue, 6 Jul 2021 at 12:15, flywire  wrote:

> Thanks for the wiki Chris. A lot of people use a Recipient Created Tax
> Invoice (RCTI) without Accounts Payable/Receivable. One of the
> complications is the invoice might have a whole range of different charges
> with different GST treatments. Could you extend the wiki with a simple
> example for those situations?
>
> eg https://lists.gnucash.org/pipermail/gnucash-user/2020-May/091146.html
> > With fees, levies, industry funds, different tax treatments, various
> parties
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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 for GST in Australia

[Christopher Lam]

You're welcome.
Setting tax tables is not obvious; the wiki
https://wiki.gnucash.org/wiki/Quickstart_Australian_BAS is now amended.
It's still the "Income and GST Statement" and within Report Options >
Format > Report Format > Australia BAS.
C

On Tue, 6 Jul 2021 at 02:05, Nathan Ellery  wrote:

> Hi Christopher,
> Thanks so much for meeting with Nathan and Lynda past Saturday afternoon.
> We have had the opportunity to put your ideas into the live program and I
> can report that the GST is now accruing in the appropriate Account in the
> chart of accounts.
> For anyone else following this post, the one thing we hadn't done is to
> ensure that when creating an invoice, in the column headed 'tax table' that
> we entered 'GST collected on Sales'. This points to the Tax table section,
> which is set up with these words on the left side of the screen and the
> relevant liability account on the right side.
> You did show us how to 'print' a complying Australian GST invoice, but we
> are unable to find this back again. Can you please let us know how to do
> this?
> Thanks again for your assistance,
>
>
> On Tue, Jun 22, 2021 at 4:17 PM Christopher Lam 
> wrote:
>
>> Welcome Nathan,
>> Have you checked out the following?
>> https://wiki.gnucash.org/wiki/Quickstart_Australian_BAS
>>
>> On Tue, 22 Jun 2021, 2:59 pm Nathan Ellery,  wrote:
>>
>>> Hi,
>>> I have recently started using GnuCash and am having difficulty in
>>> attributing GST to the GST accounts as set up in the chart of accounts. I
>>> have included the relevant posting accounts in the tax table area, but
>>> new
>>> entries aren't picking up the GST amount. What am I missing? Do you need
>>> to
>>> see screen shots of my setup to verify what I am experiencing?
>>>
>>> best regards
>>>
>>> Nathan Ellery
>>> Building designer
>>> Grandesign Pty Ltd <http://grandesignwa.blogspot.com.au/>
>>> m: 0417 951575
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> 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.
>>>
>>
>
> --
> best regards
>
> Nathan Ellery
> Building designer
> Grandesign Pty Ltd <http://grandesignwa.blogspot.com.au/>
> m: 0417 951575
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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 crashes when generating Equity Statement

[Christopher Lam]

The clue is in the report file name; there's never been an equity report in
the example folder. Where did you get the report from?

gnucash/reports/example/equity.scm

On Tue, 29 Jun 2021, 9:54 am Jakub Sygnowski,  wrote:

> Hi all,
> I have a problem with GnuCash where it's crashing when generating Equity
> Statement.
>
> I verified the report works on an empty book, so likely the problem is with
> my data. I traced it back to gnc:sum-collector-commodity
> <
> https://github.com/Gnucash/gnucash/blob/maint/gnucash/report/commodity-utilities.scm#L900
> >,
> where one of the commodities gets exchanged to #f which causes the error. I
> looked at the price database for its entries, but they look fine to me.
>
> Any idea what could have gone wrong here?
> Thank you!
>
> Version: 4.4
> Stacktrace:
> An error occurred while running the report.
>
>   19 (apply-smob/0 #)
> In c-interface.scm:
>  35:4 18 (gnc:call-with-error-handling _ _)
> In ice-9/boot-9.scm:
>   1731:15 17 (with-exception-handler # ice-9/boot-9.scm:1815:7 (exn)> _ #:unwind? _ #:unwind-for-type _)
>   1736:10 16 (with-exception-handler _ _ #:unwind? _ #:unwind-for-type _)
> In c-interface.scm:
> 40:37 15 (_)
> In unknown file:
>   14 (eval-string "(gnc:report-run 0)" #)
> In ice-9/boot-9.scm:
>2806:4 13 (save-module-excursion _)
> In ice-9/eval-string.scm:
>  38:6 12 (read-and-eval # #:lang _)
> In report-core.scm:
> 772:4 11 (gnc:report-run _)
> In c-interface.scm:
>  74:2 10 (gnc:backtrace-if-exception _ . _)
>  35:4  9 (gnc:call-with-error-handling _ _)
> In ice-9/boot-9.scm:
>   1731:15  8 (with-exception-handler # ice-9/boot-9.scm:1815:7 (exn)> _ #:unwind? _ #:unwind-for-type _)
>   1736:10  7 (with-exception-handler _ _ #:unwind? _ #:unwind-for-type _)
> In c-interface.scm:
> 39:40  6 (_)
> In report-core.scm:
>774:29  5 (_)
>756:25  4 (gnc:report-render-html #< type:
> "bce0c0d9eb31431c9b61a933becb9aea" id: 0 options: #
> …)
> In gnucash/reports/example/equity.scm:
> 295:8  3 (equity-statement-renderer _)
> In gnucash/report/commodity-utilities.scm:
> 890:2  2 (gnc:my-collector-comm # report-utilities.scm:374:4 (action commodity amount)> # …)
> In unknown file:
>1 (+ -12380177/50 0 0 0 5833/100 -1409929/10 33448/25
> 10270387/100 156399/20 101067/10 1392361/100 67913/4 542029/50 0 …)   <-
> there is "#f" further down the line here
> In ice-9/boot-9.scm:
>   1669:16  0 (raise-exception _ #:continuable? _)
>
> In procedure +: Wrong type: #f
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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 for GST in Australia

[Christopher Lam]

Welcome Nathan,
Have you checked out the following?
https://wiki.gnucash.org/wiki/Quickstart_Australian_BAS

On Tue, 22 Jun 2021, 2:59 pm Nathan Ellery,  wrote:

> Hi,
> I have recently started using GnuCash and am having difficulty in
> attributing GST to the GST accounts as set up in the chart of accounts. I
> have included the relevant posting accounts in the tax table area, but new
> entries aren't picking up the GST amount. What am I missing? Do you need to
> see screen shots of my setup to verify what I am experiencing?
>
> best regards
>
> Nathan Ellery
> Building designer
> Grandesign Pty Ltd 
> m: 0417 951575
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] Inconsistent meanings of "AsOfDate"?

[Christopher Lam]

Hi,

On Tue, 15 Jun 2021 at 00:09, Hong Xu  wrote:

> I'm checking out the APIs of GnuCash. In
> xaccAccountGetReconciledBalanceAsOfDate, AsOfDate seems to mean ON OR
> BEFORE the date:
>
>
> https://github.com/Gnucash/gnucash/blob/7fe78e7017b3cb397e6a2f5a63c56e1933521a68/libgnucash/engine/Account.cpp#L3572
>
> In xaccAccountGetBalanceAsOfDate, AsOfDate seems to mean BEFORE the date:
>
>
> https://github.com/Gnucash/gnucash/blob/7fe78e7017b3cb397e6a2f5a63c56e1933521a68/libgnucash/engine/Account.cpp#L3535
>
> I'm wondering whether I misunderstood something, or this is an oversight,
> or this is completely intended and has always been so?
>

No, Likely yes, Likely no, Yes.

The first interpretation is likely the intended one. In theory, most
transaction dates are set to 10:59am, and report date thresholds for
comparison are gnc:time64-start-day-time (0:00) and gnc:time64-end-day-time
(23:59:59), so the comparisons should give similar results.

In practice, unintended edge cases will likely exist and may slightly
modify behaviour.

In the future, there may be work to eliminate times by using GDate or
std::chrono so only the dates are considered, therefore the comparisons
will need to be consistent. Jralls could offer a more detailed explanation.



>
> Thanks,
> Hong
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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.
>

On Tue, 15 Jun 2021 at 00:09, Hong Xu  wrote:

> I'm checking out the APIs of GnuCash. In
> xaccAccountGetReconciledBalanceAsOfDate, AsOfDate seems to mean ON OR
> BEFORE the date:
>
>
> https://github.com/Gnucash/gnucash/blob/7fe78e7017b3cb397e6a2f5a63c56e1933521a68/libgnucash/engine/Account.cpp#L3572
>
> In xaccAccountGetBalanceAsOfDate, AsOfDate seems to mean BEFORE the date:
>
>
> https://github.com/Gnucash/gnucash/blob/7fe78e7017b3cb397e6a2f5a63c56e1933521a68/libgnucash/engine/Account.cpp#L3535
>
> I'm wondering whether I misunderstood something, or this is an oversight,
> or this is completely intended and has always been so?
>
> Thanks,
> Hong
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] Enable Online Stock Price Updating in GnuCash

[Christopher Lam]

Isn't this "unrealised gains/losses"?

Jai: the "proper" way to record transactions during shorting is still
unsolved, but should be similar to buying/selling stock, except the
balances are negative. Broker expense fees remain positive.

On Wed, 9 Jun 2021, 10:28 am Geoff,  wrote:

> Hi Christopher
>
> Thanks for pointing out these issues.
>
> My reasoning for the need to book a future liability for a short sell
> was to record the obligation to deliver the short sold stock at a future
> date.  Perhaps "contingent liability" would be a better term?
>
> Anyway, I'll leave that to the experts.
>
> Regards
>
> Geoff
> =
>
> On 9/06/2021 11:34 am, Christopher Lam wrote:
> > Hi Geoff
> >
> > On Wed, 9 Jun 2021, 9:27 am Geoff,  > <mailto:cleanoutmys...@gmail.com>> wrote:
> >
> >
> > Gnucash will permit you to run a negative balance on a stock, see
> > attached screenshot.
> >
> >
> > The UI will allow you to record transactions when short-selling, but
> > bear in mind:
> > - the current portfolio and advanced portfolio reports cannot handle
> > negative stock balances; the reports will bail out.
> > - it's likely very wrong to record a single transaction that sells more
> > stock than your current holding; you'll need to sell current balance
> > (and record cap gains/losses) *then* record a separate short-sell
> > transaction to achieve a negative balance.
> > - recent releases (4.5? or current daily builds) have an experimental
> > IFRS cost basis report which aims to calculate the average cost base,
> > according to some jurisdictions eg Canadian. It's not guaranteed correct
> > yet.
> >
> >
> > Note that I am not an accountant, but I think you should also book a
> > future liability for when the short falls due.
> >
> >
> > Why?
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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] Enable Online Stock Price Updating in GnuCash

[Christopher Lam]

Hi Geoff

On Wed, 9 Jun 2021, 9:27 am Geoff,  wrote:

>
> Gnucash will permit you to run a negative balance on a stock, see
> attached screenshot.
>

The UI will allow you to record transactions when short-selling, but bear
in mind:
- the current portfolio and advanced portfolio reports cannot handle
negative stock balances; the reports will bail out.
- it's likely very wrong to record a single transaction that sells more
stock than your current holding; you'll need to sell current balance (and
record cap gains/losses) *then* record a separate short-sell transaction to
achieve a negative balance.
- recent releases (4.5? or current daily builds) have an experimental IFRS
cost basis report which aims to calculate the average cost base, according
to some jurisdictions eg Canadian. It's not guaranteed correct yet.


> Note that I am not an accountant, but I think you should also book a
> future liability for when the short falls due.
>

Why?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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] Read-only transaction

[Christopher Lam]

Try right click and select "jump to associated invoice". If this doesn't
work then attach the relevant tracefile.

On Thu, 20 May 2021, 4:03 pm coolnodje,  wrote:

>Hi
>I have this odd transaction that I can't fix or delete. I'm met with
>the following error message when trying to delete it:
>This transaction is marked read-only with the comment: 'Generated from
>an invoice. Try unposting the invoice'.
>I've reviewed all invoices but I couldn't find a one with a reference
>to the transaction in question.
>Is there any way to bypass, or solve this read-only status?
>Best
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] UK. Value added tax.

[Christopher Lam]

Thanks Maf
The headers will be amended accordingly for 4.6
Cheers

On Wed, 28 Apr 2021 at 16:42, Maf. King  wrote:

> Hi Christopher,
>
> I've just run my first VAT quarter reports using the 4.x GC series (4.4
> IIRC).
> All very smooth for my simple needs, once I'd spotted the UK VAT format
> drop-
> down selector.  So thanks for your continued work on that.
>
> I'm not fully up with the international rules now that UK has parted ways
> with
> the EU (precious little business due to pandemic); there are bound to be
> lots
> of little gotchas in terms of data entry etc...but the actual reporting
> appears to be exactly the same, with the exception that Box 2, 8 and 9 are
> now
> titled slightly differently.  Where we formerly had the titles "...EU
> Member
> states" we now have to report "...in Northern Ireland [from/in] EU
> member
> states"
>
>
> thanks again,
> Maf.
>
>
>
> On Monday, 13 April 2020 02:35:10 BST Christopher Lam wrote:
> > Hi Maf, any gossip about the treatment of VAT and EU displacement of VAT
> > post Brexit? Is it worth merging the UKVAT report into 4.x series?
> > The 4.x series plan to upgrade the Income-GST-Statement report to (1)
> > output UK & Australia specific fields as well as the current generic
> report
> > (2) allow purchases to be recorded in any account; for now purchases must
> > be expense accounts.
> >
> > On Wed, 20 Nov 2019 at 21:25, Maf. King  wrote:
> > > I have used this bridge product twice now, with experimental CSV report
> > > directly output by GC
> > >
> > > https://www.chm-software.co.uk/
> > >
> > > Christopher Lam has a report in progress that will be able to cope
> with UK
> > > VAT.  So far, I used a pre-release self compiled "special edition" GC.
> > > but it
> > > is possible!
> > >
> > > HTH,
> > > Maf.
> > >
> > > On Wednesday, 20 November 2019 20:20:55 GMT Paddy Walker wrote:
> > > >   I am a business user of Gnucash for my farm accounts for about
> > > >
> > > > 15 years. I run it on Linux and have no access to a Microsoft
> machine.
> > > > A situation I do not wish to change.
> > > >
> > > >   UK.'s tax authority have decided to make the submission of VAT.
> > > >
> > > > returns dependent on compliant interactive accountancy software.  I
> > > > understand that it is entirely unreasonable to expect Gnucash to be
> > > > compliant.
> > > >
> > > >   HMRC.,  (the tax authoriy), have provided the potential fo a
> > > >
> > > > work around. They will allow bridging software, mainly to accomodate
> > > > those using spreadsheets for their accounts.
> > > >
> > > >   HMRC. provide an extensive list of compliant software without
> > > >
> > > > mentioning the platform on which it runs.  Does any body know of
> > > > bridging software that runs on Linux. Advice on how to  " make tax
> > > > digital" on a Linux machine would be most welcome.
> > > >
> > > >   Although it is not my preferred option, I have managed to
> > > >
> > > > install Microsoft compatible bridging software in Windows XP, on a
> > > > virtual Box.
> > > > Paddy Walker
> > > >
> > > >
> > > > ___
> > > > gnucash-user mailing list
> > > > gnucash-user@gnucash.org
> > > > To update your subscription preferences or to unsubscribe:
> > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > > If you are using Nabble or Gmane, please see
> > > > 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.
> > >
> > > --
> > > Maf. King
> > > PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7
> C542
> > >
> > >
> > >
> > >
> > >
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > If you are using Nabble or Gmane, please see
> > > 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] Securities disposals: pooling (not FIFO/LIFO/average costing) for UK cgt purposes: average price and identity (GNUCash v.4.5)

[Christopher Lam]

On Thu, 22 Apr 2021 at 18:44, RW Jones via gnucash-user <
gnucash-user@gnucash.org> wrote:

>
> [Summary of main question: can GNUCash v.4.5 operate with the UK capital
> gains tax rules on pooling requirements for determining price and ident
> of securities sold outright and/or on part disposals?]
>

The UK CGT treatment seems to recognise the average-cost basis of shares
similar to Canada. See https://www.adjustedcostbase.ca/ -- if so there's
some work pending[1] to calculate the average-cost of a particular stock.

[1] https://github.com/Gnucash/gnucash/pull/763
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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] New price source

[Christopher Lam]

To casual and regular users:
In addition to pricedb-nearest and pricedb-latest, there'll be a new price
source 'pricedb-nearest-before' in 4.6 onwards; this will ignore prices
*after* the report date.
e.g. a user records weekly prices e.g. on 19-dec, 26-dec, 2-jan, 9-jan etc
and runs the balance sheet report dated 31-dec.
Although the nearest price is 2-jan, we'd usually want the 26-dec price
instead (e.g. a stock-split, or a GFC may have occurred on 1-jan).
Please test and report -- recent builds 24 April 2021 onwards have this new
source.
https://code.gnucash.org/builds/flatpak/maint/ and
https://code.gnucash.org/builds/win32/maint/
Relevant bug report: https://bugs.gnucash.org/show_bug.cgi?id=743753
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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 Close Books option

[Christopher Lam]

On Wed, 21 Apr 2021 at 01:15, Derek Atkins  wrote:

> That is not how GnuCash does it.  GnuCash uses a real calendar and has no
> "special" dates in there.
>
> How it *did* it, initially, was to take the "default timestamp" of Dec 31
> and add one second to it.  This was because all posted times have a
> default timestamp of approximately noon.  So setting the closing
> transaction to one second later would assure it was the "last" transaction
> of the period.  This is how it was originally implemented, but it's
> probably been changed since then.
>

Now the timestamp is 10:59am the same as any other regular transaction[*]
but has an invisible CLOSING flag which ensures the xaccTransOrder will
always sort closing splits after regular splits in the register and
reports. The other rub is some reports (e.g. P & L) will filter out these
closing splits via description search for "Closing Entries" as well and I
wish to remove[**] this feature because all closing entries created in the
past 10 years or so will have the closing flag.

[*] which can be deleted, amended etc as desired
[**] I wonder if anyone objects? https://github.com/Gnucash/gnucash/pull/909
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
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] Pdf Export Problems

[Christopher Lam]

It's been noted.
https://bugs.gnucash.org/show_bug.cgi?id=798158

On Sat, 10 Apr 2021, 7:06 pm Gareth Davies via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> Hi,
>
>
>
> If I create a Transaction Report and export it to Pdf.
>
> When I try and open it in Adobe Acrobat DC Reader, it will not do it and
> gives an error code of 135.
>
>
>
> Does anyone have an idea of what the problem is, as it hasn't happened
> before?
>
>
>
> GC 4.5 Windows 10
>
>
>
> Sent from Mail   for
> Windows
> 10
>
>
>
> Cheers,
>
> Gareth
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> 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] Hand-over on Succession or Short Term Absence

[Christopher Lam]

Michael
First, good luck and hope all goes well.
Second, you can 'describe' a custom report by the following process. This
uses the gnucash-cli tool.

$gnucash-cli -R list

This will list all built-in and saved reports, the latter denoted by a 'C'.
e.g.

*   Account Summary
*   Advanced Portfolio
* C Annual Report for Accountant Chris AU
*   Assets
*   Assets Over Time
*   Australian Tax Invoice

$gnucash-cli -R show --name "Annual Report for Account Chris AU"

This describes the report and the options used. e.g.

* name: Annual Report for Accountant Chris AU
  guid: 49b7979123564c5e944586db82a123e8
  parent-template: Transaction Report
Display / Num: Disabled
Display / Memo: Disabled
Sorting / Show Full Account Name: Enabled
Sorting / Secondary Subtotal for Date Key: none
Sorting / Show Account Description: Enabled
Sorting / Secondary Key: date
Sorting / Primary Key: account-code
Accounts / Accounts: null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null
Filter / Account Name Filter: ^1

The reason the accounts are null is because the datafile isn't loaded.

HTH

On Thu, 8 Apr 2021 at 06:32, Michael Hendry 
wrote:

> I’m shortly to undergo surgery, and although I expect to be home in three
> or four days, it’ll be several weeks before I’m fully up and running again.
> As a retired doctor, I’m well aware that bad stuff can happen during or
> after surgery.
>
> As well as managing my personal accounts, I’m treasurer of a club and two
> small charities, and I’d like to be able to prepare a hand-over bundle for
> a temporary (or permanent) successor.
>
> This process should ideally be reversible, so that I can take over again
> after my recovery.
>
> Sharing the .gnucash files is an obvious first step, but I’d need to share
> the reports I’ve refined over the years which apply only to one set of
> books, along with any other necessary settings.
>
> There’s some overlap with a 2013 topic “sequential use of Gnucash on
> multiple computers”, but I haven’t found any recent references to this.
>
> Before I reinvent the wheel, does anyone have a ready-to-use solution?
>
> Regards,
>
> Michael
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.