Restaurant Balance Sheet Template

Complete the form to get your copy of this free resource!

Restaurant Balance Sheet Template

ProjectionHub has a balance sheet template made specifically for Restaurants that turns complicated numbers into simple questions about your business so you can have a balance sheet ready to go in no time

Restaurant Balance Sheet Template

ProjectionHub has a balance sheet template made specifically for Restaurants that turns complicated numbers into simple questions about your business so you can have a balance sheet ready to go in no time

Join 15,000+ founders and consultants who have used our free resources and tools

Arise Health logo

The restaurant balance sheet excel template used is unique because it collects your data inputs as answers to simple questions rather than you having to remember exactly where each number should go on a balance sheet. Plus the template will tell you automatically if your balance sheet balances or not!

Restaurant Balance Sheet Template FAQs

What should be included on a restaurant balance sheet?

A restaurant balance sheet should include your assets, liabilities, and equity.  As an example, a restaurant should include the following line items in each section of the balance sheet:

Restaurant Assets

  • Cash
  • Checking accounts
  • Accounts receivable
  • Kitchen equipment
  • Leasehold improvements
  • Furniture
  • Fixtures

Restaurant Liabilities

  • Accounts Payable (bills to vendors and suppliers)
  • Credit cards
  • Restaurant gift cards
  • Business loans

Equity

  • Amount that you or others have invested into the business
  • Retained earnings - the cumulative amount of profit you have earned over the life of the restaurant

Check out this article to see an example restaurant balance sheet

How to handle gift cards on a restaurant balance sheet?

Gift cards for a restaurant can be a wonderful cash flow tool.  You can receive the cash up front when you sell the gift card and only incur the food cost and labor cost when the gift card is redeemed (if it is redeemed at all).  Gift cards create a bit of a complication with your restaurant accounting though!  The dollar amount of any unused gift cards should be tracked and recorded as a liability on your balance sheet.  

How to create a balance sheet pro forma for my restaurant? 

In order to create a pro forma, or forecasted balance sheet you will need to create a full set of financial projections for your restaurant. Learn about the difference between a current balance sheet and balance sheet forecast in our guide.

How to prepare a balance sheet for a restaurant?

Preparing a balance sheet for a restaurant might seem easy at first because you just need to list your assets, liabilities, and equity, but what happens when your balance sheet doesn’t balance! Don’t worry you are not alone, it is tough to get a balance sheet to balance. In this video I walk you through the process of creating a balance sheet for your restaurant and even problem solve with you when your balance sheet doesn’t balance.

Get the Template!

Check out our Highly Rated Financial Projection Templates

★★★★★
Adam did a fantastic job helping my company formulate financial projections. We're going to raise money for our seed round, so the model lays everything out clearly, and we feel confident to pitch investors at this point in time. Not only is the model excellent, but the customer service that Adam and his company have provided is also top-notch. Very quick response times, and even gives live video reviews to major questions that you have. The process of working together side by side to build such an important document has been very pleasant and I look forward to working with Projection Hub as our company grows.
Alex Perez
★★★★★
If you are still undecided, this spreadsheet IS WORTH EVERY DOLLAR! lots of great features that will make you look so professional. The most valuable part is the customer service, I cannot believe how responsive Adam (co-founder) is, I asked many questions via many emails and he was so responsive I was very impressed, even sending me personalized video replies. AMAZING CUSTOMER SERVICE!! the service is worth the price of the spreadsheet alone.
Michael Emerson