Starting
with Cell A3: 100,
Description: Office Supplies
Check: $78.50
In Cell A4: 101
Description: The Phone Store
Check:
$180.98
In Cell A5: 102
Description: The
Electric Co
Check: $160.00
You can use today's date in the sample check book.
Working With A Ledger
3. Enter some sample data
Select Cell F2 and
type 500 for the Opening Balance. Since we formatted the column for currency, Excel will add
the dollar sign and decimals.
Now, pretend we bought some office supplies, a phone, and paid the
electric
company a deposit to start our service. We are officially open for
business!