Re: [GNC] Accounting for GST in Australia

[flywire]

I suspect GnuCash can't handle auto-populated Tax on a *cash accounting
system* invoice given the responses. Maybe the following workflow will
prompt something.

QuickBooks uses Accounts Payable/Receivable *except* being cash accounting
there is no posting Accounts Payable/Receivable or whatever. GnuCash
doesn't seem to support this tweak. I agree GST is less complex than some
of the international examples raised but these Invoices come from another
party and efficient data entry is important.

We use a clutz in QuickBooks, each Recipient Created Tax Invoice (RCTI) is
entered as a Sales Receipt and a Payment. Since I don't enter the data I
don't argue but it seems to make the best use of both forms. I have a
vague recollection of turning inventory on to use qty on a sales receipt
but other than that we don't manage inventory but find it useful.

Enter Invoice Splits:
* Item
* Description by lookup
* Qty
* Price/unit
* Tax by lookup
* Tax amount by lookup is verified
* Amount which can be entered GST inclusive or exclusive

Enter Payment Splits:
* Account
* Tax by lookup
* Amount (GST inclusive or exclusive)
* Tax amount by lookup is verified
* Memo optional
* Class (not supported in GnuCash) auto-populated

Data entry is pretty efficient but you miss out on the benefits of open
data.


On Wed, Jul 7, 2021 at 8:52 PM flywire  wrote:

> Are auto-generated GST calculations available for cash accounting without 
> Accounts
> Payable/Receivable?
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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

[William Prescott]

At one time I lived in Boulder County, Colorado. The city limit ran along the 
street at the side of my house. Across the street was a city park.
Colorado sales tax is 2.9%
Boulder County 0.99%
City of Boulder 3.86%
Transit District 1%
Scientific and Cultural 0.1%

If I bought things in a store in Boulder, I paid the full 8.85%. Items 
delivered to my house were exempt from the City tax.

Will

On 2021 Jul 7, at 07-07 11:59:28, David Carlson  
wrote:

Yep.  Lake County Illinois just added 4 cents per gallon tax on gasoline  ⛽
sales.  You can bet good money that most locals are planning their
purchases to occur in Wisconsin when possible.

On Wed, Jul 7, 2021, 10:57 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 7/7/2021 11:46 AM, David Carlson wrote:
>> Even worse, sometimes local sales taxes in the  depend on where
>> the buyer lives, not where the seller does business.
> 
> That is almost always true, and to make this even worse, JUST the
> buyer's postal address might not be a correct indication of the state.
> Postal zip codes do NOT respect state boundaries. If that seems odd to
> you, imagine the situation where a road is the boundary between two
> states or crosses back and forth across the boundary. Do you imagine the
> post office sends two postal trucks, one to deliver to one side of the
> road and the other for the other side, or one to deliver to the
> stretches of road in one state and another for the stretches in the
> other state.
> 
> How many of us have customer databases that in addition to customer
> address, store the state where this actually is as opposed to just going
> by the state that the post office is in (for that zip code)
> 
> Michael D Novack
> 
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Accounting for GST in Australia

[Stephen M. Butler]

On 7/7/21 8:33 AM, Michael or Penny Novack wrote:

On 7/7/2021 7:41 AM, flywire wrote:
GST is only really supported if it's auto-calculated otherwise a user 
has
to enter twice the splits with the associated logic and keying 
errors. I've

only been using the Account Register for data entry.


But GST in Australia appears to be a simple problem compared to "sales 
tax" here. Which not only varies by state (with respect to rate) but 
on what is or is not subject to the sales tax.


Here in Washington of the USA, sales tax is based on your address. I've 
seen houses sitting next to each other that are in different tax 
districts with different rates.  Most POS systems just go down to the 
zip code level so I have to pick the "most popular" tax rate for each 
zip code.  <>
This may be too much to expect from an ACCOUNTING system like gnucash 
if we expect automation. Usually this sort of thing is handled by what 
is called a POS system (point of sales) which builds the invoice of 
sales receipt << it will have the total sales tax attributed to this 
sale figured by adding up the sales tax on each item since whether 
taxable or at what rate depends on the item >> Such systems also need 
to make provision of "no tax" sales where the buyer has a certificate 
of exemption on file with the vendor.


Typically a POS system is paired with an accounting system. The latter 
has only to be able to accept the transaction as created by the POS, 
not figure it out.


Yes.  Now if I would only take the time to figure out the multi-split 
import.  But not enough sales to force me into making that effort!!  So 
far I just dump a report for the daily deposit showing the half-dozen 
amounts (splits) that make up the transaction and manually enter them.  
Usually I can take the last sale and duplicate it for the next one (with 
minor changes for the local tax and net deposit).


