Skip to main content

How to Export Financial Statements with Custom Dates in Puzzle

Need to export your P&L or Balance Sheet for a specific date range? Learn how to set custom dates, export by effective date, and download your financials in CSV, PDF, or Excel.

E
Written by Erik Aronesty

Overview

You can export your financial statements — Profit & Loss, Balance Sheet, or Cash Activity — directly from your Dashboard with full control over the date range, report format, and view settings.
​


Step 1: Set Your Date Range

  1. On your Dashboard, navigate to the Financial Statements section and select which report you're looking to export

  2. Set the date range to your custom date range (e.g. Feb 01, 2026 - Apr 30, 2026)
    ​


    ​


Step 2: Export the Report

  1. Click the Export button in the top right corner
    ​

  2. In the export dialog, configure your options:
    ​

    • Report type — Financial statements (by period), or Modified report (by effective date) to report transactions by their effective date instead of their posting period

    • View by — By months, quarters, etc.

    • Set period range — Confirm your selected range (shown as Set date range for a Modified report)

    • Classifications — Filter by class if needed

    • Accounting basis — Cash or Accrual

    • Report level — Compact, Summary, or Detailed

    • Export format — CSV, PDF, or Excel

    • Breakouts — Include vendor & employee breakouts

    • Export options — Include account numbers, truncate decimals, summary column preferences
      ​

  3. Click Export
    ​



⚠️ Note on Modified Reports: Effective-date reporting is only available when exporting. If you export using the Modified report (by effective date), the numbers may differ slightly from what you see in your financial statements. This is because an entry can have an effective date in one period but a posting date in another — for example, an effective date of Dec 30, 2025 but a posting date of Jan 1, 2026. The on-screen statements are always based on posting date.

Did this answer your question?