cancel
Showing results for 
Search instead for 
Did you mean: 
pkelly22
Level 2

How to adjust column order when entering Bills

My bookkeeper noticed one day when entering in a customer bill that the order of the columns had changed under the Items tab. It used to have the CUSTOMER:JOB before the CLASS when entering the bill. Now they are reversed (see attached). We have multiple companies we run through Quickbooks and it is only this way on one of the companies - and only on the bill entry screen (credit card entry did not change). How do we change it back to the original order of entry?

Solved
Best answer July 19, 2022

Best Answers
BigRedConsulting
Community Champion

How to adjust column order when entering Bills

Right click on the Bill table and choose Customize Columns.

Then change the column order and even the columns that appear to suit.

View solution in original post

Giovann_G
Moderator

How to adjust column order when entering Bills

I appreciate you sharing the screenshot, pkelly22.

 

It's odd that it doesn't show up on your end even though I'm using the same QuickBooks version of yours. Let's run through some troubleshooting steps to see if this is a problem with your company file or the QuickBooks software.

 

Before we proceed, ensure you QuickBooks Desktop is updated to the latest release. This guarantees you have the most recent features and fixes. After that, you may run the Verify and Rebuilt data to fix any potential data problems that might be causing the system to behave in an unexpected way.

 

Here's how:

 

  1. Go to the File menu, then click Utilities.
  2. Choose Verify Data, then hit OK to close all windows. If you see “Your data has failed the integrity check” you need to rebuild your file. If there are no problems with your data, you’re done.

 

Rebuild data:

 

  1. Go to the File menu, then select Utilities.
  2. Click Rebuild Data, then press OK to close all windows.
  3. Choose OK to backup your company file.
  4. Once the rebuild's finished, hit OK.

 

If you're having the same problem, you can run our QuickBooks Tool Hub by downloading it. For further instructions, see this article: Fix common problems and errors with the QuickBooks Desktop Tool Hub.

 

You can also visit our QuickBooks Desktop Help page. Here you can find some topics and discussions to assist you in accomplishing some of your QuickBooks tasks.

 

I'll get back as soon as possible if you need further assistance. Have a great day.

View solution in original post

18 Comments 18
BigRedConsulting
Community Champion

How to adjust column order when entering Bills

Right click on the Bill table and choose Customize Columns.

Then change the column order and even the columns that appear to suit.

pkelly22
Level 2

How to adjust column order when entering Bills

Thank you. I'm not seeing that option when I right-click. Maybe I'm doing something wrong? Or maybe it's in a different version? I have QuickBooks Desktop Pro Plus 2022.

pkelly22
Level 2

How to adjust column order when entering Bills

Thank you. I'm not seeing that as an option when I right-click. Maybe I'm doing something wrong? Or perhaps I have a different version that doesn't have this option? I am using QuickBooks Desktop Pro Plus 2022.

Giovann_G
Moderator

How to adjust column order when entering Bills

Hello, pkelly22.

 

I'll go into more detail regarding changing the column's order when creating a bill in QuickBooks Desktop.

 

Depending on your preferences, you can change how the column is arranged. I'll show you how.

 

  1. Go to the Vendors menu, then select Enter Bills.
  2. Right-click on the bill table, then choose Customize Columns from the dropdown.
  3. Select the Customer: Job column on the Customize Columns - Enter Bills window.
  4. Click Move Up or Move Down to organize it.
  5. Once everything looks good, hit OK.

 

I'm also adding this article for future reference to guide you in paying bills: Pay bills in QuickBooks Desktop.

 

You're welcome to post again if you need further assistance adjusting columns when creating a bill. I'll be around to help you.

pkelly22
Level 2

How to adjust column order when entering Bills

Thank you. I appreciate your detailed response. However, I still do not see that as an option. See the screenshot attached of what my options are when I rightclick:

 

 

 

Giovann_G
Moderator

How to adjust column order when entering Bills

I appreciate you sharing the screenshot, pkelly22.

 

It's odd that it doesn't show up on your end even though I'm using the same QuickBooks version of yours. Let's run through some troubleshooting steps to see if this is a problem with your company file or the QuickBooks software.

 

Before we proceed, ensure you QuickBooks Desktop is updated to the latest release. This guarantees you have the most recent features and fixes. After that, you may run the Verify and Rebuilt data to fix any potential data problems that might be causing the system to behave in an unexpected way.

 

Here's how:

 

  1. Go to the File menu, then click Utilities.
  2. Choose Verify Data, then hit OK to close all windows. If you see “Your data has failed the integrity check” you need to rebuild your file. If there are no problems with your data, you’re done.

 

Rebuild data:

 

  1. Go to the File menu, then select Utilities.
  2. Click Rebuild Data, then press OK to close all windows.
  3. Choose OK to backup your company file.
  4. Once the rebuild's finished, hit OK.

 

If you're having the same problem, you can run our QuickBooks Tool Hub by downloading it. For further instructions, see this article: Fix common problems and errors with the QuickBooks Desktop Tool Hub.

 

You can also visit our QuickBooks Desktop Help page. Here you can find some topics and discussions to assist you in accomplishing some of your QuickBooks tasks.

 

I'll get back as soon as possible if you need further assistance. Have a great day.

pkelly22
Level 2

How to adjust column order when entering Bills

Thank you so much! I ran the Data as you outlined. I actually had to run the Rebuild Data twice as it fixed some of the errors the first time, but not all of them. When I ran it the second time, it fixed all errors and now the columns on the Enter Bill screen are back to how they originally were. I appreciate your help very much!

ZackE
Moderator

How to adjust column order when entering Bills

Thanks for following up with the Community, pkelly22.

 

I'm happy to hear Giovann_G was able to help you get your columns on the Enter Bill screen to display properly.

 

You'll also be able to find many detailed resources about using QuickBooks in our help article archives.

 

Please feel welcome to send a reply here or create a new thread if there's ever any questions. The Community's always here to help. Have a great day!

ScottTherrell
Level 1

How to adjust column order when entering Bills

I also began experiencing this issue a few days ago. I verified data twice and did rebuild data several times until all errors were resolved.

 

Problem still exists for me :(

 

Any other suggestions?

 

I am running Quickbooks Desktop: Premier Plus Contractors Edition 2022 with latest updates.

JonpriL
Moderator

How to adjust column order when entering Bills

Appreciate the time you've taken in sharing the results of your troubleshooting, @ScottTherrell.

 

I'm here to help make sure you're able to adjust the order of the columns while creating bills in QuickBooks Desktop.

 

Let's continue our troubleshooting steps since the issue persists even after following the suggestions above. I'll show you how.

 

  1. Close QuickBooks.
  2. Download the QuickBooks Tool hub.
  3. Open and install the downloaded file.
  4. On the QuickBooks Tool app, select Program Problems.
  5. Click Quick Fix my Program.

 

But if the steps above didn't make any changes to the problem currently raised, let's proceed to our next troubleshooting steps by following the steps below:

 

  1. Close QuickBooks.
  2. Go to Start.
  3. Select Control Panel.
  4. Under Program and Features, select Uninstall a Program.
  5. From the list of applications, select QuickBooks.
  6. Select Uninstall/Change.
  7. Click Repair.

 

Once done, restart your computer first before working again with QuickBooks. Then, right-click on the QuickBooks icon on your Desktop, select Run as Administrator, and open your company files accordingly.

 

You may also read this reference for other steps to follow to resolve problems that cause the QuickBooks desktop to stop working: Fix Issues to Stop QuickBooks from Freezing and Use the QuickBooks Tool Hub.

 

For now, I'm adding this article with the topics you can use while recording the common vendor transactions: The Vendor Transaction Workflows in QuickBooks Desktop.

 

I've got you covered if you have questions aside from working bills and bill templates in QuickBooks. Let me know by leaving a comment below using the Reply option and don't forget to include my name, @JonpriL. Take care always and stay safe!

BigRedConsulting
Community Champion

How to adjust column order when entering Bills

@pkelly22  RE: I'm not seeing that as an option when I right-click. Maybe I'm doing something wrong? Or perhaps I have a different version that doesn't have this option? I am using QuickBooks Desktop Pro Plus 2022.

@ScottTherrell 

 

I checked Premier 2022 and Enterprise 22.0 and only Enterprise seems to have the feature to customize columns.  I don't have Pro, but if Premier doesn't have it then Pro won't either.

ScottTherrell
Level 1

How to adjust column order when entering Bills

I tried both suggestions. Neither worked.

BigRedConsulting
Community Champion

How to adjust column order when entering Bills

@ScottTherrell 

It seems that only Enterprise has the feature, so if you don't have Enterprise, no amount of repairing or reinstalling will change anything.

pkelly22
Level 2

How to adjust column order when entering Bills

So after I said it worked for me, I went back and realized it had not worked. It was correct under the 'Expenses' tab, but not the 'Items' tab. It makes no sense that there is not a way to fix this, when it was not originally like this. We just logged in one day and it had changed order. 

ScottTherrell
Level 1

How to adjust column order when entering Bills

That's exactly what happened to me. When I did my my backup on Thursday, everything was normal. When I opened my company file on Friday morning, I immediately noticed the change when I began entering bills from my suppliers.

ScottTherrell
Level 1

How to adjust column order when entering Bills

Well, something changed it between Thursday afternoon and Friday morning. The question is how do I change it back.

SarahannC
Moderator

How to adjust column order when entering Bills

Hi pkelly22 and ScottTherrell,

 

I've tried checking this on my end and see no changes in the bill columns. The Customer:JOB appears before the Class column, as shown in the screenshot below.

 

Since it happened suddenly and you have been dealing with it for a couple of days and weeks, I'd advise contacting our Support Team if you've tried all the suggestions shared above. Our Team will investigate this matter and help us change it back to the old arrangement of the columns.

 

Here's how to contact them:

 

  1. Within your company file, go to the Help menu.
  2. Select QuickBooks Desktop Help and click Contact us.

 

We'll want to visit these articles for additional details about customizing fields and paying bills in QuickBooks Desktop (QBT):

 

 

Stay in touch and let us know how the call goes. The Community is always around if you have other concerns about form format and recording transactions in QuickBooks. 

ScottTherrell
Level 1

How to adjust column order when entering Bills

FYI Followup

 

I never was able to resolve the problem.

I just restored from my last good backup and reentered the missing transactions. It was only 3 days worth of transactions and took just a few hours.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us