EN
e-Invoice and Tax

How Do You Check a Shipping Invoice? A Guide to Desi Differences, Duplicate Items, Return Shipping and Reconciling Extra Services

How do you check a shipping invoice? Shipment matching, desi differences, duplicate items, return shipping and add-on service fee checks: an 8-lesson guide with examples.

Contents 14 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: Why should a shipping invoice be checked line by line?
  3. Lesson 2: How do you prepare the data for the check?
  4. Lesson 3: How do you calculate the expected shipping cost?
  5. Lesson 4: How do you find and prove a desi difference?
  6. Lesson 5: How do you catch a duplicate item?
  7. Lesson 6: How do you check return and returned-shipment charges?
  8. Lesson 7: How do you check add-on services and off-tariff items?
  9. Lesson 8: How do you prepare a dispute file and set up a monthly routine?
  10. What are the most common mistakes in checking shipping invoices?
  11. How does NetKasam make tracking shipping expenses easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Match this month's shipping invoice line by line
  14. Frequently Asked Questions About Checking Shipping Invoices

At the end of the month, the invoice arrives from the carrier: ₺62,400. You approve the payment, because "that's just what shipping invoices look like." Yet according to your records, the packages you sent this month total ₺59,000 at the agreed rates. The ₺3,400 (5.8%) gap could come from a desi difference, a shipment invoiced twice, or a return transport that never actually happened. Nobody has to make a deliberate mistake; differences like these are a natural part of shipping operations. But unless they are checked, the same error is quietly paid every month.

This article is not an overview but an 8-lesson hands-on training. It answers the question how do you check a shipping invoice with numbers; working through a month of 1,000 shipments, we will cover matching invoice lines with your own shipment records, desi differences, duplicate items, return and returned-shipment charges, off-tariff add-on services, preparing a dispute file and the monthly check routine. There is a mini quiz at the end. How to make a shipping agreement is a separate topic; here we start from the point where the agreement is in place and the invoice has arrived. For the concept of desi, see the article how to calculate desi.

What will you be able to do by the end of this training?

In short: You will match the shipping invoice with your own shipment records, separate out desi differences, duplicate items, return and add-on service charges, prepare a dispute file and set up a monthly check routine.

Training mapThe six steps of checking a shipping invoice
  1. 01
    DataPull the invoice lines and your own shipment records for the same period.
  2. 02
    MatchingMatch shipments by tracking number.
  3. 03
    ExpectedCalculate the expected amount for each shipment based on its desi and rate.
  4. 04
    DifferenceBreak down the difference between the invoice and the expected amount by item.
  5. 05
    DisputePrepare a dispute file with evidence for the differing items.
  6. 06
    PreventionPrevent recurrence by correcting desi records and return records.

The training's 8 lessons: (1) why a shipping invoice should be checked, (2) data preparation, (3) expected cost, (4) desi differences, (5) duplicate items, (6) return and returned-shipment charges, (7) add-on services and off-tariff items, (8) dispute file and monthly routine.

Lesson 1: Why should a shipping invoice be checked line by line?

In short: Shipping is one of the biggest expense items in e-commerce, and the invoice consists of thousands of lines. When small differences repeat every month, they turn into a significant annual loss; checking line by line is the only way to catch this loss.

Difference typeWhy does it happen?How to check
Desi differenceThe carrier's measurement is larger than your recordCompare the recorded desi with the desi on the invoice
Duplicate itemThe same shipment was invoiced twiceFind duplicates by tracking number
Returns and returned shipmentsReturn charges exceed your return recordsMatch your return records with the returns on the invoice
Add-on serviceA service fee not in the rate cardCompare with the contract rate card
Wrong region or rateThe shipment was charged for the wrong regionDelivery address and regional rate

To know the share of total shipping expense per order, see the article how to calculate net profit on a marketplace. For what to watch out for before making a shipping agreement, see the articles that cover it as a separate topic; this training covers what happens after the invoice.

Lesson 2: How do you prepare the data for the check?

In short: The check requires two lists: the carrier's invoice lines and your shipment records. Bring them together in the same table using a common key such as the tracking number.

  1. Request the invoice attachment: Get the line breakdown (tracking no., date, desi, amount, service type) from the carrier as an Excel file.
  2. Pull your own records: Shipments in the same period: order, tracking number, recorded desi, rate.
  3. Align the period: The billing period and shipment dates should fall in the same range.
  4. Set the key: The tracking number is the primary key; the order number is secondary.
  5. Keep the contract rate card alongside: Unit fees by desi band and add-on service fees.

In NetKasam, you can send your orders to the carrier with a single click, create barcodes and manage your shipping costs with full visibility from A to Z; you can enter your shipments into the system via Excel or manually (shipping integration). This way, the tracking number, order and cost sit in the same place. For how orders are prepared, see the article order picking and packing.

Product pageFree Bookkeeping Software

Lesson 3: How do you calculate the expected shipping cost?

In short: Expected cost = the agreed rate corresponding to each shipment's recorded desi. The sum of these is the reference you will compare the invoice against.

