XLSX output format specifications for Zera Books PDF to Excel conversion: column structure, data types, worksheet organization, and pre-formatted import layouts for accounting software.
Standard column structure for bank statement PDF to Excel exports. Column order is fixed; optional columns are included when data is available.
| Column | Header Name | Data Type | Notes |
|---|---|---|---|
| A | Date | Excel date (MM/DD/YYYY) | Formatted as date serial; sortable in Excel |
| B | Description | Text | Cleaned and normalized; original description preserved in Col H |
| C | Debit | Numeric (currency) | Positive values only; blank if no debit on this row |
| D | Credit | Numeric (currency) | Positive values only; blank if no credit on this row |
| E | Balance | Numeric (currency) | Running balance; arithmetically verified against source |
| F | Category | Text | AI-assigned chart of accounts category; blank if uncategorized |
| G | Confidence | Integer (0–100) | Categorization confidence score; values <85 highlighted yellow |
| H | Original Description | Text | Raw description as extracted from source document |
| I | Reference / Check # | Text | Optional; populated when check number or reference ID is present |
Each XLSX file includes a structured header block above the transaction table, containing document metadata sourced from the original statement.
| Row | Content | Example Value |
|---|---|---|
| Row 1 | Bank Name | Bank of America |
| Row 2 | Account Type | Business Checking |
| Row 3 | Account Number (last 4) | ****7823 |
| Row 4 | Statement Period | 01/01/2025 – 01/31/2025 |
| Row 5 | Opening Balance | $12,450.00 |
| Row 6 | Closing Balance | $18,203.44 |
| Row 7 | Total Debits | $8,246.56 |
| Row 8 | Total Credits | $14,000.00 |
| Row 9 | (blank spacer) | — |
| Row 10 | Column headers (bold, #0A1628 fill) | Date | Description | Debit… |
| Row 11+ | Transaction data rows | 01/03/2025 | Amazon.com | $124.99 | … |
Upload any bank statement PDF and download a clean, categorized XLSX in under 30 seconds.
Try for one week →In addition to the standard XLSX output, Zera Books offers pre-formatted XLSX templates optimized for direct import into specific accounting platforms.
Columns mapped to QBO's bank transaction import format: Date, Description, Amount (signed), Account. Includes category mapped to QBO expense account names.
Columns: Date, Amount, Payee, Description, Reference, Account Code. Amounts are signed (positive = deposit, negative = withdrawal). Compatible with Xero's manual import.
Mapped to Sage journal entry import format with GL account codes. Date format set to YYYY-MM-DD per Sage requirements. Debit/credit split maintained.
All transactions in a single table with named columns. No merged cells, no header block — designed for immediate pivot table analysis in Excel or Google Sheets.
Columns: Date, Description, Amount (signed), Account Name. Compatible with Wave's CSV/Excel import wizard. Negative values for expenses, positive for income.
Mapped to Zoho's transaction import format. Includes vendor/customer name columns when available. Date format: MM/DD/YYYY per Zoho requirements.
| Data Element | Format | Notes |
|---|---|---|
| Date | Excel date serial (default: MM/DD/YYYY display) | ISO 8601 option available in export settings |
| Currency amounts | Numeric, 2 decimal places, no currency symbol | Currency symbol optionally added via cell format setting |
| Negative amounts | Not used in standard output (separate Debit/Credit columns) | Signed single-column format available as option |
| Account numbers | Stored as text (leading zeros preserved) | Column formatted as text to prevent numeric conversion |
| Column headers | Bold, white text on #0A1628 fill | Row frozen for scroll lock |
| Low-confidence cells | Yellow fill (#FFE680) on Category column | Applied when confidence score 60–84 |
| File encoding | UTF-8 (handles special characters in descriptions) | Ensures compatibility with international bank descriptions |
Zera Books exports to .xlsx format (Excel 2007 and later). The file is compatible with Microsoft Excel 2007+, Google Sheets, LibreOffice Calc, and Apple Numbers. Legacy .xls format is not available.
Dates are formatted as Excel date serial numbers with the cell format set to MM/DD/YYYY by default. Users can change the date format in Excel without affecting the underlying data. The format is also configurable in Zera Books export settings (MM/DD/YYYY, DD/MM/YYYY, YYYY-MM-DD).
The standard output contains values only (no formulas). The QuickBooks-ready template includes SUM formulas in the totals row. Users can request a formula-enabled version which includes running balance formulas in the Balance column.
Yes. When multi-account detection identifies multiple accounts, users can choose to either export separate files (one per account) or a single workbook with each account on its own worksheet. The worksheet is named with the account type and last 4 digits.
Explore related Zera Books features and documentation.
Zera Books outputs categorized, balance-verified XLSX files ready for QuickBooks, Xero, Sage, or direct analysis in Excel.
Try for one week →