Click here to Download a file that will create a fully
configured Chart of Accounts in a your new QuickBooks
2010 or later Company file consistent
with the "Uniform System of Accounts" for Restaurants. Scroll down
for information on our Restaurant Operators
Complete Guide to QuickBooks.
Note: the download file is an executable
WinZip file which, when "unzipped" will produce the file that
you will import into QuickBooks (the import file is named
COA_Restaurant.iif). The download file
should first be saved to your computer's hard drive, and then
"unzipped" by double clicking on it. Follow the directions from the
"WinZip Self Extraction Utility" window that will appear when you
Once the file is unzipped, open the QuickBooks software and follow
the directions below to 1) Create a new QuickBooks company file, and
2) Import the .iif file into QuickBooks
thereby creating your Chart of Accounts in this newly created file:
QUICKBOOKS 2010 Users:
QuickBooks Menu Bar select File...New Company
Click on the
"Skip Interview" box
From the "Enter
Your Company Information" screen input the name of the restaurant,
and any other information that is readily available to you (you can
return to this window later). When finished click "Next"
Now select the
proper the legal structure of your business in the "How is your
company organized?" window and then click "Next"
Select the fiscal
year start month (e.g. most likely January) and click "Next"
From the drop
down window in the "Select your industry" window select "Other/None"
(bottom of the list) and then click "Next"
From the “Create
your company file” window select “Next”
The final window
will be named “Filename for New Company". Make sure that you pay
attention to the “Save in” box at the top of the window as this will
define the path of the directory where your new company file will be
saved. You can change this directory to suit your needs. The file
name below will be the same as the company name you entered in Step
3. You can change the file name to suit your needs just as you
change the directory where it is saved. Note that the name you enter
in Step 3 is used for all QuickBooks reports (display and printed),
and is not necessarily the name of the file itself (though the names
will be the same if you do not change in this window.)
Now you can
"Import" the .IIF file that you have unzipped (The Uniform System of
Accounts for Restaurants) into this new QB company file.
QuickBooks Menu Bar select File...Utilities...Import...IIF Files...
The Import Window
will open and from the small "Look in" window select the location on
your computer's hard drive (or external drive) where the downloaded
.IIF file has been placed (when you unzipped it).
From there select
the .IIF file name which is "COA Restaurant.iif" and double click.
The file will be
imported and your new QuickBooks company file is now ready to use.
You should see a message that reads "Your data has been imported"
Note: In order to
insure that you new Chart of Accounts functions in the way it was
intended be sure to activate the QuickBooks account numbering option
using QuickBooks Preferences (from the Menu Bar select
Edit...Preferences. Now select the Accounting icon on the left side
of the Preference Screen and then select the Company Preferences
Tab. Check the box that reads "Use Account Numbers". Also check the
box directly below that reads "Show lowest subaccount only")
Restaurant Accounting made easy with this
Complete Guide to QuickBooks, 2nd Edition
A detailed step-by-step guide to the most popular small
business accounting software program. Written exclusively for
restaurant operators, in a jargon free and easy to understand
style. The author, John Nessel, a twenty-five year veteran of
the restaurant business and currently a restaurant consultant,
is a Certified QuickBooks Advisor and has been using
QuickBooks since 1994.
Includes "ready to use" QuickBooks company files for both full
service and quick service restaurant operations. Each file
utilizes the Uniform System of Accounts for Restaurants format
along with numerous customized features, entry screens,
memorized transactions and reports, all designed to get you
"up and running" quickly and accurately!
The guide also includes operating ratios from the 2001
Restaurant Industry Operations Report to help you analyze your
Available in 2 formats:
- Downloadable E-book (PDF Adobe Acrobat format) $79.00
- 3 Ring Binder $89.00
(plus $9.95 shipping)
QuickBooks guide is awesome! I was familiar with a lot of the
procedures but I can tell you that I will be using the Full
Service Chart of Accounts and input procedures described. I
knew I was doing things "wrong" but I just wasn't sure how to
clear it all up and your guide has helped tremendously."
Josh Devane, Devane's Italian Restaurant, Indio, CA
"Restaurant Resource Group
provided me with priceless information and guidance, enhancing
my current QuickBooks/Excel system. John’s approach to
QuickBooks is streamlined and to the point, and his ability to
write a software/accounting guide that is down-to-earth and
informative is cleverly entertaining. Yes, I said
entertaining...It's obvious he has done his homework! Grazia! "
David Militello, Tello's Trattoria, South Haven, MI
"John Nessel's guide turns
QuickBooks into an ideal restaurant accounting program. It's
logically organized, easy to follow and covers almost any
possible contingency. This book will save you time & will keep
your accounting headaches to a minimum. This has been one
of the better
purchases I've made!"
Agress, Tropical Treateries LLC, Estero, FL
"I am finally reading through the Restaurant Operator's Guide
to QuickBooks and looking at your memorized transaction
templates after purchasing the book awhile ago. It is sooooo
valuable. Thanks so much for doing this. I am familiar with
accounting concepts and used Peachtree for another business
years ago (the old DOS version!!) but your guide is a HUGE
timesaver for the setup and learning curve. I especially love
your notes and cautions."
Robin Saunders Ryan, The
Saunders Group, Chaska, MN
"I’ve tried several times to
use QuickBooks for my restaurant, but could never get it setup
to do what I wanted it to do. I have had QuickBooks for
several years and was giving it one last try! I was looking on
the Internet for information on General Ledger account numbers
for restaurants because the ones in QuickBooks just don’t
work, and I found YOUR site. After downloading and reading
your guide I knew it was what I had been looking for. It is
written so that “we” can understand, and it answers all those
questions I had on using QuickBooks in the restaurant
industry. I now have one less thing to turn gray over. Running
a restaurant is a life style, and this guide just made our
life a little easier THANK YOU!"
John and Kathi Leeds, CM Tuggs Grub n Pub, Port Deposit, MD
Click Here For More Information or to Order Now...