Import User Quotas in Amount for Collaborative forecasting

In Customizable Forecast, we can add the Quota for user by navigating to User Page and going to Quota related list However in Collaborative Forecasting aka Forecast 3 the only way is using Data Loader.

1. Log-in to the Data Loader and use the Insert function.
2. Click “Show all Salesforce objects and select “Forecasting Quota (ForecastingQuota)”.
Note: Only Data Loader version 25 and above can be used for importing Quotas in Collaborative Forecasting
3. Select the import csv file and click Next (click OK in the pop-up that shows the number of records detected in the file).

Note: The import csv file should contain the following columns:

  • Currency ISO Code
  • Quota Amount
  • Owner ID
  • Quota Month (Start Date, In Date Format , 10/1/2013 – 1 Oct 2013)
Import Quota Using DataLoader
Import Quota Using DataLoader for Forecast 3

4. Click “Create or Edit a Map”.
5. Click “Auto-Match Fields to Columns” or drag-and-drop to specify field mapping.
6. Close the mapping window and click Next.
7. Select a directory on where the error and success files will be saved.
8. Click Finish.

Note : While importing quota, on safer side, don’t select date as first of any month instead use 2nd or 3rd of month. Otherwise, it may happen that Quota of February will be inserted in month of January.

After Importing Quota, you can see in Forecast Tab for that User.

Forecast In Forcasting 3
Forecast In Forcasting 3

You can see list of all supported currency by Salesforce here. (After writing this article, it might be possible that supported currencies are updated, so its suggested to visit Salesforce documentation)

You may also like to see my latest article on “Import User Quotas in Quantity (Unit) for Collaborative Forecasting“.





Related Posts


One response to “Import User Quotas in Amount for Collaborative forecasting”

  1. sudha Avatar

    thanks for this post.With the help this I m able to upload quota and I m getting quota values against all users in forecast tab.
    But I am not getting quota related list in user record.Could u help me with this problem.I have enabled allow forecasting also in user record.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Discover more from Jitendra Zaa

Subscribe now to keep reading and get access to the full archive.

Continue Reading