I need to manually import bank activity daily and I need to know what column set up is needed.
I need to manually import bank activity daily and I need to know what column set up is needed.
If you are in a current subscription with Sage, go to the banking tab and click on BANK FEEDS at the top of the page. Sign up with your bank and start downloading your transactions right into the reconciliation.
Kind regards,
Shirley
Shirley Byard-President| Sage 50 MASTER Certified Consultant and Certified Trainer
Office Hours: Monday- Friday, 9am-6pm
[email protected] ️304-233-2612 ️ BestBusinessStrategies.com
Software Solutions: ●Sage 50 ●Act CRM
Add-ons: ●MFG Software●Merchant Services●Sales Tax●Auto Entry ●POS●Report Solutions
Services: ●Data Repair●Conversions●Purging●Year End Changes●BBS Support Minutes●BEG 101 Training Class
Other Business Solutions: ●Checks & Forms ●Remote Data Backup ●Remote Desktop ●Cloud Hosting
Follow us:Facebook, Blog Schedule a Sage 50 Demo Price Match Guarantee
I have some templates that can help with that. The layouts will depend on the transaction types you are importing. Also, you can setup the bank feed, that has a way to enter the transactions into the system from the bank feed and could be useful. Reach out and I can show you what that would look like and share the templates. [email protected]
I appreciate the response. Capital One Intellix doesn't connect with bank feed. If you have a template that would be helpful. Bank allows me export csv file. I tried creating payment journal insage 50.
Yes, I can send you a template to import the activity. We just assisted a client importing their Amex activity, it was 800+ rows and worked great. Send me an email and I can share it. [email protected]
Hi Charles,
Did you ask Sage to add your bank? I asked for my bank and they did. The Bank Feeds are wonderful.

Shirley Byard-President| Sage 50 MASTER Certified Consultant and Certified Trainer
Office Hours: Monday- Friday, 9am-6pm
[email protected] ️304-233-2612 ️ BestBusinessStrategies.com
Software Solutions: ●Sage 50 ●Act CRM
Add-ons: ●MFG Software●Merchant Services●Sales Tax●Auto Entry ●POS●Report Solutions
Services: ●Data Repair●Conversions●Purging●Year End Changes●BBS Support Minutes●BEG 101 Training Class
Other Business Solutions: ●Checks & Forms ●Remote Data Backup ●Remote Desktop ●Cloud Hosting
Follow us:Facebook, Blog Schedule a Sage 50 Demo Price Match Guarantee
I just tried.
What about the import? You could download there and simply import it to Sage 50.
*Community Hub is the new name for Sage City