Purchase order, receipt, and invoice matching
Find differences between ordered price, received quantity, and invoiced quantity before payment.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Kabul edilen adet
- 75.38
- Miktar farkı (TL)
- 278.38
- Fiyat farkı (TL)
- 140.63
Who can use it, and for what?
Purchasing and accounts payable
Find differences between ordered price, received quantity, and invoiced quantity before payment.
A worked example from the workbook
The first sample row in the baseline has the following results. Kabul edilen adet 76, Miktar farkı (TL) 215, Fiyat farkı (TL) 243, Net fatura farkı (TL) 458. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Kabul edilen adet | 75.38 |
| Miktar farkı (TL) | 278.38 |
| Fiyat farkı (TL) | 140.63 |
| Net fatura farkı (TL) | 419 |
How do you start with your own data?
- Start with Kılavuz (Guide). Replace the 16 fictional entries in the yellow cells on Veri (Data). Use an Excel date, a unique record ID and a branch or category. There are 64 ready-to-use input rows.
- Match purchase order, delivery note, and invoice lines. Deduct rejected goods and investigate price and quantity differences separately. Use a consistent tax basis.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Tutar toleransı (TL)”. The sample settings are 25 / 5 / 60. Changing the scenario preserves source records.
- Panel shows the three cases and the group breakdown for the selected case. On Hesap (Calculations), check input flags and row-level decisions. To rename a group, use the same name on Settings and Data.
Workbook input fields
Labels appear in Turkish in the workbook.
- Sipariş miktarı
- Sipariş fiyatı (TL)
- Teslim alınan
- Nitelik reddi
- Faturalanan miktar
- Fatura birim fiyatı (TL)
Sample assumptions
- Tutar toleransı (TL)
- 25