Excel: A Question of Balance Page 1 2 3 4 5 6 7 8 9 10 11 12

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!