The NPSP Data Import Template is a "flat file" structure designed to populate multiple objects in the NPSP data model simultaneously. Because NPSP uses a "Household-centric" model but also supports corporate and foundation giving, the Account fields in the template serve a dual purpose depending on the record being imported.
Business-related data (A): If the nonprofit is importing donations from a corporation, foundation, or local business, the "Account" fields in the template (such as Account Name, Account Phone, etc.) are used to create or match an Organization Account. This allows the consultant to track the entity's history and give them "Hard Credit" for their donations.
Household-related data (B): If the nonprofit is importing individual donors, the Account fields are used to define the Household Account. For example, if the template specifies "The Smith Household" in an Account field, NPSP logic will use that data to name the household record it creates for the associated contacts.
Address Logic (C): While addresses are part of an account, in the NPSP Data Importer, address data is typically handled by specific Address fields that NPSP then intelligently routes to the Household or the Contact record.
Employer Logic (D): Tracking an employer is usually handled via Affiliations. While the employer is an Account, the template has specific "Home" vs. "Work" logic to handle these relationships separately from the primary account being created.
In summary, the Account columns in the CSV template are the landing spot for any data related to the "Institutional" or "Household" entity that owns the donation or contains the contact.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit