USE EXCEL

General Journal Particulars Fol. Credit ($) Date 05 Sep Debit ($) 8230 Office furniture 2019 CASH RECEIPTS JOURNAL Date Particulars Cash at Folio Ref Sundries GST Discount Expense AR Cash Disc. GST A/R Control Collected Exp. Control Sales Amount Account Collected Bank May2 Cash Sales POS 8000 800 8800 CASH PAYMENTS JOURNAL Cash at Date Particulars Folio Rel Discount Income AP Cash Sundries GST Disc Inc A/P Control GST Paid Control PurchasAmount Account Paid Rank June 18 wages 041 2000 200 2200 Cooper commenced business as a retailer of electrical goods on 1 October 2020. The following are his transactions for the first month's operations. 1 Oct 16 17 24 26 Coopercommenced business with the following assets and liabilities: stock, $3,000; cash at bank, $100,000; premises, $50,000; mortgage loan on premises, $40,000; loan from CT Bank, $20,000. Cash sales, $2,420 inc GST (POS). Cash purchases from Elsa Supplier $4,070 inc GST (cheque 001). Paid wages, $800 (EFT). Receivable, Jack paid his account of $600, deducting discount of $33 (inc GST) for prompt payment (receipt 401). Paid payable, Power Electrical Supplier $3,900. Discount received was $110 inc GST (cheque 002) Received commission from Up Electrics , $220 inc GST (EFT). Cash refund, $1,210 inc GST paid to Ben for goods previously sold for cash (cheque 004). 29 30 You are required to: USE EXCEL Record the above transactions into the following journals: (a) (b) (c) General Journal (GJ) Cash Receipts Journal (CR) Cash Payments Journal (CPJ)