XBRL Copy and Paste

rollforward

If you are working in detail tagging mode, you can copy XBRL data and paste it to other tables, text blocks, or text links. When you paste the data you can specify to include line item concepts, dates, axes and members, fact properties, or any combination of these items.

Accessing Copy and Paste

XBRL copy and paste is available with detail tagging, and an XBRL outline section must already exist for the destination of the data you want to paste if it is a table, or already linked (if it is in text). In addition, you must paste XBRL data within the same US GAAP taxonomy.

You can find the toolbar buttons for copying and pasting in the XBRL Detail Tagging window, using the A) XBRL Copy button and B) XBRL Paste button.

image alt text

Guidelines For Pasting Data

When you copy XBRL data to the clipboard, Wdesk detects the valid paste scenarios for that data. When you select the destination and click the Paste XBRL button, the drop-down menu describes those scenarios.

image alt text

When you copy XBRL data from table cells, you can:

  • Paste that information to other table cells: from a single cell to another single cell (one-to-one), from a range to another range (many-to-many), or from one cell’s data to multiple other cells (one-to-many).

  • Paste one cell’s data to one or more text links or text blocks.

When you copy XBRL data from a text block or link, you can copy XBRL data from only one text block or link at a time then paste that data into one or more text blocks, links, or table cells.

Copying Data from One Table to Another

It is common to have the same type of data in multiple tables in your document, with only differing dates; for example, a QTD table and a YTD table. XBRL copy and paste provides an easy way to tag those tables.

The following steps demonstrate copying and pasting XBRL in a Condensed Consolidated Statement of Comprehensive Income (Loss).

  1. Open the document section that has the existing table from which you want to copy XBRL data.

  2. Select the single cell or range of cells that you want to copy.

  3. In the XBRL Detail Tagging window, click the Copy XBRL toolbar button.

  4. Find the table into which you want to paste the data, select the cell range, and in the XBRL Detail Tagging window, click Paste XBRL. You must have already run the XBRL Tagging Wizard for that table for the Detail Tagging window to appear.

  5. Select destination cell ranges carefully. If you inadvertently paste data to the incorrect location, you cannot undo the action, and you will need to retag those values manually, paste again with the correct XBRL data, or discard your XBRL changes.

    image alt text

  6. In the paste options that appear, clear the Dates/Date Ranges check box if it is selected, and then click Paste.

  7. If you have already done a similar paste action in this Wdesk session, it retains your previous check-box selections.

  8. After the paste operation is completed, select the cells again, and in the XBRL Detail Tagging window, select the appropriate date for the new table.

  9. Share your document and XBRL changes.

Tagging a 10K from the Q3 10Q

When you move from Q3 to the 10K, from the visual document perspective, it might make sense to roll from prior year’s annual reports to the current year. However, this requires significant tagging work. You can save a great amount of time by copying facts from the Q3 documents to the current year’s annual reports. The following steps describe tagging a 10K from the Q3 10Q document, after you roll forward the 10K from the previous year. If you have not rolled forward the previous year’s 10K, do this first.

  1. Open the two documents in Wdesk and turn on XBRL.

  2. In the 10Q, select the single cell or range of cells that you want to copy.

  3. Navigate to the section in the 10K document, select the first cell in the range into which you want to paste the data (for a text link, select the existing link), and in the XBRL Detail Tagging window, click Paste XBRL. You must have already run the XBRL Tagging Wizard for that table for the Detail Tagging window to appear.

  4. Select the paste options you want, and then click Paste.

    image alt text

Working with Text Block or Link Data

Copying XBRL data from text blocks or links is a bit different from copying table data, because you can copy the data from only one text block or link at a time. To access the Copy and Paste commands on a text block, click the Actions menu.

image alt text

Select the text link to access the copy and paste buttons in the Detail Tagging window, as you do with table cells. You can paste text block or link data as allowed into one or more table cells, text blocks, or text links.