FormulaSix formulas for checking a shipping invoice
  1. Expected cost = Σ (Agreed rate based on recorded desi)
  2. Invoice difference = Invoice amount − Expected cost
  3. Difference rate = Invoice difference ÷ Expected cost
  4. Desi difference charge = Shipment count × (Rate on invoice − Recorded rate)
  5. Duplicate charge = Duplicated shipment count × Shipment fee
  6. Shipping cost per shipment = Shipping invoice ÷ Shipment count

The rate is the value in your agreement; the fees used in the examples are only for illustrating the method.

Example month: 1,000 shipments, invoice ₺62,400 (excluding VAT). With the desi in your records and the agreed rates, the expected cost comes to ₺59,000. The difference is ₺3,400, and the difference rate is 3,400 ÷ 59,000 = 5.8%.

Lesson 4: How do you find and prove a desi difference?

In short: A desi difference is when the desi measured by the carrier is larger than the desi in your record. If you record your own measurement at packing time, you can prove the difference; if you don't, the dispute comes down to the carrier's measurement.

ShipmentRecorded dimensionsRecorded desiDesi on invoiceRate difference
Sample package30 × 20 × 10 cm6.000 ÷ 3.000 = 23₺13 more on the invoice

In the example, 120 shipments were charged at 3 desi (₺58) on the invoice instead of the recorded 2 desi (₺45); the difference is ₺13 per shipment, for a total of 120 × 13 = ₺1,560. The causes can vary: the box bulging out, the carrier's measurement tolerance or an incorrect record. The solution works both ways: keep your own records accurate (width, length and height at packing time) and clarify the desi rounding rule in the contract. To review the desi rate card, you can use the desi calculator.

Recommended ReadingHow Do You Calculate Desi?

Lesson 5: How do you catch a duplicate item?

In short: A duplicate item is when the same shipment appears twice on the invoice. By counting by tracking number, you can easily find duplicates.

  1. Import the invoice breakdown into Excel.
  2. Flag duplicates in the tracking number column.
  3. Check the date and amount: If it has the same tracking number, same amount and same date, it is a duplicate.
  4. If the amounts differ, separate them: The same number may be two different services (shipment and return); that is not a duplicate.
  5. Write down the total: The duplicate charge goes into the dispute file.

In the example, 10 shipments were invoiced twice: 10 × ₺55 = ₺550. Duplicate items usually stem from system errors; once documented, the dispute is easily accepted.

Lesson 6: How do you check return and returned-shipment charges?

In short: Match the return shipments on the invoice (customer returns, undeliverable) with your own return and cancellation records. A return not in your records is grounds for a dispute.

Return typeIn your recordsOn the invoiceDifference
Customer return25 returns25 returns0
Undeliverable / address error015 returned shipments15 returned shipments: 15 × 55 = ₺825 not in records

The invoice shows 40 returned shipments, but your records show 25 returns. The reason for the other 15 (address error, customer refusal or carrier return) is investigated. For a returned shipment not in your records, ask the carrier for the delivery report and the reason for return. For the return process itself, see the articles how to cancel an order and how to issue a return invoice. Reducing address errors starts with verifying the address at the time of order.

Lesson 7: How do you check add-on services and off-tariff items?

In short: Every add-on service on the invoice (cash-on-delivery fee, door-to-door delivery, regional surcharge, fuel surcharge, etc.) must be written in your contract rate card. An item not written there or applied at an off-tariff rate is grounds for a dispute.

ItemControlSample problem
Cash-on-delivery feeBased on the collection amount and the rate in the contractApplied even though the service was not provided
Regional surchargeDelivery address and region listWrong region
Add-on serviceRate card annexed to the contractService not in the rate card
Price updateBilling period and effective dateThe new rate was applied to shipments from the previous period

In the example, the off-tariff add-on service charge came to ₺465. On the cash-on-delivery and cash flow side, this service must match the recorded collection; the matching logic in the bank reconciliation article applies here too.

ChartFrom the expected shipping cost of ₺59,000 to the invoiced ₺62,400: the difference comes from four items
  1. Expected cost (record × rate)₺59,000
  2. Desi difference (120 shipments × ₺13)₺1,560
  3. Duplicate item (10 shipments × ₺55)₺550
  4. Returns not in records (15 shipments × ₺55)₺825
  5. Off-tariff add-on service₺465
  6. Amount on the invoice₺62,400

Prepared with sample values. Difference ₺3,400, difference rate 5.8%.

ChartComponents of the invoice difference: desi difference is the largest share
  1. Desi difference₺1,560
  2. Returns not in records₺825
  3. Duplicate item₺550
  4. Off-tariff add-on service₺465

Prepared with sample values. Total ₺3,400.

Lesson 8: How do you prepare a dispute file and set up a monthly routine?

In short: A dispute is made with evidence: tracking number, recorded desi and dimensions, rate card clause and the difference amount. Apply in writing within the dispute period in the contract; missing the deadline may forfeit your right.

