For teams that run on Exact Online
Exact Online payment behaviour per customer
Exact Online shows what is open and how old it is. How many days a customer usually takes to pay, and how that differs per country, is often worked out in a spreadsheet from two exports.
How it goes today
- Export revenue per customer for the period.
- Export the receivables overview at the same date.
- Add the country of each customer with a lookup.
- Calculate the days per customer and country in a pivot table.
How it can go
See how long each customer and each country takes to pay.
Each month you see per customer and per country the average days from invoice to payment and the days past the due date, over the last twelve months next to the twelve before. Customers who started paying later are at the top.
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, each month, look at the invoices our customers paid in Exact Online over the last twelve months. Per customer and per country, show the average days from invoice date to payment and the days past the due date, next to the twelve months before. Put customers who started paying later at the top and email it to me.
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.
- Every month I download a journal from our CRM and import it into Exact Online.
- 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 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