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.

Re: [GNC] Investments: Bank, Asset or Equity?

[Christopher Lam]

Looks fine. However I'm not convinced there's benefit in having placeholder
'Mutual Funds' nor 'Stocks' accounts. Thus the following works well too:

Assets (Top-level Parent) = Asset [placeholder]
---Current Assets = Asset [placeholder]
--Bank 1 = Bank [placeholder]
-Account 1a = Bank
-Account 1b = Bank
--Bank 2 = Bank [placeholder]
-Account 2a = Bank
-Account 2b = Bank

---Investments = Asset [placeholder]
--Brokerage Accounts  = Asset [placeholder]
-Brokerage Account  1 =Asset [placeholder]
Linked Bank 1 = Bank
Mutual Fund 1a = Stock
Mutual Fund 1b = Stock
Stock 1a = Stock
Stock 1b = Stock
-Brokerage Account 2 =Asset [placeholder]
Linked Bank 2 = Bank
Mutual Fund 2a = Stock
Mutual Fund 2b = Stock

On Sun, 28 Mar 2021 at 01:34, viking  wrote:

> @Christopher,
> If I have multiple Banks, Brokerage Accounts and Stocks, would the
> following
> structure work fine?
>
> Assets (Top-level Parent) = Asset [placeholder]
> ---Current Assets = Asset [placeholder]
> --Bank 1 = Bank [placeholder]
> -Account 1a = Bank
> -Account 1b = Bank
> --Bank 2 = Bank [placeholder]
> -Account 2a = Bank
> -Account 2b = Bank
>
> ---Investments = Asset [placeholder]
> --Brokerage Accounts  = Asset [placeholder]
> -Brokerage Account  1 =Asset [placeholder]
> Linked Bank 1 = Bank
> Mutual Funds 1 = Stock [placeholder]
> ---Mutual Fund 1a = Stock
> ---Mutual Fund 1b = Stock
> Stocks 1= Stock  [placeholder]
> ---Stock 1a = Stock
> ---Stock 1b = Stock
> -Brokerage Account 2 =Asset [placeholder]
> Linked Bank 2 = Bank
> Mutual Funds 2 = Stock [placeholder]
> ---Mutual Fund 2a = Stock
> ---Mutual Fund 2b = Stock
>
> Thank you for your help! I want to make sure that I set this up correctly
> from the beginning before starting to import data. If I make a mistake, I
> assume that I can easily change the type after importing the data?
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Investments: Bank, Asset or Equity?

[Christopher Lam]

This looks fine. Alternatively some may record brokerage cash assets into
the brokerage parent non-placeholder account itself but I'd recommend your
structure.

On Sun, 28 Mar 2021, 9:05 am viking,  wrote:

> @Christopher,
> Sorry, our posts crossed.
> Still, how do I classify the linked bank account in the Brokerage account?
> Like this?
>
> Assets (Top-level Parent) = Asset [placeholder]
> ---Current Assets (sub-account) = Asset [placeholder]
> --Banks etc = Bank
> ---Investments (sub-account) = Asset [placeholder]
> --Brokerage Account (sub-account) = Asset [placeholder]
> -Linked Bank = Bank??
> -Mutual Fund = Stock
> -Stock(sub-account) = Stock
>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] asset discrepancy in change of year

[Christopher Lam]

Hi Michael,

On Sat, 27 Mar 2021 at 18:11, Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> There is an issue with keeping multiple currencies in the same set of
> books that I have not yet seen discussed in detail, Namely that exchange
> rates are not constant over time.
>

There is some discussion in an unusually detailed bug report
https://bugs.gnucash.org/show_bug.cgi?id=797796 -- this originates in
GnuCash's transaction currency being permitted to be any currency. e.g. if
your home currency is USD, but transfer GBP to EUR, the UI will record only
GBP/EUR fx. The new method would enforce the transaction currency to be USD
therefore your GBP->EUR would require GBP/USD and EUR/USD fx rates. Thus,
w.r.t. USD, all fx gains/losses are recorded accurately.

To fix this would be an enormous amount of work and invalidate a lot of
code, but would definitely simplify and fix a lot of code too IMHO.


> Let's say at time T when the exchange rate between $ and EUR is
> $1.30/1.00 EUR. You take 1000 EUR and buy 1300 dollars. At THIS point in
> time, just a transfer between assets, no transaction affecting
> income/expense, so no affect on equity. Let's say no transactions from
> then on.
>
> Now we come to the end of the year, at which point let's say the
> exchange rate is $1.25/1 EUR. Those $1300 are no longer worth 1000 Eur.
> They are worth 1040 EUR. Your equity has gone up by 40 EUR.
>
> I will stop here because the issue of how "unrealized gains/losses from
> changes in exchange rate" will be treated is not a gnucash issue. It's
> exactly the same no matter what accounting software you use or even old
> fashioned pen and ink on paper.
>
> Michael D Novack
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Investments: Bank, Asset or Equity?

[Christopher Lam]

This is the recommended (i.e. to ensure reports and UI behave well)
structure:

Assets (Top-level Parent) = Asset *[placeholder]*
---Current Assets (sub-account) = Asset [*placeholder]*
--Banks etc = *Bank*
---Investments (sub-account) = Asset *[placeholder]*
--Brokerage Account (sub-account) = Asset
-Mutual Fund =
*Stock* -Stock(sub-account) = *Stock*

> Why is the Brokerage Account also not an Asset instead of a Bank?

*The main differences between Asset and Bank relate to UI and report
headers AFAIK. Ditto Liability & Credit Card (Credit Cards can also trigger
a Credit Card interest input dialog during reconciliation).*

> When I create a new file using a different Category (Sv language) I get
the
following structure and types:

* Equity* (Top-level Parent) = Equity
---*Opening Balances* (sub-account) = Equity

On Sun, 28 Mar 2021 at 00:24, viking  wrote:

> @Christopher,
> What should it look like?
> Also, does it matter if the type is incorrect?
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Investments: Bank, Asset or Equity?

[Christopher Lam]

Looks like a buggy default chart of accounts.

On Sun, 28 Mar 2021, 7:01 am viking,  wrote:

