Follow these steps to import Schedule 9 data into the system using your accountant ID:
1. Log in
link- https://finance.mvmerp.in
Log in to the portal with your accountant ID.
2. Access Schedule 9/Stock Reporting
link- https://finance.mvmerp.in/pages/StoreStockReport.aspx
Locate the icon labeled "Schedule 9/Stock Reporting" and click on it.
3. Select Store as Fixed Assets
From the drop-down menu, select "Fixed Assets" under the "Store" option.
4. Choose Current Date
Choose the current date in the relevant field.
5. Filter by Category
In the "Filter By Category" drop-down, select "All".
6. Click Go
Click the "Go" button.
7. Export Template
In the Import/Export section, click on "Export Template". This will download an Excel sheet for you to fill in the required data. Below are instructions on how to properly fill in each column of the sheet:
Instructions for Filling the Excel Sheet:
Serial Number (S. No.)
Enter a unique serial number for each item, starting from 1 and incrementing consecutively (e.g., 1, 2, 3).
Date of Purchase
Enter the purchase date of the item in dd-mm-yyyy format. Any other format will not be accepted during upload.
Description
Enter the name or description of the item (e.g., computer, chair).
Group Head
Enter the group head to which the item belongs (e.g., Furniture and Fixture, Electrical Equipment, etc.).
Quantity (Qty)
Input the quantity of the items using only numbers. Do not use characters or symbols (e.g., enter 1, 2, 3).
Rate
Enter the price per single item. Ensure that only numbers are used, with no characters (e.g., 100, 250).
Estimated Value
Enter the total value of the items. For example, if two items are bought at ₹50 each, the value would be 100 (2 x 50). Use numbers only.
Status
Write the status of the item (e.g., in use or damaged).
Location
Specify the current location of the item.
Physically Verified
Input the date the item was physically verified in dd-mm-yyyy format. No other formats are allowed.
Marked Item Code
Enter the specific code of the item, if applicable.
Remarks
Add any remarks or additional information about the item.
Important Notes:
1. Multiple entries in any cell separated by commas (,) are not allowed.
- Each cell must contain a single entry only.
2. Date format:
- Use the format dd-mm-yyyy for dates. No other format is accepted for the Date of Purchase and Physically Verified columns.
3. Quantity (Qty), Rate and Estimated Value:
- these fields should contain numbers only. Do not use any characters or symbols.
**Make sure you adhere to the format and instructions mentioned above to avoid errors during the upload process.
Final Steps for Import:
1. After filling out the Excel sheet, return to the Import/Export section.
2. Click on "Choose File", select your completed file from your computer, and click "Import".
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article