Topic Options
#60621 - 04/17/19 08:47 AM Importing RBC Statements
Eva_Froese Offline
Adagio Expert

Registered: 09/22/06
Posts: 794
Loc: MB
Since we are discussing importing bank statements...Does anyone know if RBC has the OFX option by now? or how are you uploading statements for RBC?


Edited by Andrew Bates (04/17/19 09:16 AM)
Edit Reason: Changed topic
_________________________
Eva Froese
ChoiceTech Accounting Solutions
eva@choicetech.ca

Top
#60623 - 04/17/19 12:41 PM Re: Importing RBC Statements [Re: Eva_Froese]
Lauren Stief Offline
Adagio Padawan

Registered: 09/13/12
Posts: 437
Loc: Waterloo, ON
Hi Eva,

I'm not sure if RBC has the OFX option yet, but we have clients exporting a text file from RBC/RBC Express and importing it as a CSV into BankRec. We are using the CSV option since it still allows the client to use the import statement option from within the reconciliation window. While you can setup a template with an excel file format, you have to go to File|Import|Bank Statements to do the imports.

Lauren
_________________________
Lauren Stief
Stief Group
Adagio Solutions and Support
1-800-540-3164

Top
#60626 - 04/17/19 02:38 PM Re: Importing RBC Statements [Re: Lauren Stief]
Dan_Desautels Offline
Adagio Maestro

Registered: 07/21/11
Posts: 1144
Loc: Thunder Bay, ON, Canada
Eva/Lauren:
RBC Express has the OFX option. I have two clients who use it and I have logged in with them and seen it myself.
RBC also has it as an option in the regular business banking as well.
_________________________
Dan Desautels
DezTek Solutions Inc.
Thunder Bay, ON

Top
#60663 - 04/19/19 06:03 PM Re: Importing RBC Statements [Re: Dan_Desautels]
Brian Stief Offline
Waterloo Guy

Registered: 04/04/06
Posts: 1713
Loc: Waterloo, Ontario, Canada
Hi Eva,
RBC has 2 types of account services. RBC Express and the other as Dan has suggested.

OFX version normally is the same as downloading as Quickbooks or Sage 50. If you don't see OFX, choose the quickbooks version.

RBC used to have an issue with the CSV versions but you can make work with the OFX.

Best,
Brian
_________________________
Brian Stief,CPA,CA
Stief Group www.stiefgroup.com
Link2 Systems www.link2systems.com
800.540.3164

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 21 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1846 Members
5 Forums
14234 Topics
69701 Posts

Max Online: 359 @ 11/18/19 09:08 PM
April
Su M Tu W Th F Sa
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30