Bordereaux data cleaned, checked and reconciled — so the numbers you send on, report on and settle from are trustworthy, not just tidy-looking.

WHAT THIS IS This is a specialist cleansing and validation service for insurance bordereaux. I take your bordereaux spreadsheets, check them row by row against your policy and administration data, fix what can safely be fixed, and flag — clearly and separately — anything that needs a decision from you. You receive a clean, usable file plus a written record of every change and every open item, so nothing is silently overwritten and nothing important is buried.

WHO THIS IS FOR This service is for insurance MGAs, brokers, coverholders and their operations teams who receive, prepare or submit bordereaux and need the data to reconcile before it goes further. It is especially useful when bordereaux arrive in different layouts, with inconsistent codes, missing fields, duplicate records or totals that do not agree with your policy or administration records.

PROVEN SAMPLE RESULT This is a real, already-proven service. In a 200-row sample, 74 planted errors were found: 55 were fixed directly, and 19 were flagged for client action where a client decision or source confirmation was needed. That sample shows the approach in action: errors are found and counted, fixes are made transparently, and the items that cannot safely be fixed without you are not guessed at — they are listed for your action.

WHAT YOU RECEIVE • A cleaned and validated bordereaux file in Excel or Google Sheets, in a clear, consistent layout • A validation and error log showing what was checked, what was fixed and what was flagged • An exception and client-action list, with one row per open item and the decision or information needed • Reconciliation checks against the policy and administration data you provide, with differences highlighted • A short written summary of the file: rows checked, errors found, errors fixed, items flagged, and totals before and after cleaning • Files delivered via Contra, with all communication in writing

HOW IT WORKS — STEP BY STEP

You send the bordereaux file and your policy or administration reference data, with a short written brief on the period, format and any known issues.

I confirm the scope in writing: files, row count, fields to be checked, validation rules and the fixed price, before work starts.

I profile the file — structure, field formats, codes, dates, amounts, duplicates and missing values — and agree the cleaning rules with you where a rule is not already clear.

I clean and standardise the data: formats, dates, codes, names and amounts, with duplicates identified and handled as agreed.

I validate the cleaned file against your policy and administration data, checking for missing, unmatched, duplicated and inconsistent records, and for totals that do not reconcile.

I produce the error log and the client-action list. Anything that can be fixed safely is fixed; anything that needs your decision is flagged, not guessed.

You review the cleaned file and the action list, confirm the flagged items or supply the missing information, and I finalise the file and summary.

WHAT I NEED FROM YOU • The bordereaux file or files in Excel, CSV or Google Sheets • Your policy or administration reference data for the same period, or the mapping that links bordereaux records to it • A short written brief: the reporting period, the source of the file, and any field definitions, code lists or known exceptions • Confirmation of how duplicates, missing values and unmatched records should be handled, where your house rules apply • A written contact point for decisions on the client-action list — no calls are needed

WHAT IS NOT INCLUDED • Insurance, underwriting or regulatory advice, and decisions on cover, pricing or claims • Changing data in your source or administration system — I clean and validate the bordereaux file you provide • Contacting insurers, brokers or policyholders on your behalf • Rebuilding a bordereaux from source documents where no bordereaux file is supplied • Guarantees about a third party's system, data or acceptance of the file — if a recipient rejects a record, the reason is recorded and the fix is quoted fairly • Anything that requires voice or video calls: brief, progress updates, decisions and delivery are all in writing

PRICING Fixed trial up to 1,000 rows: $495. Larger bordereaux are quoted in writing before work starts, based on row count and complexity. Follow-on monthly support is available for regular bordereaux cycles — scope and price are agreed in writing in advance, so there are no surprises.

WHY BUY FROM ME I am a spreadsheet and data specialist with 7+ years of experience in Excel, Google Sheets, data cleaning and validation, working in writing with clients worldwide. Bordereaux work rewards care over speed: every fix is logged, every open item is named, and every total is checked. If a record cannot be validated safely, I will say so and flag it, rather than present a clean-looking file that does not reconcile. Communication is written-only, and payment is via Payoneer or bank transfer, as agreed in writing before work starts.

Everything runs in writing — brief, sample checks, progress updates and delivery — no calls needed. Send your bordereaux file and reference data, and I will reply with a written scope, fixed price and delivery date.