ꯁꯦꯇꯤꯡ ꯑꯃꯁꯨꯡ ꯁꯦꯚ ꯇꯧꯔꯕ ꯗꯦꯇꯥ › ꯍꯦꯜꯞ › ꯕꯤꯖꯅꯦꯁ, ꯄꯥꯔꯇꯤ ꯑꯃꯁꯨꯡ ꯑꯥꯏꯇꯦꯝ

Excel ꯗꯒꯤ ꯑꯥꯏꯇꯦꯝ, ꯄꯥꯔꯇꯤ ꯑꯃꯁꯨꯡ ꯑꯣꯄꯅꯤꯡ ꯕꯦꯂꯦꯟꯁ ꯏꯝꯄꯣꯔꯠ ꯇꯧꯕ

ꯑꯥꯏꯇꯦꯝ ꯅꯠꯇ꯭ꯔꯒ ꯀꯁ꯭ꯇꯃꯔ ꯂꯤꯁꯤꯡ ꯀꯌꯥꯒ ꯂꯣꯌꯅꯅ ꯍꯧꯔꯤꯕꯔꯥ? Excel ꯐꯥꯏꯜ ꯑꯃ ꯃꯄꯨꯡ ꯐꯥꯍꯅꯗꯨꯅ ꯏꯝꯄꯣꯔꯠ ꯇꯧꯕꯤꯌꯨ꯫ ꯀꯔꯤꯒꯨꯝꯕ ꯑꯃꯠꯇ ꯁꯦꯚ ꯇꯧꯗ꯭ꯔꯤꯉꯩꯗ ꯅꯍꯥꯛꯅ ꯔꯣ ꯈꯨꯗꯤꯡꯃꯛ, ꯁꯤꯡꯅꯕ ꯑꯃꯠꯇꯒ ꯂꯣꯌꯅꯅ ꯎꯏ꯫

ꯁ꯭ꯇꯦꯞ ꯑꯃꯃꯃꯒꯤ

1. Import from Excel ꯍꯥꯡꯗꯣꯛꯄꯤꯌꯨ꯫ ꯑꯩꯒꯤ ꯗꯦꯇꯥ › Backup and other devices › Import from Excel (Customers ꯑꯃꯁꯨꯡ Items ꯁꯦꯛꯁꯅꯗꯁꯨ ꯂꯩ)꯫
2. ꯑꯍꯥꯡꯕ Excel ꯐꯥꯏꯜ ꯗꯥꯎꯅꯂꯣꯗ ꯇꯧꯕꯤꯌꯨ꯫ ꯃꯁꯤꯗ ꯁꯤꯠ ꯑꯍꯨꯝ ꯂꯩ: Items, Parties ꯑꯃꯁꯨꯡ Opening balances, ꯑꯍꯥꯅꯕ ꯔꯣꯗ ꯍꯦꯗꯤꯡꯒ ꯂꯣꯌꯅꯅ꯫
3. ꯃꯄꯨꯡ ꯐꯥꯍꯅꯕꯤꯌꯨ꯫ ꯑꯥꯏꯇꯦꯝ ꯅꯠꯇ꯭ꯔꯒ ꯄꯥꯔꯇꯤ ꯈꯨꯗꯤꯡꯃꯛꯀꯤ ꯔꯣ ꯑꯃ꯫ ꯁꯤꯇꯀꯤ ꯃꯃꯤꯡ ꯑꯃꯁꯨꯡ ꯍꯦꯗꯤꯡꯁꯤꯡ ꯊꯝꯕꯤꯌꯨ꯫ ꯑꯣꯄꯅꯤꯡ ꯕꯦꯂꯦꯟꯁꯀꯤ ꯃꯈꯜ: Receivable, Payable, Cash ꯅꯠꯇ꯭ꯔꯒ Bank꯫
4. Excel ꯐꯥꯏꯜ ꯈꯟꯕꯤꯌꯨ꯫ App ꯅ ꯃꯁꯤ ꯄꯥꯗꯨꯅ Found … items, … parties and … opening balances ꯎꯠꯂꯤ, ꯔꯣ ꯈꯨꯗꯤꯡꯃꯛꯀꯤ What will happen ꯒ ꯂꯣꯌꯅꯅ: Will be added ꯅꯠꯇ꯭ꯔꯒ Already saved: will be updated꯫
5. ꯁꯤꯡꯅꯕ ꯂꯩꯕ ꯔꯣꯁꯤꯡ ꯁꯦꯃꯒꯠꯄꯤꯌꯨ ꯅꯠꯇ꯭ꯔꯒ ꯊꯥꯗꯣꯛꯄꯤꯌꯨ꯫ ꯁꯤꯡꯅꯕ ꯂꯩꯕ ꯔꯣꯁꯤꯡ (ꯑꯔꯥꯅꯕ GSTIN, ꯈꯉꯗꯕ ꯁ꯭ꯇꯦꯠ ꯀꯣꯗ, ꯗꯤꯖꯤꯠ 4, 6 ꯅꯠꯇ꯭ꯔꯒ 8 ꯅꯠꯇꯕ HSN, GST ꯔꯦꯠ ꯅꯠꯇꯕ) ꯂꯤꯁ꯭ꯠ ꯇꯧꯗꯨꯅ ꯊꯥꯗꯣꯀꯏ꯫
6. ꯏꯝꯄꯣꯔꯠ ꯇꯧꯕꯤꯌꯨ꯫ Import … rows ꯅꯝꯕꯤꯌꯨ꯫

