Friday, October 20, 2017

Map excel and import in Tally ERP 9

How to map your excel file and import it into Tally ERP 9?

Here's a video on how to map excel file and import it in Tally ERP 9

For reference, the steps are given underneath :

Steps to Map your Excel file
  1. Start udi-Magic converter
  2. Select the option Excel to Tally > Create a Custom template
  3. Select the files :
    • udi-Magic Standard Excel template
    • Your Excel file
  4. Map the columns
  5. Save the Mapping file

Steps to Import data into Tally
  1. Start Tally ERP 9 and Open a Company.
  2. Start udi-Magic software.
  3. Select the option Excel to Tally > Import data into Tally.
  4. Select the files
    • Your Excel file
    • Xml file (Mapping file generated in the mapping process)
  5. Click the Start button.

Wednesday, October 18, 2017

udi-Magic v8.0 Release 3.4

Excel to Tally templates
Applicable to : udi-Magic v8.0 Release 3.4
Description : Compatible with Tally ERP 9 Release 6.1.1

NEW FEATURES
udi-Magic v8.0 Release 3.4
 now supports Trade Discount feature which allows you to specify the discount value for each item in the invoice, and the discount value is considered as part of the assessable value of an item.

The Trade discount feature is available in the following Excel formats :
a. Vouchers-V8-Sales-Purchase-Basic.xls
b. Vouchers-V8-Sales-Purchase.xls

In addition to the Trade discount feature, some modifications are done in other templates as shown underneath.

TEMPLATEs  (Modifications)

1. Vouchers-V8-Sales-Purchase.xls
The following new fields/features have been added in this template :

Field : IsAlternateUnitApplicable
Desc : This is useful when you are using alternate units in Tally ERP 9. You must specify Yes to use alternate units.

Values : Yes or No
Default Value : No

Remarks:
a. This option comes under "Other Settings"
b. You must use the EnableDisableFeatures sheet to show / display the columns for "Other Settings"

2. Vouchers-V8-Sales-horizontal-format-without-stockitems.xls
The following new fields/features have been added in this template :
  • Buyer Name
  • Addr Line1
  • Addr Line2
  • Addr Line3
  • State
  • Place of Supply
  • GST Regn Type
  • GSTIN
3. Vouchers-V8-Purchase-horizontal-format-without-stockitems.xls
The following new fields/features have been added in this template :
  • Supplier Name
  • Addr Line1
  • Addr Line2
  • Addr Line3
  • State
  • Place of Supply
  • GST Regn Type
  • GSTIN
4. Vouchers-V8-Journal-with-multiple-references.xls
This template now supports 10 ledgers with references. Earlier there was provision to specify 5 ledgers only.

Old template Name : Vouchers-V7-Journal-with-multiple-references.xls
New template Name : Vouchers-V8-Journal-with-multiple-references.xls



Saturday, September 30, 2017

udi-Magic v8.0 Release 3.3

Excel to Tally templates
Applicable to : udi-Magic v8.0 Release 3.3

TEMPLATEs  (Modifications)

Vouchers-V8-Sales-Purchase.xls
The following new fields/features have been added in this template :

1. Group Names
This allows you to specify the Group/parent Name for Party Ledgers, Sales/Purchase and Taxes ledgers; and StockItems. The default values are :

Party Ledgers : Default group is Sundry Debtors (or Sundry Creditors)
Sales Ledgers : Default group is Sales Accounts
Purchase Ledgers : Default group is Purchase Accounts
Tax Ledgers : Default group is Duties & Taxes
StockItems : There is no default StockGroup (i.e. it is kept empty)

2. Tax Classification details (Override at Voucher level)
This feature allows you to specify / override the Tax-type and Tax-rates at the Voucher-level.

Notes
a. Tally ERP 9 allows you to define / specify the tax rates at different levels viz Ledger level; StockItem level; Company level etc.
b. If you are using Sales / Purchase with Inventory, then it is advised that you specify the tax-rates at the StockItem level.
c. If you are using Sales / Purchase without Inventory, then the tax-rates must be specified at the ledger level.
d. You can override the tax-type; tax-rate; taxable amount at the Voucher level using this feature.

3. Voucher Class
A new column has been kept to specify the Voucher class.

Wednesday, September 20, 2017

udi-Magic v8.0 Release 3.2

Bugs Fixed

1. Error : "Voucher totals do not match"

Applicable to (Template-Names)
Vouchers-V8-Sales-Purchase.xls
Vouchers-V8-Sales-Purchase-basic.xls

