Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Accounting 4- Enter Data & Track Current Month & YTD
Month 2-Enter Loan Transaction, Create Amortization Table, & Investment
8005 Format Worksheet for New Month (17:39)
8020 Make Amortization Table (11:41)
8022 Make Loan Payments (17:24)
8040 Short Term Investment Sales & Gains (11:28)
Month 2-Enter Sale, Cash Received at Same Time & Bill for Inventory
8120 Sales Receipt & Deposit (28:28)
8122 Record Receipt of Inventory with Bill Linked to P.O. (10:24)
Month 2-Invoices for Service Sales & Advanced Customer Deposit
8130 Populate Invoice Using Billable Item That was Created From P.O. (15:21)
8140 Advanced Customer Payment or Unearned Revenue Method 1 (20:48)
8160 Apply Customer Deposit (Credit) to Invoice (17:19)
8200 Advanced Customer Payment or Unearned Revenue Method 2 (24:22)
Months 2-Transaction for Billable Time
8320 Bill for Hourly Services of Staff Set up Items & Enter Billable Time (8:57)
8322 Create Invoices Using Billable Time (22:08)
Month 2-Rental Income Transaction & Advanced Customer Deposit
8342 Rental Income Customer Deposit (14:25)
8344 Rental Income Estimate & Invoice (20:28)
Month 2-Purchase & Finance Equipment
8360 Purchase & Finance Equipment (10:39)
8362 Subaccounts Categories For Fixed Assets (16:57)
Month 2-Enter & Pay Month End Bills & Pay Sales Tax
8365 Bills - Enter, Sort, & Pay (27:00)
8370 Pay Sales Tax (9:20)
Month 2-Enter Payroll & Pay Payroll Tax for Prior Period
8380 Enter Payroll For Second Month Part 1 (16:25)
8381 Enter Payroll For Second Month Part 2 (20:28)
8385 Pay Payroll Taxes (15:08)
Month 2 Financial Statements
8420 Create Reports After Second Month of Data Input YTD (21:57)
8421 Create Reports After Second Month of Data Month of February Only (19:51)
8005 Format Worksheet for New Month
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock