“If you’re looking for a storage for your data, you can use Microsoft Access instead, but its seems to be more difficult to deal with compare to Microsoft Excel. (Small businesses). If you don’t want to use Microsoft Access, here deal with user-friendly Microsoft Excel. “
Accounting is part of our daily lives, even in your personal life. Like if, you are buying fruits in the market of which part of this will consumed or part of this will resell to your customers at your selling price everyday. And everyday there’s a transaction, but how will you handle this data for your analysis? Well we can keep Accounting Data Records ,simplified and organized using what we called Worksheet or General Journal book. (Manually)
What if, you got a lot of unexpected customers in just a certain period. Over thousands of fruits were buying and selling, can you handle this large, complicated, and unstructured data? how?
Indeed we can handle it in no time, how? it’s easy, if you have your Microsoft Excel (i preferred Excel 2007 up) installed on your computer, then this is it!
Let’s begin with the idea, the idea of how we organize our data
Usually, I start with the Data Entry
(assuming merchandising business)
- Open your Excel Program
- Rename your worksheet as “Data Entry Purchases”
- Now, think what are the factors that will affect the transactions. Examples
- Selling Price
- Unit Cost
- Total Sales
- Total Cost
- Customer/Client’s Name
- Document Numbers
|Date||Items||Quantity (kg)||Unit Cost||Total Cost||Docs No.||Transaction no.|
Note: You will notice the formatting is like presenting in a table, the reason why is to handle easily by the system in well organized manner. I recommend this format so that you don’t have to worry in creating an output data.
- Note: It’s very easy to make a report than to make a data entry