Michael D Novack

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

Re: [GNC] Accounting for GST in Australia

[David Carlson]

Yep.  Lake County Illinois just added 4 cents per gallon tax on gasoline  ⛽
sales.  You can bet good money that most locals are planning their
purchases to occur in Wisconsin when possible.

On Wed, Jul 7, 2021, 10:57 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 7/7/2021 11:46 AM, David Carlson wrote:
> > Even worse, sometimes local sales taxes in the  depend on where
> > the buyer lives, not where the seller does business.
>
> That is almost always true, and to make this even worse, JUST the
> buyer's postal address might not be a correct indication of the state.
> Postal zip codes do NOT respect state boundaries. If that seems odd to
> you, imagine the situation where a road is the boundary between two
> states or crosses back and forth across the boundary. Do you imagine the
> post office sends two postal trucks, one to deliver to one side of the
> road and the other for the other side, or one to deliver to the
> stretches of road in one state and another for the stretches in the
> other state.
>
> How many of us have customer databases that in addition to customer
> address, store the state where this actually is as opposed to just going
> by the state that the post office is in (for that zip code)
>
> 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] Accounting for GST in Australia

[Michael or Penny Novack]

On 7/7/2021 11:46 AM, David Carlson wrote:
Even worse, sometimes local sales taxes in the  depend on where 
the buyer lives, not where the seller does business.


That is almost always true, and to make this even worse, JUST the 
buyer's postal address might not be a correct indication of the state. 
Postal zip codes do NOT respect state boundaries. If that seems odd to 
you, imagine the situation where a road is the boundary between two 
states or crosses back and forth across the boundary. Do you imagine the 
post office sends two postal trucks, one to deliver to one side of the 
road and the other for the other side, or one to deliver to the 
stretches of road in one state and another for the stretches in the 
other state.


How many of us have customer databases that in addition to customer 
address, store the state where this actually is as opposed to just going 
by the state that the post office is in (for that zip code)


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] Accounting for GST in Australia

[David Carlson]

Even worse, sometimes local sales taxes in the  depend on where the
buyer lives, not where the seller does business.



On Wed, Jul 7, 2021, 10:34 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

> On 7/7/2021 7:41 AM, flywire wrote:
> > GST is only really supported if it's auto-calculated otherwise a user has
> > to enter twice the splits with the associated logic and keying errors.
> I've
> > only been using the Account Register for data entry.
>
> But GST in Australia appears to be a simple problem compared to "sales
> tax" here. Which not only varies by state (with respect to rate) but on
> what is or is not subject to the sales tax.
>
> This may be too much to expect from an ACCOUNTING system like gnucash if
> we expect automation. Usually this sort of thing is handled by what is
> called a POS system (point of sales) which builds the invoice of sales
> receipt << it will have the total sales tax attributed to this sale
> figured by adding up the sales tax on each item since whether taxable or
> at what rate depends on the item >> Such systems also need to make
> provision of "no tax" sales where the buyer has a certificate of
> exemption on file with the vendor.
>
> Typically a POS system is paired with an accounting system. The latter
> has only to be able to accept the transaction as created by the POS, not
> figure it out.
>
> Michael D Novack
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounting for GST in Australia

[Michael or Penny Novack]

On 7/7/2021 7:41 AM, flywire wrote:

GST is only really supported if it's auto-calculated otherwise a user has
to enter twice the splits with the associated logic and keying errors. I've
only been using the Account Register for data entry.


But GST in Australia appears to be a simple problem compared to "sales 
tax" here. Which not only varies by state (with respect to rate) but on 
what is or is not subject to the sales tax.


This may be too much to expect from an ACCOUNTING system like gnucash if 
we expect automation. Usually this sort of thing is handled by what is 
called a POS system (point of sales) which builds the invoice of sales 
receipt << it will have the total sales tax attributed to this sale 
figured by adding up the sales tax on each item since whether taxable or 
at what rate depends on the item >> Such systems also need to make 
provision of "no tax" sales where the buyer has a certificate of 
exemption on file with the vendor.


Typically a POS system is paired with an accounting system. The latter 
has only to be able to accept the transaction as created by the POS, not 
figure it out.


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] Accounting for GST in Australia

[flywire]

GST is only really supported if it's auto-calculated otherwise a user has
to enter twice the splits with the associated logic and keying errors. I've
only been using the Account Register for data entry. Are Invoices and Bills
the way to do it without obligating the user to additional Accounts
Payable/Receivable tasks?

