Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE COMPLETE ASAP. Prepare the creditors ledger to record the transactions contained in the information for November and December. GENERAL INFORMATION: 1. 2. 3. 4.

PLEASE COMPLETE ASAP.

Prepare the creditors ledger to record the transactions contained in the information for November and December.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

GENERAL INFORMATION: 1. 2. 3. 4. 5. MARVEL MAKERS buys and sells sanitizer. It began trading operations on 1 January 2015 and its financial year end is 31 December. All amounts are paid by EFT, unless otherwise stated. All EFT transactions appear in the entity's bank account on the day following the date of the transaction. The entity uses the perpetual inventory system and maintains a gross profit percentage of 25% (on selling price). During a period in November each year, the entity has an annual sale during which sanitizer is sold at a discount of 20% on normal selling price. The discount is only applied to cash sales concluded during the specified sale period. Assume that all items purchased or sold are received or dispatched correctly unless otherwise told. Cash received is deposited into the entity's bank account as indicated in the transactions provided. The entity is registered for VAT on the invoice basis. All transactions include VAT at the rate of 15% (where applicable) unless otherwise stated. The VAT periods of the entity are as follows: January - February, March - April, May - June, July - August, September, - October, November - December. Accept that all suppliers are also registered for VAT. The entity uses a VAT-input, VAT-output and VAT control account. 6. 7. 8. NB: There is NO settlement discount MARVEL MAKERS Trial balance at 1 November 2018 (for the 10 months ended 31 October 2018) Debit Credit Capital 1 357 758,00 Drawings 39 360,00 Land 200 000,00 Buildings at Cost 1 000 000,00 Buildings - Accumulated depreciation 60 000,00 Office equipment at cost 76 994,00 Office equipment - Accumulated depreciation 27 624,00 Vehicle at cost 550 200,00 Vehicle - Accumulated depreciation 173 400,00 8% Long-term loan from DC Bank 160 000,00 Inventories on hand 154 754,00 Trade debtors control (total) 32 672,00 C Boseman 4 472,00 R Downey 6 000,00 C Evans 4 000,00 C Johansson 11 400,00 C Hemsworth 4 800,00 M Raffalo 2 000,00 Allowance for expected credit losses 4 392,00 Bank (favourable) 70 554,00 Cash float 240,00 Petty cash 1 600,00 Trade creditors control 19 636,00 B Affleck 9 120,00 R Reynolds 3 520,00 T Hardy 6 312,00 I Elba 264,00 C Bale 420,00 H Cavill J Brolin VAT-Control 4 222,00 Sales 1 730 766,00 Cost of sales 1 012 812,00 Rental income 50 000,00 Interest income 15 260,00 13 Nov A petty cash voucher was approved by the accountant for the purchase of pens to be used by the general ledger clerk, R180.00 14 Nov The owner decided that the cash float in the till should be increased by R420.00. The accountant withdrew the cash from the entity's bank account on the owner's instruction. 14 Nov An EFT was received from C Boseman for R4 472.00. 14 Nov Credit invoice no. 123 was received from R Reynolds for sanitizer purchased on credit, R13 110.00. The sanitizer were delivered by H Cavill (see 20 Nov). 3 14 Nov Cash register till slips (1/11/2018 - 14/11/2018) for normal cash sales R42 030.00. Deposited on 15 Nov 2018. 15 Nov The telephone account of R4 514.00 was paid. 16 Nov A credit note for R456.00 was received from J Brolin for a rebate claimed on sanitizer that had been spilt out of its packaging on delivery. 17 Nov A petty cash voucher was made out for R400,00 cash taken by the owner's wife. 19 Nov Cash register till slips (15/11/2018 - 19/11/2018) issued for annual cash sale proceeds in respect of sanitizer, R57 796.00. Deposited on 20 Nov 2018. 20 Nov An invoice was received from H Cavill for delivery costs in respect of credit invoice no. 231 (see 14 Nov). The accountant issued an EFT for R1 300.00 to H Cavill. 21 Nov An EFT for R54 000.00 was received from the owner Stan Lee, in respect of an increase to his capital contribution. A receipt was issued to him for this amount. 23 Nov A cash invoice for R1 074.00 was handed to the cashier by the owner for repairs to the delivery vehicle, which the owner paid using his personal credit card. The accountant issued an EFT to the owner to reimburse him for this amount. 25 Nov The accountant discovered that the previous bookkeeper incorrectly posted sanitizer that were purchased as merchandise for R3 450.00 (VAT included), to the delivery costs on sales account on 31 October 2018. The owner has requested that this error be corrected. VAT was treated correctly for this transaction 25 Nov The owner requested the accountant to pay the VAT owing for the September October 2018 VAT period by EFT to the South African Revenue Services. 25 Nov Received an EFT from R Downey in settlement of his account. 28 Nov Basic salaries to the amount of R37 200.00 were paid to employees in cash. The money was withdrawn by the owner from the entity's bank account. 29 Nov A monthly statement was received from B Affleck. This was for purchases during November 2018 per invoice no. 11 for sanitizer of R37 894.00. These items were delivered by H Cavill. 29 Nov A credit invoice (AB21) was received from H Cavill for delivery costs amounting to R3 410.46 (see previous transaction). 30 Nov Cash register till slips (20/11/2018 - 30/11/2018) to be accounted for: R41 596.02. Deposited on 1 Dec 2018. 30 Nov An EFT issued to B Affleck for settlement of their account as on this date. 30 Nov Received an EFT from C Johansson in full settlement of her account. 30 Nov Cash of R774.00 was withdrawn by the accountant from the entity's bank account to re-instate the petty cash balance on hand to R1 600.00. DECEMBER 2018 3 Dec Credit sales invoice issued to C Johansson for purchases of sanitizer for R16 600.00. C Johansson transported the sanitizer herself. 6 Dec Invoice 975 was received from 1 Elba for sanitizer purchased on credit for R9 250.00 7 Dec Petty cash voucher issued for R166.00 in respect of delivery costs on certain cash sales. 8 Dec Petty cash voucher issued for purchase of stationery of R120.00. 9 Dec A credit note was received from C Bale amounting to R164.00 due to sanitizer that was over-charged on their invoice. 11 Dec Received invoice no. 72F9 from T Hardy for credit purchases of sanitizer for R13 550.00 12 Dec Invoice AB35 was received from H Cavill for delivery costs of 10% (including VAT) on sanitizer purchased from T Hardy (see previous transaction). 13 Dec A petty cash voucher issued for repairs to an office chair for R194.00. 15 Dec An EFT was issued for R3 732.00 to pay the telephone account 15 Dec Cash register till rolls (1/12/2018 - 15/12/2018) for cash sales R41 186.00. Deposited 17 Dec 2018 15 Dec EFTs issued to: R Reynolds R10 400.00; T Hardy R18 000.00; J Brolin R12 000.00; and | Elba R8 000.00 None of these payments were in settlement of the suppliers accounts. 17 Dec Petty cash vouchers for wages for R536.00. 17 Dec A credit sales invoice was issued to C Boseman for sales of R4 912.00 in respect of sanitizer. 20 Dec Invoice no. 72 received from B Affleck for purchases on credit of sanitizer R41 312.00. 21 Dec The owner informed the accountant that he had taken sanitizer with a cost of R12 260.00 (excluding VAT) for his own use. 24 Dec cash register till slips (16/12/2018 - 24/12/2018) for cash sales of: R44 464.00 Deposited 27 Dec 2018. 24 Dec The owner withdrew cash of R48 286.00 from the entity's bank account to pay employee salaries. 5 29 Dec The owner instructed the accountant to calculate interest at 8% per annum on the balance owing by C Hemsworth which had been in arrears for 7 months at this date. 30 Dec An EFT of R6 000.00 was issued to the owner, for his personal cell phone account 31 Dec A proof of payment via EFT was received for R600.00 from Martin Goodman Attorneys. Refer to letter received from the attorneys. 31 Dec Received an invoice from T Hardy for R4 020.00 in respect of office equipment purchased. The current residual value is estimated to be R1 020.00. 31 Dec Cash register till slips (27/12/2018 - 31/12/2018) for cash sales of R64 108.00. nenosited 2 Jan 20X8 31 Dec A direct deposit was received from Ragnarock Attorneys for R4 000.00 in respect of an amount that they collected for the account of L Loki. According to the accounting records, this amount had been written off as irrecoverable in a prior period. 31 Dec A EFT for R4 560.00 was issued for advertisements which appeared in local magazines during December 2018. 31 Dec Issued a credit sales invoice to R Downey for purchases of sanitizer R2 996.00. Invoice AB52 was subsequently received from H Cavill for the delivery costs of 10% (including VAT) on the value of the sanitizer sold to R Downey. 31 Dec Cash of R1 016.00 was withdrawn by the accountant from the entity's bank account to re-instate the petty cash balance on hand to R1 600.00 31 Dec Stan Lee, the owner has been discussing the sale of some office equipment with his close friend and they decided to finalise the deal before year-end. The equipment was initially purchased on 1 April 2015 for R16 000.00, and was sold to Tony Stark for R10 000.00 on 1 December 2018. No entry has been made for this transaction. Tony Stark is not registered as a VAT vendor, and agreed to pay the amount due before the end of June 2019. - All of the office equipment items on the asset register, except those purchased during the current year, were purchased and ready for use on 1 April 2015. - Office equipment is depreciated at 15% per annum in accordance with the reducing balance method. Letter received from attorneys via e-mail. Building 6 555 Spider Road December 2018 Marvel Makers Road Pretoria RE: Insolvent estate of M Refallo We hereby confirm that Mr M Refallo has been declared insolvent during November 2018. As executers of his insolvent estate we finalised his this matter with a first and final dividend payable to all his creditors of 30c in the Rand. No further claims can be made against this estate as this matter is deemed resolved by the courts. Please find attached the payment advice for the final dividend payable to Marvel Makers. Kind regards M Goodman Representative of Martin Goodman Attorneys Payment advice 231 Payable to: Marvel Makers Banking details: DC Bank Account no: 123456789 Ref: M Refallo Date authorised: 31 December 2018 Amount authorised: R60 GENERAL INFORMATION: 1. 2. 3. 4. 5. MARVEL MAKERS buys and sells sanitizer. It began trading operations on 1 January 2015 and its financial year end is 31 December. All amounts are paid by EFT, unless otherwise stated. All EFT transactions appear in the entity's bank account on the day following the date of the transaction. The entity uses the perpetual inventory system and maintains a gross profit percentage of 25% (on selling price). During a period in November each year, the entity has an annual sale during which sanitizer is sold at a discount of 20% on normal selling price. The discount is only applied to cash sales concluded during the specified sale period. Assume that all items purchased or sold are received or dispatched correctly unless otherwise told. Cash received is deposited into the entity's bank account as indicated in the transactions provided. The entity is registered for VAT on the invoice basis. All transactions include VAT at the rate of 15% (where applicable) unless otherwise stated. The VAT periods of the entity are as follows: January - February, March - April, May - June, July - August, September, - October, November - December. Accept that all suppliers are also registered for VAT. The entity uses a VAT-input, VAT-output and VAT control account. 6. 7. 8. NB: There is NO settlement discount MARVEL MAKERS Trial balance at 1 November 2018 (for the 10 months ended 31 October 2018) Debit Credit Capital 1 357 758,00 Drawings 39 360,00 Land 200 000,00 Buildings at Cost 1 000 000,00 Buildings - Accumulated depreciation 60 000,00 Office equipment at cost 76 994,00 Office equipment - Accumulated depreciation 27 624,00 Vehicle at cost 550 200,00 Vehicle - Accumulated depreciation 173 400,00 8% Long-term loan from DC Bank 160 000,00 Inventories on hand 154 754,00 Trade debtors control (total) 32 672,00 C Boseman 4 472,00 R Downey 6 000,00 C Evans 4 000,00 C Johansson 11 400,00 C Hemsworth 4 800,00 M Raffalo 2 000,00 Allowance for expected credit losses 4 392,00 Bank (favourable) 70 554,00 Cash float 240,00 Petty cash 1 600,00 Trade creditors control 19 636,00 B Affleck 9 120,00 R Reynolds 3 520,00 T Hardy 6 312,00 I Elba 264,00 C Bale 420,00 H Cavill J Brolin VAT-Control 4 222,00 Sales 1 730 766,00 Cost of sales 1 012 812,00 Rental income 50 000,00 Interest income 15 260,00 13 Nov A petty cash voucher was approved by the accountant for the purchase of pens to be used by the general ledger clerk, R180.00 14 Nov The owner decided that the cash float in the till should be increased by R420.00. The accountant withdrew the cash from the entity's bank account on the owner's instruction. 14 Nov An EFT was received from C Boseman for R4 472.00. 14 Nov Credit invoice no. 123 was received from R Reynolds for sanitizer purchased on credit, R13 110.00. The sanitizer were delivered by H Cavill (see 20 Nov). 3 14 Nov Cash register till slips (1/11/2018 - 14/11/2018) for normal cash sales R42 030.00. Deposited on 15 Nov 2018. 15 Nov The telephone account of R4 514.00 was paid. 16 Nov A credit note for R456.00 was received from J Brolin for a rebate claimed on sanitizer that had been spilt out of its packaging on delivery. 17 Nov A petty cash voucher was made out for R400,00 cash taken by the owner's wife. 19 Nov Cash register till slips (15/11/2018 - 19/11/2018) issued for annual cash sale proceeds in respect of sanitizer, R57 796.00. Deposited on 20 Nov 2018. 20 Nov An invoice was received from H Cavill for delivery costs in respect of credit invoice no. 231 (see 14 Nov). The accountant issued an EFT for R1 300.00 to H Cavill. 21 Nov An EFT for R54 000.00 was received from the owner Stan Lee, in respect of an increase to his capital contribution. A receipt was issued to him for this amount. 23 Nov A cash invoice for R1 074.00 was handed to the cashier by the owner for repairs to the delivery vehicle, which the owner paid using his personal credit card. The accountant issued an EFT to the owner to reimburse him for this amount. 25 Nov The accountant discovered that the previous bookkeeper incorrectly posted sanitizer that were purchased as merchandise for R3 450.00 (VAT included), to the delivery costs on sales account on 31 October 2018. The owner has requested that this error be corrected. VAT was treated correctly for this transaction 25 Nov The owner requested the accountant to pay the VAT owing for the September October 2018 VAT period by EFT to the South African Revenue Services. 25 Nov Received an EFT from R Downey in settlement of his account. 28 Nov Basic salaries to the amount of R37 200.00 were paid to employees in cash. The money was withdrawn by the owner from the entity's bank account. 29 Nov A monthly statement was received from B Affleck. This was for purchases during November 2018 per invoice no. 11 for sanitizer of R37 894.00. These items were delivered by H Cavill. 29 Nov A credit invoice (AB21) was received from H Cavill for delivery costs amounting to R3 410.46 (see previous transaction). 30 Nov Cash register till slips (20/11/2018 - 30/11/2018) to be accounted for: R41 596.02. Deposited on 1 Dec 2018. 30 Nov An EFT issued to B Affleck for settlement of their account as on this date. 30 Nov Received an EFT from C Johansson in full settlement of her account. 30 Nov Cash of R774.00 was withdrawn by the accountant from the entity's bank account to re-instate the petty cash balance on hand to R1 600.00. DECEMBER 2018 3 Dec Credit sales invoice issued to C Johansson for purchases of sanitizer for R16 600.00. C Johansson transported the sanitizer herself. 6 Dec Invoice 975 was received from 1 Elba for sanitizer purchased on credit for R9 250.00 7 Dec Petty cash voucher issued for R166.00 in respect of delivery costs on certain cash sales. 8 Dec Petty cash voucher issued for purchase of stationery of R120.00. 9 Dec A credit note was received from C Bale amounting to R164.00 due to sanitizer that was over-charged on their invoice. 11 Dec Received invoice no. 72F9 from T Hardy for credit purchases of sanitizer for R13 550.00 12 Dec Invoice AB35 was received from H Cavill for delivery costs of 10% (including VAT) on sanitizer purchased from T Hardy (see previous transaction). 13 Dec A petty cash voucher issued for repairs to an office chair for R194.00. 15 Dec An EFT was issued for R3 732.00 to pay the telephone account 15 Dec Cash register till rolls (1/12/2018 - 15/12/2018) for cash sales R41 186.00. Deposited 17 Dec 2018 15 Dec EFTs issued to: R Reynolds R10 400.00; T Hardy R18 000.00; J Brolin R12 000.00; and | Elba R8 000.00 None of these payments were in settlement of the suppliers accounts. 17 Dec Petty cash vouchers for wages for R536.00. 17 Dec A credit sales invoice was issued to C Boseman for sales of R4 912.00 in respect of sanitizer. 20 Dec Invoice no. 72 received from B Affleck for purchases on credit of sanitizer R41 312.00. 21 Dec The owner informed the accountant that he had taken sanitizer with a cost of R12 260.00 (excluding VAT) for his own use. 24 Dec cash register till slips (16/12/2018 - 24/12/2018) for cash sales of: R44 464.00 Deposited 27 Dec 2018. 24 Dec The owner withdrew cash of R48 286.00 from the entity's bank account to pay employee salaries. 5 29 Dec The owner instructed the accountant to calculate interest at 8% per annum on the balance owing by C Hemsworth which had been in arrears for 7 months at this date. 30 Dec An EFT of R6 000.00 was issued to the owner, for his personal cell phone account 31 Dec A proof of payment via EFT was received for R600.00 from Martin Goodman Attorneys. Refer to letter received from the attorneys. 31 Dec Received an invoice from T Hardy for R4 020.00 in respect of office equipment purchased. The current residual value is estimated to be R1 020.00. 31 Dec Cash register till slips (27/12/2018 - 31/12/2018) for cash sales of R64 108.00. nenosited 2 Jan 20X8 31 Dec A direct deposit was received from Ragnarock Attorneys for R4 000.00 in respect of an amount that they collected for the account of L Loki. According to the accounting records, this amount had been written off as irrecoverable in a prior period. 31 Dec A EFT for R4 560.00 was issued for advertisements which appeared in local magazines during December 2018. 31 Dec Issued a credit sales invoice to R Downey for purchases of sanitizer R2 996.00. Invoice AB52 was subsequently received from H Cavill for the delivery costs of 10% (including VAT) on the value of the sanitizer sold to R Downey. 31 Dec Cash of R1 016.00 was withdrawn by the accountant from the entity's bank account to re-instate the petty cash balance on hand to R1 600.00 31 Dec Stan Lee, the owner has been discussing the sale of some office equipment with his close friend and they decided to finalise the deal before year-end. The equipment was initially purchased on 1 April 2015 for R16 000.00, and was sold to Tony Stark for R10 000.00 on 1 December 2018. No entry has been made for this transaction. Tony Stark is not registered as a VAT vendor, and agreed to pay the amount due before the end of June 2019. - All of the office equipment items on the asset register, except those purchased during the current year, were purchased and ready for use on 1 April 2015. - Office equipment is depreciated at 15% per annum in accordance with the reducing balance method. Letter received from attorneys via e-mail. Building 6 555 Spider Road December 2018 Marvel Makers Road Pretoria RE: Insolvent estate of M Refallo We hereby confirm that Mr M Refallo has been declared insolvent during November 2018. As executers of his insolvent estate we finalised his this matter with a first and final dividend payable to all his creditors of 30c in the Rand. No further claims can be made against this estate as this matter is deemed resolved by the courts. Please find attached the payment advice for the final dividend payable to Marvel Makers. Kind regards M Goodman Representative of Martin Goodman Attorneys Payment advice 231 Payable to: Marvel Makers Banking details: DC Bank Account no: 123456789 Ref: M Refallo Date authorised: 31 December 2018 Amount authorised: R60

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Financial Reporting And Analysis

Authors: John Dunn, Margaret Stewart

1st Edition

0470973609, 9780470973608

More Books

Students also viewed these Accounting questions