[GNC] Import invoices ~ tax table

[Nelson Handcock]

Glad you got it sorted!

On Sat., 6 Mar. 2021, 00:50 R. Victor Klassen, <rvklassen at 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 <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.
>>>>
>>>
>>>
>