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 nowHello @kgarbeg.
I understand that it would be a big help for you to upload multiple checks from the spreadsheet to QuickBooks. However, this feature is not available in QuickBooks Online. What I can suggest is to use a third-party application.
You can use this article to know what are the integrated apps to QuickBooks Online: QuickBooks Apps.
I'd also encourage you to visit our QuickBooks Blog, so you'll get an update with our product improvements: QuickBooks Blog.
The Community is around the corner if you have more questions about QuickBooks. Have a good one.
You may utilize an importer tool
https:// transactionpro.grsm.io/qbo
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 | 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 | |||||||||||||||||||
103 | Checking | Property Mgmt Assoc | 01/10/2020 | PO Box 1800 | Albany | NY | 12345 | Mar 2011 Rent | N | Common Area Maintenance | Common Area Maintenance | 100 |
Would this also work for a deposit that has several hundred entries? I may only have 10 checks, but the line items for each check can be over a hundred. I make nearly the same deposit each month, and its very tedious.
Thank you.
Prepare the Deposits data with the following template and utilize the importer tool as I mentioned earlier
DepositToAccount | Location | Entity | LineDesc | LineAmount | Account | PaymentMethod | PaymentRefNumber | Class | CashBackAccount | CashBackAmount | CashBackMemo |
Checking | Robert | Deposit | 10 | Account1 | Cash | ||||||
Checking | Robert | Deposit | 20 | Account1 | Check | 12345 | |||||
Checking | Robert | Deposit | 30 | Account1 | Cash |
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.