You are trying to write up several financial reports but are unsure which ones are the right one to use in Sage 300 ERP. This week’s blog post takes a look at which Financial Reporter (FR) spec template is the right one for you to use in the G/L Statement Designer.
The G/L Statement Designer is an add-in program that works with Microsoft Excel. You use it to create customized statement specifications, and you can use it to generate the statements.
When you open the Statement Designer from the Financial Reporter folder, and then click Start, Excel opens with the Financial Reporter functions automatically loaded. These functions let you retrieve and work with data from your Sage 300 ERP company database.
There is a set of statements that ship with General Ledger; this includes sample balance sheets, income statements, financial analysis reports and a forecasting report.
To find the FR Spec templates in Sage 300 ERP, navigate to the directory where you have installed Sage 300 ERP. Then click on the GLxxx folder where the xxx is your version of Sage 300 ERP. Next click on the ENG folder.
In this folder, you will find the FR spec templates:
Balance Sheet Statements
- QuikBal1.xls: Standard balance sheet shown in a single column
- QuikBal2.xls: Comparative balance sheet between current year and previous year
- QuikBal3.xls: Comparative balance sheet between current period and previous period
- Balsum01.xls: Common size balance sheet summary
- A summary as amounts and as a percentage of total assets and liabilities, printed on separate pages.
- A summary as amounts and as a percentage of total assets and liabilities, printed on separate pages.
- Balsum02.xls: Balance sheet summary with graphs
- A summary as amounts and a graph as a percentage of total assets and liabilities. Asset summaries and liability summaries are printed on separate pages.
- A summary as amounts and a graph as a percentage of total assets and liabilities. Asset summaries and liability summaries are printed on separate pages.
- Balsum03.xls: Balance sheet summary for specified period
- A summary of the balance sheet for a specified period.
- A summary of the balance sheet for a specified period.
- Balsum04.xls: Comparative balance sheet summary between current year and previous yearBalsum05.xls: Comparative balance sheet summary between current year and budget
- A comparison of current and previous year amounts, and variance by amount and percentage
- A comparison of current and previous year amounts, and variance by amount and percentage
- A comparison of actual and budgeted amounts for the current year, and variance by amount and percentage.
Income Statements
- QuikInc1.xls.: Standard income statement shown in a single column
- QuikInc2.xls.: Comparative income statement comparing current year to date and last year to date
- QuikInc3.xls.: Comparative income statement between current year and budget
- QuikInc4.xls.: Comparative income statement between current year with drilldown
Income Statement Summaries
You would use these statements if you want to display each account as a percentage of sales revenue, allowing financial managers to see how the company’s profit is affected by income statement components.
- Incsum01.xls.: Common size income statement
-
- A summary as amounts and as a percentage of sales revenue, printed on separate pages.
-
- Incsum02.xls.: Income statement summary with graphs
-
-
- A summary as amounts and a graph as percentages of total revenue.
-
- Incsum03.xls.: Income statement summary for a specified period
-
-
- A summary of the income statement for a specified period.
-
- Incsum04.xls.: Comparative Income statement summary between current Year and previous year
- A comparison of current and previous year amounts, and variance by amount and percentage.
- Incsum05.xls.: Comparative income statement summary between current year and budget
-
-
- A comparison of actual and budgeted amounts for the current year, and variance by amount and percentage.
-
Financial Analysis Statements
These statements display financial ratios used by financial managers to evaluate a company's performance.
- Finratio01.xls.: Financial ratios
-
-
- A summary of the financial ratios for the current period grouped into the following categories: Profitability, Asset Utilization, Liquidity, Debt Utilization, and Growth.
- A summary of the financial ratios for the current period grouped into the following categories: Profitability, Asset Utilization, Liquidity, Debt Utilization, and Growth.
-
- Finratio02.xls.: Financial ratios and benchmarks
- A comparison of the company's financial ratios to the benchmark, and the variance between the ratios.
- Finratio03.xls.: Financial ratios and benchmarks with graphs
-
-
- A graph comparing the company's financial ratios to the benchmark.
-
- Finratio04.xls.: Comparative financial ratios between current year and previous year
-
-
- A comparison of the company's financial ratios for the current and previous years, and the variance between the ratios.
- A comparison of the company's financial ratios for the current and previous years, and the variance between the ratios.
-
- Finratio05.xls.: Comparative financial ratios and benchmarks with graphs between current year and previous year.
-
-
- A graph comparing the company's financial ratios for the current and previous years to the benchmark.
-
Financial Forecasts
Use this specification for financial forecasting to assess your current operating performance, and project how your business will perform in the future. The file will produce forecasts for the next 3 years and perform what-ifs.
- Forecast.xls creates a forecasted income statement and balance sheet. The statements include actuals for the current and previous years, and projected amounts for the next three years based on the percentage of sales revenue growth.
You can find more details on these sample financial statements in the Sage 300 ERP Financial Reporter User Guide for 6.0, 2012 and 2014.
