2016-09-22

QuickBooks Training Post:

Wishlist for QuickBooks DESKTOP 2018+ by category

Register, Transfers, Deposits, Banking, and Reconciliation

Cleared Tag on Deposits, Transfers (for EACH SIDE of the balance sheet transaction), Payments that bypass Undeposited Funds, and Sales Receipts that bypass undeposited funds

Customizable check registers just like all other screens that have a “Customize Columns” option, all registers in the balance sheet should have this option. It is useful to be able to change the order in which data is entered, and which fields to hide (like REF) and which to show (like Class and Customer:Job). QuickBooks Online executed this very well

Same type of column customizability in Bank Feeds

Ability to “Pay Bills” from the credit card bank feeds screen, currently you can only do that from the bank account bank feed screen only

A “Write Checks” transaction and a “Pay Bill-Check” transaction should be able to be swappable via a simple checkbox, just like a Credit Card Charge/Credit or a Receive Items / Bill transactions.

Deposits: Larger Memo field and Deposit To fields

Deposits: Bigger PAYMENTS button, and label it with UNDEPOSITED FUNDS so people can understand where these come from

Make sure that Payments to deposit window has the word UNDEPOSITED FUNDS somewhere. More ability to filter date ranges and more filtering options such as whether the payment is from an invoice (payment item), Payment screen, journal entry, Sales Receipt, etc. Show Memo from Payment in this screen as well

In any Register, Shortcut for QuickAdd Vendor, like CTRL-ENTER

In a Credit Card Register, Ability to switch a creditcard charge to a credit card credit from the register if the user makes a mistake

Transfer Funds, I need to know if these two bank transactions have been cleared or not. Also I need the ability to transfer into an income or expense account; not because I want to do that, it is for correcting user errors.

Reconciliation

I would like to be able to search and filter transactions within the same screen. It is also very useful to be able to see whether the account was downloaded or matched through bank feeds in the reconciliation screen.

A lot of users get stuck when a transaction is missing, so a “add new check” and “add new deposit” button under each side would be very useful.

We need “shift-click” functionality, which lets the user select several transactions in batch

Ability to Hide transactions that were checked

Mark All and Unmark all separate for debits and credits

Show void checks on the checks side, not the deposit side, its confusing

More Customized columns options

Reconcile and New Button

Add a hidden tag to transactions to know in which reconciliation they were reconciled

Group/Filter (and item count) by transaction type, very helpful for long reconciliations

Bank Feeds

Ability to bring CSV files to Bank Feeds…. This is long overdue, allow people with smaller banks or international banks to bring their data in without being a slave to .QBO files

Customize Columns, add or remove customer:job, class, or billable

Keyboard shortcut to QuickCreate Vendor

Ability quick create a customer or vendor based on the Downloaded As

There is glitch when clicking on SHIFT KEY

Sorting should be “sticky”, bank feeds gets resorted after adding a transaction

Ability to Pay Bills from a credit card on Bank Feeds

Ability to search Rules, filter by Payee or account

Keyboard Shortcut to access Rules

Option to automatically add the Bank’s Downloaded as and Memo into the Memo line, instead of just the MEMO.  QuickBooks Online does this very well.

Increase the performance of Bank Feeds, feels slow and clunky sometimes

Display when was the last time the bank was reconciled, to help user avoid accepting transactions that are dated before the reconciled period

Bills and Payables

Ability to add a memo when creating a Pay Bills

Make the Class and Terms box larger to support the view of all 31 characters

Ability to see which PO numbers are related to the bills in the Pay Bills Window

Ability to Pay a Bill using Method “Other Current Asset” which will enable all these accounts (the same way you can deposit to them) and create a General Journal Entry that hits Accounts Payable and applies it to bill

In the Pay Bills window, rename the method “Check” to “Check / Bank Debit” to make it easier for users to understand how to pay bills with debit cards, electronic debits, and/or wire transfers… which are becoming more common than “checks”

Ability to disable “Receive Items” or “Receive Inventory without Bill” from the workflow all together

Customize Columns that can be see about the bills, specially MEMO field, bill date, Terms, Class, AP account

In the Pay Bills screen, Ability to see ALL AP accounts if multiple are present, instead of bing limited to one at the time

Show MEMO from the transactions in the screen where we can apply credits

