Advanced bank reconciliation in AX 2012 is a new feature to help automate and accelerate the bank reconciliation. It helps users to match transactions with the bank statement which is automatically imported in AX. Rules can be created based on user defined parameters to mass match transactions and reduce the amount of manual work and errors.
However, before using this great new feature, you might need to consider few details and test it:
1. No going back - The first obvious and most important detail to consider is that once the advanced bank reconciliation feature is turned on, then you CANNOT turn it off!!
Make sure you test it first for few months before being sure to use it in Production, there is no going back.
I strongly advise to test full months and not just few days of the month to ensure the ending balance is correct and match your bank statement.
An option is to pick a bank account with limited activity and let the user manually create the bank statement in AX so you can still use the matching rules to practice. This limit the number of examples and potential issues you might have though.
2. Bank Integration - The standard format to exchange bank statements between AX and the bank is called BAI2. BAI file format is a file format for performing electronic cash management balance reporting and exchange data. Each bank will have its own version of this format and you will need to customize AX to ensure you can read and import the statement in AX. AIF services are provided in standard AX and can be modified to match your bank requirements.
Also, if you have several companies in AX that are using advanced bank reconciliation function, you will need to most likely split your BAI2 file to import in each company. Certain bank are sending one file with all the bank accounts that are turned on and AX doesn't make the distinction between bank accounts so it will import the entire file in one entity. By splitting the file you will be able to import each statement in the correct entity.
Finally, consider to create an automatic import of the statements in AX as certain bank will send daily statements. This will prevent your users to have to import 30 files a months especially if the file needs to be re-formatted before the import.
3. Auto Matching - When it's time to create the matching rules keep in mind to create rules with at least a few defined matching attributes. Try to refrain from creating rules that are matching only on the amount for example.
Make sure to create different rules for different type of transactions: receipts, outgoing checks, outgoing wires, GL entries... Each scenario can be treated with different attributes.
Also, the order of the execution of the rules is important as you want to match the most specific transactions first and then for the few remaining you can be more confident that matching on the date and amount for example will not clear the wrong transactions.
Rules are not set in stone and can be updated and improved as you learn about the process.
4. Reporting - The standard bank statement report provided in the advanced bank reconciliation doesn't have the list of outstanding transactions for the reconciled period. It is most likely that you will be asked to add this to the report as this will be used to match your bank balance with your GL balance.
The report do show cleared transactions and doesn't have an option to not show them which for accounts that have a lot of activity can end up being too much. Be prepared to be asked to have an option to hide those on the report as it's not necessary useful to have this :)
5. User adoption varies! The excitement at first, being able to use matching rules, having the bank statement imported in AX, this is all very exciting for a user. But once they start to use it, obviously they have to learn and learning curve can take some time. Make sure they understand that the rules can be modified and improved. Emphasize the communication with your users to understand what takes time for them, what are the type of transactions that are hard to match.
I hope this will help you and let me know if you want more information, I would be more than happy to share details :)
I do not understand the "No Going Back" issue. Once this is turned on, it can't be turned off? So, if a company ever changes to a bank without electronic files, they can no longer use AX to do bank rec? Or is it account by account "no going back"?
ReplyDeleteIf the latter, what if the file is corrupted and you just want to manually do it this month, instead of wading through IT queues? This is not an option?
Finally, I haven't found anywhere in the MS documentation where this is mentioned, which is not necessarily a surprise, but what did they say about this? Are they resolving it in a future release, or do they recommend this process? And if so, did they release a white paper or blogpost about it?
Thanks!
chris
Hi, it's an account by account limitation. you will be able to create new bank accounts and use the standard functionnality.
DeleteAlso, you can import the 'corrupted file' and either bring changes to those lines, or you can create manually the file, line by line. Which is not recommanded. But once the file is imported, it's very felxible to improve it, bring changes to it. Youc can delete it and reimport a new corrected one. But all this before clicking the Validation button.
What has your government done to help save you from your financial instability? you strive to survive and yet you hear stories of how your leaders have become terror in your entities... is time to make a different. for will have made money, and we have also come to help you out from your long time of financial suffering. clearing of credit card is made available, software for hacking ATM machines, bank to bank hacking and transfer, change your school grade and become something useful in the society. we also have other form of services such as Facebook hack, whats-app hack, twitter hack, i cloud hack, tracking of smart phones, hacking CCTV, installation of software on desktop and PC, snap-chat hack, Skype hack, wire wire, bitcoin account hack, erase your criminal record and be free for ever. database hack and many more. e-mail: cyberhackingcompany@gmail.com for your genuine hacking services and we shock we your findings.
DeleteiI’m lauriel from New York, United States. I lost my job a few months back after my divorce with my wife. I tried everything positive to make sure I took good care of my kids but all failed, and I was in debt which makes everything worse. I was kicked out of my home and i had to live with my neighbor after pleading with her to allow me to stay with her for some days while I figured out how to get a home which she agreed to, but no one was willing to help anymore. I bumped into this page from google and I was excited about this, then I contacted the hackersBill Dean. I had just $200, so I pleaded with them to help me because of my condition but they never accepted. I believed in this, so I managed to pawn a few things and got $500. I ordered the $10,000 card and I got my card delivered to me by Ups 4 days later. I never believed my eyes! I was excited and upset as well, I managed to withdraw $2000 on the ATM and $2500 the second day. I went to Walmart and a grocery store and bought a couple of things for $3000. The card got blocked the third day and I contacted them and I was told it's a mistake from my end. I’m so happy, I have started all over again and have a good apartment with my kids you can contact him through is via email (globalatmcardhackingservice@gmail.com)or his whatsap contact (+1 301-887-5071)
DeleteHi Chris,
ReplyDeleteThe setup is bank account specific so most likely you won't need to turn it off. If you change bank then you will have to setup a new bank account in AX.
If the file is corrupted, you can manually create the bank statement in AX, very manual but possible. So you won't get stuck.
The white paper might not give that detail but you will see a message in AX when you turn that feature on on one account that you cannot turning it off.
I hope that helps!
Caroline.