Build a franchise marketing-fund ledger that separates collections and spend

A useful fund ledger keeps the collection side and spending side separate, then joins them through a monthly rollforward. It provides evidence for review without asking bookkeeping to decide what the franchise agreement permits.

Create one assessment record for each franchise location and reporting period. Capture the location identifier, agreement version, assessment base, reported sales or other approved input, rate, minimum or cap, amount due, billing date, invoice, and payment status.

Reconcile the location population to the franchise system. New, transferred, temporarily closed, and terminated locations need explicit treatment. Do not omit a location because its sales report is missing. Keep it in the population with an exception so management can decide the next step.

Store the reported input and the calculation separately. If a location later revises sales, retain the first report, revised report, reason, approval, and resulting adjustment. Replacing the original value makes the billing history difficult to reproduce.

Apply receipts to the location and assessment period identified by remittance detail. A single payment may cover several periods or include royalties and other charges. Split it from evidence rather than applying the full deposit to the oldest marketing balance by default.

Record invoice amount, credit, cash applied, unapplied cash, short payment, and ending receivable separately. This shows whether a difference is a collection issue, an approved adjustment, or a missing allocation.

If the franchisor contributes to the fund, identify the contribution source, date, amount, approval, and ledger reference. Do not blend corporate contributions with franchisee assessments. Reviewers may need to understand each source independently.

Set up a campaign record before invoices arrive. Capture the campaign name, market, approved budget, vendor, contract or purchase authorization, service period, launch dates, owner, and approval. Link invoices, credits, prepayments, and payments to that record.

Campaigns often cross month end. Separate the vendor invoice date from the service period and from cash payment. The controller can then decide the appropriate accounting treatment using the contract and evidence. The offshore preparer can schedule the amounts under an approved policy but should not invent a service period from the payment date.

Keep production, media placement, agency fees, technology, and other spend categories visible. A campaign total can agree while a vendor invoice is coded to the wrong category or market. Use the approved chart and campaign map rather than free-text descriptions.

A national campaign may benefit all locations, while a regional placement may serve only a subset. Record the campaign scope and any allocation rule approved by management. Retain the population and inputs used for the allocation.

Consider a digital campaign purchased nationally with separate regional creative. The national media invoice, regional production costs, and local credits should remain distinct. If management allocates information to locations for reporting, the schedule should show the rule and result without implying that the allocation changes the underlying vendor cost.

Local advertising reimbursements need their own review queue. Link the location request, proof of spend, program terms, approval, payment, and any rejected component. A submitted request is not fund spend until it meets the approved process.

Match vendor invoices to contracts and campaign records. Flag invoices with missing service periods, duplicate numbers, amounts above authorization, unexpected markets, or no campaign owner. Record credits against the original invoice and campaign instead of reducing the next convenient payment.

For prepayments, retain the payment date, covered service period, campaign, amortization or release schedule approved by management, and posting references. A payment leaving the bank does not prove that the entire amount belongs in current fund spending.

Track disputed invoices and expected credits gross. Netting an anticipated credit into campaign cost makes the fund appear settled before the vendor agrees. The exception should state the amount, evidence, owner, and next follow-up date.

The monthly ledger should show opening fund balance, franchisee assessments, corporate contributions, approved credits or adjustments, campaign spending, reimbursements, and ending balance. Reconcile collections to receivables and bank activity. Reconcile spending to invoices, prepayments, accounts payable, and cash.

Tie each total to the exact entity, account, and period. Explain timing differences rather than forcing the subledger to the general ledger with an unidentified plug. Keep intercompany activity separate if another entity pays a vendor or receives collections.

The reviewer packet should include location assessment exceptions, aged unpaid amounts, campaign budget-to-actual detail, unapproved reimbursements, vendor disputes, and the fund rollforward. Management reporting support can carry the approved results into a recurring packet.

Bookkeeping can maintain location populations, calculate assessments from approved inputs, match receipts, index campaign evidence, prepare vendor schedules, and verify postings. Management retains interpretation of franchise agreements, permitted uses, allocation rules, budget approval, disputes, write-offs, and presentation decisions.

Document each management decision with its effective period and approver. That makes the next close repeatable without turning an earlier exception into an unwritten rule. Bookkeeping services can support the recurring preparation within this boundary.

• U.S. Small Business Administration, Manage your finances
• IRS, Recordkeeping