How to Generate FSG Reports – Part I


Learn to create Financial Statement Generator (FSG) reports that are reusable and easy to maintain. The FSG’s are powerful tools that can be used to produce a variety of traditional reports such as balance sheets, profit and loss statements, income statements, expense analyses and gross margin reports.

There are many time-saving ways to construct and test the reports. Once the “standard” reports are developed, more sophisticated reports can be generated.


Overview
Each report is made up of several components. Each component is featured on a screen and has many fields that allow for a great deal of flexibility. Each screen allows the user to input display characteristics, state override segments, input offsets, and add levels of detail. In order to successfully create uniform, reusable reports, it must be determined where and how the different features of the FSG will be used.


Financial Statement
Here is the breakdown of a financial statement:

  • Rows – Detail of the report (row headings, accounts or flexfield assignments, calculations, totals)
  • Columns – Different periods, companies or consolidations. Usually, pre-defined column sets work with minor modifications.
  • Report – A single combination of a row set and column set with an optional content set and an optional row order.
  • Content Sets (optional) – Grouping of the same row sets and column sets sorted by a flexfield segment.
  • Row Order (optional) – Display and sorting characteristics of rows in a report. Used primarily to insert the segment value (like account number) or to utilize the description of the segment value.
  • Display Set (optional) – Used to block out ranges of rows or column sets simultaneously.
  • Report Set – A group of reports that are run together.

1. Create a row set that includes all accounts in the chart of accounts. Call it a row master.  For all other reports, copy this row set and delete individual rows that are not wanted in a specific report.  For all other segments, include the entire range of segment values (all cost centers, all companies, etc.) on the account assignment.

2. Give each report component a unique name.

3. Assign descriptive names to the row set being copied such as “Balance Rows” or “Expense Rows”.

4. Note that the “Title” field is what shows up on the printed report. There is a single line for the title, and it will print in the center of the page underneath the “Set of Books Name”. The third title line of the report is the “Period” for which the report is run. The date and time of the report and a page number will print on the upper left corner of each page. Additional title lines can be typed into the “Column Set Heading” field.

5. Draw each report on an Excel spreadsheet.  Note similar flexfield assignments, calculations and totals for each report. Determine standard characteristics for the rows. For example, always group cash accounts together and report them as one total line. But list expense accounts individually on all reports.

6. Assign sequence numbers for each row to reflect the accounts in that row. Use the same number of digits as the value for the accounts in that row. The account number order is generally the order in which reporting is usually completed. Examples include:

  • Sequence numbers for all asset rows might start with a 1xxxx.
  • Rows with cash accounts might have a sequence number of 11xxx.
  • Rows with liability accounts might have a sequence number of 3xxxx.

7. Make sure the sequence number reflects the type of row.

  • Rows with sequence numbers ending in 0 or 00 should be header rows or subtitles.
  • Sequence number 11000 should be a header row with no account assignments or calculations and should be titled “Cash Assets”.
  • Rows ending in 99,999 or 9999 should be totals or subtotals.
  • Sequence 11999 would be a subtotal of all cash asset rows.
  • Sequence 19999 would be a net of all asset rows.

Parallel the names and numbers in the values for the account segment of the flexfield, and use the 9 as a parent or summary account. Have the value description read “Total Current Assets” or “Net Accounts Receivable”. Enter the value set descriptions in a form that does not require substantial retyping.

8. Autocopy completed row sets, and then make modifications for each of the other reports. Autocopy all report components (column sets, content sets, row orders, reports, and report sets).

Download PDF

432 thoughts on “How to Generate FSG Reports – Part I”

  10. Peterdex says:

    trouver un mГ©dicament en pharmacie [url=https://pharmafst.shop/#]Livraison rapide[/url] pharmacie en ligne pharmafst.shop

  20. Peterdex says:

    pharmacie en ligne france livraison belgique [url=https://pharmafst.com/#]Pharmacies en ligne certifiees[/url] Achat mГ©dicament en ligne fiable pharmafst.shop

  35. Peterdex says:

    Tadalafil 20 mg prix en pharmacie [url=https://tadalmed.shop/#]Cialis generique prix[/url] cialis prix tadalmed.com

  49. Peterdex says:

    pharmacie en ligne france livraison internationale [url=https://pharmafst.com/#]Pharmacies en ligne certifiees[/url] pharmacie en ligne avec ordonnance pharmafst.shop

  68. MichaelFuB says:

    Medicine From India [url=http://medicinefromindia.com/#]MedicineFromIndia[/url] indian pharmacy

  139. Richardanock says:

    pin-up casino giris [url=https://pinupaz.top/#]pin-up casino giris[/url] pin up azerbaycan

  160. Richardanock says:

    вавада зеркало [url=http://vavadavhod.tech/#]вавада зеркало[/url] вавада

  184. Richardanock says:

    пин ап казино официальный сайт [url=https://pinuprus.pro/#]пин ап казино[/url] пин ап казино

  188. Richardanock says:

    вавада казино [url=https://vavadavhod.tech/#]vavada вход[/url] вавада казино

  192. Richardanock says:

    вавада казино [url=http://vavadavhod.tech/#]vavada вход[/url] vavada casino

  211. Richardanock says:

    пин ап вход [url=http://pinuprus.pro/#]пин ап казино[/url] пин ап казино

  215. Richardanock says:

    вавада официальный сайт [url=https://vavadavhod.tech/#]vavada casino[/url] vavada

  228. Lorenzoalera says:

    modafinil pharmacy [url=https://modafinilmd.store/#]verified Modafinil vendors[/url] modafinil legality

  229. Lorenzoalera says:

    fast Viagra delivery [url=http://maxviagramd.com/#]fast Viagra delivery[/url] trusted Viagra suppliers

  235. Lorenzoalera says:

    best price Cialis tablets [url=https://zipgenericmd.shop/#]best price Cialis tablets[/url] FDA approved generic Cialis

  240. Lorenzoalera says:

    order Cialis online no prescription [url=https://zipgenericmd.com/#]best price Cialis tablets[/url] best price Cialis tablets

  245. Lorenzoalera says:

    cheap Viagra online [url=http://maxviagramd.com/#]order Viagra discreetly[/url] order Viagra discreetly

  251. Lorenzoalera says:

    secure checkout ED drugs [url=http://zipgenericmd.com/#]generic tadalafil[/url] generic tadalafil

  257. Lorenzoalera says:

    secure checkout Viagra [url=http://maxviagramd.com/#]fast Viagra delivery[/url] fast Viagra delivery

  262. Lorenzoalera says:

    cheap Cialis online [url=https://zipgenericmd.com/#]affordable ED medication[/url] order Cialis online no prescription

  267. Lorenzoalera says:

    discreet shipping [url=http://maxviagramd.com/#]discreet shipping[/url] secure checkout Viagra

  272. Lorenzoalera says:

    discreet shipping [url=https://maxviagramd.com/#]same-day Viagra shipping[/url] cheap Viagra online

  276. Matthewvek says:

    prednisone 20 tablet [url=http://prednihealth.com/#]generic prednisone otc[/url] prednisone 3 tablets daily

  286. Matthewvek says:

    Amo Health Care [url=https://amohealthcare.store/#]Amo Health Care[/url] amoxicillin without a prescription

  291. Matthewvek says:

    prednisone 10mg canada [url=https://prednihealth.shop/#]PredniHealth[/url] PredniHealth

  296. Matthewvek says:

    buying clomid tablets [url=https://clomhealth.shop/#]Clom Health[/url] can you buy generic clomid online

  301. Matthewvek says:

    PredniHealth [url=http://prednihealth.com/#]prednisone uk price[/url] prednisone 5 tablets

  305. Matthewvek says:

    amoxicillin 500mg over the counter [url=https://amohealthcare.store/#]Amo Health Care[/url] Amo Health Care

  309. JosephGaire says:

    cialis and dapoxetime tabs in usa [url=https://tadalaccess.com/#]TadalAccess[/url] difference between sildenafil tadalafil and vardenafil

  313. JosephGaire says:

    us pharmacy prices for cialis [url=https://tadalaccess.com/#]TadalAccess[/url] over the counter cialis walgreens

  318. JosephGaire says:

    tadacip tadalafil [url=https://tadalaccess.com/#]cialis generic overnite shipping[/url] cialis maximum dose

  323. JosephGaire says:

    tadalafil (tadalis-ajanta) reviews [url=https://tadalaccess.com/#]how long does it take cialis to start working[/url] cheap tadalafil 10mg

  327. JosephGaire says:

    how much does cialis cost per pill [url=https://tadalaccess.com/#]cialis once a day[/url] buying cialis online canadian order

  331. JosephGaire says:

    cialis manufacturer coupon [url=https://tadalaccess.com/#]Tadal Access[/url] cialis over the counter at walmart

  334. JosephGaire says:

    buy cialis cheap fast delivery [url=https://tadalaccess.com/#]cialis back pain[/url] cialis purchase

  338. JosephGaire says:

    tadalafil liquid fda approval date [url=https://tadalaccess.com/#]cialis 5mg daily how long before it works[/url] cialis tadalafil discount

  342. JosephGaire says:

    cialis information [url=https://tadalaccess.com/#]does cialis shrink the prostate[/url] cialis cheap

  347. JosephGaire says:

    tadalafil brand name [url=https://tadalaccess.com/#]cialis medicine[/url] tadacip tadalafil

  351. JosephGaire says:

    best place to get cialis without pesricption [url=https://tadalaccess.com/#]where to buy tadalafil online[/url] how long does it take cialis to start working

  356. JosephGaire says:

    canadian pharmacy generic cialis [url=https://tadalaccess.com/#]canada cialis generic[/url] cialis buy without

  360. JosephGaire says:

    take cialis the correct way [url=https://tadalaccess.com/#]TadalAccess[/url] buying generic cialis

  364. JosephGaire says:

    where to get free samples of cialis [url=https://tadalaccess.com/#]TadalAccess[/url] sublingual cialis

  371. JosephGaire says:

    cialis testimonials [url=https://tadalaccess.com/#]price of cialis at walmart[/url] cialis black 800 mg pill house

  375. JosephGaire says:

    cialis patent [url=https://tadalaccess.com/#]cialis generic versus brand name[/url] tadalafil (exilar-sava healthcare) [generic version of cialis] (rx) lowest price

  380. JosephGaire says:

    tadalafil canada is it safe [url=https://tadalaccess.com/#]cialis samples for physicians[/url] cialis one a day with dapoxetine canada

  384. JosephGaire says:

    e-cialis hellocig e-liquid [url=https://tadalaccess.com/#]Tadal Access[/url] generic cialis available in canada

  388. JosephGaire says:

    buying generic cialis online safe [url=https://tadalaccess.com/#]Tadal Access[/url] pregnancy category for tadalafil

  392. JosephGaire says:

    cheaper alternative to cialis [url=https://tadalaccess.com/#]canadian cialis no prescription[/url] cialis 20 mg how long does it take to work

  397. JosephGaire says:

    mail order cialis [url=https://tadalaccess.com/#]does tadalafil lower blood pressure[/url] generic tadalafil cost

  401. JosephGaire says:

    how much does cialis cost at cvs [url=https://tadalaccess.com/#]TadalAccess[/url] cialis tadalafil & dapoxetine

  405. JosephGaire says:

    is cialis covered by insurance [url=https://tadalaccess.com/#]TadalAccess[/url] cialis results

  409. JosephGaire says:

    buy cialis canada paypal [url=https://tadalaccess.com/#]difference between sildenafil tadalafil and vardenafil[/url] tadalafil liquid review

  414. JosephGaire says:

    cialis tadalafil 10 mg [url=https://tadalaccess.com/#]cialis trial pack[/url] cialis patent expiration date

  418. JosephGaire says:

    pictures of cialis pills [url=https://tadalaccess.com/#]Tadal Access[/url] cialis stories

  422. JosephGaire says:

    cialis generic timeline [url=https://tadalaccess.com/#]TadalAccess[/url] cialis tablet

  426. JosephGaire says:

    online cialis australia [url=https://tadalaccess.com/#]find tadalafil[/url] cialis manufacturer

  430. JosephGaire says:

    cialis ontario no prescription [url=https://tadalaccess.com/#]price comparison tadalafil[/url] what does cialis do

Leave a Reply

Your email address will not be published. Required fields are marked *