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 proceed.

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:

DIRECTIONS FOR QUICKBOOKS 2010 Users:

1.      From the QuickBooks Menu Bar select File...New Company

2.      Click on the "Skip Interview" box

3.      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"

4.      Now select the proper  the legal structure of your business in the "How is your company organized?" window and then click "Next"

5.      Select the fiscal year start month (e.g. most likely January) and click "Next"

6.      From the drop down window in the "Select your industry" window select "Other/None" (bottom of the list) and then click "Next"

7.      From the “Create your company file” window select “Next”

8.      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.)  

9.      Now you can "Import" the .IIF file that you have unzipped (The Uniform System of Accounts for Restaurants) into this new QB company file. 

10.  From the QuickBooks Menu Bar select File...Utilities...Import...IIF Files...

11.  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).

12.  From there select the .IIF file name which is "COA Restaurant.iif" and double click.

13.  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 publication....
  

Restaurant Operators
Complete Guide to QuickBooks, 2nd Edition

Order Now...

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 Operation.
 
Available in 2 formats:
- Downloadable E-book (PDF Adobe Acrobat format) $79.00
- 3 Ring Binder $89.00 (plus $9.95 shipping)

"The 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!"
John 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...

 

Restaurant Resource Group Homepage