How to Update Payroll Banking Information Using CSV Upload – ZonePayroll Knowledge Base

Purpose: This method is recommended for acquisitions, mass onboarding, or large-scale banking changes involving multiple employees.

🛈 Important: Data Validation Validate Before Cutoff: CSV uploads directly affect payroll payments. Ensure all updates are completed and verified before your payroll processing deadline to avoid payment errors.

📘 Best Practices & Warnings

Internal IDs: Always double-check employee Internal IDs; a typo here can map banking data to the wrong person.
Sandbox Testing: If available, always run a test import in your Sandbox environment first or a single employee first.
Secondary Accounts: Remember that secondary accounts require a value in the Amount column, whereas Primary accounts do not.

Related to

Step-by-Step Instructions	Screenshot / Visual
Step 1: Navigate to Import CSV Records Using the Payroll Administrator role: A. Go to Payroll > Payroll Setup. B. Select Import CSV Records.	Navigation path to Import CSV Records
Step 2: Configure Import Type Set the following initial configurations: • Import Type: Custom Records • Record Type: Payroll Bank Account 🛑 Critical Warning: Do not select Payroll Bank Payment History. You must select Payroll Bank Account.	Scan & Upload CSV File
Step 3: Prepare the CSV File Ensure your CSV includes these required columns: • A: Employee Internal ID • B: Employee's Name •C: Bank Account Name • D: BSB Number (5-digits) • E: Bank Account Number • F: Institution Code (3-digits) • G: Start Date •H: Account Status (Primary/Secondary) •I: Account Status Primary Secondary (Add amount in column J) if secondary.	Prepare your CSV File
Step 4: Set Import Options On the Import Options screen, select: • Data Handling: Add or Update. • Custom Form: Standard Payroll Bank Account. • Advanced: Log system notes (Checked); Validate mandatory custom fields (Unchecked).	2. Import Options screen with specific checkboxes
Step 5: Review Field Mapping Fields should auto-map. If Employee Internal ID does not map: A. Click the pencil icon next to the field. B. Manually select Internal ID from the list.	Steps 3 & 4: Field Mapping
Step 6: Save, Run, and Validate Submit the import and wait for the confirmation. 2. Post-Import Checklist: Confirm Primary account status. Verify Start Dates are correct. Check a sample of 3-5 employee records.	Successful Import confirmation message