F3 ACCA exercise in excel, Exercises of International Business

It's an essential document, you can download and enjoy it

Typology: Exercises

2021/2022

Uploaded on 02/21/2022

khiem-nguyen-tran-anh
khiem-nguyen-tran-anh 🇻🇳

5

(1)

4 documents

1 / 9

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
EXERCISE 1:
1) BOOKS OF PRIME ENTRY:
Cash Receipt Book
Date Narrative Bank Receivables/ SLCA Cash sales
1.11.2016 capital $ 50,000
3.11.2016 Chris $ 6,000 $ 6,000
9.11.2016 David $ 5,600 $ 5,600
Purchases day book
Date Invoice no. Suppiler Net purchase Tax
2.11.2016 445556 Paul $ 5,000 $ -
7.11.2016 John $ 7,000 $ -
TOTAL $ 12,000 $ -
Sales day book
Date Invoice no. Customer Net Sales Tax
6.11.2016 David $ 12,000 $ -
Total $ 12,000 $ -
Cash payment book
Date Narrative Bank Payables Rent
4.11.2016 Payment $ 5,000 $ 5,000
5.11.2016 Rent $ 450 $ 450
8.11.2016 Van $ 7,000
total $ 12,450 $ 5,000 $ 450
Sales returns day book
Date Credit notes Customer Net Sales Tax
10.11.2016 5568 David $ 3,000 $ -
Petty Cash book
Receipts
Payments
Date Narrative Total Date Narrative
11.11.2016 Bank $ 100 12.11.2016 Stamps
2) THE LEDGER ACCOUNT
Dr Bank account Cr
AR 5600 5000 Payment
Capital 50000 450 Rent
Sales 6000 7000 Van
pf3
pf4
pf5
pf8
pf9

Partial preview of the text

Download F3 ACCA exercise in excel and more Exercises International Business in PDF only on Docsity!

EXERCISE 1:

1) BOOKS OF PRIME ENTRY:

Cash Receipt Book Date Narrative Bank Receivables/ SLCA Cash sales 1.11.2016 capital $ 50, 3.11.2016 Chris $ 6,000 $ 6, 9.11.2016 David $ 5,600 $ 5, Purchases day book Date Invoice no. Suppiler Net purchase Tax 2.11.2016 445556 Paul $ 5,000 $ - 7.11.2016 John $ 7,000 $ - TOTAL $ 12,000 $ - Sales day book Date Invoice no. Customer Net Sales Tax 6.11.2016 David $ 12,000 $ - Total $ 12,000 $ - Cash payment book Date Narrative Bank Payables Rent 4.11.2016 Payment $ 5,000 $ 5, 5.11.2016 Rent $ 450 $ 450 8.11.2016 Van $ 7, total $ 12,450 $ 5,000 $ 450 Sales returns day book Date Credit notes Customer Net Sales Tax 10.11.2016 5568 David $ 3,000 $ - Petty Cash book Receipts Date Narrative Total Date Narrative 11.11.2016 Bank $ 100 12.11.2016 Stamps

  1. THE LEDGER ACCOUNT Dr Bank account Cr AR 5600 5000 Payment Capital 50000 450 Rent Sales 6000 7000 Van

100 Petty cash 49050 Bal c/d Bal b/d 49050 Dr Sales Ledger( Subsidiary ledger) Cr David 6000 3000 David 3000 Bal c/d Bal b/d 3000 Dr Discount allowed Expense account Cr AR 400 400 Bal (P/L) Dr Payables / PLCA account Cr Bank 5000 Purchase $ 5, Bal c/d 7000 Purchase $ 7, Bal b/d $ 12, Dr Sales account Cr AR 3000 3.11.2016 $ 6, 6.11.2016 $ 12, Bal (P/L) 15000 Dr Van expense account Cr 8.11.2016 $ 7, 7000 Bal c/d Bal b/d $ 7, Dr stamp expense account Cr 12.11.2016 $ 10 $ 10 Bal P/L

  1. TRIAL BALANCE DR CR Bank account $ 49, Receivables/ SLCA account $ 3, Sales $ 15, Capital account $ 50, Discount allowed Expense account $ 400 Purchase account $ 12,

t Book Capital Discount allowed $ 50, $ 400 y book gross $ 5, $ 7, $ 12, ook gross $ 12, $ 12, t book Van Discount received $ 7, $ 7, ay book gross $ 3, Petty Cash book Payments Voucher No. Total Postage Cleaning $ 10 Dr Receivables/ SLCA account Cr Sales 12000 5600 Bank 400 Discount allowed 3000 Sales returns

3000 Bal c/d Bal b/d 3000 Dr Capital account Cr 50000 Bank Bal c/d 50000 50000 Bal b/d Dr Purchase account Cr AP $ 5, AP $ 7, $ 12,000 Bal (P/L) Dr Purchases Ledger( Subsidiary ledger) Cr Paul $ 5,000 5000 Paul 7000 John Bal c/d 7000 7000 Bal b/d Dr Rental expense account Cr 5.11.2016 $ 450 Bal (P/L) $ 450 Dr Petty cash account Cr 11.11.2016 $ 100 12.11.2016 $ 10 Bal c/d $ 90 Bal b/d $ 90

  1. STATEMENT OF PROFIT OR LOSS 5) STATEMENT OF FINANCIAL POSITIO Sales Revenue $ 15,
  • Cost of Sales 5000 Assets Opening inventories 0 Non-current asset
  • Purchases 12000 Van
  • Closing inventories 7000 = Gross profit $ 10,
  • Discount Allowed Expense 400 Current asset

ount allowed

ATEMENT OF FINANCIAL POSITION

current asset 7000 7000 Cost 7000 Accumulate 0 59765