سفير تركيا
Active member
- Joined
- Dec 14, 2025
- Messages
- 127
- Reaction score
- 0
- Points
- 16
Reconciling store sales in Türkiye: fees, refunds, payouts and cash flow
Trace orders, payments and payouts to explain deductions and plan available cash
Trace orders, payments and payouts to explain deductions and plan available cash
Recorded sales, customer collections and provider transfers to the bank are different figures that can all be correct simultaneously. Reconciliation links each order to its transaction, deductions and settlement batch and explains differences before they distort profit or cash estimates. This guide provides a process for stores selling from Türkiye through direct payments or marketplaces. Table figures are hypothetical, rather than company fees or sales forecasts. Retain original documents and give tax questions and accounting entries to the accountant with a clear discrepancy log.
Sales reconciliation starts with order and transaction references. — General illustrative photo.
Define the figures to reconcile
Order totals may include unpaid, canceled or pending orders. Successful payments may concern earlier-period orders, while bank transfers combine movements under a settlement schedule. Define every figure and period before comparing. A whole month’s order page cannot be compared with one payout and the difference labeled commission; settlements may span days or include older refunds.
Create three core lists: sales orders, payment transactions and settlement/bank movements. Add returns and associated financial documents. Standardize dates, time zone and currency-entry rules while preserving original event dates. Each list serves a purpose: the store explains products and customers, the provider payments and deductions, and the bank actual account receipts.
Use stable references at every level
Order numbers link operations, transaction IDs link money and settlement references link payouts. An order may have several payment attempts and a batch dozens of transactions. Record these relationships instead of forcing every movement into one inexplicable row. Names or amounts alone are insufficient because both can recur.
Link every refund to its original transaction, identify full or partial refunds and retain dispute references. If a provider changes a number in a new file without changing the transaction, preserve both references and their relationship. Test exportability before relying on manual reports. Good records let any finance owner trace an order through the provider report to the bank movement without asking its preparer.
| Field | Level | Use |
|---|---|---|
| Order number | Store | Link sale and fulfillment |
| Attempt and payment ID | Provider | Distinguish declines, success and duplicates |
| Refund ID | Provider | Link refunded amounts to the original |
| Settlement reference | Batch | Break down a combined payout |
| Bank reference | Account | Confirm received amounts |
Collect original files for a small period
Start with one day or batch if reconciliation is new. Download transactions, settlements, refunds and bank statements for the necessary period alongside orders. Use exported data rather than screenshots where possible. Keep raw files and a separate working copy for cleaning and added columns; changing originals makes later explanations harder.
Check period completeness, row counts, currencies and fields. One file may omit post-cutoff transactions or contain duplicates from its export method. Keep report names, download dates and sources. Balances or statuses can change after later settlement, so identify the version used for a decision. Updated records should not erase evidence of changes explaining earlier discrepancies.
Commission, tax, withholding and holds
Classify deductions by meaning. Commission is a documented service cost, invoice tax follows applicable rules, tax withholding is not commission and a temporary hold is not a final loss. Calling every difference ‘fees’ corrupts cost and cash analysis. Request an explanation for each report code and supporting document, identifying cost, receivable balance or tax requiring accounting treatment.
GİB explains one-percent withholding for covered e-commerce intermediary payments, with exceptions and a KDV-exclusive base not reduced by certain expenses deducted from payment. Do not apply this to every direct gateway payment. Have the accountant determine applicability, documents and offsetting for your channel. Correct classification prevents counting withholding as service cost and again as tax.
| Component type | Practical meaning | What to track |
|---|---|---|
| Commission | Payment for a service | Quote and invoice |
| Tax or withholding | Treatment according to scope | Document and accountant’s decision |
| Temporary hold | Balance currently unavailable | Basis and release date |
| Refund | Money returned to the customer | Reference and amount |
| Adjustment | Separate correction | Reason and associated period |
Combined payouts require a report explaining their components. — General illustrative photo.
Match successful payments to orders
For every successful transaction, locate its order and compare amount, currency and saved basket components. Classify payments without orders, paid orders without transactions, two payments for one order and value differences. Do not eliminate these by inserting matching manual amounts; open cases explaining relationships. Failed notifications, second attempts or post-payment changes may be responsible.
Handle canceled and refunded orders according to actual movements. A platform-canceled order may still be paid and need a refund; a partially refunded order may retain a balance. Keep gross payment, returned money and net movement separate. After fixing links, review stock and fulfillment too: financial errors may accompany duplicate dispatch or paid goods never sent.
Match settlement batches to bank statements
Settlement reports detail included transactions, commission, refunds and settlement references and dates. Place expected amounts beside bank movements and record timing, account or value differences. ‘Sent’ does not prove receipt; check the beneficiary statement. For missing transfers, establish whether due and sent, then request the reference.
Where bank or provider combines movements, use the reference or aggregation file. Do not divide value equally among orders for convenience. Retain separate bank-fee documents and classify them apart from gateway commission. For different settlement currencies, review actual conversion and cost before equating numeric amounts with different units.
Hypothetical settlement batch
Assume successful payments of fifty thousand lira, refunds four thousand, commission one thousand five hundred, a new hold five thousand, release of a previous hold two thousand and a deducted adjustment three hundred. With no other components, expected transfer is forty-one thousand two hundred lira. These educational figures assume no tax or withholding universally applicable to stores.
If the bank statement shows forty-one thousand one hundred and fifty, the fifty-lira difference needs a separate explanation. Do not automatically add it to commission. It may be a fee, error or missing portion; documents determine the answer. Releasing two thousand is not a new sale but an old balance becoming cash. Establish that old and new holds belong to different periods to avoid mixing tracked balances.
| Hypothetical movement | Effect in lira | Tracking classification |
|---|---|---|
| Successful payment | 50,000 | Collection movement |
| Refunds | −4,000 | Link to original payment |
| Commission | −1,500 | Service cost |
| New hold | −5,000 | Temporarily unavailable |
| Previous hold released | 2,000 | Earlier balance now available |
| Deducted adjustment | −300 | Reason document |
| Expected payout | 41,200 | Compare with bank statement |
Result: 50,000 − 4,000 − 1,500 − 5,000 + 2,000 − 300 = 41,200 lira.
Refunds and disputes spanning periods
A sale may occur one month and its refund the next, producing a deduction without matching current sales. Preserve the original reference and both periods rather than recording an unidentified negative sale. For disputes after partial refunds, check refund amount and outcome before new movements. Settlement deduction dates can differ from case-opening dates, so separate events and money movements.
Monitor negative balances and contractual coverage, and holds arising from activity or risk reviews. Deductions are not all final before dispute status is known. Give the accountant a table of resolved, open and earlier-period corrections. Reducing uncertainty speeds closure more than a generic line easy to enter but hard to explain.
Available cash differs from gross sales and held balances. — General illustrative photo.
Currencies and exchange differences
Record display, collection and settlement currencies where different. Original values alone cannot reconcile a lira account, and lira alone cannot explain a foreign-currency refund. Request contractual and reported exchange methods, fees and reference times. Do not recalculate all old transactions using the file-download date’s rate.
Hypothetically, a sale of one hundred foreign-currency units settles at a specified lira amount in the provider report. A later half-refund may not have half the original lira effect if conversion routing differs; verify the service rather than assuming. Retain original and settlement values and references. The accountant handles exchange effects under appropriate documents and policies; operations must maintain complete links without combining currencies into one total.
Maintain a discrepancy list and closure owners
Each difference needs a case number, amount, currency, type, owner, follow-up date and document. Classify timing, linking, value, currency and missing-document differences, starting with greatest impact and oldest age. If explained as ‘a future payout’, identify reference and expected date and verify receipt; a temporary explanation does not automatically close the case.
Send the provider references, expected and actual amounts, account and date with a specific question. Do not send a thousand unlinked orders for one clear batch discrepancy. Record cause and recurrence prevention after resolution. Small repeated differences can become material at higher volume; monitor case count, age and aggregate effect consistently.
Forecast cash without spending held balances
Start with actual cash, add confirmed or expected transfers with dates and confidence levels, then deduct supplier, shipping, operating, refund and appropriate tax commitments. Not every provider balance is usable cash. Model a delayed transfer or increased refunds to identify reserve needs or deferred inventory purchases.
In a hypothetical example, opening cash is ten thousand and confirmed transfer forty-one thousand two hundred, followed by supplier payments of twenty-six thousand, shipping seven thousand and operations five thousand. Thirteen thousand two hundred remains before other excluded obligations. This is not period profit; inventory costs, taxes and other payables may remain. Do not distribute it as profit before the appropriate accounts are complete.
| Hypothetical cash forecast | Amount in lira | Effect |
|---|---|---|
| Opening cash | 10,000 | Available |
| Confirmed transfer | 41,200 | Addition |
| Supplier payment | −26,000 | Obligation |
| Shipping | −7,000 | Obligation |
| Operations | −5,000 | Obligation |
| Balance before other items | 13,200 | Not net profit |
Frequently asked questions and period closure
Before giving closure records to the accountant, collect originals, reconciliation tables, open differences, financial documents and confirmed explanations. Do not hide discrepancies to make the month appear clean. Identify estimates and pending provider responses, retaining approval date and reviewer. Reconstructable calculations are better evidence than merely making two totals equal.
Make reconciliation a short recurring habit with a wider period-end review. Store size determines frequency, but avoid postponing everything until transaction volume becomes unwieldy. Separate refund execution from reconciliation review where possible and review changes in accounts, fees and reports. The aim is an understandable operating balance supported by evidence for every deduction and transfer.
Is the payout my sales or profit?
It is cash received after settlement components. Reconcile it to collections, then calculate sales, costs and profit from documents.
Does every store pay e-commerce withholding?
Do not generalize. Check intermediary-payment scope and exceptions with the accountant; direct gateway payments are not automatically equivalent.
What should I do with a small unexplained difference?
Open a case with amount, reference, owner and deadline; do not label it commission without evidence.
I defined the period, currency and every total. I linked orders, payments, refunds, settlements and bank movements. I classified commission, withholding, holds and adjustments. I documented differences, owners and follow-up dates. I prepared a cash forecast and gave documents to the accountant.
Related topics
Online Store Invoices in Türkiye: E-Invoices, Taxes and Withholding- Payment Gateways in Türkiye: From Card Approval to Merchant Settlement
- Refunds and Chargebacks in Türkiye: The Merchant Evidence File
- Small Online Stores in Türkiye: A 90-Day Pilot and Scaling Decisions
- Choosing a Payment Provider in Türkiye: Licensing, Fees and Settlement
- Payment Problems in Turkish Stores: Declines, Pending Payments and Order Status
- Bank Payment Solutions vs FinTech Gateways in Türkiye
- Merchant Account Approval in Türkiye: Documents, Checks and Follow-Up
- Order Profit in Türkiye: Pricing, Discounts and Break-Even
Last edited by a moderator: