Re: [GNC] Goods and Services Tax - GST

[Jacob Verbeek]

Hi,
I'm a new user of GNUCash for my fledgling consulting business.  I love 
the program but can just not get GST to work the way I want to (New 
Zealand).  I've read all the documentation I can find on it. I've gone 
with the 3-account system but GNUCash seems to just add up the absolute 
value of the numbers I enter into each category, disregarding whether 
they have a positive or negative value; changing the account type to 
asset/liability doesn't seem to make any difference.  It's probably 
something really simple and dumb but I just can't seem to fix it.  How 
do I go about getting some support to resolve this issue?


Much appreciated,

JACOB

022 0264943
jacobv.consulta...@gmail.comm
www.about.me/jacobverbeek

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

Re: [GNC] Goods and Services Tax - GST

[Christopher Lam]

Maybe you can share your account structure or a data file with sample data,
and we can try make it work? The documentation is still behind the
reporting capability.

On Wed, 1 Apr 2020, 4:08 pm Jacob Verbeek, 
wrote:

> Hi,
> I'm a new user of GNUCash for my fledgling consulting business.  I love
> the program but can just not get GST to work the way I want to (New
> Zealand).  I've read all the documentation I can find on it. I've gone
> with the 3-account system but GNUCash seems to just add up the absolute
> value of the numbers I enter into each category, disregarding whether
> they have a positive or negative value; changing the account type to
> asset/liability doesn't seem to make any difference.  It's probably
> something really simple and dumb but I just can't seem to fix it.  How
> do I go about getting some support to resolve this issue?
>
> Much appreciated,
>
> JACOB
>
> 022 0264943
> jacobv.consulta...@gmail.comm
> www.about.me/jacobverbeek
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Goods and Services Tax - GST

[Christopher Lam]

Hi

(Screenshot containing private data snipped)

The first rule here is that support emails are always public because others
may want to help.

It seems you have set the Preferences > Accounts > Reverse Balanced
accounts to 'Credit accounts' which is fine.

It also seems that the GST Paid and GST Returns filed are negative --
depending on the preference above, this may be fine; but the parent account
adding the values as described would suggest that they may be incorrect
account type.

It seems your GST Sales > GST Purchases, so, I'd suggest the following
structure, with top-level GST account:

GST [Liability]
GST:Collected on Sales [Liability]
GST:Paid on Purchases [Asset]
GST:Paid to IRD [Liability]

Thus all values would usually be positive with 'credit accounts' reversal
option.

You can also try the "Income & GST Statement" report to assist with your
periodic filing.

On Wed, 1 Apr 2020 at 09:02, JV  wrote:

> That would be great!  Sorry, I'm also new to these support mailing lists
> so please let me know if I'm meant to be looking for support elsewhere
> or in a different format.
>
> I've attached a screenshot to give you some insight.  I don't understand
> why it's adding up the absolute values of the GST figures rather than
> giving the assets (GST paid & GST returns filed) a positive value and
> liabilities (GST collected) a negative value. The 'GST payable to IRD'
> in my mind should be GST collected minus GST paid minus GST returns
> filed.  Thanks for much for your help - it's starting to do my head in!
>
> On 1/04/20 9:45 pm, Christopher Lam wrote:
> > Maybe you can share your account structure or a data file with sample
> data,
> > and we can try make it work? The documentation is still behind the
> > reporting capability.
> >
> > On Wed, 1 Apr 2020, 4:08 pm Jacob Verbeek,  >
> > wrote:
> >
> >> Hi,
> >> I'm a new user of GNUCash for my fledgling consulting business.  I love
> >> the program but can just not get GST to work the way I want to (New
> >> Zealand).  I've read all the documentation I can find on it. I've gone
> >> with the 3-account system but GNUCash seems to just add up the absolute
> >> value of the numbers I enter into each category, disregarding whether
> >> they have a positive or negative value; changing the account type to
> >> asset/liability doesn't seem to make any difference.  It's probably
> >> something really simple and dumb but I just can't seem to fix it.  How
> >> do I go about getting some support to resolve this issue?
> >>
> >> Much appreciated,
> >>
> >> JACOB
> >>
> >> 022 0264943
> >> jacobv.consulta...@gmail.comm
> >> www.about.me/jacobverbeek
> >>
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Goods and Services Tax - GST

[Christopher Lam]

Please remember to cc the mailing list for all replies.

Now we've established you are on credit-accounts, the amounts showing
negative means you have likely entered the GST on Purchase data incorrectly.

On Wed, 1 Apr 2020 at 09:58, JV  wrote:

> Thanks for your help.  I wasn't aware of the Preferences>Accounts>Reverse
> Balanced Accounts feature but you're right - that was my setting.  I still
> don't understand why GNUCash is handling the values the way it is. I've
> pretty much got the structure you suggested:
>
> GST [Liability]
> GST:Collected on Sales [Liability]
> GST:Paid on Purchases [Asset]
> GST:Paid to IRD [Asset]
>
> Except that I figure that the GST I've paid to the tax department (IRD) so
> far should be an asset (please correct me if I'm wrong).  But for some
> reason whatever I change the account type to for these values (liability or
> asset), it doesn't seem to affect the top-level account sum total at all.
>
> On 1/04/20 10:31 pm, Christopher Lam wrote:
>
> Hi
>
> (Screenshot containing private data snipped)
>
> The first rule here is that support emails are always public because
> others may want to help.
>
> It seems you have set the Preferences > Accounts > Reverse Balanced
> accounts to 'Credit accounts' which is fine.
>
> It also seems that the GST Paid and GST Returns filed are negative --
> depending on the preference above, this may be fine; but the parent account
> adding the values as described would suggest that they may be incorrect
> account type.
>
> It seems your GST Sales > GST Purchases, so, I'd suggest the following
> structure, with top-level GST account:
>
> GST [Liability]
> GST:Collected on Sales [Liability]
> GST:Paid on Purchases [Asset]
> GST:Paid to IRD [Liability]
>
> Thus all values would usually be positive with 'credit accounts' reversal
> option.
>
> You can also try the "Income & GST Statement" report to assist with your
> periodic filing.
>
> On Wed, 1 Apr 2020 at 09:02, JV  wrote:
>
>> That would be great!  Sorry, I'm also new to these support mailing lists
>> so please let me know if I'm meant to be looking for support elsewhere
>> or in a different format.
>>
>> I've attached a screenshot to give you some insight.  I don't understand
>> why it's adding up the absolute values of the GST figures rather than
>> giving the assets (GST paid & GST returns filed) a positive value and
>> liabilities (GST collected) a negative value. The 'GST payable to IRD'
>> in my mind should be GST collected minus GST paid minus GST returns
>> filed.  Thanks for much for your help - it's starting to do my head in!
>>
>> On 1/04/20 9:45 pm, Christopher Lam wrote:
>> > Maybe you can share your account structure or a data file with sample
>> data,
>> > and we can try make it work? The documentation is still behind the
>> > reporting capability.
>> >
>> > On Wed, 1 Apr 2020, 4:08 pm Jacob Verbeek, <
>> jacobv.consulta...@gmail.com>
>> > wrote:
>> >
>> >> Hi,
>> >> I'm a new user of GNUCash for my fledgling consulting business.  I love
>> >> the program but can just not get GST to work the way I want to (New
>> >> Zealand).  I've read all the documentation I can find on it. I've gone
>> >> with the 3-account system but GNUCash seems to just add up the absolute
>> >> value of the numbers I enter into each category, disregarding whether
>> >> they have a positive or negative value; changing the account type to
>> >> asset/liability doesn't seem to make any difference.  It's probably
>> >> something really simple and dumb but I just can't seem to fix it.  How
>> >> do I go about getting some support to resolve this issue?
>> >>
>> >> Much appreciated,
>> >>
>> >> JACOB
>> >>
>> >> 022 0264943
>> >> jacobv.consulta...@gmail.comm
>> >> www.about.me/jacobverbeek
>> >>
>> >> ___
>> >> gnucash-user mailing list
>> >> gnucash-user@gnucash.org
>> >> To update your subscription preferences or to unsubscribe:
>> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> >> If you are using Nabble or Gmane, please see
>> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> >> -
>> >> Please remember to CC this list on all your replies.
>> >> You can do this by using Reply-To-List or Reply-All.
>> >>
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> > -
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>>
>>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or G

Re: [GNC] Backdated manual price entries

[James Edmunds]

Yes I am using Price Database Editor  .To clarify  I am trying  to manually 
 add backdated prices to shares I already own.


From: David Carlson 
Sent: 31 March 2020 16:01
To: James Edmunds 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Backdated manual price entries

Jimmy,  Are you using the Price Database editor?  That doesn't even know 
whether you own shares.

On Tue, Mar 31, 2020 at 9:13 AM James Edmunds 
mailto:jimmy...@hotmail.co.uk>> wrote:
I use F:Q 1.49 and GNC 2.6.12 running on Ubuntu 16.04 . I upgraded from Ubuntu 
14.04 to 16.04 in August 2019 , During the upgrade I removed the existing GNC 
2.6.12 ( from Ubuntu 14.04 ) using the Ubuntu Software Centre and installed GNC 
2.6.12 ( from Ubuntu 16.04 )  using the Ubuntu Software Centre.


In both 14.04 and 16.04 I successfully used F:Q to upload prices for all of my 
securities which I had set “ Get online quotes” and most of currencies which I 
had set “ Get online quotes” most of the time .


Up to early 2019 I was able to manually input back dated prices for both 
securities and currencies

eg input a 31 Dec 19 price in Mar 2020.


Now I am not able to do this . I do not know the exact date of the change.


I find that for securities I can only input a backdated price if there are no 
holdings in the security.


For currencies I can input a backdated price for some currencies but not others 
I cannot.


Any help or suggestion would be appreciated.

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


--
David 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.

Re: [GNC] Goods and Services Tax - GST

[Christopher Lam]

Bingo. Everything is wrong about it :) You should probably input this
purchase from the bank account or credit card that you used to pay for it.
It should be similar to:

