Invoicing and reminders across a Tripletex client portfolio
For each client company your Tripletex login reaches, this flow invoices delivered orders, sends the invoices and soft reminders, and asks you before any formal reminder.
The prompt
Every Monday morning, go through every client company I can log in to in Tripletex. For each client, find the open orders that have been delivered and invoice them, putting several orders for the same customer on one invoice where Tripletex allows it. Send each invoice the way the customer is set up to receive invoices, and save the PDF to Google Drive with the client's name on it. Then check the client's overdue invoices and send a soft reminder by email on any that haven't had one. When an invoice is still unpaid 14 days after a soft reminder, or the customer has no email address, don't send anything stronger. Collect those and ask me once in Slack at the end, with Send formal reminders and Leave them with me buttons, and wait for my answer. If a client can't be opened, tell me in the same message.
FlowRunner Prompt to Flow built this flow from that request. Here it is as it opens in the editor.
The flow
Inside the loop: For each client company
Inside the loop: For each customer to invoice
Inside the loop: For each invoice due a soft reminder
Inside the loop: For each invoice to remind
Download the file, then in FlowRunner click + beside Flows, pick it under Import a Flow Version and click Create. How importing works
What each step does
- Find the client companies Reads every client company your Tripletex login can act for through an accountant relation. The flow works through them one at a time and acts for that client on each call.
- Find orders ready to invoice Finds the client's open orders delivered by today and leaves subscription orders alone. A client the login can't open is noted for the summary, and the flow moves on to the next one.
- Invoice the orders together Several orders for the same customer, currency, terms and recipient become one invoice. A customer with a single order gets the invoice from that order.
- Send the invoice Sends each invoice the way the customer is set up to receive invoices in Tripletex, such as email or EHF, and files the PDF in Google Drive under the client's name.
- Send a soft reminder Reads the client's overdue invoices and sends a soft reminder by email on each one that has had none. An invoice still unpaid 14 days after a soft reminder, or whose customer has no email address, is kept for the accountant.
- Ask the accountant After the last client, posts one message to Slack with the totals and every invoice kept back, with two buttons: Send formal reminders and Leave them with me. When nothing needs a decision, the totals go to Slack as a report.
- Wait for the accountant's answer The run waits for the click. Send formal reminders sends a formal reminder by email on each of those invoices and confirms it in the Slack thread. Leave them with me sends nothing, and the invoices come up again on the next run if they are still unpaid.
Before you turn it on
- Enter the employee token for your Tripletex login. An administrator creates it under API access, and it needs access to each client company with the right to invoice and send reminders there.
- Connect your Google Drive and Slack accounts. Pick the folder for the invoice PDFs in File the PDF in Google Drive, and the accountant's channel in Ask the accountant, Report the run and the two confirmation steps.
- Copy the URL of the block Wait for the accountant's answer into the flow setting Answer link. The Slack buttons open it.
- Set the flow setting Days before escalating, for example 14 days after a soft reminder.
- Set a schedule for the flow, for example every Monday morning.