The Reports tab has a number of Financial Statement and Transaction template reports available to print. There are four Report Templates for Financial Reports, Historical Financial Reports, GL Transactions reports and GL Historical Transactions reports, each with their own set of reports and options.
Financial Report
Period – Choose a date range to include transactions for the report. Select either a month, quarter or full year from any of the three open Fiscal years.
Show Details – Some financial statements print accounts with sub-groups listed together, with a subgroup total amount. If the subgroup is configured to Suppress Accounts, then only the total prints and not the individual accounts. Enable this Show Details option to override the Suppress Accounts setting on subgroups and always print the account amounts in addition to the totals.
Base – Choose either a specific account Base value to restrict report results to only those accounts, or leave this field blank to print for all accounts. Typically you would only choose an account here if you are printing a Transaction listing report, rather than a financial statement, that should use all accounts.
Location – Choose either a specific Location value to restrict report results to only those accounts with this Location segment, or leave this field blank to not restrict accounts by Location.
Profit Center – Choose either a specific Profit Center value to restrict report results to only those accounts with this Profit Center segment, or leave this field blank to not restrict accounts by Profit Center.
Balance Sheet – Prints accounts and their ending balances as of the end of the selected fiscal period, along with totals by account type. Account Group totals may also be configured for reports.
Comparative Financial Statement – Prints columns for the year to date ending balance as of the selected fiscal period, for both the selected fiscal year and the year previous to that. Variance amounts and percentages by account are calculated.
Financial Statement by 12 Periods – Prints columns for all 12 periods of the selected fiscal year, with end of period amounts populating columns up to the selected period. Periods after the one selected will print zero amounts instead of the actual amounts. Accounts with subgroups defined are printed together with a subgroup total. Gross Profit and Operating Income are calculated for each period. Use this report for companies that have a fiscal calendar with 12 periods.
Financial Statement by 13 Periods – Prints columns for all 13 periods of the selected fiscal year, with end of period amounts populating columns up to the selected period. Periods after the one selected will print zero amounts instead of the actual amounts. Accounts with subgroups defined are printed together with a subgroup total. Gross Profit and Operating Income are calculated for each period. Use this report for companies that have a fiscal calendar with 13 periods.
Financial Summary – Prints at the top, the account balance subtotals by account type, as of the selected fiscal period and year, in separate Assets and Liabilities and Equity section as a summarized balance sheet. Prints at the bottom, Revenue and Expense account subtotals by account type, for Period to Date, Quarter to Date and Year to Date columns as of the selected fiscal period and year, as a summarized income statement.
GL Account Foreign Balance – Prints a list of accounts configured with a non-base currency, and at least one of their respective opening, net change and closing balances for the selected fiscal period and year are non-zero.
Income Statement compared to Budget – Prints a list of accounts grouped by revenue and expenses, with Period to Date, Quarter to Date and Year to Date columns as of the selected fiscal period and year, for both actual and budget amounts and the respective percentage differences.
Income Statement compared to Forecast – Prints a list of accounts grouped by revenue and expenses, with Period to Date, Quarter to Date and Year to Date columns as of the selected fiscal period and year, for both actual and forecast amounts and the respective percentage differences.
Income Statement – Prints a list of accounts grouped by revenue and expenses, with Period to Date, Quarter to Date and Year to Date columns as of the selected fiscal period and year, for actual amounts and the respective percentages to total.
Trial Balance – Prints a list of accounts where at least one of their respective opening, net change and closing balances for the selected fiscal period and year are non-zero.
Historical Financial Report
Year End – Choose a date that represents the year end for a specific fiscal year. This fills in Start and End Date values for the entire fiscal year by default.
Start Date – Choose the earliest date for transaction selection, which will typically be the first day of a fiscal period or year.
End Date – Choose the latest date for transaction selection, which will typically be the last day of a fiscal period or year.
Show Details – Some financial statements print accounts with sub-groups listed together, with a subgroup total amount. If the subgroup is configured to Suppress Accounts, then only the total prints and not the individual accounts. Enable this Show Details option to override the Suppress Accounts setting on subgroups and always print the account amounts in addition to the totals.
Segment 1 – Choose either a specific account Base value to restrict report results to only those accounts, or leave this field blank to print for all accounts. Typically you would only choose an account here if you are printing a Transaction listing report, rather than a financial statement, that should use all accounts.
Segment 2 – Choose either a specific Location value to restrict report results to only those accounts with this Location segment, or leave this field blank to not restrict accounts by Location.
Historical Balance Sheet – Prints accounts and their ending balances as of the end of the selected fiscal period, along with totals by account type. Account Group totals may also be configured for reports.
Historical Comparative Financial Statement – Prints columns for the year to date ending balance as of the selected fiscal period, for both the selected fiscal year and the year previous to that. Variance amounts and percentages by account are calculated.
Historical Financial Statement by 12 Periods – Prints columns for all 12 periods of the selected fiscal year, with end of period amounts populating columns up to the selected period. Periods after the one selected will print zero amounts instead of the actual amounts. Accounts with subgroups defined are printed together with a subgroup total. Gross Profit and Operating Income are calculated for each period. Use this report for companies that have a fiscal calendar with 12 periods.
Historical Financial Statement by Period – Prints columns for all 13 periods of the selected fiscal year, with end of period amounts populating columns up to the selected period. Periods after the one selected will print zero amounts instead of the actual amounts. Accounts with subgroups defined are printed together with a subgroup total. Gross Profit and Operating Income are calculated for each period. Use this report for companies that have a fiscal calendar with 13 periods.
Historical Income Statement – Prints a list of accounts grouped by revenue and expenses, with Period to Date, Quarter to Date and Year to Date columns as of the selected fiscal period and year, for actual amounts and the respective percentages to total.
Historical Trial Balance – Prints a list of accounts where at least one of their respective opening, net change and closing balances for the selected fiscal period and year are non-zero.
GL Transactions
Period – Choose a date range to include transactions for the report. Select either a month, quarter or full year from any of the three open Fiscal years.
Start Trans No – Choose the first transaction ID to list on the report. Often this is left blank so that the Period determines which transactions are printed.
End Trans No – Choose the last transaction ID to list on the report. Often this is left blank so that the Period determines which transactions are printed.
GL Transactions by Month – Prints each journal entry within the selected period, including the document date, type, reference, and foreign amounts if applicable.
GL Historical Transactions
Year End – Choose a date that represents the year end for a specific fiscal year. This fills in Start and End Date values for the entire fiscal year by default.
Start Date – Choose the earliest date for transaction selection, which will typically be the first day of a fiscal period or year. A date range spanning multiple years is allowed.
End Date – Choose the latest date for transaction selection, which will typically be the last day of a fiscal period or year.
Show Details – Some financial statements print accounts with sub-groups listed together, with a subgroup total amount. If the subgroup is configured to Suppress Accounts, then only the total prints and not the individual accounts. Enable this Show Details option to override the Suppress Accounts setting on subgroups and always print the account amounts in addition to the totals.
Start Trans No – Choose the first transaction ID to list on the report. Often this is left blank so that the date range determines which transactions are printed.
End Trans No – Choose the last transaction ID to list on the report. Often this is left blank so that the date range determines which transactions are printed.
Segment 1 and 2 – Not used at this time.
GL Historical Transactions by Account – Prints all transactions within the report date range, with records grouped by account number and sorted within by transaction number.
GL Historical Transactions by Transaction – Prints all transactions within the report date range, with records grouped by transaction number.
