--- title: "Export a financial report" description: "Run the Outstanding Balances, Invoices, Payments, and Billing Ledger reports and export any of them as CSV for your bookkeeper." type: guide updated: 2026-10-13 canonical_url: https://help.nestlicare.com/owners/billing/export-a-financial-report roles: ["center_admin", "super_admin"] platforms: [web] --- Every financial report lives in one place: **Reports**, in the **Billing** category. Each one is viewable on screen, exportable as CSV, and printable with the **Print** button next to **Export CSV**. ## The four billing reports | Report | What it answers | |---|---| | **Outstanding Balances** | Who owes you, bucketed by how overdue they are. No date range, it is always "as of now". | | **Invoices** | Invoice volume and status over a period. How much you billed, and how much of it is sitting unpaid. | | **Payments** | Every payment and credit received in a period. This is the month-end report your bookkeeper wants. | | **Billing Ledger** | The full ledger of charges and credits, line by line. | Outstanding Balances is the one to open when a family is behind. Payments is the one to export monthly. ## Export any report as CSV 1. Go to **Reports** and pick the report. 2. Set the **date range** if the report takes one. Outstanding Balances and the roster-style reports do not. 3. Click **Export CSV**. The file downloads as the report's name plus the date you ran it, for example `payments-2026-08-10.csv`. The date is in UTC, so an export made late in the evening can carry tomorrow's date. It is UTF-8 with commas. The file holds the report's underlying records with your date range and center filter applied. Column names are the system's own, such as `familyName` or `amountCents`, and money columns ending in `Cents` are in cents: 125000 means $1,250.00. Divide by 100 in your spreadsheet, or tell your bookkeeper. ## Multi-center organizations If you run more than one center, the billing reports take a **center filter**. Leave it on all centers for an organization-wide view, or pick one center to see only invoices and payments belonging to it. ## Who can open them Owners and center admins can open and export the billing reports. ## Reconciling with your bank Your bank deposits will not match your NestliCare revenue exactly, and that is expected: - A card payment takes a couple of days to reach your bank. - Processing fees are netted out before the deposit. - Refunds come out of a later payout rather than reversing the original deposit. For the payout side of that picture, go to **Invoices & Finances → Finances**, which shows what has actually been paid out to your bank. Reports tell you what you earned; Finances tells you what arrived. ## What is not in the export - **PDF export.** There's no PDF download. Click **Print** and choose Save as PDF in the print window. - **Sales tax by jurisdiction.** Not itemized. - **A single family's invoices.** Reports have no family filter. Open the family from **Invoices & Finances → Accounts**, go to the **History** tab, and click **Export CSV**. You get that family's invoices and payments with dates, status, amounts and a running balance. A very long history exports the latest records only, and the page says so. You can also export Payments or Invoices here and filter by the family's name in your spreadsheet. For a parent-facing document, use their annual statement instead. ## Troubleshooting **The CSV will not open properly in Excel.** Open Excel first, then use **File → Import → CSV** and pick UTF-8. Double-clicking sometimes guesses the encoding wrong. **Totals do not match what I added up from the CSV.** Check the date range boundaries and your organization's time zone under **Settings → General**. A late-evening payment can land on the next day once time zones are applied. **Outstanding Balances shows a family I know has paid.** Outstanding Balances is live. If a bank payment is still settling it has not cleared yet, so the balance is still open. Give it a couple of days. Related: [Reports overview](/owners/reports/reports-overview), [A family is behind on payment](/owners/situations/a-family-is-behind-on-payment), [Issue a refund](/owners/billing/issue-a-refund).