[GNC] Import invoices ~ tax table

Nelson Handcock nelson.handcock at gmail.com
Thu Mar 4 20:10:54 EST 2021


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: image.png]
>
> And here's a snapshot of my tax tables:
> [image: 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.
>>>
>>
>>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 5323 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210305/23243dc3/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 25920 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210305/23243dc3/attachment-0001.png>


More information about the gnucash-user mailing list