ꯇꯧꯔꯕ ꯈꯨꯗꯝ

ꯑꯥꯏꯇꯦꯝ 240, ꯄꯥꯔꯇꯤ 85 ꯑꯃꯁꯨꯡ ꯑꯣꯄꯅꯤꯡ ꯕꯦꯂꯦꯟꯁ 30 ꯂꯩꯕ ꯐꯥꯏꯜ ꯑꯃ: ꯆꯦꯛ ꯇꯧꯔꯕꯗ ꯔꯣ 3 ꯗ ꯁꯤꯡꯅꯕ ꯂꯩ ꯍꯥꯌꯏ (GSTIN ꯏꯕꯗ ꯑꯁꯣꯏꯕ ꯑꯃ, ꯗꯤꯖꯤꯠ 5 ꯂꯩꯕ HSN ꯑꯃ, ꯍꯧꯖꯤꯛ 18% ꯗ ꯂꯩꯕ ꯑꯥꯏꯇꯦꯝ ꯑꯃꯒꯤ 28% ꯔꯦꯠ)꯫ Excel ꯗ ꯁꯦꯃꯒꯠꯇꯨꯅ ꯐꯥꯏꯜ ꯑꯃꯨꯛ ꯈꯟꯕꯤꯌꯨ: "All rows look fine"꯫ ꯔꯣ 355 ꯏꯝꯄꯣꯔꯠ ꯇꯧꯕꯤꯌꯨ꯫

ꯌꯥꯝꯅ ꯊꯣꯀꯄ ꯑꯁꯣꯏꯕ ꯑꯃꯁꯨꯡ ꯁꯦꯃꯒꯠꯄꯒꯤ ꯃꯑꯣꯡ

• ꯑꯔꯤꯕ .xls ꯐꯥꯏꯜ꯫ Excel ꯗ File › Save As › Excel Workbook (.xlsx) ꯁꯤꯖꯤꯟꯅꯕꯤꯌꯨ꯫
• ꯕꯤꯖꯅꯦꯁ ꯂꯩꯇꯅ ꯑꯣꯄꯅꯤꯡ ꯕꯦꯂꯦꯟꯁ꯫ ꯑꯍꯥꯅꯕꯗ ꯅꯍꯥꯛꯀꯤ ꯕꯤꯖꯅꯦꯁ ꯍꯥꯄꯆꯤꯟꯕꯤꯌꯨ; ꯑꯣꯄꯅꯤꯡ ꯕꯦꯂꯦꯟꯁꯁꯤꯡ ꯃꯁꯤꯒꯤꯗꯃꯛ ꯁꯦꯚ ꯑꯣꯏ꯫

ꯃꯔꯤ ꯂꯩꯅꯕ ꯍꯦꯜꯞ

ꯁꯦꯇꯤꯡ ꯑꯃꯁꯨꯡ ꯁꯦꯚ ꯇꯧꯔꯕ ꯗꯦꯇꯥ ꯒꯤ ꯍꯦꯜꯞ ꯄꯨꯝꯅꯃꯛ · Nivesh Sahayak App ꯀꯤ ꯍꯦꯜꯞ