Katusome IDEA practice datasets v3 (fictional data for training only).
Company: Kampala Trading Co. Ltd (fictional). As-at date: 31 Dec 2025.

IDEA import settings. CSV: File, Import Assistant, choose Text (delimited). Character set ASCII/ANSI. Record delimiter CR LF. Field separator comma. Text encapsulator double quote. Tick 'First visible row is field names'. Set every *_DATE field to type Date with mask YYYY-MM-DD, every *_TIME field to type Time with mask HH:MM:SS, ID, account, phone and TIN fields to Character, and amounts to Numeric. Blank dates are empty and are allowed. XLSX or XLS: Import Assistant, Microsoft Excel, select the sheet named Data, tick 'First row is field names'. Dates are real Excel dates. If the Excel import gives trouble, use the .xls (Excel 97-2003) file or the CSV. IDEA Educational imports at most 5,000 records per database; every file here is within that limit (transactions has exactly 5,000). Troubleshooting: if IDEA crashes when opening an imported database, close IDEA, delete that database (.IMD file) from the project folder, and re-import the CSV as Text with the settings above.

Read data_dictionary.pdf for every field. Use control_totals to prove your imports are complete.
