← AI in CA practice
Col. P · Case
FAR.
Fixed asset register and verification
Problem
Fixed asset registers arrived as spreadsheets that did not tie to the ledger. Physical verification sheets were matched by hand, and depreciation schedules were rebuilt every year.
OutcomeRegister-to-ledger differences surface on day one instead of at sign-off.
What it does
- Imports the client register and ties it to the trial balance
- Computes depreciation under the Companies Act and the Income-tax Act
- Generates verification sheets by location
- Matches verification results back to the register
- Produces the schedules for the audit file
Built with: Python and Excel output, self-built
Screenshot to be supplied
Screenshot to be supplied