Reconcile the Bank Account In this exercise, you will reconcile the TD Operating account for the months of January 2026 through July 2026. Melanie has given you the bank statements. Looking at them, you notice that Melanie has a $5/month bank charge that starts at the end of January.

Beginning with January 2026, get the TD statements from your Chapter 06 folder and prepare to reconcile the TD Operating account for each month individually, up to July 2026.

Enter the $5 bank charge in the service charge or interest area, dated the end of each month, before you start reconciling. Remember to do this for each month you are reconciling.

Complete the seven reconciliations. Keep in mind that even though a cheque has been written on one date, it isnt necessarily cashed in the same month.

Run the Bank Account History report for the month of July 2026; to do this, you must go to the Bank Register and click Export to Excel (the only option with the Export button found in the upper-left corner of the account register). Before exporting, make sure your Date column is showing 31/07/2026 at the top and not 01/01/2026. If it's showing January, click to re-sort the date column so transactions are shown in order from newest to oldest. Save the exported file as the proper file type in your Chapter 06 folder as: CH06 July Bank Recon

Run a Transaction List by Date report for all dates, grouping by transaction type; export to Excel, saving in your Chapter 06 folder as: CH06 Transactions to Date July