Product Help and Support
What's newVideo tutorialsFAQsContact support
  • Product Guides
  • Clear Finance Cloud
    • 📢Release Notes - Clear Finance Cloud
    • GST Compliance
      • GSTR-1 Filing
      • GSTR-3B Filing
      • GSTR-6 Filing
      • GSTR-7 Filing
      • GSTR-8 Filing
      • ITC-04 Filing
      • GSTR-9 Filing
      • GSTR-9C Filing
      • GSTR-1 vs SR Recon
      • GSTR-2B vs PR Recon
      • Ewb vs G1 Recon
    • E-Invoicing
      • ClearE-Invoicing Video Tutorials
      • Authorising Clear to generate IRN
      • Get started with ClearE-Invoicing
        • Account Setup
          • Create an account
          • Register Defmacro as GSP
          • Set up Business Unit
          • Upload Documents
          • Generate IRN
        • Quick Start Guide
          • Add new members to account
          • Add additional GSTINs/Branches
          • Add NIC Credentials
          • Add UPI ID for B2C QR Code
      • E-Invoicing
        • Upload Data
          • User Guides
            • Upload E-Inv Data - Government Template
            • Upload E-Inv Data - Custom Template
          • FAQs
        • E-Invoice Generation
          • User Guides
          • FAQs
        • E-invoice Cancellation
          • User Guide
          • FAQs
        • E-Invoice Printing
          • User guides
          • FAQs
        • Downloading e-invoices
        • E-Invoice Email
        • Import History
        • E-Inv Vs Sales Reconciliation
        • B2C QR Code
          • FAQs
      • E-Way Bills
        • Eway bill data upload
          • User guides
            • IRN based Eway bill (B2B)
            • Unified template to generate E-way bill for any document type
        • E-Way Bill Generation
        • Multi-Vehicle E-way Bill
        • Consolidated E-Way Bill
        • Update Transporter of E-way bills
        • Printing an E-Way Bill
        • Extend the validity of an e-Way bill
        • Filter by Blank Transporter ID or Vehicle Number
      • Filtering expiring e-Way bills
      • Settings/Configurations
        • ClearIRP API credentials
          • How do I register my GSTIN on ClearIRP from Clear eInvoicing?
          • How do I create API creds if my GSTIN is already registered?
          • I have already created API credentials for my GSTIN, how do I add them?
          • FAQs
        • NIC Credentials
        • Integration Settings
        • E-Way Bill Settings
        • Import Settings
        • Email Settings
        • Business Settings
        • Contact Master
        • User Roles
        • Copy of User Roles
      • E-Invoice & E-way bill error resolution
      • Tally Connector for E-Invoicing
        • Installation
        • User Manual
      • Help
      • FAQs
      • What's new in ClearE-Invoicing
    • ClearID
  • For Enteprises
    • ClearGST
      • ClearGST Video Tutorials
      • Get started with ClearGST
        • Account Setup
          • Add new members to business
          • Install ClearTax Assistant
        • Quick Start Guide
          • Filing Dashboard
          • GSTIN Verification
          • Collect GSTIN of customers
          • Import Data
      • Generate Reports
        • Comparison Reports
          • GSTR-3B vs 1 Comparison Report
          • GSTR-3B Vs 2A Comparison Report
        • Purchase and 2A/2B/6A/4A Reports
          • Multi-month GSTR-2A Report
          • Multi-month GSTR-2B Report
          • GSTR-4A Report
          • Supplier Compliance Reports
        • Sales and G1
          • Rate wise Sales Summary Report
          • Sales HSN Summary Report
          • GSTR-1 Rate wise Summary Report
          • GSTR-1 HSN Summary Report
        • PAN Level Reports
          • PAN Level Multi-Month GSTR-2B Report
        • ITC Cash Ledger Reports
          • Cash Ledger Reports
          • ITC Ledger Reports
        • Tax Saving Reports
          • GSTR 3B vs 1 vs Books Report
          • GSTR 3B vs 2B vs Books Report
        • Filed Reports
      • Reconciliation
        • GSTR-1 vs Sales Register Matching
        • GSTR-2A Vs PR GSTIN Matching
        • GSTR-2A Vs PR PAN Matching
        • GSTR-2B Vs PR GSTIN Matching
        • GSTR-1 Vs E-Way Bill Matching
        • GSTR-9 (Table-8A) Vs PR Matching
      • File Returns
        • GSTR-1
        • GSTR-3B
        • GSTR-4
        • GSTR 6
        • GSTR-9
        • GSTR-9C
      • Tally Connector for GST
        • Prerequisites to Configure Tally for GST
        • Configuring Tally for GST
        • User Manual for GST Tally Connector
        • Common Tally Errors and Resolution
          • Connection issues with Tally
            • Firewall issues for Tally Connector
          • Errors in data imported via Tally
            • Mismatch in Total CGST Value
            • Mismatch in Reverse Charge
            • Mismatch in Export Type
            • Length of Import Bill of Entry Number
            • Invalid receiver GSTIN
            • Mismatch in Seller GSTIN and State
            • Invalid HSN/SAC Code
      • FAQs
        • Get started
        • Data Import
        • File Returns
        • Generate Reports
        • Reconciliation
      • What's new in ClearGST
    • ClearMax ITC
      • Get started with ClearMax ITC
      • Max ITC Reconciliation
        • Data Import
      • ITC Claim Wizard
      • Actions after running recon
      • Extra Functionalities
      • Vendor Payments
      • Table 4 changes
      • FAQs
    • ClearCapture
      • Get started with ClearCapture
        • Register Defmacro as GSP
        • Create an account
        • Add a Business Unit
        • Add GSTIN credentials
        • Add NIC credentials
        • Import invoices
        • Review invoices
        • Export invoices
        • Smart Aggregation
        • Export Issues
      • FAQ's
    • ClearTDS
      • TDS Returns
        • Prepare TDS Return
        • e-Filing TDS Returns
        • e-filing 24Q4 return
          • Form 24Q4 - Original return
          • Form 24Q4 - Correction return
        • Corrections to TDS Returns
      • Other Features
        • Filing Status Dashboard
        • Repository
        • Import and Track LDCs
        • Import Challans
        • ClearTDS Reports
        • Generate Form 16 and other TDS certificates
        • Settings
        • Retrieve Username Password in ClearTDS
        • LDC_Challan Tagging
      • 26AS Recon
        • Product Guide - 26AS Recon
    • ClearTax E-Invoicing KSA
      • Product Guides
        • Onboarding on ClearTax
        • Onboarding for E-Invoicing
        • Exploring the e-Invoicing homepage
        • Onboarding a new device (Online)
        • Onboarding a new offline device for PoS terminals
      • e-Invoicing with ClearTax on NCR-Aloha
        • Prerequisites for offline e-Invoice application
        • Create an account on ClearTax
        • Onboarding on web portal for e-Invoicing
        • Downloading and installing the offline e-Invoice application
        • Device registration on the PoS terminal
        • Generating e-Invoices and printing
      • Product Updates
      • ZATCA Updates
        • ZATCA Violations
        • ZATCA E-invoicing for Wave 2 customers announced
        • ZATCA Portal and APIs are going live
        • New SDK version update released by ZATCA
        • ZATCA Announces the Cancellation of Fines and Penalties
        • New SDK version update released by ZATCA
    • ClearTax E-Invoicing Malaysia
      • Onboarding
        • Create your profile
        • Register your business
      • B2B sales documents
        • Import your data
        • Generate e-invoice(s)
        • Generate consolidated e-invoice
        • Audit Trail
        • Delete imported data
        • Cancel an e-invoice
        • View rejection request
        • Print e-invoice(s)
        • Download report
        • E-mail invoice
        • Check sales import history
      • Purchase documents
        • Import data
        • Generate self-billed e-invoice(s)
        • Cancel a self-billed e-invoice
        • Print e-invoice(s) & download report
        • Check purchase import history
      • MIS Dashboard
      • Reconciliations
        • Reconciliation logic
        • Sales Register vs E-invoice Reconciliation
        • Purchase Register vs E-invoice Reconciliation
      • Settings
        • User access management
        • Custom Ingestion Template
        • Alerts and Communications
        • E-invoicing
          • Timezone
      • E-Invoicing customer portal
        • Registration & account creation
        • Generate your e-invoice
        • Download/Print generated e-invoice
      • Resources
        • Frequently asked questions (FAQs)
        • Error resolution guide
        • Add ClearTax as an intermediary on MyInvois portal
    • Clear Invoicing
    • Platform
      • SSO
    • Our APIs
  • For SMEs
    • ClearGST
      • ClearGST Video Tutorials
      • Get started with ClearGST
        • Account Setup
          • Add new members to business
          • Install ClearTax Assistant
          • Configuring Tally
        • Quick Start Guide
          • Filing Dashboard
          • GSTIN Verification
          • Collect GSTIN of customers
          • Import Data
      • Generate Reports
        • Comparison Reports
          • GSTR-3B vs 1 Comparison Report
          • GSTR-3B Vs 2A Comparison Report
        • Purchase and 2A/2B/6A/4A Reports
          • Multi-month GSTR-2A Report
          • Multi-month GSTR-2B Report
          • GSTR-4A Report
          • Supplier Compliance Reports
        • Sales and G1
          • Rate wise Sales Summary Report
          • Sales HSN Summary Report
          • GSTR-1 Rate wise Summary Report
          • GSTR-1 HSN Summary Report
        • PAN Level Reports
          • PAN Level Multi-Month GSTR-2B Report
        • ITC Cash Ledger Reports
          • Cash Ledger Reports
          • ITC Ledger Reports
        • Tax Saving Reports
          • GSTR 3B vs 1 vs Books Report
          • GSTR 3B vs 2B vs Books Report
        • Filed Reports
      • Reconciliation
        • GSTR-1 vs Sales Register Matching
        • GSTR-2A Vs PR GSTIN Matching
        • GSTR-2A Vs PR PAN Matching
        • GSTR-2B Vs PR GSTIN Matching
        • GSTR-1 Vs E-Way Bill Matching
        • GSTR-9 (Table-8A) Vs PR Matching
      • File Returns
        • GSTR-1
        • GSTR-3B
        • GSTR-4
        • GSTR-6
        • GSTR-9
        • GSTR-9C
      • FAQs
        • Get Started
        • File Returns
        • Generate Reports
        • Reconcilliation
      • What's new in ClearGST
    • ClearOne Suite
      • Get Started with ClearOne Suite
        • Account Setup
        • Quick Start Guide
          • Add Customers
          • Add Items
      • ClearInvoicing
      • ClearCompliance
        • ClearE-Invoicing
          • Create NIC Credentials
          • Add NIC Credentials
          • E-Invoice Generation
        • ClearE-WayBills
          • E-Way Bill Generation
      • FAQs
  • For Tax Experts
    • ClearPro Suite
      • ClearGST
        • ClearGST Video Tutorials
        • Get started with ClearGST
          • Account Setup
            • Add new clients
            • Add new members to Business
            • Install ClearTax Assistant
            • Configuring Tally
          • Quick Start Guide
            • Filing Dashboard
            • GSTIN Verification
            • Collect GSTIN of customers
            • Import Data
        • Generate Reports
          • Filed Reports
          • Tax Saving Reports
            • GSTR 3B vs 1 vs Books Report
            • GSTR 3B vs 2B vs Books Report
          • ITC Cash Ledger Reports
            • Cash Ledger Reports
            • ITC Ledger Reports
          • PAN Level Reports
            • PAN Level Multi-Month GSTR-2B Report
          • Sales and G1
            • Rate wise Sales Summary Report
            • Sales HSN Summary Report
            • GSTR-1 Rate wise Summary Report
            • GSTR-1 HSN Summary Report
          • Comparison Reports
            • GSTR-3B vs 1 Comparison Report
            • GSTR-3B Vs 2A Comparison Report
          • Purchase and 2A/2B/6A/4A Reports
            • Multi-month GSTR-2A Report
            • Multi-month GSTR-2B Report
            • GSTR-4A Report
            • Supplier Compliance Reports
        • Reconciliation
          • GSTR-1 vs Sales Register Matching
          • GSTR-2A Vs PR GSTIN Matching
          • GSTR-2A Vs PR PAN Matching
          • GSTR-2B Vs PR GSTIN Matching
          • GSTR-1 Vs E-Way Bill Matching
          • GSTR-9 (Table-8A) Vs PR Matching
        • File Returns
          • GSTR-1
          • GSTR-3B
          • GSTR-4
          • GSTR-6
          • GSTR-9
          • GSTR-9C
        • FAQs
          • Get Started
          • File Returns
          • Generate Reports
          • Reconcilliation
        • What's new in ClearGST
      • ClearTDS
        • Get started with ClearTDS
          • Retrieve Username Password in ClearTDS
        • TDS Returns
          • Prepare TDS Return
          • e-Filing TDS Returns
          • Corrections to TDS Returns
          • Revise TDS Returns
        • Generate Form 16 in ClearTDS
      • ClearTaxCloud
        • FAQs
      • ClearPro Desktop App
        • Import Data using Desktop App
        • File Returns on Desktop
          • GSTR-1 on Desktop App
          • GSTR-1 NIL Return on Desktop App
          • GSTR-3B on Desktop App
          • GSTR-3B Nil Return on Desktop app
          • GSTR-4 on Desktop App
          • GSTR-9 on Desktop App
          • GSTR-9C on Desktop App
        • Create a Challan and Pay Tax
  • For Individuals
    • File ITR
      • File ITR on ClearTax
      • FAQs
    • Invest and Save
      • FAQs
    • Expert Assistance
      • FAQs
  • Other Support Links
  • Video Tutorials
  • FAQs
  • ClearLearn
  • Contact support
