This tutorial demonstrates how to take a basic balance sheet, populate T-accounts with those balances, apply several transactions and calculate the new balances using the T-accounts. Then a trial balance is created and from that a new balance sheet.
You may download the blank file and try any of the entries from the tutorial yourself to see how all this works from this link: www.filesanywhere.com/fs/v.aspx?v=8b706a8e606272b3a1aa
This tutorial shows how to create journal entries for business transactions and then how to post them to a ledger.
You can access the excel file used in this tutorial at this link: www.filesanywhere.com/fs/v.aspx?v=8b71678b5e6271b1ae9d
This tutorial demonstrates how to complete a worksheet including the adjusting entries, income statement and balance sheet columns.
This tutorial shows how to create a formal income statement from a worksheet.
If you'd like a copy of the excel file for this tutorial, you can access it at this link: www.filesanywhere.com/fs/v.aspx?v=8b70658d615e6fbdab6a
This tutorial shows how to make a Balance Sheet from a work sheet.
This tutorial demonstrates how to enter adjusting and closing entries in a general journal for a periodic business.
This tutorial shows how to make adjustments for late invoices, accruals such as unearned revenue, interest expense and salaries & wages. This is the first part of a two part tutorial on adjustments.
This tutorial shows how to journalize adjustments for bad debts & allowance for doubtful accounts and amortization expense. This is the second tutorial in a two part series on adjustments.
This tutorial shows how to create simple arithmetic formulas in Microsoft Excel.