9.3. Reports Listed By Class

GnuCash has classified the main types of reports into major classes. These are all available under the Reports menu.

9.3.1. General Reports

The General Reports include the Account Summary Report, the Future Scheduled Transactions Summary, the Tax Schedule Report and TXF Export, and the Transaction Report and also the reports in the Sample & Custom menu.

9.3.1.1. Account Summary

9.3.1.2. Future Scheduled Transactions Summary

9.3.1.3. Tax Schedule Report and TXF Export

The tax schedule report lists all taxable income and deductible expense amounts used in the preparation of US Income Tax returns. The purpose of the report is to provide a complete audit trail for these amounts. The report is intended to be used by a tax payer to manually prepare his or her own tax return, or alternatively, to be provided to a tax preparer for that purpose. The report can also be used to generate an export of all tax related income and expenses to a TXF (Tax eXchange Format) file (this is in addition to exporting to the HTML format that all reports allow). The TXF file can be imported into tax filing programs such as TaxCut or TurboTax. The report should be run, inspected carefully for errors or omissions, and then corrections made to transactions, report settings, currency conversion rates or the account structure as needed. This process should be repeated as often as needed until all the amounts on the report are correct before a final version is used and saved along with the tax returns.

For accounts specified in the report options (none = all) that are also flagged as Tax-related, all transactions for the time period selected (also in the report options) are included. The report sorts transactions by date within account providing subtotals by account within tax code within Form or Schedule line number. Support is also provided for multiple copies of and for sub-line items for selected Forms/Schedules. Optionally uses special date processing to include federal estimated tax payments after year end.

All totals are in USD since this is the currency required for filing US Income Tax returns. Non-USD transaction amounts are converted to USD using the transaction conversion rate to USD, if available. If not, a conversion rate from the price database is used (either the date nearest the transaction date or nearest the report date as specified in the report options; if none is available, transaction amounts are converted to zero and the report provides a comment accordingly). A complete audit trail of conversions is provided.

Note

For this to work, the user has to segregate taxable and non taxable income to different accounts, as well as deductible and non deductible expenses. The Income Tax Information dialog is used for this. To access the Income Tax Information dialog go to EditTax Report Options. The user also must set the TXF category of each tax related account. The Income Tax Information dialog is described in the Section 10.5, “Setting Tax Report Options” section.

9.3.1.4. Transaction Report

This report lists transactions in selected accounts during a specified financial period. Two fields may be optionally used for sorting and totalling.

9.3.1.4.1. Report Options

Figure 9.1. Transaction Report, Report Options

Transaction Report, Report Options screen

