Guides
Straight answers to the questions owners actually ask.
Short, honest, no email needed.
Start with a free assessment.
Should I just build my own software instead of paying for this?Sometimes. Get four answers in writing first: who maintains it, what support costs, how you'd leave, and whether its rules fit on one page. Then check four security basics. Usually the cheaper fix is tidying the spreadsheet that fills the gap, or connecting two tools you already pay for. Build only when the gap is stable and written down, and the price is mostly for features you don't use.How do I stop copying between spreadsheets for my daily report?The manual copying is a join: matching rows from one file to rows in another by a shared column. Power Query does this automatically: once you set it up, the report refreshes in seconds, not an hour.What do I do when MYOB's Send to Excel button does nothing?MYOB hands the report to Excel behind the scenes. If either side can't see the other, nothing happens and usually no error shows. Three documented causes cover almost every case: the wrong Excel version, including a community-reported 32-bit/64-bit issue to confirm with MYOB. The other two are missing export template files and a security setting blocking the old template format.Why won't my neat tracking sheet give me reports?Almost every tracking sheet that won't report has the same structural problem, not a formula problem. One header row, one row per thing, one type of information per column, and nothing else inside the table. Once you can see it, this is a fix rather than a rebuild.Do I need a CRM when I've hit 5–10 clients?Probably not yet. At 5 to 10 clients what's broken is usually a missing next-action list and a fixed time to check it, not a missing database. Add both, then let what happens next tell you whether a CRM earns its keep.How do you manage estimates and quotations when every project is different?When every project is unique, the problem usually isn't the quoting tool. It's that your standard rates live in your head, and accepted quotes never become jobs on their own.How do I stop rebuilding the same weekly report by hand?The weekly report is almost always the same four manual steps done fresh each time: export, reshape, total, send. They sit in different places rather than in one chain. Fix the steps one at a time: a clean export, one flat table, formulas instead of retyped totals, then a saved query or a schedule.What breaks first when Google Sheets stops being enough for my business?It's rarely the spreadsheet itself. It's usually one of four problems. Edits overlap, only one person understands the formulas, nobody checks version history, or the sheet no longer fits the business. Name which one you have before assuming you need new software.Will I still see my old invoices after cancelling MYOB?Cancelling usually ends your access to the software's copy of your records at some point. Take your own copy before you cancel, not after.Why does my monthly total come back as zero after a payroll export?When a CSV export stores dates as text instead of real dates, any formula that adds by date range silently returns zero. The fix is two minutes; the check cell that makes it obvious is two more.How do I quote one total without showing every line item?Your costed sheet and your client's quote don't have to be the same document. Keep the detail for yourself and send a clean total instead.What do I do when Excel can't track my loaned samples?A spreadsheet usually fails at loan tracking because it has no due-back date and no way to flag what's overdue. Not because it's a spreadsheet.Why does the manual step always sit between two teams?Your spreadsheet is your org chart. That manual step almost always sits exactly where two teams stop talking to each other. Fix the handover, not just the formula, or the workaround grows back.
Not sure if yours needs fixing?
Start the sixty-second check ↗