Finance automation

Finance work, automated.

SmartTally builds the reconciliations, reports and workflows your finance team runs every month, in the Microsoft tools you already use. Less copy-paste, faster closes, clearer numbers.

Bank feeddaily import Match rulesrules applied Exceptionssent to you Ledgerreconciled Power BIrefreshed
Built in the tools you already useMicrosoft 365Power BIPower AutomateExcelSharePointKNIMEQuickBooks Online

What we build

Four kinds of finance work that come back every month

Month-end and reconciliations

Bank, card and intercompany reconciliations that run on a schedule, with only the exceptions sent to you for review.

Power Automate · KNIME · Excel

Management reporting

Power BI dashboards and month-end packs that refresh from your accounting system, so the numbers match every time.

Power BI · Excel

Budgets and forecasts

Budget, forecast and cash-flow models your team can update themselves, instead of rebuilding them every year.

Excel · Power BI

Data flows and approvals

Your bank, accounting software and spreadsheets connected, so data moves once and approvals stop living in email.

Power Automate · SharePoint · QuickBooks Online

How it runs

One reconciliation, start to finish, without anyone opening a spreadsheet

Every morning the same steps run on their own. You only see what needs a person.

  1. 01

    Bank feed

    Transactions arrive from your bank or card each morning.

  2. 02

    Matching rules

    Each line is matched to your ledger by rules we set up with you.

  3. 03

    Exceptions to you

    Only what doesn't match reaches your inbox, with the detail attached.

  4. 04

    Report refreshed

    Your Power BI pack updates itself with the reconciled numbers.

What you get

Numbers that arrive on time and add up

A month-end report that refreshes itself, with the figures your team checks first.

Days to close

4.5

▲ faster than 9.0 last quarter

Open items

3

waiting for review

Refreshed

7:00

every weekday morning

Revenue, actual and budget

ActualBudget
$0k$100k$200kApr · Actual $182kApr · Budget $180kAprMay · Actual $176kMay · Budget $180kMayJun · Actual $191kJun · Budget $185kJunJul · Actual $169kJul · Budget $180kJulAug · Actual $187kAug · Budget $185kAugSep · Actual $198kSep · Budget $190kSep$198k

Example report with sample figures.

How we work

One process at a time, built on your own data

  1. 01

    A short call

    We look at the one process that takes the most of your month.

  2. 02

    A fixed-scope proposal

    What we will build, what it replaces and the fee, in writing.

  3. 03

    Build and test

    Built in your Microsoft 365 and tested on last month's real numbers.

  4. 04

    Hand-over

    A short guide, and it stays yours. We help when something changes.

Who it's for

Built for small finance teams

If month-end still depends on copy, paste and the one person who knows the spreadsheet, we can help.

  • Owners who still close the books themselves
  • Controllers and finance teams of one to ten people
  • Accounting firms that want their own processes automated

Questions

Common questions

Do we need new software?

Usually not. We build in Microsoft 365, Excel, Power BI and your accounting system. If another tool would help, we explain why and what it costs before anything is bought.

Who owns what you build?

You do. Everything lives in your own accounts, with a short guide your team can follow.

How long does a project take?

It depends on the process. Your written proposal sets out the timeline along with the fixed fee.

Tell us which process takes up your week.

We reply within two business days · info@smarttally.ca

Request a consultation