Last updated 01/27/2022

New Features added from my wishlist in latest version (2022)… Thank you Intuit!

• Bank Feeds: Improve the overall look and feel and make it more stable when sorting and filtering by dates
• Bank Feeds: Ability to search within rules or filter by payee/account
• Bank Feeds: Shift-click and batch modify multiple transactions in one click
• Bank Feeds: add/modify the memo on the main grid
• Show preview of attached docs before your send a transaction with additional attachment
• Enable/Disable Lot Numbers on specific items, so QB does not require or prompt for one – AND require users to enter lot/or serial as a preference (Added in 2020 R8)
• Batch Delete Sales Orders
• Landed cost: functionality that allows for external costs to be added to the item’s posted valuation cost, Adjusted from COGS Account – Added in 2020 R5
• User Permissions: ability to limit which customers and/or vendors a specific user can and cannot access (Added in Enterprise Platinum 2020)
• Inventory Aging Report
• Allow for a ZERO-out all active inventory items in batch option (also allow to do it for all inactive items as well).
• Alternatively, an option that zeroes out all NEGATIVE items only
• Ability for QuickBooks user to create Invoices (and Packing Lists) in batch for all picked/packed item

Report Improvements:

• Ability to choose to show accounts, Customer:jobs, items, or classes as flat vs hierarchy (current mode) in custom summary reports
• Collapsible Columns for Classes, Customer:jobs, Items, Accounts. Plus, ability to EXCLUDE total column when there are sub accounts.  This concept can be called “Horizontal Collapse” which as already started a little bit in the 2020 version of QB, but I want it developed some more…
• Summary Reports where all tables with subs (Classes, Customer:Jobs, Customer/Vendor Type, Item, and Accounts) show as separate (tabular) format, as well as FLAT view like in the Trial Balance or Customer List Report
• In any Detail report, the Account should have an option to show the entire Account:Subaccount name instead of just the sub-account
• Secondary Total By dimension in detail reports. One Total By Dimension is not enough
• At least one more pivot dimension on Columns and Rows in summary reports (dimensions needed: Transaction Type, Transaction Number, Debit/Credit, Account Type, Account Type Summary (Asset, Liability, Equity, Income, Expense, COGS, Other Income, other Expense), and Account Report (Balance Sheet or Profit and Loss)
• A Customer (without jobs) And just a JOB dimension (without customer name) for Total by
• Account Type should be a dimension for Total By in detail reports and a row/column choice for Customer Transaction Summary reports as well
• Ability to exclude subtotals of Classes, Customer:jobs, Accounts, Items:Subitems in summary reports
• Ability to include/exclude account numbers on the-fly when printing or exporting (without having to log in as single user / admin to change back and forth)
• Ability to include/exclude account account/item descriptions on the-fly when printing or exporting (without having to log in as single user / admin to change back and forth)
• Column fields to include in a list reports: Create Date, First Used Dated, Last Used in Any Transactions, Last Used Date Posting Transaction, transaction count in last 2 years
• Linked Transaction Number field: this field will contain the Ref Num of all linked transactions. for example: a customer payment will contain a list of all the Invoices it had paid or a bill payment will contain a list of all the bills it paid. Possible both a source link and a destination/split link
• Add a “has attachment” field to transactions; and or number of attachments.. As was a filter for it, so we could create a report of all transactions lacking attachments
• Modify the Avg. Sales time period or metric on Inventory Stock Status reports
• Created Date and Created By should be an available field for any detail report. Also to filter by Create Date
• Easily increase and decrease font size on reports by using CTRL- and CTRL+
• Add service date as a visible field in custom detail reports. Also ability to do proper filtering for service date
• Cleared filter needs 4 options: Uncleared, Reconciled, Cleared, Cleared and Reconciled
• Account Filter needs All COGS/Ordinary Expenses and All COGS/Expenses options
• Two separate Accounts filters (Source and Split)
• Process Multiple Reports into one Excel Workbook with different tabs
• Longer Report Footer (more than 100 characters needed)
• Display time-based dimensions in the rows as well (in the custom summary report)
• Ability to group transaction detail reports by Source Transaction and by Linked Transactions Group
• On a Transaction Detail Report Totaled by any dimension, Ability to hide all transactions from a dimension that is balanced to zero
• Show full path for account and split fields on detail reports
• On Account Type Filter, add: All COGS and Expenses, All COGS, Expenses, and Other Income/Expenses, All Current Assets, Banks, Accounts Receivable, Credit Cards, and Current Liabilities, All Reconcilable Accounts, All Equity Except Net Income and Retained Earnings
• Cash Basis detail reports need a field called “Accrual Basis Date” with the original transaction date and all accrual basis detail reports need to have a Last Payment Date and Fully Paid Date
• An all Posting Transactions Report, that shows all transactions with source and splits that contain ALL the fields tied to them inside the transaction table, with no totals, no subtotals, no titles (just the headers) in flat view ready for export.
• Timesheet reports, a report that contains all the timesheet data in detail tabular format
• When selecting a filtered report with specific item/customer/classes/accounts with subs, ability to automatically select any NEW subs created to be added to the memorized report
• More information in the window where Multiple item/customer/classes/accounts such as Account type, Customer Type, Item Type to provide more context
• Ability to see the default account setup for a vendor under “Account Settings” in a vendor listing report

Needed New Reports:

• Trial Balance Net Change Report: contains Beg Bal, Debits, Credits, Net Change, and Ending Balance
• Inventory Stock Status by Lot Number
• Inventory Turnover Days by Item
• Commission Report by Rep
• Profitability Cashflow Report: Combines Accrual basis high-level Summary P&L (INCOME, COGS, EXPENSES, OTHER INCOME, OTHER EXPENSES) with Indirect Cash Flow report explaining how net income and cash are related to each other)
• A set of reports that show item price variance: Items sold below cost, items sold bellow desired margin, items sold at a price bellow an active price level
• Invoice Gross Profit Report
• Inventory Days/weeks forecast report: takes the historical average sales per Day or per Week and projects how many days/weeks are left based on current availability (plus on PO)
• Linked Transactions Report for POs (showing bills), for SO’s (showing linked Invoices), for Bill Payments (linked showing Bills), for Customer Payments (showing linked Invoices), Deposits (showing linked payments), and Deposits (showing linked payments AND Invoices)
• Discounted Bill Report: shows all outstanding bills with their due date and their calculated discount (based on terms) if paid by today
• Undeposited Funds As of Date Report
• Uncleared Transactions as of Date Report
• Cash/Accrual P&L Report shows two columns and the comparison dollar amount… would better explain cash basis net income for most non-accountant users
• Profit by Rep that takes into account Rep fields in Bills/Checks/CC
• “TB Mode” on P&L and Balance Sheet reports (with the Debit/Credit Format)
• Comprehensive access to “Ship To” information for sales reports, such as Sales by Country, State, City, Zip code, etc… using the Ship to Information
• WIP Report, ability to add pending expenses from open PO’s and BURDENED Payroll costs from timesheets not yet made into paychecks
  WIP Report to Journal Entry Workflow – to create Earned Income from WIP asset workflow.

Transaction with Templates:

• Show Preferred Vendor dropdown in all sales forms: Estimates, Sales Orders, Invoices, and Sales Receipts. Specifically, on Estimates and Sales Orders, the modified Preferred Vendor will also be used for creating the PO from Estimates/Sales orders
• Show Employee dropdown in all sales forms: Estimates, Sales Orders, Invoices, and Sales Receipts. Specifically, on Estimates and Sales Orders, the Employee will also be used for creating timesheets or “Work orders”
• Vendor Work order: similar to a packing slip or pick list, showing only items/description only.
• Show item price (sales forms), cost (purchase forms), description, preferred vendor in dropdown on the forms (allow the user to choose which data fields they could see)
• Disallow certain users from selecting or changing the REP on a transaction already created (or forcing that user to only have himself as the rep)
• Ability to show/hide columns in forms or change order using a Change Columns button (the same way all other modules do it) instead of just using the very cumbersome template editor
• Custom Field data entered in Estimate or SO should carry over to PO
• Transfer attachments from billable items on checks, credit cards, or bills into Invoices
• Transfer attachments from Sales Orders or Estimates to Invoices, from PO’s to Bills, from Bills to Bill Payments, etc…
• Create a transaction status dropdown for non-posting transactions like estimates, SO, and PO… the same way that Customer:Jobs have a Job Status
• Ability to show item pictures in Estimates, Sales Orders, Invoices, and Purchase Orders
• Make all visible fields in firms long enough that can be read when content in it is longer that current limited size. Particular to Memo, Customer:Job, Class, and all header fields
• Ability to collapsed rows with long word-wrapped descriptions (like in QB Mac)
• Faster way to edit items from transaction screen
• Rep on PO on each line-level that moves over to Bills/Checks/CC when received.
• Ability to add digital signature capture or approval from customers when estimate or invoice is send via email

