Help Toolbar   (select a button to browse other online help sections) Home  Index  Tutorials  Resources  Search  Tabs & Menus  Button Bar  Table & Data Display

---

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.

View step-by-step tutorial

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

• Reports Overview
  
  
• Payroll Reports
  • Payroll reports help page
  • Payroll report types
  • Creating a basic report
  • Creating a report with custom settings and date ranges
  • Creating employee pay statements
  • Emailing employee pay statements
  • Creating an EFT
  • Creating ROEs
  • Creating a report using the Customized Views feature

• HR Reports
  • HR reports help page
  • Creating an HR report
  • Creating a report with custom settings and date ranges
  • Creating a report using the Customized Views feature