[image: image.png]


On Wed, 1 Apr 2020 at 10:30, JV  wrote:

> I've attached a screenshot which shows the purchase data of a typical
> expense entry.  Please let me know if I've entered the data in the wrong
> columns.
>
> On 1/04/20 11:06 pm, Christopher Lam wrote:
>
> Please remember to cc the mailing list for all replies.
>
> Now we've established you are on credit-accounts, the amounts showing
> negative means you have likely entered the GST on Purchase data incorrectly.
>
> On Wed, 1 Apr 2020 at 09:58, JV  wrote:
>
>> Thanks for your help.  I wasn't aware of the Preferences>Accounts>Reverse
>> Balanced Accounts feature but you're right - that was my setting.  I still
>> don't understand why GNUCash is handling the values the way it is. I've
>> pretty much got the structure you suggested:
>>
>> GST [Liability]
>> GST:Collected on Sales [Liability]
>> GST:Paid on Purchases [Asset]
>> GST:Paid to IRD [Asset]
>>
>> Except that I figure that the GST I've paid to the tax department (IRD)
>> so far should be an asset (please correct me if I'm wrong).  But for some
>> reason whatever I change the account type to for these values (liability or
>> asset), it doesn't seem to affect the top-level account sum total at all.
>>
>> On 1/04/20 10:31 pm, Christopher Lam wrote:
>>
>> Hi
>>
>> (Screenshot containing private data snipped)
>>
>> The first rule here is that support emails are always public because
>> others may want to help.
>>
>> It seems you have set the Preferences > Accounts > Reverse Balanced
>> accounts to 'Credit accounts' which is fine.
>>
>> It also seems that the GST Paid and GST Returns filed are negative --
>> depending on the preference above, this may be fine; but the parent account
>> adding the values as described would suggest that they may be incorrect
>> account type.
>>
>> It seems your GST Sales > GST Purchases, so, I'd suggest the following
>> structure, with top-level GST account:
>>
>> GST [Liability]
>> GST:Collected on Sales [Liability]
>> GST:Paid on Purchases [Asset]
>> GST:Paid to IRD [Liability]
>>
>> Thus all values would usually be positive with 'credit accounts' reversal
>> option.
>>
>> You can also try the "Income & GST Statement" report to assist with your
>> periodic filing.
>>
>> On Wed, 1 Apr 2020 at 09:02, JV  wrote:
>>
>>> That would be great!  Sorry, I'm also new to these support mailing lists
>>> so please let me know if I'm meant to be looking for support elsewhere
>>> or in a different format.
>>>
>>> I've attached a screenshot to give you some insight.  I don't understand
>>> why it's adding up the absolute values of the GST figures rather than
>>> giving the assets (GST paid & GST returns filed) a positive value and
>>> liabilities (GST collected) a negative value. The 'GST payable to IRD'
>>> in my mind should be GST collected minus GST paid minus GST returns
>>> filed.  Thanks for much for your help - it's starting to do my head in!
>>>
>>> On 1/04/20 9:45 pm, Christopher Lam wrote:
>>> > Maybe you can share your account structure or a data file with sample
>>> data,
>>> > and we can try make it work? The documentation is still behind the
>>> > reporting capability.
>>> >
>>> > On Wed, 1 Apr 2020, 4:08 pm Jacob Verbeek, <
>>> jacobv.consulta...@gmail.com>
>>> > wrote:
>>> >
>>> >> Hi,
>>> >> I'm a new user of GNUCash for my fledgling consulting business.  I
>>> love
>>> >> the program but can just not get GST to work the way I want to (New
>>> >> Zealand).  I've read all the documentation I can find on it. I've gone
>>> >> with the 3-account system but GNUCash seems to just add up the
>>> absolute
>>> >> value of the numbers I enter into each category, disregarding whether
>>> >> they have a positive or negative value; changing the account type to
>>> >> asset/liability doesn't seem to make any difference.  It's probably
>>> >> something really simple and dumb but I just can't seem to fix it.  How
>>> >> do I go about getting some support to resolve this issue?
>>> >>
>>> >> Much appreciated,
>>> >>
>>> >> JACOB
>>> >>
>>> >> 022 0264943
>>> >> jacobv.consulta...@gmail.comm
>>> >> www.about.me/jacobverbeek
>>> >>
>>> >> ___
>>> >> gnucash-user mailing list
>>> >> gnucash-user@gnucash.org
>>> >> To update your subscription preferences or to unsubscribe:
>>> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> >> If you are using Nabble or Gmane, please see
>>> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> >> -
>>> >> Please remember to CC this list on all your replies.
>>> >> You can do this by using Reply-To-List or Reply-All.
>>> >>
>>> > ___
>>> > gnucash-user mailing list
>>> > gnucash-user@gnucash.org
>>> > To update your subscription preferences or to unsubsc

[GNC] Customizing of trial balance report to have a standard appearance for auditors

[finf...@gmail.com]

Hello!

Can you please help in customizing the trial-balance.scm to add some 
data in this report?


These is what I need to see there:

- the opening balance for start-date

- the sum of debits

- the sum of credits

- the ending balance for end-date

- the subtotals per account group in the balance sheet.


This is a standard appearance for preparing Financial Statements.


Regards,

Dimitri.

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

Re: [GNC] Goods and Services Tax - GST

[JV]

Thankyou!  I obviously have a lot to learn about accounting still! I'll 
have a play with this to see if it fixes my issues.  It seems to from a 
quick test data file I created.  On your other point, under Equity I 
created an account structure as follows:


Equity
    Owner's equity
        Owner's deposits
        Owner's withdrawals

to try and capture the fact that I've been using personal money 
injections to make purchases while I'm starting up my business.  So the 
screenshot I sent through shows me using personal money to pay for a 
cellphone charge.  Is there a better way of accounting to capture this?


On 1/04/20 11:41 pm, Christopher Lam wrote:
Bingo. Everything is wrong about it :) You should probably input this 
purchase from the bank account or credit card that you used to pay for 
it. It should be similar to:


