Skip to main content

Import QuickBooks Sales Taxes into EmbTrak

·         From the EmbTrak Home Screen,  go to System à Import à QuickBooks à QuickBooks 2006 – 2014 Sales Tax Import

                   IQST1

  • After the Import program completes, a dialog box displays, noting the total number of Sales Taxes that have been imported.  Only Active QuickBooks Sales Tax Items will be imported into EmbTrak.

                     IQST2

 

  • Close and reopen EmbTrak.

Accessing Sales Tax settings in EmbTrak

  • From the EmbTrak Home Screen,  go to System à Administration à Edit List Tables à List Data Editor

                   IQST3

  • Click on Sales Taxes to access the current Sales Tax settings.
    • Type = Single for Tax Codes that represent one tax.
    • Type = Group for Tax Codes that represent a combination of 2 or more taxes.
    • Ex.  Haywood COunty 7% = NC Sales Tax (4.75%) + Haywood County Tax (2.25%)
  • Change Type to "Group" where necessary. 
  • Click Save.

                      IQST4

When the Sales Tax exists in QuickBooks, but not in EmbTrak

  • The Import program will set the EmbTrak fields as follows:
 
Code = QuickBooks Sales Tax Name
Tax Agency = QuickBooks Tax Agency 
Description = QuickBooks Description 
Tax Rate = QuickBooks Tax Rate
Type = "Single"

 

   IQST5 

           QuickBooks

 

 IQST6

                    EmbTrak

  • Note: 
    • If QuickBooks Description, Tax Rate, or Tax Agency are blank, they will remain blank in EmbTrak.


When the Sales Tax exists in both QuickBooks and EmbTrak prior to Import

  • Updates will occur when a QuickBooks Sales Tax has a different Sales Tax Name, Description, Tax Rate, or Tax Agency.
  • If a Sales Tax exists on a prior EmbTrak Sales Transaction, the sales tax label will need to be reset  on each transaction.
  • If an item is marked inactive in QuickBooks, it is not imported and therefore remains unchanged in EmbTrak.

When Implementing a New Sales Tax for your Business

  • First, add the Sales Tax Item into QuickBooks.
  • Then, run QuickBooks Sales Tax Import to import it into EmbTrak.

Join our EmbTrak newsletter today for free.

The more I work with EmbTrak, the more I have come to appreciate its capabilities and efficiency as a workflow processing system. The ease of interface and simplicity of data mining/retrieval make... Read More

Eric Hann
Bermuda Sands Apparel of Embroidery Operations Manager

The proofing feature in EmbTrak has dramatically improved efficiency and accuracy in communicating the many details of orders with customers. Our customers, sales reps, and production team have a... Read More

James Hedges
Simms Fishing of Customer Service Rep

The proofing feature in EmbTrak has dramatically improved efficiency and accuracy in communicating the many details of orders with customers. Our customers, sales reps, and production team have a... Read More

James Hedges
Simms Fishing of Customer Service

"After adding EmbTrak, our color coordination staff was able to handle a 48% sales increase in March over the previous year's level with less overtime and no increase in headcount. EmbTrak has been... Read More

James Howarth
TaylorMade-Adidas Golf of National Services Manager

“EmbTrak makes training new production operators much easier by providing detailed thread-up instructions, a list of required cones, a production dispatch list and a printed Work Order with a color... Read More

Lori Young
Dunlop Sports Group of Production Supervisor

"It's a beautiful thing--you select a Work Order, you select a design from the customer's dropdown list, you click ‘Match’ and all the thread colors come in, and you're done!"

Kim Washburn
Dunlop Sports Group of Color Coordinator

“I love EmbTrak. I can do the color coordination on an order in about half the time it took without EmbTrak.”

Tara Cutts
Fairway & Greene of Color Coordinator

“EmbTrak is the best thing you’ve ever done for our business."

Sales Rep
Antigua Group of IT Department

"October was the highest sales month in the history of Antigua. It was so busy that even the VP of Operations was in the warehouse picking product for orders. However, the Order Coordination area,... Read More

Chris Devous
Antigua Group of Director of Development