Post the journal entries to the ledger. The ledger is already set up for you with balance forward amounts from the previous year.
Journal:
10 fx A B C D E F G H I J K L M N 0 P Q 80 2015 balance forwarded 28,957.00 81 82 83 84 85 86 87 201 Bank Loan 88 Date Particulars P.R. Debit Credit Balance 89 2015 balance forwarded 20,000.00 90 91 92 93 94 95 96 211 A/P - Rona Lumber 97 Date Particulars P.R. Debit Credit Balance 98 2015 99 100 101 102 103 104 105 250 HST Payable 106 Date Particulars P.R. Debit Credit Balance 107 2015 108100% Y $ % .0 .00 123- Default (Ca... 10 Y BISA 10 - fx A B C D E F G H J K L M N 0 P Q R 138 139 140 141 401 Revenue 142 Date Particulars P.R. Debit Credit Balance 143 2015 144 145 146 147 148 149 150 505 Automobile Expense 151 Date Particulars P.R. Debit Credit Balance 152 2015 153 154 155 156 157 510 Bank Charges Expense 158 Date Particulars P.R. Debit Credit Balance 159 2015 160 161 162 163 164 165 166 515 Rent Expense100% $ % .0 .00 123 - Arial 10 B A fx A B C D E F G H K L M N O P 6 General Journal Page: 14 Of course you can work on Date Particulars P.R. Debit Credit the two sheets side by side 2015 in one window. Use the Oct 1 Rent Expense 900.00 help menu and search 11 12 HST Recoverable 117.00 'view two worksheets' 13 Bank 1,017.00 14 Cheque 352 to Thornbury Investments 15 16 3 Supplies 235.00 HST Recoverable 30.55 A/P Rona Lumber 265.55 19 Purchase of supplies on account 20 5 A/R - W. Mckinley 3,955.00 HST Payable 455.00 23 Revenue 3,500.00 Sale on account 25 5 A/R - L. Ingram 2,599.00 HST Payable 299.00 28 Revenue 2,300.00 29 Sale on account 30 11 A/R - Reid Co 904.00 32 HST Payable 104.00 23 Revenue 800.00 Sale on account + Journal * Ledger100% $ % .0 .00 123- Default (Ca... 10 BISA 10 fx P Q R A B C D E F G H K L M N 0 Note that in the real A. Anderson, Fishing Guide world each account 2 General Ledger would be on a separate page. We have condensed the 101 Bank Account ledger for teaching Date Particulars P.R. Debit Credit Balance purposes only. 2015 balance forwarded 2,000.00 The account 8 Oct 9 number may appear n either the top 10 right or the top left 11 of a ledger account 12 13 14 15 16 17 Remember to 18 use a 'formula' 19 to calculate the 20 running 21 balance. 22 23 Go to Excel's 24 111 A/R - L. Ingram help menu and 25 Date Particulars P.R. Debit Credit Balance search : 26 2015 'calculate a 27 running 28File Edit View Insert Format Data Tools Help Last edit was 3 minutes ago 100% - $ % .0 .00 123- Arial 10 Y BIS A G4 fx A B C D E F G H J K L M N O P Q R 86 Bank 65.54 87 Paid telephone bill - cheque #358 88 7,843.33 7,843.33 89 90 General Journal Page: 16 91 92 Date 93 2007 Particulars P.R. Debit Credit 94 Oct 25 Bank 400.00 95 A/R.- K. Peters 400.00 96 Received payment on accounts 97 98 26 A/R - W. Mckinley 452.00 99 HST Payable 52.00 100 Revenue 400.00 101 Sale on account 102 103 26 A. Anderson, Drawings 450.00 104 Bank 450.00 105 Cheque 359 to owner for personal use. 106 107 30 Wages Expense 670.00 108 Bank 570.00 109 Cheque #360 paid for wages 110 1.872.00 1,872.00 111 112 113 11410 fx K L M N 0 P Q R A B C D E F G H 20 running 21 balance. 22 23 Go to Excel's 24 111 A/R - L. Ingram help menu and 25 Date Particulars P.R. Debit Credit Balance search : 26 2015 'calculate a 27 running 28 balance' 29 30 31 32 33 113 A/R - W. Mckinley 34 Date Particulars P.R. Debit Credit Balance 35 2015 36 37 38 39 40 41 42 115 A/R - K. Peters 43 Date Particulars P.R. Debit Credit Balance 44 2015 45 46 47 48A B C D E F G H K L M N O P Q R 168 2015 169 170 171 172 173 174 175 520 Telephone Expense 176 Date Particulars P.R. Debit Credit Balance 177 2015 178 179 180 181 182 183 184 525 Wages Expense 185 Date Particulars P.R. Debit Credit Balance 186 2015 187 188 189 190 191 192 193 194 195 196U3A6 Assignment 1. Post the following journal entries to the ledger. The ledger is set up for you. Click on the tab at the bottom to go to the ledger sheet. 2. Do an equality check to ensure that the total debits of the ledger equals the total credits.100% $ % .0 .00 123- Arial Y 10 fx A B C D E F G H 1 J K L M N O P Q R 6 Purchase supplies - cheque # 355 57 18 Bank 3,955.00 A/R - W. Mckinley 3,955.00 Received full payment of account 18 Automobile expense 118.00 HST Recoverable 15.34 Bank 133.34 Auto repairs cheque #356 19 Bank charges 250.00 Bank 250.00 Bank interest 19 Wages Expense 575.00 Bank 575.00 Paid wages on cheque #357 19 A/R - K. Peters 678.00 HST Payable 78.00 Revenue 600.00 Sale on account 19 Bank Loan 2,000.00 Bank 2,000.00 Made payment on bank loan 33 24 Telephone Expense 58.00 + Journal Ledger *G4 fx A B C D E F G H J K L M N O P Q 26 5 A/R - L. Ingram 2,599.00 27 HST Payable 299.00 28 Revenue 2,300.0 29 Sale on account 30 31 11 A/R - Reid Co. 904.00 32 HST Payable 104.00 33 Revenue 800.00 34 Sale on account 35 36 15 A. Anderson, Drawings 500.00 37 Bank 500.00 38 Cheque 353 to owner for personal use. 39 40 17 A/P Rona Lumber 265.55 41 Bank 265.55 42 Payment on account - cheque # 354 43 Equity Check: 44 Add all the figures in 45 the column above on 46 9,506.10 9,506.10 each journal page. 47 These are cross or 48 pencil footings - just 49 General Journal Page: 15 a check to ensure 50 that debits equal 51 Date credits. Particulars P.R. Debit Credit 52 2007 53 Oct 18 Supplies 165.00 54 HST Recoverable 21.45 Journal Ledger *L10 fx A B C D E F G H J K L M N 0 P Q 50 51 117 A/R - Reid Co. 52 Date Particulars P.R. Debit Credit Balance 53 2015 54 55 56 57 58 59 60 120 Supplies 61 Date Particulars P.R. Debit Credit Balance 62 2015 balance forwarded 1,450.00 63 64 65 66 67 68 69 125 Equipment 70 Date Particulars P.R. Debit Credit Balance 71 2015 balance forwarded 14,732.00 72 73 74 75 76 77 78 130 Automobile100% Y S % .0 .00 123- Default (Ca... . 10 . BISAOB L10 fx A B C D E F G H I 108 J K L M N 0 P Q 109 110 111 112 113 114 251 HST Recoverable 115 Date Particulars P.R. Debit 116 Credit 2015 Balance 117 118 119 120 121 122 123 301 A. Anderson, Capital 124 Date Particulars P.R. 125 Debit 2015 Credit Balance balance forwarded 126 27,139.00 127 128 129 130 131 132 302 A. Anderson, Drawings 133 Date Particulars P.R. Debit 134 2015 Credit Balance 135