Re: [GNC] Using the advanced portfolio report for mutual fund income

[pobox . deva]

Alister,

I had a similar problem when I recorded multiple stock buys in a single 
transaction covering over a dozen splits to account for purchases in different 
stock accounts along with its attendant brokerage and statutory levies. 
Advanced portfolio report would show incorrect brokerage amounts in that case.

The way I got around it was to create a dummy asset account (called $Cash in my 
case, but you can call it "Broker" or "Suspense” or “Staging” account, etc.). 
This is a dummy asset account that acts as a staging account - a sort of a 
bridge between fund/stock accounts and your bank account. This account is of 
simple type Asset (not Mutual Fund or Stock). And it can reside under the main 
“Investments” asset account. For example -

Assets:Investments:$Cash
Assets:Investments:Mutual Fund:Fund1
Assets:Investments:Mutual Fund:Fund2
.
.
. and so on...
Assets:Investments:Stocks:Stock1
Assets:Investments:Stocks:Stock2
.
.
. and so on...

The idea is, $Cash will always be a zero balance account after your record all 
your transactions.

With this structure in place, you can record multiple distributions from your 
fund house as if they were single distributions on each fund (as you stated in 
example 1), but instead of depositing your bank account, you would deposit your 
$Cash staging account instead. After recording your $75 distribution from fund 
1 and $25 distribution from fund 2 in the respective fund accounts, you would 
now have a balance of $100 in your $Cash (staging) account.

Now from your $Cash account, record a single transaction to move $100 from it 
to your bank account. This will bring your $Cash account back to 0.

$Cash account will not be visible if you have your settings to hide zero 
balance accounts, so you have to change that setting for you to use $Cash 
account every time.

Cheers,
Deva

> On 04-Sep-2020, at 9:30 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> Date: Fri, 4 Sep 2020 15:02:55 +1000
> From: Alister Briggs mailto:aliste...@gmail.com>>
> To: gnucash-user@gnucash.org 
> Subject: [GNC] Using the advanced portfolio report for mutual fund
>   income
> Message-ID: <03a772fd-0aac-e623-69b0-ffe51c387...@gmail.com 
> >
> Content-Type: text/plain; charset=utf-8; format=flowed
> 
> Can anybody help me work around a problem using the Advanced Portfolio 
> Report to report income on mutual funds where a single payment is made 
> for multiple funds? The Advanced Portfolio report requires atransaction 
> split to include a dummy transaction of zero value as shown below:
> 
> Scenario 1 - A single distribution payment per fund
> 
> Direct Credit CFS Distribution
> 
>   
> 
>   
> 
>   
> 
> 100
> 
>   
> 
> 100
> 
>   
> 
> Assets: Bank: CBA
> 
>   
> 
> 100
> 
>   
> 
>   
> 
>   
> 
> Income: Mutual Funds: CFS: Fund1
> 
>   
> 
>   
> 
> 100
> 
>   
> 
>   
> 
> Assets: Investments: Fund managers: CFS: Fund1
> 
>   
> 
> 0
> 
>   
> 
> 0
> 
>   
> 
>   
> 
>   
> 
>   
> 
>   
> 
> In this situation the Advanced Portfolio Report correctly reports the 
> income for Fund1 as $100.
> 
> Where more than one fund is paid the split becomes more complicated:
> 
> 
> Scenario 2 - A single distribution payment for two funds
> 
> Direct Credit CFS Distribution
> 
>   
> 
>   
> 
>   
> 
> 100
> 
>   
> 
> 100
> 
>   
> 
> Assets: Bank: CBA
> 
>   
> 
> 100
> 
>   
> 
>   
> 
>   
> 
> Income: Mutual Funds: CFS: Fund1
> 
>   
> 
>   
> 
> 75
> 
>   
> 
>   
> 
> Assets: Investments: Fund managers: CFS: Fund1
> 
>   
> 
> 0
> 
>   
> 
> 0
> 
>   
> 
>   
> 
> Income: Mutual Funds: CFS: Fund2
> 
>   
> 
>   
> 
> 25
> 
>   
> 
>   
> 
> Assets: Investments: Fund managers: CFS: Fund2
> 
>   
> 
> 0
> 
>   
> 
> 0
> 
>   
> 
> In this situation the Advanced Portfolio Report incorrectly reports the 
> income for both Fund1 and Fund2 as $100. How do I correct this so the 
> result for Fund1 is $75 and Fund2 is $25?
> 
> I am using GnuCash 4.1 on Windows 10 and fairly new user.
> 
> 
> Thank you for your efforts
> 
> Alister
> 

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

Re: [GNC] Setting up for restricted/unrestricted PCC accounts - what's a reasonable approach

[pobox . deva]

Chris,

You will find plenty of discussions on this list on restricted/unrestricted 
funds for charity, trust, etc. Much of the account setup also revolves around 
taxation in your jurisdiction, so I won’t delve into those aspects.

My comment here is restricted to your query on which account setup is the way 
to go as you stated in the post below…

Since GnuCash’s account hierarchy starts with 5 fundamental account types as 
the root accounts viz., Assets, Equity, Expenses, Income & Liabilities, you 
will find that your first model will be easy to tailor in your scheme of things.

If you try to set it up as per your second model, you will soon run into 
technical restrictions imposed by GnuCash such as certain account types cannot 
be child accounts of certain parents and so on. So a lot more struggle will be 
involved in setting that up, or in some cases, it may just not allow it at all.

Cheers,
Deva

> On 29-Aug-2020, at 3:48 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> Date: Sat, 29 Aug 2020 11:14:46 +0100
> From: Chris Green mailto:c...@isbd.net>>
> To: gnucash-user@gnucash.org 
> Subject: [GNC] Setting up for restricted/unrestricted PCC accounts -
>   what's a reasonable approach.
> Message-ID: <20200829101446.GA138604@esprimo>
> Content-Type: text/plain; charset=us-ascii
> 
> I have installed GnuCash on my xubuntu system and I've done the
> default 'business' accounts set-up as that seems closest to what a PCC
> needs.
> 
> Now presumably I need to apply some sort of restricted/unrestricted
> account types.
> 
> It would seem that the way to go would be to split 'expenses' into
> 'restricted expenses' and 'unrestricted expenses' and, similarly have
> 'restricted income' and 'unrestricted income'.  I guess these should
> be a layer below 'expenses' and 'income' so one has:-
> 
>expenses
>restricted
>church repairs
>new church furniture etc.
>unrestricted
>vicar's expenses
>CofE
>electricity bill
> 
> ... and similar for income.
> 
> Or should one have it the other way about:- 
> 
>restricted
>expenses
>   ...
>   ...
>income
>   ...
>   ...
> 
>unrestricted
>expenses
>
> 
>income
>
> 
> 
> It feels like the first is right as one can then still do overall
> expenses versus income more easily, or have I got it completely wrong
> and I shouldn't have restricted/unrestricted placeholders at all?
> 
> -- 
> 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.

Re: [GNC] Question marks instead of currency in reports

[pobox . deva]

Gio,

I had the same problem with my invoice report a while ago whereby my INR 
currency symbol was displayed as question marks. Adrien helped with some CSS 
styling code (which I had to put on the Notes tab in Embedded CSS box). After I 
put this snippet there, it all works fine now.

h1.coyname { text-align: left; }
* { font-family: Helvetica; }

You can try with a font-family name of your choice to see if that helps.

Cheers.

> On 19-Jun-2020, at 3:59 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> Date: Fri, 19 Jun 2020 18:29:38 +0800
> From: Gio Bacareza mailto:gbacar...@gmail.com>>
> To: Christopher Lam  >
> Cc: GnuCash Users mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Question marks instead of currency in reports
> Message-ID:
>>
> Content-Type: text/plain; charset="utf-8"
> 
> Thank you for the help Christopher. Yes there are bold fonts capable of
> displaying Philippine Peso but the report still displays question marks.
> See screenshot below
> 
> [image: image.png]
> 
> On Thu, Jun 18, 2020 at 2:20 PM Christopher Lam  >
> wrote:
> 
>> 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.
>>> 
>> 
> 
> -- 
> 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 informat

Re: [GNC] Australian Foreign Investments Taxation

[pobox . deva]

Ben,

I use the CSV Price Importer for loading stock/mutual fund prices every month 
(all in INR).

Though I haven’t used this in the context of currency exchange rates, I think 
it should be possible because you are essentially converting price from one 
commodity to another in both scenarios.

The CSV Price Importer works very well and it even has a Save Template option, 
which you can reuse on future imports.

Easy, peasy!

Cheers,
Deva

> On 07-Apr-2020, at 2:52 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> Message: 12
> Date: Tue, 07 Apr 2020 19:22:19 +1000
> From: Ben Stanley mailto:ben.stan...@gmail.com>>
> To: Christopher Lam  >
> Cc: GnuCash users group  >
> Subject: Re: [GNC] Australian Foreign Investments Taxation
> Message-ID:
>   <17153f294f8.27d0.e122910561de4a0ea07b2811c86c2...@gmail.com 
> >
> Content-Type: text/plain; format=flowed; charset="us-ascii"
> 
> I can get a CSV file of daily exchange rate data. Is there a way of 
> importing it into the price database?
> 
> On 7 April 2020 7:17:54 pm Christopher Lam  > wrote:
>> The only report which is capable of using closest-to-date conversion is the 
>> Transaction Report from the Income:Dividends(USD) and Income:CapGains(USD) 
>> accounts, using a Report Currency of AUD. It will choose the USD/AUD price 
>> from the price editor list closest to each transaction's posting date.
>> 
>> You'll have to ensure the price list has prices at your desired dates 
>> manually.
>> 
>> 
>> 
>> On Tue, 7 Apr 2020 at 09:13, Ben Stanley > > wrote:
>> 
>> Hello Gnucash people,
>> 
>> This question may be more suited to Gnucash developers, but lets try it
>> here first.
>> 
>> I need to perform a tax calculation in accordance with instructions from
>> the Australian Taxation Office. All foreign income, deductions and
>> foreign tax paid must be converted to Australian Dollars for tax purposes.
>> 
>> https://www.ato.gov.au/Business/International-tax-for-business/In-detail/Investing-overseas/Converting-foreign-income-to-Australian-dollars/
>>  
>> 
>> 
>> The conversion used must correspond to the transaction date.
>> 
>> In Gnucash, it would appear that the price editor could be used to enter
>> the necessary conversion data, if it were easy to see all of the dates
>> where conversions are required. However, this is tedious.
>> 
>> Far better would be to use Finance::Quote to fetch the necessary
>> conversion data for the dates it is required for. However, it seems that
>> Finance::Quote is only capable of fetching "recent" data. (The
>> documentation that I looked at seemed to be very old.)
>> 
>> http://finance-quote.sourceforge.net/documentation.html 
>> 
>> 
>> What is needed is the ability to pass a date, or a range of dates, and
>> request Finance::Quote to fetch prices for that date or date interval.
>> This would make Finance::Quote far more useful than just fetching the
>> most recent price data.
>> 
>> Is there some feature in Gnucash that I have missed that would allow me
>> to generate a report, with dividends and Capital Gains converted from
>> USD -> AUD using the currency conversion as at the transaction dates?
>> 
>> Thanks,
>> Ben Stanley.
>> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 Entry Issue with Version 3.8

[pobox . deva]

Timothy,

In the stock register, shares and amount are more important for tracking 
purposes (and tax purposes), so you need to enter only the shares and Tot Buy 
columns and GnuCash will calculate the price. Due to rounding adjustments, the 
price may be off by a little bit from your actual price, but that can be 
ignored. This way, you will have your share balance computed correctly.

Cheers.

> On 25-Mar-2020, at 11:51 PM, gnucash-user-requ...@gnucash.org wrote:
> 
> 
> Message: 2
> Date: Wed, 25 Mar 2020 13:21:17 -0500
> From: "Dr. Timothy B. Jones"  >
> To: gnucash-user@gnucash.org 
> Cc: gnucash-user@gnucash.org 
> Subject: [GNC] Stock Entry Issue with Version 3.8
> Message-ID:  >
> Content-Type: text/plain; charset="us-ascii"
> 
> Greetings:
> 
> On 12/13 I entered a stock trade on a new stock added to the database without 
> incident.  On 12/31 I upgraded to Version 3.8Windows Version.  Today I 
> have been trying to enter additional buys over the past two months and the 
> software is adding a decimal to my shares (no matter how I enter) calculating 
> the correct price, but since it changes the share decimal, it calculates the 
> wrong total and share balance.  I have tried it every possible way and no 
> matter what...the software changes the share decimal incorrectly and gives me 
> an incorrect entry.  Here is a screen shot:
> -- next part --
> A non-text attachment was scrubbed...
> Name: image1.jpeg
> Type: image/jpeg
> Size: 46442 bytes
> Desc: not available
> URL: 
>   
> >
> -- next part --
> Note...the system forced calculation is incorrect.  It was entered 10.0 
> shares at a cost of $915.  No matter which variable I leave off I get this 
> result and if I enter all three I get the error that the math is wrong, which 
> variable would I like to have calculated.  Errplease 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.

Re: [GNC] importing csv multisplit multicurrency problems

[pobox . deva]

Sorry Gio, I don’t have any experience with the import or multi-currency 
transactions in GnuCash.

I only responded to your query because you wanted a better way to load a price 
database rather than entering them manually.

Cheers.

> On 11-Mar-2020, at 10:32 AM, Gio Bacareza  wrote:
> 
> Hi Pobox.Deva,
> 
> Thank you for the suggestion. I'll try that out. However my problem, I think 
> though I may be wrong, is not the price database but the importing 
> multicurrency transactions.
> 
> I even made it simpler. Pre-import, I calculated and populated the currency 
> conversions using just 1 exchange rate. I thought that by doing this I avoid 
> having to maintain a price database that could change on a daily basis. 
> Because this would mean the calculating the conversions prior to import will 
> require me to have a different conversion rate depending on the day. It's 
> possible but I thought it will take more work.
> 
> But I may be wrong. So do you think that fixing the price database will fix 
> the multi-currency import problem I am having?
> 
> Thanks.
> 
> 
> On Fri, Mar 6, 2020 at 1:37 PM  > wrote:
> Gio,
> 
> If you are using the 3.x series, there’s a convenient CSV price importer that 
> works well. You can even save the CSV price file template for future use, so 
> you’d have to set it up only once.
> 
> That should alleviate a lot of burden in entering prices in price database 
> manually.
> 
> Cheers.
> 
> > On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org 
> >  wrote:
> > 
> > Date: Fri, 6 Mar 2020 12:23:17 +0800
> > From: Gio Bacareza mailto:gbacar...@gmail.com> 
> > >>
> > To: GnuCash Users  >   > >>
> > Subject: Re: [GNC] importing csv multisplit multicurrency problems
> > Message-ID:
> >> 
> >   > >>
> > Content-Type: text/plain; charset="UTF-8"
> > 
> > As mentioned I did some follow through tests with empty and pre-populated
> > currency price databases. Sharing it here:
> > 
> > Conclusions:
> > When doing multi-currency csv imports, it works when the price database is
> > pre-populated with exchange rates consistent with exchange rates used in
> > the import.
> > The issue I have with this is that pre-populating the price DB is
> > cumbersome.
> > There has to be a better way.
> > 
> > More details of test here
> > https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing
> >  
> > 
> >  
> >  >  
> > >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> 
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists 
>  for 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

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

Re: [GNC] importing csv multisplit multicurrency problems

[pobox . deva]

Gio,

If you are using the 3.x series, there’s a convenient CSV price importer that 
works well. You can even save the CSV price file template for future use, so 
you’d have to set it up only once.

That should alleviate a lot of burden in entering prices in price database 
manually.

Cheers.

> On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org wrote:
> 
> Date: Fri, 6 Mar 2020 12:23:17 +0800
> From: Gio Bacareza mailto:gbacar...@gmail.com>>
> To: GnuCash Users mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] importing csv multisplit multicurrency problems
> Message-ID:
>>
> Content-Type: text/plain; charset="UTF-8"
> 
> As mentioned I did some follow through tests with empty and pre-populated
> currency price databases. Sharing it here:
> 
> Conclusions:
> When doing multi-currency csv imports, it works when the price database is
> pre-populated with exchange rates consistent with exchange rates used in
> the import.
> The issue I have with this is that pre-populating the price DB is
> cumbersome.
> There has to be a better way.
> 
> More details of test here
> https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing
>  
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 invoice on Income & GST Statement Report

