For teams that run on Exact Online
Exact Online work in progress entry each month
Exact Online creates revenue entries from projects when they are invoiced. A separate work in progress module is part of the higher editions; on the others the value of work done and not yet invoiced is worked out by hand.
How it goes today
- Export the hours and costs per project up to the month end.
- Subtract what was invoiced per project so far.
- Add up the difference and decide what to book.
- Type a journal entry and remember to reverse it next month.
How it can go
Unbilled project work is on the balance sheet each month end.
At each month end you get per project the value of hours and costs up to that date and what was invoiced so far. After your approval a journal entry goes into Exact Online on the accounts you choose, with the reversal on the first day of the next month. The value is worked out per project, not per hour line.
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, at each month end, work out per project in Exact Online the value of hours and costs up to that date minus what was invoiced so far. Show me the list. After my approval, book the total as a journal entry on the accounts I choose and book the reversal on the first day of the next month.
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 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.
- 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