excel-check-printing icon indicating copy to clipboard operation
excel-check-printing copied to clipboard

"check image is missing MICR number"

Open feuGeneA opened this issue 4 months ago • 0 comments

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.

feuGeneA avatar Mar 27 '24 18:03 feuGeneA