Excel Sample Sheet 42181 | Nra Revised Coa

Partial file snippet.
Sheet 1: NRA Revised COA

	
	
	
	
	
	
	
	
		Account Number
		Account Name
		GL Type
		Parent Account
		Available to Managers
		Disable Entry
		Description
	
	
		1000
		Cash
		Current Asset
		

		No
		Yes
		

	
	
		1010
		Change and Petty Cash
		Current Asset
		Cash
		No
		No
		

	
	
		1020
		Checking 1
		Current Asset
		Cash
		No
		No
		Bank account used in R365.  Each bank account will need to reside on the GL as a GL Account (checking and savings)
	
	
		1025
		Checking 2
		Current Asset
		Cash
		No
		No
		Bank account used in R365.  Each bank account will need to reside on the GL as a GL Account (checking and savings)
	
	
		1090
		Undeposited Funds
		Current Asset
		Cash
		No
		No
		Undeposited Funds account (cash in transit) used in R365 to post pending cash disbursements that will later be posted to their respective cash accounts
	
	
		1100
		Intercompany
		Current Asset
		

		No
		No
		

	
	
		1110
		Due to/from Company 1
		Current Asset
		Intercompany
		No
		No
		Intercompany account used in R365 for automatic intercompany entries.  Replace 'Company #' with Legal Entity Name
	
	
		1120
		Due to/from Company 2
		Current Asset
		Intercompany
		No
		No
		Intercompany account used in R365 for automatic intercompany entries.  Replace 'Company #' with Legal Entity Name
	
	
		1130
		Due to/from Company 3
		Current Asset
		Intercompany
		No
		No
		Intercompany account used in R365 for automatic intercompany entries.  Replace 'Company #' with Legal Entity Name
	
	
		1210
		Accounts Receivable
		Current Asset
		

		No
		No
		

	
	
		1220
		A/R - Door Dash
		Current Asset
		Accounts Receivable
		No
		No
		

	
	
		1260
		Other Receivables
		Current Asset
		

		No
		No
		

	
	
		1270
		Vendor Credit Expected
		Current Asset
		Other Receivables
		No
		No
		Credit Expected account.  A system requirement in R365, used to post pending credits from vendors
	
	
		1300
		Inventory
		Current Asset
		

		No
		Yes
		

	
	
		
		[Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:
    Matching Consideration for Prime Costs : COGS
		1310
		Food Inventory
		Current Asset
		Inventory
		No
		No
		

	
	
		1312
		Produce Inventory
		Current Asset
		Food Inventory
		No
		No
		

	
	
		1314
		Dairy Inventory
		Current Asset
		Food Inventory
		No
		No
		

	
	
		1322
		Meat Inventory
		Current Asset
		Food Inventory
		No
		No
		

	
	
		1324
		Pork Inventory
		Current Asset
		Meat Inventory
		No
		No
		

	
	
		1326
		Beef Inventory
		Current Asset
		Meat Inventory
		No
		No
		

	
	
		1328
		Poultry Inventory
		Current Asset
		Meat Inventory
		No
		No
		

	
	
		1330
		Soft Beverages Inventory
		Current Asset
		Inventory
		No
		No
		

	
	
		1335
		Alcohol Inventory
		Current Asset
		Inventory
		

		

		

	
	
		1340
		Liquor Inventory
		Current Asset
		Alcohol Inventory
		No
		No
		

	
	
		1345
		Beer Inventory
		Current Asset
		Alcohol Inventory
		No
		No
		

	
	
		1350
		Wine Inventory
		Current Asset
		Alcohol Inventory
		No
		No
		

	
	
		1360
		Paper Products Inventory
		Current Asset
		Inventory
		No
		No
		

	
	
		1370
		Merchandise Inventory
		Current Asset
		Inventory
		No
		No
		

	
	
		1400
		Prepaid Expenses
		Current Asset
		

		No
		Yes
		

	
	
		1410
		Prepaid Insurance
		Current Asset
		Prepaid Expenses
		No
		No
		

	
	
		1420
		Prepaid Taxes
		Current Asset
		Prepaid Expenses
		No
		No
		

	
	
		1430
		Prepaid Licenses
		Current Asset
		Prepaid Expenses
		No
		No
		

	
	
		1440
		Other Prepaid
		Current Asset
		Prepaid Expenses
		No
		No
		

	
	
		1510
		Land
		Fixed Asset
		

		No
		No
		

	
	
		1520
		Building
		Fixed Asset
		

		No
		No
		

	
	
		1530
		Leasehold Improvement Assets
		Fixed Asset
		

		No
		No
		

	
	
		1540
		Furniture and Equipment Assets
		Fixed Asset
		

		No
		No
		

	
	
		1550
		Automobiles and Trucks
		Fixed Asset
		

		No
		No
		

	
	
		1560
		Construction in Progress
		Fixed Asset
		

		No
		No
		

	
	
		1590
		Accumulated Depreciation
		Fixed Asset
		

		No
		No
		

	
	
		1620
		Capitalized Org Costs
		Other Asset
		

		No
		No
		Organizational costs are incurred when organizing a business and establishing the legal entity. Examples of organization costs are legal services, filing fees and stock issuance record costs. Costs incurred prior to the opening of a restaurant, such as management wages, training of employees, food, beverages, restaurant supplies and similar operating expenses may be immediately expensed or recorded as preopening costs and amortized over a 12 month period.
	
	
		1630
		Preopening Expenses
		Other Asset
		

		No
		No
		

	
	
		1640
		Liquor (Beverage) License
		Other Asset
		

		No
		No
		

	
	
		1650
		Other Assets
		Other Asset
		

		No
		No
		

	
	
		2110
		Accounts Payable
		Current Liability
		

		No
		No
		

	
	
		2120
		Other Payables
		Current Liability
		

		No
		No
		

	
	
		2125
		Tips Payable
		Current Liability
		

		No
		No
		

	
	
		2205
		Payroll Taxes Payable
		Current Liability
		

		No
		Yes
		

	
	
		2210
		FICA Taxes Payable
		Current Liability
		Payroll Taxes Payable
		No
		No
		

	
	
		2220
		FUTA Payable
		Current Liability
		Payroll Taxes Payable
		No
		No
		

	
	
		2230
		SUTA Payable
		Current Liability
		Payroll Taxes Payable
		No
		No
		

	
	
		2310
		Sales Tax Payable
		Current Liability
		

		No
		No
		

	
	
		2320
		Alcoholic Beverage Taxes Payable
		Current Liability
		Sales Tax Payable
		No
		No
		

	
	
		2405
		Accrued Expenses
		Current Liability
		

		No
		Yes
		

	
	
		2410
		Accrued Payroll
		Current Liability
		Accrued Expenses
		No
		No
		Accrued Payroll offset account used in the R365 for automatic payroll accruals (when POS labor imports are utilized)
	
	
		2420
		Accrued Vacation and Sick Leave
		Current Liability
		Accrued Expenses
		No
		No
		

	
	
		2430
		Accrued Rent
		Current Liability
		Accrued Expenses
		No
		No
		

	
	
		2440
		Accrued Percentage Rent
		Current Liability
		Accrued Expenses
		No
		No
		

	
	
		2450
		Accrued Interest Payable
		Current Liability
		Accrued Expenses
		No
		No
		

	
	
		2460
		Accrued Real Estate Taxes
		Current Liability
		Accrued Expenses
		No
		No
		

	
	
		2470
		Accrued Personal Property Taxes
		Current Liability
		Accrued Expenses
		No
		No
		

	
	
		2480
		Accrued Utilities
		Current Liability
		Accrued Expenses
		No
		No
		

	
	
		2490
		Other Accrued Liabilities
		Current Liability
		Accrued Expenses
		No
		No
		

	
	
		2505
		Other Liabilities
		Current Liability
		

		No
		Yes
		

	
	
		2510
		Gift Certificates Outstanding
		Current Liability
		Other Liabilities
		No
		No
		

	
	
		2520
		Customer Deposits
		Current Liability
		Other Liabilities
		No
		No
		

	
	
		2530
		Employee Deposits
		Current Liability
		Other Liabilities
		No
		No
		

	
	
		2540
		Charge Tips Withheld
		Current Liability
		Other Liabilities
		No
		No
		

	
	
		2705
		Notes Payable
		Long Term Liability
		

		No
		Yes
		

	
	
		2710
		Note Payable - Building
		Long Term Liability
		Notes Payable
		No
		No
		

	
	
		2720
		Note Payable - Equipment
		Long Term Liability
		Notes Payable
		No
		No
		

	
	
		2730
		Capital Leases Payable
		Long Term Liability
		Notes Payable
		No
		No
		

	
	
		2740
		Less, Current Portion of Notes Payable
		Long Term Liability
		Notes Payable
		No
		No
		

	
	
		3100
		Common Stock
		Equity
		

		No
		No
		

	
	
		3200
		Paid in Capital
		Equity
		

		No
		No
		

	
	
		3300
		Retained Earnings
		Equity
		

		No
		No
		

	
	
		4110
		Food Sales
		Sales
		

		No
		No
		

	
	
		4130
		Soft Beverage Sales
		Sales
		

		No
		No
		

	
	
		4135
		Alcohol Sales
		Sales
		

		

		

		

	
	
		4140
		Liquor Sales
		Sales
		Alcohol Sales
		No
		No
		

	
	
		4145
		Beer Sales
		Sales
		Alcohol Sales
		No
		Yes
		

	
	
		4150
		Wine Sales
		Sales
		Alcohol Sales
		No
		No
		

	
	
		4170
		Merchandise & Other Sales
		Sales
		

		No
		Yes
		

	
	
		4610
		Merchandise Sales
		Sales
		Merchandise & Other Sales
		No
		No
		

	
	
		4710
		Banquet Room Rental Income
		Sales
		Merchandise & Other Sales
		No
		No
		

	
	
		
		[Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:
    At least ONE Comps and Discounts Account
		4800
		Comps & Discounts
		Sales
		

		No
		Yes
		

	
	
		4805
		Employee Meals
		Sales
		Comps & Discounts
		No
		No
		

	
	
		4810
		Comps
		Sales
		Comps & Discounts
		No
		No
		

	
	
		4815
		Discounts
		Sales
		Comps & Discounts
		No
		No
		

	
	
		
		[Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:
    Matching Consideration to Inventory Accounts Above
		5110
		Food Cost
		Prime Cost
		

		Yes
		Yes
		

	
	
		5112
		Produce Cost
		Prime Cost
		

		Yes
		No
		

	
	
		5114
		Dairy Cost
		Prime Cost
		

		Yes
		No
		

	
	
		5122
		Meat Cost
		Prime Cost
		

		Yes
		No
		

	
	
		5124
		Pork Cost
		Prime Cost
		Meat Cost
		Yes
		No
		

	
	
		5126
		Beef Cost
		Prime Cost
		Meat Cost
		Yes
		No
		

	
	
		5128
		Poultry Cost
		Prime Cost
		Meat Cost
		Yes
		No
		

	
	
		5130
		Soft Beverages Cost
		Prime Cost
		

		Yes
		No
		

	
	
		5135
		Alcohol Cost
		Prime Cost
		

		Yes
		No
		

	
	
		5140
		Liquor Cost
		Prime Cost
		Alcohol Cost
		Yes
		No
		

	
	
		5145
		Beer Cost
		Prime Cost
		Alcohol Cost
		Yes
		No
		

	
	
		5150
		Wine Cost
		Prime Cost
		Alcohol Cost
		Yes
		No
		

	
	
		5160
		Paper Products Cost
		Prime Cost
		

		Yes
		No
		

	
	
		5170
		Merchandise Cost
		Prime Cost
		

		Yes
		No
		

	
	
		
		[Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:
    Is this as specific as we want?
		6105
		Salaries and Wages
		Labor Cost
		

		No
		Yes
		

	
	
		6110
		Management Wages
		Labor Cost
		Salaries and Wages
		No
		No
		

	
	
		6120
		FOH Wages
		Labor Cost
		Salaries and Wages
		No
		No
		

	
	
		6130
		BOH Wages
		Labor Cost
		Salaries and Wages
		No
		No
		

	
	
		6150
		Payroll Expenses
		Labor Cost
		

		

		

		

	
	
		6300
		Employee Benefits
		Labor Cost
		Payroll Expenses
		No
		Yes
		

	
	
		6310
		Payroll Taxes  
		Labor Cost
		Employee Benefits
		No
		Yes
		

	
	
		6312
		Federal Payroll Taxes
		Labor Cost
		Payroll Taxes  
		No
		No
		

	
	
		6314
		Federal Unemployment Tax
		Labor Cost
		Payroll Taxes  
		No
		No
		

	
	
		6316
		State Unemployment Tax
		Labor Cost
		Payroll Taxes  
		No
		No
		

	
	
		6318
		State Health Insurance Tax
		Labor Cost
		Payroll Taxes  
		No
		No
		

	
	
		6320
		Other Payroll Taxes
		Labor Cost
		Payroll Taxes  
		No
		No
		

	
	
		6330
		Insurance and Retirement
		Labor Cost
		Employee Benefits
		No
		Yes
		

	
	
		6332
		Disability Insurance
		Labor Cost
		Insurance and Retirement
		No
		No
		

	
	
		6334
		Employer Contributions
		Labor Cost
		Insurance and Retirement
		No
		No
		

	
	
		6336
		Life Insurance
		Labor Cost
		Insurance and Retirement
		No
		No
		

	
	
		6346
		Worker's Comp
		Labor Cost
		Insurance and Retirement
		No
		No
		

	
	
		6350
		Employee Benefits - Other
		Labor Cost
		Payroll Expenses
		No
		Yes
		

	
	
		6360
		Other Employee Expenses
		Labor Cost
		Employee Benefits - Other
		No
		No
		

	
	
		6362
		Employee Gifts and Parties
		Labor Cost
		Employee Benefits - Other
		Yes
		No
		

	
	
		6364
		Employee Sports Activities
		Labor Cost
		Employee Benefits - Other
		Yes
		No
		

	
	
		6366
		Medical Expenses
		Labor Cost
		Employee Benefits - Other
		No
		No
		

	
	
		6368
		Credit Union
		Labor Cost
		Employee Benefits - Other
		No
		No
		

	
	
		6370
		Awards and Prizes Cost
		Labor Cost
		Employee Benefits - Other
		Yes
		No
		

	
	
		6372
		Transportation
		Labor Cost
		Employee Benefits - Other
		No
		No
		

	
	
		7100
		Direct Operating Expense
		Operating Expense
		

		No
		Yes
		

	
	
		7105
		Auto or Truck Expense
		Operating Expense
		Direct Operating Expense
		Yes
		No
		Maintenance, fuel, licenses, repairs and similar expenses for delivery autos and trucks
	
	
		7110
		Banquet Expense
		Operating Expense
		Direct Operating Expense
		Yes
		No
		Included in this account are expenses incurred in connection with banquets and catering functions which cannot be properly included in other expense accounts. Such items would be chair or equipment rental, party favors, decorations. If clients are billed separately for items rented, those rental costs should be coded to the Banquet and Catering-Equipment Rental Cost account and the income billed for such rentals, in "Other Operating Income."
	
	
		7115
		Bar Utensils and Supplies
		Operating Expense
		Direct Operating Expense
		Yes
		No
		Corkscrews, mixers, bottle openers, shakers, spoons, fruit squeezers, fancy drink decorations, measuring rules, knives, strainers, bottle stoppers, swizzle sticks, toothpicks, gratis food (such as nuts popcorn, souvenirs, chips)
	
	
		7120
		Cleaning Supplies
		Operating Expense
		Direct Operating Expense
		Yes
		No
		Cleaning fluid, cleaning compounds, polish, soap, detergent, disinfectant, cleaning chemicals, deodorant, trash cans, tissue and toilet paper, brooms and sweepers, mops, brushes, cleaning cloths, dust cloths, pails, rags, steel wool, trash liners, wool dusters
	
	
		7125
		Contract Cleaning
		Operating Expense
		Direct Operating Expense
		Yes
		No
		The cost of service contracts for night cleaning, hood and duct cleaning, deep-cleaning kitchen and equipment, window washing, carpet shampoo and floor cleaning, disinfecting and any other cleaning-related services.
	
	
		7130
		Equipment / Other Rentals
		Operating Expense
		Direct Operating Expense
		Yes
		No
		The cost of short-term rentals not associated with banquets, parties and catering functions. Examples would include seasonal rental of frozen drink dispensers, tents, dance floors and similar items.
	
	
		7145
		Glassware
		Operating Expense
		Direct Operating Expense
		Yes
		No
		

	
	
		7155
		Kitchen Utensils and Supplies
		Operating Expense
		Direct Operating Expense
		Yes
		No
		This account includes the cost of replacing tools and small equipment used in the kitchen and the cost of their repair, including knife sharpening and soldering, as well as kitchen supplies. These items generally would be under the control of the chef, kitchen manager or other kitchen employees.
	
	
		7165
		Linen and Linen Rental
		Operating Expense
		Direct Operating Expense
		Yes
		No
		Rental service cost for linen that is rented along with the replacement cost of linen items such as napkins, tablecloths, doilies, table tops, table protectors, side towels
	
	
		7170
		Menus and Drink Lists
		Operating Expense
		Direct Operating Expense
		Yes
		No
		The cost of design, art work, cuts paper stock, covers and the printing of menus and beverage lists, whether they are purchased from the outside or prepared by restaurant personnel, should be included in this category.
	
	
		7175
		Miscellaneous Expense
		Operating Expense
		Direct Operating Expense
		Yes
		No
		This account includes all items attributable directly to the service of the customer that cannot be classified under other accounts, such as the cost of laboratory tests or lost and damaged articles.
	
	
		7180
		Paper and Packaging
		Operating Expense
		Direct Operating Expense
		Yes
		No
		In full-service restaurants, this account would include the cost of the following products: cups, straws, napkins, plates, bags, table covers, boxes, wrapping paper, takeout containers, disposable table covers / skirting. This would also include any and all materials that make up the containers, cups, lids, wrapping paper, napkins, bags and other nonfood products used when food and beverages are sold to the customer.
	
	
		7185
		Parking
		Operating Expense
		Direct Operating Expense
		Yes
		No
		Parking space for customers' automobiles is vital to most restaurants. Any parking lot rental, garage or other cost in connection with the parking of customers' cars should be included in this account.
	
	
		7190
		Pest Control
		Operating Expense
		Direct Operating Expense
		Yes
		No
		

	
	
		7192
		Tableware and Smallwares
		Operating Expense
		Direct Operating Expense
		Yes
		No
		Items included in this group are: plates, cups, bowls, serving dishes, drinking glasses, platters, trays, decorative pieces.
	
	
		7194
		Electricity
		Operating Expense
		Direct Operating Expense
		Yes
		No
		The cost of electricity purchased is charged to this account.
	
	
		7196
		Gas
		Operating Expense
		Direct Operating Expense
		Yes
		No
		This account includes the cost of natural gas.
	
	
		7199
		Trash Removal
		Operating Expense
		Direct Operating Expense
		Yes
		No
		This account will be charged with the cost of garbage disposal and the removal of trash, usually done under contract. Any incinerator expenses also would be included here.
	
	
		7200
		Water and Sewage
		Operating Expense
		Direct Operating Expense
		Yes
		No
		This account is charged with the cost of water consumed along with any chemicals, such as water softener or purifying compounds used. Wastewater and sewage charges also should be charged to this account.
	
	
		7202
		Cash Over/Short
		Operating Expense
		Direct Operating Expense
		Yes
		No
		

	
	
		7204
		Uniforms
		Operating Expense
		Direct Operating Expense
		Yes
		No
		This includes the cost of all uniforms, cleaning and repairing them, and badges. Some of the items included under uniform expense are: aprons, blouses, caps, coats, dresses, gloves, suits, ties, trousers, hairnets, shoes, costumes, badges, hats.
	
	
		7210
		Music and Entertainment
		Operating Expense
		

		Yes
		Yes
		

	
	
		7215
		Audio Broadcast Service
		Operating Expense
		Music and Entertainment
		Yes
		No
		This account would include the cost of a commercial audio or music service from vendors such as Muzak, Sirius and DMX.
	
	
		7220
		Bands, Musicians Etc.
		Operating Expense
		Music and Entertainment
		Yes
		No
		

	
	
		7240
		Meals for Bands
		Operating Expense
		Music and Entertainment
		Yes
		No
		

	
	
		7260
		Television Broadcast Service
		Operating Expense
		Music and Entertainment
		Yes
		No
		The cost of cable/satellite broadcast services.
	
	
		7300
		Marketing
		Operating Expense
		

		

		

		

	
	
		7310
		Advertising  
		Operating Expense
		Marketing
		Yes
		Yes
		

	
	
		7312
		Advertising / Marketing Fees
		Operating Expense
		Advertising  
		Yes
		No
		The amount of costs expended in all of the marketing endeavors, including advertising, direct response, public relations, discounts, selling, merchandising and promotion, both by outside agencies and the restaurant staff.
	
	
		7316
		Print Media
		Operating Expense
		Advertising  
		Yes
		No
		

	
	
		7318
		Online Advertising
		Operating Expense
		Advertising  
		Yes
		No
		

	
	
		7320
		Outdoor Signs
		Operating Expense
		Advertising  
		Yes
		No
		

	
	
		7325
		Radio and Television
		Operating Expense
		Advertising  
		Yes
		No
		

	
	
		7332
		Direct Response
		Operating Expense
		Marketing
		Yes
		Yes
		

	
	
		7334
		Birthday Club
		Operating Expense
		Direct Response
		Yes
		No
		

	
	
		7340
		Loyalty Program
		Operating Expense
		Direct Response
		Yes
		No
		

	
	
		7348
		Printing and Mail Service
		Operating Expense
		Direct Response
		Yes
		No
		

	
	
		7350
		Public Relations
		Operating Expense
		Marketing
		Yes
		Yes
		

	
	
		7352
		Community Projects
		Operating Expense
		Public Relations
		Yes
		No
		

	
	
		7354
		Donations and Gifts
		Operating Expense
		Public Relations
		Yes
		No
		

	
	
		7358
		Sports Team Sponsors
		Operating Expense
		Public Relations
		Yes
		No
		

	
	
		7360
		Research
		Operating Expense
		Marketing
		Yes
		Yes
		

	
	
		7362
		Customer Surveys
		Operating Expense
		Research
		Yes
		No
		

	
	
		7364
		Outside Research Agency
		Operating Expense
		Research
		Yes
		No
		

	
	
		7370
		Marketing - Other
		Operating Expense
		Marketing
		Yes
		Yes
		

	
	
		7372
		Gift Cards Expense
		Operating Expense
		Marketing - Other
		Yes
		No
		

	
	
		7380
		Reservation System
		Operating Expense
		Marketing - Other
		Yes
		No
		

	
	
		7385
		Restaurant Website
		Operating Expense
		Marketing - Other
		Yes
		No
		

	
	
		7400
		General and Administrative 
		Operating Expense
		

		No
		Yes
		

	
	
		7460
		Recycling Credits
		Operating Expense
		General and Administrative 
		No
		No
		Any waste or other items recycled for cash should be treated as a reduction in utility services and credited to the expenses here.
	
	
		7502
		Accounting and Payroll
		Operating Expense
		General and Administrative 
		No
		No
		This account should be charged with the costs associated with accounting and payroll including outside accounting, bookkeeping services and payroll processing. The cost of software or online applications used in performing these and related functions would be charged here.
	
	
		7504
		Bad Debts
		Operating Expense
		General and Administrative 
		No
		No
		This account is charged when customer accounts receivable, returned checks, credit card chargebacks, and other receivables are determined to be uncollectable. If the granting of credit is a normal part of a restaurant's operations, an allowance for doubtful or uncollectable accounts may be used to periodically estimate the amount of receivables that will ultimately become uncollectable. If the allowance method is used, any accounts written off will be charged against the allowance account. If the allowance account is not used, any amounts written off should be charged directly to this account.
	
	
		7506
		Bank Charges
		Operating Expense
		General and Administrative 
		No
		No
		Included in this account would be the costs associated with maintaining and servicing the company's bank account(s). Fees and charges would include the amount of maintenance fees and charges for overdrafts, stop payments, money orders, cashier's checks, wire transfers and other bank fees.
	
	
		7510
		Claims and Damages Paid
		Operating Expense
		General and Administrative 
		No
		No
		Payments made for customers' property lost or damaged should be charged to this account. Any insurance reimbursements should be credited.
	
	
		7512
		Collection Fees
		Operating Expense
		General and Administrative 
		No
		No
		This account is for expenses incurred in the collection of past-due customers receivables. These costs typically would include charges and fees from collection agencies, attorney and notary fees, and the cost of credit reports.
	
	
		7514
		Computer Costs
		Operating Expense
		General and Administrative 
		No
		No
		Includes costs and ongoing expenses connected with computer and point-of sale systems and information-processing services. This would include software and software upgrades, data-backup services, online accounting and ASP (Application Service Provider) services, payroll processing and similar expenses.
	
	
		7516
		Consulting  Expense
		Operating Expense
		General and Administrative 
		No
		No
		Restaurants may use a variety of ongoing or one-time outside consultants for assistance in operations, product development, menu design, strategic and growth planning and more. Some operators also may seek the assistance of an adviser, sometimes referred to as a "business coach." Coaching services may be for personal development of operators or key personnel in the areas of strategic planning, operations, marketing and other business areas.
	
	
		7518
		Credit Card Fees
		Operating Expense
		General and Administrative 
		No
		No
		The fees and charges incurred on sales settled on credit cards are coded to this account. Disputed credit card charges or back charges should not be charged to this account but rather treated as receivables until their collectability is determined. Back charges that are not collected should be charges to "bad debts" or "provision for doubtful accounts." PCI compliance fees for processing credit cards should be charged to this account.
	
	
		7520
		Delivery Fees
		Operating Expense
		General and Administrative 
		No
		No
		The fees and expenses of directors, trustees, partners, members or others in like capacity should be charged to this account.
	
	
		7522
		Dues and Subscriptions
		Operating Expense
		General and Administrative 
		No
		No
		The dues paid for membership in trade or business organizations or for authorized members of the staff to present the restaurant in such associations are charged to this account. The cost of subscriptions to trade journals and magazines and membership in subscription websites used by the management or staff should be included here.
	
	
		7524
		Franchise Fees
		Operating Expense
		General and Administrative 
		No
		No
		Ongoing royalties or franchise fees paid by a franchisee to the franchisor generally are based on a certain percentage of sales. Franchise fees paid to the franchisor would be charged to this account.
	
	
		7526
		Insurance Expense
		Operating Expense
		General and Administrative 
		No
		No
		All types of insurance costs, other than those included as employee benefits or fire and hazard coverage on the premises and contents, including business interruptions, should be charged to this account. The types of insurance costs included here: burglary, holdup, forgery, fraud, robbery, employment practice liability, fidelity bonds, general and excess liability, liquor liability, officers' (partners', members', shareholders') life insurance, public, boiler and elevator liability.
	
	
		7528
		Licenses and Permits Expense
		Operating Expense
		General and Administrative 
		No
		No
		This account should be charged with all federal, state and municipal licenses in connection with the restaurant, bar, food or cabaret operations. The cost of special permits and inspection fees also should be included here.
	
	
		7530
		Miscellaneous G&A Expense
		Operating Expense
		General and Administrative 
		No
		No
		Expenditures similar in nature to other to G&A expenses that do not fall clearly under the description for those accounts should be charged to "miscellaneous."
	
	
		7532
		Office Printing and Supplies
		Operating Expense
		General and Administrative 
		Yes
		No
		This account should be charged with the cost of all office-related supplies and paper, printed materials not devoted to the menu, marketing and training, such as accounting forms, account books, restaurant checks, cash register and other checking supplies, letterheads, bills and envelopes.
	
	
		7536
		Postage and Delivery
		Operating Expense
		General and Administrative 
		Yes
		No
		All postage except amounts applicable to marketing should be charged here.
	
	
		7538
		Professional Services Expense
		Operating Expense
		General and Administrative 
		No
		No
		This account is for legal fees and expenses other than collection cost, the cost of public accountants' services, the fees of business engineering firms and the cost of similar professional services.
	
	
		7540
		Sales (or Beverage) Taxes
		Operating Expense
		General and Administrative 
		No
		No
		Generally sales taxes are added to the sales price of food and beverages and paid by the customer. However, if the restaurant chooses to absorb the sales tax in the price of the meals or drinks at the bar, this is an administrative decision, and the taxes then would be charged as an expense in this account.
	
	
		7542
		Security and Deposit Services
		Operating Expense
		General and Administrative 
		No
		No
		This account should be charged with the cost of any police and security guards, fire or burglar alarms and armored car or special detective services. The cost of bank deposit pickup also should be charged to this account.
	
	
		7544
		State Business Taxes
		Operating Expense
		General and Administrative 
		No
		No
		Some states assess to business annual taxes that are not income taxes but may be based on gross sales, margins or capital surplus. These taxes have different names but can be referred to as business and occupancy taxes, franchise taxes, margin taxes or other names.
	
	
		7546
		Telephone
		Operating Expense
		General and Administrative 
		Yes
		No
		The cost of telephone equipment and service for restaurant phone systems and business cell phones should be charged to this account, with the exception of calls or services connected to marketing activities. The cost of paging equipment's and services, Internet access (ISP) and related services and supplies also may be charged to this account.
	
	
		7548
		Training Programs
		Operating Expense
		General and Administrative 
		No
		No
		Costs and expenses relating to purchasing, developing and delivering employee training programs and materials should be charged here, as well as the cost of attending outside seminars, classes and training programs. The cost of salaries and wages incurred during employee training periods should be charged to the appropriate accounts under the "labor" category and not in this account.
	
	
		7550
		Travel   
		Operating Expense
		General and Administrative 
		No
		No
		The cost of the transportation, meals and related travel expenses of managers or staff members of the restaurant when they travel on business is to be charged to this account. An exception would be when traveling is done in connection with product or business research. In those cases, the expenses would be charged to "marketing" in the "research" account.
	
	
		7605
		Repairs and Maintenance
		Operating Expense
		

		Yes
		Yes
		

	
	
		8105
		Occupancy Costs
		Non Controllable Expense
		

		No
		Yes
		

	
	
		8140
		Ground Rent
		Non Controllable Expense
		Occupancy Costs
		No
		No
		

	
	
		8180
		Personal Property Taxes
		Non Controllable Expense
		Occupancy Costs
		No
		No
		

	
	
		8190
		Real Estate Taxes
		Non Controllable Expense
		Occupancy Costs
		No
		No
		Real Estate taxes are assessed by the state, county or city governments on land, building, improvements to land and certain equipment affixed to land or buildings. These taxes generally are paid by the restaurant as a tenant under a net lease arrangement or if the property is owned by the restaurant operator. Real estate and personal property taxes, if applicable, may be payable on an annual, semi-annual or even quarterly payment schedule depending on the billing schedule of the taxing authority. Regardless of the frequency of payment, it is important that each monthly or four-week financial statement reflect a pro rata share of the annual real estate and personal property tax expense for that period.
	
	
		8200
		Equipment Rental
		Non Controllable Expense
		

		No
		No
		

	
	
		8305
		Depreciation and Amortization
		Non Controllable Expense
		

		No
		No
		

	
	
		9000
		Corporate Overhead
		Corporate Overhead & Other
		

		No
		Yes
		

	
	
		9005
		Officer' Salaries
		Corporate Overhead & Other
		Corporate Overhead
		No
		No
		

	
	
		9010
		Directors' Salaries
		Corporate Overhead & Other
		Corporate Overhead
		No
		No
		

	
	
		9015
		Directors' and Trustees' Fees
		Corporate Overhead & Other
		Corporate Overhead
		No
		No
		

	
	
		9020
		Corporate Office Payroll
		Corporate Overhead & Other
		Corporate Overhead
		No
		No
		

	
	
		9025
		Corporate EE Benefits
		Corporate Overhead & Other
		Corporate Overhead
		No
		No
		

	
	
		9030
		Corporate Office Rent
		Corporate Overhead & Other
		Corporate Overhead
		No
		No
		

	
	
		9035
		Corporate Travel
		Corporate Overhead & Other
		Corporate Overhead
		No
		No
		

	
	
		9040
		Corporate Telephone
		Corporate Overhead & Other
		Corporate Overhead
		No
		No
		

	
	
		9045
		Corporate Office Auto Expense
		Corporate Overhead & Other
		Corporate Overhead
		No
		No
		

	
	
		9050
		Corporate Office Insurance
		Corporate Overhead & Other
		Corporate Overhead
		No
		No
		

	
	
		9055
		Corporate Office Utilities
		Corporate Overhead & Other
		Corporate Overhead
		No
		No
		

	
	
		9060
		Legal and Accounting
		Corporate Overhead & Other
		Corporate Overhead
		No
		No
		

	
	
		9065
		Corporate Misc Expense
		Corporate Overhead & Other
		Corporate Overhead
		No
		No
		

	
	
		9100
		Management Fee
		Corporate Overhead & Other
		

		No
		No
		

	
	
		9205
		Interest Expense
		Corporate Overhead & Other
		

		No
		Yes
		

	
	
		9220
		Long-term Debt
		Corporate Overhead & Other
		Interest Expense
		No
		No
		

	
	
		9230
		Interest Expense - Other
		Corporate Overhead & Other
		Interest Expense
		No
		No
		

	
	
		9305
		Other (Income) Expense
		Corporate Overhead & Other
		

		No
		Yes
		

	
	
		9310
		Grease and Waste Sales
		Corporate Overhead & Other
		Other (Income) Expense
		No
		No
		

	
	
		9320
		Gain / Loss on Asset Sales
		Corporate Overhead & Other
		Other (Income) Expense
		No
		No
		

	
	
		9330
		Interest Income
		Corporate Overhead & Other
		Other (Income) Expense
		No
		No
		

	
	
		9505
		Federal and State Income Tax
		Income Tax
		

		No
		Yes
		

	
	
		9510
		Federal Income Tax
		Income Tax
		Federal and State Income Tax
		No
		No
		

	
	
		9520
		State Income Tax
		Income Tax
		Federal and State Income Tax
		No
		No
The words contained in this file might help you see if this file matches what you are looking for:

...Sheet nra revised coa account number name gl type parent available to managers disable entry description cash current asset no yes change and petty checking bank used in r each will need reside on the as a savings undeposited funds transit post pending disbursements that later be posted their respective accounts intercompany due tofrom company for automatic entries replace with legal entity receivable ar door dash other receivables vendor credit expected system requirement credits from vendors inventory your version of excel allows you read this threaded comment however any edits it get removed if file is opened newer learn more httpsgomicrosoftcomfwlink linkid matching consideration prime costs cogs food produce dairy meat pork beef poultry soft beverages alcohol liquor beer wine paper products merchandise prepaid expenses insurance taxes licenses land fixed building leasehold improvement assets furniture equipment automobiles trucks construction progress accumulated depreciation capi...
Related files

Share

Help

Related files

Share

Share to social media

Help

Login Area
