Skip to content
Hypamoon

For teams that run on Exact Online

Exact Online export to Excel, filled each morning

Exact Online exports a report to Excel one overview at a time, and the live link to a reporting tool comes with the Premium editions. So a monthly overview often starts with a few exports and a pivot table.

How it goes today

  1. Export the revenue overview from Exact Online to Excel.
  2. Export the receivables overview as a second file.
  3. Combine both in a pivot table to split by country or customer.
  4. Do it again next month because the export does not refresh.

How it can go

Your Exact Online figures in a spreadsheet that fills itself every morning.

One spreadsheet with balances per ledger account and period, open invoices of customers and suppliers, and sales per customer with their country, filled from Exact Online every morning. The columns stay the same, so your own tabs and formulas next to it keep working.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. Exact Online works with a sign-in instead of a key: you sign in to Exact Online once to give access, never in the chat.

Your request

With Hypamoon, every morning, take from Exact Online the balance per ledger account and period for this year and last year, the open invoices of customers and suppliers, and sales per customer with their country. Put them in one spreadsheet with a tab per subject that I can download, and keep the columns the same each day so my own formulas keep working.

You register your own app in the App Center of your Exact Online environment and sign in once to give it access to your company. It stays yours.

More for teams on Exact Online