Here’s a list of recent improvements in QuickBooks Online bank feeds U.S.
- Create rules3 that automatically accept bank feed transactions into QuickBooks. This can be a huge time saver! — especially for entering simple transactions you make on a regular basis, like “Shell gas expenses under $100.” Transactions > Banking > ▼ to the right of Update > Manage rules > New rule > Automatically add to my books.
How it works:
- After creating the auto-add rule, any affected transactions in the “For Review” section are automatically added.
- Auto-add rules run when:
– You sign in
– You run a manual update
– A file upload is done
– You create/change an auto-add rule
The auto-add rule appears on the Rules page with a special icon.
You can find auto-added transactions at Transactions > Banking > In QuickBooks, and can undo the auto-add if you need to.
To see only auto-added transactions, go to Transactions > Banking > In QuickBooks > > Rule > Auto-add rule.
- Improvements to the Connect to American Express OPEN app. 1) Users of the ReceiptMatch mobile app can now attach receipts up to 7 days after the transaction is posted on the Amex side. Previously, receipts only flowed through to QuickBooks if the receipt was attached while the transaction was pending on the Amex side. 2) Receipts now appear as a separate attachment from the summary on the Banking page. This lets you quickly scan the list and see if a receipt is attached.
- Edit the check number field in bank feeds. Left nav > Transactions > Banking > table gear > Check no. Then when you click a transaction, you can change the check number.
- Mark a bank transaction as a billable expense and assign it to a customer1. Many of you asked for this and we heard you! Left nav > Transactions > Banking. Click a transaction to add, and then mark it Billable and select a customer.
- Add an attachment2 to a bank transaction. Another improvement based on your feedback — you can now add an attachment (like a receipt or photo) when you add a bank transaction. Left nav > Transactions > Banking. Click a transaction to add, and then click Add Attachment.
- Connect foreign bank accounts. You can now connect foreign bank accounts to QuickBooks Online. Note that you must turn on multicurrency4 if the foreign account is in a different currency. From the home page, click Connect account in the upper right corner and turn on Search global banks.
- Re-order bank accounts on the home page and Banking page. This is especially helpful when you have a lot of accounts connected. Order them by most used first, or alphabetically, or whatever works best for your business! On the home page, 1) click the pencil to the right of Bank accounts, 2) drag accounts up or down in the order you want, and then 3) click Save. Any changes you make affect both the home page and Banking page.
- Replace the Description column with the Bank Detail column. QuickBooks cleans up bank transaction details with a simpler Description column, but if you like, you can change to the full description from the bank. Transactions > Banking > table gear > Show bank details.
- “Copy bank detail to memo” turned on by default. This is useful when viewing bank transactions in reports or the register. If you don’t like it, though, you can turn it off. Transactions > Banking > table gear > Copy bank detail to memo.
- Permanently delete excluded bank transactions. Transactions > Banking > Excluded > Batch actions > Delete. Based on your feedback, you can now delete excluded transactions!
February 26 2015
- Specify a bank feed rule transaction type. We added this based on your feedback, especially for transfers: if you have a regular transfer between two accounts, create a rule to save time. Transactions > Banking > ▼ to the right of Update > Manage rules > New rule.
- Reorder bank feed rules3. Because rules are applied in numerical order, and you can apply only one rule per transaction, reordering lets you easily control which rules to apply. Drag in the leftmost column to reorder. Transactions > Banking > ▼ to the right of Update > Manage rules.
Here’s an example:
- Rule 1: Categorize all transactions under $10 as Miscellaneous Expenses.
- Rule 2: Categorize all Starbucks transactions as Meals & Entertainment.
In the case of a $5 Starbucks transaction, only Rule 1 is applied.
February 3 2015
- Tab from field to field in the bank feed expanded row. Press Up/Down arrow to select within a field or among radio buttons. Transactions > Banking > click a row to expand it.
- We help you fix bank feed error 324. This error occurs when QuickBooks is unable to download your bank transactions due to changes to your bank account number, name, or nickname. Transactions > Banking > Fix It.
December 22 2014
- Payee column on bank feeds page. Based on your feedback, a payee column is now available4! Once you enter a payee, QuickBooks remembers it for future transactions. Transactions > Banking.
December 4 2014
- Export bank rules and then import them to other QuickBooks companies. This is convenient if you manage multiple companies, like accountants do! Choose which rules to import, and then set up payees and categories in the destination company to support the new rules. Transactions > Banking > ▼ to the right of Update > Manage rules > ▼ to the right of New rule > Import/Export rules.
- Match transactions filtering. When you click a transaction and select Find match, the Match transactions window lets you filter transactions by type. Transactions > Banking > click a transaction > Find match > Show.
- Partially match bank transactions to open invoices and bills. For example, a $237 deposit can fully or partially match multiple open invoices. Transactions > Banking > click a transaction > Find match.
- Order checks link. You can order new checks by selecting Transactions > Banking > ▼ to the right of Update > Order checks.
- Recognized bank transactions. Go to Transactions > Banking > Recognized to view items (shown in green) that are already matched, have a rule applied, or use categories from related transactions you previously accepted. To accept these transactions into QuickBooks, click the checkbox to the left of the Date column header and choose Batch actions > Accept Selected.
- Bank rule “or.” Apply a bank rule when a transaction meets condition 1 or condition 2 or condition 3, etc. Example #1: If the description is Amazon or AMZN, set the payee to Amazon and category to Office Expenses. Example #2: If the description is Burger King or McDonalds or Taco Bell, set the payee to Fast Food Vendor and category to Meals and Entertainment. Transactions > Banking > ▼ to the right of Update > Manage rules > New rule > any.
- Turn off automatic categorization. When you change a bank transaction’s category, it’s automatically used for future transactions with the same vendor name. You can now turn off that autocategorization. For example, let’s say you categorize a transaction from Mahoney Mugs as Promotional, but you want future transactions from that store to come in uncategorized. If you turn off automatic categorization, future Mahoney’s Mugs transactions won’t appear in the Recognized list, and will come in uncategorized so you can put them in the right account yourself. Transactions > Banking > click a transaction to change its category > Edit this setting > Leave uncategorized.
- Import bank .csv files. You can download a .csv file of your transactions from your bank’s website. This is especially helpful if QuickBooks isn’t able to directly connect to your bank. Here’s a sample .csv file for reference. Transactions > Banking > ▼ to the right of Update > File upload.
September 26 2014
- Bank rules. Process bank feed transactions faster and with more control using bank rules. Create rules to scan bank items for certain details, and then assign specific payees and categories to them. Applied rules appear on the Bank Transactions page here and here. To get started, go to Transactions > Banking > Update > Manage rules (upper right corner).
August 25 2014
- Copy bank description to memo. Automatically copy the bank’s transaction description to the Memo field, making it visible on more reports, like General Ledger. Transactions > Banking > Table Gear > Copy Description. You don’t have to copy it yourself each time.
- Change payee name on batch bank transactions. Change the payee name on multiple bank transactions at once. Transactions > Banking > Batch actions > Modify Selected.
- Billable expense tracking is available in QuickBooks Online Plus only and requires the following settings turned on: Gear > Company Settings > Expenses > Track expenses and items by customer and Make expenses and items billable. Note that on the Banking page, only one billable customer can be assigned to a transaction; you can go back to the transaction after you add it to split it and add multiple billable customers.
- Only one attachment can be uploaded from your computer. This feature currently supports attachments when you add a transaction, not when you match a transaction. Here are some tips on using attachments.
- Here are the basics of bank rules.
- To turn it off, click the gear above the table.
- To try updates using sample data, check out the QuickBooks Online test drive.
- Missed any recent QuickBooks Online updates? See our release notes archive.
Report an issue or suggestion
Leave feedback by clicking the Gear icon in QuickBooks, and then click Feedback. This is the official way to get your ideas recorded and worked on! Learn more
Get technical support
While we would love to answer all your questions, the blog isn’t managed by customer care staff (only a lone blogger waiting for spring to start). Your fastest options to get technical support are listed on our Links page, under “Get help and give feedback.”