Monthly statements¶
A statement on the 1st of the month reminds every client what they owe in one email, instead of one reminder per invoice. This workflow runs on the 1st, finds each client with an unpaid invoice, and emails them their outstanding statement as a PDF.
Before you start¶
- Quotes and invoices made in BaseCloud
- Each client has a person responsible (the statement is sent from them) and a contact with an email address
- Optional: your bank details in Statement footer under Settings → General, and online payments switched on, so each invoice on the statement has a Pay now link. See Statements
Just once?
To send statements by hand, click Send statements on the Accounting page. See Send statements to many clients.
The workflow¶
| Step | Task | Type | What it does |
|---|---|---|---|
| 1 | Monthly timer | Timer Trigger | Starts on the 1st of every month |
| 2 | Clients | Match to Client(s) | Lists the clients to consider, such as every active client |
| 3 | For each client | Loop | Runs the next steps once per client |
| 4 | Anything owed? | Accounting | Looks for the client's unpaid invoices |
| 5 | Owes money? | If Statement | Carries on only when there are some |
| 6 | Send statement | Accounting | Emails the client their outstanding statement |
About the variables
Values such as {{task_40002_…}} carry the number of the task they come from, so yours will
differ. Do not type them: click into a field and pick the value from an earlier task.
1. Monthly timer¶
Task: Timer Trigger. Starts on the 1st of every month.
| Field | Set it to |
|---|---|
| Frequency | 1 |
| Unit | Months |
| Time of Day | 08 |
Start it on the 1st of a month, so it runs on the 1st from then on.
2. Clients¶
Task: Match to Client(s). Lists the clients to consider.
| Field | Set it to |
|---|---|
| Action | Match to Clients |
| Find the client by | Client Status = your active statuses |
3. For each client¶
Task: Loop. Runs the next steps once per client.
| Field | Set it to |
|---|---|
| Loop Type | For each item in a list |
| List Separator | Comma , |
| Value | {{task_40002_client_ids}} |
4. Anything owed?¶
Task: Accounting. Looks for the client's unpaid invoices.
| Field | Set it to |
|---|---|
| Action | Get Quotes / Invoices |
| Find quotes and invoices by | Client ID = {{task_40003_loop_value}}, Type = Invoice, Paid status = Unpaid |
5. Owes money?¶
Task: If Statement. Carries on only when the client has unpaid invoices.
| Field | Set it to |
|---|---|
| Condition | {{task_40004_found}} is true |
6. Send statement¶
Task: Accounting. Emails the client their outstanding statement.
| Field | Set it to |
|---|---|
| Action | Send Statement |
| Client ID | {{task_40003_loop_value}} |
| Statement | What is owed now |
| Send to (optional) | Leave it blank, for the client's first contact with an email address |
The statement lists each unpaid invoice with its due date and how many days overdue it is, adds them up by age, takes off any unused credit, and has a Pay now link beside each invoice that can be paid online. It's kept with the client's other emails.
Make it yours¶
- Only chase what's late: in step 4, use Paid status =
Overdueinstead ofUnpaid. - Send an activity statement instead: Statement =
Everything between two dates, with From and To set to last month's first and last days (the Date Formatter task can work them out). - Send to an accounts address you keep in a client field: map it to Send to (optional).
- A client with no person responsible or no contact email stops that client's run with the reason, and the loop carries on with the next client.