Book a demo

Moving from an old system

MemberCrew imports your club's existing members, memberships, invoices, payments, vehicles and log books, and keeps them up to date from your old system until the committee is ready to switch. This page explains how the move works and how to prepare your records for it.

Last updated

How the move works

MemberCrew moves your club’s existing records across, so the committee does not start from a blank screen. We import members, memberships, invoices, payments, vehicles and log books, and keep MemberCrew up to date from the old system until you are ready to switch.

Most clubs keep their records in more than one place: a membership spreadsheet, a separate log book register, a list of payments, sometimes an old database that only one person knows how to use. The move brings those together into one set of records.

What we import

MemberCrew imports the records that matter for running a club and meeting the Scheme.

RecordWhat it covers
MembersThe club’s member list and each member’s details
MembershipsEach member’s memberships and their history
Invoices and paymentsWhat members were invoiced, and what they have paid
VehiclesMembers’ vehicles, each linked to its owner
Log booksLog books issued, each linked to its vehicle

If your club keeps something else you want brought across, raise it in the first chat.

Once the records are in, they work like any other records in MemberCrew. Members have statuses and renewals, vehicles carry their log book history, and the committee overview shows live figures from them.

Running both systems side by side

During the changeover, MemberCrew is brought up to date from the old system’s records until the club is ready to switch over. The committee keeps working as it does now, and MemberCrew catches up without losing anything already entered in MemberCrew.

This matters because clubs rarely have a quiet time to stop and move. Renewals come in, new members join, log books are issued. Running both side by side means none of that has to pause, and the committee chooses when to switch.

It also gives the committee time to check MemberCrew against what it already knows. If the membership count or the list of current log books does not match, there is time to find out why before relying on the new records.

The four steps

Getting started follows four steps.

StepWhat happens
1. A chatWe talk about how the club runs, what records it keeps and where
2. Data moved acrossWe import the club’s records and keep them up to date from the old system
3. Committee shown aroundWe show the committee how MemberCrew works with their own club’s records
4. Go liveThe club switches over and works in MemberCrew from then on

There is a one-off setup fee to move the club’s records across, quoted per club. The pricing page covers the monthly plan.

Preparing your data

You do not have to clean up your records before you start. We work through them with you. But a little preparation makes the move quicker, and it is worth doing for its own sake. The steps below apply whichever system your club moves to.

1. Find every list

Start by finding every place the club keeps member and vehicle information. Ask each committee member, and past committee members if you can.

Common places include:

  • the main membership spreadsheet
  • the club registrar’s log book register, on paper or in a spreadsheet
  • the treasurer’s record of payments, or the bank statements
  • the magazine mailing list
  • old databases or exports from a previous system
  • application forms in a folder

Gather copies in one place. Do not change the originals yet.

2. Decide which list is right

When two lists disagree, the committee needs to decide which one to trust for each kind of information. This is often called the “source of truth”.

For example, the treasurer’s payment records are usually the best source for who has paid. The registrar’s log book register is usually the best source for which log book is with which vehicle. The magazine list may have the most recent addresses.

Write down the decision for each kind of information, so whoever does the move knows which list wins when they disagree.

3. Clean up duplicates

Most clubs find the same member or vehicle entered more than once, often with small differences in spelling or a missing detail. Clear up the obvious ones before the move if it is easy.

Do not worry about getting every duplicate. MemberCrew finds duplicate registration records for vehicles after the move. Registrars can review them and an admin merges them, so a single vehicle ends up with a single history.

4. Check plates and log book numbers

Vehicle plates and log book numbers matter more than most fields, especially for clubs on the Conditional Registration Scheme. Check them against the paperwork where you can.

Things to look for:

  • plates entered with or without spaces, or with letters and numbers mixed up
  • vehicles with more than one current log book recorded (an owner must not have more than one current log book for a vehicle under the Code, clause 3.5g)
  • log books still shown as current for members who have resigned (the Code asks clubs to cancel them, clause 2.29)
  • log books more than three years old still shown as current (the Code, clause 2.28)

