How to do Restaurant Accounting with Quickbooks? Pro tips

Doing restaurant accounting with QuickBooks is a wise choice. Quickbooks is easy to use with awesome features. You can handle most of the accounting tasks such as invoicing, payroll, budgeting and reconciliation in QB.

It requires a little bit of time to learn the software functionality but it’s worth it. We have given 7 tips on restaurant accounting with QuickBooks. Going through them will help you to use the software as a pro.

Restaurant accounting with Quickbooks:

Restaurant QuickBooks setup:

Restaurant QuickBooks setup includes many elements We recommend hiring a skilled restaurant accountant for it. There are chances of errors and discrepancy. You may get inaccurate financial statements. You may get a tax default penalty later on.

Follow below steps for accurate setup:

  1. Chart of accounts setup
  2. Setup of conversion balances
  3. Creation of products and services
  4. Setting up correct company information
  5. Setting up bank accounts for synchronisation
  6. Setting up tax rates
  7. Connect POS and Quickbooks

Please note that all steps are not required. You may skip the step if you are not using the certain feature of QuickBooks. ( Ex. Inventory).

Restaurant sales entry :

There are two ways to enter restaurant sales in QuickBooks.

  1. Entering sales via manual entry as per POS
  2. Synchronisation of POS system automatically

The work is not done here. The restaurant bookkeeper should reconcile the sales amount with a bank deposit.

Moreover, cash sales should not be unrecorded. You should have a proper cash reconciliation system to enter and reconcile the cash sales.

Sales attract sales tax. Any mistake results in sales tax default. So periodical sales reconciliation is a must.

Restaurant account payable:

Restaurant business requires the frequent purchase of inventory and other services. This often makes accounts payable messy and difficult to manage.

Restaurant accounts payable can be managed in house. You can outsource the whole function. At the month-end, you should ask for accounts payable reconciliation.

Accounts payable management includes following functions:

  1. Entering purchase bills in the system
  2. Making payments against the bill
  3. Reconciliation of payables

Today, there are many accounts payable software available. These software automate half process of accounts payable. Bill.com is one of the popular account payable software.

Restaurant inventory:

Restaurant inventory can be managed with Quickbooks or with other software. We suggest using separate software for restaurant inventory management. However, the small restaurant can go with Quickbooks inventory.

There are two options managin inventory in Quickbooks: Tracked and untracked. Untracked inventory option does not count inventory balances.

To setup thei nventory, you need to list down inventory item one by one. Inventory count increases or decreases when you record purchase or sales.

Quickbooks generates inventory reports including

  1. Inventory valuation summary
  2. Inventory valuation details
  3. Physical inventory worksheet

It is cost-effective to use Quickbook inventory for few years of startups. Once the business grows, you can easily switch to separate inventory software.

Restaurant payroll :

Restaurant business used to have lots of casual and part-time employees. Keeping track of employee information and wages is necessary to follow payroll tax rules.

Quickbooks gives you a payroll feature. It has amazing features such as time-tracking, automatic tax calculation and same day direct deposit.

To get started with payroll, you need to setup the employee details such as basic info and pay rates. Quickbooks automatically calculate the tax and wages on due dates.

Payroll tax rules has frequent updates and busy restaurants tend to outsource payroll function altogether. It saves time and efforts to manage payroll. Payroll expert helps to comply all tax rules and saves from heavy penalty.

Restaurant chart of accounts :

Quickbooks provide a default chart of accounts. You can go with it, customize it or set up a unique restaurant chart of accounts.

There are several advantage of unique restaurant chart of accounts:

  1. You can subdivide income and expense as per your need.
  2. You can keep an eye on specific revenue or expense.
  3. It helps you cut cost.
  4. It helps you in budgeting.
  5. You can stop revenue leakage.
  6. Payroll can be divided into hourly and fixed.
  7. It adds more values to financial statements.

There are several disadvantage:

  1. It makes bookkeeping more complicated and time-consuming.
  2. The effectiveness of reports is aligned with the effectiveness of data entered.

How to prepare custom chart of accounts for your restaurant?

There are two ways to cusomize the chart of accounts. Starting from scratch or customize the default quickbooks chart of accounts.

You can download Quickbooks chart of accounts file. Add the necessary accounts and codes. Save and import it in Quickbooks.