If so a brief example would be worth covering in that wiki.

On Wed, Jul 7, 2021 at 9:07 PM Christopher Lam 
wrote:

> 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.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Accounting for GST in Australia

[flywire]

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] Accounting for GST in Australia

[flywire]

Try this. Sample RCTI but varies by recipient. Note GST-Free Transaction
Levy is in this example.

This is really simplified because income and cost components are being
tracked for different enterprises and these livestock aren't
necessarily from the same enterprise.

Tax Invoice

Income   Value  Total
  12Ewes   87.501050.00
   8Lambs 115.25 922.00
  20Total   1972.00
GST  0.10197.20


Expense
   Amount GSTValue
Commission   5%  98.60   9.86 108.46
Transaction Levy   0.50  10.00 10.00
Yard Dues Sheep1.50  18.00   1.80  19.80
Yard Dues Lambs2.5%  23.05   2.31  25.36
Cartage 140.00  14.00 154.00
Insurance2%  39.44   3.94  43.38
 361.00

NETT PROCEEDS   1808.20


Farm-RCTI.xlsx
Description: MS-Excel 2007 spreadsheet
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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]

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

[Nathan Ellery]

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

[Alan Hopkins]

   Hello again Nathan
   Unfortunately I am not quite sure of the set-up you have so it is hard
   to comment.
   However, have you set up GST as a Liability Account parent account
   Liabilities and the GST Received sub-account using the GST liability
   account as "parent"?  If you haven't done that then the transaction GST
   transaction will not be entered in the ledger.
   Sorry if the above is a bit garbled but I'm in a rush!
   Good luck!
   Cheers
   Alan

   On 22/6/21 11:49 pm, Nathan Ellery wrote:

   Hello Alan Thanks for your reply.
   We are aware of the need to split transactions not entered as bills or
   invoices.
   However, we are entering invoices through the invoicing system within
   Gnucash, and the tax amount shows correctly on the actual invoice
   entry, but the amount of tax is not going to the GST accounts on the
   chart of accounts. How can we check the set-up to determine exactly why
   this is or what do we need to do in order to make the GST go to that
   account in the chart of accounts?
   Appreciate your help on this,
   And thanks Christopher, yes we did read that article but it doesn't
   seem to be working correctly.
   regards Nathan
   On Tue, Jun 22, 2021 at 5:23 PM Alan Hopkins <[1]hopp...@gmail.com>
   wrote:

   Hi Nathan
   Are you using GnuCash to generate your bills & invoices?  If not, when
   making entries directly into your accounts you won't see the GST
   automatically.  When entering invoices & bills you need to check the
   Taxable? & Tax Included? columns
   Otherwise, when making direct entries to your accounts you need to use
   "Splits" and add the GST manually.
   The above may not be clear but once we know more about how you are
   attempting to do things we might be able to help.
   Cheers
   Alan
   On 22/6/21 6:17 pm, Christopher Lam wrote:

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

On Tue, 22 Jun 2021, 2:59 pm Nathan Ellery, [3] 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 [4]
m: 0417 951575
___
gnucash-user mailing list
[5]gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
[6]https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
[7]https://wiki.gnucash.org/wiki/Mailing_Lists for 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
[8]gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
[9]https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see [10]https://wiki.gnucash.org/wiki/M
ailing_Lists for 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:hopp...@gmail.com
   2. https://wiki.gnucash.org/wiki/Quickstart_Australian_BAS
   3. mailto:ntell...@gmail.com
   4. http://grandesignwa.blogspot.com.au/
   5. mailto:gnucash-user@gnucash.org
   6. https://lists.gnucash.org/mailman/listinfo/gnucash-user
   7. https://wiki.gnucash.org/wiki/Mailing_Lists
   8. mailto:gnucash-user@gnucash.org
   9. https://lists.gnucash.org/mailman/listinfo/gnucash-user
  10. https://wiki.gnucash.org/wiki/Mailing_Lists
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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

[Maf. King]

Are you "posting" the invoices once you've created them?

Check the currencies for the invoice, customer and all the accounts you expect 
to be affected.

Just a couple of thoughts for you.


HTH,
Maf.