> When I create a new file (category = US) with investment accounts I get the
> following structure and types:
>
> Assets (Top-level Parent) = Asset
> ---Current Assets (sub-account) = Asset
> ---Investments (sub-account) = Asset
> --Brokerage Account (sub-account) = Bank
> -Mutual Fund = Asset
> -Stock(sub-account) = Asset
>
> */Why is the Brokerage Account also not an Asset instead of a Bank?/*
>
> When I create a new file using a different Category (Sv language) I get the
> following structure and types:
>
> Stocks (Top-level Parent) = Equity
> ---Start-value (sub-account) = Equity
>
> */Should Stocks be Assets or Equity? I believe Stocks should be Equity? In
> this case, the US file is created incorrectly. I believe that Mutual Funds
> are also Equity?/*
>
> Does it matter what type the accounts are...?
>
>
>
>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Mystery per-security Opening Balances accounts appearing

[Christopher Lam]

May be side effect from https://github.com/Gnucash/gnucash/pull/762

On Thu, 18 Mar 2021, 11:09 am Robin Chattopadhyay, 
wrote:

> I've been meaning to ask about this behavior too. I *think* it started
> sometime between version 4.1 and 4.4. It seems to me to happen when
> creating -- or editing -- an account that has a non-currency commodity. As
> Geoff said, it's a minor nuisance and I just delete the extra accounts when
> they appear.
>
> But I am curious about the use case that would necessitate this change.
> Unless creating a new set of books, I'm generally not going to offset an
> asset acquisition transaction against an opening balance account. But
> almost any editing of an account setup will trigger the creation of the
> Opening Balance account.
>
> And I'm not sure what the equity account is supposed to show. For example
> in the following test case:
> 1) Create an account with type STOCK. Opening Balance tab is greyed out.
> 2) The stock account and the Opening Balance accounts are created
> 3) Enter a transaction from the stock account, with a DR to the stock
> account and a CR to the Opening Balance account. Result shows the
> transaction in the stock account register as expected; but in the Opening
> Balance account register, the transaction is entered, but no value in
> either the DR or CR column
> 4) Enter a transaction from the Opening Balance account with a CR to the
> Opening Balance account and a DR to the stock account. Save the transaction
> and Gnucash displays the transfer dialog. Enter a price and save the
> transaction. Then the transaction appears as expected in both registers.
>
> I'm using the SQLite database, so in the transaction from Step 3, Opening
> Balance account split shows 0 in the quantity_num field, but the
> transaction in Step 4 shows the appropriate share value in quantity_num
> split on both sides of the transaction. Step 3 seems like a bug,
> notwithstanding the purpose of the Opening Balance account
>
> I'm using Gnucash 4.4 in Ubuntu 20.04 as a VM client on a Windows 10 host
> machine.
>
> On Wed, Mar 17, 2021 at 7:20 PM Geoff  wrote:
>
> >  > (1) Has anyone else seen this?
> >
> > Yes, you are not going crazy, I have had a similar problem on a few
> > occasions myself in the past month, however I can't put my finger on the
> > reason why or reproduce it.
> >
> > GnuCash 4.4 on Windows 10.
> >
> >
> >  > (2) What gives?
> >
> > No idea, I just deleted the accounts.  It's a minor nuisance.
> >
> >
> > Regards
> >
> > Geoff
> > =
> >
> > On 18/03/2021 4:00 am, peterb wrote:
> > > I've been using Gnucash for well over a year and a half.  Sometime
> within
> > > the past few months, I have seen a number of completely empty Opening
> > > Balances equity accounts opening themselves for certain securities
> that I
> > > own.  They are always denominated in the currency of the security; so
> for
> > > example I have one right now:
> > > [image: Screen Shot 2021-03-17 at 12.58.13 PM.png]
> > > These accounts have no balance, no transactions in them, and *to the
> best
> > > of my knowledge* have never had a transaction in them.
> > > I have asset accounts for about 75 securities, but only see this for
> > around
> > > 10 of my securities.  Most of them were acquired after starting to use
> > > GnuCash, so the top-level Equity:Opening-Balances account would not
> have
> > > been involved at all.
> > >
> > > (1) Has anyone else seen this?
> > > (2) What gives?
> > >
> > > Thanks!
> > >
> > > 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.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Error on report over time

[Christopher Lam]

This is a strange report indeed. May I suggest a bug report at Bugzilla.

On Mon, 15 Mar 2021, 3:00 am ,  wrote:

> Hello,
>
> My "Expenses over time" report and also the "Income over time" report
> from last year (2020) is showing November 2019 instead of November 2020
> and the amounts appear as the sum of those two months (Nov/2019 and
> Nov/2020).
>
>
> For the 2019 period the reports seem ok. Any idea?
>
> Thanks,
> Rafael
>
> ---
> gnucash --version
> GnuCash 4.4
> Build ID: 4.4+(2020-12-28)
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Best way to close unpaid invoices?

[Christopher Lam]

Hi David, nice to see the documented method of writing off bad debts.
However it seems hackish. It would be good to formalise the methods via a
menu item or toolbar button.

Similarly, processing refunds is currently done afaiu via credit notes.
Numerically it's fine, but does it pass the tax audit test?

On Mon, 8 Mar 2021, 11:15 am David Cousens, 
wrote:

> My description of the process has been from an accounting perspective.
>
> According to the Help Manual GnuCash cannot process the write off as a
> payment in the simple manner of a manual transaction entry as I described
> it
> because the accounts in the payment logic are restricted and the use of
> lots
> for processing partial payments complicates the issue.
>
> Section 7.6.3 of the Help manual
> (https://www.gnucash.org/docs/v4/C/gnucash-help/busnss-ar-payment1.html)
> gives a process for writing off a bad debt to a Bad Debt expense account
> which will achieve the desired result within GnuCash which AFAIK is still
> valid.
>
> David
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CSV matching produces duplicates?

[Christopher Lam]

You mean transactions imported via ofx then reimported with CSV? This may
be https://bugs.gnucash.org/show_bug.cgi?id=798128

For now, it'll be best to narrow down your CSV import to exclude the
already imported date range.

On Thu, 4 Mar 2021, 5:59 am Elmar,  wrote:

> Version 4.4 from flatpak on linux mint 19.3  ( I think my sig needs to
> be fixed, but I misremember how to do that)
>
> Since my OFX import to my bank seems now broken, I have been reduced to
> CSV imports.  And I find that the matcher does not match worth beans,
> producing duplicates of tranasctions that in fact DO match within the
> one month window.  Is this a know problem?  Is there a way to tune the
> matcher better? - Elmar
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Minor issue with invoice layout

[Christopher Lam]

Please file a bug report and attach relevant changes.

On Sat, 27 Feb 2021, 2:02 am Ajnkns,  wrote:

> "I upgraded Gnucash from ver 3.2 to 4.4 (Mac OS 10.15).  My custom
> invoice layout changed.  Particularly, the Client information, which was
> flush with the left margin, is now moved much toward the center."
>
> I am having the same problem. I've tried editing the CSS and can move the
> client table back to the left with a margin left negative number value, but
> that moves it to a set position which may end up misaligned from the grid
> below when it is printed.
>
> By exporting the report and opening it in a web browser I was able to
> figure
> out what needs to be changed to make it auto align to the left, but it
> isn't
> something that can be changed from the CSS style editor section under the
> Layout tab.
>
> Have you had any luck figuring this out?
>
> I also used to be able to have the invoice # set to be large bold text but
> I
> can't figure out how to change that in this new version either.
>
> The main thing I use Gnucash for is invoicing...it's pretty frustrating
> that
> I can't get it looking as good as I had it before. It really looks very
> weird having the customers information indented 1/4 of the way toward
> center
> while the invoice # above it is aligned all the way to the left.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] About 'parent-account-subtotal' option.

[Christopher Lam]

To clarify:

The subtotal options are:

Parent account balances ( Account Balance / Subtotal / Do not show)
Parent account sub-totals (Show subtotals / Do not show / Text-book style
(experimental))

The first one describes subtotals *before* an account group -- see [1]
below.
Options will cause this line to show either "$0", "$108,000" or blank.

The second one describes subtotals *after *an account group -- see [2]
below.
Options will cause this line to show either "$108,000", or blank (line
skipped), "$108,000" with an unusual alignment.

e.g.
Asset $0   [1]
Asset:Bank $8,000
Asset:House $100,000
Total Asset $108,000[2]

The proposal would modify saved reports with "Parent account sub-totals"
set to "Text-book style (experimental)" to use "Show subtotals", and
options limited to:

Parent account balances ( Account Balance / Subtotal / Do not show)
Parent account sub-totals (Show subtotals / Do not show)


I suspect that the number of users adversely affected will be near zero.

Hello Christopher,
> I am not sure I understand the impact of this change.
> My settings on the Income report are -
>
> Include accounts with zero total balances (unchecked)
> Omit zero balance figures (checked)
> Parent account balances (Do not show)
> Parent account sub-totals (Show sub-totals)
>
> I don't use the Text book style (experimental) option.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] About 'parent-account-subtotal' option.

[Christopher Lam]

Of course, no reason to remove the 'do not show' option.

On Sat, 13 Feb 2021 at 03:25, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> The 'Do not show' option will still be available correct?
>
>
> Regards,
> Adrien
>
> On 2/12/21 8:41 PM, Christopher Lam wrote:
> > To long-time and new users,
> >
> > Regarding subtotals in several reports e.g.
> >
> > Asset $0
> > Asset:Bank $8,000
> > Asset:House $100,000
> > Total Asset $108,000
> >
> >  From 2003 onwards, there was a 'parent account subtotals' option 'text
> book
> > style (experimental)' to show subtotal after groups of accounts. It
> mimics
> > 'parent account subtotals' = 'show subtotals' with a different alignment.
> > It has never graduated from experimental and is buggy. I suggest we
> remove
> > it, and switch the option to 'show subtotals'. The change will be in 4.5
> > due in March/April. The relevant PR is
> > https://github.com/Gnucash/gnucash/pull/908
> >
> > Any objections?
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] About 'parent-account-subtotal' option.

[Christopher Lam]

To long-time and new users,

Regarding subtotals in several reports e.g.

Asset $0
Asset:Bank $8,000
Asset:House $100,000
Total Asset $108,000

>From 2003 onwards, there was a 'parent account subtotals' option 'text book
style (experimental)' to show subtotal after groups of accounts. It mimics
'parent account subtotals' = 'show subtotals' with a different alignment.
It has never graduated from experimental and is buggy. I suggest we remove
it, and switch the option to 'show subtotals'. The change will be in 4.5
due in March/April. The relevant PR is
https://github.com/Gnucash/gnucash/pull/908

Any objections?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] flatpak 4.4 reports anomaly

[Christopher Lam]

You normally specify the name when Saving a report. What name did you use?

On Fri, 12 Feb 2021, 12:36 am Elmar,  wrote:

> Running "/usr/bin/flatpak run --branch=stable --arch=x86_64
> --command=gnucash --file-forwarding org.gnucash.GnuCash
> --logto=$HOME/gnucash.trace" in a terminal window invoked GC fine.
> Opening the saved reports item, then trying to delete a report results
> in this output in the terminal window:
>
> ets@Shinobi-L ~ $ /usr/bin/flatpak run --branch=stable --arch=x86_64
> --command=gnucash --file-forwarding org.gnucash.GnuCash
> --logto=$HOME/gnucash.trace
> Found Finance::Quote version 1.49.
> Backtrace:
> 7 (apply-smob/1 #)
> In report-core.scm:
>  735:9  6 (gnc:save-all-reports)
> In srfi/srfi-1.scm:
> 592:29  5 (map1 (("56c1338531aa5948f29ffac9c8299627" . #<) …))
> 592:29  4 (map1 (("48954786309f091b627a6d3bac31df38" . #<) …))
> 592:17  3 (map1 (("f4327d79575b0d1039dc544e59030b77" . #<) …))
> In report-core.scm:
> 725:20  2 (gnc:report-template-save-to-savefile _)
> 659:21  1 (gnc:report-template-serialize #< vers…>)
>  165:0  0 (%report-template-name-procedure _)
>
> report-core.scm:165:0: In procedure %report-template-name-procedure:
> In procedure struct_vtable: Wrong type argument in position 1 (expecting
> struct): #f
> ets@Shinobi-L ~ $
>
> OTOH the gnucash.trace file is completely blank.
>
> - Elmar
>
> On 2/11/21 11:23 AM, Geert Janssens wrote:
> > Ok, the branch specification is probably important.
> >
> > You can try as follows:
> > /usr/bin/flatpak run --branch=stable --arch=x86_64 --command=gnucash
> --file-
> > forwarding org.gnucash.GnuCash --logto="path-to-log-to-or-stdout"
> >
> > My mail client splits this line up, but the command should be all on one
> line.
> >
> > Regards,
> >
> > Geert
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] flatpak 4.4 reports anomaly

[Christopher Lam]

Scheme backtraces are usually found at
https://wiki.gnucash.org/wiki/Tracefile but if flatpak hides them somewhere
obscure you can dump onto console via "gnucash --logto=stdout". See
https://wiki.gnucash.org/wiki/Logging

On Thu, 11 Feb 2021, 6:29 am Elmar,  wrote:

> The sequence of events was that I had been running 3.8, but somehow it
> started to fail badly, with CTD.  So I uninstalled that one and
> reinstalled the one from the Mint repository, which was 2.6.19.  All
> seemed well. I tried to reinstall 3.6 and then 3.8, then 3.11, but the
> installs failed in weird ways, which I didn't bother to document - my
> goal was to get to 4.4 anyway.  So I gave up and grabbed the flatpak of
> 4.4.  In all these versions, going up and down, the data file remained
> perfect, and once I moved the "guts" of my aqbanking folder (archived
> from version 3.8) into the correct folder for 4.4, my online banking
> (downloads of transactions) also worked perfectly, and continue to
> work.  The "guts" of the gnucash folder (the one holding the reports
> templates) when copied from the 3.8 archive into the correct 4.4 folder
> (under .var) seemed to go smoothly, and all my reports showed up fine,
> and they run fine.  I just cannot edit or delete any one of them without
> a CTD, and have to delete the settings6 folder to get them to show up
> again.  All check and repair seems to do is look for imbalances across
> the selected accounts, and it finds no problems.  It doesn't touch
> report or online templates as far as I can see. So, as I said, my only
> problem are editing my reports (running them works), and I see no way to
> edit/resave them, since I CTD as soon as I try.
>
> On 2/10/21 5:13 PM, David H wrote:
> > Elmar,
> >
> > Can I ask how you went from 2.6.19 to 4.4 flatpak?  ... For the
> > reports you may have to open each and re-save the config after the 2.8
> > update, I don't know.
> >
> > Cheers David H.
> >
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Help adding withholding tax and VAT in seperate fileds of the invoice.

[Christopher Lam]

A final note relating to recording the withholding tax as liability: it
will artificially decrease your net worth by the cumulative tax amount.

On Thu, 28 Jan 2021, 12:29 am Nikos Parafestas,  wrote:

> Thank you Derek for your answer.
> In my case I am not accountable whether or not my client pays the 20%
> Withholding Tax but it is obligatory to be written in the invoice as a
> seperate line. It would be nice for me to have a report every year for
> this amount but it is optional.
> On the other hand I need to keep track of the 24% VAT, because I have
> to deposit the VAT I recieve to the goverment every 3 months.
>
>
>
>
> On Wed, 2021-01-27 at 09:17 -0500, Derek Atkins wrote:
> > Hi,
> >
> > On Wed, January 27, 2021 8:49 am, Nikos Parafestas wrote:
> > > Beacuse of the taxation sytem in my country I need to add
> > > withholding
> > > tax and VAT in seperate fields in the invoice. This applies to
> > > every
> > > tansaction with a net price of 300 euro or more.
> >
> > The first thing to note is that GnuCash only allows you to apply a
> > single
> > Tax Table per invoice line-item, but each line item can have its own
> > unique tax-table.  You can (I believe) supply a "default tax table"
> > which
> > gets applied.  There is no way to set a floor, meaning that you will
> > need
> > to manually determine if/when the tax(es) apply.
> >
> > > For example if the Net Price is 1000 euro the invoice should
> > > include
> > > the following:
> > > ---
> > > 1. Net Price = 1000 euro
> > > 2. VAT = 240 euro
> > > 3. Total Price 1240 euro
> > > 4. Withholding Tax (which is 20% of the Net Price. This amount the
> > > client pays directly to the goverment not to me) = 200 euro
> > > 5. Payable (Total - Witholding Tax) = 1040 euro
> > > 
> > >
> > > 1-3  : I have managed to add them correctly
> > > 4 & 5: I don't have a clue how to add them.
> >
> > The best way to think about your particular case is with some
> > algebra, and
> > you'll need to help me a bit to fill that in.
> >
> > GnuCash has two ways to compute taxes:  either they are included in
> > the
> > price, or they are added to the price.
> >
> > If tax is included, then the line-item price is what the user pays,
> > and
> > the tax is computed in such a way that value+tax = price.  In other
> > words,
> > if the price is $100 and 5% tax is included, then the customer pays
> > you
> > $100, of which $4.76 is tax (because 5% of $95.24 is 4.76, and 95.24
> > +
> > 4.76 == 100).
> >
> > If the tax is added on, then the line-item price is the basis for the
> > tax,
> > and the user pays the price+tax total.  In other words, if the price
> > is
> > $100 and there is 5% tax, the user pays $105.
> >
> > Now, back to the GnuCash tax tables.  You can include multiple taxes
> > in a
> > tax table, but the two are independent.  So let's say you have a 5%
> > state
> > tax and a 2% city tax, where the user pays a total of 7%.  This is
> > easy,
> > you have two entries in the tax table, one for 5% and one for 2%.
> >
> > However, there are places (e.g. Canada), where one tax includes the
> > other.
> >  For example, you might have a 10% GST and a 7% PST, where the PST
> > *includes* the GST.  In this case, you would put the 10% GST in one
> > tax
> > table line, but for PST you cannot say 7%, because the 7% includes
> > the
> > 10%.  This is where the algebra comes in.  To compute the PST, you're
> > want
> > to compute x% where:
> >
> > x% of price = 7% of (price + 10% of price)
> >   x * price = .07 * (1 + 0.1) price
> >   x = .07 * (1 + 0.1)
> > = .077
> > = 7.7%
> >
> > So you would enter GST of 10% and PST of 7.7% to get the correct
> > taxes
> > computed.
> >
> > Now, back to YOUR case.  It sounds like you have:
> >   price = 1000
> >   VAT = 24% of the price
> >   Withholding = is 20% of price
> >   Invoice amount is price + VAT - Withholding
> >
> > So really, the invoice amount is price + 4%.
> >
> > It sounds like you need to actually show VAT and Withholding amounts
> > on
> > the invoice.  Do you need to actually RECORD the VAT + Withholding
> > amounts, or just display them on the invoice?  What if the customer
> > does
> > not actually pay the withholding to the government?  Are you still on
> > the
> > hook for it?
> >
> > I am asking because the answer to these questions will tell us if we
> > need
> > to handle it within the tax table system, or by the invoice report.
> >
> > If you are only on the hook for 4%, regardless of whether they pay or
> > not,
> > then you should probably just record the 4% and update the invoice to
> > report the 24% and 20% values.  However if you need to actually
> > record
> > that, we might have a SMALL problem, because I am not sure that
> > GnuCash
> > supports a "negative" rate, which is what you would need for the
> > withholding.
> >
> > > I hope I made it clear.
> >
> > Ditto..
> >
> > > ps. If you want to help I would like to ask you to provide your
> > > answers
> > > in a

Re: [GNC] The man who saw everything twice....

[Christopher Lam]

> Why do Gnucash balance sheets print account and subaccount totals twice:
once at the beginning of each such account and again at the end?

Because you'd selected Subtotal on both options as you described. This is a
long-standing wart/bug because it's nonsensical to allow subtotals to be
shown both before and after each account+subaccounts. And it's impossible
to fix this behaviour without angering many long term users. The "next-gen"
balance sheet is in the experimental reports menu; the latter will never
show subtotals twice.


On Sun, 24 Jan 2021, 11:04 pm Peter S. Shenkin,  wrote:

> Please tell me where this option is.
>
> I already said that I didn't see an option for this. I looked before
> posting and just looked again. I don't see anything like what you
> mentioned. I believe I have been through all the Options and in fact I got
> as far as I did by specifying several. For example, I see the following
> options in Display that pertain to the account balances:
>
>- Parent account balances
>   - Subtotal (I have this selected)
>   - Account Balance
>   - Do not show
>- Parent account subtotals
>   - Show subtotals (I have this selected)
>   - Do not show
>   - Text book style (experimental)
>
> It's not impossible that I am missing it somewhere, but if so, please tell
> me where to look.
>
> I also looked in Preferences > Reports, but I see nothing relevant there
> either.
>
> -P.
>
> On Sun, Jan 24, 2021 at 9:28 AM Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
>
> > On 1/24/2021 12:26 AM, Peter S. Shenkin wrote:
> > > Gnucash 4.3 on a mac.
> > >
> > > Why do Gnucash balance sheets print account and subaccount totals
> twice:
> > > once at the beginning of each such account and again at the end?
> > >
> > > It adds a large number of extra lines and no new information, and
> > > balance-sheet examples from (the few) accounting books on my shelf do
> not
> > > do this.
> > >
> > > I find this very annoying and cannot find an option to turn this off.
> Is
> > > there a hidden way? Or even an obvious way that I'm just missing?
> > >
> > Edit => Report Options
> >
> > One of the things you get to choose is how you see "subtotals" -
> > none, before, after, or both. Sounds like you are doing both. Just turn
> > off the one you don't want and keep the one you do want. My personal
> > preference is "after" so that's what I specify.
> >
> > I will suggest again, anybody new to gnucash should spend a little time
> > investigating the options available to each report used. You don;t have
> > to accept the defaults.
> >
> > Michael D Novack
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Switching to trading accounts in existing database

[Christopher Lam]

Personally I'd stick with 1 book = 1 currency, and record all transactions
in their home currency only. I'd only record the same transaction in both
books if they're a formal currency transfer.

A simple issue is balance sheet: if you hold stocks eg TSLA in your USD
account, and ANA from your Japan account... the overall balance sheet in
USD will convert ANA->JPY->USD. This has a chance of being accurate if you
have *daily* USD/JPY prices. Most users don't.

On Fri, 22 Jan 2021 at 02:06, Lukas Haase  wrote:

> Hi Christopher,
>
> This is very sad. Sad for various reasons.
>
> I went over these documents previously (but did not read them thoroughly).
>
> My takeaway is:
> * Storing the conversion rate per transaction makes the accounting
> equation as a function of time inconsistent (but it is consistent for
> each snaphot in time).
> * Trading account accounts for these inaccuracies.
>
> My question was more why the trading accounts (which seem to me the
> cleaner, superior and better way) are not enabled by default.
>
> Also, can you comment a bit more why precicely this would be a major
> minefield? (If you know it, of course).
>
> Multiple databases are just extremely hard for some people (like me).
>
> Consider living for a couple of months to a year in a different place.
> There is just no way to separate this in a clean way without replicating
> all the transactions in different databases. BTDT.
>
> Also I moved multiple times. Even then, there is no clear cut: Initially
> I would use credit cards, ATM etc. from previous country. Even the first
> or second rent may be partially paid with funds from the previous
> location. It takes a few months until I could consider the books between
> two countries sufficiently separate. The only ways are a) Massive
> transaction Replication b) booking everything I pay with funds from old
> country into old database. But with my rent example, it gets very
> inconsistent how much I paid rent at the new place.
>
> Lastly, simple portfolio accounting (e.g. crypto currencies) if they are
> bought in different countries.
>
> I am curious what the potential mines are so I can try to avoid them.
>
> Lukas
>
>
>
> On 2021-01-21 20:20, Christopher Lam wrote:
> > Multicurrency is a major minefield.
> > Start from
> https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html
> > and finish with
> > https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the
> > background on trading accounts.
> >  From discussion with accountant, it would seem that the safest approach
> is
> > to have 1 book per home currency. When you move countries you'd be better
> > off with a new book with a new home currency. Taking temporary trips
> abroad
> > gets the currencies translated to home currency. AFAIU. IANAA YMMV.
> > https://techcrunch.com/2010/08/14/internet-must-be-true/
> >
> > On Fri, 22 Jan 2021 at 00:59, Lukas Haase  wrote:
> >
> >> Hi Mike,
> >>
> >> On 2021-01-21 02:24, Mike Alexander wrote:
> >>> On 19 Jan 2021, at 20:08, Lukas Haase wrote:
> >>>
> >>>> So I got recommended using trading accounts. But suddenly all my
> >>>> previous multi-currency transactions get a small grey box with a cross
> >>>> (hinting the transaction is inconsistent).
> >>>>
> >>>> How do I best deal with this?
> >>>> Is it possible to keep my old multi currency transactions as-is and
> >>>> use trading accounts only for securities/stocks?
> >>>>
> >>>> If not, how do I migrate while ensuring my ten years worth of data
> >>>> does not suddenly get inconsistent?
> >>>
> >>> You should be able to use the "Check & Repair" commands in the Actions
> >>> menu to add the trading account splits to existing transactions.  I
> >>> would certainly save a copy of my data before doing this, and try it on
> >>> a few transactions first.  Your situation is complex enough that it is
> >>> not unlikely that this won't do exactly what you want, but it's worth a
> >>> try assuming you have good backup.
> >>
> >> Thank you, I think that worked indeed.
> >>
> >> I still need to cross-check everything (at the first glance things look
> >> OK).
> >>
> >> So then I'd have a general question on the multi currency feature:
> >>
> >> 1.) Are "Trading Accounts" just an *alternative* way to handle multi
> >> currencies (and as such have nothing to do with "trading&

Re: [GNC] Switching to trading accounts in existing database

[Christopher Lam]

The issue is when currency fluctuates, you have capital gains or losses,
depending on whatever you consider to be your home currency. These
gains/losses are unrecorded (but not unrealised). C

On Fri, 22 Jan 2021 at 04:36, w...@theprescotts.com 
wrote:

> I am probably missing something here.
>
> I have bank accounts in two countries and regularly transfer money between
> them. Whenever I move money, I record the transaction and the amount for
> each side of the transaction. Gnucash automatically makes an entry in the
> Price Database recording the conversion rate.
>
> It seems much cleaner than treating one currency or the other as a
> commodity that is bought or sold at some rate. One thing that is a little
> strange is that the Price Database has separate tables for each direction.
> I suppose it depends on which side of the transaction I use to record the
> transfer. But I almost never look at the Price Database so it doesn't
> bother me much.
>
> Will
>
> On 2021 Jan 21, at 01-21 20:06:04, Lukas Haase  wrote:
>
> Hi Christopher,
>
> This is very sad. Sad for various reasons.
>
> I went over these documents previously (but did not read them thoroughly).
>
> My takeaway is:
> * Storing the conversion rate per transaction makes the accounting
> equation as a function of time inconsistent (but it is consistent for each
> snaphot in time).
> * Trading account accounts for these inaccuracies.
>
> My question was more why the trading accounts (which seem to me the
> cleaner, superior and better way) are not enabled by default.
>
> Also, can you comment a bit more why precicely this would be a major
> minefield? (If you know it, of course).
>
> Multiple databases are just extremely hard for some people (like me).
>
> Consider living for a couple of months to a year in a different place.
> There is just no way to separate this in a clean way without replicating
> all the transactions in different databases. BTDT.
>
> Also I moved multiple times. Even then, there is no clear cut: Initially I
> would use credit cards, ATM etc. from previous country. Even the first or
> second rent may be partially paid with funds from the previous location. It
> takes a few months until I could consider the books between two countries
> sufficiently separate. The only ways are a) Massive transaction Replication
> b) booking everything I pay with funds from old country into old database.
> But with my rent example, it gets very inconsistent how much I paid rent at
> the new place.
>
> Lastly, simple portfolio accounting (e.g. crypto currencies) if they are
> bought in different countries.
>
> I am curious what the potential mines are so I can try to avoid them.
>
> Lukas
>
>
>
> On 2021-01-21 20:20, Christopher Lam wrote:
> > Multicurrency is a major minefield.
> > Start from
> https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html
> > and finish with
> > https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the
> > background on trading accounts.
> > From discussion with accountant, it would seem that the safest approach
> is
> > to have 1 book per home currency. When you move countries you'd be better
> > off with a new book with a new home currency. Taking temporary trips
> abroad
> > gets the currencies translated to home currency. AFAIU. IANAA YMMV.
> > https://techcrunch.com/2010/08/14/internet-must-be-true/
> > On Fri, 22 Jan 2021 at 00:59, Lukas Haase  wrote:
> >> Hi Mike,
> >>
> >> On 2021-01-21 02:24, Mike Alexander wrote:
> >>> On 19 Jan 2021, at 20:08, Lukas Haase wrote:
> >>>
> >>>> So I got recommended using trading accounts. But suddenly all my
> >>>> previous multi-currency transactions get a small grey box with a cross
> >>>> (hinting the transaction is inconsistent).
> >>>>
> >>>> How do I best deal with this?
> >>>> Is it possible to keep my old multi currency transactions as-is and
> >>>> use trading accounts only for securities/stocks?
> >>>>
> >>>> If not, how do I migrate while ensuring my ten years worth of data
> >>>> does not suddenly get inconsistent?
> >>>
> >>> You should be able to use the "Check & Repair" commands in the Actions
> >>> menu to add the trading account splits to existing transactions.  I
> >>> would certainly save a copy of my data before doing this, and try it on
> >>> a few transactions first.  Your situation is complex enough that it is
> >>> not unlikely that this won't do exactly what you want, but it'

Re: [GNC] Representing fund restructure in Gnucash

[Christopher Lam]

You could use the stock split assistant to record the stock split (cannot
record stock split using the register only), then use the security editor
to rename the stock. Someone else may have better ideas.

On Fri, 22 Jan 2021, 3:59 pm Peter Lamb via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> I own some Exchange Traded Fund stocks, and one of the stocks has been
> restructured: the stock I owned has been converted into another stock,
> so that 1 ABC share (the original stock) has been converted into N DEF
> shares. I have only been provided with the ratio of share values, not
> with prices. No money changed hands.
>
> How do I represent this in Gnucash?
>
> Peter
>
> --
>
> Peter Lamb
>
> Canberra, ACT
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Switching to trading accounts in existing database

[Christopher Lam]

https://www.accaglobal.com/us/en/technical-activities/technical-resources-search/2015/march/frs102-foreign-currency-translation.html

This is all I can offer in supporting information. Experienced users can
undoubtedly offer more.

On Fri, 22 Jan 2021, 12:36 pm w...@theprescotts.com, 
wrote:

> I am probably missing something here.
>
> I have bank accounts in two countries and regularly transfer money between
> them. Whenever I move money, I record the transaction and the amount for
> each side of the transaction. Gnucash automatically makes an entry in the
> Price Database recording the conversion rate.
>
> It seems much cleaner than treating one currency or the other as a
> commodity that is bought or sold at some rate. One thing that is a little
> strange is that the Price Database has separate tables for each direction.
> I suppose it depends on which side of the transaction I use to record the
> transfer. But I almost never look at the Price Database so it doesn't
> bother me much.
>
> Will
>
> On 2021 Jan 21, at 01-21 20:06:04, Lukas Haase  wrote:
>
> Hi Christopher,
>
> This is very sad. Sad for various reasons.
>
> I went over these documents previously (but did not read them thoroughly).
>
> My takeaway is:
> * Storing the conversion rate per transaction makes the accounting
> equation as a function of time inconsistent (but it is consistent for each
> snaphot in time).
> * Trading account accounts for these inaccuracies.
>
> My question was more why the trading accounts (which seem to me the
> cleaner, superior and better way) are not enabled by default.
>
> Also, can you comment a bit more why precicely this would be a major
> minefield? (If you know it, of course).
>
> Multiple databases are just extremely hard for some people (like me).
>
> Consider living for a couple of months to a year in a different place.
> There is just no way to separate this in a clean way without replicating
> all the transactions in different databases. BTDT.
>
> Also I moved multiple times. Even then, there is no clear cut: Initially I
> would use credit cards, ATM etc. from previous country. Even the first or
> second rent may be partially paid with funds from the previous location. It
> takes a few months until I could consider the books between two countries
> sufficiently separate. The only ways are a) Massive transaction Replication
> b) booking everything I pay with funds from old country into old database.
> But with my rent example, it gets very inconsistent how much I paid rent at
> the new place.
>
> Lastly, simple portfolio accounting (e.g. crypto currencies) if they are
> bought in different countries.
>
> I am curious what the potential mines are so I can try to avoid them.
>
> Lukas
>
>
>
> On 2021-01-21 20:20, Christopher Lam wrote:
> > Multicurrency is a major minefield.
> > Start from
> https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html
> > and finish with
> > https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the
> > background on trading accounts.
> > From discussion with accountant, it would seem that the safest approach
> is
> > to have 1 book per home currency. When you move countries you'd be better
> > off with a new book with a new home currency. Taking temporary trips
> abroad
> > gets the currencies translated to home currency. AFAIU. IANAA YMMV.
> > https://techcrunch.com/2010/08/14/internet-must-be-true/
> > On Fri, 22 Jan 2021 at 00:59, Lukas Haase  wrote:
> >> Hi Mike,
> >>
> >> On 2021-01-21 02:24, Mike Alexander wrote:
> >>> On 19 Jan 2021, at 20:08, Lukas Haase wrote:
> >>>
> >>>> So I got recommended using trading accounts. But suddenly all my
> >>>> previous multi-currency transactions get a small grey box with a cross
> >>>> (hinting the transaction is inconsistent).
> >>>>
> >>>> How do I best deal with this?
> >>>> Is it possible to keep my old multi currency transactions as-is and
> >>>> use trading accounts only for securities/stocks?
> >>>>
> >>>> If not, how do I migrate while ensuring my ten years worth of data
> >>>> does not suddenly get inconsistent?
> >>>
> >>> You should be able to use the "Check & Repair" commands in the Actions
> >>> menu to add the trading account splits to existing transactions.  I
> >>> would certainly save a copy of my data before doing this, and try it on
> >>> a few transactions first.  Your situation is complex enough that it is
> >>> not unlikely that this won't 

Re: [GNC] Switching to trading accounts in existing database

[Christopher Lam]

Multicurrency is a major minefield.
Start from https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html
and finish with
https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the
background on trading accounts.
>From discussion with accountant, it would seem that the safest approach is
to have 1 book per home currency. When you move countries you'd be better
off with a new book with a new home currency. Taking temporary trips abroad
gets the currencies translated to home currency. AFAIU. IANAA YMMV.
https://techcrunch.com/2010/08/14/internet-must-be-true/

On Fri, 22 Jan 2021 at 00:59, Lukas Haase  wrote:

> Hi Mike,
>
> On 2021-01-21 02:24, Mike Alexander wrote:
> > On 19 Jan 2021, at 20:08, Lukas Haase wrote:
> >
> >> So I got recommended using trading accounts. But suddenly all my
> >> previous multi-currency transactions get a small grey box with a cross
> >> (hinting the transaction is inconsistent).
> >>
> >> How do I best deal with this?
> >> Is it possible to keep my old multi currency transactions as-is and
> >> use trading accounts only for securities/stocks?
> >>
> >> If not, how do I migrate while ensuring my ten years worth of data
> >> does not suddenly get inconsistent?
> >
> > You should be able to use the "Check & Repair" commands in the Actions
> > menu to add the trading account splits to existing transactions.  I
> > would certainly save a copy of my data before doing this, and try it on
> > a few transactions first.  Your situation is complex enough that it is
> > not unlikely that this won't do exactly what you want, but it's worth a
> > try assuming you have good backup.
>
> Thank you, I think that worked indeed.
>
> I still need to cross-check everything (at the first glance things look
> OK).
>
> So then I'd have a general question on the multi currency feature:
>
> 1.) Are "Trading Accounts" just an *alternative* way to handle multi
> currencies (and as such have nothing to do with "trading")?
>
> 2.) Trading Account seem to be way more powerful than storing the
> exchange rate in each transaction
>
> 3.) Why exactly aren't they enabled by default if they are so superior?
> Why let people my default use the way that makes things less consistent
> and error-prone?
>
> Thanks,
> Lukas
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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 specific: MTD - Making Tax Digital

[Christopher Lam]

But the CSV export already exists. See the "Income and GST Statement"
report which is definitely tailored for VAT/GST calculations for UK and
Australia but can be used for any similar tax regimes, and has a dedicated
CSV export facility. If your bridging software has particular requirements
for formatting the CSV input, the report may be amended as required.

On Sun, 17 Jan 2021, 4:53 pm chr...@floatdene.com, 
wrote:

> Good points. I have bridge software already working and approved by HMRC
> for
> use. My initial thought was to have a report in GnuCash that generated the
> VAT report for a period. There would then be a menu option to submit VAT.
> This menu option would generate a csv file containing the VAT values for
> submission. The bridge software is then invoked independently and submits
> the VAT return to HMRC. As there are only about 6 users interested, it is
> definitely not worth the effort!
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Styles of different items in GNUcash reports

[Christopher Lam]

Check the style sheets on the edit menu.

On Wed, 13 Jan 2021, 5:41 pm mummins heitzel,  wrote:

>I am trying to fix an issue with the formatting of different items in a
>simple journal or general ledger.
>
>What I am trying to achieve is to format the primary sorting key in
>BOLD, but it appears that this item does not have s style of its own.
>
>In my case the primary sorting key are the accounts The primary sorting
>key in the generated report seems to be using the background color as
>defined for the subheader (in e.g. the technicolor style).
>
>But it does not appear to have a text style of its own, it appears to
>use the test style as defined for the normal text field Example of
>report
>
>
>1000 Bank account One <-- I want this bold
>
>01.01.2020 Transfer 2000 EUR
>
>02.01.2020 Transfer 1000 EUR
>
>Total 3000 EUR
>
>1100 Bank account Two <-- I want this bold
>
>03.01.2020 Transfer 6000 EUR
>
>05.01.2020 Transfer 4000 EUR
>
>Total 1 EUR
>
>
>Does anyone have an idea of a workaround or any ongoing improvement to
>allow this in GNUcash.
>
>Right now my only option is to export the HTML, import in Excel and do
>this manually.
>
>Feels like a waste of time as the report function in GNUcash is
>otherwise very nice and easy.
>
>Anyone who can point to a GNUcash developer forum, for these types of
>issues.
>
>
>Thank you for all advice
>
>
>Ray
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Best way to upgrade from an old version (2.6.14) to current

[Christopher Lam]

A last note: during upgrades, check the trace file for possibly important
logs. These are overwritten, hence upgrade messages can disappear easily.

https://wiki.gnucash.org/wiki/Tracefile

On Sat, 9 Jan 2021, 9:58 am Tfastle via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> Well, I must chime in.
>
> You all are way over my head now but the thread seems lively and is
> entertaining.  I think what I will do is save my file in a safe place and
> try the update and see what happens and, along the way, learn a little.
> Then, maybe I'll understand a bit more of what is being discussed here and
> be able to resolve issues. If I don't end up having many then great.  If I
> do, I will then switch to the "fresh install of newest version and import
> my
> Quicken date mode" and see if I can figure that out. If I can't, it won't
> be
> the end of the world.
>
> For now, I have quickly moved on to step 8 am enjoying a brew as I type
> this.  I really appreciate all of the replies and input but think I may
> have
> gotten a little ahead of myself (often do) and need to get a little
> practical experience (ie - give it a go) before thinking I will understand
> the problems.
>
> I will say, you all write well, are knowledgeable and entertaining.  I will
> try to update my program and continue to watch this thread and  throw
> something in if and when I have something I think is of value.
>
> Thanks!
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Shortcut to Custom Reports query

[Christopher Lam]

The shortcut key combo is: Alt-R S if your locale is English-US.

On Thu, 7 Jan 2021 at 09:51, Roberts Klotiņš 
wrote:

> Hi,
> I often use "Saved Report Configurations", but I find menu click-through
> access rather cumbersome. Is there a shortcut key combination for that, or
> has someone found a way to map a shortcut key in GnuCash?
>
> With thanks,
>
> Robert
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Income statement with transactions

[Christopher Lam]

You're nearly there. In the Transaction Report, you'll want to:
1) sort by account code instead of account name, and ensure all accounts
have appropriate code. eg. Revenue accounts code "I-01" and Expense
accounts "X-01"
2) sorting/show full account name is enabled.
HTH

On Thu, 24 Dec 2020 at 22:49, Yves Forget via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I am trying to get a report similar to the Income Statement (Revenues and
> expenses, with subtotals by account), but with transactions instead of just
> the summary for each account.
>
> I went with the Transactions Report and got pretty close with the
> following : account name as primary key and date and secondary key.  With
> account in ascending order, I get Expenses before Revenues.  Revenues first
> would be better but I can live with that.
>
> My main problem is that the report shows only the account name of the
> bottom-level account.  The sort seems to be on the full name
> (Expenses:Car:Gas) but it shows only Gas in the report.
>
> Is there any way to get that with existing reports ?  Should I use another
> report instead of the Transactions Report to achieve this purpose ?
>
> Thanks,
>
> Yves
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] multi col income report

[Christopher Lam]

The usual recommendation to export reports as HTML and import from Excel
still applies.
To format date differently, review your global preferences found in Edit >
Preferences > Numbers, Date and Time


On Sun, 20 Dec 2020 at 22:41, Ian D Henry  wrote:

> I have been using the experimental multi col report.  Up to the end of
> October, the report prints on one page.  Now that Nov is included the
> document is too wide for the paper and the numbers for November are
> truncated.  There is no second page with the missing numbers.  Once I add
> the year end column after December there will be two columns that are not
> printed.  Is there a way to avoid this?
>
> I'd also like to suppress the printing of the $ sign, since it does not add
> any useful information.  Is that possible?
>
> On a less important note is there a way to change the date format to read
> something like 31Dec20 instead of 31/12/20 and is there a way to suppress
> leading zeros  in the current date formats?
>
> Thank you for your advice.
>
> Ian
> --
> Ian D Henry
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] barcode & invoices

[Christopher Lam]

Liz there's https://en.m.wikipedia.org/wiki/EPC_QR_code and someone could
write a QR code plugin connector for use by the invoice report.

On Wed, 16 Dec 2020, 5:40 am Liz Dodd,  wrote:

> On Tue, 15 Dec 2020 21:54:50 +0100
> Saša Janiška  wrote:
>
> > Hello,
> >
> > I'm using GC to track our personal finances, non-profit account and
> > my small 1-man company.However, for generating company's invoices I
> > use web-based solution offering ability to have separate
> > quotes/invoices etc.
> >
> > However, I'm considering to simplify my workflow and take advantage
> > of GC's invoicing features. Of ocurse, I'd need to customize several
> > things by adding some custom data to the invoice, but wonder how to
> > e.g. add time when the invoice is generated or what is the
> > recommended customization method in GC-4.2?
> >
> > Moreover, since the beginning of 2021 every invoice in Croatia when
> > paid via cash must have QR code soe that end customer can check its
> > fiscalization data via tax office. I plan to void dealing with cash,
> > but many/most of generated invoice do contain barcode which enables
> > one to use his/her smart phone and scan the barcode via banking
> > application for easy payment, so I am interested how that feature
> > could be added to GC-created invoices? (I'm running Debian Sid...)
> >
> >
> > Sincerely,
> > Gour
> >
>
> Gour, the use of a QR code in that context is interesting. I have few
> ideas about generating a QR code and putting it on the invoice. Is it
> the same code each time (easier) or a new code each time (hard)?
>
> I worry about the fraud opportunities when the payment details are not
> easily seen. How are people asked to verify correct banking details on
> these QR-coded invoices?
>
> 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.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] bulk operations?

[Christopher Lam]

But it's crucial to input the exchange rate - and IIUC you are encouraged
to use
https://www.gov.uk/government/publications/hmrc-exchange-rates-for-2020-monthly

On Mon, 7 Dec 2020 at 22:47, Samantha Payn 
wrote:

>
> Thanks for the suggestion, Adrien. I’ve got entering the invoice data into
> Gnucash down to a fine art (especially with the recent “predictive text”
> input in my “product” fields! Thanks again for that, whoever it was!). It
> is specifically the step to confirm the exchange rate when posting an
> invoice which is the time consuming point.
> Samantha Payn
>
> > On 7 Dec 2020, at 22:25, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> >
> > Samantha, you can import invoice data.
> >
> > Thus, if you have a way to easily create that data in a spreadsheet, you
> can save it as CSV, then import them to GnuCash.
> >
> > See the Help/Guide about importing business data for the required
> columns.
> >
> > I'm not certain if it works well with a foreign currency however.
> >
> > Regards,
> > Adrien
> >
> >> On 12/7/20 4:11 PM, Samantha Payn wrote:
> >> I’d find a “batch post invoice” function enormously helpful. I have a
> foreign currency client who insists on a separate invoice for each
> (sometimes inconsequential) amount and the multiple clicks to post the
> invoice and confirm the exchange rate for each one are time consuming.
> >> Currently the quickest I’ve got it is to create each invoice but not
> post it, then use “find invoice” criteria to call all the invoices up,
> highlight them all and then click “post” which prompts the exchange rate
> dialogue (for every invoice). I use “fetch rate” for the first invoice, and
> just “accept rate” for all the others, but that’s still three clicks per
> invoice (I think).
> >> Please could Santa bring me a “batch post invoice” function for
> Christmas?
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Income in foreign currency - unrealized vs realized gains / losses How To

[Christopher Lam]

Agreed.

https://www.ato.gov.au/Individuals/Income-and-deductions/In-detail/Income/Converting-foreign-income-to-Australian-dollars/

Either convert *all* amounts into home currency AUD, or show original
currencies (and any conversion) to an accountant who will apply the
correct fx rate and any gains.

On Fri, 27 Nov 2020 at 17:49, John Ralls  wrote:

>
>
> > On Nov 27, 2020, at 8:47 AM, Anton via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > Dear Gnucash community,
> >
> > Residing in Australia, I work with US customers and get paid in US
> dollars. I don't always convert money from USD to AUD, and if I do, it's
> usually an arbitrary amount on an arbitrary day.
> >
> > Now, how do I setup my accounts in Gnucash, and what would be the
> corresponding income and exchange transactions, in order to be able to
> report report unrealized and realized currency exchange gains and losses?
> >
> > Here's how I have it now (simplified):
> >
> > Income
> > US Client A
> > Assets
> > US Bank
> > AU Bank
> > Trading:Currency (automatic accounts)
> > AUD
> > USD
> >
> > When I got paid USD 1000, I recorded the first transfer:
> >
> > Income:US Client A => Assets:US Bank
> > USD $1000
> > This was worth AUD $1500 at 1.5 AUD = 1 USD, but I keep USD
> > Also, AUD $1500 is what I will have to report in my business activity
> statement for GST purposes.
> >
> > Then say in 1 month time I convert USD $100 to AUD $130 at 1.3
> > My understanding is this transaction should generate a realized loss of
> AUD$20
> >
> > At the end of the day, in my report for the taxation office I need to
> put something like this:
> >
> > Income: AUD $1500
> > Expense:
> > Deductible
> > Realized currency exchange loss: AUD $20
> >
> > Please advise. -- Thanks, Anton
>
> There's a long discussion about this (with lots of digressions) in
> https://bugs.gnucash.org/show_bug.cgi?id=797796. The TL;DR is that
> GnuCash doesn't support it well and needs a fundamental change it the way
> it selects transaction currency to do it right. That change is a long way
> off.
>
> In the meantime, you can capture the rate and include the sale in the
> trading accounts by using AUD income accounts to record your USD sales and
> AUD expense accounts to record any expenses paid for with USD assets. That
> won't help with purchase of assets from a USD account but you can fake that
> part out by creating an AUD scratch account in which you first buy AUD with
> USD and then buy the USD asset with the AUD in that scratch account. This
> workaround will work best if you always create the transactions from an
> AUD-denominated account so that the transaction currency is AUD, causing
> the transaction to balance in AUD.
>
> Disclaimer: I do no multi-currency accounting myself and the above is a
> very condensed summary of a long-running discussion. The accountant who is
> participating in that bug doesn't like mailing lists but is on IRC so you
> might go there to ask him. You should also get advice from your own
> accountant/tax advisor.
>
> Regards,
> John Ralls
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Create Chart to Forecast Future Cash Flow

[Christopher Lam]

The the Balance Forecast report in the Asset menu.

On Mon, 23 Nov 2020 at 17:49, Chris Gifford  wrote:

> Hello all,
>
> I am relatively new to Linux computing and new to GNU Cash and
> considering to move from Microsoft Money. However, Microsoft Money has
> the capability to graph future cash flow based on scheduled transactions
> for any date range. It also has the capability of changing one scheduled
> transaction in the future.  The only app that even comes close to this
> capability is Quicken, however it only allows you to change the next
> transaction.  And it has a lot of flaws that MS Money does not.
>
> I am hoping there is a way to add this type of capability to GNU Cash,
> however, I don't even see any  charts in the default set of reports,
> only HTML based text reports.  I understand GNU Cash is open source and
> I am programmer but before I even start a project of this magnitude, I
> was wondering if anyone has tried creating charts such as the one below
> and if so what the process is.
>
> Thank you for any input provided.
>
>
> MS Money Cash Flow Forecast
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Apparent Miscalculation

[Christopher Lam]

Because it's what it was written to do. Try the closest direct price first
if one exists. If not try with 1 intermediate currency. If not, it fails.
https://github.com/Gnucash/gnucash/blob/maint/libgnucash/engine/gnc-pricedb.c#L2576

On Mon, 16 Nov 2020 at 10:55, Eric Coates via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Hi
>
> SAP 19 shares @ €102.00 equals €1938.00 @ (€0.89662 = £1) thus value
> =£1737.65 *NOT £1831.77*
>
> You avoided answering the question about your recorded EUR-GBP rate.
>
> Mea culpa!
> It should have read "€1 = £0.89662" - and I spent over an hour writing
> that email! On the bright side the calculation (€1938.00 = £1737.65) used
> the correct conversion.
>
> As a side issue (and for my education, not as a criticism) why does
> Gnucash use outdated GBP prices (they were from early 2018) instead of the
> two stage conversion using current data?
>
> Take care
>
> Eric
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget screen Grand Total

[Christopher Lam]

You'll need to upgrade to 4.2 -- see the flatpak releases.

On Sun, 15 Nov 2020, 9:54 am Andrew,  wrote:

> Hi All
>
> I have just rolled from Ubuntu 18.04 to 20.04 and note a difference in
> the GNUCash app versions making it more difficult to for me to manage my
> expenses.
>
> Current Ubuntu 20 GNU Cash Version
>
>  Version: 3.8
>  Build ID: 3.8b+(2019-12-29)
>  Finance::Quote: 1.49
>
> Version under Ubuntu 18
>
>  Version 2.6.19
>
> In previous version there was a total line at the very bottom of the
> budget screen that allowed me to see which months were over/under spent
> allowing me to forecast future issues in my cash flow. Is there a way to
> turn this back on in settings or can it be reintroduced. I am a 60  year
> old creature of habit and I have had to reinstall Ubuntu 18 alongside
> 20 just to use older version of GNU Cash which served my purpose.
>
> The Income/Expenses/Liabilities used to be grand totaled at the very
> bottom and updated on live updates of the budget above . Now it does not.
>
> Many thanks in anticipation of a reply.
>
>
> Cheers
>
> Andrew
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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 4.2 QIF download issue

[Christopher Lam]

Would you please file a bug on bugs.gnucash.org ideally with a small full
qif file

On Sat, 7 Nov 2020, 5:42 am Roderick Averill, 
wrote:

> Version 4.2 problem: When I import a qif file from my bank, it imports the
> "+" transaction amounts (deposit), but not the "-" transaction amounts (EFT
> out of the account). The - amounts are all zeros.
>
> Here's a snippet from the qif file:
>
> !Type:Bank
>
> D01/02/2020
>
> T100.00-
>
> NEFT
>
> Company A
>
> ^
>
> D01/03/2020
>
> T500.00+
>
> NDEPOSIT
>
> PDEPOSIT
>
>
> The EFT amount does not import, the deposit imports.  Is this a qif format
> issue? This worked fine in the previous version of Gnucash (3.6)
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Looking for Upgrade Tips

[Christopher Lam]

Safest approach would be to upgrade 2.4 -> 2.6.21 -> 3.11 -> 4.x and of
course backups before each step.

On Sun, 1 Nov 2020 at 22:11, TanyaMc70  wrote:

> I currently have v. 2.4.13 and am needing to upgrade to get export and
> reporting options. I have researched on the site, wiki, and archives. I am
> just wanting to make sure I am not missing something by asking for info
> here.I am running Windows 10 OS.This is what I understand is the correct
> process:1. Backup current version.2. Download and install 3.113. Open
> account and run Action > Check & Repair > Check & Repair All after opening
> the file for the first time post upgrade. 4. Repeat above steps for 4.0Am I
> missing anything? Thank you!
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Bizarre happenings

[Christopher Lam]

This may happen if there's a report options window hidden behind the main
Gnucash window.

On Sun, 1 Nov 2020 at 18:39, alessandra derniat <4san...@live.com> wrote:

> My copy of gnucash is acting strange and will not let me access any
> options for reports. I’m stuck with the options I had the last time I used
> it.
>
> Can someone help me fix this? I’ve been using this program successfully
> for almost 2 years and in general am very happy with it but this has me
> looking around for something else.
> Thanks,
> Sandy
>
>
> Sent from Mail for
> Windows 10
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to turn off report/chart animations in 4.x?

[Christopher Lam]

Chartjs animation uses its own options mechanism to disable animation. The
animation will be removed in 4.3 onwards. There's no plan to introduce an
option to reenable animation.

On Thu, 29 Oct 2020, 8:17 am Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> Perhaps try setting Options > General > Stylesheet to "CSS-based" then
> Edit > Style Sheets > CSS-based and see if you can set the animation
> transition time to zero. (not sure if they can be turned off)
>
> You'll probably have to export one first and then open with a text
> editor to find the proper node/class for the CSS declaration.
>
> Regards,
> Adrien
>
> On 10/28/20 5:20 PM, lj wrote:
> > I just starting moving from gnucash-3.11 to 4.2. The animations in
> > report charts and graphs are a little cute the first time you see them,
> > but get annoying (to me) very quickly. Is there any way to turn them
> > off? Permanently, for every report? So that (for example) a bar chart
> > just appears, rather than slowly sliding up the screen?  Perhaps a bit
> > of CSS in in gtk-3.0.css?
> >
> > As far as I can tell, they come from Chart.js, and they can be turned
> > off in the report scripts by programmers. But I can't find any way the
> > application user can turn them off.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Simple reporting help

[Christopher Lam]

The experimental multicolumn reports have a "show report options" or
something in the general tab, which will assist troubleshooting.

On Tue, 27 Oct 2020, 8:26 pm Michelle,  wrote:

> I did try. Had to get the flatpak version 4.2 as Mint is too far behind
> that I couldn't easily "make" it, but it still gave nothing.
>
> Michelle.
>
> On Tue, 2020-10-27 at 09:00 +1100, Geoff wrote:
> > Wow, that's a much better solution, it shows sub-totals for
> > sub-accounts, and even handles financial years not just calendar
> > years.
> >
> > Thanks for the tip Gal!
> >
> > Michelle - it might be worth upgrading for this feature, see
> > attached
> > screenshot.
> >
> > Geoff
> > =
> >
> > On 27/10/2020 3:49 am, Gal wrote:
> > > Another way to achieve what you're looking for is to select Reports
> > > -->
> > > Experimental --> Income Statement (Multicolumn)
> > >
> > > Then select the relevant account in the Accounts Tab, and select
> > > "Year" in
> > > the Period duration dropdown list in the General tab.
> > >
> > >
> > >
> > > --
> > > Sent from:
> > > http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > If you are using Nabble or Gmane, please see
> > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] 4.2 on Windows 10 keeps randomly crashing

[Christopher Lam]

Is there a comma in the pasted amount? You'll want to remove it.
https://bugs.gnucash.org/show_bug.cgi?id=797959

On Wed, 21 Oct 2020 at 15:21, mike823  wrote:

> My new installation of 4.2 on Windows 10 keeps randomly crashing. Maybe 10
> times in the last two weeks. Version 3 was extremely stable, have not seen
> a
> crash in years.
>
> Today it happen 5 times while I was trying to enter a new stock buying
> transaction as following:
> - duplicated an existing transaction
> - edit quantity
> - edit price  <<< crash on
> paste
> - edit total drawn from cash balance <<< crash on keyboard edit
>
> GC windows fading, spinning circular cursor and crash, no message what so
> ever.
>
> What is the standard procedure to troubleshoot something like this? TIA.
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] v4.2 exchange rates' decimal places

[Christopher Lam]

Please file bug in Bugzilla and some screenshots.

On Sat, 17 Oct 2020, 12:39 pm Phil Diacono,  wrote:

> Hi team,
>
> I have a multi-currency setup so when I run reports (Balance Sheet,
> Profit and Loss, Trial Balance) I click on options -> commodities -> and
> tick "Show Foreign Currencies" and "Show Exchange Rates".
>
> Back in v3 of gnucash, these would display with 2 decimal places (the
> same number of decimal places as Edit -> Preferences -> Numbers ->
> Decimal Places).
>
> Now in v4.2 of gnucash, these Exchange Rates display with 4 decimal
> places with the last two places zero so the number displayed is still
> effectively rounded to 2 decimal places. But the Price Database from
> where these exchange rates are extracted holds them to 6 decimal places
> and it does seem as though the currency conversions in the report line
> items do honour the 6 decimal places exchange rates.
>
> So you could argue:
>
> -1- listing an exchange rate of $1.6300 instead of the rate actually
> used of 1.627650 is misleading
>
> or
>
> -2- wouldn't it be helpful to have a separate setting for number of
> decimal places to display exchange rates (defaulting to 4 as seems to be
> hinted at in the change from v3 to v4 of gnucash).
>
> [I know those big City types who boast of making their living on the
> fifth decimal place would probably appreciate it].
>
> Anyway, what do you think?
>
> Regards
>
> Phil
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Exchange rate of income statement report

[Christopher Lam]

Found it. Both methods are acceptable:
1) reach foreign currency converted to local according to Forex on date.
Transaction report will do this.
2) average rate is allowed under GAAP. Not doable easily unless price data
is carefully scrutinised.

https://www.accaglobal.com/us/en/technical-activities/technical-resources-search/2015/march/frs102-foreign-currency-translation.html


On Fri, 16 Oct 2020, 4:10 am Christopher Lam, 
wrote:

> As I understand, for personal tax most would offer the original currency
> income statements to the accountant; the latter would convert to local
> currency using an exchange rate from legislated sources.
>
> To achieve this using the formal reports you'd ensure there is price data
> USD/ILS on the report date corresponding to the legislated exchange rate
> rather than the daily rate. IMHO this is too complex; I'd rather the
> reports use the original currency amounts instead.
>
> On Thu, 15 Oct 2020, 8:22 pm Gal,  wrote:
>
>> Michael or Penny Novack wrote
>> > Well, this was the P&L report, one of the uses being when filing out
>> tax
>> > forms (this is a case where the name usually used for the report
>> depends
>> > on the form of the entity for which the books being kept)
>> >
>> > So  what do the tax codes of the US and Israel have to say
>> about
>> > currency conversion dates? For example, suppose you had a dollar
>> expense
>> > that was deductible on Israeli taxes. As of what date must the
>> > conversion to shekels be done. Now vice versa. How about if the two
>> > jurisdictions don't  agree? For the more general situation, consider
>> any
>> > other pair of countries.
>> >
>> > Michael D Novack
>>
>> I don't keep track of expenses for tax reports.
>> I do so purely for expense and income tracking.
>> For several years now I've used YNAB4 and implemented SSAP20 method for
>> tracking foreign currency accounts:
>> https://www.mscs.dal.ca/~selinger/accounting/tutorial.html#3
>>
>> But now I'm making the transition to GnuCash and one of the reasons was to
>> take advantage of the better multi currency support is has.
>> So I'm mainly trying to figure out how to setup the accounts, and whether
>> if
>> having expense account per currency is the right way for me.
>>
>> The thing I had in mind, in addition to what I wrote before, is that it
>> seems like a good practice to have a separation between the data and the
>> translation+reports.
>> The expense was done in USD? document it in USD, and the report system
>> should deal with the translation for you.
>> If a country has specific tax codes, but a common one, I expect that the
>> report system will provide me with that option.
>> Doing the translation during data entry means you stick with a single
>> predetermined rule/tax code that cannot be changed without modifying all
>> of
>> the transactions.
>>
>>
>>
>>
>> --
>> Sent from:
>> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Exchange rate of income statement report

[Christopher Lam]

As I understand, for personal tax most would offer the original currency
income statements to the accountant; the latter would convert to local
currency using an exchange rate from legislated sources.

To achieve this using the formal reports you'd ensure there is price data
USD/ILS on the report date corresponding to the legislated exchange rate
rather than the daily rate. IMHO this is too complex; I'd rather the
reports use the original currency amounts instead.

On Thu, 15 Oct 2020, 8:22 pm Gal,  wrote:

> Michael or Penny Novack wrote
> > Well, this was the P&L report, one of the uses being when filing out tax
> > forms (this is a case where the name usually used for the report depends
> > on the form of the entity for which the books being kept)
> >
> > So  what do the tax codes of the US and Israel have to say about
> > currency conversion dates? For example, suppose you had a dollar expense
> > that was deductible on Israeli taxes. As of what date must the
> > conversion to shekels be done. Now vice versa. How about if the two
> > jurisdictions don't  agree? For the more general situation, consider any
> > other pair of countries.
> >
> > Michael D Novack
>
> I don't keep track of expenses for tax reports.
> I do so purely for expense and income tracking.
> For several years now I've used YNAB4 and implemented SSAP20 method for
> tracking foreign currency accounts:
> https://www.mscs.dal.ca/~selinger/accounting/tutorial.html#3
>
> But now I'm making the transition to GnuCash and one of the reasons was to
> take advantage of the better multi currency support is has.
> So I'm mainly trying to figure out how to setup the accounts, and whether
> if
> having expense account per currency is the right way for me.
>
> The thing I had in mind, in addition to what I wrote before, is that it
> seems like a good practice to have a separation between the data and the
> translation+reports.
> The expense was done in USD? document it in USD, and the report system
> should deal with the translation for you.
> If a country has specific tax codes, but a common one, I expect that the
> report system will provide me with that option.
> Doing the translation during data entry means you stick with a single
> predetermined rule/tax code that cannot be changed without modifying all of
> the transactions.
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Exchange rate of income statement report

[Christopher Lam]

The only report with ability to exchange currency amounts using price on
posting date is the Transaction Report.

On Thu, 15 Oct 2020, 5:40 pm Gal Bar Mashiah,  wrote:

> I have expense accounts in several currencies, for example:
> Expenses:Food:USD
> Expenses:Food:ILS
>
> I run the income statement report for 2013 for example, select only
> Expenses:Food account (and its sub accounts) and select ILS as the currency
> report.
> The Price source chosen is Nearest in time.
>
> While I expected each Expenses:Food:USD transaction to be translated to ILS
> based on the transaction date exchange rate (the price database is
> populated with that data), what I actually observed is that all
> Expenses:Food:USD transactions are translated to ILS based only on a single
> fixed exchange rate, in this case - the exchange rate as of the report end
> date 31/12/2013.
>
> Is this the expected behavior?
> Is there a way to achieve the behavior I was expecting?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Issues with Balance Sheet report in 4.2

[Christopher Lam]

The old venerable balance sheet (and many "classic" reports) are not
exactly well behaved when a subset of accounts, especially of varying
levels, is selected for reporting. The experimental and eguile reports may
behave better. Unless someone steps up and decodes the classic reports,
this is likely to remain unresolved for a long time.

On Tue, 13 Oct 2020, 9:44 am David Carlson, 
wrote:

> So the fundamental issue seems to be that the report is not showing the
> full account tree above the accounts that contain the desired data in the
> same tree structure that you see in the Chart of Accounts.
>
> Is this the first time to use this report for this purpose, or is it a case
> that has changed from previous behavior, say in GnuCash release 3.x or
> earlier?
>
> You mentioned that if you select all accounts, the report is correct, but
> when you try to omit unnecessary lines, some necessary lines disappear and
> others seem to change level.
>
> A brute force work-around might consist of producing a complete report and
> using a spreadsheet to delete unnecessary lines.
>
> Also, as Frank asked in the previous email, did you select the Owner
> accounts when selecting accounts?  Also, are those accounts possibly marked
> hidden or placeholder?
>
> All of these questions are partly attempts to eliminate the possibility
> that there truly is a bug in the report design, or, conversely, to identify
> where a bug might lie.
>
> --
> 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] Issues with Balance Sheet report in 4.2

[Christopher Lam]

Always easier to post screenshots, with appropriately placed smudges. Also
post screenshots of the report options.

On Sun, 11 Oct 2020 at 23:15, mike823  wrote:

> I definitely do not understand what you are trying to say.
>
> - Are talking about  "Balance Sheet (eguile)" report or  "Balance Sheet"?
> - You are using "nesting" term in context of report options but there is no
> such option.
> - "CoA" is an acronim for what ?
>
> The issues I have mentioned are present on default report options,
> absolutely nothing customized.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Data Entry Overload - Create Bill + Post Bill + Pay Bill vs just Pay Bill?

[Christopher Lam]

I'd think that invoices are much more useful than bills. Because I send
invoices and want to track being paid; as a customer I send (usually future
dated) payments on time (or dispute them) and don't need to remind myself.

On Sat, 10 Oct 2020, 7:20 am Fran_3 via gnucash-user, <
gnucash-user@gnucash.org> wrote:

>  So Greg, you don't post any Bills to Accounts Payable? Electric & Utility
> bills. Rent or whatever?
> You just post the payments... is that what you are saying?
> Thanks
>
> On Friday, October 9, 2020, 12:15:25 PM EDT, Greg Feneis <
> mfen...@gmail.com> wrote:
>
>  I don't use this process at all. Everything my business buys how on a
> credit card. 🤷
>
> Kind regards, Greg Feneis
> (Pixel 3)
>
>
> On Fri, Oct 9, 2020, 08:41 Fran_3 via gnucash-user <
> gnucash-user@gnucash.org>
> wrote:
>
> > Posting Bills allows you to keep track of AP and provides data to the
> > Bills Due Reminder...
> > However some routine expenses may just get paid without going through the
> > steps of creating and posting and paying a bill.
> > For a small venture posting bills can require a lot of keyboard time...
> > even duplicating a bill requires a number of steps, data entry, and
> clicks
> > and can eat up time if you have a bunch of them to do...
> > Example, we have a couple of vendor from which we get 50+ to 100+ charges
> > per year. They each are on auto pay and are mostly for the same amount
> per
> > charge... but each charge is for a different thing... so descriptions,
> due
> > dates, etc are different for each item.
> > (You can think of these as if they were an annual listing or service
> > fee... one for each item.)
> > I got reminded of this recently when we made an effort to enter/create
> > Bills for the 100+ charges that were going to occur for Vendor-A over the
> > next 12 months... again, the big corporate vendor does not supply a
> monthly
> > Bill listing all charges for that month... the item fee comes up and gets
> > auto paid... so 100+ transactions per year for that one vendor.
> >
> > It is a lot less work to just enter each payment into the system as
> > opposed to first creating a bill then posting a bill and then paying the
> > bill.
> > How do you all choose which things to create Bills for and which things
> > just Pay?
> > Thanks.
> >
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account view question

[Christopher Lam]

Easiest process would be to generate a daily-resolution table, then
post-process in spreadsheet.

e.g. from Asset/Liability/Income/Expense Chart

General/Start date: start of this month
General/End date: today
General/Step size: day
Display/Show table: enabled
Run report
This generates a chart and table

File > Export > Export Report

Choose CSV (new in 4.2)

Import into spreadsheet, calculate row differences.

On Wed, 7 Oct 2020 at 22:24, Kalpesh Patel  wrote:

> Hello GNUCash subscribers -
>
>
>
> I was looking for a way to see delta change between yesterday and today in
> the Account View page. I have added columns from the drop down list such
> Present, Cleared, Reconciled, Total, etc., but I did not see anything that
> would come close to show me 'change from yesterday' type of column.
>
>
>
> If there is a way then any help that would make that column available for
> display would be welcome.
>
>
>
> Thanks.
>
>
>
> Kalpesh Patel
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Fwd: Changing report title of the General,Journal; was: Solving printer issues

[Christopher Lam]

Usually https://bugs.gnucash.org/ would be the preferred reporting
mechanism, but this one will be fixed for 4.3 onwards.

On Tue, 6 Oct 2020 at 18:37, Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> Might have gotten to actually look at the problem if had been described
> clearer.
>
> > Brilliant!  Thanks to all of you for this guidance. I never realized
> > before that ‘export’ will produce an html version.
> >
> > However — I have not yet been able to change the title of the General
> > Journal, not in the Gnucash window (clicking on ‘apply’ doesn’t work),
> > not in the Firefox browser print settings, even though I have done it
> > several times.  How can I change (actually, not change but add to, the
> > title ‘General Journal’ so that it will print on the document as
> > ‘General Journal BE 175’?  Doesn’t work in Gnucash & doesn’t work in the
> > browser with the print settings, etc. . . .
>
> Appears to be a bug. I might have checked it for myself before now had
> the problem been described as "I created a :Journal" report and tried to
> us Edit  =+>report options to change the title line. There was a box
> provided to do that BUT when I tried to apply that change, nothing
> happened.
>
> I just tried it. Does not work as it should. Users SHOULD be able to
> modify/add to this title. Remember, might be keeping several sets of
> books and nice to have the "which" in the title when exported.
>
>
> Michael D Novack
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Changing report title of the General,Journal; was: Solving printer issues

[Christopher Lam]

The General Journal was an oddball among reports for ages.

https://idioms.thefreedictionary.com/%27twas+ever+thus

On Mon, 5 Oct 2020 at 21:05, Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

> Chris, you know this part better.
>
> Anita, are you not subscribed to
> https://lists.gnucash.org/mailman/listinfo/gnucash-user? I do not see
> the mail in the archive until now.
>
> Regards
> Frank
>
>  Weitergeleitete Nachricht 
> Betreff:Re: [GNC] Solving printer issues
> Datum:  Mon, 5 Oct 2020 08:41:23 +0300
> Von:Anita Graves 
> An: David Carlson 
> Kopie (CC): Frank H. Ellenberger ,
> gnucash-user@gnucash.org 
>
>
>
> Brilliant!  Thanks to all of you for this guidance. I never realized
> before that ‘export’ will produce an html version.
>
> However — I have not yet been able to change the title of the General
> Journal, not in the Gnucash window (clicking on ‘apply’ doesn’t work),
> not in the Firefox browser print settings, even though I have done it
> several times.  How can I change (actually, not change but add to, the
> title ‘General Journal’ so that it will print on the document as
> ‘General Journal BE 175’?  Doesn’t work in Gnucash & doesn’t work in the
> browser with the print settings, etc. . . .
>
> Anita
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Invoice Payment

[Christopher Lam]

This one's slightly different because both payments must be used to clear
invoices from 2 separate entities. The best method here is to use a
suspense account.

On Mon, 5 Oct 2020, 4:28 pm Liz,  wrote:

> On Mon, 5 Oct 2020 09:12:07 +0200
> Oliver Arnold  wrote:
>
> > I have a customer with two different business entities. Every month,
> > I write an invoice to each entity. Unfortunately, I receive ONE
> > payment for both invoices on my bank account. My question is: How to
> > I process this invoice payments? Since I use an online account to
> > sync my bank, I have the issue, that I can not really split the
> > booking.
> >
> > Thanks for ideas
>
> This is the same problem as one where of a charge of 100, 80 was paid
> to the vendor, and 20 went to a tax withholding account.
>
> Have a look at the varied answers to the problem.
>
> https://lists.gnucash.org/pipermail/gnucash-user/2020-October/093407.html
> https://lists.gnucash.org/pipermail/gnucash-user/2020-October/093418.html
>
> 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.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Customer Listing Report and Receivable Aging Report Error

[Christopher Lam]

Hi, there have been some changes in the reports to fix errors. It is
possible that other errors may have crept in. Please submit screenshots,
suitably anonymised, in Bugzilla.

On Sat, 3 Oct 2020, 5:31 am Bob Jenkins,  wrote:

> I recently updated from version 3.9 to 4.2. Version 4.2 seems to have an
> error in the "total" column for some customers that have made prepayments
> on both the Customer Listing Report and Receivable Aging Report. The amount
> in the "total" column does not agree with the "total due" balance on that
> customer's individual Customer Report. I did not observe this error with
> version 3.9.
>
> Is there any way to get a customer Listing Report that shows the "total
> due" amount shown on the individual Customer Report?
>
> 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] withholding tax (Liz Dodd)

[Christopher Lam]

Typo in middle section:

Therefore your *only *currently available steps is (IMHO):  process payment
as usual, for *$100 *only. This creates a regular transaction:
 - asset:bank +100
 - a/receivable -100 (to clear the invoice)

On Fri, 2 Oct 2020 at 15:26, Christopher Lam 
wrote:

> While experimenting this problem, I found it exposes a subtle
> behaviour/bug... I was hoping to do the following manual assignment: create
> a transaction with 3 splits -
>  - asset:bank +80
>  - a/receivable -100
>  - asset:WHT +20
>  then right-click the transaction, assign $80 as payment for the invoice.
> But this will assign the 100 to the invoice then 20 as overpayment to the
> same customer. This is not what we want.
>
> Therefore your *only *currently available steps is (IMHO):  process
> payment as usual, for $80 only. This creates a regular transaction:
>  - asset:bank +100
>  - a/receivable -100 (to clear the invoice)
>
> Then you will do *two* further modifications:
> 1. modify to include split to asset:WHT
>  - asset:bank +80
>  - a/receivable -100 (linked to invoice)
>  - asset:WHT +20
> 2. import OFX/QIF from the bank, and match the OFX transaction to your
> asset:bank split. Thus:
>  - asset:bank +80 (linked to OFX online_id)
>  - a/receivable -100 (linked to invoice)
>  - asset:WHT +20
>
> On Fri, 2 Oct 2020 at 04:25, Paul W via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
>>  Stan,
>>
>> I see what you are saying. Practically I think I need to process the
>> invoice payment twice, first part payment (80) to Accounts Receivable then
>> another payment (20) to Assets: WHT. But I don't seem to have this ability
>> in gnucash because when I process an invoice payment in the 'post to' box
>> only has Assets: Accounts Receivable as an option in the pull down menu.
>> Help!
>>
>> Paul
>>
>>
>> On 2020-10-01 19:14, Paul W via gnucash-user wrote:
>> > Foreign Government A keeps this money and My Government B will credit
>> this amount against my corporation tax liability.
>> >
>> > My invoice is for the full amount, £100.
>> >
>> > Usually (without WHT) when the invoice is paid the full amount is
>> > sent to my Accounts Receivable. In this case I think the way to do it
>> > is for gnucash to send £100 to Accounts Receivable then £80 will go
>> > from here to my Asset: Bank Account and £20 to Asset: WHT. How do I
>> > achieve this in gnucash?
>>
>> Just to be clear, the answer to any question like this is always, "Think
>> of GnuCash as a pen-and-ink ledger. First determine what entries you
>> need to make, to cover your own accounting and tax needs. Once you know
>> that, you can make those entries in GnuCash."
>>
>>
>> > Do you agree this is the way to do it?
>>
>>
>> I don't think so. Since you will collect 80 pounds not 100, the amount
>> in receivables should, I think, be 80 pounds not 100. The 20 pounds is
>> an asset, but it is a prepaid tax expense and not a receivable.
>>
>> Debit: Assets: Receivable from {customer} 80
>> Debit: Assets: Tax prepaid to {Foreign Government} 20
>> Credit: Income: Sales 100
>>
>> Then at the end of the year you make an adjusting entry:
>> Debit: Liabilities: Tax payable to {My Government) {total for the year}
>> Credit: Assets: Tax prepaid to {Foreign Government} {same amount}
>>
>> That lets you track the amounts invoice by invoice or by annual totals.
>> For strictly accounting purposes, that is what I would do. However, your
>> country may mandate doing it in a particular way, so you may want to get
>> local advice on that point. There's no need to bring GnuCash into that
>> discussion; just ask how debits and credits should be recorded.
>>
>> --
>> Regards,
>> Stan Brown
>> Tehachapi, CA, USA
>> https://BrownMath.com
>> https://OakRoadSystems.com
>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] withholding tax (Liz Dodd)

[Christopher Lam]

While experimenting this problem, I found it exposes a subtle
behaviour/bug... I was hoping to do the following manual assignment: create
a transaction with 3 splits -
 - asset:bank +80
 - a/receivable -100
 - asset:WHT +20
 then right-click the transaction, assign $80 as payment for the invoice.
But this will assign the 100 to the invoice then 20 as overpayment to the
same customer. This is not what we want.

Therefore your *only *currently available steps is (IMHO):  process payment
as usual, for $80 only. This creates a regular transaction:
 - asset:bank +100
 - a/receivable -100 (to clear the invoice)

Then you will do *two* further modifications:
1. modify to include split to asset:WHT
 - asset:bank +80
 - a/receivable -100 (linked to invoice)
 - asset:WHT +20
2. import OFX/QIF from the bank, and match the OFX transaction to your
asset:bank split. Thus:
 - asset:bank +80 (linked to OFX online_id)
 - a/receivable -100 (linked to invoice)
 - asset:WHT +20

On Fri, 2 Oct 2020 at 04:25, Paul W via gnucash-user <
gnucash-user@gnucash.org> wrote:

>  Stan,
>
> I see what you are saying. Practically I think I need to process the
> invoice payment twice, first part payment (80) to Accounts Receivable then
> another payment (20) to Assets: WHT. But I don't seem to have this ability
> in gnucash because when I process an invoice payment in the 'post to' box
> only has Assets: Accounts Receivable as an option in the pull down menu.
> Help!
>
> Paul
>
>
> On 2020-10-01 19:14, Paul W via gnucash-user wrote:
> > Foreign Government A keeps this money and My Government B will credit
> this amount against my corporation tax liability.
> >
> > My invoice is for the full amount, £100.
> >
> > Usually (without WHT) when the invoice is paid the full amount is
> > sent to my Accounts Receivable. In this case I think the way to do it
> > is for gnucash to send £100 to Accounts Receivable then £80 will go
> > from here to my Asset: Bank Account and £20 to Asset: WHT. How do I
> > achieve this in gnucash?
>
> Just to be clear, the answer to any question like this is always, "Think
> of GnuCash as a pen-and-ink ledger. First determine what entries you
> need to make, to cover your own accounting and tax needs. Once you know
> that, you can make those entries in GnuCash."
>
>
> > Do you agree this is the way to do it?
>
>
> I don't think so. Since you will collect 80 pounds not 100, the amount
> in receivables should, I think, be 80 pounds not 100. The 20 pounds is
> an asset, but it is a prepaid tax expense and not a receivable.
>
> Debit: Assets: Receivable from {customer} 80
> Debit: Assets: Tax prepaid to {Foreign Government} 20
> Credit: Income: Sales 100
>
> Then at the end of the year you make an adjusting entry:
> Debit: Liabilities: Tax payable to {My Government) {total for the year}
> Credit: Assets: Tax prepaid to {Foreign Government} {same amount}
>
> That lets you track the amounts invoice by invoice or by annual totals.
> For strictly accounting purposes, that is what I would do. However, your
> country may mandate doing it in a particular way, so you may want to get
> local advice on that point. There's no need to bring GnuCash into that
> discussion; just ask how debits and credits should be recorded.
>
> --
> Regards,
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> https://OakRoadSystems.com
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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 headings, can one separate the company name from the report name?

[Christopher Lam]

Ideally you'd submit changes in a PR or bugzilla so that further
architectural changes may be debated. For illustration on further work, try
this fix in html-style-info.scm: it'll sanitize most/all strings, but many
old reports will be damaged because they use html for layout:

gnucash/report/html-style-info.scm
@@ -161,7 +161,7 @@
 

 (define (gnc:default-html-string-renderer datum params)
-  datum)
+  (gnc:html-string-sanitize datum))

 (define (gnc:default-html-gnc-numeric-renderer datum params)
   (xaccPrintAmount datum (gnc-default-print-info #f)))

On Thu, 1 Oct 2020 at 08:54, Chris Green  wrote:

>
> That's exactly why I called it a hack.  :-)
>
> I've actually now dug down into the scheme files that generate the
> reports and they're not as frightening as I thought from looking at
> the documentation.  So I'll modify and customise reports by adapting
> the scheme files.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report headings, can one separate the company name from the report name?

[Christopher Lam]

Please be aware that inserting raw HTML into textual fields in datafile or
report options is a wart and will very likely be sanitized in the future.
At best, simple formatting elements e.g. multiline into  tags are
already possible in some report options.

The reason is it's not difficult to craft a data file containing html and
JavaScript and can damage the data file or the underlying file system.

On Thu, 1 Oct 2020, 12:42 am Chris Green,  wrote:

> On Mon, Sep 28, 2020 at 09:04:28PM +0100, Chris Green wrote:
> > I have just been looking at and printing some reports, the 'Company
> > Name' set in Properties is just put on the same line as the report
> > name.
> >
> > Is there any way to get the Company Name on a line by itself at the
> > top of the report?
> >
> No answers?  It seems such an obvious thing to want to do.
>
> Anyway I've found a bit of a 'hack' that does what I want.  Since the
> reports are all HTML then one can add HTML to the strings in options.
>
> I just changed the business name from "This is my business name" to
> "This is my business name" and now it appears in a line by itself
> at the top of the report.
>
> --
> 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] $0 splits in QIF imported incorrectly, flipping + and - values

[Christopher Lam]

Please file a bug, and include .qif and screenshots from Quicken to
illustrate the transaction.

On Sun, 27 Sep 2020 at 23:06, B Wooster  wrote:

> Thanks everyone, I think once I clean up my example and terminology, I'll
> file a bug.
>
> Certainly the checking account is all fine as far as total balance is
> concerned - but then importing further accounts messes up every account -
> including checking.
> That is the same even if I include both checking and savings QIF in one
> import session.
>
> Also tested just now with gnucash Version: 4.2 Build ID: 4.2+(2020-09-26)
>
> On Sun, Sep 27, 2020 at 5:21 PM Jim DeLaHunt 
> wrote:
>
> > Hello, BWooster:
> >
> > I think I may see a terminology difference, which might be interfering
> > with you making your question clear in this forum.
> >
> > On 2020-09-27 11:41, B Wooster wrote:
> > > $0 split transactions are not getting imported from QIF correctly.
> > > Non-zero transactions get imported fine.
> >
> > In GnuCash terminology, a "split" typically means a "split line" in a
> > transaction. Each transaction consists of two or more split lines, with
> > credits and debits which sum to zero. See the Tutorial and Concepts
> > Guide, 2.9.3. "Simple vs. Split Transactions",
> > . A
> > "simple transaction" is a transactions with two splits, e.g. one split
> > to a chequing account and another split to an account for insurance
> > expense, presented in the ledger of the chequing account, so that only
> > the split to the insurance expense account is displayed and the split to
> > the chequing account is implicit.  A "split transaction" is a
> > transaction with three or more splits. It cannot be fully displayed with
> > the split to the chequing account implicit.
> >
> > When I look at the QIF file example you give, it seems that the S, E,
> > and $ lines together describe one of what GnuCash would call a "split".
> > None of these sets of QIF lines have a value of zero. So your file does
> > not have what GnuCash would call a "$0 split".
> >
>
> Right, the file is actual (dummied) data from a large 15+ year Quicken QIF
> export.
> That transaction originated from a Quicken split entry.
>
> Whether the final amount to checking is 0.01 (deposit), -0.01 (withdrawal),
> or 0.00, I was expecting all three to show up similarly in gnucash.
> The first two do, the last one does not.
> The first two also work correctly  when loading further accounts - it
> matches up transactions correctly between savings and checking, etc.
>
>
> > In the transaction "PPay Check Incorrect Withdrawal from Savings", the
> > S, E, and $ lines add up to $0. This corresponds to the $0.00 in the U
> > and T lines. It appears that you are calling this a "$0 split" or "$0
> > split transaction". In GnuCash terms, I would call it a correct,
> > balanced transaction.  Note that none of the S lines mention the
> > "L[Checking]" account.
> >
> > In the transaction "PPay Check Correct Deposit to Savings", the S, E,
> > and $ lines add up to $1,200. This corresponds to the $1,200.00 in the U
> > and T lines. It appears you are calling this a "non-zero transaction".
> > In GnuCash terms, I would call it in incorrect, unbalanced transaction —
> > unless you assume an implicit entry of $1,200.00 to the "L[Checking]"
> > account. That would make it a balanced transaction.
> >
> > So, it appears that GnuCash is not importing transactions correctly from
> > the "L[Checking]" account QIF file if the S, E, and $ lines add up to
> > $0, so that the implicit entry for the host "L[Checking]" account is
> zero.
> >
> > What do you expect to see in the GnuCash register for the Checking
> > account after importing the  "PPay Check Incorrect Withdrawal from
> > Savings" transaction? It seems to me that none of the money movements in
> > this transaction affect the Checking account, so there is no reason for
> > the transaction to appear in the Checking register.
> >
>
> That is a good point. I'll have to think about it, though.
> I think it will mess up the matching phase. Quicken exports the Saving.QIF
> data showing a transfer from Checking to Savings. If the original
> transaction does not appear in the Checking account, it will again cause
> ledger to completely mess up.
> Quicken export for Savings only shows that one transfer from Checking to
> Savings, it does not show the whole transaction (Salary -> Savings, Tax,
> Checking, etc).
>
> Granted, this is a byproduct of how data was entered into quicken to keep
> all Salary events in the Checking ledger in Quicken, so when a particular
> Salary was totally transferred to other accounts, the Quicken split
> transaction shows all the transfers and 0 remainder into Checking.
>
>
> > It seems to me that such transactions should be put into a QIF file for
> > one of its related accounts. Perhaps it belong in a QIF file for the
> > "[Savings]" account, where it describes $1,400.00 coming in from
> > "Payche

Re: [GNC] How to have Transaction Report show Debit Totals (&/or Credit Totals) ?

[Christopher Lam]

The Transaction Report cannot show Debit and Credit totals separately. The
Reconciliation Report can, however, due to a prior feature request, the
date filters from the reconciled dates.

On Sat, 26 Sep 2020, 2:41 am Fran_3 via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> Is there anyway to have a Transaction Report show the total of the Debits
> column... or the Credits column... or both?
> (I thought sure I had done this before but today I stared and stared at
> the Transaction Report Tabs and didn't see it.)
> Thanks for any help.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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 balance correctly a particular transaction which involves debt?

[Christopher Lam]

I'd thought that "reimbursable expenses" would generally mean purchases
incurred in the course of running a business or service, and will be later
charged to the customer when invoicing them. Eg materials, supplies.
Slightly different from a friendly loan which is an asset IMV.

On Mon, 21 Sep 2020, 10:57 pm w...@theprescotts.com, 
wrote:

> IANAA (I am not an accountant), but I handle that situation in my personal
> books with an expense account named "Reimbursable expenses". When the money
> is spent I credit it to Reimbursables, and when the money is repaid, I
> debit it to Reimbursables.
>
> Will
>
> On 2020 Sep 21, at 09-21 09:35:39, Christopher Lam <
> christopher@gmail.com> wrote:
>
> Well you'd use the description field to describe the narrative of the
> transaction. "Bought $50 of books from Shop for friend". Later on when
> friend settles debt into your bank you'd write "recover $50 from friend".
>
> This approach would mean the widget shop shouldn't appear in your expense
> report. IMHO.
>
> On Mon, 21 Sep 2020, 10:25 pm Daniel Fishman,  wrote:
>
> > On 9/21/20 5:15 PM, Christopher Lam wrote:
> >> I wouldn't add an entry into Expenses:shop -- you didn't exactly spend
> > your
> >> money into this shop.
> >>
> >> Spending/lending money:
> >> Liability:credit card -$50
> >> Asset:Friend owes me +$50
> >>
> >> Recovering funds:
> >> Asset:Friend owes me -$50
> >> Asset:Cash or bank +$50
> >
> > It seems to me that using the
> >
> > Liability:credit card -$50
> > Asset:Friend owes me +$50
> >
> > loses a bit of information, since a credit card statement will list the
> > shop
> > as the receiver of the money. It seems to me that by omitting  the shop
> > from
> > being mentioned in any of the entries will make it more difficult to
> > correlate
> > the credit card statement with an information in gnucash.
> >
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] How to balance correctly a particular transaction which involves debt?

[Christopher Lam]

Well you'd use the description field to describe the narrative of the
transaction. "Bought $50 of books from Shop for friend". Later on when
friend settles debt into your bank you'd write "recover $50 from friend".

This approach would mean the widget shop shouldn't appear in your expense
report. IMHO.

On Mon, 21 Sep 2020, 10:25 pm Daniel Fishman,  wrote:

> On 9/21/20 5:15 PM, Christopher Lam wrote:
> > I wouldn't add an entry into Expenses:shop -- you didn't exactly spend
> your
> > money into this shop.
> >
> > Spending/lending money:
> > Liability:credit card -$50
> > Asset:Friend owes me +$50
> >
> > Recovering funds:
> > Asset:Friend owes me -$50
> > Asset:Cash or bank +$50
>
> It seems to me that using the
>
> Liability:credit card -$50
> Asset:Friend owes me +$50
>
> loses a bit of information, since a credit card statement will list the
> shop
> as the receiver of the money. It seems to me that by omitting  the shop
> from
> being mentioned in any of the entries will make it more difficult to
> correlate
> the credit card statement with an information in gnucash.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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 balance correctly a particular transaction which involves debt?

[Christopher Lam]

I wouldn't add an entry into Expenses:shop -- you didn't exactly spend your
money into this shop.

Spending/lending money:
Liability:credit card -$50
Asset:Friend owes me +$50

Recovering funds:
Asset:Friend owes me -$50
Asset:Cash or bank +$50

HTH

On Mon, 21 Sep 2020, 9:40 pm Daniel Fishman,  wrote:

> Hello,
>
> Suppose that you go with your friend to a shop, and then a friend
> remembers that he forgotten his credit card and asks you to pay
> for his merchandise. He intends to return the money later. You pay
> in the shop (for example, buy a book) using your credit card. Then
> a few days later the friend returns his debt - for example, by paying
> you cash.
>
> I want to document those facts in gnucash.
>
> Since the payment to the shop was made by the credit card, an account
> 'Expenses:' is debited, while an account 'Liability: card name>'
> is credited. I also want to make it explicit that a friend incurred
> debt due to this transaction. Therefore, it seems to me that this
> transaction
> should also contain a split which debits an account
> 'Assets:Accounts receivable:'. But which account should be
> credited to balance the transaction? Suppose that I credit some
> artificial account, like 'Equity:Balancing account' and succeed to
> balance the transaction. Then when the friend pays his debt, an account
> 'Assets:Accounts receivable:' should be credited, and
> an account 'Assets:Cash' should be debited, but what about an account
> 'Equity:Balancing account' - should it just be left as is (that is,
> not debited)? It seems a bit artificial.
>
> What is the accepted way to document such transactions?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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 stop a Transfer Funds dialogue autmatically appearing after reconciliation?

[Christopher Lam]

Try the preference setting Register / Reconciling / Automatic credit card
payment

On Mon, 21 Sep 2020, 3:12 pm Jim DeLaHunt,  wrote:

> Hello, folks:
>
> I have been catching up on reconciliation of a few credit card accounts
> this weekend. For one credit card account, when I click the "Finish"
> button to complete the reconciliation, a Transfer Funds dialogue appears
> automatically. It has the ending balance of the credit card account
> filled in, and is set to transfer from a convenient chequing account to
> the credit card account.
>
> Only this one credit card account behaves this way. For other credit
> card accounts, finishing the reconciliation does not cause a Transfer
> Funds dialogue to appear.
>
> I would like to stop the Transfer Funds dialogue from appearing for this
> one account. I can do payment myself. How do I stop it?
>
> I don't see any obvious setting in the Reconcile dialogue, the start
> reconciling dialogue, the Edit Account window, or the Gnucash
> preference. I don't see this Transfer Funds behaviour mentioned in
> either the Help or the Concepts Guide.
>
> Thanks in advance for any help,
>   —Jim DeLaHunt, Vancouver, Canada
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Need to - Mark Split as Un-reconciled - in GC 3.8

[Christopher Lam]

This freezing of reconciled splits was removed in a later release: you will
be able to modify the textual fields without necessarily resetting
reconcile status.

In the old release, if you unreconcile then you can simply reconcile again
(but you can't reconcile using old statement date, must be recent).

On Thu, 17 Sep 2020, 8:08 am Fran_3 via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> Under Liabilities I have an account named "Reimbursable"
> I want to change the Description field of each Transaction to make have
> them more uniform...
> However a few of the transactions... in the "R" column have one line/split
> set to... "n" for "not reconciled" and the other line/split set to "r" for
> "reconciled"
>
> So GC warns me when I attempt to modify the Description of that
> Transaction that I may break things as doing such will "un-reconcile" the
> split.
> What are the risk of just going ahead and changing the Transactions
> Description and ignoring the warning?
> Any other way to do this?
> Thanks for any help.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Go To Date

[Christopher Lam]

You are very welcome, and thank you :)
This fixes a 13-year old request.

On Sun, 6 Sep 2020 at 02:59, Kim  wrote:

> The last MAINT nightly Windows version or two includes a go to date
> feature.
> This completes the second of my two most desired enhancements.
> 1. Future transactions after blank transaction Preferences menu) - already
> done
> 2. Go to date (menu item and shortcut) - now done
> The go to date command makes it very easy to navigate around a large
> multi-year GnuCash register.
> Thank you Christopher Lam.  Great work.
> Regards,
> Kim
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Asset accounts: cost, or value?

[Christopher Lam]

I can illustrate an example where costs etc are derived from my book.

When I purchase a house at $100,000, using a $20,000 deposit and $83,000
mortgage. Purchase costs are $3,000 - includes insurance, buyer's agent
fees etc.

The Balance line describes Asset:Settlement Running Balance.

Deposit
Asset:Settlement +20,000
Asset:Bank -20,000
Balance 20,000

Mortgage drawn
Asset:Settlement +83,000
Liability:Mortgage -83,000
Balance 103,000

House Purchase
Asset:Settlement -100,000
Asset:Fixed:House +100,000
Balance 3,000

Purchase Costs
Asset:Settlement -3,000
Expense:Stamp Duty 1,000
Expense:Buyer's Agent 1,000
Expense:Title Insurance 500
Expense:Building Insurance 500
Balance = 0

I chose to input each component as a separate transaction because they had
different dates (e.g. deposit sent before exchange of contracts).
Alternatively they could all be written as a multi-split transaction.
Selling will be a similar setup.

On Wed, 2 Sep 2020 at 15:16, Marcus Winston 
wrote:

> Well, yes, it isn't necessarily a gnucash question. But pen and ink are
> a bit cumbersome, and so I use gnucash.
>
> Let me illustrate, perhaps it will help to identify whether I'm
> fundamentally doing it wrong, or just have the wrong accounts.
>
> In the assets:fixed assets:house account, I have (I'm making up numbers
> to make things simple):
>
> purchase price of house: +$100,000, balance $100,000
>
> costs to purchase: +$1000, balance $101,000
>
> costs to sell: +$2000, balance $102,000
>
> capital gains: $20,000, balance $122,000
>
>
> What I'm attempting to do is see the cost or value of the house (or,
> that's what I thought it would do) in the assets:fixed assets:house
> account.  The purchase price is, of course, fine. The costs to purchase
> add to the basis, which is what I want to do in order to easily
> see/calculate (eventually) capital gains (for tax-related purposes). I
> add the selling costs before capital gains because, when I add the
> capital gains, then I get to the actual selling price of the house,
> which is convenient. It might be wrong from an accounting perspective,
> but I'm just a "regular person", not an accountant. I'm trying to figure
> out how to use GnuCash to track all this stuff.  What I see in the other
> accounts tells me I am probably doing it wrong. The "costs to purchase"
> account is an expense. But that account has a -$1000 balance, and the
> "costs to sell" account (also under Expenses) has a -$2000 balance. The
> capital gains is the only thing that's right, because that's an income
> account.
>
> The fundamental question is, should I be trying to use the assets:fixed
> assets:house account to track this stuff? What I see in there has me
> thinking that account tracks my actual costs, but when I add the capital
> gains, it appears to reflect the value of the house, not the cost.
> Hence, my original question: is the "house" account intended to track
> the value, or the cost, of the house?
>
> MW
>
>
> On 9/2/20 6:53 AM, Michael or Penny Novack wrote:
> > On 9/2/2020 8:28 AM, Marcus Winston wrote:
> >> OK, Thanks. So the "balance" in the asset account would reflect the
> >> cost of the asset, not its value. That's fine, and is what I
> >> concluded also.
> >>
> >> Next question: When I sell the house, I'm adding the costs to sell
> >> the house (title insurance, reconveyance fees, etc) to the cost of
> >> the house itself. In other words, this will increase the bottom line
> >> on the fixed asset "House" account. For two-column accounting, where
> >> does that money come from (what's the other account)? I tried using
> >> an equity account, but then I end up with a positive equity value on
> >> the house after I sell it, and that doesn't make sense (I think I
> >> should have zero equity in the house once it's sold).
> >>
> >> MW
> >
> > This isn't a gnucash question per se (you would have exactly the same
> > question were we back in the days of pen and ink on paper accounting)
> >
> > When these transactions occurred you may have entered them wrongly <<
> > BTW, maybe it is being in different jurisdictions, but you are listing
> > things like "title insurance" and "conveyance fees" as SELLER costs.
> > In my experience, it is the buyer who pays for those particular
> > things. >>
> >
> > But back to the other side of those transactions. What I suspect is
> > that you entered them incorrectly with the other side as expenses, not
> > changes to the basis.
> >
> > Michael D Novack
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> __

Re: [GNC] Unexpected change in reconcile status

[Christopher Lam]

The reconcile-status being reset when editing past transactions'
description/notes/memo was a change that was later reverted, although I
cannot find the exact release.

In latest releases, reconcile-status is reset only when editing split's
account & amount IIRC.

On Wed, 2 Sep 2020 at 05:45, John Angelico  wrote:

> Michael and Janet,
>
> I would consider this to be a logical consequence of editing a transaction
> (and potentially changing the amount).
>
> In commercial packages like Quicken/Reckon, MYOB, Xero et al, the same
> applies. Other packages don't allow you to change a completed transaction -
> you must do a correcting entry to fix some error.
>
> As long as you are aware of the behaviour, you can re-reconcile the
> transaction once you have finished editing.
>
> It's mainly a surprise later, when we forget to do that, at the time.
>
> Regards,
> John Angelico
> Melbourne Aust
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] More Fun with Lots

[Christopher Lam]

Hi Geoff, feel free to analyse the Lot Viewer report (visible with gnucash
--extra) and offer any suggestions. It was designed to assist AP/AR lot
usage, and could be augmented to assist STOCK use of lots (afaik is
optional for this).

On Wed, 26 Aug 2020 at 02:19, Geoff  wrote:

> Yes David there are some "interesting" behaviours within the Lot Viewer,
> however with patience and perseverance you should be able to master it,
> and one day you will sit back and wonder what all the fuss was about.
>
> I have successfully used Lots for all sorts of corporate actions
> including returns of capital, fractional consolidations, demergers,
> dividend reinvestments, and partial sales spanning multiple lots.  It
> can be relied upon to calculate the correct capital gains/losses on each
> lot.  One of my accounts has over 200 lots in it.  The only weakness I
> have encountered is that it doesn't include brokerage and other charges,
> and there is a workaround for this (nett pricing).
>
> Here are some tips:
> Read (and re-read) this excellent guide:
> https://codesmythe.gitbooks.io/gnucash-guide/content/en/ch_invest.html.
> The team that wrote it deserve a medal!
>
> NEVER EVER click on "Scrub Account" - unless you have a simple series of
> Buys & Sells that you are happy to treat on a FIFO basis.
>
> Start with a blank slate.  Everything the Lot Viewer does is completely
> reversible.  Delete all of the "Realized Gain/Loss" transactions it
> creates in your register, and then delete all the Lots it created by
> selecting them one at a time and hitting the Delete button in the Lot
> Viewer.
>
> Manually create a new Lot for each of your "Buy" splits:
> (1) Use the "New Lot" button
> (2) Select the newly created Lot (in the top panel)
> (3) Select the "Buy" split (in the bottom left panel)
> (4) Hit the ">>" button.
>
> Manually allocate all of your "Sell" splits to your newly created Lots:
> (1) Select the "Buy" Lot (in the top panel)
> (2) Select the correct "Sell" split(s) (in the bottom left panel)
> (4) Hit the ">>" button - this is the magic step that calculates the
> Gain/Loss and creates a corresponding "Realized Gain/Loss" transaction
> in the register.
>
> Resist the temptation to click on the "Scrub" button.
>
> Review all the "Realized Gain/Loss" transactions in the register.
> Replace the default description with some details of the Sale (eg cut
> and paste the description from the Sale transaction).
>
> DELETE the "Orphaned Gains-XXX" account and move its transactions to
> your regular Capital Gains / Losses accounts.
>
> Rinse and repeat.
>
>
> Good luck!
>
> Geoff
> =
>
> On 26/08/2020 12:44 am, David T. via gnucash-user wrote:
> > Hello,
> >
> > Having now fiddled with the Lots features some more, I have encountered
> > some issues with its implementation.
> >
> > First, if I open up the lots viewer to see what it is doing with lot
> > allocations, the interface appears to automatically recalculate the gain
> > in the entire account, and it does this silently when you simply click
> > on a given lot (e.g., to see its allocation). I discovered this issue
> > because I was attempting to clean up several accounts in which a stock
> > split had occurred at some point in the past, and for which I still had
> > active holdings. Attempting to adjust the transaction for the stock
> > split to account for an adjusted cost basis caused all gains to become
> > adjusted--even ones that had been manually entered to match my
> > institution's accounting.
> >
> > Second, I am having troubles with the Scrub feature. While manually
> > assigning a sale to a particular lot, when I clicked Scrub (not Scrub
> > Account) I found that the viewer would automagically assign subsequent
> > transactions to the lot--even though I had specifically assigned only
> > particular transactions to a lot. For example, I have one account where
> > I had two purchases (i.e., two lots), followed by a partial sale (which
> > could be assigned wholly to the first lot with remaining shares in that
> > lot), followed by a reverse split, followed by another sale. For reasons
> > that were not clear, when I assigned the first sale manually to a
> > particular lot and then clicked Scrub, the subsequent transaction for
> > the reverse split kept getting added to the lot. It appears that the
> > scrub function insists on adding all subsequent share transactions to
> > the lot. Given that there is no way to process the lot without using the
> > Scrub in one of its forms, the user is left having to either delete all
> > subsequent transactions and reconstruct the account step by step, or
> > abandon the lots altogether for that account. This leaves the user with
> > the unfortunate situation of having to remember which accounts use lots,
> > and which don't.
> >
> > I am not sure how best to proceed for my own accounts; I generally like
> > the lots features, and hope to find a way to use them even in this
> > particular use case. I welcome sug

Re: [GNC] Capital Gain Calculations on Split Stocks

[Christopher Lam]

David, I don't use stock at all myself but have a couple of suggestions.

1) lots can be made much more visible with the "lot-viewer" report which is
hidden behind the --extra flag.

2) FIFO and LIFO are handled in advanced-portfolio, and adjusted cost basis
is a difficult task documented and being discussed in
https://github.com/Gnucash/gnucash/pull/763 and bug 797796.

3) stock splits are recognised and handled by advanced portfolio. I don't
understand this report myself.


On Tue, 25 Aug 2020, 9:40 am David T. via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> Hi,
>
> In the last couple of days, I have learned TONS about how to manage
> capital gains with assorted lots in the GnuCash realm. The financial
> institution I use has algorithms that adjust my accounts to minimize tax
> implications. This results in sales against specific lots within
> GnuCash, and I've been able to match sales with specific lots and
> achieve numbers in GnuCash which match the institution's calculations.
> All good!
>
> However, I have one account with a single purchase, followed by a two
> for one split, followed by a partial sale. Using the lots in this case,
> however, yields wildly variant and incorrect results. In the attached
> image, you can see the full transaction history, along with the lots
> window indicating the assignment of the February sale to Lot 0 with a
> loss of $169.96.
>
> This happens because 7*53.29 (the original share price) = $373.03, and
> 203.07 - 373.03 = -169.96
>
> If I choose to use Lot 2 for the match, the result is $203.07 gain
> (7*0=$0 cost). This also is wrong.
>
> The correct calculation is: $203.07 - (7 * 53.29 / 2) = $16.55, which is
> what the institution is reporting. I am hesitant to adjust the gain
> value to match this amount, as I suspect that GnuCash will then report
> the account as out of balance. I have seen in the past that incorrect
> gains calculations can throw off the balance sheet, with painful
> remedies and memories. My questions here are:
>
> 1) Is there a way to have GnuCash properly track cost basis in an
> account with a stock split?
>
> 2) If I arbitrarily change the gains transaction, will subsequent
> balance sheet numbers be in balance?
>
> 3) What is the proper way to handle a stock split?
>
> TIA,
>
> David T.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recording Tax Correctly

[Christopher Lam]

As I said before

VAT:Input VAT receives only VAT on Purchases
VAT:Output VAT receives only VAT on Sales
VAT:VAT Return receives only periodic government VAT transfers

The VAT parent account does not receive any splits; but its balance
(including children accounts) will tell me, roughly, the VAT payable (or
receivable). It will reset towards zero.

On Sun, 16 Aug 2020 at 13:46, Omer Hayat  wrote:

> @Christopher Lam  I'll show this to my
> accountant.
> In the meanwhile, I tried following:
>
> Created a 'TAX' account under 'Liability' parent account. Then created 2
> sub-accounts under the TAX account, Input VAT & Output VAT respectively.
> Now, when I post the vendor bills or customer invoices, the VAT is recorded
> properly in these sub-accounts, and their main account TAX also shows a
> final figure. But, from here I'm not clear what to do. I passed an entry:
>
> DR TAX
> CR Bank
>
> with the equivalent amount. This did make the amount to '0' for the TAX,
> but the 2 sub-accounts still have the respective amounts in them. Although,
> the Liabilities parent account was also showing a correct balance, as I
> think it just picks up the amount from TAX.
>
> Not sure if this will be a correct way of doing, or maybe there are
> multiple ways to do this.
> --
> *From:* Christopher Lam 
> *Sent:* Sunday, August 16, 2020 2:00 PM
> *To:* Omer Hayat 
> *Cc:* gnucash-user@gnucash.org 
> *Subject:* Re: [GNC] Recording Tax Correctly
>
> Hi Omer, my approach is:
>
>- VAT:Input VAT - an ASSET account
>- VAT:Output VAT- a LIABILITY account
>- VAT:VAT Return - an ASSET or LIABILITY account
>
> and run the "Income & GST Statement" periodically, posting the govt
> returns as follows:
> Dr VAT:VAT Return
> Cr Bank
>
> HTH, C
>
> On Sun, 16 Aug 2020 at 07:55, Omer Hayat  wrote:
>
> Hi.
> We have a 5% VAT charged on all bills and invoices. To the government, we
> pay the difference.
> I have setup an 'Input VAT(paid to Vendor)' and 'Output VAT(received from
> Customers)' accounts under Liabilities, and set them up. These are
> recording the VAT paid & received from Bills/Invoices correctly. The Input
> VAT account has negative values, and output VAT has positive values. We are
> supposed to pay the difference of these.
> For example:
>
> VAT paid to Vendor
> (50.00)
> VAT received from Customer  75.00
> FINAL VAT PAYABLE TO GOVT   25.00
>
> Keeping the above example, I would like to pass one entry, and pay off the
> difference amount.
> Example:
> DR Final Payable to Govt
> CR Bank
> But, how can I pass the Debit entry? Should I create a 'Tax' placeholder
> account and pass it to that? But then the individual Input & Output VAT
> accounts might have a balance.
>
> Please advise.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Recording Tax Correctly

[Christopher Lam]

Hi Omer, my approach is:

   - VAT:Input VAT - an ASSET account
   - VAT:Output VAT- a LIABILITY account
   - VAT:VAT Return - an ASSET or LIABILITY account

and run the "Income & GST Statement" periodically, posting the govt returns
as follows:
Dr VAT:VAT Return
Cr Bank

HTH, C

On Sun, 16 Aug 2020 at 07:55, Omer Hayat  wrote:

> Hi.
> We have a 5% VAT charged on all bills and invoices. To the government, we
> pay the difference.
> I have setup an 'Input VAT(paid to Vendor)' and 'Output VAT(received from
> Customers)' accounts under Liabilities, and set them up. These are
> recording the VAT paid & received from Bills/Invoices correctly. The Input
> VAT account has negative values, and output VAT has positive values. We are
> supposed to pay the difference of these.
> For example:
>
> VAT paid to Vendor
> (50.00)
> VAT received from Customer  75.00
> FINAL VAT PAYABLE TO GOVT   25.00
>
> Keeping the above example, I would like to pass one entry, and pay off the
> difference amount.
> Example:
> DR Final Payable to Govt
> CR Bank
> But, how can I pass the Debit entry? Should I create a 'Tax' placeholder
> account and pass it to that? But then the individual Input & Output VAT
> accounts might have a balance.
>
> Please advise.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] envelope method, equity sub-accounts, cash vs. hybrid vs. accrual accounting

[Christopher Lam]

The issue of budgets come back from time to time. There are proposals for
shadow/virtual accounts, and also my proposal for virtual transactions;
none have gained any traction over the years.

https://lists.gnucash.org/pipermail/gnucash-devel/2018-January/041529.html

On Wed, 12 Aug 2020, 8:34 am doncram,  wrote:

> The idea of "envelope method" then is to mirror the model of budgeting and
> control done by real life envelopes holding the cash allowed to be spent in
> each budget area.  This is an inspiring model/image.  The physical model is
> very visual, very clear... each envelope of cash is a continuous visible
> indicator of how much more can be spent in that category.  It is alarming
> if one runs low or empty.  If overspending really does have to be done,
> then cash must be "borrowed"/transfered from another envelope/budget
> category.  In a household where one person has the envelope for groceries
> vs. another has the envelope for clothes purchases, there would be
> "transaction costs" or punishments of having to beg other person to fork
> over some of their budget.  I see the appeal of trying to make an
> accounting/budgeting system follow that.  However
>
> If implemented by putting budget amounts into separate real accounts where
> spending is controlled, say into separate debit cards where an attempt to
> overspend one will simply be denied by the debit-card device at a store,
> then that would be a pretty good implementation of the model.  To actually
> overspend one budget area would require negotiation/transaction costs to
> implement a transfer of some balance of another debit card.  In effect a
> revision to the budgets.  And actual, perhaps observable balances in each
> debit card, would constantly reflect how much budget slack there is in each
> category.  This would give the same information as a regular accounting
> system, if it was continuously updated for each new transaction, that would
> report how much expense occurred in each budget category, and continuously
> presented that with the budget amounts for each type of expense.  So budget
> slack, difference between budget vs. actual expense in each category would
> be clear.  But this multiple debit card system would not require the
> accounting transactions to be recorded continously, either manually or by
> an automated system which analyzes the apparent expense type for each
> charge coming in.  The actual accounting could be done later.
>
> A virtual implementation, say by designating that the asset of a
> checking/debit card account is to be understood as divided into a
> subaccount assets, one for each expense type (each budget category), would
> seem to mirror the envelopes model, where each separate envelope of cash is
> indeed clearly an asset.  But... for this virtual system to work, each new
> charge of any type would have to be reflected by an entry (manual or
> automatic) changing the balance of the proper subaccount.  You could
> "pretend" that you are limited in your spending by the remaining balances
> of each subaccount.   But again, this would provide the same information,
> the amount of budget slack available in each category, as a regular
> accounting system where new charges are properly charged to each expense
> type, and where there is a continuously updated report of budget vs.
> actuals.  No more and no less information, but the entries implementing
> reductions in the separate subaccounts aren't proper accounting
> transactions.   And proper accounting would have to be implemented later.
> In the regular system, the equivalent transactions are just processed as
> charges to various expense types, and accounting is done, and the same info
> is available.  Is this analysis correct?  Maybe i misunderstand, please
> advise.
>
> A further point to consider is that in real-life budget counseling courses,
> and in courses like a "Work of Art" program for artists in Minnesota, USA,
> what is taught is budgeting by expense type, and then recording the actuals
> in each expense type. I have been interested in such for many years.
> The course and its manual to improve business skills of artists has one
> session/chapter about "record keeping" covering budgets, at
> https://springboardexchange.org/workofart/ . An envelope-type system is
> not
> ever taught, AFAIK, i think because it is not better, and it is not as
> natural, as regular accounting compared to budgeting by same expense
> categories.  Which is what GnuCash and Quickbooks and other packages all
> provide, I believe.
>
> I do think the "envelope method" has great natural appeal, and deserves to
> be considered in larger discussion about how budgeting can be done.  Like
> among other budgeting methods like  "Zero-base budgeting" (and when I look
> it up, also there is "Activity-Based Budgeting", "Incremental Budgeting",
> "Value proposition budgeting", "Cash flow budgeting", which emphasize
> different things in setting budget amounts).  But if I 

Re: [GNC] GnuCash and Swedish accounting legislation

[Christopher Lam]

This is not a problem that can be solved in an open-source software.
Perhaps you're looking for a datafile archiving and notarization service?

On Sun, 9 Aug 2020 at 09:27,  wrote:

> Would like to revive this old thread since the request made by the OP is
> still valid for us Swedish users (and maybe German users according to one
> post in the thread?). I wonder if there has been some development along
> making transactions "persistent" or read-only/locked/un-changeable?
>
> In short the request was made since the Swedish accounting legislation
> requires transactions to be persistent, i.e. when entered into the ledger
> it
> shall not be possible to change it afterward (or rather, entering of the
> transaction is considered completed when it has been made persistent). To
> shortcut a long discussion about how silly this requirement is, because you
> can always change your transactions somehow by editing databases etc., we
> can postulate that it would be enough to fulfill this requirement if the
> transactions somehow was made read-only in an irreversible manner from the
> user interface. I.e. once  a transaction is made read-only, it should not
> be
> possible to change it from the UI. ( I also understand that a differently
> compiled version of gnucash could import the data files and change the
> read-only transactions, but that would be ok also since the intention is
> not
> to fully secure a system against such changes, which is more or less
> impossible, but make it difficult for the ordinary user to change
> transactions afterwards).
>
> Here is the last post in the old thread from 2016:
>
> ---
> On 2 February 2016 at 15:39, John Ralls
>  wrote:
> >
> >> On Feb 2, 2016, at 8:17 AM, Colin Law
>  wrote:
> >>
> >> On 18 January 2016 at 08:18, Draug
>  wrote:
> >>> Hi,
> >>>
> >>> For quite a while I've used GnuCash for the accounting of my company,
> but
> >>> recently I've come to question if it's legal to use GnuCash for that
> >>> purpose. According to Swedish accounting legislation, you are not
> allowed to
> >>> use accounting software that allows you to edit registered transactions
> >>> (where they use Excel as an example), which to my knowledge is quite
> easy to
> >>> do in GnuCash, even after reconcilation. Swedish accounting legislation
> >>> requires that every mistake is corrected with another transaction, and
> that
> >>> the mistake is left intact in the records.
> >>>
> >>> Is there anything that I've missed that makes it possible to use
> GnuCash
> in
> >>> accordance with Swedish law? I really want to avoid switching to some
> >>> proprietary, cloud-based accounting software that costs $12 a month to
> use.
> >>
> >> An email from Geert in a different thread has reminded me that there
> >> is already code that optionally makes reconciled transactions read
> >> only. I wonder then whether it would in fact be a fairly simple change
> >> to the code to make it so that /all/ transactions would be locked,
> >> dependent on a configuration option that could be set but not cleared.
> >>
> >
> > Yes, the locking code is already in place-or more likely, in several
> places-so it would just take a creation option in the New File Assistant to
> make a book immediately lock transactions. Like the root account currency,
> it would be unchangeable once the book is created.
> >
> > I don't think we'd want it to be a config option because that would
> require either that users who want the feature build it themselves or that
> distros and we provide multiple packages. Building is beyond the ability of
> most of our target audience, particularly on Macs and Windows, and aside
> from the distros probably not wanting to cooperate there's a good chance
> that many users would accidentally get the build they didn't want.
>
> Sloppy use of words on my part, I meant a setting rather than a build
> option, but a creation option would be even better.
>
> Colin
> ---
>
> Regards
> //Bengt
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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 u

Re: [GNC] recognition of unrealized gains

[Christopher Lam]

You may wish to read Peter Selinger's essay at
https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html

On Thu, 6 Aug 2020, 7:09 am doncram,  wrote:

> Does GnuCash recognize unrealized gains/losses of investments such as
> stocks, so that they would appear in an Income Statement for a given period
> and in a Balance Sheet for a given date?  And if so, how/where, and can one
> control the presentation?
>
> The online documentation of the Tutorial and Concepts Guide, (at
> www.gnucash.org) doesn't say.  A lot of effort seems to be devoted to the
> good purpose of developing/maintaining the automated updating of prices for
> securities, drawing from the internet.   The Investments Chapter covers
> purchases and sales and other transactions, and in 9.6.5 has an example
> "Assets Over Time" bar chart (found by selecting Reports / Assets &
> Liabilities / Asset Chart, apparently) showing the changing value of an
> investment in Amazon stock, using varying price quotes, so surely an
> updated "most recent" value is available for reporting the value of the
> Amazon investment in the Balance Sheet report for any given date, either in
> total or by basis vs. unrealized gain/loss amounts.  Also the amount of
> unrealized gain/loss achieved for any period could be computed, using the
> price database.  Chapter 11 describes manual updating of asset value for a
> valuable painting by an explicit entry recognizing unrealized gain, but
> this seems not applicable to securities.
>
> Do the B/S and IS reports reflect these?  Sorry for dumb aspect of this
> question, because I should be able to figure that out by testing an
> example.  I am guessing not because it is not described.  If the reports
> automatically do, then the documentation should report that (and I think it
> should be highlighted as a really nice feature of GnuCash not done by, say,
> Quickbooks AFAIK).  If not, can the amounts be reported, so one could at
> least manually record, by journal entry dated December 31, what is
> necessary for the B/S and IS to report correctly in total?  If it is
> automatically done, it seems to me that one would want to designate where
> each stock's unrealized gain/loss should go, e.g. into a general
> "Unrealized Gain/Loss - Taxable" or a "-Non-Taxable" account.  Or for a
> more specific account like "Unrealized Gain/Loss in Education Fund" (to
> relate this to ongoing thread titled "non-currency liabilities").
>
> The not-dumb aspect of this question is to call for a new section in
> Chapter 9 and/or Chapter 11 to cover this topic, for an individual and/or
> for a business, whether the feature is already developed within GnuCash
> 4.0, or not.
> --Don
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] 4.1 on Mac - undocumented breaking change in customized reports

[Christopher Lam]

Your changes are quite nice, but may be too obscure for general use!
- Instead of how=7 you can use GNC-HOW-RND-ROUND (ie change C's _ to
guile's -) but equally easy to use (/ num denom) directly.
- Instead of "lastInList" you can use "last" directly

v4.2 will add the _ shim, which would make it work unless you used
guile-3.0 onwards. Thanks for your report!

On Sun, 2 Aug 2020 at 22:20, Tim Quinn  wrote:

> Hi, Christopher.
>
> Thanks for the response.
>
> I do get that libraries evolve, and GC must do so with them. I’m just
> saying it would have been helpful if the GC release notes for 4.1 noted
> this change so those of us who do customize reports were not caught
> off-guard.
>
> Because revising old reports to change “_” to “G_” is so straightforward,
> speaking for myself I’m not sure the shim is worth it now that 4.1 is out
> without it.
>
> I’ve attached the modified .scm file and also included a diff.
>
> Here’s what the customizations do. My wife charges clients by the hour,
> and offers a discounted rate if they prepay for multiple hours. The
> customized report:
>
> -  identifies the most recent customer invoice (skipping credit memos),
> -  extracts the hourly rate from the last line in the invoice,
> -  calculates the number of prepaid hours remaining by dividing by any
> remaining credit by that rate, and
> -  includes that as an addition line in the summary section of the report.
>
> As I mentioned earlier, I feel as if I have learned just enough to
> accomplish what I wanted. There might be better or more efficient ways to
> accomplish this and I’d welcome any suggestions for improvement.
>
> - Tim
>
>
>
>
> On Aug 2, 2020, at 9:32 AM, Christopher Lam 
> wrote:
>
> Hello
> Glad you managed to make your report work. The _ could not be used anymore
> because in guile-3.0 it is a reserved symbol. Many modern Linux distros had
> moved to guile-3.0 necessitating this change. This change is not limited to
> experimental reports; all custom reports using _ were similarly affected.
> If you're willing to share your customised owner-report.scm we can
> certainly add new features. If possible we'll add a guile-2.2 specific shim
> to pass _ through (and encourage its change to G_).
> C
>
> On Sun, 2 Aug 2020 at 13:50, Tim Quinn  wrote:
>
>>
>> When 4.0 arrived I was intrigued by the experimental
>> new-owner-report.scm. I had customized the regular owner-report.scm several
>> releases ago, and forward-ported my changes to create a customized
>> new-owner-report.scm that I had working fine with 4.0.
>>
>> I’ve just installed 4.1 and I saw errors when Gnucash tried to load the
>> report.
>>
>> Comparing that report’s source in 4.0 vs. that in 4.1, I see that uses of
>> “(_” have become “(G_”. I made those corresponding changes in my customized
>> copy and now it seems to be working with 4.1.
>>
>> Now, I understand that experimental reports are just that — experimental
>> — and not guaranteed to work in a future release. But this same change was
>> made in the non-experimental owner-report.scm from 4.0 to 4.1 (and, I
>> assume, other reports — I have not checked).
>>
>> I also freely admit that I’ve customized reports by learning just barely
>> enough about reporting to accomplish what I need, not by mastering all of
>> the reporting infrastructure. So maybe this is something that would be
>> obvious to people with a more thorough understanding of all that.
>>
>> Still, I think anyone who has customized reports will run into this and I
>> was a little surprised seeing a breaking change in a dot release and no
>> release note about it.
>>
>> If there *was* something in the release notes that I’ve missed, I
>> apologize and please point me to it.
>>
>> Thanks.
>>
>> - Tim
>>
>>
>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] 4.1 on Mac - undocumented breaking change in customized reports

[Christopher Lam]

Hello
Glad you managed to make your report work. The _ could not be used anymore
because in guile-3.0 it is a reserved symbol. Many modern Linux distros had
moved to guile-3.0 necessitating this change. This change is not limited to
experimental reports; all custom reports using _ were similarly affected.
If you're willing to share your customised owner-report.scm we can
certainly add new features. If possible we'll add a guile-2.2 specific shim
to pass _ through (and encourage its change to G_).
C

On Sun, 2 Aug 2020 at 13:50, Tim Quinn  wrote:

>
> When 4.0 arrived I was intrigued by the experimental new-owner-report.scm.
> I had customized the regular owner-report.scm several releases ago, and
> forward-ported my changes to create a customized new-owner-report.scm that
> I had working fine with 4.0.
>
> I’ve just installed 4.1 and I saw errors when Gnucash tried to load the
> report.
>
> Comparing that report’s source in 4.0 vs. that in 4.1, I see that uses of
> “(_” have become “(G_”. I made those corresponding changes in my customized
> copy and now it seems to be working with 4.1.
>
> Now, I understand that experimental reports are just that — experimental —
> and not guaranteed to work in a future release. But this same change was
> made in the non-experimental owner-report.scm from 4.0 to 4.1 (and, I
> assume, other reports — I have not checked).
>
> I also freely admit that I’ve customized reports by learning just barely
> enough about reporting to accomplish what I need, not by mastering all of
> the reporting infrastructure. So maybe this is something that would be
> obvious to people with a more thorough understanding of all that.
>
> Still, I think anyone who has customized reports will run into this and I
> was a little surprised seeing a breaking change in a dot release and no
> release note about it.
>
> If there *was* something in the release notes that I’ve missed, I
> apologize and please point me to it.
>
> Thanks.
>
> - Tim
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

[Christopher Lam]

On Mon, 27 Jul 2020 at 18:52, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> 2. Statement of Cash Flows
>
> I don't recall if this was heavily discussed in a thread or bug report
> (I think a bug report, maybe both) but I recall looking over this last
> year when trying to help a user with the current Cash Flow report.
>
> Indeed it isn't anything at all like a 'Statement of Cash Flows'.
>
> I theorized that it *might* be possible to get close if the Options >
> Accounts section were divided into 3, one for each of the three parts of
> the standard report form. John noted it is too difficult for GnuCash to
> know what accounts belong in each section, so like with other such
> questions for other reports (even this one as it is now), let the user
> select them.
>

Anyone interested in the difficulties in a *formal* 'Statement of Cash
Flow' for formal accounting must first read through
https://bugs.gnucash.org/show_bug.cgi?id=797093 and
https://bugs.gnucash.org/show_bug.cgi?id=722140. Summary: it's *difficult*.
Anyone interested in a *consumer-grade* 'cash flow' for entertainment
purposes report can preview https://github.com/Gnucash/gnucash/pull/759,
which won't be ready until 5.0 at least :)
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Import Transaction Matcher issue in v4

[Christopher Lam]

As I understand the ofx spec*, the fitid should be an invariant for the
bank and account. By any chance do you have older qfx files to compare?

* https://www.ofx.net/downloads.html

On Tue, 28 Jul 2020, 4:34 am Fross, Michael,  wrote:

> Thanks Jean / John for your thoughts.  There is a register entry that
> matches, IMHO, very closely.   I increased the Match Display Threshold from
> 1 to 3, and then to 6 (which appears to be the highest value allowed.)
> Every transaction from the import says "Match Missing."
>
> Digging around a bit, for the transaction in question, the QFX file
> contains the FITID of 202007210003:
>
> 
> CREDIT
> 2020072112
> 54.00
> 202007210003
> ACH Electronic Credit
> Expenses
> 
>
> My GNUCash file contains, for the same transaction has the online id being
> 202007210002
> 
>   
> online_id
> 202007210002
>   
>
> The online_ID is ...002 instead of ...003.  Changing the QFX file to match
> the online_id value seemed to work.  Now my question is why would this be
> different for *lots* of transactions.  Everything worked normally in v3,
> but this would not have changed as part of the release.  I'll check a few
> more problem transactions and see if I can detect a pattern.  Perhaps
> Citibank is paying games
>
> Michael
>
> On Sun, Jul 26, 2020 at 4:57 PM jean laroche  wrote:
>
> > To get a match you have to have a transaction in the register that's
> > sufficiently similar to the one you're importing, and that has not been
> > imported/matched before.
> > In your case, it could be one of these reasons (I can't see the image):
> > - There's no matching transaction in your register (no existing
> > transaction has amount close, and a date close to the imported one)
> > - There's a matching transaction but it's already been matched to an
> > imported transaction at some point so it's not available to be matched
> > to the new imported one.
> > - There's a matching transaction that's available, but the match score
> > is below the threshold that allows the transaction to be shown as a
> > potential match. Too large a date mismatch can cause that.
> >
> > Can you check whether you're in one of these 3 cases? If you're in case
> > 3, you can lower the minimum matching threshold in the preferences and
> > see if that helps.
> > J.
> >
> >
> > On 7/26/2020 2:44 PM, John Ralls wrote:
> > > If there's no matching transaction already in the account then there's
> > nothing to clear. In that case only adding or not makes sense.
> > >
> > > Regards,
> > > John Ralls
> > >
> > >
> > >> On Jul 26, 2020, at 1:56 PM, Fross, Michael 
> wrote:
> > >>
> > >> Hello all,
> > >>
> > >> I sent this earlier this month and didn't see any reply so I thought I
> > >> would try again.   Has anyone else seen these issues?  I use Citibank
> > and
> > >> perhaps it's a Citibank issue, but I did not have this problem on v2
> or
> > v3.
> > >>
> > >> Thanks all.  I appreciate the help.
> > >>
> > >> Michael
> > >>
> > >>
> > >> On Sat, Jul 4, 2020 at 9:48 AM Fross, Michael 
> > wrote:
> > >>
> > >>> Hello all,
> > >>>
> > >>> I typically download QFX files from my banks every day or two, import
> > them
> > >>> to clear them in Gnucash.  Worked great.  However, ever since
> > upgrading to
> > >>> v4, the importer seems to have trouble matching.  Most of the
> imported
> > >>> transactions are listed in the importer as (A)dd, but when I select
> > >>> (C)lear for them it says match missing.
> > >>>
> > >>> This has occurred for several accounts.  Here is a simple credit card
> > >>> example, although for my checking account, there are dozens like
> > this.  The
> > >>> top portion shows the register with the Sprint bill cleared.  The
> date,
> > >>> amount, and name (mostly) match.
> > >>>
> > >>> [image: image.png]
> > >>>
> > >>> Not sure if there is just something wrong with my setup or not.
> > Perhaps a
> > >>> bug?  Are others experiencing this?  Any ideas to get the matcher
> > matching
> > >>> again?  Something need to get cleared out?
> > >>>
> > >>> For those of us in the US, happy Independence Day.  Thank you all for
> > your
> > >>> assistance.
> > >>>
> > >>> 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 Gman

Re: [GNC] Adjusted Trial Balance

[Christopher Lam]

Please keep replies public.

Answer: No idea.

On Wed, 22 Jul 2020, 12:27 am Ron Gill,  wrote:

> Maybe creating an Adjustment Account is not such a bad idea in that case -
> is there a quick way to temporarily remove and restore a single account?
> Exporting and deleting Adjustment account is quick, but the Import  looks
> not so good. Am I missing any tricks here?
>
> On Tue, Jul 21, 2020, 7:43 AM Christopher Lam 
> wrote:
>
>> The various options in the Trial Balance are very ill-defined. This
>> report was created in 2004 [1], with an addition of merchandising
>> businesses [2], but not actually documented anywhere. They have received
>> minor maintenance fixes only otherwise. So, it would be nice to open a
>> dialogue on what these mean exactly. Otherwise it will continue to be
>> undocumented, misunderstood, and perhaps best retired completely.
>>
>> [1] https://github.com/Gnucash/gnucash/commit/a107a9af2
>> [2] https://github.com/Gnucash/gnucash/commit/259e01d5c
>>
>>
>> On Tue, 21 Jul 2020 at 14:13, Ron Gill  wrote:
>>
>>> Trying to figure out what the best practice is for Adjustment Entries and
>>> Adjusted Trial Balance is in GnuCash.
>>>
>>> My main requirement is to be able to easily produce a (Non-Adjusted)
>>> Trial
>>> Balance and a Adjusted Trial Balance report.
>>>
>>> I was thinking of creating a temporary Adjustment Account to hold changes
>>> and I could restore/delete this account to generate the above report.
>>>
>>> Seeking help on best practice for this.
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Adjusted Trial Balance

[Christopher Lam]

The various options in the Trial Balance are very ill-defined. This report
was created in 2004 [1], with an addition of merchandising businesses [2],
but not actually documented anywhere. They have received minor maintenance
fixes only otherwise. So, it would be nice to open a dialogue on what these
mean exactly. Otherwise it will continue to be undocumented, misunderstood,
and perhaps best retired completely.

[1] https://github.com/Gnucash/gnucash/commit/a107a9af2
[2] https://github.com/Gnucash/gnucash/commit/259e01d5c


On Tue, 21 Jul 2020 at 14:13, Ron Gill  wrote:

> Trying to figure out what the best practice is for Adjustment Entries and
> Adjusted Trial Balance is in GnuCash.
>
> My main requirement is to be able to easily produce a (Non-Adjusted) Trial
> Balance and a Adjusted Trial Balance report.
>
> I was thinking of creating a temporary Adjustment Account to hold changes
> and I could restore/delete this account to generate the above report.
>
> Seeking help on best practice for this.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Command Line Report Options

[Christopher Lam]

Hi Robin

The documentation is not comprehensive yet. The export-type argument refers
to the *report-specific* export types available, rather than PDF/XLS/DOC
etc. Report-specific exports are rather sparse; currently only the
following exist:

Income and GST Statement: CSV
Tax Schedule Report & TXF Export: TXF
Tax Report & XML Export (in German only): XML

To export "Income and GST Statement" CSV, you'd need to customize the
report options, save into "Saved Report Configurations" eg. "My GST", then
run as follows. I cannot assist with the tax reports.

$ gnucash-cli --report run --name "My GST" --export-type CSV --output-file
gst.csv datafile.gnucash

outputs the following into gst.csv

"from","01/04/20"
"to","30/06/20"
"Gross Sales",220.0
"Net Sales",200.0
"Tax on Sales",20.0
"Gross Purchases",110.0
"Net Purchases",100.0
"Tax on Purchases",10.0

On Sat, 18 Jul 2020 at 02:52, Robin Chattopadhyay 
wrote:

> In the release notes and the help page, the documentation lists
> 'export-type' as an option and the example cites html as an export type
> option. Are there any other supported options? I tried 'pdf' and 'PDF' and
> neither of those worked.
>
> From the release notes:
> • A new separate executable, gnucash-cli (gnucash-cli.exe on
> Microsoft Windows) for doing command-line things like updating the prices
> in your book. gnucash-cli gains the ability to run reports from the command
> line. Specify reports to run by name or guid. It also provides an export
> format and an output file name without which it will output the report to
> stdout.
> • gnucash-cli --report run --name=[reportname/guid]
> datafile.gnucash
> • gnucash-cli --report run --name=[reportname/guid]
> --output-file=x.html datafile.gnucash
> • gnucash-cli --report run --name=[reportname/guid]
> --output-file=x.html --export-type=TYPE datafile.gnucash
>
> Thanks,
> Robin
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Budgeting > transfers to liabilities and securities purchase

[Christopher Lam]

Ok. The 3.11 release will have fixed some bugs there. Please copy to list
on replies.

On Tue, 7 Jul 2020, 7:04 pm Mark Walters,  wrote:

> Thanks Christopher,  just checked and I'm running v3.4 in debian buster.
>
> On Tue, 7 Jul. 2020, 18:07 Christopher Lam, 
> wrote:
>
>> 1. Please use the very latest gnucash 3.11 or 4.0; if there are still
>> issues please file bug in Bugzilla.
>>
>> 2. Budget for securities is error prone; currency and share exchanges are
>> complex and not proven to be reliable in budgeting module.
>>
>> On Tue, 7 Jul 2020, 3:43 pm Mark Walters, 
>> wrote:
>>
>>> Hi everyone,
>>> I am trying to use Gnucash budgeting and have 2 issues. I have searched
>>> the
>>> mailing list and google'd but had no luck.
>>>
>>> 1.Sign convention issues between budget, transactions and budget reports
>>> I am budgeting for transfers to a liability (mortgage repayment). To make
>>> the budget balance sheet reduce my liability, a positive number is
>>> entered
>>> in the budget under mortgage liability. But when I use the estimate
>>> function, the repayments are entered as negative numbers.
>>> i.e. a test repayment of $50k comes through to -$50k with the estimate
>>> function. But the budget balance sheet records an increase in the
>>> liability
>>> from $350k to $400k, this should be $350k to $300k. I though perhaps my
>>> liability should have a negative balance, but the transaction entry
>>> (actuals) currently decrease the liability as entered and as expected.
>>>
>>> 2. Budgeting for securities purchase
>>> I'd like to budget a certain dollar value transaction to buy shares (Say
>>> $1k). When I enter this in the budget. the totals in the budget sheet
>>> work
>>> as expected. But the budget balance sheet adds 1000 units to my holding,
>>> instead of the number of units. Understand that the future price is
>>> unknown
>>> but the calculation seems inconsistent (dollars in budget, but carried
>>> forward as units). If I enter units in the budget, the budget balance
>>> sheet
>>> works.. but then the budget doesn't sum to zero (because no price is
>>> applied to units)
>>> How do others enter this in a budget? Should I have another 'dollar'
>>> account to capture the value of the shares?
>>>
>>>
>>> Kind Regards,
>>> Mark Walters
>>> Email: mark.walter...@gmail.com
>>> Mob: 0404 305 661
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Budgeting > transfers to liabilities and securities purchase

[Christopher Lam]

1. Please use the very latest gnucash 3.11 or 4.0; if there are still
issues please file bug in Bugzilla.

2. Budget for securities is error prone; currency and share exchanges are
complex and not proven to be reliable in budgeting module.

On Tue, 7 Jul 2020, 3:43 pm Mark Walters,  wrote:

> Hi everyone,
> I am trying to use Gnucash budgeting and have 2 issues. I have searched the
> mailing list and google'd but had no luck.
>
> 1.Sign convention issues between budget, transactions and budget reports
> I am budgeting for transfers to a liability (mortgage repayment). To make
> the budget balance sheet reduce my liability, a positive number is entered
> in the budget under mortgage liability. But when I use the estimate
> function, the repayments are entered as negative numbers.
> i.e. a test repayment of $50k comes through to -$50k with the estimate
> function. But the budget balance sheet records an increase in the liability
> from $350k to $400k, this should be $350k to $300k. I though perhaps my
> liability should have a negative balance, but the transaction entry
> (actuals) currently decrease the liability as entered and as expected.
>
> 2. Budgeting for securities purchase
> I'd like to budget a certain dollar value transaction to buy shares (Say
> $1k). When I enter this in the budget. the totals in the budget sheet work
> as expected. But the budget balance sheet adds 1000 units to my holding,
> instead of the number of units. Understand that the future price is unknown
> but the calculation seems inconsistent (dollars in budget, but carried
> forward as units). If I enter units in the budget, the budget balance sheet
> works.. but then the budget doesn't sum to zero (because no price is
> applied to units)
> How do others enter this in a budget? Should I have another 'dollar'
> account to capture the value of the shares?
>
>
> Kind Regards,
> Mark Walters
> Email: mark.walter...@gmail.com
> Mob: 0404 305 661
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Custom invoices don't work after upgrade

[Christopher Lam]

Here you go. Seems to be a nice css template. You should submit for
inclusion ^_^

On Fri, 3 Jul 2020 at 11:24,  wrote:

> Still locked in battle with my invoice template. While testing a few
> changes I noticed they weren't being picked up - because I was editing
> the wrong file. A search revealed no less than five(!) different
> locations where I had copies of the template files:
>
>~/.local/share/gnucash/
>~/.config/gnucash/
>~/.gnucash
>/usr/share/gnucash/scm/gnucash/report/
>/usr/share/gnucash/scm/gnucash/reports/
>
> I guess at least some of these are left-overs from earlier versions.
> Perhaps I should apt-get purge and start over. Having perused the wiki
> it is my understanding that custom template files should (now) go in
> ~/.config/gnucash/, but if I put everything in there and dump the other
> duplicates I get an error "Template file "cwo-invoice.eguile.scm" can
> not be read". My template consists of the following files:
>
>cwo-invoice.eguile.scm
>cwo-invoice.scm
>cwo-invoice.css
>
> I also have a config-user.scm in ~/.config/gnucash/ which contains
> (load "~/.config/gnucash/cwo-invoice.scm"). Where do I put cwo-
> invoice.eguile.scm so that GnuCash finds 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
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
=cwo=

  Invoice 01

   Customer-GBP
   B1
   B2
   B3
   b4
   b5
   Invoice Date:  04/11/19
   Due Date:  04/11/19
   myname
   myaddress1
   myaddress2
   myaddress3

 Date   Description Net Price Tax Rate Tax Amount Total Price
   02/11/19 Income Standard   £100.00  20% £20.00 £120.00
   02/11/19 Income Reduced£100.00   5%  £5.00 £105.00
   Sub-total  £200.00  £25.00 £225.00
   11/11/19 Payment received, thank you  -£225.00
   Amount Due   £0.00

   Inv-GBP Accumulatew

   Thank you for your patronage!
   myname
   myaddress1
   myaddress2
   myaddress3
   myphone
   Company registered in the UK #
diff --git a/gnucash/report/reports/standard/cwo-invoice.scm b/gnucash/report/reports/standard/cwo-invoice.scm
index 693831897..0f14f835b 100644
--- a/gnucash/report/reports/standard/cwo-invoice.scm
+++ b/gnucash/report/reports/standard/cwo-invoice.scm
@@ -22,25 +22,22 @@
 ; - specify a different module name below (eg mycwo-invoice)
 ; - refer to it from .gnucash/config.user
 ; (see http://wiki.gnucash.org/wiki/Custom_Reports )
-(define-module (gnucash report cwo-invoice))
+(define-module (gnucash reports standard cwo-invoice))
 
 (cond-expand
   (guile-2
   (use-modules (ice-9 local-eval)))  ; for the-environment
   (else ))
 (use-modules (gnucash gnc-module))
-(use-modules (gnucash gettext))
+(use-modules (gnucash core-utils))
 
 (gnc:module-load "gnucash/report/report-system" 0)
 (gnc:module-load "gnucash/html" 0)
 (gnc:module-load "gnucash/engine" 0)
 
-(use-modules (gnucash report standard-reports))
-(use-modules (gnucash report business-reports))
+(use-modules (gnucash reports))
 
-(use-modules (gnucash report eguile-utilities))
-(use-modules (gnucash report eguile-html-utilities))
-(use-modules (gnucash report eguile-gnc))
+(use-modules (gnucash eguile))
 
 (use-modules (srfi srfi-13)) ; for extra string functions
 
@@ -53,34 +50,33 @@
   ;; depending on how complicated the tax table is.
   ;; (When called from within the eguile template, anything
   ;; (display)ed becomes part of the HTML string.)
-  (if (or (not taxable) (eq? taxtable '()))
-(display " ")
+  (cond
+   ((or (not taxable) (eq? taxtable '()))
+(display " "))
+   (else
 (let* ((amttot  (gnc:make-commodity-collector))
-   (pctot   (gnc:make-numeric-collector)) 
+   (pctot   (gnc:make-value-collector))
(entries (gncTaxTableGetEntries taxtable))
(amt?#f)  ; becomes #t if any entries are amounts
(pc? #f)) ; becomes #t if any entries are percentages
-  (for entry in entries do
-  (let ((tttype (gncTaxTableEntryGetType   entry))
-(ttamt  (gncTaxTableEntryGetAmount entry)))
-(if (equal? tttype GNC-AMT-TYPE-VALUE)
-  (begin
-(set! amt? #t)
-(amttot 'add curr ttamt))
-  (begin
-(set! pc? #t)
-(pctot 'add ttamt)
-  (if pc? (begin (display (fmtnumeric (pctot 'total #f))) (display "%")))
-  (if (and amt? pc?) (display " + ")); both - this seems unlikely in practice
-  (if amt?
-(display-comm-coll-total amttot #f))

Re: [GNC] Custom invoices don't work after upgrade

[Christopher Lam]

Going forward, it will be useful to attach your custom invoice and we can
offer better feedback.

On Fri, 3 Jul 2020, 12:53 am Geert Janssens, 
wrote:

> I'm sorry your distro pulled the rug from under you at this crucial
> moment. However if it's that
> crucial perhaps you should revert your system to a backup before the
> upgrade, do your invoice
> work and then when the pressure is off, look at upgrading again and what's
> needed to get
> your custom template compatible with gnucash 3.x.
>
> Closer to your question then - you provide little detail on your custom
> template. However
> assuming it's based on an existing invoice template, perhaps you can start
> from the newer
> version of that template and reapply only your changes ?
>
> Regards,
>
> Geert
>
> Op donderdag 2 juli 2020 18:04:37 CEST schreef lo...@clickworkorange.com:
> > On Thu, 2020-07-02 at 17:37 +0200, Frank H. Ellenberger wrote:
> > > Hi,
> > >
> > > Am 02.07.20 um 17:01 schrieb
> > > lo...@clickworkorange.com
> > >
> > > > On Thu, 2020-07-02 at 13:32 +0100,
> > > > lo...@clickworkorange.com
> > > >
> > > >  wrote:
> > > > > My custom invoice template that I've used for many years stopped
> > > > > working after upgrading to 3.4 as part of a dist-upgrade. I had
> > > > > to
> > > > > remove a few things such as
> > >
> > > also 3.4 is several years old. If you prefer to stay on a
> > > distribution
> > > shipping such old program versin, you should consider to use
> > > https://wiki.gnucash.org/wiki/Flatpak
> > > .
> > >
> > > > I have compared this with the shipped reports (e.g. taxinvoice.scm)
> > > > and
> > > > it looks correct. So, a few hours killed, no progress. Any
> > > > suggestions?
> > >
> > > Yes, you should compare the shipped reports, but of a *recent*
> > > GnuCash
> > > version 3.11 or 4.0. ISTR they got several improvements in between.
> > >
> > > Regards
> > > Frank
> >
> > Thanks Frank, but I really just need to get my invoice generated and
> > sent out. I have no problem staying with the distro version, even if
> > it's old, as long as my template works. It has bank details, address etc
> as
> > well as a few other bells & whistles such as my logo and tax reg. info -
> > all of which are important and tedious to replicate in e.g. LibreOffice
> > Writer. In fact in desperation I tried to build an earlier version of
> > GnuCash just to be able to do this, but found that my distro ships
> goffice
> > 0.10.10 while GnuCash 2.6.19 would only build with goffice >= 0.7.0 and <
> > 0.9.0. Can't be bothered to dig deeper so I'm just going to get drunk
> > instead.
> >
> >
> >
> >
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Cost Basis Report on Transaction

[Christopher Lam]

No such report exists. It'll be useful to illustrate a sample list of stock
transactions and the desired report.

On Fri, 3 Jul 2020, 6:59 am ,  wrote:

> I'm evaluating gnuCash for tracking investments.  For my taxes I need a
> report of all stock sales during the year, showing the cost basis.  Perhaps
> even a report of the lots used in a sale.  I cannot find any of these on
> Standard Reports.  Am I missing it somewhere?  Are these reports called
> something different?
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Australian System

[Christopher Lam]

GnuCash is designed to be world-neutral. Record your transactions in any
currency. There is a report "Income and GST Statement" which will summarise
your BAS for you, assuming you have recorded them correctly.

On Thu, 2 Jul 2020 at 11:00, Mike Alsop  wrote:

> You have probably been asked a thousand times, but as we entered a new
> financial year yesterday, I seriously need to look at doing my own
> books. Bookkeeping fees are now over the moon!!
>
> So, does this system comply with the Aussie GST and BAS reporting
> system for the Australian Taxation Office??
>
> Many thanks in advance for any info.
>
> Mike
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Customer Report - Account Receivable

[Christopher Lam]

On Thu, 2 Jul 2020, 12:28 am Geert Janssens, 
wrote:

> Op woensdag 1 juli 2020 18:02:35 CEST schreef Adrien Monteleone:
> In practice the most common use case for multiple AR accounts is as Frank
> pointed out: you can
> have one per currency you do business in. In that case you post invoices
> for customers in
> currency A to an AR account denominated in currency A, and invoices for
> customers in currency
> B to an AR account denominated in currency B.
>

Moreover, customer currencies are modifiable, so you may have customer A
with currency X, create invoice in currency X and post into AR account
denominated in X.

Later the customer changes currency to Y, so, future invoices will be in Y
and posted to another AR account using Y.

X = DEM or BEF and Y = EUR were a common scenario...
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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 troubleshot a "Report error"

[Christopher Lam]

Nice to hear that it's fixable. The pricedb entries have unreasonable
precision and was fixed a few months ago, but existing entries remain. This
is still a worthwhile bug to fix.

On Sun, 28 Jun 2020 at 14:43, Lipp F.  wrote:

> Hi Christopher,
>
> Your suggestion about verifying pricedb was invaluable. I cannot thank you
> enough.
>
> I was able to identify the security responsable by disabling sub-accounts,
> one by one, until I was left with only the one generation the error. I have
> checked  pricedb for that specific security and I've noticed that prices
> prior to Jul 9 are recorded fractional (as 273 + 342939880122/353546268167)
> but displayed correctly (as 273.97). So, it was enough to edit the entry
> and re-enter the correct decimal value and everything works fine.
>
> On Sat, Jun 27, 2020 at 11:37 PM Christopher Lam <
> christopher@gmail.com> wrote:
>
>> Hi Lipp
>> The usual approach is to file a bug in bugs.gnucash.org
>> Include the exact version used (3.10?)
>> Also you are using pricedb - it would be worth reviewing the pricedb
>> entries around 9th July and add this to the bug report.
>> C
>>
>> On Sat, 27 Jun 2020 at 14:28, Lipp F.  wrote:
>>
>>> Wondering if anyone can help. I am trying to run the "Net Worth
>>> Linechart"
>>> report only for brokerage accounts. It works fine form Jul 9, 2019 to
>>> date
>>> but any earlier date than Jul 9 throws the error.
>>>
>>> On Jul 9 I only have two monthly divident payments, recorded the same way
>>> as ever.
>>>
>>>
>>> Thanks.
>>>
>>>
>>> Report error
>>> > An error occurred while running the report.
>>> >   19 (eval-string "(gnc:report-run 8)" #)
>>> > In ice-9/boot-9.scm:
>>> >2312:4 18 (save-module-excursion #)
>>> > In ice-9/eval-string.scm:
>>> >  38:6 17 (read-and-eval # #:lang _)
>>> > In report.scm:
>>> > 776:4 16 (gnc:report-run _)
>>> > In c-interface.scm:
>>> > 64:23 15 (gnc:backtrace-if-exception _ . _)
>>> >  22:4 14 (gnc:call-with-error-handling _ _)
>>> > In ice-9/boot-9.scm:
>>> > 829:9 13 (catch #t #
>>> …)
>>> > In c-interface.scm:
>>> > 26:40 12 (_)
>>> > In report.scm:
>>> >780:24 11 (_)
>>> >756:25 10 (gnc:report-render-html #< type: d8b63264186b1…>
>>> …)
>>> > In net-charts.scm:
>>> >326:30  9 (net-renderer #< type: d8b63264186b11e19038001…>
>>> …)
>>> > 247:6  8 (process-datelist _ _ _)
>>> > In commodity-utilities.scm:
>>> >927:17  7 (gnc:sum-collector-commodity #
>>> …)
>>> > In srfi/srfi-1.scm:
>>> >592:29  6 (map1 (#< commodity: # …))
>>> >592:29  5 (map1 (#< commodity: # …))
>>> >592:29  4 (map1 (#< commodity: # …))
>>> >592:17  3 (map1 (#< commodity: # …))
>>> > In commodity-utilities.scm:
>>> >930:46  2 (_ #< commodity: #)
>>> >777:12  1 (gnc:exchange-by-pricedb-nearest _ #
>>> …)
>>> > In unknown file:
>>> >0 (gnc-pricedb-convert-balance-nearest-price-t64 #
>>> …)
>>> > Throw to key `numerical-overflow' with args `("/" "Numerical overflow"
>>> #f
>>> > #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] How to troubleshot a "Report error"

[Christopher Lam]

Hi Lipp
The usual approach is to file a bug in bugs.gnucash.org
Include the exact version used (3.10?)
Also you are using pricedb - it would be worth reviewing the pricedb
entries around 9th July and add this to the bug report.
C

On Sat, 27 Jun 2020 at 14:28, Lipp F.  wrote:

> Wondering if anyone can help. I am trying to run the "Net Worth Linechart"
> report only for brokerage accounts. It works fine form Jul 9, 2019 to date
> but any earlier date than Jul 9 throws the error.
>
> On Jul 9 I only have two monthly divident payments, recorded the same way
> as ever.
>
>
> Thanks.
>
>
> Report error
> > An error occurred while running the report.
> >   19 (eval-string "(gnc:report-run 8)" #)
> > In ice-9/boot-9.scm:
> >2312:4 18 (save-module-excursion #)
> > In ice-9/eval-string.scm:
> >  38:6 17 (read-and-eval # #:lang _)
> > In report.scm:
> > 776:4 16 (gnc:report-run _)
> > In c-interface.scm:
> > 64:23 15 (gnc:backtrace-if-exception _ . _)
> >  22:4 14 (gnc:call-with-error-handling _ _)
> > In ice-9/boot-9.scm:
> > 829:9 13 (catch #t # …)
> > In c-interface.scm:
> > 26:40 12 (_)
> > In report.scm:
> >780:24 11 (_)
> >756:25 10 (gnc:report-render-html #< type: d8b63264186b1…> …)
> > In net-charts.scm:
> >326:30  9 (net-renderer #< type: d8b63264186b11e19038001…> …)
> > 247:6  8 (process-datelist _ _ _)
> > In commodity-utilities.scm:
> >927:17  7 (gnc:sum-collector-commodity # …)
> > In srfi/srfi-1.scm:
> >592:29  6 (map1 (#< commodity: # …))
> >592:29  5 (map1 (#< commodity: # …))
> >592:29  4 (map1 (#< commodity: # …))
> >592:17  3 (map1 (#< commodity: # …))
> > In commodity-utilities.scm:
> >930:46  2 (_ #< commodity: #)
> >777:12  1 (gnc:exchange-by-pricedb-nearest _ # …)
> > In unknown file:
> >0 (gnc-pricedb-convert-balance-nearest-price-t64 # …)
> > Throw to key `numerical-overflow' with args `("/" "Numerical overflow" #f
> > #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] Question marks instead of currency in reports

[Christopher Lam]

The only technical difference between regular lines and total lines is that
the latter is in bold. Try checking your font for bold symbol?

On Thu, 18 Jun 2020, 1:57 pm Gio Bacareza,  wrote:

> it now shows up in the reports but the total is still a question mark. see
> screenshot below
> [image: image.png]
>
> On Thu, Jun 18, 2020 at 1:49 PM Gio Bacareza  wrote:
>
> > Hi Adrien and others,
> >
> > I checked the character viewer and Peso is confirmed to be there
> available
> > in various fonts including Apple Symbols collection. See screenshot.
> > [image: image.png]
> >
> > It is also in the Security Editor. see screenshot below
> > [image: image.png]
> >
> > So I don't know what else I need to do.
> >
> >
> >
> > On Thu, Jun 18, 2020 at 12:47 AM Adrien Monteleone <
> > adrien.montele...@lusfiber.net> wrote:
> >
> >> Your font probably doesn’t have that symbol. Check your custom CSS file
> >> and find a different font. I’d use either the Mac Character Viewer or
> Font
> >> Book to find a suitable one. It looks like that is Unicode 20B1. A
> simple
> >> search in Character Viewer for ‘peso’ brought it right up. Select the
> >> character in the search results in the middle pane, then use the
> >> bottom-right pane to click each sample to see what fonts have it. (that
> is
> >> a really bad UI/UX for this, but it is doable)
> >>
> >> Also check Tools > Security editor and make sure a symbol is displayed
> >> there. If not, you can reset it manually.
> >>
> >> Regards,
> >> Adrien
> >>
> >> > On Jun 17, 2020 w25d169, at 3:34 AM, Gio Bacareza <
> gbacar...@gmail.com>
> >> wrote:
> >> >
> >> > Why am I getting question marks instead of currency in the reports?
> >> >
> >> > Gnucash Version: 3.7
> >> > Preferences / Default Currency = PHP (Philippine Peso)
> >> >
> >> > Mac OSX Catalina
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >
> >
> > --
> > cheers,
> >
> > Gio
> >
>
>
> --
> cheers,
>
> Gio
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GnuCash 3.905 Released

[Christopher Lam]

A couple of notes:
- Balance-sheet is reverted back to the legacy report: multicolumn
balance-sheet had a few more bugs identified related to currency
conversions, so, isn't ready yet. The latter is downgraded back to
experimental submenu.
- gnucash-cli --report run --name "VAT Report" --export-type CSV
--output-file VAT.CSV, when "Income and GST Statement" is properly set up
and saved as "VAT Report", would be a convenient way to generate the VAT
figures and save as CSV. Also applicable for Australian BAS reports.

On Sun, 14 Jun 2020 at 23:21, John Ralls  wrote:

> The GnuCash development team announces GnuCash 3.905, the fourth testing
> release for what will soon be GnuCash 4.0.
>
> Changes
>
> Baseline requirements
>
> Operating Systems:
>
> • Linux: Ubuntu 18.04LTS
> • MacOS: 10.13
> • Windows: 8.1
> Software Dependencies:
>
> • C++ standard is now C++17, requires gcc 8.0 or clang 6.0.
> • Cmake 3.10
> • boost 1.67.0
> • gettext 0.19.6 for general use, 0.20 to generate gnucash.pot.
> • glib-2.0 2.56.1, gtk 3.22.30
> • googletest 1.8.0
> • ICU, any version.
> • libdbi 0.8.3
> • libxml2 2.9.4
> • swig 3.0.12 Now required for building from tarballs as well as
> from git.
> • Webkit 2.4.11 Mac & Win32, 2.14.1 Linux/BSD
> New Features
>
> The intent is to have command categories with subcommands to better enable
> a richer command line capability as illustrated with the new report
> commands list and show.
>
> • A new separate executable, gnucash-cli (gnucash-cli.exe on
> Microsoft Windows) for doing command-line things like updating the prices
> in your book. gnucash-cli gains the ability to run reports from the command
> line. Specify reports to run by name or guid. It also provides an export
> format and an output file name without which it will output the report to
> stdout.
> • gnucash-cli --report run --name=[reportname/guid]
> datafile.gnucash
> • gnucash-cli --report run --name=[reportname/guid]
> --output-file=x.html datafile.gnucash
> • gnucash-cli --report run --name=[reportname/guid]
> --output-file=x.html --export-type=TYPE datafile.gnucash
> The GUI command, gnucash responds to the same command line arguments. In
> order to provide more options its syntax (and gnucash-cli's) for quote
> retrieval is changed from --add-quotes to --quotes get.
>
> • When deleting accounts the destination accounts of moved splits
> will be checked to ensure that they have the same commodity as the source
> account. If they don't you'll get a warning and the opportunity to pick
> another account or to carry on regardless.
> • New type-ahead search added to sequential search when selecting
> an account in the register: Instead of typing the first few characters of a
> top level account, the separator, the first few characters of the next
> level account and so on you may instead type a few characters of any part
> of a full account name and the drop-list will be filtered to contain only
> matching accounts. Once you have a small enough list you can use the arrow
> keys to select the account that you want.
> • Python bindings are now localized and their strings available
> for translation.
> • The new reports introduced in the Experimental Reports menu are
> moved to the main menu and the old reports hidden; the old reports can be
> unhidden by running GnuCash from the commandline with the --extra argument.
> That will cause the old reports to appear in their regular locations on the
> menu labeled (legacy). Note that new reports use different options and
> layouts and you may need to adjust your saved report configurations.
> • A new Transaction Association dialog, available from the new
> Update Transaction Association item in the register context menu, provides
> the ability to have multiple associations for a single transaction.
> Associations may now be easily removed.
> • Allow Associations to be added to invoices. The actual
> association when present is added as a link button which is shown below the
> notes.
> • A symbol is now displayed on transactions in the register when
> they have an attachment and the selected font supports the symbol.
> • The OFX file importer can now import more than one file at a
> time.
> • A new report menu supbmenu Multicolumn contains the old
> custom-multicolumn report and a new Dashboard report containing Account
> reports for expenses and income, an income-expense chart, and an account
> summary.
> • When importing, the matcher will no longer offer to match a
> transaction to one that has already matched in a previous import, nor will
> it offer to match more than one imported transaction to a single existing
> transaction.
> • Support for UK VAT and Australian GST added to the Income-GST
> report. The reports options are

Re: [GNC] Default View: Tip

[Christopher Lam]

The full list of free-text fields available to use are:

per-Transaction: Num, Description
per-Split: Action, Memo

The book property 'Use Split Action Field For Number' will internally swap
Num & Action IIUC.

The main purpose was originally likely to mimic Quicken behaviour. Quicken
(DOS) is available to explore at https://archive.org/details/msdos_Quicken_7

The secondary purpose is to have enough text fields to store data from OFX
imports. See OFX 1.6 spec at https://www.ofx.net/downloads.html - OFX1.6
hasetc.

On Thu, 11 Jun 2020, 12:30 pm Stan Brown, 
wrote:

> Can I suggest some indication of why one might want to use the Notes
> field? Until this thread I didn't even know it existed. (And I'm still
> on 2.6.19 also. I figure I'll upgrade directly to 4.0.)
>
> --
> Regards,
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> https://OakRoadSystems.com
>
> On 2020-06-10 21:05, David Carlson wrote:
> > Here is my suggestion.  If someone wants to improve the syntax, go ahead.
> >
> > To change the register view to show the Notes field in each transaction
> > select 'View' in the menu bar and check 'Double Line'.
> >
> >
> > David CArlson
> >
> > On Wed, Jun 10, 2020 at 10:16 PM David Carlson <
> david.carlson@gmail.com>
> > wrote:
> >
> >> Is there a way to review the current tips database?  I should warn you
> >> that I  am still using release 2.6.19.
> >>
> >> David Carlson
> >>
> >> On Wed, Jun 10, 2020, 8:35 PM Frank H. Ellenberger <
> >> frank.h.ellenber...@gmail.com> wrote:
> >>
> >>> Can somebody provide a tip before the string freeze this weekend?
> >>> Frank
> >>>
> >>> Am 11.06.20 um 01:02 schrieb David Carlson:
>  Frank, you caught me flat-footed, as I have had tips turned off for
> >>> years.
>  I will need to turn it back on and watch a few of them to see how
> other
>  tips look.  It may take a few days...
> 
>  On Wed, Jun 10, 2020 at 4:33 PM Frank H. Ellenberger <
>  frank.h.ellenber...@gmail.com> wrote:
> 
> > That is easy done. Your proposal?
> > Frank
> >
> > Am 10.06.20 um 22:00 schrieb David Carlson:
> >> Maybe there could also be a comment in the program tips section.
> >
> 
> 
> >>>
> >>
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Transaction Report Filter Questions

[Christopher Lam]

Until 4.x is ready, yes you'll have to use this syntax.

On Thu, 21 May 2020, 12:19 am Fran_3 via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> Transaction Filter seems to be case sensitive as searching for "Chevron"
> will not find "CHEVRON" so you must use regx like
> [Cd][Hh][Er][Vv][Rr][On][Nn]Right?
> 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] Is there a better way enter multi-currency split transaction?

[Christopher Lam]

Bugzilla will be a better forum to discuss issues with the multicolumn P&L
report:

bugs.gnucash.org


On Mon, 18 May 2020, 7:31 am davygc,  wrote:

> Just want to share what I will do as I don't think there will be a solution
> soon.
>
> I will create a sub-account for each currency under all my income and
> expense accounts. Foreign income/expenses will be transferred to respective
> currency. At the end of each month, I will then transfer all foreign
> income/expense to home currency. This way, I can still use the memorized
> transaction, I just have to key in the amount twice and it is easier to
> spot
> the error (typo will create imbalance entry).
>
> Without converting the income/expense account to home currency, I noticed
> the annual total of the multi-column P/L report won't match the sum the
> individual months due to the fluctuation in exchange rates.
>
> Anyway, I have submitted a feature request. If memorized transaction can
> add
> some extra logic to ignore dummy split with 0 qty and treat it as a normal
> debit/credit transaction, everything will be perfect. Hope
> someone can look into it.
>
> Feature request:
>
> https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/40444765-ignore-dummy-split-in-memorized-transaction-for-pr
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Cash Flow with Split Transaction

[Christopher Lam]

Hi,
The cashflow report is not wrong and not right either.
See https://bugs.gnucash.org/show_bug.cgi?id=797093 for the full dev
understanding.
C

On Sat, 16 May 2020 at 20:45, Matthew Clay  wrote:

> Gnucash Community,
>
> I have a question about the "Cash Flow" report. When I set up a simple
> paycheck with splits for taxes and net pay, why is it that when I run
> a "Cash Flow" report on my checking account the entirety of the split
> transaction is reflected in the report?
>
> For example, for a $100 paycheck with $10 going to taxes and $90 going
> to my checking account, the "Cash Flow" report looks like:
>
> ---
> Selected Account
> * Assets
>
> Money into selected accounts comes from
> Income:Salary $100
>
> Money out of selected accounts goes to
> Expenses:Taxes $10
>
> Difference
> $90.00
> ---
>
> While the net pay ("Difference") is correct, it's not like the taxes I
> pay "flow into and out of" my checking account --- the account never
> sees anything more than the net deposit.
>
> Is it possible to set the "Cash Flow" report to only show what
> actually "flows" into and out of a selected account(s) with split
> transactions, or is it on the user to mentally keep track of this?
> Maybe there is another kind of report that can do this? Thank you for
> your time and help.
>
> Sincerely,
> Matthew Clay
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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 seems to pull wrong amount from transaction

[Christopher Lam]

The Transaction Report will convert a split amount to the nearest price if
required.

I think the OP is reporting issues with the TXF report.

On Wed, 13 May 2020 at 03:44, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> The Transaction Report doesn’t offer this option. (not sure when it was
> removed or if it was never there)
>
> But I too suspect this is the case.
>
> Regards,
> Adrien
>
> > On May 12, 2020 w20d133, at 9:44 PM, D.  wrote:
> >
> > I'd look at the price source used in the report (on the report options).
> It sounds to me like the report is converting the January shares sold at
> the February/March price.
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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] RegEx Case insensitive Search via Reports > Transaction Report > Transaction Filter ?

[Christopher Lam]

You'll need to use [Gg][Oo][Dd][Aa][Dd][Dd][Yy]

On Sat, 9 May 2020 at 16:06, Fran_3 via gnucash-user <
gnucash-user@gnucash.org> wrote:

> When using Reports > Transaction Report
> I want to use the Transaction Filter to do a case insensitive search for
> some word like, for instance ... godaddy
> I'm searching the Check Register but do not want use the Ctl-F search as
> it always returns each transaction as a split.
> I tried
> (?i)godaddy
> in the Transaction Filter field but get nothing...
> The target word may be entered into the system in many ways
> GODADDYGodaddyGoDaddyetc
> Thanks for any help.
>
>
>
>
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Import matcher shortcomings, OFX realm (at least)

[Christopher Lam]

Ok agreed. There'd need to be a mechanism to skip individual split import
as well.

On Thu, 7 May 2020, 8:17 am Derek Atkins,  wrote:

> What if there are no matches?
> Then the LHS won't be empty.
>
> -derek
> Sent using my mobile device. Please excuse any typos.
> On May 6, 2020 8:09:03 PM Christopher Lam 
> wrote:
>
> > Are you discussing qif or ofx. The main difficulty is qif code written 20
> > years ago and has not modernised.
> >
> > The multi to multi issue will always be very difficult, hence I'd
> > previously imagined a two pane register, qif/ofx on left, existing
> register
> > on right, and drag and drop to marry up the splits. A successful pairing
> > removes line on both panes out of sight. Matching is complete when the
> LHS
> > is empty.
> >
> > On Thu, 7 May 2020, 3:39 am David Reiser via gnucash-user, <
> > gnucash-user@gnucash.org> wrote:
> >
> >> Overall, yes. But this case presents a many-to-many sorting out vs. the
> >> one-to-many resolution in QIF. And none of those unique IDs exist in the
> >> gnucash file until the transactions have finished being imported.
> >> --
> >> Dave Reiser
> >> dbrei...@icloud.com
> >>
> >>
> >>
> >> > On May 6, 2020, at 2:50 PM, Jean Laroche  wrote:
> >> >
> >> > QIF is a lot worse the OFX. OFX transactions have a unique ID, which
> QIF
> >> ones don't have...
> >> >
> >> > On 5/6/20 11:48 AM, David Reiser wrote:
> >> >> Thanks, Jean.
> >> >> I think the QIF importer has some code that detects multiple possible
> >> matches and pops up a “select the right match” dialog/window. Perhaps
> that
> >> can be reworked/incorporated. I don’t use QIF too much, but I think that
> >> particular behavior gets triggered in a step a little closer to the
> final
> >> import sequence than the General Matcher window gets to when it has
> decided
> >> it has already identified matches.
> >> >> --
> >> >> Dave Reiser
> >> >> dbrei...@icloud.com
> >> >>> On May 6, 2020, at 2:16 PM, Jean Laroche  wrote:
> >> >>>
> >> >>> I have run into this issue as well! Thanks for looking into it.
> >> >>> I'll try to fix it. What should really be done here, I'm guessing is
> >> that the matcher should not match several transactions to the same one.
> >> This may not be super easy to fix, but I'll take a look.
> >> >>> Jean
> >> >>>
> >> >>> On 5/6/20 11:00 AM, David Reiser via gnucash-user wrote:
> >> >>>> Michael Fross said:
> >> >>>>> I have to keep importing the same QFX file over and over until I
> get
> >> >>>>> “nothing to import” message. If I don’t, it seems to miss
> >> transactions in
> >> >>>>> the file. Not sure about QIF, but Maybe it’s similar.
> >> >>>>>
> >> >>>>> Michael
> >> >>>> Ok, I’ll split this out into another discussion.
> >> >>>> The need for multiple attempts at importing the same ofx file to
> get
> >> all the transactions imported is probably a result of a shortcoming in
> the
> >> matcher code when multiple same-dollar-value transactions (or nearly the
> >> same if Commercial ATM fee threshold is set to anything greater than
> 0.00)
> >> appear in the ofx file. One very common cause of such cases is vending
> >> machine transactions.
> >> >>>> If you never enter any of the same-value transactions manually, and
> >> only import them, then you’ll probably be OK, because the matcher will
> >> suggest that all the transactions should be Added rather than matched.
> >> >>>> If, however, you have even one of the same-value transactions
> entered
> >> manually, and a set of 5 same-value transactions incoming in the import
> >> file, the matcher’s default behavior is to display all 5 incoming
> >> transactions as having a good candidate match. The problem is that all
> five
> >> of those incoming transactions are pointed at a single transaction in
> the
> >> gnucash file. If you blithely click OK in the Matcher window, the import
> >> process matches the first incoming transaction to the existing
> transaction.
> >> Then when the second same-value transaction gets examined, the matcher
> says
> >> “Oh, I already matc