Finance teams

Automating financial reporting and reconciliations for your finance team.

The same extracts, reworked by hand every month, then copied from one file to another: that is where time and reliability are lost. I automate these finance processes in your tools, so that your teams can focus on analysis.

From accounting extract to Power BI dashboard

  1. ExtractsTrial balances, general ledgers, FEC files (the French tax audit export), bank statements, ERP exports.
  2. PreparationPower Query cleans and combines the data, and maps each account to a reporting line.
  3. ChecksBalanced trial balance, agreement with the general ledger, differences and anomalies flagged.
  4. CalculationsCash flows, indicators, comparison with budget and forecast.
  5. ReportingPower BI dashboards, cash flow statement, reporting to management.
With each update, the whole chain runs again: your teams start from figures that have already been through the automatic checks, and spend their time on analysis.

Power BI reporting and dashboards

Extracts from your accounting software or ERP feed straight into the reporting. A refresh replaces copying, pasting and reformatting.

  • Trial balances, general ledgers and FEC files processed in Power Query
  • Mapping table between accounts and reporting lines
  • Power BI dashboards refreshed by company, by project or by business line

Cash flow statement fed automatically

The cash flow statement is rebuilt from the trial balances, using a mapping table between accounts and cash flows. Each update checks that the flows do explain the change in cash.

  • Operating, investing and financing cash flows
  • Check that the flows tie in with closing cash
  • View by company and for the group as a whole

Cash monitoring and forecasting

Balances and flows from each company come into a single tool, where they are classified by rules, consolidated and projected, with no re-keying.

  • Bank statements imported and classified by rules
  • 13-week and 12-month forecasts
  • Actual compared with forecast, low points flagged
Try the simplified forecast

Reconciliations and cross-checks

Banks, debt, VAT, flows between group companies: the sources are compared line by line at each update, and differences stand out on their own.

  • Revenue and VAT in the accounts against the VAT returns
  • Outstanding debt against bank records and contracts
  • Reciprocal intragroup flows and bank reconciliations

Recurring closing calculations

Calculations redone at every close become models fed by the trial balance: same rules and same checks, from one financial year to the next.

  • Interest deduction limitation (ATAD) tracked over time
  • Loan schedules and accrued interest
  • Bridge tables and figures for the notes to the accounts
Try the ATAD calculator

More reliable Excel files

The file that only one person knows how to run becomes a tool: clear structure, robust formulas, identified sources.

  • Formulas that withstand column changes
  • Sources and assumptions identified
  • A user guide for whoever takes over the file

A chartered accountant’s automatic checks

I know where the figures come from, and therefore where they are likely to be wrong. These checks run at each update and flag anything out of the ordinary, instead of leaving you to look for it.

  • Trial balance checked for balance and agreed to the general ledger, company by company
  • Uncleared suspense accounts and abnormal balances: customers in credit, suppliers in debit
  • Likely duplicate supplier invoices: same supplier, same amount, close dates
  • VAT in the accounts reconciled with the VAT returns
  • Cash in the accounts reconciled with bank statements
  • Intragroup balances that do not match from one company to another
  • Entries posted to a period already closed
  • Alert thresholds: cash low point, upcoming due dates, budget overrun

Reconciliations and cross-checks bring differences to light: your accounting teams decide on the corrections. When a difference raises a tax question, I analyse it with you as part of an advisory assignment, also carried out by EZM CONSULTING. These automations can also be part of anoutsourced CFO assignment, full-time or part-time (time-share).

Small businesses and the self-employed

Automating your small business admin, from invoices to payment reminders.

When you run your business alone or with a small team, repetitive admin eats into your core work. I automate what can be automated, with simple tools sized to your needs.

Collecting invoices and receipts

Your purchase invoices are retrieved automatically and matched to your bank transactions. All that is left to chase are the receipts that are genuinely missing.

  • Invoices retrieved from supplier portals and your mailbox
  • Receipts photographed with your phone
  • Missing receipts listed every month

Connected accounting

Your bank is synchronised with your accounting software, Pennylane for example. Recurring transactions follow classification rules agreed with whoever keeps your books.

  • Bank accounts synchronised
  • Classification rules for recurring transactions
  • A reminder when a bank connection needs renewing

Quotes and invoices

An accepted quote becomes an invoice with no re-keying, with the mandatory information, continuous numbering and tracking of payments received.

  • Quotes converted into invoices
  • Mandatory information built into the template
  • Tool chosen with e-invoicing in mind

Customer payment reminders

Late invoices are identified and chased on a schedule agreed with you, in a tone you approve.

  • Customer due dates tracked
  • Reminders scheduled in stages
  • A clear view of unpaid invoices

Between businesses, late payment penalties can apply without a prior reminder, and a fixed €40 recovery fee is due for each invoice unpaid on its due date. Your reminders can point this out, in the tone you choose.

Paperless expense claims

A photo of the receipt is enough: the expense is classified and tracked through to reimbursement, with no spreadsheet to copy out.

  • Receipts photographed and filed
  • Expenses categorised
  • Approval and reimbursement tracked

