XLSX → QuickBooks Online (US bank CSV)
Prepare a bank CSV for QuickBooks Online US from an original Excel workbook, without an automatic import into QuickBooks.
Purpose
Upload the original XLSX workbook. Inspect the selected worksheet, map real columns when needed, choose an existing BOOKING or VALUE date and confirm the same currency on both accounts. ValidConvert passes the original OOXML bytes to Java and returns Date,Description,Amount when representable.
Workflow fit
For transactions belonging to one real bank account in an XLSX workbook, suitable for the QuickBooks Online US three-column import profile.
Implementation note
US profile only, up to 999 transactions. No currency is embedded in the output. Formula cells, hidden sheets or rows, damaged leading zeros in account IDs and ambiguous worksheets are not certified by the browser. Java must verify or reject unsafe workbooks. No FX, automatic import, de-duplication or Intuit certification.
QuickBooks Online US · Date,Description,Amount
No. This route accepts the original XLSX (OOXML) input, validates the workbook on the Java server and writes a separate three-column bank CSV. The workbook is not reserialized in the browser.
Review the worksheet explicitly. Browser inspection cannot guarantee formula safety, hidden-row visibility or numeric-ID fidelity. Java must reject unsafe or ambiguous material instead of silently skipping transactions.
The download is Date,Description,Amount with dd/MM/yyyy dates, from a selected real BOOKING or VALUE source field. Neither missing dates nor source account identifiers may be invented.
No. The QuickBooks Online US bank CSV profile accepts at most 999 movements, one account and one currency per file. The confirmed source and destination account currencies must match.
No connection or external import certification is provided. You import the CSV manually and check for duplicates. Eligible trial files are limited to 10,000,000 bytes; paid conversion costs at least one credit per started 10,000,000 bytes.
Related converters
Explore other production-ready routes connected to this format.