Excel Accounting 3 – Enter First Month of Transactions
Learn how to enter transactions, & their impact on general ledger, subsidiary ledgers, trial balance, & financial stmtsWhat you'll learn
- 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