Importing envelope numbers allows envelope numbers to be matched with individuals so that contributions can be added by only using the envelope number as the reference for who gave the contribution. While envelope numbers can be added individually, importing them allows multiple envelope numbers to be added at once.
When ready to import envelope numbers
- Navigate to the Account Settings (
) - Select " Bulk Tasks"
- Select "Import Giving Envelopes" (on the left)
- Download the template file and populate it with your data.
- Import the revised file using the "Import Envelopes" button. Use the key below for determining how to populate the data.
Note: Revised File simply means that you will need to delete out all of the blank fields (the people without envelope numbers). You can simply do this by sorting the Excel spread sheet, which will group all the blank fields together and delete them. Otherwise an error message will appear when importing your template.
| Field |
Options |
Examples |
|---|---|---|
| Breeze ID Breeze IDs can be obtained by exporting people after they've already been imported. Use the names column to cross-reference the rows to obtain the correct Breeze ID. If a person is not in the database, add them. If there’s a large number of people not in the database, bulk import them. Be sure that the person is not in the database with a slightly different name as creating them as a new person will create a duplicate person. If duplicates are created, they can be merged (individually).
|
Integer | 102301231 194202391 140293123 |
| First Name Technically speaking, the first name field is ignored by the import (the Breeze ID is the only identifier used). The first name field is for the benefit of the person constructing the import file.
|
String (optional) | Jack Lisa Sue Craig |
| Last Name Technically speaking, the last name field is ignored by the import (the Breeze ID is the only identifier used). The last name field is for the benefit of the person constructing the import file.
|
String (optional) | Anderson Smith Rogers Doe |
|
Envelope Number
|
Integer | 50 101 10003 |
Can giving information be imported by envelope number?
While this is not a current native feature within Breeze. You can easily Import Giving using Envelope #'s with this workaround in the linked article.