To turn a trust account statement into Excel for trustee records, convert each monthly PDF to rows, then label every row as income, principal, fee or distribution before you total anything. Those labels are what a trustee's accounting needs. At early pricing, a year of twelve trust statements of up to 10 pages each costs $25.96 to convert.
What does a trust account statement show a trustee?
A trust account statement shows the money that moved through an account held in the trust's name during one period: deposits, withdrawals, the opening and closing balances, and often a summary by type. For a trustee, it is the raw record behind every report to beneficiaries and every tax figure for the trust.
Trust accounts come in two broad kinds, and the statement looks different for each:
- A bank account titled to the trust. This looks like an ordinary checking or savings statement. The account name is the trust, or the trustee for the trust, and the rows are deposits and payments.
- An account at a trust company or investment firm. This often splits activity into sections, such as income received, principal transactions and holdings, and may print several pages that hold positions rather than cash.
The first kind is a bank statement in every sense, and it converts like one. The second kind mixes a cash statement with an investment report. Only the cash parts belong in a transaction sheet. The rest is a different document, covered in the edge case below.
Whichever kind you hold, the parts a trustee uses most are:
- The account title and statement period from the header.
- The opening and closing balances.
- Each deposit, with its source: interest, dividends, rent, a sale, a contribution.
- Each payment, with its payee: a bill, a fee, a distribution to a beneficiary.
Keep each month's PDF as well as the spreadsheet. The spreadsheet is your working record; the PDF is the evidence behind it.
Income and principal columns in a trustee spreadsheet
Income and principal are the two pots a trust's money usually falls into. Income is what the assets earn, such as interest, dividends and rent. Principal is the assets themselves and the proceeds when they are sold. In a spreadsheet, give each row a Pot column so the two can be totalled separately.
The split matters because many trusts treat the two pots differently. One beneficiary may be entitled to the income while another receives the principal later, and fees may be charged to one pot or shared. Which rule applies comes from the trust document and the law that governs it, not from the statement. If you are unsure how a line should be split, ask the trust's lawyer or accountant before you label it.
The statement does not always tell you which pot a line belongs to. A trust company statement may print separate income and principal sections, which makes the labelling easy. A plain bank statement prints one list, so you supply the label yourself.
Here is an example of a trustee ledger built from converted rows. The figures are made up.
| Date | Description | Amount | Pot | Type |
|---|---|---|---|---|
| 2026-03-01 | Interest credited | 42.18 | Income | Interest |
| 2026-03-05 | Rent, 14 Elm St | 1,650.00 | Income | Rent |
| 2026-03-12 | Sale proceeds, bond | 10,000.00 | Principal | Sale |
| 2026-03-15 | Trustee fee, March | -125.00 | Shared | Fee |
| 2026-03-20 | Distribution to beneficiary | -1,200.00 | Income | Distribution |
| 2026-03-28 | Property tax, 14 Elm St | -540.00 | Income | Expense |
A pivot table with Pot as rows and Amount as values then shows the month's net income and net principal movement in one view. Keep the Shared rows visible: they need a decision about how to split them, and that decision belongs in a note next to the row.
Trustee fees, expenses and distributions as separate rows
Money going out of a trust should be labelled by purpose, because each kind is reported differently. A trustee fee pays the trustee. An expense pays a bill for the trust's assets, such as property tax or insurance. A distribution pays a beneficiary. Each needs its own Type label, never one combined "payments" line.
Two habits keep this clean:
- Record the payee in the description. If the bank prints only a check number, add the payee from your check register next to it.
- Keep the backup. Each expense should have an invoice or bill behind it. Bills often arrive as PDFs, and they are not statements. The guide to converting a PDF invoice to Excel for free covers getting invoice lines into a sheet when there are many.
Distributions to beneficiaries deserve extra care. Note the beneficiary's name and what the payment was for. If the trust reimburses a beneficiary for purchases made online, the order history is the backup. Getting Amazon order history into Excel shows how to pull that record for free and match it to payments.
Fees charged by a trust company usually appear as their own line, sometimes monthly and sometimes quarterly. Check that the fee matches the fee agreement. A spreadsheet makes this easy: filter Type for Fee and compare the total with what the agreement says.
The cost of converting a year of trust statements
A year of trust statements costs between $0 and about $30 to convert at early pricing, depending on page counts. The homepage lists $2.99 for one statement up to 10 pages and $5.99 for 11 to 40 pages. A bundle covers any five statements up to 40 pages for $9.99. The first 2 pages of any statement preview free.
The table shows the cheapest plan for twelve monthly statements at three example page mixes.
| Example mix | Cheapest plan | Total |
|---|---|---|
| 12 statements, each 2 pages or fewer | Free preview covers each | $0.00 |
| 12 statements, each 3 to 10 pages | 2 bundles + 2 singles | $25.96 |
| 12 statements, each 11 to 40 pages | 3 bundles | $29.97 |
Trust company statements tend to be longer than plain bank statements because they add holdings and summary pages. Page count is set by the whole PDF, including those pages. How many pages a bank statement usually runs explains what adds pages to a statement and how to check before you pay.
Some trusts receive quarterly statements rather than monthly ones. Four quarterly statements of up to 10 pages cost $9.99 as one bundle, or $11.96 as singles, so the bundle wins. A quarterly statement covers three months of activity, so it is more likely to cross 10 pages than a monthly one.
Older trust records are often on paper, especially when a trustee takes over from someone else. A scanned statement is an image, not text, and the homepage says CheapBankConvert is built for text-based PDF statements. If you are thinking about reading scans yourself with free software, using Tesseract OCR on bank statements sets out what that involves and where it goes wrong.
Trust statement edge case: holdings pages with no cash rows
Holdings pages list what the trust owns, such as shares, bonds and funds, with quantities and market values. They have no deposits or withdrawals, so they do not belong in a transaction sheet. Converting them produces rows that look like transactions but are not, and those rows break every total.
When a trust statement mixes cash activity and holdings, handle it in three steps:
- Find the pages that hold cash activity: deposits, withdrawals, income received and payments made.
- Convert those pages and keep the holdings pages as a PDF for reference.
- Record the market value of the holdings once per period, in a separate small table, if you need it for reports.
Removing pages before conversion is only safe when you are certain they hold no cash rows. Some statements print a trade, such as a sale of shares, on a holdings page, with the cash proceeds on another page. If in doubt, keep the whole file and delete the non-cash rows after conversion.
Use the free preview to test the layout first. The preview converts the first 2 pages, and on many trust statements those are the summary and the start of cash activity. If the preview rows look like positions rather than transactions, this is a layout to convert page by page or to read by hand.
Does the trust spreadsheet tie to the statements at year end?
The trust spreadsheet ties when every month's opening balance, plus deposits, minus withdrawals, equals the closing balance printed on that month's statement, and the twelve months chain together. Do this check before handing anything to a tax preparer. A trust that files an income tax return needs figures that agree with the bank's.
In the US, the IRS page for Form 1041 says the fiduciary of a trust files that form to report the trust's income, deductions, gains and losses, and the income distributed to beneficiaries. Your Income and Distribution labels are the raw material for those lines. Whether the trust must file, and how each figure is reported, is a question for the preparer.
A year-end tie-out in five steps:
- List the twelve months with their printed opening and closing balances.
- Check that each closing balance equals the next opening balance.
- For each month, check that the sheet's deposits and withdrawals produce the printed closing balance.
- Total the year by Pot and Type: income received, principal received, fees, expenses, distributions.
- Note any Shared rows and how you split them, and keep that note with the sheet.
If step 3 fails for a month, the gap is in that month. Look for a row at a page break or a payment that came through as a deposit. Fix the row against the PDF rather than adjusting the total.
When your year of statements is downloaded and counted, CheapBankConvert will email you when you can convert them. It is getting ready to open, and the prices quoted here are early pricing.