Checks, deposit tickets, forms, and more! Harland Clarke offers personal and business checks and check-related products. Shop for checks online using our secure ordering sites. 1-part tickets include 62 check entry lines (28 front, 34 back) plus cash and coin count on back. Multi-part tickets include 28 check entry lines (28 front), plus cash and coin count on back. Industry-best deposit tickets: Meet or exceed all bank standards for MICR processing, with guaranteed compatibility with today's latest technologies.

1. Bank Deposit Slips

I do a lot of banking by mail—mainly depositing checks that I receive in the mail. 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 took a look online and didn’t find anything particularly satisfying, so I made my own.

When I did a search online, I came to

• The deposit ticket or slip is then given to the bookkeeper to match up with the cash receipts journal. This internal control double-checks both the accuracy of the bookkeeper’s and banks records—not to mention it physically prevents someone from taking company funds and covering it up in the accounting system.
• Find the exact business deposit tickets for your business today! Menu SHOP DELUXE If you experience difficulty accessing content on ShopDeluxe, please contact us at 800-865-1913.

a post in a forum that looked pretty good. It seemed to have all the right bits in place. I downloaded it and discovered that the template doesn’t work on its own. 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 find this funny because it’s a spreadsheet. We could just type in the values and let it add them up and all that. That wasn’t useful enough for me.

My Solution

So here is my Excel template for a bank deposit ticket. You will also need to download the MICR font (which is free) and install it.

Features

• You can type in the blanks next to the amounts. I.e., you can enter check numbers (like where I typed “check #1234”
• You can type in the amount of the check in the blanks (e.g., 123.45)
• The “Total Items” field automatically totals up how many items there are. This can be 1, 2, or 3, depending on how many checks are listed.
• The subtotal line calculates automatically.
• The total line calculates automatically based on the subtotal minus the cash received line
• The date is automatically filled in with today’s date, but you could easily just override that and type in any date you want.
• It’s roughly the same shape and size as the reference ticket I used (from Wells Fargo née Wachovia)

Prepare the Template for First Use

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.

1. Fill in your account holder details. Name, address, city, state, zip (Cells A4, A6, A8, A10)

2. Fill in your bank’s name and address. It seems to be sufficient to put the name, city, state, and zip. (Cells B15, B16, B17)

3. Fill in your deposit routing number (Cell A20) and account number (D20). Note that this is very often NOT the same as the routing number at the bottom of your checks. For one possible reason why, see here.

4. Notice that, in the formula bar, you will see the letter A, some numbers, and the letter a. Those two letters create symbols at the start and end of your routing number. Keep them!

5. Notice, also in the formula bar, after the account number (Cell D20) there is the letter c. Keep it!

6. If you don’t see the numbers in a strange looking typeface (font), then you haven’t installed the MICR font properly. If you see actual letters A, a, and c, you have done it wrong.

7. Make sure ALL the digits and all the symbols are visible.

8. Remove the example data (checks, amounts, etc.).

9. Do File → Save As. and save it as an Excel Template (xltx). Make sure it’s in the My Templates area. Now, when you choose to create a new Excel Spreadsheet (via File → New from Template.) this template will be available each time. No deposit free spins bingo sites.

Using It Normally

It’s just a normal deposit ticket now. Just fill it out as necessary. You can either use the New from Template feature of Excel, or you can double-click the XLTX file. It will create a copy (so you’re not changing the template permanently). Once you have it open, you just fill in the values.

1. Check the date. If Today is ok, leave it alone.
2. Enter the cash amount (Cell H2)
3. Enter the check numbers or identifiers (cells F4, F6, F8, as necessary)
4. Enter the corresponding amounts for the checks (cells H4, H6, H8 as necessary)
5. Check that the subtotal is calculating correctly
6. Enter any cash you plan to receive
7. Double-check the total
8. File → Print

Done.

DEP-PER01 Jackpot party casino on facebook.

These Personal Deposit Tickets are bound and stitched in the same manner as personal check pads and sold by the box. The ticket mimics that of which is included in the back of every personal check pad and are available in single or duplicate formats. These deposit tickets allow you to record 17 transactions. Books of deposit tickets are bound 25 to a pad. Size: 6' X 2 3/4'

Bank Deposit Slips