Real jobs, real clients

What the work actually looks like.

A few jobs I've done for clients, written up so you can see what happens when you get in touch. Each one started with a problem that was eating someone's time.

Technical support

Technical support when things go wrong

Nikki runs her own virtual assistant business. She has come back to me whenever something technical goes wrong.

Three separate jobs

  1. Job one

    DNS after a host move

    Nikki moved her website to a new host, and the domain's DNS records weren't pointing where they needed to, so parts of her site and her email stopped working. I put the records right so the domain, website and email all pointed at the right places again.

  2. Job two

    Moving her email to Gmail

    On a separate occasion, Nikki wanted her business email in Gmail. I moved her email across, keeping the existing messages and folders, and checked that new mail was arriving correctly.

  3. Job three

    Locked out by a fatal error

    The error logs pointed to a plugin with a missing file. I disabled the plugin to get Nikki's website working again and restore access to WordPress. When the problem returned a few weeks later, I removed it completely to prevent it happening again.

Rory came to the rescue so many times over the space of a couple of weeks, fixing things that should never have broken with a migration, and then fixing more when it inevitably broke again due to updates.

Nikki, virtual assistant

What changed

Each problem was fixed properly, and Nikki knows who to call when the next one comes along.

Technical support and automation

Three jobs, one clinic

Beth runs an aesthetics clinic. Over several months she brought me in for three separate pieces of work.

Three separate jobs

  1. Job one

    Moving her email to Google Workspace

    Beth's two business mailboxes were with her old provider, and she wanted them in Google Workspace. I set up Workspace, moved both mailboxes across with every email and folder intact, and switched the domain over so new mail arrived in Gmail. I also set up her email authentication records (SPF, DKIM and DMARC), and her setup scored 10 out of 10 on a deliverability test. The whole move was done in a day.

  2. Job two

    Moving her website and fixing what was already broken

    Some time later, Beth wanted her WordPress website and domain moved to new hosting that she controlled herself. I moved the site, transferred the domain and set up the DNS so the website and email kept working throughout. Along the way I fixed a problem that had been there for a while: her contact form had stopped sending enquiries. I also put right everything the move threw up, so the site looked and worked exactly as before.

  3. Job three

    Over 11,000 files out of her booking system

    Later still, Beth needed every client's consultation forms and photos taken out of her booking system, one folder per client, leaving out anyone who'd never had a treatment. The system had no bulk export, and the forms weren't even files: they only existed on screen when you clicked to view one. By hand it would have taken well over 40 hours. I wrote a script instead. It went through every client, rebuilt each completed form as a PDF with the client's signature, saved the photos at full size and filed everything into its own folder. It finished with 459 client folders, 6,761 photos, 3,231 forms and 1,496 other documents, plus a log showing nothing had failed. I handed it all over and deleted my copy.

What changed

Her email, website and records are now on systems she owns and controls, and none of it disrupted the clinic.

Business admin

Making market admin easier across seven venues

Laura runs farmers markets and needed help getting her admin organised, particularly the spreadsheets she relied on to manage traders and bookings.

Four separate jobs

  1. Job one

    One trader list instead of eleven

    Laura had a list of 357 traders and ten separate exports from market application forms. I combined them into one list of 479 traders, removed duplicates and organised the categories so she can quickly find the right traders when a market has spaces to fill.

  2. Job two

    A booking sheet she can trust

    Laura's booking spreadsheet covered seven markets, but the prices, colours and formulas had become inconsistent. I rebuilt it so every market works the same way, with bookings, costs, profit and available stalls clearly shown. A yearly summary brings everything together, and the formulas are protected against accidental changes.

  3. Job three

    A mileage log that sorts itself

    Laura records her mileage in Google Sheets and uploads it to her accounting software. I added a script that creates a new tab each year, fills in the details that stay the same and automatically sorts journeys by date as she enters them.

  4. Job four

    A licence counter

    Laura needed to keep track of the temporary alcohol licences used throughout the year. I created a simple tracker that shows how many have been used and how many are still available.

What changed

Laura now has a set of spreadsheets that make managing her seven markets much easier. Trader contacts are in one place, bookings are easier to manage, mileage sorts itself and licence usage is tracked automatically. Less manual checking and fewer opportunities for mistakes.

Got something like this going on?

Tell me what's going wrong and I'll tell you honestly whether I can help.

Free. Fifteen minutes. No hard sell.