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 nowHi userjim2,
.CSV file is the accepted file type in QuickBooks Online. Sure, you can import a CSV file from UPS into QuickBooks.
You just have to follow the formatting on the CSV files in Excel to get your transactions into QuickBooks.
For future reference, you can also visit our QuickBooks Articles hub to search for relevant topics. We have available resources that can guide you on whatever QuickBooks tasks you need to process.
Feel free to get back and post some more if you have additional questions. I'm always here to help.
Hi userjim2,
Hope you’re doing great. I wanted to see how everything is going about importing a CXV file from UPS to QBO you had yesterday.
Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.
Looking forward to your reply. Have a pleasant day ahead!
Hi and thanks for getting back with me. So, I'm trying to import a CSV file from UPS into QB online, is there a format template? If I go to "Settings" > "Import". I see templates for invoice, chart of accounts , bank data, do I use one of these or is there one for "bills"?
Prepare the 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 the trial period of an importer tool
https:// transactionpro.grsm.io/qbo
I'm happy to see you here again, @userjim2.
Let me chime in and provide some details about importing CSV files in QuickBooks Online.
If you mean you'll want to import bills in QuickBooks, currently, this feature is available in Canada and the UK versions. If you’re in the US, there isn't a direct way of importing bills into QuickBooks.
In this case, you may consider searching for third-party applications that you can integrate with QuickBooks. This way, you can import bills seamlessly.
I recommend you to visit the QuickBooks Apps site and look for an app that meets your business needs. You can also do this inside your company. You just have to select the Apps menu on the left panel and then enter a keyword in the search field.
For more details, check out the Apps that work with QuickBooks article.
Otherwise, you can also check out the answer provided by Fiat Lux - ASIA.
Furthermore, for future reference, I've added this article to help you how to track bills and record the payments: How to enter and pay bills.
If you have any questions with vendor transactions in QBO, please let me know by leaving a comment below. I’ll be right here to answer them. Stay safe and have a nice day.
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.