About useme4
Free tools that get bank data into the shape your accounting software expects — without sending your statements to anyone.
Who makes this
useme4 is built and run by Sunil Kharol, an MIS Executive and Power BI Developer based in India, with about two years of professional experience and a Master of Computer Applications (MCA) degree.
What I do day to day
My job is reporting and data preparation. Most days that means taking exports from banks, ERP systems and accounting software and turning them into clean, reliable tables in Excel, Power Query, SQL and Power BI. The raw files are rarely tidy: summary rows above the data, dates in different orders, separate debit and credit columns, amounts stored as text, and descriptions split across lines. Reshaping them so the numbers can be trusted — and checking that the totals still match the source — is the core of the work.
Why I built useme4
Reformatting bank files by hand is a task I've done more times than I can count: deleting summary rows, fixing day-first dates, flipping signs, merging debit and credit columns. The same problems come up for every bookkeeper and small-business owner who has to import a statement into QuickBooks or Xero, and the tools available usually ask you to upload your bank statement to someone else's server.
useme4 packages that work into simple tools anyone can use, without an upload. The name is short for “use me for…”: use me for converting a bank CSV to QuickBooks, for getting a PDF statement into Excel, for preparing a Xero import.
How the tools work
Every converter runs inside your web browser. When you open a page, your browser downloads a small program. When you choose a file, that program reads it on your device, converts it, and saves the result to your device. There's no upload, no account and no database of statements. That's a deliberate choice: bank statements are some of the most sensitive documents people have, and the safest place for them is on your own computer.
How they're tested
Each converter is tested against a library of sample files that copy the layouts of real exports from US, UK and Canadian banks — headerless files, files with summary rows, separate debit and credit columns, text dates, old Windows encodings, Excel files with real date cells, and multi-page PDF statements with wrapped descriptions. The samples use made-up names and numbers. Every output format is checked: row counts, totals, date formats, unique transaction IDs in OFX and QBO files, and protection against spreadsheet formula injection.
Automated tests also check the detection rules — for example, that a US bank file opened in a UK browser is still read month-first. The tests are re-run before every change to the converters is published.
If a file from your bank doesn't convert correctly, please tell me which bank and which export option you used. Don't send the file itself — a description of the column headings is enough.
Editorial policy
The guides on this site are written to help people get a real task done, so they follow a few rules:
- How guides are researched. Each guide is based on the import screens and file formats of the software it covers, and on the bank export layouts the converters are tested with. Where a bank's or vendor's menus vary or change often, the guide says so rather than guessing at exact labels.
- How guides are updated. Every guide shows the date it was last updated. Guides are reviewed when QuickBooks, Xero or a major bank changes its import or export process, and when readers report something out of date.
- How mistakes are corrected. If you find an error, let me know. Confirmed errors are fixed promptly and the “Updated” date is changed.
- No paid placement. No bank, software company or advertiser pays to be mentioned or recommended. Ads are served by Google and are kept separate from the guide content.
- Not professional advice. The guides explain how to move data between systems. They are not accounting, tax or financial advice — see the disclaimer.
How the site is funded
The tools are free and supported by advertising. Ads never appear inside the converter steps, and no advertiser has any access to your files, which never leave your device. See the privacy policy for details.
Independence
useme4 is independent. It isn't affiliated with, endorsed by or sponsored by Intuit (QuickBooks), Xero, or any bank. Product names are used only to describe compatibility.