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

Batch entry of Transactions for Deposits

At 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!!

3 Comments 3
ChristieAnn
QuickBooks Team

Batch entry of Transactions for Deposits

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.

Fiat Lux - ASIA
Level 15

Batch entry of Transactions for Deposits

@lbauer 

You should utilize the importer tool

https://transactionpro.grsm.io/qbo

 

Prepare your Deposits data with the following template

RefNumberTxnDatePrivateNoteCurrencyExchangeRateDepositToAccountLocationEntityLineDescLineAmountAccountPaymentMethodPaymentRefNumberClassCashBackAccountCashBackAmountCashBackMemo
112/12/2020 USD Checking RobertDeposit 10Account1Cash     
112/12/2020 USD Checking RobertDeposit 20Account1Check12345    
112/12/2020 USD Checking RobertDeposit 30Account1Cash     
lbauer
Level 1

Batch entry of Transactions for Deposits

That is an option, if I can get management to agree.  It's a waiting game.

Need to get in touch?

Contact us