[pobox . deva]

Many thanks to you and Maf for your suggestions - I was able to fix the problem 
by setting the General/Add options summary to know what was wrong.

The offending invoice was issued to a new customer who started in Jan, so the 
corresponding Income account was created recently. When this new income account 
was added, it didn’t automatically get selected in the Report Options->Accounts 
tab. This was made evident by the add option summary setting, in which this 
account wasn’t listed.

To Maf’s musings, yes, the account tree is quite nested, because this was done 
at a time of chaotic rollout of GST in India and I was trying to keep all 
possibilities open by way of reporting - hence the granularity.

This is an extremely valuable report for my GST filings, so I am relieved that 
the taxes I have been paying are accurate.

Cheers.



> On 02-Feb-2020, at 4:44 PM, Christopher Lam  wrote:
> 
> Set General/Add options summary to 'always', and paste the headers.
> 
> On Sun, 2 Feb 2020 at 10:36,  > wrote:
> Yes, there’s 1 split going to Income account. See screenshot link below. This 
> screenshot is from the IGST @ 18% account view. The account, 
> Assets:Business:Invoices, is my A/R account.
> 
> https://drive.google.com/open?id=1mgf4H13ywbMPKv9UtthyQrl7NJ_2o7Te 
> 
> 
> Thank you for making time to review this anomaly.
> 
> Cheers.
> 
>> On 02-Feb-2020, at 2:04 PM, Christopher Lam > > wrote:
>> 
>> This report doesn't query the A/R register. It queries the Income account. 
>> Did you post it there?
>> 
>> On Sun, 2 Feb 2020, 4:09 pm , > > wrote:
>> Yes, the previous quarter ends on 31-DEC-2019.
>> 
>> Perhaps I was misunderstood. Since I didn’t find the invoice showing up in 
>> the current quarter (Jan - Mar 2020), I ran the report for the previous 
>> quarter to check if it somehow shows up there. But it didn’t. In fact, I ran 
>> the report for the entire financial year thus far (1-APR-19 to 1-FEB-20) and 
>> that particular invoice doesn’t show up in any quarter or month.
>> 
>> It happened once before about 2 years ago when an invoice was posted on 1st 
>> of the month, internally, it got recorded as 31st of the previous month in 
>> one of the splits and the report correctly didn’t show that particular 
>> invoice. But this was in the 2.6 series and I was able to edit the A/R 
>> register then, so I went in and changed the offending date to 1st and 
>> everything worked fine from then on.
>> 
>> But in the current 3.x series, the A/R register edit feature is now 
>> disabled. However, all dates are stored correctly, so I am at a loss as to 
>> why it’s not showing on the report.
>> 
>> I am not sure if the PNG attachments I sent earlier came through. If it 
>> didn’t, I am sharing the same via Google Drive links here. Hopefully this 
>> will work.
>> 
>> https://drive.google.com/open?id=1FsWMCgwszskdxeNuOi6VApvxn_vyS7_y 
>> 
>> https://drive.google.com/open?id=1qqbvieyO4NnTlxDyzlMRmvqd_u-29X3p 
>> 
>> 
>> Please let me know if you need any more information.
>> 
>> Cheers.
>> 
>> 
>>> On 02-Feb-2020, at 1:34 AM, Christopher Lam >> > wrote:
>>> 
>>> Doesn't previous quarter end on 31/12/2019?
>>> 
>>> On Sat, 1 Feb 2020, 10:58 pm , >> > wrote:
>>> Hello,
>>> 
>>> I am running 3.7 on Mac OS High Sierra 10.13.6.
>>> 
>>> Something peculiar is happening with my datafile this month.
>>> 
>>> See attached 2 screenshots - one from Find Invoice dialog for the date 
>>> range 1-JAN-2020 to 1-FEB-2020. The other from the Income & GST Statement 
>>> report.
>>> 
>>> There’s one invoice that’s not showing up in the Income & GST Statement 
>>> (i.e., invoice id = 000361). And I can’t find out why.
>>> 
>>> This invoice was opened on 2-JAN-2020, posted on 6-JAN-2020 and paid on 
>>> 2-JAN-2020. I tried unposting and changing all dates to 2-JAN-2020 and it 
>>> still doesn’t show up on the report.
>>> 
>>> When I run the Income & GST Statement report for the previous quarter, this 
>>> invoice isn’t there either.
>>> 
>>> Can someone please help since my GST tax payment is due in the coming week?
>>> 
>>> This invoice is no different from any other invoice in the period and I 
>>> have confirmed that it is still marked active.
>>> 
>>> Cheers.
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org 
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>>> 
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lis

