i would like to get the 3rd task done which is post relevant information from the journals to the subsidary accounts receivable and aubsidiary accounts payable ledgers in the below format
i hope the numbers are visible nw..3rd task please..
Accounts Receivable Subsidiary Ledger CREDIT Details Amt. $ Date Details Amt.S LE Wison Accounts Payable Subsidiary Ledger CREDIT Details Amt. $ Date Details Amt.$ Reconciliation of subsidiary Accounts Receivable Ledger with General Ledger Control Account for Accounts Receivable Account name Balance at moath end Balance at month end as per Accounts Reccivable Control Account in the General Ledger Reconciliation of subsidiary Accounts Payable Ledger with General Ledger Control Account for Accounts payable Balance at month end Balance at month end as per Accounts Payable Contrel Account in the General Ledger You have been provided with the completed specialised journals and general journal for a retailer, Bethany Pty Ltd (refer next two pages) 1. Use the completed journals provided and post to the General Ledger for the month of November 2. Prepare a Trial Balance as at 30 November. 3. Then also post the relevant information from the journals to the subsidiary accounts receivable and subsidiary accounts payable ledgers (you may use the templates provided for the General Ledger and subsidiary ledgers if you wish) SALES Journal for Bethany Pty Ltd Date Invoice Account details Fosting Accounts Sales GST Pavable Cost of Sales Receivable (Credit (R(Credit) (L+) Dr Cost of Sales Cr Inventory (Debit) (A +) Nov 2 151 Nov 9 152 Nov 15 153 Nov 18 154 Nov 29 155 2 350 6 250 740 1 825 1 800 L. Wilsorn Clarence Associates Waters L Wilson Clarence Associates 2 136 5682 673 659 1636 214 568 67 166 164 1 390 3 300 410 970 1 000 1 390 3 300 410 970 1 000 30 totals 12 965 11 786 1 179 7 070 7 070 CASH RECEIPTS Journal for Bethany Pty Ltd Date Details Cash at Sales GST Accounts Sales GST Other Accounts Cost of Inventory Bank Discounts Clearing Receivable (R+ Payable Adjust for GST a(A(Credit) on Sales Sales Aect name Ameunt S (Debit) (Credit) (Debit) (Debit) longer payable due te discount) (Credit) (Credit) (Debit) Nov 4 Cash sale 3 100 3 410 120 2 303 6 125 80 1 825 310 1 820 1 820 interest 120 12 19 Clavnce Assac 24 Sold supplies 30 2 350 6 250 114 7 supplies 73 1 825 30 total 13 863 157 10 425 3 100 317 193 1820 1 820 PURCHASES Journal for Bethany Pty Ltd Date Account details terms oting Accounts Payable Inventory Supplies Other Accounts (Debit) GST Input (Credit) (L+) (Debit) (A +) (Debit) (A+) Acct name Amount Credit (Debit) (A+) 537 Nov Deloraine Plaza 3/10n60 5 900 5 363 13 20 22 28 Horton Supplies Eom Jasmine Sales Net 30 Deloraine Plaza 3/10n60 Horton 680 2 150 618 62 195 70 1 955 Furniture 382 30 totals 9 925 7 700 618 705 902 Cash PAYMENTS Journal for Bethany Pty Ltod Date Chq # Details of GST Input Accounts Payable Other Accounts Inventory adjustment Cash at Bank Credit L- or doc ID payment Account Name for discount received AmountS Inventory GST adjust (A-) (Debit) (Debit) (Credit) (Credit) (Credit) Nov 5473 Furniture 0474 Iveory 13 475 Deloraine Plaza 22 476 Insurance 25 477 Electricity 30 478 Horton Supplies 0 49 Salary expense 98 Furniture 982 1 080 770 5 723 1 345 380 680 1 100 Inventory 700 5 900 161 122 35 Insurance 1 223 Electricity 345 Salary exp 1 100 4 350 30 totals 325 6 580 161 11 078 General journal over General Journal for Bethany Pty Ltd Date Details Nov 17 Sales returns and allowances Debit Credit 673 67 GST Payable Accounts receivable Waters 740 (Waters returned goods to us) 410 Cost of Sales (reverse cost of sale of returned goods) 410 Nov 29 Accounts Payable Horton 420 GST 38 382 (returned damaged goods to supplier)
