Menu

Search

Knowledge Base


10947: Detail Worksheets


Data Entry Basics

How can I create worksheets to include details about particular lines, such as gifts to charity, or other income?

You can use detail worksheets to enter up to 30 items for a numeric field. Totals are calculated automatically.

To create a detail worksheet:

  1. Select the numeric field to which the worksheet will apply.
  2. Double-click in the field, press CTRL + W, or right-click and select Add Worksheet to open a Detail Worksheet.
  1. Enter or edit the worksheet Title.
  2. Enter a Description and Amount for each item.
    • Do not skip lines.
    • As needed, use function keys F1, F2, F3, and F4 to sort items in the list.
  3. Press ESC. The software saves your work and displays the total in data entry. By default, the field is shaded red to indicate a worksheet is present.

Notes:

  • You can change the highlight color indicating a worksheet is present. Go to Setup > Colors and select another color under Data Entry Colors for Worksheet Highlight Background.
  • Some fields require a worksheet, notably in business package returns. When required, the detail worksheet is produced when you attempt to make an entry in the numeric field. See Related Links below for examples. 
  • Certain fields that require a detail worksheet are limited to one Detail Worksheet screen per line.
    • For example, in the 1120 package, the Other (itemize) line on the DED Deductions screen is limited to a single detail worksheet in data entry.
  • In view, the detail worksheet items will show on either an Overflow worksheet or a Statement with a number that corresponds to a specific line on the form to which it applies. 
  • Mixed case and Upper case options are located on the Setup > Options > Data Entry tab. They are effective for text you enter after selecting the option, but selecting either option does not modify previously entered text unless you reopen the overflow screen (CTRL + W) where you previously entered the text.

Mixed case and Upper case options are located on the Setup > Options > Data Entry tab. They are effective for text you enter after selecting the option, but selecting either option does not modify previously entered text unless you reopen the overflow screen (CTRL + W) where you previously entered the text.
Mixed case and Upper case options are located on the Setup > Options > Data Entry tab. They are effective for text you enter after selecting the option, but selecting either option does not modify previously entered text unless you reopen the overflow screen (CTRL + W) where you previously entered the text.
Mixed case and Upper case options are located on the Setup > Options > Data Entry tab. They are effective for text you enter after selecting the option, but selecting either option does not modify previously entered text unless you reopen the overflow screen (CTRL + W) where you previously entered the text.

Related Links


Also In This Category


Details
Article has been viewed 7.7K times.
Last Modified: 4 Months Ago
Options