×

QuickBooks Chart of Accounts Import File and Directions

Click here to download a file that will create a fully configured Chart of Accounts in your new QuickBooks 2016 (or later) Company file. This chart of accounts is consistent with the National Restaurant Association "Uniform System of Accounts for Restaurants”.

Scroll down for information on our Restaurant Operators Complete Guide to QuickBooks.

Note: the download file is a ZIP file which will open to the file that you will import into QuickBooks (the import file is named restaurant-coa.iif).  The download file should first be saved to your computer's hard drive, and then "unzipped" by double clicking on it. 

Once the file is unzipped, open your QuickBooks software program and follow the directions below to 1) Create a new QuickBooks company file, and then 2) Import the .iif file into QuickBooks thereby creating your Chart of Accounts in this newly created file:

DIRECTIONS FOR QUICKBOOKS 2016 or later users:

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

2)  From the Opening Screen that appears select the “Other Options” button in the lower left portion of the window, then select “Advanced Setup”. See image below. DO NOT select the Start Setup button!


3)   Enter your company information.

4)   SKIP the Select Your Industry screen and select Next.

5)   Select the legal status of your business and select Next.

6)   Select the first month of your Fiscal Year and select Next.

7)   Setup your Administrative Password (Optional) then select Next.

8)   Create the new Company file by selecting Next.

9)   Select the location on your hard drive where the new company file will live (e.g. Documents). Then click SAVE.

10)   From the “Customize QuickBooks for Your Business” window select Next.

11) From the “What do you Sell” window make the appropriate selection, then select Next.

12) Click Yes to charge Sales Tax then select Next.

13) Make appropriate selections to the next few screens till you get to the Tracking Inventory in QuickBooks window. Select NO and then continue till you get to the Using Accounts in QuickBooks window, then select Next.

14) Select your Start Date from the options, then select Next.

15) From the Review Income & Expense Accounts window UNCLICK (De-select) all accounts that have a check mark in the left margin! Before proceeding make sure that no accounts are selected then select Next.

16) From the Congratulations window select “Go to Setup”.

17) Select the “Start Working” button.

18) From the QuickBooks menu (top left) select File|Utilities|Import|iif 



19)  Now select the file you downloaded in the first step of this process. Its name is restaurant-coa.iif. The file will be imported.


To view your new Chart of Accounts go the the QuickBooks Main Menu and select Lists|Chart of Accounts

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 forty year veteran of the restaurant business and currently a restaurant consultant, is a Certified QuickBooks Advisor and has been using QuickBooks since 1994.

Includes a "ready to use" QuickBooks company files. The file utilizes the Uniform System of Accounts for Restaurants format and includes 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 Restaurant Industry Operations Report to help you analyze your Operation.
 
"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...