This is an image of the Transaction Report, Report Options, Display tab.


  • Accounts tab

    • Accounts: Select one or more accounts to be reported.

      There are 4 buttons to aid account selection

      Select AllSelect all accounts
      Clear AllClear the selection and unselect all accounts
      Select ChildrenSelect all descendants of selected account
      Select DefaultSelect the default account selection
    • Show Hidden Accounts: Show accounts that have been marked hidden.

    • Filter By: Optionally select accounts to be either included or excluded depending on Filter type

    • Show Hidden Accounts: Show accounts that have been marked hidden in the Filter By list of accounts

    • Filter Type: One of

      NoneDo not do any filtering
      Include Transactions to/from Filter AccountsInclude Transactions to/from Filter Accounts only
      Exclude Transactions to/from Filter AccountsExclude Transactions to/from all Filter Accounts
    • Void Transactions: One of

      Non-void onlyShow only non-voided transactions
      Void onlyShow only voided transactions
      BothShow both and include voided transactions in totals
    • Reset defaults button: Reset all values to their defaults

  • Display tab

    • Date

    • Reconciled Date

    • Num

    • Description

    • Memo

    • Notes: Display the notes if the memo is unavailable

    • Account Name

    • Use Full Account Name

    • Account Code

    • Other Account Name: For multi-split transactions, this parameter should be unticked. See below for more details.

    • Use Full Other Account Name

    • Other Account Code

    • Shares: Display number of shares

    • Price: Display share prices

    • Amount: One of

      NoneDo not display Amount
      SingleSingle column display
      DoubleTwo column display
    • Running Balance

    • Totals

    • Sign Reverses: One of

      NoneDo not display signs reversed
      Credit AccountsReverse amount display for Liability, Payable, Equity, Credit Card and Income accounts
      Income and ExpenseReverse amount display for Income and Expense accounts
    • Reset defaults button Reset all values to their defaults

  • General tab

    • Report name: Enter a descriptive name for this report

    • Stylesheet: Select Default, Easy, Footer or Technicolor

    • Start Date: Enter or select a specific Start Date

      or select one of the following named start date options which will be used to determine the start date each time the report is run

      TodayThe current date
      Start of this monthFirst day of the current month
      Start of previous monthFirst day of the previous month
      Start of current quarterFirst day of the current quarterly accounting period
      Start of previous quarterFirst day of the previous quarterly accounting period
      Start of this yearFirst day of the current calendar year
      Start of previous yearFirst day of the previous calendar year
      Start of accounting periodFirst day of the accounting period as defined in the global preferences
    • End Date: Enter or select a specific End Date,

      or select one of the following named end date options which will be used to determine the end date each time the report is run

      TodayThe current date
      End of this monthLast day of the current month
      End of previous monthLast day of the previous month
      End of current quarterLast day of the current quarterly accounting period
      End of previous quarterLast day of the previous quarterly accounting period
      End of this yearLast day of the current calendar year
      End of previous yearLast day of the previous calendar year
      End of accounting periodLast day of the accounting period as defined in the global preferences
    • Style: One of

      SingleDisplay 1 line
      Multi-LineDisplay N lines
      Note

      In stable version 2.8.0, the Style option will be renamed to Detail Level and moved to the Display tab.

    • Common Currency: Convert all transactions into a common currency

    • Report's currency: Select the currency to display values

    • Table for Exporting: Formats the table for cut & paste exporting with extra cells

    • Reset defaults button: Reset all values to their defaults

  • Sorting tab

    • Primary Key: Primary Sort Key. One of

      NoneDo not sort
      Account NameSort and subtotal by account name
      Account CodeSort and subtotal by account code
      DateSort by date
      Exact TimeSort by exact time
      Reconciled DateSort by the reconciled date
      Register OrderSort as within the register
      Other Account NameSort by account transferred from/to's name
      Other Account CodeSort by account transferred from/to's code
      AmountSort by amount
      DescriptionSort by description
      NumberSort by check/transaction number
      MemoSort by memo
    • Show Full Account Name: Show the full account name for subtotals and subtitles

    • Show Account Code: Show the account code for subtotals and subtitles

    • Primary Subtotal: Subtotal according to the primary key

    • Primary Subtotal for Date Key: Do a date subtotal. Only configurable if primary key is date, exact time or register order. One of None, weekly, monthly, quarterly or yearly

    • Primary Sort Order: One of

      AscendingSmallest to largest, earliest to latest
      DescendingLargest to smallest, latest to earliest
    • Secondary Key: Secondary Sort Key. Same options as Primary Key

    • Secondary Subtotal: Subtotal according to the secondary key

    • Secondary Subtotal for Date Key: Do a date subtotal. Only configurable if primary key is date, exact time or register order. One of None, weekly, monthly, quarterly or yearly

    • Secondary Sort Order: One of

      AscendingSmallest to largest, earliest to latest
      DescendingLargest to smallest, latest to earliest
    • Reset defaults button: Reset all values to their defaults

9.3.1.4.2. Displaying Split Account Details

This is controled by the Style option on the General tab.

Note

In stable version 2.8.0 this option will be renamed to Detail Level on the Display tab.

In Single line mode, there's only one line per transaction. So you can have the account name on one side of the equation and

a. the other account name if there's only one other split in the transaction

or

b. "Split" if there are multiple other splits in the transaction. You can't display multiple "other" account names in one line. There's just no room for it.

In the case of Multi-Line mode, this report uses a completely different concept. For each transaction, every split (both the split in this account and the split(s) in the other account(s) !) is printed on a separate line. And every split really means every split: both the split which belongs in the account being reported and the split(s) in the other account(s) that balance the transaction. So even the most basic transaction, with only two splits (this account and other account) will print two lines in multiline mode.

For a simple transaction like this

DescriptionAccountDebitCredit
Cheques Received   
"multiple payers"IncomeAccount £30.00
 BankAccount£30.00 

then on a Transaction Report for the bank account the details appear pretty much as above.

For clarity of the accounts, you might enter transactions with multiple splits referring to the same account. For example, the above transaction might well be entered like this

