How to keep a Sales Day Book with Analysis in Excel - [2021]

In this video we show you how to keep your Sales data in a Sales Day Book Excel template and then how to perform some useful Sales Analysis routines.
You can follow the Excel methodology throughout the tutorial and work at your own pace.
here is the download link to this template -
mrspreadsheet.com/products/fr...
Our Sales Analysis spreadsheet includes sections on:
Sales Tax calculations
performing arithmetic data checks
using Excels ROUND() function
inserting filters and using the SUBTOTAL(9) routine
creating a customer list using the Data Validation tool
and using the SUMIF command to perform analysis at the customer level
Here are the links to the various Mr.SpreadSheet resources available to you.
Please help support our channel by subscribing.
Many thanks
Free Sales Day Book - www.MrSpreadsheet.com/product...
You can also visit our websites at:
USA & Canada & World - www.MrSpreadSheet.com
UK & Europe - www.MrSpreadSheet.co.uk
Or our Social channels:
FaceBook - / mrspreadsheets
Instagram - / mrspreadsheet
Twitter - / mr_spreadsheet
#MrSpreadSheet #Excel #spreadsheet #exceltutorial #msexcel #Accounting

[@user-ye7yt6fw4b]

I have been following your Tutorials , you are the best of the best

[@MrSpreadSheet]

Glad you like them! :-)

[@asimsiddiq475]

thank you.

[@MrSpreadSheet]

Welcome!

[@junpetjohnson1263]

Very good informative

[@MrSpreadSheet]

Glad you think so!

[@amadougitteh2058]

cool contents

[@MrSpreadSheet]

Thanks once again ...

[@gowthamdsp1042]

👌👍

[@MrSpreadSheet]

Thank you ...

[@nozisikhonde6426]

This is yet again a fantastic video, thank you. However, what sort of analysis would one do for a business that issues receipts and customers are never the same such as a pharmacy or grocery store?

[@MrSpreadSheet]

Hi Nozi, That would depend on your individual requirements, you could 'generalize' or be 'specific'. You would just need to create the Analysis types. :-)

[@nozisikhonde6426]

@@MrSpreadSheet Please assist with just a few ideas in terms of analysis types if you can. Thank you

[@NgoniDamison]

In classifying sales as Sales A; Sales B...Sales C etc., What would be the reason for this kind of sales analysis or split? Please give examples if any?

[@MrSpreadSheet]

Hi Ngoni, Lets say you sell computers, you could have a sales analysis of Computers, Software and Services.

[@NgoniDamison]

@@MrSpreadSheet Okay, all on one invoice. I understand. Much appreciated. Whenever you can please do a separate video on the classification, maybe of sales and expenses. Your videos I must say are very useful, practical & well presented. Thank you!

[@robiluckdeejayofficial256]

Can you design for me pharmacy Excell template. We I can balance stock in and out.. plus purchase.n general stock

[@MrSpreadSheet]

Hi, Yes, I'd love to, but there are tooo many other work commitments :-)

[@trex6230]

Hi Mr spreadsheet can you design a rental income spreadsheet

[@MrSpreadSheet]

Yes, this is something I am considering :-)

[@gowthamdsp1042]

i need a copy please

[@MrSpreadSheet]

Hi, please see the guide at the end of the video

[@NgoniDamison]

I dont understand why on the calculation of tax , you are saying 20/120 *1200? ...or is it supposed to be 20/100*1200?

[@MrSpreadSheet]

Hi Ngoni, this formula calculates the net value from a gross figure. This is fine for UK Tax, your local taxes will require a separate formula depending on how the tax is levied.

[@NgoniDamison]

@@MrSpreadSheet Many thanks for your response, and it makes sense now, I get it- I am much smarter from watching your very informative video. Thanks again!

[@nicoletaradulescu1442]

Hi - the formula for tax is wrong- it should to be 20/100*F7= 240 - and no 200

[@MrSpreadSheet]

Hi Monika, 20% Tax on a Gross Value of 1200.00 is 200. Are you confusing Gross with Net ?