Quickbooks Chart of Accounts Import File

Our sample chart of accounts for restaurants has been downloaded many times, so we have made a Quickbooks version of the file available for download for $3.95.

The starting chart of accounts created in Quickbooks when you select the setup option for restaurants is minimal, and does not contain any detail food categories.

We have created two different variations our default chart of accounts in the Quickbooks format, one in a simple list and one that uses a sub-account structure. In the first file format, all accounts are listed without any parent account structure. In the second file, the inventory and expense accounts use sub accounts, so things like “Meat Inventory” and “Produce Inventory” are sub accounts of “Food Inventory” (see the example below).

Both files in IIF format can be downloaded for $3.95, paid with any major credit card.

If you ever decide you like SimpleRestaurantAccounting better than Quickbooks, we’ll credit your purchase toward any usage fees.

Regardless of which file you import, you can modify the sub account assignments after importing to suit your preferences. And of course you can change generic names like “Primary Bank Account” to match your own bank.

Please note that the files do not have the tax line assigned to each account, so you will need to review to proper assignments with your tax preparer if you want to link your Quickbooks data to any tax preparation software.

The following report, which you can also view as a PDF, shows the second file layout using sub-accounts. You can also view a PDF of the simple layout without sub-accounts.

Account Type Description
1010 · Bank Accounts Bank
1010 · Bank Accounts:1020 · Primary Bank
1010 · Bank Accounts:1030 · 2nd Bank
1010 · Bank Accounts:1060 · Merchant 1 Bank
1010 · Bank Accounts:1070 · Merchant 2 Bank
1100 · Accounts Receivable Accounts Receivable
1000 · Cash Other Current Asset
1080 · Undeposited Funds Other Current Asset
1200 · Food Inventory Other Current Asset Inventory of food and other meal ingredients
1200 · Food Inventory:1210 · Meat Other Current Asset
1200 · Food Inventory:1220 · Poultry Other Current Asset
1200 · Food Inventory:1230 · Seafood Other Current Asset
1200 · Food Inventory:1240 · Dairy Other Current Asset
1200 · Food Inventory:1250 · Produce Other Current Asset
1200 · Food Inventory:1260 · Bakery Other Current Asset
1200 · Food Inventory:1270 · Frozen Other Current Asset
1200 · Food Inventory:1280 · Grocery Dry & Canned Other Current Asset
1320 · Beverage Inventory Other Current Asset
1330 · Liquor Inventory Other Current Asset
1340 · Beer Inventory Other Current Asset
1350 · Wine Inventory Other Current Asset
1360 · Merchandise Inventory Other Current Asset
1380 · Bar & Consumable Inventory Other Current Asset
1500 · Fixed Assets Fixed Asset Furniture and equipment with useful life exceeding one year
1510 · Land & Building Fixed Asset
1520 · Automobile Fixed Asset
1530 · Furniture Fixtures & Equipment Fixed Asset
1540 · Leasehold Improvements Fixed Asset
1600 · Accumulated Depreciation Fixed Asset Accumulated depreciation on equipment, buildings and improvements
1700 · Capitalized Start Up Expenses Other Asset
1800 · Security Deposits Asset Other Asset Deposits and other returnable funds held by other entities (Rent, Utilities, etc.)
2000 · Accounts Payable Accounts Payable
2110 · Credit Card Credit Card
2210 · Sales Tax Payable Other Current Liability
2250 · Payroll Liabilities Other Current Liability
2280 · Employee Tips Payable Other Current Liability Tips collected by restaurant, payable to employees
2300 · Gift Cards & Certificates Other Current Liability
2350 · Customer Credits Other Current Liability
2400 · Notes Payable Long Term Liability
3000 · Opening Bal Equity Equity
3100 · Capital Stock Equity Value of corporate stock
3140 · Shareholder Distributions Equity Distributions paid to shareholders
3300 · Retained Earnings Equity Undistributed earnings of the business
4200 · Food Sales Income Food sales
4320 · Beverage Sales Income
4330 · Liquor Sales Income
4340 · Beer Sales Income
4350 · Wine Sales Income
4360 · Merchandise Sales Income
4500 · Catering & contracts Income
4700 · Other Operating Income Income
4900 · Discounts Income
9900 · Other Income-not from operation Income
5200 · Food Costs Cost of Goods Sold
5200 · Food Costs:5210 · Meat Cost of Goods Sold
5200 · Food Costs:5220 · Poultry Cost of Goods Sold
5200 · Food Costs:5230 · Seafood Cost of Goods Sold
5200 · Food Costs:5240 · Dairy Cost of Goods Sold
5200 · Food Costs:5250 · Produce Cost of Goods Sold
5200 · Food Costs:5260 · Bakery Cost of Goods Sold
5200 · Food Costs:5270 · Frozen Cost of Goods Sold
5200 · Food Costs:5280 · Grocery Dry & Canned Cost of Goods Sold
5320 · Beverage Cost Cost of Goods Sold
5330 · Liquor Cost Cost of Goods Sold
5340 · Beer Cost Cost of Goods Sold
5350 · Wine Cost Cost of Goods Sold
5360 · Merchandise Cost Cost of Goods Sold
5380 · Bar & Consumable Cost Cost of Goods Sold
5600 · Delivery & direct labor Cost Cost of Goods Sold
5700 · Merchant Account Fees Cost of Goods Sold Credit card merchant account discount fees, transaction fees, and related costs
5800 · Inventory Loss/Waste Cost of Goods Sold
6000 · Payroll Expenses Expense
6000 · Payroll Expenses:6100 · Management Wages Expense
6000 · Payroll Expenses:6200 · Staff Wages Expense
6000 · Payroll Expenses:6300 · Contract Labor Expense
6000 · Payroll Expenses:6400 · Commissions paid Expense
6000 · Payroll Expenses:6500 · Employee Benefits Expense
6000 · Payroll Expenses:6600 · Workers Comp Insurance Expense
6000 · Payroll Expenses:6700 · Payroll Taxes Expense
6000 · Payroll Expenses:6800 · Payroll Processing Expense
7100 · Direct Operating Expense Expense
7100 · Direct Operating Expense:7110 · China – Glassware – Flatware Expense
7100 · Direct Operating Expense:7120 · Restaurant & Kitchen Supply Expense
7100 · Direct Operating Expense:7130 · Cleaning Supply & Expense Expense
7100 · Direct Operating Expense:7140 · Decorations & Guest Supply Expense
7100 · Direct Operating Expense:7150 · Laundry – Linen – Uniforms Expense
7100 · Direct Operating Expense:7160 · Business Licenses and Permits Expense Business licenses, permits, and other business-related fees
7100 · Direct Operating Expense:7200 · Pest – Security – other contrac Expense
7100 · Direct Operating Expense:7250 · POS – Tech support – Online ser Expense
7100 · Direct Operating Expense:7300 · Advertising and Promotion Expense Advertising, marketing, graphic design and other promotional expenses
7100 · Direct Operating Expense:7320 · Promotional Events Expense
7100 · Direct Operating Expense:7400 · Automobile & travel Expense
7100 · Direct Operating Expense:7500 · Music and Entertainment Expense
7100 · Direct Operating Expense:7600 · Repairs and Maintenance Expense Incidental repairs and maintenance of business assets that do not add to the value …
7100 · Direct Operating Expense:7700 · Utilities Expense Water, electricity, garbage and other basic utilities expenses
7100 · Direct Operating Expense:7750 · Telephone & Internet Connection Expense Telephone bills and Internet connection charges
7800 · General and Administrative Expense
7800 · General and Administrative:7810 · Bad Debts – Over/short Expense
7800 · General and Administrative:7820 · Bank Service Charges Expense Bank account service fees, bad check charges and other bank fees
7800 · General and Administrative:7830 · Insurance Expense Insurance expenses
7800 · General and Administrative:7840 · Interest Expense Expense Interest on credit cards, AP, and long term debt
7800 · General and Administrative:7850 · Professional Fees Expense Payments to accounting professionals and attorneys for accounting or legal services
7800 · General and Administrative:7890 · Office Supplies Expense Office supplies expense
7800 · General and Administrative:8100 · Rent Expense Expense Rent paid for company offices or other structures used in the business
7800 · General and Administrative:8200 · Equipment Rental Expense
7800 · General and Administrative:8600 · Sales tax paid on purchases Expense
8700 · Amortization Expense
8760 · Depreciation Expense Expense Depreciation on equipment, buildings and improvements
8900 · Other expense Expense
9000 · Income Tax Expense
9500 · Gain/Loss on sale of assets Expense
9999 · Ask My Accountant Other Expense Transactions to be discussed with accountant or tax preparer

Purchase the IIF file download now.