cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
kenzierae
Level 2

Bulk Entry - Class

Good Morning, 

 

I am using the “bulk enter transactions” feature to enter bills, and using the class column to apply them to a class. However, the class is only being applied to the account line item and not the whole transaction. Therefore, when I run reports and filter using class it’s not pulling up. Is there a way to get the class to apply to the whole transaction in bulk entry? 

IMG_6023.jpeg

2 Comments 2
Chrea
Level 7

Bulk Entry - Class

You can prepare your bills data with the following template

 

VendorTransaction DateRefNumberBill DueTermsMemoAddress Line1Address Line2Address Line3Address Line4Address CityAddress StateAddress PostalCodeAddress CountryVendor Acct NoExpenses AccountExpenses AmountExpenses MemoExpenses ClassExpenses CustomerExpenses BillableItems ItemItems QtyItems DescriptionItems CostItems ClassItems CustomerItems BillableUnit of MeasureAP AccountCurrencyExchange Rate
Bell Telephone01/09/2020123#########Net 30Office TelephoneBell Telephone1 Main Street  NewtonNY12345USA Telephone1000Sales Line              
Bell Telephone01/09/2020123#########Net 30Office TelephoneBell Telephone1 Main Street  NewtonNY12345USA Telephone500Service Line              
Ajax Lumber01/09/2020400#########Net 30RepairsAjax Lumber200 Smith Street  AnytownNY11111USA Repairs750Front Door              
Green Taxi Company01/09/2020500#########Net 30Taxi to AirportGreen Taxi Company1 North Street  AnytownNY11111USA       Part 11Part #120  N    
Green Taxi Company01/09/2020500#########Net 30Taxi to AirportGreen Taxi Company1 North Street  AnytownNY11111USA Travel25VT Trip ABC CompanyY           
Green Taxi Company01/09/2020500#########Net 30Taxi to AirportGreen Taxi Company1 North Street  AnytownNY11111USA Travel25CA Trip DEF CompanyN           
Green Taxi Company01/09/2020500#########Net 30Taxi to AirportGreen Taxi Company1 North Street  AnytownNY11111USA Travel25FL Trip              

 

then use an importer tool to proceed. It's a $199 one time license and you can get a free license through a reseller. T&C apply.

https://get.transactionpro.com/qbd

 

JanbonN
QuickBooks Team

Bulk Entry - Class

Hello there, Ken. Classes to be added to the Batch Enter Transaction feature are only available at the transaction entry level. I'm here to provide further details about this.

 

The ability to automatically apply a class to all of your entries is not available, you'll have to manually choose the class per transaction. Please refer to this article for more details: Set up and use class tracking in QuickBooks Desktop.

 

That said, I recommend sending feedback to our product engineers for them to analyze and consider adding this for future updates.

 

Here's how to send your request:

 

  1. Go to Help, select Send Feedback Online, and choose Product Suggestion.
  2. Type in your request in the Here is my suggestion field.
  3. Fill in the necessary details.
  4. Once done, click Send Feedback.

 

For now, you can utilize the Split feature to assign a single class to a transaction that includes multiple line items. However, please be aware that this process requires manual selection of the class for each individual line item.

 

Additionally, you can run and customize vendor reports to see where your company stands, in terms of expenses and accounts payable.

 

The Community is available 24/7 to help you if you have other questions about Quickbooks, Ken. Have a great day ahead.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up