Wallet by BudgetBakers import: file format and steps in the Web App
Wallet by BudgetBakers imports transactions from CSV, Excel and OFX files, but only in its Web App, only into General accounts, and with strict rules on dates and amounts. It doesn't list PDF as a file type, so bank statements you only have as PDFs need converting first. Here's the import format Wallet expects, the steps, why an import stops working, and free CSV test files with known totals so you can try an import before you touch real data.
Short answer: sign in to the Wallet Web App at web.budgetbakers.com (import isn't in the Android or iOS app), click Import, pick a General account, choose a CSV, XLS/XLSX or OFX file, switch on Header row, map the Amount and Date columns (Note and Payee are optional), then Preview and Import. Amounts need the minus sign in front and no thousands separators, and the file must be in the account's currency. Free test files: a checking CSV (31 fictional transactions) and a credit card CSV (21).
See the statement behind the test files
Open Utilly's fictional September 2026 checking statement: every line, the balance check from 12,418.36 to 13,440.52, and the CSV download. Free, because the data is made up. The checking test file on this page holds those same 31 lines, so you know exactly what an import should bring in.
1. The test files
These files hold Utilly's fictional September 2026 checking and credit card statements as CSVs laid out for Wallet's import, so you can try it on a spare General account and compare the result with known totals. No sign-up.
| File | What's in it | Known totals |
|---|---|---|
| Checking CSV | A Date, Note, Amount header row, then the 31 lines of the fictional checking statement | 20 payments 28,575.27; 11 deposits 29,597.43; net +1,022.16 |
| Credit card CSV | The same header, then the 21 lines of the matching fictional card statement, by date | 19 charges 1,939.94; 2 credits 1,542.18; 397.76 more owed |
The rows come from Utilly's fictional sample statements (explained on sample bank statement PDF), read by the same engine Utilly's converters use. Each CSV is comma-delimited with a header row and three columns: the date written year first (2026-09-01, a four-digit year and two-digit month, so day and month can't be swapped), the statement description as the note, with commas and quote marks taken out, and the amount as one signed number with a period decimal, the minus sign in front and no thousands separator (money out is negative). There's no currency column, so the records take the account's currency.
Date,Note,Amount
2026-09-01,ACH DEBIT GUSTO PAYROLL 0912,-6420.18
2026-09-01,STRIPE TRANSFER ST-K2M8Q4,3184.27
2026-09-02,CHECK 2041,-1850.00
2. The import format Wallet accepts
| Rule | Wallet's help says | What it means for you |
|---|---|---|
| Where | On Android, import "is currently not supported within the app"; on iOS it's "Not available please refer to the Web App instructions" | Use a computer browser and the Web App at web.budgetbakers.com, signed in with the same account as your phone |
| File types | CSV, XLS / XLSX and OFX. For OFX: "Wallet exclusively supports files formatted according to the Open Financial Exchange Specifications 2.2." | No PDF on the list. Many banks' OFX downloads are the older 1.x kind, and so is Utilly's OFX, so use a CSV (section 4) |
| Required data | "Your import file must have the following data": Amount and Date. Note, Payee and Currency are optional columns | The test files have Date, Note and Amount |
| Amounts | "We only support left-to-right amounts (e.g., -100.00, not 100.00-)." Decimal points and decimal commas both work, but "we do not support the use of thousands delimiters" | Write 6420.18, not 6,420.18 or 6420.18-. A bank CSV with 1,234.56 amounts needs the commas taken out |
| Dates | "Dates must be in English or number format". Use "two digit months and four digit years to avoid ambiguous formats" | 1/2/11 could be read three ways; 2026-09-01 can't |
| Delimiter | Caret, comma, hashtag, semicolon or vertical bar. "My file has a different delimiter": replace it with a supported one and save as CSV | Tab-separated files need converting; the test files use commas |
| Currency | "All records must be in a single currency", matching the account | One file per currency and account |
| Size | "We recommend that the file size contains a maximum of 1,000 rows." | Split a long history by quarter or year |
| Account | "Imports are available only to General Accounts". "If your account is linked to a bank, imports are unavailable." | Import into a General account; a bank-connected account has to be disconnected first (section 3) |
3. Importing a file, step by step
Wallet's help gives these steps in the Web App:
- Log in to the Web App and click "Import" at the top of the screen.
- Select your account. If it isn't in the list, "it may not be a General account".
- Click "choose a file", or drag and drop the file on the green button.
- If the file has a header row, enable "Header row" and select "Next". For the test files, it does.
- Choose the Amount and Date columns. Optionally identify Note, Payee and Currency. For the test files: Date as Date, Amount as Amount, Note as Note.
- Select Preview, check it, then select Import.
After the first file, "Wallet will automatically display a preview for you to review and accept if everything is in order", so check the preview each time anyway. Wallet's help says it then categorises the new records from the note field first, then the payee field.
Adding a file to an account that's connected to a bank: edit the account and disconnect it, switch it to a General account, run the import, then edit the account again and select "Deactivate Imports". You can then return it to its original account type and connect again.
Undoing an import: go to Imports, select the account, pick the imported file and select Delete. "Deleting the import file will result in the removal of all records associated with it", which makes a test import easy to throw away.
Wallet's help doesn't say how a single signed Amount column is read when it shows the records as expenses and income. Import a test file first and check that the 20 payments come in as expenses (section 5).
4. PDF bank statements
Wallet's import takes CSV, Excel and OFX 2.2 files, so months you only have as PDF statements need converting first:
- Convert each statement with Utilly's bank statement PDF to CSV converter (card statements: credit card statement to CSV, or PDF to Excel if you'd rather tidy it in a spreadsheet). The free preview shows every line and whether the statement balances before you download.
- The CSV has Date, Description, Amount and Balance columns with year-first dates and plain signed amounts. Map Date and Amount, map Description as the note, and leave Balance unmapped.
- Import it into a General account, only for dates that aren't in Wallet yet.
5. Checking the import against known totals
Import a test file into a new General account you don't rely on, then compare:
| Check | Checking file | Credit card file | If it's wrong |
|---|---|---|---|
| Records | 31 | 21 | Fewer: a row didn't parse, or the header row was imported as data (switch Header row on) |
| Expenses | 28,575.27 (20) | 1,939.94 (19) | All as income: the Amount column wasn't read as signed; check the mapping |
| Income | 29,597.43 (11) | 1,542.18 (2) | Same as above |
| Change in balance | +1,022.16 | −397.76 | A different figure means rows are missing or a sign was flipped |
| Dates | Sept 1–30, 2026 | Sept 1–30, 2026 | Day and month swapped: the dates were read in the wrong order |
The data is fictional (Example Community Bank and Sample Customer LLC don't exist; both statements say SAMPLE STATEMENT, FICTIONAL DATA FOR DEMONSTRATION ONLY). Delete the test import afterwards (Imports, the account, the file, Delete), and replace every row before using a template for real.
6. Import not working: problems and fixes
| Symptom | Likely cause and fix, from Wallet's help |
|---|---|
| No Import option | You're in the Android or iOS app. Import is only in the Web App |
| Account missing from the list | It isn't a General account, or it's linked to a bank. Disconnect it from the bank first, or import into a General account |
| Amounts wrong or missing | Minus signs after the number (100.00-) or thousands separators (1,000.00). Put the minus in front and take the separators out |
| Dates wrong | Ambiguous dates such as 1/2/11. Use two-digit months and four-digit years |
| Currency error | The file's currency doesn't match the account. You can delete the currency column, then double-check the records after importing |
| OFX file rejected | Wallet reads only OFX 2.2 files. Export CSV, XLS or XLSX instead and try again |
| Wrong categories | Categories come from the note, then the payee. Wallet's workaround: set up automatic rules with keywords, then import with your category column mapped as the note |
| Records doubled | The same dates were imported twice. Delete the import file (which removes all its records) and import only new dates. Wallet's duplicate merge covers records from bank-connected accounts |
| Email import stopped | BudgetBakers ended the email import function on 31.1.2024; use the Web App |
Comparing apps? Spendee imports CSV and Excel files into cash wallets from its web app, PocketSmith also takes OFX and QIF, Monarch Money and YNAB import CSVs in their own layouts, and Firefly III and Actual Budget map a signed Amount column.
Get PDF statements into Wallet
PDF statements, downloaded or scanned, get a free preview with the balance check, no sign-up. Download a clean CSV with year-first dates and one signed Amount column, map Date, Amount and Description as the note, and import it into a General account. Files are processed in memory and not stored.
Utilly isn't affiliated with BudgetBakers or Wallet. The steps and quotes above are from BudgetBakers' own Wallet Help Center, checked November 19, 2026; the test files weren't imported into a live Wallet account, and screens may differ. Sources: Import your transactions or files, Unable to import my files, My data has not been imported correctly, Wallet Web App, Solve Duplicate Transactions (Wallet Help Center, updated October 26 to November 18, 2026).
FAQ
Can I import transactions into Wallet by BudgetBakers?
Yes, from a CSV, XLS/XLSX or OFX file in the Wallet Web App at web.budgetbakers.com. BudgetBakers' help says import isn't supported in the Android app and isn't available on iOS.
What format does a Wallet import file need?
At least a Date and an Amount column. Amounts need the minus sign in front (-100.00) and no thousands separators; dates should use two-digit months and four-digit years; all records must be in one currency, matching the account. Comma, semicolon, caret, hashtag and vertical bar delimiters work.
Why is my Wallet import not working?
The usual causes in BudgetBakers' help: the account isn't a General account or is linked to a bank, amounts have thousands separators or a trailing minus, dates are ambiguous, the currency doesn't match the account, or an OFX file isn't OFX 2.2.
Can Wallet by BudgetBakers import a PDF bank statement?
BudgetBakers' help lists CSV, XLS/XLSX and OFX files, not PDF. Convert the PDF statement to CSV first, then map Date, Amount and the description as the note.
How do I undo an import in Wallet?
In the Web App, go to Imports, select the account, pick the imported file and select Delete. Deleting the import file removes all the records that came in with it.
Related guides
- Spendee import: CSV and Excel files in the web app, step by step
- PocketSmith import: CSV, OFX and QIF bank files, step by step
- How to import transactions into Monarch Money (CSV format, free template, old statements)
- YNAB CSV import: the format, a free template, and how to import past transactions
- Free sample bank statement CSV (fictional, with known totals)
- Catch-up bookkeeping: getting 12 months of bank statements into QuickBooks or Xero and reconciled
Related tools
- Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
- Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.