1. Math
  2. Mathematics
  3. using the excel file you have already been working on...

Question: using the excel file you have already been working on...

Question details

Using the excel file you have already been working on, enter the transactions into the General Journal and then update the Ledger accounts as required. Please use a spreadsheet or do it on a paper 

Transactions

January 2         Sold 100 Lunch in a Box meals on credit to School Snackers for $990 (including GST).

January 3         Made a cash sale of $650 (net of GST) to Philip Heathers when they bought 10 Cake it Away desert kits.

                        Received a cheque from Delicious Deserts as full payment of their account.

January 5         Purchased 50 Cake it Away desert kits from Flavour and Thensome. Each kit costs $30 and there is a delivery charge of $100. All amounts are net of GST.

January 7         Sold 20 Gourmet Dinner Just Heat It meals to Help Those in Need for $25 each plus a delivery fee of $50. The total GST charged was $55

January 9         Issued Cheque number 1034 to Prepared for Good. The cheque amount was $2024 and a discount of $176 (including GST of $16) was received for early payment.

January 11       Purchased 200 Ultimate BBQ Flavours packs on credit from Ingredients Plus. Each pack costs $50 and there is a delivery charge of $0.50 per pack. All amounts are net of GST.

January 13       Sold 25 Cake it Away desert kits on credit to Delicious Deserts for $66 each (including GST).

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution