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 |