Monthly statement PDF template for account summaries
Generate monthly customer statements from CSV exports with balances, charges, payments, due dates, and account contact details.
Template ingredients
- CSV fields
- 9 mapped columns
- Liquid steps
- 4 setup steps
- Industries
- Subscription services, Agencies, Education
This monthly statement template is built for teams that need to summarize account activity at the end of a billing period. Each CSV row includes an account number, customer name, statement month, opening balance, new charges, payments received, closing balance, due date, and support contact. The layout gives recipients a readable snapshot first, then backs it with enough detail for finance or customer success teams to answer follow-up questions quickly.
Use it when invoices are too transactional and a customer needs a broader view of account movement. The template is useful for membership businesses, managed services, education programs, agencies, and B2B platforms that report recurring balances. Because the Liquid variables are plain and compact, operators can add aging buckets, credit notes, remittance instructions, or account manager details without turning the statement into a custom design project. Preview a few edge cases with credits, zero balances, and long customer names before running the full monthly batch.
Sample CSV
| account_number | customer_name | statement_month | opening_balance | new_charges | payments_received | closing_balance | due_date | support_contact |
|---|---|---|---|---|---|---|---|---|
| AC-1004 | Harbor Training | April 2026 | 250.00 | 410.00 | 250.00 | 410.00 | 2026-05-20 | support@harbor.example |
| AC-1005 | Maple Studio | April 2026 | 0.00 | 980.00 | 0.00 | 980.00 | 2026-05-20 | billing@maple.example |
Sample Liquid
<article class="monthly-statement">
<header>
<p>Statement {{ statement_month }}</p>
<h1>{{ customer_name }}</h1>
<p>Account {{ account_number }}</p>
</header>
<dl>
<div><dt>Opening balance</dt><dd>{{ opening_balance }}</dd></div>
<div><dt>New charges</dt><dd>{{ new_charges }}</dd></div>
<div><dt>Payments received</dt><dd>{{ payments_received }}</dd></div>
<div><dt>Closing balance</dt><dd>{{ closing_balance }}</dd></div>
</dl>
<p>Payment due by {{ due_date }}.</p>
<p>Questions? Contact {{ support_contact }}.</p>
</article>How to use this template
- 1
Export period activity
Create one CSV row per account for the statement month, including opening balance, new charges, payments, closing balance, and due date.
- 2
Check balance logic
Before rendering, spot check that opening balance plus new charges minus payments equals the closing balance shown to the customer.
- 3
Render edge cases
Preview rows with credits, zero balances, and long customer names so the statement remains readable when the data varies.
- 4
Archive generated statements
Generate the full batch and store the PDFs with your account records before emailing, uploading, or sharing them with customer teams.