Jira & Confluence 
Bitrix24 Unapplied payments
A payment that is not applied to an invoice leaves old invoices looking overdue. Apply it, or it shows as an unapplied credit.
Reconcile with a counterparty · step 1
Statement of account template that ages itself
List every invoice, payment and credit on the account for the period. The sheet keeps the running balance and ages what is still open at the statement date.
No sign-up to start. The document stays editable in this browser; sign-in appears only when you save it to a workspace or invite a team.
Share the live result:
Start editing here — no sign-up. Send the result first; sign in only if you want to keep it in a workspace or invite your team.
- 1Set the period. Enter the statement date, the period, the currency and the opening balance with the date it fell due.
- 2Add every document. One line per invoice, debit note, payment, credit note or adjustment, in date order, with its own reference.
- 3Apply payments and credits. In Applies to, name the invoice each payment or credit settles. This is what makes the aging correct.
- 4Check and send. The check cell must show OK: the aging total equals the closing balance. Then send the statement to the customer.
The situation
When this template earns its place
Quarter end, an audit, or a customer who says they owe less than you think. Before anyone argues about the number, both sides need the same list: opening balance, every document since, and what is still unpaid and how late. This live spreadsheet opens on the page without registration. Type or paste your lines and the balance, closing balance and aging update as you go.
How to use it
A short path to a usable result
1
Set the period
Enter the statement date, the period, the currency and the opening balance with the date it fell due.
2
Add every document
One line per invoice, debit note, payment, credit note or adjustment, in date order, with its own reference.
3
Apply payments and credits
In Applies to, name the invoice each payment or credit settles. This is what makes the aging correct.
4
Check and send
The check cell must show OK: the aging total equals the closing balance. Then send the statement to the customer.
Filled example
See the result before you start
The filled example is a supplier's statement to a food manufacturer for August to October 2026: an opening balance of 18,640.00, 19 documents, a closing balance of 47,187.00 and an aging of 27,477.00 current, 19,325.00 at 1–30 days and 385.00 at 31–60 days.
Common mistakes
What makes the document stop working
Missing references
The customer matches your lines to theirs by invoice and payment number. A line without a reference cannot be matched.
Aging by invoice date
Count days past the due date, not the invoice date, or every invoice on 30-day terms looks a month late.
FAQ
Questions before you use it
Is it free? Do I need to sign up?
It is free, and the spreadsheet opens on this page without an account. Sign-in appears only when you save it to your workspace or invite your team.
What is the difference between a statement of account and an invoice?
An invoice asks for payment of one sale. A statement lists every invoice, payment and credit on the account for a period and shows the balance.
How is the aging calculated?
For each invoice, the open amount is the invoice less the payments and credits applied to it. Days past due are counted from the due date to the statement date and grouped into current, 1–30, 31–60, 61–90 and over 90 days.
What if a payment covers several invoices?
Split it into one line per invoice with the same payment reference and date, each applied to its invoice.
Can I download it?
A PDF with a “Made with Layers” line is free and needs no registration. The Excel file that keeps the formulas is on the paid Send plan.
Next step