Summary – When any Balance‑type report uses a single date as the timescale (regardless of interval), most export methods apply suboptimal formatting to the exported timescale field. The exported date becomes a concatenation of the date, a hidden linefeed (LF or CRLF), and the word “Balance.” This produces a non‑ideal text label instead of a clean numeric date, complicating downstream analysis in Excel and other tools.
Expected Behavior – If the report’s timescale resolves to a single date, the exported column header should contain only the date (e.g., 08/06/2026).
Actual Behavior – Most export pathways produce a single cell containing: 08/06/2026<LF>Balance This occurs in: Copy to Clipboard, Export to Excel (.xlsx), Export to Text (.txt), and Export to PDF (.pdf).
Correct Behavior Already Exists – Under Export to PDF → Export to CSV, Quicken exports the date and the word “Balance” as two separate rows/cells, with no hidden characters and no concatenation. This structure is clean, consistent, and machine‑readable.
Request – Please make all single‑date exports follow the same clean structure already implemented in Export to PDF → Export to CSV: Row 1: numeric date, Row 2: “Balance” with No hidden characters and No concatenation. This would provide consistent, predictable formatting across all export methods.
Additional Note – The preferred CSV export pathway is currently located under Export to PDF → Export to CSV, which makes the consistent behavior harder to discover. Aligning all export methods with this existing CSV structure would eliminate the inconsistency without requiring any UI changes.
Reproduction Steps
- Open any Balance‑type report (e.g., Net Worth & Balances → Account Balances, or Net Worth).
- Set Date Range = Year to Date or Custom → choose any single date.
- Set Interval to anything except None (all intervals reproduce the behavior).
- Export using any of the four top‑level export methods.
- Compare with Export to PDF → Export to CSV, which exports in the preferred structure.
Impact – The current formatting causes the exported date field to be treated as text, not a numeric date, affecting sorting, pivot table grouping, date arithmetic, PowerQuery ingestion, and automation workflows. Aligning all export methods with the existing CSV structure would eliminate these issues and provide a consistent, modern export experience.
If a Report a Problem submission or a sample file is required, I’m happy to provide it. This formatting behavior is easy to reproduce and affects all single‑date Balance report exports.
