Trust Accounting Software for Trustees and Fiduciary Accounting from Bank Statements

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.

One-time 15 page demo, no credit card
Balance checked on every statement
Starter $49 a month for 800 pages

PDF, JPG, PNG, BMP, HEIC, TIFF, MT940, BAI2, NACHA, camt.053, CSV

Upload your bank statement

Extract:

How trustees build the beneficiary accounting from statements

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.

Why the Annual Trust Account Takes So Long

Beneficiaries are entitled to see where the money went, and a summary with round numbers invites questions or a petition.

Income and Principal Kept Apart

Dividends and rent are income, sale proceeds are principal, and a trust with an income beneficiary and a remainder beneficiary needs both columns right.

Several Accounts per Trust

A checking account for bills, a money market for reserves and a brokerage account for the portfolio, each with its own statement format.

Transfers Inflate Both Sides

Sweeping $10,000 from brokerage to checking is neither a receipt nor a disbursement, yet typed by hand it often shows up as both.

Every Figure Must Tie

Ending assets must agree with the closing statements to the cent, and become the opening figures of next year's account.

Successor Trustees Inherit Paper

After a settlor dies or steps down, the new trustee often starts from boxes of mailed statements and scans, not a clean ledger.

Many Trusts, One Season

A professional trustee or CPA firm prepares a stack of accountings in the same weeks as fiduciary tax returns.

What BankXLSX Gives a Trust Accounting

Clean transaction rows from each statement, in bank order, with proof that no page went missing.

Every Transaction as a Row

Date, description, amount and running balance in their own Excel columns, so one filter separates receipts from disbursements.

Balance Check per Statement

Opening balance plus credits minus debits is tested against the printed ending balance, which flags a skipped page before a beneficiary does.

All Accounts in One Batch

On Plus, upload up to 50 PDFs at once, enough for checking, money market and brokerage across a twelve month period.

Payees Grouped

Plus categorizes transactions and normalizes payee names, so every property tax, insurance and distribution payment subtotals cleanly.

Scans and Photos Read

AI visual OCR reads scanned and photographed statements in PDF, JPG, PNG and HEIC, useful for a successor trustee's first account.

Trust Data Kept Private

256-bit encryption in transit, no bank login requested, and uploads you can delete once the account is delivered.

From Statement PDFs to a Beneficiary Account in 3 Steps

The routine is the same for an annual account, an account on a change of trustee, and a final account at termination.

1

Convert the Period

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.

2

Tag Income, Principal and Transfers

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.

3

Build the Schedules

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.

Who Prepares Trust Accountings with BankXLSX

People who owe beneficiaries an account of someone else's money, often across many trusts.

Professional Trustees

Run annual accounts for a book of trusts without retyping hundreds of statement lines each year.

CPAs and Fiduciary Accountants

Get statement rows into the workpapers that feed both the account and the Form 1041.

Estate Planning Paralegals

Prepare the schedules for the attorney to review, with the statement row behind every subtotal.

Successor and Family Trustees

Produce a first account that holds up when a sibling beneficiary asks to see it.

Transaction Types We Handle

Dividends and interest
Rent deposits
Sale proceeds
Property tax and insurance
Distributions to beneficiaries
Trustee and CPA fees
Transfers between trust accounts
Repairs and maintenance

What a trustee's account has to show

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.

Worked example of a twelve month trust account

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.

LineIncomePrincipal
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.00Tagged transferOn 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.

The Excel formulas behind the schedules

Put every converted row in one sheet with columns for Date, Description, Amount (credits positive, debits negative), Account and Class. Then:

  • Income receipts: =SUMIFS(C:C,E:E,"Income receipt")
  • Principal disbursements: =-SUMIFS(C:C,E:E,"Principal disbursement")
  • Transfers net to zero: =SUMIFS(C:C,E:E,"Transfer") should return 0.00 when both sides of every transfer are in the file

A 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.

Trust accounting software compared

OptionWhat it doesCostBest for
Typing from the statementsEvery line keyed into a spreadsheet by handHours per trustOne small trust with few transactions
Trust Accountant (Delta Data)Fiduciary portfolio accounting for trusts, estates and guardianshipsListed on Capterra from $100 per user a monthTrustees managing portfolios across many trusts
Estateably or Onesource Fiduciary AccountingTrust administration and court or beneficiary format reportsVendor quoteLaw firms and trust departments filing formal accounts
QuickBooks or Xero with a trust company fileGeneral ledger with bank feedsSubscriptionTrusts with accounts connected online from day one
BankXLSXConverts statement PDFs and scans to checked Excel rows you tag into schedulesStarter $49 a month for 800 pages, Plus $149 for 1,920 pages with batch uploadTrustees 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.

What it costs for a book of trusts

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.

Checklist before the account goes to beneficiaries

  • Every trust account has statements covering the first and last day of the period.
  • Each converted statement ties to its printed ending balance.
  • Transfers between trust accounts net to zero and sit on neither schedule.
  • Income and principal allocations follow the trust instrument, then the state principal and income act.
  • Trustee compensation and agents hired are shown as your state requires.
  • Ending assets equal the closing statements and carry forward as next year's opening figures.

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.

Why Trustees Use BankXLSX for Beneficiary Accounts

$0.00
balance difference you can show per statement
50
statement PDFs in one batch on Plus
800
pages a month on Starter for $49

Security & Privacy

  • No bank login requested
  • 256-bit encryption on every upload
  • Delete uploaded statements at any time
  • Unlimited users on every paid plan

Trust Accounting Questions

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.