How do we process or push Journal data to Tally?

A step by step guide to manage, update and transfer journal data from Suvit to tally. Simply prepare your excel sheet, upload and map the required fields & then proceed to transfer those journal entries in tally.


How to push data to tally in Journal:

1.jpg

Process Screen will look like the above image.

 **Note**: Words in Blue have selected one, and words in Orange are not selected.

General Filters

2.jpg

  1. The informative "i" button will show you the number of total transactions and the total number of invoices.

  2. General Filters: Here, you can use three different filters.

  • a. Hide Tally Synced Records: This filter can hide already pushed data from your processing screen.
  • b. Saved Records: It will allow you to see only saved data.
  • c. Blank Records: It will filter out any blank data.
  1. Date: Here, you can filter the date range, for example, if you want to filter a specific date range to send data to Tally.

  2. Warning Triangle: This will appear when there is any data that is mismatched with Tally data. You can click on that triangle to see the unselected field of that particular record.

  3. Data in orange will indicate which data has not been auto-selected.

Bulk Operations

3.jpg

  1. Update Bulk Records: Here, you can select the type of data that can be updated in bulk, such as Voucher Type and Particulars.

4.jpg

  1. You can select the ledger accounts based on your type selection.

5.jpg

  1. You can use this option to select your records in bulk.

  2. In the given search box, you can search for other Journal types if you have created them.

  3. In the given box, you can search for Reference No according to your Excel data.

  4. Particulars: In the given box, you can search for Particulars according to your Excel data.

  5. Here, you can search the Debit/Credit part and also alter them.

  6. The final Amount can be checked here.

  7. You can use the Delete button to delete unwanted data.

How to save and push the data

6.jpg

  1. As per the image, you can select all transactions using the bulk options or use the filter to select the desired transactions.

  2. After selecting the transactions, click on the Save button.

7.jpg

  1. Select all transactions again using bulk options, or you can use the filter and re-select the desired transactions selected in Step 14.

  2. Use the Send Transaction button to push the data into Tally.