Upload a year of the trust's checking, money market and brokerage statements and download one Excel workbook with every dividend, rent deposit, bill and distribution in its own row, ready to split into income and principal for the annual account to beneficiaries. Built for professional and successor trustees, private fiduciaries, and the CPAs and estate planning paralegals who prepare their accountings.
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 trust accounting shows the assets at the start of the period, every receipt and disbursement split between income and principal, and the assets at the end, and the figures must agree with the bank and brokerage statements. BankXLSX converts those statement PDFs, including scans, into Excel rows with date, description, amount and running balance, checked against each printed ending balance, so the trustee or the trustee's CPA tags rows instead of typing them. Starter is $49 a month for 800 pages.
Beneficiaries are entitled to see where the money went, and a summary with round numbers invites questions or a petition.
Dividends and rent are income, sale proceeds are principal, and a trust with an income beneficiary and a remainder beneficiary needs both columns right.
A checking account for bills, a money market for reserves and a brokerage account for the portfolio, each with its own statement format.
Sweeping $10,000 from brokerage to checking is neither a receipt nor a disbursement, yet typed by hand it often shows up as both.
Ending assets must agree with the closing statements to the cent, and become the opening figures of next year's account.
After a settlor dies or steps down, the new trustee often starts from boxes of mailed statements and scans, not a clean ledger.
A professional trustee or CPA firm prepares a stack of accountings in the same weeks as fiduciary tax returns.
Clean transaction rows from each statement, in bank order, with proof that no page went missing.
Date, description, amount and running balance in their own Excel columns, so one filter separates receipts from disbursements.
Opening balance plus credits minus debits is tested against the printed ending balance, which flags a skipped page before a beneficiary does.
On Plus, upload up to 50 PDFs at once, enough for checking, money market and brokerage across a twelve month period.
Plus categorizes transactions and normalizes payee names, so every property tax, insurance and distribution payment subtotals cleanly.
AI visual OCR reads scanned and photographed statements in PDF, JPG, PNG and HEIC, useful for a successor trustee's first account.
256-bit encryption in transit, no bank login requested, and uploads you can delete once the account is delivered.
The routine is the same for an annual account, an account on a change of trustee, and a final account at termination.
Upload every statement for each trust account in the period and download one Excel workbook. Each statement keeps its dates and balance check.
Tip: Include the statement covering the start date so opening balances are on file.
Add a Class column and tag each row as income receipt, principal receipt, income disbursement, principal disbursement or transfer.
Tip: Follow the trust instrument first, then your state's principal and income act.
Subtotal each class with a pivot table and carry the figures into the account, your fiduciary software or the CPA's workpapers.
Tip: Test opening plus receipts minus disbursements against the closing statements before sending.
People who owe beneficiaries an account of someone else's money, often across many trusts.
Run annual accounts for a book of trusts without retyping hundreds of statement lines each year.
Get statement rows into the workpapers that feed both the account and the Form 1041.
Prepare the schedules for the attorney to review, with the statement row behind every subtotal.
Produce a first account that holds up when a sibling beneficiary asks to see it.
States word it differently, but the content is close everywhere the Uniform Trust Code or a similar statute applies. California is a clear example. Probate Code section 16062 requires a trustee to account at least annually, at the termination of the trust, and on a change of trustee, to each beneficiary to whom income or principal is required or authorized to be distributed. Section 16063 lists what the account contains, starting with a statement of receipts and disbursements of principal and income for the period and a statement of the assets and liabilities at its end, plus the trustee's compensation and the agents the trustee hired.
Every receipt and every disbursement in that list started life as a line on a bank or brokerage statement. That is the part BankXLSX does: it reads the statements into a spreadsheet so the schedules come from the institution's own numbers instead of a retyped copy. Deciding whether an item is income or principal stays with you, guided by the trust instrument and your state's principal and income rules.
A successor trustee administers a family trust with a checking account for a rental property and a brokerage account. Twelve statements per account at five pages each is 120 pages for the year. Converted and tagged, the account looks like this.
| Line | Income | Principal |
|---|---|---|
| Cash at start, both accounts | $27,840.55 | |
| Rent, 12 deposits of $1,800.00 | $21,600.00 | |
| Dividends | $4,120.33 | |
| Money market and bank interest | $612.08 | |
| Proceeds from sale of shares | $48,500.00 | |
| Total receipts | $26,332.41 | $48,500.00 |
| Distributions to the income beneficiary | $16,000.00 | |
| Property tax, two installments | $5,840.00 | |
| Repairs, 9 payments | $2,315.40 | |
| Property insurance | $1,920.00 | |
| Trustee fee | $3,000.00 | |
| CPA fee for the fiduciary return | $1,450.00 | |
| Total disbursements | $26,075.40 | $4,450.00 |
| Brokerage to checking transfers, 2 of $5,000.00 | Tagged transfer | On neither schedule |
| Cash at end | $72,147.56 |
The tie out is one line: $27,840.55 plus $74,832.41 of total receipts minus $30,525.40 of total disbursements is $72,147.56, and the two closing statements must add up to that figure. The fee allocation in the example follows a trust instrument that charges both fees to principal; under many principal and income acts part of the trustee fee would be charged to income instead, which moves the split but not the ending cash. The $10,000 of transfers is where hand typed accounts go wrong most often. It is a credit on the checking statement and a debit on the brokerage statement, and counted on both schedules it overstates receipts and disbursements by $10,000 each while the ending balance still looks right.
Put every converted row in one sheet with columns for Date, Description, Amount (credits positive, debits negative), Account and Class. Then:
=SUMIFS(C:C,E:E,"Income receipt")=-SUMIFS(C:C,E:E,"Principal disbursement")=SUMIFS(C:C,E:E,"Transfer") should return 0.00 when both sides of every transfer are in the fileA pivot of disbursement rows by payee produces the line items beneficiaries ask about. On Plus, categorization groups spellings such as "COUNTY TAX COLL" and "COUNTY TAX COLLECTOR ONLINE" into one payee first, see categorizing transactions from a bank statement. Brokerage statements convert the same way, the brokerage statement to Excel page shows the dividend and trade rows you get.
| Option | What it does | Cost | Best for |
|---|---|---|---|
| Typing from the statements | Every line keyed into a spreadsheet by hand | Hours per trust | One small trust with few transactions |
| Trust Accountant (Delta Data) | Fiduciary portfolio accounting for trusts, estates and guardianships | Listed on Capterra from $100 per user a month | Trustees managing portfolios across many trusts |
| Estateably or Onesource Fiduciary Accounting | Trust administration and court or beneficiary format reports | Vendor quote | Law firms and trust departments filing formal accounts |
| QuickBooks or Xero with a trust company file | General ledger with bank feeds | Subscription | Trusts with accounts connected online from day one |
| BankXLSX | Converts statement PDFs and scans to checked Excel rows you tag into schedules | Starter $49 a month for 800 pages, Plus $149 for 1,920 pages with batch upload | Trustees and CPAs building accounts from statements, alone or feeding a fiduciary suite |
A fiduciary suite does principal and income bookkeeping and produces formatted reports, and for a trust company it is the right core system. It still needs transactions in it, and for trusts that arrive as a stack of statements, or for a successor trustee who will only ever handle one or two trusts, a converter plus a spreadsheet is the faster and cheaper path. The two also work together: export CSV from BankXLSX and import it into the suite instead of keying it.
The trust in the example used 120 pages for the year. A CPA firm preparing 20 similar accountings converts about 2,400 pages a year. If they cluster in the first quarter alongside fiduciary returns, a peak month of 1,200 pages fits Plus at $149 for 1,920 pages, with batch upload of up to 50 PDFs. Spread across the year, Starter at $49 a month (or $24 billed yearly) covers 800 pages a month. The batch conversion page shows a full year per account going up in one upload.
When a trust funds from a probate estate, the opening figures come from the probate accounting built from estate bank statements. If the beneficiary was under a court appointed guardian before the trust took over, the guardianship accounting from bank statements uses the same routine, and the forensic accounting bank statement analysis page covers tracing when a beneficiary disputes the figures.
In most states, yes. California Probate Code 16062 requires an account at least annually, at termination and on a change of trustee, to each beneficiary entitled to income or principal. Uniform Trust Code states require at least annual reports to qualified beneficiaries. Trust terms and beneficiary waivers can change the details.
Receipts and disbursements of both principal and income for the period, the assets and liabilities at the end, the trustee's compensation, and the agents the trustee hired, as California Probate Code 16063 lists. Opening assets plus receipts minus disbursements must equal ending assets, supported by the bank and brokerage statements.
Trust companies use fiduciary suites such as Trust Accountant or Onesource. Individual and successor trustees and their CPAs usually combine a statement converter, a spreadsheet and the account format their attorney uses. BankXLSX covers the first step, turning statement PDFs into checked Excel rows so nothing is retyped.
No. BankXLSX converts statements into Excel or CSV rows with balances checked, and on Plus categorizes payees. Whether a receipt is income or principal depends on the trust instrument and your state's principal and income act, so you tag that column and the formulas subtotal it.
Yes. Brokerage, money market and bank statements all convert to rows with date, description and amount, so dividends, interest, trades and transfers land in the same workbook as the checking account. Check each converted statement against its printed totals before relying on the schedule.
Yes. Scanned and photographed statements are read with AI visual OCR and come out in the same Excel layout as digital PDFs. For a first account built from paper the settlor kept, confirm each statement's balance line in the export before using the totals.
A trust with two accounts and five page statements uses about 120 pages a year. Twenty such trusts is about 2,400 pages a year. Starter at $49 a month covers 800 pages, and Plus at $149 covers 1,920 pages with batch upload, which suits a busy first quarter.
Estate receipts and disbursements after death.
Court accountings for a ward's accounts.
Dividends and trades as Excel rows.
A year of statements in one upload.
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.