Exporting Exchange Rates From Quickbooks Online

This task will download exchange rates from Quickbooks Online to an XML file.

Note

Quickbooks keeps a historical record of the exchange rate for all currencies on a daily basis. So if the task is configured to export all, it will output an extremely large number of records. We recommend using the following approaches:
1. Configuring the task to export modified records. This means it will output the latest exchange rates, but only when they change.
2. Configuring the task to export all records, and using the filter setting to specify a particular date to export e.g. asofdate='2026-06-03'. This means it will output the exchange rates for the given date every time it runs.
3. Configuring the task to export all records, and using the filter setting to specify today's date using Razor e.g. asofdate='@(DateTime.Now.ToString("yyyy-MM-dd"))'. This means it will output the current exchange rates every time it runs.

Download Exchange Rates

Connection

Required
Select a connection to the Quickbooks Online company you want to use. See Connecting to QuickBooks Online

Export Settings -> Date Created

Required
When the 'Export Modified, New or All Records' setting is set to 'New', only records created after this date will be exported. The date will update automatically each time the task runs, to ensure that only records created since the task last ran will be exported.

Export Settings -> Date Modified

Required
When the 'Export Modified, New or All Records' setting is set to 'Modified', only records created or updated after this date will be exported. The date will update automatically each time the task runs, to ensure that only records modified since the task last ran will be exported.

Export Settings -> Export Modified, New or All Records

Required
Used to choose which records should be included in the export. The available options are:

All - All records will be exported, regardless of whether or not they have been created or updated since the task last ran.
New - Only records created since the task last ran will be exported.
Modified - Only records created or updated since the task last ran will be exported.

Filter

Optional
Allows a filter to be set to limit the data that is returned. The following operators are supported by Quickbooks Online:

Equals (e.g. CustomerRef = '123')
Greater than (e.g. TxnDate > '2016-01-01')
Greater than or equal to(e.g. TxnDate >= '2016-01-01')
Less than (e.g. TxnDate < '2016-01-01')
Less than or equal to (e.g. TxnDate <= '2016-01-01')
In (e.g. CustomerId IN ('1', '2'))
Like (e.g. GivenName LIKE 'Fred%')
And (e.g. Active = true AND GivenName LIKE 'Fred%')

Output File

Required
The file save exported records to.

Page Size

Required
The number of records to include in each page of results exported from Quickbooks. Increasing this value will speed up the export, but will use more memory. Defaults to 1000.

Zynk Settings

See Common Task Settings

Available Filters

AsOfDate
Rate
SourceCurrencyCode
TargetCurrencyCode

Examples

Sample output file:

<?xml version="1.0" encoding="utf-8"?>
<ArrayOfExchangeRate
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <RecordOfExchangeRate>
    <Data xmlns="http://schema.intuit.com/finance/v3">
      <MetaData>
        <LastUpdatedTime>2026-06-03T12:01:08Z</LastUpdatedTime>
      </MetaData>
      <SourceCurrencyCode>EUR</SourceCurrencyCode>
      <TargetCurrencyCode>GBP</TargetCurrencyCode>
      <Rate>0.863632</Rate>
      <AsOfDate>2026-06-03T00:00:00Z</AsOfDate>
    </Data>
  </RecordOfExchangeRate>
  <RecordOfExchangeRate>
    <Data xmlns="http://schema.intuit.com/finance/v3">
      <MetaData>
        <LastUpdatedTime>2026-06-03T12:01:08Z</LastUpdatedTime>
      </MetaData>
      <SourceCurrencyCode>USD</SourceCurrencyCode>
      <TargetCurrencyCode>GBP</TargetCurrencyCode>
      <Rate>0.743329</Rate>
      <AsOfDate>2026-06-03T00:00:00Z</AsOfDate>
    </Data>
  </RecordOfExchangeRate>
</ArrayOfExchangeRate>