Moving a children's home off spreadsheets and paper

Move a children's home off spreadsheets and paper one area at a time, starting with what has clear edges and where the most searching happens: usually staff files and the recurring safety checks, then the rota, then children's records. Bring each child's details and earlier records across in one checked batch, run old and new side by side for a short, fixed time, and keep the old paper files safely rather than throwing them away.

Most homes do not choose paper and spreadsheets. They end up there: a staff tracker someone built years ago, a rota in a spreadsheet, daily logs in a bound book, a fire log on the back of a door. Each one works well enough on its own. The trouble is the joins between them.

Why move a children's home off paper at all?

Not because paper is old-fashioned. Paper is quick, it never runs out of battery, and a bound daily log is hard to tamper with. The case for moving is narrower and more practical:

• A paper record is in one place at a time. The manager reading the log in the office means the night staff cannot add to it.
• Follow-ups depend on memory. An incident written in a book does not remind anybody that the debrief has not happened.
• Spreadsheets do not record who changed what. A date overwritten in a staff tracker leaves no trace.
• Finding things takes longest exactly when time is shortest: during an inspection, or when a placing authority calls.

If none of those is a problem in your home, there is no hurry. If two or three are, it is worth planning the move.

What should a children's home move first?

Start with something that has clear edges, that the manager owns, and that does not involve children's records. That gives you a few weeks to learn the system before the most sensitive records go in.

• Staff files first: each person, their checks, their documents and the dates that lapse. It is often the most out-of-date spreadsheet in the building, and it stands on its own.
• The recurring checks next: fire alarm tests, gas and electrical certificates, the vehicle. You do not need years of history — when each was last done and when it is next due is enough to start.
• Then the rota and timesheets, which touch every member of staff and are best moved at the start of a pay period, not halfway through one.
• Children's records last, once the team is comfortable signing in and recording.

For staff who have been with you for years, you do not need to rebuild their recruitment from scratch. Open a file for each, upload what you hold — the background check, the contract, the references — and set the renewal dates. The gaps you find while doing it are the useful part.

How do you bring children's records into new software?

Carefully, and not by retyping years of logs. There are three practical routes, and a home may use more than one:

• A spreadsheet of the basics: one row per young person with their details, arrival date and keyworker, plus earlier records and medicines if you hold them in that form.
• Scans or PDFs of the existing file, kept against each child as earlier records. Anything that can be printed or scanned can come across this way.
• A full record pack from another home, when a young person moves between homes that use the same system.

Whichever route you take, nothing should go live until somebody responsible has checked it. A missing arrival date, a keyworker who has left, a child entered twice: these are easy to fix in a draft and awkward once they are in the live record.

Two rules are worth holding to. Earlier records should arrive exactly as they were written, with their original date and author, and be marked as imported so nobody mistakes them for work done in the new system. And medicines should never be started from a spreadsheet: set each one up again from the prescription.

Should you run paper and software side by side?

Yes, briefly, and with an end date written down before you start. Running both for a fixed period — often a couple of weeks for each area — catches what the new system does not yet hold and gives staff a fallback while they learn. Running both with no end date is the most common way a move stalls: staff keep writing in the book because it is what they know, the software ends up half-used, and the record is split in two.

• Pick a switchover date for each area and tell the whole team.
• Decide which record counts if the two disagree during the overlap. It should be the new one.
• Have the manager read the new system, not the book, from day one. Staff record where the manager reads.
• At switchover, close the old book with a dated line saying where recording continues.

What should you do with old paper records?

Keep them. Moving to software changes where you record from now on; it does not change how long the records written before need keeping. A scan is a copy, and whether it can ever replace an original is a question for proper advice. Your regulator and your data protection adviser can tell you what applies to your home.

• Box the closed books and files, label them by child or subject and by date range, and store them securely, with a note of where they are.
• Scan what you are likely to need again, such as a current child's file, and keep the scan against that child's record.
• Keep a short written note of what was moved, what was scanned and where the originals are. It answers the question an inspector, or a young person asking about their own history, may put to you later.
• Do not shred anything in the first flush of tidying up.

How Careframe handles this

Careframe brings children's records across three ways — our spreadsheet, documents only, or another Careframe home's record pack — as drafts only the importing manager can see, checked and released one young person at a time. Earlier records arrive marked Imported with their original date and author, and medicines arrive as a note for the manager to set up from the prescription. It does not connect to your old system: the home uploads what it has, and the switching to Careframe page has the detail.

Careframe organises and evidences the work a children's home already does. Nothing here is legal or regulatory advice, and nothing here is a statement of what your regulator requires of you — for that, go to your regulator.