Re: [GNC] Missing invoice on Income & GST Statement Report

[pobox . deva]

Yes, there’s 1 split going to Income account. See screenshot link below. This 
screenshot is from the IGST @ 18% account view. The account, 
Assets:Business:Invoices, is my A/R account.

https://drive.google.com/open?id=1mgf4H13ywbMPKv9UtthyQrl7NJ_2o7Te 


Thank you for making time to review this anomaly.

Cheers.

> On 02-Feb-2020, at 2:04 PM, Christopher Lam  wrote:
> 
> This report doesn't query the A/R register. It queries the Income account. 
> Did you post it there?
> 
> On Sun, 2 Feb 2020, 4:09 pm ,  > wrote:
> Yes, the previous quarter ends on 31-DEC-2019.
> 
> Perhaps I was misunderstood. Since I didn’t find the invoice showing up in 
> the current quarter (Jan - Mar 2020), I ran the report for the previous 
> quarter to check if it somehow shows up there. But it didn’t. In fact, I ran 
> the report for the entire financial year thus far (1-APR-19 to 1-FEB-20) and 
> that particular invoice doesn’t show up in any quarter or month.
> 
> It happened once before about 2 years ago when an invoice was posted on 1st 
> of the month, internally, it got recorded as 31st of the previous month in 
> one of the splits and the report correctly didn’t show that particular 
> invoice. But this was in the 2.6 series and I was able to edit the A/R 
> register then, so I went in and changed the offending date to 1st and 
> everything worked fine from then on.
> 
> But in the current 3.x series, the A/R register edit feature is now disabled. 
> However, all dates are stored correctly, so I am at a loss as to why it’s not 
> showing on the report.
> 
> I am not sure if the PNG attachments I sent earlier came through. If it 
> didn’t, I am sharing the same via Google Drive links here. Hopefully this 
> will work.
> 
> https://drive.google.com/open?id=1FsWMCgwszskdxeNuOi6VApvxn_vyS7_y 
> 
> https://drive.google.com/open?id=1qqbvieyO4NnTlxDyzlMRmvqd_u-29X3p 
> 
> 
> Please let me know if you need any more information.
> 
> Cheers.
> 
> 
>> On 02-Feb-2020, at 1:34 AM, Christopher Lam > > wrote:
>> 
>> Doesn't previous quarter end on 31/12/2019?
>> 
>> On Sat, 1 Feb 2020, 10:58 pm , > > wrote:
>> Hello,
>> 
>> I am running 3.7 on Mac OS High Sierra 10.13.6.
>> 
>> Something peculiar is happening with my datafile this month.
>> 
>> See attached 2 screenshots - one from Find Invoice dialog for the date range 
>> 1-JAN-2020 to 1-FEB-2020. The other from the Income & GST Statement report.
>> 
>> There’s one invoice that’s not showing up in the Income & GST Statement 
>> (i.e., invoice id = 000361). And I can’t find out why.
>> 
>> This invoice was opened on 2-JAN-2020, posted on 6-JAN-2020 and paid on 
>> 2-JAN-2020. I tried unposting and changing all dates to 2-JAN-2020 and it 
>> still doesn’t show up on the report.
>> 
>> When I run the Income & GST Statement report for the previous quarter, this 
>> invoice isn’t there either.
>> 
>> Can someone please help since my GST tax payment is due in the coming week?
>> 
>> This invoice is no different from any other invoice in the period and I have 
>> confirmed that it is still marked active.
>> 
>> Cheers.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org 
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>> 
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists 
>>  for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 invoice on Income & GST Statement Report

