Bingo. This has been hanging around for a long time since 99% of our sales are zero-rated. Automatically catching the other 1% will reduce the opportunity for errors and speed up the process.
Sent from my iPhone > On Mar 5, 2021, at 7:13 AM, R. Victor Klassen <rvklas...@gmail.com> wrote: > > I’m wondering whether I left out the “Tax Included” column, and whether > there are no important columns after that so it just (almost) works. > > I’ll have another chance to try it out this morning, as we have an importable > invoice twice a week. Something to try. > >> On Mar 4, 2021, at 8:10 PM, Nelson Handcock <nelson.handc...@gmail.com> >> wrote: >> >> In your original email you say your GST Tax table is in column P - mine is >> in column Q. So perhaps that's the problem? >> >> Thanks & Regards, >> >> Nelson Handcock >> 0409 149919 >> >> http://www.linkedin.com/in/nelsonhandcockaustralia >> >> >> On Fri, Mar 5, 2021 at 11:09 AM Nelson Handcock <nelson.handc...@gmail.com> >> wrote: >>> Hello, >>> >>> Ahh yes - I mis-read your original email! >>> >>> Here's a snapshot of my recent loadfile: >>> <image.png> >>> >>> And here's a snapshot of my tax tables: >>> <image.png> >>> >>> The loaded invoice looks fine in GN - the GST amount is correct and is >>> showing in the liabilities account as defined. >>> >>> >>> Thanks & Regards, >>> >>> Nelson Handcock >>> >>> >>> >>> On Thu, Mar 4, 2021 at 10:29 AM R. Victor Klassen <rvklas...@gmail.com> >>> wrote: >>>> When I said the x in the “Taxable?” column is correctly showing which >>>> items are taxable, I was referring to the column in the invoice after >>>> import. >>>> >>>> I do have a Y in the appropriate column of the csv file being imported - >>>> else I wouldn’t get the x in the “Taxable?” column. >>>> >>>> >>>>> On Mar 2, 2021, at 2:50 PM, Nelson Handcock <nelson.handc...@gmail.com> >>>>> wrote: >>>>> >>>>> Hello, >>>>> >>>>> Try using "Y" in the Taxable column instead of "X" >>>>> >>>>> Regards, etc >>>>> >>>>> On Wed., 3 Mar. 2021, 02:40 R. Victor Klassen, <rvklas...@gmail.com> >>>>> wrote: >>>>>> The documentation I’ve read has me specify the tax table in column 15 >>>>>> (counting from 0) aka column P when the csv file is opened as a >>>>>> spreadsheet. >>>>>> >>>>>> When I put the three letters “HST” or the phrase “Harmonized Sales Tax”, >>>>>> both of which name sales tax tables, in that column, it is ignored. >>>>>> >>>>>> The x in the “Taxable?” Column is correctly showing which items are >>>>>> taxable. >>>>>> >>>>>> Is there a trick I am missing? >>>>>> >>>>>> >>>>>> Gnucash v 3.11 MacOS 10.13.6 if it matters. >>>>>> >>>>>> Sent from my iPhone >>>>>> _______________________________________________ >>>>>> 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.
