How to have USE tax identified on committed cost?

We have a new out-of-state vendor who is a committed cost on a job.  The vendor tells us they do not have nexus in the state of NJ (where we are located).  So we will need to pay use tax to the state, and bill our client for the use tax.  But, we do not want the tax to be a part of the commitment as the vendor will not be charging us for it.  Any way I try to enter it, the tax changes the commitment amount, increasing the commitment.

Compounding this issue is the fact that SOME of the work they are doing is taxable according to NJ, but not all of it is.  So when they send us an invoice, we will need to input it into AP as partially use-taxable and partially exempt from tax.

When we set up the vendor, we identified the tax as tax liability only.

We then tested entering an AP invoice.  When entering a generic invoice with no associated commitment, we got the tax liability amount to default in to the entry grid.  Good.

However, when we entered an AP Invoice and selected the commitment, the tax group column pre-filled with the tax on the commitment, which is "exempt".  We were not able to override the tax group and therefore the tax liability did not calculate.  Bad.

Please help, we can not be the only company to have run into this issue.  FYI - we are on Sage CRE 300 v. 15.1 and use AP, AR, BL, CM, CN, GL, JC, PR, and PJ.  Thank you!

  • 0
    According to AP Help -
    Tax retrieval hierarchy
    Tax groups and rates prefill on Accounts Payable invoices from the following locations in the following order:

    1. JC Commitment record
    2. JC Job
    3. AP Vendor record (Setup Vendors, Terms and Defaults tab)
    4. AP Settings (Invoice Settings, Tax Settings)

    We don't use PJ so my suggestion may not be useful. However, it sounds like you need to leave the tax field blank on the commitment and then it would look to the AP Vendor record which seems to be working for you.
  • 0 in reply to Rhonda V
    You can't override the tax group on a commitment. You may have to add additional lines to the invoice that are for the tax liability amounts only that are not linked to the commitment. (in the AP Distributions)
    You may want to call support for help in determine how to make this work
  • 0
    I am running into a similar issue and am curious if you've found a good way to remedy this. We also have costs that need to be committed and therefore need the amounts available in the contract amount, but don't want the tax amount to show on change orders that go to the vendor. I am hoping that using the TL tax features could help with this.

    I am currently trying to work with the tax liability features in AP to automatically put our invoices to our sales tax payable account, but previously we would just code the invoice header as the amount payable to the vendor and then create multiple distributions on the invoice - distribution(s) coded to the job to bill for both the amount payable to the vendor and the amount of the tax, then a distribution for the negative amount of the tax to our sales tax payable account.

    Some workarounds we have found that are not exactly ideal, but can work:

    - Create change orders for the tax amount on the commitment, but do not check the "revise commitment" box / leave pending. This way, future COs to the vendor reflect the actual amounts being paid direct to the vendor but there is at least some record of the tax amounts in the commitment. When you get to the end of the contract, it will look like you have a negative balance, but it is easy enough to check that all pending COs are for tax and that the pending CO amount is equal to the commitment balance overage.

    - Create a second commitment for the same job and same vendor for the tax only. All change orders for this tax commitment will be internal simply to add that tax to the proper place on the budget. When coding an invoice that needs tax added, use the original commitment for coding the amount to be paid to the vendor, and use the tax commitment to bill for tax.

    Note that for both of these workarounds, we did not even have the tax feature turned on, so all of these amounts were simple in the "amount" column, not in tax or tax liability.

    It seems to me that for our purposes, we would either need PJ to have a "tax liab" column similar to in AP and that this amount does not increase the commitment amount. Or if there is a way to change the crystal report for commitment COs so that the amounts on the CO do not reflect tax, that would probably work too.

    We are also on Sage 300 CRE 15.1 using AP, AR, CM, GL, JC, PR, PJ