A table of transactions is not an accounting
Converting a statement into a spreadsheet gives you rows: dates, descriptions, amounts. A California fiduciary accounting needs much more: each row on the right schedule, principal kept apart from income, transfers between accounts recognized, each security’s carry value followed through every sale, gains and losses calculated from carry value, the property on hand at the beginning and end listed, and both sides of the summary balanced (Prob. Code §§1061–1063). That is where the days, weeks or months of manual work go.
What you add
- The PDF statements for every account, for the whole period, as the bank or brokerage issued them
- The statement for the month before the period, so the opening balances come from a source document
- Optionally, a prior accounting or carry-forward file, and a memo for anything the statements cannot show: a residence, a business, notes, preferences
What you get back
Balanced converts and organizes your statement data exactly as the statements show it, using disclosed, standard accounting conventions you can change. Everything beyond that comes from your own instructions.
One fully editable Excel workbook: the summary of charges and credits, every schedule, carry values and market values, gains and losses, changes in form, and a tax summary for the CPA, each account reconciled to its own statements and the summary balanced to the penny, each row citing the statement and page it came from. For a conservatorship or guardianship, the same in the GC-400 layout. You review and verify it before you rely on it or file it.
Your statements stay on your computer
The PDF files are converted in your own web browser, on your own computer, and the files themselves are never uploaded, shared or transmitted.
From your statements to the accounting
Balanced is a new kind of software for California fiduciary accountings. From the PDF bank and brokerage statements, Balanced generates the accounting in minutes to hours, rather than the days, weeks or months of manual work it otherwise takes: transactions classified to their schedules, carry values tracked lot by lot, each account reconciled to its own statements, the summary balanced to the penny, and each entry cited to the statement and page from which it was drawn, delivered as one fully editable Excel workbook. $699 per accounting.