Sharpe CPA / For CPAs / Trial balance workbook
Give it the client’s trial balance. You get back an Excel workbook with a workpaper for every account, sign-offs for the preparer and the reviewer, a sheet for proposed adjustments, and a summary of where the work stands. Free, no account needed.
Step 1
A printed trial balance saved as text (.txt or .prn), a CSV, or an Excel workbook (.xlsx). Account number, description and the balance are all it needs; beginning balance and activity are picked up when the report has them.
Your client’s figures stay on your computer. The file is read by this page in your browser and the workbook is written there too. Nothing is uploaded, stored or seen by anyone.
What you get
The figures that depend on the work — adjustments, sign-offs, conclusions — are formulas, so the summary stays true as the file is worked.
The sign-off for the workbook; the trial balance by type before and after proposed adjustments, with net income and whether it balances; the adjustments proposed and accepted; and an index of every workpaper showing who prepared and reviewed it, when, and what it concluded.
Heading, preparer and reviewer sign-offs, the balances with any proposed adjustment, a procedures table started with steps suited to the kind of account, a conclusion and a tickmark legend. Each prints on one page.
Enter each line against an account number. The description fills itself in, debits and credits are checked against each other, and the adjustment flows to the workpaper, the trial balance and the summary.
Every account as read, with beginning balance and activity where the report has them, proposed adjustments, the adjusted balance, and a link to its workpaper.
The suggested procedures are a starting point, not an audit program. What is done, and what it proves, stays with the CPA who signs the report.