CSV Import Manual for Legacy Transactions

This guide explains the process of importing historical transactions using the CSV Import feature. It is designed for clients transitioning from a previous fiscal supplier and is intended for one-time use only to ensure compliance with fiscal regulations. 

1. Introduction

• Purpose: The CSV Import feature allows clients to upload past transactions that occurred before integrating their current fiscal system.  
• Important Limitation: This option can only be used once. Afterward, all invoices should be processed through regular fiscalization methods. 
• Warning: If prior invoices exist in the system, it may cause a failure in closing the fiscal day, requiring intervention from the revenue authority. 

2. Document Format

• The file must be in UTF-8 CSV format.
• Each row in the document corresponds to a single line item on an invoice, including details about the buyer and invoice information. 
• The CSV file must contain 23 specific columns that follow the guidelines outlined below. 

3. Key Columns Overview

Here are some of the key columns and their required details: 

Optional Columns: 

• TIN: Tax Identification Number (10 digits).
• VAT Number: VAT number (9 digits).
• Reference: Optional reference for the invoice (e.g., order number).
• Discount: Discount amount for the line item (optional).
• Credited Invoice: For credit notes, reference the invoice being credited.
• Reason: Reason for issuing a credit note (optional for invoices).

4. Important Guidelines

• Credit Notes: For credit notes, you must include the Credited Invoice column to link it to the original invoice.  
  
• Fiscal Day: Make sure the import occurs on a fresh fiscal day without any previously submitted transactions. Request that the fiscal day be manually closed after the import.

5. Uploading the Document  

Steps: 

1. Login to the Fiscal Harmony Application.

2. Navigate to the CSV Upload menu. If this option is unavailable, contact your service provider          for   access.  

3. Click Pick a CSV file to select your file (must be under 2MB). 

4. The system will check for formatting errors and display any issues for correction. A maximum        of 50 errors can be shown at a time.

6. Fiscalization Process 

• After successfully uploading, the user can proceed with fiscalizing invoices.
• If errors occur during fiscalization, a CSV file containing the failed transactions will be available for download.
• For successfully processed invoices, a zipped folder containing all the fiscal documents can be downloaded.

Error Handling:

• A checkbox titled Stop If Error Occurs allows users to halt the process at the first fiscalization error or continue processing successful invoices while generating a separate error log.  
  

This knowledge base serves as a comprehensive guide to ensure accurate and efficient CSV imports for legacy transactions. Following these steps carefully will minimize errors and ensure compliance with fiscal authorities.