Weekly purchase reconciliation in Holded
Each week this flow checks Holded purchase invoices and payments against the daily ledger, posts what does not match to Slack, and asks the controller before any correcting journal goes in.
The prompt
Every Monday morning, look at the past seven days in Holded. List our purchase invoices and payments, read the daily ledger and the expense accounts, and work out which purchase invoices have no matching payment, which supplier payments have no matching invoice, and where the ledger doesn't line up. Post that reconciliation to our finance channel in Slack. If a correcting journal entry is needed, draft the balanced lines and ask the controller in Slack, with Post the journal and Leave it buttons, and wait for the answer. Only post the journal to Holded if the controller says to.
FlowRunner Prompt to Flow built this flow from that request. Here it is as it opens in the editor.
The flow
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
- Set the period Works out the past seven days, the window each run checks.
- List purchase invoices Reads the Holded purchase invoices dated in that window, then the payments and the daily ledger entries over the same days.
- Reconcile the purchase side An AI agent matches each purchase invoice to its supplier payments and checks both against the ledger. It writes the reconciliation and, only when a ledger entry is missing or wrong, drafts a balanced correcting journal using expense accounts that exist in Holded.
- Post the reconciliation to Slack Posts the reconciliation to your finance channel, naming the invoices with no matching payment and the payments with no matching invoice.
- Correcting journal needed? When nothing needs correcting, the run ends here with the reconciliation posted.
- Ask the controller Otherwise the drafted journal goes to the controller in Slack, line by line with its debit and credit totals, with Post the journal and Leave it buttons. A journal that does not balance gets only Leave it.
- Wait for the controller's answer The run waits for the controller's click. Leave it posts nothing and says so in the Slack thread.
- Post the journal in Holded Post the journal creates the entry in the Holded daily ledger and confirms it in the Slack thread. The connector checks that debits and credits agree before it sends anything.
Before you turn it on
- Enter your Holded API key and connect your Slack account.
- Add your Anthropic key in the flow setting Anthropic key.
- Copy the URL of the block Wait for the controller's answer into the flow setting Answer link. The Slack buttons open it.
- Pick your finance channel in the four Slack steps.
- Give the flow a weekly schedule, for example Monday at 8:00, before you turn it on.