Ad Agency Fee Reconciliation
Check media balances, minimum fees and refund charges in KRW.
Korea · KRW · 2026 contract reconciliation
Media ledger 1
A reversal restores current-period spend to the wallet. A cash refund is paid by the platform to the agency. Enter 0 for each absent transaction.
Use paid funds from the same period. Reconcile direct advertiser payments/refunds, promotional credits, prior-period reversals and a shared cross-media minimum separately.
Reconcile agency fees against the media ledger
Money paid to an agency, funds topped up into an advertising account and advertising spend are separate movements.
Treating all top-ups as spend, or treating a platform wallet balance as cash already available for repayment, can produce a misleading reconciliation.
This advertising agency media ledger, minimum fee and refund fee calculator checks one actual contract against the account records for the same settlement period.
Small business owners and settlement staff can distinguish spend reversals, cash refunds, minimum fees, production charges and reporting charges before comparing the result with an agency statement.
The calculator does not assess market pricing, forecast advertising performance or establish a legal refund entitlement.
For the decision to hire an agency or run campaigns internally, use the separate Search Ads Agency vs In-house Break-even Calculator to compare operating costs and performance assumptions.
Korea, KRW and the 2026 rule context
Use Korean won (KRW), one settlement period and up to three paid media accounts managed by the agency.
Prepare the media ledgers, fee contract, invoices showing VAT treatment, and records of payments to and repayments from the agency.
The tax options model Korean standard VAT at 10% or a confirmed case with no VAT applied; the calculator does not determine which treatment applies.
Separate free promotional credits from paid wallet funds.
Understand the six media ledger amounts
Opening balance, top-ups and spend
The opening balance is the paid wallet balance at the start of the settlement period.
Top-ups are additional funds put into the platform during the period; spend is the amount consumed by advertising.
An advertiser payment to the agency is not itself a platform top-up, so use the original record for each movement.
Spend reversal and cash refund
A spend reversal credits the platform wallet after cancelling spend from the current period.
A cash refund moves money out of the platform wallet to the agency.
Only the reversal reduces net spend; deducting a cash refund from net spend as well would count the same movement twice.
Actual closing wallet balance
Enter the balance shown by the platform at the end of the same period.
It must match the expected closing balance from the ledger equation.
If campaigns are still running, a reversal has posted late or records cover different periods, reconcile the source records first.
Blank differs from a confirmed zero
Enter 0 when the records confirm there was no transaction.
Leave an amount blank when it is unknown.
The calculator keeps missing data separate from zero and shows available subtotals and outstanding items before a final settlement reference can be shown.
Use one VAT-inclusive or VAT-exclusive display basis for all six ledger amounts within each account.
Also confirm whether standard 10% VAT or no VAT applies to that account.
A reversal cannot exceed that account’s spend for the period; a reversal relating to earlier-period spend requires a separate reconciliation.
Input amounts support whole won from 0 to 100,000,000,000; percentage inputs support 0% to 100% with up to two decimal places.
Negative or invalid numbers are not accepted as settlement values.
Choose the contractual fee base and minimum fee
An identical fee percentage can produce different charges when the underlying base differs.
Choose spend before reversals, net spend after reversals, top-ups before cash refunds, or a separately agreed custom amount.
Keep the base unconfirmed if the contract does not establish it clearly, and ask the agency to confirm its definition in writing.
The VAT-inclusive or VAT-exclusive fee-base choice is separate from the ledger display basis; a custom base is used directly in the selected basis without another conversion.
Derive spend, net spend or top-ups from the original displayed ledger amounts first; preserve that raw amount when the VAT bases match, and convert and round only when the bases differ.
Fixed, percentage and minimum fees
The fixed method uses the agreed fixed charge; the percentage method uses fee base × rate ÷ 100.
The account fee is the greater of the selected method’s amount and that account’s minimum fee.
Apply the minimum once per account, then round that account fee to whole won.
Production or reporting charges are added afterwards and do not enter the minimum-fee comparison.
Two progressive percentage bands
min(base, threshold) × lower rate ÷ 100 + max(0, base − threshold) × excess rate ÷ 100
Each rate applies only to its own portion of the base.
A KRW 700,000 base, KRW 500,000 threshold, 10% lower rate and 5% excess rate produce KRW 60,000 before the minimum.
A KRW 100,000 minimum raises the account fee to KRW 100,000.
A single minimum covering all accounts, or a threshold that changes the rate on the entire base, requires a different contract model.
Do not use this model’s result as a completed check for those arrangements.
A full reversal can reduce net spend to zero while the agreed minimum still applies.
Minimum-fee waivers, proration and early termination terms require confirmation from the contracting parties.
Add refund handling and apply service VAT
- Add the account fees, production charge and reporting charge.
Enter a confirmed zero for a charge that does not apply. - Refund handling equals the agreed fixed refund charge plus total VAT-inclusive cash refunds from platforms to the agency × refund handling rate ÷ 100.
Wallet credits from spend reversals do not enter this cash-refund base. - Use a consistent VAT-inclusive or VAT-exclusive quoted basis for all agency charges and minimum fees.
This service-fee basis is independent of each media ledger’s VAT basis. - With standard 10% VAT added, round 10% of the quoted fee subtotal to whole won and add it.
With VAT included, round subtotal ÷ 1.1 to obtain the net service amount; the remainder is VAT.
With confirmed no VAT, VAT is zero.
Example contract rates are not statutory rates
The example’s 10% agency fee, 1% refund handling rate and KRW 100,000 minimum are hypothetical contract inputs.
They are not a market benchmark or a statutory fee schedule, even though the example agency rate happens to equal the standard VAT rate.
The calculator does not decide taxability, exemption or input VAT deductibility, and mixed-tax invoices are outside its scope.
Whole-won rounding is a model convention rather than a claim about mandatory invoice rounding.
Separate agency-held cash from platform wallet funds
Reconcile the wallet first
Expected closing balance = opening balance + top-ups − spend + spend reversals − cash refunds
A negative expected wallet or any whole-won difference from the actual closing balance holds back the final reference.
Convert each ledger amount to a whole-won VAT-inclusive cash amount before aggregating cash flows.
Even when the original displayed ledger balances, independently rounded VAT conversions can leave a cash-basis difference, which also holds back the final reference; check the actual tax and invoice rounding before reconciling the amounts.
Net media cost is VAT-inclusive spend minus VAT-inclusive spend reversals.
Reconcile funds remaining with the agency
Agency balance = total opening wallets + period prepayment − net media cost − total closing wallets − total service cash charge − prior repayment
Period prepayment includes advertiser funds sent to the agency for media and fees, plus any opening agency-held cash carried forward.
Do not include opening platform wallet funds in prepayment again.
Prior repayment is money already returned by the agency to the advertiser during the period.
A platform refund made directly to the advertiser is outside this agency-managed cash-flow model.
A positive balance is a repayment review reference; a negative balance is an additional payment reference.
Closing platform wallet funds remain a separate asset and are not automatically added to cash available for repayment.
Top-ups and platform cash refunds are already reflected in the ledger and closing wallet, so do not deduct or add them again in net media cost or the final balance.
Required values, matching ledgers and the contract, ledger, tax and repayment-condition confirmations must all be complete before the final reference is shown.
The actual right, timing and permitted offsets still depend on the contract and confirmation by the parties.
Worked example: a KRW 261,580 repayment review reference
All media ledger figures in this example include standard 10% VAT.
Opening balance is 0, top-ups 1,100,000, spend 880,000, spend reversals 110,000, cash refunds to the agency 220,000, and actual closing balance 110,000, all in KRW.
The ledger balances, agency fees are quoted excluding VAT, and the fee base is net spend excluding VAT.
| Item | Calculation | KRW |
|---|---|---|
| Net media cost | 880,000 − 110,000 | 770,000 |
| Fee base | 770,000 ÷ 1.1 | 700,000 |
| Account fee | max(700,000 × 10%, minimum 100,000) | 100,000 |
| Production and reporting | 50,000 + 0 | 50,000 |
| Refund handling | 10,000 + 220,000 × 1% | 12,200 |
| Service subtotal and VAT | 162,200 + 16,220 | 178,420 |
| Prepayment and prior repayment | Prepayment 1,320,000; prior repayment 0 | 1,320,000 |
| Closing platform wallet | Reported separately from repayment | 110,000 |
| Repayment review reference | 1,320,000 − 770,000 − 110,000 − 178,420 | 261,580 |
For a different contract with VAT-inclusive quoted fees of KRW 110,000, the net service amount would be KRW 100,000 and VAT KRW 10,000.
Do not mix that quoted basis with the VAT-exclusive example above or change the minimum-fee unit silently.
The example is illustrative: return to your saved inputs and replace every amount with the actual contract and records before relying on a reconciliation.
From source records to a checked statement
- Set a common settlement period and start with the opening media balance, then enter all six ledger amounts.
Add the second and third accounts only if needed and set each account’s VAT display basis. - In the contract step, confirm the fee-base definition, its VAT treatment, the fee method and the minimum.
For progressive bands, check the threshold and both rates against the contract. - In the settlement step, enter production, reporting and refund charges, service VAT, prepayment and prior repayment.
Keep unknown amounts blank rather than filling them with zero. - Resolve ledger differences and missing inputs, then complete the contract, ledger, tax and repayment-condition confirmations.
Read the repayment or additional payment reference separately from funds still held in platform wallets. - Save the TXT review sheet with the contract and statement.
Ask the agency to confirm disputed fee bases, minimum-fee units and repayment dates in writing, then rerun the check against the revised statement.
Contract renewal and minimum fees
When spend is low, check whether a minimum exceeds the percentage charge.
For multiple accounts, a per-account minimum may differ substantially from a single contract-wide minimum, so confirm the billing unit first.
Campaign closure and remaining funds
Separate platform wallet balances from cash refunds already received by the agency.
Do not enter a pending refund estimate as a completed cash refund.
Update the ledger after completion and check whether the agency has separately repaid the advertiser.
Frequently asked questions
Does this provide a standard agency fee rate?
No market default is supplied.
Enter fixed charges, percentages, minimums and refund handling rates from the actual agreement.
The worked example uses hypothetical inputs to explain the arithmetic.
Should both reversals and cash refunds reduce net spend?
Only spend reversals reduce net spend.
A cash refund is a transfer out of the platform wallet and appears separately in the ledger equation.
Deducting it from net media cost or adding it again to the final repayment would double-count that movement.
Why can repayment be small when the wallet still has funds?
Wallet funds are still with the platform, separate from cash held by the agency.
After a completed platform refund to the agency, update both the cash refund and closing wallet records.
Do not add the existing wallet balance as though it were already available for cash repayment.
Does a KRW 1 difference also hold back the final reference?
Yes, any difference between expected and actual closing balances requires a ledger check.
Review VAT conversion, rounding, posting times and settlement-period boundaries first.
Missing values and unchecked conditions also remain unresolved rather than becoming a completed repayment figure.
Which arrangements need a separate review?
A contract-wide minimum, mixed taxation, foreign currencies, free promotional funds, reversals of prior-period spend and advertiser-direct platform payments or refunds require separate treatment.
Termination penalties, legal refund rights, guaranteed performance and unrealized revenue are not calculated.
Separate these transactions rather than forcing them into the current fields.
2026 sources and items to recheck
Official sources were checked on 2026-11-22.
The Korean National Law Information OPEN API returned the current Value-Added Tax Act, ID 001571, MST 276117; Articles 29, 30 and 31 were checked directly.
Act No. 21065 was promulgated on 2025-10-01 and took effect on 2026-01-02.
The cited provisions support the separation of taxable value and VAT and the standard 10% rate; they do not establish agency fee rates or repayment rights.
- Korean Value-Added Tax Act: confirm the actual transaction’s tax treatment separately.
This calculator does not prepare a VAT return or determine deductible input tax. - NAVER Ads Bizmoney transaction history help: official help updated 2026-11-05 and marked as AI-written by the provider.
Used for distinguishing ledger fields and paid versus promotional funds, not as evidence of an agency fee agreement. - NAVER Ads advertising refund guidance: platform policy updated 2026-07-14.
Do not generalize one platform’s processing policy into an agency repayment obligation or another platform’s rules.
Recheck contract bases, VAT, billing units, minimums, repayment conditions and completed transactions each time you use the tool.
Review changes to legislation and public platform guidance quarterly.
Tax treatment and legal disputes require separate confirmation using the original documents.
Keep evidence for every statement difference
Enter the actual ledger and contract, then compare agency fees, wallet funds and the repayment or additional payment reference separately.
Save the TXT review sheet with unresolved items, request written confirmation of the supporting amounts and repayment date, and rerun the same check when the statement is corrected.
Related calculators
- Search Ads Agency vs In-House Break-Even CalculatorCompare agency fees with in-house loaded labor, CPC, conversion rate, and contribution value to estimate total cost, CPA, ROI, budget break-even, and crossover time.
- Hospital Marketing Patient Acquisition ROI CalculatorConnect marketing cost, inquiry-to-first-visit conversion, attribution, patient revenue, and contribution margin to estimate CAC, ROAS, ROI, payback, and break-even inquiries.
- Branding Agency vs In-House TCO CalculatorCompare agency strategy, rollout, retainer, production, oversight, risk, delay, and handoff with in-house loaded labor, tools, specialists, turnover, and residual value.
- Video Production Estimate & Campaign Payback CalculatorBuild a video production estimate and connect campaign spend to incremental contribution profit, ROI, and payback.
- Product Detail Page Production Cost & Conversion ROI CalculatorBuild a product detail page production quote, then connect page views, baseline and target conversion, refunds, attribution, and contribution margin to ROI and payback.
- Cash Runway CalculatorEstimate how long available cash can support a business under current revenue and expense assumptions.