---
name: fatura-mal-kabul
description: "Use when an invoice vs. goods receiving variance analysis is requested from goods receiving slips, approved purchase order unit prices and invoice lines. Produce a formula-based Excel file and a Word summary."
---

# Invoice vs. goods receiving variances

How much of the invoice amount comes from quantity differences and how much from unit price differences?

## Input and scope

Goods receiving slips, approved purchase order unit prices and invoice lines.

Use the attached Excel/CSV files as the source. Read each one without modifying it. Identify the sheets, report scope, periods, units and required fields. Map synonymous column headers against the sample. If a missing field affects only a specific metric, still produce the other metrics. If a critical definition can be read in more than one way, ask one focused question. Trace subtotals and duplicates back to the source row. Remove fields containing personal data from the outputs. Use the sample only when the user wants to try it with the sample data.

## Analysis

1. Link supplier, purchase order, receiving slip, invoice and item code. Consolidate partial deliveries and multiple invoices on the same order line. Verify the unit of measure, discount and tax basis.

2. Quantity effect = (invoiced quantity − received quantity) × approved unit price. Price effect = invoiced quantity × (invoice unit price − approved unit price). Verify that the two effects add up to invoice amount − expected received amount.

3. Keep invoices that cannot be linked separate. Write partial invoicing and return possibilities as check questions. In the Word report, do not let positive and negative variances mask each other.

## Delivery and checks

On the first sheet of Analiz.xlsx, show the rows that answer the question and the calculated indicators. Keep the sources on a separate sheet with anonymised fields. Write Excel formulas for derived measures. On the Checks sheet, add the date range, column mapping, scope, missing/unmatched records and the reconciliation result. Create the Word file named Yonetim-Ozeti.docx. On one page, write the period, the main result, at most three evidence-backed findings and the follow-up the responsible team will check. Reopen both files; independently check the numbers, the denominators of ratios and the source totals. Do not present unverifiable causes as findings. Deliver both files as downloads.

Visible fields in the Excel analysis: Item, Quantity effect (TL), Price effect (TL), Total variance (TL).

## Try it with the sample

Use the file assets/ornek-girdi.xlsx. The expected Excel and Word examples are in the ornekler/ folder. Sample-specific check: The olive oil invoice is 1,425 TL higher than the received goods and the purchase order.
