Mapping excel sheet data of Journal with SUVIT configuration

After uploading a journal Excel sheet in Suvit, map the data to Tally-required fields. This guide helps you complete the journal mapping process smoothly.

šŸ–¼ļø Mapping Screen Overview

Journal Mapping

  1. Excel Headers

    → Suvit shows the column names from your uploaded Excel sheet.

  2. Assign Tally Fields

    → Link your Excel columns with the correct Tally fields. → Example: → Journal number → Reference no → Invoice value / Total value → Amount

  3. Top 3 Values from Sheet

    → Suvit shows top 3 sample entries to help you confirm the match is correct.

→ If no data shows up, check your Excel format — something might be off.

  1. Other Ledger Mapping

    → You can also map extra fields like: → Round-off → Discount → Freight Charges

→ Just select the correct column and link it with the right ledger.

  1. Reset Button

    → Made a mistake? Click this to clear and re-map everything.

  2. Save & Proceed

    → After mapping, click this button to go to the processing screen.

  3. Save Mapping

    → Want to save time next time? Save this mapping format and Suvit will remember it.


āš™ļø Item Allocation in Configuration

Item Allocation

  • If your journal has items, go to Configuration.

    → Then find and enable the Item Allocation field.

    → This makes sure item-wise details are recorded properly.


šŸ“˜ You May Find This Useful:

Want to learn how to push journal data to Tally? šŸ‘‰ Learn More