| Template 18 |
| Journal/Ledger Worksheet | | | | | | See Chapter 20 for a discussion of this topic. |
| This worksheet may be used to record journal entries, and post the amounts to ledger accounts. The last row in the worksheet may then |
| be used to prepare financial statements. Open Template 19 before entering data in this template and the financial statements in |
| Template 19 will update as you enter data here. To customize the worksheet, start by replacing the xx's in the Beginning Balance row with the |
| values from your ending balance sheet for the prior time period. Then record each transaction in chronological order. You may replace the |
| transactions' numbers shown on the left side with actual dates. Insert rows before the ending balance row, if you have more transactions |
| than the number shown in the current worksheet. Change the titles of the ledger accounts as needed, and add additional columns |
| if you have more ledger accounts than the number currently shown. The beginning balance is added to all transactions posted to |
| a specific ledger account to get the ending balance in that ledger account's column. Be sure to copy the formula from the last row to any |
| new columns that you add. To make a column wider, so your numbers fit, move your cursor to the top of the column, just above |
| Row 1, to highlight the column and double click on the vertical line that separates the column from the next column. |
| If you have trouble with that, click on Format in the menu and then on autofit column width. |
| Ledger Account |
| | | | Assets | | | | | + | Expenses | | | | | + Div. = | | | Liabilities | | | Stockholder's |
| | | | | | | | | | | | | | | | | | | | | + | Equity | | + Rev. |
| | | | Cash | Prepaid Insurance | Accounts Receivable | Inventory | Plant & Equipment | | Cost of Goods Sold | Labor | Interest | Insurance | Depreciation | | Dividends | | Accounts Payable | Wages Payable | Mortgage Payable | | Common Stock | Retained Earnings | | | Revenue |
| Beginning Balance | | | $325,000 | xx | xx | xx | xx | | $10,000 | xx | xx | xx | xx | | xx | = | xx | xx | xx | | xx | xx | | | xx |
| | | 1 |
| | N | 2 |
| | O | 3 |
| | I | 4 |
| | T | 5 |
| | C | 6 |
| | A | 7 |
| | S | 8 |
| | N | 9 |
| | A | 10 |
| | R | 11 |
| | T | 12 |
| | | 13 |
| | | 14 |
| | | 15 |
| | | 16 |
| | | 17 |
| | | 18 |
| | | 19 |
| | | 20 |
| Ending Balance | | | $325,000 | $0 | $0 | $0 | $0 | | $10,000 | $0 | $0 | $0 | $0 | | $0 | | $0 | $0 | $0 | | $0 | $0 | | | $0 |
excel_123
Template18.xls
