Financial Period Setup & Import

For Manual Financial Period Setup See G/L Module -> Financial Period Setup

Navigate to the System Settings module and click the menu Setup -> Financial Period Import. Click the button to download the template. The template displays in the form of a spreadsheet. Fill in the information in each of the columns for each financial period you’d like to import.

When finished, click the Test Import File button.

The system alerts you to any errors in the template so that you can fix them in the spreadsheet, resave it, remove the file from the import screen using the x Remove button then re-select the corrected template to upload it.

Repeat the process until the system gives you a successful message that the import test passed.

Click the button “Import File” and the system provides you a success message that the period has been imported.

To view the financial periods imported, click the menu Setup -> Financial Period Setup. Scroll through the data and the imported periods display.

Import Template

Column Name	Example	Format and Data Source	Mandatory/ Optional
Financial Period	2021-04	YYYY-MM as setup by the system administrator	Mandatory
Quarter	3	Numeric value for the quarter number being 1, 2, 3, or 4.	Mandatory
Start Date	04/01/2021	MM/DD/YYYY as per the date format setup by the administrator for US or Europe formats	Mandatory
End Date	04/31/2021	MM/DD/YYYY as per the date format setup by the administrator for US or Europe formats	Mandatory