A bulk bank statement converter takes a whole folder of client statements in one upload, works out which client and account each file belongs to, converts them together, and returns the results grouped by client. Files that cannot be read or fail the balance check are flagged, so the rest of the batch still finishes.
How does a bulk converter sort a mixed folder?
A bulk converter sorts a mixed folder by reading each file rather than trusting its name. It looks at the bank, the account number and the statement period printed on the statement, then groups the file with the client and account it matches. Files you named carefully help, but the sorting should not depend on them.
Real folders are messy. A month-end download folder holds files called "statement.pdf", "Statement (3).pdf", a scan from a phone named after a date, and a few forwarded attachments. If sorting relied on names, you would rename everything first, which is the work you wanted to avoid.
What the sorting decides
For each file, the converter has to settle three things, and you should check a fourth yourself:
- Which client the statement belongs to. AutoBankConvert matches each file to its client when you upload a month of PDFs or forward them to your firm's inbox.
- Which account within that client, since one client may have checking, savings and a card.
- Which period the statement covers, so March and April for the same account stay separate.
- Whether it is a repeat, which you should check yourself, because the same statement can arrive twice from a client and a forwarded email.
A mistake in any of these puts transactions in the wrong books, so check the grouping before you trust the numbers. After the first run for a new client, open the grouped result and confirm each account shows the periods you expected and no others.
Files that belong to no client yet
New statements from a client you have not set up will not match anything. A good bulk tool shows these as unmatched, rather than guessing. Add the client, then run the file again. Guessing is the dangerous option, because a statement filed under the wrong client looks fine until someone reads the account number.
Names still help people, even when the tool does not need them. A consistent scheme such as client, bank, last four digits and month makes a folder searchable by hand. The bank statement file naming convention post lays one out.
Bulk upload limits on pages, files and clients
Bulk upload limits come in three kinds: how much you can send in one batch, how much you can convert in a month, and how many clients you can hold. The monthly and client limits are the ones that decide which plan fits.
AutoBankConvert states its limits on the homepage as pages a month and clients:
| Plan | Pages a month | Clients |
|---|---|---|
| Solo | 500 | Up to 10 |
| Practice | 2,000 | Up to 50 |
| Firm | 6,000 | Unlimited |
Those are early-access plans, and the homepage says pricing may change before general release. The homepage does not give a per-file or per-batch cap, so ask about that directly if your folders are large, and do not assume one from another tool.
Count pages, not files
Limits measured in pages punish long statements and reward short ones. A savings statement with three transactions may be one page. A busy business checking statement can run past ten. To size a plan, count the pages in last month's folder, not the files. The quick method is to add up the page counts of your last month-end pile and compare the total with the plan's monthly figure, leaving headroom for catch-up months.
Catch-up work is the case that breaks estimates. A client who is six months behind brings six months of pages at once. The catch up bookkeeping plan covers how to batch that work so a backlog does not use a whole month's allowance in one go.
Other limits worth asking about
- Whether a password-protected PDF can be converted or must be unlocked first.
- Whether a very large file is accepted whole or must be split.
- Whether duplicates count against the page allowance.
None of these are answered by the product pages this post draws on, so treat them as questions for the vendor, not as facts.
What happens to failed files in a bulk run?
In a bulk run, a failed file is set aside and reported while the rest of the batch continues. A failure means the converter could not read the file, or the statement did not pass its balance check. Nothing from that file reaches your export until you decide what to do about it.
This is the behaviour that makes bulk conversion safe. AutoBankConvert marks a statement as done only when the opening balance plus the transactions equals the closing balance. A statement that fails is flagged instead of exported. Without that rule, a bulk run would turn one bad file into a hidden error inside an otherwise good export.
Reading the flagged list
Treat the flagged list as a short to-do list. For each flagged file, note the reason, then pick the fix:
- Poor scan or photo: ask the client for the bank's downloaded PDF.
- Missing pages: the statement is incomplete. Ask for the full file.
- Password lock: unlock it with the client's help and upload it again.
- Odd layout: some layouts are not read correctly. Check it by hand and report it.
- Real balance gap: a line was missed or doubled. Find the page where the gap starts.
The reasons a file may be flagged, and how to get each type converted, are covered in the post on why bank statements get flagged as unsupported. That post is the place to go when the same file keeps failing.
Do not export around a flag
It is tempting, near a deadline, to export the converted files and leave the flagged ones for later. That is fine if you note which ones are missing. It is a problem if you forget the flagged file and a month goes unposted. Keep a simple rule: a client's month is not closed until every statement for that client is converted or a person has handled it.
Bulk converter exports per client or per batch
A bulk converter can export one file per client or one file for the whole batch, and you will want both at different times. Per-client exports go into each client's books. A batch export is for review, for a summary across clients, or for archiving a month's run.
AutoBankConvert offers exports per client or per batch, in the format each client's books already use, with QuickBooks and Xero files named on the homepage. Pick the export by what happens next:
- Posting to client books: export per client. Each file contains one client's transactions only, so nothing crosses between companies.
- Reviewing a run: export the batch, filter by client, and look for odd amounts or uncategorized lines.
- Filing for audit trail: keep the batch export together with the original statements for that month.
Why per-client exports are the default for posting
Mixing clients in one import file is how books get contaminated. Accounting systems import to one company at a time. A batch file containing eight clients cannot be imported as is, and splitting it again by hand reintroduces the error you wanted to remove. Client workspaces help here: each client keeps their own accounts, rules and history, so a per-client export comes out already separated.
A note on spreadsheets
People searching for a bulk PDF to Excel converter online often want everything in one workbook. That is a different job from posting to books, and it has its own layout questions: one sheet or many, which columns identify the account, and how to avoid duplicates. Those are the subject of extracting data from multiple PDF files to Excel. A converter that handles clients properly can still give you the combined workbook when you need it.
A worked example: sixty files for eight clients
Here is an example run so you know what to expect. The numbers are made up for illustration and are not results from real clients.
A bookkeeper drops a month-end folder with sixty statement files covering eight clients and a mix of banks. Some are digital, some are scans. She uploads the whole folder once. The result table looks like this:
| Client | Files in | Converted | Flagged | Exported |
|---|---|---|---|---|
| Example Bakery LLC | 9 | 9 | 0 | 9 |
| Example Dental Group | 8 | 7 | 1 | 7 |
| Example Landscaping | 7 | 7 | 0 | 7 |
| Example Consulting | 6 | 6 | 0 | 6 |
| Example Auto Repair | 10 | 8 | 2 | 8 |
| Example Yoga Studio | 5 | 5 | 0 | 5 |
| Example Design Co | 9 | 8 | 1 | 8 |
| Example Property Mgmt | 6 | 6 | 0 | 6 |
| Total | 60 | 56 | 4 | 56 |
Four files are flagged. Two are phone photos of paper statements, one is missing its last page, and one has a balance gap of a single debit. She asks the affected clients for better files, then runs those four again. Fifty-six statements were already exported per client, so most of the folder never waited on the four.
What to check after a run
Before you post, spend five minutes on the result table:
- The total in equals converted plus flagged. If it does not, a file went missing.
- Each client has the number of files you expect for that month, one per account.
- The flagged list matches what you already know about difficult clients.
- A sample client's export opens cleanly and the totals match one statement.
Then the categorization step takes over. Transactions the rules are unsure about go to a review queue with a suggested category, and approving one teaches the client's rules for next month.
When a bulk converter is overkill
A bulk converter is overkill when the folder is small enough that sorting and checking it by hand takes less time than learning the tool. If you handle a handful of statements a month for one or two clients, a single file conversion and a spreadsheet will do, and you avoid a subscription.
Signs you are in that position:
- You convert fewer than ten statements a month.
- All files come from one or two banks that you know well.
- You post to one set of books and never mix clients.
- Nobody on the team needs to see a review queue.
The reverse signs point to bulk: more than a few clients, several banks, scanned files in the mix, a monthly deadline, or a backlog. The pressure is rarely the conversion of one file. It is the repetition across files and the risk of a missed one.
A middle path
You do not have to decide forever. One way to start is to run only your busiest month-end through a bulk tool, keeping the small clients manual, and move more clients over as the saving shows. The mixed banks guide helps when the variety of banks is what makes the folder hard. If you want to try a folder of your own, request a spot at Get started, since AutoBankConvert is onboarding bookkeeping firms in small groups.