Tax Codes

 

 Tax Codes allows the user to create tax codes that can be assigned to products and/or freight in contracts, orders and invoices in both purchases and sales. The system has the ability to have numerous tax codes. Effective dates are used to change rates for the tax codes. In v7.27+, there is an option to automatically calculate the tax amount based on the product type and source country and/or state and the destination country/and or state.

 

Table Name: ProteinTaxCodes, Protein Tax Rates

Create Tax Code

There are two grids that must be defined on the tax code:

Tax Codes

Tax Codes must be defined prior to creating an effective date in the tax rate section.

 

  1. In Admin>Business>General>Definitions, select  Tax Codes.

  2. Select to create a new record.

  1. Enter a Tax No  to identify the tax.

  2. Enter a Tax Name to describe the tax.

  3. Select a Tax Type to identity the type of tax.  Options are State, Federal or Other.

  4. Select an Expense Type where system will code the tax account. Options are:

  5. Select a Purchase Account No where the tax will be coded when the tax code is assigned to vendor skus.

  6. Select a Sales Account No where the tax will be coded when the tax code is assigned to a sales sku

  7. Grower Pay Expense Account can be used in settlements to define the Cost Element in the tax amount.

  8. The Grower Pay AP Account allows the user to select the User Account that will be used when recording taxes in settlements.

  9. Vendor No defines the vendor that is paid for the tax remittance.

  10. Check Calc on Net if the tax will be calculated on the product amount plus and taxes that do not have the Calc on Net option selected. This option basically calculates tax on tax.

  11. Tax Exempt indicates if the tax is tax exempt but still requires a tax code to identify that it is exempt. If the Customers>Companies or Vendor>Companies tab has the Tax Exempt option selected, the tax logic will only look to Tax Exempt tax codes when deriving the applicable tax rate.

  12. Cash Basis indicates that the tax is recognized when the cash is collected. There is no logic for cash receipts in MTech so there is no additional logic. It is only required to transfer data to the financial system. If the Customers>Companies or Vendor>Companies tab has the Cash Basis option selected, the tax logic will only look to Cash Basisi  tax codes when deriving the applicable tax rate.

 

Tax Rates

Tax Rates are updated in the Tax Rate Screen by assigning a new  effective date to a new tax rate. The effective date will determine when the tax rate is to be applied.

 

  1. Enter an Effective Date when the tax rate is to be utilized.

  2. Select the Product Type. Leave blank if the Tax No applies to all product Types.

  3. Select the Source Country No to indicate the country is being shipped from. Leave blank if Tax No applies to all countries where product is being shipped from.

  4. Select the Destination Country No to indicated where the product is being shipped to. If the Source Country No is selected, the Destination Country No must also be defined for the tax logic to be applied.

  5. Select the Source State No if the tax is calculated based on a specific state where the product is being shipped. Leave blank if the Tax No applies to all states where the product is being shipped from.

  6. Select the Destination State No to indicate the tax based on where the product is being shipped to. If the Source State No is selected, the Destination State No must also be defined for the tax logic to be applied.

  7. Enter a Tax Rate -amount of tax.

  8. Save and close the record.