eCommerce accounting tool for online sellers

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.