Payroll Direct Deposit using RBC Express, File Transfer

SUGGESTED

Does anyone here use RBC File Transfer to upload payroll direct deposits? When I click on upload, Sage takes me to the Worldline Authentication screen. Apparently Worldline is optional, but I can't get past this screen. Is there an option to choose your file format in settings? RBC Express wants me to change some text in the file and upload it using RBC Express, File Transfer.

Thanks, Susan

  • 0

    Hi

    Thanks for reaching out. Did you ever find an answer to your question?

    You have two options in Sage 50 Canada for payments processing, you can either use "Direct Payments" (requires a Bambora sign on, if this is selected then the Worldline login screen is what you see) and or EFT Direct setup (see this video for details). Note that EFT is an add-on purchase to your Sage 50 Canada subscription, contact our sales team at 1-888-261-9610 for details.

    I've mostly heard of a EFT - DAT file transfer for Payroll Direct Deposit with RBC, here's an article with details on setup. 

    Most likely, your product settings are set as:

    If you are still looking for guidance, please let us know and we can try to point you in the right direction or suggest some resources or next steps.

    Warm Regards, 
    Erzsi

  • 0

    After file transmission, TD takes out the total lump sum of the payroll but Sage has it individually.  Is there a way to have it show as one lump sum in Sage rather than individually?  It makes it very difficult when it comes to reconciling the bank.

  • 0 in reply to Daniela@ABPaving
    SUGGESTED

    Hi Daniela:

    I would suggest to have your payroll post to a Payroll Clearing account rather than the Bank account. First create a Payroll Clearing Account and categorize(Type) it as a Bank. In Setup, Settings, Payroll, Linked Accounts, change the bank account to the Payroll Clearing Account and save. Make a journal entry every pay for the total of the payroll to be taken out of the Bank. This should solve your problem!