For teams that run on Exact Online
Exact Online import invoices with one mapping
Invoices made in a CRM, a member system or your own web app still have to reach Exact Online. The import asks which column is which each time, cost units go in through a separate file format, and new customers have to exist first.
How it goes today
- Export the invoices of last month from your own system.
- Import the file in Exact Online and map the columns again.
- Create new customers by hand before the import accepts them.
- Fix the rejected lines and import the rest again.
How it can go
Invoices from your own system reach Exact Online with a mapping you set once.
You send the export file of your own system, and it is read with a mapping you check once. New customers and cost units are created, and each invoice is booked in Exact Online as a sales entry with its own number, ledger account, VAT code and cost unit, so payments can be matched against it later. Anything that does not fit goes on a short list for you.
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.
With Hypamoon, when I send the monthly export file of our own invoicing system, book each invoice in Exact Online as a sales entry with the same invoice number, customer, ledger account, VAT code and cost unit. Create the customer when it is new and the cost unit when it does not exist yet. Use the column mapping I check once, and email me a short list of anything that did not fit.
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.
- I can only send one statement at a time from Exact Online.
- I export from Exact Online twice and build a pivot table to see it per country.
- Exporting my own data from Exact Online does not work in one go.
- I book the whole credit card statement as one invoice.
- I enter the exchange rates in Exact Online by hand every day.
- Each month I merge the figures of every company into one spreadsheet.
- Every month I run the same reports in Exact Online and mail them on.
- I want to see days sales outstanding per country, but I can't filter on country everywhere.
- I calculate the interest on each late invoice by hand.
- Before the new year I write the new prices in Excel first.
- I change the price on every subscription by hand each year.
- I want to send a payment confirmation once a customer has paid.
- I type every order between our two companies in twice.
- Every new item has to be created again in each of our companies.
- Our engineers write hours in their own company, but the client gets the invoice from another one.
- Each month end I work out our unbilled hours in a spreadsheet and book them by hand.
- After each delivery someone has to remember to make the invoice.
- Half the calls we get are customers asking where their order is.
- When a customer asks for their prices, I spend an hour in a spreadsheet.
- After a price change I go through every open order to fix the prices.
- Our warehouse fills in each CMR by hand from the packing slip.
- I add our handling percentage to each invoice with a calculator.
- We keep a separate sheet of how many kegs each pub still has.
- We put the costs of a container in a spreadsheet and divide by the number of boxes.
- Twice a year we count on paper and then type it into Exact Online for two days.
- Our reorder points were set once and nobody has looked at them since.
- Every month I hand my bookkeeper a stack of till receipts to type in.
- Every week I download the CODA files and upload them one by one.
- Each new member means typing a mandate into Exact Online by hand.
- We have nine kinds of membership, billed monthly, quarterly or yearly.
- Our rentals live in a spreadsheet and I invoice them by hand each month.
- Every Friday our office types in a stack of paper work orders.
- Each month I copy the payroll journal line by line into Exact Online.
- I add up our sales to consumers in other EU countries by hand each quarter.
- A big client wants our emissions and I have no idea where to start.
- I write almost the same hours every day: client, project, code, number.
- Customers tell us the invoice did not arrive.
- My bookkeeper keeps sending me lists of receipts they do not have.
- Our payment schedule per project lives in a spreadsheet next to Exact Online.
- We retype item codes into the label program for every receipt.
- Everything for Exact Online