GENERAL ADMINISTRATION
      Back to home
      1. Help Center
      2. Firm Administration
      3. GENERAL ADMINISTRATION

      Generating reports from Connectworks

      Information on obtaining reports from within Connectworks

      Connectworks offers many different types of .csv (excel) and .pdf reports regarding your clients from many points throughout the product. This article will show you where and how to obtain these reports.

      Reports available in Connectworks

      You can generate a report from any section of the product by clicking on the "I would like to..." drop-down menu located on the top right-hand side of the page and selecting the report you would like to export.

      Dashboard>Client Tasks

      • Export (PDF & CSV) all outstanding Client Tasks

      • Type

        • Sign Documents,

        • Approve Resolutions

        • Accept Invitations

      • Age (+30 days, +60 days, and +90 days)

      • Output in the Document

        • Date

        • Entity (Trust, Company etc)

        • Assignee (Party signing)

        • Description (Document title)

      Dashboard>Reminders

      • Type

        • Annual Reviews

        • Gifting

        • AGMs

        • Balance Dates

        • Vesting Dates

        • Annual Filing Dates

        • Entitlement Dates

        • Identity expirations

        • Register completions

        • Register expirations

      • Period (Date range)

      • Time (1, 2, 3, 6 months and 1 year)

      Dashboard>Recent Activity

      • Date Range

      • Type (For) Clients and Firm

      • Export (PDF & CSV)

      • Output in the Document

        • Date

        • Type (Create, Update etc)

        • Author

        • Organisation (Trust, Company etc)

        • Description

      Clients>Individuals:

      • Export list (CSV) of all individuals detailing: Name, Connectworks ID, Subscription type, Client ref, Email, Phone 1, Phone 2, Website, Birth location, Birth country, DOB, Tax code, IRD, GST, Residential address, Mailing address, Manager, Partner.

      Clients>Companies:

      • Export list (CSV) of all companies detailing: Name, Connectworks ID, Subscription type, Client ref, Annual review date, Email, Phone 1, Phone 2, Website, Tax code, IRD, GST, All address types, Company type, Incorporation date, AGM date, Balance date, Annual return date, Manager, Partner.

      • Export trusteeships of trustee companies (CSV) a report detailing all Corporate Trustee Companies and the trusts in which they hold a role.

      • People & Employees report (CSV) is a report detailing all the people contained within the "People & Employees" section in each company profile, the roles they hold in the company and their appointment/retirement dates.

      Within a Company workspace:

      Directors tab:

      • List of directors (PDF & CSV)

      Shareholders tab:

      • Transaction report (chronological)

      • Transaction report (by allocation)

      • Capital report

      • History of ownership (XLS, CSV & PDF)

      • History of control (XLS & PDF)

      • Shareholder continuity report

      • Compliance report s87(2)(a)

      • Compliance report s87(1),(2)(b,c)

      • Allocation report (PDF & Excel)

      • Allocation contact report (Excel)

      • Transaction report (chronological, by allocation & CSV)

      • List of Shareholders (PDF & CSV)

      Clients>Trusts:

      • Export list (CSV) of all trusts detailing: Name, Connectworks ID, Subscription type, Client ref, Annual review date, Email, Phone 1, Phone 2, Website, Tax code, IRD, GST, All address types, Trust type, Business unit, Settlement date, Gross income distributions, 6-month distributions, FATCA reporting, Foreign tax, Files tax returns, Vesting Date, Decisions (majority or consensus), AGM date, Balance date, Annual return date, Manager, Partner.

      • Export by Corporate trustee (PDF) a report detailing all Corporate Trustee Companies and the trusts in which they hold a role.

      • Trustee report (CSV) is a report detailing all the people contained within the "Associated Parties" section in each trust profile, the roles they hold in the trust and their appointment/retirement dates.

      • Status report (CSV) is a report detailing the information contained within a trust profile including Trust name, Client Reference, Business unit, Partner, Manager, Subscription plan, Settlement date, Vesting date, Vesting event, Balance date, IRD, GST, US citizen, Non-local tax resident, roles present within the trust, the total number of documents loaded in the trust.

      Within a Trust workspace:

      Workspace tab:

      • Export trust profile (PDF)

      Ledger tab:

      • Movements report (CSV)

      • Transactions report (CSV)

      Note - there is a separate report section of the ledger's tab, Ledger>Reports. Place a tick on the report you would like to obtain on the left-hand side of the page and click on the "I would like to..." drop-down menu and select export results. export report at the bottom of the page. See more here.

      Clients>Contacts:

      • Export list (CSV) detailing all of your firm's contacts.

      • Client summary (PDF) is an additional report available via the 3 dots menu in the Clients>Contacts list. This report can be generated for any entity type (contact, individual, company or trust) by using the "Advanced" filter in the left column and selecting "contact or client".

      If you are looking for a particular report, or need assistance with a report. Please contact the team at support@connectworks.com