Payroll Direct Deposit [SMC WIRE FABRICATORS]

Yahoo Archive
1
There is a script that has been written by someone else. I have written a
full fetured VB program that takes the file(s) exported by Vantage and
cretes an ACH file that is exepted by banks. It is free to anyone who needs
it.





-----Original Message-----
From: Rick Spriggle [mailto:rspriggle@...]
Sent: Thursday, August 15, 2002 9:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Payroll Direct Deposit [SMC WIRE FABRICATORS]


If I remember correctly the particular VB script everyone is referring to
was pasted as text to the bottom of a message since attachments aren't
allowed on this group. If you search the archives for "direct deposit" you
can probably find the message, then copy the code from that message and
paste it into a new file.

Hope this helps,

Rick



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
Hi Group,

We have begun evaluating payroll direct deposit and I am hoping you can help
in this process. From what I have gathered so far from our bank (US Bank),
is that the only format that they will accept is the NACHA formatted ACH
file standard. If this be the case has anyone been successful in generating
a file based on this format? Or is anyone familiar with a conversion
application that could take the raw date and manipulate it to meet these
standards. Do I even mention the Custom Programming route?
Any help would be much appreciated. Thanks in advance to all those gracious
enough to respond!!!

In Christ
Randy Vander Galien
IS Manager
Heartland EPS



[Non-text portions of this message have been removed]
3
If you are lucky, your bank can provide you with software to convert the
text file output from Vantage to the ACH format required by the banking
community. In our case, they couldn't even come up with software names that
we could buy ourselves. We had just about given up. Fortunately, another
Vantage user provided us with a program he wrote in Visual Basic (I think)
that does the conversion to ACH. I think he watches this list, so hopefully
he will respond to you directly.
Nora Story
Spectra Technologies, Inc.

> -----Original Message-----
> From: Randy Vander Galien [mailto:randyv@...]
> Sent: Wednesday, August 14, 2002 5:02 PM
> To: Vantage@yahoogroups (vantage@yahoogroups.com)
> Subject: [Vantage] Payroll Direct Deposit
>
>
> Hi Group,
>
> We have begun evaluating payroll direct deposit and I am hoping
> you can help
> in this process. From what I have gathered so far from our bank (US Bank),
> is that the only format that they will accept is the NACHA formatted ACH
> file standard. If this be the case has anyone been successful in
> generating
> a file based on this format? Or is anyone familiar with a conversion
> application that could take the raw date and manipulate it to meet these
> standards. Do I even mention the Custom Programming route?
> Any help would be much appreciated. Thanks in advance to all
> those gracious
> enough to respond!!!
>
> In Christ
> Randy Vander Galien
> IS Manager
> Heartland EPS
>
4
Do you think he might respond to me if I put in my $.02? We are using
Direct Deposit and changing banks. They are looking for the same thing from
us now.

If the someone is out there watching, I would really appreciate the same
help.

Thanks,

Aaron Hoyt
Design Standards

-----Original Message-----
From: Nora Story [mailto:Nora_Story@...]
Sent: Thursday, August 15, 2002 7:02 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Payroll Direct Deposit


If you are lucky, your bank can provide you with software to convert the
text file output from Vantage to the ACH format required by the banking
community. In our case, they couldn't even come up with software names that
we could buy ourselves. We had just about given up. Fortunately, another
Vantage user provided us with a program he wrote in Visual Basic (I think)
that does the conversion to ACH. I think he watches this list, so hopefully
he will respond to you directly.
Nora Story
Spectra Technologies, Inc.

> -----Original Message-----
> From: Randy Vander Galien [mailto:randyv@...]
> Sent: Wednesday, August 14, 2002 5:02 PM
> To: Vantage@yahoogroups (vantage@yahoogroups.com)
> Subject: [Vantage] Payroll Direct Deposit
>
>
> Hi Group,
>
> We have begun evaluating payroll direct deposit and I am hoping
> you can help
> in this process. From what I have gathered so far from our bank (US Bank),
> is that the only format that they will accept is the NACHA formatted ACH
> file standard. If this be the case has anyone been successful in
> generating
> a file based on this format? Or is anyone familiar with a conversion
> application that could take the raw date and manipulate it to meet these
> standards. Do I even mention the Custom Programming route?
> Any help would be much appreciated. Thanks in advance to all
> those gracious
> enough to respond!!!
>
> In Christ
> Randy Vander Galien
> IS Manager
> Heartland EPS
>



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
5
I am always surprised when this subject comes up and people have a hard time
"finding" software to create a file acceptable to their bank. We have used
3 different banks in the last 7 years to do DD and each one has provided (or
sold) us their software to read and import the Vantage created text file.
Here in our little corner of NW Pennsylvania I always think we are behind in
technology but maybe not. We are now using our bank's website to which we
can upload the Vantage file directly. The format our banks have needed is
simply a fixed-width text file that uses some but not all of the info in the
Vantage file. For the website I had to create a mapping so the bank's
system can find the info it needs in the Vantage file.
Recently I have gone a step further and made our 401(K) deductions a "direct
deposit" so Vantage puts them in the same file. I then have a Crystal
report that reads the Vantage file, separates the 401(K) info into one file
and the bank DD info into a second file. We then have a file ready to be
uploaded to our bank and one for our 401(K) investment folks. I compiled
the Crystal report so our Controller double clicks an icon on her desktop
(after she has run payroll) and the 2 files are created, ready to be
uploaded. This has been working very nice.
I would be happy to answer any questions anyone has about our experiences.

