I’ve followed this guide Use receipt rules to categorize imported transactions | Manager and read other posts about this topic but can’t make it work.
I’ve got bank statements imported.
Bank and Cash Accounts → Uncategorized Receipts
New Receipt Rule
Create new rule
Check all transactions and click Batch update
Nothing happens except no transactions are checked now.
I am running version 22.12.29.575
Bank rules stop working
6 month ago, I set up the Bank rules for receipts and payment and it was working well after importing bank transaction
Today I import bank transaction, the import are fine but the bank rules does not work and all the transactions are classified as suspense , so I have individually edit and update each transaction.
why does the Bank rules stop working?
Without seeing your bank rules and imported bank records no one else can answer that question other than you.
Start by
looking at one of your transactions you believe should be processed by an existing bank rule
Find the bank rule which is suppose to process that transaction
Compare the above two and see if you can identify why it was not processed
If you can identify the cause (eg your bank or supplier has changed their format), update the bank rule as required. If you can’t identify the cause post a screen shot of the bank rule and pertinent part of the bank record here.
How often did you import bank statements with the rules you set that where successful? A common fault is to be too precise in the rules which for example can be caused by not editing the description and if unique the rule would never be applied again.
A simple example. Assume the description is something like “purchase of 10 apples” and you make a rule to assign this receipt to Sales then next time a statement say purchase of 4 apples" it will require a new bank rule. To make this work the bank rule needs to change to “purchase of apples” it will not have a problem with the 10 and 4 in the example as it will apply the rule irrespective of whatever came in between.
Same problem. I have been working with AI trying for 7 hours and can’t get Manager.io Desktop Version 26.2.20 to follow a single rule. The records import and all the accounts are coded to Suspense in the Equity section. Both Gemini and the Manager.io AI ran out of things to try. I tried Other and left the optional field blank and I made a generic Supplier called Repair and Set it to Repair and maintenance then selected Supplier and Repair but the account still got coded to Suspense.
My rules are simple “contains” ARCO or CIRCLE K. Only one parameter and a simple find like HRWDE that you can’t get wrong. It is not the Rule because I have imported hundreds and not one is found and changed from Suspense. I don’t think they can all be wrong. I have about 50 Rules and can’t believe none of the are correct. It is seeing the account. It is a Credit Card created under Cash Accounts, visible there and available for internal transfers. I believe it is set up correctly.
I created a test company with one account and it did the same thing. One account, one import, one rule and it imported but coded the COA to Suspense instead of Repair.
In Manger the rules are NOT applied during data import. Import only imports the banking data into Manager. Because these transactions are not complete / valid they all go into suspense.
The additional data for each transaction can be manually entered (which is the most efficient for one off transactions), or you can define and use bank rules.
Bank rules are specific for receipt or payments.
None of the bank rules are working. The import goes fine but the rules are all ignored. I tried using OTHER with no optional description and Employee Benefits as the Account selection and that didn’t work. So I created a Supplier named Employee Benefits and entered Supplier Employee Benefits as the Payee. Neither worked. Everything always codes to Suspense. There is no match. The rules are simple. Here is a sample for a Description that contains the word RADIOLOGY to be coded to Employee Benefits:
I used csv and qbo formats neither worked. Here is a csv file for a test import. I eliminated all of the bank exported fields down to Date Description Debit and Credit. That didn’t work so I added Account with a value to try to force the Account field to populate but that didn’t work either.
There are rules for each supplier and none import to the SUPPLIER or to OTHER (I have tried both). Not one is recognized. They all import but have to be edited one at a time to change the Account from Suspense (in the Equity section of Balance sheet) to the correct expense account.
If the “Contains” statement is actually an exact match (equals statement) they would not match because the Payee allocations are only for a portion of the field. But “contains” should not require an exact match of the entire description so long as the exact description is exactly contained in the field. Also you can disregard the Account Field in the csv file. I just tried to force the entry with a test import but that field is ignored on the import and didn’t affect anything one way or the other. It was not in the first 20 or so attempts I made. I noticed on this one Employee is spelled wrong but the Account Field is not evaluated anyway. This was a bad example. There were 59 items imported and None were coded to any account other than Suspense.
When I build the Rules all of the appropriate values are picked from a drop down so I know they are in the system correctly.
I am assuming you are creating rules from the Settings menu. What behaviour do you see if you use the New Receipt Rule button from the Uncategorized Payments page?
As is so often the case it is very hard to communicate for help. Too many things have been relocated or renamed. I mentioned before I have never seen an Uncategorized Page. I doubt the latest build has that concept but I would be happy to look around for it as long as it is for Version 12.25.21. Instead of an Uncategorized page every imported item gets categorized to Suspense. See all my screenshots above.
They aren’t uncategorized, they are categorized wrong. 
My exact problem too.
Probably not as they were looking in the correct screen. It’s much more likely you have the same problem as Rules not working - #2 by Patch rather than the thread you have posted in.
The answer to which is
Hence the request to show Uncategorized Payments & Receipts screen
Yes that probably reflects the Manager Guides are now optimised for AI not human consumption. As a result they describe what commands do but not how to use several feature to do common tasks.
To address your problem.
Bank receipt rules are applied (and most easily created) in the receipt tab.
Bank payment rules are applied (and most easily created) in the payment tab.
Setting → Bank Rules → Payment / Receipt rules is generally less useful unless you want to modify old rules or debug rule interactions.
For example after you have imported bank transactions containing some payment, at the top of the payment tab screen you will see the link to the uncategorised payment screen
When you know what you are looking for these guide pages may help
AaaaHAAAA. I finally get it. I didn’t understand what you meant. The rules are followed but placed under the payments tab for editing before updating the account choices. They show up as uncategorized into a batch waiting for me to make any changes, add new rules or approve them. Then I do a batch update.
The missing key for me was looking under the Payments tab. I am used to QB where they go in without the batch step. I like the batch system better now that I know how to use it.
It was late for this import since I manually went in and fixed them all already but I’ve got it now. Pretty funny that Google Gemini never figured that out and had me keep redoing all the rules.
Thank you so much for your help. - Skip
