Skip to content

Sales software and profit reports: joining your sources

Using Sapo, KiotViet, Haravan or Nhanh.vn but no true profit report? What sales software has, what it lacks, and 3 ways to join it with marketplaces and ads.

By The DataxLand team· · 6 min read

Most multi-channel shops already run sales software — in Vietnam that is typically Sapo, KiotViet, Haravan, Nhanh.vn or a similar POS and order-management system. That software holds orders, inventory and customers, and has a built-in reports section. So why do shop owners still open Excel at the end of every month to work out profit?

The short answer: sales software knows a lot about what happens inside the store (orders, products, stock), but it doesn't always know what happens outside the store: marketplace fees finalized after settlement, ad spend on Facebook or TikTok, orders returned after delivery. This post covers what sales software usually has and lacks for a profit and loss report, three ways to join sources, and the joining mistakes that most often skew the numbers.

This post describes the general kind of data sales software holds; it does not review any product. Reporting features and data export options vary by plan and version; check with your vendor.

What sales software usually has, and what it lacks

Data needed for profit and lossSales softwareMarketplaceAd platform
Orders, product lines, discountsYes (in-store, website; marketplace orders if synced)Yes—
Cost of goods, inventory, purchasingUsuallyNo—
Delivery and return statusPartly, depending on the shipping syncYes—
Finalized marketplace feesUsually missing or only estimatedYes, in the settlement—
Ad spendNoIn-marketplace adsYes
Revenue "reported" by adsNoYesYes

The biggest strength of sales software for profit and loss is cost of goods: inventory management usually keeps purchase prices, average cost and purchase history. Marketplaces don't have this. Conversely, finalized marketplace fees only exist in the marketplace settlement, and ad spend only exists in the ad platform. A true profit and loss report needs all three.

Three ways to get data out of sales software

1. Regular Excel exports

Almost every sales software can export order, product and inventory lists to Excel. This is the easiest way to start: export once a week or once a month and keep the same column names between exports. The downside is that it's manual, and one forgotten export is a gap in your numbers.

2. The software's API

Some vendors publish developer APIs. For example, Haravan documents its orders API at docs.haravan.com and Nhanh.vn documents its orders API at apidocs.nhanh.vn (both accessed 16 Nov 2026). Other software may also have an API or a partner integration portal; ask your vendor about access, rate limits and which data is returned. An API allows automatic scheduled refreshes, with no one exporting files.

3. Pulling marketplace orders straight from the marketplace

If your sales software only receives part of a marketplace order's information (often without the finalized fee), pull orders and fees from the marketplace itself, and let the sales software supply only cost of goods and in-store or website orders. This avoids the most discrepancies, but the join needs care (next section).

Four joining mistakes that skew profit and loss

Counting marketplace orders twice

Many sales software products sync orders from Shopee, TikTok Shop and Lazada (the largest marketplaces in Vietnam and South-East Asia) to handle stock. If you take orders from the sales software and also take orders directly from the marketplace, every marketplace order appears twice. The rule: each order has exactly one primary source. Marketplace orders come from the marketplace; from the sales software, take only non-marketplace orders (in-store, website, phone), filtered by the order source column.

Order IDs that don't match

Sales software usually generates its own internal order ID and stores the marketplace order ID in a separate column. When joining marketplace fees to orders, join on the marketplace order ID, not the internal one.

Different SKUs in different places

The same product can carry different codes on the marketplace (variant code), in the sales software (item code) and in the cost-of-goods file. You need a SKU mapping table. An order line whose SKU is missing from the catalog gets no cost of goods — and that line's profit is inflated.

Bundles and free gifts

A bundle sold on a marketplace is one line, but three products leave the warehouse. If cost of goods is looked up by the bundle code and the catalog has no such code, the bundle carries a cost of zero. Declare bundle components, or a separate cost for the bundle code, before calculating profit.

Joining sources step by step

  1. List the sources and their roles: sales software (cost of goods, non-marketplace orders), each marketplace (marketplace orders, finalized fees, returns), ad platforms (spend).
  2. Choose the primary source for each type of order, written down as an explicit filter rule.
  3. Build a SKU mapping table across all places, including bundles.
  4. Standardize order statuses: each source's "delivered", "returned" and "cancelled" mapped to one shared set of statuses.
  5. Join on marketplace order ID and SKU, then check: total orders after the join equals the total from each primary source, nothing extra, nothing missing.
  6. Measure two health metrics before trusting the numbers: what percentage of revenue has cost of goods, and what percentage of fees are still estimated.

Step 6 matters more than it looks. In the DataxLand sample data (a simulated scented-candle shop, 1 Aug – 29 Oct 2026), after joining there are still 3 order lines with SKUs missing from the catalog, and the share of revenue with cost of goods is 92.35%. That means almost 8% of revenue is being counted as if its cost of goods were zero. Knowing that number tells you how much profit is inflated and where the catalog needs fixing.

How DataxLand does it

DataxLand accepts all three routes in the same workspace (see Connect data):

  • exports from your sales software through the Excel source, replacing the file when new numbers arrive;
  • software with a REST API that returns JSON through the custom REST API source: enter the base URL, authentication, endpoint and pagination, then click Try it to see records before adding the source;
  • marketplaces connected directly, for example Shopee, together with ad sources in the connector library.

When you add a new source related to an existing one, you mark the relationship; Si proposes how to join them (which column is the marketplace order ID, which status means a return) for you to approve before anything is built. Checks after every build catch unmatched SKU lines and duplicate rows (see Verified numbers), and the multi-channel profit and loss dashboard shows the share of revenue with cost of goods.

Frequently asked questions

My sales software already has a profit report. Why join anything?

That report usually calculates gross profit from selling price and cost of goods inside the software. It doesn't know finalized marketplace fees, ads outside the software, or return shipping costs, so profit usually comes out higher than reality. Joining sources gives you profit after fees and after ads.

Do I need to replace my sales software?

No. Your sales software remains where you run orders and stock, and it's the best source of cost of goods. The profit and loss report only reads data from it; it doesn't replace it.

What if my software has no API?

Use Excel exports on a fixed schedule and keep the same sheet and column names each time. When your vendor opens an API, switch to automatic refreshes without redoing the mapping from scratch.

Should marketplace orders come from the marketplace or from the sales software?

From the marketplace if you need finalized fees and accurate return status. The sales software works too if it syncs fees and returns fully — but pick only one, to avoid counting orders twice.

Read next: Outgrowing Excel: when you need a data warehouse · How to calculate true profit on Shopee, TikTok Shop and Lazada · Replace manual Excel work

Related posts

Verified dashboards from your own data, this afternoon

Free plan with no time limit · No card required · Sample workspace ready in minutes