Guides · Wallet by BudgetBakers

Wallet by BudgetBakers import: file format and steps in the Web App

Updated November 19, 2026 · 6 min read · By the Utilly team

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.

Checking CSVCard CSV

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.

FileWhat's in itKnown totals
Checking CSVA Date, Note, Amount header row, then the 31 lines of the fictional checking statement20 payments 28,575.27; 11 deposits 29,597.43; net +1,022.16
Credit card CSVThe same header, then the 21 lines of the matching fictional card statement, by date19 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

RuleWallet's help saysWhat it means for you
WhereOn 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 typesCSV, 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 columnsThe 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
DelimiterCaret, comma, hashtag, semicolon or vertical bar. "My file has a different delimiter": replace it with a supported one and save as CSVTab-separated files need converting; the test files use commas
Currency"All records must be in a single currency", matching the accountOne 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:

  1. Log in to the Web App and click "Import" at the top of the screen.
  2. Select your account. If it isn't in the list, "it may not be a General account".
  3. Click "choose a file", or drag and drop the file on the green button.
  4. If the file has a header row, enable "Header row" and select "Next". For the test files, it does.
  5. 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.
  6. 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:

  1. 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.
  2. 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.
  3. 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:

CheckChecking fileCredit card fileIf it's wrong
Records3121Fewer: a row didn't parse, or the header row was imported as data (switch Header row on)
Expenses28,575.27 (20)1,939.94 (19)All as income: the Amount column wasn't read as signed; check the mapping
Income29,597.43 (11)1,542.18 (2)Same as above
Change in balance+1,022.16−397.76A different figure means rows are missing or a sign was flipped
DatesSept 1–30, 2026Sept 1–30, 2026Day 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

SymptomLikely cause and fix, from Wallet's help
No Import optionYou're in the Android or iOS app. Import is only in the Web App
Account missing from the listIt 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 missingMinus signs after the number (100.00-) or thousands separators (1,000.00). Put the minus in front and take the separators out
Dates wrongAmbiguous dates such as 1/2/11. Use two-digit months and four-digit years
Currency errorThe file's currency doesn't match the account. You can delete the currency column, then double-check the records after importing
OFX file rejectedWallet reads only OFX 2.2 files. Export CSV, XLS or XLSX instead and try again
Wrong categoriesCategories 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 doubledThe 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 stoppedBudgetBakers 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 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.