If you keep the register on paper or in a loose spreadsheet, the log book register template shows the columns worth tracking. The vehicles and log books page shows how MemberCrew holds them.

5. Keep the old files

Once you have switched, keep the old files. Do not delete them.

They are the record of how things stood before the move, and they are useful if a question comes up later. For clubs on the Scheme, the Code asks recognised clubs to keep records of all vehicles with an MR334, all log books issued to financial members, and other Scheme records such as membership records and minutes for five years from the date of each document (the Code, clause 2.39).

Store the old files somewhere the committee can find them, not on one person’s laptop.

Common surprises

A few things turn up in most clubs’ records, and it helps to expect them.

Life and honorary members are often recorded in different ways over the years: a note in a comments column, a zero fee, or a separate list. Decide how each one should be recorded before the move. Vehicles are sometimes listed under one partner’s name when both own them. For Scheme vehicles that matters, because if a vehicle is jointly owned, all owners must be financial members (the Code, clause 3.1). And resigned members often linger on the magazine list long after they have left the club.

Who does what

We move the records across. The committee’s part is to send us what it has, answer questions about anything that is unclear, and check the result.

TaskWho
Gather the club’s lists and filesThe committee
Decide which list is right when they disagreeThe committee, with our help
Import members, memberships, invoices, payments, vehicles and log booksMemberCrew
Keep MemberCrew up to date from the old systemMemberCrew
Check the result against what the committee knowsThe committee
Show the committee aroundMemberCrew
Decide when to switchThe committee

A good time to switch

There is no wrong time to start, because the old system keeps running until the club switches. Some committees prefer to go live before renewal season, so renewals for the new club year are handled in MemberCrew from the start. Others prefer to switch after the AGM, when a new committee takes over. The committee handover checklist covers what to pass on at that point.

If your club runs on spreadsheets today, the comparison with spreadsheets sets out honestly where spreadsheets work and where they start to cause problems.

Start with a chat

The first step is a conversation about how your club runs and what records it keeps. Book a demo and we will take it from there.

Common questions

What can you import?

MemberCrew imports the club's existing members, memberships and their history, invoices and payments, vehicles and log books. Those are the records most clubs keep across spreadsheets, an old database and paper registers. If your club keeps something else you want brought across, raise it in the first chat.

Can we keep using our old system during the move?

Yes. During the changeover, MemberCrew is brought up to date from the old system's records until the club is ready to switch over. The committee keeps working the way it does now, and nothing already entered in MemberCrew is lost when it is brought up to date.

How long does the move take?

It depends on the club's records: how many there are, how many places they are kept in, and how tidy they are. We will give you a realistic picture after the first chat, once we have seen what you have. There is no fixed timetable to fit into.

What does it cost to move our records?

There is a one-off setup fee to move the club's records across, quoted per club. The quote depends on what your records look like, so we give it after we have seen them. The monthly plan is priced separately by the number of current members.

Do we have to clean up our data before we start?

No, but it helps. A little preparation, such as gathering every list in one place and deciding which one is right, makes the move quicker. We work through the rest with you.

What about duplicate members or vehicles?

Most clubs have some, usually because different volunteers kept their own lists over the years. MemberCrew finds duplicate vehicle registration records for review, and an admin merges them. We work through duplicate members with you during the move.

What happens to our old spreadsheets?

Keep them. Once the club has switched, the old files are a record of how things stood before the move. Clubs on the Scheme must keep certain records for five years (the Code, clause 2.39), so do not throw old registers away.

Who does the work of moving the records?

We move the records across. The committee's part is to send us what it has, answer questions about anything unclear, and check the result. After that, we show the committee around before the club goes live.

See it with your own club in mind.

Bring whoever does the club’s paperwork. We will show you around and answer the committee’s questions.