Using EBanking Solutions In Dynamics GP - Forvis

Transcription

Using eBankingSolutions inDynamics GPSeptember 24, 2020

To Receive CPE Credit Individuals Participate in entire webinar Answer polls when they are provided Groups Group leader is the person who registered & logged on to the webinar Answer polls when they are provided Complete group attendance form Group leader sign bottom of form Submit group attendance form to training@bkd.com within 24 hours of webinar If all eligibility requirements are met, each participant will be emailed theirCPE certificate within 15 business days of webinar

INTRODUCTIONSCharles AllenSenior Managing Consultant More than 30 years of experience Microsoft MVP

AGENDA Overview EFT for Payables Safe Pay Electronic Bank Reconciliation EFT for Receivables Q&A

EFT for Payables

EFT for PayablesSteps to Implement Set up SecurityAdd EFT information to a CheckbookSet up Email for the CompanyModify the template, if necessarySet up VendorsCreate PrenotesGo Live

Security SetupVerify users areassigned to theproper securityrolesUse the SecurityTask Setup reportto determine theroles with EFT

EFT Setup Select the EFT button from Checkbook Maintenance Add the EFT information from the bank Set up Payables options EFT file format EFT file location Numbering SequenceGet an EFTFormat Guidefrom your bank!

EFT Setup

Email SetupSelect the Server Type Exchange – Also used forOffice 365 MAPI – Used for Outlook

Company Email Setup Select the options for themessages Select the file format youwant to use. PDF is mostcommon

Purchasing Series Email Enable the purchasing types ofdocuments to be used Create the email message Select other options

Vendor Setup Add EFT information tothe Remit To address

Vendor Setup Enter email information Use the To, Cc, & Bcc fields

Vendor Setup Enable sending formsto the vendor Only VendorRemittance needs tobe selected if notsending purchaseorders Select a message forthe vendor

Create a payment batchCreating anEFT Batch Select the EFT option Add payments to the batch Only vendors with EFT information can be included

Processing PaymentsAfter selecting the vouchers for payment, select ProcessPrint remittance advicesPost the paymentsGenerate the EFT fileUpload the file to the bank

Safe Pay

Steps to SetupSet up the UploadinformationSet up the SafePay file formatGet the requiredformat from thebank Associated Bank &Checkbook Location for files tobe created

Safe Pay File Format Example

Using Safe Pay Post a payment batch Use Transactions Upload tocreate the Safe Pay file Upload the file to the bank Be wary of using the samecheck number when reprintingchecks

Electronic Bank Reconciliation

Electronic Bank Reconciliation SetupSet up the formatof the file to beimportedBAI & BAI2 arethe commonformatsBAI2 can createdby modifying thestandard BAIformat

File Format Configuration

DownloadMaintenance Enter a Download ID Select a Bank Format Select one or more Checkbooks Select the Path for the file

Using Electronic Bank ReconciliationDownload the filefrom the bankUse theTransactionsDownload windowto import the dataSelect theReconcile buttonto reconcile thecheckbook

EFT for Receivables

EFT for Receivables – SetupUse theCheckbookMaintenancewindow toAdd EFTinformationSelect theEFT BankbuttonEnter bankinformationSelectReceivablesOptionsCreate aformatdifferent fromthePurchasingformatEnter theoutput fileinformation

EFT for Receivables – Customer SetupSelect theCustomerAddress recordSelect the EFTBank buttonEnter informationfor the customerrecord

EFT for Receivables – Using the SystemSelect Generate EFT File from the SalesTransactions menuSelect the CheckbookMark one or more batchesSelect Generate EFT File

Resources Electronic Banking User Guide

BKDTECHNOLOGIESSUPPORT CENTERBKD Technologies Support Center forMicrosoft Dynamics GP 877.253.7778 (toll-free) GPsupport@bkd.com Monday–Friday, 8 a.m.–5 p.m.

BKD, LLP is registered with theNational Association of StateBoards of Accountancy (NASBA) asa sponsor of continuingprofessional education on theNational Registry of CPE Sponsors.State boards of accountancy havefinal authority on the acceptance ofindividual courses for CPE credit.Complaints regarding registeredsponsors may be submitted to theNational Registry of CPE Sponsorsthrough its websitewww.nasbaregistry.orgThe information contained inthese slides is presented byprofessionals for your informationonly & is not to be considered aslegal advice. Applying specificinformation to your situationrequires careful consideration offacts & circumstances. Consultyour BKD advisor or legalcounsel before acting on anymatters covered

CPE Credit CPE credit will be awarded upon verification of participant attendance;however, credits may vary depending on state guidelines For questions, concerns, or comments regarding CPE credit, please emailBKD Learning & Development Department at training@bkd.com

Thank You!Charles Allen, Senior Managing Consultant713.499.4629 callen@bkd.com

Processing Payments. After selecting the vouchers for payment, select Process . Microsoft Dynamics GP . CPE credit will be awarded upon verification of participant attendance; however, credits may vary depending on state guidelines For questions, concerns, or comments regarding CPE credit, please email .