Need help choosing a plan?
Created with Sketch. 1800 917 771 Schedule a call
Need help?
We're here for you.
Schedule call
Created with Sketch.
product update

QuickBooks Online Update – August 2015

Improved Customer Notes

Want to know more about your customers at a glance?

You can now addΒ NotesΒ under the customer name showing three lines by default, with a …moreΒ link to select the entire field for easy editing.

CustomersΒ > click a customer name >Β NotesΒ field under your customer name.

Customer view now has a Customer column. This is helpful when you’re viewing sub-customers. To turn on the Customer column, go toΒ CustomersΒ > click a customer name > click theΒ cog wheelΒ far right > tick the box next toΒ (2)Β CustomerΒ from the drop down fields.

β€œSticky” search selections.Β When you do an advanced search:Β SearchΒ >Β Advanced SearchΒ in theΒ transaction type andΒ transaction field, it now remembers your previous choices so you don’t have to change them when searching on the same transaction or transactions of the same type when leaving the Advanced Search window.


Easier importing of products and services.Β Add products and services by importing a CSV or Excel file.Β Company SettingsΒ >Β ToolsΒ >Β Import DataΒ >Β Products and Services*Β (please seeΒ NoteΒ down this page before importing CSV file).

1.Β Download aΒ sample file, save it to your desktop, update it with your own data, and then upload it, by clicking onΒ (1)Β Browse

2.Β Map your fields to QuickBooks fields then > clickΒ NextΒ at bottom right


Click in theΒ (1)Β Sell, Buy, and TrackΒ columns to show which related fields will be imported. You can edit item details if you need to if you’ve imported them incorrectlyΒ (2) (3) (4)Β as seen below.Β You can choose whether toΒ (5)Β overwrite existing items that have identical names.

*Note: Prior to importing your Products and Services the settings need to be turned on.


Company SettingsΒ >Β SettingsΒ >Β Company Settings (1)

SalesΒ >Β (1)Β Products and services  – tick boxes next to β€˜Track quantity and price rate’ and β€˜Track quantity on hand’


ImprovedΒ Inventory

The improved inventory release is the first step in the new and enhanced Inventory Management within QuickBooks Online. Saving you time in creating transactions, fulfilling orders and making Inventory a much easier procedure, heading in the right direction to making this area a very robust feature which I’m looking forward to.

Some of the features you will have:

1.Β The option of Filtering the Products and Services List which is all one currently, to either an Item or a Service, making this easier to identify and filter when searching for a product/service.

1

2.Β You will be able to upload a photo of the Item you are selling.

3.Β Add a SKU number.


4.Β On theCogs button (far right button) you will be able to choose what columns you will prefer to view in your window to suit your business.

5.Β To be able to view more Products and Services on the screen click on Compact under the Cogs Button and this reduces the width of the individual rows.

6.Β Make a Copy of an Item or Service easier, one click away by clicking on β€œduplicate”.

7.Β Multiple items can quickly be made inactive by after ticking the item > down arrow on Batch Actions then click on Make Inactive.

8.Β Filtering by Type (Item or Service) and Status ( All, Active or Inactive) just became easier from the Filter button >Β Click down arrow onΒ FilterΒ button thenΒ StatusΒ choose either Active, Inactive or All.Β From theΒ TypeΒ click drop down arrow and choose All, Item or Service.

9.Β There is also a search field β€œFind Inventory” where you will be able to search by Name, SKU and description

10.Β We now see the Rate/Price column replaced by a Sales Price and a Cost column.


This will make running Inventory in QuickBooks Online easier and friendlier to search if you have 100’s and 100’s of items and reporting is a breeze!


TPAR Enhancements

We recently had the TPAR feature enhanced with the ability to turn TPAR on or off. By adding in the electronic file feature, we canΒ download the .efile and upload direct to the ATO BAS portal or GovReports depending on what you are using. QuickBooks OnlineΒ has gone one extra step for us and added the feature of allowing the ABN Number to be visible at the Suppliers window by ticking the box at the Cogs wheel for added monitoring of supplier ABN numbers.


BAS Rounding

As we are all aware of, when lodging BAS the ATO does not accept any cents and only use whole dollars to lodge. If not accounted for, these small amounts remain in the BAS Payable control account.

QuickBooks OnlineΒ helps us automate this step. When you Lodge the Quarter BAS through the GST Centre, the rounded amount will be posted to a rounding account automatically. There will be a new account called the β€˜BAS Roundoff Gain’ or β€˜Loss’ in our β€˜Expense accounts’ in the β€˜Chart of Accounts’.

WhenΒ rounding values up or down to the nearest dollar, the cents will be simply left off. So for example, $50.21 or $50.89 will bothΒ become $50.00.

Sample File Access want a Test Drive

Just as a reminder that QuickBooks Online has a sample file that is available to you and your clients. If you need to test something, don’t use aΒ real file, use the sample file that’s been provided to you. KeepΒ the linkΒ as a bookmark on your browser’sΒ tab so it’s at your fingertips when needed.

Each time you exit out of the sample file, this file will refresh itself so start Test Driving away!

Invoice template: import enhancements & setting a default style

What we all have been waiting for, here’s just a few teasers for you:

– We can now set the imported invoice style as your default (and don’t forget you can have one for each day if you want)

– Resizing the logo on the friendly templates within QBO

Changes & Improvements

Also in the August update we see some changes in different areas:

– We have improved the look and feel of β€œImporting data” to be in line with rest of features within QuickBooks Online.Β 

– Importing Product & Services the ability for users on lower resolution screens, column headings would overlap this has been updated to accommodate the width & also scrolling is easier

– The currency centre page will also now be in line with the Harmonising look in QuickBooks Online. The Revalue Currency page is much more usable than before

Importing Customers and Suppliers with Opening Balance and ABN detail

When importing Customers direct from a .CSV file we now have the addition of including the opening balance and the ABN details of a customer. This is helpful if you’re importing a large amount of Customers and you don’t want to add each invoice individually.



Related Articles

Looking for something else?

Get QuickBooks

Smart features made for your business. We've got you covered.

Help Me Choose

Use our product selector to find the best accounting software for you.

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.

Stay up-to-date with the latest small business insights and trends!


Sign up for our quarterly newsletter and receive educational and interesting content straight to your inbox.

Want more? Visit our tools and templates!

By signing up you are agreeing to our terms and privacy policy.

A happy small business owner signing up for the QuickBooks newsletter on laptop