Powered by GitBook
On this page
  • Custom data mapping as part of Ingestion workflow
  • Custom data mapping via settings section
  • Addition of custom fields
  1. For Enteprises
  2. ClearTax E-Invoicing Malaysia
  3. Settings

Custom Ingestion Template

PreviousUser access managementNextAlerts and Communications

Last updated 9 months ago

The product provides standard templates in which invoice data can be entered and ingested into the product.

However, if you have a data file with required data but in your own format then you can create a custom ingestion template by mapping the file headers with standard templates and use this to ingest invoice data directly.

The following section explains how to get custom data ingestion mapping done.

Custom data mapping as part of Ingestion workflow

  • Once you have added business, completed onboarding, and have the data file ready, please go to upload file section

  • In the upload section, please select whether you want to map purchase data or sales data

  • Click on the “Select a file to import” button to choose a file from your system to ingest.

If you do not have the template, you can download the B2B and B2C template using the download option in the bottom right corner

  • You can ingest the file that contains the required headers to be mapped with the standard template using the import flow as explained in the earlier section

  • In the template selection dropdown, select “Create Custom Template” option and click on “Check file for errors & duplicates”

The file is processed, the processing may take some time depending on the file size

  • Once the file is processed and ingested, the custom mapper screen is displayed, in which you can see the column header name from the standard template.

  • Map the column header in the standard template with the corresponding column header in the file ingested. Make sure that correct headers are mapped. You can also search the required header using the search bar. Bar at the top of the table shows the number of fields - required, mapped, unmapped.

  • The required headers are highlighted in red. All the required headers need to be mapped, then only the template can be saved. Once all the desired headers from the files have been mapped, you can save the template by clicking on the “Save template” button. Auto filled template name is shown which can be changed if required.

  • The newly created custom template is saved and the ingestion process continues with running the validation on the invoice file and checking duplicates.

  • This mapped template will now be visible under the templates section once the mapping is done for any future ingestion. You can select this template to upload data in this format going forward

