[GNC] Import invoices ~ tax table

[R. Victor Klassen]

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 <rvklassen at 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.handcock at 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.handcock at 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 <rvklassen at 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.handcock at 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, <rvklassen at 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 at 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.
>>>> 
>