image.png


On Wed, 1 Apr 2020 at 10:30, JV > wrote:


I've attached a screenshot which shows the purchase data of a
typical expense entry.  Please let me know if I've entered the
data in the wrong columns.

On 1/04/20 11:06 pm, Christopher Lam wrote:

Please remember to cc the mailing list for all replies.

Now we've established you are on credit-accounts, the amounts
showing negative means you have likely entered the GST on
Purchase data incorrectly.

On Wed, 1 Apr 2020 at 09:58, JV mailto:jal...@hotmail.com>> wrote:

Thanks for your help.  I wasn't aware of the
Preferences>Accounts>Reverse Balanced Accounts feature but
you're right - that was my setting.  I still don't understand
why GNUCash is handling the values the way it is. I've pretty
much got the structure you suggested:

GST [Liability]
GST:Collected on Sales [Liability]
GST:Paid on Purchases [Asset]
GST:Paid to IRD [Asset]

Except that I figure that the GST I've paid to the tax
department (IRD) so far should be an asset (please correct me
if I'm wrong).  But for some reason whatever I change the
account type to for these values (liability or asset), it
doesn't seem to affect the top-level account sum total at all.

On 1/04/20 10:31 pm, Christopher Lam wrote:

Hi

(Screenshot containing private data snipped)

The first rule here is that support emails are always public
because others may want to help.

It seems you have set the Preferences > Accounts > Reverse
Balanced accounts to 'Credit accounts' which is fine.

It also seems that the GST Paid and GST Returns filed are
negative -- depending on the preference above, this may be
fine; but the parent account adding the values as described
would suggest that they may be incorrect account type.

It seems your GST Sales > GST Purchases, so, I'd suggest the
following structure, with top-level GST account:

GST [Liability]
GST:Collected on Sales [Liability]
GST:Paid on Purchases [Asset]
GST:Paid to IRD [Liability]

Thus all values would usually be positive with 'credit
accounts' reversal option.

You can also try the "Income & GST Statement" report to
assist with your periodic filing.

On Wed, 1 Apr 2020 at 09:02, JV mailto:jal...@hotmail.com>> wrote:

That would be great!  Sorry, I'm also new to these
support mailing lists
so please let me know if I'm meant to be looking for
support elsewhere
or in a different format.

I've attached a screenshot to give you some insight.  I
don't understand
why it's adding up the absolute values of the GST
figures rather than
giving the assets (GST paid & GST returns filed) a
positive value and
liabilities (GST collected) a negative value. The 'GST
payable to IRD'
in my mind should be GST collected minus GST paid minus
GST returns
filed.  Thanks for much for your help - it's starting to
do my head in!

On 1/04/20 9:45 pm, Christopher Lam wrote:
> Maybe you can share your account structure or a data
file with sample data,
> and we can try make it work? The documentation is
still behind the
> reporting capability.
>
> On Wed, 1 Apr 2020, 4:08 pm Jacob Verbeek,
mailto:jacobv.consulta...@gmail.com>>
> wrote:
>
>> Hi,
>> I'm a new user of GNUCash for my fledgling consulting
business.  I love
>> the program but can just not get GST to work the way
I want to (New
>> Zealand).  I've read all the documentation I can find
on it. I've gone
>> with the 3-account system but GNUCash seems t

Re: [GNC] Customizing of trial balance report to have a standard appearance for auditors

[Michael or Penny Novack]

Dimitri,

Two questions:
1) Are all of this data available from the report? Or if not, otherwise 
known (for example, maybe just end date but start date known as the date 
of the previous run --- I am a bit confused because like Balance Sheet, 
I thought a trial balance was "as of" some date and not applying to an 
interval.
  In other words, data available but report not formatted the way the 
auditors want it.


2) If so, do you understand how to EXPORT a report from gnucash? And 
then get THAT into a document you can edit using your favorite editor?
    scheme is not something to do pretty print editing in, though the 