DescriptionAccountDebitCredit
Cheques Received   
"FirstPayer"IncomeAccount £10.00
"SecondPayer"IncomeAccount £20.00
 BankAccount£30.00 

When this transaction is printed on the bank account's Transaction Report in Single line mode, then under other account it simply prints the word split instead of the account name.

To display the additional split detail, you need to set Single/Multi-Line to Multi-Line and then tick Display -> Account Name. Do NOT tick Display -> Other Account Name.

You can choose whether or not to turn off the full account name using Display -> Use Full Account Name.

Use Full Other Account Name has no effect in Multi-Line mode.

9.3.2. Assets & Liabilities

The Assets & Liabilities reports includes the Balance Sheet report, Investment reports and the Net Worth report.

  • Advanced Portfolio:

    Columns

    • Account: Stock Account

    • Symbol: Ticker Symbol/Abbreviation as defined in the Security Editor. A report option can suppress this column.

    • Listing: Type as defined in the Security Editor. A report option can suppress this column.

    • Shares: Number of shares (quantity). A report option sets how many decimal places to show. A report option can suppress this column.

    • Price: Unit market price as at report date. A report option can suppress this column.

    • Basis: Cost of all shares acquired by any means, including brokerage fees if the option to include them is checked. Report option Basis calculation method can be set to Average, LIFO or FIFO.

    • Value: Number of shares * Unit market price as at report date

    • Money In: Sum of the cost of stock purchased, excluding stock acquired as part of a Dividend Reinvestment Plan. I.e. External money used to purchase shares.

    • Money Out: Money from selling shares or a spin off transaction.

    • Realized Gain: Money received for selling shares minus basis for shares sold, minus brokerage fees for the sale if the option to include them in basis is checked.

    • Unrealized Gain: Value less Basis for unsold shares

    • Total Gain: Realized Gain + Unrealized Gain

    • Rate of Gain: Total Gain / Money In * 100 (from GnuCash 2.6.1 onwards)

    • Income: Total of all income transactions associated with a stock account.

      Note

      To include income from dividends which are not reinvested (if there is no split to the stock account in the income transaction, the report has no way of associating the income with a particular stock) :

      Ensure there is a dummy transaction split to the stock account with quantity 0, price 1 and value 0 in the dividend transaction. Enter the dummy stock split with no values in the dividend account and it will create the transaction with price 1 even though you cannot see the Price column in that register.

      In GnuCash 2.6.6, this report was modified to simplify the recording of dividend and interest payments. With this change it may not be necessary to include the dummy stock split in the transaction. The report will find income (and expense) transactions that are in the parent account of the stock account being reported on. This is done by looking in the parent account for transactions that have exactly two splits (not counting trading account splits) where the other split is to an income or expense account with the same name as the stock's account.

      For example given an account structure like


                      Assets (type ASSET)
                        Broker (type ASSET)
                          Widget Stock (type STOCK)
                      Income (type INCOME)
                        Dividends (type INCOME)
                          Widget Stock (type INCOME)
                      

      A transaction that debits the "Assets:Broker" account and credits the "Income:Dividends:Widget Stock" account will count as income even though it doesn't have a split with account "Assets:Broker:Widget Stock".

      This only works if the parent account ("Assets:Broker" in this case) is a Bank or Asset account and the Income/Expense account has the same name as the stock account. It won't double count transactions that have a dummy split since they won't have exactly two split transactions.

      It will not work if the income or expense account split is to a subaccount of the account with the same name as the stock account i.e. "Income:Dividends:Widget Stock:Franked"

    • Brokerage Fees: Brokerage Fees

    • Total Return: Total Gain + Income

    • Rate of Return: Total Return / Money In * 100

    Common report options are described in Section 9.2, “Configuring Reports and Charts”

    Report Specific Options

    • Accounts Tab

      • Include accounts with no shares: Unchecked (default) or checked.

    • Display Tab

      • Show ticker symbols: Checked (default) or unchecked. If unchecked, Symbol column will be omitted.

      • Show listings: Checked (default) or unchecked. If unchecked, Listing column (source of shares price quotes) will be omitted.

      • Show number of shares: Checked (default) or unchecked. If unchecked, Shares column will be omitted.

      • Share decimal places: The number of decimal places to show in the number of shares. Default is 2.

      • Show prices: Checked (default) or unchecked. If unchecked, Price column will be omitted.

    • General Tab

      • Price Source: Nearest in time (default) or Most Recent.

      • Basis calculation method: Average (default), FIFO or LIFO.

      • Set preference for price list data: Checked (default): Use price list data. If there is no relevant price list data, transaction prices will be used and there will be a warning. Unchecked: Get prices from stock transactions.

      • How to report brokerage fees: Include in basis (default), Include in gain or Ignore.

  • Asset Barchart:

    The Asset Barchart report displays bars that present the value of all assets in a GnuCash file over time. By default, the report shows all accounts in Accounts Receivable, Current Assets, Fixed Assets, Investments and Special Accounts (if they exist) and it displays monthly bars for the current financial period. This report provides a graphic view of the assets in the file over time.

    Tip

    Like all the generic reports, the user can assign a title and save the report with it's selected options for re-use later.

    The display is in the form of either a stacked barchart or simple barchart with an option to display a table of the values.

    This report calculates and displays a default of 8 bars or up to 24 separate asset accounts value at the end of the day on several dates through a specified time period. The report automatically selects the most significant accounts to display with all other selected accounts summed as Other.

    The report exploits the outline structure of the chart of accounts to allow the user to select top level accounts and sub-accounts down to a user-selectable depth. Selected sub-accounts below the selected depth are automatically summed up into the next level when it is also selected. The default number of sub-account levels is 2, giving a summary view. Increasing the number of sub-levels increases the detail available to display. It is possible to un-select a higher level account and leave sub-accounts selected to force greater detail to appear in the report.

    By default the report includes all asset accounts and sub-accounts, as well as Imbalance and Orphan Special accounts in whatever currencies or commodities may be present. The report's base currency is the default currency of the GnuCash file but if the file has data for multiple currencies, then it can be changed to another currency.

    Since each account may be individually selected, the report can be designed to focus on a small subset of data such as current assets or investments.

    The overall interval of the report defaults to start at the start of the current accounting period and to end at the end of the current accounting period. Numerous other starting choices and ending choices are available.

    The first bar shows the selected values at the end of the day on the first date chosen. There are a number of choices for step size from day to year with the default being month. Note that if any step date would fall on the 29th, 30th or 31st in a month that does not have such a date the next interval will be 31 days later. For that step only the date will slip up to 3 days into the following month. This is true for releases at least through 2.4.13. Bug 639049 is open in Bugzilla to modify this behavior.

    Currently, there is no option to start the report on the last day of any period. There is also no option to show beginning balances or end of previous step balances. This makes it difficult to correlate this report to business quarterly reports, for example.

    The Net Worth linechart report, Liability barchart report and Net Worth barchart report are similar except for the graphic type and default account groups selected.

    Other features are customizable in a manner similar to other standard reports.

  • Asset Piechart:

  • Average Balance:

  • Balance Sheet: This report summarizes assets, liabilities, and equity. When properly maintained, assets should equal the sum of liabilities and equity. If that is not the case, there is some kind of internal imbalance in the accounts.

  • Balance Sheet using eguile-gnc:

  • General Journal:

  • General Ledger:

  • Investment Portfolio: This report summarizes the value of the stocks in the current portfolio.

  • Liability Barchart:

  • Liability Piechart:

  • Net Worth Barchart: Net worth is the difference between the value of assets or liabilities.

  • Net Worth Linechart: Net worth plotted over time. Net worth is the difference between the value of assets or liabilities.

  • Price Scatterplot:

