Business Administration, Bookkeeping, Compliance News & Tips MYOB Reckon Quickbooks Xero Software Training Small Business

Making Business Books and Accounting Come Alive! MYOB Reckon Xero

MYOB – How to remove “prices are tax inclusive” from my items (or reverse)


MYOB Quickbooks Bookkeeping


Client called saying they are now not registered for GST, but “have thousands of items that I have to remove the ‘prices are tax inclusive’ tick in MYOB and was wondering if there was a quicker was other than going into the item and removing them one at a time.”

Yes there is a quick way to edit items (any part in fact)

Solution: In MYOB –

  1. DO A BACK UP to be safe!
  2. (> means “click”) > File > Export Data > Items
  3. Should say Tab-Delimited and Header Record – leave as is
  4. > Continue > Match All > Export > Save to Desktop
  5. Open the ITEM.TXT file that was created on your desktop – it opens in excel. The top row is the headings. Column AB should be “Sell Price Inclusive” and there should be an x in the column cells below.
  6. Highlight all the cells with an x below, > Delete
  7. > File > Save, say Yes to any warnings . Close the excel file
  8. Back in MYOB: > File > Import Data > Items > Tab-Delimited, Header Record, Duplicate Records – “Delete Item” > Continue > Search Desktop, select ITEM.TXT > Match All > Import, Check the report and any warnings, should be “imported without errors”
  9. Check the items have the box unticked as you wanted.

Author: Account keeping plus (Business accounting software

Administration, Bookkeeping and Compliance for small business, and Self-Managed Super Funds (SMSF) Training, trouble-shooting, or we can do the books and payroll for you! Self Managed Superannuation Fund Service Provider, Free support 30 min call 0407 361 596 Australia (+61 drop 0 from overseas) MYOB Certified Consultant, Reckon/QuickBooks Professional Partner.

2 thoughts on “MYOB – How to remove “prices are tax inclusive” from my items (or reverse)

  1. Where does it say delete them???? My version 19 says update them or reject them not delete them.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s