On Tuesday, 22 June 2021 14:49:16 BST Nathan Ellery wrote:
> Hello Alan Thanks for your reply.
> We are aware of the need to split transactions not entered as bills or
> invoices.
> However, we are entering invoices through the invoicing system within
> Gnucash, and the tax amount shows correctly on the actual invoice entry,
> but the amount of tax is not going to the GST accounts on the chart of
> accounts. How can we check the set-up to determine exactly why this is or
> what do we need to do in order to make the GST go to that account in the
> chart of accounts?
> Appreciate your help on this,
> 
> And thanks Christopher, yes we did read that article but it doesn't seem to
> be working correctly.
> regards Nathan
> 
> On Tue, Jun 22, 2021 at 5:23 PM Alan Hopkins  wrote:
> > Hi Nathan
> > Are you using GnuCash to generate your bills & invoices?  If not, when
> > making entries directly into your accounts you won't see the GST
> > automatically.  When entering invoices & bills you need to check the
> > Taxable? & Tax Included? columns
> > Otherwise, when making direct entries to your accounts you need to use
> > "Splits" and add the GST manually.
> > The above may not be clear but once we know more about how you are
> > attempting to do things we might be able to help.
> > Cheers
> > Alan
> > 
> > On 22/6/21 6: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 
> >  m: 0417 951575
> > ___
> > gnucash-user mailing listgnucash-u...@gnucash.org
> > To update your subscription preferences or to
> > unsubscribe:https://lists.gnucash.org/mailman/listinfo/gnucash-user If
> > you are using Nabble or Gmane, please
> > seehttps://wiki.gnucash.org/wiki/Mailing_Lists for 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 listgnucash-u...@gnucash.org
> > To update your subscription preferences or to
> > unsubscribe:https://lists.gnucash.org/mailman/listinfo/gnucash-user If
> > you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for 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] Accounting for GST in Australia

[Nathan Ellery]

Hello Alan Thanks for your reply.
We are aware of the need to split transactions not entered as bills or
invoices.
However, we are entering invoices through the invoicing system within
Gnucash, and the tax amount shows correctly on the actual invoice entry,
but the amount of tax is not going to the GST accounts on the chart of
accounts. How can we check the set-up to determine exactly why this is or
what do we need to do in order to make the GST go to that account in the
chart of accounts?
Appreciate your help on this,

And thanks Christopher, yes we did read that article but it doesn't seem to
be working correctly.
regards Nathan

On Tue, Jun 22, 2021 at 5:23 PM Alan Hopkins  wrote:

> Hi Nathan
> Are you using GnuCash to generate your bills & invoices?  If not, when
> making entries directly into your accounts you won't see the GST
> automatically.  When entering invoices & bills you need to check the
> Taxable? & Tax Included? columns
> Otherwise, when making direct entries to your accounts you need to use
> "Splits" and add the GST manually.
> The above may not be clear but once we know more about how you are
> attempting to do things we might be able to help.
> Cheers
> Alan
>
> On 22/6/21 6: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  
> 
> m: 0417 951575
> ___
> gnucash-user mailing listgnucash-u...@gnucash.org
> To update your subscription preferences or to 
> unsubscribe:https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please 
> seehttps://wiki.gnucash.org/wiki/Mailing_Lists for 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 listgnucash-u...@gnucash.org
> To update your subscription preferences or to 
> unsubscribe:https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for 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

[Alan Hopkins]

   Hi Nathan
   Are you using GnuCash to generate your bills & invoices?  If not, when
   making entries directly into your accounts you won't see the GST
   automatically.  When entering invoices & bills you need to check the
   Taxable? & Tax Included? columns
   Otherwise, when making direct entries to your accounts you need to use
   "Splits" and add the GST manually.
   The above may not be clear but once we know more about how you are
   attempting to do things we might be able to help.
   Cheers
   Alan

   On 22/6/21 6:17 pm, Christopher Lam wrote:

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

On Tue, 22 Jun 2021, 2:59 pm Nathan Ellery, [2] 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 [3]
m: 0417 951575
___
gnucash-user mailing list
[4]gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
[5]https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
[6]https://wiki.gnucash.org/wiki/Mailing_Lists for 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
[7]gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
[8]https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see [9]https://wiki.gnucash.org/wiki/Ma
iling_Lists for 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. https://wiki.gnucash.org/wiki/Quickstart_Australian_BAS
   2. mailto:ntell...@gmail.com
   3. http://grandesignwa.blogspot.com.au/
   4. mailto:gnucash-user@gnucash.org
   5. https://lists.gnucash.org/mailman/listinfo/gnucash-user
   6. https://wiki.gnucash.org/wiki/Mailing_Lists
   7. mailto:gnucash-user@gnucash.org
   8. https://lists.gnucash.org/mailman/listinfo/gnucash-user
   9. https://wiki.gnucash.org/wiki/Mailing_Lists
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for 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.