Skip to Content
TaxPrepareWork with leadsheets and custom sheets

Work with leadsheets and custom sheets

The Leadsheet section combines document-type sheets and your own working sheets in one workbook. Use document sheets to review source figures and custom sheets to build calculations.

Read a leadsheet

Choose a sheet from the bar below the grid. A document-type sheet brings documents of that type together, with fields or boxes down the rows and documents across the columns. Select a figure to inspect its source.

Display narrows rows to All, To verify, Has values, Edited, or Verified. Its document filters include All docs, Needs verify, Failed, and Not extracted. Filtering changes what you see; it does not delete the hidden information.

Use the column finder in the sheet bar to jump to a document when the grid is wide. Select a document column and use Move left or Move right to arrange the review order. Pin column holds a document beside the field list during horizontal scrolling; Unpin releases it.

Select rows and understand totals

Select a document heading to select its values, or use a row’s selection control to choose that box across documents. Ctrl+Space selects a column; Shift+Space selects a row. These selections work with copy, formatting, and the review actions available for the chosen cells.

Collapse a row group to hide its detail and expand it when you need the underlying boxes. The field labels and Total column stay visible while you scroll sideways.

Not totalled means the row is not eligible for a total or includes a document that has not been read. It does not mean zero. A row’s Total is read-only.

Selection statistics show Sum, Avg, Min, and Max when the selected cells include numeric figures. If some filled cells are text, the display states how many are figures. Use these statistics to inspect a selection without changing the sheet.

Add working values

Use Insert → Add column to add a manual column to a leadsheet. Enter the label and click Add. Custom columns hold your working values and notes; they do not have a source document.

Double-click an editable cell to enter a value. Press Enter to save or Escape to cancel. Use Clear where the selected manual or custom value supports clearing.

Create a calculation sheet

  1. Click Add sheet on the bottom sheet bar.
  2. Select the new sheet.
  3. Enter labels and values in its cells.
  4. Type a formula directly into a cell or the formula bar when needed.
  5. Check the displayed result and save status.

For example, =SUM(A1:A9) adds a range on your working sheet. A source-document box expects a figure, so put supporting formulas on a custom sheet.

Use Rename to name your own sheet and Delete when it is no longer needed. Deletion requires confirmation and cannot be undone. Document-type leadsheets keep their names and structure.

Format and copy your work

Select cells and apply the supported ribbon controls: bold, italic, underline, text color, fill, alignment, or a number format. Money shows thousands separators and two decimals; Money (whole) shows whole numbers.

Use Copy or Command/Ctrl+C to copy the selection. Selection totals help you inspect the selected figures without creating another formula.

Choose a number format

Use Number format to select Plain, Money, Money (whole), Percent, Date, or Text. Apply it to the current cell or selected range. Money uses thousands separators and two decimal places without a currency symbol.

The format controls how a value is displayed. Review the underlying entry in the formula bar before changing a figure to make it look different.

Clear cells and undo figure edits

Select cells and press Delete or Backspace to clear values the sheet allows you to edit. On a custom sheet, Clear these cells? states how many cells will be emptied, including formulas. Review the count before Clear; custom-sheet clearing cannot be undone.

On a document-type leadsheet, Undo and Redo name the figure change they act on. Undo covers changes made since opening the binder. Formatting has a separate boundary: apply the desired format directly when the control explains that the latest formatting change cannot be undone.

If the workbook changed while you were working, use the offered reload before attempting more history changes. A save conflict needs a choice between the current figure and your proposed figure; see verifying extracted figures.

Check changing calculations

When underlying figures move after review, the custom sheet can show … figure moved since it was last reviewed. Compare the previous and current values before Accept or Accept all.

The save line distinguishes saving, saved, and not saved. Resolve a failed write before relying on a calculation. Leadsheet figure edits have Undo and Redo where available; do not assume every sheet operation has the same history controls.

See Excel import and export to continue work in a downloaded workbook.

Last updated on