you are an accountant, regular person or you have a small business and would like to make excel help you to manage your financial issues, follow up these posts and you will learn very important things
this place doesn't target the expert person, but it target the person who would like to start his/her way to be an expert
- A very simple way that will provide you with most of the skills to perform financial math using Microsoft Excel
- It will help you to make a future plan or forecast for your business or personal financial management
- see your products movements and make products category (moving, slow moving or non moving items)
- manage your expenses and monitor your expenses budget
- years, months comparison to know where you are and make future plan
send your idea and believe that there is no impossible in this world
----------------------------
start your idea from first step
what is the value data you have to start your analysis
1 - Income 2 - Expenses 3 - what you have on hand (Products)
4 - Import 5 - Net Profit
Income is coming from the products we sell (minus) the landed cost of the products we sell (L/C) and the OUTPUT will be the Gross Profit (GP)
Expenses is coming from what we pay to make the business going like ( salaries, telephone bills, Rents, Commissions, Transportation, ............ Etc)
Products is coming from Stock on hand (S.O.H.)
Import is the products we buy from suppliers for selling to the customers or the retailers ( depends on the category of your business)
Net Profit is the Gross Profit (Minus) total Expenses
the next step is how we can use these data and numbers in excel to make our analysis and statics
-----------------
FIRST STEP
you have to make a new Excel File
* Right click - New - Microsoft Excel Worksheet
* To change the file name ( Select the the file and press F2 on Keyboard
After making a New Excel File
Open the file and Create Sheets ( press on +) and change the Sheet name by double click on the every sheet Tab or Right Click then Rename ( then write a new name)
The Income ( Sales & GP )
As it shown in the previous picture, we will start from Sales sheet, which will show as the daily sales per Salesmen, Groups or Sections
we will add the Gross Profit (GP), Total Expenses, Net Profit or Loss (P/L), Monthly Sales & Sales Comparison with Previous Months of Last Year
let's start by practical ways.....
Target sheet
In this sheet we will make target details for the current year compairing with the actual monthly sales & compairing with last year sales to know our position against target & last year achievement
We can make the mentioned details per salesman, department, group, or total company Here we going to practice in total company sales
------ > To Be Continued
You can send me a comment with any idea to add it or make a new post