emacs diehards will be screaming at me (scheme is a lisp dialect)


I always exported and then used a general purpose editor to 
reformat/pretty print reports before presenting them to a board. And I 
am/was a pro who could get by in lisp << not one of my regular languages 
as not paid to design/code in it ; but I could at least read most 
anything even of not fluent writing it >>


Michael D Novack



Hello!

Can you please help in customizing the trial-balance.scm to add some 
data in this report?


These is what I need to see there:
- the opening balance for start-date
- the sum of debits
- the sum of credits
- the ending balance for end-date
- the subtotals per account group in the balance sheet.

This is a standard appearance for preparing Financial Statements.

Regards,

Dimitri.




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

Re: [GNC] Goods and Services Tax - GST

[Christopher Lam]

As long as your accountant is happy with it.

On Wed, 1 Apr 2020, 7:14 pm JV,  wrote:

> Thankyou!  I obviously have a lot to learn about accounting still!  I'll
> have a play with this to see if it fixes my issues.  It seems to from a
> quick test data file I created.  On your other point, under Equity I
> created an account structure as follows:
>
> Equity
> Owner's equity
> Owner's deposits
> Owner's withdrawals
>
> to try and capture the fact that I've been using personal money injections
> to make purchases while I'm starting up my business.  So the screenshot I
> sent through shows me using personal money to pay for a cellphone charge.
> Is there a better way of accounting to capture this?
>
> On 1/04/20 11:41 pm, Christopher Lam wrote:
>
> Bingo. Everything is wrong about it :) You should probably input this
> purchase from the bank account or credit card that you used to pay for it.
> It should be similar to:
>
> [image: image.png]
>
>
> On Wed, 1 Apr 2020 at 10:30, JV  wrote:
>
>> I've attached a screenshot which shows the purchase data of a typical
>> expense entry.  Please let me know if I've entered the data in the wrong
>> columns.
>>
>> On 1/04/20 11:06 pm, Christopher Lam wrote:
>>
>> Please remember to cc the mailing list for all replies.
>>
>> Now we've established you are on credit-accounts, the amounts showing
>> negative means you have likely entered the GST on Purchase data incorrectly.
>>
>> On Wed, 1 Apr 2020 at 09:58, JV  wrote:
>>
>>> Thanks for your help.  I wasn't aware of the
>>> Preferences>Accounts>Reverse Balanced Accounts feature but you're right -
>>> that was my setting.  I still don't understand why GNUCash is handling the
>>> values the way it is. I've pretty much got the structure you suggested:
>>>
>>> GST [Liability]
>>> GST:Collected on Sales [Liability]
>>> GST:Paid on Purchases [Asset]
>>> GST:Paid to IRD [Asset]
>>>
>>> Except that I figure that the GST I've paid to the tax department (IRD)
>>> so far should be an asset (please correct me if I'm wrong).  But for some
>>> reason whatever I change the account type to for these values (liability or
>>> asset), it doesn't seem to affect the top-level account sum total at all.
>>>
>>> On 1/04/20 10:31 pm, Christopher Lam wrote:
>>>
>>> Hi
>>>
>>> (Screenshot containing private data snipped)
>>>
>>> The first rule here is that support emails are always public because
>>> others may want to help.
>>>
>>> It seems you have set the Preferences > Accounts > Reverse Balanced
>>> accounts to 'Credit accounts' which is fine.
>>>
>>> It also seems that the GST Paid and GST Returns filed are negative --
>>> depending on the preference above, this may be fine; but the parent account
>>> adding the values as described would suggest that they may be incorrect
>>> account type.
>>>
>>> It seems your GST Sales > GST Purchases, so, I'd suggest the following
>>> structure, with top-level GST account:
>>>
>>> GST [Liability]
>>> GST:Collected on Sales [Liability]
>>> GST:Paid on Purchases [Asset]
>>> GST:Paid to IRD [Liability]
>>>
>>> Thus all values would usually be positive with 'credit accounts'
>>> reversal option.
>>>
>>> You can also try the "Income & GST Statement" report to assist with your
>>> periodic filing.
>>>
>>> On Wed, 1 Apr 2020 at 09:02, JV  wrote:
>>>
 That would be great!  Sorry, I'm also new to these support mailing
 lists
 so please let me know if I'm meant to be looking for support elsewhere
 or in a different format.

 I've attached a screenshot to give you some insight.  I don't
 understand
 why it's adding up the absolute values of the GST figures rather than
 giving the assets (GST paid & GST returns filed) a positive value and
 liabilities (GST collected) a negative value. The 'GST payable to IRD'
 in my mind should be GST collected minus GST paid minus GST returns
 filed.  Thanks for much for your help - it's starting to do my head in!

 On 1/04/20 9:45 pm, Christopher Lam wrote:
 > Maybe you can share your account structure or a data file with sample
 data,
 > and we can try make it work? The documentation is still behind the
 > reporting capability.
 >
 > On Wed, 1 Apr 2020, 4:08 pm Jacob Verbeek, <
 jacobv.consulta...@gmail.com>
 > wrote:
 >
 >> Hi,
 >> I'm a new user of GNUCash for my fledgling consulting business.  I
 love
 >> the program but can just not get GST to work the way I want to (New
 >> Zealand).  I've read all the documentation I can find on it. I've
 gone
 >> with the 3-account system but GNUCash seems to just add up the
 absolute
 >> value of the numbers I enter into each category, disregarding whether
 >> they have a positive or negative value; changing the account type to
 >> asset/liability doesn't seem to make any difference.  It's probably
 >> something really simple and dumb but I just can't seem to fix it.
 How
 >> d

Re: [GNC] some of my reconciliations in 3.9 are completely bonkers

[David Reiser via gnucash-user]

I have no problem with (A), except maybe if you’re using the gnucash posting 
date. A reconciliation resolves transactions based on the bank’s posting date, 
not gnucash’s. If I don’t enter March 31, 2020 interest until April 1, I’m 
still going to enter it in my account as having occurred on 3/31. But even that 
distinction can’t be causing what I’m seeing.

In my simplest case, my savings account was last reconciled based on the 
interest paid 1/31/2020. On 2/29 I received $0.96 in interest and on 3/31 I 
received $1.03 in interest. There were no other transactions during that time. 
I have no idea when I entered the February interest, but I did enter the March 
interest on 3/31/2020 (at least it was still 3/31 on the U.S. east coast).

When I click Reconcile, in the Reconcile Information dialog, I get:
Statement date 02/29/2020
Starting Balance $3024.39 (this amount was reconciled in gnucash 3.7)
ending Balance $3025.36  (reasonable, since 3024.39 + 0.96 = 3025.35)

Now if I click OK to get to the transaction check-off dialog, I get:

Starting balance: 375.15  (What???)
Ending Balance: 3025.36 (well, it remembered what I entered)
Reconciled balance: 376.11 (well, it is 375.15 + 0.96 …)

Difference: 2649.24 (the math is locally consistent, but the starting balance 
doesn’t represent anything in my register or what gnucash showed me on the 
prior screen)

Dave
--
Dave Reiser
dbrei...@icloud.com





> On Apr 1, 2020, at 1:19 AM, Christopher Lam  wrote:
> 
> This is due to https://bugs.gnucash.org/show_bug.cgi?id=797640 
> 
> 
> This change modifies the reconciliation starting balance calculator from 
> Account->reconciled_balance to account->reconciled_balance on statement date.
> 
> The reasoning for this change is with the observation:
> 
> (A) if reconciliation is performed from a statement dated 31/01/2019, the 
> starting balance calculator should ignore transactions posted later than 
> 31/01/2019.
> 
> (B) subsequent work https://github.com/Gnucash/gnucash/pull/667 
>  aims to store past 
> reconciliation ending balances and statement date. As a result we can 
> re-reconcile any past statement.
> 
> (C) subsequent work will allow a sanity-check type report (illustrated in 
> above PR)  which will compare account reconciled balances at previous 
> statement dates, and highlight any discrepancy.
> 
> There have been previous feature requests to store and retrieve reconciled 
> balances and reconciliation dates, and I believe it's possible and reasonable.
> 
> Having explained the rationale, the reasoning (A) may be incorrect -- please 
> file in bug 797640 how/why starting_balance should include transactions 
> posted after statement date. If reasoning (A) is invalid then we will need to 
> revert the change, which means (B) and (C) above cannot happen.
> 
> On Wed, 1 Apr 2020, 11:48 am David Reiser via gnucash-user, 
> mailto:gnucash-user@gnucash.org>> wrote:
> My checking account reconciled fine.
> Then I went to two savings accounts and got completely off-the-wall results. 
> When I first clicked the reconcile button, the dialog that comes up has the 
> correct starting balance and the correct proposed to-be-reconciled balance. 
> When I click OK to get to the transaction check-off dialog, gnucash has 
> completely changed the starting balance to a much smaller number (and one 
> that has never appeared in the account ledger) and thus presents an out of 
> balance total that cannot be reconciled with the transactions that are in the 
> account.
> 
> Dave
> --
> Dave Reiser
> dbrei...@icloud.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] GnuCash 3.9 still has problems with Budget ?