In Bills, Checks, and CC Charges Screen, “Expenses” tab, should actually say “Accounts”; this is very inconsistent with the rest of the software… This tab gives you access to accounts, not just expenses. Notice they fixed this in QBO as well.

Abilty to track Name/Header custom fields in Bills as well, so these can transfer from the PO

Transfer attachments from Bill/Check/CCcharge onto Invoice when marked as billable

We need a better system to manage Prepayments (against POS) that do not create negative A/P

Homepage, General Visuals and Preferences

All screens need to have a larger Memo field, at least TWICE as large. Checks and Bills should have 2 lines

Ability to search accounts (in expense tab or journal entry) the same way we search for Items in Sales Transactions

Ability to block the ability for using an account, customer, or item that has an active subaccount, job, or subitem

Ability to DISABLE “Other Names” so users cannot ever touch this

Add ability for purchase orders without the need for inventory

Ability to disable Item Receipts function so users go from PO to Bill directly or PO to Check/CC

Fast access to search transaction for a specific amount that uses the FIND functionality, not the SEARCH functionality, right on the main toolbar

Ability to change the names or add descriptions to any icon on the home page in parenthesis. Like if I want the Purchase Order to say in parenthesis (Work Order) to help the user really understands what that function does based on their industry or need. Like Customers (Patients) or Vendors (Service Providers). Also if we could move them around and change the arrows, we can really help customize workflows, at least visually

Move the Banking Area to the top, make Pay Bills cross into the Banking Area.   Company Area under the Banking Area

EVERY transaction type should have a keyboard shortcut

Add the Custom Fields for items and Names edit screen onto the List Menu, its too counter intuitive to access via the item list or customer/vendor center

Ability to increase and decrease overall font type, some people like the smaller funds to have more space to work, there is a lot of wasted space

Vendor/Customer Centers

Ability to separate Customers and Jobs into multiple columns, in addition to Flat view and hierarchal view

Last Transaction Date column, so we can know how “active” the customer or vendor is

Ability to use Subvendors just like Customer:Job, Item:SubItem, Account:subaccount, etc… Seems like vendors were left out all together

Transaction Forms: Invoices, Sales Receipts, Estimates, and Purchase Orders

Preferred Vendor option inside the item columns to give the user the ability to see the vendor for the item on sales transactions (or change it in the case of using a sales order or estimate to create a PO!)

Larger Customer:Job and Vendor dropdown menu (many times Customer names truncate)

Larger or Resizable Header fields on all forms, it makes no sense we are stuck with “on-size-fits-all” boxes

Ability to “collapse” or wordwrap lines on invoices to be able to see more lines whenever a description is long (see the fix of QuickBooks Mac 2015 to 2016, would like the ability to toggle it back and forth)

Attached file preview on right sidebar with thumbnails

Add a pencil icon next to the template name on the top right for quick access to customize data layout

Ability to use Copy Down feature on any field inside the form (must specifically on Class)

Larger Memo Field and Larger Customer Message Field (I am not talking about the capacity, just the display)

Ability to add aging bar on the footer when printing the invoice

Pencil icon next to any item to be able to quickly edit the item, or ability to right-click and click on Edit Item

Shortcut key for Copy Line and Paste Line (CTRL-ALT-C / CTRL-ALT-V)

Ability to BLOCK the ability to override the document number (Admin Company Preference) that way the user must work with the automated number provided. This one is HUGE for control

When clicking on Select Items to Receipts when inside an Open Purchase Order, it should jump straight into the PO being received, instead od having to select the vendor and then the PO

When a PO is created from an Estimate using the Cost and markup columns, the costs from the estimate should flow to the PO, instead of the default cost from the item (maybe this can be a preference to toggle this mode or the old mode)

Any custom field restricted to Date (Enterprise) needs to behave like other date fields (T to Today, +/- to go and down one). Additionally when using filters with those dates, we need to be able to work with a range, otherwise they are not really that useful.

Service Date needs to be available for searching and filtering for reports; otherwise is not too useful

Reports

We need these two Default Reports: Unreconciled Transactions Report and Undeposited Funds Report

Cleared Filter: I want to be able to see both types of cleared transactions: Cleared and Reconciled as a filter

Horizontal Collapse for Classes and Customers:Jobs

Multiple Accounts, Multiple Items, Multiple Classes, and Multiple Items filter needs to be cleaner looking, with ability to search, sort, and filter

