Please could we be able to apply rules to Imported Statements in one of 2 ways
Either - let us import statements into the Bank Feeds window so that the Rules functionality will apply
Or - add...
I suggest adding a function on BankFeeds page so we are able to upload old bank statements in .qif format so we can create and run rules on old bank statements as well not only on the new bank feeds.
I know that we can import a .qif statements in bank reconciliation screen but there you cannot create rules and run there.
This function is in Essential and I hope that we can have it in AccountRight. I work for a public practice and I work on different clients during the week, some client have backlog of data entry for months and years. This way would make it much easier and faster to work on backlogs.
- Status removed:New
Hi Jmourtada
Thank you for your idea in regards to AccountRight and importing bank files.
You can import bank transactions using the Banking>>Bank Register>>Get Statement option. This is similar to bank feeds,as it allows you to match transactions already in the file and also create new transactions of those bank transactions.
For more information into Get Statement please the Help Article: Reconciling your bank accounts - section To Reconcile by importing a bank statement or the Support Note: Importing bank statements using the "Get Statement function. Could we please clarify that this feature isn't already in the product. The current "Get Statement function" doesn't use the bankfeed screen and more importantly doesn't use 'rules.'
The original poster wants to be able to import
Jmourtada wrote:... statements in .qif format so we can create and run rules on old bank statements as well not only on the new bank feeds.
I.e. To use the bank rules feature on imported statements.
This feature is available in MYOB BankLink, MYOB Essentials and Xero and is helpful when you only activate a bankfeed at a certain point in time and you need to quickly catch up on all the dates prior to the bankfeed activation date.
I hope by clarifying that the status of this idea can be reverted from 'Already in Product' to 'Under Consideration.' I believe this feature will be particularly appreciated by users just starting out in ARL and just beginning to activate bankfeeds.
- Status added:Open
Thank you for your feedback in regards to this idea and the status of it.
Upon reviewing this Idea I have updated the status to be Under Consideration. The idea's premise is the allowing of Get Statement to have rules to allowing the data to be easily matched.
Currently the following criteria must be met for a valid auto-match between a transaction in the company file and a transaction from the statement file:- Cheque: Cheque number and Amount must be the same.
- Deposit: Amount and Date must be the same.
- Other transaction types: Amount and Date must be the same
I would encourage other users that would like to see the option for creating rules within Get Statement to vote and comment if required for this idea.
Thanks for changing the status from already in product to under consideration.
To work on backlogs efficiently it is very useful if we can upload old bank statements in .qif format into BankFeeds page not into Bank reconciliation page (Get Statement) so we are able to run the rules setup in BankFeeds on the old banking data before applying for bankfeeds date. Basically posting the transaction off the .qif bank data file.
Yes - please this needs to happen - I have voted.
I dont understand why you cant simply import a csv/qif into the bank feeds screen i.e. for historical data before the bank feed started. MYOB is not making it easy to change over and get started.
I agree it would be wonderful if you could upload hsitorical data and would save plenlty of time.
What is the best process for uploading current bank statements? for AccountEdgev13. Do you sent up rules and then upload in bank register or reconcile accounts?
Hi bbb
Thanks for showing your support for this idea.
AccountEdge v13 has got an update Bank Statement feature. This allows for the setup of rules to allow for easier matching if required. For more information into the Bank Statement feature of AccountEdge please see AccountEdge Help Article: Importing statements
