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 <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, <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 Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
