SOLVED : articlewritingcafe.net – the journals and general ledger and subsidiary ledger accounts /2022
SOLVED : articlewritingcafe.net –
Presented below are a set of vendor invoices and a few partially completed journals and ledgers.
Your job is to record these transactions and update the appropriate ledgers. Be sure to leave a proper audit trail
. Use Excel to complete this problem. Be sure to use cell links/references and formulas in Excel so that your worksheet(s) can be used in future months. Include account balances for the end of the month. Submit your Excel workbook here by the due date. Include your name and REDID as the heading for the worksheet(s) of your Excel workbook.
Here is the list of vendor invoices for the month of May.
Vendor Invoices
Date
Supplier Invoice
Supplier Name
Supplier Address
Amount
6-May TT45 Bud’s Soil Prep PO Box 34 $192.45
10-May 14568 Osto Farmers Supply 45 Main $527.42
13-May 893 Whalleys Fertilizer Route 34 $1,980.00
13-May 14699 Osto Farmers Supply 45 Main $1,274.20
20-May 10102 IFM Wholesale 587 Longview $2,110.00
24-May 10145 IFM Wholesale 587 Longview $673.99
The following are the journals and general ledger and subsidiary ledger accounts required to complete this activity.
Purchases Journal
Date
Supplier
Supplier Invoice
Account Number
Post Ref
Amount
General Ledger
Accounts Payable: Account Number 300
Date
Description
Post Ref
Debit
Credit
Balance
1-May
Balance Forward
$18,755.53
Purchases: Account Number 605
Date
Description
Post Ref
Debit
Credit
Balance
1-May
Balance Forward
$54,688.49
Vendor Subsidiary Ledgers (Subledgers)
Account No: 23
Bud’s Soil Prep
PO Box 34
Terms: 2/10, Net 30
Date
Description
Debit
Credit
Balance
1-May
Balance Forward
1100.05
Account No: 24
Osto Farmers Supply
45 Main
Terms: 2/10, Net 30
Date
Description
Debit
Credit
Balance
1-May
Balance Forward
0
Account No: 36
Whalers Fertilizer
Route 34
Terms: 2/10, Net 30
Date
Description
Debit
Credit
Balance
1-May
Balance Forward
0
Account No: 38
IFM Wholesale
587 Longview
Terms: 2/10, Net 30
Date
Description
Debit
Credit
Balance
1-May
Balance Forward
0