[pobox . deva]

Yes, the previous quarter ends on 31-DEC-2019.

Perhaps I was misunderstood. Since I didn’t find the invoice showing up in the 
current quarter (Jan - Mar 2020), I ran the report for the previous quarter to 
check if it somehow shows up there. But it didn’t. In fact, I ran the report 
for the entire financial year thus far (1-APR-19 to 1-FEB-20) and that 
particular invoice doesn’t show up in any quarter or month.

It happened once before about 2 years ago when an invoice was posted on 1st of 
the month, internally, it got recorded as 31st of the previous month in one of 
the splits and the report correctly didn’t show that particular invoice. But 
this was in the 2.6 series and I was able to edit the A/R register then, so I 
went in and changed the offending date to 1st and everything worked fine from 
then on.

But in the current 3.x series, the A/R register edit feature is now disabled. 
However, all dates are stored correctly, so I am at a loss as to why it’s not 
showing on the report.

I am not sure if the PNG attachments I sent earlier came through. If it didn’t, 
I am sharing the same via Google Drive links here. Hopefully this will work.

https://drive.google.com/open?id=1FsWMCgwszskdxeNuOi6VApvxn_vyS7_y 

https://drive.google.com/open?id=1qqbvieyO4NnTlxDyzlMRmvqd_u-29X3p 


Please let me know if you need any more information.

Cheers.


> On 02-Feb-2020, at 1:34 AM, Christopher Lam  wrote:
> 
> Doesn't previous quarter end on 31/12/2019?
> 
> On Sat, 1 Feb 2020, 10:58 pm ,  > wrote:
> Hello,
> 
> I am running 3.7 on Mac OS High Sierra 10.13.6.
> 
> Something peculiar is happening with my datafile this month.
> 
> See attached 2 screenshots - one from Find Invoice dialog for the date range 
> 1-JAN-2020 to 1-FEB-2020. The other from the Income & GST Statement report.
> 
> There’s one invoice that’s not showing up in the Income & GST Statement 
> (i.e., invoice id = 000361). And I can’t find out why.
> 
> This invoice was opened on 2-JAN-2020, posted on 6-JAN-2020 and paid on 
> 2-JAN-2020. I tried unposting and changing all dates to 2-JAN-2020 and it 
> still doesn’t show up on the report.
> 
> When I run the Income & GST Statement report for the previous quarter, this 
> invoice isn’t there either.
> 
> Can someone please help since my GST tax payment is due in the coming week?
> 
> This invoice is no different from any other invoice in the period and I have 
> confirmed that it is still marked active.
> 
> Cheers.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> 
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists 
>  for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

[GNC] Missing invoice on Income & GST Statement Report

[pobox . deva]

Hello,

I am running 3.7 on Mac OS High Sierra 10.13.6.

Something peculiar is happening with my datafile this month.

See attached 2 screenshots - one from Find Invoice dialog for the date range 
1-JAN-2020 to 1-FEB-2020. The other from the Income & GST Statement report.

There’s one invoice that’s not showing up in the Income & GST Statement (i.e., 
invoice id = 000361). And I can’t find out why.

This invoice was opened on 2-JAN-2020, posted on 6-JAN-2020 and paid on 
2-JAN-2020. I tried unposting and changing all dates to 2-JAN-2020 and it still 
doesn’t show up on the report.

When I run the Income & GST Statement report for the previous quarter, this 
invoice isn’t there either.

Can someone please help since my GST tax payment is due in the coming week?

This invoice is no different from any other invoice in the period and I have 
confirmed that it is still marked active.

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