9.3.3. Business Reports

The Business Reports includes Customer and Vendor Reports and Printable Invoices as well as Aging reports.

9.3.3.1. Customer Report

9.3.3.2. Customer Summary

9.3.3.3. Easy Invoice

9.3.3.4. Employee Report

9.3.3.5. Fancy Invoice

9.3.3.6. Job Report

9.3.3.7. Payable Aging

This report provides a listing of vendors and their aged outstanding balances. Vendors may be included if they have posted business transactions (e.g. invoices) for the selected accounts payable account. It shows their current balance, and how much they have due from invoices over time periods 0-30 days, 31-60 days, 61-90 days, and over 90 days. The report also contains links to each vendor and to their current vendor report.

Optionally, vendor address details may be also shown.

Tip

To export vendor address details, say in order to do a mail merge, select the optional vendor address details in the report options display tab, apply the options to regenerate the report, then copy and paste the report into a spreadsheet. Alternatively, the report can be exported to a .html file, then read into a spreadsheet.

9.3.3.7.1. Report Options
Note

See Common Report Options in the Configuring Reports and Charts section of this help manual for more details of the common options.

  • General tab

    • Report name: Enter a descriptive name for this report - see common report options.

    • Stylesheet: Select a style sheet for this report - see common report options.

    • To: Select a date to report on or a named date. Transactions up to and including the selected date will be used to calculate the outstanding aged balances. See common report options.

    • Report's currency: Select the currency to display the values in - see common report options.

    • Price Source: Select the source of price information used for currency conversion if needed. One of

      Average CostThe volume-weighted average cost of purchases
      Weighted Average (default) The weighted average of all currency transactions in the past
      Most recentThe most recent recorded price
      Nearest in timeThe price recorded nearest in time to the report date
    • Show Multi-currency Totals: If not selected, all totals are shown in the report currency.

    • Sort By: Sort companies by one of

      Name (default)Company name
      Total OwedTotal amount owed to company
      Bracket Total OwedAmount owed in oldest bracket. If same, use next oldest
    • Sort Order: One of

      Increasing (default) 
      Decreasing 
    • Show zero balance items: Show companies even if they have a zero outstanding balance.

    • Due or Post Date: Leading date. Which date to use to determine aging. One of

      Due Date (default) 
      Post Date 
    • Payable Account: The accounts payable account used to select vendors to be reported. Vendors are included if they have a posted business transaction (usually an invoice) on or before the report date and also meet the Show zero balance items criteria.

  • Display tab

    • Address Name: Display vendor address name. This, and other fields, may be useful if copying this report to a spreadsheet for use in a mail merge.

    • Address 1: Display address line 1.

    • Address 2: Display address line 2.

    • Address 3: Display address line 3.

    • Address 4: Display address line 4.

    • Phone: Display address phone number.

    • Fax: Display address fax number.

    • Email: Display email address.

    • Active: Display vendor active status.

