how to make z report

Please enable JavaScript to view this site.

• Zoom Window Out
• Larger Text  |  Smaller Text
• Hide Page Header
• Show Expanding Text
• Print Topic
• Send Mail Feedback
• Share This Topic
• Save Permalink URL

Every time you are closing the cash register , the printer for orders can print a sales overview for the specific shift, the so-called Z-report. To print the Z-report, in the settings of the corresponding printing task activate the option Automatically print ZReport . All the data in the Z-report relates to the operations performed while the cash register is open until it is closed.

The Z-report is identical to the data you find in the Sales overview . You can also print the Z-report or email it anytime from there. If you want the Z-report to be sent automatically by email after closing the cash register, go to the Application settings and set this option in the item Email Summary Reports .

Which items can I find in the printed Z-report?

You can define the items in the Z-report. In the Application settings go to the menu Print and adjust the corresponding printing task - enable items to be specified in the Z-report. An example of the Z-report is shown below.

Keyboard Navigation

F7 for caret browsing Hold ALT and press letter

• Ask a Question
• Write a Blog Post
• Login / Sign-up

Z-Report Preparation

Hi, I want to know basics in preparing the Z-Reports. I mean when you do confirmation where the data will be saved? the table name that appears in CO11N screen (by clicking F1-> Tech info) will remain same when we save? or will it change? any specific steps req? pls help.

What is Meant by Z Report and Where it is Used?

Updated May 04, 2023

In SAP, a Z report refers to a customized report developed by a user or a developer using ABAP programming language to meet specific business requirements.

The term "Z" stands for "customer-specific," and it indicates that the report is not part of the standard SAP system. Z reports can be created for various purposes, such as financial reporting, inventory management, and sales analysis, among others.

Uses of Z Report

Z reports are custom reports developed in SAP to meet specific business requirements. Here are some of the uses of Z reports in SAP:

Customized Data Analysis: Z reports are developed to provide customized data analysis that is not available in standard SAP reports. Users can extract data from various SAP modules, manipulate it as per business requirements, and present it in a meaningful format.

Enhanced Reporting: Z reports allow users to develop reports with enhanced functionalities such as drill-down capabilities, data filtering, and sorting options, among others. This helps users to analyze data at a more granular level and make informed business decisions.

Increased Efficiency: Z reports help organizations to automate and streamline their business processes. By providing users with customized reports that cater to their specific requirements, it reduces the time taken to gather and analyze data, enabling users to focus on more critical tasks.

Compliance Reporting: Z reports can be developed to generate reports that meet regulatory requirements, such as financial statements, audit reports, and tax filings. These reports ensure that the organization is compliant with various regulations and laws.

Integration with Other Systems: Z reports can be integrated with other systems to provide a seamless user experience. For example, a Z report can be developed to extract data from an external system and present it in SAP, enabling users to view all relevant data in one place.

How to Create a Z Report in SAP?

To create a Z report , a developer would typically use SAP's report development tools such as SAP Query, ABAP List Viewer (ALV) , or Business Explorer (BEx) to extract data from SAP's various modules, transform and manipulate the data as needed, and then present it in a meaningful format to the end-user.

Once the Z report is developed and tested, it can be added to the SAP menu for easy access by authorized users. Z reports are essential in SAP because they provide custom insights into business operations that are not available in the standard SAP reports.

Note: Creating a Z Report requires knowledge of ABAP programming language and access to the SAP ABAP Workbench.

To create a Z Report in SAP GUI, you can follow the steps below:

Enter t-code  SE38 in the SAP GUI command field and hit Enter  to open ABAP Workbench

In the next screen, enter the report name starting with "Z" in the Program  field and click the Create  button to create a new report.

Now enter a short description in the Title  field and also select Type and Status of the report.

• Click on the Save button to save the report

Next choose the Package and Save the report into it or you can also save it as Local Object .

In the next screen, you will see the ABAP Editor . Here, you can write your ABAP code to define the logic of your Z Report .

Test your report by clicking the Check  icon to ensure that the syntax is correct.

Click on the Save buttom to save your report in Abap editor.

A message Program ZSTECH saved willbe displayed in the bottom of screen.

To run your Z Report, return to the SAP Easy Access screen by entering t-code SA38  in the SAP command field and hit Enter .

In the next screen, enter the name of your Z Report in the Program  field and hit Activate icon to activate objects of the report.

• A message Object activated will be displayed.

• Now click on the Execute button to run your Z Report .

The output of your Z Report will be displayed on the screen.

You have successfully created and executed a Z Report in your SAP ABAP system.

