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
- 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.
- 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 |
- Import the Data
· Go to Administration > Business Planning > Fiscal Calendar.
· Click “Import”.
· Select “Choose File” and upload your file.
- 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.
- 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
Feedback sent
We appreciate your effort and will try to fix the article