Skip to content

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 = Overdue instead of Unpaid.
  • 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.