Microsoft Office Tutorials and References
In Depth Information
The file financial statements.xlsx contains all the examples in this chapter and can be
found at this book's website.
For all the accounts on the trial balance whose class equals Cash, their total is summed here. The formula is re-
peated for every financial statement classification on both the balance sheet and income statement. For classific-
ations that typically have a credit balance — such as liabilities, equity, and revenue — the formula starts with a
negative sign. The formula for Accounts Payable, cell B18, is
=-SUMIF(Class,A18,Balance)
Search JabSto ::




Custom Search