Financial Report

Go to CAS --> Reports --> Financial

The Financial tab contains the Financial Reconciliation report which is used to reconcile deposit activity against expected POS totals and Audit Report.

 

Financial Reconciliation

Overview

Go to CAS --> Reports --> Financial--> Financial Reconciliation

The purpose of this report is to reconcile the media totals reported on the CAS with the total PLU Movement with the deposits reported in the Deposit Reconciliation User Interface. It is essentially the data reported by the Real Time Sales report with the detail of the credit card totals by 5 card type classifications (VISA, MASTERCARD, AMEX, DISCOVER and OTHER) In addition the Gift card totals will also be reported. No data is displayed on this report until at least one Deposit Reconciliation is posted.

The next set of data will be related to Transactions and will consist of the Total discounts, Coupons, extended Cost of sales, retail Collected, Tax and a total of Retail plus Tax. This is followed by the items including tax and should equal the Retail plus Tax . and the Deposit Totals from the Deposit UI. Finally, there would be a display of the difference between the Actual Deposit and the CAS Totals. This displays any shortages or overages to the deposit.

The following is an explanation of some of the headings :

• Extended Cost This will display the cost of the items sold

• Extended Retail Total amount collected on sales excluding taxes

• Tax Amount collected as a result of sales tax

• PLU Movement Total reported from CAS of all PLU Movement

• POS Totals Total reported from POS should equal Extended retail plus Tax

• Deposit Amount entered on Reconciliation UI

• Difference: Difference between Deposit and POS Totals

There will be a tendency to enter the media totals from the daily Summary Reports, they should be entered at the store level based on actual receipts so that they can accurately reflect outages.

Details

 

The user provides details and generates a financial reconciliation report. The user specifies the report by the venue, store or register, and then provides the dates between which the sales are to be reported. This report displays the user entry of the daily sales summary and the actual daily sales report and ensures that they match. The user then can generate the report or download the CSV file. The generated report provides the date, and the amount spent in cash, visa, MasterCard, AMEX, Discover, others, as well as a credit card total, the amount spent on debit cards and gift cards, and the total amount spent using cards for that day. The report also includes the amount spent using checks, coupons, and discounts. The report also includes the extended cost and retail, and the PLU movement, POS totals, deposit and the difference. The downloaded cvs file will also include the transaction count and item count (not on the pdf report).

Access

Access to this function at an enterprise level is limited by default to the System Administrator and Financial users only. Accounting, store managers, warehouse general managers as well as zone managers may view the Financial Reconciliation report at the venue(s) or store(s) assigned to them.

Item (SKU) totals with Tax

Some reports are configured to report totals at an item level that include tax, in these instances users may see a variance from the transaction level totals due to rounding.

At the PLU (Price Look Up) movement level tax is calculated at the individual PLU level and so there is sometimes a rounding variance, as in actuality tax is applied at a transaction level.

For example, consider the case of the following three items, where the tax rate is is 8.875%:

Item 1 12.82 Item 2 13.25 Item 3 17.35

At a transaction level, you have a total of 43.42 and a tax of 3.85, however, if you calculate the tax at a PLU level for report purposes; then you get a total of 3.86 after rounding calculated tax at each PLU level.

Again this happens because the tax is calculated and rounded at a transaction level.

Audit Report

Overview

Go to CAS --> Reports --> Financial--> Audit Report

Articles in this section

• Central Administration System
• Configuration
• Company Details
• Company Information
• Mail
• Payroll Settings
• Merchant Email Configuration
• Invoice Setup
• QSR
• Payment Settings

See more