Start free trial

Excel Exports

Excel exports deliver formatted .xlsx files from list pages and reports — frozen headers, filters, currency cells, and red negatives — respecting whatever filters you have applied.

Key capabilities

  • Transaction export honoring every active filter: date range, bank-account ledger, category ledger, source account, tags, search, amount direction, uncategorized-only, missing-counterparty, and review status
  • Customer, vendor, and purchase-order list exports (Excel; purchase orders also export to CSV)
  • Per-report Excel buttons on Income Statement, Balance Sheet, Cash Flow, Managerial P&L, Vendor Spend, Cash Flow Forecast, and Budget Projection
  • Bold white-on-green header row, frozen at the top so it stays visible while scrolling
  • Auto-filter enabled across the full data range, plus auto-sized columns
  • Real Excel currency cells ($#,##0.00), not text, with right-aligned numbers
  • Negative amounts highlighted in red via conditional formatting
  • Proper Excel date cells, landscape print layout fit to page width, and a "Generated by DayZero" footer with page numbers
  • Dropdown validation on Status (Posted / Pending / Deleted) and Reconciled (Yes / No) columns
  • Color-coded sheet tabs per export type, and descriptive filenames (<Type> Export - <Business> - <YYYY-MM-DD>.xlsx)
  • Every export records an audit-log entry capturing the format, filters, and row count
  • Values are escaped so exports open safely in Excel — leading formula characters won't execute

How it works

For list exports, DayZero pulls the filtered records (up to a generous per-export cap), formats amounts and dates, applies the shared styling pass, and downloads the file to your browser. Report exports assemble each report's sections into one or more worksheets directly.

flowchart TD
  click["Click Excel export"] --> fetch["Fetch filtered records (capped)"]
  fetch --> conv["Format amounts and dates"]
  conv --> write["Write rows with headers and filters"]
  write --> audit["Write audit-log entry"]
  audit --> dl["Download .xlsx file"]

How to use it

  1. Open the page with the data you want: Transactions, Customers, Vendors, or Purchase Orders (under Inventory).
  2. Apply any filters — date range, bank account, status, search, etc. The export mirrors exactly what the filtered table shows.
  3. Click the Excel export (download) icon in the page header. Purchase Orders also offers Export Excel alongside a CSV option.
  4. The file downloads immediately as a formatted .xlsx, named with the business and today's date.
  5. For financial reports, open the report page (e.g. Income Statement) and click its own Excel export button.

Pro tips

  • Filter before exporting — the transaction export respects all active filters, so you get exactly the slice you need with no spreadsheet cleanup afterward.
  • The frozen header row and auto-filter mean you can sort and slice large exports immediately in Excel or Google Sheets.
  • Negative amounts come pre-flagged in red, making refunds, credits, and adjustments easy to spot at a glance.
  • Numbers export as real currency and date cells, so SUM and date math work without re-typing or reformatting.
  • For very large datasets, list exports cap at a high limit (10,000 transactions; 5,000 customers/vendors/orders) — narrow the date range or filters for anything bigger.
  • Need a plain data feed instead of formatting? Use the Purchase Orders CSV export.

In-depth guide

Available exports and columns

Export Columns
Transactions ID, transaction_id, Date, Counterparty, Description, Amount, Ledger ID, ledger_name, category, Status, Review Status, Reconciled
Customers ID, Name, Email, Phone, Address, Created Date, Updated Date
Vendors ID, Name, Email, Phone, Category, Status, Credit Limit, Address, Website, Tax ID, Notes, Created Date, Updated Date
Purchase Orders PO Number, Name, Status, Vendor, Total, Balance, Line Items, Description, Expected Delivery Date, Expected to Pay On, Payment Terms, Created Date, Updated Date

On the Transactions export, the category column shows the categorization ledger name (preferring spend categories over transfer accounts), or "Uncategorized". ledger_name is the source bank account. transaction_id duplicates ID so exports align with bulk-update column names. Anything you filter on screen — date range, bank account, tags, review status, sort order — carries into the file.

Formatting applied to list exports

Feature Behavior
Header row Bold white text on a green fill, centered, bordered
Freeze panes Top row frozen so headers stay visible
Auto-filter Enabled across the full data range
Column width Auto-sized to content
Currency cells $#,##0.00 number format, right-aligned, on amount columns
Negatives Red font on a light-red fill for values below zero
Dates Proper Excel date number format on date columns
Print setup Landscape, fit-to-width, repeating header row, footer with page numbers and "Generated by DayZero"
Validation Dropdowns on Status (Posted/Pending/Deleted) and Reconciled (Yes/No)
Tab color Per type — transactions green, customers blue, vendors red, orders orange

Financial report exports

Report pages assemble their workbooks directly:

  • Income Statement — each section (Operating Revenue, Cost of Goods Sold, Operating Expenses, Other Income/Expense) as a block with a Sum row and computed subtotals for Gross Profit, Operating Income, and Net Income across the selected periods.
  • Other reports — Balance Sheet, Cash Flow (including monthly and forecast variants), Managerial P&L, Vendor Spend, and the multi-sheet Budget Projection each have their own export tailored to that report's structure.

Every export — Excel or CSV — writes a record to the audit log capturing the export action, entity type, row count, and filters in effect. Useful for close reviews and data-handling controls.