Last updated 09/27/2017

 

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.  Also, Horizontal Collapse
  • 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 subaccount
  • 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 creating custom fields with item/customer/classes/accounts with subs, ability to automatically select any NEW subs created
  • More information in the window where Multiple item/customer/classes/accounts such as Account type, Customer Type, Item Type to provide more context

 

 

Needed New Reports:

  • Trial Balance Net Change Report: contains Beg Bal, Debits, Credits, Net Change, and Ending Balance
  • Inventory Aging Report
  • 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)

 

 

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 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 linfer 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.

 

 

All Transactions or Other Transactions

  • Show preview of attached docs
  • 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, ?, *)

 

 

Item List:

  • Allow to show item list in Tabular format (items and sub items in separate columns)
  • Introduce new Item Category Type dimension that can group items in reports the same way that
  • 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
  • Cost Levels (is like Price levels but for the cost of the item and could be assingned to vendors) OR Multiple preferred vendors with a different cost for each

 

Adjust QTY/Value on Hand

  • 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 to Copy/Paste (like in batch enter or add/edit multiple) in the Adjust screen
  • Barcode scanning feature should work for Inventory QTY adjustments

 

 

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.
  • Enable/Disable Lot Numbers on specific items, so QB does not require or prompt for one

 

 

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)
  • Date range and transaction type filters

 

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 search within rules or filter by payee/account
  • Ability to add classes or customer:job into 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 or ALT-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

 

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 prefill or learned default account when selecting a vendor during batch enter transactions

 

 

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
  • 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.
  • Location Tracking (just like QBO) would be great
  • 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 and/or a secondary Class

 

 

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)
  • Landed cost (functionality that allows for external costs to be added to the item’s posted valuation cost) without changing the billed item cost for A/P purposes and PO matching purposes

 

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 od 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

 

 

Did I miss anything? e-mail me: hector@garciacpa.com

 

Share →

Leave a Reply

Your email address will not be published. Required fields are marked *



For More Information

Call us to 954-633-2718 or email: hector@quickbooks-training.net