Home / Services

Excel automation and financial modelling

Excel workbooks that update themselves and are easy to check.

2D Canada builds financial models, forecasts and reporting workbooks that do the repeat work for you. Change one input and the whole model rolls forward, with built-in checks that catch mistakes before anyone else does.

Fund dashboard built in Excel, with names and amounts hidden

Your team already knows Excel. Let it do more of the work.

Most businesses do not need new software. They need the spreadsheets they rely on to be faster, safer and simpler to use.

What you get

What 2D Canada builds

  • Financial models and three-way forecasts: profit, balance sheet and cash flow
  • Investor and fund reporting, from each investor's share to a finished statement
  • Budgets and rolling forecasts your managers can update themselves
  • Automated workbooks using Power Query, formulas and VBA where it helps
  • Clean-ups of existing spreadsheets that have grown too complex to trust
  • Built-in checks, clear input cells and a short guide for whoever uses it next
Who it's for

A good fit if…

One person holds the key spreadsheet

And everyone worries about what happens when they are away.

Every month starts from a copy

Last month's file is copied, pasted over and fixed by hand.

Investors or lenders need reports

Quarterly statements, returns and fees that have to be right every time.

How it works

Three steps, each one paying off before the next.

01

Understand

Walk through how the numbers are used today and where time goes.

02

Build

Design the workbook around your process, with inputs, checks and outputs kept apart.

03

Hand over

Test it with your real data and train your team to run it on their own.

Quarterly investor summary in Excel, names and amounts hidden
Client names and amounts hidden.
Past projectClient name removed

Example: investor reporting for private funds

For several private mortgage and real estate funds, 2D Canada built the quarterly workbooks that calculate each investor's share, interest, distributions and fees, and produce a statement for every investor. The largest holds 25 investments and reports to 12 investors. Changing one cell rolls the model to the next quarter.

Questions

Common questions

Can you fix a spreadsheet we already have?

Yes. Many projects start with an existing workbook that has become slow or hard to trust. It can be cleaned up, simplified and given proper checks.

Will we be able to maintain it ourselves?

That is the goal of every build. Inputs are clearly marked, the logic is kept simple, and your team is shown how to run and update it.

Do you use macros (VBA)?

Only where they genuinely save time. Many automations work better with formulas and Power Query, which are easier for others to follow.

Can the workbook feed Power BI?

Yes. Workbooks can be set up as a clean data source for Power BI dashboards.

Let's find your first step.

Tell 2D Canada what is slowing your finance team down. You'll get a straight answer on where to start.

Book a call