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?
You can prepare your bills data with the following template
Vendor | Transaction Date | RefNumber | Bill Due | Terms | Memo | Address Line1 | Address Line2 | Address Line3 | Address Line4 | Address City | Address State | Address PostalCode | Address Country | Vendor Acct No | Expenses Account | Expenses Amount | Expenses Memo | Expenses Class | Expenses Customer | Expenses Billable | Items Item | Items Qty | Items Description | Items Cost | Items Class | Items Customer | Items Billable | Unit of Measure | AP Account | Currency | Exchange Rate |
Bell Telephone | 01/09/2020 | 123 | ######### | Net 30 | Office Telephone | Bell Telephone | 1 Main Street | Newton | NY | 12345 | USA | Telephone | 1000 | Sales Line | |||||||||||||||||
Bell Telephone | 01/09/2020 | 123 | ######### | Net 30 | Office Telephone | Bell Telephone | 1 Main Street | Newton | NY | 12345 | USA | Telephone | 500 | Service Line | |||||||||||||||||
Ajax Lumber | 01/09/2020 | 400 | ######### | Net 30 | Repairs | Ajax Lumber | 200 Smith Street | Anytown | NY | 11111 | USA | Repairs | 750 | Front Door | |||||||||||||||||
Green Taxi Company | 01/09/2020 | 500 | ######### | Net 30 | Taxi to Airport | Green Taxi Company | 1 North Street | Anytown | NY | 11111 | USA | Part 1 | 1 | Part #1 | 20 | N | |||||||||||||||
Green Taxi Company | 01/09/2020 | 500 | ######### | Net 30 | Taxi to Airport | Green Taxi Company | 1 North Street | Anytown | NY | 11111 | USA | Travel | 25 | VT Trip | ABC Company | Y | |||||||||||||||
Green Taxi Company | 01/09/2020 | 500 | ######### | Net 30 | Taxi to Airport | Green Taxi Company | 1 North Street | Anytown | NY | 11111 | USA | Travel | 25 | CA Trip | DEF Company | N | |||||||||||||||
Green Taxi Company | 01/09/2020 | 500 | ######### | Net 30 | Taxi to Airport | Green Taxi Company | 1 North Street | Anytown | NY | 11111 | USA | Travel | 25 | FL 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
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here