Re: [GNC] Accounting for GST in Australia
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
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
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
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
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
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
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
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
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
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.
