Jan 112 min read

Integrating Your Ecommerce App with QuickBooks Online: A How-To Guide for Marketplace Facilitators and Payment Processors "Sellers Data Gold"

Updated: Jul 9

Ecommerce app mapping to QuickBooks Online: What every seller needs to know.

Location: in QuickBooks Online is Origin (warehouse, inventory, store, business office, employees, tradeshow, sellers location)

Sales Tax NEXUS Tracking

QuickBooks first checks Ship to (destination) then Ship From (origin)

States that follow an origin-based sales tax system (charge at the rate of the seller's location) include:

Origin Based Sale Tax System	NOMAD States-No Sales Tax
Arizona	New Hampshire
Illinois	Oregon
Mississippi	Montana
Missouri	Alaska
New Mexico	Delaware
Ohio
Pennsylvania
Tennessee
Texas
Utah

Items: Products and Services in QuickBooks Online are:

Inventory Products
Non-Inventory Products *for Shipping Income (check local jurisdiction laws)
Services
Bundles (Multi-Product)

Items are associated with a (select one or both, purchase or sell)

Inventory Asset
Income-Sales Price (taxable or non-taxable)
Expense-Purchase Price (or COGS or COS) *optional Vendor Name and SKU
Sales Tax (Taxable based on location of the buyer (ship to-destination) or default to origin based, or custom rate.
Quantity of items in stock

Category Other Fees: (Service Expense Item: Cost of Sales)

(Setup items for the income statement categories below)

Payment Processing Fees
Platform or Marketplace Fees
Shipping Fees
Currency Conversion Fees
Return and Refund Fees
Subscription or Membership Fees
Integration Fees
Advertising Fees
Storage Fees
Discounts and Refunds (contra income)
et......

Customer Name: A critical component of any business

(Tax Exempt Requires a Tax Exempt or Resale Certificate)

1. Revenue Generation

2. Profitability

3. Brand Reputation

4. Market Feedback

5. Brand Loyalty

6. Business Growth

7. Adaptability

8. Competitive Advantage

9. Repeat Business

10. Customer-Centric Culture

Payment Method:

Cash
Credit Card
On Account (Accounts Receivable/Invoice, not Sales Receipt)
Crypto Currency

Document Mapping:

1. Data import to a Sales Receipt, deposited to undeposited funds, per sale

(or per day: batch close).

2. Followed by a deposit to your bank account and bank feed matching!

*Sale receipts-sales tax is due on receipt, even if funds are undeposited.

3. If Products and Service Items are returned a Credit Memo should be issued following the same steps as above on the sales receipt and applied to the correct customer transaction.