Usage

For general information on how to use reports – please see:

Media Report Examples

Media Overview Report

As of version 1460, Breakdown Overview has been renamed as Media Overview.

This particular report was designed to give a complete and total break down of the day's media and sales information. The intention is to have this report cover all the standard information a site or server might need to fill in any basic paperwork they have. It also includes information such as Net Sales, Taxes and Cash Due.

This report would be used by the Server and all Floor Staff, while also being used as a full overview for managers and owners of the sales events for the day.

Columns	Definition
Media	Each payment type
Count	Number of transactions under each payment type
Amount	Total amount of transactions under each payment type
Tip	Tips entered manually by customer under each payment type
Total	Amount + Tip

Rows	Definition
On Account	We need to create customer account in CustomerDB and use the customer account to purchase.
Gift Card	Gift Card can be activated in CustomerDB. We can use active Gift Card to purchase.
VISA	One type of credit card
MASTER	One type of credit card
Cash	Transactions paid by cash
Cash Tips	Tips paid by cash. Not charged in bill.
Charged Tips	Tips entered manually by customer on debit/credit payments.
iGift Card Redemption	Transactions paid by iGift Card
Charged Gratuity	Tips charged as part of the bill. Often seen as a service charge or fee. Received by Cash/Credit/Debit.
Load Gift Card	Gift Card can be activated in CustomerDB. We can load fund to Gift Card.
Account Payment	We can create customer account in CustomerDB and load fund to the account.
iGift Card Sold	We can load fund to iGift Card
Cash Rounding	When the Cash Rounding Setting is used, this value will display the overages(Negative (-)Extra Money Collected, Rounded up. ) and underages (Positive (+) Money not charged on the transaction, Rounded Down) Cash is also effected by rounding which is why this is in reverse of the cash when calculating netsales $ balance.
Net Sales before Voids	Total Media + Cashrounding - Tax
Net Sales	Net Sales before Voids + Voids
Net Sales + Tax	Net Sales + Total Taxes

Media Collected Report

This report provides a breakdown of all media types collected.

Columns	Definition
Media	Each payment type
Count	Number of transactions under each payment type
Amount	Total amount of transactions under each payment type
Tip	Tips entered manually by customer under each payment type
Total	Amount + Tip

Rows	Definition
On Account	We need to create customer account in CustomerDB and use the customer account to purchase.
Gift Card	Gift Card can be activated in CustomerDB. We can use active Gift Card to purchase.
VISA	One type of credit card
MASTER	One type of credit card
Cash	Transactions paid by cash
Cash Tips	Tips paid by cash. Not charged in bill.
Charged Tips	Tips entered manually by customer on debit/credit payments.
iGift Card Redemption	Transactions paid by iGift Card
Charged Gratuity	Tips charged automatically as part of the bill. Received by Cash/Credit/Debit.
Load Gift Card	Gift Card can be activated in CustomerDB. We can load fund to Gift Card.
Account Payment	We can create customer account in CustomerDB and load fund to the account.
iGift Card Sold	We can load fund to iGift Card

Cash and Tips Breakdown Report

The Cash Tips Report was designed so that of cash transactions and tips can be viewed.

Usually used by servers to assist in calculating amount of cash to be given back to management at the end of their shift.

Example report:

Cash tip breakdown report.jpg

Rows	Definition
Cash	Amount of cash received for transactions. [Cash Collected]
Cash Tips	Tips paid by cash. Not charged in bill.
Charged Gratuity	Tips charged as part of the bill. Often as a Service Charge or Service Fee. Received by Cash/Credit/Debit.
Charged Tips	Tips entered manually by customer on debit/credit payments.
Grand Total	Amount of cash belonging to business. The difference being tips.

Cash Rounding

With Cash Rounding ...

Total 4.98
Collect 5.00

Tax Collected Breakdown Report Example

The following report depicts the actual amount of tax collected.

Name	Definition
Media	Media is always defined as payment media
Total	Total per Line
GST, HST8%C, HST*%F	Different taxes that have been setup by the business for taxes purposes
Grand Total	Total of all line values.

Net Sales + Tax does not balance with Total Media

Open Tables

If there are any open tables that fall within the time period that the report was generated, the Net Sales + Tax field will not balance with Total Media. Check the Open Table Total field highlighted in red below, if this value is greater than 0, then there are open tables. In this case you must close out all open transactions that occurred within the time period that the report was generated. You may close these open transactions in transaction checker, for further assistance on how to close transactions from transaction checker please see the following link /wiki/spaces/IS/pages/63610819.

Another reason you may see a difference in this number is because they are not Directly related in this way.

Net Media = Total of all Media collected Except cash Rounding, In the later reports if you review Media before rounding this number should more acculturate match with net sales + tax.
Keep in mind that Gift Card purchases and usages should be also taken into consideration when considering this calculation.

Also in 1620 prior to patch 0040. there is a potential issue that on splitting of items with priced options that the option can double, if this happens then the net sales + tax will be greater then the media collected.

Credit Card Payments Not Recognized

Some credit card payments won't appear in reports because they aren't a recognized credit card type. Another CC payment type can be added to the system to account for these credit card transactions, click the images below to enlarge. Please contact Volanté Support if you would like to add the other CC payment type.

Media Report Only Filters

In reportsV2, under Additional Options tab, and Advanced Options side tab. There are 3 filters used for Media Reports only:

Name	Description
Use Separate Timestamp for Each Payment (Media Reports Only)	Reported data will be based on the entered time of the payments and not based on the closed time of the transaction. If a transaction was opened and payments made before 5pm, then the transaction was closed at 6pm. When you print the report from 6:00pm - 7:00pm, normally these payments will be included because it's based on closed time of the transaction. However when this option is selected, the payments will not appear as they are based on the enter time which is before 5pm.
Use Server Information for Each Payment (Media Reports Only)	This must be used in conjunction with Group By Employee filter. (Group by Employee Filter is found under the Additional Options tab - Group By Side tab). When this checkbox is enabled, the displayed media will belong to the Server who entered the payment instead of the owner of the transaction. ie. If Server1 started a table, and Server2 went in to make a cash payment of $10.00. When Server1 closes his table, the cash payment would normally show up under Server1. However when this checkbox is enabled, the cash payment would show up under Server2 as he is the server who actually made the payment.
Use Terminals for Each Payment (Media Reports Only)	This must be used in conjunction with Group By Terminal filter. (Group by Terminal Filter is found under the Additional Options tab - Group By Side tab). When this checkbox is enabled, the displayed media will belong to the Terminal where the payment was entered instead of the terminal where the transaction was closed. ie. If Server1 opens a table at Terminal1 and then uses Terminal2 to make cash payment of $10.00. When the transaction is closed, the cash payment would normally show up under Terminal1. However when this checkbox is enabled, the cash payment would show up under Terminal2 as this is the terminal used to make the payment.

Related Articles

Page:

Report List - V.1454 and Lower
Page:

Reporting Module in BackOffice (V2)
Page:

Close Day Reports
Page:

Report List
Page:

Reporting Quick Guide
Page:

Media Reports
Page:

Report List - Version 1760+
Page:

Sales Reports
Page:

POS Web Services API - Reporting
Page:

Cash Drawer Reporting
Page:

Reporting User Guide (PDF)
Page:

Close Day Reports - Report Detail Calculations
Page:

Terminal Setup Guide (PDF)
Page:

Custom Formula Formating
Page:

Reports Reference Guide (PDF) - Reports Listing

See Also:

Troubleshooting Articles

Browser not supported