Daily Sales Report : DSR in Hindi : Restaurant DSR with Different Channels

Daily Sales Report : DSR in Hindi : Restaurant DSR with Different Channels
Restaurant Daily Sales Report: Everything You Need To Know. In a nutshell, DSR or a daily sales report paints a picture of your daily sales, transactions, APC or APT, actual sales vs Target. The Daily Sales Report provides a list of transactions by date, and the sales in each transaction.
A daily sales report provides three key benefits to your restaurant:
1) Keep up with accounting
2) Be able to compare periods and identify trends
3) Match cash deposits to sales
For English Videos Follow my second channel : / @office-monk
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚 Please join this Channel to download the file:
Join this channel from the link below:
/ @officefreak
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📚File Link: docs.google.co...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
In this video I have divided sales in 3 different channels. Dine in, Take away & Delivery. You can create your DSR with Three, Two or even a single channel, based on the requirement and type of business.
#DSR #DailySalesReport #DailyReport #SalesReport #RestaurantDSR #RestaurantSalesReport #HotelDSR #Hotel #Restaurant #ResortSalesReport #CafeSalesReport #Cafe #CafeDSR #restaurant #Excel #advancedexcel
Topics Covered:
What is DSR
How to make DSR
How to make Daily Sales Report
How to calculate APC
How to calculate APT
Please Like, Share & Subscribe; #OfficeFreak

[@adilafridiofficial3388]

Tnx sir very impressive video for my job 🎉

[@adilafridiofficial3388]

Sir what is dine in sale Dine in Tickets APC/Apt ?

[@OfficeFreak]

Thank you 😊

[@OfficeFreak]

You can follow my English Channel. You will get many more interesting formats and topics over there.
youtube.com/@Office-Monk?si=MEumkTKjyS1yMNaS

[@OfficeFreak]

In restaurants there are 3 ways or channels of Sale.
Dine in : People eat their food in restaurants
Take away: People place the order and take their food as Parcel
Delivery: People order from home and get their food delivered.
Tickets: Number of transactions is alao called tickets. Means how many customers placed the order.
APC / APT : Average Per Cheque or Average Per Transaction.
How much amount 1 customer spent on 1 order

[@Meen.K1919]

Hello Vijay Sir, Minakshi here ❤❤❤❤ how are you (KFC)

[@OfficeFreak]

Call me

[@DomainofRyujin]

Thanks

[@artiaroda793]

❤❤ thank you sir

[@OfficeFreak]

Most welcome 😊

[@Official_Rocket]

Helo Sir Google sheet me ek daliy production report summary Attendance sheet ki trah banaiye but usme data ko add kare ge lekin jab mai next month ko tab select Kare to date cell balank ho or jab bichhe ka month select Kare to sare data show Kare please help me

[@Sarkar2_611]

thank u sir

[@OfficeFreak]

Thanks a lot for the appreciation. It really matters a lot 😊😊😊

[@mohitkumargiri7983]

Sir if we change the month then not change the fill data to month wise

[@OfficeFreak]

Hi Mohit, the data will not be blank if Months will be changed from the drop down. For 12 months we will have to create 12 work sheets or you will have to use Macros for that purpose.
You can follow my English channel too. I have got many more interesting formats over there.
youtube.com/@Office-Monk

[@deepreet9091]

Please make on video weekly report with summary

[@OfficeFreak]

Please check my another Channel. You will get bit advanced format of Daily Sales Report
youtube.com/@Office-Monk?si=d9-9WLbpchkzqJUT

[@gautamsah5075]

🎉🎉

[@OfficeFreak]

Thank you so much for loving the video and getting connected with the Channel. 😊
In case you want more interesting videos, you can get connected with my English Channel.
youtube.com/@Office-Monk?si=8GE2BDMn_L7Bc7q6

[@cramprajapat9352]

Sir me ek firm me kaam karta hun jaha kayi mode me payment lee jaati hai or agle din unki receipt banayi jaati hai or charges less kiye jaate hai jaise cash sale card sale upi sale finance sale or credit sale or ye amount alag bank account me received hoti hai to in sabka hisab ke liye koi achhi si dsr banayi jaa sakti hai kya

[@OfficeFreak]

Aisi sheet banayi ja sakti hai lekin phir woh DSR Sheet nahin hoga. Woh Banking Sheet ho jayega

[@Guru_Valmiki_Naam]

What is APC

[@OfficeFreak]

Average Per Cheque or Average Per Ticket / Transaction

[@sudhasahai2440]

How we add all months in one cell?

[@OfficeFreak]

It can be added in next columns. Format would be bit lengthy but ya, it can be adjusted

[@sudhasahai2440]

@@OfficeFreak can you please make a video on this?

[@OfficeFreak]

Sure. You can check more formats on my other Channel, Office Monk

[@sudhasahai2440]

@@OfficeFreak thank you