Financial Reports
Sage ERP Accpac's Financial Reporter is a powerful tool that uses Microsoft Excel to manipulate, format, graph, and print general ledger data.
Financial reports are printed like other Sage ERP Accpac reports. You open the print form, choose the report you wish to print and choose from a number of print options. (See Print Financial Statements.)
Report information
Financial statements can include as many columns of data as you wish, and can contain any of the following account information:
-
Current or historical balances for any range of accounts.
-
Net changes for a fiscal period, quarter, half-year or year.
-
Balances or net changes in the functional currency or any of the source currencies in a multicurrency ledger.
-
Comparative figures from complete or to-date time spans.
-
Budget figures from up to five fiscal sets.
You can also use any of the following information in a financial statement:
-
Company information such as the name, address, phone number, and company contact.
-
The starting and ending dates of a given fiscal period.
-
The exchange rate entered for a particular currency, rate type, functional currency, and date.
-
The options selected for printing the financial statement, such as the print date, the department range, and the period-end date. You can also include provisionally posted transactions, and rollup amounts.
Standard reports
General Ledger comes with the following standard financial statements, which you can use as is or modify to suit your requirements:
Balance
Sheet statements
-
QuikBal1.xls. Balance Sheet.
-
QuikBal2.xls. Comparative Balance Sheet (Current Balance/Previous Year).
-
QuikBal3.xls. Comparative Balance Sheet (Current Balance/Previous Period).
Balance
Sheet summaries
Balance sheet summaries are files that display a summary of the company’s balance sheet.
-
Balsum01.xls. Balsum01.xls is a summary of the balance sheet as amounts and as a percentage of total assets/liabilities, printed on separate pages.
-
Balsum02.xls. Summary of the balance sheet as amounts and as a percentage of total assets/liabilities, with a graph on a separate page. This report is not generated by Financial Reporter, but is from data generated from fixed cell locations, and may not reflect correct information when generating with the report option. Also, labels on charts in different versions of Excel may be located in different positions.
-
Balsum03.xls. Summary of the balance sheet for the period specified by users.
-
Balsum04.xls. Summary of the balance sheet for the current and previous years. Additionally, the report prints variances between the current and previous years’ numbers (in amount and percentage), on the same page.
-
Balsum05.xls. Summary of the actual and budgeted balance sheet for the current year. Additionally, the report prints variances between the actual and budgeted numbers (in amount and percentage), on the same page.
Financial
Analysis statements
-
Finratio01.xls. Financial ratios for the current period grouped into five main categories.
-
Finratio02.xls. Financial ratios of the company and financial ratios of an average company in the same industry (benchmarks) and variances between those ratios.
-
Finratio03.xls. Financial ratios of the company, compares them with benchmarks, and displays the results in a graphical format. This report is not generated by Financial Reporter, but is from data generated from fixed cell locations, and may not reflect correct information when generating with the report option. Also, labels on charts in different versions of Excel may be located in different positions.
-
Finratio04.xls. Financial ratios of the company for the current and previous years and variances between them.
-
Finratio05.xls. Financial ratios of the company for the current and previous years and benchmarks. The results are displayed in a graphical format. This report is not generated by Financial Reporter, but is from data generated from fixed cell locations, and may not reflect correct information when generating with the report option. Also, labels on charts in different versions of Excel may be located in different positions.
Financial
Forecasting statements
Forecast.xls. Allows users to create forecasts and perform what-if analyses. Summary of the income statement and balance sheet for the current and previous years. Additionally, the report prints a forecast of the income statement and balance sheet for the next three years. The forecast is based on the percentage of sales revenue growth.
Income
Statements
-
QuikInc1.xls. Income Statement.
-
QuikInc2.xls. Comparative Income Statement (Current Year/Last Year).
-
QuikInc3.xls. Comparative Income Statement (Current Year/Budget).
-
QuikInc4.xls. Comparative Income Statement (Current Year with Drilldown).
Because statements are created in a spreadsheet, you can use any spreadsheet formulas and functions to perform relative-change calculations on General Ledger figures, to express them as percents or ratios.
Income
Statement summaries
Income Statement summaries display each account as a percentage of the value of sales, allowing analysts to see how the company’s profit is affected by income statement components.
-
Incsum01.xls. Summary of the income statement as amounts, and, on separate pages, displays all amounts as a percentage of sales revenue (sales revenue must equal 100%).
-
Incsum02.xls. Summary of the income statement in the regular format (as amounts) and displays percentages of total revenue in graphical format. This report is not generated by Financial Reporter, but is from data generated from fixed cell locations, and may not reflect correct information when generating with the report option. Also, labels on charts in different versions of Excel may be located in different positions.
-
Incsum03.xls. Summary of the income statement for a specified period.
-
Incsum04.xls. Summary of the income statement for the current and previous years. Additionally, the report prints variances between the current and previous year’s numbers (in amount and percentage), on the same page.
-
Incsum05.xls. Summary of the actual and budgeted income statement for the current year. Additionally, the report prints variances between the actual and budgeted numbers (in amount and percentage), on the same page.
See also
Consolidating Financial Statements of Multiple Companies in Microsoft Excel