All Transactions or Other Transactions

• Create Date/By and Last Modified Date/By should be in the bottom of every transaction as a reference.
• Ability to use Copy Down function in all transactions
• Receive Payment and Bill Payment windows should contain the invoice/bills source MEMO line, is VERY important!
• Receive Payment and bill-payment window should have the ability to select a class (important for unapplied payments)
• Contextual Audit Trail from ANY transaction. In other words, being able to pull an Audit Trail for a single transaction from ANY transaction. This already words very well inside of an Invoice or Inside of a Bill.
• Show transaction MEMO on Pay Bills window, Customer Payment Window, and Apply Credits windows for bills and invoices
• EVERY transaction type should have a keyboard shortcut
• Add a Cleared Date to all transactions that have been MATCHED via Bank Feeds, and a Reconciled Period Date that brings over the closing period of a reconciliation and adds it to each transaction
• Boolean search in MEMO (AND, OR, NOT, ?, *)
• Show preview of attached docs when you hover over the attachments icon
• Batch CLOSE Open sales orders.

Item List:

• Introduce new Item Category Type dimension that can group items in reports the same way that
• Allow to show item list in Tabular format (items and sub items in separate columns)
• Show all custom fields in Edit Item window, no need to click on Custom Fields!
• Store item-level numerical value as a number field so when its exported to excel it is NOT a text field. Also, numerical value fields should behave like all other QB numerical fields
• Show calendar dropdown on Date-based custom fields (Enterprise-only) and allow for date keyboard shortcuts
• Allow calculation on numerical-based custom fields
• Historical transaction account change when an item’s account has been modified, should be able to have a stop date (such as the way it works with Payroll items, which is amazing!)
• Ability to add classes to item groups
• Lead time (in days) should be added to items (that way it can calculate estimated arrival date of PO based on lead time)
• Preferred Unit of Measure to be used for EVERY transaction type: PO, Item Receipt/Bill/Check/CC, Estimates/Sales Orders/Invoices, Picklist, and Packing Slip. A global setting for all U/M set and one per item.

Advanced Pricing / Price Levels

• Allow for volume discounts on purchases
• A special user permission that disallows the user from changing a price or restricts the user from choosing from a price level
• Allow for importing price levels in Add/Edit Multiple item module
• Allow for Inventory Adjustments in the Add/Edit multiple item module

Advanced Inventory

• When serial numbers are turn on, the valuation method should be based on Specific Identification
• When Lot numbers and FIFO is turned on, there should be an option to make FIFO layers calculated in EACH lot
• Barcode scanning feature should work for Inventory QTY adjustments
• Should be able to turn on Bin Locations for a single inventory location where the user does not have to CHOOSE the location each time (in other words, the Inventory Site is chosen automatically)
• Item reports with Lot numbers should be able to show QTY or valuation by Lot number. Same thing for items by Site or bin locations.
• Ability to work with Serial Numbers AND Lot Numbers
• Add Expiration Dates
• Add Manufactured Dates
• Add Sell-by date

Mobile Warehouse (using Site Operations function under Advanced Inventory)

• Password/Pin style login for mobile warehouse users
• Ability Restrict a mobile android app user to a specific site location
• Ability to prevent a user of a mobile android app to pick items with lot numbers or serial numbers that are actually in the QB File.   Currently it allows any serial number to be used, it does not restrict the user (or give an error) when picking items
• Ability for mobile android app user to do item inquiries by scanning an item (such as quick stock and availability info)
• Ability for mobile android user to generate Invoice (and most importantly Packing List) to print from app to be able to put it inside the box while packing
• Ability to disable separate Pick/Pack workflow when Express Pick-Pack is enabled (and vice versa)
• Ability for mobile android user select any open PO to be received and not have to wait until a QB user to “send to device”
• Ability for mobile android user to do inventory adjustments “on the fly” and no need to wait for a cycle count
• Ability to print any related transaction from mobile android device
• Ability to generate shipping and print labels from android device
• Ability to do Inventory Site Transfers, Bin Number Transfers, and/or Lot Number Transfers within mobile android app
• iPhone app and compatibility with any Bluetooth barcode scanner
• Ability to print a barcode on a Sales Order or Purchase Order template, so that the mobile user could just scan it to go straight to pick or receive that transaction

Bank Feeds and Check Register screen

• Redesign Bank Feeds screen and Check register screens to be more friendly and to look similar to each other
• Enable/disable customer:jobs and class column
• Ability to disable Ref Num on check register screen so it does not automatically ad a bogus check number
• Create different bank rules based on source account (like in QBO)
• Ability to add classes in bank feeds and/or bank rules
• Ability to add customer:job in bank feeds and/or bank rules
• Ability to make rules based on money-in, money-out, or both
• Ability to make a bill payment from a Credit Card bank feed
• Ability to quickly create a new vendor without having to click on QuickAdd or any box (like by using a keyboard shortcut like CTRL-ENTER)
• Ability to choose item instead of account in bank feed or bank register screen
• Ability to upload CSV files as bank feeds (instead of only .QBO)
• Duplicate complete Payee/Description into Memo field in the Bank Feeds window
• Ability

Write Checks  / Check Register

• An option to identify a transaction that is not a Check (such as ACH or Bank Debit)
• When a Vendor with open bills is chosen, ability to choose the bills to pay with the check (in other words, change the check into a billpmt-check)
• Cleared Date on checks should appear whenever the check is matched with bank feeds
• Customizable Check register, ability to show/hide any columns or field needed, also ability to filter in check register such as in QBO

Batch Enter Transactions

• Ability to batch enter transactions with multiple lines (if ref num, date, and payee matches)
• Ability to batch enter checks/deposits on the same screen with negative a positive numbers (just like in the credit card option)
• Ability to Batch Enter Sales Receipts
• Ability to Batch Enter Journal Entries with Single lines for any Balance Sheet account at source account (such like all other current batch enter functions)
• Ability to batch enter customer payments and vendor bills (UNAPPLIED)
• Also add non-posting transactions such as estimates, Sales orders, and sales receipts
• Ability for QuickBooks to automatically select pre-fill or learned default account when selecting a vendor during batch enter transactions
• Batch Enter Timesheets

Reclassify Transactions

• This module should respect closing date password protection
• Ability to Reclassify Source Payee
• Ability to Reclassify Destination Customer:Job
• Ability to Append a memo to reclassified transactions
• Ability to select multiple vendors when filtering by payee
• Shift-click to select multiple

Other Accountant Tools

• Add more transaction types to Batch Void/Delete Tool such as Sales Receipts and Journal Entries
• Ability to Add/Edit Accounts in batch
• Zero-out Balance Sheet.. quickly create a Journal Entry that would bring all accounts of balance sheet to zero at a specific date
• Batch Merge Items, Accounts or Classes (but in a much simpler way compared to Merge Vendors new QB18 feature)
• Batch convert all Other Names to Vendors
• Batch zero Qty to Inventory items via Inventory Adjustment
• Batch zero-out invoice or vendor balances via journal entry

Reconciliation Screen

