Hi, I have bank transactions downloaded from the bank into the Bank feeds. My client has over 1,000 checks that were written in the bank feeds. I have asked him to input into my spreadsheet the Payee name for each check that was written, the amount, and the date. Can I import the payee of these checks back into QBO only? I want QBO to recognize the Check number as well as the payee. Is this possible?
Utilize a 3rd party app to do so. Export your data out to XLS, modify, and import them back into QBO
|101||Checking||Joe's Coffee||01/10/2020||12 Main Street||Suite 102||Albany||NY||12345||N||General Supplies||General Supplies||85.21|
|102||Checking||Costco||01/10/2020||PO Box 1000||Dallas||TX||28456||N||General Supplies||General Supplies||125|
|103||Checking||Property Mgmt Assoc||01/10/2020||PO Box 1800||Albany||NY||12345||Mar 2011 Rent||N||Rent||Rent||1000|
I can walk you through in importing payees into QuickBooks, Halphen.
In addition to Fiat Lux - ASIA's answer, you can import customers or vendors list into QuickBooks and assign them to the bank downloaded transactions. The option to import customers or vendors list with check numbers and amounts is unavailable. You'll have to import the lists first, from there you can categorize the transaction and then select the payee.
I'll show you how to import Vendors or Customer list:
After that, go to the Transactions or Banking menu to start categorizing multiple transactions to a Payee. Here's how:
Do the same steps for the rest of the transactions. Added transactions are moved in the Categorized tab. If you mistakenly added a transaction, just click Undo under the ACTION column.
To help you manage your client's bank downloaded transactions and reconciling accounts, click these articles below:
You can always leave a reply below if there's anything else that you need help with. You stay safe!
Hi, I know how to import the vendor list. I was basically trying to import the checks so they will match to the bank feeds. I need something that will import this information:
Payee, Payment date, check no, category, amount, and memo. I also want to add that I have the 2qbo Convert Pro + PDF software.
Hi there, @Halphen.
Thank you for sharing what applications you have that may help us import your checks to QuickBooks Online (QBO).
If you're referring to the check transactions from your vendors, you can use the third-party app like SaasAnt Transactions to import the check into QBO directly. This is the suggested third-party app for importing different kinds of transactions for QBO. I'll guide you through the steps.
However, if you're referring to manually uploading your bank transactions back to QBO, you can check out this article: Manually upload transactions into QuickBooks Online.
I've also added this article for your future task when you're ready to reconcile your account: Learn the reconcile workflow in QuickBooks. This also includes topics such as fixing reconciliation issues in QBO.
Please don't hesitate to tag my name in the comment section below if you need further assistance or questions. I'd be glad to back you up. Take care.