For teams that run on Candis
Candis per diem payroll: one monthly file
Candis works out per diems and mileage for each trip. For payroll, the Candis help center describes a monthly CSV export of reimbursements that you filter for per diem afterwards, because the export holds each type together.
How it goes today
- Open Archive, Reimbursements in Candis and filter on last month.
- Export the CSV with the reimbursements of that month.
- Open it in a spreadsheet and filter the type column for per diem and mileage.
- Add up the amounts per employee and send the file to the payroll provider.
How it can go
Per diems and mileage reach payroll without a spreadsheet step.
On the second working day of each month, the approved per diems and mileage of the previous month are collected from Candis. Payroll gets one file with a row per employee: per diems, mileage, number of travel days and the total, plus a second sheet with each trip and its date. You get the file first, and once you approve the layout it goes to payroll each month.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. Candis works with a sign-in instead of a key, through an app that has to be approved first. That can take several business days; after that you sign in to Candis once, never in the chat.
With Hypamoon, on the second working day of each month, collect the approved per diems and mileage from Candis for the previous month. Make one file with a row per employee showing per diems, mileage, travel days and the total, and a second sheet with each trip and its date. Email it to me to check, and once I approve the layout, send it to our payroll provider each month.
You first ask Candis support in the chat to switch on the Candis API for your company: export and supplier data come with the Plus package and higher, invoice data with Max. After that an administrator creates a Client ID and Client Secret in Candis under Settings, Candis API, with the return address the portal gives, and signs in to Candis once to choose the company. It stays yours.
More for teams on Candis
- Invoices sit with the second approver for days, and I chase each one with a comment.
- I pay through my bank and then mark each Candis invoice as paid by hand.
- The discount date is today and the invoice is still waiting for approval.
- Every month I add up the Candis reports of each of our companies in a spreadsheet.
- I keep our supplier list up to date twice, once in our own system and once in Candis.
- At month end I collect the invoices still in approval so the accountant can book accruals.
- Every week I start the export in Candis and read the file into our accounting software.
- Everything for Candis