MisaNeco Works Blog

MisaNeco Works Blog

Practical guides to automating everyday admin for small businesses in the US, UK, Canada and Australia — every fact checked against official sources. Tap any card to read the article.

Free tools (no sign-up, runs in your browser)

Bookkeeping & tax8

2026-10-21How to number your invoices (a simple system, plus a formula that does it for you)

A simple invoice numbering system for freelancers and small businesses (year plus a running number, like 2026-001), why it works, a formula that numbers invoices automatically in Excel or Google Sheets, and what to do about cancelled or corrected invoices. UK rules checked against GOV.UK.

InvoicingSmall businessExcel
2026-10-20Paying freelancers in the US - Form W-9, Form 1099-NEC and a simple tracking sheet

A plain-English guide for small US businesses that pay contractors. When to ask for a Form W-9, what Form 1099-NEC reports, the current threshold and deadline, and a spreadsheet layout that keeps January stress-free.

AutomationSmall businessUS tax
2026-10-20Track unpaid invoices in Google Sheets (with overdue days and red rows)

A simple invoice tracker that counts days overdue, colours late invoices red, and shows only the ones you need to chase. Works in Excel too, plus a polite reminder email you can copy.

AutomationSmall businessInvoicing
2026-10-20A simple monthly expense tracker in Google Sheets or Excel (with SUMIFS totals)

Log receipts, pick a category from a dropdown, and see spending by month and category with SUMIFS. Includes a missing-receipt check and a file naming tip. Works in Excel and Google Sheets.

AutomationSmall businessBookkeeping
2026-10-20Making Tax Digital for Income Tax - who must join, when, and a simple spreadsheet checklist

A plain-English guide to Making Tax Digital for Income Tax for UK sole traders and landlords. Who must join and when, what digital records and quarterly updates mean, and a spreadsheet setup you can copy.

AutomationSmall businessUK tax
2026-10-20What a GST/HST invoice must show in Canada - a checklist and invoice template layout

The information the CRA says an invoice needs so your customers can claim input tax credits, by sale amount (under $100, $100 to $499.99, $500 or more), plus a checklist and a simple invoice layout for small businesses.

AutomationSmall businessCanada tax
2026-10-19How long to keep business records in the US, UK, Canada and Australia (and a simple filing system)

The official record-keeping periods for small businesses in four countries, checked against IRS, HMRC, CRA and ATO pages, plus a folder and file-naming system that makes old receipts easy to find.

AutomationSmall businessBookkeeping
2026-10-19How to Automate Invoicing and Payment Follow-Up

Automate invoicing and payment reminders step by step with a spreadsheet, email templates and bank files, with notes for the US, UK, Canada and Australia.

AutomationSmall businessInvoicing

Small business guides2

Spreadsheets & automation15

2026-10-21Password rules for a small business: what NIST SP 800-63B-4 (2025) actually says

A plain-English summary of the password rules in NIST SP 800-63B-4 (final, July 2025) — minimum length, no forced complexity, no scheduled resets, blocklists, password managers — and a short policy a small business can copy.

Security
2026-10-21How to calculate prorated rent (3 methods, with Excel formulas)

Prorated rent for a move-in or move-out month, explained with the three common methods (days in the month, a 30-day month, a 365-day year), worked examples, Excel and Google Sheets formulas, and what to check in your lease.

HousingExcel
2026-10-21How to work out the business-use share of home costs in a spreadsheet (US and UK)

A simple Excel or Google Sheets layout for splitting rent, utilities, phone and internet between business and personal use, plus the flat-rate options from the IRS and HMRC to compare against.

Small businessExcelTax records
2026-10-21How to find reused and weak passwords (and which ones to fix first)

A short guide for small businesses and freelancers: use your browser's built-in Password Checkup to find compromised, reused and weak passwords, decide what to fix first, and handle an exported password file safely.

Security
2026-10-21When someone leaves: an account offboarding checklist for small businesses

What to switch off, change, collect and record on the day an employee, part-timer or contractor leaves a small business, with a copyable checklist. Based on Japan's IPA security guideline for SMEs (version 4.0, March 2026).

Security
2026-10-21Clicked a phishing link at work? What to do next (small business checklist)

Someone on your team clicked a link in a suspicious email, or typed a password into a fake login page. What to do next, step by step, based on the UK National Cyber Security Centre's phishing guidance, with a short checklist for small businesses.

Security
2026-10-20Build a weekly staff shift schedule in Google Sheets (hours per person, gaps highlighted)

A weekly rota with shift codes, automatic hours per person, red cells when a shift is short of staff, and a view-only link for your team. Formulas also work in Excel.

AutomationSmall businessExcel
2026-10-20Simple job costing in a spreadsheet - see if each job actually made money (Excel or Google Sheets)

Log materials, labour and subcontractor costs against each job, total them with SUMIFS, and see profit and margin per job. Low-margin jobs light up on their own. Works in Excel and Google Sheets.

AutomationSmall businessExcel
2026-10-20Save Gmail attachments to Google Drive automatically (free Apps Script)

Label an email in Gmail and its attachments are saved to a Google Drive folder within the hour. A short Google Apps Script, one label, one trigger. No add-ons.

AutomationSmall businessGoogle Apps Script
2026-10-20How to raise your prices as a small service business - a simple calculation and a customer letter template

Check your margin, model a price rise for each regular customer in Excel or Google Sheets, and tell customers with a short, clear letter. Includes two email templates and a checklist.

AutomationSmall businessExcel
2026-10-20A simple quote-to-job tracker for trades and service businesses (Excel or Google Sheets)

Track every quote you send, see which ones need a follow-up call today, and work out your win rate with one COUNTIFS formula. Works in Excel and Google Sheets.

AutomationSmall businessExcel
2026-10-20A simple inventory tracker with low-stock alerts (Excel or Google Sheets)

Log stock in and out, let SUMIFS work out what you have on the shelf, and turn items red when they hit their reorder point. Works in Excel and Google Sheets, plus an optional Apps Script email alert.

AutomationSmall businessGoogle Apps Script
2026-10-20A simple customer follow-up sheet (CRM-lite) for small service businesses

Track last contact and next action for every customer, see who is due today, spot customers who have gone quiet, and count your pipeline with COUNTIFS. Works in Excel and Google Sheets.

AutomationSmall businessExcel
2026-10-19Clean up a messy customer list in Excel or Google Sheets (5 formulas, 10 minutes)

Extra spaces, random capital letters, duplicate customers and mixed phone formats. Five simple formulas and two built-in tools fix most of it, in Excel and in Google Sheets.

AutomationSmall businessExcel
2026-10-19Send appointment reminder emails automatically with Google Sheets (free, no add-ons)

A short Google Apps Script that emails each customer the day before their appointment, using a simple Google Sheet. Copy, paste, set one trigger, done.

AutomationSmall businessGoogle Apps Script