Glad you got it sorted! On Sat., 6 Mar. 2021, 00:50 R. Victor Klassen, <rvklas...@gmail.com> wrote:
> 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.
