Re: [GNC] Is there a report with transactions by date and accounts in columns?

[Christopher Lam]

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

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

> My auditor wants a transaction report showing transactions in date
> order one per line with the transaction amounts in columns according
> to account name.
>
> Is there anything in GnuCash that can do this?
>
> The closest I can find is the Income Statment (Multicolumn) in the
> Experimental Reports section.  However it's the wrong way round, I
> want dates down the page and accounts across the page.
>
> --
> Chris Green
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GST Report - not showing tax amounts

[Christopher Lam]

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

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

> Hi Gnucash Users,
>
> I'm trying to get a report that shows my last 6 months  of GST/HST amounts
> for both sales and expenses.
> I've used the GST report - the headings are correct - listing the
> customer/vendor, base sales amount, tax on sale or purchase BUT only prints
> out the sales/purchase amounts with no tax amounts???
> I'm not sure what options I need to include to show the tax amounts as well
> on the report.  I need this for my GST/HST filing. Maybe there's a better
> report??
>
> Your assistance would be appreciated.
> Thanks!
> Nora
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GST Report - not showing tax amounts - got it!!!

[Christopher Lam]

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

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

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

Re: [GNC] Missing 2nd entry

[Christopher Lam]

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

On Thu, 9 June 2022, 12:59 pm Fred Tydeman,  wrote:

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

Re: [GNC] How to reorganize the account tree

[Christopher Lam]

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

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

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

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

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

Re: [GNC] How to reorganize the account tree

[Christopher Lam]

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

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

^ clarification of unexpected sorting caused by base-36 sort:
https://bugs.gnucash.org/show_bug.cgi?id=797573#c6
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] more integrated lots features

[Christopher Lam]

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

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

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

Re: [GNC] Third party OFX/CVS providers

[Christopher Lam]

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

https://bankstatementconverter.com/

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

> My current bank (US, Hancock Whitney) unfortunately does not provide
> account data in a digital format other than monthly PDF statements for
> personal accounts. I know third-party programs, such as YNAB (ynab.com),
> can get access my bank while I can't, but I don't want the baggage that
> comes with it.
>
> Does anyone know of a third-party entity I could use just to get access to
> the raw data for my personal accounts?
>
> Thanks.
>
> -Tom
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Build From Source Near Impossible

[Christopher Lam]

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

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

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

> Aha, thanks John. I wonder how much trouble it would be for a user to
> update their compiler or if that is just a mess for the rest of the
> system. (all else being equal, which I'm sure it isn't)
>
> Regards,
> Adrien
>
> On 8/9/22 3:06 PM, John Ralls wrote:
> > Caveat: Check the dependency requirements in README.dependencies for the
> GnuCash version you're trying to build against what a particular OS release
> provides. Pay particular attention to the C++ standard level supported by
> the compiler, Boost, Cmake, and GLib. You can't build GnuCash 4.x on Ubuntu
> 14.04 or 16.04 because the compilers in those releases don't support C++17
> and that's required for GnuCash 4.x and later.
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Crash in Trial Balance report

[Christopher Lam]

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

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

> I am running Linux and GnuCash 4.11
> When I try to do a Trial Balance report, I get a crash.
> Screenshot attached.
> I assume it is due to bad data somewhere,
> but I have no idea where or what it is.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Lots report?

[Christopher Lam]

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

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

Good luck!

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

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

Re: [GNC] CSV transaction import settings

[Christopher Lam]

In release 4.12 - try Help > About

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

> David,
>
> It looks like you want the chart here:
>
> https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux
>
> 1. /home//.local/share/gnucash
> 2. /home//.local/share/gtk-3.0
> 3. /home//.config/gnucash
> 4. /home//.config/gtk-3.0
>
> One of those four directories should have the file you are looking for.
>
> Based on the expected files listed in that chart, I'd hazard that either
> #1 or #3 is the proper location.
>
> Regards,
> Adrien
>
> On 10/6/22 3:16 PM, David Carlson wrote:
> > I went through that part of the FAQ  and I got lost with locations  and
> > paths and relative paths but no hard filename to search for with my
> > filemanager. If it is there I gave up in frustration before I found it.
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] User-defined commands

[Christopher Lam]

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

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

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


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

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

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


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

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


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

Re: [GNC] Net Worth Barchart

[Christopher Lam]

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

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

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

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

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

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

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

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

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

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

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

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

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

