Workiva Support Center

When preparing your documents for a new quarter, you can use the documents you've filed previously as a base for the new quarter's documents.

Initial Document Setup

To begin your roll-forward:

1. Copy the entire folder containing your previous filings. This ensures all internal links remain functional. For more information on copying a folder, see Copy a file or folder.
2. In the Copy Includes options, open the Links menu and select Keep links to original source files. This prevents the creation of unnecessary duplicate files and maintains the connection to your central data source.
   
3. Once the copy is created, update your Spreadsheet first, then your linked 10-Q or 10-K document.

Managing Investments in the SOI

To maintain the integrity of your XBRL, follow these specific procedures for adding, removing, or moving investments.

Adding an Investment

1. Insert a new row in your Spreadsheet and Document.
   
2. Add the data in the Spreadsheet and create the links to the Document.

3. Use sub-cell linking (e.g. for interest rate columns) where applicable to ensure Inline XBRL applies correctly.

   Warning: Skipping this step may cause incorrect XBRL.

Removing an Investment

1. In the Document, manually remove any links within the row you wish to delete.
2. Delete the row in both the spreadsheet and the document.

Note: This must be done individually for each investment being removed.

Moving an Investment

1. Insert a new row in your spreadsheet and document at the new target location.
2. Cut and Paste the data from the old row to the new row. This method preserves the XBRL tags and individual sub-cell links.
3. Delete the original (now empty) row.

Warning: To preserve XBRL, never copy and paste over an entire schedule in the document. Always manage changes row-by-row.

Using the Sort Function

If you need to reorder investments within a sub-group (e.g., by name, industry, or value), use the Sort function.

1. Highlight the data range you wish to sort.
2. Go to the Data menu and select Sort.
3. Ensure Selection includes header row is unchecked.
4. Choose your sort column and order (A→Z or Z→A).
5. Alignment: Perform the exact same sort in both the Spreadsheet and the Document to keep them synchronized.

Warning: Failing to update as described above will cause XBRL to be disconnected and require a full retag, which is outside the scope of full-service XBRL contracts and will incur extra charges. If you have any questions, please reach out to your assigned Client Relationship Manager.