Fiscal Calendar Import

Modified on Tue, 1 Jul at 10:32 AM

How to Import a Fiscal Calendar

Summary:

This guide walks you through downloading the import template, preparing your fiscal calendar data, and successfully importing it into Cora. Follow the formatting rules carefully to avoid errors during the import process.

 

Step-by-Step Instructions

  1. Download the Template

·         Go to Administration > Business Planning > Fiscal Calendar.

·         Click the “Export” button to view the correct format.

Note: Do not delete or reorder columns—even if unused. 

Column headers in red are required.

  1. Prepare Your Data

·         Clear any existing data in the file, but retain the column headers.

·         Populate the file using the rules below:

Field

Requirements

FiscalPeriods

Values 1–13

StartDate

Format: YYYYMMDD

Must not exist in current records

Must follow the previous EndDate + 1

EndDate

Format: YYYYMMDD

Must not exist in current records

Must be ≥ StartDate

Quarter

Values 1–4

  1. Import the Data

·         Go to Administration > Business Planning > Fiscal Calendar.

·         Click “Import”.

·         Select “Choose File” and upload your file.

  1. Review Messages

·          Success: File is correctly formatted.

·         ⚠️ Warning: Pop-up will explain issues. Update and re-upload if needed.

·         If successful, click “Import” to complete.

  1. Verify Your Data

·         Review your newly imported fiscal calendar records to confirm accuracy.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article