I need to create a General Journal for weeks 1, 2, and 3 along with t accounts with cash subtotals for each week, and the answer to these two questions: 1.) what is the balance in a.martinez, Capital at the end of week 3? & 2.) What is the sales income balance at the end of weed 3?
week 1
Week 2
Week 3
Chart of accounts to be used:
Inser Project Action Video Cancel Page Layout Femmes Data Help Tell me what you want to do Anul V111 vai DA Wapat Painter General 5.%MA Norm Conditional Format Good Formatting table Font Neutre Det Form Alignment Sinds X D E F G H K M N O P R S U V w ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 Memorandum No. 1 South Atlantic Computers and computer package today INVOICE Pay 32.100.00 today 6/7/10 323 Via Solana Boulevard Siunt parts are follow North Miami Beach, FL 33162 51,70 de June 28, 31,17 July 28, balanced Apt 28 Date: June 2, 20 - To Action Video Productions Involce No.: 1131 2433 Atlantic Ave., Suite 311 Terms: 90 days Surfside, FL 33154 Shipped By: Pick-Up TO: Accounting Clerk FROM: Adrian Martinez DATE: June 2, 20- SUBJECT: Business Investment Quantity have invested personal savings of $8,500 in the business by pening a checking account for Action Video Productions at Florida National Bank. Unit Price Total $ 2,100.00 $ 2,100.00 2 (included) 2,000.00 2,000.00 anielle Sloane has entered the $8,500 cash as the beginning alance in the checkbook. Please record the journal entry in the eneral journal. Item Personal computer package (1.0 GHz Processor, keyboard, monitor, mouse, printer and cables) Hard Disk 40GB Drives Matrix capture card for MPEG2 compression with editing software package Additional color monitor Pair computer speakers AC stabilizer Work table SUBTOTAL 19.00 - 6% Sales Tax TOTAL 1 1 1 300.00 60.00 150.00 175.00 300.00 60.00 150.00 175.00 $ 4,785.00 287.10 $ 5,072.10 10 Week Week we chart of out 2cer Home Page Layout Format Project Action Video Colex Excel Tell me what you want to do Data Review Katherine Wright Xon Copy Format Paint TAA General 2. Wrap at + Mergea Center Normal Conditional Format Good Farming Table 27 $ Nestal ||| K] Dlate at Fort CH Falect Eng X A B D E F G H N O R S T VW X Danny's News Stand 4338 Collins Avenue Surfside, FL 33154 INVOICE Datat June 2, 20- Invece No. 12:50 Coastal Copy Center 8175 Harding Ave Surfside, FL 33151 INVOICE Date: June 3, 20 - Invoice No.: 602 BILL TO: Action Video Productions 2430 Atlantic Ave., Suite 311 Surfside, FL 33154 BILL TO: Action Video Productions 2433 An Ave., Suite 311 Surfside, FL 39154 Write a check today. 6/2/20 - and charyeto Mucellaneous Write a check today, 6/3/2004 DATE DESCRIPTION 2/20 or purchase of 20 different Weekly community newspapers CHARGES CHARGES 20 newspapers, per agreement 6% sales tax TOTAL DUE: $ 20.00 1.20 $ 21.20 DATE DESCRIPTION 6.320 For copying of marketing flyers. 100 8x10 color 1.35 per copy 500 8x10 beoo.07 per copy 6 sales tax TOTAL AMOUNT DUE: $ 135.00 35.00 10.20 $ 120.20 med check 102 for $21.20. - DS Issued check #103. DS Memorandum MIAMI NEWS SERVICE STATEME ACTION VIDEO DDODUCTIONS Weakt We ro D De 21 acer Hom Insert Page Layout Project Action Video Concel Tell me what you want to do Femida Data 1 View Help A As Wrap test AN & A Bad Mergea Center Nigent General $ .. MA Normal Conditional Format Good To The Styr Neut De board Sort Font C. Eng C D E F G H K M o o R S T. U W X ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 Memorandum No. 2 STATEMENT MIAMI NEWS SERVICE 2232 Drexel Drive Miami Beach, FL 33139 BILL TO: Action Video Productions 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 TO: Accounting Clerk FROM: Danielle Sloane DATE: June 4, 20- SUBJECT: Rent Write a check today, 6/4/20 AM CHARGES I issued check 1104 payable to Highland Realtors for $975.00. This covers the rent on the studio for the month of June. DATE DESCRIPTION 6/20 or placement of 1-inch ads in monthly marriage announcement sections of 10 weekly community newspapers (lune issues). Please make the necessary journal entry. TOTAL AMOUNT DUE: $ 450.00 Tsued checb105 for $450.000 Memorandum ACTION VIDEO PRODUCTIONS BA Atlantis Aun Week 1 Week w MA acer Project Action Video Co.xlsx Excel Tell me what you want to de Home Page Layout Formulas Data Pe View Arial VAA General Bad x can DoCopy Format Painter Clipboard & A. Wrap Test Merge Center - Algement $% Normal Conditional Format Good Formning ahe Neutral IntDelete Termal Fant Nube Cell X A B D E G H w R Issued checkalos for $450.00. -DS ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 Memorandum No. 3 RECEIPT Surfside Post Office 3341 Coolidge Avenue Surfside, FL 33154 TO: Accounting clerk FROM: Adrian Martinez DATE: June 5, 20- SUBJECT: Additional Investment DATE: June 5, 20 - I have decided to invest my sports utility vehicle in the business. The current market value is $23, 540.00 Please record this transaction in the general journal. AMOUNT: $28.00 I paid cash for athletic department madings. Please reunburse me and enter in the general journal.- AM Ishund check 106 for $28.00-DS THANK YOU Week w WE chart of accounts o a 1 Project Action Video Coxx Excel Home Page Layout Ferma D Review View Help Tell me what you want to do Piel VAA General Xcut Copy - Format Painter apboard BI A- Wap Test Mega Center Alignment S. Normal Conditional Format Good Farming Table II Font Insert Delete Format Nur Cle X so SH C D F G H M N O P R U V w THANK YOU ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 Surfside, FL 33151 INVOICE Date: June 5, 20 -- Invoice No.: S101 SOLD TO: Nicolas Decilla 1246 Avenida Via Lido Bal Harbor, FL 33139 ACTION VIDEO PRODUCTIONS RECEIPT No. 1 Date: June 5, 20 - DATE DESCRIPTION 6/5/20 - Videography of Decilla/Boles Wedding CHARGES $ 1,950.00 $650.00 Received from: Nicolay Decala Shundred fifty and no/100... Dollars Payable in three equal installments For: Deposit for videography of Decala/Bolex wedding Received by: AM Intro Week 1 Week w chat of accounts Home Page Layout Formulas Duta View Project Action Video Call Tell me what you want to de Help AW 5 cut Copy Format Pater 11 A BLU- - Wapest + Merge Center General $. Nom Candidats Good Formang. Tube Toat Neutral SIE SI Agent N CH B D E F G H M N o P Q R S U V w Y Tropical Video 3554 Valencia Boulevard Fort Lauderdale, FL 33301 INVOICE ACTION VIDEO PRODUCTIONS RECEIPT Write a check today, June 8, for $1,000 AM To Action Video Productions 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 Date: June 8, 20 - Invoice No.: 2105 Terms: Net 60 days Shipped By: For Pick-Up No. 3 Date: June 9, 20 - Received from: slastre Art Gallery $300.00 Three hundred and no/100... Dollars For: Second installment for video shoot of art gallery opening and delivery of unedited digital master le Received by: AM Quantity Item 1 Unit Price $ 2,100.00 250,00 550.00 200.00 50.00 Digital video camera DVD recorder 4-hour battery belt Tripod digital memory card 1 Total $ 2,100.00 250.00 550.00 200.00 N/C $ 3,100.00 186.00 $286.00 2 SUBTOTAL 6% Sales Tax TOTAL w Week 2 werk art of con o Houne Page Layout Formula Project Action Video Control Tell me what you want to de Help Cut Copy Format Painter VAA ca BIU- $.$. Now Condition Formats Good Feming. We Font ||||| Metal N O P R S T U B CD Dade Discount Video 345 East 45th Street Hialeah, FL 33010 V W INVOICE ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 Memorandum No. 5 Action Video Productions 2433 Atlantic Ave, Suite 311 Surfside, FL 33154 Date: une 9, 20 - Involce No. 1602 Terms: Net 60 days Shipped By: For Pick-Up TO: Accounting Clerk FROM: Adrian Martinez DATE: June 9, 20- SUBJECT: Purchase Reimbursement Quantity Item Unit Price Total $ 30.00 $ 300.00 10 Blank DVD's I paid $550.00 for a used wireless microphone set with a check from my personal account. Please write a check payable to me for reimbursement. Ted check 109 5550.000 SUBTOTAL 6% Sales Tax TOTAL $ 300.00 18.00 $ 318.00 Picked up to today Paid with check 100 H week Week 2 wa chart of accounts acer Fee Projection Video Excel Formulas Data Help Ana Home rent acow - Da Caboard Gerard Share - DA Normal Condo Good forming the Merete Anment Font . AI B D K L M N O P R 5 T V w Y 58 57 58 59 co 61 62 63 64 65 ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave, Suite 311 Surfside, FL 33154 INVOICE Date: June 10, 20 - Invoice No.: S103 ACTION VIDEO PRODUCTIONS RECEIPT SOLD TO: Arnold Stein 3252 Orange Blossom Lane Miami Beach, FL 33139 07 68 No. 4 Date: June 10, 20- Received from: Amold Stein $500.00 Foe hundred and no/100- Dollars For: Deposit for video shoot of the Amold Stein Golden Annoverary first of three payments) 70 DATE DESCRIPTION 6/10/20 - Videography of Golden Anniversary CHARGES $ 1,500.00 23 274 5 Payable in three equal installments Received by: AM +7 8 0 w Week 2 w D 4.30 PM acer B Ho Insert Page Layout Formulas Review Hely Tell me what you want to de Katherine AU Xur Cory format Point 11VA A. Wrap Test BIU- General $.$. - Merge Center Norm Conditional Format Good Formatting Table Font D F M N O R s T U V w Y Z M ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 INVOICE Date: June 11, 20 - Invoice No.: 5104 BILLING STATEMENT Florida United Insurance 3131 Nueva Corona Avenue Miami Beach, FL 33140 305-555-2111 SOLD TO: Hallendale High School Athletic Department 442 West 12m Street Fort Lauderdale, FL 33301 BILL TO: Action Video Productions 2233 Atlantic Ave, Suite 311 Surfside, FL 33154 Date: June 11, 20 - Due: Upon Recept CHARGES DATE DESCRIPTION 6/1/20 - Business lisbility coverage for period beginning June 1, 20 - and to ending August 30, 20 B/30/20 DATE DESCRIPTION 6/11/20 - Videography of two home baseball games: 2 $515 CHARGES $ 1,030.00 See attached policy $ 756.00 30 1 32 93 34 05 30 57 AMOUNT DUE: Iskud check 110 for $756. Payable upon delivery of unedited videos 30 Web chart of account acer B Home Page Layout Formulas Data Review Ve Tell me what you wanted 11 Xcut na py Paste Format Painter Cipherd A. Ba Norma Cand am Goed Formatting KI>> Font Neutral Al Nu Sort x fo C D E F H 4 113 114 K N O P Q R s T v w X Y 115 ACTION VIDEO PRODUCTIONS 116 117 RECEIPT ACTION VIDEO PRODUCTIONS RECEIPT 119 No. 6 120 Date: June 12.20 -- 121 122 123 No. 5 Date: June 12, 20 - Received from: Nicolay Decala $650.00 suhundred fifty and no 100.- Dollars For: On account for Decala/Boley wedding Received by: Received from: Cash Sale $450.00 Four hundred filty and no/100............. Dollars For: DVD duplicates of Decala/Boley wedding AM Received by: AM 124 25 126 127 28 29 30 31 32 33 -34 ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 Memorandum No. 6 ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 Memorandum No. 7 30 37 28 39 TO: FROM: TO: Accounting clerk Accounting clerk Adrian Martinez Wer Week 2 We chart of accounts tro . H Fle Home Project Action Video Colabod Formula View Help Xcut Copy som en A General Norm Conditional format Good fomailing Clipboard KILI Tort AL Number H 131 N O R S U v w Y 133 ACTION VIDEO PRODUCTIONS 134 2433 Atlantic Ave., Suite 311 135 Surfside, FL 33154 136 Memorandum No. 6 ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 Memorandum No. 7 131 TO: Accounting clerk FROM: Diane Sloane DATE: June 15, 20 -- SUBJECT: Cash Balance 138 139 140 141 142 143 144 145 145 147 149 149 150 151 152 153 154 155 156 157 TO: Accounting Clerk FROM: Adrian Martinez DATE: June 15, 20- SUBJECT: Employee Wages Danielle Sloane issued checks 111 and 112 to pay the employee wages for the last two-week period. The total amount of the two checks was $750.00 Please make the necessary journal entry recording this expense and use "checks 111 and 112" as your source document reference. The checkbook cash balance is $4,221.60. Please verify this balance with the balance in the general ledger Cash account as of 6/15/20- tre Week Week 2 Week chart of accounts EBP acer WS VEO Project Action Video Cabral Tell me what you want to do O File Page Layout Ford Help Share Insert Xon Copy format Paiste Wapest Ariel V1 VAA BIU Nam Merge Center Condo for Good Forming tee Delete Font Fant man D E F G H K N 0 9 R S T U V w X - INVOICE Islander Audio Systems 3435 Roland Avenue Miami Beach, FL 33139 Miami Daily News 1237 Federal Boulevard Miami Beach, FL 33139 STATEMENT Date: June 16, 20- To: Action Video Productions 2433 Atlantic Ave, Suite 311 Surfside, FL 33154 Date: June 16, 20 - Invoice No.: 7083 Terms: Net 90 days Shipped By: Pick-Up BILL TO: Adion Video Productions 2433 Asantic Ave, Suite 311 Surfside, FL 33154 Witached today, 6/16/20 CHARGES Quantity Item 8 channel sound board CD Player Unit Price $ 325.00 100.00 DATE DESCRIPTION 6/16/20- For advertisement placed in Sunday sports section TOTAL AMOUNT DUE Total $325.00 130.00 $ 455.00 27.30 $ 482.30 1 $174.00 SUBTOTAL 6% Sales Tax TOTAL Tied check for $150.00 > DECETAT ACTIAM VIDEA NOADITIONE Week 1 Week 2 Week ro DOM BI acer B Page Layout Duta Action Vides - Bece Tell me what you do Karine X Cut Copy Format Pan board AN D.A. Whepat lamod T-E- Mere & Co Coated Font Neytral KET 1 Ne Set C D E H M N 0 P U V w Coral Reef Video 6280 Bridger Boulevard Fort Lauderdale, FL 33301 INVOICE ACTION VIDEO PRODUCTIONS RECEIPT No. 7 Date: June 17, 20 -- Received from: Nicolas Decca $650.00 Suhundred fly and no/100- Dollars For: Final payment for edited DVD'y of Decal/Bolex wedding Please write a check today- 6/18 for $44.52 AM To Action Video Products 2433 Ae Ave, S311 SFL 33154 Date: June 17, 20 Involce No.: 222 Received by: AM Quantity 14 Total Unit Price $3.00 Item Duplicate OVD's from digital master With labels reading "Nicolas and Angela Decla Wedding Day June 12, 20 SUBTOTAL 6% Sales Tax TOTAL $42.00 2.52 Tundcheck 114 for 452 DS ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 Memorandum No. 2 wo Week Week acer flame Insert Page Layout Formulas Data Project Action Video Card Tell me what you want to do Arial apy Painter BIU- S.A. General $.% ad Merge Center Algement Fant Normal Conditional Format Good Formatting to Sys 2 o - ||| | be Fiat Select B c D E F G H - M o R S T w ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 Memorandum No. 8 TO: Accounting Clerk FROM: Adrian Martinez DATE: June 18, 20- SUBJECT: Cash Refund ACTION VIDEO PRODUCTIONS RECEIPT No. 8 Date: June 19, 20- Received from: Amold Stein $500.00 Ewe hundred and no/100... Dollars For: Payment on account for Stein Golden Anniversary I received and deposited $46.64 in cash from Dade Discount Video for a returned defective DVD. Please make the necessary general Journal entry. Received by: AM ACTION VIDEO PRODUCTIONS RECEIPT RECEIPT No. 9 Date: June 19. 20.- Surfside Post Omce 111 Clan intro Week Werk Week chart of accounts BE 0 de acer Home Insert Page Layout Formulas Project Action Video Co - Esce Data Review Tell me what you want to do Arial VI Van Wapest Format Painter B TU- General DA * Menge a Center - B oard $.$. Normal Constions format Good Formatting Table Fane WE Neutral LI ut Delete for f Celle B G ACTION VIDEO PRODUCTIONS ACTION VIDEO CIUN J K N O KECEIPT Q R S KECEIPT V Surfside Post Office 3341 Coolidge Avenue Surfside, FL 33154 No. 9 Date: June 19.20 -- Received from: Nicolas Decala $350.00 Three hundred fifty and no/100- Dollars For: $350,00 (14 @ $25) DVD duplicates of Decala wedding digital master Received by: AM DATE: June 19, 20 - AMOUNT: $24.60 Paid cash for Decilla/Boley wedding DVD mading, Please reunburse me and enter in general journal. - AM Imed check 115 for $24.60 DS ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 Memorandum No. 9 THANK YOU TO: Accounting clerk FROM: Adrian Martinez DATE: June 19, 20- Week Week 2 Week chart of account ACTION VIDEO PRODUCTIONS Intro Page Layout Fem Review Project Action Video Co. - Excel Tell me what you want to do Ariel 11 VA SA mer BIU- 0 + Merge Center General 5 - 2 Font Normal Conditional Good Formatting 99 X Art Neutral KIIKI PC D G ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 N 0 Memorandum No. 9 V w THANK YOU Y TO: Accounting clerk FROM: Adrian Martinez DATE: June 19, 20- SUBJECT: SUV maintenance reimbursement I paid $42.50 for an oil change for the sports utility vehicle. Please make a check payable to me for reimbursement. ACTION VIDEO PRODUCTIONS RECEIPT No. 10 Date: fune 19, 20- Received from: Cash Saley Two hundred and no/100- $200.00 Dollars Issued check 116 for $42.50. For: Editing 5-minute marketing video of the glastre Art Gallery opening cash receaved from famal Nkomo Copripir 2017 MEGTE Received by: AM ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 CEI EA week We Week Chart of account Memorandum No. 10 acer Project Action Video Co.xlsx - Excel Insert Page Layout Formulas Data Review View Help Tell me what you want to do Arial General 2 2 Wrap Text 3. Merge & Center. BIU A $. % Conditional Format as Formatting Table nter Font Alignment Number D E F G H K M N o ACTION VIDEO PRODUCTIONS 2433 Atlantic Ave., Suite 311 Surfside, FL 33154 Memorandum No. 10 TO: Accounting Clerk FROM: Danielle Sloan DATE: June 22, 20- SUBJECT: Cash Balance The checkbook cash balance is $5,682.62. Please verify this balance with the balance in the general ledger Cash account as of 6/22/20 -- Intro Week Week 2 Week 3 chart of accounts 1 acer 10 File Home Page Layout Data Project Action Vides Co. Gace Tell me what you want to do View Help Anal Xon Copy format ante Clascara BIU- A $. %. 121 Normal Condition forms Good Formwing table OM SIEI Agent Neutral AL X Cal A B 4 ACTION VIDEO PRODUCTIONS CHART OF ACCOUNTS N o P Q R S T U REVENUE 410 Sales Income 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 ASSETS 110 120 122 124 126 128 130 135 140 141 142 143 144 145 Cash Accounts Receivable-Correa Accounts Receivable-DeCilla Accounts Receivable-Glastre Art Gallery Accounts Receivable-Hallendale High School Accounts Receivable-Stein Videography Supplies Prepaid Insurance Computer Equipment Accumulated Depreciation-Computer Equipment Equipment Accumulated Depreciation Equipment Vehicle Accumulated Depreciation-Vehicle EXPENSES 510 Advertising Expense 515 Insurance Expense 520 Maintenance Expense 525 Miscellaneous Expense 530 Rent Expense 535 Videography Supplies Expense 540 Utilities Expense 545 Vehicle Expense 550 Wages Expense 555 Depreciation Expense-Computer Equipment 560 Depreciation Expense-Equipment 565 Depreciation Expense-Vehicle 25 26 27 28 LIABILITIES 210 Accounts Payable-Islander Audio Systems 212 Accounts Payable-South Atlantic Computer Accounts Payable-Tropical Video 214 30 31 OWNER'S EQUITY 310 Adrian Martinez, Capital 26 Adela Intro Week Week 2 Week chart of account 13 14 15 16 17 18 19 20 B IZO 128 130 135 140 141 142 143 144 145 Accounts Receivable-nanenoare High Schour J K L Accounts Receivable Stein Videography Supplies Prepaid Insurance Computer Equipment Accumulated Depreciation-Computer Equipment Equipment Accumulated Depreciation Equipment Vehicle Accumulated Depreciation-Vehicle 21 MIN EXPENSES 510 Ad 515 Ins 520 Ma 525 Mis 530 Re 535 Vid 540 Util 545 Ver 550 Wa 555 Dep 560 Dep 565 22 23 24 25 26 27 28 9 IIIIII LIABILITIES 210 Accounts Payable_Islander Audio Systems 212 Accounts PayableSouth Atlantic Computer 214 Accounts Payable - Tropical Video Der 1 OWNER'S EQUITY 310 Adrian Martinez, Capital 315 Adrian Martinez, Drawing 399 Income Summary 2 3 Intro Week 1 Week 2 Week 3 chart of accounts
