EN
e-Invoice and Tax

How to Find Uninvoiced Orders: Order and Invoice Matching, Channel Breakdown, Aging, and Correction Training

How to find uninvoiced orders? Order and invoice list matching, channel and cause breakdown, aging, and the correction flow: an 8-lesson guide with examples.

Contents 15 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: What is an uninvoiced order?
  3. Lesson 2: How do you prepare the lists?
  4. Lesson 3: How do you match and calculate the difference?
  5. Lesson 4: Which channel is missing invoices?
  6. Lesson 5: Why was the invoice not issued?
  7. Lesson 6: How long have uninvoiced orders waited and how much are they worth?
  8. Lesson 7: How do you make the correction?
  9. Lesson 8: How do you run the check regularly?
  10. Which situations confuse the matching?
  11. What are the most common mistakes when checking for uninvoiced orders?
  12. How does NetKasam reduce the uninvoiced order problem?
  13. Mini quiz: Test what you have learned
  14. Conclusion: Make every order's invoice easy to find
  15. Frequently Asked Questions About Uninvoiced Orders

At month end your accountant says "I saw this many invoices," you say "I shipped this many orders," and the two numbers do not match. The gap is often small: 20, 40, 60 orders. But each one is a transaction where a sale was made, the parcel shipped, the money collected, and no invoice issued. If the gap goes unnoticed, the VAT return is incomplete, and a fix has to be found when a customer or marketplace asks for an invoice.

This article is not a narrative but an 8-lesson hands-on course. We will answer how to find uninvoiced orders using an example multichannel store with 1,560 order records a month: matching order and invoice counts, channel and cause breakdown, aging, amount impact, the correction flow, and a lasting fix. At the end there is a mini quiz and an answer key. All figures are example values chosen to demonstrate the method; for tax rates and invoice deadlines, refer to the legislation and your certified public accountant (mali müşavir).

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

In short: You will match order and invoice lists to find uninvoiced orders, classify their causes, fix them, and prevent them from recurring.

Course mapSix steps of the uninvoiced order check
  1. 01
    ListPull the period's order and invoice lists.
  2. 02
    FilterRemove orders that do not need an invoice (cancellations).
  3. 03
    MatchLink each invoice to its order by order number.
  4. 04
    ClassifySplit the remaining orders by channel and cause.
  5. 05
    FixIssue the missing invoices or document the reason.
  6. 06
    PreventClose the cause at its source.

The course has 8 lessons: (1) what an uninvoiced order is, (2) preparing the lists, (3) matching and the difference, (4) channel breakdown, (5) cause analysis, (6) aging and amount impact, (7) the correction flow, (8) regular checks.

Lesson 1: What is an uninvoiced order?

In short: It is an order that should be invoiced but has no invoice linked in the system; it is not an unrecorded sale but, most of the time, an overlooked one.

An order lives in two places: in the order system and in the invoice records. These two records need to be linked. An uninvoiced order is one where the first exists and the second does not. The cause is rarely intentional; it is usually a delayed payment confirmation, missing customer details, an integration error, or a forgotten manual order. The result is still the same: there is a revenue record but no invoice.

Orders that do not need an invoice are kept separate: cancelled orders and orders that were not delivered and refunded, for example. So the first job is to define the set of "orders that should be invoiced" correctly. For the general framework on invoice deadlines, see the article within how many days is an invoice issued; for the difference between e-Invoice and e-Archive invoice, see the terms e-Invoice and e-Archive invoice.

Lesson 2: How do you prepare the lists?

In short: Pull the order list and the invoice list for the same period with a common order number field; mark cancellations and returns separately.

ListFields it should contain
Order listOrder no., channel, date, status (delivered/cancelled/returned), amount
Invoice listInvoice no., linked order no., date, amount, type (e-Invoice/e-Archive invoice)

Watch for the period-end effect: an order placed on the 30th may be invoiced on the 1st. Run the matching a few days after the month closes, including the first days of the next month. For the closing routine, see the article how to do the month-end close.

