excel-check-printing
excel-check-printing copied to clipboard
"check image is missing MICR number"
I printed a check on the recommended paper, and tried to deposit it using my bank's mobile application, but the app rejected the image, saying "The check image is missing MICR number".
I noticed on some other checks that I have that the check number actually comes after the routing and account numbers, not before. I also noticed that the other checks only have one instance of the c
symbol in the MICR line, just before the check number, but not also after like you had it. I also noticed that my other checks only have 4 digits for the check number, not 6 like you had it. I "corrected" all these things, and my bank's mobile app still rejected the check with the same message. Finally, I realized that my other checks have the MICR number fully aligned to the left, along with the other content on the check, so I moved the number to the left, and the app finally accepted the check.
To be clear, I changed the MICR cell formula from
=CONCATENATE("c", TEXT(F24, "000000"),"c a", F29, "a ", F30, "c ")
to
=CONCATENATE("a", F29, "a", F30, "c", TEXT(F24, "0000"))
And I moved that formula from cell D16
to cell B16
.
I humbly suggest that you make this change to the excel file hosted here.