A simple dashboard

Revenue, cash received, cash position: a dashboard fed by your data, which you can check at any time.

  • A few indicators chosen with you
  • Fed by your bank and your tools
  • Cash for the coming months at a glance

Generative AI

Generative AI for finance, with safeguards.

AI saves time on text and documents. It replaces neither professional judgement nor checks: I use it where it brings a real gain, within a framework you approve.

What I use AI for

  • Writing draftsReplies to recurring requests, reminders, meeting notes, summary notes: following your instructions, your templates and your tone.
  • Analysing documentsPicking out the amounts, due dates and terms in a loan agreement, a lease or an invoice, to feed a schedule or a tracking table.
  • Checking consistencyComparing a reporting commentary with the figures, spotting a contradiction between two documents, flagging a document that does not match its description.
  • Writing and documentingFormulas, Power Query queries, Power BI measures and user guides, as well as scripts written with Claude Code in the terminal, reviewed and tested before use.

The safeguards I apply

  • Human approvalNo AI suggestion is sent or posted to the accounts without review, by you or by the person you appoint.
  • Figures calculated by rulesAmounts come from your data and from formulas that can be checked, never from generated text.
  • Tools disclosed upfrontBefore any use on your data, I tell you which AI tool I use and on what terms. You decide.
  • Nothing sensitive in a tool we do not controlHealth data, personnel files, full bank details, strategic information: all of this stays out of consumer tools.
  • GDPR appliedOnly the data needed is processed. When personal data is processed on your behalf, article 28 of the GDPR provides for a written contract setting out the processor’s obligations.
Edwin Marks, French chartered accountant (expert-comptable)

My day-to-day work

What I offer you, I use every day.

I run a one-person firm, with no staff, and that is a choice: in my practice, automation does the work a team would do. The methods I set up for you are the ones I apply every day in my own firm. Since 2025, I have also been working within the finance department of a major property developer.

  • My own processesInvoices retrieved, bank transactions categorised, reconciliations, draft replies to emails.
  • A chartered accountant’s eyeI know where the figures come from, and therefore what needs checking.
  • Human controlAn approval step is built into the tool before the result is used.

Examples

Automation examples: time spent, before and after.

Four common situations, to give an idea of what changes day to day. The time that remains is time for analysis and decisions.

Finance team

Example: monthly reporting for a group of several companies

Before

About 2 days a month

Every month, the trial balances are extracted company by company, copied into the reporting file, adjusted by hand and then checked.

After

About half a day a month

The trial balances are dropped into a folder. Power Query combines them, applies the mapping table and runs the checks, then the dashboard updates. The time left goes into analysing variances.

  • Power Query
  • Power BI
  • Excel
Finance team

Example: weekly cash monitoring across several companies

Before

About 3 hours a week

Balances are noted bank by bank and copied into a spreadsheet, then upcoming flows are updated from emails and schedules.

After

About 1 hour a week

Statements are imported and classified by rules, and the 13-week forecast recalculates and flags low points. What remains is to approve the week’s assumptions.

  • Power Query
  • Excel
  • Power BI
Small business

Example: supplier invoices and payment reminders for a services company

Before

About 5 hours a month

Invoices are downloaded one by one from supplier portals and then sent to the accountant. Late-paying customers are chased case by case.

After

About an hour and a half a month

Invoices are collected and matched to bank transactions automatically, and reminders go out on an agreed schedule. What remains are the missing receipts and special cases.

  • Pennylane
  • Make
Self-employed

Example: replies to the requests that come back every week

Before

About 3 hours a week

The same questions arrive by email (appointment slots, documents to provide, terms) and each reply is written from scratch.

After

About 1 hour a week

AI prepares a draft from your instructions and your templates. You review it, adjust it if needed and send it yourself.

  • Generative AI
  • Reply templates

Illustrative examples, built to show orders of magnitude: they do not describe real assignments and are not a commitment to any result. The time saved depends on your volumes, your tools and the quality of your data. For completed assignments, anonymised, see the case studies.

My method

How I automate your processes, step by step.

I start from your tools and your actual tasks. Each step produces something usable, and you keep control of the priorities.

  1. Review of repetitive tasks

    With you, I list the tasks that come back every week, every month or at every close: who does them, how long they take, what errors they cause.

  2. Prioritisation by time saved

    Each option is assessed in hours saved and in set-up effort. I start with what frees up the most time for the least effort, with controlled risk.

  3. Prototype

    A first version runs on your real data. You use it alongside your current method and we compare the results.

  4. Go-live

    Once the results match, the automation replaces the old method: access, scheduled updates, checks and alerts in place.

  5. Documentation and handover

    Each automation is documented: what it does, where the data comes from, what to do if it stops. The aim is for you to keep it running without depending on me.

