cancel
Showing results for 
Search instead for 
Did you mean: 
Halphen
Level 1

Import payee name into QBO

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? 

4 Comments 4
Fiat Lux - ASIA
Level 15

Import payee name into QBO

Utilize a 3rd party app to do so. Export your data out to XLS, modify, and import them back into QBO

RefNumberBankAccountVendorPrintOnCheckNameTxnDateLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteToBePrintedCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101CheckingJoe's Coffee 01/10/2020 12 Main StreetSuite 102  AlbanyNY12345  N  General SuppliesGeneral Supplies85.21           
102CheckingCostco 01/10/2020 PO Box 1000   DallasTX28456  N  General SuppliesGeneral Supplies125           
103CheckingProperty Mgmt Assoc 01/10/2020 PO Box 1800   AlbanyNY12345 Mar 2011 RentN  RentRent1000           

 

https:// transactionpro.grsm.io/qbo

 

Catherine_B
QuickBooks Team

Import payee name into QBO

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:

 

  1. Open the client's company and click the Gear icon.
  2. Select Import data under the Tools section.
  3. Click Customers or Vendors
  4. Select Browse and open the Excel or CSV file of the customer list.
  5. Click Next and map the data from your fields to QuickBooks fields. Then, Next.
  6. Select Import. You'll receive a notification that import is successful.

After that, go to the Transactions or Banking menu to start categorizing multiple transactions to a Payee. Here's how:

 

  1. From the Transactions or Banking menu, click Banking.
  2. Select the bank where the transactions were imported. 
  3. Check all the transactions that have the same payee and category.
  4. Above the columns, click Update
  5. Select the correct Payee and Category.
  6. Click Apply and accept to add them to your register. 

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!

Halphen
Level 1

Import payee name into QBO

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. 

MarsStephanieL
QuickBooks Team

Import payee name into QBO

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.

 

  1. Go to the Settings or Gear icon, select Import data.
  2. Select the hyperlinked text Try this app on the Need to bring in sales receipts, invoices, and expenses? section.
  3. Select Get app now button after reviewing the app profile. Then, follow the on-screen instructions and confirm the subscription.
  4. You will be routed to the App page, select the New import tab to get a sample file format for the check.
  5. Choose if you want the simple format or the detailed one. Please check the screenshot below.


     
  6. When you open the excel file for the sample format, look for the Checks page tab at the bottom. This is how it looks like.

  7. Then edit the details and select the Browse file button in the New import tab.

 

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.

Need to get in touch?

Contact us