For teams that run on Jortt
Jortt export to Excel, booking by booking
Jortt lets your accountant log in to check the books, and gives a profit and loss file with a total per category and an audit file per year. A list of the bookings themselves, per category, to open in a spreadsheet is not one of its exports.
How it goes today
- Invite the accountant to log in to Jortt as a viewer.
- Download the profit and loss file, which has one total per category.
- Ask the Boekhoudbot for an audit file and send it on.
- Download the bank transactions again at the bank for a separate list.
How it can go
Give your accountant the bookings in a spreadsheet each month.
On the first working day of the month you get a spreadsheet with every booking of the month before: number, date, description, category, amount and VAT, with the sales invoices on a second tab. The receipt files that belong to those bookings come along in a folder, named after the booking number. Your accountant gets the same file by email.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your Jortt key in the portal, never in the chat.
With Hypamoon, on the first working day of each month, make a spreadsheet of last month's bookings in Jortt with booking number, date, description, category, amount and VAT, and the sales invoices on a second tab. Put the receipts that belong to those bookings in a folder named by booking number. Email both to me and our accountant.
You create your own Jortt connection with a client ID and secret in Jortt, under Settings, Connections, Jortt API connection, Own API connection. It works from the jortt MKB plan and stays yours.
More for teams on Jortt
- I want to charge interest on invoices that were paid late, without a calculator.
- After three reminders I still write the formal notice myself.
- I want reminders to go out on their own, not when I remember to open the to-do list.
- I book every line of my credit card statement by hand each month.
- My receipts are in the Jortt Inbox, but linking them to the right payment is still my job.
- Quotes go out and I lose track of who still has to answer.
- I have a holding and two companies in Jortt and add up their figures in a spreadsheet.
- I keep my hours in a sheet and type them into Jortt again at the end of the week.
- Everything for Jortt