What you receive

  • A map of repetitive tasks, with the time spent and the time to be saved
  • Power Query queries, Excel files and Power BI dashboards
  • Automation scenarios between your applications
  • Checks and alerts set up
  • Documentation: sources, rules, what to do if it stops
  • A hands-on session with the people taking over the tool

Indicative timescales

Initial review
A few days, depending on the number of processes reviewed.
First automation up and running
Usually 2 to 6 weeks, depending on complexity and access to the data.
As part of outsourced CFO services
The automations are built into an assignment lasting 3 months to 3 years.

After an initial conversation, you receive a written proposal: scope, deliverables and timetable.

Describe my processes

Tools

The tools of accounting and finance automation.

The choice of tool depends on what you or your teams will be able to keep running. I favour what is already in place in your business and what stays easy to follow for whoever takes over the tool.

  • Excel

    The tool your teams already know: structured tables, formulas that refer to columns by name, assumptions kept separate.

    The right choice when the deliverable must remain editable by your teams.

  • Power Query

    Imports, cleans and combines your extracts: trial balances, general ledgers, FEC files, bank statements. Each step is recorded and replayed at each update.

    The right choice when the same extract is reworked every month.

  • Power BI

    Shared dashboards, refreshed automatically, with access rights depending on the reader.

    The right choice when several people follow the same indicators.

  • Make

    Connects your applications: email, file storage, invoicing tool, spreadsheet. An event triggers a series of actions.

    The right choice when a task consists of passing information from one tool to another.

  • Pennylane

    Connected accounting: synchronised bank, invoices collected and matched, invoicing of your customers.

    The right choice when a small business wants its accounts kept up to date continuously.

  • Generative AI

    Drafting, document analysis, help with writing formulas and scripts, always reviewed.

    The right choice when the work involves text or unstructured documents.

  • Claude Code and custom scripts

    Claude Code, Anthropic’s programming assistant, used in the terminal: it helps me write, test and run custom scripts (processing large files, specific connections between tools, scheduled tasks), which I review before anything goes live.

    The right choice when no standard tool covers the need, or the processing must run on its own at regular intervals.

Frequently asked questions

Accounting automation: your questions.

Is my data secure?

I ask only for the access that is strictly necessary, read-only wherever possible, and you can withdraw it at any time. Your data stays in your tools as far as possible: the automations run in your environment, not on a file passed around by email. Confidentiality is covered in the contract, and I can sign your non-disclosure agreement. When personal data is processed on your behalf, article 28 of the GDPR provides for a written contract setting out the processor’s obligations: processing on documented instructions, confidentiality, security, deletion or return of the data at the end of the assignment.

Do I need to change software?

In most cases, no. I start from the tools you already use: Excel, your accounting software or ERP, your bank, your email. If a tool is genuinely missing, I tell you, with the possible options and their limits, and you decide.

How long does it take to automate a first process?

It depends on the process and on access to the data. As a guide, a first targeted automation, for example preparing a monthly report or collecting invoices, is up and running within a few weeks: a review lasting a few days, a prototype used alongside your current method, then go-live. The precise timetable is set out in the written proposal.

Who maintains the automations once they are in place?

Your teams, if you wish: each automation is documented (sources, rules, what to do if it stops) and I train the people who take it over. An automation can stop: a supplier changes its invoice format, an extract gains a column, an access expires. Checks flag the most likely anomalies, to limit the risk of a wrong result going unnoticed. Follow-up can also be included in the proposal, for fixes and changes.

I don’t have a CFO: is automation for me?

Yes. When the business owner handles the admin, every hour saved counts. For a small business or a self-employed person, I start with invoice collection, bank synchronisation, quotes and invoices, payment reminders and a simple dashboard. The tools stay light and can be used without any particular technical skills. If your business needs closer financial management, outsourced CFO services on a time-share basis can take over.

Do you use AI on my data, and who checks the result?

Only with your agreement. Before any use, I tell you which AI tool I use and on what terms, and you decide. Confidential or sensitive information, such as health data, personnel files or full bank details, does not go through tools we do not control. AI prepares drafts, sorts documents, helps write a formula: it decides nothing. Its suggestions go through an approval step, by you or by the person you appoint. Amounts, for their part, are calculated by explicit rules that can be checked.

Do I need to be a KOADVISE client for an automation assignment?

No. Automation assignments are carried out by EZM CONSULTING, whether your accounts are kept in-house, by your chartered accountant or by KOADVISE. If you already have a chartered accountant, I work with them: the tools put in place make their work easier without replacing them.

Is e-invoicing an opportunity to automate?

Yes. Since 1 September 2026, VAT-registered businesses established in France must be able to receive electronic invoices, through an approved platform. Large companies and mid-sized companies must also issue them from that date, and SMEs and micro-businesses will have to do so from 1 September 2027. Since your invoicing tools have to change anyway, it is a good time to connect quotes, invoices, payments received, reminders and accounting, so that each invoice is entered only once.

Another question? Write to me or read thefinancial, tax and accounting news (in French).

Repetitive tasks to automate?

Describe your processes and tools to me: you receive a written proposal, with no commitment.