Importing Bonds without Serial Numbers
I’ve received a few questions from people about how to import Savings Bonds from other programs where they haven’t entered their complete Serial Numbers. For example, they may only have the series and denomination instead of a complete serial number such as M555123456EE.
If you’ve got a CSV file to work with, you can open it using Excel, Numbers, CSVEdit, or any text editor of your choice. If you don’t want to enter the actual digits of the serial number from the front of your paper bond, you can simply use zeros instead, with the correct prefixes and suffixes.
The denomination codes are:
- 50 = L
- 75 = K
- 100 = C
- 250 = R
- 500 = D
- 1000 = M
- 5000 = V
- 10000 = X
The series codes are:
- E Bond = E
- EE Bond = EE
- I Bond = I
So for example if you have a $100 I bond without the serial number digits, you can edit the CSV file so that the Serial Number field for the bond reads “C00000000I”.