For the past 2 weeks we've been having trouble with EFT payroll transactions, after it was integrated into SAGE50 (following last update).
We are getting rejected transactions every time an EFT file is uploaded to our bank, after much investigation we found through careful examinatio of the EFT files what was going on.
For employees that have more than one transaction (for example: someone leaving and getting leave pay), EFT generates transactions with duplicate payment numbers when using RBC's Standard (STD152) Debit File Format ( https://www.rbcroyalbank.com/ach/file-451773.pdf ), field #7, columns 41-42. RBC payroll support helped us find this problem. SAGE50 tech support then suggested using the CPA Standard 005.
After testing the result EFT file, it turned out to be invalid. Guided by RBC, it was determined there were extra blank lines.Even removing them the file was still invalid and rehected by RBC. The long waiting time and the multiple resources involved on our side to wait on the phone, wait for call backs, investigate, test and keep track of all this is absurd.
Is anyone else having these problems? Using SAGE50 latest version, its payroll EFT feature and RBC should not be that uncommon in Canada, has anyone had resolution for this? What other options or solutions are possible other than waiting forever on the phone? A timely software fix seems unlikely at this point, and it will be the third week we have to prepare several payments manually and deal with employees communications, clarifications, cancelling/updating transactions manually etc.