Jerry Boyle
Sipco Molding Technologies
Meadville, Pa. 16335-6725
814.724.2243 x53
vantage 5.00.337
6
We could use the same as well. Thanks

-Dave Schnorr
Minnesota Electric Technology

-----Original Message-----
From: Aaron Hoyt [mailto:aaron@...]
Sent: Thursday, August 15, 2002 5:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Payroll Direct Deposit

Do you think he might respond to me if I put in my $.02? We are using
Direct Deposit and changing banks. They are looking for the same thing
from
us now.

If the someone is out there watching, I would really appreciate the same
help.

Thanks,

Aaron Hoyt
Design Standards

-----Original Message-----
From: Nora Story [mailto:Nora_Story@...]
Sent: Thursday, August 15, 2002 7:02 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Payroll Direct Deposit


If you are lucky, your bank can provide you with software to convert the
text file output from Vantage to the ACH format required by the banking
community. In our case, they couldn't even come up with software names
that
we could buy ourselves. We had just about given up. Fortunately,
another
Vantage user provided us with a program he wrote in Visual Basic (I
think)
that does the conversion to ACH. I think he watches this list, so
hopefully
he will respond to you directly.
Nora Story
Spectra Technologies, Inc.

> -----Original Message-----
> From: Randy Vander Galien [mailto:randyv@...]
> Sent: Wednesday, August 14, 2002 5:02 PM
> To: Vantage@yahoogroups (vantage@yahoogroups.com)
> Subject: [Vantage] Payroll Direct Deposit
>
>
> Hi Group,
>
> We have begun evaluating payroll direct deposit and I am hoping
> you can help
> in this process. From what I have gathered so far from our bank (US
Bank),
> is that the only format that they will accept is the NACHA formatted
ACH
> file standard. If this be the case has anyone been successful in
> generating
> a file based on this format? Or is anyone familiar with a conversion
> application that could take the raw date and manipulate it to meet
these
> standards. Do I even mention the Custom Programming route?
> Any help would be much appreciated. Thanks in advance to all
> those gracious
> enough to respond!!!
>
> In Christ
> Randy Vander Galien
> IS Manager
> Heartland EPS
>



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/








Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/M=209084.2258962.3692857.1943904/D=egroupweb/S=1705
007183:HM/A=1198188/R=0/*http:/shop.store.yahoo.com/cgi-bin/clink?logite
ch2+shopping:dmad/M=209084.2258962.3692857.1943904/D=egroupweb/S=1705007
183:HM/A=1198188/R=1/1029411156+http://us.rmi.yahoo.com/rmi/http://www.l
ogitech.com/rmi-framed-url/http://yahoo.buylogitech.com/referrer.asp%3Fr
=cam-y63>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.


[Non-text portions of this message have been removed]
7
If I remember correctly the particular VB script everyone is referring to
was pasted as text to the bottom of a message since attachments aren't
allowed on this group. If you search the archives for "direct deposit" you
can probably find the message, then copy the code from that message and
paste it into a new file.

Hope this helps,

Rick
8
-----Original Message-----
From: Aaron Hoyt [mailto:aaron@...]
Sent: Thursday, August 15, 2002 6:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Payroll Direct Deposit [SMC WIRE FABRICATORS]


Do you think he might respond to me if I put in my $.02? We are using
Direct Deposit and changing banks. They are looking for the same thing from
us now.

If the someone is out there watching, I would really appreciate the same
help.

Thanks,

Aaron Hoyt
Design Standards

-----Original Message-----
From: Nora Story [mailto:Nora_Story@...]
Sent: Thursday, August 15, 2002 7:02 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Payroll Direct Deposit


If you are lucky, your bank can provide you with software to convert the
text file output from Vantage to the ACH format required by the banking
community. In our case, they couldn't even come up with software names that
we could buy ourselves. We had just about given up. Fortunately, another
Vantage user provided us with a program he wrote in Visual Basic (I think)
that does the conversion to ACH. I think he watches this list, so hopefully
he will respond to you directly.
Nora Story
Spectra Technologies, Inc.

> -----Original Message-----
> From: Randy Vander Galien [mailto:randyv@...]
> Sent: Wednesday, August 14, 2002 5:02 PM
> To: Vantage@yahoogroups (vantage@yahoogroups.com)
> Subject: [Vantage] Payroll Direct Deposit
>
>
> Hi Group,
>
> We have begun evaluating payroll direct deposit and I am hoping
> you can help
> in this process. From what I have gathered so far from our bank (US Bank),
> is that the only format that they will accept is the NACHA formatted ACH
> file standard. If this be the case has anyone been successful in
> generating
> a file based on this format? Or is anyone familiar with a conversion
> application that could take the raw date and manipulate it to meet these
> standards. Do I even mention the Custom Programming route?
> Any help would be much appreciated. Thanks in advance to all
> those gracious
> enough to respond!!!
>
> In Christ
> Randy Vander Galien
> IS Manager
> Heartland EPS
>



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/






Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/