Excel Accounting 4–Enter Data & Track Current Month & YTD
Learn how to enter accounting data into an accounting system using Excel, generating reports for multiple months
What you will learn:
How to enter transactions into an accounting system using ExcelHow to create reports for the current month and for the year to date
How to enter transactions into a general journal
How to post transactions to a general ledger
How to create a trial balance for the current month and the year to date
How to create subsidiary ledgers for accounts receivable, accounts payable, and inventory
How to create financial statements for one month and for the year to date