User manual Adra Match Accounts 13
Contents
1. Caen Maintenance Help User manual Adra Match Accounts Page 9 match Accounts Add import Click Add to add XML code or create your own user defined import Select a name for the new import Then select Wizard to create a user defined import or XML to add XML code File type Position Delimited Tab Remove character Westem European Windows 1252XWindows 1252 Debit Credit columns Debit and Credit in seperate columns invent amount Multiplier 1 Decimal symbol 1 Digit grouping symbol Column index XLM import Select XML Type or paste the XML code in to the window Click Save XML import lt xml version 1 0 encoding iso 8859 1 gt lt ImpMatchODFile xmins http schemas adramatch com Import OdFile delimited true delimiter t gt lt collection name File gt lt row name Settings read false gt lt column name NumberDecimal Separator type Output output gt lt column name NumberGroup Separator type Output output lt column name RemoveSpace type Output outputz Talse 5 lt row gt lt row read false gt lt column name Type type Output output MOTP 5 lt row gt lt end gt lt collection gt lt collection name Matchltems gt lt row name InLine gt lt column name Ftg columnNumber 1 lt column name VerNr columnNumber 2 lt colu2. output Mpart gt lt column type Output name Content output InLine Mpart gt lt row gt lt row name ExtraKonto test InLine Konto read false gt lt column type Output output Konto gt lt column type Output name Content output InLine Konto gt lt row gt 4 X Maintenance Help User manual Adra Match Accounts Page 10 d m tch Accounts User defined import VVizard xi BEE My ERP Wizard File type Position Delimited Tab Remove character Encoding Westem European Windows 1252 Windows 1252 Static account Debit Credit columns Debit and Credit in seperate columns Invert amount Multiplier 1 Decimal symbol Start at line 2 Digit grouping symbol Column index Client no Account no Amount Date Date format yyyymmdd Date format yyyymmdd X BDate 1 F4 5 Sign 0 4 4 6 Reference Text 7 Free text E Extra field Cancel Save Back Settings File type Select Position if the field columns in the text file have Fixed width Select Delimited if the field columns in the text file are delimited e g tab or comma Remove character This is used to remove Wrappers for instance if you have a CSV file that has a quotation mark on both sides of a text column E g 2010 08 15 400 00 B
3. m tch Settings for exceptions Account group Bank Account Allovved deviation 0 99 Maximum number of transactions shov n 50000 Sort maximum number of transactions by Reference Save Reset User manual Adra Match Accounts Page 39 d m tch Accounts Undo import and reconciliation Imported files with reconciled transactions will not appear in the list To undo the import of a file with reconciled transactions you first have to undo the reconciliation of those transactions and then undo the import of the file select Maintenance Undo import Imports Files and folders Reports Settings for automatic reconciliations Settings for exceptions Registration Backup Restore License settings Select the file or files you vvish to undo f you logged in as admin select Engagement mode to see the files imported to all clients You can click on the button Details to see the impact on balance the Undo import will have on the selected file or files Click Undo import Click Yes to confirm If the file or files you want to undo do not appear in the list select Reconciled imports adra match Undo import V Engagement mode Unreconciled imports Reconciled imports V Show the last 100 unreconciled or reconciled imports only Import name File name Date of import File date MANREG ManReg 03 05 2011 15 14 03 05 2011 15 14 MANREG 2405 2011 0
4. match Accounts d match Accounts Contents Guide Adra Match Accounts ssesssssserssersresserssersserssrsssresereserssressresrossreseessressresereseesseessreseresereseesne 4 PODallonNnuc ul 4 ORCS 7 0000000000 607 7 0000000000 4 102 4 VY ICO RNG x O 5 Edit accounts and account a a bala 5 Sel staring Dalan EERS 8 TT un 9 ROUNDO FU sate tnt ters ee eee E ee estas 7777 ee ets ns ee cate ets 0000009900 10 PEI AAO O r 10 WISER GETING import Wizard r n a n 11 17 m s 11 GOlus 12 Upton rr 3005500005 12 EEE R abba 12 EL AQ 13 14 Balance pos amad 15 Suloma FE COMC 1 16 Scheduled Automated 18 0000000 19 LS SN US 21 Reconcile transactions with deviation 25 Reconciled TANS ACTIONS b 26 Search and Replace Reconciled 5 27 BO 29 View historical O a yd 30 Repor e and 1562 0977 00 30 CI OLEEL6O ns 31 200701 TED ritini rer eE OEE RERE E E ERREEN 31 License SOUNE NAANA
5. From To Ok Ok iv Ref Al 0 Close maintenance SEE User manual Adra Match Accounts Page 48 d m tch Accounts Create a One to Many or Many to One reconciliation rule On the picture below you can see two payments on the bank account which combine to the same amount as the single ledger booking on account 2331 The payments on the bank are booked on the same date and 3 and 4 days later than the ledger booking The text is the same on the payments from the bank 22 08 2010 22 08 2010 249 00 Kortind 100819 10518520 3554000000 23 05 2010 22 08 2010 25 587 00 V Kortind 100819 10518520 3554000000 19 08 2010 19 08 2010 KA6120864 25 338 00 V Kontokort Danske Bank 2331 Now we are going to set up a reconciliation rule for the example above Create a new reconciliation rule Give the reconciliation rule a descriptive name We know from the example above that it is 3 days between the ledger booking and the two payments from the bank Set Date deviation to 3 in the right side box We also know that we have more than one transaction from the bank and that they are booked on the same date Select Many items from bank Because the bank transactions are on the same day you do not have to set any Date deviation within group In Indexing you just select Text Field Click Save adra match Settings for automatic reconciliations
6. amount deviation 0 Allowed amount tolerance on deviation Intervals to reconciliation Amounts Larger then Less then 0 0 Intervals for allowed deviation Deviation Larger then Less then 0 mm M Maintenance Help Select if you want to reconcile with Variance or Split To learn more read about it in the section Reconcile transactions with deviation Insert deviation transaction on To be selected if you want to insert deviation on the ledger side or Bank side Left or Right Use info from latest or oldest on deviation transaction If you reconcile many to one or many to many you can select from which of the many transaction oldest or newest to save the info from Reconcile with an exact deviation or Select this option if you only want to reconcile transactions with an exact deviation To only reconcile transactions that are 20 less on the bank side then on the ledger side you need to select this option and set Allowed or amount deviation to 20 Reconcile with deviation in percent Select this option if you want to reconcile transactions with a percentage difference Allowed amount deviation Enter the amount deviation you want to allow If you enter 5 00 the rule will reconcile all transactions where the amount of the right side transaction s is between 5 00 amount units less to 5 00 amount units larger than the amount of the left side transaction s Allowed or am
7. A m tch Client Comorate Recon Bil ini E3 Welcome Import Automatic Reports Sum of your selected transactions equals zero Press ALT A to reconcile Account A nts Payable R r Credit Count debit Count credit Accounts Pay 2 010 00 0 00 1 0 Accounts Rec 0 00 2 010 00 0 4 sum 0 00 Sum remaining PONE w Reconcile qem Date BDate Reference Amount W V Text Comment Acc no 02 01 2008 02 01 2008 8012047000 3 00 1211699 ACCOUNTPAY 30 12 2007 30 12 2007 2910231000 3 00 E 1199539 ACCOUNTREC 30 12 2007 30 12 2007 4709142000 3 00 E 1202195 ACCOUNTREC 01 01 2008 01 01 2008 2321000000 31 08 1198710 ACCOUNTREC 30 12 2007 30 12 2007 8012047000 922 00 1211699 ACCOUNTREC 09 12 2007 09 12 2007 8012047000 925 00 1211699 ACCOUNTPAY 09 12 2007 09 12 2007 2910231000 1 469 00 E 1199539 ACCOUNTPAY 09 12 2007 09 12 2007 2910231000 1 472 00 1199539 ACCOUNTPAY 02 01 2008 02 01 2008 4709142000 1 934 00 E 1202195 ACCOUNTPAY 09 12 2007 09 12 2007 4709142000 1 937 00 1202195 ACCOUNTPAY 07 11 2007 07 11 2007 7902203000 2 000 00 E 1197463 ACCOUNTPAY 09 01 2008 09 01 2008 4107246000 2 000 00 1213175 ACCOUNTREC 09 12 2007 09 12 2007 7107064000 2 010 00 1210204 ACCOUNTPAY 30 01 2008 30 01 2008 6707062000 2 010 00 1213239 ACCOUNTREC 22 11 2007 22 11 2007 2321000000 2 832 00 E 1198710 ACCOUNTPAY When you cannot find any more transactions with equal amounts sort the transactions on date by clicking the Date or BDate col
8. Account group Bank Account Reconciliation type Reconcile general Name One to Many 3 days E Reconcile using the same text string for Ledger and Bank E Reconcile a suspense account debit credit F Reconcile a suspense account sum Reconcile only when one altemalive exists Date range 02 32 Many items from Ledger Many items from Bank 7 From To From To Date range within group 0 0 Date range within group oz 0 Group items Group ilems No of items in group 0 No of items in group 0 Indexing Indexing Index type Default Index type Default Split on space vi Split on space E Split on other Split on other Field Ref Field Text Only numbers Only numbers T Length 0 Length 0 Reconcile with Split or Variance m User manual Adra Match Accounts Page 49 d m tch Accounts Automatic reconciliation vvith Variance or Split Select the Reconcile with Variance and Split checkbox on the reconciliation rule to enable automatic reconciliation with variance or split The automatic reconciliation with variance or split can be added to all reconciliation rules accept when you selected the option Reconcile a suspense account Sum v Reconcile with Split or Variance Variance Split Insert deviation transaction on Ledger Use info from latest or oldest on deviation transaction Oldest X Reconcile with a exact deviation or Reconcile with deviation in percent 22 Allowed
9. 03 05 2011 13 03 E bjom companyname co uk anna hansen companyname com ds s nm iS iS iS M RB Sis isis User manual Adra Match Accounts Page 35 d m tch Accounts Single sign on The user can be set up to be automatically logged in to Adra Match Accounts If you register the windows user name DOMAINUSERNAMEFE as the username in Adra Match Accounts and then select Windows authentication the users will be automatically logged in next time they start Adra Match Accounts If you only have one administrator Admin do not set the administrator Windows authentication Add or change Company information Select the tab License from the License settings window Add the company address in Company information and click Save m tch License settings Clients Users License Company information is Adra Match AS Address Schweigaardsat 28 Zipcode N 0134 City OSLO i p i Add or change product key or update licence Select the tab License from the License settings window Click Change product key Enter or paste the Adra Match Accounts product key and click Add License infomation Max Transactions 100000 4979 Change product key Max users 15 5 A product key must be added to obtain a new license or to update existing license
10. Add the product key that you received from Adra Max Clients 10 7 Match Expiration date 2011 05 31 Product k 844BF 787 62C2 498E BF5D 44E4F1A719C7 Product key 00000000 0000 0000 0000 000000000000 Change product key User manual Adra Match Accounts Page 36 d m tch Accounts Click Check for license update Verify that the license is right and then click Confirm License information Used Max Transactions 100000 4979 Max users 15 5 Max Clients 10 7 Expiration date 2011 05 31 Product key 844bf787 62c2 498e bf5d 44e4f1a719c7 Change product key 222 Check forlicense update License update A License update License information License update available click Confirm to download your new license Adra Match ASA 2037 1 1 999999 2011 2 15 False If you have any problems with your license please contact Adra Match Support User manual Adra Match Accounts Page 37 d m tch Accounts Backup and restore If your SQL server is not set up to do backups automatically you can do a backup manually If you encounter problems with the program Adra Match support can ask you to do a backup and send it to them Select Maintenance Backup Restore Create backup Select path to backup folder Click Create backup Restore backup Select path to backup folder if not all ready selected Select file to restore click Restore backup Ba
11. Debit Credit Count debit Count credit edger 1 422 897 35 2 0 Bank 0 00 1 422 897 00 0 1 Sum Sum remaining Reconciled Search Reconcile Date BDat Reference Amount v V Text Comment Acc no 13 11 2007 13 11 2007 BF6003645 29 26 V ND BF 6003536 SE E4 63 1941 15 11 2007 15 11 2007 E40000063 29 26 E INS SYSTELMVPA014 1941 01 12 2007 30 11 2007 51595742 254 35 Bankgiro inb 51595742 48501234 30 11 2007 30 11 2007 BF6003647 899 00 E VERF BG 901 6031 R3 52 1941 22 11 2007 22 11 2007 KOD870 1 500 00 Lev kostn uti vp KOD870 48501234 29 11 2007 28 11 2007 51595742 4 482 00 F Bankgiro inb 51595742 48501234 24 11 2007 24 11 2007 BF6003426 24 120 50 AVVISADE LONER 1941 28 11 2007 27 11 2007 9100005159574 50 000 00 Ins ttning 91000051595742 48501234 23 11 2007 23 11 2007 1 726 32 INS SYSTELMVPA012 1941 24 11 2007 24 11 2007 110014814 464 140 22 F ARVODEN UPPDRAG LON 0633 1941 23 11 2007 23 11 2007 E40000067 1 371 171 03 V INS SYSTELMVPA014 Coming in December 1941 23 11 2007 23 11 2007 51703362 1 422 897 00 V Bankgiro inb 51703362 48501234 24 11 2007 24 11 2007 L10013689 2 869 915 26 77 UTLAND LON 0611 1941 You will now be prompted to select if the deviation is Split or Variance Split should be used if you want to save the deviation difference to be reconciled later e Saves the text fields and dates from the oldest transaction with the largest amount from the Ledger side If you reconcile Bank against Bank or Led
12. If you search for From Amount 120 and To Amount 245 Adra Match Accounts will display all amounts between these two amounts adra match Welcome Import Automatic Reports Account group Bankavstemming SE Reconciled Reconcile From Amount 120 Date 15 02 2011 EM Reconciled dat 15 02 2011 To Amount 245 E 15 02 2011 gv To reconciled q 15 02 2011 Comment Search Clear Date BDate Reference Amount Text Comment Acc no Reconcile id Reconcile date 01 11 2010 G30001770 200 00 p INS SYSTBG 9016031 1941 5097 25 10 2010 13 22 06 11 2010 06 11 2010 BF6003241 120 00 p LK UTL BET 061106 1941 5099 25 10 2010 13 22 07 11 2010 07 11 2010 BF6003262 120 00 LK UTL BET 061107 1941 5100 25 10 2010 13 22 13 11 2010 13 11 2010 G20003122 245 00 INS SYSTBG 1554393 1941 4943 25 10 2010 13 22 21 11 2010 21 11 2010 BF6003392 120 00 p LK UTL BET 061121 1941 4979 25 10 2010 13 22 22 11 2010 22 11 2010 326005004 225 00 Kontof rt 1941 5103 25 10 2010 13 22 23 11 2010 23 11 2010 BF6003419 240 00 LK UTL BET 061123 1941 5091 25 10 2010 13 22 30 11 2010 30 11 2010 BF6003510 120 00 LK UTL BET 061130 1941 5092 25 10 2010 13 22 02 11 2010 02 11 2010 5500000901603 200 00 p Ins ttning 55000009016031 48501234 5097 25 10 2010 13 22 02 11 2010 02 11 2010 1970000090025 200 00 Ins ttning 197000009002569 48501234 5066 25 10 2010 13 22 To Amount field can only be used when From Amount field is filled
13. User manual Adra Match Accounts Page 23 d m tch Accounts Date You can choose vvhether you vvant to search for exact date or a space of time From Date To Date When only Date is filled in Adra Match Accounts will search for the exact date When both From Date and To Date are filled in the Adra match Accounts will search for all dates between the two dates that were typed When searching for exact amount only the name of the field is Amount As soon as you type in both From and To date the label of the field will change To Date field can only be used when From Date field is filled Comment To search for text or numbers type in the full string or parts of it Text The text should contain the search string anywhere in the text Reference The reference should contain the search string anywhere in the reference text User manual Adra Match Accounts Page 24 Reconcile transactions vvith deviation d m tch Accounts It is possible to reconcile transactions with deviation Split or Variance interactively To reconcile a transaction with deviation you first have to set up Allowed deviation see Settings for Exceptions Select transactions with deviation If the deviation difference is within the Allowed deviation you will be able to click Reconcile O makh Client Sweden xe Bee Welcome Import Automatic Reports Accent poe ae xl
14. 15 24 admin 05 04 2011 15 24 Match Stand Tab casv0d0e001 Prog MatchProdukter Adra Match Accounts Public Sprint Te 05 04 2011 15 23 admin 05 04 2011 15 23 G ount Cards 22 03 2011 14 00 GL Acco ards 11 13 59 Are you sure you vvant to undo reconciliation for the follovving 1 file s sez s Demo AMAN LedgerM1790 HB bt 17 03 2011 15 59 17 03 2011 16 2011 1 Confirm m ike Watch ron Are you sure you want to undo import E c Program Files adra match as Demo Match Stand Tab C Demo AMA IB1790 b 09 11 2010 18 24 adm AMI0 _Ledger Ledger_Sweden_1941 mstt GL Account Cards C Demo s StartOpen be 14 09 2010 14 04 adn hat d T licASaleNDEMO AM10 NY den 1 1 Undo import Undo reconciliation Maintenance Help User manual Adra Match Accounts Page 41 Manual registration d m tch Accounts Manual registration is used to add transactions manually to an account Select Maintenance Registration Imports Files and folders Undo import Reports Settings for automatic reconciliations Settings for exceptions Backup Restore License settings Select Account group Register the transactions in the top window In the window below all the registered transactions are shown Do not forget to select the correct account When all transactions are registered click Insert to add the tra
15. 33 E EE 33 Add a0 arr 34 User manual Adra Match Accounts Page 2 d match Accounts User Privileges 34 SAE ON zm E E 36 Add or change Company 36 Add or change product key or update 36 Brb R 10006 38 GOD 0 daban na mam m n 38 38 Settings for 1 95 39 Undo import and 40 DE R EE 42 Settings for automatic 43 Reconcile general Reconciliation rules 43 45 Automatic reconciliation with Variance or 9 50 53 Data enrichment with regular expressions Find Expression and add new 53 User manual Adra Match Accounts Page 3 d m tch Acco
16. 7 9100005159574 50 000 00 E ing Select 7 20000029 51 726 32 El Ni Remove selection 7 um s o s s C vE Emmy lll 1 uu Bes Remove filter for this column al Remove all filters 7 51595742 4 482 00 B Send transactions by E mail outlook 7 51595742 254 35 B Copy transactions to Excel r BF6003426 24 120 50 r L10014814 464 140 22 ARVODEN UPPDRAG L N 0633 40000067 1 371 171 03 F INS SYSTELMVPA014 Coming in December r 6409058000 260 00 1120097 ACCOUNTPAY r 6409058000 500 00 E 1120097 r 6610052000 684 00 El 1090811 Select 7 6510052000 700 00 FE 1090811 Remove selection 27 Te Remove filter for this column r 6608221000 1 201 00 1143606 m s 6608221000 1 368 00 27 Wea Send transactions by E mail outlook 3 7703020000 1 382 00 1145548 Copy transactions to Excel r 6610052000 1 579 00 1090811 r 6503271000 1 649 00 E 1143262 ACCOUNTPAY r 6409058000 1 652 00 1120097 ACCOUNTPAY r 6503271000 1 668 00 E 1143262 ACCOUNTPAY User manual Adra Match Accounts Page 21 d m tch Accounts To remove a filter from a single column click the funnel indicator in the column header Right click and select Remove all filters to remove all filters from all columns Search Reconcile rence Amount V V Text T Comment Acc no 358000 260 00 vi HEM ACCOUN 358000 500 00 E 1120097 ACCOUN 358000 892 00 E 1120097 ACCOUN 358000 1 652 00 1120097 ACCOUN Search Reconci
17. Debit Credit The transaction amount in the data file If you selected the setting Debit Credit columns amount will be separated into one Debit column and one Credit column Date Transaction Date The transaction date Value date in the data file Do not forget to change the date format to the one used in your data file Reference The reference in your data file Optional fields Client no The unique number or name in the text file used to import to more than one client at the time Sign Only used if or d k symbols are in a separate column in the data file BDate Booking Date The booking date in the data file Do not forget to change the date format to the one used in your data file Text The transaction text in the data file Free text Free text in the data file Extra field Select extra field if you want to display any additional information in a separate column Select Extra field and type the name of the new field Enter the column number or from position and length Text Free text v Extra field StoreNumber Q TWA oO m k m ms Se User manual Adra Match Accounts Page 12 d m tch Accounts Files and folders This is where you define the path to the import folder the folder to which you save your text files and the backup folder This is set once per sele
18. No Edit Store No Edit Store No Edit Store Edit Store EditStoreNo Edit Store No Edit Store No EditStoreNo Edit Store No Edit Store No EditStoreNo EditStoreNo EditStoreNo EditStoreNo EditStoreNo EditStoreNo EditStoreNo User manual Adra Match Accounts Page 53
19. account group Use high contrast Shows the transactions from the Ledger Left side and Bank Right side in higher contrast colours Fit row to text Will adjust the row height to the content of the text column Reset column order Will reset column order and width to the preset values adra match Welcome Account group Import Automatic Reports Credit Card Reconciled Search Show reconciled transactions Date BDate Reference Amount Use high contrast A 01 08 2010 VER61810 8 4 Fit row to text 01 08 2010 01 03 2010 VER61821 9 2 Reset column order 01 08 2010 01 08 2010 VER61821 02 08 2010 02 08 2010 KA6690271 298 00 Kontokort Danske Bank 02 08 2010 02 08 2010 KA6690282 298 00 Kontokort Danske Bank User manual Adra Match Accounts Page 19 d m tch Accounts Start by clicking on the Amount column to sort the transactions by the absolute amount The transactions will be sorted independently of whether it is a debit or credit Look through the open transactions to find two equal amounts one debit and one credit from each side Ledger left side blue rows Bank right side yellow rows It is also possible to reconcile two blue or two yellow transactions Select these transactions in the checkbox column and click Reconcile or press ALT A to reconcile the transactions The reconciled transactions are now moved to the tab Reconciled
20. of the screen You can also see the number of items and the percentage each setting rule has reconciled and the total percentage for the account group Client Co Sweden Open transactions 571 V One One 5 days Only one Reconcile general o Complete transactions V One Many 5 days Reconcile general 19 Complete transactions reconcil V One Many 5 days 9 Reconcile general Complete transactions ciled One Mary 5 days 8 Reconcile general Complete transactions reconciled 3 V One Many 5 days 5 Reconcile general 9 Complete transactions iled 4 Many One Reconcile general Many Many Reconcile general V One One 5 days Reconcile general V Debit Credit 3 days Reconcile general Open transactions Reconciled transactions User manual Adra Match Accounts Page 17 d m tch Accounts Scheduled Automated Reconciliation You can schedule the automated reconciliation to do the reconciliation at the time that is most convenient for you The reconciliation can be scheduled to run daily weekly monthly on certain days or times on specific clients and account groups Scheduled automated reconciliation presupposes that files have been imported into the Account Groups you want to schedule and that balances are verified Engagement Level You can choose whether you want to run scheduler on all reconciliation r
21. sort data option izi Use standard AMA data Show the Per date option El Open 3 Show the From to date option M Show All available clients option V Select output type Select an account group 7 PDF V Excel 4 E RTF ETT V Report Vievver Show historical data option Save Back Select if you vvant the report to be vievvable on the active client or on all clients and select Admin only if you only vvant the report to be restricted to administrators Close maintenance and you are ready to use your nevv report ive client n use on all clients Admin only ss z Add Edit Delete User manual Adra Match Accounts Page 32 License settings This is where you manage your users and clients Select Maintenance License settings Edit accounts and account groups Imports Files and folders q Undo import Reports R z Settings for automatic reconciliations vi Settings for exceptions Registration Backup Restore Add or edit a client d m tch Accounts Click Add Client name is mandatory Address and Zip Post Code is optional Add client number if you have one The client number is used to find the right client when importing to more than one client Select users Users can be added later Click Save Select a client to edit Edit client and clic
22. that has already been done how it has been done and by whom A Viewer has access to o Exceptions View Exceptions e Write Comments to Exceptions e Send copy of Exceptions to e mail Outlook of Excel o Report View and print Reports User manual Adra Match Accounts Page 34 d m tch Accounts Select the tab Users from the License settings vvindovv Click Add Enter a User name Passvvord and Language Other optional fields are First name Last name and E mail Under Role you select vvhether the user should have the role Admin Super User User Vievver or Restricted User If you do not select Admin you need to select the Clients the user should have access to Click Save If you uncheck n use the user will no longer be able to log in and the user will be returned to Available users Edit user by selecting user to edit Change values and click Save The Roles feature is meant to be a dynamic feature Should there be a need for tailor made roles other than the five roles listed above Adra can help create and add roles with different combinations match J Fil License settings Close maintenance Clients Users License 15 Last logged in Windows authentication 04 05 2011 12 20 10 03 2011 10 33 27 04 2011 12 38 03 05 2011 16 04 29 03 2011 11 27 03 05 2011 12 52 10 03 2011 12 37 02 05 2011 21 14 03 05 2011 13 13 16 03 2011 13 04 03 05 2011 13 01 03 05 2011 13 03
23. to work See Settings for automatic reconciliation for more information Select Automatic Click on Automatic once more and select Shovv all clients It is possible to run automatic reconciliation for all clients and account groups simultaneously You can also show only the account groups and hide the reconciliation rules by selecting Show only account groups adra match Welcome Import Exceptions Reports Show all clients v Select All mb 2 Shovv only account groups Nam atus Bank Account Make sure that the clients you want to reconcile are selected You can also choose not to run a particular setting rule by removing the check in the checkbox Click Reconcile You can stop the reconciliation by clicking Stop Welcome Import Exceptions Reports V Select All Name Status Bank Account V One One 5 days Only one Reconcile general One Many 5 days Reconcile general V One Many 5 days 9 Reconcile general V One Many 5 days 8 Reconcile general V Many 5 days 5 Reconcile general IV Many One Reconcile general v Many Many Reconcile general v One One 5 days Reconcile general V Debit Credit 3 days Reconcile general User manual Adra Match Accounts Page 16 d m tch Accounts VVhen the reconciliation is complete the number off open and reconciled transactions is shovvn in the lovver right corner
24. 014 1941 24 11 2007 24 11 2007 BF6003426 24 120 50 E AVVISADE LONER 1941 24 11 2007 24 11 2007 110013689 2 869 915 26 E UTLAND L N 0611 1941 24 11 2007 24 11 2007 L10014342 6 149 731 26 KANSLI L N 0611 1941 24 11 2007 24 11 2007 L10014814 464 140 22 E ARVODEN UPPDRAG LON 0633 1941 28 11 2007 27 11 2007 9100005159574 50 000 00 FE ins ttning 91000051595742 48501234 29 11 2007 28 11 2007 51595742 4 482 00 Bankgiro inb 51595742 48501234 30 11 2007 30 11 2007 BF6003647 899 00 E VERF BG 901 6031 R3 52 1941 01 12 2007 30 11 2007 51595742 254 35 Bankgiro inb 51595742 48501234 User manual Adra Match Accounts Page 20 d m tch Accounts Useful tips In the Comment column you can type whatever you want for example why a transaction hasn t been reconciled Reconciled Search Reconcile Date BDate Reference Amount W V Text Comment Acc no 23 11 2007 23 11 2007 E40000067 1 371 171 03 V INS SYSTELMVPA014 Coming in December 1941 a Sees a ann an ur E PE You can select several transactions by dragging your mouse pointer over several rows If the Amount column is selected the sum of the selected rows is shown on the information bar on the lower right of the application Then right click and click Select or Remove selection Reconciled Search Reconcile Date BDate Reference Amount V Text Comment 23 11 2007 23 11 2007 40000067 kite V INS SYSTELMVPA014 Coming in December 29 11 2007 28 11 200
25. 4245 14098 14098 14177 14177 Reconcile date 04 05 2011 08 31 04 05 2011 08 31 04 05 2011 08 31 04 05 2011 08 31 04 05 2011 08 31 04 05 2011 08 31 04 05 2011 08 31 04 05 2011 08 31 04 05 2011 08 31 Credit Count debit Count credit 0 00 0 0 0 00 Sumremaining Reconciled By admin admin admin admin admin admin admin admin admin 04 05 2011 08 31 a 04 05 2011 08 31 a 04 05 2011 08 31 a 04 05 2011 08 31 a 04 05 2011 08 31 a 04 05 2011 08 31 a 04 05 2011 08 31 04 05 2011 08 31 a 04 05 2011 08 31 04 05 2011 08 31 04 05 2011 08 31 a 04 05 2011 08 31 a 04 05 2011 08 31 04 05 2011 08 31 Opentransactions 15 To Amount field can only be used when From Amount field is filled User manual Adra Match Accounts Page 27 d m tch Accounts Date You can choose vvhether you vvant to search for exact date or a space of time From Date To Date When only Date is filled in Adra Match Accounts will search for the exact date When both From Date and To Date is filled in the Adra match Accounts will search for all dates between the two dates that were typed When searching for exact amount only the name of the field is Amount As soon as you type in both From and To date the label of the field will change To Date field can only be used when From Date field is filled Reconciled date The fields Reconciled Date From Reconciled Date and To Reconciled Date w
26. 603 1970000090025 1980000090025 2040000090025 2090000090025 1210000090998 2150000090025 G30001770 51703361 61122575179 326005004 BF6003419 1554393 G20003122 9020405 G40004481 Amount t 120 00 120 00 120 00 120 00 120 00 120 00 120 00 200 00 200 00 200 00 200 00 200 00 200 00 200 00 200 00 225 00 225 00 225 00 240 00 245 00 245 00 250 00 250 00 Reconcile 120 Date F 04 05 2011 250 Todate E 04 05 2011 Text Bet uppdrag 20061106 Bet uppdrag utl 20061107 Bet uppdrag utl 20061121 LK UTL BET 061106 LK UTL BET 061107 LK UTL BET 061121 LK UTL BET 061130 Ins ttning 55000009016031 Ins ttning 197000009002569 Ins ttning 198000009002569 Ins ttning 204000009002569 Ins ttning 209000009002569 ins ttning 121000009099995 ins ttning 215000009002569 INS SYSTBG 9016031 Ocr inb 51703361 Bet uppdrag uti 1 61 1 225751 79 Kontof rt LK UTL BET 061123 Bankgiro inb 1554393 INS SYSTBG 1554393 Bankgiro inb 9020405 INS SYSTBG 9020405 Bv Reconciled datl 04 05 2011 El To reconciled di 04 05 2011 Acc no 48501234 48501234 48501234 1941 1941 1941 1941 48501234 48501234 48501234 48501234 48501234 48501234 48501234 1941 48501234 48501234 1941 1941 48501234 1941 48501234 1941 Reconcile id 14253 14254 14133 14253 14254 14133 14246 14251 14219 14220 14225 14231 14232 14237 14251 14210 14261 14261 1
27. 7 02 05 2011 07 57 OdFile 05 04 2011 15 23 OdFile as Import details 05 04 2011 15 23 Gina 152 OdFile 05 04 2011 15 23 Match Stand Tab 05 04 2011 15 23 Match Stand Tab casvf Account no Sum imported Current balance 05 04 2011 15 23 Match Stand Tab 3015119123 325 114 00 325 114 00 05 04 2011 15 23 Match Stand Tab casvf 1940 203 104 00 213 104 00 05 04 2011 15 23 Intema Mellanh 22 03 2011 10 49 MOTP 16 03 2011 12 04 Match Stand Tab 13 10 2010 15 28 Match Stand Tab 12 10 2010 16 17 Match Stand Tab b 12 06 2008 15 39 Match Stand Tab Pub 12 06 2008 15 39 User manual Adra Match Accounts Page 40 d m tch Accounts Before you undo the reconciliation for a selected file or files you can click on the button Details to see the impact on balance the Undo import will have If you still want undo the reconciliation on the selected file or files close the Undo Import Details window and click Undo reconciliation When you unreconciled the selected file or files select Unreconciled transactions to undo the import adra m tch Client Co Sweden ei Bee Undo import Close maintenance v Engagement mode Unreconciled imports Reconciled imports V Show the last 100 unreconciled or reconciled imports only Import name File name Date of import User name File date OdFile casv0d0e001 Prog MatchProdukter Adra Match Accounts Public Sprint Te 05 04 2011
28. 7 51595742 777757 F Bankgiroinb 51595742 24 11 2007 24 11 2007 6003426 ey l AVVISADE LONER 22 11 2007 22 11 2007 KOD870 Se B Lev kosfn uti vp KOD870 23 11 2007 23 11 2007 L N UTTAG 9 459 666 24 VE Uttag LON UTTAG 23 11 2007 23 11 2007 51703362 EPA Tl Bankgiroinb 51703362 28 11 2007 27 11 2007 910000515957 S M ins ttning 91000051595742 01 12 2007 30 11 2007 51595742 254 23 11 2007 23 11 2007 20000029 51 726 Remove selection 24 11 2007 24 11 2007 L10013689 2 869 915 Greater than or equal to 24 11 2007 24 11 2007 L10014342 6 149 731 Less than or equal to 24 11 2007 24 11 2007 L10014814 464 140 Equals to 30 11 2007 30 11 2007 BF6003647 899 Remove filter for this column Remove all filters Send transactions by E mail outlook Copy transactions to Excel Select a word or a number string or a part of a word or number string from one of the text columns Right click and select Contains from menu to set filter to what you have selected or right click on a single cell in a column and select Equals to Date and amount can also be filtered on Greater than or equal to Less than or equal to or Equal to lt is also possible to apply filters to several columns at the same time Reference Amount V Text Comment T KOD870 1 500 00 E Lev kostn KOD870 7 LON UTTAG 9 459 666 24 7 Uttag LON UTTAG 51703362 1 422 897 00 a 5170336
29. ank Encoding Set the encoding to the encoding of your text file If you do not Know the encoding of your text file use the standard Western European Windows 1252 Windows 1252 Static account Use this static field if your text file does not contain any account number or account name Enter the appropriate account number Debit Credit columns To be selected if debit and credit transaction amounts are divided in to two separate columns in the data file Invert amount Inverts the amount Plus to minus and minus to plus Multiplier Multiplies the amount in the text file with the value in multiplier E g 1000 multiplied with 0 01 equals 10 00 Start at line Use this if the transaction data in the text file does not start at the first line E g if you have a header in the text file set the value to 2 Decimal symbol If the amount look like this 100 000 00 the value will be Digit grouping symbol If the amount look like this 100 000 00 the value will be User manual Adra Match Accounts Page 11 d m tch Accounts Columns Column index Delimited file Insert the number of the corresponding columns in the text file From Length Position Insert the start position and length of the corresponding columns in the text file Mandatory fields Account no The account number in the data file Amount
30. arger then Less then This value selects which transactions to reconcile If you enter 0 00 in the first box and 1 00 in the second box only transactions with the amount 1 00 to 0 00 on the left side and transactions with the amount 0 00 to 1 00 on the right side will be reconciled Intervals for allowed deviation Deviation Larger then Less then This option is only active if you have the option Reconcile with deviation in percent selected If you enter 1 00 in the first box and 10 000 00 in the second box the rule will only reconcile transactions with the amount from 10 000 00 to 1 00 and 1 00 to 10 000 00 User manual Adra Match Accounts Page 51 d m tch Accounts Set the order of automatic reconciliation rules Click on the dropdown in the Order column to select the priority order of the reconciliation rules It is good practice to start with the tightest rules e g One to One match with a short date deviation before One to Many or many to one rules are processed adra match Settings for automatic reconciliations Account group Bank Account gt User manual Adra Match Accounts Page 52 Actions to perform after import This feature can be used to run actions or tasks after import Data enrichment with regular expressions Find Expression and add new d m tch Accounts This feature can find an expression by using Regular Expressions in a text column that ex
31. ciled on the selected BDate date Reports and content Open items Gives you the open transactions list within an account group or client or for all clients together with the balance of each account and the number of open transactions This list can be sorted on several different columns including date amount and text and reference Username timestamp and date are also included Open items bank This report is only accessible if the right account type is ledger and the left is bank or vice versa The report is split on debit and credit bank ledger and gives you the sum of these Reconciled Transactions Reconciled transactions after your chosen date The number of transactions timestamp creation date and username are also displayed Balance The balance and the sum of the open transactions for all available account groups A timestamp and username are also displayed Corrected Transactions A report of all the transactions reconciled with a deviation giving you the deviations the total amount and the number of transactions reconciled with a deviation A timestamp and username are also displayed User manual Adra Match Accounts Page 30 d m tch Accounts Custom Reports Reports can be customized to suit your needs A custom report made according to your spescifications can be ordered from Adra Match Add a Custom Report A custom report made by Adra Match is normally sent to you via email Save
32. ckups will always be saved with the name AmBackup YYYY MM DD HH MM SS xml If Adra Match support asks you to send them a backup go to the backup folder right click on the backup file and select Send To Compressed zipped Folder Send the ZIP file you created to Adra Match support m tch Backup Restore Create backup Select path C Backup 2010 Create backup mv User manual Adra Match Accounts Page 38 d m tch Accounts Settings for exceptions Set the allowed deviation for interactive manual reconciling When reconciling with a deviation a balancing transaction with the deviation amount will be saved as an open transaction in Adra Match Accounts Correct this transaction in your ledger and when a file containing the adjustment is imported into Adra Match Accounts it will clear the open deviation amount thus returning to a reconciled position Select Maintenance Settings for exceptions Edit accounts and account groups Imports Files and folders Undo import Reports Settings for automatic reconciliations Select the Account group that you want to change the values to Enter the deviation you want to allow in the Allowed deviation field If you have large amounts of open transactions you can enter the Maximum number of transactions shown to display per page in Exceptions and the sort order of them Click Save and Close maintenance
33. cted import and client Paths for file import in engagement mode can also be set up Select Maintenance Files and folders Undo import Reports Settings for automatic reconciliations Settings for exceptions Registration Backup Restore License settings Select the import you want to set a folder path for Select a path to the folder where the files are located You can also setup a path to a Backup folder Select a Filter e g to show only text files txt Click Save To select a path for an import in engagement mode imports data to all clients Select Engagement mode before you select your import and paths It is also possible to run action after import See Actions to perform after import for more info Client Co Sweden E Engagement mode Select import Match Standard file format TAB Folder c My Files Backup folder c My Files Backup Filter idi Actions to perform after import Ci Find expression and add new ee X Maintenance Help User manual Adra Match Accounts Page 13 d m tch Accounts import This is where you import the files from your Bank ERP or other Source System Click on mport Click it again and you are presented with three options see below What you select here is saved for the current user and PC Import to all clients t is possible to import to two or more clients simultaneously if the accounts you are im
34. e Date or BDate Select type of preview on the dropdown Select report format Then click Preview O match Client Sweden Bi isi VVelcom Import Automatic Exceptions Select report Sort on Balance Amount vl Corrected Transactions em GRC Management Dashboard Reference NetNet Date Open items bank Reconciled Transactions ReportLog Per date 15 desember 2010 El Select type Active client All available clients Select an account group Select report format PDF 2 The report can be previewed in three fromats PDF RIF TXT XLS and Report Viewer Note that the application is delivered with a set of standard reports In addition Adra Match provides tailor made reports according to your specifications If you need a specific report please contact Adra Match User manual Adra Match Accounts Page 29 d m tch Accounts Vievv historical date A historical report can only be created as an Open items Open items Bank or Balance report The balance is also shown in the Open items and Open items Bank reports Per date Produces a report with all the transactions that were imported and not reconciled up till the selected Per date date Date Produces a report with all the transactions not reconciled on the selected Date date BDate Produces a report with all the transactions not recon
35. e Text and Reference Amount You can choose vvhether you vvant to search for exact amount or from and to amount To search for an exact amount type in the amount you are looking for in the Amount field Adra Match Accounts will then search for this specific amount and list up all reconciled transaction lines on that account group regardless of what sign the amounts have When searching for exact amount only the name of the field is Amount As soon as you type in both From and To date the label of the field will change Example If you search for From Amount 120 and To Amount 250 Adra Match Accounts will display all amounts between these two amounts Open From Amount To Amount Comment Client Co Sweden SEE Search Clear Date BDate 06 11 2007 06 11 2007 07 11 2007 21 11 2007 06 11 2007 07 11 2007 21 11 2007 30 11 2007 02 11 2007 02 11 2007 03 11 2007 13 11 2007 20 11 2007 21 11 2007 28 11 2007 01 11 2007 22 11 2007 23 11 72007 22 11 2007 23 11 2007 14 11 2007 13 11 2007 28 11 2007 27 11 2007 07 11 2007 21 11 2007 06 11 2007 07 11 2007 21 11 2007 30 11 2007 02 11 2007 02 11 2007 02 11 2007 10 11 2007 17 11 2007 20 11 2007 27 11 2007 01 11 2007 21 11 2007 22 11 2007 22 11 2007 23 11 2007 13 11 2007 13 11 2007 27 11 2007 27 11 2007 Reference 20061106 20061107 20061121 BF6003241 BF6003262 BF6003392 BF6003510 5500000901
36. e reconciliation between debit to credit within the account Set it to Unique if the account number is unique for the entire engagement This enables the possibility to import at engagement level Import to all clients Click Save to save the added edited account s This procedure has to be done for all accounts you want to reconcile in the application 10750550555 X Maintenance Help User manual Adra Match Accounts Page 6 0 m tch Accounts Click Account group Make sure that the right account group is selected Select one or more of the Available accounts Then click the up arrow to add account to Ledger Left or Bank Right It is also possible to change account type Ledger or Bank When you have finished click Save Client Co Norway Edit accounts and account groups Close maintenance Account group Account settings Account group Bank Recon 2 Accounts for account group Ledger Bank 10750550555 Account group Bank Recon Left account type Ledger Right account type Bank Delete transactions Delete reconciled transactions with reconciliation date Delete reconciled User manual Adra Match Accounts Page 7 d m tch Accounts Set starting balance Click Set starting balance under Account group Set the balance of the month period you want to star
37. e type XML import or User defined import Imports with the type File cannot be changed or deleted Administrators can import to all clients by checking Engagement mode Click Get XML to view the code of an existing XML import or User defined import match Client Corporate Recon Bee Engagement mode mport name Huvudbok ERP ntema Balans ntema Resultat Jyske Bank CSVfile Mamut enterprise Match Standard file format TAB Match Standard filformat Micro 80 MuttiSoft My ERP system p e i Output output gt Nordea Com Manuel udtreek n 3 gt Nordea EKK Nordea K Link Corporate Netbank Nordea K Link Corporate Netbank Nordea K Link Corporate Netbank Utland Nordea K Link Corporate Netbank Utland Nordea Untel Danmark s2000 Payx PlusGirot Girovision SEB KK BGCom test Matchitem lu ez output EditKST gt SEB SEBRA lt col pe Output name Content output _ Match x g nu lt row Er an SHB inl sen Swedbank e CM Swedbank och Sparbankema SWIFT Syd Bank ASC udg 3 Uni micro Unitel test import 5 JF EEF 241 2211 Visma business Visma business Bdate Visma contracting B R F Z R F F F F
38. eptions manually where not auto matched or investigate and resolve Produce and Print reports Login Log in with the username and password you have been assigned 4 Adra Match Accounts login User manual Adra Match Accounts Page 4 0 m tch Accounts VVelcome Page Once logged in Adra Match Accounis vvill shovv a vvelcome page displaying the account groups of the clients the user has access to Client Recon mport Automatic Selected client Corporate Recon Date 03 05 2011 Account group Last import Last reconciled Accounts Payable Receivable 16 03 2011 13 01 02 46 03 2011 13 03 07 Welcome Carole Smith Open transactions 15 Sum open transactions 2 800 92 Last logged in Account Open transactions Sum open transactions Balance 03 05 2011 07 53 ACCOUNTPAY 9 7 770 00 6 510 200 78 Logged in as ACCOUNTREC 6 4 969 08 6 507 399 86 Admin Account group Last import Last reconciled License expires in 28 days Bank Account 02 05 2011 07 57 34 Open transac tions 1 Sum open transactions 8 006 06 Account n transactions Sum open transactions Balance 1040 8 006 06 51 659 948 00 10750550500 0 00 51 667 954 06 Account group Lasti Last reconciled Bank Test Open transactions 0 Sum open transactions 0 00 Account 1050 80012345678 The Welcome Page works like a dashboard showing all clients that are available to the user logged on Select Client in the box in the right
39. ger against Ledger all the text fields BDate and Date from the oldest transaction with the largest amount will be saved A reconciliation ID is added on a new row in the text column Variance should be used if you want an item to correct in your ledger e Saves the text fields and date from the oldest transaction with the largest amount from the Ledger side If you reconcile Bank against Bank or Ledger against Ledger all the text fields BDate and Date from the oldest transaction with the largest amount will be saved The Reference will be copied text column and replaces Reference will be replaced with Diff 1296 The number is the unique variance number and adds a Reconciliation ID on a new row in the text column Variance transactions can be printed separately Split This option will reconcile a part of the transactions and save the remainder an open transaction Value of open transachon Variance This option will reconcile the transactions and save the difference as an variance Variance transactions can be printed separately 23 11 2007 Diff 1296 0 35 Value of variance 0 35 INS SYSTELMVPA014 Reconcile id 18328 INS SYSTELMVPA014 Reference E40000067 1941 Reconcile id 18326 User manual Adra Match Accounts Page 25 d m tch Accounts Reconciled transactions Click the tab Reconciled Here you can undo reconciled transactions search for a reconciled transaction see whe
40. ists in the selected import and database and insert a new value into an existing or new column This vvill only be performed on the imported file Select import Select Find Expression and add new and click on the button to the left of the option to open the settings vvindovv Enter your Regular Expression on the column Find expression f you if you enter a number or text in the Find expression column the function will search for it in the select In column Select your n column from the dropdovvn Enter the text and or number you vvant to insert into the nevv or existing the insert vvill only happen if the imported text column ln column contains the Find expression value Enter the name of the new or existing column in the Into column and select a account Click Save Regular Expressions can be used with numbered groups Example if you would like to extract a number from a column containing the text Check nr 4358 Enter the Regular Expression Check nr d 4 into the Find expression column and 1 in the Insert text column the number 4358 will be inserted in to the new or excising column Files and folders Engagement mode Select import Bank Accoount Cards Folder C Demo AMAN Cards Backup folder 10518538 10518546 Filter BANK 3554000000 10518553 Actions to perform after import V Find expression and add new Save Reset M Maintenance Help column Edit Store
41. k LALO TA Select V Remove selection Le Ba Equals to AN Remove filter for this column Ins Remove all filters Send transactions by E mail outlook E Bankgiroinb 51703362 UTLAND L N 0611 E KANSLI L N 0611 Uttag LON UTTAG User manual Adra Match Accounts Page 22 d m tch Accounts Search for Open Transactions Another way of searching for open transactions is to use the functionality in the Search tab under Exceptions Search m tch Welcome Import Automatic Reports v Accountgroup Accounts Payable Receivable x Open Reconciled 2 Reconcile Amount Date 06 05 2011 By To Amount To date 06 05 2011 EM Comment Search Clear Date BDate Reference Amount Text Comment This feature allows you to do extended search among the open transactions You can search for a specific values or search within to and from values Amount You can choose whether you want to search for exact amount or from and to amount To search for an exact amount type in the amount you are looking for in the Amount field Adra Match Accounts will then search for this specific amount and list up all open transaction lines on that account group regardless of what sign the amounts have When searching for exact amount only the name of the field is Amount As soon as you type in both From and To date the label of the field will change Example
42. k Save License settings Clients Users License Max Clients Clients used 10 User manual Adra Match Accounts Page 33 d m tch Accounts Add or edit users User Privileges and Roles Adra Match Accounts contains five levels of roles and user privileges Grouped from highest to lowest order these are e Admin e Super User e User e Restricted User e Viewer Admin is the superior user level and has full user rights at all levels in the program Super User has full control on all available clients This role can do anything except from change licenses users or clients and taking backup Holding the User role you can do any typical user task in the program such as o Set Available Clients Set available Account Groups o Import Reconcile Report Import data Auto reconcile Exceptions Manual reconciliation e Undo Reconcile o Older than undo Auto reconciled e Reconcile with variance o Max amount Print Reports o Available on Maintenance Menu Undo Import Registration of new starting basis A Restricted User has the same rights as a User except from on Maintenance where only Undo Import is available The Viewer role is typically meant for auditors A Viewer would normally be interested in performing IT audit and accounting audit of work
43. le ence Amount W V Text T Comment Acc no 58000 260 00 7 ACCOUNT Select 58000 500 00 F ACCOUNT Remove selection 58000 892 00 27 ACCOUNT 58000 1 652 00 r Equals to ACCOUNT Remove filter for this column Send transactions by E mail outlook Copy transactions to Excel Click the checkbox in the column header of the V column to select all open or filtered transactions Unselect clear all selected transactions Citrl Z to undo the last manually reconciled transaction Ctrl U to jump up to the next checked transaction Ctrl D to jump down to the next checked transaction Right click in the grid and select Send transactions by E mail Outlook to copy checked transactions to Outlook E mail 29 26 254 35 899 00 1 500 00 4 482 00 24 120 50 4 50 000 00 51 726 32 464 140 22 1 371 171 03 1 422 897 00 2 869 915 26 6 149 731 26 9 459 666 24 T VP TESTAMENTE E Bankgiro inb 51595742 m OF Select F Le Remove selection Ba AA Equals to E in Remove filter for this column 7 N Remove all filters Al anf AD Copy transactions to Excel E Ban in E UTLAND LON 0611 E KANSLIL N 0611 E Uttag LON UTTAG Right click in the grid and select Copy transactions to Excel to copy checked transactions to Excel 464 140 22 1 371 171 03 1 422 897 00 2 869 915 26 6 149 731 26 9 459 666 24 VP ItSIAMENIt B is in
44. mn name Datum columnNumber 3 lt column name Konto lt column name Mpart lt column name Val lt column name Belopp lt row gt lt row name Matchitem read false gt lt column name Content output _ InLine Val type Output gt lt column name Ref output InLine Ftg InLine VerNr InLine Mpart InLine Konto type Output gt lt column name AccountNo output balans type Output gt lt column name VDate output InLine Datum type String inFormat yyyy mm dd gt lt column name Amount output InLine Belopp type Output gt lt column name ItemLevel output 0 type Output gt lt row gt lt row name ExtraVerNr test InLine VerNr 1 read false gt lt column type Output output VerNr gt lt column type Output name Content output _ InLine VerNr gt lt row gt rov name ExtraFtg test InLine Ftg read false gt lt column type Output name Type output Fig gt lt column type Output name Content output InLine Ftg gt lt row gt lt row name ExtraMFtg test InLine Mpart read false gt lt column type Output output MFtg gt lt column type Output name Content output substring InLine Mpart 2 2 gt lt row gt rov name ExtraMpart test __ InLine Mpart read false gt lt column type Output
45. n it was reconciled by whom and if it is manually reconciled or not Select a date from the dropdown menu Reconciled after to see reconciled transactions after a specified date this will also include the transactions reconciled on the selected date If you want to undo a reconciled transaction select the check box on the transaction you want to undo and Adra Match Accounts will automatically check the transaction it is reconciled against Then click Undo button to return the transactions to the Open tab adra match Welcome Import Automatic Reports Account group Bank Account gt Reconciled after 04 05 2011 v Open Search Undo Date BDate Reference Amount V Text Comment 23 11 2007 23 11 2007 Variance 947 0 35 F INS SYSTELMVPA01 2 15 11 2007 NonRef 29 26 inl sen vardepap 15 11 2007 15 11 2007 BF6003536 29 26 E TESTAMENTE 03 11 2007 02 11 2007 8107039 50 00 Bankgiro inb 8107039 02 11 2007 02 11 2007 BF6003195 50 00 810 7039 NR 70 20 11 2007 17 11 2007 51703361 78 00 E Ocrinb 51703361 17 11 2007 17 11 2007 BF6003353 78 00 5170 3361 02 11 2007 01 11 2007 9020405 100 00 E Bankgiro inb 9020405 01 11 2007 01 11 2007 G40004200 100 00 F INS SYSTBG 9020405 20 11 2007 20 11 2007 NonRef 100 00 Avg eni faktura User manual Adra Match Accounts Page 26 Search and Replace Reconciled Transactions d m tch Accounts It is possible to search for reconciled transactions on Amount Comment Dat
46. ne from ACCOUNT REG The three transactions on ACCOUNTPAY have the same amount as the single transaction on ACCOUNT REGC The smallest date devition between ACCONTPAY and ACCOUNTREC is 23 days 5 215 00 and 431 00 and the largest deviation within the ACCOUNTPAY bundle is 88 days 5 215 00 and 4 665 00 11 36 2007 6905250000 119 00 1181959 ACCOUNTP AY TO e007 6905250000 3 215 00 1151358 ACCOUNTPAY 132008 6905250000 4 565 00 1181959 ACCOURTP AY 10 30 2007 6905250000 431 00 1161959 Below you can see the reconciliation rules with Indexing Default to the left and Indexing RegEx to the right User manual Adra Match Accounts Page 45 d m tch Accounts Create a One to One reconciliation It is easy to create a reconciliation rule that reconciles one transaction from the left side often the ledger account against one transaction from the right side often the bank account within a date deviation Start by selecting Settings for automatic reconciliation from Maintenance Select the Account group you want to add the reconciliation rule to Click Add ada match Client Co Dermak See Settings for automatic reconciliations Account group Bank Account Order Name Type User manual Adra Match Accounts Page 46 d m tch Accounts Give the reconciliation rule a clearly descriptive name Then select the date deviation In this case we want to reconcile transactions again
47. nsactions to the reconciliation Test Free text ha 334 00 48501234 gt transfer 756 663 00 1941 Balance 35 049 422 61 35 101 769 61 User manual Adra Match Accounts Page 42 d m tch Accounts Settings for automatic reconciliation This is where you manage your settings rules for automatic reconciliation You can add settings to reconcile one to one many to one many to many or within an account You can reconcile on parameters texts amounts and dates Click Automatic Click Settings Settings for automatic reconciliation Reconcile general Reconciliation rules Settings Reconcile using the same text string for Ledger and Bank Only reconciles if the information in the bank and ledgers text string are the same For example if the text OCR is in both sides text strings Reconciliation within an account debit credit Reconciles one debit transaction against one credit transaction within one account The transactions must be within the allowed Date deviation The account must be set to nterim Reconcile a suspense account sum Reconciles one or more transactions within the same account with the same text string The setting indexes on one column and tries to find a match within the same account with the same text string which it then sums up to test to see if the sum is zero The transactions that are summed up must be within the
48. ork in the same way as the Date fields Comment To search for text or numbers type in the full string or parts of it Text The text should contain the search string anywhere in the text Reference The reference should contain the search string anywhere in the reference text For all fields press Clear to remove contents If you want to undo reconciled transactions click on the actual transaction you want to undo Adra match Account will then display in a new window the transactions that were reconciled and that were given the same reconcile id Click on Undo User manual Adra Match Accounts Page 28 d m tch Accounts Reports This is where you produce and print reports for one or more account groups and clients Click on the tab Reports Select report type sorting and the account group s or client you wish to print Select Active client to show all accounts on active client or All available clients to show all account groups on all clients you have access to Select more than one account group by holding down the left mouse button and drag the mouse over the account groups or hold down Ctrl and select the desired account groups with the mouse or select the first account group and scroll down to the last and hold down Shift and select the last too select all You can also select a date to be printed on the report If you check the View historical date check box to produce a report on Per dat
49. ou can of curs RegEx Indexing here to The Regular Expression could look like this d 6 w 2 Settings for automatic reconciliations Account group Reconciliation type Reconcile general Name One to One Ref Reconcile using the same textstring for Non and Suspense Account Reconcile a suspense account sum Date deviation 02 Many items from Credit Date deviation vath n bundle Indexing 4 Reconcile a suspense account debit credit Suspense Account 1020 Reconcile only when one alternative exists OF Index type Split on space IF Split on other Only numbers Length 0 Cancel Save adra match Settings for automatic reconciliations Account goup veconc on type cle gener sre One to One Ref leconci ing the same text string for Debi leconci uspense account debiticredi Reconcile only when ane enst Date range 05 0 Many items Irom Crest From To Date range within group Date range withn group Group ters Group ters No of items in group No of rtems in group Indexing indexing Index type RegEx x Index type Field Ret Split on space Regt di5h v 1 Split on offer Field Only numbers Length Reconcile with Split or Variance Gir ee Maintenance Help Many iteens fram Debet Hany items from Debit Date deviation vath n bundle Indexing Index type Split on space Split on other Field Only numbers Length
50. ount deviation Enter the or amount deviation you want to allow If you enter 25 00 the rule will reconcile all transactions where the amount of the right side transaction s is 25 00 amount units less than the amount of the left side transaction s Enter a negative amount deviation like this 25 00 Allowed percent deviation Enter the percent deviation you want to allow If you enter 1 50 the rule will reconcile all transactions where the amount of the right side transaction s is between 1 50 less to 1 50 larger than the amount of the left side transaction s User manual Adra Match Accounts Page 50 d m tch Accounts Allowed or percent deviation Enter the or percent deviation you want to allow If you enter 0 10 the rule will reconcile all transactions where the amount of the right side transaction s is 0 10 amount units less than the amount of the left side transaction s Enter a negative percent deviation like this 0 10 Allowed amount tolerance on deviation This option is only active if you have the option Reconcile with an exact deviation or selected Enter the tolerance you want to allow on the exact deviation If you enter a 0 10 on this value and have an exact deviation of 1 00 the rule will reconcile transactions where the amount on the right side is 0 90 to 1 10 amount units larger the amount on the left side Intervals to reconciliation Amount L
51. outines on an engagement or just some of them Client Level You can choose whether you want to run scheduler on all reconciliation routines on a Client or just some of them To run the scheduler the file AMAScheduler dll and Scheduledob xml need to be located in the Adra Match Account application folder Note If you change the name of an Account Group or a Client that is referred in the ScheduleJob the ScheduleJob must also be changed To start the file ScheduleJob xml a Task Scheduler needs to be created Open Windows Task Scheduler and select Create Task Password needs to be a Windows User Password never expires User manual Adra Match Accounts Page 18 d m tch Accounts Exceptions This is where you reconcile your outstanding transactions interactively Search sort summarize and filter to find transactions that match but were outside of the specified rules set up in the system Select Exceptions Click on Exceptions once more and you have several options Reconcile Reconciles the checked transactions if the sum is O or if the deviation is within the allowed limit for the account group Search Search for a transaction among the open reconciled transactions Reconcile when sum is 0 Reconciles the transactions without prompting the user when you have checked two or more transactions that summarize to zero Show reconciled transactions Shows the reconciled transactions of the selected
52. ported Click Back to return to the balance window Make sure that the balance is correct and then click Accept If it is incorrect click Cancel and redo the import You can also click Print to print the balance for all the imported accounts Match New Balance 28 26 VAND BF 6003535 SE 2453 2826 INS SYSTELMVPADI4 29 26 VP TESTAMENTE 50 00 810 7039 NR 70 78 00 5170 3361 100 00 INS SYSTBG 3020405 100 00 INS SYSTBG 1954393 1000 SERVICEBOX 28 8 28 9 26 10 100 00 INS SYSTBG 1554393 100 00 INS SYSTBG 9095895 102 00 110 00 LKUTLBET 061128 120 00 LK UTLBET 061106 120 00 LK UTLBET 061107 120 00 UK UTLBET 061121 120 00 LK UTLBET 061130 200 00 INS SYSTBG 3016091 PEM Ketone Adra Match New Balance 268 transactions imported A ml Couldn t find Account No 1942 Line 125 126 127 rows dropped empty ref 3 rows dropped Line 26 27 dropped Wrong date format 2 rows dropped Examples 2007 13 02 2007 13 02 Expected format yyyy MM dd 5 The file Ledger Suveden 1941 mstt is probably imported from before x Client Acc no Balance 35 582 582 32 CE Do this once per ERP Bank or Source you want to import files from User manual Adra Match Accounts Page 15 d m tch Accounts Automated reconciliation This is where you run your settings rules for automatic reconciliation You need to set up settings rules for automatic reconciliation for this
53. porting to are set to unique under Maintenance Accounts and account groups or if they aren t unique have a client number set under Maintenance License settings that also needs to be in the file you are importing Exclude duplicate transactions Excludes already imported transactions from your data file If you add transactions to an already imported booking period you can export a new data file from your ERP on the same booking period and import it to Adra Match Accounts and only import the new transactions in the data file to Adra Match Accounts Show advanced settings Gives you the option to limit the import based on date Select import lf you successfully set up the correct paths under Files and folders you can select the file s you want to import and click Import as the files will appear in this window automatically It is possible to import one or multiple files of the same type at the same time Select one data file by selecting one row with the mouse Select multiple data files by clicking and dragging the mouse over the data files Add files manually by clicking Add User manual Adra Match Accounts Page 14 d m tch Accounts Balance post import When the files are imported you will be prompted with the number of transactions imported and the balance post import By clicking the magnifier glass next to the balance you can see the transactions that have been im
54. set date deviation Remember to set the account to nterim to use this reconciliation rule Reconcile when only one alternative exists Reconciles provided that only one alternative exists within the allowed date deviation you just need to create a new setting give ita Name select Reconcile when only one alternative exists set a date deviation and click Save Date deviation This is the deviation between transactions on the left and right side often the bank and ledger accounits The deviation can be set to reconcile transactions booked before or after the transaction you are reconciling Reconcile using the same text string for Ledger and Bank Reconcile a suspense account debit credit Reconcile a suspense account sum Reconcile only when one altemative exisis Date range 0 0 User manual Adra Match Accounts Page 43 d m tch Accounts Many items from Select if you want to reconcile One to Many Many to One or Many to Many If the transactions in the bundle you vvant to reconcile are booked on different days you have to set a Date deviation vvithin the bundle Many items from Ledger Many items from Bank From To From To Date range within group D 0 Date range within group 02 02 Group items Group items No of items in group D No of items in group If you know that just a known number of the transactions found on the Many side in a One to Many Many to One or Many to Man
55. st one another with the same amount that deviates 5 days Set the Date deviation to 5 and 5 Click Save Settings for automatic reconciliations Account group Bank Account Reconciliation type Reconcile general X Name One to One 5 days F Reconcile using the same text string for Ledger and Bank Reconcile a suspense account debit credit Reconcile a suspense account sum Reconcile only when one altemative exists Date range 52 524 Many items from Ledger From To Date range within group 0 Group items No ofitems in group 0 Indexing Index type Split on space Split on other Field Ref x Only numbers Lengih SI E Reconcile with Split or Variance Many items from Bank From To Date range within group 0 Group items No of items in group 0 Indexing Index type Split on space El Spliton other Field Ref x Only numbers 127 Length 0 User manual Adra Match Accounts Page 47 0 m tch Accounts You can also create a One to One reconciliation rule that checks if a text string or a part of text string is alike on the two transactions In the example below the transactions we are about to match if from the same account one debit and one credit The date and reference number is the same B31 2007 105306 366 00 631 2007 105306 366 00 Text 1020 1020 Below you see how the rule should set up Y
56. t your reconciliation and remember to reverse the signs of the bank transactions Then manually enter the open transactions from ledger and bank Remember to reverse the signs of the bank transactions Do not forget to select the correct account number When Difference is zero click Insert to save the starting balance and the open transactions Registration of start sums for account group Bank Recon tt R RN Register balances and open posts for each account and click Insert when the difference is 0 NB Bank transactions and expense accounts are registered negatively Text 00606 f f 00 Total registered 8 006 06 Corrected balance an 51 667 954 06 Bank 51 667 954 06 Variance 0 00 Insert Cancel User manual Adra Match Accounts Page 8 d match Accounts Imports Select Import from the Maintenance menu to select predefined import add an XML import or create a user defined import If you have received a standard import for your company it will be available here Select Maintenance Imports Edit accounts and account groups Files and folders Undo import Reports Settings for automatic reconciliations F Settings for exceptions Registration Backup Restore License settings X Maintenance Help Click Add to add new import or select one of the existing imports to Edit or Delete It is only possible to edit or delete imports with th
57. the custom report to your desktop You will also get screen dump with the settings your report is customized for Start Adra Match Accounts and login Select Maintenance Reports Imports Files and folders Undo import Settings for automatic reconciliations Settings for exceptions Registration Backup Restore License settings Client Co Sweden Close maintenance Rapport type n use on active client n use on all clients Admin only IEIE ElE E 25 ElElElE E EE mmi L Delete User manual Adra Match Accounts Page 31 d m tch Accounts 1 Enter a report name 2 Select a report file RPT 3 Select the settings the report is designed for 4 Select the output type CRV is the Crystal Reports Viewer Click Save Only select Use standard AMA data if you want to use datasets from AMA engine This can be used if you e g want to change an existing standard rapport Client Sweden Reports Close maintenance Name 1 GRC Management Dashboard ImportT ype Crystal Reports Crystal Report Selected report file ManagementDashboard rpt Select report file C Users My_Reports AgeAnalysis Week mt 2 a a Settings for Report tab Use standard AMA data Show
58. umn For example Try to find one or more transactions from the ledger that match the amount of one or more transactions in the bank You are helped by the calculator in the upper right corner which Summarizes the number and amount of the selected items and highlights the net difference When net difference is zero or within the allowed deviation Sum remaining the Reconcile button will be active Click on Reconcile to reconcile the selected transactions Keep doing this until you are out of reconcilable transactions adra az J Bun Welcome Import Automatic Reports ma B xl Debit Credit Count debit Count credit Ledger 1 552 00 1 200 652 00 2 Bank 1 199 100 00 0 00 1 0 Sum 0 00 Sum remaining 0 Reconciled re ee I Date BDate Reference Amount V V Text Comment Acc no 08 11 2007 08 11 2007 BF6003374 432 00 V ARVODE NAMN 1941 09 11 2007 09 11 2007 LON UTTAG 1 199 100 00 V Uttag LON UTTAG 48501234 10 11 2007 10 11 2007 BF6003532 1 120 00 V NAMN ARVODE 1941 10 11 2007 10 11 2007 L10013562 1 200 652 00 ARVODEN UPPDRAG L N 0632 1941 22 11 2007 22 11 2007 KOD870 1 500 00 Lev kostn uti vp KOD870 48501234 23 11 2007 23 11 2007 LON UTTAG 9 459 666 24 E Uttag LON UTTAG 48501234 23 11 2007 23 11 2007 51703362 1 422 897 00 Bankgiro inb 51703362 48501234 23 11 2007 23 11 2007 E20000029 51 726 32 E INS SYSTELMVPA012 1941 23 11 2007 23 11 2007 E40000067 1 371 171 03 INS SYSTELMVPA
59. unts Guide Adra Match Accounts Preparations Export an account statement as a text file from your Financial Ledger referred to herein as ERP containing the accounts you vvish to reconcile Usually this is done via a Report or Export function in your ERP system o Create a folder on a network drive where you can save the files e g G AccountMatch name_of_ERP o Create a backup folder where Adra Match Accounts will move the imported files e g G AMAccounts name_of_ERP Backup o The file must be a text file Excel files can be used if it is saved as a TAB delimited text file Obtain your bank statement as a text file from your bank o Contact your bank for further instructions on how to do this Most banks provide this service via their web site or through online banking software o Create a folder on a network drive where you can save the files e g G AMAccounts name_of_bank o Create a backup folder where Adra Match Accounts will move the imported files e g G AMAccounts name_of_bank Backup Daily routines Download the text file account statement from your ERP system Download the text file account statement from your bank Log in to Adra Match accounts Import the file from your ERP system and bank into Adra Match Accounts Verify that the post import balance is the same as the balance on your bank and ledger account s Run the automatic reconciliation routine s Reconcile exc
60. upper corner The welcome page will then display all the Account groups belonging to the client you chose Edit accounts and account groups Before you start using the program you have to register some basic information about the accounts you want to reconcile in Adra Match Accounts In the tab Edit accounts and account groups you can add modify and delete accounts and account groups Set the starting balance of account groups delete all transactions or delete all reconciled transactions up to a specified date Select Maintenance Edit accounts and account groups Imports Files and folders Undo import Reports Settings for automatic reconciliations Settings for exceptions Registration Backup Restore License settings Maintenance Help User manual Adra Match Accounts Page 5 d m tch Accounts Click New and select a name for the account group Click Save Client Co Norway Edit accounts and account groups Close maintenance Account group Account settings Account group New account group D Account group Bank Account Recon Y Left account type Ledger Right account type Bank Set starting balance Delete transactions Delete reconciled transactions with reconciliation date Delete reconciled Select Account settings click New and enter the account number Set it to nterim to enabl
61. y reconciliation rule matches the other side For example 3 out of 5 transactions on the same day on the Ledger side match a single transaction on the Bank side Select Bundle combinations on the Ledger side and set the value to 3 in fems returned Adra Match Accounts will now try to find all unique combinations of 3 out of the 5 transactions in the bundle and try to match the single transaction on the Bank side From To From To Date range within group 0 0 Date range within group 0 0 Group items V Group items No of items in group 3 No of items in group 1 Indexing You can select two different index types Default creates the index by splitting the text on space or on other You can also select which Field you want to create an index from and if the vvord string is only numbers and length of the vvord string 0 as Length will Index vvords strings of all lengths RegEx creates an index item from the Value of a Named Value that is defined in the regular expression You can find more information on Regular Expressions on the internet Indexing Indexing Index type Default 7 Indextype RegEx Fie Tae 2 Split on other RegEx Qh UCU oo Field Text M Only numbers Length 0 User manual Adra Match Accounts Page 44 0 m tch Accounts Examples Default indexing On the image below you can see four transactions three from ACCOUNTPAY and o
Download Pdf Manuals
Related Search