Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
L
lbauer
January 12, 2021
Question

Batch entry of Transactions for Deposits

  • January 12, 2021
  • 3 replies
  • 34 views

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 replies

    C
    ChristieAnn 11
    Level 9
    January 12, 2021

    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
    Fiat Lux - ASIA
    Level 14
    January 12, 2021

    @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     
    L
    lbauerAuthor
    January 13, 2021

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

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement