How to Import Schedule 9 Data Using an Accountant ID

Created by Himanshu Arya, Modified on Thu, 10 Oct, 2024 at 4:53 PM by Mansi Thakur

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

Let us know how can we improve this article!

Select at least one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article