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 nowAt the beginning of the month, I regularly have to enter one or more deposits with several hundred line items. Why can't I use the batch transactions and a csv file to upload my transactions? It works for expenses, why not deposits? I'm trying to get my employer to approve using the Transaction Pro importer tool, but it doesn't seem like that's going to happen. Meanwhile, I have a $45k deposit with approximately 450 items that I will have to manually enter, again. I did create the spreadsheet, but no go on the importer tool.
Hopefully the powers that be at QB will read this and smack their heads that this hasn't already been done.
Thanks, done venting!!
Hi there, lbauer.
I appreciate you for providing detailed information with your concern.
Currently, there's no option to use a batch feature to enter deposits with several hundred line items in QuickBooks Online. Manually recording them is the way you can perform. Meanwhile, you can also use an app like the Transaction Pro importer tool that you've mentioned to help you do the things that you want to work on.
Then, once you manually entered transactions in QuickBooks Online, you can match them from downloaded entries to avoid duplicate data. Please click this article to see the process: Categorize and match online bank transactions in QuickBooks Online.
Please refer to this article to see how you can reconcile your accounts so they always match your bank and credit card statements to avoid discrepancies: Reconcile an account in QuickBooks Online.
Please let me know if there's anything I can help you with managing your bank transactions or other QuickBooks-related concerns. Take care and stay safe always.
You should utilize the importer tool
https://transactionpro.grsm.io/qbo
Prepare your Deposits data with the following template
RefNumber | TxnDate | PrivateNote | Currency | ExchangeRate | DepositToAccount | Location | Entity | LineDesc | LineAmount | Account | PaymentMethod | PaymentRefNumber | Class | CashBackAccount | CashBackAmount | CashBackMemo |
1 | 12/12/2020 | USD | Checking | Robert | Deposit | 10 | Account1 | Cash | ||||||||
1 | 12/12/2020 | USD | Checking | Robert | Deposit | 20 | Account1 | Check | 12345 | |||||||
1 | 12/12/2020 | USD | Checking | Robert | Deposit | 30 | Account1 | Cash |
That is an option, if I can get management to agree. It's a waiting game.
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.