Trying to import contributions. The data file has integer for Financial Type. Import fails Error File says: "Financial Type is not valid: 1"

Everything I have read said to enter the Financial Type Id. My data table for Financial Type has IDs 1,2,3,4,5 How can 1 not be valid?


We’ve hit this too in the past -> solution is to use the Name of the Financial Type. eg Donation (instead of 1). PS - Also match the case.

  • I followed your suggestion, and the problem was solved. Contrary to the documentation, the Financial Type is the Financial Type Name not the Financial Type ID. Thanks. May 7 '19 at 23:28
  • Exactly - glad it helped you out. May 8 '19 at 0:05
  • @BenBachrach - if you've found a bug in the documentation would be great if you can submit an update for that.
    – Aidan
    May 8 '19 at 8:22
  • I think it’s even _id in the header of that column in the import_errors csv file May 8 '19 at 12:01
  • @Aidan - where do we submit updates for the documentation? May 9 '19 at 7:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.