Excel Accounting 3 – Enter First Month of Transactions

Excel Accounting 3 – Enter First Month of Transactions

Learn how to enter transactions, & their impact on general ledger, subsidiary ledgers, trial balance, & financial stmts



Sub Category

  • Accounting & Bookkeeping

{inAds}

Objectives

  • How to record financial transactions into an accounting system using an Excel worksheet
  • How to record the impact of each financial transaction on the general ledger, subsidiary ledgers, trial balance, & financial statements
  • How to enter financial transactions related to the owner investing in the company and the business taking out a loan
  • How to enter transactions related to the purchase of inventory and investing in short term investments
  • How to enter transactions related to the selling of inventory
  • How to enter transactions related to the receipt of payments from costumers
  • How and why to use the undeposited funds accounts often seen in accounting software like QuickBooks
  • How to enter transactions related to writing checks for common expenses like utilities and phone
  • How to enter transactions related to paying employees including withholdings and employer taxes
  • How to create month end financial statements


Pre Requisites

  1. None-If you do not have access to Excel you may use Google Sheets


FAQ

  • Q. How long do I have access to the course materials?
    • A. You can view and review the lecture materials indefinitely, like an on-demand channel.
  • Q. Can I take my courses with me wherever I go?
    • A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!



{inAds}

Coupon Code(s)

Previous Post Next Post