Ph: +1 (619) 377-0977 (9 A.M to 5 P.M EST)

SaasAnt Support Portal

Submit a ticket My Tickets Blog
Welcome
Login  Sign up

Import Transactions with Sales Tax for U.S QuickBooks Online Companies

Well, It is not a super engineering work to incorporate sales tax for your transactions into QuickBooks Online when you use SaasAnt Transactions (Online). We will see how it can be done according to this article.


For U.S QuickBooks Companies, you can mention Sales Tax in all your sales transactions like Invoice, Sales Receipt, Estimate &, etc.


Kindly go through the below link for setting up Sales Tax in QuickBooks Online.

 

http://www.teachucomp.com/set-up-sales-tax-in-quickbooks-online-tutorial


How to Record Sales Tax in QuickBooks


 In order to record Sales Tax for a transaction, you have to do the following:

 

1.  We need to mark the Product or Service as taxable in the transaction.

2.  Sales Tax Code should be given in the transaction.


The above information is given to SaasAnt Transactions (Online) by mapping relevant fields from the file. In the next section, we will see how the fields are mapped to get Tax information.

 

QuickBooks Field Mapping


Please go through this link if you are new to the Field Mapping concept.

  

In the Field Mapping Screen, for each Transaction Type (Invoice, Sales Receipt, Estimate & Credit Memo), you will get the following QuickBooks Fields.

 

1. Line Item Taxable
2. Sales Tax Code
3. Sales Tax Amount (this is Optional)


1) Line Item Taxable


This field takes only BOOLEAN value such as “TRUE” / “T” or “FALSE” / “F”. If “Line Item Taxable” is TRUE, then the particular product or service will be counted for Sales Tax.


Field mapping: 

 

 field mapping in quickbooks

 

Sample File Template: 


field mapping quickbooks

 

QuickBooks View:  



2) Sales Tax Code

 

This field takes the PROPER Name of your Sales Tax. You can find the tax code name in QuickBooks UI (Sales Tax menu). The Sales Tax Codes can be found by navigating to


Sales Tax (left navigation bar) > Add/edit tax rates

and agencies California, Tucson, AZ State tax, and Tucson City are Sales Tax Code in the below screenshot. 

 

quickbooks Sales Tax Code 

You can also refer to the sales tax code in Sale Transactions UI (QuickBooks). Check this invoice Screen. The Sales Tax Code is "California" in the example. 

 

Sales Tax Code quickbooks 

Field mapping: 

 

field mapping quickbooks

 


3) Sales Tax Amount


This is an optional field. Because “SaasAnt Transactions (Online)” will automatically calculate the tax based on Sales Tax Code and sends the final tax amount to QuickBooks Online.


As we want to control everything, we have provided an option to override the calculated amount. You can use this field to feed the actual tax amount. 

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.