Re: [GNC] Accounting for GST in Australia

2021-07-07 Thread 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.

Re: [GNC] Accounting for GST in Australia

2021-07-07 Thread 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

Re: [GNC] Accounting for GST in Australia

2021-07-07 Thread 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.

Re: [GNC] Accounting for GST in Australia

2021-07-07 Thread 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

Re: [GNC] Accounting for GST in Australia

2021-07-07 Thread 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

Re: [GNC] Accounting for GST in Australia

2021-07-07 Thread 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

Re: [GNC] Accounting for GST in Australia

2021-07-07 Thread 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

Re: [GNC] Accounting for GST in Australia

2021-07-07 Thread 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

Re: [GNC] Accounting for GST in Australia

2021-07-07 Thread 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: > *

Re: [GNC] Accounting for GST in Australia

2021-07-07 Thread 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

Re: [GNC] Accounting for GST in Australia

2021-07-06 Thread 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

Re: [GNC] Accounting for GST in Australia

2021-07-06 Thread 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

[GNC] Accounting for GST in Australia

2021-07-06 Thread flywire
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

Re: [GNC] Accounting for GST in Australia

2021-07-05 Thread 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: >

Re: [GNC] Accounting for GST in Australia

2021-07-05 Thread 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

Re: [GNC] Accounting for GST in Australia

2021-06-23 Thread 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

Re: [GNC] Accounting for GST in Australia

2021-06-22 Thread 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

Re: [GNC] Accounting for GST in Australia

2021-06-22 Thread 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

Re: [GNC] Accounting for GST in Australia

2021-06-22 Thread 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

Re: [GNC] Accounting for GST in Australia

2021-06-22 Thread 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

[GNC] Accounting for GST in Australia

2021-06-22 Thread Nathan Ellery
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