Creating Custom Financial Statements with Excel

Price: $19.99

CPE Credits: 2.0

Category: ,

Course Number: CXCFSTMC

custom financials

Description: 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. Delivery Method: Online QAS Self Study. Level: Overview (Intermediate recommended) Version: Excel 2007-Excel 2016 Prerequisites: See version comment Advanced Preparation: None

AuthorJoseph P. Helstrom, CPA Publication: May 2014 Update: November 2017 Format: PDF and Exercise File Pages: 61 Passing Grade: 70% Exam Policies: Exam may be retaken. Course must be completed within one year of purchase. CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:

  • 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 INDIRECTfunction with referencing Excel worksheets

 

Below are Students’ Comments: ” I use Excel quite a bit but still learned a few new things!” – Holly B. 11/17 “Overall, I thought it was a good course. I liked having the provided excel workbook”. Lisa C. 11/17 “I thought the jump from the SUMIF functio nto VLOOKUP and INDIRECT was a little challenging” Eric Y. 11/2017

Description: 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. Delivery Method: Online QAS Self Study. Level: Overview (Intermediate recommended) Version: Excel 2007-Excel 2016 Prerequisites: See version comment Advanced Preparation: None

AuthorJoseph P. Helstrom, CPA Publication: May 2014 Update: November 2017 Format: PDF and Exercise File Pages: 61 Passing Grade: 70% Exam Policies: Exam may be retaken. Course must be completed within one year of purchase. CPE Sponsor Info : NASBA/QAS #109234. Click here to view specific state approvals.

By the end of the course participants should be able to:

  • 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 INDIRECTfunction with referencing Excel worksheets

 

Below are Students’ Comments: ” I use Excel quite a bit but still learned a few new things!” – Holly B. 11/17 “Overall, I thought it was a good course. I liked having the provided excel workbook”. Lisa C. 11/17 “I thought the jump from the SUMIF functio nto VLOOKUP and INDIRECT was a little challenging” Eric Y. 11/2017

  • Thank you Patricia. I really love your courses. I learned so much about excel this weekend!”

    - Connie K.

  • “I am extremely impressed with the courses and the reasonable price.” -Janet A. May 2017

    - Janet

  • “..may I say it is rarer that I ever have gotten a personal reply from a CPE Site! Glad I have found your site.”

    - Tom