You can create subaccounts if you don’t want to take the trouble of customizing accounts. Let’s understand subaccounts concept with example.

Example :

Two sub-accounts can be created for inventory: Food inventory and Beverages inventory.

You can create sub-accounts for furniture: Office furniture and Cafe furniture.

I hope you get the point. Still not sure? Then ask your accountant to draw a chart of accounts for you. So you just plug it in Quickbooks and start working.

Restaurant Tax compliance:

Restaurant business requires multiple tax compliance such as federal tax, sales tax, payroll tax, wine tax etc. Even tip involves taxes.

Quickbooks offers sales tax features in all plan. You get benefit of automated tax calculation, tax reports and tax suggestions. However, you need to take care of few tasks such as

  1. Input of correct organization details such as location of business and business type.
  2. Input of correct customer info while creating sales invoice.
  3. Selection of correct tax code while doing expense categorization.
  4. Selection of correct sales tax code as per location of business.
  5. Review of tax reports

Tax compliance requires in debt knowledge of thousand of taxes. Self compliance is cost effective. Yet, you can always ask for help of tax professional. This way, you can save time and remain worry free about taxes.

Restaurant Bank Reconciliation :

Bank reconciliation requires crystal clear focus. It should be done by a skilled bookkeeper. A small error might cost you huge bucks. The error may result in tax defaults. Inaccurate coding of supplier account results in late payment interest.

Quickbooks give easy to use bank screen. Bank coding is easier compared to other apps. Quickbooks offer automated features. A little bit of care is required here. We suggest don’t use full automation. Partially automation along with human eye review is necessary to avoid mistakes.

At the end of the month, you should compare the month-end bank balance with the Quickbooks balance. This can be done with the bank reconciliation function. You need to compare actual bank entry with Quickbooks data. Sounds too much right? That’s all accounting.

Not doing bank reconciliation leads to inaccurate reporting. Reconciliation should be done and then tax should be filed.

Restaurant Reporting :

Most restaurant owners consider accounts as compliance task. Just get the books done and get reports for taxes.

Reports are not only for taxes. It gives you an overview of the profitability of the business. Have you tried to read the financial statements? Do you know the importance of stock reports?

Quickbooks has advanced reporting features. Get the following reports downloaded from Quickbooks and read them every month:

  1. Income statement
  2. Inventory overview
  3. Account receivable age summary
  4. Account payable age summary
  5. Sales by customer summary

Restaurant Budgeting :

Restaurant business involves daily pretty expense. Managing cash flow is necessary to run the restaurant business smoothly.

But how can you manage the cash flow when you are already busy in growing the business? Budgeting is the answer.

You should get the restaurant budget on a weekly or monthly basis. This helps you to review the actual vs budget spent. You can keep track of the expense and cut down the unnecessary cost.

Quickbooks has inbuilt budgeting features. It can be accessed with the budgeting menu. It populates the automated budget. All you need to do is add numbers for upcoming new events.

Reviewing the budget periodically and taking necessary action can save you from a cash crisis.

Quickbooks Apps for restaurant :

Quickbooks offer lots of features. Anything missing? You can visit the marketplace and choose the app for your restaurant.

It is totally up to your need and budget. The app can cost you few bucks per month. Most of the time, the money is worth spending.

You may want to choose app for any of the following functions:

  1. Pos system
  2. Time tracking
  3. Expense management
  4. Tax management
  5. Payroll
  6. Inventory

Setting up apps requires technical as well accounting knowledge. You may use video tutorials available at the apps’ website. Don’t hesitate to get the help of a QuickBooks expert. He can set up the app if the app setting is a clumpy task for you.

Wrap up:

We cover most of the important points related to restaurant accounting with QuickBooks. You should have a basic idea of functions such as reconciliation, inventory, payroll and banking.

It takes around 15 to 30 days to get familiar with software functionality. There are online tutorials available everywhere. However, sorting out whole restaurant bookkeeping is time-consuming. It requires good accounting knowledge.

As a restaurant business owner, it is your choice to handle the accounting function or outsource it altogether. If you choose to get help, feel free to contact us to get help with restaurant bookkeeping and accounting.

Leave a Reply

Your email address will not be published. Required fields are marked *