Skip to content

Exporting Expense Sheets from Dovico Timesheet

This task will export expense sheet information from your Dovico Timesheet account to an XML file.

Settings

Dovico Timesheet Connection

Required
The Dovico Timesheet connection to use. See the Connecting to Dovico Timesheet article if you require more information on how to create/manage connections.

Export Currencies

Required
Set to True to include related currency records in the exported data.

Export Employees

Required
Set to True to include related employee records in the exported data.

Export Expense Categories

Required
Set to True to include related expense category records in the exported data.

Export Expense Entries

Required
Set to True to include related expense entry records in the exported data.

Export Projects

Required
Set to True to include related project records in the exported data.

Export Settings

Required
Settings to control whether new, modified or all records will be exported from Dovico Timesheet. The following options are available:

  • Date Created - The date to use when exporting new records. Records created since this date will be exported. The date will update automatically each time the task runs.
  • Date Modified - The date to use when exporting modified records. Records updated since this date will be exported. The date will update automatically each time the task runs.
  • Export New, Modified or All Records - Choose whether the task should export new, modified or all records.

Filters

Optional
Filter the export based on the value of specific fields. Please note that Dovico Timesheet only supports filtering on specific fields. Please refer to this article for details on which fields are supported, and the filter syntax.

Status

Required
Filters the export by status. The following options are available:

  • Any
  • ApprovedToBeReimbursed
  • ApprovedReimbursed
  • NotSubmitted
  • PartiallyReviewed
  • Rejected
  • UnderReview

Timeout

Optional
The length of time (in seconds) to wait for responses from the Dovico Timesheet API. If not specified, the timeout will default to 100 seconds.

Output File

Required
The name of the file to export the data to. The data will be output in XML format, a sample of which is shown below.

Zynk Settings

See Common Task Settings

Examples

Sample output file:

<?xml version="1.0" encoding="utf-8"?>
<ExpenseSheets xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ExpenseSheet>
    <ID>131927</ID>
    <ExternalID />
    <Employee>
      <ID>123</ID>
      <GetItemURI>https://api.dovico.com/Employees/123/?version=7</GetItemURI>
      <Record>
        <ID>123</ID>
        <ExternalID />
        <Created>2026-04-24T17:17:19</Created>
        <Modified>2026-07-24T16:22:36</Modified>
        <LastName>Smith</LastName>
        <FirstName>John</FirstName>
        <EmployeeGroup>
          <ID>141</ID>
          <Name>Integrations Team</Name>
          <GetItemURI>https://api.dovico.com/Teams/141/?version=7</GetItemURI>
        </EmployeeGroup>
        <SecurityGroup>
          <ID>95</ID>
          <Name>Time and Expense Entry</Name>
          <GetItemURI>https://api.dovico.com/SecurityGroups/95/?version=7</GetItemURI>
        </SecurityGroup>
        <SoftwareAccess>T</SoftwareAccess>
        <Wage>0</Wage>
        <WageCurrency>
          <ID>-1</ID>
          <GetItemURI>N/A</GetItemURI>
          <Symbol>$</Symbol>
        </WageCurrency>
        <Charge>0</Charge>
        <ChargeCurrency>
          <ID>-1</ID>
          <GetItemURI>N/A</GetItemURI>
          <Symbol>$</Symbol>
        </ChargeCurrency>
        <ChargeChangedDate>2026-04-24T00:00:00</ChargeChangedDate>
        <StartDate>2026-04-27T00:00:00</StartDate>
        <EndDate>2100-12-31T00:00:00</EndDate>
        <Email>[email protected]</Email>
        <WorkDays>.MTWTF.</WorkDays>
        <Hours>7.5</Hours>
        <AltApproval>F</AltApproval>
        <NotificationTime>T</NotificationTime>
        <NotificationExpense>T</NotificationExpense>
        <NotificationRejected>T</NotificationRejected>
        <Archive>F</Archive>
        <Integrate>
          <INT />
        </Integrate>
        <CustomFields>
          <CustomField>
            <ID>164741</ID>
            <TemplateID>115</TemplateID>
            <Name>Sage Account</Name>
            <Values>
              <Value>SMIT0001</Value>
            </Values>
            <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/115/?version=7</GetCustomTemplateURI>
          </CustomField>
        </CustomFields>
      </Record>
      <Name>Smith, John</Name>
    </Employee>
    <Status>A</Status>
    <Title>Smith, John Mon Jul 13 2026 from Fri Jul 10, 2026 to Thu Jul 16, 2026</Title>
    <Description />
    <Reimbursed>F</Reimbursed>
    <CheckDate>1900-01-01T00:00:00</CheckDate>
    <CheckNumber />
    <Approver />
    <GetExpenseEntryItemsURI>https://api.dovico.com/ExpenseEntries/Sheet/131927/?version=7</GetExpenseEntryItemsURI>
    <ExpenseEntries>
      <ExpenseEntry>
        <ID>174062</ID>
        <Created>2026-07-13T17:07:25</Created>
        <Modified>2026-07-24T11:39:59</Modified>
        <Manager>
          <ID>210</ID>
          <GetItemURI>https://api.dovico.com/Employees/210/?version=7</GetItemURI>
          <Record>
            <ID>123</ID>
            <ExternalID />
            <Created>2026-04-24T17:17:19</Created>
            <Modified>2026-07-24T16:22:36</Modified>
            <LastName>Smith</LastName>
            <FirstName>John</FirstName>
            <EmployeeGroup>
              <ID>141</ID>
              <Name>Integrations Team</Name>
              <GetItemURI>https://api.dovico.com/Teams/141/?version=7</GetItemURI>
            </EmployeeGroup>
            <SecurityGroup>
              <ID>95</ID>
              <Name>Time and Expense Entry</Name>
              <GetItemURI>https://api.dovico.com/SecurityGroups/95/?version=7</GetItemURI>
            </SecurityGroup>
           <SoftwareAccess>T</SoftwareAccess>
            <Wage>0</Wage>
            <WageCurrency>
              <ID>-1</ID>
              <GetItemURI>N/A</GetItemURI>
              <Symbol>$</Symbol>
            </WageCurrency>
           <Charge>0</Charge>
            <ChargeCurrency>
              <ID>-1</ID>
              <GetItemURI>N/A</GetItemURI>
              <Symbol>$</Symbol>
            </ChargeCurrency>
            <ChargeChangedDate>2026-04-24T00:00:00</ChargeChangedDate>
            <StartDate>2026-04-27T00:00:00</StartDate>
            <EndDate>2100-12-31T00:00:00</EndDate>
            <Email>[email protected]</Email>
            <WorkDays>.MTWTF.</WorkDays>
            <Hours>7.5</Hours>
            <AltApproval>F</AltApproval>
            <NotificationTime>T</NotificationTime>
            <NotificationExpense>T</NotificationExpense>
            <NotificationRejected>T</NotificationRejected>
            <Archive>F</Archive>
            <Integrate>
              <INT />
            </Integrate>
            <CustomFields>
              <CustomField>
                <ID>164741</ID>
                <TemplateID>115</TemplateID>
                <Name>Sage Account</Name>
                <Values>
                  <Value>SMIT0001</Value>
                </Values>
                <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/115/?version=7</GetCustomTemplateURI>
              </CustomField>
            </CustomFields>
          </Record>
          <Name>Smith, John</Name>
        </Manager>
        <Project>
          <ID>3363</ID>
          <GetItemURI>https://api.dovico.com/Projects/3363/?version=7</GetItemURI>
          <Record>
            <ID>3363</ID>
            <Created>2023-11-23T17:02:48</Created>
            <Modified>2023-11-23T17:05:39</Modified>
            <Client>
              <ID>923</ID>
              <GetItemURI>https://api.dovico.com/Clients/923/?version=7</GetItemURI>
              <Name>ACME Ltd</Name>
            </Client>
            <Name>IT</Name>
            <Leader>
              <ID>123</ID>
              <GetItemURI>https://api.dovico.com/Employees/123/?version=7</GetItemURI>
              <Name>John Smith</Name>
            </Leader>
            <Description />
            <Status>1</Status>
            <ProjectGroup>
              <ID>0</ID>
              <Name>[None]</Name>
              <GetItemURI>N/A</GetItemURI>
            </ProjectGroup>
            <StartDate>2023-11-23T00:00:00</StartDate>
            <EndDate>2024-11-23T00:00:00</EndDate>
            <ProjectObjective>3</ProjectObjective>
            <BillingBy>1</BillingBy>
            <BillingByProjectRate>0</BillingByProjectRate>
            <FixedCosts />
            <BudgetedHoursType>1</BudgetedHoursType>
            <BudgetedHoursProjectHours>0</BudgetedHoursProjectHours>
            <Currency>
              <ID>-1</ID>
              <GetItemURI>N/A</GetItemURI>
              <Symbol>$</Symbol>
            </Currency>
            <BudgetRateDate>2023-11-23T00:00:00</BudgetRateDate>
            <HideTasks>F</HideTasks>
            <ExpensesBillableByDefault>T</ExpensesBillableByDefault>
            <Linked>F</Linked>
            <MSPConfig />
            <RSProject>F</RSProject>
            <Archive>F</Archive>
            <CustomFields>
              <CustomField>
                <ID>1</ID>
                <TemplateID>114</TemplateID>
                <Name>Sage Project</Name>
                <Values>
                  <Value>PROJ0001</Value>
                </Values>
                <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/114/?version=7</GetCustomTemplateURI>
              </CustomField>
            </CustomFields>
          </Record>
          <Name>IT</Name>
        </Project>
        <ExpenseCategory>
          <ID>173</ID>
          <GetItemURI>https://api.dovico.com/ExpenseCategories/173/?version=7</GetItemURI>
          <Record>
            <ID>173</ID>
            <Created>2023-05-18T13:31:50</Created>
            <Modified>2023-05-18T13:31:50</Modified>
            <Projects>
              <ProjectReference>
                <ID>0</ID>
                <GetItemURI>N/A</GetItemURI>
                <Name>[All]</Name>
              </ProjectReference>
            </Projects>
            <Name>IT Equipment</Name>
            <Unit>F</Unit>
            <CostPerUnit>0</CostPerUnit>
            <Currency>
              <ID>-1</ID>
              <GetItemURI>N/A</GetItemURI>
              <Symbol>$</Symbol>
            </Currency>
            <UnitDescription />
            <Description>Keyboards, monitors, etc.</Description>
            <Archive>F</Archive>
            <CustomFields />
          </Record>
          <Name>IT Equipment</Name>
        </ExpenseCategory>
        <Status>A</Status>
        <Date>2026-07-10T00:00:00</Date>
        <PurchaseOrder />
        <ReferenceNumber />
        <Quantity>14</Quantity>
        <CostPerUnit>0.5932</CostPerUnit>
        <Amount>8.3</Amount>
        <Currency>
          <ID>-1</ID>
          <GetItemURI>N/A</GetItemURI>
          <Symbol>$</Symbol>
        </Currency>
        <Markup>0</Markup>
        <FixedAmount>0</FixedAmount>
        <FixedCurrency>
          <ID>-1</ID>
          <GetItemURI>N/A</GetItemURI>
          <Symbol>$</Symbol>
        </FixedCurrency>
        <Tax1>0</Tax1>
        <Tax2>0</Tax2>
        <Description />
        <Reimbursable>T</Reimbursable>
        <Billable>T</Billable>
        <Attachment>
          <Name />
          <GetItemURI>N/A</GetItemURI>
        </Attachment>
        <Archive>F</Archive>
        <CustomFields>
          <CustomField>
            <ID>168579</ID>
            <TemplateID>106</TemplateID>
            <Name>Description</Name>
            <Values>
              <Value>IT Equipment</Value>
            </Values>
            <GetCustomTemplateURI>https://api.dovico.com/CustomFieldTemplates/106/?version=7</GetCustomTemplateURI>
          </CustomField>
        </CustomFields>
      </ExpenseEntry>
    </ExpenseEntries>
  </ExpenseSheet>
</ExpenseSheets>