Skip to main content
Unicart+ / Topic 17 of 19

How to Reconcile Marketplace Settlements Using Bulk Knock Off

Implementation steps, settings and original screenshots from the SiteGiant ERP–AutoCount integration guide.

When to Do Bulk Knock Off

Bulk Knock Off compares the marketplace Statement Amount with the AutoCount Invoice Outstanding Amount. Proceed only when the marketplace settlement is available and the related AutoCount Invoice already exists.

Settlement commonly takes around 2 weeks or longer to process. Two weeks is a reference, not a fixed minimum.

Situation & Action Guide

ResultMeaningWhat to Do
MatchStatement Amount matches Invoice Outstanding Amount.Confirm and complete Bulk Knock Off.
Not MatchStatement Amount and Invoice Outstanding Amount are different.Check the reason before continuing.

Questions to Ask the Client

  1. Has the marketplace already released the settlement?
  2. Does the related AutoCount Invoice already exist?
  3. If the result is Not Match, what caused the difference?

Detailed Steps — Bulk Knock Off

  1. Export the required settlement statement from the marketplace or SiteGiant.
  2. Open A/R Received Payment and select the correct Debtor.
  3. Click Bulk Knock Off and download the Bulk Knock Off Excel Template.
  4. Enter the required Order ID / Marketplace ID and Statement Amount in the template.
  5. In Bulk Knock Off, select Match Against → Order ID or Marketplace ID.
  6. Copy prepared records from the Excel template and click Paste from Clipboard.
  7. Check the result: Match → proceed; Not Match → check the reason first using the scenario guide below.
  8. Select the records that are ready and click Confirm.
  9. Back in A/R Payment, select the correct Payment Method.
  10. Update Payment Amount = Unapplied Amount.
  11. Check the payment details and click Save.
  12. If prompted to create an A/R Credit Note, check the Not Match amount, account and related Invoice before saving the CN.
Original Unicart+ software screenshot, PDF page 62, image 1
Original screenshot · PDF page 62 · Click to enlarge
Original Unicart+ software screenshot, PDF page 62 image 2
Original screenshot · PDF page 62 · Click to enlarge
Original Unicart+ software screenshot, PDF page 63, image 1
Original screenshot · PDF page 63 · Click to enlarge
Original Unicart+ software screenshot, PDF page 63, image 2
Original screenshot · PDF page 63 · Click to enlarge
Original Unicart+ software screenshot, PDF page 63, image 3
Original screenshot · PDF page 63 · Click to enlarge
Original Unicart+ software screenshot, PDF page 63, image 4
Original screenshot · PDF page 63 · Click to enlarge
Original Unicart+ software screenshot, PDF page 63 image 5
Original screenshot · PDF page 63 · Click to enlarge
Original Unicart+ software screenshot, PDF page 64, image 1
Original screenshot · PDF page 64 · Click to enlarge

How to Export the Income Statement

The original manual lists these guides for obtaining an income statement or viewing marketplace reconciliation details:

SourceGuide Title in the PDF
Marketplace Seller Centre — Shopee, Lazada or TikTokHow To Retrieve Income Statement From Marketplaces
SiteGiant — ShopeeHow To Use Shopee Payment Reconciliation
SiteGiant — LazadaHow To Use Lazada Payment Reconciliation
SiteGiant — TikTokHow To Use TikTok Payment Reconciliation

How to Handle Not Match

When Bulk Knock Off shows Not Match, identify the reason before continuing.

Not Match SituationWhat Staff Should Do
Order / settlement still pendingUse Pull Order → Bulk Inquiry for the latest order. If still pending or incomplete, select Ignore and check later.
Cancelled / Returned / Lost or DamagedCheck the latest status in Pull Order and refer to Topic 16. Check whether a CN already exists. Do not create another CN.
Statement Amount = 0 / Marketplace RefundConfirm the refund with the marketplace and check for an existing CN. If refund is confirmed and no CN exists: leave status Not Match → Confirm → save A/R Payment → process the prompted A/R CN.
Marketplace fee / charge missingCheck and correct Summary Code → Repost Order → run Bulk Knock Off again.
Other valid differenceConfirm reason and accounting treatment with client / accountant, select correct Not Match action, and process prompted A/R CN if required.
Reason unknownDo not force knock off. Select Ignore and investigate first.

Example Scenario — Marketplace Refund Not Updated to SiteGiant

Order IDInvoice OutstandingStatement AmountStatus
ORD001RM100RM0Not Match
ORD002RM80RM0Not Match
ORD003RM120RM0Not Match

How to Handle Negative Settlement

A negative settlement occurs when marketplace deductions for refunds, fees or other charges exceed the seller’s available settlement amount.

Important Steps

  1. Separate negative records from the settlement Excel file.
  2. Check each record in the marketplace to confirm whether it is a completed refund.
  3. For a confirmed refund, paste the separated Excel data into A/R Credit Note → Bulk Knock Off and set Action to Follow Outstanding Amount to process the full refund.
  4. After the full Invoice amount is refunded, check the remaining negative settlement amount. This represents extra marketplace fees or charges already deducted.
  5. Total the remaining negative amount and record it separately using a Payment Voucher or Journal Voucher as an expense.

Returned Item

Check whether the refunded item was returned and is still sellable.

Returned Item StatusAction
Item is sellableRecord Stock In in the system used as the Stock Master.
Item is damaged, lost or not sellableDo not record the item as sellable stock.

AutoCount Stock Master: Record Stock In in AutoCount and synchronize the updated stock to SiteGiant.

SiteGiant Stock Master: Record Stock In in SiteGiant.

Original Unicart+ software screenshot, PDF page 66, image 1
Original screenshot · PDF page 66 · Click to enlarge
Original Unicart+ software screenshot, PDF page 66, image 2
Original screenshot · PDF page 66 · Click to enlarge

Additional Note — Auto Create CN for Not Match

Go to Unicart+ → General Settings → General and enable Auto create CN if any ‘Not Match’ record in AR Payment bulk knock off.

When enabled, saving an A/R Payment containing Not Match records can open the A/R Credit Note screen for further checking and processing.

Original Unicart+ software screenshot, PDF page 67, image 1
Original screenshot · PDF page 67 · Click to enlarge

Troubleshooting / Common Errors

IssueWhat to Do
Bulk Knock Off cannot be clickedSelect Debtor first. If still unavailable, check user’s access rights.
Paste from Clipboard cannot match orderCheck Order ID / Marketplace ID and Excel template.
A/R CN does not open after savingCheck that Auto create CN if any ‘Not Match’ is enabled.
A/R Payment cannot save / amount wrongCheck Payment Method and ensure Payment Amount = Unapplied Amount.