Account filter needs the option for Cost of Goods Sold / Expenses and All Expenses Including COGS

Amount (Between / Range)

Two separate Account filters (Source and Split)

Name filter for Source and Split separate filters and also both showing as defaults in a transaction detail report

Transaction detail Report : At least two Dimensions of Total By for better grouping, maybe a “Subtotal by”

Transaction detail Report: Total by Options: Customers Only (Collapsed), Jobs Only, Classes without Subs (Collapsed)

Transaction detail Report: ability to export a FLAT FILE (CSV) with no totals, just headings and raw data

Process Multiple Reports into a single Excel file with different worksheets (Report Pack) or for a single PDF file with multiple pages

When memorizing a report, the ability to create a new group in that screen

Larger Footer Disclaimer for reports (EXTRA FOOTER LINE IS TOO SHORT, need 250 characters at least)

Quick Access to filters, Cash/Accrual toggle, within report

Filter/Columns available for transaction detail report: Has linked transactions?, Service Date, Creation Date

Quick Font resizing for reports (CTRL + / CTRL -)

Write Checks

Checkmark next to check number that disables the reference and enters “BNKDEBIT” as the reference number to represent a debit card, ACH, direct deposit, wire, anything but a check. This should be accompanied with a filter on reports to be able to filter checks that are BNKDEBIT or not

Ability to Copy Down for Customer:Jobs and Classes (also suggested for all other transaction forms and fields)

Ability to convert a Check into a Bill-Pmt in a single click. This helps to correct many errors that require the user to use ACCOUNTS PAYABLE when using a check to pay a bill. Or add a third tab called “Open Bills” that is like a pay bills window.

Preview open bills for that vendor when user overrides pay bills warning, not just a warning; it may help the person realize they are trying to Pay the Bill when they see it on the screen

Customer Payments

Larger Memo field

Customize fields that can be seen here about the invoices, specially MEMO field, terms/due date, source class, rep, PO number, SO number

We need a better system to manage Prepayments (against estimates and SO) that do not create negative A/R

Chart of Accounts

Ability to search just like in the Items screen

Right-Click Duplicate account

Display a thick black line between the Balance Sheet accounts and P&L Accounts. Between the last equity account and the first Income account. You could also make all the Balance Sheet accounts Bold.

In the NEW ACCOUNT screen, open all the accounts instead of having them inside that other account types dropdown. Organize them like a P&L and a balance sheet so it makes sense to the users.   In other words, on the left column put: Income, COGS, Expense, Other Income, and Other Expense… on the right column, put: Bank, A/R, Other Currenct Asset, Fixed Asset, Other Asset, A/P, Other Current Liability, Long Term Liability, and Equity.

Item List

When Editing an item, display the custom fields, no need to click on CUSTOM FIELDS

Quick Report or CTRL-Q from within the Edit Item screen

Ability to separate Items and Sub-items into multiple columns, in addition to Flat view and hierarchal view

Larger Item name field in the edit item screen

Item Category <- This may be a new/major feature, but I just want a dropdown field with any categories I want to use. This avoids the needs to use sub items many times, which is confusing for most users. This would of course be filterable just like preferred vendor or a custom field. However this field would not show in an invoice as a field, is just an internal category for reporting and sorting

QUICKBOOKS ACCOUNTANT’S TOOLS

Batch Enter Transactions

Add Purchase Orders, Sales Receipts, Customer Payments, and Sales Orders

Add Batch Enter Journal Entries… WOW!

Ability to Copy/paste inside split screen or If a user has more than one transaction with the same ref number and payee, it should become just one transaction with multiple lines. Allowing us to Batch Enter with multiple lines, eliminated the need for complicated 3rd party tools for Import, easier for us to bring data from other accounting systems into QuickBooks. Marketing wise, you can now claim that with QBES you can “import data from any existing accounting system” WIN-WIN

Recognize and omit $ signs from paste, and auto round to 2 decimals

Reclassify Transactions

Reclassify Payee and/or Customer:Job as well

Ability to add memo to reclassified transactions (like with the batch void new feature)

Ability to select Parent Account with all included sub accounts

Ability to reclassify items

Customize columns to see more data from the transactions, specially the CLR or Banking status

Ability to select a multiple vendors when filtering

Shift-Click to select multiple transaction

Add/Edit Multiple List Entries

Add Accounts as one of the options

Add Other Charges as a item option as well

