Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
classsection group
<span data-swiftype-index="true">
This feature does not support password protected files. Only the Entire document reference option is available.
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.

References are bookmarks in PDFs and, from AE/AO version 2017.1, worksheets in spreadsheets.

UI Text Box

You can link to worksheets with Excel 2013, Excel 2016, and XLS, XLSX and XLSM file types

are supported for adding Excel spreadsheets with references


UI Text Box

In password-protected files, you can only link to the entire document, not to references in the document.

To use bookmarks when linking the document, make sure you've added bookmarks to the document before you start. For example, using PDF Manager, you can save the bank statement and asset purchase contract as one document with bookmarks for each section. You can then link the bookmarks to specific accounts in the Trial Balance (Workpapers). From AE/AO version 2017.1, you can also link to spreadsheet worksheets.

UI Expand
titleTo link to specific
bookmarks in an external document
Open the workpapers period. See Opening an existing period. The Prepare Trial Balance (Workpapers) table is displayed
  1. Go to the client’s Client Accounting > Trial Balance (Workpapers) tab and click a period in the Select Period section.
  2. On the TASKS bar, click Open Period. The table for the period appears.
  3. Select the detail or header account in the table
  1. , or

  1. select the checkbox in the first column for the selected account.
Click Link document on
  1. On the TASKS bar
UI Text Box

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


  1. , click Link Document. The Link External File window
  1. appears.
  2. Ensure that the correct account is displayed in
the Account drop-down field
  1. the Account field.
Click Browse in
  1. In the Select external file
  1.  section, click Browse. The
  1.  Attach External
  1. File window
  1. appears.
  2. Navigate to the location where the PDF file is stored and find the file.
  • Ensure that the path and filename in the File field are correct.
  • 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.
    1. Click Open.
    UI Text Box

    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.

    Select the Rollover this document to the next period checkbox. This will
    1. If your document is a PDF with bookmarks or a spreadsheet with worksheets and you want link to a specific bookmark or worksheet, select the bookmark or worksheet from the Bookmark or Reference drop-down list, depending on your version. Otherwise the link will be to the entire document.

      UI Text Box

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

    1. Linking to worksheets using the Reference column is available from AE/AO version 2017.1.

    2. If you want to include the document in the next rollover period, select the Roll forward checkbox. During rollover, the previous
    1. workpaper period is used as a base.
    If this option is selected the
    1. The link to the document will be recreated and included on the same account in the next period.
    Click Preview.
    1. 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.Click
    1. want to check that the link opens correctly, click Preview and close the document when you're done.
    2. Click Link. The external file is linked to the selected account. The
    external file is
    1. files are displayed as a sub-row
    1. under the account in the table. A paperclip (Image Modified
    document link
    1. ) icon identifies a linked document.
    HTML Wrap
    classcol span_1_of_5
    HTML Wrap
    classcol span_1_of_5
    titleRelated topics
    HTML Wrap

    Linking an external document to an account

    Linking an external 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