9.3.3.8. Printable Invoice

9.3.3.9. Receivable Aging

This report provides a listing of customers and their aged outstanding balances. Customers may be included if they have posted business transactions (e.g. invoices) for the selected accounts receivable account. It shows their current balance, and how much they have outstanding from invoices over time periods 0-30 days, 31-60 days, 61-90 days, and over 90 days. The report also contains links to each customer and to their current customer report.

Optionally, customer address details may be also shown.

Tip

To export customer address details, say in order to do a mail merge, select the optional customer address details in the report options display tab, apply the options to regenerate the report, then copy and paste the report into a spreadsheet. Alternatively, the report can be exported to a .html file, then read into a spreadsheet.

9.3.3.9.1. Report Options
Note

See Common Report Options in the Configuring Reports and Charts section of this help manual for more details of the common options.

  • General tab

    • Report name: Enter a descriptive name for this report - see common report options.

    • Stylesheet: Select a style sheet for this report - see common report options.

    • To: Select a date to report on or a named date. Transactions up to and including the selected date will be used to calculate the outstanding aged balances. See common report options.

    • Report's currency: Select the currency to display the values in - see common report options.

    • Price Source: Select the source of price information used for currency conversion if needed. One of

      Average CostThe volume-weighted average cost of purchases
      Weighted Average (default) The weighted average of all currency transactions in the past
      Most recentThe most recent recorded price
      Nearest in timeThe price recorded nearest in time to the report date
    • Show Multi-currency Totals: If not selected, all totals are shown in the report currency.

    • Sort By: Sort companies by one of

      Name (default)Company name
      Total OwedTotal amount owed by company
      Bracket Total OwedAmount owed in oldest bracket. If same, use next oldest
    • Sort Order: One of

      Increasing (default) 
      Decreasing 
    • Show zero balance items: Show companies even if they have a zero outstanding balance.

    • Due or Post Date: Leading date. Which date to use to determine aging. One of

      Due Date (default) 
      Post Date 
    • Receivables Account: The accounts receivable account used to select customers to be reported. Customers are included if they have a posted business transaction (usually an invoice) on or before the report date and also meet the Show zero balance items criteria.

  • Display tab

    • Address Source: Which customer address fields to display. One of

      Billing (default)Address fields from billing address.
      ShippingAddress fields from shipping address.
    • Address Name: Display customer address name. This, and other fields, may be useful if copying this report to a spreadsheet for use in a mail merge.

    • Address 1: Display address line 1.

    • Address 2: Display address line 2.

    • Address 3: Display address line 3.

    • Address 4: Display address line 4.

    • Phone: Display address phone number.

    • Fax: Display address fax number.

    • Email: Display email address.

    • Active: Display vendor active status.

