How do we replace paper fundraising forms and spreadsheets?

Choose a clean point to switch

The easiest boundary is often the start of the next fundraiser. Finish the current paper campaign, reconcile it and use the online page for the new one. Changing systems halfway through can be worthwhile, but someone must own the remaining paper forms and explain how they fit with the online records.

Write a switch-over time and tell every volunteer who takes orders. If families still need an offline route, assign one organiser to handle it. Do not leave a classroom envelope, a personal message inbox and a public order link operating as three unconnected records with different cut-off dates.

From [date and time], please place new orders through [fundraiser link]. If you already submitted a paper form, do not order again. Contact [organiser] for an amendment or help ordering. We will confirm your existing order separately if any details are missing.

Reconcile what you already have

Number the paper forms or give each existing order a stable reference. Compare the forms with the spreadsheet before any transfer. A row without a phone number may be incomplete; two rows with the same surname may be separate orders. Investigate rather than automatically merging them.

Keep payment evidence separate from a supporter's preferred payment method. A bank-transfer option means that route was selected, not that the money arrived. Ask the treasurer to confirm amounts received and record who resolved each discrepancy. Do not put bank statements or payment screenshots in a shared public folder.

Confirm the supported workflow before copying data

Ask the platform which existing-order workflows it supports. Do not assume a CSV export from one system can become an import into another. Product names, variants, payment status and collection fields may not match. Test any supported transfer with non-sensitive sample data before attempting the real records.

If a transfer is not supported, you can keep a reconciled legacy register and use the new system only for new orders. Assign distinct references, then combine totals once at the supplier-order stage. Never ask supporters to repay just to create a matching online transaction. An already-paid order needs a record, not another charge.

Keep buying quantities separate from packing lists

A supplier summary answers how many of each item to buy. A packing list answers what goes in each supporter's order. Build both from the same checked set of orders, then make sure the product quantities agree. Exclude cancelled entries and handle unpaid orders under the policy you told supporters.

For example, 40 paper orders and 60 online orders do not necessarily mean 100 unique orders. If five families submitted both, you need to resolve those five cases before adding the totals. Record which version remains and whether any payment needs attention. Keep the example separate from your real campaign figures.

• Set one final amendment deadline and identify who can approve exceptions.
• Confirm the combined quantity for every product option.
• Give collection volunteers only the information they need.
• Mark handovers in one record to avoid handing an order out twice.

Leave the next organiser a simpler process

Once the campaign is reconciled, close obsolete order links and update the instructions families see. Store financial records under your organisation's retention policy and limit access to supporter details. A general volunteer handover should describe the process without copying everyone's private information into it.

Note the fields that caused confusion and the reports you actually used. Update the next campaign's product descriptions and collection instructions before launch. Moving online is useful when it reduces repeated work; a second spreadsheet that everyone edits independently can recreate the original problem.