- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Import check number and payee
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
I'm here to help import your check number and payee in QuickBooks Online (QBO), fslivestockmarke.
You need to use the CSV file to import transactions in QBO. Please refer to this link for instructions: Format CSV files in Excel to get bank transactions into QuickBooks.
Once the file is ready, you can start importing them to QuickBooks. Let me show you how:
- Go to the Banking menu, then select Upload from file.
- Click Browse and choose the .CSV file.
- Select Open, then select Next.
- Choose the account from the QuickBooks Account drop-down, then select Next.
- Select a Date and a date format.
- Select the Description and Amount statement fields.
- When you are ready, click Next.
- All transactions in your .CSV file will show. If you'd like to exclude transactions, clear the checkbox next to date, then click Next.
- Select Yes to import now, then select Let's go!
Now that your transactions are in QuickBooks, it's time to match and categorize them. The transactions go into your accounts after you review them.
Stay in touch with me if there's anything else I can help you with importing checks to QuickBooks. I'm always right here to help you.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
Prepare the Checks data with the following template
| RefNumber | BankAccount | Vendor | PrintOnCheckName | TxnDate | Location | AddressLine1 | AddressLine2 | AddressLine3 | AddressLine4 | AddressCity | AddressState | AddressPostalCode | AddressCountry | PrivateNote | ToBePrinted | Currency | ExchangeRate | ExpenseAccount | ExpenseDesc | ExpenseAmount | ExpenseBillableStatus | ExpenseBillableEntity | ExpenseClass | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineBillableStatus | LineBillableEntity | LineClass |
| 101 | Checking | Joe's Coffee | ######### | 12 Main Street | Suite 102 | Albany | NY | 12345 | N | General Supplies | General Supplies | 85.21 | |||||||||||||||||||
| 102 | Checking | Costco | ######### | PO Box 1000 | Dallas | TX | 28456 | N | General Supplies | General Supplies | 125 | ||||||||||||||||||||
| 103 | Checking | Property Mgmt Assoc | ######### | PO Box 1800 | Albany | NY | 12345 | Mar 2011 Rent | N | Rent | Rent | 1000 |
then utilize an importer tool
https:// transactionpro.grsm.io/qbo
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
This process does not import the check number. It will only import the date, amount and description fields. Is there a way to also get the check number uploaded?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
Let me share with you a few details about importing, jaramillo.
For now, you're unable to import check numbers in QuickBooks Online (QBO). You'll want to use a third-party application or manually enter the check number in your QBO account.
However, if you decide to use another application that you can integrate with QuickBooks, you'll want to search them on the hyperlink I've provided above and check out its reviews and ratings. For more questions about importing data, go through this article: Common Questions About Importing Data To QuickBooks Online.
After you have entered and written checks, you'll want to match the downloaded entry to what you've entered in QBO. To give you more information about the process, check this article: Categorize and match online bank transactions in QuickBooks Online.
Please touch base with us if you need anything else with importing data. The Community is always here to help you 24/7.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
If you are using the importer tool as I mentioned earlier, you can put your check number in the Ref number field.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
I did this but my description has employee numbers next to the employee name in the description. QB removes them. I have tried several formats and it only imports the name.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
My description has employee numbers in it. QB will not import them!!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
Is there a fee to use the 3rd party importer?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
Hey there, @Kelly26.
Thanks for chiming in on this thread.
Depending on which third party importer you use will determine if there is a fee to use it. I recommend looking on the third party's website or plans and pricing.
I hope this answers your question. I'm only a reply away if you need me again. Bye for now!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
Yes. You can check this one. If you are using QB Desktop, you can purchase a $199 one time license. You can get $100 cashback to purchase thru a partner.
https://get.transactionpro.com/qbo