Importing Old Transactions to Skwad App
Mar 24, 2024
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 or download your old transactions from services like Mint or your bank or credit card provider.
Step 2: At this point, Qfx and Qif are ready. For Csv and Excel files, double check that your data has the following columns:
- Date: MM/dd/yyyy or dd/MM/yyyy or yyyy-MM-dd
- Description: The transaction description
- Amount: The transaction amount (see below for debit and credit)
- Transaction Type: (Optional) If provided, it should be
debit
orcredit
ord
orc
- Category: This is optional but recommended
- Account Name: This is optional
- Memo: (Optional) Your notes / comments.
- ExternalId: (Optional) Used to deduplicate your transactions.
Rename columns to match. For example, Transaction Date
should be renamed to Date
.
Step 3: From your personal email, send the updated file as an attachment to your Skwad scan email address. You can find your skwad scan email address in your account settings after logging in.
That's it. Your transactions should appear in your account within seconds.
Deduplicating transactions
- When you upload Ofx or Qfx files, Skwad will automatically use FITID to filter out duplicate transactions. You don't have to worry about overlapping your exported transactions.
- For Csv and Excel files, the optional ExternalId column will be used to filter out duplicates.
Get a better understanding of your finances today.
Start your 30-day trial
More posts
- How to automatically forward transactions from Proton Mail to Skwad
- How to automatically forward transactions from Gmail to Skwad
- Open Banking Budgeting: Bridging the Gap
- Effortless Balance Tracking with Skwad - No Bank Linking Required
- Protecting Your Financial Privacy: Automating Transactions Import Without Linking Your Bank
- Importing Old Transactions to Skwad App
Created and hosted in the USA πΊπΈ
Data encrypted & stored with AWS π
Bootstrapped & funded by our users.
Resources
Free bank transaction categorizerHow to setup auto import without bank linkingBank linking with 11,000+ financial institutionsHow to auto sync transactions to Google SheetsHow to import from MintHow to import old transactions