Tutorials & Guides

Step-by-step guides

Practical, finance-grade walkthroughs — the Excel techniques and the month-end workflows we leaned on for years running multi-location operations.

Reconciliation, bookkeeping & close

• How to compare two lists in Excel and instantly spot what doesn't matchExpected payments in one column, actual deposits in another. Here's the one-minute way to find every mismatch — both directions — and the four traps that fake a mismatch.
• How to reconcile deposits to your bank statement in ExcelA step-by-step method to match the deposits in your books against the deposits on your bank statement in Excel — and find every difference before month-end.
• The month-end close checklist for a small finance teamA practical month-end close checklist — reconcile cash, match deposits, review AR/AP, book accruals, and tie it out — so nothing slips and the numbers hold up.
• Bank reconciliation explainedWhat bank reconciliation is, why your book balance and bank balance differ, and a clear step-by-step method to make them tie — with the usual culprits.
• How to track business mileage for taxes (and keep an audit-ready log)What the IRS requires in a mileage log, the records that survive an audit, and how to track business miles without turning it into a second job.
• Receipt organization and a tax-prep checklist for sole proprietorsHow to organize receipts so they're actually usable at tax time, what records to keep and for how long, and a simple year-round system that beats the shoebox.
• A physical inventory count that doesn't take all weekendHow to plan and run an accurate physical inventory count across one or several locations — prep, counting method, reconciling variances, and cycle counting.
• Chart of accounts basics for small businessWhat a chart of accounts is, how it's structured, and how to set one up that keeps your books clean and your reports meaningful — without over-engineering it.

Excel how-tos

• How to use Flash Fill in ExcelFlash Fill splits names, reformats phone numbers, and pulls invoice numbers out of messy cells — automatically. Type one example, press Ctrl+E, done.
• XLOOKUP vs VLOOKUP: why XLOOKUP winsXLOOKUP looks left or right, defaults to exact match, returns a clean message instead of #N/A, and doesn't break when you insert a column. Here's how to use it.
• Build a PivotTable in four clicksSummarize thousands of rows into a clean total by location or month in about four clicks. Here's the fastest way to build a PivotTable — and keep it current.
• Text to Columns: split data and fix numbers stored as textSplit "Last, First" or a stuck-together date into real columns in seconds — and fix numbers-stored-as-text while you're at it. Here's how Text to Columns works.
• Power Query: clean a report once, refresh it foreverIf you build the same report every month, Power Query records your cleanup once and replays it on next month's file with one click. Here's how to start.
• TRIM and CLEAN: why "identical" values refuse to matchA single trailing space or a hidden character makes two identical-looking values refuse to match. =TRIM(CLEAN(A2)) fixes it. Run it before every lookup.
• How to remove duplicates in Excel the safe wayRemove Duplicates deletes rows in place in a couple of clicks. Here's how to use it safely, choose the right "duplicate" columns, and keep your originals.
• SUMIFS and COUNTIFS: conditional totals that update themselvesTotal or count rows that meet several conditions at once — by location, by period, by category. SUMIFS and COUNTIFS are the backbone of any real summary.
• Conditional Formatting to catch outliers instantlyHighlight blanks, negatives, duplicates, or the whole row that fails a rule — instantly. Conditional Formatting turns a wall of numbers into something you can read.
• Paste Special → Values: the fix before you sort, send, or deleteConvert formulas to their results before you sort, send, or delete the source. Ctrl+Alt+V then V. Paste Special also transposes rows/columns and more.
• Freeze Panes: keep headers visible across 1,000 rowsKeep your header row — or header row and first columns — visible as you scroll a thousand rows. Here's how Freeze Panes works and the one trick to get it right.
• Data Validation drop-downs: stop typos at the sourceNo more North vs north vs Nrth. A data-validation drop-down limits a cell to a fixed list of choices, so your data stays clean enough to total and match.
• Named ranges: make formulas read like English=SUM(Revenue) beats =SUM(C2:C500) — it's readable and it survives inserted rows. Here's how to create and use named ranges.
• IFERROR: hide errors without hiding problemsIFERROR replaces ugly error values with a blank or a message — so a report reads clean. Here's how to use it without hiding problems you actually need to see.
• The TEXT function: format numbers and dates as text=TEXT(A2,"$#,##0.00") or =TEXT(A2,"mmm yyyy") turns a number or date into exactly the text you want — for labels, filenames, and joined strings.