aat
Association of
Accounting Technicians
Unit 1 - Bookkeeping Transactions
Assessment Task Questionnaire
E-Ca�EE�J' e
ASSIGNMENT
Complete all 10 tasks.
Background of S&A Pet Food Supplies:
You are employed by S&A Pet Food Supplies, as a bookkeeper
S&A Pet Food Supplies use a manual bookkeeping system
Double entry takes place in the general ledger. Individual accounts of trade
receivables and trade payables are kept in the sales and purchases ledgers as
subsidiary accounts.
The cash book and petty cash book should be treated as part of the double-entry
system unless the task instructions state otherwise.
The VAT rate is 20%.
Question 1
You have been provided with the following delivery note relating to goods delivered to a
credit customer, Tim’s Pet Shop.
DELIVERY NOTE
S&A Pet Food Supplies
1 High Street
Sandbach
Cheshire
CW1 1AA
Tel: 01234 123456
To: Tim’s Pet Shop Ref: DN194637
10 Main Road Delivery date: 07.09.20XX
Nantwich Sales order number: 57473
Cheshire Customer account code: TIM01
CW5 6GG
Code Quantity Description
DG004 20 Adult dog food 15 litre
The above goods have been delivered and received in good condition.
T. Sharpe
The list price of the dog food is £18.99 plus VAT at 20%. Tim’s Pet Shop are given a 10%
trade discount and a 5% prompt payment discount if the invoice is settled within 7 days.
(a) Complete the eight boxes on the sales invoice below:
SALES INVOICE
S&A Pet Food Supplies
1 High Street
Sandbach
Cheshire
CW1 1AA
To: Tim’s Pet Shop Invoice No. 156472
10 Main Road Order No. 57473
Nantwich Customer account
code. TIM01
Cheshire
Invoice date [Link]
CW5 6GG
Details Unit price Total Trade Net
Discount
£ £ £
%
18.99 379.80 37.98 341.82
20 x Adult dog food 15 litre (DG004)
Net total 341.82
VAT
68.36
Total 410.18
Terms: Net 30 days
Terms: 5% prompt payment discount for payment within 7 days
E&OE VAT Reg No. 246 4725 46
(b) If Tim’s Pet Shop settles his account and takes the prompt payment discount
offered, how much will he pay?
£ 389.68
(c) Once Tim’s Pet Shop has settled his account and taken the discount, what action
should be taken regarding the settlement discount?
No action required
Issue a credit note for the discount amount X
Issue a credit note for the sales invoice amount
Issue a credit note for the VAT amount
(d) You have received payment for £564.62 from The Kitty Store on the 5th September
20XX. Identify which item has not been included in the payment, referring to the
sales ledger account below:
Sales Ledger Account
The Kitty Store
Details Reference Amount Details Reference Amount
£ £
01.08.20XX 2654 354.60 10.08.20XX CN 105 30.50
04.08.20XX 2661 244.52 15.08.20XX Bank 229.00
05.08.20XX 2669 237.50 15.08.20XX Discount 12.50
28.08.20XX 2705 120.00
272.00
956.62
Question 2
(a) Sales invoices have been partially entered in the day book below. You are required
to complete the entries and total the day book.
SALES DAY BOOK
DATE DETAIL REFERENCE TOTAL VAT NET
£ £ £
01.09.20XX Coopers Ltd SL02 169.80 28.30 141.50
03.09.20XX Potters & SL09 144.60 24.10 120.50
Co.
04.09.20XX Green Direct SL15 238.65 39.77 198.88
04.09.20XX Harpers SL20 363.20 60.53 302.67
05.09.20XX Coopers Ltd SL02 255.45 42.57 212.88
1,171.70 195.27 976.43
(b)
A supply of dog food has been delivered to S&A Pet Food Supplies by Pet World Direct.
The purchase order and invoice from Pet World Direct are shown below.
You are required to check the details of the invoice against the purchase order including
quantities, description, codes and arithmetical calculations, and identify any discrepancies.
You can assume the unit prices are correct.
Terms are: Net 60 days and trade discount 20%
PURCHASE ORDER Order No: PO 2031
S&A Pet Food Supplies
1 High Street VAT Reg No: 547 2526 44
Sandbach
Cheshire CW1 1AA
To: Pet World Direct Date: 20 September 20XX
Quantity Description Code
40 Dog food (puppy) DF 010
60 Dog food (adult) DF 011
30 Dog food (senior) DF 012
Deliver To: Above address
Signed: S Tonks (Head
Buyer)
SALES INVOICE Invoice No: 2847
Pet World Direct
20 High Street
Crewe
CW1 6HH
To: S&A Pet Food Supplies
1 High Street Date/Tax Point: 28 September 20XX
Sandbach
Cheshire Your Order No: PO 2031
CW1 1AA
Unit VAT Goods
Rate
Product Quantity Description Price Total
Code
£ p % £ p
DF010 40 Dog food (puppy) 22 00 20 880 00
DF011 60 Dog food (adult) 20 00 20 1,200 00
DF012 30 Dog food (senior) 22 00 20 660 00
Goods Total 2,740 00
Less Trade Discount 10% 274 00
Net Goods 3,014 00
2,466 00
VAT 602 80
Carriage Paid 493 20
Total Due 3,616 80
Terms: Net 30 day 2,949 20
E & OE VAT Reg No: 835 7564 29
Question 3
You have received the following statement from The Village Pet Store:
STATEMENT OF ACCOUNT
To: S&A Pet Food Supplies
The Village Pet Store
1 Maple Street
Sandbach
Cheshire
CW1 3FF
Tel: 0111 200 3000
Date: 30.09.20XX
DATE TRANSACTION DEBIT CREDIT BALANCE
01.09.20XX INVOICE 5647 188.20 188.20
04.09.20XX INVOICE 5659 142.30 330.50
05.09.20XX INVOICE 5668 98.00 428.50
10.09.20XX CN 382 20.50 408.00
12.09.20XX PAYMENT 387.60 20.40
28.09.20XX INVOICE 5705 120.00 140.40
Our terms are 30 days net, however if payment is made within 14 days, a prompt
payment discount of 5% can be taken.
The purchase ledger account for The Village Store is shown below:
Purchase Ledger Account
The Village Pet Store
Details Reference Amount Details Reference Amount
£ £
01.09.20XX 5647 188.20 10.09.20XX CN 382 20.50
04.09.20XX 5659 142.30 12.09.20XX Bank 387.60
05.09.20XX 5668 98.00 12.09.20XX Discount 20.40
28.09.20XX 5705 120.00
548.50 428.50
En el
(a) Which item is missing from the statement of account?
Discount Amount 20.40
(b) Which item is missing from the supplier account in the purchases ledger?
28.09.20XX Invoice 5705 Amount 120.00
Se adeudara
(c) Assuming the omissions are the only errors, what amount will be due to The Village
Pet Store?
The amount of 120 is owed
Question 4
(a) You have been provided with details of payments received from customers during
the week ending the 7th September 20XX, and should now write up the cash
receipts book:
Customer Name Customer Code Amount
£
D. Sky SKY002 372.40
C. Crookes CRO004 138.00
P. Ryall RYA001 275.99
Cash sales of £228.00 including VAT have also been received and banked.
Por cobrar
CASH RECEIPTS BOOK
Date Detail Reference Bank VAT Receivables Cash
£ £ £ sales
£
01.09.20XX Balance b/f 125.40
Totals
(b) The payments side of the cash book totalled £823.90. What will the balance
brought down be in the cash book?
(c) If the bank balance is a credit balance, does this mean the account is overdrawn?
Question 5
S&A Pet Food Supplies maintain a petty cash book as part of the double-entry system,
and you have been provided with the petty cash purchases for the week.
02.09.20XX Postage £7.80 (VAT Exempt)
03.09.20XX Advert £54.00 (including VAT)
04.09.20XX Coffee £8.40 (no VAT)
(a) Enter the transactions into the partly completed petty cash book below, total the
petty cash book and show the balance carried forward as at the 5th September
20XX.
RECEIPTS PAYMENTS
Date Detail Total Date Detail Voucher Total Post Advert Sundry VAT
£ No. £
20XX 20XX
01.09 Bal B/f 88.20 01.09 Postage 44 6.20 6.20
01.09. Bank 61.80
(b) Which four accounts in the general ledger will record the above transactions?
(c) At the end of the week, S&A Pet Food Supplies require the petty cash balance to be
restored to the imprest amount of £150.00. State the amount required to restore
the balance.
Question 6
The following two credit notes have been entered in the sales returns day book below.
SALES RETURNS DAY BOOK
DATE DETAIL REFERENCE TOTAL VAT NET
£ £ £
01.09.20XX Coopers Ltd SL02 57.60 9.60 48.00
04.09.20XX Harpers SL20 38.40 6.40 32.00
96.00 16.00 80.00
(a) What will the entries be in the general ledger?
General ledger
ACCOUNT AMOUNT DEBIT CREDIT
£
(b) Complete the subsidiary sales ledger accounts.
Sales ledger
ACCOUNT AMOUNT DEBIT CREDIT
£
Coopers Ltd
Harpers
Question 7
You have been provided with the cash payments book below, which has been totalled:
CASH PAYMENTS BOOK
Totals Cash Bank VAT Payables Cash Sundry
purchases expenses
£ £ £ £ £ £
621.90 4,100.50 170.40 3,700.00 500.00 352.00
(a) What will the four entries be in the general ledger?
General ledger
ACCOUNT AMOUNT DEBIT CREDIT
£
(b) The payables total includes a payment made to supplier Pet Direct for £320.00.
What will the entry be in the purchase ledger?
Purchase ledger
ACCOUNT AMOUNT DEBIT CREDIT
£
Question 8
The two accounts below are in the general ledger.
DISCOUNT ALLOWED
DATE DETAIL £ DATE DETAIL £
01.09.20XX Balance b/d 250.00
16.09.20XX Discount 88.00
allowed day
book
BANK INTEREST RECEIVED
DATE DETAIL £ DATE DETAIL £
01.09.20XX Balance b/d 56.50
16.09.20XX Bank 12.10
(a) What will the balance brought down on each account be?
ACCOUNT AMOUNT DEBIT CREDIT
(b) The purchases account shown below is also in the general ledger. You are
required to total the account and show the balance carried down as at the
7th September 20XX, and brought down as at the 8th September 20XX.
PURCHASES
DATE DETAIL £ DATE DETAIL £
01.09.20XX Balance b/d 2,567.80
05.09.20XX Bank 425.33
07.09.20XX Bank 210.66
Question 9
You have been given the Trial Balance below and now need to enter the amounts shown
in either the debit or credit columns, and then total the Trial Balance.
Trial Balance at 30th September 20XX
AMOUNT DR CR
£ £ £
Capital 21,340
Bank (overdraft) 1,030
Delivery vehicle 20,000
Shop equipment 4,300
Computer 1,200
Rent 6,000
Sales 25,000
Purchases 8,000
Discounts received 880
Discounts allowed 750
Advertising 400
Heat and light 1,050
Staff wages 6,000
Delivery vehicle fuel 550
Question 10
(a) State which of the following statement/s is/are correct for the accounting equation:
TRUE FALSE
Assets = Liabilities + Capital
Assets – Liabilities = Capital
Assets + Liabilities = Capital
(b) State if the following are either an asset or liability:
ASSET LIABILITY
Bank overdraft
Money due from customers
Motor vehicles
(c) State if the following items are capital income, capital expenditure, revenue income
or revenue expenditure:
CAPITAL CAPITAL REVENUE REVENUE
INCOME EXPENDITURE INCOME EXPENDITURE
Office equipment
Sale of motor van
Rent paid
Receipt from cash
sales
