We created this example to illustrate how sales transactions generated in Quickbooks can be processed by Taxcompliant to produce sales tax reports for each of the 45 states having sales tax requirements.
Using Quickbooks we generated sales in various locations within each state. We customized the report feature for sales transactions, making sure data elements for state, zip code, taxable amount, and tax rate, and tax collected were included. This report (showing headings, etc) can be viewed by clicking QuickbooksTestReport. The report was then exported as a text csv file (once the report is displayed, click “Excel” and select the text file csv option). The text file for our example is quickbooksreport.csv.
By sharing the csv file via the Dropbox, we matched the sales data with our tax data base, and added tax jurisdiction and description elements to each transaction. Once this match was made, we generated tax reports for each state where sales occurred. These reports (produced as Excel worksheets) are then provided back to the retailer via the Dropbox.
Listed below are links to each state’s sales tax report. We suggest you print the csv file and review the input data along with the generated tax reports.
State Sales Tax Reports:
Alabama: Alabama_1 Arizona: Arizona_1, Arizona_2, Arizona_3
Arkansas: Arkansas_1, Arkansas_2 California: California_1, California_2, California_3, California_4
Colorado: Colorado_1 Connecticut: Connecticut_1
Washington DC: Washington DC_1 Florida: Florida_1 Florida_2 Florida_3
Georgia: Georgia_1 Georgia_2 Hawaii: Hawaii_1
Idaho: Idaho_1 Illinois: Illinois_1
Indiana: Indiana_1 Iowa: Iowa_1 Iowa_2
Kansas: Kansas_1 Kansas_2 Kentucky: Kentucky_1
Louisiana: Louisiana_1 Louisiana_2 Maine: Maine_1 Maine_2
Maryland: Maryland_1 Massachusetts: Massachusetts_1
Michigan: Michigan_1 Michigan_2 Minnesota: Minnesota_1
Missouri: Missouri_1 Nebraska: Nebraska_1 Nebraska_2 Nebraska_3
Nevada: Nevada_1 New Jersey: New Jersey_1
New Mexico: New Mexico_1 New York: New York_1 New York_2 New York_3
North Carolina: North Carolina_1 North Carolina_2 North Carolina_3 North Carolina_4 North Dakota: North Dakota_1 North Dakota_2 North Dakota_3
Ohio: Ohio_1 Ohio_2 Ohio_3 Ohio_4 Oklahoma: Oklahoma_1
Pennsylvania: Pennsylvania_1 Rhode Island: Rhode Island_1 Rhode Island_2
South Carolina: South Carolina_1,South Carolina_2, South Carolina_3 South Dakota: South Dakota_1, South Dakota_2
Tennessee: Tennessee_1, Tennessee_2, Tennessee_3 Texas: Texas_1, Texas_2
Utah: Utah_1, Utah_2 Vermont: Vermont_1
Virginia: Virginia_1, Virginia_2, Virginia_3 Washington: Washington_1 Washington_2 Washington_3
West Virginia: West Virginia_1 West Virginia_2 Wisconsin: Wisconsin_1 Wisconsin_2 Wisconsis_3
Wyoming: Wyoming_1
This example is intended simply to show how tax reports are generated by location, depending on how taxes are collected through Quickbooks or some other application. For a particular retailer, how those taxes are collected depends on the retailer’s nexus in each state, and whether the retailer is required to collect taxes for locations out-of-state. For example, a retailer in Washington would collect and report taxes based on the in-state location where products/services are received (Destination rule). On the other hand, a retailer in Texas would collect and report taxes based on the retailer’s in-state location (Origin rule). For out-of-state sales, the Washington and Texas retailer would need to comply with the rules established in the particular state where products/services are delivered. Most states have established exemption thresholds for smaller retailers (Wayfair) and some states allow for the collection of a single use tax (Texas for example). More discussion about these issues is contained in the Nexus and Sourcing tab.