> On Tue, 6 Dec 2022 00:57:44 -0600
> Adrien Monteleone  wrote:
>
> > Liz,
> >
> > I just ran the chart for myself and indeed, it appears your
> > Liabilities are backwards. That is, if you owe money, they should
> > have a Credit balance, but yours show as Debit balance. (The *normal*
> > balance of a Liability account is Credit, not Debit)
> >
> > What is your preference setting for Accounts > Reversed Balanced
> > Accounts?
> >
> > If it is "none" or "Income & Expense" then your Liability accounts
> > will show as negative amounts in the Accounts tab if they are a
> > Credit balance.
> >
> > If it is "Credit accounts" then they will show as positive on the CoA.
> >
> > If your balances are opposite of that, then your balances are
> > reversed. (they are 'contra balances' from what is normally expected)
> >
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] What accounts should I reconcile?

[Christopher Lam]

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

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

Later hopefully sibling pays back

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

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

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

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

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

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

[Christopher Lam]

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

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

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


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

Re: [GNC] NEw user assistance

[Christopher Lam]

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

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

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

Re: [GNC] GnuCash 4.900 Released

[Christopher Lam]

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

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

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

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

Re: [GNC] Is it reasonable to have sub-accounts under Equity:Fixed Assets?

[Christopher Lam]

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

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

My starting book could look like:

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

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

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

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

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

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

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

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

Re: [GNC] Read-only transaction

[Christopher Lam]

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

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

>Hi
>I have this odd transaction that I can't fix or delete. I'm met with
>the following error message when trying to delete it:
>This transaction is marked read-only with the comment: 'Generated from
>an invoice. Try unposting the invoice'.
>I've reviewed all invoices but I couldn't find a one with a reference
>to the transaction in question.
>Is there any way to bypass, or solve this read-only status?
>Best
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Enable Online Stock Price Updating in GnuCash

[Christopher Lam]

Hi Geoff

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

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

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


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

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

Re: [GNC] Enable Online Stock Price Updating in GnuCash

[Christopher Lam]

Isn't this "unrealised gains/losses"?

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

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

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

Re: [GNC] Inconsistent meanings of "AsOfDate"?

[Christopher Lam]

Hi,

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

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

No, Likely yes, Likely no, Yes.

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

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

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



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

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

> I'm checking out the APIs of GnuCash. In
> xaccAccountGetReconciledBalanceAsOfDate, AsOfDate seems to mean ON OR
> BEFORE the date:
>
>
> https://github.com/Gnucash/gnucash/blob/7fe78e7017b3cb397e6a2f5a63c56e1933521a68/libgnucash/engine/Account.cpp#L3572
>
> In xaccAccountGetBalanceAsOfDate, AsOfDate seems to mean BEFORE the date:
>
>
> https://github.com/Gnucash/gnucash/blob/7fe78e7017b3cb397e6a2f5a63c56e1933521a68/libgnucash/engine/Account.cpp#L3535
>
> I'm wondering whether I misunderstood something, or this is an oversight,
> or this is completely intended and has always been so?
>
> Thanks,
> Hong
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounting for GST in Australia

[Christopher Lam]

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

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

> Hi,
> I have recently started using GnuCash and am having difficulty in
> attributing GST to the GST accounts as set up in the chart of accounts. I
> have included the relevant posting accounts in the tax table area, but new
> entries aren't picking up the GST amount. What am I missing? Do you need to
> see screen shots of my setup to verify what I am experiencing?
>
> best regards
>
> Nathan Ellery
> Building designer
> Grandesign Pty Ltd 
> m: 0417 951575
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GnuCash crashes when generating Equity Statement

[Christopher Lam]

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

gnucash/reports/example/equity.scm

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

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

Re: [GNC] Accounting for GST in Australia

[Christopher Lam]

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

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

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

Re: [GNC] Accounting for GST in Australia

[Christopher Lam]

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

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

> Thanks for the wiki Chris. A lot of people use a Recipient Created Tax
> Invoice (RCTI) without Accounts Payable/Receivable. One of the
> complications is the invoice might have a whole range of different charges
> with different GST treatments. Could you extend the wiki with a simple
> example for those situations?
>
> eg https://lists.gnucash.org/pipermail/gnucash-user/2020-May/091146.html
> > With fees, levies, industry funds, different tax treatments, various
> parties
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounting for GST in Australia

[Christopher Lam]

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


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

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

Re: [GNC] Finding sales tax liability

