Upload a year of the ward's checking and savings statements and download one Excel workbook with every deposit and payment in its own row, ready to sort into receipts and disbursements for the annual accounting. Built for professional guardians, conservators, fiduciaries and the elder law paralegals who prepare their filings.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940, BAI2, NACHA, camt.053, CSV
Uploading...
A guardianship or conservatorship accounting lists every receipt and every disbursement for the period, then shows that the opening balance plus receipts minus disbursements equals the property on hand at the end. That detail sits in the ward's monthly bank statements. BankXLSX converts those PDFs, including scans, into Excel rows with date, description, amount and running balance, and checks each statement against its printed ending balance, so you sort rows into the court's schedules instead of typing them. Starter is $49 a month for 800 pages.
The court does not accept a summary. It wants each transaction, sourced, and a closing figure that agrees with the bank.
Social Security, pension, facility payments, pharmacy, premiums and the allowance all appear one by one on the schedules, twelve months of them per ward.
Checking, savings, a burial account and sometimes a brokerage sweep, each with its own statement layout and its own cutoff dates.
Moving $500 from savings to checking is neither a receipt nor a disbursement. Typed by hand, it often lands on both schedules.
Reviewers check the closing cash against the statements to the cent, and the next year's opening figure must match it.
For the first accounting you may be working from paper the ward kept before your appointment, scanned at a branch or photographed.
A guardian with a caseload of wards often faces many accountings in the same season, such as Florida's 1 April due date for calendar year accountings.
Clean transaction rows from each statement, in bank order, with proof that no page went missing.
Date, description, amount and running balance in separate Excel columns, so a filter splits receipts from disbursements in seconds.
Opening balance plus credits minus debits is tested against the printed ending balance, which flags a skipped page before the reviewer does.
On Plus, upload up to 50 PDFs at once, enough for two or three accounts across a twelve month period.
Plus categorizes transactions and normalizes payee names, so every facility payment or pharmacy charge groups together for the schedule subtotal.
AI visual OCR reads scanned and photographed statements in PDF, JPG, PNG and HEIC, useful for the records from before your appointment.
256-bit encryption in transit, no bank login requested, and uploads you can delete when the accounting is filed.
The same routine works for an annual, biennial or final accounting, whatever form your county uses.
Upload every statement for each account in the accounting period and download one Excel workbook. Each statement keeps its period and balance check.
Tip: Include the statement that covers the start date so the opening balance is on file.
Add a Schedule column and tag rows as receipt, disbursement or internal transfer. Transfers stay out of both schedules.
Tip: Keep the transfer rows tagged rather than deleted, the reviewer may ask.
Subtotal each schedule with a pivot table and carry the figures to the court form or your fiduciary software.
Tip: Test opening plus receipts minus disbursements against the closing statements before filing.
People who answer to a probate or guardianship court for someone else's money, usually across more than one ward.
Run annual accountings for a caseload of wards without retyping hundreds of statement lines each spring.
Prepare the schedules for the attorney to review, with the statement rows behind every subtotal.
Produce the receipts and disbursements detail that supports a conservatorship accounting.
Get a first accounting right when the ward's records come as a box of paper statements.
The names of the forms change by state, but the structure barely does. You report the property on hand at the start of the period, list every receipt, list every disbursement, and show the property on hand at the end. Florida puts it in statute: under section 744.3678 each guardian of the property files an annual accounting with a full and correct account of the receipts and disbursements of the ward's property, plus a statement of the property on hand at the end of the period. California's Rule of Court 7.575 requires the account statements named in Probate Code section 2620(c) with each accounting, and local courts reject copies when they want originals lodged.
So the bank statements do two jobs. They are the evidence the court reviews, and they are the raw material for the schedules. BankXLSX handles the second job: it reads the statements into a spreadsheet so the schedules come from the bank's own figures rather than a retyped version of them. You still file or lodge the statements themselves as your court requires.
A professional guardian manages a ward with a checking account and a savings account. Twelve monthly statements per account, four pages each, is 96 pages. Converted to Excel and tagged, the year looks like this.
| Line | Amount | Source rows |
|---|---|---|
| Cash on hand at start, both accounts | $38,412.17 | Opening balances on the first statements |
| Social Security, 12 deposits of $1,927.00 | $23,124.00 | Receipts |
| Pension, 12 deposits of $812.40 | $9,748.80 | Receipts |
| Savings interest | $186.55 | Receipts |
| Premium refund from insurer | $214.00 | Receipts |
| Total receipts | $33,273.35 | Pivot subtotal |
| Care facility, 12 payments of $2,450.00 | $29,400.00 | Disbursements |
| Insurance premiums, 12 of $189.00 | $2,268.00 | Disbursements |
| Guardian fee as approved by the court | $1,800.00 | Disbursements |
| Pharmacy, 31 charges | $1,236.88 | Disbursements |
| Personal needs allowance, 12 of $100.00 | $1,200.00 | Disbursements |
| Total disbursements | $35,904.88 | Pivot subtotal |
| Savings to checking transfers, 4 of $1,500.00 | $6,000.00 | Tagged transfer, on neither schedule |
| Cash on hand at end | $35,780.64 | Must equal the closing statements |
The check is one line: $38,412.17 plus $33,273.35 minus $35,904.88 is $35,780.64. If the two closing statements add up to that figure, the accounting ties. If they do not, the gap is almost always a transfer tagged as a receipt, a missing month, or a check that cleared after the period end. The transfer row is the one hand-typed accountings get wrong most often, because it appears as a credit on one statement and a debit on the other. Count it on both schedules and receipts and disbursements are each overstated by $6,000 while the totals still look plausible.
Put every converted row in one sheet with columns for Date, Description, Amount (credits positive, debits negative), Account and Schedule. Then:
=SUMIFS(C:C,E:E,"Receipt")=-SUMIFS(C:C,E:E,"Disbursement")=SUMIFS(C:C,E:E,"Transfer") should return 0.00 when both sides of every transfer are in the fileA pivot of the Disbursement rows by payee gives the line items most schedules ask for. Plus plan categorization groups payee spellings such as "SUNRISE SR LIV ACH" and "SUNRISE SENIOR LIVING" into one payee before you pivot, see categorizing transactions from a bank statement.
| Option | What it does | Cost | Best for |
|---|---|---|---|
| Typing from the PDFs | Every line keyed by hand into the form or a spreadsheet | Hours per ward | One ward with a few transactions a month |
| Bank feed in bookkeeping software | Pulls transactions once an account is connected | Software subscription | Accounts you control online from day one, not older paper statements |
| State or court systems | Some states run their own filing tool, such as Minnesota's MyMnConservator | Set by the state | Filing in that state, you still need the transactions entered |
| Fiduciary accounting suites | Produce court format reports and principal and income splits | Vendor quote or license | Trust departments and firms filing many formal accounts |
| BankXLSX | Converts statement PDFs and scans to checked Excel rows, you tag the schedules | Starter $49 a month for 800 pages, Plus $149 for 1,920 pages with batch upload | Guardians and paralegals preparing several accountings from statements |
BankXLSX is not a court form filler and does not decide what your state counts as a receipt. It removes the typing and gives you a balance check, which is where most of the hours and most of the errors sit. It also feeds whatever comes next: export CSV into a fiduciary suite, or keep the workbook as the support file behind a paper form.
The ward in the example used 96 pages for a year. A guardian with 15 similar wards converts about 1,440 pages a year. Spread evenly that is 120 pages a month, well inside Starter at $49 a month (or $24 a month billed yearly) with its 800 page allowance. If most accountings fall due in the same quarter, a peak month of 600 to 700 pages still fits Starter, and Plus at $149 for 1,920 pages adds batch upload of up to 50 PDFs and categorization. The batch conversion page shows how a full year per account goes up in one upload.
When the ward dies and the guardianship turns into an estate, the same rows carry into the probate accounting from estate bank statements. For eligibility reviews that ask for the same months of records, see the Medicaid bank statement converter, and for scanned paper records the OCR bank statement converter covers what to expect from older statements.
The property on hand at the start of the period, a list of every receipt, a list of every disbursement, and the property on hand at the end. Opening balance plus receipts minus disbursements must equal the closing balance. Courts also ask for supporting bank statements, filed, lodged or kept for inspection depending on the state.
Often yes, but the rule is local. California requires the account statements named in Probate Code 2620(c) with each accounting, and many counties want originals lodged. Florida Rule 5.696 asks for year-end statements but has them filed only if the court orders it. Check your county's local rules before filing.
Most states require an annual accounting, and some allow biennial accountings after the first one. Florida guardians of the property file each year, due 1 April for calendar year accountings under Rule 5.695 unless the court sets a fiscal year. A final accounting is due when the guardianship ends.
Many combine three tools: a way to get transactions out of bank statements, a spreadsheet or bookkeeping file to sort them, and the court form or a fiduciary suite for the filing. BankXLSX covers the first step, converting statement PDFs and scans into checked Excel rows so nothing is retyped.
No. BankXLSX converts the statements into Excel or CSV rows with balances checked, and on Plus categorizes payees. You tag each row as receipt, disbursement or transfer and carry the subtotals to your state's form or fiduciary software. Your court's rules decide what goes on each schedule.
Yes. Scanned and photographed statements are read with AI visual OCR and come out in the same layout as digital PDFs. For a first accounting built from paper the ward kept, check each statement's balance line in the export before relying on the totals, as you would with any typed record.
A ward with two accounts and four page statements uses about 96 pages a year. Fifteen such wards is about 1,440 pages a year, which fits Starter at $49 a month for 800 pages even in a busy month. Plus at $149 covers 1,920 pages with batch upload and categorization.
Estate receipts and disbursements after death.
Look-back periods built from statements.
A year of statements in one upload.
Scanned and photographed statements.
Cancel anytime from your account settings · refund policy
Get started converting bank statements to spreadsheets.
USD
per month
per month
$288 charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | 800 pages |
| Pro AI Best accuracy | 80 pages |
Scale statement conversion across your team with automation.
USD
per month
per month
$888 charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | 1,920 pages |
| Pro AI Best accuracy | 192 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
One shared monthly allowance, up to half of it per day
| 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.