๐Ÿงพ How to Prepare Depreciation Schedule

  1. ๐Ÿ“ฅ Download the CSV template provided (if any).
  2. ๐Ÿ“ Open the CSV file in Excel or any spreadsheet software.
  3. Edit the details as per your requirement:
    • Asset Name
    • Opening Value
    • Addition (if any)
    • Sale Amount (if any)
    • Days (holding period in FY)
    • Asset Group (choose from the predefined categories)
  4. ๐Ÿ’พ Save the file in CSV format.
  5. โฌ†๏ธ Upload the updated CSV file into the system.
  6. ๐Ÿ“Š Click "Generate Schedule" to view depreciation.
  7. ๐Ÿ–จ๏ธ Click "Print Schedule" if you need a hard copy or PDF.

โ“ FAQs:

Q1: What file format is supported?
A: Only .csv files (CSV format) are supported.

Q2: What is the purpose of the Days column?
A: It helps determine half or full depreciation under the Income Tax Act.

Q3: Can I edit depreciation rates?
A: Rates are predefined. Custom rates not yet supported.

Q4: Why is the sale amount adjusted automatically?
A: Sale is capped to avoid negative base.

Q5: How do I print the schedule?
A: Use the "๐Ÿ–จ๏ธ Print Schedule" button after generating the report.

๐Ÿ“š More FAQs:

1. What is a depreciation schedule?
A depreciation schedule tracks the reduction in value of fixed assets over time.

2. Who should use this tool?
Company accountants, CAs, and business owners who need to calculate depreciation for tax/audit purposes.

3. Can I calculate depreciation under both Acts?
Yes! You can choose either Income Tax Act or Companies Act rates.

4. What type of file is needed?
A properly structured .csv file. Sample format is available for download.

5. Is my data stored?
No. Data is processed on server and not stored or shared.

6. More asset categories?
You can edit PHP code to add new asset categories and rates.

7. Can I print the schedule?
Yes. After generation, the Print button appears for easy output.

๐Ÿ”™ Back