create a purchases, payable reconciliation summary.

report^

Transaction Sources Cash registers - for cash sales Invoices -- for credit sales Cheque book - for cash payments Deposit books - for cash receipts Bank statements - for direct charges and direct deposits Supplier invoices - for goods and services Working papers - for adjusting and miscellaneous entries GST Please note that GST free items are bank fees, salaries and wages, interest expense, superannuation and fines - you can check with your lecturer for others. Transaction Period New financial year starting 1* July 2020, and the processing period is July 2020, the current financial year is 2021, conversion month being July and there are 12 periods. Opening Balances as at 1 July 2020 Credits Debit $ $45,000 $61,000 $150,190 $9,000 $4,400 $80,500 $45,000 $55,000 General Ledger Account Balances Cash at Bank Accounts Receivable Inventory Prepaid Insurance Prepaid Rent Store Fittings Accumulated Depreciation Store Fittings Motor Vehicles Accumulated Depreciation - Motor Vehicles Accounts Payable GST Collected (payable) GST Paid (receivable) Sales Commission Payable Loans Current PAYG Withholding Payable Loan - Non-current Share Capital Retained Earnings $30,000 $75,970 $16,000 $7,200 $6,500 $20,000 $8,500 $80,000 $80,000 $49,820 $411,790 $411,790 Customers 1. Students are required to devise their own unique customer names and addresses. 2 Both cash and credit sales are recorded via the sales modules. 3. Information provided for customers and their balance as at 14 July are as follows: Accounts Receivable Control Balance Days Customer Code Outstanding $ Outstanding CUS01 $9,000 60 CUSO2 $7,500 30 CUSO3 $6,800 90 CUSO4 $8,700 30 CUSOS $2,400 30 CUSO6 $8,600 60 CUSOZ $7,200 30 CUS08 $4,800 30 CUSO9 $2,800 90 CUS10 $3,200 30 Total $61,000 Suppliers 1. Students are required to devise their own unique supplier names and addresses. 2. Accounts Payable ledger has suppliers entered for trading stock as well as other goods and services acquired on credit. 3. All suppliers extend the normal 30-day terms, with no discount for prompt payment. 4. Information provided for suppliers and their balance as at 14 July are as follows: Accounts Payable Control Balance Invoice Supplier Code Outstanding $ Date SUP01 $23,000 7-Jun-20 SUPO2 $16,500 12-Jun-20 SUPO3 $18,400 15-Jun-20 SUPO4 $9,800 22-Jun-20 SUPOS - Telephone $770 4-Jun-20 SUP06 - Stationery 5660 9-Jun-20 SUPO7 - MV Maintenance 5440 24-Jun-20 SUP08 - Real Estate (rent) SO 18-Jun-20 SUP09 - Advertising 55,300 3-Jun-20 SUPIO . Postage $1,100 20-Jun-20 Total $75,970 Inventory 1. Students are required to devise their own unique product names. 2. Inventory unit measure is per gift item (unit). There are 10 different products. 3. The firm uses the perpetual inventory method of accounting for inventory, (that is when inventory is purchased it is added to "Inventory and when it is sold, the cost is debited against Cost of sales' and credited against "Inventory). 4. Information provided for the inventory opening balance as at 1 July is as follows: Inventory Control Quantity Unit cost Value of Unit Sell Price Product Code on Hand Inventory Excluding GST P001 1,100 $16 $17,600 $40.00 POO2 750 $14 $10,500 $35.00 P003 860 $12 $10,320 $30.00 P004 940 $18 $16,920 $40.00 POOS 1,150 $15 $17,250 $37.50 P006 1,480 $10 $14,800 $25.00 P007 1,600 $20,800 $32.50 POOS 900 $17 $15,300 $42.50 P009 1,200 $14 $16,800 $35.00 P010 900 $11 $9.900 $27.50 Total $150,190 $13 Transactions for July 2020 Date source: Supplier Invoice dates and amounts include GST. Date Transaction Details 5 July Received invoice from SUPO1, for 800 units of P001, received into the warehouse. The invoice was for $14,080. 8h July Received invoice from SUPO4 for 250 units of POO2, $3,850. 9 July Received invoice from SUPO3 for 300 units of P009, $4,620 and 200 units of P010, $2,420. 106 July Received invoice from SUPO5 for telephone for the month, $880. 119 July Purchased stationery on account from SUP06, for $330 (stationery is expensed at the time it is purchased). 12 July Received advertising invoice from SUPO9 for $5,500 14 July Received invoice for $7,480 with shipment from SUPO2 of 400 units of P008. 19 July Received invoice from SUPO7 for maintenance of company vehicles $770.00. 23 July Invoice from SUPO6 for more office stationery purchased 264.00 24 July Received Invoice from SUPO3, for 360 units of P004 $7, 128 and 440 units of P003 S5,808 24 July Received Invoice from SUP04, $14,025 for 850 units of P005. Sales Returns - Credit Notes Issued Dato Transaction Details gth July CUSOS has retumed 20 units of P006, as damaged and requested a credit note for the amount - (REPER to the sale on GH July listed above). 5th July gth July Data source - Deposit book (Cash Receipts) Date Transaction Details Customer CUS01 paid $9,000, the balance of their account as at 1* July. 6th July Customer CUS03 paid $6,800, the balance of their account as at 12 July. 7th July Customer CUSO4, paid $8,700 the balance of their account as at 1July. Customer CUS10 paid $3,200, the balance of their account as at 1 July. 10th July Customer CUSO6 paid $8,600 the balance of their account as at 1* July. 15th July CUSOS, paid the balance of their account as at 1* July, plus all the purchases of goods made up to and including the 6th July. 25th July CUSO8 paid $18,000 of the outstanding balance of their account. 27th July Received $15,000 from CUS09. 30th July Received a cheque from CUSO2 for full settlement of their account, leaving a nil balance. 313 July On 31st July, after depreciation was recorded, the business sold an old motor vehicle that had a written down value of $6,500.00 at the end of the month, for $7,700.00 cash (the $7,700 is inclusive of GST). The motor vehide originally cost $20,000.00. This amount was not banked as at 31* July. Data source - Cheque book (Cash Payments) Date Transaction Details 1 July Drew a cheque for $1,500.00 to start a Petty Cash float. (Cheque No: 1001) 30 July Reimbursed $132.00 to an employee for travel expenses incurred. (Cheque No: 1002) 6 July Paid June's sales commission to retail assistants of $6,500.00 previously accrued. (Cheque No: 1003) 14" July Paid June's PAYG withholding tax of $8,500.00 (Cheque No: 1004) 16 July Paid net GST obligation for June, as per the trial balance. (Cheque No: 1005) 2011 July Paid SUP01 $23,000, the balance owing as at 14 July. (Cheque No: 1006) 219 July Paid SUPO2 $16,500, the balance owing as at 1st July. (Cheque No: 1007) 23 July Paid SUPO4, 59,800.00 being the previous month's balance, plus $3,850.00 toward current month purchases. (Cheque No. 1008) Sales Returns-Credit Notes Issued Date Transaction Details gth July CUSOS has returned 20 units of P006, as damaged and requested a credit note for the amount - (REPER to the sale on 6th July listed above). 5th July 6th July 7th July Data source - Deposit book (Cash Receipts) Date Transaction Details Customer CUS01 paid $9,000, the balance of their account as at 1* July. Customer CUSO3 paid $6,800, the balance of their account as at 1st July. Customer CUSO4, paid $8,700 the balance of their account as at 1* July. 8th July Customer CUS10 paid $3,200, the balance of their account as at 19 July, 10th July Customer CUS06 paid $8,600 the balance of their account as at 14 July. 15th July CUSOS, paid the balance of their account as at 1* July, plus all the purchases of goods made up to and including the 6th July. 25th July CUSO8 paid $18,000 of the outstanding balance of their account. 27th July Received $15,000 from CUSO9. 30th July Received a cheque from CUSO2 for full settlement of their account, leaving a nil balance 315 July On 31st July, after depreciation was recorded, the business sold an old motor vehicle that had a written down value of $6,500.00 at the end of the month, for $7,700.00 cash (the $7,700 is inclusive of GST). The motor vehicle originally cost $20,000.00. This amount was not banked as at 31 July. Data source - Cheque book (Cash Payments) Date 14 July 3rd July 6th July 14th July 16 July 2016 July 219 July 23 July Transaction Details Drew a cheque for $1,500.00 to start a Petty Cash float. (Cheque No: 1001) Reimbursed $132.00 to an employee for travel expenses incurred. (Cheque No: 1002) Paid June's sales commission to retail assistants of $6,500.00 previously accrued. (Cheque No: 1003) Paid June's PAYG withholding tax of $8,500.00 (Cheque No: 1004) Paid net GST obligation for June, as per the trial balance. (Cheque No: 1005) Paid SUP01 $23,000, the balance owing as at 14 July. (Cheque No: 1006) Paid SUPOZ $16,500, the balance owing as at 1st July. (Cheque No: 1007) Paid SUPO4, 59,800.00 being the previous month's balance, plus $3,850.00 toward current month purchases (Cheque No: 1008) 25th July Pald balances as at 15 July owing to SUP03 (Cheque No: 1009), SUP05 (Cheque No: 1010), SUP06 (Cheque No: 1011) SUP07 (Cheque No: 1012), SUP09 (Cheque No: 1013), SUP10 (Cheque No: 1014), 30th July Net wages paid to employees for the month amounted to $38,000 (Cheque No: 1015). The PAYG withholding tax amounted to $12,000.00 and this amount will be remitted to the Australian Tacation Office on the 23 August. 314 July Paid $4,500.00 (Cheque No: 1016) for employee superannuation on wages earned during July 31 July Drew a cheque (Cheque No: 1017) for $810.00 to reimburse petty cash fund for the following cash expenses: (all amounts are GST Indusive) Subscriptions $210.00 Printing $320.00 Travelling Expenses $180.00 Sundry Office Expense $100.00. Data source - Bank Statement (see next page) Date Transaction Details 18th July Periodic payment for lease of POS equipment $1,100.00 for July (incl. GST). 30th July Bank charges of $80.00 were charged to the account Data source - Notes and Working papers (Month-end Adjustments) Date Transaction Details 31 July Store Fittings are depreciated at 20% per annum, calculated and recorded using the number of days in the month. 31 July Motor Vehicles are depreciated at the rate of 25% of carrying amount per annum (using the reducing balance method of depreciation). Depreciation is calculated as follows - (Carrying Amount 25% - 31+365) 31 July Sales commission earned but not paid as at 31 July, amounted to 54,200. 31 July Prepaid insurance as at 1 July ($9,000.00) represented the balance of the premium paid on the annual policy, which started on 1 May (with 2 months insurance expired as at 30 June). This prepaid insurance is expensed monthly. (irrespective of the number of days in the month). 31st July The prepaid rent at the start of the month was charged to Rent expense during the month. 312 July The company's short term and long term loans are charged interest at the rate of 12% per annum and interest needs to be accrued for July (31 days). 31 July Estimated electricity cost for July is $2,600 which must be accrued. The Bank Statement received from the bank at the end of July is as follows: NABBY Bank Australia Business Trading Account Account Name: Case Study Account No. 012 199 088789 The Manager, Your Name Gifts Pty Ltd Address From: To: 1-July-2020 31-July-2020 Debit Credit $13,200.00 $17,160.00 $1,500.00 $132.00 $5,912.50 $9,000.00 $4,757.50 $6,800.00 34,138.75 $6,500.00 $1,320.00 $8,700.00 $3,795.00 $3,200.00 $8,600.00 Date 1-Jul-20 2-Jul-20 3-Jul-20 3-Jul-20 5-Jul-20 5-Jul-20 6-Jul-20 6-Jul-20 7-Jul-20 7-Jul-20 8-Jul-20 8-Jul-20 8-Jul-20 9-Jul-20 9-Jul-20 11-Jul-20 15-Jul-20 18-Jul-20 16-Jul-20 20-01-20 22-Jul-20 23-Jul-20 23-Jul-20 25 Jul-20 26-Jul-20 27 Jul 20 27-Jul-20 28 Jul 20 28-Jul-20 28 Jul 20 28 Jul 20 28-Jul-20 30 Jul-20 31-Jul-20 30-Jul-20 Particulars Opening Balance Deposit - Cash & Cheques Deposit - Cash & Cheques Chq.# 1001 Chq.e 1002 Deposit - Cash & Cheques Deposit - Cash & Cheques Deposit Cash & Cheques Deposit - Cash & Cheques Deposit - Cash & Cheques Chq.# 1003 Deposit - Cash & Cheques Deposit - Cash & Cheques Deposit - Cash & Cheques Deposit Cash & Cheques Deposit Cash & Cheques Chq. 1004 Periodic Payment POS Equip Lease Deposit - Cash & Cheques Chg. 1005 Ch. 1006 Deposit - Cash & Cheques Chq.100 Chq.# 1008 Deposit Cash & Cheques Ch. 1010 Chq.# 2009 Chg. 1014 Chg. 1012 Ch. 1013 Chg 1011 Deposit Cash & Cheques Bank Charges July Chg 1015 Depost Cash & Cheques $8,500.00 $1,100.00 Balance $45,000.00 $58,200.00 $75,360.00 $73,860.00 $73,728.00 $79,640.50 $88,640.50 $93,398.00 $100,198.00 $104,336.75 $97,836.75 $99,156.75 $107,856.75 $111,651.25 $114,851.75 $123,451.75 $114,951.75 $113,851.75 $129,066.75 $120,266.75 $97,266.75 $99,686.75 $83,186.75 $69,536.75 $87.536.75 586,266.75 $68,366.75 567, 266.75 366,826.75 $61 526.75 $60,866.75 $75,866,75 $75,286.75 $37,786,25 553,426.75 515,215.00 58,800.00 523,000.00 52,420.00 $16,500.00 513,650.00 $18,000.00 $270.00 $18.400.00 $1,100.00 $440.00 $5,300.00 $660.00 $15,000.00 $80.00 $38,000.00 $15,640.00 Transaction not shown on the Bank Statement are either UNPRESENTED CHEQUES or OUTSTANDING DEPOSITS. Transaction Sources Cash registers - for cash sales Invoices -- for credit sales Cheque book - for cash payments Deposit books - for cash receipts Bank statements - for direct charges and direct deposits Supplier invoices - for goods and services Working papers - for adjusting and miscellaneous entries GST Please note that GST free items are bank fees, salaries and wages, interest expense, superannuation and fines - you can check with your lecturer for others. Transaction Period New financial year starting 1* July 2020, and the processing period is July 2020, the current financial year is 2021, conversion month being July and there are 12 periods. Opening Balances as at 1 July 2020 Credits Debit $ $45,000 $61,000 $150,190 $9,000 $4,400 $80,500 $45,000 $55,000 General Ledger Account Balances Cash at Bank Accounts Receivable Inventory Prepaid Insurance Prepaid Rent Store Fittings Accumulated Depreciation Store Fittings Motor Vehicles Accumulated Depreciation - Motor Vehicles Accounts Payable GST Collected (payable) GST Paid (receivable) Sales Commission Payable Loans Current PAYG Withholding Payable Loan - Non-current Share Capital Retained Earnings $30,000 $75,970 $16,000 $7,200 $6,500 $20,000 $8,500 $80,000 $80,000 $49,820 $411,790 $411,790 Customers 1. Students are required to devise their own unique customer names and addresses. 2 Both cash and credit sales are recorded via the sales modules. 3. Information provided for customers and their balance as at 14 July are as follows: Accounts Receivable Control Balance Days Customer Code Outstanding $ Outstanding CUS01 $9,000 60 CUSO2 $7,500 30 CUSO3 $6,800 90 CUSO4 $8,700 30 CUSOS $2,400 30 CUSO6 $8,600 60 CUSOZ $7,200 30 CUS08 $4,800 30 CUSO9 $2,800 90 CUS10 $3,200 30 Total $61,000 Suppliers 1. Students are required to devise their own unique supplier names and addresses. 2. Accounts Payable ledger has suppliers entered for trading stock as well as other goods and services acquired on credit. 3. All suppliers extend the normal 30-day terms, with no discount for prompt payment. 4. Information provided for suppliers and their balance as at 14 July are as follows: Accounts Payable Control Balance Invoice Supplier Code Outstanding $ Date SUP01 $23,000 7-Jun-20 SUPO2 $16,500 12-Jun-20 SUPO3 $18,400 15-Jun-20 SUPO4 $9,800 22-Jun-20 SUPOS - Telephone $770 4-Jun-20 SUP06 - Stationery 5660 9-Jun-20 SUPO7 - MV Maintenance 5440 24-Jun-20 SUP08 - Real Estate (rent) SO 18-Jun-20 SUP09 - Advertising 55,300 3-Jun-20 SUPIO . Postage $1,100 20-Jun-20 Total $75,970 Inventory 1. Students are required to devise their own unique product names. 2. Inventory unit measure is per gift item (unit). There are 10 different products. 3. The firm uses the perpetual inventory method of accounting for inventory, (that is when inventory is purchased it is added to "Inventory and when it is sold, the cost is debited against Cost of sales' and credited against "Inventory). 4. Information provided for the inventory opening balance as at 1 July is as follows: Inventory Control Quantity Unit cost Value of Unit Sell Price Product Code on Hand Inventory Excluding GST P001 1,100 $16 $17,600 $40.00 POO2 750 $14 $10,500 $35.00 P003 860 $12 $10,320 $30.00 P004 940 $18 $16,920 $40.00 POOS 1,150 $15 $17,250 $37.50 P006 1,480 $10 $14,800 $25.00 P007 1,600 $20,800 $32.50 POOS 900 $17 $15,300 $42.50 P009 1,200 $14 $16,800 $35.00 P010 900 $11 $9.900 $27.50 Total $150,190 $13 Transactions for July 2020 Date source: Supplier Invoice dates and amounts include GST. Date Transaction Details 5 July Received invoice from SUPO1, for 800 units of P001, received into the warehouse. The invoice was for $14,080. 8h July Received invoice from SUPO4 for 250 units of POO2, $3,850. 9 July Received invoice from SUPO3 for 300 units of P009, $4,620 and 200 units of P010, $2,420. 106 July Received invoice from SUPO5 for telephone for the month, $880. 119 July Purchased stationery on account from SUP06, for $330 (stationery is expensed at the time it is purchased). 12 July Received advertising invoice from SUPO9 for $5,500 14 July Received invoice for $7,480 with shipment from SUPO2 of 400 units of P008. 19 July Received invoice from SUPO7 for maintenance of company vehicles $770.00. 23 July Invoice from SUPO6 for more office stationery purchased 264.00 24 July Received Invoice from SUPO3, for 360 units of P004 $7, 128 and 440 units of P003 S5,808 24 July Received Invoice from SUP04, $14,025 for 850 units of P005. Sales Returns - Credit Notes Issued Dato Transaction Details gth July CUSOS has retumed 20 units of P006, as damaged and requested a credit note for the amount - (REPER to the sale on GH July listed above). 5th July gth July Data source - Deposit book (Cash Receipts) Date Transaction Details Customer CUS01 paid $9,000, the balance of their account as at 1* July. 6th July Customer CUS03 paid $6,800, the balance of their account as at 12 July. 7th July Customer CUSO4, paid $8,700 the balance of their account as at 1July. Customer CUS10 paid $3,200, the balance of their account as at 1 July. 10th July Customer CUSO6 paid $8,600 the balance of their account as at 1* July. 15th July CUSOS, paid the balance of their account as at 1* July, plus all the purchases of goods made up to and including the 6th July. 25th July CUSO8 paid $18,000 of the outstanding balance of their account. 27th July Received $15,000 from CUS09. 30th July Received a cheque from CUSO2 for full settlement of their account, leaving a nil balance. 313 July On 31st July, after depreciation was recorded, the business sold an old motor vehicle that had a written down value of $6,500.00 at the end of the month, for $7,700.00 cash (the $7,700 is inclusive of GST). The motor vehide originally cost $20,000.00. This amount was not banked as at 31* July. Data source - Cheque book (Cash Payments) Date Transaction Details 1 July Drew a cheque for $1,500.00 to start a Petty Cash float. (Cheque No: 1001) 30 July Reimbursed $132.00 to an employee for travel expenses incurred. (Cheque No: 1002) 6 July Paid June's sales commission to retail assistants of $6,500.00 previously accrued. (Cheque No: 1003) 14" July Paid June's PAYG withholding tax of $8,500.00 (Cheque No: 1004) 16 July Paid net GST obligation for June, as per the trial balance. (Cheque No: 1005) 2011 July Paid SUP01 $23,000, the balance owing as at 14 July. (Cheque No: 1006) 219 July Paid SUPO2 $16,500, the balance owing as at 1st July. (Cheque No: 1007) 23 July Paid SUPO4, 59,800.00 being the previous month's balance, plus $3,850.00 toward current month purchases. (Cheque No. 1008) Sales Returns-Credit Notes Issued Date Transaction Details gth July CUSOS has returned 20 units of P006, as damaged and requested a credit note for the amount - (REPER to the sale on 6th July listed above). 5th July 6th July 7th July Data source - Deposit book (Cash Receipts) Date Transaction Details Customer CUS01 paid $9,000, the balance of their account as at 1* July. Customer CUSO3 paid $6,800, the balance of their account as at 1st July. Customer CUSO4, paid $8,700 the balance of their account as at 1* July. 8th July Customer CUS10 paid $3,200, the balance of their account as at 19 July, 10th July Customer CUS06 paid $8,600 the balance of their account as at 14 July. 15th July CUSOS, paid the balance of their account as at 1* July, plus all the purchases of goods made up to and including the 6th July. 25th July CUSO8 paid $18,000 of the outstanding balance of their account. 27th July Received $15,000 from CUSO9. 30th July Received a cheque from CUSO2 for full settlement of their account, leaving a nil balance 315 July On 31st July, after depreciation was recorded, the business sold an old motor vehicle that had a written down value of $6,500.00 at the end of the month, for $7,700.00 cash (the $7,700 is inclusive of GST). The motor vehicle originally cost $20,000.00. This amount was not banked as at 31 July. Data source - Cheque book (Cash Payments) Date 14 July 3rd July 6th July 14th July 16 July 2016 July 219 July 23 July Transaction Details Drew a cheque for $1,500.00 to start a Petty Cash float. (Cheque No: 1001) Reimbursed $132.00 to an employee for travel expenses incurred. (Cheque No: 1002) Paid June's sales commission to retail assistants of $6,500.00 previously accrued. (Cheque No: 1003) Paid June's PAYG withholding tax of $8,500.00 (Cheque No: 1004) Paid net GST obligation for June, as per the trial balance. (Cheque No: 1005) Paid SUP01 $23,000, the balance owing as at 14 July. (Cheque No: 1006) Paid SUPOZ $16,500, the balance owing as at 1st July. (Cheque No: 1007) Paid SUPO4, 59,800.00 being the previous month's balance, plus $3,850.00 toward current month purchases (Cheque No: 1008) 25th July Pald balances as at 15 July owing to SUP03 (Cheque No: 1009), SUP05 (Cheque No: 1010), SUP06 (Cheque No: 1011) SUP07 (Cheque No: 1012), SUP09 (Cheque No: 1013), SUP10 (Cheque No: 1014), 30th July Net wages paid to employees for the month amounted to $38,000 (Cheque No: 1015). The PAYG withholding tax amounted to $12,000.00 and this amount will be remitted to the Australian Tacation Office on the 23 August. 314 July Paid $4,500.00 (Cheque No: 1016) for employee superannuation on wages earned during July 31 July Drew a cheque (Cheque No: 1017) for $810.00 to reimburse petty cash fund for the following cash expenses: (all amounts are GST Indusive) Subscriptions $210.00 Printing $320.00 Travelling Expenses $180.00 Sundry Office Expense $100.00. Data source - Bank Statement (see next page) Date Transaction Details 18th July Periodic payment for lease of POS equipment $1,100.00 for July (incl. GST). 30th July Bank charges of $80.00 were charged to the account Data source - Notes and Working papers (Month-end Adjustments) Date Transaction Details 31 July Store Fittings are depreciated at 20% per annum, calculated and recorded using the number of days in the month. 31 July Motor Vehicles are depreciated at the rate of 25% of carrying amount per annum (using the reducing balance method of depreciation). Depreciation is calculated as follows - (Carrying Amount 25% - 31+365) 31 July Sales commission earned but not paid as at 31 July, amounted to 54,200. 31 July Prepaid insurance as at 1 July ($9,000.00) represented the balance of the premium paid on the annual policy, which started on 1 May (with 2 months insurance expired as at 30 June). This prepaid insurance is expensed monthly. (irrespective of the number of days in the month). 31st July The prepaid rent at the start of the month was charged to Rent expense during the month. 312 July The company's short term and long term loans are charged interest at the rate of 12% per annum and interest needs to be accrued for July (31 days). 31 July Estimated electricity cost for July is $2,600 which must be accrued. The Bank Statement received from the bank at the end of July is as follows: NABBY Bank Australia Business Trading Account Account Name: Case Study Account No. 012 199 088789 The Manager, Your Name Gifts Pty Ltd Address From: To: 1-July-2020 31-July-2020 Debit Credit $13,200.00 $17,160.00 $1,500.00 $132.00 $5,912.50 $9,000.00 $4,757.50 $6,800.00 34,138.75 $6,500.00 $1,320.00 $8,700.00 $3,795.00 $3,200.00 $8,600.00 Date 1-Jul-20 2-Jul-20 3-Jul-20 3-Jul-20 5-Jul-20 5-Jul-20 6-Jul-20 6-Jul-20 7-Jul-20 7-Jul-20 8-Jul-20 8-Jul-20 8-Jul-20 9-Jul-20 9-Jul-20 11-Jul-20 15-Jul-20 18-Jul-20 16-Jul-20 20-01-20 22-Jul-20 23-Jul-20 23-Jul-20 25 Jul-20 26-Jul-20 27 Jul 20 27-Jul-20 28 Jul 20 28-Jul-20 28 Jul 20 28 Jul 20 28-Jul-20 30 Jul-20 31-Jul-20 30-Jul-20 Particulars Opening Balance Deposit - Cash & Cheques Deposit - Cash & Cheques Chq.# 1001 Chq.e 1002 Deposit - Cash & Cheques Deposit - Cash & Cheques Deposit Cash & Cheques Deposit - Cash & Cheques Deposit - Cash & Cheques Chq.# 1003 Deposit - Cash & Cheques Deposit - Cash & Cheques Deposit - Cash & Cheques Deposit Cash & Cheques Deposit Cash & Cheques Chq. 1004 Periodic Payment POS Equip Lease Deposit - Cash & Cheques Chg. 1005 Ch. 1006 Deposit - Cash & Cheques Chq.100 Chq.# 1008 Deposit Cash & Cheques Ch. 1010 Chq.# 2009 Chg. 1014 Chg. 1012 Ch. 1013 Chg 1011 Deposit Cash & Cheques Bank Charges July Chg 1015 Depost Cash & Cheques $8,500.00 $1,100.00 Balance $45,000.00 $58,200.00 $75,360.00 $73,860.00 $73,728.00 $79,640.50 $88,640.50 $93,398.00 $100,198.00 $104,336.75 $97,836.75 $99,156.75 $107,856.75 $111,651.25 $114,851.75 $123,451.75 $114,951.75 $113,851.75 $129,066.75 $120,266.75 $97,266.75 $99,686.75 $83,186.75 $69,536.75 $87.536.75 586,266.75 $68,366.75 567, 266.75 366,826.75 $61 526.75 $60,866.75 $75,866,75 $75,286.75 $37,786,25 553,426.75 515,215.00 58,800.00 523,000.00 52,420.00 $16,500.00 513,650.00 $18,000.00 $270.00 $18.400.00 $1,100.00 $440.00 $5,300.00 $660.00 $15,000.00 $80.00 $38,000.00 $15,640.00 Transaction not shown on the Bank Statement are either UNPRESENTED CHEQUES or OUTSTANDING DEPOSITS