Customizing financial statements

Q:  I need to create a new financial statement. I’ve tried, but I just don’t understand how the system works.

A:  When creating a new financial statement you must have Advanced Financials selected in the General Ledger or Client Write-up Master Data, and the following three things must be determined:

  1. What type financial statement do you want? (i.e.  Balance Sheet, Income Statement, etc.)  
  2. What style financial is it going to be? (i.e.  YTD Only, YTD Budget with Variances, etc.) 
  3. What Groupings do I want it to have?

After determining the above, take a look at all the financials in CertiflexDimension. Then print out the Financial Statement Groupings Listing report (with accumulators) for the financial you want to mimic by going to >Reports >General Ledger/Client Write-Up >Groupings Listing, click >Options> Report Criteria Tab, select Include Accumulators.

Under Maintain, Ledger, Financial Statement Formats> Maintain Financial Statement Reports, notice the Financial Type of the financial you would like to mimic.

Go into your company and set up a new report under >Maintain >General Ledger/Client Write-Up >Financial Statement Formats> Maintain Financial Statement Reports, click >New, assign the report a number, click >OK, and set up the remaining fields according to settings you copied. Create the Groupings for the new financial based on the Financial Statement Groupings Listing report you printed from existing financials. Be careful to make adjustments to the new report when CertiflexDimension prompts for accumulator settings.