Custom data mapping via settings section

You can create a custom ingestion template during the ingestion and directly from the settings section as well.

  • Go to settings section - you can find it towards the bottom left side on the menu

  • Select the type of template you want to create from the Template dropdown, whether it is for B2B or B2C

  • Select the business (TIN) for which this template is to be created. The created template would be available only for the selected business

  • All the created custom templates will be shown in the table along with other details for the template. You can edit the template by clicking on “Edit” under actions. If you want to delete the template, click on 3 dots on the right side of actions and select “Delete template”.

Addition of custom fields

  1. Apart from the required fields that are allowed by the government, if you wish to pass additional fields in the invoice data during ingestion, you can set up custom fields using this setting.

  2. The custom fields set up for a template and business will be checked during data import. Only the fields part of standard/custom ingestion template or custom fields will be ingested on the product

Steps to create custom fields -

  • Select the type of template for which you want to add the custom fields from the Template dropdown, whether it is for B2B or B2C

  • Select the business (TIN) for which this template is to be created. The created custom field would be available only for the selected business

  • You can set up line level and document level custom fields. Enter the header name of the custom field column under the “Label for custom field” and click on save.

  • By default 5 custom fields are shown, more can be added by clicking on “Add new custom field”. For deleting a custom field, click on 3 dots under actions and click on “Delete custom fields”

You can click on “Create Template” and follow the steps mentioned in the “Custom data mapping as part of Ingestion workflow” to create a new template.

section