Drake Tax - Detail Worksheets

Article #: 10947

Last Updated: October 21, 2024

 

Tags: Drake Tax

Drake Tax logo

Data Entry

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.

  3. Enter or edit the worksheet Title.

  4. 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.

  5. 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.

Note  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.

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 screen is limited to a single detail worksheet in data entry.

In View/Print, 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.

Worksheet Transmission

Some lines of the tax forms require the detail to be sent to the IRS, but most detail worksheets are not included in an e-file transmission.

  • The detail worksheets that get e-filed to the IRS will say "IRS requires this field to have a worksheet."

  • The detail worksheets that do not get e-filed will just say "Detail Worksheet" at the top of the screen.