---
schema_version: "1"
id: 4b2a94a0dde004a0da4887200243bf46e9115fb62fe0c6873fb5071ea98c071b
title: Forecast Quotas from External Sources
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/forecasts3_loading_quota_data.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.forecasts3_loading_quota_data.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 4db8a20eaf1d3d033d36de94d809a7280c5b8cfd6cb16204666b2ad1dfdc238c
description: Data Loader provides a simple point-and-click method for adding, inspecting, and editing quota data in Salesforce. APIs provide more flexibility but require you to write code.
products:
  - Sales Cloud
release: "264"
---
# Forecast Quotas from External Sources

Data Loader provides a simple point-and-click method for adding, inspecting, and editing quota data in Salesforce. APIs provide more flexibility but require you to write code.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition">
        <colgroup>
          <col>
        </colgroup>
        <tbody>
          <tr class="">
            <td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic and Lightning Experience</td>

          </tr>
          <tr class="">
            <td class="slds-cell-wrap" style="vertical-align:top;">
              <p>Available in: <strong>Performance</strong> and <strong>Developer</strong> Editions and in
                <strong>Enterprise</strong> and <strong>Unlimited</strong> Editions with Sales
              </p>
              <p style="margin-bottom:0;">Available in:
                <strong>Professional</strong> Edition with the API Enabled permission
              </p>
            </td>

          </tr>
        </tbody>
      </table>

## Data Access and Availability

The data for quotas is stored in the ForecastingQuota object. Users who have access to import data and who have the Manage Quotas permission can update quota data for users below them in the forecast hierarchy. Users who have access to import data and also have the Manage Quotas and View All Forecast permissions can load data for all users in the forecast hierarchy.

## Data Preparation

Import quota data to the Forecasting Quota object using Data Loader. If you need more flexibility than what Data Loader provides, use Enterprise API. To use either method, ensure that API access is enabled and prepare a .csv file that contains these columns.

- User ID
- Forecast Type ID
- Quota Amount or Quota Quantity (depending on how you forecast)
- Currency Code
- Period Start Date (yyyy-mm-dd or yyyy-mm-ddThh:mm:ss.sssZ; for example, 2012–03–01T08:00:00.00Z)

If you use territory forecasts, include a Territory ID column. If you use product family forecasts, include a column for product family.

To help organize the .csv file, you can also include columns for Forecast Owner Name and Forecast Type Name, but those columns aren’t required. Here’s an example .csv file setup using Quota Amount and the additional columns added for organization purposes.

      
| User Name | User ID | Forecast Type Name | Forecast Type ID | Quota Amount | Currency Code | Start Date |
| --- | --- | --- | --- | --- | --- | --- |
| Kevin Bailey | 00599000000Hofh | OpportunityRevenue | 0DbD00000001eQBKAY | 250000 | USD | 2012–03–01 |
| Kevin Bailey | 00599000000Hofh | OpportunityRevenue | 0DbD00000001eQBKAY | 250000 | USD | 2012–04–01 |
| Kevin Bailey | 00599000000Hofh | OpportunityRevenue | 0DbD00000001eQBKAY | 250000 | USD | 2012–05–01 |

## Data Mapping

When you complete the import, map the columns in your .csv file to the ForecastingQuota object as shown in this table.

 
| Column Headers in CSV File | ForecastingQuota Fields |
| --- | --- |
| User ID | QuotaOwnerID |
| Quota Amount | QuotaAmount |
| Quota Quantity | QuotaQuantity |
| Currency Code | CurrencyIsoCode |
| Start Date | StartDate |
| Product Family (needed only when the forecast data source is Product Families) | ProductFamily |
| Forecast Type ID | ForecastingTypeID |
| Territory ID | Territory2ID |

## Additional Considerations for Loading Quota Data

As a best practice, load quota data in the quota owner’s [personal currency](https://help.salesforce.com/s/articleView?id=sales.forecasts3_definitions.htm&release=264.0.0&type=5 "If you’re using forecasting features in Salesforce, learn about the elements that comprise a forecast."). You can still upload quota data using the API even if **Show Quotas** is disabled. If your Data Loader time zone setting is ahead of quota owners’ time zones, the month can be off by one. To avoid this problem, use a date greater than or equal to the third day of each month when inserting quotas.

#### See Also

- [Define Forecasts Quotas in Salesforce Setup](https://help.salesforce.com/s/articleView?id=sales.forecasts3_quota_management_in_setup.htm&release=264.0.0&type=5 "Easily manage sales quotas without Data Loader or the API, and let your team see quotas on the forecasts page.")
- [Why do date fields import incorrectly when I use the Data Loader?](https://help.salesforce.com/s/articleView?id=xcloud.faq_import_general_wrong_date.htm&type=5&language=en_US)
- [Show Quotas in Forecasts](https://help.salesforce.com/s/articleView?id=sales.forecasts3_enabling_quotas_in_forecasts.htm&release=264.0.0&type=5 "Let your team see sales quotas and quota attainment percentages on the forecasts page.")