NetClose - Auto-generate quarterly tasks and reconciliations outside the calendar quarter
Overview
Quarterly task templates and account groupings don't have to follow the calendar quarter (January, April, July, October). Two fields control when they auto-generate:
- Auto Generation Day sets which day of the period NetClose generates the record on.
- Auto Generation Preferred Period sets which period the generated record belongs to.
This article explains how NetClose counts the Auto Generation Day on a quarterly schedule. It then shows how to set these fields when your fiscal quarters don't line up with calendar quarters, or when a quarterly task needs to land in the middle month of the quarter (for example February, May, August, and November). For general setup of these fields, see NetClose - Auto-Generate Tasks and NetClose - Auto-Generate Reconciliations.
Key assumptions
- The NetClose auto-generate scripts for tasks and reconciliations are deployed and scheduled to run daily.
- Your accounting periods in NetSuite include quarter and year periods for the dates you are generating into. NetClose reads quarters and fiscal years from your NetSuite accounting periods, not from the calendar.
How Auto Generation Day is counted
The Auto Generation Day counts days across the period that matches the record's frequency, not across a month.
| Frequency | Auto Generation Day counts across |
|---|---|
| Monthly or Weekly | The current month |
| Quarterly | The current quarter, as defined by your NetSuite accounting periods |
| Annually | The current fiscal year, as defined by your NetSuite accounting periods |
- A positive number counts forward from the first day of the period. 1 is the first day, 10 is the tenth day.
- A negative number counts backward from the last day of the period. -1 is the last day, -5 is four days before the last day.
- 0 turns auto-generation off.
- A number larger than the period has days generates on the last day of the period.
A quarterly day counts across the whole quarter
On a quarterly template, an Auto Generation Day of 20 means the 20th day of the quarter. For a calendar quarter that is January 20, April 20, July 20, and October 20, not the 20th of the quarter-end month. To generate in the last month of the quarter, use a negative number.
Fiscal quarters that don't match the calendar
If your fiscal quarters are set up in NetSuite to start in a month other than January, April, July, and October, you don't need to do anything special. NetClose counts from the start or end of your fiscal quarter.
For example, with a fiscal year that starts February 1, the quarters are February-April, May-July, August-October, and November-January:
| Auto Generation Day | Generates on |
|---|---|
| 1 | Feb 1, May 1, Aug 1, Nov 1 |
| -1 | Apr 30, Jul 31, Oct 31, Jan 31 |
To check your quarters, navigate to Setup > Accounting > Manage Accounting Periods in NetSuite.
Step-by-step process for quarterly tasks
- Navigate to NetClose > Lists > Tasks and filter the list to Close Task Templates Only.
- Click Edit on the quarterly task template.
- Confirm the Frequency is Quarterly.
- Enter the Auto Generation Day. Use the examples below to pick a value.
- Select the Auto Generation Preferred Period:
- Current - the task belongs to the month it generates in.
- Previous - the task belongs to the month before the one it generates in.
- Next - the task belongs to the month after the one it generates in. If left blank, the system defaults to Next.
- Click Save.
A task always belongs to a monthly period, even on a quarterly template. The Preferred Period picks that month relative to the month the task generates in. Due dates are then calculated from the end of the month the task belongs to.
Example setups for quarterly tasks
These examples assume a fiscal year that follows the calendar year, so the quarters start January 1, April 1, July 1, and October 1.
| Goal | Auto Generation Day | Preferred Period | Generates on | Task period |
|---|---|---|---|---|
| Middle month of the quarter, around the 10th | 41 | Current | Feb 10, May 11, Aug 10, Nov 10 | Feb, May, Aug, Nov |
| Middle month of the quarter, around the 20th | 51 | Current | Feb 20, May 21, Aug 20, Nov 20 | Feb, May, Aug, Nov |
| Middle month, but belongs to the quarter-end month | 41 | Next | Feb 10, May 11, Aug 10, Nov 10 | Mar, Jun, Sep, Dec |
| Last day of the quarter | -1 | Current | Mar 31, Jun 30, Sep 30, Dec 31 | Mar, Jun, Sep, Dec |
| Five days before the quarter ends | -5 | Current | Mar 27, Jun 26, Sep 26, Dec 27 | Mar, Jun, Sep, Dec |
| First day of a new quarter, for the quarter just closed | 1 | Previous | Jan 1, Apr 1, Jul 1, Oct 1 | Dec, Mar, Jun, Sep |
In the last example, a Preparer Due Date (Relative) of 5 makes the task due 5 business days after the end of the quarter it closes (for example, 5 business days after December 31).
Generation dates can shift by a day between quarters
Months have different numbers of days, so the same Auto Generation Day can land on a slightly different date each quarter. Day 41 lands on May 11 in the second quarter because April has 30 days. No single number lands on the exact same day of the month in every quarter.
Reconciliations
Account groupings use the same Auto Generation Day counting, with two differences.
- Auto Generation Preferred Period has two options: Current and Previous. If left blank, NetClose uses Previous.
- For a quarterly account grouping, the Preferred Period picks a quarter, not a month. Current generates the reconciliation for the quarter you are in. Previous generates it for the quarter before.
To set up a quarterly account grouping:
- Open the NetClose Account Grouping record and click Edit.
- Confirm Quarterly is selected in Frequency.
- Enter the Auto Generation Day and select the Auto Generation Preferred Period.
- Click Save.
For example, with calendar quarters, an Auto Generation Day of 41 and a Preferred Period of Previous generates the October-December reconciliation on February 10, the January-March reconciliation on May 11, and so on.
If an account grouping has more than one frequency selected (for example Monthly and Quarterly), the same Auto Generation Day applies to each one. A day of 3 generates the monthly reconciliation on the 3rd day of the month and the quarterly reconciliation on the 3rd day of the quarter.
Quarterly reconciliations always cover a full quarter
The Auto Generation Day changes when a quarterly reconciliation is generated, not which months it covers. A quarterly reconciliation always covers a quarter period from your NetSuite accounting periods. To reconcile over different quarters, the quarter periods themselves have to be set up that way in NetSuite.
Limitations / things to be aware of
- Next on a task needs the following accounting period to exist in NetSuite. If periods have not been set up that far ahead, the task has no period to land in.
- A due date earlier than the generation date makes the task overdue as soon as it is created. This is easy to hit with Previous and a small or absolute due date.
- If both Preparer Due Date (Relative) and Preparer Due Date (Absolute) are filled in, the relative value is used and the absolute value is ignored. The same applies to reviewer due dates.
