Automated CONTPAQi Customer Statement Reports
On the first of each month, WebRun opens CONTPAQi, compiles each client's open CFDI invoices, payments, and running balance into a statement of account, drafts the statement email in Outlook for your review, and logs which statements are ready to send in a shared sheet.
How do I send clients an accurate statement of account each month?
On the first of each month, WebRun opens CONTPAQi and compiles every active client's open CFDI invoices, payments, and running balance into a statement of account. It drafts each statement in Outlook for your review and logs which ones are ready in a shared sheet, so nothing goes to a client without your approval first.
- Every active client gets an accurate statement drafted on the first of the month
- Balances always match the live CFDI invoices and payments in CONTPAQi
- No statement reaches a client without your review and approval
Built for accounts receivable teams · CONTPAQi bookkeepers · small business owners billing clients · credit and collections staff
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
sistema.contpaqi.com/LoginContpaqi/Loginin a real browser with your saved login - no setup, no API keys. -
1
CONTPAQi - compile each client's balance and activity
contpaqi.com
WebRun opens CONTPAQi to compile each client's balance and activity. - Open CONTPAQi and pull each client's open CFDI invoices, payments received, and running balance for the month
- Note the oldest unpaid invoice and total balance for each client
- Skip any client with a zero balance and no activity this month
Done when Every active client's invoices, payments, and balance for the month are compiled.
-
2
Outlook - draft the statement of account email
microsoft.com
WebRun opens Outlook to draft the statement of account email. - Draft a statement of account email for each client listing invoices, payments, and the balance due
- Leave every statement as a draft in Outlook for your review
- Never send a client statement without approval
Done when A reviewable draft statement of account sits in Outlook for every active client.
-
3
Google Sheets - log which statements are ready
google.com
WebRun opens Google Sheets to log which statements are ready. - Log which clients have a statement drafted and ready, with their balance due
- Mark each statement as sent once you approve and send it
Done when The statement tracker shows every client's draft status and balance due.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it email statements to clients on its own?
No. Every statement of account is left as a draft in Outlook. WebRun never sends a client a statement without you reviewing and approving it first.
How is each client's balance calculated?
From the live CFDI invoices and payments recorded in CONTPAQi for that client, so the balance on the statement matches what's actually in your books.
What if a client had no activity this month?
It's skipped. A client with a zero balance and no invoices or payments this month gets no statement drafted.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.