[Phil Longstaff]

True. However, the problem is that the budget report shows a payment to a
liability as negative. So, unless the budget amount is also negative, the
"diff" column is incorrect.

On Tue, Mar 31, 2020 at 10:12 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Negative from the perspective of the source account, not from the
> perspective of the liability. The same is true of expenses.
>
> In the budget module, your amounts should all be positive for
> savings(assets), income, expenses and payments on liabilities.
>
> 1. Budget your income
> 2. Budget the following based on priorities
>   a. Expenses
>   b. Liability Payments
>   c. Savings (or other asset acquisitions)
> 3. Enter every number as positive
>
> Observe that the total remaining to be budgeted increases when you budget
> positive income.
> Observe that the total remaining to be budgeted decreases when you budget
> positive anything else.
>
> I just tested this on 3.9 and it works as expected.
>
> Regards,
> Adrien
>
> > On Mar 31, 2020 w14d91, at 8:45 PM, Long 
> wrote:
> >
> > Jim,
> >
> > When you made a payment to liability, the amount are negative.
> >
> > Regards
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Backdated manual price entries

[David Carlson]

Exactly what happens after you click the add button?

On Wed, Apr 1, 2020 at 5:24 AM James Edmunds  wrote:

> Yes I am using Price Database Editor  .To clarify  I am trying  to
> manually  add backdated prices to shares I already own.
>
> --
> *From:* David Carlson 
> *Sent:* 31 March 2020 16:01
> *To:* James Edmunds 
> *Cc:* gnucash-user@gnucash.org 
> *Subject:* Re: [GNC] Backdated manual price entries
>
> Jimmy,  Are you using the Price Database editor?  That doesn't even know
> whether you own shares.
>
> On Tue, Mar 31, 2020 at 9:13 AM James Edmunds 
> wrote:
>
> I use F:Q 1.49 and GNC 2.6.12 running on Ubuntu 16.04 . I upgraded from
> Ubuntu 14.04 to 16.04 in August 2019 , During the upgrade I removed the
> existing GNC 2.6.12 ( from Ubuntu 14.04 ) using the Ubuntu Software Centre
> and installed GNC 2.6.12 ( from Ubuntu 16.04 )  using the Ubuntu Software
> Centre.
>
>
> In both 14.04 and 16.04 I successfully used F:Q to upload prices for all
> of my securities which I had set “ Get online quotes” and most of
> currencies which I had set “ Get online quotes” most of the time .
>
>
> Up to early 2019 I was able to manually input back dated prices for both
> securities and currencies
>
> eg input a 31 Dec 19 price in Mar 2020.
>
>
> Now I am not able to do this . I do not know the exact date of the change.
>
>
> I find that for securities I can only input a backdated price if there are
> no holdings in the security.
>
>
> For currencies I can input a backdated price for some currencies but not
> others I cannot.
>
>
> Any help or suggestion would be appreciated.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
>
> --
> David Carlson
>


