Accounting System on Excel - journal Entries to Financial Statement - for small Business

Описание: If you use Microsoft 365
I recommend to watch this series
   • Part 1 - The primary and index Worksheet -...  

A lot of people are looking for an accounting system for a small business on Excel. And many ask: How can the journal entries be written and posted to the ledger?
How can the trial balance and financial statements be prepared?
Should I use formulas, or macros, or pivot tables?
In this lesson we will answer all of these questions.
We will prepare a small accounting system, without using macros.
This system is for a small service company, as well as you can use it for commercial companies, But without inventory control.
we will define the chart of accounts and write journal entries in the journal with an example, and create a sheet for general ledger, then will get the account balances to use them later in the trail balance and financial statements.

00:00 Intro
00:54 The chart of accounts
Conditional Formatting
Freeze panes
04:14 Journal Entries
Format Painter
Data Validation
COUNTA Function
INDIRECT Function
Use a Name in Data Validation
MAX and MIN Functions
SUM and SUMIF Functions
15:12 Assumptions Sheet
15:50 Trail Balance
Center Across Selection
IF Function
Split Formulas
Nested IF
Use Excel Camera
Set Print Area
22:04 General Ledger or Statement of Account
INDEX and MATCH Functions
ROW and COUNTIFS Functions
Office Clipboard
IFERROR Function
SUMIFS Function
TEXT Function
Combine Texts with Numbers
35:09 Retained Earnings Statement
VLOOKUP Function
SUMIF Function
39:19 Income Statement
Pivot Table
41:53 Balance Sheet
Hyper Links
48:09 Video end

Journal Entries Example
   • Accounting cycle - Journal Entries, Postin...  

Income Statement
   • Income Statement and Retained Earnings Sta...  

Balance Sheet
   • Balance Sheet - With Examples - Intermedia...  


Only members can request files

   / @amdstt