Sales day book is a spreadsheet analysis that is used for the calculation of goods sold out of a firm in a given sales day, week, month or year.. This topic in Microsoft excel is of importance to managements, as this can help them to know it they are making profits or running loss. Well, there are some functions (little formulas that are applied before the program starts functioning well. All the topics have their own formulas so please do not join them together, if you get confused along the way simply drop your question/questions in my comment box and i will pay attention to it.
The fields present in sales day book are as follows;
SERIAL NUMBER
DATE
NAME OF CUSTOMER
PARTICULARS
QUANTITY
RATE
COST
CASH
BALANCE
The serial number is our normal numeric values, numbering from 1-0. To get this in excel, all you have to do is to click on a cell and type the number (1). As you will see, the cell containing the 1 is an active cell, hence its border will be thicker and it will also have a thick dark spot at the bottom right. Now all you have to do is to take your cursor to that spot and click and hold and drag it downward, holding down your control key, when you get to your destination, LEAVE THE CONTROL KEY BEFORE LEAVING THE LEFT CLICK BUTTON, you will see the numbers is order from 1-20 as the case may be. Another way of doing this is by holding your left click, drag it to the button without holding your control key, after leaving the left click you will notice what you will have is a repeated figure like....
Now at the bottom left you will see a discussion box, click on the arrow and select FILL SERIES, all the numbers will be arranged in order.
Date: the date has to be the present date,Well it has its own formula but the formula can be wrong when you have a wrong date in your system, so it is advised that you correct your date in your computer before applying the formula. What you have to do is click on the cell you want to add the date to and type either of the formula's below
=NOW()
=TODAY()
=DATE()
If you want to apply the date according to the number of serial numbers you have, you don't need to repeat the formula again, all you have to do is to click on the answer given to you by the formula and click and hold and drag downward without holding the control key... (THIS VIDEO IS HERE FOR BETTER UNDERSTANDING)
Name of customers: These are the names of the customers that bought from that firm at that particular day.
Particulars: these are the goods bought by the customers. If the goods bought are in series or models, they should be specified with the aid of a bracket.
Quantity: this is the number of particulars obtained by the customer.
RATE: this is the cost of one of the particulars, if the goods bought are 3, how much does one cost?
Cost: this is the amount the firm sold a product, hence multiplying quantity and rate will give you this amount. Formula is =SUM(E5*F5), if the fields are much, there's no need of repeating the same formula, all you need do it click and hold and drag for the answer to be applied to all.
Cash: this is the amount deposited by the customer for the purchased goods. This is not a fixed amount, while doing this we can assume the amounts in percentages, the formula is =SUM(G5*90%). where G5 is the cost and the customer paid 90% of the actual cost amount.
Balance: this is the remaining amount the customer will be paying to the firm. =SUM(G5-H5), WHERE G5 IS THE COST AND H5 IS THE CASH...
For better understanding study the image below.
The fields present in sales day book are as follows;
SERIAL NUMBER
DATE
NAME OF CUSTOMER
PARTICULARS
QUANTITY
RATE
COST
CASH
BALANCE
The serial number is our normal numeric values, numbering from 1-0. To get this in excel, all you have to do is to click on a cell and type the number (1). As you will see, the cell containing the 1 is an active cell, hence its border will be thicker and it will also have a thick dark spot at the bottom right. Now all you have to do is to take your cursor to that spot and click and hold and drag it downward, holding down your control key, when you get to your destination, LEAVE THE CONTROL KEY BEFORE LEAVING THE LEFT CLICK BUTTON, you will see the numbers is order from 1-20 as the case may be. Another way of doing this is by holding your left click, drag it to the button without holding your control key, after leaving the left click you will notice what you will have is a repeated figure like....
Now at the bottom left you will see a discussion box, click on the arrow and select FILL SERIES, all the numbers will be arranged in order.
Date: the date has to be the present date,Well it has its own formula but the formula can be wrong when you have a wrong date in your system, so it is advised that you correct your date in your computer before applying the formula. What you have to do is click on the cell you want to add the date to and type either of the formula's below
=NOW()
=TODAY()
=DATE()
If you want to apply the date according to the number of serial numbers you have, you don't need to repeat the formula again, all you have to do is to click on the answer given to you by the formula and click and hold and drag downward without holding the control key... (THIS VIDEO IS HERE FOR BETTER UNDERSTANDING)
Name of customers: These are the names of the customers that bought from that firm at that particular day.
Particulars: these are the goods bought by the customers. If the goods bought are in series or models, they should be specified with the aid of a bracket.
Quantity: this is the number of particulars obtained by the customer.
RATE: this is the cost of one of the particulars, if the goods bought are 3, how much does one cost?
Cost: this is the amount the firm sold a product, hence multiplying quantity and rate will give you this amount. Formula is =SUM(E5*F5), if the fields are much, there's no need of repeating the same formula, all you need do it click and hold and drag for the answer to be applied to all.
Cash: this is the amount deposited by the customer for the purchased goods. This is not a fixed amount, while doing this we can assume the amounts in percentages, the formula is =SUM(G5*90%). where G5 is the cost and the customer paid 90% of the actual cost amount.
Balance: this is the remaining amount the customer will be paying to the firm. =SUM(G5-H5), WHERE G5 IS THE COST AND H5 IS THE CASH...
For better understanding study the image below.
Ready To Be Make Elegant Blog
Subscribe to KOKOCOMPUTERS to enjoy Free Tricks
ReplyDeleteHow do you skyrocket your book sales without a bigger platform, email list, paid traffic, or PR?
It starts by understanding how your readers buy books today, and how you can reach them (without a huge marketing budget).
I've found something that can show you how.
Bestseller Ranking Pro provides authors and publishers with live data on every single bestseller list on Amazon for eBooks and physical books (all 19,669 of them and counting), as well as advanced video trainings on how to maximize your sales and sales rankings on Amazon.
Check it out here: http://XXX.bsrpro.hop.clickbank.net
If you haven't met Tom Corson-Knowles yet, the author who created Bestseller Ranking Pro, I think you'll find his story inspiring.
Like most authors who have been in the game for years, the only signs of interest Tom got from publishers were rejection letters. After six years of trying to get a traditional publishing deal, he finally decided to self publish his first book on Kindle in February, 2012.
It was a life-changing decision.
Just twelve months after publishing that first book, he had his first $12,000+ month from Kindle ebook royalties alone!
You can learn how in this video. These strategies have also helped him and his clients become #1 Amazon bestselling authors.
If you're going to write, publish or promote a book this year, you need to see this:
https://bestsellerrankingpro.com?jfgsu8945639dg7gnk
Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. אסטרטגיה תדמיתית
ReplyDeleteI think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. קורס מכירות
ReplyDelete