NetLease Custom Calendars

Overview

Clients who do not use a calendar year for their accounting but use alternate accounting periods (for example a 4-4-5 [13 period] calendar) can manually set up the periods in NetLease. This article will walk through 1) how to create custom calendars and 2) how to apply custom calendars to NetLease records.

Prerequisite: Custom calendars must be enabled in the NetLease System Setup. Enable them by navigating to NetLease > NetLease Setup > System Setup. Under the System Settings tab, check the box next to Custom Calendars:

1) Creating a custom calendar

  • Navigate to NetLease > NetLease Setup > Manage Custom Calendars
  • Click "Create New Calendar" to create a new NetLease calendar. 
  • Give the calendar a name, then add the period names, start dates, and end dates below. These accounting periods can be added manually, by syncing your NetSuite accounting periods, or can be added by CSV upload.

Synching to Accounting Periods

  • If your accounting periods in NetSuite are set up the same way you'd like your custom calendar in NetSuite, you can sync the data. Click the "Sync to accounting periods" button and it will automatically pull in your accounting periods from NetSuite.

CSV Upload

  • To easily add all accounting periods, create a CSV file with the name of the custom calendar, accounting period name, start date, and end date. Navigate to Setup > Import/Export > Import CSV Records
    • Import Type > Custom Records
    • Record Type > NetLease Custom Calendar Period

  • Map the data from your CSV to the NetSuite Fields as shown below:

  • Click "Next" then run the import to finish setting up the custom calendar.

2) Applying custom calendars to NetLease records

  • With custom calendars enabled in the NetLease System Setup, a new box appears on the NetLease Type record for "Default Custom Calendar":

  • A new field also becomes available on the NetLease Lease record on the accounting subtab for "Custom Calendar":

  • To apply a custom calendar to all leases of a certain type, select a custom calendar in the "Default Custom Calendar field on the lease type record. This can be overridden at the individual lease level. 
  • To apply a custom calendar only to specific leases, leave the "Default Custom Calendar" field on the type record blank and select the custom calendar on the individual lease records. Select the custom calendar to be used on the lease prior to generating the lease schedule to apply the custom calendar.




Was this article helpful?