If invoice records have no order number, matching gets harder. In that case you can use customer name, amount, and date together, but the margin of error is high; the lasting fix is to generate the invoice automatically from the order. That is covered in Lessons 7 and 8.

Product pageFree Bookkeeping Software

Lesson 3: How do you match and calculate the difference?

In short: Subtract cancellations from the total order records, then subtract the invoiced count; the remainder is the uninvoiced orders.

FormulaUninvoiced order and rate formulas
  1. Orders to be invoiced = Total order records − Cancelled and returned
  2. Uninvoiced orders = Orders to be invoiced − Invoiced orders
  3. Uninvoiced rate = Uninvoiced ÷ Orders to be invoiced
  4. Uninvoiced amount = Sum of uninvoiced order amounts
ChartMatching from order records down to uninvoiced orders
  1. Total order records in the period1,560 orders
  2. Cancelled orders−60 orders
  3. Orders that have an invoice−1,455 orders
  4. Uninvoiced orders45 orders

Prepared with example values. Calculation: 1,560 − 60 − 1,455 = 45. Uninvoiced rate 45 ÷ 1,500 = 3%.

In the example, orders to be invoiced are 1,560 − 60 = 1,500, invoiced 1,455, uninvoiced 45, and the rate 45 ÷ 1,500 = 3%. That rate looks small, but each of the 45 orders is a separate customer and a separate tax record. The goal is to bring the rate close to zero.

Lesson 4: Which channel is missing invoices?

In short: Split uninvoiced orders by channel; the problem is usually in the flow of a single channel.

ChannelNeeds an invoiceInvoicedUninvoicedRate
Marketplace90089010%1,1
Own site45043020%4,4
Manually entered orders15013515%10
Total1.5001.45545%3
ComparisonUninvoiced order rate by channel
  1. Manually entered orders10.0%
  2. Own website4.4%
  3. Marketplace1.1%

Manually entered orders make up only 10% of volume (150 ÷ 1,500) yet account for a third of uninvoiced orders (15 ÷ 45); their rate is 10%. Here the flow depends on a person remembering. The 4.4% rate on the own website may stem from payment confirmation and customer details. The marketplace rate is low but not zero; for stuck orders, see the article how to find stuck marketplace orders.

Lesson 5: Why was the invoice not issued?

In short: There are five causes: an order awaiting payment confirmation, missing or incorrect invoice details, a cancellation/return record mismatch, an integration error, and a forgotten manual order.

BreakdownBreakdown of the 45 uninvoiced orders by cause
  • Payment confirmation arrived later₺1533.3%
  • Customer details (tax ID, address) missing or incorrect₺1226.7%
  • Cancellation and return record inconsistent₺920%
  • Integration or transfer error₺613.3%
  • Manual order, invoice forgotten₺36.7%
ReasonSolution
Payment confirmation arrived laterAutomatically pull confirmed orders into the invoicing list
Missing customer detailsRequired fields and tax ID validation on the order
Cancellation/return mismatchClose cancellations and returns together with the order status
Transfer errorMonitor the list of failed orders daily
Manual orderConnect manual entry to the same invoice flow

More than half of the causes (27 orders, 60%) are concentrated in the first two groups. Issuing an invoice before payment confirmation may not be correct; but once confirmation arrives, the order must enter the invoicing queue. For cancellation and return mismatches, see the articles how to cancel an order and how to issue a return invoice.

Lesson 6: How long have uninvoiced orders waited and how much are they worth?

In short: Group uninvoiced orders by waiting time and calculate the total amount; the oldest items get priority.

AgingDistribution of uninvoiced orders by waiting time
  1. 0–1 days20 orders
  2. 2–3 days10 orders
  3. 4–7 days9 orders
  4. 8 days and over6 orders