-- 
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.

Re: [GNC] GnuCash 3.9 still has problems with Budget ?

[Adrien Monteleone]

I get the same thing. Looks like a bug in the Budget Report then. I’m going to 
hazard that perhaps rather than budgeting a single amount with a sign, the 
module should allow for budgeting debits and credits separately. That way there 
is never a sign confusion or an issue with the reverse balance accounts 
setting. But that would require a major re-write of the Budget Module. It is 
probably easier to fix the report.

Regards,
Adrien

> On Apr 1, 2020 w14d92, at 10:24 AM, Phil Longstaff  
> wrote:
> 
> True. However, the problem is that the budget report shows a payment to a
> liability as negative. So, unless the budget amount is also negative, the
> "diff" column is incorrect.
> 
> On Tue, Mar 31, 2020 at 10:12 PM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> 
>> Negative from the perspective of the source account, not from the
>> perspective of the liability. The same is true of expenses.
>> 
>> In the budget module, your amounts should all be positive for
>> savings(assets), income, expenses and payments on liabilities.
>> 
>> 1. Budget your income
>> 2. Budget the following based on priorities
>>  a. Expenses
>>  b. Liability Payments
>>  c. Savings (or other asset acquisitions)
>> 3. Enter every number as positive
>> 
>> Observe that the total remaining to be budgeted increases when you budget
>> positive income.
>> Observe that the total remaining to be budgeted decreases when you budget
>> positive anything else.
>> 
>> I just tested this on 3.9 and it works as expected.
>> 
>> Regards,
>> Adrien
>> 
>>> On Mar 31, 2020 w14d91, at 8:45 PM, Long 
>> wrote:
>>> 
>>> Jim,
>>> 
>>> When you made a payment to liability, the amount are negative.
>>> 
>>> Regards


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

