Please enable JavaScript to view this site.

RanceLab Software User Help

Main Menu > Sale Management > Reports > Day End Report > Day Audit Report        

In Day End report, a new button ‘Day Audit’ has been added. It provides daily activity report of an outlet at the day end.

The system can email this report automatically using the Email Scheduler

A sample report in PDF format can be seen here.

Sale Summary

This is a summary report of sale.

Gross Sale

Gross sale amount is calculated by the following formula excluding discount and charges.

Gross sale = Quantity * Rate

Net Sale

Net sale amount including discount and charges with gross sale.

Tax Total

Total amount of tax including all available tax.

Total Sale

Total sale including net sale, total tax amount, other charges, other discount and round off amount.

 

MOP Analysis

This is an analysis report of MOP including tip amount.

 

Key Performance Indicators

Start Bill Number

Starting bill number of the sale transaction for the given period.

End Bill Number

Ending bill number of the sale transaction for the given period.

Pax

Total number of customer.

Avg Amt Per Pax

Average bill amount per customer.

No of KOT

Total numbers of KOTs are generated.

No of Transaction

Total numbers of transactions are generated.

Avg Amt Per Transaction

Average amount per sale transaction.

Void Bills

Total number of void bills.

Void Qty

Total quantity of items which are void.

Void Amount

Total amount of void transaction.

 

Group wise Sales Analysis

 

Sub Group Wise Sales

 

Operator Wise MOP Analysis

Tax Analysis

Type Wise Sales

   Type Wise Sales based on the type of product defined in product master

 

Discounted Invoice Detail

It lists all the invoices of the day where discount is applied with discount reasons.

Void/Modified Invoice Number

It lists all the invoices of the day having void with cancellation reason.

Invoice No

Invoice no of the void or modified sale transaction.

Product

Item name which is void or modified.

KOT time

Time of KOT generation.

Void  Time

Time of void of the item.

Void By

The name of the user who void the items.

Cancellation Reason

Cancellation reason of the void of any item.

Qty

Quantity of the time which is void or modified.

Amount

Amount of the void or modified item.

After Void

Amount after void item.

After Print

True – If any item is void after print bill.

False – If any item is void before print bill.

 

Re-Print Invoice Number

It lists all the invoice that has been re-printed with number of prints.

Unsettled Invoice Number

It lists all the invoices that are still open.

 

Credit Invoice number

It lists all the invoices where mode of payment is credit sale.

 

Enhancement in Day Audit Report

Scenario:

Need sale return transaction amount involvement in Day Audit Report. Now Gross Sale & Net Sale at Day Audit Report only comes with sale data.

The requirement is to show total net sale after deduction of sale return data.

 

Solution:

In the Day End report - Day Audit Report(ctrl+D) Added a new section for Sale Return like Sale with the following field.

Gross Sale Return

Charges

Discount

Net Sale Return

Tax Amount

Other Charges

Other Discount

R/o

Total Sale Return

Net(Sale-Sale Return)

 

 

Note: Now we will show Tax and MOP Analysis excluding Sale Return Amount.