Example:
=SUMIFS(Journal!C:C, Journal!B:B, A2) (A2 = Account Name) Pull ending balances from Ledger. Verify: Total Debits = Total Credits . Step 5: Income Statement Use SUMIFS on Trial Balance where Type = Income or Expense. free download accounting software in excel full version
| Code | Name | Type | Normal Balance | |------|------|------|----------------| | 1000 | Cash | Asset | Debit | | 2000 | Accounts Payable | Liability | Credit | | 3000 | Owner's Equity | Equity | Credit | | 4000 | Sales Revenue | Income | Credit | | 5000 | Rent Expense | Expense | Debit | Columns: Date , Account , Debit , Credit , Description Example: =SUMIFS(Journal