Whenever you want to develop Z reports first under stand the client requirement, where SAP standard program is not supporting there we will develop Z Reports or Functional specifications. Once you understood the client requirement you take which fields and table names are required. After you prepared all that information provides to ABAPER . ABABERS will develop the Z reports according to your information provided by you.

Thank you and Is there any other reports like this which we come across usually in support while dealing with tickets.

Actually if you know can you provide me the basic info about role of a support consultant means how they deal with tickets and all.

Z reports is nothing but Customizing the reports as per your requirement with the help of ABAP consultants.

• What is SAP FICO?
• SAP FICO Define Account Group
• SAP FICO Reverse Clearing Document
• SAP FICO User Exit for Vendor Master
• FICO Vendor Account Group Table
• SAP FICO Withholding Tax
• SAP FICO Posting Key for Bank
• SAP FICO Document Type
• SAP FICO Parked Workflow Configuration
• SAP FICO GL Account for Cash Journal
• SAP FICO Accounts Receivable Process Cycle
• SAP FICO Accounts Receivable Configuration
• SAP FICO Chart of Accounts
• SAP AS11 Create Asset Sub-Number
• SAP Business Area and Profit Center
• SAP Inconsistent Withholding Tax Info
• SAP FICO Scope and Opportunity
• FICO Certification Cost in India
• SAP FICO Interview Questions
• SAP FICO Tree Menu
• SAP FICO Training Tutorials for Beginners
• Foreign Currency Valuation Configuration
• SAP FICO Dunning Area
• SAP FICO Cash Management Group
• Assessment Cycle vs Profit Center
• SAP FICO Asset Accounting
• SAP FICO Document Number Ranges
• SAP FICO Classic GL vs New GL
• GR/IR Accounting Entries and Journal Entries
• SAP FICO Transaction Codes
• SAP Active vs Passive Document Splitting
• Reverse MIRO Document in SAP

Z Report explained

When performing the End of Day process, the Z Report is designed help you balance your tills.

• Register Number
• Employee ID
• Shift Number
• Shift Start time
• Shift End Time

Contains the main details for the store sales for the shift/terminal across all payment methods.

• Sales – total value of sales for shift/terminal including taxes.
• Returns – total value of any return sales for shift/terminal including taxes.
• Taxes – total value of any taxes for sales and returns for shift/terminal.
• Discounts – sum of any discount amounts for sales and returns for shift/terminal.
• Rounded – sum of any rounding that has occurred on transactions.
• To account – sum of any customer account. payments for shift/terminal

To calculate the overall banking figure for the terminal/batch, the formula is: (Sales - Returns - Rounding) + (To Account - Expense) .

The sample (above) returns the following banking figure: $50.93 - (-$0.01) + $25.00 - $10.00 = $65.94

Provides statistical information on the shift/terminal.

• Sales – count of unique receipt numbers (Customer Count).
• Customer Sales – count of transactions that have customer account added to transaction (loyalty, account customers).
• Voided Sales – count of voided transactions.
• Logon – count of logons.
• Open Drawer – count of open drawer.

This section currently does not have any overall totals value. You can balance this to the Banking calculation above using the following formula: (Tendered - Change) .

The sample (above) returns the following figure: $70.00 - $5.05 = $65.94

Provides a summary of all of the different payment methods for the shift/terminal.

• Tendered – sum of all different payments for the shift/terminal.
• Change – sum of all change for shift/terminal.
• Started – value for any shift starting amount if entered when shift is opened.
• Added – sum of any float entries for shift/terminal if entered.
• Removed – sum of any tender removal entries for shift/terminal if entered.
• Bank Drop – sum of any bank drop transactions for shift/terminal
• Safe Drop – sum of any safe drop transactions for shift/terminal.
• Counted – sum of amounts entered into tender declaration for shift/terminal.
• Short – sum of short and over amounts for shift/terminal (only useful if doing tender declaration).

Provides detailed information for each of the different payment methods, expense and income transactions for the shift/terminal.

If there are expense of income transactions, the Tenders section shows the amount (as illustrated).

For the other payment methods, the fields displayed on the Z Report depend on the payment method being set up or not.

For example, Cash is normally setup to be counted, whereas Cards (EFT) and Customer Account are usually not set up to be counted.

If the payment method is not set up for counting, the following fields are used:

• Added – shows any added amounts for payment method generally would only see for Cash Payment method and would only occur if we declare starting amounts for shift.
• Collected – system generated sum of transactions for payment method for shift/terminal.
• Removed – sum of any amounts removed for payment method again generally only would see for Cash payment method and would relate to actions like Safe Drop or Bank Drop.
• Transactions – count of non-void transactions for payment method.

