Skip to main content
L
lfinn1
February 24, 2025
Question

How to Break Down a single Batch Deposit into Multiple Transactions

  • February 24, 2025
  • 1 reply
  • 0 views

Hi, I'm using QB Enterprise Desktop. We receive multiple direct deposits from the same company into our bank account that I manually enter into OB. Is there a way of recording a batch deposit, but then breaking it down into multiple transactions for reconciliation purposes? It's just very tiring to enter one deposit, click "Save & New," and then have to change the date and memo again to enter the next transaction, and then repeat the process 4-5 times. But if I do it as one deposit, it makes reconciling very difficult since they're individual transactions in our bank account. Also, there is not an invoice or bill that these deposits are attached to in QB. Thanks!

1 reply

Clark_B
Clark_B
February 24, 2025

Yes, there's a method to streamline this process, @lfinn1. However, this method applies only when importing your transactions from Excel or .CSV files via the accountant menu. Allow me to guide you through it.

 

To start, please note that the option to enter transactions by batch is unavailable in QuickBooks Desktop Enterprise, as this feature is exclusively found in QuickBooks Desktop Accountant. As an alternative, you can request your accountant to import your batch transactions on your behalf. Also, make sure that you create a backup file of your company to protect your data from any unexpected issues before proceeding with the steps below.

 

To enter your transactions in batches, here’s how:

 

  1. Navigate to the Accountant menu and select Batch Enter Transactions.
  2. Choose Deposits as the Transaction Type and select the appropriate Account. 
  3. Open the spreadsheet that contains the transactions you want to record in QBDT. Make sure the columns in your spreadsheet align with the order of the columns in the Batch Enter Transactions window.
  4. Highlight the relevant information in your spreadsheet, right-click, and select Copy.
  5. In the Batch Enter Transactions window, right-click on the first date field and choose Paste.
    • Note: Items will appear in red if they are not currently in the company file. For any red-highlighted items, select them and click Quick Add or Set Up.
  6. Click Save Transactions, then confirm by selecting Yes on the Confirm Account screen.
  7. A window displays the number of transactions saved. Select OK to finish the import.

 

For more detailed information, check this article: Enter transactions by batch in QBDT.

 

Moreover, you can refer to this article on reconciling your accounts to ensure they consistently match your bank and credit card statements: Reconcile an account in QBDT. This guide provides step-by-step instructions to help maintain accurate financial records.

 

My top priority is assisting you in breaking down your batch deposit into multiple transactions. If you need additional assistance, please leave a comment below. I'm here to support you and will respond promptly.

L
lfinn1Author
February 24, 2025

Thank you for you help, but I do not have the Accountant tab. Is it located somewhere else?

S
Shania_C
February 24, 2025

Thanks for getting back here in the Community, @lfinn1.

 

Currently, QuickBooks Desktop Enterprise does not support breaking down a single batch deposit into multiple transactions. Additionally, the reason why you don't have the option to the Accountant tab as this is exclusive to the accountant version of QuickBooks Desktop. 

 

As an alternative solution, you can have your accountant handle the entry of batch transactions for you. Here's how:

 

  1. Navigate to the Accountant menu and select Batch Enter Transactions.
  2. Use the Transaction Type drop-down to select the type of transaction you wish to enter. QuickBooks supports multiple transaction types across all versions, including Checks, Deposits, Credit Card Charges or Credits, Invoices, Credit Memos, Bills, and Bill Credits.
  3. Select the appropriate bank, credit card, AR (Accounts Receivable), or AP (Accounts Payable) account from the drop-down menu. Select Add New to set up a new account.
  4. Open the spreadsheet that contains the transaction data you want to import into QuickBooks.
  5. Adjust the columns in your spreadsheet so that they align with the column order on the QuickBooks Batch Enter Transactions screen.
  6. Highlight the relevant transaction data in your spreadsheet, right-click, and choose Copy.
  7. Move to the QuickBooks Batch Enter Transactions screen, right-click on the first date field in the list, and select Paste.
  8. Review the data displayed on the Batch Enter Transactions screen to ensure accuracy.
  9. Proceed to add all necessary transactions.
  10. Click on Save Transactions, then confirm by selecting Yes to save the data.
  11. A notification window will appear to confirm the number of transactions successfully saved. Click OK to finalize the import.


Note: While QuickBooks does not support exporting batch transactions, you can copy multiple transactions from one company file to another, using them in conjunction with the enter batch transactions feature.

 

For more detailed information, you can check this article: Accountant tools: Batch enter transactions.

 

Additionally, after reconciling, you can choose Display to view the reconciliation report or Print to print it. You can find detailed information in this article: Reconcile an account in QuickBooks Desktop.

 

Moreover, for more information on the reconciliation process and to explore the reports you can generate in QuickBooks, please visit the following link: Fix issues when you're reconciling in QuickBooks Desktop.

 

Please let me know if you have further questions or concerns about managing your transactions in QuickBooks Desktop. The Community is always ready to circle back. Have a safe weekend ahead!

Terms & ConditionsAccessibility statement