Hi Neil Cooper Sage 50 ,

Thank you for reaching out, and my apologies for the delayed response. Regarding your question about the Sage 2024.1 payroll and converting the output for CIBC's requirements, I have good news. Although Sage 50 typically generates .DAT files for payroll, these files are essentially text files and can be renamed to .txt for easier access. The .DAT files that Sage generates for EFTs are already in a standard format that many banks, including CIBC, should recognize.

For your specific scenario, CIBC requires a Data Centre number, which is supported by Sage's EFT file format. You can follow the instructions outlined in our knowledgebase to change your payroll bank account and generate EFT .DAT files. Once you've created the file, you can rename the extension to .txt or .csv if needed. Please ensure that the format complies with CIBC's requirements for processing.

Here are the steps for generating the EFT .DAT file:

1. Complete the initial setup for EFT if not already done.
2. Navigate to File > Import/Export > Upload Direct payments > Employee Direct Deposit options after posting all deposit cheques.
3. After selecting the cheques and clicking Upload, save the EFT Direct File to your computer.

For a more detailed guide and troubleshooting, refer to the full articles on our support site:

• Changing the bank account for payroll cheques
• Generating EFT .DAT files
• Understanding the EFT generated .DAT files

If you need further assistance with the file conversion or have any additional questions, please don't hesitate to reach out. If this helps, please mark it as verified :)

Warm Regards,
Erzsi