Disputed itemEvidenceRequest
Desi differenceDimensions recorded at packing time, photo, rate card clauseCorrection based on recorded desi
Duplicate itemTwo lines with the same tracking numberCancellation of the duplicated line
Returns not in recordsYour own return record, request for the delivery reportReason for return and justification, cancellation if needed
Off-tariff add-on serviceContract rate cardCancellation or refund
When?What to do?Who?
On every shipmentRecord the dimensions (width, length, height), desi and tracking numberWarehouse
Every weekCompare the shipment count with the carrier's summary statementWarehouse, accounting
When the invoice arrivesLine matching, difference table, dispute fileAccounting
When the invoice arrives (within the deadline)Submit the dispute in writing; pay the undisputed portionManager
Once a quarterMonitor the difference rate, review the rate card and agreementManagement
Takeaways from the exampleFour numbers from the sample shipping invoice
  • ₺3,400difference between the invoice and the expected cost
  • 5.8%difference rate (3,400 ÷ 59,000)
  • ₺1,560desi difference (the largest item)
  • ₺62.40shipping cost per shipment (62,400 ÷ 1,000)

The dispute period and procedure are stated in your contract; if there is a legal dispute, consult your legal advisor. To see how your monthly shipping expense affects product margin, see the article how to calculate profit margin.

What are the most common mistakes in checking shipping invoices?

  1. Paying the invoice without checking. The same error repeats every month.
  2. Not recording desi measurements. You have no evidence against the carrier's measurement.
  3. Not keeping return records. You cannot verify return charges.
  4. Not keeping the contract rate card at hand. Add-on service differences go unnoticed.
  5. Missing the dispute deadline. You may lose your right.
  6. Rejecting the entire invoice. The undisputed portion is paid, and disputed items are handled separately.
  7. Looking only at the total amount. Errors that cancel each other out stay invisible.

How does NetKasam make tracking shipping expenses easier?

  • One click from order to carrier. You send your orders to the carrier, create the barcode and pass tracking information to the customer (shipping integration).
  • Seeing shipping costs. You manage your shipping costs with full visibility from A to Z.
  • Excel and manual data entry. You can enter your shipments into the system via Excel or manually.
  • Regional management. With region, province, district or customer-based definitions, you ensure the most suitable carrier is selected.
  • Status tracking and sharing. You monitor shipping status and share the tracking link via WhatsApp, SMS or email.
  • Fast bulk processing. You hand your orders to the carrier in bulk (order management).
  • Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.

Mini quiz: Test what you have learned

In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.

  1. If the invoice is ₺41,000 and the expected cost is ₺38,500, what are the difference and the difference rate?
  2. If the rate on the invoice is ₺8 higher than recorded for 200 shipments, what is the desi difference charge?
  3. What is the desi of a 45 × 30 × 15 cm package (divided by 3,000)?
  4. Are two lines with the same tracking number always duplicates?
  5. How do you calculate the shipping cost per shipment?

Answer key:

  1. 41.000 − 38.500 = 2.500 ₺; 2.500 ÷ 38.500 = %6,5.
  2. 200 × 8 = 1.600 ₺.
  3. 45 × 30 × 15 = 20,250; 20,250 ÷ 3,000 = 6.75 desi.
  4. No; they may be different services (shipment and return). Look at the amount, date and service type.
  5. Shipping invoice divided by shipment count (62,400 ÷ 1,000 = ₺62.40).

Frequently Asked Questions About Checking Shipping Invoices

How do you check a shipping invoice?

Invoice lines are matched with your own shipment records by tracking number, the expected amount is calculated for each shipment based on the recorded desi, and the difference between the invoice and the expected amount is broken down by item.

How do you dispute a desi difference?

You submit a written dispute with the dimensions and desi recorded at packing time, the rate card clause and the tracking number. If you don't keep records, you have no evidence against the carrier's measurement.

How do you find duplicate shipping charges?

The invoice breakdown is imported into Excel and duplicates in the tracking number column are flagged. The same number, date and amount count as a duplicate.

How do I verify return shipping charges?

You match the return shipments on the invoice with your own return and cancellation records. For a return not in your records, ask for the delivery report and the reason for return.

How long do you have to file a dispute?

The dispute period is stated in your shipping contract. You need to apply in writing within that period; for legal disputes, consult your legal advisor.

Can I pay the invoice partially?

The undisputed portion is usually paid, and disputed items are handled separately in writing. This procedure depends on your contract.

How do you calculate the shipping cost per shipment?

It is found by dividing the shipping invoice by the number of shipments. For a ₺62,400 invoice and 1,000 shipments, it is ₺62.40.

Can I see shipping costs in NetKasam?

Yes. NetKasam lets you manage your shipping costs with full visibility from A to Z; you can also enter your shipments into the system via Excel or manually.

Conclusion: Match this month's shipping invoice line by line

Checking a shipping invoice may take half a day the first time; by the second month it drops to hours, and by the third to minutes. This month, request the invoice breakdown as an Excel file, match your shipment records by tracking number, break the difference down into four items and prepare a dispute file for the largest item. To keep the same error from repeating in the following months, start organizing your desi and return records today.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeFree Bookkeeping Software

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools