Home

Easy e-Bank Rec™ User Manual

1. cccssccccsssceceseceeeseeeeeeecesseeceeseeess 28 Internal ID Maintenance sseessessessssesessrresrrrsrrrsrrrsressrersrersrresreereesrerereseeeseere 29 Delete Latest IMPOrt ecsiissoresisssnressssrorsssnri isis cirois erno ni En E Esa Siasea 29 Update Internal IDs in Accounting System eseessseesssersserresresssrrssrereseereseeees 30 EASY E BANK REC USER MANUA siccatiwanetciesesasaca vamenesien aeaseremssesnensiarerencuesucasinaneranemeaenss 31 Barik ROCO CINCH MN serenan rE EEE A 31 Record the Bank Statement siete cence as sects En e Ean r TER E A 31 Step 1 Import the Bank TapGenriseimrenriniriare aran EE E 32 Step 2 Preview Matching TranSactiOns cccccssscccsssccccssececesecesensceceesceseeeceesuecessuncesseaees 35 Step 3 Process Automated Bank Tape Transactions ccccsccccsssccceeseeceeseceeeeecessescesseness 43 Step 4 Preview Create Small Adjustments eeseseseessseesrrrrrrrrrrrreeeeessssssrrrrrrrrrrrrrreeeeeessssses 45 Step 5 Mark all Matching Items as Reconciled sesssssensseesseessserssseroseersserrssersssrreseeress 47 Step 6 One Click Resolution of Unresolved ItemS cccccssecccsscecesceeeenececeneceseeseesseaees 48 POCOS D DO Ol eesri n E a seedtgaiwactanccesseeniene 49 PROCESS IN PUTEO een eracaceiea 50 PV BUN OM eaae E E ocuesaeh ipcascedevetseeeeaes aleeuscontset 51 PROC CSS U BUOD crore aea E E A E 51 Undeposited Receipts cccccessecccsececesscecsesccecesececsusceeses
2. 3 Click on the Ellipse Buttons in Check Book Management to drill Copy Paste Document All equal transactions will be marked as reconciled in Microsoft Dynamics GP NOTE If you click on Cancel in the message box prompt your matching transactions in Microsoft Dynamics GP will not be reconciled ALTERNATIVELY Easy e Bank Rec Page 47 of 4 1 HOVER over the Document on the left side of the grid and RIGHT CLICK the mouse CLICK on the Select Document Number message Enter Check to Check Book Management searchin Grid Search T TrxAm Sy Post Date Y C Y Cleared Sy Pstd Cld W Select Document Number 00000000000000000001 For Matching ufo G Ext 2 4 1 Right click mouse ee J Manual Match Right Click 2 MOVE the cursor to the right side of the grid and hover over the lt Doc USER INPUT gt field and RIGHT CLICK pank Statement Undeposited Receipts Download P P M Show IIDs Locations Doc From Bank 7 Doc User Input Y Cleared Sy Bank Dat Y Diff Sv B T Description 2 Hover over the Doc User Input field and right click Manual Match Doc User Input If there is no Document Number on the Bank Statement side and the amount matches the Document Number will be pasted in automatically If there is a Document Number the user will be prompted to override the existing Document Number If the amounts do not match the user will be p
3. BTP Technologies Dynamics GP Bank Rec with VELOCITY LLC EASY E BANK REC MANUAL Version 10 5 TABLE OF CONTENTS WAAT Sy arrears vce s tastes nsnde nese nner esses denenuasawaransscevaeveesvensausauasaaneneessssisesercasaeees 3 Description of the Easy e Bank SOftWALE ccccccssecccessccceeseceeeececaeececeeseeeeeaecessuecesseneessees 3 Rele E NOTS esceitese E ns EAE T E O N EEE OA AEO A OOA 3 EASY E DANK REC REFERENCE MIANUAL csiciscenceadseccnitawenanssdcncacduawacnwnaceetescuansnsnecdonsaeneaawanens 5 ACCESSING Easy C BaNk ROC siaucccsssnessainceavanncarssandeaverssnsmenasanadmentencseasagdvavarssannasbadseswatensoustaainashs 5 Mam CroO ener eee eee een ne nee oe PS ne een ee en Or en rene eens ee ene 5 TOOB eene A E E E E E set ecemesateusce sateen 6 PUN OOM Dea E E E a E 9 Main Screen ComponentS sssssessessesressessesessessessrssrsressesseseesessrsresseseeseesee 11 Additional Features cccsccscsessescscsscscussscussecncscncescncusescussscaeucnaeseneuseseussseas 14 REN C 6 al et orc dB i aare E E E EAA 15 AEDE EE E E E EE A E N E T E E 18 SOUD a E E eae ieantetaaeest 18 Excel Header SetU aes peter taeenetis ea EET E EO 23 Tap Heada SO UID Ee E E E E A EAEE 24 Update TRXDATE with GLPOSTDT ccccsssccccssececesscecesceceeeeeeeaecesseseeseeness 26 Bank Code Master List Maintenance ssssssseeseesssersssrrssreresrerssrressrreserreseeres 27 Extract Internal IDs from Import Data
4. Ellipse Bank Transaction Details To split the bank tape transactions into separate document numbers ENTER a starting check or deposit number or a zero in the field to the left of the Auto Update Button Then CLICK on lt AUTO UPDATE gt to split the bank tape transaction grouping into its component transactions The Auto Update feature will automatically renumber each transaction sequentially in the User Input column beginning with the document number you enter In the example above 1234 was entered in the lt Type in Starting gt field Clicking on Auto Update automatically entered the three sequential transaction numbers in the User Input column CLICK on the lt SAVE amp CLOSE gt button to return to the main grid Easy e Bank Rec Page 13 of 74 10 Description Easy e Bank Rec displays all comments that appear below the transaction on the Bank Statement Tape such as Merchant ID Commercial Deposit ZBA Credit and so on NOTE All columns in the Main Screen can be sorted filtered and summarized CLICK on any column header to sort the data in the column CLICK on the icon to the right of the column header to view the lt SELECT SUMMARIES gt window CLICK on the option you want to review CLICK on the filter icon lt gt in each column to display a drop down menu of transaction views SELECT the value to display only rows with that data The grid also can be sorted by multiple columns PRESS the l
5. HA fi Easy e Bank Rec Page 50 of 74 Process N Button The N Button Account will default to the accounts you identified in Setup Two comment fields appear at the bottom of the screen 3 System Comment this is a read only field that identifies the user and the date and displays the transferred amount and document numbers 4 User Comment the user can enter additional comments in this field CLICK the button labeled lt PROCESS N BUTTON gt A message box appears on the screen asking if you want to create the N Button adjustment CLICK on lt OK gt to adjust the document Conversely CLICK on lt CANCEL gt to cancel the process Two entries will be created one increase adjustment and one decrease adjustment in the Bank Rec module Two GL entries will be posted as well The effect 1s zero in the GL M Button CLICK on the lt M BUTTON gt to mark individual documents in Microsoft Dynamics GP as reconciled This is equivalent as being inside the bank reconciliation in GP and click marking an item A message box appears on the screen asking if you want to mark the document as reconciled CLICK on lt OK gt to mark the document Conversely CLICK on lt CANCEL gt to cancel the process WHEN ALL EFFORTS TO RESOLVE VARIANCES HAVE BEEN EXHAUSTED THE U BUTTON CAN BE USED Process U Button The U Button is used to set aside unidentified or unresolved transaction such as wire transfers or variances
6. g S oa o z Drill down to verify paper bank statement with electronic download Identifies voided documents that were open at the bank rec closure date Reconciliation Screen Main Easy e Bank Rec Page 66 of 74 Numbered items on the Reconciliation Summary screenshot are described below l Error There are unposted GL transactions Financial transactions belonging within the period being reconciled are in the work area Post the unposted General Ledger batches that contain these transactions Error The sum of the bank transactions does not match the variance between bank statements Easy e Bank Rec takes the current ending balance and subtracts the prior reconciliation ending balance The variance is then compared to the download for that period If they do not match then either the bank ending balance is wrong or the bank tape upload is incorrect Enter GL Previous Month Balance Enter the amount of the GL as it was recorded in your last reconciliation Easy e Bank Rec column The values in this column are from Easy e Bank Rec They detail transactions in Microsoft Dynamics GP The Voided Outstanding F value in the Easy e Bank Rec column shows if a document is voided in Microsoft Dynamics GP but the void date is after the statement close date Great Plains Actual column The values in this column are from Microsoft Dynamics GP Back Office summary table
7. tiis ie my comme 0372872007 i A Travel Compan _ this ie my comme _ Preview Update Check Payer Payee e The bank transaction description appears on the far right of the grid Easy e Bank Rec Page 40 of 74 Iv ran Iv Refresh lv az Selected and Unsele M Display Records Joc H v Bank Cleared Amount S Y Bank Cleared Date Description 90629 250 00 03 26 2007 CHECKS PAID 475 80630 2 000 00 03 27 2007 CHECKS PAID 475 J1 053 500 00 03 1 9 2007 CHECKS PAID 475 Preview Update Check Description Easy e Bank Rec automatically highlights transactions that are banked beyond a user designated acceptable range of days and also flags transactions that have been banked before they have recorded in the GL The transactions that have been banked before recording in the GL are color coded in Orange The transactions that have cleared the bank beyond the user designated acceptable range of days appear in Yellow Transactions that are within the acceptable date range appear in White 2 CLICK on the lt UP gt or lt DOWN gt arrows below Flag Items Where Bank Cleared Date Is to select the appropriate date ranges Flag items Where Bark Cleared Date Is Display Records a Move Than ho Dayt Balore GL Post Date Vv oe wv Retresh ie Move Than f1 i Days Afer GL Post Date vj Selected and Unsek Preview Update Deposit Color Scheme 3 CLICK on the lt CHECK BOXES gt by the
8. 03 14 2007 03 14 2007 1232 13 American Electrical C PYMNTOO0000000291 Cah o 02 25 2010 Undeposited Receipts Main The Undeposited Receipts window displays 1 the Total Receipts number of items 2 the Total Amount of the displayed transactions 3 the breakdown into types of transactions Cash Receipts Checks and Credit Card Payments HE Undeposited Receipts Total Receipts Cash Receipts Credit Card Payments of Items 1 6 of Items 3 of Items 2 Create Deposit Amount 17 136 70 Amount 1 232 13 Amount 7 13 996 79 Amount 1 907 78 vias of Selected Items 0 of Selected Items 0 of Selected Items 0 of Selected Items 0 Amount 0 00 Amount 0 00 Amount 0 00 Amount 0 00 Deposit Date 03 30 201 0 v I Include Receipt Types Date Range Select All I All M Checks M Cash M Credit Card Start j 201 1900 x End 03 30 2010 Refresh Audit Trail YH Receipt Number V Receipt Da Y GL Post V ReceiptAm VY Received From Y Source Document Number YH Receipt Type YH Credit Card Type V PostedDate Y Post RMCSHOOO00012 PYMNTOOOOOO00028 03 25 2007 03 25 2007 453 45 Alton Manufacturing PYMNTOOOOOO000294 Check fs 02 25 2010 BE A E A Y2si21 Rew WedcaCener PawnTomoommnnss Oreck a Ee A A Yaar 23213 Bakes Enoanmin e Geeta E BEE Parone A aaa r S e CeCe E BEE A A A A E tah S Undeposited Receipts Receipts Amounts Types CLICK o
9. button in the upper right corner of the window to create the deposit A dialog box will appear on the screen to confirm the deposit deposit number and number of items 9 CLICK on lt OK gt Step 7 Preview Move to Paid No Issue Paid No Issue Transactions This process allows you to move transactions that are in the Bank Tape but not recorded in Microsoft Dynamics GP to a holding area for Paid No Issue Transactions These transactions will be resolved in subsequent Bank Reconciliation s 1 Under lt ACTIONS gt in the Menu Bar SELECT lt PREVIEW MOVE TO PAID NO ISSUE gt The following screen will appear Easy e Bank Rec Page 57 of 4 HE Preview Move to Paid No Issue Check VW Bank Code VY Bank Description v ClearedDate Y p aam eee Mar a fonera a ee p p e r mej To 160 0000 CHECKS PAID 475 037 3172007 Select Posting Accounts Cash Account 100 1000 00 PNI Account 000 1115 00 Cash Paid No Issue Cash System Comment i check is moved to Paid No Issue window by sa on 037 3172007 User Comment Move Checks Cashed to Paid No Mo Onion Si Y a Preview Paid No Issue This screen brings up a view of all the transactions that are in the Bank Tape but are not recorded in Microsoft Dynamics GP and that have PNI marked as Yes in the BAI master code table Note that you can sort filter summarize and print the information in the grid The PNI Account will default to the ac
10. gonceDoo o ca Nein Tos Odom CMTRX 281 798 36 264 492 00 17 306 36 17 306 36 90 851 13 K grm eaS PER EATS Wy IK i 02 44 21 702 46 P Ch kik 7 TOA NCO EAL AO COFCO D 51 mee ITIO IT TEJ UO La t L P Ei E ii w Show Print Error Message D UNPOSTED GL CASH TRANSACTIONS Variances show up immediately 390 764 45 485 988 25 95 223 80 CM THERE ARE MATCHING TRANSACTIONS THAT ARE NOT YET MARKED MARK ALL Sowce Doc Debt Credit NetChange Toa N EQUA MTRX 141 982 52 215 527 29 73 544 77 73544 77 N A 90 851 13 AAA Ada ia u a Wa aiis ue s f ee J 2 Pinpoints errors When the bank rec balances the total is 0 00 When it does not balance the variance appears in red 217 449 58 428 204 92 210 755 34 173 314 87 57 783 33 Great Plains Totals Great Plains st Pv Hod Eo H A oy etek Fee 5 Great PaneAcusl MBS Grea Pare Vou mcare stononnon 2EGNWNG eaa oi 3 B GLPERIOD VARI 95 223 80 895 22380 0 wo C EOP CALCULATE 95 223 80 4 776 20 J EOM ACTUAL 100 000 00 Refresh Data in Adjacent Grid gt gt D OUTSTANDINGB 110 755 34 110 755 34 K OUTSTANDING DO 0 00 rE BANK STMNT TO 15 531 54 36 808 00 L STATEMENT VARI 102 339 54 2 Q PoE sooo ssn More o THD _so00 _
11. r 2 21 2 4 Show Duplicate Locations and Credit Card Types Only Add New Edit Import Close Internal ID Maintenance Delete Latest Import This feature is useful only for custom imports that extract the Merchant ID or Location ID from the downloaded bank statement Easy e Bank Rec Page 29 of 74 CLICK on this menu option to delete the most recent import for the displayed Checkbook ID The application asks if you wish to delete the file CLICK on lt Yes gt to complete Easy e Bank Rec Q Delete latest import for Check Book GP WACHOYIA No Update Internal IDs in Accounting System This feature is only useful for imports with a custom code import with the extraction of the Merchant ID or Location ID from the downloaded bank Statement CLICK on this menu option to update the Internal IDs in the accounting system for the displayed Checkbook ID The system will extract the location and transaction type from the accounting transaction and derive the Internal ID from the Internal ID Maintenance Table The application asks if you wish to update the Internal IDs Easy e Bank Rec 2 Update Internal IDs for Check Book GPWACHOYVIA No CLICK on lt Yes gt to complete Easy e Bank Rec Page 30 of 74 EASY E BANK REC USER MANUAL Bank Reconciliation Open Easy e Bank Rec by clicking on lt Easy e Bank Rec gt under the lt ADDITIONAL gt option in the Microsoft
12. 03 22 2007 675 65 Advanced Paper Co PYMNTOOOOO0000292 Credit Card Gold Credit 02 25 2010 RMCSHOO000014 PYMNTOOOOOOOO029 03 14 2007 03 14 2007 1232 13 American Electrical C PYMNTOOO000000291 Cah 02 25 2010 To create a deposit for the selected transactions 3 CLICK on the lt SELECT ALL gt button above the grid on the left side OR 4 CLICK on the first row PRESS the lt SHIFT KEY gt and click on the last row to select all NOTE that the Deposit Date field will automatically display the date of the most recent transaction s in the grid HE Undeposited Receipts IGPWACHOVIA Undeposited Receipts Refresh Display OC Amount 17 136 70 Amount f 1 232 13 Amount j 13 996 79 Amount 1 907 78 of Selected Items 0 of Selected Items 0 of Selected Items 0 of Selected Items 0 Deposit Date Amount 0 00 Amount 0 00 Amount 0 00 Amount 0 00 03 30 201 0 x Total Receipts of Items Include Receipt Types Date Range I Select All T All V Checks M Cash M Credit Card Start on 01 1900 x End 03 30 2010 Refresh RMCSHOO000012 PYMNTOOOOOO00028 03 25 2007 03 25 2007 453 45 Alton Manufacturing PYMNTOOOO00000284 Check fs 02 25 2010 RMCSHOO000012 PYMNTOOOOOO00028 03 25 2007 03 25 2007 1231 23 PYMNT000000000285 Check 02 25 2010 RMCSHOO0001 4 MNTO0000000029 03 25 2007 03 25 2007 1232 13 Baker s Emporium In PYMNTO00000000290 Credit Card 02 25 2010 RMCSHOO000014
13. Book Name Import Cancel a Import Bank Statement The Last Cleared Date field is a read only field and will display the last imported document date SELECT the File Format from the drop down menu CLICK on lt SAVE gt Easy e Bank Rec will remember the selected file format for all future bank file imports The available file formats are a Import Bank Statement Check Book ID GPWaACH Ovi Last Cleared Date 03 31 2007 Select File Format GPC WACHOVIA FILE Save Select Files BAI Credit Card Work Book Name BAI DATE ON 16 BAI F5 FORMAT BAI MONTHLY SUNTRUST BAI NOBANK 175 BAI USRDF1 FORMAT GPC WACHOVIA FILE STANDARD BAI FORMAT STANDARD GIF FILE NO BAI CODE port Cancel S Easy e Bank Rec Page 32 of 74 BAI Credit Card e Used to demonstrate retrieval of credit card information and internal ID for demo purposes only BAI DATE ON 16 e For BAI files which have the date in the 16 type records BAI FS5 Format e For BAI files where the document number is stored in the fifth position rather than the normal 6 position BAI Monthly SunTrust e Fora SunTrust BAI that combines all entries for a complete month into one 02 type record BAI NOBANK 175 For BAI file where the document number position 6 in 16 type records is omitted from the Easy e Bank Rec grid This is useful in case the document numbers are not matching the data in the Accounting system The mat
14. Easy e Bank Rec Page 53 of 74 HE Undeposited Receipts Total Receipts of Items 6 Amount 17 136 70 of Selected Items Oo Amount g0 Cash Receipts of Items as Amount 1 232 13 of Selected Items a Amount 0 00 Checks GPWACHOVIA of Items 4 Amount 13 996 79 of Selected Items so Amount g0 Credit Card Payments of Items ze Amount 1 907 78 of Selected Items oO Amount ga 00 Deposit Date 03 30 201 0 bd Create Deposit Close Include Receipt Types Date Range I SelectAll M All V Checks M Cash W CreditCard Start jor 70171900 End 03 30 2010 7 Refresh Audit Trail YR Receipt Number VW Receipt Da WV GL Post VW Receipthm V7 Received From WR Source Document Number w Receipt Type WR Credit Card Type WH PostedDate WH Post RMCSHO0000012 PYMNTOOOOOOOO028 03 25 2007 03 25 2007 453 45 Alton Manufacturing PYMNT 000000000284 02 25 2010 RMCSH00000012 PYMNTOOOOOOO0N28 03 25 2007 03 25 2007 1231 23 PYMNToo0000000295 02 25 2010 Fi RMCSH00000012 PYMNTOO0O0000028 03 25 2007 03 25 2007 12312 1 Berry Medical Center PYMNTOOOOONN00286 02 25 2010 RMCSHOOO00014 PYMNTOOOOO000029 03 25 2007 03 25 2007 1232 13 Baker s Emporiumin PYMNTOOOOOOO00290 Credit Card 02 25 2010 RMCSHO0000014 PYMNTOOOOOOOOO29 03 22 2007 03 22 2007 675 65 Advanced Paper Co PYMNTO00000000292 Credit Card Gold Credit 02 25 2010 RMCSHOO000014 PYMNTOOOOOOO0029
15. Location SELECT the option you wish To display all the records for the location on both sides of the grid CLICK on lt SHOW RECORDS FOR LOCATION XXX ON BOTH SIDES gt To display possible matches for that particular location on the opposite side of the grid CLICK on lt SHOW POSSIBLE MATCHES gt It will be filtered by location not amount Note You can sort the columns within the views Just click on the desired column header to sort by the criteria within the selected column Easy e Bank Rec Page 63 of 74 Internal ID This capability is used to find Internal ID matches on both the Check Book Management and Bank Statement sides of the grid for credit card wire reconciliation RIGHT CLICK the lt BANK ID gt Select the option you wish To display all the records for the Internal ID on both sides of the grid CLICK on lt SHOW RECORDS FOR IID XXXXXXXXXX ON BOTH SIDES gt Doc From Bank v Doc Userlnput Y Cleared SV Bank Dat 7 Diff Sv B v T Description Wi Bank lID Y Show Records for IID 543684555534137 on Both Sides Show Possible Matches Show All Records Exit Right Click Internal ID To display possible matches for that particular record on the opposite side of the grid CLICK on lt SHOW POSSIBLE MATCHES gt Bank Statement Undeposited Receipts Download P P V Show IIDs Locations Pstd Clrd V Loc Y Doc FromBank w Doc Userlnput w Cleared SV Bank Dat Y Diff 5y
16. Maintenance P Actions v Paid No Issue Trx Setup Options Update TRXDATE with GLPOSTDT Bank Code Master List Maintenance Extract Internal IDs from Import Data Internal ID Maintenance Delete Latest Import Update Internal IDs in Accounting System Maintenance Menu setup The Setup screen is password protected in order to prevent unauthorized access to the Easy e Bank Rec system defaults There are six Setup features 1 Password entry and verification Each time you enter Setup you will be required to enter your password and verify it 2 Set Change Your Password This feature will be used when you enter Setup for the first time It 1s recommended that you change your password periodically to prevent unauthorized access to the system defaults 3 Adjustments Account Information This screen allows you to automate BAI codes to generate the transactions in the correct account in the GL without data entry Examples of BAI codes that can be automated are interest bank fees ZBA or Sweep transfers Typically they are entries that require you to wait for the bank statement to be available before you can book them into your accounting system 4 Registration This feature is used to enter the Registration Keys to activate Easy e Bank Rec The first action in Setup is to change your password ENTER your new password in the field labeled Please Enter New Password RE ENTER the password in the next field then CLICK on lt
17. Options Show Split Clear Filters Enter Check to Bank Statement Check Book Management Search in Grid Search Download Undeposited Receipts l Show lIDs Locations U aa Doc Y TixAm SY Post Date Y C Y Cleared zy Pstd Chd Y M N _ Doct FiomB Y Doc UserIn Y Cleared ZY Bank Dat Y Dif EY B Y Description Y ue e He 1 o o oo i a soo BODE soo soo soo Boo ujo BUC BUC ele Main Screen v 10 Easy e Bank Rec Page 5 of 74 Tool Bar The tool bar contains the menu options that allow the user to set defaults and to perform the bank reconciliation Main Screen Tool Bar The options from left to right are 1 Checkbook ID This field will be populated with the checkbook you select using the lt CHANGE gt button to the right 2 Change To change the Checkbook ID CLICK on the lt CHANGE gt button to the right of the field and SELECT the appropriate active Checkbook ID 3 Reconcile This button opens the lt MICROSOFT DYNAMICS GP RECONCILE BANK STATEMENT gt window where the Bank Statement Ending Balance from the bank statement is recorded at the beginning of the Easy e Bank Rec bank reconciliation process 4 Maintenance The options under Maintenance all relate to setting up the program and Maintenance There are seven options Maintenance P Actions Y Paid No Issue Trx Setup Options Update TRXDATE with GLPOSTDT Bank Code Master List Maintenance Extract Interna
18. PYMNTOOOOOOOO029 03 22 2007 03 22 2007 675 65 Advanced Paper Co PYMNTOOOO00000292 Credit Card Gold Credit 02 25 2010 RMCSHOOO00014 PYMNTOOOOO000029 03 14 2007 03 14 2007 1232 13 American Electrical C PYMNTOOOOO0000291 Cah 02 25 2010 mi RMCSHO0000012 PYMNTOOOOOO00028 03 25 2007 03 25 2007 12312 1 PYMNT000000000286 zi PY Undeposited Receipts Deposit Date Easy e Bank Rec Page 55 of 74 5 6 fe CLICK on the lt CREATE DEPOSIT gt button in the upper right corner of the window to create the deposit A dialog box will appear on the screen to confirm the deposit deposit number and number of items Easy e Bank Rec Deposit number COOOOO00000000000011 successfully created Number of items included 4 Undeposited Receipts Create Deposit CLICK on lt OK gt If you previously displayed one or two of the types of receipts CLICK on the checkbox labeled lt ALL gt under Include Receipt Types to display the remaining un deposited receipts Undeposited Receipts Display All In this example only two transactions remain Both are credit card transactions Undeposited Receipts Credit Card Type Easy e Bank Rec allows the user to create a deposit for each type of credit card In this example the AMEX transaction has been selected To create a wire deposit for the AMEX credit card receipt Easy e Bank Rec Page 56 of 74 8 CLICK on the lt CREATE DEPOSIT gt
19. Reports gt Excel z Print xX Close About CM Cutoff Date 03 31 2007 Bank Cutoff Date 03 31 2007 Marked x Check Deposit ALL Refresh Grid Options Show Split Clear Filters Enter Check to Bank Statement eve Book Management Searchin Grid Search po nload Undeposited Receipts Show lIDs Locations 2 Doc v Trs m Sy Post Date v E v Cleared Sy Pstd Clrd v i B v 9 Description VW SERRE TR Main Screen Components 1 Undeposited Receipts Button The Undeposited Receipts feature displays all of the cash receipts that have not yet been processed and allows the user to create a Deposit on the fly It takes seconds to process a very high volume of cash receipts 2 Show IDs Locations Enter Check to Bank Statement Check Book Management Search in Grid Search Download Undeposited Receipts IV Show IIDs Locations Clicking on the Show IIDs Locations checkbox expands the grid to display six columns Checkbook Management Left Side of Grid 1 Accounting ID 2 Account Location 3 Bank the bank Location for sorting purposes 4 Location Location of the store for sorting purposes Easy e Bank Rec Page 11 of 74 Bank Statement Download on Right Side of Grid 5 Bank ID the bank statement Merchant ID 6 Bank Location derived location from Bank ID NOTE This feature is used for credit card wire reconciliation U Button Used to set aside unidentified or unreso
20. and close the bank reconciliation while you research the item A decrease or increase adjustment will be generated in the amount of the variance i e wire for 550 00 credit GL to cash and debit to Paid No Issue account e g 1190 Easy e Bank Rec holds all those Document Numbers in a table until you reverse them under the Paid No Issue grid Easy e Bank Rec Page 51 of 74 Typically you would reverse them in a future period when the accrual is made in Microsoft Dynamics GP If the wire is recorded through AP Easy e Bank Rec reverses the Paid No Issue and the sum will be zero thus not requiring a bank tape download to clear CLICK on the lt U BUTTON next to the transaction you wish to set aside The following window will appear on the screen a Process U Button Check Information Check Book GPWACHOVIA Check Number 00000000000000000001 Amount 6 564 1 1 Type DEP Check Date 3 31 2007 v Diff 6 564 1 1 Action This process will move all checks that are cashed but not booked to the Unidentified Window Select Posting Accounts U Button Account 000 1 115 00 Cash Paid No Issue Cash System Comment i OODO0000000000000001 Adjustment DAJ for 6 564 11 by sa on 03 31 2007 User Comment Print Process U Button Cancel A A Process U Button The U Button Account will default to the accounts you identified in Setup Two comment fields appear at the bottom of the screen Easy
21. appropriate date ranges er More Than f Days After GL Post Date IV Ay Selected and Unsele Preview Update Deposit Color Scheme 3 CLICK on the lt CHECK BOXES gt by the colors under Display Records and CLICK on the lt REFRESH gt button to view the transactions in the grid and instantly identify the anomalies The column labeled DATE lt gt in the center of the grid displays the date variance between the booked banked days required by business rules and the actual days that have elapsed between the banked and booked transactions rowed eS Preview Update Deposit Elapsed Days GL Post Date l ip Wy 03 30 2007 03 31 2007 m3 Cashed 19 days after the check was recorded in Dynamics GP Hy r i To undo an automatic match and reconcile manually 4 UN CLICK the checkbox to the left of the transaction Easy e Bank Rec Page 38 of 4 EE Preview Update Deposit s Mark AllRecordsAs Selected Unse ZE F ooooooooooooooooo 2708 58 a Pe Derom 217248 Preview Update Deposit Record Select THE TRANSACTION WILL REMAIN ON THE MAIN GRID FOR MANUAL RECONCILIATION 5 CLICK on the lt UPDATE DEPOSIT S gt button at the bottom of the window to automatically update the document numbers in the Bank Tape with the matching deposit numbers in Microsoft Dynamics GP 6 The window will close and a mes
22. colors under Display Records and CLICK on the lt REFRESH gt button to view the transactions in the grid and instantly identify the anomalies The column labeled DATE lt gt in the center of the grid displays the date variance between the booked banked days required by business rules and the actual days that have elapsed between the banked and booked transactions Easy e Bank Rec Page 41 of 74 GL Post Date Date lt gt Pea o ES a pensar 0372472007 The check was recorded in Dynamics GP and cleared the bank 2 days later Preview Update Check Elapsed Dates To undo an automatic match and reconcile manually 4 UN CLICK the checkbox to the left of the transaction EE Preview Update Deposit s r Preview Update Check Record Select 5 CLICK on the lt UPDATE CHECK S gt button at the bottom left side of the window to update the document number in the Bank Tape with the matching check number in Microsoft Dynamics GP 6 The window will close and a message will appear on the Main Screen that will ask you if you want Refresh the Grid CLICK on lt YES gt to refresh the document numbers on the Bank Statement Download side Easy e Bank Rec Page 42 of 4 Step 3 Process Automated Bank Tape Transactions This window is used to process ZBAs SWEEPS interest charges service fees and other BAI code transactions that you identify in the S
23. down to print or re print previously reconciled bank statements Variance per Great Plains Outstanding by Transaction date Page 74 of 74 How to Resolve Variances Transactions were posted in prior period after bank reconciliation was already closed Make a notation on the paperwork and adjust the beginning balance Possible unposted GL transactions GP needs to have summary tables reconciled GL entries in cash account GJ and not in bank reconciliation This will match A amp B GL Posting date is different than transaction date GP bank reconciliation only accounts for transaction dates Variances show items that have different GL posting date Use Easy e Bank column to reconcile to your bank statement balance Easy e Bank Rec Addendum Description _Easye BankRec Calculated Bank Statement total based on above transactions Bank Statement Should match your bank Calculated Balance statement ending balance Any document voided beyond the current period ending date Voided Outstanding Adjust Calculated Bank Statement Total Easy e Bank Rec Great Plains Actual Description This amount is the ending balance in the Great Plains bank reconciliation This amount can be verified by drilling down and comparing with the previous period balance The drill down provides an ability to match the downloaded bank transactions and verify that all of them are matching the v
24. e Bank Rec Page 52 of 74 1 System Comment this is a read only field that identifies the user the transaction and the amount to be set aside 2 User Comment the user can enter additional comments in this field CLICK the button labeled lt PROCESS U BUTTON gt A message box appears on the screen asking if you want to move checks to Paid No Issue CLICK on lt OK gt to move the documents to Paid No Issue Conversely CLICK on lt CANCEL gt to cancel the process Undeposited Receipts The Undeposited Receipts feature displays all of the cash receipts that have not yet been processed and allows the user to create a Deposit on the fly It takes seconds to process a very high volume of cash receipts Once the user clicks on the lt UNDEPOSITED RECEIPTS gt button it takes as little as 20 seconds to bring up 100 000 cash receipts 1 CLICK on the lt UNDEPOSITED RECEIPTS gt button Mi Easy e Bank Rec File Edit Tools Help GPWACHOYVIA Change Reconcile Maintenance Actions Paid No Issue Trx Reconciliation Summary Reports y Excel G Print x Close About CM Cutoff Date 03731 2007 x Bank Cutoff Date 03 31 2007 Marked ALL Check Deposit ALL Refresh Grid Options Split Clear Fi Enter Check to Bank Statement Check Book Management Searchin Grd Search D ownloa d Undeposited Receipts Show IIDs Locations Undeposited Receipts Button The following window will appear on your screen
25. e Teal Transactions highlighted in teal are items on the bank statement that are unmatched e Red Transactions highlighted in red match but there is a variance between Issued and Paid e White Transactions that completely match the variance is zero Right Click Features for Matching Right Click Features allow matching in the following ways Document Number Right Click the Document on the Check Book Management side of the grid A message appears that identifies the match Click on lt Select Document Number gt to copy the Document Number Easy e Bank Rec Page 61 of 74 Enter Check t Check Book Management s hic crd Right click in the Document field then right click on the Select Document message to copy Right Click Document Number Document User Input RIGHT CLICK in the lt DOC USER INPUT gt field on the right side of the grid to paste the Document Number ni 5752007032700 575200703270001 3 171 65 03 27 2007 ZBA DEBIT 575 oo 5752007032800 575200703280001 13 342 63 03 28 2007 0 00 Tle ZBA DEBIT 575 efi a s n Caan a 65 ZBADEDIT 55 Joe E Don se e ee ee Dor B Right Click Doc User Input The possible outcomes by right clicking in the Doc User Input field are 1 Ifthe amounts match and the Document User Input field is blank the amount will be pasted automatically There will be no prompt 2 Ifthe amounts do not match but the Document
26. the columns within the views Just click on the desired column header to sort by the criteria within the selected column Internal ID used to find Internal ID matches on both the Check Book Management and Bank Statement sides of the grid for credit card wire reconciliation RIGHT CLICK the lt BANK ID gt Select the option you wish To display all the records for the Internal ID on both sides of the grid CLICK on lt SHOW RECORDS FOR IID XXXXXXXXXX ON BOTH SIDES gt Bank Statement Undeposited Receipts Download p P MV Show llDs Locations i EY Padd Le 7s i0 val M N _ DoctFomBak Y Doc Userinna Y Oeued Biv BorkDa v Di EY B v Desipion v Em0 7 a ig is E m z Show Records For IID 543684555534137 on Both Sides hs Show Possible Matches Show All Records f Eyt Right Click Internal ID To display possible matches for that particular record CLICK on lt SHOW POSSIBLE MATCHES gt Bank has ra Undeposited Receipts Download P p MV Show IIDs Locations baed Zv Paad VilocV mD val W N _ DoctFiombak Y _Doc Useiinnd Y Chued E BarkDat v Di Ev B v Demin v oN v BONE E Right Click Internal ID Bank Statement h Bank Statement Check Book Management Search in ond 3 Search Download Undeps U e E Accounting IID 3 Acct VW Tr m EV Post Date Y C Y Cleared SV Pstd Chrd Y Loc TEET Right Click Internal ID Check Book Easy e Bank Rec Page 17 of 74 Maintenance
27. total of the electronic bank tape import The Bank Tape Variance is the difference between the Statement Variance and the Bank Tape Total It should always be zero If itis not zero it means there was a problem in either the import process or in the bank statement total 1 REVIEW the bank tape file to ensure all the transactions have been imported If all the transactions have been imported you can filter by Bank Date with sorting 2 The Bank Statement amount might have been keyed in incorrectly under Reconcile on the Reconcile Bank Statement window 3 The dates may be incorrect in the Reconcile Bank Statement window 4 If there are transactions that are missing the import was not successful You can use the Delete Latest Import functionality under Maintenance and re import the file Help Easy e Bank Rec calculates and compares each value with the corresponding Microsoft Dynamics GP stored value It pinpoints variances in order to resolve variances quickly and efficiently The Error Message Box to the left of the screen tells you where the issues are For a detailed explanation of the items in the Microsoft Dynamics GP grid CLICK on the lt HELP gt button See Easy e Bank Rec Manual Addendum for the explanation available in Help Easy e Bank Rec provides three reports Easy e Bank Rec Page 70 of 4 1 Bank Tape Report This report displays the debits and credits in the Bank File that you importe
28. 000091053 500 00 03 19 2007 CHECKS PAID 475 O oooo00091055 2 000 00 03 24 2007 CHECKS PAID 475 000000091151 400 00 03 25 2007 CHECKS PAID 475 000000091152 1 500 00 03 28 2007 CHECKS PAID 475 91 9 O oooo00091551 160 00 03 25 2007 CHECKS PAID 475 O J ooon00031553 160 00 03 31 2007 CHECKS PAID 475 O oooo00091554 280 00 03 31 2007 CHECKS PAID 475 50 0 ms 000000092102 106 35 03 31 2007 CHECKS PAID 475 Ee ee eA CHECKS PAID 475 160 00 4 vel Lompai Al me 3 3 2007 CHECKS D 475 s2000 106 35 4 Travel Comoan this is my comme 03 31 2007 Update Check s Close ET Hooi complete Preview Update Check Wi i Matches are performed for these conditions 1 The Bank Document Number 1s zero 2 The amount matches 3 The check user input field is null or blank In all cases there must only be one entry for that document in the bank reconciliation NOTE the following features e The transaction Payer Payee and Checkbook description appear on the left side of the grid E Preview Update Check s Flag items Where Bank Cleared Date Is GPWACHOVIA fi More Than fi Days Before Ei More Than fi Days After G Payer Payee CM Description GL PostDate f amp Travel Compan this is my comme 03 26 2007 0372772007 A Travel Compan 03 19 2007 O08 A Travel Compan 03 24 2007 D0 A Travel Compan 03 25 2007 1 500 00 A Travel Compan
29. AYMENT CR Preview Update Deposit Description Easy e Bank Rec automatically highlights transactions that are banked beyond a user defined acceptable range of days and also flags transactions that have been banked before they have recorded in the GL beyond the user defined acceptable range If the variance between the date issued and the date banked is greater than the default entered at the top of the screen the click mark on the left of the grid will not be enabled The intent is to require the end user to review items that are beyond an acceptable date range For example 1f a deposit is recorded on the 10 of the month and the bank shows it deposited on the 25 of the same month 15 days will have elapsed which is likely not within the normal range In order for the software to match the document numbers a user must click the item by hand yellow and orange items The transactions that have been banked before recording in the GL are color coded in Orange Easy e Bank Rec Page 37 of 4 The transactions that have cleared the bank beyond the user designated acceptable range of days appear in Yellow Transactions that are within the acceptable date range appear in White Z L Flag Items Where Bank Cleared Date Is Display Records as More Than Days Before GL Post Date Show iv E4 Iv ia Refresh CLICK on the lt UP gt or lt DOWN gt arrows below Flag Items Where Bank Cleared Date Is to select the
30. BAI codes For more information on BAI codes go to http www x9 org standards free X9_BAI Codes_Version_2 Cash Manage ment_Balance_Reporting pdf or http www x9 org and search for Cash Management Balance Reporting Specifications Version 2 In 2009 the standards were transferred by the Banking Association Industry BAD to the X9 Financial Industry Standards In this display the cleared check codes are shown Easy e Bank Rec Page 27 of 74 HE Bank Code Master List Maintenance foeral CORPORATE TRADE PavMeNTOOEBT E No CORPORATE TRADE PAYMENT SETTLEMENT A Nos pera ACHSETTEWENT Ne SUMMARY ACHSETTUEMENTOEBTS Ao Le DETAIL INDIVIDUAL OUTGOING INTERNAL MONEY TRANSFER pon o Bank Code Master List Maintenance Only items marked Yes will be moved to Paid No Issue As a default only BAI code 475 items Check Paid are moved to the Paid No Issue table The Bank Code Description can be changed to fit your nomenclature Any new BAI code typically non standard will be added at the time of importing the bank statement If necessary the user must change the description to reflect the description to be used and 1 for inbound monies or 1 for outbound monies BAI contains a range of codes 900 to 960 that are used at the bank s discretion Extract Internal IDs from Import Data This feature is useful only for custom imports that extract the Merchant ID or Location ID from the downloa
31. BY Description V Bank Right Click Internal ID Bank Statement Enter Check to Bank Statement Check Book Management search in Grid Search Download Undep ar U 2 a Accounting IID 37 Acct VW Tre Am EV PostDate Y C Y Cleared v Pstd Cld VW Loc TEET Right Click Internal ID Check Book Note Easy e Bank Rec will not allow matching across locations Matching is permitted only within a given location When the transactions from multiple locations and multiple credit card wires have been matched continue the bank reconciliation or move on to the Reconciliation Summary Easy e Bank Rec Page 64 of 74 The bank tape reconciliation process is complete To properly reconcile to the GL follow the Book to Bank Statement reconciliation in the next section which describes the Reconciliation Summary and how to generate Reports Easy e Bank Rec Page 65 of 74 Reconciliation Summary Book to Bank CLICK on the lt RECONCILIATION SUMMARY gt button on the Tool Bar With Easy e Bank Rec you can readily compare General Ledger transactions with the bank transactions If there are variances between the cash and General Ledger they will be identified immediately You can also reconcile the GL and outstanding Document Numbers to compare and match the match the bank statement Specify the date range You can reconcile daily and even prepare reconciliations ahead of time GL
32. Dynamics GP Tool Bar Like the Microsoft Dynamics GP Bank Rec Easy e Bank Rec begins with recording the Bank Statement Record the Bank Statement CLICK on lt RECONCILE gt in the Tool Bar ENTER the Bank Statement Ending Balance from the bank statement in the field labeled lt BANK STATEMENT ENDING BALANCE gt Mi Reconcile Bank Statements File Edit Tools view Range Help sa Fabrikam Inc 4 12 2017 i Save X Delete Checkbook ID GPWACH OVIA Description Operating Checkbook Currency ID Z US Bank Statement Ending Balance Bank Statement Ending Date 3 31 2007 Cutoff Date 3 31 2007 Transactions ld 4a gt DI iy O Reconcile Bank Statements ENTER the Bank Statement Ending Date and Cutoff Date in the appropriate fields CLICK on lt SAVE gt This is used to determine the period Beginning Date There are essentially seven steps to reconciling your bank statement with Easy e Bank Rec These steps are grouped under the Action menu on the Tool Bar Easy e Bank Rec Page 31 of 74 Step 1 Import the Bank Tape CLICK on lt ACTIONS gt in the Tool Bar CLICK on lt IMPORT BANK FILE gt The Import Bank Statement window appears on the screen a Import Bank Statement Check Book ID i PWACHOYIA w Last Cleared Date 5 54 5555 Select File Format GPC WACHOVIA FILE Save Select Files c Program Files x86 Microsoft Dynamics GP DexToNet GPC_Bank_Statemer _ Work
33. EN SETUP AUTOMATED BANK TAPE TRANSACTIONS WINDOW button Automated Bank Tape Transactions Open Setup Automated Bank Tape Transactions Window Setup Automated Bank Transactions Easy e Bank Rec Page 20 of 74 All bank BAI codes will appear in the screen if they have been previously imported through a bank tape upload into Easy e Bank Rec for this Checkbook ID If the grid is blank return to this option after your first import of the bank tape aS Setup Automated Bank Tape Transactions i Source Company Fabrikam Inc CheckBook GPWACHOYIA Select or ALL v Show Account Desc Save Print x Close Help Bank Code Description Debit Credit Setup Destination Check Book Debit Credit fee feomrorwrer fit TT peme Z E e a E E S UPTO CONTRO OUETCOTE E a E E a a a E s me dT CP S pem p o A S o m a y o o s pma a o S S S 389 NEGATIVE ADI A CC tC Setup Automated Bank Transactions Screen This screen allows you to set up the BAI codes you want to process automatically from the bank tape to the appropriate accounts in the General Ledger For example you can select the BAI code 275 to automatically process ZBAs within one company and or across Microsoft Dynamics GP companies To set up to automatically process ZBAs within one company 1 CLICK on lt BANK CODE 275 gt for ZBA credits 2 Inthe Debit column CLICK on the lt DOWN ARROW gt to bring up the list of accounts and
34. ER the appropriate account in which to record the Unidentified Cash transaction and CLICK on the lt SAVE gt button to the right This should be a Balance Sheet account 4 N Adjustment Clearing Account N corresponds to the N button on the bank reconciliation screen Pressing the N button allows you to create adjustments to checks to match the Bank Statement transactions When you press the N button next to a particular entry an increase and a decrease will be generated affecting the cash account and the adjustment clearing account you have defined resulting in a zero transaction in both accounts This account will always be zero ENTER the appropriate account in which to record the Adjustment Clearing Account and CLICK on the lt SAVE gt button to the right 5 Small Adjustments Expense Account ENTER the appropriate account from the drop down menu in which to record the Small Adjustment Expense variances This must be a P amp L account CLICK on the lt SAVE gt button to the right This feature adjusts all small differences simultaneously For example if you set the Small Adjustment Expense Limit to 5 all small variances will automatically be adjusted in the bank reconciliation and expensed to this account Small Adjustments Amount Limit ENTER the Small Adjustments Expense Amount Limit in this field and CLICK on the lt SAVE gt button to the right 6 Automated Bank Tape Transactions CLICK on the lt OP
35. Microsoft Dynamics GP where the variance is less than the default amount you specify in Setup When these transactions are processed an increase or decrease bank transaction will be recorded in Microsoft Dynamics GP Mark All Equal as Reconciled this option allows you to instantaneously mark all matching items as reconciled inside Microsoft Dynamics GP This replaces the one by one clicking of matching transactions inside the Microsoft Dynamics GP Bank Rec Easy e Bank Rec Page 8 of 74 e Preview Move to Paid No Issue this option opens the window that allows you to preview all documents in the bank tape that are not booked in Microsoft Dynamics GP and move them to the Paid No Issue window 6 Paid No Issue Transactions Button this option opens the window that allows you to view the items that were previously moved to Paid No Issue and reverse matching items to Microsoft Dynamics GP 7 Reconciliation Summary this option opens the window that allows you to view the variances between the Checkbook Management General Ledger and the Bank Statement 8 Reports this option allows you to run the following reports By Excel GY Print XK Bank Tape Report Paid No Issue Trx Outstanding Checks Report Reports Tab 9 Excel this option allows you to export the transaction in the Easy e Bank Rec screen to an Excel spreadsheet Excel will launch when exporting 10 Print this option lets you print both the
36. N NAME field to the right of each Easy e Bank Rec column name and select the matching name NOTE If the bank file does not contain an Account Number you must ENTER a lt CONSTANT gt in the Constant field to the right It can be any value of your choosing If there is no matching column name in the bank tape you must ENTER a lt CONSTANT gt in the Constant field to the right It is appropriate to enter lt N A gt LI cx Fal Format Descipion Fie Type Fie Has BAI Code Excel Forna wath tab w ELEL Y TABOEUMITED If the bank file does not contain an Account Number enter a constant Add New import File in this field Mapping For impot File Selected in above Gad Eaty EBark Rec Coksnn Fie Format Cohen Name P BANK ACCOUNT NUMBER Bank Account Number BAI Code DOCUMENT CLEARED AMO Document Cleared Amourt DOCUMENT CLEARED DATE Document Cleared Date TRANSACTION OESCRMPTIO Transaction Description Cokan Name BAJ Code Bark Account Number Document Cleared Amourt Document Onaed Date Docurnert Nusnber Import File Data Entry Setup Screen 7 When you have finished mapping each column name CLICK on lt SAVE MAPPING gt Tab Header Setup 1 CLICK on the lt ADD NEW IMPORT FILE gt button Easy e Bank Rec Page 24 of 4 CE Import File Data Entry r EEE File Format Shot Name fraa FileFormatDesciiption Tabdemnted n File Type TAB SEPERATED V Work Book Name E Select Fil
37. OOOO oo po e eO w p po e OOOO 4 O60 S533700 CORPORATE TRADE PAYMENT CREDIT 164 w p o e e w p o e e man aT 140 ANN Ob db d Mmm AL A aT ae p Frint Close Bank Statement Already Imported Trx otep 2 Preview Matching Transactions Bank downloads often come without entry document numbers that match the Microsoft Dynamics GP entries Easy e Bank Rec automatically finds the matching deposits or check numbers based on matching transaction Easy e Bank Rec Page 35 of 4 amounts in the Microsoft Dynamics GP check register and assigns those document numbers to the corresponding bank tape entries The Document provided in the bank statement is never altered to ensure a proper audit trail Instead Easy e Bank Rec provides a supplemental field called Doc User Input that allows the user to enter a corresponding Check In this manner the integrity of the Document in the bank statement is preserved with a record of the Document to which the item was matched To preview matching deposit numbers 1 Under lt ACTIONS gt in the Menu Bar SELECT lt PREVIEW UPDATE DEPOSIT gt The following window appears on the screen This window displays all of the matching Deposit Numbers a Preview Update Deposit s Bj x m Flag Items Where Bank Cleared Date Is Display Records Check Book ID GPWACHOVIA E More Than i Days Before GL Post Date Show Vv E m Refresh Mark AllRecardsAs Selected C U
38. SELECT the appropriate General Ledger account 3 In the Credit column CLICK on the lt DOWN ARROW gt to bring up the list of accounts and SELECT the appropriate clearing account To set up to automatically process ZBAs across Microsoft Dynamics GP Companies 1 CLICK on the lt SETUP gt button for the 275 BAI code to open the window where you can select the appropriate Microsoft Dynamics GP company Company Code Fabrikam K Ine Check Book UPTOWN TRUST Debit Account Cash Suspense Credit Account Cash Operating Account Cancel Setup Automated Bank Transactions Easy e Bank Rec Page 21 of 74 2 SELECT the Microsoft Dynamics GP lt COMPANY CODE gt from the drop down list 3 SELECT the lt CHECKBOOK gt from the drop down list 4 SELECT the lt DEBIT gt account from the drop down list 5 SELECT the lt CREDIT gt account from the drop down list 6 CLICK on lt OK gt Repeat this process for each BAI code that you want to automate Typical BAI codes might include Interest Charges ZBA transactions Service Fees and SWEEP transactions NOTE If the ZBA will be uploaded in the destination company it is suggested that you not perform the set up across companies 7 Set Import File Mapping This function allows you to set up your bank file import mapping CLICK on the lt SETUP IMPORT FILE MAPPING gt button Setup Import File Mapping Setup Impor
39. SET PASSWORD gt Set Change Your Password here Please Enter New Password 000 Please Re enter New Password en 4 Set Password Set Change Password Easy e Bank Rec Page 18 of 74 Next you must enter and validate your password in the field labeled Please Enter Password at the top of the screen then CLICK on lt VALIDATE PASSWORD gt j Validate Password to Make Changes to data on this screen Please Enter Password Validate Password Validate Password You will set up your Adjustment Accounts Information next Adjustment Account Information D Adjustment Amount Limit 200 00 D Adjustment Expense Account Ooo 6B01 00 tt sts U Paid No Issue Cash Account 000 111500 N Adjustment Clearing Account 000 660200 it Small Adjustment Expense o00 6603 000 C S ts Small Adjustments Amount Limit 91000 Open Account Maintenance Window Adjustment Accounts Information 1 D Adjustment Expense Amount Limit D corresponds to the D button on the bank reconciliation screen When you press the D button next to a particular document the variance between the bank statement and the checkbook will be adjusted automatically The adjustment will create a Decrease Adjustment or an Increase Adjustment on the same document number in the Bank Rec module GL transactions will be posted as well No adjustment can be greater than the amount specified in this field The value you enter should be the
40. User Input field is blank you will be prompted to confirm the delta A in the amount 3 Ifthe amounts match or do not match but there is an existing entry in the Document User Input field you will be prompted to confirm the different document number you wish to enter Amount Amount Check Book Management or Bank Statement RIGHT CLICK on any amount on either side of the grid to display two options Easy e Bank Rec Page 62 of 74 Bank Statement Undeposited Receipts Download P P Show IIDs Locations M _ DocHFromB Y Doc Userlnput V7 Cleared S Y Bank Dat v Dif SVB Y Description Y m 2 0 Eoo 65 00 03 04 2007 65 00 301 el COMMERCIAL D Show Possible Matches Show All Records Exit MIN i K MLN 1 Right Click Amount Show Possible Matches Restricts the grid view to possible matches on the opposite side with the same amount Show All Records Displays all of the records in the grid view Location This capability is used to find Location matches on both the Check Book Management and Bank Statement sides of the grid for credit card wire reconciliation Make sure the Show IIDs Locations checkbox is checked RIGHT CLICK the lt BANK LOCATION gt IV Show llDs Locations MI N _ Doct FromB Y Doc User VW Cleared SV Bank Date w Diff Zv BY Description Y BankliD v BankLoc al oruc pEECO EAICOAEEEESAOC one Show Possible Matches Show All Records Exit Right Click
41. VW MINE 5752007032700 575200703270001 3 171 65 03 27 2007 Ee ZBA DEBIT 575 MIN E 5752007032800 575200703280001 13 342 63 03 28 2007 0 00 575 ZBA DEBIT 575 i erea ea eam sa 000 7s aA DEBIT 7s mv 2 ing B Right Click Doc User Input Amount Check Book Management or Bank Statement RIGHT CLICK on any amount on either side of the grid to display two options Bank Statement Undeposited Receipts Show IIDs Locations Description COMMERCIAL E K Show Possible Matches Show All Records Exit Right Click Amount 1 Show Possible Matches Restricts the grid view to possible matches 2 Show All Records Displays all of the records in the grid view Location used to find Location matches on both the Check Book Management and Bank Statement sides of the grid for credit card wire reconciliation Make sure the Show IDs Locations checkbox at the function bar is checked RIGHT CLICK the lt BANK LOCATION gt IV Show IIDs Locations BankDate Y Dif Y B Y Bank IID Show Possible Matches Show All Records Exit Right Click Location SELECT the option you wish To display all the records for the location on both sides of the grid CLICK on lt SHOW RECORDS FOR LOCATION XXX ON BOTH SIDES gt To display possible Easy e Bank Rec Page 16 of 4 matches for that particular record CLICK on lt SHOW POSSIBLE MATCHES gt Note You can sort
42. ariance between each reconciled statement Ending Balance Statement Variance drill down Adjusted Great Plains Page 75 of 74 How to Resolve Variances If a check is voided in a future month it is no longer accounted for in the Dynamics GP bank reconciliation in versions prior to Dynamics GP 10 0 It is considered voided However at the end of this closing period it is possible that a check was outstanding as the void occurred in the future This line compensates for these items
43. asy e Bank Rec Page 43 of 74 4 CLICK on the lt NOTES gt button on the selected transaction CE a E E E E EE j Tee e e a a E Sd a A E e pe ee e 7 aoe e i Print Refresh Process Automated Bank Tape Transactions Automated Bank Transactions Notes The following window will open The bank statement detail is displayed below the line item 5 CLICK on the lt DOWN ARROW gt below lt CREDIT gt on the upper right of the screen to display the accounts and descriptions E Bank Transaction Details a o ae Ute ingat Field lo update Document Numbert Se eee Cexwed Date Document 8 User input Amok Descapbon Import Date Bark Code P 03 18 2007 0 15030000 ZBA CREDIT 275 016 2010 275 000133000 sw ni Automated bank transactions Details To over ride the default account setup for the transaction Easy e Bank Rec Page 44 of 74 J Account Description 000 1190 00 Cash Suspense Automated bank transactions Override Default 6 CLICK on the desired Account and Description 7 CLICK on lt SAVE AND CLOSE gt The transaction type will be permanently associated with the selected account unless over ridden at a future date 8 CLICK on the lt PROCESS AUTOMATED BANK TAPE TRANSACTIONS gt button to process the transactions This will automatically create GL and Bank transactions for you and does not require posting in Microsoft Dynamics GP 9 The window will close and a message wil
44. beled lt PROCESS D BUTTON gt A message box appears on the screen asking if you want to create the D button adjustment CLICK on lt OK gt to adjust the document Conversely CLICK on lt CANCEL gt to cancel the process A decrease adjustment will be created and a GL entry will be posted If the lt PROCESS D BUTTON gt is grayed out and not active it means you either do not have an account in the setup or you have exceeded the allowable difference limit set in the setup Process N Button The N Button is used to move partial or complete amounts from one document number to another consolidate with proper traceability CLICK on the lt N BUTTON next to the transaction you wish to transfer The following window will appear on the screen HE Process N Button Check Information Check Book GPWACHOVIA Check Number 00000000000000000001 Amount 6 564 1 1 Type DEP Check Date 3 31 2007 Diff 6 564 11 Action Displays the LU button Dbutton N Button Move to Unresolved ultimate result Original Amount Transfer mount Final Amount per Document Doc From O000000000000C 146 564 11 sa 00 Number 6564 11 Doc To 5432 0 00 6 564 11 Select Posting Accounts Cash Acco N Button Account 000 6602 00 N Adjustment Clearing System Comment ii amount 6 564 11 from OOOOO000000000000001 to 54324 by sa on 03 31 2007 User Comment po of document number to error in actual entry Process N Button Cancel
45. ceeeeneceseuecessneesseness 53 Step 7 Preview Move to Paid NO ISSUC cccccccccccccceeeeeeeeeseesseseeeeeeececccceseseesseeueeeeeessseeeeess 57 Paid NOISSUC Transactions cicsecsenscssncensriessaccsnnusasseoceanedsnnentaeteeavivstisrinesecuenss 57 Retrieving Paid No Issue TransactionS ccccccssecccesececeesceceeseceeeeecessuecesseness 59 Multi Location Multi Credit Card Wire Recon ciliation c ccecccsseccceececeececescecetceceeees 60 Right Click Features for Matching ccccssscccsssccccsececesececeesceesenecesesceseuass 61 Document NUMDET sins sicactnsncnsusenadeatcneuehsannsbascieiadesaanseasheavadsssanaedassdavadeasemendesst 61 AOU e E E E E ESA 62 EOC Oee E A E E E E 63 AALE Aa D E A E E arse A E E 64 Easy e Bank Rec Page 1 of 74 Reconciliation Summary BOOK to Bank csccccsseccccsseeccesececeececseececeuseceeeecesseeceseeeeeees 66 Vahlances DilMDOW Minctibemice ote settee teeta ate mea ata eh ts 67 Balik Std Cement MEO EMA UON rerien E A A 69 FG pcsenasez svcnsiresacneneaccieguaeee E E E 70 REDOT chuck sacra heel yur EATEN AET 70 a Gl a ial fe a S morie are eeeresete re ne Rae aera Ries na rene eg tary eS eae rea 71 Grid for Dynamics GP Reconciliation cccessccceesececesececeeeeeeeeeeeeeaeceseeseeees 74 Easy e Bank Rec Page 2 of 74 WHAT S NEW Description of the Easy e Bank Software Easy e Bank Rec is a PC based tool published by BTPTechnolo
46. ching only occurs on check numbers that are zero Many banks now insert miscellaneous information that will not help in recognizing the transaction The best match is accomplished by amount but can only occur if the document number is blank BAI USRDF1 Format e In some instances the Bank Account number is normally stored in the Account field in the Dynamics GP accounting gt Cards gt Financial gt Checkbook Checkbook Maintenance screen The field in question is the 4 one from the bottom left Bank Account It sometimes conflicts with the number used in the BAI file For example the Account number field in GP will have 1234567899 while the 03 record in the BAI file will have 001234567899 Some 3 party software use the account field for safe or MICR printing This import format will look for the proper match with the BAI file in the user defined field 1 rather than the account field GPC Wachovia File e Custom import format from an HTML scrape Standard BAI Format e This format will import any BAI or BAI2 format and respect the special encoding for the funds types in BAI formats as supplied by banks It should be the default test format for any BAI bank file e No mapping is needed e Note that the Bank Account field in the Check Book ID must match the value after the 03 in a BAI file in order for the system to recognize which section of the BAI to import Easy e Bank Rec Page 33 of 4 In the example below the fo
47. counts you identified in Setup Two comment fields appear at the bottom of the screen 1 System Comment this is a read only field that identifies the user and the date the transaction was moved to Paid No Issue 2 User Comment the user can enter additional comments in this field CLICK the button labeled lt MOVE CHECKS CASHED TO PAID NO ISSUE WINDOW gt A message box appears on the screen asking if you want to move checks to Paid No Issue CLICK on lt OK gt to move the checks to Paid No Issue Conversely CLICK on lt CANCEL gt to cancel the process Easy e Bank Rec Page 58 of 4 Retrieving Paid No Issue Transactions To retrieve the bank tape transactions you have set aside in Paid No Issue CLICK on the lt PAID NO ISSUE TRX gt button at the top of the Easy e Bank Rec screen The following window will appear on the screen PS Paid Me issue Iry Check Bock GWACPSOVIA Atos Pret Reports x eee CM Cuol Dae Cone Sek Ool Dae Coo Show Enter Doo to Check Book Management Searchin Grd Sevech On Bank Statement but Not in Great Pians Docwmere B V tat SV PotOee Y Cok YV Cove EV Docunert 8 Y OeeetA Y Gok EV OW EV Cocke Y Revere tan ett 200 Oo rn se 1 400 0 Ow aviri _4 4 _ gt 4 ___ __ __ 4 __ ___ i EGTA Memi Ommam ipi 0 Gee Reverse n a viet Bs a E v eae Total CM Cleared Tote Bord BLED yo
48. d 2 Paid No Issue Trx Report This report displays the transactions that you set aside in the Paid No Issue holding area 3 Outstanding Checks Report This report displays the outstanding checks and deposits in Microsoft Dynamics GP To access the reports CLICK on the lt REPORT gt button in the Easy e Bank Rec Main Screen CLICK on the report you wish to view and or print Print Options Easy e Bank Rec allows the user to print to Excel and the Screen or to Print the Grid Print Options Print Print Grid Print Screen Print Options If you export to Excel the application will save the file and then launch Excel The Print Grid allows you to eliminate elements on the report you do not wish to print Easy e Bank Rec Page 71 of 74 ra Printer Setup Hidd Header Eeo AE WY Doc User Input oc User Input e l m cl I Acct Loc E E Print Preview Printer Setup Printer Setup UN CLICK the elements you do not want to print and CLICK on the lt PRINT PREVIEW gt button to see the print view Easy e Bank Rec Page 72 of 74 6P OOBBB8 a Print Preview Easy e Bank Rec Support Telephone 703 760 9700 Email info btptek com BTP Technologies Inc 4001 Westfax Drive Suite H Chantilly Virginia 20151 Easy e Bank Rec Page 73 of 74 Easy e Bank Rec Addendum Grid for Dynamics GP Reconciliation The application offers a Book to Bank Reco
49. ded bank statement CLICK on this option to run the process to extract the Merchant ID from the bank tape information This process normally runs during the import When completed you will receive the following notification Easy e Bank Rec Page 28 of 74 Easy e Bank Rec xX Process completed Process Completed Notification CLICK on lt OK gt to complete Internal ID Maintenance This feature is useful only for custom imports that extract the Merchant ID or Location ID from the downloaded bank statement This screen provides a view of the Internal ID Maintenance mapping table where the cross referenced IDs and Locations are maintained for credit card wire reconciliation and cash deposits made in multiple locations within a master bank account It will allow end users to view only a particular location or Internal ID Merchant ID within the complete set of data for the check book ID which might comprise many locations a Internal ID Maintenance Iof x Internal ID Y Internal ID Fromimp WW Location Y Credit Card Type W gt CheckBookID w LoadedFrom VW LoadedOn VW p 0000010025 0000010025 10025 CASH pF End User 07 28 2010 ie ig i m 1041138629 1041138629 AMEX OoOo ti iCiSYS gpctilesgroup R 08 18 2010 1041138645 1041138645 AMEX PCS gpcfiles group R 08 18 2010 1041138678 1041138678 AMEX A gpcfiles group R 08 18 2010 1041138769 1041138769 223 AMEX apctiles qroup F 08 18 2010 Fo b
50. deposited Receipts Show lIDs Locations Pu aa Doe Y TrkAm EY PostDate Y C Y Cleared SV Pstd Chd Y z y CY D C E a C a C C ses a eof o 5 7a aT DEF DEJN eae Boorer a BEF m7 oo AnAHAnAANnAAAoON al al 3 27 200 600 0 y U gpg Doc T TrAm SV Post Date Y C Y Cleared zy Pstd Clrd W _ Doct FromB Y Doc UserlIn VW Cleared SW Bank Dat Y Diff XA gt ab arm oooooo00000000000001 6 564 11 564 1 E 0 00 03 04 2007 AA pi s6504T HUD nooooooooooooooooN 10 24 II 03 11 2007 0 00 03 feel taint ut poorest a a Split Screen Bar o L Right Click Features Right Click Features display matches for the following fields Document Right Click the Document on the Check Book Management side of the grid A message appears that identifies the match Click on lt Select Document Number gt to copy the Document Number Check Book Management Etter Check to Right click in the Document field then ov Geaed SY right click on the Select Document tey eared message to copy j Select Document Number 87786 for Matching J Right Click Document Number Document User Input RIGHT CLICK in the lt DOC USER INPUT gt field on the right side of the grid to paste the Document Number Easy e Bank Rec Page 15 of 74 Undeposited Receipts Show lIDs Locations M N _ Doc FromB W Doc User Input Y Cleared SV Bank Dat 7 Diff Sy BY ail Description
51. each Transaction Description in the Suggested Code column If the suggested codes are acceptable CLICK on the lt SMALL BUTTON gt in the Suggested Code column to accept the code then CLICK on lt SAVE gt to complete the import process Easy e Bank Rec Page 34 of 4 If you prefer to enter your own codes CLICK on the lt SMALL BUTTON gt in the Bank Code column A Bank Code Master List window will appear on the screen Bank Code Master List Seles Bank Code Ww Type W Debit Credit WF Bank Code Description Ww Click to SELECT STATUS H OPENING LEDGER R SUMMARY C amam E CR TOTAL CREDITANOUNT TDS ios Sunway or __ereoisnor SSCS fio SUMNaRY CR DEPOSITS SUBVECTTOROAT ior Suwwany CR TOTALADJUSTMENT CREDITS YTD oe fora oR __ dCEDTTIAN TPE Bank Code Master List CLICK on the lt BUTTON gt in the Click to Select column on the right of each line item to map the BAI codes to the transaction descriptions If you try to re import the file by mistake Easy e Bank Rec will not allow duplicate entries to be re imported The duplication is based on the dollar amount in the Document Number The following window will appear on the screen that displays the previously imported file data Bank Statement Already Imported Transactions Check Book ID EEMO Bank Code w Doc VY Cleared Date V7 Cleared Amo Y Description 0 03 03 2007 21 702 4600 CORPORATE TRADE PAYMENT CREDIT 164 a p pom am
52. es Gpcfies group Research and Development Easy eBank Rec BankR Import File Data Entry Screen 3 2 From the drop down menu for File Type SELECT lt TAB SEPARATED gt 3 ENTER the File Format Short Name and File Format Description in the corresponding fields 4 CLICK on the lt ELLIPSE gt button next to the Select Files field to browse for your bank file 5 Next you will map the file format column names to the columns in Easy e Bank Rec CLICK in the FILE FORMAT COLUMN NAME field to the right of each Easy e Bank Rec column name and select the matching name OTE If the bank file does not contain an Account Number you must ENTER a lt CONSTANT gt in the Constant field to the right It can be any alue of your choosing If there is no matching column name in the bank ape you must ENTER a lt CONSTANT gt in the Constant field to the right It s appropriate to enter lt N A gt 6 When you have finished mapping each column name CLICK on lt SAVE MAPPING gt Easy e Bank Rec Page 25 of 4 impor Files lt Fiel Foemat Sheet Name Fiet Format Descaption E anal Excel Format with tab w Add New Import Fie Mapping For Import Fie Selected in above Grid _ Fees Be Ean EBark Rec Comin 2 BANK ACCOUNT NUMBER ea oo ete o R DSCUNERT CLEARED e E i a aooe fom SCS p a RasacTiON escena Bos i Date Cleared Import File Setup Screen 2 8 Regis
53. etup to be processed automatically This process will create the matching transactions in Microsoft Dynamics GP across multiple companies if required 1 CLICK on Actions in the Tool Bar Menu SELECT lt PROCESS AUTOMATED BANK TAPE TRANSACTIONS gt The following window appears on the screen Process Aviometed Hare lage ransactions BA DEEN SESE ea EGEL EEE oE RAST BA Tong PECCO 7 PRS GA GOD TION eo ante be e a _ ENO wn 100100 F seh AST BA 000110 TE gt ZBA DESIT a Gore TUTE Pek PRST BAT 0001102 g 7 4 55 ojaa an Sa TOOT Fa e wean E mT fa raha EAA L fuera TT es O_ E E C e zane S vonsou mri rasta STOR OOS ROTI e ae a C a B z ST E L A CA A A a e ee aaa C oe _ L Vea 9 453 37 ONE 2007 CORPORATE TAA 700 3000 core ar CE 81 1750 G Eeo B ioon SD Fabebam s PRST BAT OOD 1130 GOO FON oleae mae a 1100 OOD Prada TRRST BA on oT Process Automated Bank Trx Main Screen i i 2 REVIEW the data on the screen 3 Optional CLICK on the lt PRINT gt button SELECT from the options Export to Excel Print Grid or Print Screen and follow the directions in the corresponding windows Print Options Export to Excel Export to Excel Print Print Grid Print Screen Print Options To view the bank statement detail or change a booking account for a particular transaction E
54. gies LLC that vastly simplifies the monthly Bank Reconciliation in Microsoft Dynamics GP accounting software The program is Windows XP Vista Win 7 Terminal Server and Windows Server compatible Release Notes Easy e Bank Rec includes the following new features e Ability to match one to many many to many and many to one transactions e Multi location and multi credit card electronic wire ACH reconciliation with the ability to sort view and limit the view for a particular site which provides a micro location view reconciliation within a checkbook ID Custom import automatically extracts the Merchant ID from the bank statement The fee for the custom import will be determined by the Scope of Work Automatically extracts Location and Transaction Type from the accounting bank reconciliation transaction Provides a mapping table for Location Transaction Type and Internal ID merchant ID that cross references both the accounting and bank statement transactions to produce a Location and Internal ID common to both Right clicking on Location or Internal ID provides a view of a single location or Internal ID within a master bank account Automated matching occurs only within the location The system prevents the matching of like amounts across locations when Location or ID is present e The Preview Update Deposit and Preview Update Check windows contain a number of new features Itis pos
55. grid and the screen 11 Close CLICK on this option to close the Easy e Bank Rec application 12 Color Scheme Colors have been added to the Main Screen grid to facilitate matching e Yellow Transactions highlighted in yellow are items in the accounting system that are unmatched e Teal Transactions highlighted in teal are items on the bank statement that are unmatched e Red Transactions highlighted in red match but there is a variance between Issued and Paid e White Transactions that completely match the variance is zero Function Bar The Function Bar contains the following 1 CM Cutoff Date Easy e Bank Rec Page 9 of 74 2 Bank Cutoff Date 3 Marked Changes the view to display All Unmarked or Marked items in the grid 4 Check Deposit Changes the view to display All Checks or Deposits in the grid 5 Refresh Grid Options Used to refresh the data in the grid based on user specified views Retresh Grid Options Select one of the following options All C Equal Not Equal Not Equal in both sides Difference lt ho Eliminate lt 10 Banked not in CM C GL Date lt gt Trs Date C InCM not Booked Zero Trx Small Adjustments Max Limit 1 0 00 OK Cancel Refresh Grid Options All Displays all items on the grid Not Equal Displays items where the difference between issued and paid is not equal to zero Difference lt Displays
56. items where the difference between issued and paid is below the default threshold Banked not in CM Displays items that have been processed at the bank but no matches are found in the accounting system In CM not Booked Displays items that were recorded in the accounting system but the bank has not yet cleared them or no match was found Outstanding items Equal Displays items that completely matched where the variance is equal to zero Not Equal in Both Sides Displays items that have a match but there is a variance between the total amount issued and banked Eliminate lt Eliminates from the grid all items that have a variance below the set minimum dollar amount GL Date lt gt Trx Date Displays any item where the General Ledger date is different from the Transaction date Zero Trx Displays items that are zero in total in the accounting system Easy e Bank Rec Page 10 of 74 Small Adjustments Max Limit Displays the maximum limit for small adjustments established in the Setup 6 Show Used to populate the grid 7 Split Button The Split button is used to process selected records and match one to many many to many and many to one transactions 8 Clear Filters Click on the Clear Filters button to clear all grid filters at once Main Screen Components Mi Easy e Bank Rec File Edit Tools Help GP WACHOVIA Change Reconcile Maintenance Actions Paid No Issue Trx Reconciliation Summary
57. l IDs from Import Data Internal ID Maintenance Delete Latest Import Update Internal IDs in Accounting System Maintenance Tab e Setup Options used to set all system defaults per selected Check Book ID such as passwords and adjustment account information Users can also set up the import file mapping for automated bank tape transactions e Update TRXDATE with GLPOSTDT Microsoft Dynamics GP Bank Rec works on the transaction date If the transaction date is not equal to the GL date you will not be able to reconcile This option will store the Transaction Date in the user defined 1 field and make the transaction equal to the GL date As a result the Microsoft Dynamics GP bank reconciliation will match the Easy e Bank Rec reconciliation Easy e Bank Rec Page 6 of 74 e Bank Code Master List Maintenance This option allows you to view all the BAI codes For more information on BAI codes go to http www x9 org standards free X9_BAI_ Codes_Version_2 Cas h_Management_Balance_Reporting pdf or http www x9 org and search for Cash Management Balance Reporting Specifications Version 2 In 2009 the standards were transferred by the Banking Association Industry BAI to the X9 Financial Industry Standards e Extract Internal IDs from Import Data Runs the process that normally happens during the import to extract the Merchant ID from the bank tape information and stores the Bank ID and Bank Location for all ba
58. l appear on the Main Screen that will ask you if you want Refresh the Grid CLICK on lt YES gt to view the matching Bank Tape transactions in Microsoft Dynamics GP Step 4 Preview Create Small Adjustments To preview and create small adjustments 1 Under lt ACTIONS gt in the Menu Bar SELECT lt PREVIEW CREATE SMALL ADJUSTMENTS gt The following screen will appear Easy e Bank Rec Page 45 of 74 a Preview Create Small Adjustments Adjustment Amount 10 00 Check Book SSS M Select Posting Accounts Cash Account 100 1000 00 Operating Small Adj Account S Small Adjustment Expense System Comment check is adjusted by small amount of 10 00 by sa on 03 31 2007 User Comment Print Process Small Adjustments Cancel A Preview Create Small Adjustments The Small Adj Account will default to the accounts you identified in Setup Two comment fields appear at the bottom of the screen 1 System Comment this is a read only field that identifies the user and the date and default amount by which the check is to be adjusted 2 User Comment the user can enter additional comments in this field Both comments will appear in the yellow post it note in the Microsoft Dynamics GP bank transactions CLICK on the button labeled lt PROCESS SMALL ADJUSTMENTS gt A message box appears on the screen asking if you want to create small adjustmen
59. liation l CASH o TT CREDIT CARDS e i ARN CREDIT CARD WIRE ma TSA PAYMENT PROCESSOR LOCATION STORE POS BANK TRANSACTION TYPE CASH DEPOSIT pp ee BAI STATEMENT DOWNLOAD DISCOVER ELECTRONIC CHECK SCANNER TRANSACTION MATCHING 4 BANK STATEMENT Microsoft Dynamics GP Pe DOWNLOAD Description ACCOUNTING EASY e BANK REC Bank Rec Transaction File Reference File The Internal ID facilitates the matching of credit card wires and cash deposits within a given location In order to work Easy e Bank Rec Page 60 of 74 A custom import must be developed The code is developed from the Doc number and the Description of Paid to extract Location and Transaction Type Install the custom code Set up Internal ID table Select the custom import to import the bank transactions To begin CLICK on the lt SHOW IITDS LOCATIONS gt checkbox in the Function Bar The grid expands to display six columns Checkbook Management Left Side of Grid 1 Accounting ID 2 Account Location 3 Bank the bank Location for sorting purposes 4 Location Location of the store for sorting purposes Bank Statement Download on Right Side of Grid 5 Bank ID the bank statement Merchant ID 6 Bank Location derived location from Bank ID The grid will be color coded as follows e Yellow Transactions highlighted in yellow are items in the accounting system that are unmatched
60. limit between Issued and Paid entries that your organization is comfortable with ENTER the Adjustment Expense Amount Limit in the field NOTE For the next four fields if the account does not validate in the window CLICK on lt OPEN ACCOUNT MAINTENANCE WINDOW gt and enter the account information When you have finished CLICK on lt SAVE gt to refresh the drop down list with the account you have created 2 D Adjustment Expense Account ENTER the appropriate account from the drop down menu in which to record the Adjustment Expense variance This must be a P amp L account CLICK on the lt SAVE gt button to the right 3 U Unidentified Cash Account U corresponds to the U button on the bank reconciliation screen This account is used to temporarily record cash transactions that appear on the bank tape but do not correspond to entries on the GL For example Easy e Bank Rec Page 19 of 74 1 the Bank issues an erroneous credit or debit on your account and you need to record it in the current month in order to reconcile your bank statement When the bank reverses the transaction in the next month credit or debit the Unidentified Cash Account accordingly 2 you receive a wire transfer that you can t identify but you want to close the bank reconciliation and further research the transaction This feature allows you to record the wire transfer as a cash transaction and close the bank reconciliation ENT
61. llowing bank account must be stored in the bank account field in Check Book Maintenance 4121876348 Sample BAI header Oy E2V000246 376056 1690 00606 0I908 01 080 427 077610061090 1210 9696 1 1005267557 03 4121876348 USD Standard QIF File no BAI Code NOTE If Excel is used you must specify the name of the sheet inside the workbook typically Sheet or Import CLICK on the lt ELLIPSE gt button to the right of the field labeled Select Files to browse to the location of the file SELECT the file to be imported CLICK on lt IMPORT gt A message appears on the screen that the import has been successful IF YOU HAVE A BAI FILE MOVE TO STEP 2 PREVIEW MATCHING TRANSACTIONS For bank files without BAI codes it is necessary to map the transaction descriptions to the appropriate BAI codes A window will appear on the screen that will allow you to map the BAI codes to the description Description Bank Code Mapping Seles Check Book ID GPWaACHOVIA Bank Code amp Description Mapping Transaction Description Suggested Code Bank Code Bank Code Description F ACH Debit 451 ACH DEBIT RECEIVED F Automatic Payment Withdrawal 00 SOT INOMIDUAL AUTOMATIC TRANS Check Paid 475 CHECE PAID T7OTHER DEPORT ECA i Incoming Wire o IncomingwieFNS o i OE Incomingwie NAMSA a ee Vie o E arr Pritt Save Description Bank Code Mapping Easy e Bank Rec provides a list of suggested codes for
62. lved issues such as wire transfers or variances and close the bank reconciliation while you research the item This function should be used only after all other bank reconciliation tasks have been performed D Button Used to adjust any bank rec entry up to a maximum allowable amount to a default P amp L account M Button Used to mark individual entries as reconciled equivalent to placing the checkmarks in GP N Button Used to move partial or complete amounts from document to another consolidate with proper traceability This creates two documents in the bank reconciliation module one increase and one decrease adjustment Question Button Corresponds to the highlight color and opens a notification that explains the transaction Main Grid Question Button Easy e Bank Rec Oo Transaction cleared the bank on 03 19 2007 but has not posted toGl Main Grid Question Transaction Explanation Ellipse Button Check Book Management If a given entry on the left side of the grid has only one transaction associated with it the button to the right of the entry displays as an ellipse If there are multiple associated transactions the actual number will appear on the button in red For example if the number 3 appears on the ellipse button it means there are 3 items in the accounting system that comprise the total that appears in the grid Clicking on the button will allow you to drill down to the associated transaction
63. nciliation Grid The Grid also compares the calculated total with the data stored in the accounting system Below you will find the explanation of every element in the grid Description Easy e Bank Rec Last GL reconciled statement amount as documented as retrieved from the prior reconciliation GL Bal Prev Period Calculated Sum of all transactions as stored in GP per date range specified from the General Ledger not the summary table GL Period Variance calculated from detail transactions Calculated balance Sum EOP Calculated GL of A B Calculated Amount of outstanding documents by GL Posting Date not marked as cleared GP does this by transaction date which will cause reconciliation variances with documents that have a transaction date different than the GL Posting Date drill down to print or re print previously reconciled bank statements Outstanding Transaction by GL Date Easy e Bank Rec Great Plains Actual Description The beginning balance as stored in Great Plains Beginning Balance GL Stored Period GL Stored Variance from GP summary tables Stored End of Period EOP Actual J value in Great Plains Calculated Amount of outstanding documents by Document Transaction date not marked as cleared GP does this by Transaction Date which will cause reconciliation variances with documents that have a transaction date different than the GL Posting Date drill
64. nk statement records e Internal ID Maintenance This screen provides a view of the Internal ID Maintenance mapping table where the cross referenced IDs and Locations are maintained for credit card wire reconciliation or cash deposits e Delete Latest Import Clicking on this button allows the user to delete the most recent import e Update Internal IDs in Accounting System The system will extract the location and transaction type from the accounting transaction and derive the Internal ID from the Internal ID maintenance table 5 Actions The options under Actions represent the steps to complete the bank reconciliation They are Paid No Issue Trx Reconciliation Sumr Import Bank File Preview Update Deposit Preview Update Check Process 4utomated Bank Tape Transactions Preview Create Small Adjustments Mark All Equal as Reconciled Preview Move to Paid No Issue Actions Tab e Import Bank File this option opens the window that allows you to select the bank file for importing e Preview Update Deposit this option opens the window that allows you to preview all the deposits with missing document Easy e Bank Rec Page 7 of 74 numbers in the bank tape Items are matched by amount Easy e Bank Rec will automatically match those transactions to the corresponding entries in Microsoft Dynamics GP and will populate the document number in the bank tape Deposits Transfers and Increase Adjustments are matched t
65. nselected C More Than fi Days After GL Post Date Iv Selected and Unsele TRARACOCIA Aco IMMERLIGL DI Doc v Amou Ev GL Post Date Bank Doc 7 Bank Cleared Amount SV Bank Cleared Date MMERCIAL DEPOS N A ooooo000000000000 2 708 58 i 03 30 2007 ae fos 82 708 58 03 31 2007 COMMERCIAL DEPOSIT 301 1 799 73 03731 2007 COMMERCIAL DEPOSIT 301 m 21 702 46 03 03 2007 CORPORATE TRADE PAYMENT CR AJ UUL ES XFR000000011 21 702 46 Transter From Pa J fozos2007 Print Update Deposit s Close Preview Update Deposit Matches are performed when the Bank Document Number is zero and the amount matches In all cases there must only be one entry for that document in the bank reconciliation NOTE the following features e The transaction Payer Payee and item description appear on the left side of the grid Easy e Bank Rec Page 36 of 4 z Preview Update Deposit s Flag Items Where Bank Oleared Date Is Check Book ID GPWACHOVIA a More Than 7 Days Getore Mark AlRecordsAs C Selected Unpelected More Than io Days After G s DACE M A aC M A A E e A Preview Update Deposit Payer Payee e The bank download transaction description appears on the far right of the grid Display Records rE r p m ected an Unet 7 R 03a COMMERCIAL DEPOSIT 301 ssn oao commERCAL DEPOSIT an sree eoar CORPORATE TRADE P
66. o bank statements entries Automated matching prevents matching of like amounts across Internal IDs If an Internal ID is present in accounting or the bank statement transaction the matching record must contain the same ID Preview Update Check this option opens the window that allows you to preview all the checks with missing document numbers in the bank tape It will automatically match those transactions to the corresponding entries in Microsoft Dynamics GP and will populate the check number in the bank tape The Preview Update Deposit or Checks Matching will actually strip leading zeroes and do the matching for you Checks Transfers and Decrease Adjustments are matched to bank statements entries Automated matching prevents matching of like amounts across Internal IDs If an Internal ID is present in accounting or the bank statement transaction the matching record must contain the same ID Process Automated Bank Tape Transactions this option opens the window with all the BAI code transactions that you set up to process automatically such as ZBAs interest charges SWEEP transactions and service fees When these transactions are processed an increase or decrease bank transaction will be recorded in Microsoft Dynamics GP The Notes button allows the user to change the default distribution Preview Create Small Adjustments this option opens the window that allows you to view all the transactions in the bank tape and
67. or Credit Cards types Cash receipts are in the GL but not in the bank reconciliation because the deposit was not created The speed issue with large Chart of Accounts affecting the N D and U drill down buttons has been resolved D button screen allows the user to override the default D account and book the opposite of cash where required The full description available in the bank statement download with Automated Bank Transactions is now stored in the yellow sticky note in GP with Automated Bank Transactions A Clear Filters button has been added to clear all grid filters at once The most recent import can be deleted by the end user and the file can be re imported Easy e Bank Rec Page 4 of 74 EASY E BANK REC REFERENCE MANUAL Accessing Easy e Bank Rec To access Easy e Bank Rec simply CLICK on lt ADDITIONAL gt in your Microsoft Dynamics GP toolbar then CLICK on lt EASY E BANK REC gt by Microsoft Dynamics GP se 4t Microsoft Dynamics GP Transactions Inquiry Reports Cards Additional Home Loo EE Re Main Screen The following is a view of the main screen of Easy e Bank Rec Al Easy e Bank Rec File Edit Tools Help GPWACHOYIA Change Reconcile Maintenance Actions Paid No Issue Trx Reconciliation Summary Reports y Excel g Print x Close About CM Cutoff Date 03 31 2007 Bank Cutoff Date 03 31 2007 w Marked JALL v Check Deposit ALL Refresh Grid
68. r UN CLICK the checkboxes in the Include Receipt Types box to change the view of the cash receipts 1 e Checks Cash or Credit Card 2 CLICK on the lt REFRESH gt button to change the grid to the desired view Easy e Bank Rec Page 54 of 4 nelude Re eipt pes i Date Rang ee al M Checks M Cash MP Credit Card Stat 00171900 End 03 30 2010 Undeposited Receipts Refresh In this view Cash Checks and Credit Card Payments are displayed HE Undeposited Receipts Total Receipts Cash Receipts Credit Card Payments of Items 6 of Items ai of Items 4 of Items e Amount 17 136 70 Amount 1 232 13 Amount 13 996 79 Amount 1 907 78 of Selected Items oO of Selected Items 0 of Selected Items oo of Selected Items oo Deposit Date Amount g0 Amount g0 Amount g0 Amount p0 037307200 reese r Date Range Pi e Mal M Checks M Cah M CedtCad Stat forvor7iso0 End fosvsv2m0 __ Behesh Audit Trail YH Receipt Number VY Receipt Da VH GLPost Y Receipt Am 7 Received From YW Source Document Number w Receipt Type Y Credit Card Type WH Posted Date WH Post Duce R Chek TIO Ee A A E Amore Reenensc PrvnTonmooooees Check PESEE A a T2121 BewyWedeaOarer Prvnooommanes Check S ea PY al RMCSHOO00001 4 MNTOOOOO000029 03 25 2007 03 25 2007 1232 13 Baker s EmporiumIn PYMNTOOOOOOONN290 Credit Card 02 25 2010 RMCSHOO000014 PYMNTOOOOOOOO029 03 22 2007
69. rompted to confirm the choice of matching item Step 6 One Click Resolution of Unresolved Items Easy e Bank Rec Page 48 of 74 In the next steps you will be guided through one click resolutions of common back reconciliation issues Process D Button The D Button is used to adjust any bank reconciliation entry up to a maximum allowable amount to a default expense account CLICK on the lt D BUTTON next to the transaction you wish to adjust The following window will appear on the screen BH Process D Button Check Information Check Book GPWACHOVIA Check Number 87786 Amount list 60 00 Type CHK Check Date 3 31 2007 v Diff 1 60 00 Action 1 60 00 Select Posting Accounts Cash Account 100 1000 00 000 6607 00 D Adjustment Expense System Comment Pe H 87786 Adjustment I amp J for 160 00 by sa on 03 31 2007 User Comment Print Process D Button Cancel ip Z Process D Button The D Button Account will default to the accounts you identified in Setup The Default Account for the D button can be overridden by keying any valid GL account Two comment fields appear at the bottom of the screen 1 System Comment this is a read only field that identifies the user the date the transaction and the transaction amount to be adjusted Easy e Bank Rec Page 49 of 74 2 User Comment the user can enter additional comments in this field CLICK the button la
70. s Ellipse Button Easy e Bank Rec Page 12 of 74 9 Ellipse Button Bank Statement Download If a given entry on the right side of the grid has only one transaction associated with it the button to the right of the entry displays as an ellipse If there are multiple transactions associated with the same document number the actual number will appear on the button CLICK on the button to drill down to the bank tape comments for the associated transaction s A window opens that displays the following information Cleared Date Document Number Field the document number on bank tape User Input Field you can enter modify or delete the corresponding GP document number Amount per transaction Detailed Description from the bank tape comments If the file was imported from a BAI file the details or the transaction as printed on the bank statement will be displayed If you hover over the description field with your cursor you will see the full description Import Date Bank Code ll Bani Transaction Details Type in User Input Field to update Document Numbers Cleared Date Document User Input Amount Description Import Date Bank Code H 03 05 2007 000000000000 627 6300 CHECKS PAID 475 09 09 2010 0 CHECKS PAID 475 Eana Ki 475 te oooooo000000 42350 362 1000 CHECKS PAID 475 09 09 2010 475 Type in Starting or Leave Blank to make all 0 1234 Auto Update Save amp Close Cancel
71. s and compared with the values in Easy e Bank Rec to display variances immediately Outstanding by GL D in Easy e Bank Rec Display and print the outstanding list for this or any previous reconciliation Variances Drill Down If there are any variances between the General Ledger and Check Book Management they will appear in the Drill Down column on the right side of the grid CLICK on the amount to drill down to the details of the transaction See the example below Easy e Bank Rec Page 67 of 4 RE Error Drill Down GL Doct VY GLAmount v Diff Sv Eror OMG 80 00 XFIT emi 621 70246 _ 821 702 46 IN GL pCMGL xrRooooo002 stag 0 00 1 149 73 NoN CE e 8 00 1 400 003 INC pCMGL xro sere 80 00 aeo CMGL_ xFROQo OOOIe get a Close Drilldown Window Error Drill Down To drill down to the General Ledger transaction CLICK on the button to the right of the CM Doc or GL Doc The Journal Entry for the transaction will appear on the screen HE Journal Entry for XFROOOO00011 OF x Journal Entry 37 Account Num Y Debit SV Credit SV Account Descripti 7 GL Date Y Source Do VY Reference Batch ID YE DE 4400 000 1110 00 0 00 21 702 46 Cash Payroll 03 04 2007 CMXFR Bank TransferE CMxFROOOOO005 0 m f 4400 100 1000 00 21 702 46 0 00 Operating 03 04 2007 CMXFR Bank TransferE CMXFROOOO0005 0 gt Close GL Lookup Window A La Journal Entry CLICK on the l
72. sage will appear on the Main Screen that will ask you 1f you want Refresh the Grid CLICK on lt YES gt to refresh the document numbers on the Bank Statement Download side To preview matching check numbers 1 Under lt ACTIONS gt in the Menu Bar SELECT lt PREVIEW UPDATE CHECK gt The following window appears on the screen This window displays all of the matching Check Numbers Easy e Bank Rec Page 39 of 74 HE Preview Update Check s Flag Items Where Bank Cleared Date Is Display Records Check BookID GPWACHOVIA Pi More Than 1 Days Before GL Post Date Vv E Vv Refresh Mark AllRecordsAs Selected C Unselected E More Than E Days After GL Post Date Iv iJ Selected and Unsele x bes o ooo Selected Doc v Amou yf Payer Payee CM Description GL Post Date Date lt gt BankDoc Y Bank Cleared Amount S v Bank Cleared Date Description iw 90629 250 00 A Travel Compan this is my comme 03 26 2007 a 0 000000090629 250 00 03 26 2007 CHECKS PAID 475 O ooono00s0630 2 000 00 03 27 2007 100000090852 i 2 CHECKS PAID 475 90630 2 000 00 A Travel Compan 03 27 2007 _ 9085 201 SUES ray thi Z Oo mY comme A ave pompar om fais son00f a Tava Conean tisis ny cone _ oa722007 om fais enoo a Tevet Compan tisis ny cone Yos722007 oe ares sen Tre Conpan isis n comme fosa e ares seen A Tiavea Comeon ie ny comme 0aarann7 c 000
73. sible to de select automatic matches and manually match the transactions Easy e Bank Rec Page 3 of 74 New color coding denotes transactions that are banked beyond the allowable range and those that are banked before they have been recorded in the GL The transaction description has been added to the grid The Payer Payee descriptions have been added to the Check Management Dynamics GP side of the grid The number of days between booked and banked transactions 1s displayed A Notes button has been added to Preview Automated Bank Transactions In this window the user can change the non cash account which will override the default setting for that particular transaction In other words the user can override the automated transaction distribution The full bank statement additional detail is available for viewing Any issued or banked amount on the grid can be right clicked to display all the transactions of the same amount on both the Check Management and Bank Statement sides of the grid The window displays all the items for that amount that have been matched and those that have not yet been matched A new column in the main grid called Pstd Clrd contains the date issued accounting or the bank cleared date thus providing the ability to sort all transactions accounting and bank in date order Ability to create a deposit on the fly with any un deposited Cash Receipts with filtering capability on Cash Checks
74. t File Mapping Setup Import File Mapping Button The screen is divided into two parts Add New Import File Mapping for Import File Easy e Bank Rec Page 22 of 74 EM import Fde Setup ss impot Fies ss E r 3 7 cane l FielFormat Desenpton FileType Vp est exeFomawinubw ome ys Ti certo TABDELIMITED PY Talat Add New Import Fie Mapping For Import Fae Selected in above Grid _ 3 Es Eam EBank Rec Cohmn Fie Foma Cokan Name La 71 BANK ACCOUNT NUMBER Bark Accourt Number pmo a moa oooO oeeo omnea e fome oom oo Import File Setup Screen Excel Header Setup 1 CLICK on the lt ADD NEW IMPORT FILE gt button import File Data Entry i O xj Fie Format Shot Name Exa Fie Format Description Exceli Format withtab worksheet caled IMPORT Fie Type EXCEL FILE bd Work Book Name MPORT o Select Fies Gpefiles group Research and Development E acy eBank Rec BarkR Import File Data Entry Screen 2 From the drop down menu for File Type SELECT lt EXCEL FILE gt Easy e Bank Rec Page 23 of 74 3 ENTER the File Format Short Name and File Format Description in the corresponding fields 4 ENTER the Work Book Name in the corresponding field 5 CLICK on the lt ELLIPSE gt button next to the Select Files field to browse for your bank file 6 Next you will map the file format column names to the columns in Easy e Bank Rec CLICK in the FILE FORMAT COLUM
75. t N BUTTON gt to the left of the Journal Entry item to view the Existing transaction notes in Microsoft Dynamics GP The Existing Comments is a read only field You can also add new notes to this transaction in the Add New Comments field If you add a new comment the Save New Comments button will be enabled CLICK on the lt SAVE NEW COMMENTS gt button at the bottom of the screen to save your remarks Easy e Bank Rec Page 68 of 74 HE Notes for Journal Entry 4400 Existing Comments This is a GL Note Add New Comments Saye New Comments Close Note Window Notes for Journal Entry Bank Statement Information In the Great Plains grid at the bottom of the screen you can drill down to view the bank statement and compare it with the electronic bank tape CLICK on the amount in the Great Plains Actual column to the right of Item E Bank Statement Total NOTE Ifthe bank statement ending balance is negative the amount will appear in Red If the ending balance is positive the amount will appear in blue HE Bank Statement Info Check Book Stmnt Date Stmnt Bal Last Stmnt Bal StmntVariance Bank Tape Total Bank Tape Variance Reconciled p GPWACHOW 03 31 2007 86 808 00 Bank Statement Info Easy e Bank Rec Page 69 of 74 Reports The Statement Variance is the ending balance in Microsoft Dynamics GP that you entered at the start of the bank reconciliation The Bank Tape Total is the
76. t SHIFT gt key and click each column in the order you wish to sort them Additional Features When you click on the icon in the header of any column a window appears that allows you to select the summary you wish to view CLICK the checkbox to the left of the option you want and CLICK lt OK gt F 4 Select Summaries Average T Count F Maximum M Minimum V Sum os _ Select Summaries When you click on the filter icon in the header of any column a drop down menu is displayed with options for transaction views CLICK on the view you want to display in the example below the Check Book Management Document Number has been selected All Blanks Custom NonBlanks oooo0000000000000001 o0000000000000000002 o0000000000000000003 o0000000000000000004 Column Filter Icon Easy e Bank Rec Page 14 of 74 Split Screen Bar This bar can be clicked and dragged down to create two data views on the screen Mi Easy e Bank Rec File Edit Tools Help sa Fabrikam Inc 4 12 2017 GP WACHOVIA Change Reconcile Maintenance Actions Paid No Issue Trx Reconciliation Summary Reports Excel G Print x Close About CM Cutoff Date 03 31 2007 Bank Cutoff Date 03 31 2007 Marked JALL v Check Deposit ALL Refresh Grid Options Refresh Grid Refresh Grid Options Show Split _ Clear Fi Clear Fi Enter Check to Bank Statement Check Book Management Search in Grid Search oa Un
77. tration This function is used to activate Easy e Bank Rec from the Trial Version after you have purchased the license CLICK on lt UPDATE REGISTRATION KEY gt ENTER the Registration Key in the field and CLICK on lt REGISTER gt TT Update Registration Key Update Registration Key Update TRXDATE with GLPOSTDT Update TRXDATE with GLPOSTDT Microsoft Dynamics GP Bank Rec works on the transaction date If the transaction date is not equal to the GL date you will not be able to reconcile This option will store the transaction date in the user defined 1 field and make the transaction equal to the GL date As a result the Microsoft Dynamics GP bank reconciliation will match the Easy e Bank Rec reconciliation Easy e Bank Rec Page 26 of 74 N Check List where GLPOSTDT gt TRXDATI Owi Book ID EEE Check List where GLPOSTDT gt TRXDATE Doc tt Type DocDste Gidse mort E Padto CeeredAmourt CeaedDete 3 Vowied Ved Date RAT Che 1O4 2B 2007 03 25 2007 160 00 A Travel Comps 16000000 arr 2007 1 gt f 0101 7900 _ es e _ e ___ 478 CHI LOUVO DA 160 OD Update TRADATE wh GLOATE Update TRXDATE with GLPOSTDT CLICK on lt UPDATE TRXDATE WITH GLDATE to make the transaction date equal the GL posting date CLICK on lt PRINT gt to print the information on the screen Bank Code Master List Maintenance This option allows you to view all the
78. ts CLICK on lt OK gt to create small adjustments Conversely CLICK on lt CANCEL gt to cancel the process Easy e Bank Rec Page 46 of 74 step 5 Mark all Matching Items as Reconciled To mark all matching items as reconciled 1 Under lt ACTIONS gt in the Menu Bar SELECT lt MARK ALL EQUAL AS RECONCILED gt 2 A message box appears on the screen asking if you want to mark all equal transactions as reconciled 3 CLICK on lt OK gt The application automatically places the check marks inside Dynamics GP 4 Itis also possible to match items manually by copying the Document Number from the Check Management side of the grid and pasting it into the corresponding item s in the bank statement see example below Pi casy e Bank Rec File Edit Tools Help GPWACHOYIA Change Reconcile Maintenance Actions Paid No Issue Trx Reconciliation Summary Reports 7 Ey Excel 9 Print X Close About CM Cutoff Date 03 31 2007 Bank CutoffDate 03 31 2007 v Marked ALL v Check Deposit ALL Refresh Grid Options Clear Fiers Bank Statement 2 Paste Document 1 Copy Document amp Enter Check to Ctrl C ment Search in Grid Search Download U Ctrl V m Agr Y TrAm EY Post Date 5 Y Cv Cleared SV Pstd Chd Y M N D Doct From Bank Y Doc tt User Input 7 Cleared SV Bank Dat Y Diff LY mF U ooooooooood0o0o00001 6 564 11 03 04 2007 DEP 0 00 03 04 2007 IMIN 7 hiy Ea Oo a0 3
79. un 51 560 00 Amari Cleeeed Anori mat Paid No Issue Retrieving Trx The bank tape transactions that you placed in the Paid No Issue holding area appear on the right side of the grid If the field on the left is blank it is because the transactions are unresolved In subsequent bank reconciliations 1f there is a matching transaction in Microsoft Dynamics GP it will appear automatically in the Check Book Management side of the grid CLICK on the lt ELLIPSE gt button to drill down to the details of the transaction CLICK on the lt REVERSE gt button to the right of the Bank Tape transaction to reverse the Paid No Issue to a reconciled transaction NOTE If multiple matching transactions appear in the grid you can reverse them all at once CLICK on lt ACTIONS gt in the Tool Bar menu at the top of the window CLICK on lt REVERSE ALL EQUAL gt Easy e Bank Rec Page 59 of 74 Multi Location Multi Credit Card Wire Reconciliation Easy e Bank Rec facilitates credit card wire and cash transactions in businesses with multiple locations that process multiple credit card transactions The drawing below depicts how the bank statement Merchant ID and Bank Location are correlated to the Location and Transaction Type inside the accounting system This is accomplished in a master cross reference table called the Internal ID Maintenance table Easy e Bank Rec Multi Location Multi Credit Card Electronic Reconci

Easy e-Bank Rec™ User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents

Easy e-Bank Rec&trade; User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents

Easy e-Bank Rec™ User Manual