Guides

Guides to Excel finance automation and reconciliation

Written for controllers, finance managers and the people who run the close. Each guide says where your existing setup is already enough, because often it is.

Excel finance automation

How to automate a monthly reconciliation in Excel with Power QueryCombine the exports, clean them once, match with merges, and keep the unmatched items visible.Guide Power Query, VBA macros or Python: which to use for finance automationChoose by who maintains it and what your IT policy allows, not by what is most powerful.Guide Seven checks every month-end close spreadsheet should runRequired columns, duplicates, completeness, control totals and more, each built into the workbook.Guide How to document an Excel workflow so someone else can run itA workflow map, a rules list, a check sheet, a change log and a one-page run guide.Guide How to check AI-generated Excel formulas before you rely on themRead it, test it on known answers, reproduce key totals another way, and log the change.Guide How to automate a bank reconciliation in ExcelOrdered matching passes, one-to-many handling and a clean list of reconciling items.Guide

Reconciliation examples: e-commerce

Why an e-commerce clearing account will not reconcileThe residual balance is usually five or six small recurring causes, not one large error.Guide Why Shopify payouts do not match the bankA payout is a net settlement of many orders, not a sale, and the two are not comparable.Guide Refunds and chargebacks across month-endWhy cross-period adjustments leave clearing balances that carry forward indefinitely.Guide When A2X, Bookkeep or Synder is working and exceptions remainThe narrow case where a correctly configured connector still leaves recurring manual work.Guide How to decide whether a reconciliation workflow is worth automatingRecurrence, repeatability and reuse, and the cases where the answer is no.Guide

Interactive tools and examples

Workflow Payback CheckEstimate the payback on automating one recurring workflow, and get an honest yes, maybe or no.Free check Excel workflow demoThree monthly exports refreshed into a checked AR reconciliation, with exceptions and handover notes. Synthetic data.Interactive demo E-commerce reconciliation reference buildA synthetic month of multi-source e-commerce evidence worked down to a short review queue.Interactive demo E-commerce Fit ScoreScore one payout or clearing-account workflow against recurrence, effort and repeatability.Diagnostic

General educational information only. Not accounting, tax or legal advice.

Have a workflow in mind while reading?

Describe it in a few sentences. No files or preparation needed. If it is not worth automating, we will say so.

Discuss your workflow Explore the Excel demo