Mapping excel sheet data of Journal with SUVIT configuration

After uploading the excel sheet of journal, you need to map those data according to its tally required field. Here we will guide you to successfully map your journal sheet.


Mapping Screen for journal data in SUVIT

Journal Mapping

  1. Imported file header from your Excel sheet.

  2. Assign Tally Fields:

  • For example, map Journal number as Reference no and Invoice value/Total value as Amount.
  1. This section will show you the top 3 values of your sheet data to help you assign the correct Tally field.
    Note: If you can't see any data from your sheet, please check the format of your data in the sheet and correct it.

  2. Other Ledger Mapping:
    Here, you can add different debit & credit amounts (e.g., Round Off, discount, freight charges, etc.) by selecting the appropriate file header and ledger.

  3. Reset: This option can be used to reset the mapping.

  4. Save & Proceed: This will take you to the process screen.

  5. Save Mapping: This option allows you to save the particular format with Suvit. Once saved, Suvit will pre-map the fields if the same format is uploaded again.

Item Allocation Field in Configuration

Item Allocation

  • If your journal includes items, go to Configuration → the Item Allocation field.
  • Refer to the above image for guidance.

You may find this useful:

  • To learn how to process the journal sheet,Learn More