Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

Datasets

Roll forward datasets manually

There are cases when the roll forward should be manual. Manual roll forward is appropriate for unusual periods, such as periods that are not monthly, bi-monthly, or quarterly, usually where the authorities have agreed to a dispensation.
You should make sure that a calculation in a dataset is deleted permanently from ONESOURCE before the dataset is rolled forward; otherwise the soft deleted calculation will also be rolled forward along with other calculations in the dataset. It can be hard deleted by selecting
Deleted dataset(s)
 from the Show menu option and then deleting the calculation.
To manually roll forward:
  1. On the main menu, select
    Returns
     >
    Returns
    .
  2. Group the columns by dataset.
    1. If it is not already active, select the
      Show Group Panel
       icon to open the heading pane. If the heading pane is already active, the
      Show/Hide Group Panel
       option appears in the toolbar grid instead. You can use these icons to toggle the heading pane on and off.
    2. Drag the column headings you want to group into the heading pane (located above the column headings). In this example, the grid will be grouped by Dataset.
    3. To remove the grouping, select the
      X
       for the grouping name in the column header.
  3. Check the checkbox for the dataset to be rolled forward.
  4. Select the
    RollFwd
     option on the toolbar.

Same Entity and Period with Multiple Calculations for Different Purposes

If a calculation is part of two different datasets, one for monthly (Jan) and the other for quarterly (Jan – Mar), and if you import the next period’s data related to first dataset (for example, for the month of February), ONESOURCE verifies if there is a dataset already existing for the dates being imported and as there is already one covering the periods January till March (for example, second dataset – quarterly), it will not roll forward the first dataset automatically. Instead you must do it manually.

This article applies to:

  • PRODUCT: ONESOURCE Indirect Tax,ONESOURCE Indirect Tax Compliance
  • Subject: Roll forward / rollover

Related Content