Simplified sales accounting in three easy steps

Step 1.

Retrieve detailed and accurate data

From Amazon to Stripe, Dext Commerce fetches itemised transactions from retailers, marketplaces, e-commerce platforms, point of sale systems, payment providers and more.

View Integrations

Step 2.

Consolidate and standardise

Once the data’s been retrieved from multiple platforms, it’s converted into a standardised format, covering sales, expenses, refunds and reimbursements.

Step 3.

Export with ease

Customer details, payment methods, shipping fees, taxes, SKU info and more can all be exported to your Xero or Quickbooks account. Pick and choose the data you want.

Tax-ready, wherever

Split out fees and taxes, for accurate sales figures. Allocate the correct tax rate, whether sales are local or international.

Sales in real time

Stay ahead of cut-off dates, deferred revenue and more, with real-time sales data presented in a standardised view.

Everything itemised

Once transactions are retrieved, the data can be separated into sales, fees, refunds and reimbursements.

Seamless sync

Keep selling on the world’s leading ecommerce platforms and marketplaces, then export your data to your preferred accounting software.

Simplified reporting

The data you need at your fingertips to provide a new level of in-depth reporting, enabling you to make proactive decisions.

Free your time

With less admin and greater data and reporting, you can start to make plans, and future-proof your decisions.

Benefits for Accountants & BookkeepersFree up your time for the important things

Dext Commerce automatically fetches your clients’ sales data from multiple e-commerce and point-of-sale platforms. It splits out transactions, fees, refunds and reimbursements, line by line and allocates the right taxes, whatever the region. All under one subscription.

Dext Commerce Integration Logos

Benefits for Small/Medium BusinessesYou handle the sales, we’ll handle the data

Dext Commerce extracts your expenses and sales data from your ecommerce and point-of-sale platforms, then organises and exports it. All in a single and standardised view. Making all that data much easier to view and analyse.

Dext Commerce Video

What our clients say

“I sell on Amazon, Etsy and Shopify and there is no way I would have been able to do my bookkeeping without it. In my opinion if you sell on any of these platforms this is a must have app!”

“We were able to get our client added and syncing transactions with QBO effortlessly. This saved us a ton of time to get all the transactions (8000+ per month) posted from Shopify.”

“We have linked several marketplaces ebay, amazon, etsy, shopify. Very useful and a huge time saver if your entering all your sales manually. Wish I had found this app sooner.”

