How to Do Virtual POS Reconciliation: Expected Net Collection, Value Date, Commission Verification, Difference Analysis and Dispute Training
How do you do virtual POS reconciliation? Expected net collection, value date, commission verification and difference analysis: an 8-lesson guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: What is virtual POS reconciliation?
- Lesson 2: How are the three parties matched?
- Lesson 3: How is expected net collection calculated?
- Lesson 4: What types does the difference consist of?
- Lesson 5: How do you analyze a difference?
- Lesson 6: How is the commission rate verified?
- Lesson 7: How do you correct and dispute?
- Lesson 8: How do you do reconciliation regularly?
- What are the most common mistakes in virtual POS reconciliation?
- How does NetKasam make virtual POS reconciliation easier?
- Mini quiz: Test what you have learned
- Conclusion: Read the amount deposited to the bank item by item, not by guesswork
- Frequently Asked Questions About Virtual POS Reconciliation
Every business that sells by card runs into the same question: the system shows ₺570,000 in sales, so why isn't that the amount deposited to the bank? Part of the answer is normal: commission has been deducted, and the money for some transactions has not yet reached the account. But part of it may be an error: a wrongly applied commission rate, an unnoticed deduction, an unrecorded return. Virtual POS reconciliation is the work of breaking this difference into items and finding which is normal and which is an error.
This article is not a narrative but an 8-lesson practical training. We will answer the question how to do virtual POS reconciliation through a sample store with ₺600,000 in monthly card sales: matching the three parties (order record, virtual POS report, bank movement), calculating expected net collection, the types of difference, difference analysis, commission verification, correction and dispute, and regular checking. At the end there is a mini quiz and an answer key. All figures and rates are sample values chosen to show the method; use the rates and settlement times in your own contract.
What will you be able to do by the end of this training?
In short: You will calculate expected net collection, compare it with the amount deposited to the bank, break the difference into items, verify the commission rate and have errors corrected and recorded.
- 01CollectGet the orders, POS report and bank movement.
- 02CalculateFind the expected net collection.
- 03CompareWork out the difference against the actual bank deposit.
- 04SeparateBreak the difference into items.
- 05VerifyCompare the commission rate with the contract.
- 06CloseCorrect errors, dispute and record.
The 8 lessons of the training: (1) what virtual POS reconciliation is, (2) three-party matching, (3) expected net collection, (4) types of difference, (5) difference analysis, (6) commission verification, (7) correction and dispute, (8) routine and monitoring.
Lesson 1: What is virtual POS reconciliation?
In short: It is the work of verifying that your record of card sales, the virtual POS provider's record and the amount deposited to the bank are consistent with each other.
The money from a card sale does not go straight into your account. The customer's card is charged, the transaction is approved through the virtual POS, commission and deductions are taken out, and the remaining amount reaches the account after the period stated in your contract. This chain creates three separate records, and each can show a different amount. Reconciliation puts these records side by side for the same period.
How this differs from bank account reconciliation is that items arrive in bulk, not one by one: on the bank statement, "POS deposit" appears as a single line, and the detail of the hundreds of transactions inside it is in the POS report. For general bank reconciliation, see how to do bank reconciliation; this article is its continuation specific to card collections.
Lesson 2: How are the three parties matched?
In short: The order record, the virtual POS report and the bank movement are matched using the same period and the same amount logic; any item that differs is examined.
| Source | What it shows | Example amount |
|---|---|---|
| Order and collection record (your system) | Gross sales taken by card, and returns | Gross ₺600,000, returns ₺30,000 |
| Virtual POS report | Approved transactions, commission, amount to be credited | Transaction-level list, commission total |
| Bank statement | The actual amount credited and its date | 513.400 ₺ |
Do matching daily and final close monthly. In the daily check, look only at large deviations: is the day's card sales in the system the same as the approved transaction total in the POS report? In the monthly check, you break out commission and value date in detail. For daily cash and cash close, you can use the layout in the article how to do a daily cash count and cash close for card collections as well.
Reconciliation of other collection routes such as cash on delivery and marketplaces is separate; for cash on delivery, see how to manage cash-on-delivery orders, and for marketplace payments, see how to find marketplace payout differences.
Lesson 3: How is expected net collection calculated?
In short: Subtract returns from gross card sales and deduct commission; the resulting amount is the net collection expected to reach the bank.
- Net sales = Gross card sales − Returns and cancellations
- Commission = Net sales × Commission rate
- Expected net collection = Net sales − Commission
In the sample store, gross card sales are ₺600,000 and returns and cancellations are ₺30,000. Net sales are 600,000 − 30,000 = ₺570,000. If the average commission rate is 3%, commission is 570,000 × 3% = ₺17,100 and expected net collection is 570,000 − 17,100 = ₺552,900. This example assumes that the commission on the returned transaction is also refunded; this practice varies by contract, so use the rule in your own contract. For the effect of commission rates on business cost, see how to calculate the cost of installment sales.
| Item | Account | Amount |
|---|---|---|
| Gross card sales | System record | 600.000 ₺ |
| Returns and cancellations | System record | − 30.000 ₺ |
| Net sales | 600.000 − 30.000 | 570.000 ₺ |
| Commission (3%) | 570.000 × %3 | − 17.100 ₺ |
| Expected net collection | 570.000 − 17.100 | 552.900 ₺ |
It is important that returns are recorded; an order whose return invoice has not been issued or that has not been cancelled makes gross sales higher than they are and pushes expected collection above reality. For return invoices, see how to issue a return invoice; for the cancellation process, see how to cancel an order.
Lesson 4: What types does the difference consist of?
In short: There are five types of difference: value date (not yet credited), commission difference, additional deduction, return and dispute difference, and recording difference. The first two are often normal or correctable, and the last is your own recording error.
| Difference type | Cause | Normal? |
|---|---|---|
| Value date (timing) | Money for period-end transactions arrives after the period in the contract | Yes, it closes in the next period |
| Commission difference | A rate different from the contract applied to an installment or foreign card transaction | No, it must be verified |
| Additional deduction | Separate lines such as service fees, holds and transaction fees | Yes, if it is in the contract |
| Return and dispute difference | A cardholder's dispute or a return you did not record | Must be recorded |
| Recording difference | A collection missing from your system, or recorded twice or incorrectly | No, it must be corrected |
The value date difference is the largest, so it is the first item to look at and the most harmless; but if it is not taken into account on the closing date, the reconciliation looks broken. Because the money for transactions at the end of the month appears on the next month's statement, period-end recording is critical. For period close, see how to do a month-end close.
Lesson 5: How do you analyze a difference?
In short: Subtract the actual bank deposit from the expected collection and split the difference into types. Examine it transaction by transaction until the unexplained part shrinks.
In the sample store, the amount deposited to the bank is ₺513,400. The difference is 552,900 − 513,400 = ₺39,500. Of this, ₺38,000 is transactions made at the end of the month that have not yet reached the account (value date). Total installment sales are ₺120,000, and 3.7% was applied to these transactions instead of the 3% in the contract; the difference is 120,000 × 0.7% = ₺840. An additional service fee of ₺480 was deducted in the period. The remaining 39,500 − 38,000 − 840 − 480 = ₺180 is the unexplained difference.
- Expected net collection₺552,900
- Transactions not yet credited (value date)−₺38,000
- Installment commission difference−₺840
- Additional service fee−₺480
- Unexplained difference−₺180
- Amount deposited to the bank₺513,400
Prepared with sample values. Calculation: 552,900 − 38,000 − 840 − 480 − 180 = ₺513,400. Total difference ₺39,500.
The share of the explained difference is (38,000 + 840 + 480) ÷ 39,500 = 39,320 ÷ 39,500 = about 99.5%. This is a good reconciliation; but because the unexplained ₺180 exceeds your own rule's threshold of ₺100, it should still be examined. Treating small differences as insignificant means missing the early sign of a large problem once they add up. The remaining difference is usually in a single transaction: rounding, a small difference in cents, a double charge or an unrecorded return. Sort the transaction list by amount and match it against the POS report.
Recommended readingHow to Find Marketplace Payout DifferencesLesson 6: How is the commission rate verified?
In short: Multiply the commission in the POS report by the contract rate for each transaction type and compare. Pay particular attention to rates that vary by number of installments and card type.
| Transaction type | Transaction amount | Contract rate | Applied rate | Difference |
|---|---|---|---|---|
| Single payment | 450.000 ₺ | %3 | %3 | 0 ₺ |
| Installment | 120.000 ₺ | %3 | %3,7 | 120.000 × %0,7 = 840 ₺ |
Commission verification is done monthly, because the contract rate can change, a new installment option can be added or a separate rate can apply to a different card group. We explained how to reflect the cost of installment sales in pricing in the article how to calculate the cost of installment sales. You can see NetKasam's current virtual POS rates on the pricing page.
If the difference repeats, calculate its annual effect: 840 × 12 = ₺10,080 of excess deductions a year. The additional service fee is 480 × 12 = ₺5,760. Deductions like this are small individually, but because they flow continuously and unnoticed, their annual totals reach a serious amount. It gives you a concrete figure in negotiation or when choosing a provider. To compare online collection methods, see how to choose online payment methods.
Lesson 7: How do you correct and dispute?
In short: Close your own recording errors with a correcting entry and dispute provider-caused differences with documentation. Value date differences are tracked until they close in the next period.
- Recording error. Correct collections that are missing or recorded twice in your system. If cancellation and return entries are needed, make them with a reversing entry; past records are not deleted.
- Provider difference. If a commission or deduction violates the contract, write a dispute with the transaction list, the contract clause and the calculation. State the difference amount and the number of transactions.
- Value date difference. Write it on the reconciliation list as "pending" and verify that it was deposited on the next month's statement. If it was not deposited, dispute it then.
- Cardholder dispute. Record the disputed transaction (the amount withdrawn back from your account) as a separate item; submit your evidence within the deadline.
Keeping documents in an orderly way makes disputes easier: keep the POS report, statement and comparison table in the month's folder. For documents delivered to your accountant monthly, see how to deliver monthly documents to your accountant. To see the effect on cash flow, the article how to prepare a cash flow statement is useful; the amount pending because of value date appears as money "in transit" in the cash plan.
Lesson 8: How do you do reconciliation regularly?
In short: Do a quick daily check, a weekly difference list and a final monthly reconciliation. Track four indicators in each period.
| Frequency | What happens |
|---|---|
| Every day | Compare the day's card sales in the system with the approved total in the POS report |
| Every week | Match bank deposits with the POS report and update pending items |
| Every month | Compare expected net collection with the actual deposit, verify commission and break the difference into items |
| Every quarter | Review commission rates and provider terms |
| Indicator | How it is calculated | Sample value |
|---|---|---|
| Total difference | Expected − Actual collection | 39.500 ₺ |
| Explained difference rate | Explained ÷ Total difference | %99,5 |
| Unexplained difference | Total difference − Explained | ₺180 (threshold ₺100) |
| Excess commission | Transaction amount × Rate difference | ₺840 / month |
- ₺552,900expected net collection
- ₺39,500difference between expected and actual
- 99.5%explained difference rate
- ₺10,080annual cost of the installment commission difference
If you reconcile regularly even once, you will see that most differences come from the same causes; that way you follow patterns instead of searching from scratch every month. To add the reports to a management summary, you can use the layout in the article how to prepare a weekly management report. To see your real profit, see how to calculate net profit on a marketplace, which also includes payment cost.
Recommended readingHow to Set Channel-Based Sales Prices: Price by Target Contribution, Commission Effect, Break-Even Sales Loss, Price Gaps Between Channels and Scenario TrainingWhat are the most common mistakes in virtual POS reconciliation?
- Treating the value date as an error. A transaction not yet credited is a normal timing difference; it should be tracked as pending.
- Not verifying commission. A different rate applied to installment transactions can go unnoticed for years.
- Not recording returns and cancellations. Expected collection comes out higher than it is and a false difference appears.
- Ignoring a small unexplained difference. It grows as it accumulates and hides problems such as double charges.
- Looking only at the total amount. Without transaction-level matching, the source of the difference cannot be found.
- Not recording a cardholder dispute. The amount withdrawn back from the account looks like a difference with no cause.
- Not keeping documents. The POS report and statement needed for a dispute cannot be found.
How does NetKasam make virtual POS reconciliation easier?
- Online collection. You track card and link payment collections in the system and match them with orders (online collection).
- Automatic cash and bank entries. Cash and bank records are created at the same time as transactions; no manual double entry is needed.
- Automatic bank fees. An expense voucher is created for bank fees arising from collections or payments (expense management).
- Single-screen order management. You see orders from different channels together with their cancellations and returns (order management).
- Automatic invoice and return invoice. Invoices for orders are issued automatically; you record returns (invoice tracking).
- Saved reports. You save collection and bank movement reports with their criteria, export them to Excel and compare them with the POS report (reports).
- 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.
- If gross card sales are ₺600,000, returns ₺30,000 and commission 3%, what is the expected net collection?
- If 3.7% was applied instead of 3% to installment transactions of ₺120,000, how many ₺ is the excess commission?
- If value date 38,000, commission difference 840, additional fee 480 and the unexplained ₺180 are subtracted from the expected ₺552,900, what is the amount deposited to the bank?
- If the total difference is ₺39,500 and the explained part is ₺39,320, what is the explained difference rate in percent, roughly?
- How many ₺ a year is an excess commission of ₺840 a month?
Answer key:
- Net sales 600,000 − 30,000 = ₺570,000; commission 570,000 × 3% = ₺17,100; 570,000 − 17,100 = ₺552,900.
- 120.000 × %0,7 = 840 ₺.
- 552.900 − 38.000 − 840 − 480 − 180 = 513.400 ₺.
- 39.320 ÷ 39.500 ≈ %99,5.
- 840 × 12 = 10.080 ₺.
Frequently Asked Questions About Virtual POS Reconciliation
What is virtual POS reconciliation?
It is verifying that your record of card sales, the virtual POS report and the amount deposited to the bank are consistent. If a difference appears, it is broken down into its items.
How is expected net collection calculated?
Returns and cancellations are subtracted from gross card sales and commission is deducted from the remaining net sales. For example, with ₺600,000 gross, ₺30,000 in returns and 3% commission, the expected amount is ₺552,900.
Why is the amount deposited to the bank less than expected?
Transactions not yet credited to the account (value date), a commission applied differently from the contract, additional service fees, disputes and recording errors can create this difference.
What is the value date?
It is the time between a card transaction being approved and the money reaching the account. Because the money for transactions at the end of the month appears in the account in the next period, it is tracked as a pending item in reconciliation.
How is the commission rate verified?
The contract rate is applied according to the transaction type in the POS report and compared. Differences are more likely in installment and different-card transactions.
How often should reconciliation be done?
A quick daily check, weekly matching and a final monthly reconciliation are recommended. Commission verification is done monthly, and provider terms are reviewed quarterly.
What do you do if there is an unexplained difference?
The transaction list is sorted by amount and matched against the POS report. The difference is usually in a single transaction: a double charge, a rounding difference or an unrecorded return.
How do you dispute a difference caused by the provider?
You file a written dispute with the transaction list, the contract clause and the difference calculation. Stating the difference amount and the number of affected transactions helps speed up the process.
Conclusion: Read the amount deposited to the bank item by item, not by guesswork
The most useful thing you can do today is calculate the expected net collection from last month's card sales and compare it with the amount deposited to the bank. Split the difference into four items: value date, commission, additional deduction and unexplained; compare the commission rate with your contract. Find the remaining unexplained difference in the transaction list and produce the same table again next month.
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.