Using the Report Wizard

Select a Reporting Pack

Select the Standard reporting pack.

Report Template

There are four financial report templates available for selection if you use the standard reporting pack. The templates are Balance Sheet By Type, Balance Sheet By Account Class, Trial Balance, and Profit and Loss Statement. Select the template that you want to use. There are also four financial report templates available for selection if you use the Chinese reporting pack. The templates are Income Statement, Balance Sheet, Statement of Cash Flow, and Statement of Changes in Equity Report. Select the template that you want to use.

Site

Select a site. This default site name comes from the site selected on the Excel toolbar. The Year field is updated when the site changes.

Period

Select the period that will be used in the formula.

Year

Select the fiscal year that will be used in the formula.

Currency

If you select a currency, the report is formatted to use the GL function with a currency parameter. The G/L balances are converted to the selected currency when the currency parameter is supplied to the function. The currency selection is not visible for the Chinese Reporting Pack or for the Trial Balance from the Standard Reporting Template.

Use Dynamic Parameters

Select this check box to make the report interactive. When selected, Period, Year, and Site are added to the top of the report, each with a selectable drop-down list. Choose an option in the drop-down list, and the data in the report changes.

Include Zero Balance

This check box does not display if using the Chinese Reporting Pack and Income Statement is selected as the report template. Otherwise, if this check box is cleared, the tool removes GL accounts that have zero balances for the selected period and fiscal-year. Select this check box if you want to include zero-balance accounts.

There are four report templates if you use the standard reporting pack:

• Balance Sheet by Type: This report, grouped by the Type column from the Chart of Accounts, has Account Code and the SLDESC function to retrieve the description, and either the SLGLBAL or the SLNGLBAL function to retrieve the balance amount. The Site, Period, and Year have a selectable drop-down list, so you can easily change the data that displays in the report. The difference between revenue and expenditure is added to the bottom of the Balance Sheet with a title of Estimated P/L. The argument value of the GL function uses absolute cell reference for Site, Period, and Year, and relative cell references for account code, when the Use Dynamic Parameters is checked in the Report Wizard. The estimated P/L is calculated using the End of Period rate.
• Balance Sheet by Account Class: This report is the same as Balance Sheet by Type except that the grouping is performed based on Account Class.
• Trial Balance: This report is set up with the use of an extra drop down list field in the Report Wizard. When you select Trial Balance as the Report Template, the Income Summary Account field is displayed.

  This report is grouped by Account Class. It includes account codes with type Assets, Liabilities, Owners' Equity, Revenue and Expense. The closing amount, which may be already part of Retained Earnings, may cause a non-balanced debit and credit totals. To avoid this, the closing balance must be subtracted from the Retained Earnings account. Since the SL doesn’t keep the Income Summary account while performing the Year-end closing activities, the Add-in requires you to select the same prior to generating the Trial Balance. The Income Summary Account field only displays account codes with the type ‘Owners Equity’.

  The closing summary amount is calculated as: SLPL(12, 2012, "OH", "Y") - SLPL(12, 2012, "OH", "N")

• Profit and Loss Statement: This report is set up with the use of an extra check box on the Report Wizard. When you select Profit and Loss Statement as the Report Template, the Use Expense-to-Revenue check box is displayed. If you select the Use Expense-to-Revenue check box, the period total and YTD total percentage is calculated by dividing an individual expense by total revenue. If this check box is cleared, the percentage is calculated by dividing an individual expense amount by total expense.

  This report includes items from revenue and expenditure type accounts. You must assign the appropriate Account Class to your chart of accounts code to generate this statement. The report is formatted in this order:

  • Revenue and Group Total
  • Cost of Sales and Group Total
  • Gross Profit. Calculated : Revenue - COS
  • Operating Expense and Group Total
  • Profit from Operations. Calculated: GP - Operation Total
  • Interest Income Expense and Group Total
  • Non-Operating Income Expense and Group Total
  • Depreciation and Amortization Expense and Group Total
  • Profit before Tax Expense. Calculated: GP - Total Expense (without Tax)
  • Tax Expense and Group Total
  • Net Profit Calculated: GP - Total Expense