Compare the files Statement2Sheet produces
| Format | What you get | Before you use it |
|---|---|---|
| CSV | A transaction table with Date, Description and Balance, plus separate Debit/Credit columns or one signed Amount column. No row review highlighting. | Check date and text import settings, column mapping and amount signs. Keep application warnings available. |
| OFX | A financial-data file containing transactions, currency, account information, the statement period and closing balance. | Confirm the account number, dates, closing balance and amounts. Check whether your software accepts the file before importing real records. |
| QBO | A file intended for QuickBooks, with transactions and statement information. Check that names and descriptions display correctly after import. | QuickBooks imports have not been verified for your bank. Try a sample first; if the file is rejected, use CSV instead. |
If you need visible row status and review formatting, use XLSX alongside the application review screen. The CSV guide shows actual split and signed synthetic exports.
Check signs, dates and the account number
Signed amounts use credit − debit: deposits and payments are positive; withdrawals and card purchases are negative. In signed CSV and OFX/QBO, a card closing balance owed is negative. Split CSV keeps separate Debit and Credit columns and the source balance convention.
OFX/QBO transaction dates use a posting date when available, otherwise the transaction date. CSV uses the transaction date. Confirm the account number in the application before downloading OFX or QBO.
Use the same account number for each month you import. Before importing a file again, check how your software handles duplicates; Statement2Sheet does not guarantee that repeat imports will avoid duplicate transactions.
Review the result before importing
- Compare the extracted rows and balances with the original statement. Leave anything flagged for review unresolved until the source proves a correction.
- Inspect the columns, dates, descriptions and destination account. Statement2Sheet checks each file it generates, but it does not open QuickBooks or another external application.
- Import an invented sample into the exact receiving software and version. Check the account destination, count, signs, dates, descriptions, closing balance and repeat-import behavior before using real records.
The pass and review examples show when a statement is flagged for review rather than marked as converted. The sandbox API quickstart exercises upload, status and CSV retrieval, with fixed synthetic responses.