[Christopher Lam]

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

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

> This is for a business that sells stuff and keeps track of sales tax.
> At the end of the reporting period, I need a report of the sales
> tax owed to the state.
>
> With previous versions it was easy, there was a pull-down item
> for getting a report of the sales tax but I can't remember where
> exactly it was, I think it was under Business | Vendor or
> maybe Actions? But in any event, I can't find it anywhere now,
> nor does the documentation seem to help.
>
> How do I find the sales tax accumulated during the reporting
> period? And is it in the docs anywhere?
>
> Thanks!
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finding sales tax liability

[Christopher Lam]

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

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

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

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

> Thank you, but that doesn't really work because it looks like it
> lumps sales (which requires Gross Receipts Tax) and interest on
> the bank account (which does not). Is there some way to
> differentiate this, like some way for interest and any
> other income to be separated from actual sales?
>
> It seemed to work just fine previously, was the capability
> removed for some reason?
>
> Thanks!
> -Paul Kinzelman
>
> On 7/9/2021 4:46 PM, Christopher Lam wrote:
>
> It's likely the Income and GST statement report can be used for your
> purposes.
>
> On Tue, 6 Jul 2021, 10:47 pm Paul Kinzelman,  wrote:
>
>> This is for a business that sells stuff and keeps track of sales tax.
>> At the end of the reporting period, I need a report of the sales
>> tax owed to the state.
>>
>> With previous versions it was easy, there was a pull-down item
>> for getting a report of the sales tax but I can't remember where
>> exactly it was, I think it was under Business | Vendor or
>> maybe Actions? But in any event, I can't find it anywhere now,
>> nor does the documentation seem to help.
>>
>> How do I find the sales tax accumulated during the reporting
>> period? And is it in the docs anywhere?
>>
>> Thanks!
>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] piecharts/linecharts turned blank in reports after upgrade

[Christopher Lam]

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

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

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

Re: [GNC] gnucash-cli options - accounts, dates and other settings

[Christopher Lam]

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

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

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

Re: [GNC] Redo account reconciliations

[Christopher Lam]

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

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

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

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

Re: [GNC] Redo account reconciliations

[Christopher Lam]

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

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

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

Re: [GNC] Redo account reconciliations

[Christopher Lam]

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

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

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

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

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

Re: [GNC] Report Question

[Christopher Lam]

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

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

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

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

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

Re: [GNC] Set up GnuCash to track monthly net income considering taxes and pension fund contributions

[Christopher Lam]

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

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

> Thanks for the reply Rich.
>
> My main question is: is there a way to automate these calculations in
> GNUCash or for each transaction I need to compute and input each component
> of the income by hand?
> I have read the GNUCash documentation but I was not able to figure out if
> this is possible or not.
>
> On Sun, Sep 19, 2021 at 8:32 AM Simone Gaiarin  wrote:
>
> > Hi all,
> > I need help in setting up GnuCash to achieve the following goal:
> > - Track my monthly net income (after taxes and pension fund contribution)
> >
> > Situation:
> > I give a service that I invoice per hour and the cost paid by the
> customer
> > consists of the following components:
> >
> > x: Cash payment = y + p1
> > y: Service gross cost
> > p1: 1st pension fund contribution = 0,02 * y
> >
> > On y I have to pay also:
> > t1: tax I have to pay = 0,05 * y
> > p2: 2nd pension fund contribution = 0,10 * (y - t1)
> >
> > Accounts:
> >
> > - Income
> >
> > - Bank Account
> >
> > - Tax
> > - Pension fund
> >
> > Given that I pay out of my bank account the taxes twice a year and the
> > contribution to the pension fund twice a year, the 'Income chart' report
> > does not give me a clear view of my net income over the month.
> >
> > I tried to set up a tax table where I used some equivalent coefficients
> in
> > order to automatically assign t1 to Tax account and p1, p2 to the Pension
> > fund account (rather difficult given that here the tax and pension fund
> are
> > computed in cascade), but I wonder if this is the correct strategy (the
> > Pension fund account goes negative instead of positive for example).
> >
> > What is the correct way to proceed in order to obtain a monthly net
> income
> > chart considering the taxes and pension fund contribution percent over
> each
> > customer payment?
> >
> > Thanks
> >
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Christopher Lam]

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

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


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

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

Re: [GNC] Split Transaction Confusion Again

[Christopher Lam]

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

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


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

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

