ACC-315 Accounting Information Systems

profileRose26
ACC315ProjectTwoPoseysPetEmporiumAccountsPayableLedgersandJournals2.xlsx

Sheet1

Account: Accounts Payable No. 200
Balance
Date Invoice Debit Credit Debit Credit
8/1/22 Beginning Balance 2,075.55
8/3/22 4325 350.44 2,425.99
8/4/22 4322 200.00 2,225.99
8/8/22 4320 1,132.22 1,093.77
8/9/22 4326 380.99 1,474.76
8/12/22 4324 200.00 1,274.76
8/12/22 4327 435.76 1,710.52
8/15/22 4328 400.00 2,110.52
8/17/22 4318 300.12 1,810.40
8/17/22 4329 1,844.28 3,654.68
8/18/22 4330 280.09 3,934.77
8/19/22 4331 87.92 4,022.69
8/22/22 4325 350.44 3,672.25
8/23/22 4333 150.00 3,822.25
8/24/22 4332 250.00 4,072.25
8/24/22 4334 109.52 4,181.77
8/26/22 4316 200.00 3,981.77
8/29/22 4335 2,000.00 5,981.77
8/30/22 4336 350.41 6,332.18
8/30/22 4328 4,000.00 2,332.18
8/31/22 Ending Balance 6,382.78 6,639.41 2,332.18
Accounts Payable Subsidiary Ledger
Vendor A
Balance
Date Invoice Debit Credit Debit Credit
8/1/22 Beginning Balance 1,532.22
8/4/22 4322 200.00 1,332.22
8/8/22 4320 1,132.22 200.00
8/18/22 4330 280.09 480.09
8/24/22 4332 250.00 730.09
8/26/22 4316 200.00 530.09
8/31/22 Ending Balance 1,532.22 530.09 530.09
Vendor B
Balance
Date Invoice Debit Credit Debit Credit
8/1/22 Beginning Balance 200.00
8/3/22 4325 350.44 550.44
8/12/22 4324 200.00 350.44
8/17/22 4329 1,804.28 2,154.72
8/22/22 4325 350.44 1,804.28
8/30/22 4336 350.41 2,154.69
8/31/22 Ending Balance 550.44 2,505.13 2,154.69
Vendor C
Balance
Date Invoice Debit Credit Debit Credit
8/1/22 Beginning Balance 43.21
8/4/22 4319 43.21 - 0
8/12/22 4327 435.76 435.76
8/19/22 4331 87.92 523.68
8/24/22 4334 109.52 633.20
8/31/22 Ending Balance 43.21 633.20 633.20
Vendor D
Balance
Date Invoice Debit Credit Debit Credit
8/1/22 Beginning Balance 300.12
8/9/22 4326 380.99 681.11
8/15/22 4328 4,000.00 4,681.11
8/17/22 4318 300.12 4,380.99
8/23/22 4333 150.00 4,530.99
8/29/22 4335 2,000.00 6,530.99
8/30/22 4328 4,000.00 2,530.99
8/31/22 Ending Balance 4,300.12 6,530.99 2,530.99