Combine EFT Files?

SUGGESTED

Is there a way in Sage 50 to combine multiple EFT files from different companies into one that gets sent to the bank?  We run separate payroll for each of our 3 companies but pay from one bank account.  In Sage 300 we are able to combine the files to make 1 large one but I don't see that option in Sage 50.

  • 0
    SUGGESTED

    Hi  ,

    Thanks for reaching out with your query about combining multiple EFT files in Sage 50. Unfortunately, there isn't a direct feature within Sage 50 to merge EFT files from different company files into a single one, as Sage 50 does not inherently support exporting or merging transactions between multiple company files. This differs from your experience with Sage 300.

    However, there's a manual workaround described in the article titled "How to edit an eft file". It suggests manually combining .DAT EFT files using a text editor like Notepad. Here's a brief summary of the steps:

    1. Locate all the .DAT EFT files you want to combine.
    2. Open each file with Notepad.
    3. Copy and paste the data from each file into a new Notepad document.
    4. Save the new document as a .DAT file.

    Please note, manually modifying EFT files can be sensitive and may lead to the files being rejected by your bank. It's crucial to ensure that the combined file adheres to your bank’s file format requirements. If you encounter any submission problems after modifying the EFT file, I recommend contacting your banking institution for assistance.

    As an alternative, you might consider reaching out to a Sage Development Partner for a specialized solution. They might be able to develop an add-on that automates this process for you.

    I hope this helps point you in the right direction. If you need further guidance or have other questions, please let us know.

    Warm Regards,
    Erzsi