Client Invoice, DSO & Collections Dashboard — Excel spreadsheet template to download
Track invoices, DSO and collection effectiveness for service firms
Finance · dashboard · CC0 public domain · Built by Sheetly AI
About this template
This finance dashboard brings together indicators like "Total Open AR", "Average DSO" and "Collection Rate (Last 30 Days)" in a single view. Edit the entries in the Data tab and the dashboard numbers update instantly — no need to build the spreadsheet from scratch.
Released under the CC0 license (public domain): download, edit and use it freely — including commercially — with no attribution required.
Use cases
- Visualize indicators like "Total Open AR" and "Average DSO"
- Make faster decisions based on "Collection Rate (Last 30 Days)"
- Compare your finances without building the spreadsheet from scratch
- Edit the entries in the Data tab and watch the dashboard recalculate automatically
Key features
- Total Open AR
- Average DSO
- Collection Rate (Last 30 Days)
- Visual dashboard with 3 automatic indicators
- Editable formulas in the Data tab
- In-cell mini charts (sparklines)