Skip to main content
December 6, 2021
Question

Can I edit my two opening deposits in my bank register to record the correct amount for each partner investment?

  • December 6, 2021
  • 2 replies
  • 0 views
Four partners, each invested 5000.00 to open our business bank account. My register shows after connecting, one deposit for 18,000.00 and one for 2000.00 totaling 20,000.00. I want to record in our Partner capital accounts each of us contributed 5000.00 as our initial investment. Can the bank deposits in the register be edited? How can this be done? Thank you

2 replies

December 7, 2021

Welcome back to the QuickBooks Community, res@finisroadrvp. I'll be providing information on how banking entries work in QuickBooks Online. Then, to ensure you'll be able to track investment transactions in the system so your account stays accurate.

 

The downloaded data in QuickBooks Online depends on what your bank shares with us and how they're posted online. That said, we're unable to edit the opening deposits from your financial institution showing on your Bank Feeds. However, you can exclude the deposits amounts in the For Review tab and manually track the investment amount in QuickBooks to properly divide the twenty thousand into different partners.

 

Here's how to exclude the transactions:

 

  1. Go to the Banking menu and choose the Banking section.
  2. Choose an account.
  3. Go to the For Review tab.
  4. Put a checkmark beside the transactions you want to exclude.
  5. Then, click the Exclude button.

 

Once done, you can now start setting up accounts to track money that your partners or owners invest or draw from a business. To begin with, you'll have to set up an owner or partner as a vendor.

 

Follow these steps:

 

  1. Go to the Expenses menu and choose the Vendors tab.
  2. Select the New Vendor button.
  3. Fill out the form and click Save.

 

After that, you'll need to set up their owner or partner equity account. These accounts let you view what someone invests and makes from a business. You may open this article to see the details on how to perform the steps and to finish the process: Add an owner or partner to your books.

 

You can refer to this article to view details on how you can reconcile your accounts so they always match your bank/credit card statements to avoid discrepancies: Reconcile an account in QuickBooks Online.

 

Don't hesitate to reply below if you have a further concern about recording transactions or any other questions related to QuickBooks. I',m always here to help.

KimMcCPA
December 7, 2021

The previous answer is correct for the debit side, because that would need to stay matching what came in on the bank feeds (the two deposits for $18,000 and $2,000).

 

However, if you're talking about editing the credit side of the transaction, it looks like you may be able to. 

In the bank register, click on the first transaction

Select Edit

Make a note of the deposit total.

To keep it clean, I would enter the original coding with a negative amount.

In description on that same line, enter something like "split of initial OE amounts"

Then enter four more lines to split that amount to each of the Owner's Equity accounts.

Owners should be set up as vendors, as the first field is "received from."

Verify that your transaction still has the same total.

Save and close, and then do similar for the second deposit.

Save and close, then run a Balance Sheet to see if you have your expected result.