Fee and charge reconciliation

What does the fee and charge reconciliation produce?

Compare posted charges with explicit approved fee disclosures and calculation rules.

Use the exact local files and task-specific inputs listed below. Preparation and review stay in this browser. Inspect all findings before preparing the finalized pack.

What do you need before you start?

• Define the authorized source population and your review rules.
• Keep the unchanged original files and record the snapshot and exclusions.
• Review missing and invalid inputs before preparing the finalized pack.

What information do you enter?

Select the actual local sources and freeze the task-specific inputs below. Keep source files and complete findings private.

• Approved fee disclosures. Exact headings charge_id, account_id, fee_code, currency, basis_amount, rate_percent, fixed_amount, minimum, maximum, valid_from, valid_until, authority_ref.
• Actual charge records. Exact headings charge_record_id, charge_id, account_id, fee_code, currency, charged_on, amount.
• Review reference. Customer-controlled review reference.
• Review owner. Responsible customer reviewer.
• Observation date. Real YYYY-MM-DD date. Effective date intervals include both endpoints.
• Selected source scope. Name actual populations, versions, period and known omissions.
• Population declaration. Choose the explicit working rule before preparing a result.
• Absolute reconciliation tolerance. Nonnegative plain decimal, at most six decimal places. The exact boundary is included.
• Working currency decimal places. Whole number from 0 to 6. This explicit customer rule is not a currency registry lookup.
• Expected fee rounding. Choose the explicit working rule before preparing a result.

What you can download

Every result must identify its supplied facts, assumptions and unresolved items.

Fictional review report (PDF). Editable review (DOCX). Complete fictional pack (ZIP). Requires tailoring and responsible review. Samples use the finalized renderer.

How does the fee and charge reconciliation work?

1. 1
   Select the actual sources

   Approved fee disclosures. Exact headings charge_id, account_id, fee_code, currency, basis_amount, rate_percent, fixed_amount, minimum, maximum, valid_from, valid_until, authority_ref.

2. 2
   Freeze the review rules

   Match charge_id, account_id and fee_code. Calculate approved basis_amount times rate_percent divided by 100 plus fixed_amount, apply optional minimum and maximum, then selected rounding precision. Compare summed actual charges in the exact currency within tolerance. Validate disclosure intervals and unique actual charge_record_id. Missing approvals, mismatched currencies, dates and duplicate records remain unresolved.

3. 3
   Inspect complete findings

   Review all source-linked results and unresolved items. Free JSON and CSV preserve complete results.

4. 4
   Keep recoverable work

   Inputs and exact source bytes save locally and survive reload. Strict restores verify tool identity, input schema, original hashes and parsed bytes before atomic replacement. Earlier generic work, prior checkpoint files and purchases remain preserved separately.

5. 5
   Prepare the finalized pack

   Prepare seven core files and the exact selected attachments, then download them free. Review the fictional sample below.

Method and sources

Apply the steps above to the supported inputs. Use the listed source sections to review the rule basis, assumptions and limits.

• Common Format and MIME Type for Comma-Separated Values FilesCSV mechanics only. This source supplies no customer schema, legal requirement, matching identity, population completeness, threshold or reconciliation rule. Section 2 describes CSV records, field counts, double-quote escaping and embedded commas or line endings.RFC Editor. Reviewed 2026-10-09.

Common questions

What still needs review?

Mechanical working results use exact supplied source populations and your rules. Originals remain unchanged in this browser. No identity, legal obligation, source completeness, currency conversion, suppression consent, refund, cancellation, shipment or external operation is authenticated or performed.

Rate is a nonnegative percentage at most 100. Tax, currency conversion, compounding and undisclosed fee rules are unsupported.

At most 5000 rows, 50 fields, 100000 cells and 5000000 parsed characters per source, 10 MB per file. Exact decimal arithmetic supports 12 whole digits and 6 fractional places.

Complete reviews are bounded to 20000 findings and 15000000 result characters. Split larger populations into explicit source batches.

Formal reports show at most 100 findings and 400 characters per displayed field. Complete sources, findings and working output values remain in Excel and JSON.

Related working records

The related workspace contains working administrative records. Open it for the related administrative task.

Related tools

Browse all financial crime and sanctions tools.

• Complaint deadline trackerApply jurisdiction and product rules. Try the free example, then enter your own inputs and review the result before exporting.
• Complaint response preparationDraft from confirmed facts and outcomes. Try the free example, then enter your own inputs and review the result before exporting.
• Financial promotion checklistReview against the customer’s jurisdiction-specific playbook. Try a free example. Review your inputs and result. No account or payment required.
• Marketing approval workflowRecord versions, reviewers, restrictions and expiry. Try a free example, then review your inputs and the result. No account or payment required.
• Performance presentation checkerCheck methodology, periods, calculations and required review points. Try a free example. Review your inputs and result. No account or payment required.