Creating Custom Financial Statements with Excel (FSMC)

Customer Rating
Field of Study
Computer Software & Applications
Level
Intermediate
Credits
2
Qualifies For
CPE



Price:  $ 19.99

Most general ledger packages do a great job of aggregating journal entries and creating a trial balance. Where many fall short is in the presentation of financial information in the form of financial statements. Many have default financial statements that conform to the presentation needs of a manufacturing entity or a wholesaler, but are not very flexible beyond that. If they do provide for customizable financial statement formats, it can be a difficult and time consuming process. The good news is that using Excel to prepare custom financial statements from a trial balance is a relatively easy and straightforward process. If the general ledger account numbers already have financial statement mapping embedded in them, the process is a few simple steps. If the general ledger account numbers do not indicate the appropriate financial statement line item, there is one intermediate step that provides a map to the financial statement from the trial balance. Using the techniques in this course, you can create custom financial statements in any form or format that is necessary using Excel.

Additional information

year

2019, 2022

version

01

Credits

2

Company Code

Self Study

Format

On Demand

Yellow Book Approved

0

CFP Approved

0

IRS Approved

0

CTEC Approved

0

Field of Study Credits

Computer Software & Applications (2)

Field of Study Department

Computer Software & Applications

Course Version

2022-01

CPE Approved

1

Pre-requistes:

None

Knowledge Level:

Intermediate

Major Topics:

  • Overview of text functions used to capture general ledger account number
  • SUMIF function
  • VLOOKUP function
  • INDIRECT function 

Learning Objectives:

  • Define certain text functions and use them to capture a portion of a general ledger account number
  • Recognize the uses of the SUMIF function
  • Define and use the VLOOKUP function
  • Associate the INDIRECT function with referencing Excel worksheets

Designed For:

All CPAs

Customer Reviews

Based on 3 reviews
100%
(3)
0%
(0)
0%
(0)
0%
(0)
0%
(0)
P
Pamela N. (Wilmington, US)
Useful course

This course was very helpful and I have already found myself using what I learned to prepare, sort, and filter tables in Excel.

J
Jennifer S. (Foster, US)

Excel: Audit & Analytical Uses for Filters & Tables (AUMC)

L
Lauren V.D. (Montgomery Village, US)

Excel: Audit & Analytical Uses for Filters & Tables (AUMC)