1 / 7

DATA CLEANING THROUGH DB ANALYZER

Dive into effective data cleaning techniques for DB Analyzer with our comprehensive guide outlining 34 critical exercises. This resource highlights common discrepancies in account management, such as indices without entries, zero account numbers, and ledger entry inconsistencies. By addressing issues like incomplete data, incorrect codes, and discrepancies in service charges, organizations can enhance data accuracy and integrity. Streamline your data management processes and prevent future issues with these actionable insights tailored for finance professionals working with accounts.

rafer
Download Presentation

DATA CLEANING THROUGH DB ANALYZER

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DATA CLEANING THROUGH DB ANALYZER

  2. DB Analyzer – 34 Points of exercise SB/MIS/PPF/RD/TD/SCSS • 1.Index with zero account no. • 2.Index entries with open date 01.01.1900 • 3.Ledger entries prior to account open date • 4.Index entries different PO code • 5.Accounts without names of depositors • 6.Account numbers with blank account type

  3. 7.Account no. without previous year interest entries • 8.Ledger entries with zero account no. • 9.Ledger entries with LOT date 01.01.1900 • 10.Account no. with zero Nomination no. • 11.Ledger entries with different PO code • 12.Account without address of depositors • 13.Account no. with blank account status • 14.Accounts for which Service charge have been deducted

  4. 15.Index entries without ledger entries • 16.MIS discrepancy • 17.Accounts with wrong amount in SI register • 18.Accounts having no ledger entries • 19.Accounts with fractions • 20.Default entries discrepancy • 21.Accounts with different months counts • 22.Accounts with more than one entry in SI register • 23.Ledger entry discrepancy

  5. 24.RD bulk list not posted • 25.Paid/Unpaid discrepancy • 26. Accounts for which interest calculated is zero • 27. Accounts with difference of amount in index & ledger • 28. Account no. with SI without previous quarter interest withdrawal • 29. accounts with SI which TDS deducted automatically ( 15G/15H not submitted 2008-09)

  6. 30. Account no. for which TDS exemption has been given • 31. Account nos. with incomplete ledger entries • 32. Account nos. with withdraw type but not in SI entries • 33. Account nos. with SI having withdrawal entries with future dates • 34. Account nos. in SI register having closed/transferred SB accounts.

  7. Thank You

More Related