Small Business Reporting Setup

Five questions, eight headline numbers and connected bank, payment and sales feeds, then owner routines, statement reading skills, accountant and lender packs, and set-ups for shops, services, cafés and founders.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Small Business Reporting Setup, and click Install. It goes into your own files, and works offline from then on.

What it installs.

1

Pillar

1

Area

50

Projects

190

Starter tasks

📊 Data & Analytics

Small Business Reporting Setup

Setting up simple, reliable reporting for a small business by connecting sales, finance and marketing tools into a few useful views.

  1. Five questions your business numbers must answer
  2. Map of every tool that holds business data
  3. Owner admin access to every data tool
  4. Eight headline numbers for the business
  5. Chart of accounts tidy-up with your bookkeeper
  6. Matching sales categories across till, shop and books
  7. Choosing where your reports will live
  8. Bank, payment and sales feeds into the accounting tool
  9. Twelve-month baseline of sales, costs and cash
  10. Source map for every number in your reports
  11. Daily takings close-out against card and cash
  12. Monday ten-minute numbers check
  13. Friday bank feed reconciliation
  14. Weekly overdue invoices and debtors view
  15. Monthly management report pack
  16. Monthly marketing spend and enquiries tally
  17. Monthly stock value and slow movers view
  18. Connector and sync failure check
  19. Quarterly report prune and repair
  20. Year-end reporting archive and year-on-year comparison
  21. Reading your profit and loss, balance sheet and cash flow
  22. Why profit and the bank balance disagree
  23. What your till and online shop count as sales
  24. Reading payment processor payout and fee reports
  25. Exporting clean CSV files from your business tools
  26. Gross margin by product or service line
  27. Like-for-like comparisons and seasonality
  28. Reading ad platform results against real orders
  29. Retiring the hand-typed sales spreadsheet
  30. Payment processor clearing account with your bookkeeper
  31. One customer list across till, shop and email tool
  32. Recording where every enquiry came from
  33. Cash position and upcoming bills view
  34. Budget versus actual view for the year
  35. Automating the monthly report pack
  36. Year-end figures pack for the accountant
  37. Figures pack for a loan or grant application
  38. Peak season daily sales tracker
  39. Switching accounting or till software without losing history
  40. Monthly reporting for a one-person business in an hour
  41. Reporting for a shop that sells in store and online
  42. Job profitability reporting for a service business
  43. Covers, spend per head and food cost for a restaurant
  44. Founder metrics for a monthly investor update
  45. Handing the reporting routine to a bookkeeper
  46. Partner and staff views with the right access
  47. Contribution per order after fees, shipping and packaging
  48. Consolidated reporting across two or more locations
  49. Syncing all your tools into one small database
  50. Clean financial history ready for a business sale

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Five questions your business numbers must answer

Owners who start by connecting tools usually end up with forty charts and no answers. Writing down the five questions you actually ask about the business each month, such as whether last month made money, which products carry the margin and whether there is cash for the next payroll, decides what every later report has to show and what it can leave out.

First tasks

  • Write down the last three decisions you made that needed a number
  • Turn them into five questions the reports must answer each month
  • Note which tool you believe holds each answer
  • Share the list with your partner or bookkeeper and adjust it

Map of every tool that holds business data

A typical small business has sales in a till or online shop, money in a payment processor and a bank, costs in accounting software, and customers spread across an email tool, a booking app and a spreadsheet. Listing every one, with what it holds and who pays for it, shows where the numbers live before anything gets connected, and often turns up a subscription nobody uses.

First tasks

  • List every app the business pays for from the last three bank statements
  • Add the till, payment, accounting, email and booking tools you use for free
  • Record what data each tool holds and whether it exports to CSV
  • Flag any two tools that record the same thing

Owner admin access to every data tool

Accounts set up by a web designer, an agency or a former bookkeeper are often registered to their email address, and the business only finds out when that person leaves. Making sure the owner holds the top-level admin login for the accounting software, payment processor, online shop and ad accounts protects years of history and means reports can never be held hostage.

First tasks

  • Check who is listed as account owner in your accounting software
  • Request an ownership transfer for any account held by an agency or former helper
  • Move every business login into a password manager the business owns
  • Review each tool's user list and remove people who have left @recurring(yearly)

Make it yours.

Install Small Business Reporting Setup, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.