Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore Intuit QuickBooks Workforce
Havabrew
Level 1

Update supplier bill locations via import

Afternoon

New to QBs so maybe missing the obvious but..

I would like to export a list of supplier bills filtered by date and account that they have been processed against and then update the locations before importing back into QB.

I've tried reclassifying but the volume is a little onerous..

 

Thank you

1 Comment 1
Rusimyhr
QuickBooks Team

Update supplier bill locations via import

Hi there, Havabrew. You’re already on the right track by using the Reclassify transactions tool. There is no need for an export-edit-import process to update existing transactions. In fact, reimporting a CSV of existing bills would create duplicates rather than updating the originals.
 
To make the bulk editing much easier, you just need to use the right filters. Here’s how:
 
  1. In your Reclassify transactions tab, change your Account types to Profit and Loss.
  2. Select the specific Account from the left-hand list where the bills were originally processed.
  3. Change the Date range to cover the period of the bills you need to update.
  4. Set the Type filter to Bills. You can also filter by Customer/Supplier name to narrow down the list even further.
  5. Click Find transactions.                     reclassify1.png           
     
  6. Click the checkbox beside the Date column to automatically select all bills on the page.
  7. Click the Reclassify button, choose your new Location, and hit Apply to save changes.
 
Also, if you have hundreds of bills, click the small gear icon directly above the transaction list and change the rows per page to 300.                                          reclassify2.png    
 
I’ll keep an eye on this thread if you have additional questions or concerns.
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us