9.3.3.10. Tax Invoice

9.3.3.11. Vendor Report

9.3.4. Income & Expense

The Income & Expense reports includes the Cash Flow and Income Statement reports.

  • Cash Flow:

  • Equity Statement:

  • Expense Barchart:

  • Expense Piechart:

  • Expense vs Day of Week:

  • Income & Expense Chart:

  • Income Barchart:

  • Income Piechart:

  • Income Statement: This report summarizes sources of income and expenditure. (This report was called Profit & Loss in gnucash-1.8.)

  • Income vs Day of Week:

  • Profit & Loss: This is the same report as the Income Statement but with a different title.

  • Trial Balance: This report summarizes sources of income and expenditure.

9.3.5. Sample & Custom

9.3.5.1. Welcome Sample Report

9.3.5.2. Custom Multicolumn Report

This report is used to place multiple reports into a single report window to examine a set of financial information at a glance.

9.3.5.3. Sample Report with Examples

9.3.6. Budget

9.3.6.1. Budget Balance Sheet

9.3.6.2. Budget Barchart

9.3.6.3. Budget Flow

9.3.6.4. Budget Income Statement

9.3.6.5. Budget Profit & Loss

9.3.6.6. Budget Report

This report is used to compare budgeted and real amounts for selected accounts. It allows you to review how well you follow the budget.

The report is generated as a table in which each row represents an account and each set of columns shows the budgeted amount, the real amount, and the difference between them for each report period.

Each entry in the real amount column is the sum of all the splits in the row's account over the column's period. For example, if the report is set up for monthly periods, the column is for May, and the row is for Expenses:Groceries, then the value will be the sum of all Expenses:Groceries splits for that May.

The report supports selecting a range of periods instead all of them. Periods that are out of range can be included in the report as the consolidated columns around the selected range. This allows you to focus on particular periods, for example the current one, and is especially useful for budgets with many periods. For example, if you have a 12 period budget you can make a 3 column report with the format "(all periods before columns set) (current period columns set) (all periods after columns set)" that is easily fits on the screen and allows you to match values with account names.

Budget report options

Note

Here we describe only options that are specific for the Budget Report. You can find information about standard parameters in Section 9.2, “Configuring Reports and Charts”.

  • Show budget - include the budgeted values for the period

  • Show actual - include the real values for the period

  • Show difference - include the difference between budgeted and real values for the period. Enabling this option does not force including budgeted and actual values in the report

  • Show Column with totals - Adds a final column set containing budgeted, real value, and difference columns summing those values across all periods of the report.

  • Rollup budget amounts to parent - not used in the report, can be deleted or should be fixed

  • Include accounts with zero total balances and budget values - enables display of accounts with no budget or splits in any period.

  • Budget - Select the budget to use for report generation

  • Report for range of budget periods - Enables reporting on a subset of the budget by selecting a beginning and an ending period.

  • Range start - a combobox with a list of options to select the start period:

    1. First - select first budget period

    2. Previous - select previous period.

    3. Current - select current period.

    4. Next - select next period.

    5. Last - select last budget period

    6. Manual - enables spinbox where you can select exact period

    Note

    The current, previous, and next options select the period based on the date on which the report is run, with current being the period in which the date falls, previous being the one before that, and next the period after. If the current date falls outside the date range covered by the budget, the first or last period will be used as appropriate.

  • Exact start period - options for select exact start period, enabled only if the range start option is set to Manual

  • Range end - a combobox with a list of options to select the end period. Values are the same as in Range start options

  • Exact end period - the same as Exact start period but for the end of range

  • Include collapsed periods before selected - if on, then includes in the report all budget periods, that are before selected period range, as a single consolidated column set

  • Include collapsed periods after selected - if on, then includes in the report all budget periods, that are after selected period range, as a single consolidated column set.