Home

User manual Adra Match Accounts 13

1. The information window also shows if something went wrong during the import Do this once per ERP System Bank or Source you want to import files from Import Wizard The Import Wizard feature guides the user through a wizard to setup a new import template instead of setting up one beforehand User can initiate the process by clicking Import Wizard button in the Import Tab Clicking on Import Wizard button will open a new Pop up window for Import Wizard 19 adra match Accounts Import Wizard Step 1 Select File screen Select a delimited text file to import or paste clipboard data from Excel or from a tab delimited file into the grid below Encoding Windows 1252 Enter a file name or description optional The user has the following options e Select a delimited text file to be imported Select File Mode e Paste data from an Excel file or a Tab delimited file in the space provided Paste Mode lf the user picks File Mode and selects a text file to be uploaded the user will be presented with a preview of the file content lf a user opts to use the Paste Mode the user will be taken directly to Import Wizard Step 3 Map Colum screen 20 d match Accounts Import Wizard Step 1 Select File screen preview file content Select a delimited text file to import or paste clipboard data from Excel or from a tab delimited file
2. Maintenance Help Custom Reports Reports can be customized to suit your needs A custom report made according to your specifications 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 the custom report to your desktop You will also get screen dump with the setiings your report is customized for Start AMA and login 13 d metch Accounts Select Maintenance Reports Imports Files and folders Undo import Settings for automatic reconciliations Settings for exceptions Registration Backup Restore License settings Client Co Sweden In use on active client In use on all clients Admin only G E 0 8 S S E 7 8 8 000g Enter a report name Select a report file RPT Select the settings the report is designed for Select the output type CRV is the Crystal Reports Viewer aa aT 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 14 d match Accounts Reports Name 1 GRC Management Dashboard mportType Crystal Reports z Crystal Report seor Oe 2 Select report file CAUsers My_Reports AgeAnalysisWeek pt a 3 Settings for
3. 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 XLM import Select XML Type or paste the XML code in to the window Click Save XML import lt hi vertion aleer ar so 8959 1 lt impMetchOOFie xmins http wines abanaich com tapa Odie debated ue delmier t gt lt collection name Fie gt crow name Settings sade Tale gt lt column name NumberDecmal Separator types Output output lt column names i ame n ae a types Opat cutee gt lt column nane RemoveSpace type Output output talse lt ow gt crow names Type sade Talse gt lt column names Type types Outpt outputa MOTP gt ow gt e fw ont odgat nine Pg cow name BeaMRg test fnilirne Mpan l read false gt lt column type Output name Type outpute Wig skanie Output name Content Outpat abang finLine Moart 2 2 13 d metch Accounts User defined import Wizard Client Co Denmark ERP Wizard m Position Delimited Tab M Westem European Windows 1252 Wi indows 1252 z Debit and Credit in separate columns 1 Decimal symbol Digit grouping symbol Column index Settings File type Select Position if the field columns in the text file h
4. vERF BG 901 6031 R3 52 10 11 2007 _ 10 11 2007 _ BF6003532 1120 00 F NAMN ARVODE 30 11 2007 _ 30 11 2007 _ BF6OO3511 1 120 00 Z UTL BET061130 30 11 2007 30 11 2007 20061130 1 240 00 F Bet uppdraguti 20061130 22 11 2007 22 11 2007 _ KODB70 1 500 00 F Levkostn ut vp KOD870 29 11 2007 _ 2811 2007 _ 51595742 4 482 00 E Bankgiroinb _ 51595742 30 10 2007 _ 30 10 2007 _ BF6003199 12 999 52 InbetBG 24 11 2007 _ 24 11 2007 _ BF6003426 24 120 50 AVVISADE LONER 28 11 2007 27 11 2007 9100005159574 50 000 00 F Ins ttning 91000051595742 23 11 2007 23 11 2007 _ E20000029 51 726 32 INS SYSTELMVPA012 24111 2007 24 11 2007 _ L10014814 464 140 22 ARVODEN UPPDRAG L N 0633 09 11 2007 09 11 2007 L NUTTAG 1 199 100 00 Uttag LON UTTAG 4 Maintenance Ed Help Sum 0 Open transactions 27 Useful tips Add comments to the transactions in the Comment column for example to explain why a transaction hasn t been reconciled 30 d match Accounts Reconciled Search Reconcile Date BDate Reference Amount M V Text Comment Acc no 23 11 2007 23 11 2007 E40000067 1 371 171 03 V INS SYSTELMVPA014 Coming in December 1941 m ne Arran da 1 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 selecti
5. If you search for From Amount 1000 and To Amount 2000 AMA will display all amounts between these two amounts adra match Welcome Import Automatic Reports Workflow Account group Bank Account Rec x Credit Count debit Count credit 0 00 0 0 00 0 00 Sum remaining Open Reconciled of Reconcile From Amount 1000 Date v 01 01 2010 Text To Amount 2000 Todate 30 11 2011 Reference KundelD Search Clear Date BDate Reference Amount V Text Comment ACC no KundelD 04 01 2010 297194 1 075 00 EBF 04 01 2010 A60910 20100104 04 01 2010 04 01 2010 297194 1 044 07 EBF 04 01 2010 A60910 20100104 04 01 2010 04 01 2010 297194 1 346 25 EBF 04 01 2010 A60910 20100104 04 01 2010 04 01 2010 297194 1 402 50 E EBF 04 01 2010 A60910 20100104 04 01 2010 04 01 2010 297194 1 666 50 l EBF 04 01 2010 A60910 20100104 04 01 2010 04 01 2010 297194 1 582 96 EBF 04 01 2010 A60910 20100104 04 01 2010 04 01 2010 297194 1 443 75 EBF 04 01 2010 A60910 20100104 04 01 2010 04 01 2010 297194 1 206 25 EBF 04 01 2010 A60910 20100104 04 01 2010 04 01 2010 297194 1 750 00 EBF 04 01 2010 A60910 20100104 04 01 2010 04 01 2010 297194 1 400 40 EBF 04 01 2010 A60910 20100104 04 01 2010 04 01 2010 297194 1 524 30 EBF 04 01 2010 A60910 20100104 04 01 2010 04 01 2010 297194 2 000 00 E EBF 04 01 2010 A60910 20100104 04 01 2010 04 01 2010 297194 1 645 00 EBF 04 01 2010 A60910 20100104 54 Maintenance Help
6. 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 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 15 d match 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
7. 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 24 d match Accounts 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 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 it a 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 accounts The deviation can be set to r
8. Cancel Save adra match Chest Settings for automatic reconciliations Account group Reconciliation type Reconcie general Name Ref 7 Rec tng the ng for Creat and Deb J Pe susperse ac det dit pe Reconcile only when one alematve costs Many items fram Debt Date range anther group Group items Group items No of items in group No of items in group indexing indexing Index type RegEx Index type Detuk Field Ret Split on apace RegEx Calhwi2hi Split on ofer Field Ret Only numbers Length 0 Reconcile with Split or Vanance Maintenance Help 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 28 22 08 2010 23 08 2010 19 08 2010 22 08 2010 22 08 2010 19 08 2010 v iurnwiguy CMKV KA6120864 J UU AV VINGIYG Kortind 100819 10518520 249 00 25 587 00 V Kortind 100819 10518520 25 338 00 V Kontokort Danske Bank 3a0fa match Accounts 3554000000 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
9. d match Accounts 3a0fa match Accounts Contents Guid for Using Adra Match ACCOUNTS oriscciaticindsccnsencenorcductnnnasnetahesiuenionasnecsenaduseeinacnetehusauaesaneeacauincouesenace 3 PD al UON a RAGE AA EO OE 3 PR TOUTE MISS se ts cee aerate OE AO OOOO O OP R OO N 3 KOT 4 Edit accounts ANG ACCOUNCETOUDS wiadetessiccsssccsitecesdiceceiiadesideseinntaraiiidantssisatiadscedsiesadssinensteiesticeneeeaiiad 5 SEE Star UNS DAIA CE edt a A PCO A AiR W ann dan da 8 Add workflow settings for account groupS cccccccsseccccesseccceesececceeceeseesecessuseceseeneceeseuaecessenecetseees 10 AA OLO E 12 Ada IM DOL es i O O O EE O AS EO AA R 13 XEMLIMDO zeza OE AAAA OOO 13 User defined import Wizard wood a ET GRE eS 14 SOE S doi OO OOO AO GZ Ek 14 CONTAGION ea AO E AZER saris 15 ODICNALIES lt na Gao Rd AERO AEK EPA OK Ad AAA dA AA 15 PIE deco ana W W GOO A AO 15 PIESANATOKIE A add REGA AF OOO Z O E EEE 16 MIO oe OE O AO A AE E E AAA 17 Balance DOSE IMPOF e R RAE OTO a AA dp bO doda pd E OPS 18 WMO ANON RA E O AAC AOR A AO AAAA AKA 19 Automat Tre concia AGA OE EEE EEE ROA PO AEC 27 Scheduled Automatic RECONCIIATION ccccccccccccccceeeseeecccccessaeesseeececeessueeuseeeceeseesauaeseeeeeeeesaaaasesss 28 ACEDUO S wani OW O OCE 29 eS INNS ZE EN NENA 30 Reconcile transactions with deviation e eee aaa aaa aaa aaa aaa aaa aaa aaa aaa aaa aaa aaaaa aaa aaa aaaaaaaaaaeaaaaaaaa 2 Recon cSd Ta
10. 05 08 2010 198 00 Kortind 100804 10519056 22 08 2010 199 00 Kortind 100819 10519262 03 08 2010 29 03 2012 12 28 12 admin Copyright Adra Match 2011 View 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 reconciled 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 10 d match Accounts Reconciled Transactions Reconciled transactions after your chosen date The number of transactions timestamp creation date and username
11. 1 Fixed Width each column has a fixed width User can draw guidelines to separate the columns given that the import file content columns length is known and fixed ImportWizard Select a format that best describes the file You can see how the text is affacted in the preview below When it looks OK choose Next Fixed width Fields are aligned in columns with space between each field C Delimited Characters such as commas or tabs seperate each field The window below lets you set field widths column breaks Lines with arrows signify a column break To CREATE a break line click at the desired position To DELETE a break line double click on the line To MOVE a break line click and drag it 10 20 6001057740901 06 2007600144147 266 SZMUTOGIR 98029 4 6001057740901 08 2007600144147 266 3QAUTOGIR 960294 4 6001057740901 06 2007600144147 266 SAAUTOGIR 960294 IB 6001057740901 08 2007600144147 266 32MUTOGIR 980294 21 d match Accounts Option 2 Delimited Columns are separated by a specific character User needs to specify which character has been used as a column separator under the Delimiter dropdown and the application will break the file appropriately Also specify if any text wrapper is used Select the format that best describes the file You can see how the file is affected in the preview below When the file is divided into columns click Next Fixed width Fields are aligned in
12. 1 500 00 E Lev kostn utl vp KOD870 LONUTTAG 9 459 666 24 E Uttag LON UTTAG r 51703362 1 422 897 00 E 51703382 t 9100005159574 50 000 00 fF m Select E20000029 51 726 32 IN Remove selection L10013689 2 869 915 26 ia 3 nt ZA Remove filter for this column SZ SZ nad Remove all filters r 51595742 4 482 00 FE Send transactions by E mail outlook T 51595742 254 35 F B Copy transactions to Excel r BF6003426 24 120 50 r L10014814 464 140 22 F ARVODEN UPPDRAG LON 0633 E40000067 1 371 171 03 INS SYSTELMVPA014 Coming in December 6409058000 260 00 7 1120097 ACCOUNTPAY 6409058000 500 00 1120097 6610052000 634 00 1090811 Select 6610052000 700 00 _ 1090811 Remove selection 7703020000 936 00 1145548 Remove filter for this column A ZZM sh zyc z 1006 Remove all filters 6608221000 1 368 00 O 1 143606 Send transactions by E mail outlook U 7703020000 1 382 00 1145548 Copy transactions to Excel 6610052000 1 579 00 1090811 6503271000 1 649 00 1143262 ACCOUNTPAY 6409058000 1 652 00 1120097 ACCOUNTPAY 6503271000 1 668 00 E 1143262 ACCOUNTPAY 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 Te x rence Amount V x ext Y Comment Acc no ets Reconcile 58000 260 00 WI 1120097 ACCOUN ence Amount M V Tex Y Comment Acc no 5
13. 15 03 2012 23 04 15 03 2012 23 04 15 03 2012 23 04 admin 15 03 2012 23 04 15 03 2012 23 04 3a0fa match Accounts It is possible to search for reconciled transactions on Amount Comment Date Text and Reference 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 AMA 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 100 and To Amount 1000 AMA will display all amounts between these two amounts d metch Accounts Reconciled transactions with reconcile id 267479 Date BDate Reference Amount Text 01 08 2010 01 08 2010 475019 198 50 OVERF 771597 60010577408 11527 01 08 2010 01 08 2010 104518MA 198 50 1930 11527 Open Reconciled f Reconcile From Amount 100 Date To Amount 1000 To date Comment Search Clear Date BDate Reference Amount 01 08 2010 01 08 2010 600146 379 00 01 08 2010 01 08 2010 190488LB 379 00 p 01 08 2010 01 08 2010 475019 198 50 ETZ 01 08 2010 01 08 2010 104518MA 198 50 P 01 08 2010 01 08 2010 600146 210 00 02 08 2010 02 08 2010 1053
14. Account group from the workflow by selecting or deselecting the Use workflow for this account group check box You can set workflow details for different account groups and save all details at the end by clicking on Save button 11 Imports d match Accounts 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 accoun its and accouni t groups Files and folders Undo import Reports j Settings for automatic reconciliations p Settings for exceptions P gt Registration Backup Restore License settings 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 the 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 Nordea K Link Corporate Netbank Nordea K Link Corporate Netbank Utiend Nordea K Link Corporate Netbank Utland Nordea Ln el Danmak 252000 Pay PiusGrot Growsion SEB KK BGCom SEB SEBRA SEB AAMMDO SEB DOMMAA 2 JFIEJEJEJF JEJEJEJEJ 3 4 12 d
15. Match Stand Tab Match Stand Tab Match Stand Tab G Pub File name Reconciled imports Date of import 03 05 2011 15 14 admin Below you can see how the balances will change if you choose to undo the import for the selected file s Sum imported Current balance Account no 2015119123 325 114 00 325 114 00 f 1940 203 104 00 203 104 00 V Show the last 100 unreconciled or reconciled imports only File date 03 05 2011 15 14 02 05 2011 07 57 05 04 2011 15 23 05 04 2011 15 23 05 04 2011 15 23 05 04 2011 15 23 05 04 2011 15 23 05 04 2011 15 23 05 04 2011 15 23 05 04 2011 15 23 22 03 2011 10 49 16 03 2011 12 04 13 10 2010 15 28 12 10 2010 16 17 12 06 2008 15 39 12 06 2008 15 39 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 unreconcile the selected file or files select Unreconciled transactions to undo the import 22 d Accounts adra match Client Co Sweden J See 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 ofimpot Username Fie date P Sprint 05 04 20
16. Ref Only numbers ia Only numbers E Length 0 Length 0 E Reconcile with Split or Variance X Maintenance Help 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 27 d match Accounts 105306LB 366 00 366 00 843112007 Text 1020 Text 1020 art 2007 105306L6 Below you see how the rule should set up You can of curs RegEx Indexing here to The Regular Expression could look like this d 6 w 2 Close maintenance Settings for automatic reconciliations Account group Suspense Account 1020 Reconciliation type Reconcile general Name One to One Ref VY Reconcile using the same textstring for Non and Suspense Account 7 Reconcile a suspense account debit credit Reconcile a suspense account sum Reconcile only when one alternative exists Date deviation 0 Oe Many items from Credit Many items from Debit From To From To Date deviation within re re Date deviation within AL JE bundle gil p bundle ws UR Indexing Indexing Index type Index type Split on space W Split on space 7 Split on other Split on other Field Ref v Field Ref Only numbers E Only numbers F Length 0 Length 0
17. Report tab Use standard AMA data Show sort data option A Use standard AMA data Show the Per date option T Open_ltems Show the From to date option Show All available clients option 4 Select output type Select an account group M PDF w F RTF Report Viewer Show historical data option Cancel Save Back X Maintenance Help Select if you want the report to be viewable on the active client or on all clients and select Admin only if you only want the report to be restricted to administrators Close maintenance and you are ready to use your new report In use on active client In use on all clients Admin only 7 SI STS FE License settings This is where you manage your users and clients 15 d match Accounts Select Maintenance License settings Edit accounts and account groups Imports Files and folders Undo import Reports Settings for automatic reconciliations E J Settings for exceptions Registration Backup Restore Add or edit a client Click Add Client name is mandatory Address and Zip Post Code is optional Add client number if you have one The cl
18. You can choose whether you want to run scheduler on all reconciliation routines 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 ScheduleJob 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 28 d match Accounts 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 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 reco
19. account group which you want to set a workflow and then tick on Use workflow for this account group check box Now you can select the starting period from the drop down list and add owner and approvers to the account group workflow adra match Edit accounts and account groups Account group Account settings Workflow Settings Account group Credit Cards 10227 M Accounts for account group Ledger Bank 10227 Account group Credit Cards 10227 Left account type Ledger Right account type Bank Set starting balance Delete reconciled transactions with reconciliation date Delete reconciled 26 03 2012 When you click on Add Owner or Add Approver buttons a list of users will pop up so that you can select the relevant user from the list You can select more than one user for each group adra match Edit accounts and account groups Account group Account settings Workflow Settings Account group Credit Cards 10227 M 7 Use workflow for this account group Workflow Settings Starting Period for Workflow 2011 08 UserName FirstName LastName Role Admin ii Own Add Approver Delete Approver 10 d match Accounts lf you want to delete an owner or approver you just need to select that name from the selected list and click on delete buttons You also can include and exclude
20. 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 Larger 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 30 d match Accounts 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 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 2 One Many 5 days Reconcile gener
21. authentication admin com Engli 15 03 2012 22 09 admindk i 10 03 2011 10 33 adminno Kari Nordmann i i 26 05 2011 09 06 adminse i 16 05 2011 11 28 adminUK Andersson bjom comp i Admin 7 29 03 2011 11 27 Hansen anna hansen Admin 03 05 2011 12 52 Super User E 10 03 2011 12 37 Super User M 02 05 2011 21 14 Ruser i Restricted User 17 05 2011 14 32 16 09 9N11 19 NA Organization Department v Windows authentication F Username admin First name Paula Last name Johnson E mail admin companymame com Password Confirm Password BY Maintenance r4 Help Single sign on The user can be set up to be automatically logged in to AMA If you register the windows user name DOMAIN USERNAME as the username in AMA and then select Windows authentication the users will be automatically logged in next time they start AMA If you only have one administrator Admin do not set the administrator Windows authentication 18 d metch Accounts Add or change Company information Select the tab License from the License settings window Add the company address in Company information and click Save adra match License settings Gets use cense Company information inz Adra Match AS Address Schweigaardsat 28 Zipcode N 0134 City OSLO Add or change product key or update licence Select the tab License from the License settings window Click Change product key Enter
22. 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 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 17 d match Accounts Select the tab Users from the License settings window Click Add Enter a User name Password and Language Other optional fields are First name Last name and E mail Under Role you select whether the user should have the role Admin Super User User Viewer or Restricted User If you do not select Admin you need to select the Clients the user should have access to Click Save lf you uncheck In 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 adra match Client Co Sweden BEE License settings Close maintenance Cients Users License Max users 20 Users used Available users Show only users In Use Usemame First name Last name Language Role In use Last logged in Windows
23. number of items and the percentage each setting has reconciled and the total percentage for the account group 27 d match Accounts zJ BER Name Co Sweden Open transactions 569 Bank Account Open transactions 569 One One 5 days Only one o Complete transactions reconciled 336 One Many 5 days o Complete transactions reconciled 60 One Many 5 days 9 o Complete transactions reconciled 66 One Many 5 days 8 RZ Complete transactions reconciled 3 One Many 5 days 5 o Complete transactions reconciled 3 Many One o Complete transactions reconciled 0 Many Many o Complete transactions reconciled 27 One One 5 days o Complete transactions reconciled 28 Debit Credit 3 days o Complete transactions reconciled 28 v CZ M v W Vv M V Ea lt New account group Open transactions 0 e handel Inlosen FSB E E E 5 dor E E E 2 dar only one Inl sen SHB E E E 5 dgr E E E 4 dgr only one E EE D K 2 dgr text Scheduled Automatic Reconciliation You can schedule the automatic 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
24. select if the deviation is Split or Variance d match Accounts 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 Ledger 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 ZMIENNE ee Lee sda save the remainder as an open transaction 23 11 2007 _ E40000067 0 35 miei ing 1941 Value of open tranzachon Variance This option will reconcile the transactions and save the difference as an variance Variance transactions can be printed separately NS SYS Value of wanancg h 2
25. 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 Accountgroup Bank Accou Reconciliation type Reconcile general X Name One to Many 3 days 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 alternative exists Date range 0K 3 Many items from Ledger From To Date range within group 0 Group items No of items in group 0 Indexing Index type Split on space v Spliton other Field Ref 3 Only numbers E Length 0 Reconcile with Split or Variance Co Se Many items from Bank From To Date range within group ok o Group items No of items in group 0 Indexing Index type Default Split on space w Split on other Field Text z Only numbers Length 0 Automatic reconciliation with 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
26. 11 15 24 1 Are you sure you want to undo reconciliation for the following 1 file s NEO CiDemo AMA _Ledger 1790 HB tt nlalafa a a n n nlisolc ololao o iJ II SI BL S ale Maintenance Help Manual registration 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 E 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 transactions to the reconciliation 23 d metch Accounts adra match Client Co Sweden Sik Registration Close mamtenance Accountgrap Bak Account Date Reference Account no 05 05 2010 00056 334 00 48501234 aC b 105 05 20 04H39 756 663 00 1941 LJ jv Free text Balance New balance 35 043 432 61 35 049 766 61 35 101 769 61 34 345 106 61 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
27. 21ME 210 00 01 08 2010 01 08 2010 600146 630 00 02 08 2010 02 08 2010 105321ME 630 00 03 08 2010 03 08 2010 999004 500 00 02 08 2010 02 08 2010 104603ME 500 00 02 08 2010 600146 436 00 4226 00 Reconciled transactions 2 Opentransactions 54 To Amount field can only be used when From Amount field is filled To undo reconciled transactions click on the magnifying glass next to one of the transactions you want to undo Based on a reconciliation ID AMA will find the corresponding matched transaction and you can undo the reconciliation of these transactions Date You can choose whether you want to search for exact date or a space of time From Date To Date When only Date is filled in AMA will search for the exact date When both From Date and To Date is filled in the AMA will search for all dates between the two dates that were typed When searching for exact date only the name of the field is Date 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 work 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 d match Accounts Reference The reference should contain the search s
28. 26 d match Accounts Automatic reconciliation This is where you run your settings for automatic reconciliation You need to set up settings for automatic reconciliation for this to work See Settings for automatic reconciliation for more information Select Automatic Click on Automatic once more and select Show 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 Workflow Show all clients minis x Show only account groups Name Ej Bank Account v Bank Account Recon v Bank Recon Make sure that the clients you want to reconcile are selected You can also choose not to run a particular setting by removing the check in the checkbox Click Reconcile You can stop the reconciliation by clicking Stop adra Q match Welcome Import Exceptions Reports Workflow v Select All Name Status v Corporate Recon v Accounts Payable Receivable Vv Bank Account v Suspense Account v Suspense Account 1020 v Co Denmark vV Bank Account V Bank Account Rec v Co Norway v Bank Account v Bank Account Recon v Bank Recon When the reconciliation is complete the number of open and reconciled transactions is shown in the lower right corner of the screen You can also see the
29. 3 11 2007 Diff 1296 0 35 eee Ee 067 1941 Reconciled transactions Click the tab Reconciled Here you can undo reconciled transactions search for a reconciled transaction see when 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 AMA 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 Account group Bank Account Reconciled after 15 03 2012 om Amount Date BDate Reference 03 11 2007 02 11 2007 8107039 02 11 2007 02 11 2007 BF6003195 20 11 2007 17 11 2007 51703361 17 11 2007 17 11 2007 BF6003353 02 11 2007 01 11 2007 9020405 01 11 2007 01 11 2007 G40004200 20 11 2007 20 11 2007 NonRef 20 11 2007 20 11 2007 BF6003349 08 11 2007 07 11 2007 1070000090204 w 9 V Text Comment 50 00 50 00 78 00 78 00 100 00 100 00 100 00 100 00 100 00 Workflow Bankgiro inb 8107039 E 810 7039 NR70 7 Ocrinb 51703361 5170 3361 Bankgiroinb _ 9020405 E INS SYSTBG 9020405 Awg enl faktura SERVICEBOX 28 8 28 9 26 10 Insattning 107000009020405 A
30. 8 00 Then click Next to 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 Amount left to be registered is zero click Finish to save the starting balance and the open transactions d match Accounts Step 2 of 2 Register the open transactions that represent the balance difference Always register the Ledger or Bank transactions as transaction amount 1 When the difference is registered click Finish r VDate Text Line 1 Text Line 2 nama isco aor emo le Mam wiam wee sesja wam woan aoa sosoo eosa jej Mon woncort ita e fe ava jawa 007 omeniaso amam froma jamo azuwjaw ej Bank 23 094 556 00 Total Balance 23 168 934 00 72 989 00 3 trans Registered 1 389 00 2trans 23 167 545 00 Corrected Balance 23 167 545 00 Initial difference to be registered 74 378 00 Amount left to be registered 0 00 d match Accounts Add workflow settings for account groups Workflow can be purchased as an additional module to AMA When the Workflow module has been added to AMA it will appear as an extra tab called Workflow Settings under Edit Accounts and Account Groups Please contact Adra Match to learn more about how to obtain this module To start up with workflows first you have to set workflow user groups and starting period First select the
31. 8000 500 00 p 1120097 ACCOUN 58000 260 00 Vv ACCOUNT 158000 892 00 E 1120097 ACCOUN Select 58000 500 00 ACCOUNT 158000 1 652 00 1120097 ACCOUN ECKA 58000 892 00 T ACCOUNT 58000 1 652 00 E Equals to ACCOUNT Remove filter for this column Send transactions by E mail outlook Copy transactions to Excel 31 Click the checkbox in the column header of the V column to select all open or filtered transactions Unselect clear all selected transactions Ctrl 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 VP TESTAMENTE 254 35 i 899 00 of Bankgiro inb 51595742 Select AED z Remove selection 4 482 00 E B4 24 120 50 A 4 50 000 00 F i Remove filter for this column 51 726 32 IN Remove all filters 464 140 22 Al SEE 1 371 171 03 7 Copy transactions to Excel 1 422 897 00 Bankgiro in 2 869 915 26 E UTLAND LON 0611 6 149 731 26 KANSLILON 0611 9 459 666 24 Uttag LON UTTAG Right click in the grid and select Copy transactions to Excel to copy checked transactions to Excel 23 240 Ji F IEDIAMENIE 254 35 FE Select 899 00 OV Remove selection 1 500 00 Ff Le 4 482 00 E Ba
32. 9 08 2011 060153 887 60 E Visa 29 08 2011 29 08 2011 001282 896 90 F Visa 29 08 2011 29 08 2011 070351 930 80 E Visa 29 08 2011 29 08 2011 201414 989 70 E MasterCard 30 08 2011 30 08 2011 048036 1 180 00 E MasterCard 29 08 2011 29 08 2011 681466 1 244 60 MasterCard 29 08 2011 29 08 2011 069161 2 735 00 E Visa 29 08 2011 29 08 2011 000000 3 696 30 E MasterCard 24 64 Maintenance fd Help Sum 580 00 4 OQ adra maich Cle BSE Welcome Import Automatic Reports Workflow ko Account group Awaiting submission for period 2011 08 Click bar to submit Debit Credit Count debit Count credit Ledger 0 00 0 00 0 0 Bank 0 00 0 00 0 0 Sum 0 00 Sum remaining 0 00 Date V Text 29 08 2011 29 08 2011 391017 89 90 E Visa Submit Reconciliation for Credit Cards 10227 See 290020 200951 13920 lesz Select the closing period for the reconciliation Check the account balance s against the source s for the 29 08 2011 29 08 2011 065502 168 50 T MasterCard selected closing period Comments are optional 30 08 2011 30 08 2011 017258 199 80 Visa let cag Ei 2011 08 29 08 2011 _ 29 08 2011 _ 009260 206 00 E MasterCard 30 08 2011 30 08 2011 008972 226 70 E Visa 29 08 2011 29 08 2011 _ 673295 252 80 E Visa 30 08 2011 30 08 2011 078233 299 90 E Visa 30 08 2011 30 08 2011 _ 473721 335 60 EO Visa 30 08 2011 30 08 2011 050609 339 90 E MasterCard 29 08 2011 29 08 2011 487367 353 90 E MasterCard 29 08 2011 29 08 2011 074297 397 60 F MasterCard 4 Are you sure you wan
33. Bankgiro inb 51703362 24 11 2007 24 11 2007 L10013689 2 869 915 26 E UTLAND LON 0611 54 Maintenance dHelp Sum 0 When you cannot find any more transactions with equal amounts sort the transactions on date by clicking the Date or BDate column 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 Welcome Import Automatic Reports Workflow Account group Bank Account Credit Count debit Count credit 1 120 00 3 1 499 35 1 z Sum remaining Reconciled Search Date BDate Reference Amount M V Text 29 11 2007 _ 29 11 2007 _ x889900 45 00 30 11 2007 _ 30 11 2007 _ BF6003510 120 00 LK UTL BET 061130 1411112007 _ 13 11 2007 _ 1554393 245 00 Bankgiroinb 1554393 13 11 2007 13 11 2007 G20003122 245 00 INS SYSTBG 1554393 04 12 2007 30 11 2007 51595742 254 35 Bankgiroinb 51595742 30 11 2007 _ 30 11 2007 _ BF6003510 263 45 LK UTL BET 061130 08 11 2007 _ 08 11 2007 _ BF6003374 432 00 V ARVODE NAMN 30 11 2007 _ 30 11 2007 _ BF6003647 899 00
34. CC no 48501234 1941 48501234 1941 48501234 1941 48501234 1941 48501234 Reconcile id 21285 21285 21520 21520 21280 21280 21365 21365 21463 Sum of your selected transactions equals zero Press ALT A to undo reconciliation Reconcile date 15 03 2012 23 04 15 03 2012 23 04 15 03 2012 23 13 15 03 2012 23 13 15 03 2012 23 04 15 03 2012 23 04 15 03 2012 23 04 15 03 2012 23 04 15 03 2012 23 04 Count debit Count credit 1 0 0 1 0 00 Sum remaining 0 00 1711112007 16 11 2007 2080000090025 24 11 2007 23 11 2007 1240000090999 30 11 2007 29 11 2007 1570000015543 13 11 2007 10 11 2007 1554393 10 11 2007 10 11 2007 G20003059 28 11 2007 27 11 2007 1554393 27 11 2007 27 11 2007 G20003271 29 11 2007 28 1 1 2007 1260000090993 28 11 2007 28 11 2007 G20003277 64 Maintenance FKdHelp Sum 0 Search and Replace Reconciled Transactions 100 00 100 00 100 00 100 00 100 00 100 00 100 00 100 00 100 00 E Ins ttning 208000009002569 ins ttning 124000009099995 Ins ttning 157000001554393 Bankgiro inb 1554393 INS SYSTBG 1554393 F Bankgiroinb _ 1554393 E INS SYSTBG 1554393 Insattning 126000009099995 E INS SYSTBG 9099995 Reconciled transactions 543 48501234 48501234 48501234 48501234 1941 48501234 1941 48501234 1941 21471 21475 21480 21497 21497 21503 21503 21504 21504 15 03 2012 23 04 15 03 2012 23 04 15 03 2012 23 04 15 03 2012 23 04
35. Equals to 24 120 50 AN Remove filter for this column 50 000 00 E ins Remove all filters 51 726 32 INS gt z Send transactions by E mail outlook 464 140 22 AF ee 1 371 171 03 1 422 897 00 E Bankgiro inb 51703362 2 869 915 26 UTLAND L N 0611 6 149 731 26 KANSLI LON 0611 9 459 666 24 E Uttag LON UTTAG Search for Open Transactions Another way of searching for open transactions is to use the functionality in the Search tab under Exceptions gt Search adra O Import Automatic Reports Workflow Welcome Accountgroup Bank Account X Open Reconciled w Reconcile _ From Amount 245 From date 01 11 2011 x To Amount 250 Todate v 30 11 2011 X Search Clear Date BDate Reference Amount V Text Comment A This feature allows you to do extended search among the open transactions You can search foras pecific values or search within to and from values d match Accounts 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 AMA 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 Amount the label of the field will change Example
36. N SACU ONS e da O OE E aid oO tO da 3 Check in Transactions toa WGrKI W Gawoa io wode Giro kota GA 6 RODO iGo O AE ORO O A EO AO R eae mean ee anya 9 WHEW VISCO CA AE dnc EO OPC G RCE R E 10 DEBORSEANO CENIE a E c dO EO 10 MV COW NSA dA AEO AO OOO JOW 11 CUSTOM REDONS neser EEG EO ak z 13 RAJALCUSTOMNEBO zaa on dA R A RAR OO W A R O ener dO 13 Heen ESEO adwokaci ao a OEG HO OH O PAG a a 15 3a0fa match Accounts Addar edikta CIENI aso eee er enn ene en O E ee 16 PAI OF COI MIS T woo ico A Gp ang satis Spd e pod Pp APO Ewo Oc pb Goda 17 User Privileges and ROES eien RO l RA O AA 17 IREIE Aa NEEN ENE AENEA AA AA OO OOO AA OOO 18 Add or change Company information ccccessccccessecceceseccceeesececeeececceeeceeeeeeeeeseeceesuneceesageeetes 19 Add or change product key or update licence eeeaa aaa aaa aaa aaa aaa anna aaa aaa naka nazaa aa naana aa iin0A 19 Ba KUD AMA TESIEFO OO AO OO GOA AEO EGO OOOO 20 A CC AU Aaa AEO AG O EA EA EEE AAC 20 PRES OF 1G 46 0 PE A 20 SEMI SSTONOXCEDUOMS GA EA l o eee 21 Undo importa d reconciiallo u zanussi Es ada Adi EEG a 21 PVM EIS Ui cede aa A GAR AGO OEG GA OE OEI 23 Settings for automatic reco clliatlo w acc cwi iaii nai a E 24 Reconcile general Reconciliation rules asaieaiakiaan ii AGA CEA GAGA G A 24 EOMPIES acid do dn OSA AAA bo AAS ad EA add Ada 26 Automatic reconciliation with Variance or Split cccccecccccssseccceesececeesecceeeeseceeees
37. Sum 0 Open transactions 5230 To Amount field can only be used when From Amount field is filled Date You can choose whether you want to search for exact date or a space of time From Date To Date When only Date is filled in AMA will search for the exact date When both From Date and To Date are filled in AMA will search for all dates between the two dates that were typed When searching for exact date only the name of the field is Date 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 d metch Accounts 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 Reconcile transactions with deviation lt 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 adra Os Welcome Import Automatic Reports Workflow Account group Bank Account x Debit Credit Count debit Count credit 1 422 897 35 0 00 2 0 0 00 1 422 897 00 0 1
38. Sum Sum remaining painia a Date BDate Reference Amount M V Text Comment Acc no 01 12 2007 _ 30 11 2007 _ 51595742 254 35 E Bankgiroinb _ 51595742 48501234 30 11 2007 _ 30 11 2007 _ BF6003510 263 45 LK UTL BET 061130 08 11 2007 _ 08 11 2007 _ BF6003374 432 00 ARVODE NAMN 30 11 2007 30 11 2007 _ BF6003647 899 00 OVERF BG 901 6031 R3 52 10 11 2007 _ 10 11 2007 _ BF6003532 1 120 00 NAMN ARVODE 30 11 2007 _ 30 11 2007 _ BF6003511 14 120 00 F UTLBETO6113 0 30 11 2007 30 11 2007 20061130 1 240 00 Bet uppdrag utl 20061130 22 11 2007 22 11 2007 _ KOD870 1 500 00 F Lev kostn utl vp KOD870 29 11 2007 28 11 2007 51595742 4 482 00 Bankgiro inb _ 51595742 30 10 2007 30 10 2007 _ BF6003199 12 999 52 InbetBG 24 11 2007 _ 24 11 2007 _ BF6003426 24 120 50 F AWVISADE L NER 28 11 2007 _ 27 11 2007 9100005159574 50 000 00 Ins ttning 91000051595742 23 11 2007 23 11 2007 _ E20000029 51 726 32 INS SYSTELMVPA012 24 11 2007 24 11 2007 L10014814 464 140 22 E ARVODEN UPPDRAG LON 0633 09 11 2007 09 11 2007 LON UTTAG 1 199 100 00 F Uttag LON UTTAG 10 11 2007 10 11 2007 _ L10013562 1 200 652 00 F ARVODEN UPPDRAG LON 0632 23 11 2007 23 11 2007 E40000067 1 371 171 03 V INS SYSTELMVPA014 23 11 2007 23 11 2007 51703362 1 422 897 00 Bankgiroinb _ 51703362 30 11 2007 _ 30 11 2007 _ BF6003511 2 354 88147 Ff UTLBET 061130 64 Maintenance KdHelp Sum 0 Open transactions 27 You will now be prompted to
39. a name for the account group Click Save 5 d match Accounts Edit accounts and account groups Close maintenance Account group Account settings Account group New account group Accounts for account group edger Account group New account group Left accounttype Ledger Right accounttype Bank O Q 060 Available accounts Set starting balance Delete transactions Delete reconciled transactions with reconciliation date Delete reconciled New Delete Maintenance Help Select Account settings click New and enter the account number Set it to nterim to enable 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 All client accounts Account no 1922 10750550555 New Delete Maintenance Help 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
40. added to all reconciliation rules accept when you selected the option Reconcile a suspense account Sum Reconcile with Split or Variance Variance Split Insert deviation transaction on Use info from latest or oldest on deviation transaction Reconcile with a exact deviation or Reconcile with deviation in percent Allowed amount deviation Allowed amount tolerance on deviation Intervals to reconciliation Amounts Larger then Less then Ledger 7 Oldest 0 7 Intervals for allowed deviation Deviation Larger then Less then 0 Cancel Save Maintenance Help 29 d match Accounts 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
41. al 3 One Many 5 days 9 Reconcile general 5 One Many 5 days 8 Reconcile general gt One Many 5 days 5 Reconcile general 8 Many One Reconcile general zony Many Many Reconcile general en en 8 x One One 5 days Reconcile general x Debit Credit 3 days Reconcile general w Actions to perform after import This feature can be used to run actions or tasks alter import Data enrichment with regular expressions Find Expression and add new This feature can find an expression by using Regular Expressions in a text column that exists in the selected import and database and insert a new value into an existing or new column This will 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 window Enter your Regular Expression on the column Find expression If you enter a number or text in the Find expression column the function will search for it in the select In column Select In column from the dropdown Enter the text and or number you want to insert into the new or existing the insert will only happen if the imported text column In 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 th
42. an 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 date Date or BDate Select type of preview on the dropdown Select report format Then click Preview All available clients Select an account group Credit Card Credit Cards 10227 Select report format 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 d match Accounts 5 AMExport129774904860264256 pdf Adobe D S File Edit View Window Help x BEboeuwueyY hlel e amp o KB e a Tools Comment m 17 08 2010 28 08 2010 31 08 2010 26 08 2010 31 08 2010 26 08 2010 618 19 08 2010 98 00 Kortind 100818 10519064 22 08 2010 98 00 Kontokort Danske Bank 12 08 2010 118 50 Kortind 100810 10519056 05 08 2010 149 00 Kortind 100803 10519049 642 26 08 2010 174 50 Kontokort Danske Bank 656
43. ancies click on the Notification button to view detailed import messages or click on the icon in the Details column to view transaction details Notifications Balance change Balance Transactions 36 941 901 00 36 941 901 00 50 Save as a new import template Total imported 50 Print screen presents a summary of the imported transactions and a projection of how the Account balances would be updated under each section for a client Clicking on Undo button will rollback the transaction and close the wizard No changes will occur to account balances The user can click Accept button to confirm the import 24 d metch Accounts Import Wizard Step 6 Saving Import Template e This step allows you to review the import result before you Accept the import Be sure that the account balance and the number of imported transactions are consistent with the account balance and the number of transactions from the source files system If you find discrepancies click on the Notification button to view detailed import messages or click on the icon in the Details column to view transaction details Balance change Balance Transactions Details Seo ES Save as a new import template Total imported 50 The user can check the Save as a new import template check box and click Accept or Back button in order to save the import as a template for future imports Cli
44. 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 Workflow This tab will represent all workflow details related to the selected client Main table will represent the workflow details for each group and you can filter workflows from the Selected Period and Status type Initially workflow main table will select the first row and details of that workflow will be load in to Details section There are several status with related to workflows e Awaiting submission Workflow has not been submitted yet You can submit it in Exception tab e Awaiting approval When a workflow is submitted to a period e Approved If you are an approver you can approve the workflow by clicking on approved button e Reject Approver can reject the workflow e Revoke Owners can revoke the workflow e In Progress Workflow is in Awaiting approval state in a previous period e Closed for submission Time period in between start date and submit period will be displayed as closed for submission eg Workflow start period for AG1 account group is 2012 01 but workflow is submitted
45. ave 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 Bank JJ J Acc 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 10007 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 looks 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 14 d match Accounts Column index Column index Delimited file
46. cking Accept button while having Save as new import template checked will update the account balance and proceed to saving the import template function Clicking Back button while having Save as new import template checked will rollback the transaction account balances will not be updated but will proceed to saving import template function 25 d metch Accounts Import Wizard Step 7 Saving Import Template ImportWizard The Save Import window allows you to select a name for the import and you can set the import path backup path and file filter i uired to save the import Only the Import name is req This import will be saved as an import on the client Co Norway Import name Client 001 Import path C Wedger Import backup path C Ledger Backup Filter ba Import name Specify a name for the new template Import Path Point to the location where data files will be uploaded saved in When using the new template to import files application will refer this folder for data sources Import backup path Specify a folder to which the application should move the imported file once an import is completed using the new template Optional field Import filter Specify a file name filter to use when seeking for potential candidates when using the new template Optional field Once the import is saved a new record will be added under Import Templates section in the application
47. columns with space between each field Delimited Characters such as commas or tabs seperate each field Delia raper Tester ma anwo esmm aa aaa 6 aaa jaaa nn a pam masm aema oaae 30 musk buik ee mon pemo omm int Once columns are identified proceed by clicking Next button Import Wizard Step 3 Map Column screen This step allows you to map each column to a field If you map a column to a date or amount field you must select the formatting of the data in the field You only need to map the mandatory fields If you don t have data for all mandatory fields you can click Next and enter static values for the mandatory fields you lack data for You can also choose to skip the header Skip header delete first row Invert amount amount 1 Group separator Comma 22 d metch Accounts Map Column screen assists the user in mapping column names Depending on the column name more options will be available for user to describe the features Dependent fields Invert Amount Group Separator Decimal Separator Amount AmountDebit AmountCredit Multiplier Bdate Vdate Date format Extra column name Extra identifier Here the user can use Skip header check box to ignore the first row if needed Reset Mapping button can be used to clear a column mapping if needed NOTE Client No column name will be available only if Import to all available clients option
48. e 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 31 d match Accounts Files and folders T Engagement mode Select import Bank Accoount Cards Folder C Demo AMA _Cards Backup folder Filter Actions to perform after import Find expression and add new siec ea fe lose eal rosiesst ie rosie fiee freas losie fie hostess ist fele osie rei gt e2 32
49. ecesseeeceesegeeeeses 29 Set the order of automatic reconciliation rules cccccccccsssssseeeccccccceaeeseeeccccesssueesseeeeeesessaaeseess 31 ACTIONS to perior atter MPO sssini E OGAE 31 Data enrichment with regular expressions Find Expression and add new sccccccesssseeeeeeees 31 d match Accounts Guide for Using Adra Match Accounts When describing the functionalities in this users manual we will mainly use bank reconciliation as example and hence refer to the source systems ERP and bank system The application Adra Match Accounts will hereafter be referred to as AMA Preparations Export an account statement as a text file from your Financial Ledger referred to herein as ERP containing the accounts you wish 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 AMA 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 AMAccountsi
50. econcile 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 easts Date range o 0 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 want to reconcile are booked on different days you have to set a Date deviation within the bundle Many items from Ledger Many items from Bank From To From To Date range within group 0 0 Date range within group 05 04 Group items Group items No of items in group No of items in group D 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 Many 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 tems returned AMA 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 OK Date range within group 0 0 Group items J Group items No of items in group 3 No of items in group i 25 d match Accounts Indexing You can
51. eptions Registration Create backup Select path to backup folder Click Create backup Restore backup Select path to backup folder if not all ready selected Select tile to restore click Restore backup Backups 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 adra match Backup Restore Create backup Select path C Backup 2010 Create backup Restore backup Select file to restore AMABackup 2011 05 04 15 26 59 xml Delete Engagement Ee Restore backup 20 d match 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 AMA Correct this transaction in your ledger and when a file containing the adjustment is imported into AMA it will clear the open deviation amount thus returning to a reconciled position select Maintenance Settings for exceptions 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 numb
52. er of transactions shown to display per page in Exceptions and the sort order of them Click Save and Close maintenance adra match Settings for exceptions Account group Bank Account Allowed deviation 0 99 Maximum number of transactions shown 5000d Sort maximum number of transactions by Reference Save Reset 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 21 select Maintenance Undo import Imports Files and folders Reports Registration Backup Restore License settings Settings for automatic reconciliations Settings for exceptions d match Accounts Select the file or files you wish to undo If 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 7 Engagement mode Unreconciled imports Import name OdFile Match Stand Tab Match Stand Tab Vcasvf Match Stand Tab V Match Stand Tab
53. finished click Save d match Accounts Edit accounts and account groups bd Accounts for account group 8 00 00 Available accounts Delete transactions Delete reconciled transactions with reconciliation date Delete reconciled v d match Accounts Set starting balance Click Set starting balance under Account group Set the balance of the month period you want to start your reconciliation and remember to reverse the signs of the bank transactions New starting balance 1 2 Step 1 of 2 Register the starting balance for the account groups accounts If the total Ledger balance and the total Bank balance do not sum up to zero you need to click Next and register the open transactions that make the difference These transactions represent the sum between Ledger balance and the Bank balance When the Ledger balance and Bank balance sum up to zero click Finish Ledger Bank Register the Ledger opening balance for the month or period you Register the Bank opening balance for the month or period you wish to start your reconciliation from wish to start your reconciliation from Always register the Bank balance or expense account balance as balance 1 Balance AC e Balance 23 034 556 00 0457 23 68 934 00 Total Ledger balance 23 094 556 00 Total Bank balance 23 768 934 00 Sum of open transactions to be registered 674 37
54. ient 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 click Save Clients used Available Clients 300 Address2 Zipcode City London Client no Client name Info Address1 Address2 Zipcode City Maintenance Help 16 d match Accounts Add or edit users User Privileges and Roles AMA 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 o Can 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
55. iliation 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 26 d metch Accounts adra match Client Co Dermak See Settings for automatic reconciliations Order Name Type M Maintenance Help Give the reconciliation rule a clearly descriptive name Then select the date deviation In this case we want to reconcile transactions against 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 Name One to One 5 days E Reconcile using the same text string for Ledger and Bank E Reconcile a suspense account debit credit E Reconcile a suspense account sum E Reconcile only when one alternative exists Date range 5 5 Many items from Ledger Many items from Bank _ From To From To Date range within group 0 0 Date range within group 0 Group items Group items No of items in group 0 No of items in group 0 Indexing Index type Detault Index type Split on space El Split on space w Split on other Split on other Field Ref gt Field
56. 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 amount 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 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
57. into the grid below C Ledger 2992 bt Select file z Paste BZ51529 512837 82 System logistics AB Lagerhy 591307 25 Clear grid BZ51734 98 367 27 JD Lindqvist AB 100831 29 a 10 363 64 30 Musik till butik SAMI 1 30 9 471 17 30 Musik till butik SAMI2 30 158 000 00 Res Emballage amp pAEsar Lindqvist 263 33 Telia IK2526 21 230 Telia 1k2525 21 263 33 Telia IK2527 21 805 Telia IK2524 21 7 245 00 Telia IK2523 BZ51515 11 098 25 StrAElfors AB 8654365 32 BZ51478 51 715 00 PA Resurs BS AB 1011 22029 BZ51518 7 843 21 Addicom AB 822934 32 BZ51876 241 819 00 Tullverket 1035522893 26 BZ51589 10 119 00 System 889040705 28 BZ51569 111 735 00 Me and You Communications AB 221014 BZ51598 20 415 38 Loomis Sverige AB BZ51872 5276 78 Tekniska Verken 100906014059254 24 BZ51813 2 282 42 Tingstad Papper AB 199508529 BZ51866 880 08 Tingstad Papper AB 199769629 BZ51940 876 Zwork 3648 BZ51941 650 43 Zwork 3649 BZ51942 1 204 50 Zwork 3650 BZ51935 6 356 25 Zwork 3643 BZ51934 1 423 50 Zwork 3642 BZ51933 2 944 25 Zwork 3641 BZ51932 1 323 61 Zwork 3640 BZ51931 1 040 25 Zwork 3639 BZ51936 1 759 50 Zwork 3644 2011 09 10 BZ51937 21 802 93 Zwork 3645 Encoding will be prepopulated by the application Yet the user can change select a different option if the applications selection is incorrect Click Next to proceed Import Wizard Step 2 Select File Format screen Describe specify the file format Option
58. is selected prior to initiating the Import Wizard Once Column mapping is done click Next button to proceed Import Wizard Step 4 Mandatory Fields screen ImportWizard lea This step allows you to select a static value for each mandatory field you did not select a column for When you provide the static values you can click on Import to start the data load Select static account number 2331 v Select static date Wednesday February 29 2012 B F Use Import Date Select static amount 0 00 This step is optional and the screen is displayed only if any of the mandatory fields were not mapped in the previous step Screen content is dynamic Only the missed columns in 23 d match Accounts previous step will be displayed Values specified on this screen will act as static values when the Import Template is finalized NOTE Client No column name will be available only if Import to all available clients option is selected prior to initiating the Import Wizard Once all fields are mapped correctly Import button will be enabled Click Import to proceed Import Wizard Step 5 Import Results screen 5 ImportWizard o s This step allows you to review the import result before you Accept the import Be sure that the account balance and the number of imported transactions are consistent with the account balance and the number of transactions from the source files system If you find discrep
59. k Account 12 06 2008 15 39 25 Open transactions 2 Account 3015119123 1940 Account group Bank Account Rec Open transactions 5230 Open transactions 1 1 Last import 17 03 2011 15 59 37 Sum open transactions 122 010 00 Sum open transactions 325 114 00 203 104 00 Last reconciled 27 02 2012 12 55 56 Sum open transactions 45 780 468 54 Balance 325 114 00 203 104 00 Last bgged n 15 03 2012 22 09 Logged in as Admin License expires in 337 days x Maintenance kd Help 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 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 AMA 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 e Settings for exceptions Registration Backup Restore License settings Maintenance Help Click New and select
60. name_of_ bank o Create a backup folder where AMA 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 into AMA Import the file from your ERP system and bank into AMA 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 exceptions manually where not auto matched or investigate and resolve Produce and Print reports d match Accounts Login Log in with the username and password you have been assigned C Adra Match Accounts login Username Password Change Password Change Password User has the option to change the password by checking Change Password check box Doing so will expand the window as below Provide new password details in order to proceed C Adra Match Accounts login Username Old Password New Password Confirm Password Change Password d motch Accounts Welcome Page Once logged in AMA will snow a welcome page displaying the account groups of the clients the user has access to adra metch Welcome Import Automatic Exceptions Workflow Selected client Co Denmark Total open transactions 5232 Date 15 03 2012 Account group Last import Last reconciled Welcome Paula Johnson Ban
61. nciled transactions of the selected 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 Os Welcome Import Automatic Reports Workflow s Account group Nordea K Link Reconcile Alt A Search Ctrl F Reconcile when the sum is 0 Show reconciled transactions Reconciled Search Use high contrast Fit row to text f Date BDate Reference Amount Comment Acc no Reset column order 10 04 2010 10 04 2010 685147 5 01 RWE 62300559579 07 06 2010 07 06 2010 600180 3 900 00 7 011309 62300559579 13 06 2010 13 06 2010 1600520 3 565 00 Allmote seminar J T 1920 01 04 2010 01 04 2010 2600080 2 088 00 Flyreise 1920 01 04 2010 01 04 2010 2600079 1 968 00 Flyreise 1920 01 06 2010 01 06 2010 2600093 1 050 00 Korr ref utlegg bil 1920 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 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
62. o the balance you can see the transactions that have been imported 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 Adra Match New Balance This step allows you to review the import result before you Accept the import Be sure that the account balance and the number of imported transactions are consistent with the account balance and the number of transactions from the source files system If you find discrepancies click on the Notification button to view detailed import messages or click on the icon in the Details column to view transaction details Notifications 295 transactions imported Client Account group Account no Balance change Balance Transactions Details Bank Account 48501234 35 172 472 61 35 172 472 61 295 al 18 d match Accounts E sata Torao O BDate 15 11 2007 02 11 2007 17 11 2007 01 11 2007 07 11 2007 40 11 2007 16 11 2007 20 11 2007 23711 2007 2771172007 28 11 2007 29 11 2007 157000001554393 15 11 2007 8107039 28 11 2007 20061128 06 11 2007 20061106 07 11 2007 20061107 21 11 2007 20061121 02 11 2007 55000009016031 02 11 2007 197000009002569 02 11 2007 198000009002569 10 11 2007 17 11 2007 20 11 2007 27 11 2007 21 11 2007
63. on Reconciled Search Reconcile Date BDate Reference Amount M V Text Comment 23 11 2007 23 11 2007 E40000067 V INS SYSTELMVPA014 Coming in December 29 11 2007 28 11 2007 51595742 E Bankgiro inb 51595742 24 11 2007 24 11 2007 BF6003426 AVVISADE LONER 22 11 2007 22 11 2007 KOD870 E Lev kostn utl vp KOD870 23 11 2007 23 11 2007 L N UTTAG E Uttag LON UTTAG 23 11 2007 23 11 2007 51703362 E Bankgiroinb 51703362 28 11 2007 27 11 2007 9100005159574 F 01 12 2007 30 11 2007 51595742 Ins ttning 91000051595742 23 11 2007 23 11 2007 E20000029 Remove selection 24 11 2007 24 11 2007 _ L10013689 2 869 919 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 It is also possible to apply filters to several columns at the same time Reference Amount V Text Comment KOD870
64. or paste the AMA product key and click Add License information Used Max users 15 5 A product key must be added to obtain a new license or to update existing license Add the product key that you received from Adra Max Clients 10 7 Match Expiration date 2011 05 31 Product key 844BF787 62C2 498E BF5D 44E4F1A719C7 Product key 00000000 0000 0000 0000 000000000000 Change product key lt m Greka kac ne Click Check for license update Verify that the license is right and then click Confirm License update LA License update License infomation License update available click Confirm to download your new license Adra Match ASA License information Used 2037 Max Transactions 100000 4979 1 Max users 15 5 1 999999 Max Clients 10 7 2011 2 15 Expiration date 2011 05 31 False Product key 844bf787 62c2 498e bf5d 44e4f1a719c7 Change product key Check for license update If you have any problems with your license please contact Adra Match Support 19 d match 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 Edit accounts and account groups Imports Files and folders Undo import Reports Settings for automatic reconciliations e Settings for exc
65. roved date onwards Status tab will be displayed in green colour and you can click on it to resubmit the workflow Debit Credit Count debit Count credit Ledger 0 00 0 00 Bank 0 00 0 00 0 0 sum 0 00 Sum remaining 0 00 You have to select the closing period for this submission and also you can add comments regarding this submission Submit Reconciliation for Credit Cards 10227 Eaa Select the closing period for the reconciliation Check the account balance s against the source s for the selected closing period Comments are optional Select Closing Period WRENS Total Amount of Open Transactions 23 125 00 Total Number of Open Transactions 32 3 Submitting after rejecting or revoking the workflow If a workflow is rejected or revoked in previous submission you can resubmit the workflow for the latest submission period This is more or less similar to first time workflow submission Status tab will be displayed in red colour Debit Credit Count debit Count credit Ledger 0 00 0 00 Bank 0 00 0 00 0 0 sum 0 00 Sum remaining d match 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 th
66. 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 word string is only numbers and length of the word string 0 as Length will Index words 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 v Index type RegEx 7j Split on space 7 Field Text 7 Split on other RegEx Masi Field Text Only numbers Length 0 Examples Default indexing On the image below you can see four transactions three from ACCOUNTPAY and one from ACCOUNTREC The three transactions on ACCOUNTPAY have the same amount as the single transaction on ACCOUNTREC The smallest date deviation 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 26 2007 6905250000 119 00 1181959 ACCOUNTPAY TO 2007 6905250000 3 215 00 W 1181959 ACCOUNTFA Y 1 2008 8905250000 4 565 00 W 1181959 ACCOUNTFA Y 1002007 6905250000 431 00 W 1181959 ACCOUNTREC x Below you can see the reconciliation rules with Indexing Default to the left and Indexing RegEx to the right Create a One to One reconciliation It is easy to create a reconc
67. t to submit the open items and account balances Dii PEE 65 FP NostoCani for account group Credit Cards 10227 for closing period 2011 08 29 08 2011 29 08 2011 103140 E MasterCard 29 08 2011 29 08 2011 070332 E Visa 29 08 2011 _ 29 08 2011 _ 347559 FP Visa 30 08 2011 30 08 2011 000068 E Diners 29 08 2011 29 08 2011 316845 E MasterCard 30 08 2011 30 08 2011 065046 E MasterCard 29 08 2011 29 08 2011 _ 066668 E Visa 29 08 2011 29 08 2011 _ 915011 E MasterCard 29 08 2011 29 08 2011 162906 754 80 E MasterCard 29 08 2011 29 08 2011 040326 758 80 E Visa 29 08 2011 29 08 2011 _ 072026 791 10 FP Visa 29 08 2011 29 08 2011 060153 887 60 E Visa 29 08 2011 _ 29 08 2011 001282 896 90 E Visa 29 08 2011 29 08 2011 070351 930 80 E Visa 29 08 2011 29 08 2011 _ 201414 989 70 E MasterCard 30 08 2011 30 08 2011 048036 1 180 00 E MasterCard 29 08 2011 29 08 2011 681466 1 244 60 E MasterCard 29 08 2011 29 08 2011 069161 2 735 00 E Visa 29 08 2011 29 08 2011 000000 3 696 30 MasterCard 7 Bi Maintenance fdHelp Sum 580 00 Now your status bar will turn into orange colour and it will display as Awaiting approval for period 2011 08 Debit Credit Count debit Count credit a 0 00 0 00 0 0 0 00 0 00 0 0 sum 0 00 Sum remaining 0 00 d match Accounts 2 Submitting after approving the workflow You can submit workflow again if you approve it for a period But resubmission can only be done for the periods from app
68. the backup folder This is set once per selected import and client Paths for file import in engagement mode can also be set up Select Maintenance Files and folders 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 It is possible 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 information adra Os GG Files and folders Close maintenance E Engagement mode Select import Bank Denmark Folder C Bank Backup folder C Bank Backup Filter Bank_Denmark_3015119123 bt Actions to perform after import Ci Find expression and add new Rea 16 d match Accounts Import This is where you import the files from your Bank ERP system 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 It is possible to import to two or more clients simultaneously provided that the accounts you are importing to are set to unique under Maintenance Accounts and account groups If they aren t unique the
69. the transactions The reconciled transactions are now moved to the tab Reconciled 29 d metch Accounts Welcome Import Automatic Reports Workflow Sum of your selected transactions equals zero Press ALT A to reconcile Account group Bank Account Credit Count debit Count credit 0 00 1 0 78 00 0 1 0 00 Sum remaining 0 00 Reconciled Search Date BDate Reference Amount Z V Text 20 11 2007 17 11 2007 51703361 78 00 Ocr inb 51703361 17 11 2007 17 11 2007 BF6003353 78 00 9 5170 3361 01 12 2007 30 11 2007 51595742 254 35 E Bankgiro inb 51595742 08 11 2007 08 11 2007 BF6003374 432 00 ARVODE NAMN 30 11 2007 30 11 2007 BF6003647 899 00 E OVERF BG 901 6031 R3 52 10 11 2007 10 11 2007 BF6003532 1 120 00 NAMN ARVODE 22 11 2007 22 11 2007 KOD870 1 500 00 E Lev kostn utl vp KOD870 28 11 2007 _ 28 11 2007 _ 51595742 4 482 00 E Bankgiroinb 51595742 30 10 2007 30 10 2007 BF6003199 12 999 52 E InbetBG 24 11 2007 24 11 2007 BF6003426 24 120 50 AVVISADE LONER 28 11 2007 27 11 2007 9100005159574 50 000 00 7 ins ttning 91000051595742 23 11 2007 23 11 2007 E20000029 51 726 32 INS SYSTELMVPA012 24 11 2007 24 11 2007 110014814 464 140 22 ARVODEN UPPDRAG LON 0633 09 11 2007 09 11 2007 LON UTTAG 1 199 100 00 E Uttag LON UTTAG 10 11 2007 10 11 2007 L10013562 1 200 652 00 ARVODEN UPPDRAG L N 0632 23 11 2007 23 11 2007 E40000067 1 371 171 03 INS SYSTELMVPA014 23 11 2007 23 11 2007 51703362 1 422 897 00
70. to 2012 05 Therefore statuses for AG1 account group in 2012 01 2012 02 2012 03 and 2012 04 will be displayed as Closed for submission 11 d match Accounts Transactions related to AG1 relation related to AG1 relation e nts related to AG1 relation You can approve reject and revoke workflows related an account group by clicking on the buttons in each row Approve Reject Revoke 13k Details will not be displayed if the workflow status is In Progress Awaiting Submission or Closed for Submission Details Section This section contains Balance Transaction details and Events of the selected workflow Balance This represents the balances of left side and the right side of the selected account group 12 d match Accounts Transactions All transaction details related to selected account group will be displayed in this table Events This section represents all the events occurred to the selected workflow Date Time event and person who is responsible will be displayed More Details You view more details related to the workflow transactions by clicking on More Details button right side bottom corner Events 19 03 2012 13 12 07 Approved by admin 19 03 2012 10 20 29 Submitted by admin
71. tring 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 Check in Transactions to a Workflow Transactions in exception tab can be checked in to a workflow in several scenarios 1 First time submission You can check in to any month within the starting period to next 12 months You can click on gray color bar on top right hand side of the exception tab 39 1 s599 68 5 39 8 206 0 2267 2328 39 MasterCard 10227 MasterCard 0227 MasterCard MasterCard Select month for closing period and you can add a comment for the submission When you click on the submit button it will pop up a confirmation window to submit workflow for the selected closing date d match Accounts adra match Client EET Welcome Import Automatic Reports Workflo
72. w Account group Awaiting submission for period 2011 08 Click bar to submit Debit Credit Count debit Count credit Ledger 0 00 0 00 0 0 Bank 0 00 0 00 o 0 Sum 0 00 Sum remaining 0 00 WA Reconcile Date BDate Reference Amount V Text 29 08 2011 29 08 2011 391017 Visa A ZEE LARA m Select the closing period for the reconciliation Check the account balance s against the source s for the 29 08 2011 29 08 2011 _ 065502 E MasterCard selected closing period Comments are optional 30 08 2011 30 08 2011 017258 Visa 29 08 2011 29 08 2011 009260 MasterCard 30 08 2011 30 08 2011 008972 FP Visa 29 08 2011 _ 29 08 2011 _ 673295 E Visa 10 30 08 2011 30 08 2011 078233 E Visa 250 471 10 30 08 2011 30 08 2011 473721 E Visa 30 08 2011 30 08 2011 050609 E MasterCard 29 08 2011 29 08 2011 _ 487367 7 MasterCard 29 08 2011 29 08 2011 074297 MasterCard 29 08 2011 29 08 2011 835963 E MasterCard TR Aroun of Open Transadiois 29 08 2011 29 08 2011 103140 E MasterCard 29 08 2011 29 08 2011 070332 E visa Total Number of Open Transactions 29 08 2011 29 08 2011 347559 E Visa 30 08 2011 30 08 2011 000068 E Diners 29 08 2011 29 08 2011 316845 615 60 E MasterCard 30 08 2011 30 08 2011 065046 658 20 E MasterCard 29 08 2011 29 08 2011 066668 659 90 E Visa 29 08 2011 29 08 2011 915011 734 80 E MasterCard 29 08 2011 29 08 2011 162906 754 80 MasterCard 29 08 2011 29 08 2011 040326 758 80 E Visa 29 08 2011 29 08 2011 072026 791 10 E Visa 29 08 2011 2
73. y need to have a client number set under Maintenance License settings that also has to be present 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 system on the same booking period and import it to AMA and only import the new transactions in the data file to AMA 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 17 d metch Accounts adra O Welcome Automatic Exceptions Workflow Select import Bank Sweden Select files to import C AMA_Demo_Data _Bank Bank_Sweden_48501234 txt 27 05 2008 18 13 24 ingen 46 xX Maintenance Help 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 t

User manual Adra Match Accounts 13

Contents

Download Pdf Manuals

Related Search

Related Contents