Ability to Export to excel the EXACT list with the EXACT order that you are seeing on the screen

Ability to COPY DOWN for Active/Inactive items

Add the ability to choose the default Account Settings to vendors

New Tools Ideas

FINISH Batch Delete, add all other transaction types

Batch Edit (this is a little far fetched, but imagine a Check Register, Batch Enter, and Add/Edit Multiple had a brainchild feature called Batch Edit.   Allowing to change dates, payees, memos, customer:job, amounts, source accounts, anything in batch.. with COPY DOWN feature and robust filters, this would be the best tool ever!

Batch Merge. Ability to select a group of vendors and merge them all at once! Same for Items, Accounts, Customers, Classes, etc.

Specifically for QuickBooks Enterprise

User permissions, there is a LOT of work to do here.. we need DATA LEVEL (specific account, classes, reps, customers, vendors, etc…) permissions; more over we need permissions to modify which FIELDS within certain transactions that can/cannot be manipulated.  Also the fact that Intuit has not fixed that ANYONE can just change the sales price of the product (or not be able to put a “floor” on the price) is a deal breaker for a lot of mid-market clients.  We also need to be able to have more than 1 Admin

Multi-user support.  Our customers yell across their offices asking for people to get out to use in single user, and/or have to wait for people to finish… sometimes the Admin cant even boot them out through the messenger, lots of drama…  QBES should just be able to do VIRTUALLY everything in multi-user.  Plus while in multi-user, ADMIN should be able to temporarily override any transactions that a user doesn’t have access to, instead of: making the person get out, change permissions, log back in, make changes, get out, change permissions again… its a big waste of time

Advanced Inventory

1. FIFO, we need to be able to have FIFO data through the SDK as well, plus other areas where FIFO is just marking the “real” number which is still using avg. cost.  Additionally, FIFO needs to also be present at the LOT LEVEL, because the one of the most common reasons must people use lots is to track its costs/profit by LOT.  Same goes for SERIAL NUMBERS, which could give us the ability to do Specific identification (another GAAP inventory valuation method)

2. Lot Numbers are missing reports, there are virtually no useful reports when it comes to Lot numbers

3. Multiple Locations actually work pretty well (it being the most mature of the features), but there are a lot of missing reports in regards to bin locations

4. Barcode. well this features not so useful if you cant get a real wireless scanner to do inventory cycle counts or stock inquiries.  And Barcodes need to work in ALL transactions (specially inventory adjustment), not just a few

Core Inventory,

1. More stability and better performance after 20k+ items

2. Multiple preferred vendors with separate costs per vendor, this is so important for people making the decisions to purchase inventory.

3. Volume discounts (this is something advanced pricing cant fix either) which is to recognize the the cost of inventory simply just varies with volume

4. Sales Price AND List Price.  We need to be able to work with two dimensions of pricing, most wholesale and distribution businesses work with BOTH of these, and price levels and rules sometimes need to work of one or the other

5. Cost, Avg. Cost, and FIFO Cost.  These 3 pieces of information are important an need to be available in ALL SCREENS where we are making a cost inquiry or producing a MARKUP/MARGIN calculation

6. BOM Costs.  the cost of BOM is still works of “Cost”, we have got to be able to pull real costs like AVG or FIFO, otherwise the sales price is hard to get right

7. Units of Measure, have a very small limitation for conversion (10,0000), due to the 5 decimal limitation.  We need a 10 decimal limitation at least, that way we can have broader conversion ranges

8. Landed Cost, ability to allocate freight and other expenses to the item cost

9. Assemblies, we need to be able to have a better way to integrate Payroll/Overhead costs.  Also the ability to have NEGATIVE qty in the BOM could fix the deficiency with scrap.  We also need some production planning reports and tools, as QBES only works for very “light” manufacturing.

10. Inventory Attributes. we need to be able to have an attributes table with different prices… and/or and “Item Category” field that allows us to use instead of SUBITEMS which is a complete mess for end-users.   Item Categories need to be used to group and organize your items, and on top of that

Core Reporting: there are some really basic things that we can get from standard reports like a workable commissions report, Inventory Reports by Lot or Bin, Inventory Aging Reports, Inventory Forecasting, etc…

The post My QuickBooks Desktop 2018 and Beyond wishlist… appeared first on QuickBooks Training & QuickBooks Consulting. Best rated in Miami & Broward.

Show more