![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |