How to Record a Negative Deposit in QuickBooks Online & Desktop?

In QuickBooks, you can record a negative deposit via a journal entry and reset the negative balance to zero because you cannot deposit a negative value. A negative balance could be due to a refund issued to the customer, a refund case, or a correction or reversal of a transaction.

What is an Undeposited Funds Account?

Undeposited Funds Account in QuickBooks is a nominal account for the amounts of money collected but not yet banked. This facilitates the monitoring of outstanding deposits, ensuring that several payments are recorded in a single bank deposit entry as seen in the actual bank statement.

What is a Negative Deposit?

A negative deposit is a situation in which money has been withdrawn from an account or when a deposit amount must be changed because of a refund, reversal, or correction.

As you may note when using the ” Make Deposits ” option, depositing a negative amount to QuickBooks Online or Desktop is not possible. But there are ways to tackle situations where you have to record a negative deposit, for instance, refunds or adjustments.

If you receive a correction for service, you need to record it as a separate transaction. Once done, you can apply it to the Bill. It’s a very simple way to ensure your records are accurate and up-to-date in QuickBooks.

Here’s how you can manage it:

QuickBooks Online (QBO)

There are 3 methods to record a negative deposit issue in QuickBooks Online:

Method 1: Journal Entry

By making a reverse journal entry, this issue can be resolved:

1. To do this go to Gear Icon → Journal Entry.
2. If you want, off-set the account by debiting the bank account with the negative amount.
3. Charge the right income or clearing account.
4. Save the journal entry.

Method 2: Refund Receipt

This situation can also be resolved by filling a refund receipt:

1. Tab + New → Choose Refund Receipt.
2. Decide who the customer should be when requesting for a refund.
3. Punch-in the refund amount, but in this case as a credit amount, meaning a negative value.
4. Choose the bank account for refund.
5. Save the refund receipt.

Method 3: Clearing Account

A negative deposit issue can also be resolved by setting up a clearing account by following the below steps:

1. Set up a clearing account with the following details: Go into the program and select Settings → Chart of Accounts → Add New.
2. Select Bank Account, and for the Account name, use Clearing Account.
3. Record the negative deposit or refund, which is usually used in the clearing account, using a journal entry or payment.
4. Clear the clearing account as needed with another journal entry or transfer when necessary.

QuickBooks Desktop (QBD)

There are also 3 methods to record a negative deposit issue in QuickBooks Desktop:

Method 1: Journal Entry

Follow the steps to resolve the issue with a journal entry:

1. Then click on Companies then hit on Make General Journal Entries.
2. Decrease the bank account for the negative deposit amount.
3. Credit the appropriate income or clearing account.
4. Save the journal entry.

Method 2: Credit Memo

In QuickBooks Desktop, creating a credit memo will also resolve this issue:

1. Click on Customers in the navigation panel and then select Create Credit Memos/Refunds.
2. Choose the customer to whom you are willing to return the money.
3. If you’re collecting refunds, enter the details and the negative amount.
4. The correct account to use under the income account category is.
5. Preserve the credit memo and use it for the deposit.

Method 3: Clearing Account

Follow the below steps to resolve the issue using a clearing account:

1. Under lists select Chart of Accounts, then click on New to create a clearing account.
2. Go to Settings, follow by selecting Bank Account, and then label it as “Clearing Account”.
3. This should be done by preparing the journal entry, which reflects the refund or adjustment in the clearing account.
4. Use the clearing account to balance another transaction later. Therefore, do not clear the account.

These are logical instructions for documenting negative deposits in QBO and QBD, offered in a simple structure.

Record Negative Credit Card Batch Transactions in QuickBooks Desktop

Since the refund is larger than the amount in your undeposited account, you may need to create a Journal Entry in QuickBooks Desktop for Windows or Mac to offset the Undeposited Funds.

To record negative credit card batch transactions in QuickBooks Desktop, go to Company, select Make General Journal Entries, adjust the date, and enter the necessary details to offset Undeposited Funds.

Let’s see how:

Record Negative Deposits using Batch Enter Transactions in QuickBooks Desktop

QuickBooks Desktop (QBDT) won’t allow a negative total amount when recording transactions manually. However, you can use the Batch Enter Transactions option to enter negative amounts for credit card charges or credits.

To record negative deposits using Batch Enter Transactions in QuickBooks Desktop, go to Accountant, select Batch Enter Transactions, choose Checks, enter date, number, payee, and credit card details, and input the amount as positive. This will decrease both bank and credit card balances.

Below are the steps you must follow:

Note: This process will decrease both bank and credit card balances.

Record the Credit Card Charges in QuickBooks Desktop

Record credit card charges in QuickBooks Desktop, go to Banking, select Make Deposits, choose your Deposit To account and date, click Payments, review transactions, add the charge, and save.

Following the step-by-step information below:

Resolve Negative Entries from Undeposited Funds in QuickBooks Online

At times, negative value transactions show up in Undeposited Funds and appear on the Bank Deposit screen (for instance, if you issue a customer refund from Undeposited Funds). You can’t deposit a negative value entry by itself. The net deposit must be a value greater than or equal to zero. To resolve issues with negative transactions in Undeposited Funds, make a zero-value deposit and record the negative-value deposit with it.

