Hello, I'm looking at ways to improve setup for our documents and spreadsheets. We have 2 separate spreadsheets (Financial Statements and MD&A) linking to the respective documents of the same name. How can we set up a single source spreadsheet and properly link to the multiple documents without relinking or retagging XBRL? We have XBRL tags in our Financial Statements Document, but only used for our annual report, for the rest of the year, we don't use this Document with XBRL.
Specifically, for our annual report, we normally take a copy of prior year's Q4 Financial Statements (FS) Document and the linked Spreadsheet and a copy of the current year's Q3 MD&A Document and the linked Spreadsheet to make up the Q4 package. This way we have the XBRL tags intact in the FS and the most up-to-date narrative in the MD&A, but with this method, it would require re-linking of some values that flows from the FS to MD&A. It would be preferable if we can roll forward a master folder for each quarter with everything we need, instead of combining 2 different files from different folders. We also have our press release linked to the MD&A.
- I would like to hear more of what others have done. I'm planning to reach out to our CSM to discuss about this after Q3, but since this AMA came up, I thought I'd pick the brains of others first.
- Is it best practice to have destination links in our FS and MD&A sourced from the same cell in the spreadsheet?
- We are not using Wdesk Sync, as it would require a lot of rejigging of our Excel files to mirror how it looks in Spreadsheets, so we're manually copying/pasting between Excel and Spreadsheet, I guess we just have to take the time to setup both Excel and Spreadsheets to be the same, but do you have any suggestions or best practices?
- I know we have Export Importer, which will eventually replace Wdesk Sync, do you recommend we begin to fix up our Excel files now and use Importer when replaces Wdesk Sync?