Import Transactions
Switching to Pocket Clear from another app or spreadsheet? You can import your existing transaction history from a CSV or Excel file. This is a free feature available to all users — no Pro subscription required.
Pocket Clear recognises exports from Money Manager, Money Lover, Spendee and YNAB, so those files import without any editing. For any other file you match the columns yourself. Nothing is saved until you confirm the preview.
How to import transactions
- Open Pocket Clear and tap Settings (gear icon).
- Tap Import Transactions.
- Choose where your data comes from, then pick your file (CSV, Excel .xlsx, TSV or zip).
- Review the preview: match any new categories and accounts, and check the duplicates.
- Tap Import to add the entries to your account.
What the preview shows
- Match categories. Names that match a category you already have are matched for you, in any app language. A name with no match keeps its name as a new category, or you can pick an existing one or Other. Your choices are remembered on this phone for the next file from the same app.
- Match accounts. Accounts are matched by name. A new one is created, or choose No account.
- Duplicates. An entry already in Pocket Clear (same day, type, amount, category and note), or repeated in the file, starts unticked. A possible duplicate (same day, type and amount) stays ticked and is labelled, so you can drop it. If you pick a file you imported before, its entries start unticked.
- Transfers. A transfer between two accounts becomes one transfer entry. Transfers are a Pro feature: on Free they are skipped, and never saved as income or an expense.
- Other currencies. Entries in another currency are skipped. If the whole file is in another currency, you'll see a warning, and the amounts are only imported if you confirm. They are saved as they are, with no conversion.
- Opening balances. If the file has them (YNAB and Money Lover do), you can choose to set them on the matching accounts. An account that already has one keeps it.
Imported entries show up in your Reports and history straight away, but they don't count towards streaks, milestones or Road to 50: those reward what you log by hand.
Undo an import
For 30 days, Settings › Import Transactions lists Recent imports with Undo import. Undo removes that import's entries, except any you edited since. Categories and accounts it created stay. Undo works on the phone you imported on.
Money Manager
- In Money Manager, open More › Backup › Export to Excel.
- Send the file to yourself, then choose it in Pocket Clear.
Carries over: dates, amounts, income and expenses, categories, subcategories, accounts, notes and transfers. A foreign purchase comes in at the amount in your main currency, and the preview shows the original.
Doesn't carry over: budgets, and transfers on Free. The PC Manager's Wi-Fi export is a web page rather than a spreadsheet, so export from the phone app instead.
Money Lover
- In Money Lover, open Tools (Database on iPhone) and export to CSV, choosing the wallet and date range.
- Choose the file in Pocket Clear. Comma, semicolon and tab files all work.
Carries over: dates, amounts, categories, wallets, notes and starting balances, if you choose to set them. If the columns aren't recognised, you can match them yourself.
Doesn't carry over: budgets, and entries in another currency.
Spendee
- In Spendee, open Settings › Export data and choose CSV or Excel. The file arrives by email.
- Choose it in Pocket Clear. If you export every wallet you get one file each, so import them one at a time.
Carries over: dates, amounts, categories, wallets, notes and transfers. Labels become tags for Pro users with Tags on.
Doesn't carry over: budgets, transfers on Free, and entries in another currency. A transfer whose other wallet isn't in the file is skipped.
YNAB
- On the YNAB website, open your plan menu and choose Export Plan. The mobile apps can't export.
- Choose the zip, or the Register file inside it, in Pocket Clear.
Carries over: dates, amounts, categories, accounts, notes (payee and memo together), refunds, transfers and starting balances, if you choose to set them.
Doesn't carry over: budgets and category groups, and transfers on Free.
Any other file
If Pocket Clear doesn't recognise a file, it asks you to match the columns: date and format, amount, and optionally type, category, subcategory, account, currency and note. It remembers your choices for files with the same columns. If a preset read a file wrongly, tap Wrong columns? in the preview to do the same.
You can also start from the blank template on the Import Transactions screen: Date, Type and Amount are required, and Category, Subcategory, PaymentType and Note are optional. In that format a category with no match goes to Other, unless you choose otherwise in the preview.
Limits
- Each file can be up to 8 MB and 10,000 entries. A longer file keeps the newest 10,000, and files over 30,000 rows need splitting.
- You can import up to 3 files a day. Changing the columns or the date order doesn't count: only the first upload of each file does.
- Pocket Clear holds up to 15,000 of your entries, so a bigger history starts from the earliest date that fits. The preview shows that date.
Still need help? Email us at [email protected]