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.
Bookkeeping & tax8
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 businessExcelPaying freelancers in the US - Form W-9, Form 1099-NEC and a simple tracking sheetA 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 taxTrack 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 businessInvoicingA 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 businessBookkeepingMaking Tax Digital for Income Tax - who must join, when, and a simple spreadsheet checklistA 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 taxWhat a GST/HST invoice must show in Canada - a checklist and invoice template layoutThe 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 taxHow 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 businessBookkeepingHow to Automate Invoicing and Payment Follow-UpAutomate 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 businessInvoicingSmall business guides2
Nine small-business admin jobs for trades, from quotes to invoices, each with what is tedious, a few simple ways to fix it and a first step.
AutomationTradesSmall businessSimple automation for a small hair or beauty salonSeven small admin jobs a salon or barbershop can simplify with tools it already has: booking, client records, rebooking, stock, takings, rota and replies.
AutomationSalonSmall businessSpreadsheets & automation15
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.
SecurityHow 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.
HousingExcelHow 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 recordsHow 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.
SecurityWhen someone leaves: an account offboarding checklist for small businessesWhat 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).
SecurityClicked 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.
SecurityBuild 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 businessExcelSimple 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 businessExcelSave 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 ScriptHow to raise your prices as a small service business - a simple calculation and a customer letter templateCheck 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 businessExcelA 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 businessExcelA 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 ScriptA simple customer follow-up sheet (CRM-lite) for small service businessesTrack 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 businessExcelClean 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 businessExcelSend 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