Date posted: 01/12/2021 5 min read

How to best manage digital sales and point-of-sale data

Find out why having clients selling on multiple digital platforms doesn’t need to be an accounting headache. Brought to you by Dext.

During a time when access to bricks-and-mortar stores is haphazard and reaching customers often means going to where they shop, rather than having them come to you, a multi-channel digital sales strategy is often essential for retailers.

However, such customer convenience frequently results in accounting inconveniences. A client with multiple online platforms and retail points requires more cumbersome journal entries and greater complexity of compliance.

The first and best step to overcoming such challenges is automating manual tasks. This is the value of a digital sales aggregator. It automatically fetches and consolidates sales transaction data from various ecommerce and point-of-sale platforms, streamlines tax compliance and saves accountants valuable time and effort.

Nattika Munro CA, senior practice solutions expert at accounting software provider Dext, says these tools also help accountants become powerful advisers.

“As a former digital adviser, I know clients are looking for more than just compliance services,” she says. “Tools such as Dext Commerce free up valuable time and provide the real-time insights accountants and bookkeepers need to add more value to client relationships.”

What does a digital sales aggregator do?

The right digital sales aggregator simplifies the collection and categorisation of sales data from multiple ecommerce, point-of-sale and payment platforms – Dext Commerce, for example, handles data from platforms including Shopify and Square. The data is consolidated and standardised in the platform and transferred directly into software such as Xero or Quickbooks via a seamless integration.

“It connects sales platforms together in one place, which simplifies workflows and provides real-time reconciliation so, as advisers, we can accurately assess cut-off dates, cash and accrual based accounting methods and deferred revenue,” says Munro.

Beyond providing a single source of truth for all your information, the right digital sales aggregator can also capture all the line-by-line financial data attributed to a transaction, says Munro.

“This means accountants don’t need to spend time on tedious tasks like capturing the right amounts of GST.”

“Accountants don’t need to spend time on tedious tasks like capturing the right amounts of GST.”
Nattika Munro CA, Dext

Cross-border sales are a wonderful way to expand your customer base, but also add a layer of complexity to tax compliance.

This, too, can be simplified through automation. The correct domestic or international tax rates can be applied at the point of sale.

Munro says that solutions such as Dext Commerce allow users to set rules for handling default tax settings, including region or market data fields that your accounting platform may not handle.

“For example, if an Australian-based retailer is selling in the UK or US, the platform can show whether GST needs to be attributed, so accountants can properly address tax compliance.”

How does a digital sales aggregator benefit accountants?

The ultimate value of a single platform is that, after doing all of the above, the platform provides greater visibility of client data, which can be analysed to provide useful business information.

“Being able to see who a client’s customers are and what products those customers are buying, for instance, allows accountants to provide deeper analysis and advice,” says Munro.

“Digital sales aggregators take away the manual, time consuming, tedious task of attributing the right revenue, the right tax for the right region and the associated fees that come with individual transactions. With this kind of platform in place, an accountant can be more productive, provide more valuable insights, and be in a position to service digital sales clients.”

Find out more:

Want to learn more about how to handle digital sales data for your clients? Scan the QR code or visit