Skip to content
Open appSchedule a pilot

Excel Exports

Excel exports download formatted .xlsx files from list pages and reports, so you can sort, pivot, and share the data in Excel or Google Sheets without cleanup.

Key capabilities

  • Transactions export that follows every filter on screen: date range, bank account, category, tags, search, money in or out, uncategorized only, missing counterparty, review status, reconciled, Posted or Pending, source, receipts, and cardholder
  • Export only the rows you have selected with Export Selected
  • Large transaction exports run in the background and download when ready
  • Exports for the Chart of Accounts, Customers, Vendors, Purchase Orders, Orders, Contracts, and Projects
  • Purchase Orders also offer a CSV download
  • Excel buttons on Income Statement, Balance Sheet, Cash Flow, Trial Balance, General Ledger, and several CFO reports
  • Bold white-on-green header row that stays frozen, auto-filters, and auto-sized columns
  • Real Excel currency and date cells (not text), with negative amounts shown in red
  • Dropdowns on the Status and Reconciled columns, landscape print layout, and a "Generated by DayZero" footer with page numbers
  • Descriptive filenames that include the business name and date
  • Every list export is recorded in the audit log, and values are escaped so exports open safely in Excel

How it works

For list exports, DayZero gathers the records you are looking at, applies the shared formatting, and downloads the file to your browser. Financial report exports are assembled in your browser from the report you have open.

flowchart TD
  click["Click Export"] --> size{"More than 2,000 transactions?"}
  size -->|"No"| now["File is built right away"]
  size -->|"Yes"| bg["Prepared in the background"]
  now --> dl["Download .xlsx file"]
  bg --> dl
  dl --> audit["Recorded in the audit log"]

How to use it

  1. Open the page with the data you want, such as Transactions, Customers, Vendors, or Chart of Accounts.
  2. On Transactions, apply any filters first, or tick rows to export only those. The file matches what the table shows.
  3. Click Export in the page header (Purchase Orders has Export Excel and a CSV button).
  4. Large transaction exports show "Preparing your export" with progress and download on their own when finished.
  5. For financial reports, open the report (for example Income Statement) and click its Excel button.

Pro tips

  • Filter before exporting. The transaction export respects all active filters, so you get exactly the slice you need.
  • The frozen header and auto-filter let you sort and slice large exports immediately.
  • Negative amounts are flagged in red, which makes refunds, credits, and adjustments easy to spot.
  • Amounts and dates are real Excel values, so SUM and date math work without reformatting.
  • A transaction export holds up to 10,000 rows. If your filters match more, you see a warning and get the first 10,000, so narrow the date range for the rest.
  • Customer, vendor, and order exports include everything (up to 5,000 records) regardless of what is searched on screen.

In-depth guide

Available exports

Export What you get
Transactions Date, counterparty, description, amount, bank account, card last four digits and cardholder, category (or "Uncategorized"), source, posted status, review status, and reconciled
Chart of Accounts Two sheets: an import-ready template and a full detail sheet with account type, status, cash flow settings, and balance. Respects the search box and the inactive-accounts toggle
Customers Name, email, phone, address, tags, created and updated dates
Vendors Name, email, phone, category, status, credit limit, address, website, tax ID, tags, notes, created and updated dates
Purchase Orders PO number, name, status, vendor, bill status, ship-from and ship-to locations, total, balance, shipping cost, line item count, delivery and payment dates, payment terms
Orders and Contracts Customer, project, status, values, billing dates; contracts also show billed, earned, and deferred amounts
Projects Name, code, status, customer, start and end dates, active flag

The transaction export also carries each transaction's ID, so the file lines up with bulk-update uploads. The category shown is the spend category (preferred over transfer accounts).

Formatting on list exports

Feature Behavior
Header row Bold white text on a green fill, frozen at the top
Filters and widths Auto-filter across all data, columns sized to content
Currency Dollar format on amount columns, right-aligned
Negatives Red text on a light-red fill for values below zero
Print Landscape, fit to page width, repeating header, page-number footer
Validation Dropdowns on Status (Posted, Pending, Deleted) and Reconciled (Yes, No)

Financial report exports

Report workbooks are plainer than list exports: values arrive as numbers with auto-sized columns, and statements include the accounting basis at the top. The Income Statement lays out each section (Operating Revenue, Cost of Goods Sold, Operating Expenses, Other Income and Expense) with a Sum row and computed Gross Profit, Operating Income, and Net Income across the selected periods. Cash Flow has a monthly variant, Trial Balance and General Ledger also offer CSV, and Budget Projection exports a multi-sheet workbook (actuals, assumptions, 12-month projection).

List exports are logged with who exported, what, how many rows, and which filters were applied, which helps with close reviews and data-handling controls.