How do you record negative entries from Undeposited Funds in QuickBooks Online? Create a journal entry with the Undeposited Funds and bank accounts, enter amounts in debit and credit columns, and then save. Next, use Bank Deposit to offset the negative value, ensuring the total is zero.

Part 1: Create a Journal Entry

Create a Journal Entry, click + New, select Journal Entry, enter the date, choose Undeposited Funds in the Debit column, select the bank account for the Credit column, then save and close.

Part 2: Offset the Negative Value

To offset the negative value, click + New, select Bank Deposit, add the payment and the Journal Entry ensuring the total is zero, then save and close.

Another Way to Record a Negative Deposit in QuickBooks Online

Record a negative deposit in QuickBooks Online, create a Journal Entry, set Undeposited Funds for Debits and a bank account for Credits, ensuring the amounts match the negative balance. Save and close.

Select Undeposited Funds and Bank Account

You can choose your undeposited funds and bank account as the source account of your journal entry to zero out the negative balance.

Here’s how:

Deposit the Journal Entry to Offset the Negative Credit Card Balance

How to Deposit the journal entry to offset the negative credit card balance, click + New, select Bank Deposit, choose the journal entry created, and then hit Save and Close.

How to Write a Check or Create an Expense Transaction?

You can write a check or create an expense transaction to record the money you take away or withdraw from your bank account.

To record money withdrawn from your bank account, click + New and select Check or Expense. Choose the bank account, enter details for the withdrawal amount, fees, and client payment, then save and close.

Below are the steps you’ve to follow:

In the Category detail section, type the following:

• 3331.63 (total amount of withdrawal), you can use an AR account (or any Income account used in the original transaction) since this transaction is for client CC refund.
• 1.04 for the credit card processing fees.
• – 25.00 (This is the total amount of your client’s payment ( $23.96 +Credit Card fee) for the service you rendered.)

Negative Credit Card Deposit in QuickBooks Accountant Online/ QuickBooks Payments

If you run into a scenario in which you actually have a negative deposit (a banking debit/withdrawal from your account) by your merchant services processor, you need to move the expected deposit from the Undeposited Funds account to your Bank Account via a journal entry.

This may happen in the event you have a large credit card refund that exceeds your new credit card sales on a particular day. Thus, you are required to match your downloaded payments with your QuickBooks transactions to resolve negative credit card deposits.

About the refund, record it as Check or Expense by do the following:

After this, link the refund to your customer’s credit or overpayment.

Adhere to these steps:

Conclusion!

In QuickBooks, when your bank balance shows negative, it’s usually a result of making payments or processing checks that contain a larger amount than the money you have in your checking account. In this case, you have to generate a report so that you can track all transactions associated with your financial institution.

If you have a large credit card refund that exceeds your new credit card sales on a particular day or if you have a negative deposit by your merchant services processor, you’re recommended to move the expected deposits from the Undeposited Funds account to the appropriate bank account via Journal Entry. Then, group it with the payments to create a $0 deposit and remove the payment from the Undeposited Funds account.

Frequently Asked Questions!

How Do I Record an Expense as Negative in QuickBooks?

To enter a negative expense in QuickBooks, you can use a journal entry or an expense transaction:

1. Journal Entry: Press the Gear Icon → Journal Entry, enter the negative figure in the expense account, and the amount in the corresponding account (for example, bank or accounts payable).

2. Expense Transaction: Record a refund or credit by clicking on + New → Expense → select the bank-account → in the expense-account field, type in the negative amount and press enter.

How to Rectify a Negative Balance in QuickBooks?

To fix a negative balance, you need to identify the cause of the discrepancy and make the necessary adjustments:

1. Check for errors: Compare recent transactions in order to see if there are double postings, errors, or perhaps outstanding deposits.

2. Record a deposit: Click on + New → Bank Deposit, and include the deposit or payment that has not recorded within the account.

3. Adjust via journal entry: Substitute Journal Entry to rectify the accounts that appear with a discrepancy (for instance, if the bank account needs to be credited then cast corresponding debits on an appropriate account).

4. Reconcile your accounts: With QuickBooks, it is best to match your bank account daily so as not to have negative balances in the future.

How Do You Record Insufficient Funds in QuickBooks?

To record insufficient funds (NSF checks) in QuickBooks:

1. Create a negative transaction: Click on the navigation bar: + New → Transactions → Bank Deposit; choose the bank account on the bottom line and, as a negative deposit, enter the NSF check amount.

2. Record the bounced check fee: Go to New + and select Expense → enter the type of bank account and put in the fee amount.

Apply the payment correctly: Make sure that the payment received from the customer is cleared from accounts receivable, or if required, make an adjustment entry of NSF that should be recorded as NSF. If necessary, change the customer balance and bank account.

Disclaimer: The information outlined above for “How to Record a Negative Deposit in QuickBooks Online & Desktop?” is applicable to all supported versions, including QuickBooks Desktop Pro, Premier, Accountant, and Enterprise. It is designed to work with operating systems such as Windows 7, 10, and 11, as well as macOS.