Negative Cash Balance at EOD / on DSR

Negative Cash Balance at EOD / on DSR

Understanding Negative Cash Balance 

This article will explain what is meant by a negative cash balance both for the actual totals at EOD, and the Cash column of the Receipts section of the Daily Sales Report.

Info
For further explanation on everything in the Daily Sales Report, consult this article: Reports - Sales Reports - Daily Sales Report - DSR

EOD System Totals

Daily Sales Report - Receipts Section


Alert
Mainly, it is important to understand that negative cash balance is fairly normal and not cause for concern. 

Explanation

Idea
A negative cash balance occurs when the amount a restaurant pays out in server tips is greater than the amount of overall cash sales for that night. 

- To make these calculations, the assumed starting balance of a cash drawer is 0*
- This is to monitor the balance of ALL cash received vs ALL cash paid out to employee tips for a singular journal date.

Info
*If you want to edit a cash drawers starting balance:


Examples: 

- If an employee is owed $200 in cash tips and $200 was paid out from the drawer, you arrive back at 0. 

- If employees in total are paid out $1000 for a night, and the restaurant only had $900 in total cash sales , you would arrive at a -$100 cash balance.

Investigation

Using Daily Sales Report (DSR)

- You can verify the amount of total cash sales VS total amount of tips at a glance by viewing the "Bank Deposits" section of the DSR. 




- You will see that the column for Cash Total shows
  1. Base - total cash sales for that journal date
  2. Tip - total tips paid out to employees for that journal date 
  3. Total - The system's calculation between those two numbers
  4. Actual - What was physically counted and input in actual totals when running EOD, and what goes into the actual column for cash in the receipts section of the DSR as well. 

Alert
Do note that actual cash totals are limited in the ability to be externally investigated by a tech, due to the fact this actual total derives from what was physically counted on site when EOD was ran.

Employee Checkout Details

- There are 2 main ways to verify the details of employee checkout totals if you need:
  1. Deposit #1 on Daily Sales Report - typically reserved for Cash payments and will give the cash due totaled from printed employee checkouts.
  1. Employee Payment Summary Report - Via manager console, reports > employees > employee payment summary report. 
    1. This will allow you to see CC and cash sales and tips and show what the final checkout amount was for each employee. 
      1. A positive checkout total is what the employee is owed, A negative checkout total is what the employee owes back to the restaurant. 
      2. If the "checkout" box is missing, you can manually calculate the checkout total by following this article: Calculate Missed Employee Checkout




    • Related Articles

    • Reports - Sales Reports - Daily Sales Report - DSR

      Overview The Daily Sales Report is the most standard report, used to see overall sales for a specific time period, whether that be for a day, a month, or even a year. About the Daily Sales Report How to Generate a Daily Sales Report Open Manager ...

    • EOD Reports Not E-Mailed / Printed

      Sometimes, even if EOD is ran and fully completed, reports may not be e-mailed due to internet connection or other such issues. If, after running an End Of Day, you do not see reports that were previously set up to be printed or emailed, there is a ...

    • Hourly Sales Report

      If you want to view sales by the hour, for purposes of sales forecasting or otherwise, the following article will explain the process of accessing these reports and how to best use them. - You can access hourly sales report via the manager console ...

    • Calculate Missed Employee Checkout

      If an employee did not complete their checkout, we will still need to see if there is any cash owed to or by the employee 1. Check For Tip Fees In Manager Console, go into setup > payment setup and select 'credit' or any of the named credit cards Go ...

    • Setting Up Auto Email Reports for End of Day

      Setting Up Auto Email Reports 1. In MC, go to Setup -> System Preferences -> EOD Setup. 2. Click the “Reports” tab 3. Click one of the empty options that say “none” in the white box on the left. Scroll down if need be 4. Select the report from the ...