15 of the 45 orders (9 + 6) are older than 4 days; these are the priority. Amount impact: if the average order is ₺400 (VAT included), 45 × 400 = ₺18,000. Assuming a 20% VAT rate in the example, the uninvoiced VAT portion is 18,000 × 20 ÷ 120 = ₺3,000. Rates vary by product; use the rate for your own product groups and confirm with your certified public accountant (mali müşavir).

ItemAccountAmount
Uninvoiced order amount (VAT included)45 × 40018.000 ₺
VAT included (assuming 20%)18.000 × 20 ÷ 1203.000 ₺
Annual amount if repeated every month18.000 × 12216.000 ₺

The annual amount shows that the problem is the accumulation of a small percentage. Sharing this list with your accountant at month end prevents surprises; for handing over documents, see the article how to hand over documents to your accountant monthly.

Lesson 7: How do you make the correction?

In short: Work from oldest to newest, cause by cause; write down the reason for any order that cannot be invoiced.

  • Missing details. Ask the customer for the details and issue the invoice once complete; if they do not arrive, decide with your certified public accountant (mali müşavir) whether a retail invoice or the e-Archive invoice route applies under the general rules.
  • Order with payment confirmation received. Add it to the invoicing list and issue the invoice.
  • Cancellation/return mismatch. Correct the order status; issue a return invoice if needed.
  • Transfer error. Re-transfer the order or enter it manually; note the source of the error.
  • Forgotten manual order. Issue the invoice and decide to connect that channel to the automatic flow.

Measure the correction time: if an uninvoiced order is fixed in 6 minutes on average, 45 orders take 45 × 6 = 270 minutes (4.5 hours). If this repeats every month, the problem is not just the invoice but the process. The article how to invoice orders in bulk speeds up bulk invoicing.

Lesson 8: How do you run the check regularly?

In short: Do a quick daily look, a weekly match, and a final monthly check; the goal is to bring the uninvoiced rate close to zero.

FrequencyWhat happens
Every dayCheck that yesterday's delivered/shipped orders have been invoiced
Every weekMatch order and invoice counts; close uninvoiced orders older than 3 days
Every monthProduce the channel and cause breakdown; compare the rate with last month
When the process changesMatch daily for the first two weeks of a new channel or integration
IndicatorHow it is calculatedSample value
Uninvoiced rateUninvoiced ÷ Orders to be invoiced%3
Uninvoiced amountSum of order amounts18.000 ₺
Uninvoiced older than 4 daysWaiting 4+ days15 orders
Correction timeOrders × Minutes270 min / month
Takeaways from the exampleFour numbers from the uninvoiced order example
  • 45uninvoiced orders (3%)
  • 10%uninvoiced rate of manually entered orders
  • ₺18,000VAT-inclusive amount of uninvoiced orders
  • 270 minmonthly manual correction time

To add the monthly results to a management summary, you can use the layout in the article how to prepare a weekly management report. To add the check to your daily operations, see the article e-commerce daily operations checklist: how to create one. For general invoice tracking, the article how to track invoices is a useful complement.

Which situations confuse the matching?

In short: Partial shipments, partial returns, exchanges, and orders combined on a single invoice distort the count; set rules for these cases in advance.

  • Partial shipment. If an order ships in two packages, you may issue two separate invoices or a single one. Decide which you apply; do the matching at order number and line item level.
  • Partial return. If one line of an order is returned, the invoice stays but its amount changes. This order is not uninvoiced but is waiting for a correction; keep it in a separate list.
  • Exchange. In a product exchange, the new shipment may create a separate order record. Note its link to the original order; otherwise the new record looks uninvoiced.
  • Combined orders. If several orders from the same customer are combined on one invoice, the order count will exceed the invoice count. In matching, look at the order numbers on the invoice lines.
  • Samples and gifts. Separate non-sale shipments from the order status so they are not counted as uninvoiced.

Keeping these rules in a one-page note saves you from having the same discussion again at month end. If more than one person enters orders on your team, share the note with everyone. On the accounting side, also send your accountant the list of these exceptions at month-end close.

