Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHello everyone. When we import customer invoices via Batch Enter Transactions the top level Class field right below the menu and between Customer:Job and Template fields is not populating. The Class field populates just fine in the body of the Invoice. Any suggestions on how to fix this? Thank you.
Hello RRMANDO!
Thanks for reaching out to us and for the screenshot. Allow me to assist you in importing transactions.
When you enter transactions by batch in QuickBooks Desktop, this behavior about the class is normal. It'll be reflected in the class column and not in the header section. If needed, you can open the invoice to update the class.
You can check this link to learn more on how and what other data you can import and export: Import and export data in QuickBooks Desktop.
Also, here's the article if you need more help in tracking customer transactions: Get started with customer transaction workflows in QuickBooks Desktop.
You can reply to this thread if you need more assistance in importing data. Take care!
Thank you for the reply. So there is no way to import into the header section or force that header field to populate? We're importing hundreds of transactions. Some of the reports we run omit the invoice information if that header class is left empty. Thank you.
I appreciate your prompt reply, @RRMANDO. I'm here to share further details about populating the top-level class when importing invoices in QuickBooks Desktop (QBDT).
When you import transactions (i.e., invoices) to QBDT, the class info that will be included are per line items (column) and not in the header section. The option to import the class into the header section isn't an option.
QuickBooks displays reports based on a set of instructions. Information is extracted from the data file and shown as a set of transaction lines. With this, I'd recommend customizing your reports to focus on the data you need. To learn more about this, please refer to this article: Understand reports.
Also, to further guide you in organizing your cash flow, and tracking sales, receivables, and profitability more accurately in QBDT, I'd recommend checking out this article: Customer transaction workflows in QuickBooks Desktop.
Please keep me posted if you have other class concerns and questions about managing invoices in QBDT. Drop a comment below, and I'll gladly help. Take care, and I wish you continued success, @RRMANDO.
As another option, prepare the Invoice data with the following template including Class and Item Line Class
Customer | Transaction Date | RefNumber | PO Number | Terms | Class | Template Name | To Be Printed | Ship Date | BillTo Line1 | BillTo Line2 | BillTo Line3 | BillTo Line4 | BillTo City | BillTo State | BillTo PostalCode | BillTo Country | ShipTo Line1 | ShipTo Line2 | ShipTo Line3 | ShipTo Line4 | ShipTo City | ShipTo State | ShipTo PostalCode | ShipTo Country | Phone | Fax | Contact Name | First Name | Last Name | Rep | Due Date | Ship Method | Customer Message | Memo | Cust. Tax Code | Item | Quantity | Description | Price | Is Pending | Item Line Class | Service Date | FOB | Customer Acct No | Sales Tax Item | To Be E-Mailed | Other | Other1 | Other2 | Unit of Measure | AR Account | Currency | Exchange Rate | Sales Tax Code | |
Anne's Bakery | 01/09/2020 | 100 | Y | 15/09/2020 | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | (123) 456-7890 | Non | Cabinets | 10 | Cabinets | 1000 | Non | ||||||||||||||||||||||||||||||||
Anne's Bakery | 01/09/2020 | 100 | Y | 15/09/2020 | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | (123) 456-7890 | Non | Hardware | 10 | Hardware | 50 | Non | ||||||||||||||||||||||||||||||||
John's Barber Shope | 02/09/2020 | 101 | Y | 15/09/2020 | John's Barber Shope | 1 Main Street | Anytown | NY | 12345 | USA | John's Barber Shope | 1 Main Street | Anytown | NY | 12345 | USA | (999) 888-8888 | Non | Blueprints | 1 | Blueprints | 500 | Non | ||||||||||||||||||||||||||||||||
Main St Bank | 03/09/2020 | 102 | N | 16/09/2020 | Main St Bank | 1 State Street | Anytown | NY | 12345 | USA | Main St Bank | 1 State Street | Anytown | NY | 12345 | USA | (888) 888-8888 | Non | Door | 1 | Door | 300 | Non | ||||||||||||||||||||||||||||||||
Main St Bank | 03/09/2020 | 102 | N | 16/09/2020 | Main St Bank | 1 State Street | Anytown | NY | 12345 | USA | Main St Bank | 1 State Street | Anytown | NY | 12345 | USA | (888) 888-8888 | Non | Handles | 1 | Handle | 10 | Non | ||||||||||||||||||||||||||||||||
Main St Bank | 03/09/2020 | 102 | N | 16/09/2020 | Main St Bank | 1 State Street | Anytown | NY | 12345 | USA | Main St Bank | 1 State Street | Anytown | NY | 12345 | USA | (888) 888-8888 | Non | Hinges | 3 | Hinges | 5 | Non |
then utilize one of these importer tools
https://transactionpro.grsm.io/qbd
https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
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.