Importing imp file to Sage - tax exempt issue.

I can successfully import a imp file into the sample company using this code:

<Version>
12001, 1
</Version>

<SalInvoice>
"Ashburton Reinforcing"
2, ,,03-31-2025, 0, ,66.65,0.00
C1020,2.0000,4.7500,9.50,GST,0,1,5.00,0.48,PST,0,0,7.00,0.665
H1020,2.0000,25.0000,50.00,GST,0,1,5.00,2.50,PST,0,0,7.00,3.50
</SalInvoice>

I understand that the tax code isn't being used and that the "GST" is pulling from the taxes. In my import code above I can see how when it it imported that Sage will put the sales invoice to the tax code GP.

However, how would my code look if I wanted the tax code to be GST exempt?

I tried the below, which it did import, but nothing was under the tax code.

<Version>
12001, 1
</Version>

<SalInvoice>
"Ashburton Reinforcing"
2, ,,03-31-2025, 0, ,66.65,0.00
C1020,2.0000,4.7500,9.50,GST,Exempt
H1020,2.0000,25.0000,50.00,GST,Exempt
</SalInvoice>

Any help would be greatly appreciated.

  • I personally have never used the E tax code.  If something is exempt, I skip the field and don't enter anything.

    However, have you tried

    C1020,2.0000,4.7500,9.50,GST,0,0,0,0
    H1020,2.0000,25.0000,50.00,GST,0,0,0,0

    I don't think it will work but it is the best approximation to the calculations of the E tax code.  The reason I don't think it will work is because there are no details in the Rate, Included and Refundable columns, but it might work.

    If you were going to skip the sales tax you could use the following and I think that will import.  I didn't test these, I'm just going from memory.

    C1020,2.0000,4.7500,9.50
    H1020,2.0000,25.0000,50.00

  • 0 in reply to Richard S. Ridings

    Hi Richard,

    Thanks for your reply.  I imported both of your suggestions.  They both did import, however, the tax code in the tax column was still blank.

    Ideally I would like the E tax code to show up so that the imported invoices to look the same as if they were manually entered.  Do you have any other suggestions?

  • 0 in reply to Kari_B

    I also tried changing the default tax code for the customer to see if that would make a difference and imported all of the different files to see if any of them would show the E tax code, and that didn't work either.