3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE-HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y SEE EXAMPLE A - POST ENTRY DATE Normal 2 De Good Z Styles Normal Neutral B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment JK L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T Balance Number Balance AP Subsidiary Ledger Schedules U V W X Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment K L M N O PQR S Credit ab Wrap Text Merge & Center Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number T U V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z Styles Normal Neutral Bad Calculation B - POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri | A Á BIU = - * - A. A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = = = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE-HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y Normal 2 Good De Z Styles Normal Neutral SEE EXAMPLE A - POST ENTRY DATE B - POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment J K L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T Balance Number Balance AP Subsidiary Ledger Schedules U V W X Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment Credit ab Wrap Text KL MN O PQR S Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Merge & Center 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number T U V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z Styles Normal Neutral Bad Calculation B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri | A Á BIU = - * - A- A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = = = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE-HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y SEE EXAMPLE A - POST ENTRY DATE Normal 2 Good De Z Styles Normal Neutral B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D - POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment J K L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T Balance Number Balance AP Subsidiary Ledger Schedules U V W X Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment K L M N O PQR S Credit ab Wrap Text Merge & Center Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number T U V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z Styles Normal Neutral Bad Calculation B - POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri A Á BIU = - * - A- A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = = = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE-HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y SEE EXAMPLE A - POST ENTRY DATE Normal 2 De Good Z Styles Normal Neutral B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment J K L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T Balance Number Balance AP Subsidiary Ledger Schedules U V W X Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment K L M N O PQR S Credit ab Wrap Text Merge & Center Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number T U V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z D - POST DEBIT OR CREDIT p Styles Normal Neutral B - POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE Bad Calculation E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri A Á BIU = - * - A- A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = = = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE-HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y SEE EXAMPLE A - POST ENTRY DATE Normal 2 Good De Z Styles Normal Neutral B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D - POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment J K L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T UV W X Balance Number Balance AP Subsidiary Ledger Schedules Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment K L M N O PQR S Credit ab Wrap Text Merge & Center Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number T U V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z Styles Normal Neutral Bad Calculation B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri | A Á BIU = - * - A- A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = 3 = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE-HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y SEE EXAMPLE A - POST ENTRY DATE Normal 2 De Good Z Styles Normal Neutral B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment J K L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T UV W X Balance Number Balance AP Subsidiary Ledger Schedules Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment K L M N O PQR S Credit ab Wrap Text Merge & Center Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number TU V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z Styles Normal Neutral Bad Calculation B - POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri A Á BIU = - * - A- A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = = = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE-HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y SEE EXAMPLE A - POST ENTRY DATE Normal 2 De Good Z Styles Normal Neutral B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment J K L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T Balance Number Balance AP Subsidiary Ledger Schedules U V W X Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment K L M N O PQR S Credit ab Wrap Text Merge & Center Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number T U V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z Styles Normal Neutral Bad Calculation B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri A Á BIU = - * - A- A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = = = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y SEE EXAMPLE A - POST ENTRY DATE Normal 2 De Good Z Styles Normal Neutral B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment J K L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T Balance Number Balance AP Subsidiary Ledger Schedules U V W X Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment K L M N O PQR S Credit ab Wrap Text Merge & Center Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number T U V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z Styles Normal Neutral Bad Calculation B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri A Á BIU = - «- A- A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = = = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE-HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y SEE EXAMPLE A - POST ENTRY DATE Normal 2 De Good Z Styles Normal Neutral B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment JK L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T Balance Number Balance AP Subsidiary Ledger Schedules U V W X Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment K L M N O PQR S Credit ab Wrap Text Merge & Center Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number T U V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z Styles Normal Neutral Bad Calculation B - POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri | A Á BIU = - * - A. A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = = = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE-HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y Normal 2 Good De Z Styles Normal Neutral SEE EXAMPLE A - POST ENTRY DATE B - POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment J K L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T Balance Number Balance AP Subsidiary Ledger Schedules U V W X Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment Credit ab Wrap Text KL MN O PQR S Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Merge & Center 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number T U V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z Styles Normal Neutral Bad Calculation B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri | A Á BIU = - * - A- A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = = = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE-HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y SEE EXAMPLE A - POST ENTRY DATE Normal 2 Good De Z Styles Normal Neutral B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D - POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment J K L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T Balance Number Balance AP Subsidiary Ledger Schedules U V W X Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment K L M N O PQR S Credit ab Wrap Text Merge & Center Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number T U V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z Styles Normal Neutral Bad Calculation B - POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri A Á BIU = - * - A- A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = = = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE-HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y SEE EXAMPLE A - POST ENTRY DATE Normal 2 De Good Z Styles Normal Neutral B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment J K L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T Balance Number Balance AP Subsidiary Ledger Schedules U V W X Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment K L M N O PQR S Credit ab Wrap Text Merge & Center Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number T U V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z D - POST DEBIT OR CREDIT p Styles Normal Neutral B - POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE Bad Calculation E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri A Á BIU = - * - A- A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = = = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE-HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y SEE EXAMPLE A - POST ENTRY DATE Normal 2 Good De Z Styles Normal Neutral B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D - POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment J K L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T UV W X Balance Number Balance AP Subsidiary Ledger Schedules Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment K L M N O PQR S Credit ab Wrap Text Merge & Center Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number T U V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z Styles Normal Neutral Bad Calculation B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri | A Á BIU = - * - A- A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = 3 = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE-HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y SEE EXAMPLE A - POST ENTRY DATE Normal 2 De Good Z Styles Normal Neutral B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment J K L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T UV W X Balance Number Balance AP Subsidiary Ledger Schedules Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment K L M N O PQR S Credit ab Wrap Text Merge & Center Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number TU V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z Styles Normal Neutral Bad Calculation B - POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri A Á BIU = - * - A- A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = = = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE-HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y SEE EXAMPLE A - POST ENTRY DATE Normal 2 De Good Z Styles Normal Neutral B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment J K L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T Balance Number Balance AP Subsidiary Ledger Schedules U V W X Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment K L M N O PQR S Credit ab Wrap Text Merge & Center Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number T U V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z Styles Normal Neutral Bad Calculation B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri A Á BIU = - * - A- A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = = = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good 3. 4 5 6 SOME COMPANY, INC. Jan Transactions - Reported using Gross Method for Purchases & Sales (w/o discounts like you will use in Snap2IT Acctg) 8 Some Company Inc. purchased $2,000 in inventory from Bottle Inc. on account. 7 8 9 10 11 12 13 14 15 16 10 Sold $2,000 of inventory to ABC Company for $4,000 terms 2/10, N30. 15 Made a partial payment to Bottle Inc. for $1,500. 20 Sold $1,000 of inventory to JKL Company for $2,000 terms 2/10, N30. 20 Received full payment for Jan 10 sale to ABC less discount. 21 JKL Company returned $200 of merchandise for a credit of $400. 25 Purchased $500 of supplies on credit Jarhead Inc. 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 INSTRUCTIONS Using the transactions above, shown in the journal to the right, complete the following: 1. Refer to the General Journal (shown here on the right-hand side of this worksheet) Notice we are using the Periodic Inventory system. Sales & Purchases are reported using GROSS METHOD so all purchases and sales are reported before discounts. Post transactions as shown - DO NOT CHANGE THEM THE FIRST TRANSACTION HAS BEEN POSTED AS AN EXAMPLE HIGHLIGHTED IN YELLOW/RED YOU WILL ONLY BE POSTING ENTRIES TO CONTROL ACCOUNTS (A/P & A/R) AND TO SUBSIDIARY ACCOUNTS 2. Post the appropriate entries to the accounts payable control ledger (use the individual transactions) and to the vendor subsidiary ledger. Note, use the Accounts Payable subsidiary ledgers provided for Bottle Inc. and Jarhead, Inc. 34 35- 36 SEE EXAMPLE HIGHLIGHTED IN YELLOW/RED IN G/L CONTROL ACCTS & A P SUBSIDIARY LEDGER 3. Post the appropriate entries to the accounts receivable control ledger (use the individual transactions) and to the customer subsidiary ledger. Note, use the Accounts Receivable subsidiary ledgers provided for ABC Company and JKL Company. 4. Prepare a Schedule for both the Accounts Receivable and the Accounts Payable Subsidiary Ledger Accounts to prove that the balances in these subsidiary accounts tie to the total of the General Ledger Control Accounts. Ready Transactions Accessibility investigate General Ledger Control Accts AR Subsidiary Ledger AP Subsidiary Ledger DATE 8-Jan Purchases 10 Accounts Payable, Bottle, Inc. Purchased inventory on account Accounts Receivable, ABC Company Sales Sold inventory on account Accounts Payable, Bottle Inc. Cash Partial Payment on Account 20 Accounts Receivable, JKL Company Sales 15 20 21 25 Schedules GENERAL JOURNAL ACCOUNT TITLE Sold inventory on account Cash Sales Discount + Accounts Receivable, ABC Company Received Payment less discount Sales Returns & Allowances Accounts Receivable, JKL Company Sales Retumed by JKL Company Supplies Accounts Payable, Jarhead, Inc. Purchased supplies on account POST REF. PAGE 1 1 DEBIT 2,000.00 4,000.00 GENERAL 1,500.00 2,000.00 3,920,00 80.00 400.00 500.00 CREDIT 2,000,00 2 4,000.00 1,500.00 2,000.00 4,000.00 400.00 500.00 File Home Insert Page Layout Formulas Data Review X Cut [Copy Z4 2 3 Paste 4 LO AutoSave Off= Subsidiary exercise template Saved to this PC 6 7 8 9 10 12 13 14 15 A B 16 17 18 Clipboard Date 19 20 21 22 Jan 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Date 38 39 40 41 Format Painter 42 43 A Ready Arial BIU :X ✓ fx C Explanation 51°F Mostly clear Font Explanation 8 Purchase from Bottle Inc. ACCOUNTS RECEIVABLE Post Ref. DE 10 Α' Α΄ 3 3 О. А ACCOUNTS PAYABLE Post Ref. 121 Debit * View FGH 1 Debit == J Help EE Alignment KLMN Credit Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate Wrap Text Merge & Center 00 PQR S Dr. Dr. O Search AP Subsidiary Ledger General Q Search $ % 9 500 00 T ACCOUNT NO. 1020 Balance Number ACCOUNT NO. 2000 Balance U V W X Cr. Schedules E Cr. 2 0 0 0 00 + Conditional Format as Formatting Table - Y SEE EXAMPLE A - POST ENTRY DATE Normal 2 De Good Z Styles Normal Neutral B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT Bad Calculation AA 19 C2 1 2 3 4 5 6 7 9 12 13 yenm St A 15 16 17 18 19 20 21 22 Date 23 24 25 26 27 28 29 30 31 32 33 Clipboard B 34 35 36 37 38 39 Format Painter Date 40 41 42 V Ready : x ✓ fx C ABC COMPANY Explanation Font Explanation JKL COMPANY Accessibility: Investigate D Post Ref. Post Ref. E F G H I Debit Debit Transactions General Ledger Control Accts Alignment J K L M N Credit Credit AR Subsidiary Ledger O Dr. Dr. S P Q R S T Balance Number Balance AP Subsidiary Ledger Schedules U V W X Cr. Cr. Formatting Table- Z AA File Z12 1 2 3 Paste AutoSave 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B 18 19 35 20 21 22 Date 23 24 25 26 27 28 29 Explanation Jan 8 Purchased Inventory 30 31 32 33 m m m 3 Home Insert Page Layout X Cut [Copy 34 35 56 36 Clipboard 37 38 39 40 41 42 Format Painter Off 89- Date < Ready Arial B B I U = Subsidiary exercise template Saved to this PC Explanation Formulas Data Review View V BOTTLE INC. Font JARHEAD INC. M D 10 C Post Ref. 11 Post Ref. Bak A A A NAMM 17 FGH 1 Debit . Debit J Help With Alignment K L M N O PQR S Credit ab Wrap Text Merge & Center Credit Transactions General Ledger Control Accts AR Subsidiary Ledger Accessibility: Investigate 00 Dr. Dr. General AP Subsidiary Ledger $ % 900 20 Balance Balance Search Number T U V W X Cr. 2 0 0 0 Cr. Schedules E + 00 3 Conditional Format as Formatting Table - Y Normal 2 Good SEE EXAMPLE A - POST ENTRY DATE Z Styles Normal Neutral Bad Calculation B-POST EXPLANATION OF TRANSACTION C-POST POSTING REFERENCE D-POST DEBIT OR CREDIT E-POST BALANCE: NOTE BALANCE IS RUNNING BALANCE NOTE: BALANCE IS DEBIT OR CREDIT, NOT BOTH TIP: BALANCE SHOULD BE ON "NORMAL BALANCE" SIDE A/P NORMAL BALANCE IS CREDIT + AA File 114 1 2 Paste 3 4 5 6 7 A 8 9 10 11 12 13 quatic 14 15 16 17 18 19 20 21 22 23 Home Insert Page Layout X Cut [Copy 24 25 26 Clipboard 27 28 ABC Company JKL Company 29 30 31 32 33 Format Painter Total 34 35 V 36 F B :X ✓ fx Calibri A Á BIU = - «- A- A Font SOME COMPANY, INC SCHEDULE OF ACCOUNTS RECEIVABLE JAN 30, XXXX C Review D view Help Total = = = = = = = = @ Bottle Inc. Jarhead Inc. E a Wrap Text Alignment Merge & Center F SOME COMPANY, INC SCHEDULE OF ACCOUNTS PAYABLE JAN 30, XXXX G General $ - % 9 , Number H Score F Conditional Format as Formatting Table - Graded Area 30 Recorded Numbers Instructor to Complete Shaded Area Grading Rubrics 100% out of 100% Par less numbers incorrect (highlight in yellow) 30 numbers correct 25 x Available Points 25 Total Points out of 25 Total Points 100% Total% Normal 2 Good
Expert Answer:
Answer rating: 100% (QA)
Solution Given Data Job Label JD Immediate Predecessors Time neededdays Earliest Date to start at A select Staff members 12 15Mar20 B Survey 9 16Mar20 ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Which categories make up the contingent workforce?
-
The following table shows the staffing requirements and the associated costs (in thousand dollars) for a local firm. The firm requires workers to work for three consecutive seasons and to take the...
-
How can Ben provide access control for his customers without having to provision user IDs before they connect while also gathering useful contact information for his business purposes?
-
The following data show the curb weight, horsepower, and -mile speed for 16 popular sports and GT cars. Suppose that the price of each sports and GT car is also available. The complete data set is as...
-
Answer the following questions. 1. A company has an inventory of 1,300 assorted parts for a line of missiles that has been discontinued. The inventory cost is $71,000. The parts can be either (a)...
-
Number of coins in a jar Determine whether the quantitative variable is discrete or continuous.
-
Correctly apply the rules for the order of operations to accurately compute the following: \(10-3 \times 5^{3} / 15+56 / 4\)
-
Precision Castparts, a manufacturer of processed engine parts in the automotive and airline industries, borrows $41 million cash on October 1, 2015, to provide working capital for anticipated...
-
Centana Inc. would like to assess the country risk of a foreign country. Centana has identified various political and financial risk factors, as shown below. Political Risk Factor Assigned Rating...
-
The Ploughman family owns and operates a 640-acre farm that has been in the family for several generations. The Ploughmans always have had to work hard to make a decent living from the farm and have...
-
You observe a Zero coupon 6month Treasury-Bill rate of 2.5% and a 1-year zero coupon rate of 3.5%. You also observe a government bond with 1yr maturity, Face Value = $100 and a coupon rate of 3%,...
-
Compare this stable pattern with the ones that are designed by using a traditional method.
-
What is meant by the term concentration ratio?
-
Which tool is most useful in Pareto analysis, a scatter plot or a histogram?
-
Is fairness pattern stable and application specific?
-
What is a domain model?
-
Additional Activities DIRECTIONS: On a separate sheet of paper, write you answer to the question below. Suppose you will be joining an annual school fair and you are given the chance to sell any...
-
a. Show that the expansion of q(x) in ascending powers of x can be approximated to 10 2x + Bx 2 + Cx 3 where B and C are constants to be found. b. Find the percentage error made in using the series...
-
Jason and Mary are married taxpayers in 2012. They are both under age 65 and in good health. For this tax year, they have a total of $41,000 in wages and $500 in interest income. Jason and Mary's...
-
On July 1, 2012, Ted, age 73 and single, sells his personal residence of the last 30 years for $365,000. Ted's basis in his residence is $35,000. The expenses associated with the sale of his home...
-
Matthew borrows $250,000 to invest in bonds. During 2012, his interest on the loan is $30,000. Matthew's interest income from the bonds is $10,000. This is Matthew's only investment income. a....
-
The following information is available for the Dixon Company for the second quarter of 2005. Required: Prepare a cash budget for the second quarter of 2005. Apr May Jun Budgeted Receipts from Credit...
-
The following information is available for the Art Kriner Company for the first quarter of 2005: Beginning cash balance for January 2005 is expected to be \($1,500\). The company intends to maintain...
-
The following information is available for November 2005. Beginning cash balance for November is expected to be \($5,800\). The company intends to maintain a cash balance of at least \($5,000\). The...
Study smarter with the SolutionInn App