Cause of Error
The aforesaid error occurs when Freight / Courier / shipping charges ledger is specified in Sales Invoice which has different tax-rate from the tax-rate applicable to the Stockitems in that Sales Invoice,

Solution
The aforesaid bug has been rectified and the revised templates are available in udi-Magic v8.0 Release 3.2

References:
How to add Freight, Courier, Service charges along with StockItems in Sales Invoice in Tally ERP?

PS:
You can download (all latest templates for udi-Magic v8.0) the zip file from this link :
https://github.com/ShwetaSoftwares/standard-templates/archive/master.zip

Saturday, September 16, 2017

Duplicate States in B2C (Small) Invoices in GSTR-1 in Tally ERP

Recently, we noticed that the GSTR-1 report displays duplicate State names in the table B2C (Small) Invoices. Here's a screen snapshot of it.



The aforesaid problem occurs when Sales data is imported using udi-Magic Software wherein the State Name is specified in mixed letters. Example: GUJARAT, Gujarat, gujarat.

Solution
This problem has been rectified in the udi-Magic v8.0 Release 3.1

Templates Modified
The following templates have been modified :
Vouchers-V8-Sales-Purchase.xls
Vouchers-V8-Sales-Purchase-basic.xls
Vouchers-V8-Sales-Horizontal-format-without-stockitems.xls
Vouchers-V8-Purchase-Horizontal-format-without-stockitems.xls

Important Note
Though it is not yet confirmed by Tally Solutions-Bangalore, this problem prima facie, looks likes a bug in the GST Reports (as Tally ERP is not case sensitive).


Tuesday, September 12, 2017

Template modifications

Excel to Tally templates
Applicable to : udi-Magic v8.0 Release 3.0
Description : Compatible with Tally ERP 9 Release 6.1 - Original Sales details not specified error rectified

TEMPLATEs  (Modifications)

1. Vouchers-V8-Sales-Purchase.xls
The following new fields/features have been added in this template :

a. URD-ORIGINAL-SALE-VALUE (under Additional GST details for Credit / Debit Notes)
b. If the Party GSTIN is NOT specified, then the GST Registration type (in Tally) is set as Unregistered (instead of empty)

2. Master-StockItemMaster.xls
The following new fields/features have been added in this template :

a. Price levels (upto 10 price levels)

Remarks:
You can now upload Price levels using the Masters-StockItem sheet itself. However, the Price-levels must exist in Tally and are NOT created automatically.

3. The following templates include facility to hide / show columns and are now protected (no password required to unprotect) :

a. Vouchers-V8-Sales-Purchase.xls
b. Masters-StockItemMasters.xls
b. Masters-LedgerMaster.xls

Remark:
You must enable Macros to hide / show columns in the aforesaid templates

TEMPLATEs  (removed)

1. Master-V6-StockItem-Multiple-price-levels.xls
2. Vouchers-Flipkart-Receipts-and-Journal.xls

Remarks:
Though these template are discontinued, they are still available within the sub-folder named "templates-discontinued".

Saturday, September 2, 2017

Template modifications

Excel to Tally templates
Applicable to : udi-Magic v8.0 Release 2.9
Description : Compatible with Tally ERP 9 Release 6.1

TEMPLATEs  (Modifications)

1. Vouchers-V8-Sales-Purchase.xls
The following new fields/features have been added in this template :

Additional GST details (Nature of Return for Debit/Credit Notes)
a. Nature of Return
b. Supplier's Debit/Credit Note No
c. Date
Buyer details
a. State
b. Place of Supply
c. GST Regn Type
d. GSTIN
Other Settings
a. IsCancelled
b. IsOptional
Overwrite/Update existing Masters (Warning : May result in data loss)
a. Update StockItem Masters

Remarks:
The template Vouchers-V8-Sales-Purchase.xls contains macros. You must enable macros to hide / show the columns using the EnableDisableFeatures sheet.

2. Master-UnitMaster.xls
The following new fields/features have been added in this template :
a. Decimal Places
b. UQC (Unit Quantity Code)

3. Master-LedgerMaster.xls
a. Re-grouping of fields/columns
b. Hide or Show fields/columns

4. Vouchers-V8-Sales-Purchase-Basic.xls  &  Vouchers-V8-Sales-Purchase.xls
To specify Freight or other ledger(s) before Taxes :
   - Keep the Item-Name and PartNo empty/blank;
   - Specify the Amount; and the Sale/Purchase LedgerName
   - Refer sample data in the aforesaid templates

You can download (all latest templates for udi-Magic v8.0) the zip file from this link :
https://github.com/ShwetaSoftwares/standard-templates/archive/master.zip