How import works

• Every transaction row in the sheet is saved to the transactions table. Rows with a duplicate Transaction ID are skipped automatically.
• Rows that also carry a "Total Gross Payout" batch total are additionally saved to the payouts table (Bank Reference, Gross Payout, Settlement Fee, Net Payout, Settlement Date).
• Both LKR and USD settlement sections in the same file are read automatically.
• Re-uploading the same file will not create duplicate rows.