FAQs

  • Can I view the country origin or destination?
    In most cases Dext Commerce will have bill to and shipping information (including shipping tracking number in many cases). We can currently use the shipping information to create coding rules as needed. This can come in handy when applying tax rates to transactions based on the destination of an order. We're also working on product updates that will allow us to leverage both the origination of an order and the destination of an order when creating coding rules.
  • How do I deal with Shopify data that contains orders from other platforms?
    Shopify aggregates data from other marketplaces. Dext Commerce acquires all of this data from a connected shopify account. We can separate/map different this other data as needed. The data in Shopify contains a unique marketplaceID that allows us to identify which transaction are native to shopify vs other marketplaces. For example, we can segment and map data for shopify separately from data from Klarna.
  • How can I automate my exports to save more time?
    Auto exports and roll up exports are scheduled exports based on rules that are a great way to setup recurring automation once all accounts have been properly mapped
  • Can I leverage custom attributes from the integration to create rules?
    Yes, in many cases we acquire custom attributes from each marketplace. These attributes can be used to create mapping and transform rules.
  • How do I ensure Dext Commerce is not missing data for a given accounting period?
    The best way to do this today is to review the total transactions and monetary amounts of sales, refunds, costs and reimbursements from a report provided by your marketplace. You can then compare that to the Dext Commerce snapshot report to ensure they match. In the near future we will be building an automated reconcilation service that will identity if your Dext Commerce account is missing data for a given period compared to the reports we are able to extract from the marketplace.
  • How do I map my sales to accounting if i'm not using SKUs?
    SKUs matching is a great way to create a map between the items you sell and the product or services within your accounting file. If you don't use SkUs, Dext Commerce can create rules that reference aspects of your product names to properly map to a chart of account. We can also use rules to simply map all sales to a single product or service or directly to an income/revenue account within your COA.
  • How is my transaction volume calculated?

    When determining your monthly transaction volume, Dext Commerce only counts those transactions that are authoritative in nature; in other words, the original sales or expense occurrence. We understand how difficult it is to predict your sales and expenses, so ancillary transactions like seller-related fees, refunds and reimbursements do not count against your plan's transaction count.

    Sales transactions that are marked as archived, trashed or duplicated (due to a data transform) do not count against your plan's transaction limit either.

  • Which editions of Quickbooks does Dext Commerce support?

    Dext Commerce is currently supported on all QuickBooks Online small business editions including Simple Start, Essentials, Plus and Advanced. At the moment, we do not support QuickBooks Desktop.This integration, however, is currently in the works and will be supported soon in an upcoming roadmap update.

  • How far back can Dext Commerce acquire historical data?

    That varies depending on the integration. For eBay, your data is only stored for 90 days but if your eBay transactions were settled using PayPal, Dext Commerce can back-fill summary level transactions going back three years. If you need Amazon Seller Central transactions older than 90 days, you need to specifically request historical statements from Amazon before Dext Commerce can fetch those transactions. In most cases, Dext Commerce can acquire multiple years of historical data.

  • How does Dext Commerce map sales taxes?

    As you export transactions, Dext Commerce is always learning how best to map transaction data to the appropriate accounts in your accounting file. For sales taxes, we’ll look for previously exported sales transactions that match the postal code of the current transaction and default to the appropriate tax rate/jurisdiction. Sales tax rate mappings can be overwritten at any time by manually defining a different tax rate from the drop menu.

  • Will Dext Commerce create invoices for my sales transactions?

    For QuickBooks Online users, Dext Commerce exports your sales transactions as Sales Receipts (not invoices). There is little difference between the two other than a sales receipt is a more appropriate way of booking sales revenue collected at the time of the sale.

    For Xero Users, we export your sales transactions using one of the following methods, (a) invoice + payment, or (b) direct transaction to a bank account.

  • What payment providers are supported with eBay?

    eBay recently released its own Managed Payments platform with support for more payment options for buyers such as credit, debit, gift cards, Apple Pay, and Google Pay. In addition, eBay will continue to support PayPal and PayPal Credit. Transactions on Dext Commerce that were processed through Managed Payments will be inclusive of sales, payment processing fees, refunds and reimbursements. In those cases where you configure a PayPal payment method external to the eBay Managed Payments service. You will need to connect your PayPal account to Dext Commerce in order to sync your payment processing fees.

  • How do I address Etsy sales from the UK and EU that are missing VAT Taxes?

    Most supported integrations on Dext Commerce will include applicable VAT taxes as a part of your transaction data, with the exception of Etsy. Etsy does not provide tax data for EU sellers.

    Dext Commerce can solve this problem for Etsy sellers using a feature called VAT Transform. VAT transforms, when applied to your Etsy data, transform your transactions by applying the appropriate VAT rate to the transaction, creating a VAT tax line item within the transaction. When exporting the transaction to an accounting program, you can now easily categorise the VAT taxes. For the UK and EU, Dext Commerce will apply a 20% VAT tax rate.

  • Are sales receipts and invoices created by Dext Commerce in my accounting file numbered sequentially?

    Yes, sales receipts and invoices created within your accounting software will leverage the numbering logic within the accounting package itself. In almost all cases, sales receipts are numbered sequentially.

  • Why are some of my most recent Amazon Seller transactions missing?

    The good news is that they’re not missing. Amazon works a bit differently than some other marketplaces as to how they handle their settlements. As an Amazon Seller, your sales accrue over time. While Amazon will sometimes display your sales in certain reports, in reality they only truly remit payment to the Seller after the order is fulfilled. Once the order is marked as fulfilled, only then does Dext Commerce display them as settled transactions.

    This means that the date when the item was purchased and the date we actually show it as settled are often different dates. Dext Commerce always references the actual settlement date in our systems, irrespective of the date when the customer purchased the product on their end.