create a bank reconciliation with the bank and book sides

Bank Statement Trans Amt Date Trans Description 1/1/21 Beginning Balance 1/5/21 Check 1/9/21 Check 1/12/21 Check 1/14/21 |Check 1/18/21 Transfer: Payroll Account Credit 1/25/21 Check 1/28/21 Transfer: Savings Account Credit 1/31/21 Monthly Service Fee 2/5/21 Transfer: SunTrust Bank 2/8/21 Check 2/9/21 Check 2/9/21 Check 2/11/21 Check 2/12/21 Check 2/20/21 EFT: Vendor Payment: Goodyear Regional Sales 2/21/21 Check 2/26/21 EFT: Customer Payment: Discount Tires-Log Cabin 2/27/21 Transfer: Payroll Account Credit 2/27/21 Check 2/28/21 Monthly Service Fee 3/2/21 EFT: Customer Payment: Huck & Shuck 3/3/21 Cash Deposit 3/6/21 Check 3/7/21 Check 3/8/21 Check 3/9/21 Check 3/9/21 Check 3/10/21 Check 3/10/21 Cash Deposit 3/11/21 Check 3/11/21 Check 3/15/21 Cash Deposit 3/15/21 Check 3/22/21 Transfer. Payroll Account Credit 3/22/21 Check 3/25/21 Check 3/29/21 Check 3/30/21 Check 3/31/21 Check 3/31/21 Monthly Service Fee -12,600.00 -9,120.00 - 1.000.00 -595.00 -10.00 -340.00 -12,500.00 -75.00 -104,241.14 -1,080.00 -340.00 -2.900.00 -492.00 -1,785.00 -20,000.00 -5,900.00 23,600.00 4.020.00 -2,500.00 -95.00 2.360.00 56.250.00 -1.901.00 - 125.00 -360.00 - 16,800.00 -340.00 -11,500.00 23,054.00 -1,498.00 -340.00 50,540.00 4,500.00 -4.020.00 -800.00 -1,300.00 -900.00 -30,000.00 -634.00 - 130.00 Balance 560,000.00 547,400.00 538,280.00 537.280.00 536,685.00 536,675.00 536.335.00 523,835.00 523.760.00 419,518.86 418,438.86 418.098.86 415,198.86 414,706.86 412.921.86 392,921.86 387,021.86 410,621.86 406,601.86 404,101.86 404,006.86 406.366.86 462,616.86 460.715.86 460,590.86 460,230.86 443,430.86 443,090.86 431,590.86 454,644.86 453, 146.86 452,806.86 503,346.86 498,846.86 494,826.86 494,026.86 492.726.86 491,826.86 461,826.86 461,192.86 461,062.86 Ending Balance 461,062.86 dger TYPE DATE DOCUMENT NUMBER NAME DEBIT CREDIT BALANCE king $560,000.00 006 Warehouse Supply Company 006-Travelers Insurance Company 006-Macon Utilities 006-Lynch Property Management Company 006-Austin & Morris, P.C. 006-Hertz Equipment Rental 006-Man Power Labor Source Agency $104,241.14 Journal 1/1/20211 Check 1/1/2021 2 Check 172/2021 1 Check 1/2/2021 4 Check 1/2/2021 3 Bill Payment 1/3/2021 5 Check 1/4/20216 Transfer 1/16/2021 1 Transfer 1/26/2021 2 Bill Payment 1/29/2021 7 Journal 2/1/20218 Check 2/2/20218 Check 2/3/20219 Check 2/5/2021 10 Bill Payment 2/7/2021 11 Bill Payment 2/16/2021 12 Bill Payment 2/25/2021 13 Journal 2/26/2021 11 Check 2/27/2021 15 Check 2/28/2021 14 Check 3/1/2021 16 Journal 3/1/2021 22 Bil Payment 3/2/2021 17 Check 3/3/2021 18 Check 3/4/2021 19 Bill Payment 3/6/2021 20 Deposit 3/7/2021 1 Journal 3/9/2021 23 Bill Payment 3/9/2021 21 Full Paumont 0212 FROM Jan 2021 006-Lynch Property Management Company 006-High Profile Marketing 006-Hertz Equipment Rental 006-Macon Utilities 006-Bridgestone Manufacturing Corporation 006-Goodyear Regional Sales $0.00 $560,000.00 $9,120.00 $550,880.00 $12.600.00 $538,280.00 $1,000.00 $537,280.00 $595.00 $536,685.00 52,500.00 $534,185.00 $340.00 $533,845.00 $10.00 $533,835.00 $ 12,500.00 $521.335.00 $1,080.00 $520,255.00 $624,496.14 $1.785.00 $622,711.14 $2,900.00 $619,811.14 $340.00 $619,471.14 $492.00 $618,979.14 $5,900.00 $613,079.14 $11,500.00 $601,579.14 $4,020.00 $597,559.14 $360.00 $597,199.14 $1,901,00 5595,298.14 $125.00 $595.173.14 3651,693.14 $16.800.00 $634.893.14 $340.00 $634,553.14 $4,500.00 $630,053.14 $1,498,00 5628,555.14 $651.609.14 $702,149.14 $1,300.00 5700,849-14 33.000,00 1697 8.49.14 006-Manpower Labor Source Agency 006-Suntrust Bank 006-Perfect Payroll 556,520.00 006-Bridgestone Manufacturing Corporation 006 Hertz Equipment Rental 006 WMAC Radio Broadcasting 006 Macon Utilities $23,054.00 $50,540.00 006-FedEX 06. Austin & Lactis LC TO Mar 2021 Customize DATE DOCUMENT NUMBER NAME DEBIT CREDIT BALANCE Bill Payment 1/292041 Ob ManPower Labor Source Agency $700.00 5520,255.00 Journal 2/1/2021 8 $104.241.14 5624,496.14 Check 2/2/2021 8 006-Lynch Property Management Company $1,785.00 $622,711.14 Check 2/3/2021 9 006-High Profile Marketing $2,900.00 $619,811.14 Check 2/5/2021 10 006-Hertz Equipment Rental $340.00 $619,471.14 Bill Payment 2/7/2021 11 006 Macon Utilities $492.00 $618,979,14 Bill Payment 2/16/2021 12 006 Bridgestone Manufacturing Corporation $5.900.00 $613,079.14 Bill Payment 2/25/2021 13 006 Goodyear Regional Sales $11,500.00 5601,579.14 Journal 2/26/2021 11 $4,020.00 5597,559.14 Check 2/27/2021 15 006-Man Power Labor Source Agency $360.00 5597,199.14 Check 2/28/2021 14 006-Suntrust Bank $1.901.00 $595,298.14 Check 3/1/2021 16 006.Perfect Payroll $125.00 $595,173.14 Journal 3/1/2021 22 $56,520.00 $651,693.14 Bill Payment 3/2/2021 17 006 Bridgestone Manufacturing Corporation $16,800.00 5634.893.14 Check 3/3/2021 18 006-Hert: Equipment Rental $340.00 $634,553.14 Check 3/4/202119 006-WMAC Radio Broadcasting $4,500.00 $630,053.14 Bill Payment 3/6/2021 20 006-Macon Ubilities $1,498.00 5628,555.14 Deposit 3/7/2021 1 $23,054 00 $651.609.14 Journal 3/9/2021 23 $50,540.00 $702.149.16 Bill Payment 3/9/2021 21 006-FedEx 51,300.00 $700,849.14 Bill Payment 3/10/2021 22 006- Austin & Morris, RC $3,000.00 1697,849.14 Check 3/14/2021 23 006-Discount Tires. Log Cabin $800.00 5697,049.16 Check 3/15/2021 24 006-IRS $1.920.00 $695.129.14 Check 3/15/2021 25 006 Georgia Department of Revenue $900.00 5694 229.14 Journal 3/12/2021 25 $49,480.00 $743,709.14 Bill Payment 3/20/2021 26 006 Goodyear Regional Sales $30,000.00 $213.709.14 Bill Payment 3/25/2021 27 006 Staples 163400 1713,075.14 Journal 3/25/2021 29 14,020,00 5709.055.14 Bill Payment 3/26/2021 28 006 Yokohama Limited Sales $18,600.00 $690.455.14 Check 3/30/2021 29 006 Suntrust Bank 51.901.00 5688.554.14 necking 5843,835.14 5155,281.00 5688,554.14 FROM Jan 2021 TO Mar 2021 stomize