Re: [GNC] GnuCash 3.9 still has problems with Budget ?

[Christopher Lam]

No, the budget editor is still buggy. This is why we really need beta
testers.

On Thu, 2 Apr 2020, 3:38 am Adrien Monteleone, <
adrien.montele...@lusfiber.net> wrote:

> I get the same thing. Looks like a bug in the Budget Report then. I’m
> going to hazard that perhaps rather than budgeting a single amount with a
> sign, the module should allow for budgeting debits and credits separately.
> That way there is never a sign confusion or an issue with the reverse
> balance accounts setting. But that would require a major re-write of the
> Budget Module. It is probably easier to fix the report.
>
> Regards,
> Adrien
>
> > On Apr 1, 2020 w14d92, at 10:24 AM, Phil Longstaff <
> phil.longst...@gmail.com> wrote:
> >
> > True. However, the problem is that the budget report shows a payment to a
> > liability as negative. So, unless the budget amount is also negative, the
> > "diff" column is incorrect.
> >
> > On Tue, Mar 31, 2020 at 10:12 PM Adrien Monteleone <
> > adrien.montele...@lusfiber.net> wrote:
> >
> >> Negative from the perspective of the source account, not from the
> >> perspective of the liability. The same is true of expenses.
> >>
> >> In the budget module, your amounts should all be positive for
> >> savings(assets), income, expenses and payments on liabilities.
> >>
> >> 1. Budget your income
> >> 2. Budget the following based on priorities
> >>  a. Expenses
> >>  b. Liability Payments
> >>  c. Savings (or other asset acquisitions)
> >> 3. Enter every number as positive
> >>
> >> Observe that the total remaining to be budgeted increases when you
> budget
> >> positive income.
> >> Observe that the total remaining to be budgeted decreases when you
> budget
> >> positive anything else.
> >>
> >> I just tested this on 3.9 and it works as expected.
> >>
> >> Regards,
> >> Adrien
> >>
> >>> On Mar 31, 2020 w14d91, at 8:45 PM, Long 
> >> wrote:
> >>>
> >>> Jim,
> >>>
> >>> When you made a payment to liability, the amount are negative.
> >>>
> >>> Regards
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.