Sales Quickbooks Fuse “Basic View” Overview

The Sales Quickbooks Fuse is the home for your restaurant’s chart of accounts.  This page is displayed in the “Basic View” by default.  If you feel your restaurant needs a more robust view and further options to edit the accounting that goes into your restaurant’s calculations on Eyenalyze, please see the tutorial on How to use the Advanced Accounting View (How to use the Advanced Accounting View).  

Dashboard → Sales Hub → Quickbooks Fuse

To view the Quickbooks Fuse, from the Dashboard, go to the Sales Hub, then go to the Quickbooks Fuse.

ss sales quickbooks fuse.png

Here you can view and edit your restaurant’s chart chart of accounts, which is used for calculations within Eyenalyze.

You do not have to save after each adjusted entry, but you will need to select “Save Changes” in the bottom right corner to apply your changes.

How to Set Up Cash Flow

Once Eyenalyze is receiving sales data from your restaurant’s POS, you will want to set up your credit card groups, house accounts, and initial safe balance in order to set up your cash flow.

Dashboard → Sales → Cash Flow Fuse

From the Dashboard, go to the Sales Hub, then go to the Cash Flow Fuse.

ss how to set up cash flow

In the Credit Cards box you can add credit cards you would like to group by deposit information.  For example, MasterCard, Discover, and Visa would be named WorldPay, if that is your credit card merchant.

In the Miscellaneous box you can create payment groups such as House Account.

In the Safe Balance box you can enter your initial safe balance.

Completing these three fields will complete setting up your restaurant’s cash flow.

Sales Accounting Fuse Overview

The Sales Accounting Fuse is an overview of your restaurant’s accounting information.  It displays information such as net sales, taxes, and credit card payments.  This page also contains an Over/Under for your restaurant that is calculated based on sales and payments.  The bar will appear red when situations such as walkouts happen.

This page is specifically designed for accountants, and can be used to cross check information for your restaurant.  Using the Date Range Function, users can view all of this information for specific time periods including specific days, weeks, months, or even years.

ss sales accounting fuse.png

 

How to use the Advanced Accounting View

advanced-view-ss

Eyenalyze offers an Advanced Accounting view which displays a more robust view of the accounting that goes into your restaurant’s data.  If you have already mapped your chart of accounts in the basic view, then you will not need to repeat this step in the advanced view, or you can map your chart of accounts directly using the advanced view.  

Sales -> Quickbooks -> Edit Menu -> Advanced View

To switch to the Advanced Accounting view, go to the Sales Hub, and select Quickbooks.  Then go to the edit menu and select Advanced View.  The first thing you will need to do before you can edit your chart of accounts is unlock the features by clicking the padlock in the top left corner.  The Advanced Accounting page adds three core features that lets you customize how your accounting system operates.  

The first feature is you can edit whether an entry is a debit, credit, or both.  You can do this by dragging the box into the debit or credit square.  You can delete a box by selecting the small “x” in the corner.  

The second feature is the ability to hide items.  This would occur if you are no longer using an item and you do not want it to show in the system or on your balance sheet.  

The third feature is at the bottom you will see total columns for your debits and credits.  These totals should equal out to zero.  We encourage you to involve your accountant or controller in that process so it is accurate.  When you are finished working, go back to the padlock in the top left corner to lock the page, and doing so will save your changes.  

How to Upload a Chart of Accounts

quickbooks-upload-sc

Sales -> Quickbooks -> Edit Menu -> Quickbooks Upload

In order to set up accounting features on Eyenalyze, the first thing you will need to do is upload your chart of accounts from Quickbooks.  To do so, go to the sales hub and select the Quickbooks fuse.  You can import your chart of accounts by going to the edit menu and selecting Quickbooks Upload.  Here you can browse your files and locate your chart of accounts, which should be a .iif file, the standard for importing and exporting in Quickbooks.  

Once you have selected your chart of accounts file, save your changes, and the Quickbooks page will populate with your chart of accounts.  Finally you must go through and map your chart of accounts.  You will only have to do this once, and you do not have to save after each entry, but you must save in order to apply your changes.  Below is what a completed chart of accounts should look like.  

chart-of-accounts-ss

If you feel that you need more advanced accounting options, please see the tutorial on using the Advanced Accounting page.

Sales Cash Flow Fuse Overview

cash-flow-page-sc

Sales -> Cash Flow

The Cash Flow fuse, located in the Sales Hub, provides information on day to day operations within your restaurant.  

In the Batch ID box you can enter credit card batch IDs.  

The Credit Cards box summarizes your credit card transactions.  

In the Safe Balance box you will enter your safe balance to verify that your cash is correct.  

In the Bank Deposit box you will enter your actual deposit.  For example if your were $10 short, that would appear here.  

The Miscellaneous box will show any other remaining transactions.

The Total Cash Flow box shows your calculated cash flow, actual cash flow, and the total difference based on the information entered on this page.  

Sales Hub Overview

sales-hub-overview-sc

On the dashboard, the Sales Hub shows your net sales for the designated date range.  You can navigate to the Sales Hub by clicking the “Sales” header, or you can access a specific fuse within the Sales Hub directly by clicking the chevron drop down menu, and selecting the desired fuse.  

Within the Sales Hub, there is the Accounting, Credit Card Tracker, Cash Flow, and Quickbooks fuse.  

The Accounting fuse provides a summary of the transactions for the set date range.  Here you can view information such as net sales, voids, and payments due, as well as other summaries used for accounting purposes.

The Credit Card Tracker fuse reconciles credit card sales from your POS with data from the credit card payment processor to verify your totals.  

The Cash Flow fuse, which could be considered your cash count, or your cash audit, provides information on day to day operations within your restaurant.  

The Quickbooks fuse lets you view and manage the chart of accounts for your restaurant, as well as importing and exporting data to an accounting software, such as quickbooks.

Below the sales fuse panel you can view your restaurant’s net sales for yesterday, the last 7 days, and the last 30 days, along with graphical representations for this data.