What are the most common mistakes when checking for uninvoiced orders?

  1. Not filtering out cancellations. Orders that do not need an invoice look uninvoiced and inflate the rate.
  2. Skipping the period end. An order placed at month end may be invoiced the next month; keep the window wide.
  3. Looking only at the total count. Without a channel breakdown, the source of the problem stays hidden.
  4. Not linking invoice and order by number. The matching then relies on guesswork.
  5. Leaving old uninvoiced orders. The longer they wait, the harder the correction; do the aging.
  6. Forgetting the manual flow. Orders taken by phone or in the store stay outside the system.
  7. Not closing the cause at its source. The same problem repeats every month.

How does NetKasam reduce the uninvoiced order problem?

  • Marketplace integration. Marketplace orders are invoiced automatically and posted to bookkeeping (marketplace integration).
  • e-Invoice and e-Archive invoice. You issue e-Invoice and e-Archive invoice from orders (e-Invoice).
  • Invoice tracking. You follow issued invoices and their statuses in a single list (invoice tracking).
  • Single-screen order management. Orders from different channels appear in one list with their statuses (order management).
  • Saved reports. You save order and invoice reports with their criteria and export them to Excel; you can prepare your matching table with this data (reports).
  • Free bookkeeping. e-Invoice, customer and supplier accounts, inventory, cash register, bank, and expense management are free on every plan; for e-Invoice credit plans, see the pricing page.

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 60 cancellations are removed from 1,560 order records, how many orders should be invoiced?
  2. If 1,455 of them are invoiced, what are the number and rate of uninvoiced orders?
  3. If 15 of 150 manual orders are uninvoiced, what is the channel's uninvoiced rate?
  4. If the average amount of the 45 uninvoiced orders is ₺400, what is the total amount?
  5. Assuming 20% VAT, how many ₺ of VAT are included in a VAT-inclusive amount of ₺18,000?

Answer key:

  1. 1,560 − 60 = 1,500 orders.
  2. 1,500 − 1,455 = 45 orders; 45 ÷ 1,500 = 3%.
  3. 15 ÷ 150 = %10.
  4. 45 × 400 = 18.000 ₺.
  5. 18.000 × 20 ÷ 120 = 3.000 ₺.

Frequently Asked Questions About Uninvoiced Orders

What is an uninvoiced order?

Orders that should be invoiced but have no linked invoice. They are usually forgotten, pending, or untransferred orders.

How do you find uninvoiced orders?

Match the period's order list with the invoice list by order number. After removing cancellations, the orders that do not match are uninvoiced.

How is the uninvoiced rate calculated?

Divide the number of uninvoiced orders by the number of orders that should be invoiced. For 45 uninvoiced orders out of 1,500, the rate is 3%.

Are invoices issued for cancelled orders?

Orders that are cancelled before delivery are generally not invoiced; however, cancelling an order that already has an invoice requires a separate procedure. Confirm your own situation with your certified public accountant (mali müşavir).

Why is an uninvoiced order a problem?

The sales revenue is on record but there is no invoice, so the VAT return may be incomplete and you need a solution when the customer asks for an invoice. That is why regular checks are necessary.

Which channel has the most uninvoiced orders?

Usually manually entered orders, because the flow depends on a person. In the example, the manual order rate is 10% and the marketplace rate is 1.1%.

How often should you match?

A quick daily look, a weekly match, and a final monthly check are recommended. For a new channel, check daily for the first two weeks.

How do I get uninvoiced orders close to zero?

Generate the invoice automatically from the order, connect manual entry to the same flow, make missing customer details mandatory on the order, and match every week.

Conclusion: Make every order's invoice easy to find

The most useful thing you can do today is to put last month's order list and invoice list side by side. Remove the cancellations, split the unmatched ones by channel and cause, close the oldest ones, and automate the flow of the channel that causes the most trouble. Seeing the rate fall when you run the same check next month is the best measure.

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