Remove the example data (checks, amounts, etc.).ĭo File → Save As. Make sure ALL the digits and all the symbols are visible. If you see actual letters A, a, and c, you have done it wrong. If you don’t see the numbers in a strange looking typeface (font), then you haven’t installed the MICR font properly. Notice, also in the formula bar, after the account number (Cell D20) there is the letter c. Those two letters create symbols at the start and end of your routing number. Notice that, in the formula bar, you will see the letter A, some numbers, and the letter a. Note that this is very often NOT the same as the routing number at the bottom of your checks. (Cells B15, B16, B17)įill in your deposit routing number (Cell A20) and account number (D20). It seems to be sufficient to put the name, city, state, and zip. Name, address, city, state, zip (Cells A4, A6, A8, A10)įill in your bank’s name and address. If you make it a custom XLTX (Excel template) with your own values, then you can save yourself a lot of changes each time you use it.įill in your account holder details.

It’s roughly the same shape and size as the reference ticket I used (from Wells Fargo née Wachovia).

The date is automatically filled in with today’s date, but you could easily just override that and type in any date you want.

The total line calculates automatically based on the subtotal minus the cash received line.The subtotal line calculates automatically.This can be 1, 2, or 3, depending on how many checks are listed. The “Total Items” field automatically totals up how many items there are.You can type in the amount of the check in the blanks (e.g., 123.45).I.e., you can enter check numbers (like where I typed “check #1234” You can type in the blanks next to the amounts.You will also need to download the MICR font (which is free) and install it. So here is my Excel template for a bank deposit ticket. We could just type in the values and let it add them up and all that. I find this funny because it’s a spreadsheet.

I haven’t investigated enough to figure out what it does, but as far as I can tell it is either meant to be filled out by QuickBooks (which its name implies) or it’s just meant to be printed and filled out by hand.

I downloaded it and discovered that the template doesn’t work on its own. It seemed to have all the right bits in place. I took a look online and didn’t find anything particularly satisfying, so I made my own.Ī post in a forum that looked pretty good. I have run out of deposit tickets from the back of my check books, and I resent the idea of having to pay for more to be printed. I do a lot of banking by mail-mainly depositing checks that I receive in the mail.

Quickbooks deposit slip template free