Guardianship Accounting Software for Bank Statements and Conservatorship Accounting

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.

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 guardians build the court accounting from bank statements

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.

Why the Annual Accounting Eats a Guardian's Week

The court does not accept a summary. It wants each transaction, sourced, and a closing figure that agrees with the bank.

Every Line Gets Listed

Social Security, pension, facility payments, pharmacy, premiums and the allowance all appear one by one on the schedules, twelve months of them per ward.

Several Accounts per Ward

Checking, savings, a burial account and sometimes a brokerage sweep, each with its own statement layout and its own cutoff dates.

Transfers Count Twice if You Are Careless

Moving $500 from savings to checking is neither a receipt nor a disbursement. Typed by hand, it often lands on both schedules.

The Ending Balance Must Tie

Reviewers check the closing cash against the statements to the cent, and the next year's opening figure must match it.

Old Statements Arrive as Scans

For the first accounting you may be working from paper the ward kept before your appointment, scanned at a branch or photographed.

Deadlines Cluster

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.

What BankXLSX Gives the 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 separate Excel columns, so a filter splits receipts from disbursements in seconds.

Balance Check per Statement

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

A Full Year in One Batch

On Plus, upload up to 50 PDFs at once, enough for two or three accounts across a twelve month period.

Payees Grouped

Plus categorizes transactions and normalizes payee names, so every facility payment or pharmacy charge groups together for the schedule subtotal.

Scans and Photos Read

AI visual OCR reads scanned and photographed statements in PDF, JPG, PNG and HEIC, useful for the records from before your appointment.

Ward Data Kept Private

256-bit encryption in transit, no bank login requested, and uploads you can delete when the accounting is filed.

From Statement PDFs to Court Schedules in 3 Steps

The same routine works for an annual, biennial or final accounting, whatever form your county uses.

1

Convert the Period

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.

2

Sort and Tag

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.

3

Copy Into the Form

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.

Who Prepares Guardianship Accountings with BankXLSX

People who answer to a probate or guardianship court for someone else's money, usually across more than one ward.

Professional Guardians

Run annual accountings for a caseload of wards without retyping hundreds of statement lines each spring.

Elder Law Paralegals

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

Private Fiduciaries and Conservators

Produce the receipts and disbursements detail that supports a conservatorship accounting.

Family Guardians

Get a first accounting right when the ward's records come as a box of paper statements.

Transaction Types We Handle

Social Security deposits
Pension and annuity payments
Care facility payments
Pharmacy and medical bills
Insurance premiums
Personal needs allowance
Transfers between accounts
Interest and dividends

What a guardianship accounting has to show

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.

Worked example of a twelve month annual accounting

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.

LineAmountSource rows
Cash on hand at start, both accounts$38,412.17Opening balances on the first statements
Social Security, 12 deposits of $1,927.00$23,124.00Receipts
Pension, 12 deposits of $812.40$9,748.80Receipts
Savings interest$186.55Receipts
Premium refund from insurer$214.00Receipts
Total receipts$33,273.35Pivot subtotal
Care facility, 12 payments of $2,450.00$29,400.00Disbursements
Insurance premiums, 12 of $189.00$2,268.00Disbursements
Guardian fee as approved by the court$1,800.00Disbursements
Pharmacy, 31 charges$1,236.88Disbursements
Personal needs allowance, 12 of $100.00$1,200.00Disbursements
Total disbursements$35,904.88Pivot subtotal
Savings to checking transfers, 4 of $1,500.00$6,000.00Tagged transfer, on neither schedule
Cash on hand at end$35,780.64Must 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.

Three Excel cells that do the subtotals

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

  • Receipts: =SUMIFS(C:C,E:E,"Receipt")
  • Disbursements: =-SUMIFS(C:C,E:E,"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 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.

How BankXLSX compares with the other ways guardians do this

OptionWhat it doesCostBest for
Typing from the PDFsEvery line keyed by hand into the form or a spreadsheetHours per wardOne ward with a few transactions a month
Bank feed in bookkeeping softwarePulls transactions once an account is connectedSoftware subscriptionAccounts you control online from day one, not older paper statements
State or court systemsSome states run their own filing tool, such as Minnesota's MyMnConservatorSet by the stateFiling in that state, you still need the transactions entered
Fiduciary accounting suitesProduce court format reports and principal and income splitsVendor quote or licenseTrust departments and firms filing many formal accounts
BankXLSXConverts statement PDFs and scans to checked Excel rows, you tag the schedulesStarter $49 a month for 800 pages, Plus $149 for 1,920 pages with batch uploadGuardians 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.

What it costs for a caseload

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.

Checklist before the accounting is filed

  • The first statement shows the balance on the start date and the last statement covers the end date, for every account.
  • Each converted statement ties to its printed ending balance.
  • Transfers between the ward's own accounts net to zero and appear on neither schedule.
  • Cash on hand at the end equals the sum of the closing statements, and becomes next period's opening figure.
  • Your fee and any attorney fees match the amounts the court approved.
  • Original or electronic statements are lodged or kept for inspection as your court requires.

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.

Why Guardians Use BankXLSX for Court Accountings

$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

Guardianship Accounting Questions

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.