excel question

Record the following transactions in the appropriate journals. Remember: Bright Spot CREDIT SALE TERMS are 2/10,n/30. DAILY TRANSACTIONS IN DATE ORDER Aug. 6 Rec'd cheque from customer P Hogan. Invoice issued on July 29 for $2,500 Aug. 7 Paid Sales Salaries $1,800 and Office Salaries $700 with Cha#457 Aug. 8 Proprietor withdrew $600 cash for personal use. Cha#458 Paid supplier Lights Galore (terms 2/12, n30) with Cha#459. July 28 invoice, $8,000 Aug. 9 Rec'd supplier invoice from Phullops Lamps for $4,500 (terms 2/1, n30) Sales for the day were: Cash Sales $3,200 B Yang $4,000 Paid supplier. Lamphouse (terms 2/10,n30) with Chq#460. July 30 invoice, $8,150 Rec'd cheque from customer PTsu. Invoice issued on July 31 for $220 Aug. 11 Sales for the day were: Cash Sales $5,500 W Harrigan $3,200 incl. $35 delivery charge Light Fantasy $5,000 Rec'd customer payments for Inv's dated Aug 1 Light Fantasy $3,500 P Hogan $650 Aug. 12 Rec'd and paid Electricity Account $525 with Cha#461 Aug. 13 Issued Chq#462 paying Easy Print (terms n30) for July printing account $650 Rec'd customer payments for Inv's. dated Aug 4 & 5 respectively; J Roberts $700 N Smith $4,500 CASH RECEIPTS JOURNAL DEBITS Date Account Bank Disc. Allow 5-Aug Progress totals 7118.90 16.10 CREDITS Sales A/Rec's 5980 1155 13-Aug Progress totals 27647.50 257.50 14680 13225 CASH PAYMENTS JOURNAL DEBITS Cheque # Other Acc's A/Payable 200 13000 Date Account 5-Aug Progress totals CREDITS Bank Disc. Rec'd 12940 260 13-Aug Progress totals 3825 29800 33042 583 PURCHASE JOURNAL Inv Date Account name Terms Purchases 5-Aug Progress totals 9250 A/Payable 9250 13-Aug Progress totals 13750 13750 SALES JOURNAL Inv Date Account name Sales Deliv. Exp A/Receivable 5-Aug Progress totals 12275 75 12350 13-Aug Progress totals 24440 110 24550