We make sure you are familiar with the name excel, if not ya .. kayakanya little trouble dech .. should first learn microsoft office (Word, Excel, Access, Power Point). Since then the formula that we want to create a development of basic Excel formulas. Also more importantly you also have to understand accounting theory, ie at least you can journal. Because it is this writing for those of you who have studied accounting, but also had to learn Excel.
The steps outlined are as follows:
Make No and name in Sheet1 Estimates
Create a blank / table for the journal in Sheet2
Create a blank to make the balance sheet at Sheet3
Create a view to profit and loss in Sheet4
Create a view to balance the Sheet5
Make No and Name of Estimates
No and name of the estimates follow the rules in accounting theory, and the future can develop their own. Estimates adjusted kebutuah company premises means every company must have a type of use within the different transactions. But the outline will remain the same, so we know the major in accounting estimates, as follows:
PROPERTY
LOANS
CAPITAL
REVENUE
COST
That is the main assessment, but you can just add / grouped into a form other than the above estimates, for example, to No.6 plus OTHER INCOME and No.7 with OTHER FEES. That's up to how you make it. Then it becomes no initial number estimates serve targeted groups, meaning that there are still some digit number that need to be added for a more detailed estimate.
So you can create for example 1102 = Bank, 1103 what else, and so on. That is if keompok Current Assets. But if a group of Fixed Assets, you must exchange ANGA second to 2, so it looks like
And so also for the other estimates. So the point is for the first digit is the main estimates, the second digit is a division of the main estimates and the next digit is the type of estimates that will be used. Can also estimate the distribution of the main uses 2-digit number that can be a lot.
nice..
ReplyDelete