- EBMS Knowledge Base
- Sales
- Sales and Use Tax | TaxJar
-
Client Resources
-
EBMS Main Documentation
- Introduction
- Getting Started
- Getting Started | Initial Installation
- Getting Started | Company Setup
- Quick User Guide | Financial Staff | Accountant
- Quick User Guide | Financial Staff | Accountant | Accountants Journal
- Quick User Guide | Sales Staff
- Quick User Guide | General Staff
- Features
- Reports
- Reports | Excel Add-In
- Reports | Excel Add-In | Troubleshooting
- Security
- Server Manager
- Technical
- Technical | Data Import and Export Utility
- Technical | SQL Mirror
- Automotive
- Automotive | Parts Catalog
- Automotive | Pricing
- Automotive | Point of Sale
- Automotive | Product Application
- Automotive | Keystone Interface
- Metal Supply
- Fuel Sales
- Horticulture
- Horticulture | Farm Setup
- Horticulture | Processing Payroll
- Horticulture | Managing the Farm
-
Sales
- Introduction
- Customers
- Customers | Miscellaneous Customers
- Proposals
- Proposals | Processing Proposals
- Proposals | Sets and Templates
- MyProposals
- MyOrders
- Sales Orders
- Invoices
- Materials Lists
- Sales and Use Tax
- Sales and Use Tax | TaxJar
- CRM
- CRM | Auto Send
- Recurring Billing
- Credits
- Customer Payments
- Payment Card Processing
- Payment Card Processing | Gift Cards
- Payment Card Processing | Loyalty Cards
- Payment Card Processing | Verifone Gateway
- Freight and Shipping Tools
- General Ledger Transactions
- Point of Sale
- Point of Sale | Point of Sale Hardware
- Point of Sale | Xpress POS System
- Point of Sale | Advanced Tools
- Signature Capture
- Salesperson Commissions
-
Inventory
- Product Catalog
- Product Catalog | Using Product Codes for No Count Items
- Product Pricing
- Product Pricing | Special Pricing
- Tracking Counts
- Unit of Measure
- Purchasing
- Special Orders and Drop Shipped Items
- Receiving Product
- Barcodes
- MyInventory and Scanner
- Components (BOM) and Accessories
- Components (BOM) and Accessories | Component Formula Tool
- Made-to-Order Kitting
- Configure-to-Order Kitting
- Multiple Inventory Locations
- Multiple Inventory Locations | Creating Locations
- Multiple Inventory Locations | Using Multiple Locations
- Multiple Inventory Locations | Product Catalog Sync
- Multi-Vendor Catalog
- Serialized Items
- Serialized Items | Purchasing or Manufacturing an Item
- Serialized Items | Selling and/or Associating an item with a customer
- Lots
- Product Attributes
- Product Attributes | Selling and Purchasing Items with Attributes
- Product Attributes | Custom Attributes
- Mobile Scanner (Legacy)
-
Labor
- Getting Started
- Workers
- Taxes and Deductions
- Work Codes
- Time and Attendance
- Time and Attendance | Time Track App
- Processing Payroll
- Closing the Payroll Year
- Processing Payroll - Advanced
- Salaried Pay
- Piecework Pay
- Direct Deposit
- 3rd Party Payroll Service
- Subcontract Workers
- Flag Pay
- Prevailing Wages
- MyDispatch
- MyTasks
- MyTime
- MyTime | Communications
- MyTime | Setup
- Tasks
- Tasks | Getting Started
- Tasks | Creating Tasks
- Tasks | Scheduling Tasks
- Tasks | Customizing Task Views
- Tasks | Managing Tasks
-
Financials
- Introduction
- Fiscal Year
- Chart of Accounts
- Budget
- Financial Reporting
- Transactions and Journals
- Transactions and Journals | Journals
- Account Reconciliation
- 1099
- Departments and Profit Centers
- Fund Accounts
- Bank Accounts
- Bank Feed
- Vendors
- Vendors | Miscellaneous Vendors
- Purchase Orders
- Expense Invoices
- Vendor Payments
- AP Transactions
- Landed Cost
- Fixed Assets and Depreciation
- Fixed Assets and Depreciation | Fixed Assets
- Fixed Assets and Depreciation | Fixed Assets | Adding Assets
- Fixed Assets and Depreciation | Processing Depreciation
- Fixed Assets and Depreciation | Disposing Assets
- MyJobs
-
E-commerce
-
Rental
-
Job Costing
-
Manufacturing
Upload Data for Reporting and Filing
The sales data must be uploaded to TaxJar to calculate the sales tax filing reports. This step is needed to display the taxable gross amounts and the tax amounts for individual juri strict ions.
EBMS uploads this data to TaxJar using a CSV file. TaxJar does connect directly to various e-commerce shopping carts such as Bigcommerce, Amazon, Woo commerce, Shopify, PayPal, and others.
Complete the following steps to upload sales tax information in a monthly basis.
-
Open the www.TaxJar.com website and log into the TaxJar account. Review Overview for more TaxJar details.
-
Select Sales > Create TaxJar CSV File from the main EBMS menu
-
Click Yes to export the TaxJar tax transactions to a CSV file. Note the file name and location in the resulting dialog:
-
Click on the website Transactions page of the TaxJar account web page as shown below:
-
Click on the Actions menu and select the Add new data source option to open the following page:
-
Select the Choose File button and locate the file and path displayed on the EBMS dialog in step #3:
-
Click on the Upload spreadsheet button to pull data from CSV spreadsheet file into the TaxJar website as shown below:
-
Click on the Dashboard or Transactions page on the website to see results of the imported Transactions after each file import status shows completed. The website processing may take 30 minutes to an hour to import the transactions and summarize your tax reports.
TaxJar Reports
Click on the Dashboard page to view the tax liability summaries. Select the date range on the top right side of the page. 
Click on the Sales Tax Report link to review the tax report for individual states. Sales Tax Report that has all of the data required file each state's return. Because each state’s return form is different, the TaxJar Report for each state may vary, but there are a few details found in each Sales Tax Report:
The Actual Report shows your gross sales, sales by jurisdiction, and the actual sales tax that you collected during this time period.
The Expected Report shows your gross sales, sales by jurisdiction and TaxJar’s estimate of the sales tax that you should have collected during this time period.
The following jurisdiction breakdown will show if a state requires sales to be reported by city, state, or county.
Click View transactions to view a list of the transactions included in this Report.
Click View Gross Sales from All States to see the Gross Sales total in all states