• Select ALL or None for each side (credits/debits)
• Shift select to select a group
• Reconcile and Next (to do multiple months)
• Clear Date (such as in QBO, with transactions that were matched with Bank Feeds)
• Show source account, customer:job, and source clear status on the screen (allow the user to choose what columns they want to see
• Ability to display all transactions under a parent account, so user does not have to reclassify all the transactions of each sub at the time
• Add a hidden field in transactions called reconciled date (which ads the date of the reconciliation period used when reconciling the transaction)
• Filter that only shows uncleared transactions

Make Deposit Screen

• Cleared label needs to be visible in deposit screen
• Undeposited funds window needs to have more filters and search
• Easier way to replace lines with a transaction from undeposited funds
• Larger memo/ref field
• Keyboard shortcut for Make Deposit window, such as CTRL-ALT-D

Preferences / User Permissions / Other:

• Default class by SOURCE account (right now we have Name, Target Account, and Item only)
• Ability to turn on Purchase Orders without turning on Inventory
• Ability disable Item receipts (when Enhanced Inventory Receiving is not on)
• Closing Date should have a selective transaction type (such as only bank / credit card affecting transactions, allowing users to still make changes to invoices and bills if they need to). Allow users to modify the source MEMO from filed from transactions in close periods (allowing for future notes)
• Ability to disallow certain users from changing the sales price of items in transaction forms
• Ability to disallow users from entering transactions into a parent account that has subaccounts (preventing the messy “ – Other” suffix added on reports). Same for Customer:Jobs, Items:Sub-items, and Classes:Subclasses.
• Ability to disable Other Names
• Ability to rename icons in the home screen
• Fast access to amount find from the tool bar (most used find feature)
• Ability to disallow user from overriding transaction numbers for Estimates, Invoices, Sales Orders, Purchase Orders, and Sales receipts
• Enable Locations (like in QBO) and/or a secondary Class
• When giving users permissions to reconcile accounts, ability to choose which accounts can and cannot be reconciled.

Bills

• Bills should carry custom header fields just like a PO and Invoice do
• Add a Posting Date (current bill transaction date) and a “billing date” that is used to calculate the terms for the due date (important for inventory-based bills)
• Ability to turn a check or credit card charge into a bill payment on the fly

Customer Center / Vendor Center

• Sub-Vendors (even If is just one layer) would be amazing!
• Ability to Quickly change the Job Status within the Customer:Job Screen
• Separate Customer and Jobs in a “Tabular view”
• Add a last transaction date column
• Ability to show first Autofill Account in vendor center (either the one from the Account Settings or the one in QB’s internal memory for autofill)
• Ability to add/edit that account

For Manufacturing and Inventory Assembly

• Ability to create byproducts from Inventory assembly (negative BOM)
• Create Inventory Assemblies from Sales Orders
• Ability to easily import BOMs from excel
• Batch Assembly, single screen to create multiple assemblies from one screen, similar to the Sales Order Fulfillment worksheet to know if multiple assembly items can be made simultaneously keeping track progressively of the stock components

Transfers

• Cleared label on Transfers for BOTH SIDES
• Ability to convert Transfers to Journal Entries

Journal Entries

• Ability to use an item in a journal entry
• Cleared label on balance sheet accounts in Journal Entries
• Ability to batch enter Debit/Credit Style Journal entries with multiple lines (OR allow for batch enter style copy/paste functions in current batch enter screen)

Managing Pre-Payments

• Option to send all unapplied customer payments to a Unapplied Customer Payments Current Liability Account (instead of a negative A/R)
• Option to make payments via check or credit card to a Vendor Prepayment current asset account, that can then be used as a payment source when paying bills (instead of choosing Accounts Payable).
• Ability to “Tag” customer prepayment to a Sales Order so when the invoice is created, QuickBooks prompts to apply to that invoice
• Ability to “Tag” vendor prepayment to a Purchase Order so when the bill is received, QuickBooks prompts to apply to that bill

Chart of Accounts

• Search within descriptions
• Right Click DUPLICATE should be enabled in Accounts, Customer:Job, and Vendors.. to function identical to Items
• Create a column for identifying if accounts are in the P&L or the balance Sheet – or some other way to make is very evident to the user the two types of accounts (maybe make all BS account bold)
• Display all account types in New Account Screen as a drop down (like in QBO), don’t lump any accounts into an Other Category (confusing)
• Ability to flag accounts with a custom dimension such as Variable/Fixed, call it Account Group. The allow reports to group via Account Groups instead if by Account; similar to Account Type, but with customizable dimensions

Preferences / Toggles

• Ability to disallow a user from choosing an account or item that has sub:accounts or sub:items
• Ability to completely turn off the automation of the BILLABLE checkbox when entering items with customer:job selected in timesheets, bills, checks, and credit card charges
• Deeper ability to be able to enable/disable certain areas and functionality of QuickBooks to customize it for customers that get overwhelmed and/or get in trouble with so many buttons

Did I miss anything? e-mail me: [email protected]