Cheque Register Export
This comma-separated values (.CSV) file lists the amounts for all cheques issued during the last pay calculation. This report includes the amounts for employees who have been paid using the Electronic Funds Transfer (EFT) feature. Note: If you do not print cheques or create an EFT file, this report will not break down employee amounts because it requires a cheque number or a bank number to assign the amounts to this register.
Data Columns
Each column and row shows specific data for each employee who was included in the payroll calculation.
- payDate - This column shows the payroll's Pay Date as defined in the Payroll Processing - Calculations screen.
- payRun - This column shows the payroll's Year, Sequence Number, and Run Number as defined in the Payroll Processing - Calculations screen.
- employeeName - This column shows each employee's Surname and Given Name as defined the Employee - Setup Employee screen.
- employeeNumber - This column shows each employee's Employee Number as defined the Employee - Setup Employee screen.
- employeeChequeNumber - This column shows the cheque number that was assigned to each employee if the employee was paid by manual cheque.
- employeeChequeAmount - This column shows the employee's total Net Pay amount for the current pay period if the employee was paid by manual cheque.
The following columns shows individual bank account settings for each employee. These settings can be edited in the Employee - Bank Accounts screen.
- employeePrimaryEftAccount - This column shows the employee's Primary bank, Transit ID, and Account number.
- employeePrimaryEftAmount - This column shows the amount of Net Pay that was deposited into the employee's Primary bank account, if the employee was paid by EFT/Direct Deposit.
- employeeSecondaryEftAccount - This column shows the employee's Secondary bank Transit, ID and Account number.
- employeeSecondaryEftAmount - This column shows the amount of Net Pay that was deposited into the employee's Secondary bank account, if the employee was paid by EFT/Direct Deposit.
- employeeOtherEftAccount - This column shows the employee's Other bank Transit, ID and Account number.
- employeeOtherEftAmount - This column shows the amount of Net Pay that was deposited into the employee's Other bank account, if the employee was paid by EFT/Direct Deposit.
See Also