Accounting Question

Learning Goal: I’m working on a accounting project and need support to help me learn.

The Thomas Family has been growing various varieties of heirloom tomatoes in its green houses near Fargo North Dakota. During the summer months, the family sells their tomatoes at farmers markets around the area under the name of Thomas’ Tomatoes. Thomas has 24 full-time employees and hires 150 to 200 seasonal workers for the harvest.

For the past few summers, you have sold tomatoes at farmers’ markets within a 20-mile radius of the Thomas family farm. When you graduated, you were hired as the full-time accountant/office manager. Until now, Thomas’ Tomatoes, or TT for short, kept most of its accounting records in a big file box. Tom Thomas Jr., the owner, would like a more organized approach to the farm’s accounting records. He has asked you to establish a proper set of books. You decide to start by establishing appropriate journals and ledgers for these transactions.

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
Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.