June 4, 2013 
My excel template provides a simple means for an at-home business to keep books:
http://accountinator.com/2012/11/26/simple-accounting-spreadsheet-excel/
Here’s a new video to explain how to use it.
About Mark P. Holtzman
Chair of Accounting Department at Seton Hall University. PhD from The University of Texas at Austin. Worked at Deloitte's New York Office. BSBA from Hofstra University.9 Responses to “Directions on using my excel template”
Leave a Reply
The Accountinator
Mark P. Holtzman, PhD, CPA, Chair and Associate Professor of Accounting, Seton Hall University
Wall Street Journal Small Business
- An error has occurred; the feed is probably down. Try again later.
Reblogged this on Homepreneurs's Blog.
This is fantastic! By any chance do you have a version for Mac?
No, sorry. But the excel spreadsheet should import just fine onto the Mac.
your template say it has ‘frozen panes’ and we should ask to unlock them? can you explain?
Don’t unlock them unless you must.
Hello Mark, & thank you for taking the time to put together this spreadsheet for we spreadsheet novices..My (newly married) wife & I have a house we rent out, (her old one) & your excel worksheet seems ideal. But there are many columns that we have no need of, & when I went to print out my document, my printer spat out 43 pages!
Can you tell me how to remove the extraneous columns so I don’t waste so much paper? I tried to just delete a column, but got an error message that prevented me closing the program entirely for a while.
thanks for any suggestions you may have, Barry
Go to the top of each undesired column (where the letter is). Right-click it and select “hide.”
You know there should be a donate link so you could love a more comprehensive form and reports. Its a great addition to my new business but I would like to see it develop as time passes and would pay to do so.
Thanks in advance
Kirt
Thanks. I don’t think Excel or Google Docs is well-suited to keep more sophisticated records. If you need financial statements, billing, inventory management, etc., then it’s a good idea to get a real accounting program. If you’re averse to buying a commercial package, try GnuCash.