Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI have an accounts payable invoice that I have to manually enter over 100 items into. Is there a way to use the import functionality to import the expense detail into one invoice?
You can prepare your Bills data with the following template
| RefNumber | APAccount | Vendor | PrintOnCheckName | TxnDate | DueDate | SalesTerm | Location | AddressLine1 | AddressLine2 | AddressLine3 | AddressLine4 | AddressCity | AddressState | AddressPostalCode | AddressCountry | PrivateNote | Currency | ExchangeRate | ExpenseAccount | ExpenseDesc | ExpenseAmount | ExpenseBillableStatus | ExpenseBillableEntity | ExpenseClass | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineBillableStatus | LineBillableEntity | LineClass |
| 101 | Staples | ######### | 15/11/2020 | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | Office Supplies | For Anne | 25.1 | ||||||||||||||||||||
| 101 | Staples | ######### | 15/11/2020 | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | Telephone | Phone Cards | 50.25 | ||||||||||||||||||||
| 101 | Staples | ######### | 15/11/2020 | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | MP3 Player | Blue MP3 Player | 2 | 55 | |||||||||||||||||||
| 185 | Green's Taxi Service | ######### | Net 30 | 1 Main Street | San Diego | CA | 12345 | Transportation | 125.13 | |||||||||||||||||||||||
| 201 | Federal Express | ######### | Net 30 | PO Box 1800 | Dallas | TX | 23456 | Delivery Charges | tracking number 12345 | 25.15 | ||||||||||||||||||||||
| 201 | Federal Express | ######### | Net 30 | PO Box 1800 | Dallas | TX | 23456 | Delivery Charges | tracking number 12358 | 85.3 | ||||||||||||||||||||||
| 201 | Federal Express | ######### | Net 30 | PO Box 1800 | Dallas | TX | 23456 | Delivery Charges | tracking number 12387 | 65.12 | ||||||||||||||||||||||
| 201 | Federal Express | ######### | Net 30 | PO Box 1800 | Dallas | TX | 23456 | Delivery Charges | tracking number 12391 | 88.5 |
then utilize an importer tool to proceed
https://transactionpro.grsm.io/qbo
I'll help you import these expense details into QuickBooks, @RCoff.
The option to import bills with multiple line items is currently unavailable in the US version of QuickBooks Online (QBO). You may consider looking for a third-party application that can help import your bill transactions.
To find a third-party app, you can search the Apps menu for a keyword (bill importer). You might also want to go directly to our Apps Store and look for an app.
On the other hand, you can follow the steps that were shared by Fiat Lux - ASIA to import your bills into the program.
I can see the benefits of you having this option for your business. Thus, let me take note of this to improve your QuickBooks experience.
You can also send feedback to our product developers so they can review your suggestions. Here's how:
Moreover, you can track feature requests through the QuickBooks Online Feature Requests website.
You might also want to review all your vendor transactions in the future. You can go to the Expenses menu and select Vendors. Then, go to the Transactions List tab.
I'm still open to your replies, @RCoff. If you need further assistance importing transactions in QBO, just comment below or post again. Have a good one.
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