Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

When you link a PDF file or Excel spreadsheet, you can specify the PDF bookmark or Excel worksheet as a reference.

Excel 2013, Excel 2016, and XLS, XLSX and XLSM file types are supported for adding Excel spreadsheets with references.

UI Text Box
typenote

This feature does not support password protected files. Only the “Entire document” Entire document reference option is available.

UI Expand
expandedtrue
titleTo link to specific references in an external document
  1. Open the workpapers period. See Opening an existing period. The Prepare Trial Balance (Workpapers) table is displayed.
  2. Select the detail or header account in the table.
    or
    Click the checkbox in the first column for the selected account.
  3. Click Link document on the TASKS bar.

    UI Text Box
    typetip

    Another way of linking an external file to a selected account in the table, right-click and select Link document.

     

    The Link External File window opens.
  4. Ensure that the correct account is displayed in the Account drop-down field.
  5. Click Browse in the Select external file section. The Attach External File window opens.
  6. Navigate to the location where the PDF file is stored and find the file.
  7. Click Open.
    UI Text Box
    typenote

    If the Document name is already in use, a message will appear asking if you wish to add the document with a suffix attached. If you click OK, the document will be automatically added to the account.

  8. Ensure that the path and filename in the File field are correct.
  9. If you are linking to a specific PDF bookmark or Excel worksheet, select the reference from the Reference drop-down.
    If the external file does not contain any references, then a link will be created to the Entire Document.
    The Document name field is automatically filled with the name of the file that is to be linked to the period. If you are linking to a PDF bookmark or Excel worksheet, then the bookmark/worksheet name enclosed in brackets is added as a suffix to this value. You can change this value by deleting the existing text and entering a new Document name.
    UI Text Box
    typenote

    The Document name must be unique. An error message is displayed if the Document name is already in use.

  10. Select the Rollover this document to the next period checkbox. This will include the document in the next rollover period. During rollover, the previous workpapers period is used as a base. If this option is selected the link to the document will be recreated and included on the same account in the next period.
  11. Click Preview. If you are linking to a specific PDF bookmark or Excel worksheet, the file opens at the specified reference. If you are linking to the entire file as it does not have any references, then the document opens at the first page. Preview the displayed information and check that the reference is correct.
  12. Click Link. The external file is linked to the selected account. The external file is displayed as a sub-row below the account in the table. A Document link icon document link icon identifies a linked document.
HTML
</span>
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Linking an external file document to an account

Linking an external file document to a period

Adding workpapers

Viewing a list of all workpapers and source documents

Opening workpapers

Opening source documents

Deleting workpapers and source documents

Importing the client's balances

Adjustment journals

Opening an existing period

Opening Document Manager files