Build a commission source register that reviewers can trace

Commission preparation begins with the plan version, effective date, eligible population, sales period, and approving owner. Keep the signed or approved plan with the workpaper. Do not infer a rate from a prior month or from a spreadsheet someone forwarded without context. The bookkeeper can record the plan reference and identify missing terms. The business owner or authorized finance reviewer decides how the plan applies to an unusual sale, territory, return, or employment event. A versioned plan protects the team from calculating a precise number from an outdated rule.

List the transactions, people, teams, accounts, or projects included in the period. Record report filters, extraction time, entity, currency, and exclusions. Link sales records to orders, invoices, delivery or acceptance evidence, returns, credits, and cancellations where the plan requires them. The bookkeeper can prepare the population and flag records that cannot be matched. The reviewer approves the definition of completeness. A commission register should make it possible to explain both what was included and what was left out. Without that boundary, a dispute about one transaction can become a dispute about the whole calculation.

Put source values in one set of fields and proposed calculations in another. Preserve sale amount, invoice status, return, credit, date, owner, and source reference as observed. A formula can show how the draft was calculated, but it does not establish that the plan applies. The support role should not change a source record, approve a compensation exception, or decide an employment question. When a result depends on a plan clause, write the clause and ask the authorized reviewer to confirm the interpretation. This makes the calculation auditable and keeps a disputed conclusion from looking like source data.

Commission inputs can change after the period closes. Returns, credits, cancellations, late invoices, and corrected customer records should enter a change log. Record the original value, new value, reason, source, preparer, and review status. Do not overwrite the first calculation without leaving history. The bookkeeper can update the draft and show the effect of the change. The reviewer decides whether the plan calls for an adjustment, a hold, or a separate exception. A visible change log helps the owner answer why a payroll or accounting packet differs from the earlier version.

Escalate transactions involving disputed ownership, split credit, plan ambiguity, unusual timing, a return after payment, or a person whose eligibility is unclear. Include the facts checked, plan reference, proposed options if the procedure allows them, decision owner, and deadline. Avoid asking a reviewer to “confirm commission” without showing the underlying question. The bookkeeper can maintain the queue and request permitted evidence. The authorized owner keeps compensation, employment, and policy decisions. An explicit boundary reduces rework because a reviewer can answer the real question instead of correcting an unauthorized assumption.

A commission source register is not a payroll approval and not an accounting entry. Use named accounts and least privilege for sales, payroll, and accounting systems. Keep the preparer from approving its own calculation or changing payroll inputs without authorization. The final handoff should identify the period, total draft, exceptions, source reports, plan version, reviewer, and next action. If the payroll cutoff arrives before a dispute is resolved, follow the written hold or escalation path. Never remove the dispute to meet the deadline. Record what was paid or posted and why the authorized reviewer accepted it.

Track population completeness, first-pass agreement, missing sources, returned calculations, late changes, and time waiting for decisions. Segment errors by source system, plan ambiguity, data timing, and preparation mistake. A high agreement rate can be misleading if difficult cases were excluded. Sample ordinary transactions and exceptions. Ask whether another preparer can reproduce the result from the plan and sources. Use findings to improve the report filter, source ownership, plan wording, or review question. The goal is a repeatable packet, not an unsupported speed metric.

Name the system of record for sales, customer adjustments, returns, and payroll input. When two reports disagree, record both report dates and filters instead of choosing the larger number. Ask the system owner which report should control future runs, and retain the answer with its effective date. The bookkeeper can prepare this comparison and update the data dictionary. The authorized reviewer decides whether the current calculation can proceed while the report definition is repaired. This note prevents a recurring disagreement from being blamed on the person doing the calculation when the real problem is an unstable source.

The final packet should show whether the reviewer approved the draft, approved it with a listed exception, returned it for new evidence, or deferred the question. Preserve the plan clause and source reports that supported the response. The bookkeeper can update the status and attach the decision. It should not turn an informal message into a formal approval unless the written process recognizes that channel and authority. A clear boundary protects both the business and the person preparing the register. It also explains why a later payroll or accounting adjustment differs from the first draft.

Keep the plan version, population, source reports, calculation, change log, exception decisions, and final handoff together. Preserve the calculation used at approval and record later corrections separately. Update the procedure when a plan, sales system, payroll cutoff, entity, or approval path changes. Offshore bookkeeping support can organize commission preparation without deciding compensation policy. The durable standard is a register that shows where every input came from, how a draft was calculated, and which authorized person accepted the remaining questions.