If the payment method is set up for counting, then two additional fields are included on the report:

• Counted – the value that has been counted and entered into a tender declaration before the shift was closed.
• Short or Over – the difference (if any) between the Collected Value and the Counted value. It is shown as Short if the Counted value is less than the Collected Value; it is shown as an Over if the Counted Value is greater than the Collected Value.

Search is based on keyword.

Ex: "Procedures"

Do not search with natural language

Ex: "How do I write a new procedure?"

Z Report explained - Any tips we missed? Need more information?

Email [email protected] with your help topic request.

Learn at your own pace, tailored to your role

• Troubleshooting
• Hospitality tips and advice
• Kobas: Complete Hospitality Management
• Kobas online learning
• Configuring your account
• Food Hall clients and traders
• Card Machines
• EPoS Basics
• EPoS Advanced
• Discount and availability changes
• MPoS & VEPoS
• Kobas Display System
• Compliance & Task Management
• Stock Management: Recipe Set up
• Stock Management: Deliveries & Usage
• Stock Management: Counting & Analysis
• Configuring your CIC
• Mobile Ordering (to table, delivery & collection)
• Customer Database (CRM) & Loyalty
• Gift Cards and Loyalty Campaigns
• Reservations
• Recruitment
• HR Management
• Rota & Payroll
• Holidays & Time Off
• Kobas Cloud Reporting
• Report Engine
• Reporting explored
• Payment Services
• Accounting and finance
• Reservations and bookings
• Online ordering and loyalty
• Benefits and communication
• Marketing Integrations
• Knowledge Base

Your Till Z Report Explained

This article gives you an explanation of the z report that is generated when you "close session" at the end of your days trade..

Last updated 9 August 2022

Introduction

• What is the Till Z Report
• How to read the Till Z Report
• Printing previous Till Z Reports

The term X and Z reading or reporting is a legacy term that comes from historic manual standalone tills. The letter coding was a short code on a till that would have been overrun with buttons and options to physically press. 

Typically, the X Report is used mid-day and the Z Report is used at the end of the day. They both summarise the transactions of your venue, however, the purpose of the X Report is that you can read and print the information, without "Closing the session".

Kobas EPoS utilises the concept of "sessions". For most of our clients, each "session" will equate to one day of trade. However, you may wish to close the session if you close for lunch, for example, generating two sessions per day. Once you choose to Close Session this will close the session and automatically open the next. You will then be able to view  Z Report for the session you have just closed.

Your venue's  Closing Tasks must be completed per day. Therefore you have to choose which sessions to attach to which Closing Task, where more than one exists. If you don't  Close Session and have sales from several days on one "session", it cannot be split and those sales have to be attributed to one particular day.

What is a Till Z Report?

The Z Report is typically used for "cashing up" (or End of Day Financial Reconciliation) and its purpose is to inform you what the EPoS system believes you should have in Cash/Card/etc based on what has been put through your till. A Till Z Report consists of a number of individual lines, each of which is explained below this demonstration report.

To generate  Close Session  and therefore generate your Till Z Report; on your Kobas EPoS, click the Admin > Till X Read . When you hit the red button on this screen, it will "Close the session" meaning that a new session will be generated at that point and the Z Report will print. 

Warning: You will be unable to  Close Session if there are outstanding reservations for that day, or if you have open tabs and your venue is set to only allow the session to be closed if there are no outstanding tabs.

How to read your Till Z Report

The Z Rreport is split into various sections, to allow you to find the data you need quickly. The two headline figures are:

• Total Payments : The physical payments you have taken that day to be reconciled, calculated as Total Cash (which is less refunds) + Total Card (including tips and service charge, less refunds). 

Note: Other forms of payment such as Other Payment Types, Fixed Discounts, Deposits Redeemed and Gift Vouchers are detailed further down. As these represent pre-payments, or payments received outside of the venue, they are not actively reconciled in the venue with that session's takings. As such, they are displayed separately. 

• Tax : This figure is calculated from the Total Payments  figure, but may also include tax incurred by a historic pre-payment (as tax is due on the sale value when pre-paid for). The Tax figure is calculated from payments rather than sales, as items sold in a previous session, but paid for in the current one, will contribute to the figure.

There are two important observations to make here:

• Total Expected Payments  figure from Till Z is also presented in the Cash Log in Cloud. This figure will differ from your Total Sales figure in various different reports and Cloud locations.
• Total Sales figure is taken from the monetary value of items when items are sold, Total Expected Payments  is the sum of all payments made in the session.

Totals Section

