Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Thanks for sharing the details with us, bbahara. I'll ensure you can import your CSV file data in QuickBooks Online (QBO).
QBO uses the 3-column or 4-column format in importing the CSV file. The 3-column have the Date, Description, and Amount of the transaction. While the 4-column have a Date, Description, and both Credit and Debit columns.
In your case, you'll still be able to import the transactions even if you have the Payee column instead of the Description column. You'll need to ensure you use the correct mapping. Although, if you want to change the header from Payee to Description, you can edit it thru Excel and then save it in CSV file format.
You can also check this article for more details about importing bank transactions using Excel CSV files: Import bank transactions using Excel CSV files.
I'll be adding these articles for future reference:
Do get back to me if there's anything else you need help with importing data to QuickBooks Online. I'm always here to back you. Have a wonderful day!
Good morning and thank you. My problem is I don't want the data in QBO transaction description, I want it as the payee. I'm not sure why I'd want to import a description and why I would not want to import the Payee/Vender.
Another way to say it is, on the screen below, I want a Quickbooks Online Field to be payee not description. I must be missing something because I don't understand who wouldn't want to import the payee of a transaction?
Thank you.
You can prepare Bill Payment data with the following template
RefNumber | APAccount | Vendor | TxnDate | Bank or CC Account | PrivateNote | Currency | ExchangeRate | ToBePrinted | BillApplyTo | LineAmount |
2001 | Staples | ######### | Checking | Bill Payment | N | 101 | 375.53 | |||
3454 | Green's Taxi Service | ######### | Checking | Bill Payment | N | 185 | 125.13 | |||
321901 | Federal Express | ######### | Checking | Bill Payment | N | 201 | 264.07 |
then use an importer tool to proceed
https://get.transactionpro.com/qbo
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