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.
Rolling a 10-Q to a 10-Q or a 10-K to a 10-K
When copying a document, select Keep link to original source files in the Links options under Copy Includes. This will eliminate additional files rolling forward each quarter and keep the links to the original source file(s).
Copy the folder you want to roll forward in order to create the documents you will update for the roll forward process. For more information on copying a folder, see Copy a file or folder.
Because the copied documents are linked to the spreadsheet, XBRL will roll forward by copying the folder containing the previously-filed document(s).
After creating a document for the current period, update the spreadsheet followed by the linked 10-Q or 10-K document. For more information on linking, see Link and publish in Spreadsheets.
Rolling forward a BDC Schedule of Investments
To add an investment, insert a new row in your spreadsheet and the document.
To remove an investment, first remove any links in the row and then delete the row in the spreadsheet and document. This function should be performed individually for all investments that are added or removed.
To move an investment, insert a new row in your spreadsheet and document where the investment will be moved to. Then cut and paste the previous row to the new location (including individual sub-cell links). This will retain the XBRL. You can then delete the empty row where the investment was previously. See Sort Function below for additional ways to move investments.
After adding investments, make sure to add any necessary links. Sub-cell linking should be performed where applicable (see interest column as an example), allowing inline XBRL to be applied appropriately. Updates to the linked sub-cell values should also be done in the spreadsheet. For more information on sub-cell linking, see Creating multiple links in a cell.
Note: To preserve XBRL, do not copy and paste over the schedule in the document, and make sure updates are made in the spreadsheet. Instead, add or remove a row to the applicable table in the linked 10-Q or 10-K document, then apply links from the spreadsheet to that row.
Using Sort Function to Move Investments
If reordering investments within the same sub-grouping (by $ value, %, name, industry, etc), the sort function may be used.
- Select the range of data to sort
- Under the Data menu, select Sort
- Uncheck Selection includes header row.
- Select the column to sort by.
- Select A→Z or Z→A, for ascending or descending order
To keep the document and spreadsheet in alignment, perform this sort in both locations