Uploading Transactions
Skwad allows you to import transactions from other services like Mint, YNAB, or directly from your bank or credit card provider.
Supported File Formats
Skwad supports the following file extensions:
- Open Financial Exchange (ofx) (Recommended)
- Quicken Financial Exchange (qfx) (Recommended)
- Quicken Interchange Format (qif)
- Excel (xlsx, xls)
- Csv
Step 1: Export Your Transactions
Export or download your old transactions from other services like Mint or your bank or credit card provider.
Coming from Mint or YNAB? Your exports are ready to go. Feel free to upload them without additional edits.
Step 2: Prepare Your File
For Qfx and Qif Files
These are ready to upload! No additional preparation needed.
For Csv and Excel Files
Your file should include these core columns:
| Column | Required | Description |
|---|---|---|
| Date | Yes | MM/dd/yyyy, dd/MM/yyyy, or yyyy-MM-dd |
| Description | Yes | The transaction description |
| Amount | Yes | The transaction amount (see below for debit and credit) |
| Transaction Type | No | If provided: debit, credit, d, or c |
| Category | No | Recommended. Assign categories after import |
| Memo | No | Your notes / comments |
Optional fields for richer data and account routing:
| Column | Description |
|---|---|
| Last 4 | Account last 4 — helps route transactions to the correct account |
| ExternalId | Used to deduplicate your transactions |
| Tags | Comma-separated list of tags (e.g. food, travel). Created automatically if they don't exist |
| Original Description | Raw merchant string. Stored on the line item while Description becomes the cleaned merchant name |
| Currency | Currency code (e.g. USD, CAD, EUR). Or use currency-specific amount columns like CAD$ / USD$ |
| TOCURRENCY | Target currency to convert to. Required if providing a conversion rate |
| CONVERSIONRATE | Conversion rate from Currency to TOCURRENCY. Required if providing a target currency |
You can include conversion rates directly in your CSV or Excel uploads to convert into your default Skwad currency. Both TOCURRENCY and CONVERSIONRATE columns must be present for rates to be recognized. Column names are case-sensitive and must be UPPERCASE (TOCURRENCY, CONVERSIONRATE), camelCase (toCurrency, conversionRate), or lowercase (tocurrency, conversionrate).
Conversion rates are also automatically extracted from OFX and QFX file uploads if your bank provides them — no extra columns needed.
Example Files
Basic Upload
Full Upload
The first row should be headers (labels for the corresponding column). Common variations like Transaction Date, Posted Date, Transaction Amount, Payee, and Merchant are automatically recognized.
Step 3: Upload Your File
- Go to Settings → Import to upload your files
- Select your prepared file
- Wait for processing
That's it. Your transactions should appear in your account within seconds.
Deduplicating Transactions
Skwad automatically filters out duplicate transactions on import:
- Ofx or Qfx files: Skwad uses FITID to detect duplicates. You don't have to worry about overlapping your exported transactions.
- Csv and Excel files: The optional ExternalId column is used to filter out duplicates.
Checking for Errors
You can check the status of your file uploads in your Skwad inbox:
- Desktop: On the sidebar, click Inbox
- Mobile: Tap the drawer, click Inbox
- App: Tap More → Scan Settings → click the Inbox icon
Troubleshooting
Invalid 'Description' on row number x
If x is 1, the first thing to check are your headers. Make sure the first row is the header row. Then, check the data on row x. Make sure each column follows the instructions above.
Transactions not appearing
- Check your Skwad inbox for error messages
- Verify your file format matches the requirements
- Ensure the first row contains headers, not data
Duplicate transactions
- Make sure you're using the ExternalId column for CSV/Excel files
- For OFX/QFX files, duplicates are automatically handled via FITID
Need Help?
Having trouble uploading old transactions? Email us and we're happy to help.