Tax Workpaper Software: Every Figure Traced to Its Source Page

Your Reviewer has a drafted 1040 open and stops on the ordinary dividends figure. Which statement did it come from? Which page? Was it this year's composite 1099 or last year's, which the client also dropped in the folder? The number on the return doesn't say. So the Reviewer either trusts it or goes digging through the folder, and digging is the hour your firm never budgeted for.

That's the problem good tax workpaper software has to solve. A finished number reads the same whether it's right or wrong. For an extracted figure, the first check is to follow it back to the page it came from, alongside the Reviewer's own recalculation and judgment on treatment. A workpaper earns its name when that trail exists for every figure. This piece shows what that looks like on a synthetic 1040 workpaper index you can copy, and what to require of any software that builds one.

What makes a workpaper checkable

A workpaper is checkable when someone who didn't build it can confirm any figure without asking the person who did.

Figure, document, page

Every figure on a source-cited workpaper carries a pointer with three parts, plus the value as printed. Take a made-up interest figure on a Doe file: $412.00, from a bank 1099-INT, page 1, Box 1, printed as $412.00. The Reviewer opens the page, sees the printed value next to the drafted one, and moves on.

Without the pointer, the same check means opening the folder, finding the right bank's form among several, and hoping it's the current year. Multiply that by every figure on a 1040 and you can see where review time goes. For what a usable pointer needs, see AI citations in tax prep workpapers.

Why a finished number cannot be checked by reading it

A dividend total built from the right statement and one built from last year's statement look identical on the return. Same font, same line, same confidence. Reading the number tells your Reviewer nothing about where it came from.

So the check has to be the trail. When the trail exists, review becomes inspection: open the page, compare, decide. When it doesn't, review becomes reconstruction. A source on every figure makes the process inspectable, and your Reviewer decides what the figures add up to.

A synthetic 1040 workpaper index

Here's a skeleton you can copy. Everything in it is synthetic: Jane and John Doe are made-up taxpayers, and every amount is invented. The "Carries to" column is a synthetic example of where a preparer would usually carry each figure on a tax year 2025 Form 1040. It names forms and schedules, not line numbers, on purpose. The current-year IRS instructions and your firm's own return software govern where any figure actually goes, and your preparer decides. The primary sources for these mappings are the IRS's 2025 Instructions for Form 1040 and the separate 2025 instructions for each schedule and form the tables carry figures to.

Each row is one figure. Ref is the index number the draft cites, so a figure on the return points back to a row here, and the row points to a page.

Income documents

Two rows show why the index matters. I-4 has a tie-out: the summary page prints $1,940.00, and the detail pages list three holdings at $1,020.00, $610.00, and $310.00, which add to $1,940.00, so the figure ties and the row shows the sum. I-6 doesn't tie. The 1099-B detail pages add to less than the summary, because page 4 of the statement is missing from the folder. The index flags it instead of drafting around it. When page 4 arrives, the preparer re-runs the tie-out and the row can close. For more on checking extracted totals, see tying out AI-extracted totals.

Deductions, credits, and payments

The index records what each document says and where it would carry. Whether the Does itemize or take the standard deduction is a separate decision, made by your preparer with the whole return in view, and it rests on figures anyone can trace.

Open items

Open items live on the index, each one tied to the rows it affects. When the file reaches your Reviewer, they know exactly what they're signing around and what's still with the client. That's a large part of what makes a draft review-ready.

What to require of the software

If you're evaluating tax workpaper automation, ignore the interface for a minute and look at the index it produces. Three things separate workpapers your Reviewer can check from numbers your Reviewer has to redo.

Source link per figure

Require that every figure link to its page, with the printed value shown beside the drafted value, and that where a document prints a total, the tie-out is shown, not asserted. Ask the vendor to open the source behind three figures you pick at random. If one of them has no pointer, assume others don't either. TracePrep's approach, a source citation on every figure, is on the traceable evidence page.

Preparer changes with a reason

Preparers change figures. That's their job. What matters is the record: who changed it, the prior value, the new value, the reason, and the time. A figure that moves without a reason on the record looks exactly like a mistake, and your Reviewer can't tell which one it is.

Reviewer sign-off on record

The Reviewer has to be able to send a figure back with a note, hold sign-off until open items clear, and leave a record of who signed and when. Any tool that suggests review is optional fails here.

Who keeps the workpapers

Firm-owned workpapers

Workpapers are your firm's record of how a return was built. Your duty to keep that record doesn't end because a software subscription does, so the question belongs in the evaluation, not after it.

Ask any vendor what your firm holds if you stop using the product: the index, the source pointers, the change log, the sign-off record. The answer should be plain and in writing. TracePrep's position is that the firm owns its workpapers; see firm-owned workpapers and the data ownership page for the details.

Where TracePrep fits

TracePrep is tax-prep software for CPA and EA firms. What it aims to hand you looks like the index above: a return draft ready for your own Reviewer to review, with each figure traced to its source document and missing items already asked. The plugin drafts; the Firm's preparer prepares; the Reviewer signs off. Access to the plugin is by waitlist.

Start with the index

Build the index before you draft: every source document, every page, every open item. Then require a pointer on every figure from whatever software you use. When you want to see drafts built that way, join the TracePrep waitlist.

<!-- lint-ignore: missing-required-reciprocal-anchor per brand form v4.0 plugin-copy rule -->

Not tax advice. TracePrep is a software product from TracePrep Inc., not a CPA firm. This content is operator experience for educational purposes; it is not tax advice and has not been reviewed by a licensed CPA. Consult a qualified tax professional for guidance on your specific situation. Source citations in TracePrep workpapers support audit defense but do not guarantee IRS outcomes.