Space for pervasive banner when authenticated
Customize list columns and format negative numbers
Learn how to customize list columns and format negative numbers in QuickBooks Desktop for Mac Plus.
You can customize list columns in your Items, Memorized Transactions, Customers, and Vendors lists. You can also format the negative numbers in those columns. This lets you sort and check the data you need in one place.
Customize list columns
Item list columns
Go to File, then select Open Recent >.
Select the company you want to open.
Go to Lists, then select Items.
Note: The Item List window appears.Right-click on a column header to see all available columns.
To add a column, select it from the list without a checkmark.
To remove a column, select it from the list with a checkmark.
Select Set to Default to go back to the default column layout.
Use columns in item list
Have access to 12 new columns when you customize the item list. They provide you with data for more insights. These include:
Active
Purchase Description
Asset Account
COGS Account
Cost
Sales Tax Code
Payment Method
Quantity on PO
Reorder Point
Tax Agency
Preferred Vendor
Purchase for Resale
Memorized Transaction list columns
Go to File, then select Open Recent >.
Select the company you want to open.
Go to Lists, then select Memorized Transactions.
Right-click on a column header to see all available columns.
To add a column, select it from the list without a checkmark.
To remove a column, select it from the list with a checkmark.
Select Set to Default to go back to the default column layout.
Customer list columns
Go to File, then select Open Recent >.
Select the company you want to open.
Go to Customers, then select Customer Center.
In the Transactions section, right-click on a column header to see all available columns.
To add a column, select it from the list without a checkmark.
To remove a column, select it from the list with a checkmark.
Select Set to Default to go back to the default column layout.
Vendor list columns
Go to File, then select Open Recent >.
Select the company you want to open.
Go to Vendors, then select Vendor Center.
In the Transactions section, right-click on a column header to see all available columns.
To add a column, select it from the list without a checkmark.
To remove a column, select it from the list with a checkmark.
Select Set to Default to go back to the default column layout.
Format negative numbers
Select how you want to view negative numbers in your columns. This helps you find them faster while you check the data in your:
Chart of Accounts
Items
Customers
Vendors
Go to File, then select Open Recent >.
Select the company you want to open.
To format the negative numbers in Chart of Accounts:
a. Go to Lists, then select Chart of Accounts.
b. Go to the Negative Number ▼ dropdown in the toolbar.
c. Select a format from the list in the ▼ dropdownTo format the negative numbers in Items:
a. Go to Lists, then select Items.
Note: The Item List window appears.
b. Go to the Negative Number ▼ dropdown in the toolbar.
c. Select a format from the list in the ▼ dropdown.To format the negative numbers in Customers:
a. Go to Customers, then select Customer Center.
b. Go to the Negative Number ▼ dropdown in the footer.
c. Select a format from the list in the ▼ dropdown.To format the negative numbers in Vendors:
a. Go to Vendors, then select Vendor Center.
b. Go to the Negative Number ▼ dropdown in the footer.
c. Select a format from the list in the ▼ dropdown.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
Call Sales: 1-800-365-9606
