Appendix: Completing an end$-$of$-$period spreadsheet

List $($a$)$ through $($j$)$ in the order they would be performed in preparing and completing an end$-$of$-$period spreadsheet.

a$.$Add the Debit and Credit columns of the Unadjusted Trial Balance columns of the spreadsheet to verify that the totals are equal.

$1245689$

b$.$Add the Debit and Credit columns of the Balance Sheet and Income Statement columns of the spreadsheet to verify that the totals are equal.

$23467810$

c$.$Add or deduct adjusting entry data to trial balance amounts, and extend amounts to the Adjusted Trial Balance columns.

$1235789$

d$.$Add the Debit and Credit columns of the Adjustments columns of the spreadsheet to verify that the totals are equal.

$24678910$

e$.$Add the Debit and Credit columns of the Balance Sheet and Income Statement columns of the spreadsheet to determine the amount of net income or net loss for the period.

$1234568$

f$.$Add the Debit and Credit columns of the Adjusted Trial Balance columns of the spreadsheet to verify that the totals are equal.

$12368910$

g$.$Enter the adjusting entries into the spreadsheet, based on the adjustment data.

$13578910$

h$.$Enter the amount of net income or net loss for the period in the proper Income Statement column and Balance Sheet column.

$1234569$

i$.$Enter the unadjusted account balances from the general ledger into the Unadjusted Trial Balance columns of the spreadsheet.

$13578910$

j$.$Extend the adjusted trial balance amounts to the Income Statement columns and the Balance Sheet columns.

$12357910$