Guides
Excel se Proaqsa ERP tak, ek weekend mein
Saat kadam, kisi salahkar ki zaroorat nahi. Bas tithi chunna hi thoda kathin hai.

Shuruaat se pehle dhyaan dein
Excel chhodna ek tithi par saaf badlaav (cut-over) hai, puraane data ka roopantaran nahi. Ek tarikh ke balance aage laaiye aur usi din se naye document bhariye; purana workbook sirf padhne layak sangrah ban jaata hai.
- Mahine ki pehli tarikh lijiye, taaki vivaran aapas mein mel khaayein.
- Pehle se baant lijiye ki kaun kya bharega: item (maalik), partner (accountant), opening stock (store).
- Workbook mitaaiye nahi; ek hafte tak usi se tulna hogi.
Saat kadam
Kaam ka kram.
- 1. Badlaav ki tithi
Mahine ka pehla din. Usse pehle ka koi bhi lenden document ke roop mein nahi bhara jaata.
- 2. Soochiyan saaf
Item aur partner ke alag-alag code; dohraav hataiye; band ho chuke naamon par nishaan lagaiye.
- 3. Company banaiye
Dekhiye: account kaise banayein.
- 4. Mool jaankari
Base unit aur packaging ke saath item, graahak/supplier role ke saath partner, aur locations.
- 5. Opening balance
Stock, partner, bank aur nakad ke liye dekhiye opening balance ki margdarshika.
- 6. Saath chalne wala hafta
Har bikri, kharid aur receipt ERP mein post kariye; saatvein din dono ke jod milaaiye.
- 7. Excel ko vida
Workbook ko read-only kar dijiye. Vishleshan karna ho to ERP se export kar lijiye.
Aksar hone wali bhoolein
- Purana itihaas document bana kar bharna — sirf balance bhariye, pichhle varsh ke invoice nahi.
- Poore mahine dono systems ko "live" rakhna — saath chalane ke liye ek hafta paryaapt hai.
- Unit aur packaging ki setting taal dena — pehli kharid se pehle ise sahi kar lijiye.
Aarambh
Apni muft company abhi banaiye.
FAQ
Aksar puchhe jaane wale sawal
Kya item kisi file se import ho sakte hain?
Ji haan, agar aapke plan aur role mein yah suvidha ho to Items Import/Export sheet se spreadsheet ke zariye item, unke unit, daam aur opening stock samet, load kiye ja sakte hain. Graahak aur supplier partner form par apne opening balance ke saath jode jaate hain.
Opening balance galat bhar diya to kya karein?
Opening tithi par vivaran (narration) ke saath ek sudhaar wala journal voucher post kariye; pehli entry record mein jas ki tas rehti hai.