Upload the PDF trust or operating statement and download a file CosmoLex imports: one row per transaction with date, payee, check number, amount and balance. Built for law firms and legal bookkeepers on CosmoLex Core, where there is no bank feed, and for anyone moving older months into CosmoLex.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
CosmoLex cannot read a PDF bank statement. It imports bank transactions from QBO, Excel and CSV files under Accounting > Bank > Details > Action > Import Transactions, and pulls live data through bank feeds only on the Pro plan. Convert the PDF to QBO, Excel or CSV, import it, add or match each row (trust rows need a matter), then reconcile against the statement ending balance.
CosmoLex does the trust accounting well once the transactions are in. The monthly grind is getting them in when all you have is a PDF.
Import Transactions takes QBO, Excel and CSV. The e-statement your bank emails, or the scan a client drops off, is not something CosmoLex can open.
The CosmoLex pricing table marks bank feeds for Pro only. On Core, every trust and operating account comes in by file, every month.
Banks keep transaction downloads for a limited window, while PDF statements go back years. Migration and catch-up months are usually PDF only.
Typing trust activity by hand means keying the amount and the matter for each line. One transposed digit throws off the three-way reconciliation.
CosmoLex matches deposits on date and amount and checks on check number and amount. Copy and paste from a PDF garbles exactly those fields.
A missed line or a sign error leaves a difference that is not $0.00, and the hunt through a month of trust activity starts.
A clean file per bank account and statement period, shaped for Import Transactions so the add and match step is a review, not data entry.
Excel and CSV on every plan. QBO, the format CosmoLex calls the easiest to import, on the Plus plan.
Check numbers the bank prints come through in their own column, which is what CosmoLex uses to match checks.
Money in and money out land in separate columns, so nothing depends on guessing a sign.
Opening, running and ending balances come with the rows, so you can confirm the file ties before it touches the trust ledger.
On Plus, upload up to 50 PDFs in one batch when you are moving a firm onto CosmoLex or catching up months of trust activity.
Nothing connects to the bank or to CosmoLex. Upload a statement, download a file, and delete the upload whenever you like.
The monthly routine for a trust or operating account on CosmoLex Core, or any month a feed cannot reach.
Upload the PDF and download QBO, Excel or CSV. Every transaction comes back with date, description, check number, amount and balance.
Tip: Check that opening balance plus deposits minus withdrawals equals the ending balance.
In CosmoLex open Accounting > Bank > Details > Action > Import Transactions, upload the file, confirm green matches and add the rest.
Tip: For Excel or CSV, tick File has header and map the columns once.
Open Reconciliation, click Add, enter the statement end date and ending balance, clear the matched items and click Reconcile at $0.00.
Tip: Run the Three Way Reconciliation Report for trust accounts.
US law firms and legal bookkeepers who keep trust and operating books in CosmoLex.
No bank feed on the plan, so every account arrives as a file. Convert and import instead of typing.
Close several firms each month from the PDF statements they forward, and keep three-way reconciliations on schedule.
Bring prior months of trust and operating activity in from PDFs when the bank no longer offers downloads for them.
Card statements convert the same way. Remember the ending balance goes in as a negative.
No. CosmoLex brings bank activity in two ways: a bank feed, or a file you upload under Action > Import Transactions. The file import is documented for QBO, Excel and CSV, and CosmoLex notes that an .ofx download can be renamed to .qbo and imported. A PDF e-statement, or a scan of a paper statement, is not on that list.
That is rarely a problem for last month, because most banks let you download a QBO file for recent activity. It becomes a problem when you need older months. Plenty of banks only keep downloadable transaction files for a limited window, while the PDF statements go back years. A firm moving its trust books into CosmoLex, a new bookkeeper catching up a year of IOLTA activity, or an attorney whose client sent a stack of statements for a matter all end up holding PDFs. Converting those PDFs is the step that replaces typing.
All three land in the same review screen, where you add or match each transaction. What differs is which plan you need, how far back you can reach, and how much setup the file takes.
| Question | Bank feed | QBO file | Excel or CSV file |
|---|---|---|---|
| CosmoLex plan that includes it | Pro (the pricing table lists bank feeds on Pro only) | Core and Pro, through Import Transactions | Core and Pro, through Import Transactions |
| Where it comes from | A connected bank account | Your bank download, or a converted statement | A converted statement or an old accounting program |
| Setup on import | None after the connection | None: the columns are fixed | Tick File has header, then map columns on the Raw Data Mapping screen |
| How far back | Only what the bank shares from the connection date | Whatever the file covers | Whatever the file covers |
| Works from a PDF statement | No | Yes, once converted to QBO | Yes, once converted to Excel or CSV |
Plan availability from the CosmoLex pricing page and import behavior from CosmoLex Support articles, checked September 2026.
If your firm is on Core, there is no bank feed to lean on, so every account comes in by file every month. That makes clean files the whole game. QBO is the format CosmoLex calls the easiest, and matching works on it the same way as on feed data. Excel or CSV works too, with one extra mapping step the first time.
Go to Accounting, then Bank, open the bank account with Details, and choose Action > Import Transactions. Upload the QBO, Excel or CSV file. For Excel and CSV, tick File has header so the first row is read as column names, then map the columns. The Raw Data Mapping screen shows the rows for review only: nothing is imported until you add or match it.
Each row gets a status. A green Matched icon means CosmoLex found exactly one book transaction with the same date and amount, or for a check, the same check number and amount. A gray Matched icon means more than one candidate, so you pick the right one. A gray Add icon means there is no match and the row will be created when you add it. You can work row by row or tick a batch and use Add/Confirm Match, then clear out anything left over with Remove Transactions.
The account type changes what you fill in. In a trust account, every added transaction needs a matter from the Matter drop-down, because each dollar belongs to a client ledger. In an operating account you choose a chart of accounts line from the Account drop-down instead. Mapping Rules (Action > Mapping Rules) can rename statement payees and remember accounts using Equals To, Contains or Starts With, which saves a lot of clicks on recurring items like rent, payroll and card processor deposits.
One row per transaction, dates in a single format, and amounts that CosmoLex can read without guessing. The converter gives you exactly that from the PDF, and the table shows how the columns line up with what you map.
| Converted column | What it holds | Why it matters in CosmoLex |
|---|---|---|
| Date | The posting date printed on the statement | Matching on deposits uses date plus amount |
| Description | The full payee or memo text | Becomes the Statement Payee, which Mapping Rules act on |
| Check number | The number the bank printed, where there is one | Check matching uses check number plus amount |
| Debit and credit | Money out and money in, in separate columns | No sign guessing: deposits and disbursements stay apart |
| Balance | The running balance after each row | Lets you prove the period ties to the ending balance before you import |
Column output from BankXLSX. Matching rules as described in the CosmoLex Support article on managing imported transactions.
Tie the file out before you upload it. The opening balance plus deposits minus withdrawals should equal the ending balance printed on the statement. If it does, the import can only be as wrong as your coding, not your typing.
Open Accounting > Bank, select the account, then Details > Reconciliation. Click Add, pick the statement end date and enter the bank ending balance. For a credit card account the ending balance goes in as a negative, so a $1,000 balance is entered as -1,000. You can tick the option to automatically reconcile transactions with a Matched status, which is where an imported file pays off.
Then check the uncleared deposits and payments that appear on the statement, click Clear Selected, and watch the difference. When it reaches $0.00, click Reconcile. If it does not, fix the book side with Add, Edit, Delete or Void, and record genuine bank mistakes as bank errors rather than pushing them into a client ledger. The Reconciliation Report and the Three Way Reconciliation Report are both under Reports.
A three-way reconciliation ties the bank statement, the trust journal and the sum of the client ledgers. The ABA Model Rules for Client Trust Account Records set quarterly as the minimum and call monthly the better practice, and many states, Florida among them, require monthly. Every hand-keyed trust line is a chance to post a transposed amount to the wrong matter, and on a trust account that is a compliance problem, not just a bookkeeping one. More on the cadence in when trust accounts must be reconciled, and the full tie-out is walked through on the three-way trust account reconciliation page.
No. On the current CosmoLex pricing page, bank feeds and the general ledger with payables are marked for Pro only. Core includes trust accounting, compliance reporting and bank reconciliation. Launch includes trust accounting and ledgers but not bank reconciliation. The trial includes the full product with a single bank feed connection.
| CosmoLex plan | Monthly price per user | Bank reconciliation | Bank feeds | General ledger and payables |
|---|---|---|---|---|
| Launch | $49 | No | No | No |
| Core | $99 | Yes | No | No |
| Pro | $129 | Yes | Yes | Yes |
Monthly list prices and feature marks from cosmolex.com/pricing, checked September 2026. CosmoLex says yearly billing saves $120 per user per year.
So a Core firm faces a simple choice: pay $30 more per user each month for Pro and the feed, or import files. For a two-attorney firm that is $720 a year before any add-ons. Even on Pro, a feed only reaches back to when you connected it, so migration and catch-up months still come from statements.
BankXLSX is priced by pages. Starter is $49 a month, or $24 a month billed yearly, for 2,500 Base pages with unlimited users, and it exports Excel and CSV. Plus is $149 a month, or $74 billed yearly, and adds QBO export, bulk upload of up to 50 files, saved templates and category tagging. A new account gets a one-time 15 page demo with no credit card, so you can convert one trust statement and run it through Import Transactions before paying.
Firms that also keep clients or a second entity in Clio will find the same routine on the Clio bank statement converter page, and the bank statement converter for law firms covers statements you receive as evidence in a matter rather than your own books.
No. CosmoLex imports bank transactions from QBO, Excel and CSV files under Action > Import Transactions, and an .ofx file can be renamed to .qbo. A PDF statement has to be converted to one of those formats first. BankXLSX turns the PDF into Excel or CSV on every plan, and into QBO on Plus.
CosmoLex documents QBO, Excel and CSV for Import Transactions, and says QBO is the easiest because almost every bank offers it. If your bank gives you an .ofx file, rename the extension to .qbo and import it. Excel and CSV files need the File has header box and a column mapping.
No. The CosmoLex pricing table lists bank feeds on the Pro plan only. Core includes trust accounting and bank reconciliation, so Core firms bring bank activity in by importing a QBO, Excel or CSV file for each account every month.
A deposit shows a green Matched icon when exactly one book transaction has the same date and amount. A check matches on the same check number and amount. A gray Matched icon means several candidates, and a gray Add icon means no match, so the row is created when you add it.
Yes. When you add an imported transaction to a trust account, CosmoLex asks for the matter from the Matter drop-down so the money lands on the right client ledger. Operating account transactions take a chart of accounts line from the Account drop-down instead.
Enter it as a negative number. CosmoLex Support gives the example of a $1,000 credit card statement balance entered as -1,000. Bank account ending balances are entered as positive numbers.
The CosmoLex pricing page lists Launch at $49, Core at $99 and Pro at $129 per user per month on monthly billing, and says yearly billing saves $120 per user per year. Bank reconciliation starts on Core, and bank feeds are on Pro.
QBO is less work on import because the columns are fixed, and it is available on the BankXLSX Plus plan. Excel or CSV works on every plan and needs a one-time column mapping on the Raw Data Mapping screen. If an account will not accept a QBO file, the Excel route goes through the same screen.
Tie bank, journal and client ledgers.
The same workflow for Clio firms.
Statements as evidence in a matter.
Rebuild months a feed cannot reach.
Convert a year of statements at once.
Cancel anytime from your account settings · refund policy
Get started converting bank statements to spreadsheets.
USD
per month
per month
$288 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
per month
$888 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
Try it once, free: sign up and convert up to 15 pages (5 per statement) with no credit card. The demo does not renew.
