Importing bank statements into epicor bank reconciliation

How do you build a SC WF?

we do have it in excel format.

Hello,


Several of our companies using Epicor have hundreds of checks each month and they'd like to import the bank statement into the bank rec module to speed up the Cleared Check process.


Has anyone done any type of import or update into bank statements to clear checks?


If I missing something in standard functionality, please let me know.


Thanks


Only thing I could think of the top of my head would be to build a SC WF to import all your statements into E9. Do you have them on CSV, Excel, XML?
 
Kind Regards,
Sergio P. 
CTO, Sr. Partner
Kind Regards,
Sergio P.

Mayan Technologies USA, Inc.
(858) 900.1555
sprieto@...




On Wednesday, March 25, 2015 9:50 AM, "john.gillenwater@... [vantage]" <vantage@yahoogroups.com> wrote:


 
<div id="ygrps-yiv-1984394689yiv2015853135ygrp-text">
  
  
  <div></div><div><span>Hello,</span></div><div><span><br clear="none"></span></div><div>Several of our companies using Epicor have hundreds of checks each month and they&#39;d like to import the bank statement into the bank rec module to speed up the Cleared Check process.</div><div><br clear="none"></div><div>Has anyone done any type of import or update into bank statements to clear checks?</div><div><br clear="none"></div><div>If I missing something in standard functionality, please let me know.</div><div><br clear="none"></div><div>Thanks</div><div><br clear="none"></div>

</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135 -- #ygrps-yiv-1984394689yiv2015853135ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-mkp #ygrps-yiv-1984394689yiv2015853135hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-mkp #ygrps-yiv-1984394689yiv2015853135ads {
margin-bottom:10px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-mkp .ygrps-yiv-1984394689yiv2015853135ad {
padding:0 0;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-mkp .ygrps-yiv-1984394689yiv2015853135ad p {
margin:0;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-mkp .ygrps-yiv-1984394689yiv2015853135ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-sponsor #ygrps-yiv-1984394689yiv2015853135ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-sponsor #ygrps-yiv-1984394689yiv2015853135ygrp-lc #ygrps-yiv-1984394689yiv2015853135hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-sponsor #ygrps-yiv-1984394689yiv2015853135ygrp-lc .ygrps-yiv-1984394689yiv2015853135ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135activity span {
font-weight:700;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135activity span span {
color:#ff7900;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135activity span .ygrps-yiv-1984394689yiv2015853135underline {
text-decoration:underline;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 .ygrps-yiv-1984394689yiv2015853135attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 .ygrps-yiv-1984394689yiv2015853135attach div a {
text-decoration:none;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 .ygrps-yiv-1984394689yiv2015853135attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 .ygrps-yiv-1984394689yiv2015853135attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 .ygrps-yiv-1984394689yiv2015853135attach label a {
text-decoration:none;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 .ygrps-yiv-1984394689yiv2015853135bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 .ygrps-yiv-1984394689yiv2015853135bold a {
text-decoration:none;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 dd.ygrps-yiv-1984394689yiv2015853135last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 dd.ygrps-yiv-1984394689yiv2015853135last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 dd.ygrps-yiv-1984394689yiv2015853135last p span.ygrps-yiv-1984394689yiv2015853135yshortcuts {
margin-right:0;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 div.ygrps-yiv-1984394689yiv2015853135attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 div.ygrps-yiv-1984394689yiv2015853135attach-table {
width:400px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 div.ygrps-yiv-1984394689yiv2015853135file-title a, #ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 div.ygrps-yiv-1984394689yiv2015853135file-title a:active, #ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 div.ygrps-yiv-1984394689yiv2015853135file-title a:hover, #ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 div.ygrps-yiv-1984394689yiv2015853135file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 div.ygrps-yiv-1984394689yiv2015853135photo-title a, #ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 div.ygrps-yiv-1984394689yiv2015853135photo-title a:active, #ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 div.ygrps-yiv-1984394689yiv2015853135photo-title a:hover, #ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 div.ygrps-yiv-1984394689yiv2015853135photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 div#ygrps-yiv-1984394689yiv2015853135ygrp-mlmsg #ygrps-yiv-1984394689yiv2015853135ygrp-msg p a span.ygrps-yiv-1984394689yiv2015853135yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 .ygrps-yiv-1984394689yiv2015853135green {
color:#628c2a;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 .ygrps-yiv-1984394689yiv2015853135MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 o {
font-size:0;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135photos div {
float:left;width:72px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135reco-category {
font-size:77%;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135reco-desc {
font-size:77%;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 .ygrps-yiv-1984394689yiv2015853135replbq {
margin:4px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-mlmsg select, #ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 input, #ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-mlmsg pre, #ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 code {
font:115% monospace;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-mlmsg #ygrps-yiv-1984394689yiv2015853135logo {
padding-bottom:10px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-msg p#ygrps-yiv-1984394689yiv2015853135attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-reco #ygrps-yiv-1984394689yiv2015853135reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-sponsor #ygrps-yiv-1984394689yiv2015853135ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-sponsor #ygrps-yiv-1984394689yiv2015853135ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-sponsor #ygrps-yiv-1984394689yiv2015853135ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1984394689 #ygrps-yiv-1984394689yiv2015853135 #ygrps-yiv-1984394689yiv2015853135ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1984394689



Since the checks are on a list sheet, export the list sheet to excel, do a vlookup from the statement and update the cleared checkbox based on the vlookup. Then paste update.

Charlie Smith
ESSNER Manufacturing, L.P.
6651 Will Rogers Blvd.
Fort Worth, TX 76140
csmith@...<mailto:csmith@...>
ph: (817) 529-6165
fx: (817) 568-2625
[LOGO_Essner_Manufacturing]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 25, 2015 4:30 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] importing bank statements into epicor bank reconciliation


Only thing I could think of the top of my head would be to build a SC WF to import all your statements into E9. Do you have them on CSV, Excel, XML?

Kind Regards,
Sergio P.
CTO, Sr. Partner
Kind Regards,
Sergio P.

Mayan Technologies USA, Inc.
(858) 900.1555
sprieto@...
www.mayantechs.com<http://www.mayantechs.com/>



On Wednesday, March 25, 2015 9:50 AM, "john.gillenwater@... [vantage]" <vantage@yahoogroups.com> wrote:


Hello,

Several of our companies using Epicor have hundreds of checks each month and they'd like to import the bank statement into the bank rec module to speed up the Cleared Check process.

Has anyone done any type of import or update into bank statements to clear checks?

If I missing something in standard functionality, please let me know.

Thanks





[Non-text portions of this message have been removed]