The formula for the Journal

Once we make the list in Sheet1 or sheet approximate estimate, then we create a table for the journal is on Sheet2 (Sheet Journal), then the next step is to create a formula that is used for the journal.

In a journal that later we would type the code from estimates like those in The estimate sheet. Estimated Cash For example, we simply type the number 10 101, type the number 410 101 Perndapatan estimates. In this case we simply use the formula Loookup, which takes data from the auxiliary table (Estimates), which, because of its vertical, then the formula is vlookup.


The formula is as follows:

= VLOOKUP (CLICK CEL CODE, CLICK THE ESTIMATE SHEET BLOCK CODES AND NAMES ESTIMATE ALL PRESS F4, 2.0)

If you follow the formula above.

= VLOOKUP (B6, Estimates! $ A $ 5: $ B $ 44,2,0)

Explanation of the formula above:

B6 is the first cell where the latter contains the code estimates

Estimate! $ A $ 5: $ B $ 44 is the name of the estimates and cel sheetnya in the block beginning from A5 to B44 and in absolutkan by pressing F4 to exit a sign of the dollar. Cell A5 to B44 is a cell that contains the code and name of the Estimates.

2 is the name of the estimates, which is the second column of that on the block earlier.

0 are the cover of a formula or False means (other than those blocked last meaningful one because beyond the range of range / block).

The results are the # N / A. This happens because there are no codes that must be filled at the time of journal. So do not be confused ...! Then please copy down as much as you want, but expect to taste aja ya .... Do not get too excited, it will be added if less.
Example:
Date 20-Jan-08 Received cash as additional capital of Rp. 500.000

So the journal is:

Cash 500,000

Capital 500,000

So to menjurnalnya, the contents of the date first, then type the code 10 101 for cash, then the contents of such Description Receive cash for additional capital or the other is also not what is important disconnected. Estimates are not on the contents of the column as it will appear automatically. Do not forget to fill 500,000 in the debit.

Then the bottom row of his content is also the same date and type code 30 101 for Venture Capital, wrote the same statement made by the above (copy not only the above information kebaris below) and fill in the amount of 500,000 in loans...

Related Post :