Re: [GNC] Budget Report Questions

[Christopher Lam]

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

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

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

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

[Christopher Lam]

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

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

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

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

[Christopher Lam]

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

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

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

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

[Christopher Lam]

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

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

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

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

[Christopher Lam]

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

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

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

Re: [GNC] Stock transaction research

[Christopher Lam]

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

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

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

> On Sat, Nov 27, 2021 at 18:17 Geoff  wrote:
>
> > Hi Tom
> >
> > I suggest you read Chapter 9 Investments:
> > https://www.gnucash.org/docs/v4/C/gnucash-guide/invest_concepts1.html
>
> ...
>
> Thanks, Geoff, will do.
>
> Blessings,
>
> -Tom
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget Report Liability "Act" VS Liability Report "Delta"

[Christopher Lam]

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

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

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

Re: [GNC] clearing reconciled transactions

[Christopher Lam]

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

Re: [GNC] Stock data export to Portfolio Performance

[Christopher Lam]

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

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

 (Not an accountant).

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

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

Re: [GNC] Search Results

[Christopher Lam]

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

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

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

Re: [GNC] Incorrect QFX Import

[Christopher Lam]

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


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


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

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

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

   second one won't be imported.


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

   FITID as some of the transactions that were imported?

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

   that can cause a problem for GC.

   Jean


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

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

   > made no difference.

   >

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

   >

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

   >> tried to import the file.

   >>

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

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

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

   >> the months showed the deposit,

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

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

   >> description - they aren't there.

   >>

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

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

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

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

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

   >> function that would throw these transactions away.

   >>

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

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

   >> not? I see no important difference.

   >>

   >> 

   >> CREDIT

   >> 2021120112[0:GMT]

   >> 1772.79

   >> 202112010

   >> COOK COUNTY PENS PENSIONS

   >> PPD ID: 3660023021

   >> 

   >>

   >> 

   >> CREDIT

   >> 2021110112[0:GMT]

   >> 1772.79

   >> 202111010

   >> COOK COUNTY PENS PENSIONS

   >> PPD ID: 3660023021

   >> 

   >>

   > ___

   > gnucash-user mailing list

   > gnucash-user@gnucash.org

   > To update your subscription preferences or to unsubscribe:

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

   > If you are using Nabble or Gmane, please see
   https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

   > -

   > Please remember to CC this list on all your replies.

   > You can do this by using Reply-To-List or Reply-All.

   ___

   gnucash-user mailing list

   gnucash-user@gnucash.org

   To update your subscription preferences or to unsubscribe:

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

   If you are using Nabble or Gmane, please see
   https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

   -

   Please remember to CC this list on all your replies.

   You can do this by using Reply-To-List or Reply-All.

References

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

Re: [GNC] Budget calculation possible bug

[Christopher Lam]

Please file a bug report on Bugzilla?

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

> I am using the Budget routine with Expenses and Income selected, set to
> range, manual periods, with 1 selected in both cases.
> In the January ie first column only for Income, the Total does not equal
> the sum of the components in both the Budget, and Budget report. In fact,
> if I enter zero in each income component, the total stays the same.
> Regards
> Peter
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Warning account contains splits whose reconcile date is after statement date

[Christopher Lam]

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

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

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

Re: [GNC] Focus on international standards

[Christopher Lam]

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

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

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

Re: [GNC] Stock Merger

[Christopher Lam]

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

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

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

Re: [GNC] Directly posting payments

[Christopher Lam]

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

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

On Tue, 22 Feb 2022, 6:10 am ,  wrote:

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

Re: [GNC] Report - Income Statement - Layout problem

[Christopher Lam]

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

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

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

Re: [GNC] Have you abandoned gnuCash email list? U were so helpful!

[Christopher Lam]

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

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

Thank you Fran; no, the project is alive as long as there is interest in
it. The number of live bugs seems to be decreasing, hence the slow decline
in traffic. It seems the community is being very helpful, thus there's
little need to intervene.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Christopher Lam]

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

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

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

Re: [GNC] Report - Income Statement - Layout problem

[Christopher Lam]

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

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

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

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

Re: [GNC] Some questions about reports

[Christopher Lam]

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

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

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

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

Re: [GNC] Feature Request/Workaround Info: Preserve "Notes" Field?

[Christopher Lam]

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

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

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

Re: [GNC] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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 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'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 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] $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] 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] 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] 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] 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] 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.