• Total Sales (Gross): Amount of all the items you’ve sold in this session minus  Total Refunds  and  Total Fixed Discounts . It doesn’t matter if everything is paid for today, this is purely a measure of the trade you’ve done. It’s worth noting that the value of items added to tabs in a previous session but closed in your current session will not show here.
• Tab Outstanding Credit : A snapshot figure of the total value held on currently open tabs.
• Total Cash: Total of all payments taken in cash. This will include Service Charges .
• Total Cards: Totals of all payments taken using any card. This will include Services Charges  and  Tips .
• Total Deposits Received: Deposits received on EPoS during this session. 
• Total Deposits Redeemed: Accounts for deposits we have already received which are being used as payment for services in this session, and as such are fed into variance calculations.
• Total Deposits Refunded: All deposits that were refunded on EPoS during this session.
• Total Gift Vouchers : Value of sales that have been paid for using a pre-paid Gift Voucher.

Other Payments

• Total monetary value of sales paid for using the "other payment types" set up in your account. 

Reservation Payments

• This section logs payments associated with Reservations.
• The total monetary value for Comp, Directors, Waste, Refunds, and No-Sales.

Sales Section

• Gross Sales: Total sales in this session before tax is deducted.
• Net Sales: Total sales after tax has been deducted.
• Sales Tax:  Amount of tax on sales.

Gross Sales Breakdown

• This section provides a breakdown of total monetary sales for each Lead Type such as Food ,  Wet ,  Other , etc.
• The latter half provides a breakdown of total monetary sales for each Consumption Mode  Eat-In ,  Takeaway , and  Delivery .

Refunds Section

• Total Refunds: Same as shown in the Totals section.
• Food  Refunds, Wet  Refunds etc show the breakdown of  Total  Refunds  based on the category assigned to each item refunded. If you have other categories such as Door Entry, Cloakroom or Tobacco etc, they will show as extra lines in this section.

Tabs Section

• Number of Tabs: Sum of tabs that have been created in the session. If a tab was created on a previous day, it will not be reflected in this number, even though you may have added orders to it.
• Tab Revenue: Sum of all payments (including part payments) taken for tabs in this session.
• Tabs Outstanding Credit: Same as in the Totals section.
• Tab Credit Change This Session: A running total of the changes in credit during these sessions. As tab credit increases, so will this figure. This figure will reduce as credit is paid off, therefore this figure can be negative. When all Tab Credit is settled, the total will be zero. 
• Covers: Number of people assigned to the tabs created this session. If you have tabs open from previous sessions they will not be included in this figure.
• Tabs Without Covers Set: Gives this information as a total number.
• Average Spend Per Head: Calculated by taking the revenue taken on tabs where covers are set, then dividing that total by the number of covers.

Gratuity Section

• Service Charge – Card:  Amount of service charge added to tabs that have been paid off this session using a card only.
• Service Charge – Cash: Amount of service charge added to tabs that have been paid off this session using either cash only or a mixture of cash & cards.
• Service Charge Earned: Totals the above two figures.
• Card Tips: Total of all overpayments made on a card. Note – Kobas assumes that all tab cash overpayments are changed. If this is subsequently left as a tip, or indeed a different amount is left, there is no provision for recording this at present.
• Voucher Tips: Total of tips received via the CIC Online Ordering.

Others Section

• Total Orders: Amount of orders placed today. This includes orders added to tabs that are still open at the end of the session.
• Total Items Sold: Number of items on all orders placed today. This includes items added to tabs that are still open at the end of the session.
• Average Order:  Mean value derived from the total of all orders placed this session, divided by the number of orders placed.
• All Promo Sales: Total of all items sold that have a promotion applied to them. This could be £10 off, 3 for 2, 15% off food or X + Y for £8 etc. Orders added to tabs that are not settled still show here.
• Total Fixed Discounts:  Amount of payment taken in the form of Fixed Discounts. That means it’s discounts like £10 off rather than 25% off or 3 for 2 etc.
• Total Forfeited Pre-Paid Vouchers:  Total amount left over unused by the customer from Gift Cards and Fixed Discounts.
• 10pm  &  Midnight Sales: Total of items sold this session up to this time. Items on orders added to tabs that are not settled still show here.
• Price Adjustments Up  &  Down: Shows how much manual price adjustment has been done on the till during this session.

Top Tip:  Using the button at the top of the Till Z screen you can print out your Till Z Report for each individual till or all tills combined.

Previous Till Z Reports

By going to Admin > Journal > Till Z you can print any of the past three months of Z Read's from this venue.

Also read:  Take a look at our  Other Payment Types  article and consider if you need to set any custom payments types.