---
title: "Exact Online export to Excel, filled each morning · Hypamoon"
description: "Exporting Exact Online reports to Excel and rebuilding them each month? Get one spreadsheet with balances, open items and sales that fills itself each morning."
url: https://hypamoon.com/connect-to/exact-online/export-to-excel
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [Exact Online](https://hypamoon.com/connect-to/exact-online)
3.  Export to Excel

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.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=exact-online/export-to-excel)

## 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.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~exact-online/export-to-excel&say=a%20spreadsheet%20filled%20from%20Exact%20Online%20each%20morning%20with%20balances%20per%20ledger%20account%20and%20period%2C%20open%20invoices%20and%20sales%20per%20customer%20and%20country.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=exact-online/export-to-excel)

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

-   [**I still type every line of every purchase invoice into Exact Online.**](https://hypamoon.com/connect-to/exact-online/purchase-invoice-lines)
-   [**I can only send one statement at a time from Exact Online.**](https://hypamoon.com/connect-to/exact-online/customer-statements)
-   [**Exporting my own data from Exact Online does not work in one go.**](https://hypamoon.com/connect-to/exact-online/backup)
-   [**Every month I download a journal from our CRM and import it into Exact Online.**](https://hypamoon.com/connect-to/exact-online/import-invoices)
-   [**I book the whole credit card statement as one invoice.**](https://hypamoon.com/connect-to/exact-online/credit-card-statements)
-   [**I enter the exchange rates in Exact Online by hand every day.**](https://hypamoon.com/connect-to/exact-online/exchange-rates)
-   [**Each month I merge the figures of every company into one spreadsheet.**](https://hypamoon.com/connect-to/exact-online/consolidation)
-   [**Every month I run the same reports in Exact Online and mail them on.**](https://hypamoon.com/connect-to/exact-online/monthly-report)
-   [**I want to see days sales outstanding per country, but I can't filter on country everywhere.**](https://hypamoon.com/connect-to/exact-online/payment-behaviour)
-   [**I calculate the interest on each late invoice by hand.**](https://hypamoon.com/connect-to/exact-online/late-payment-interest)
-   [**Before the new year I write the new prices in Excel first.**](https://hypamoon.com/connect-to/exact-online/price-increase)
-   [**I change the price on every subscription by hand each year.**](https://hypamoon.com/connect-to/exact-online/subscription-prices)
-   [**I want to send a payment confirmation once a customer has paid.**](https://hypamoon.com/connect-to/exact-online/payment-confirmation)
-   [**I type every order between our two companies in twice.**](https://hypamoon.com/connect-to/exact-online/intercompany-orders)
-   [**Every new item has to be created again in each of our companies.**](https://hypamoon.com/connect-to/exact-online/master-data-sync)
-   [**Our engineers write hours in their own company, but the client gets the invoice from another one.**](https://hypamoon.com/connect-to/exact-online/intercompany-hours)
-   [**Each month end I work out our unbilled hours in a spreadsheet and book them by hand.**](https://hypamoon.com/connect-to/exact-online/work-in-progress)
-   [**After each delivery someone has to remember to make the invoice.**](https://hypamoon.com/connect-to/exact-online/invoice-deliveries)
-   [**Half the calls we get are customers asking where their order is.**](https://hypamoon.com/connect-to/exact-online/delivery-updates)
-   [**When a customer asks for their prices, I spend an hour in a spreadsheet.**](https://hypamoon.com/connect-to/exact-online/customer-price-list)
-   [**After a price change I go through every open order to fix the prices.**](https://hypamoon.com/connect-to/exact-online/reprice-open-orders)
-   [**Our warehouse fills in each CMR by hand from the packing slip.**](https://hypamoon.com/connect-to/exact-online/cmr-consignment-note)
-   [**I add our handling percentage to each invoice with a calculator.**](https://hypamoon.com/connect-to/exact-online/invoice-surcharges)
-   [**We keep a separate sheet of how many kegs each pub still has.**](https://hypamoon.com/connect-to/exact-online/crate-deposits)
-   [**We put the costs of a container in a spreadsheet and divide by the number of boxes.**](https://hypamoon.com/connect-to/exact-online/landed-costs)
-   [**Twice a year we count on paper and then type it into Exact Online for two days.**](https://hypamoon.com/connect-to/exact-online/stock-count)
-   [**Our reorder points were set once and nobody has looked at them since.**](https://hypamoon.com/connect-to/exact-online/reorder-points)
-   [**Every month I hand my bookkeeper a stack of till receipts to type in.**](https://hypamoon.com/connect-to/exact-online/cash-book)
-   [**Every week I download the CODA files and upload them one by one.**](https://hypamoon.com/connect-to/exact-online/coda-bank-files)
-   [**Each new member means typing a mandate into Exact Online by hand.**](https://hypamoon.com/connect-to/exact-online/direct-debit-mandates)
-   [**We have nine kinds of membership, billed monthly, quarterly or yearly.**](https://hypamoon.com/connect-to/exact-online/membership-fees)
-   [**Our rentals live in a spreadsheet and I invoice them by hand each month.**](https://hypamoon.com/connect-to/exact-online/rental-invoicing)
-   [**Every Friday our office types in a stack of paper work orders.**](https://hypamoon.com/connect-to/exact-online/work-orders)
-   [**Each month I copy the payroll journal line by line into Exact Online.**](https://hypamoon.com/connect-to/exact-online/payroll-journal)
-   [**I add up our sales to consumers in other EU countries by hand each quarter.**](https://hypamoon.com/connect-to/exact-online/oss-threshold)
-   [**A big client wants our emissions and I have no idea where to start.**](https://hypamoon.com/connect-to/exact-online/carbon-from-spend)
-   [**I write almost the same hours every day: client, project, code, number.**](https://hypamoon.com/connect-to/exact-online/repeat-timesheets)
-   [**Customers tell us the invoice did not arrive.**](https://hypamoon.com/connect-to/exact-online/invoice-emails)
-   [**My bookkeeper keeps sending me lists of receipts they do not have.**](https://hypamoon.com/connect-to/exact-online/receipt-reminders)
-   [**Our payment schedule per project lives in a spreadsheet next to Exact Online.**](https://hypamoon.com/connect-to/exact-online/milestone-invoicing)
-   [**We retype item codes into the label program for every receipt.**](https://hypamoon.com/connect-to/exact-online/item-labels)
-   [**Everything for Exact Online**](https://hypamoon.com/connect-to/exact-online)
