Managing digital sales data just got simpler
Created for bookkeepers, accountants and businesses, Dext Commerce's accounting automation software provides the data, insight and tools for companies to thrive.
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.
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 e-commerce 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.
What our clients say
FAQs
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.
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.
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
Yes, in many cases we acquire custom attributes from each marketplace. These attributes can be used to create mapping and transform rules.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.