Completing an Excel Based Countout

Updated 5 months ago

This lesson will show you how to complete an excel based count out. You will learn how to enter sales and other POS data and record your deposit.

Completing your Excel Count-out Form


Locate the "Total Cash Payments" section of your Sales Summary Report on ToastTab.com.


  1. Login to Toasttab.com with your user credentials
  2. Click the "Sales" link under the "Reports" heading

  3. Click "Summary" and make sure the date filter is showing "Today"

 

     4. Click "Load Report"



Locate your Paid Outs and Paid Ins for the Day using the Cash Drawer Summary Report


  1. Login to Toasttab.com with your user credentials
  2. Click the "Sales" link under the "Reports" heading

  3. Click on the "Cash Drawers" report


  4. Locate the "Total" column on the left hand side of the cash drawer report

  5. Locate the "Cash In" value.  This value will be recorded as "Paid Ins" on your excel count out form.

  6. Locate the "Paid Out" value.  This value will be recorded as "Paid Outs" on your excel count out form.




Transcribe the Data From the Reports to your Count Out Form:


1. Locate the "Total Cash Payments" from the Toast Sales Summary Report 

2. Enter the "Total Cash Payments" from the Toast Sales Summary Report  into the "Total Cash Payments" field on your excel count out.

3. Locate "Credit/Non-Cash tips" from the Toast Sales Summary Report.

4. Enter the "Credit/Non-Cash tips" into the "Credit/Non-Cash tips" field on your excel count out.

5. Locate the Paid-In's for the day by adding up your Paid-in for the day

6. Enter the Paid-Ins for the day into the "Paid In" field of your excel count out

7. Locate the Paid-Outs for the day by adding up your Paid-Outs for the day

8. Enter the Paid-Outs for the day into the "Paid Outs" field fo your excel count out.

9. Enter the "Change in Bank".  If your bank is increasing then you will enter the amount you that the bank will be increasing by but as a negative number.  For example: if your stores bank is increasing from $1000.00 to $1200.00 you should enter -$200 in the "Change in Bank" field.  If your bank is decreasing from $1200 to $1000.00 then you would enter $200 in the "Change in Bank" field.  The "Change in Bank" field is very seldom used and will often only be used is situations like concerts, parties, or game day events.

10.  Enter the actual cash that you are depositing into the bank in the "Deposit Is" field.



Sales Summary Report


Cash Report



Excel Count Out Form





Back