cancel
Showing results for 
Search instead for 
Did you mean: 
blueview1901
Level 3

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

I have a notary signing service with notaries all over the country. Title companies pay me to have my notaries do real estate closings for them. I also, personally do real estate closings for those same title companies. Signing service payments are tied to a specifice invoice. Personal signings are not invoice driven. Usually I receive separate checks for personal signings and signing service signings. Occasionally the payments are combined. How do I record them when the payments are combined?
Solved
Best answer October 28, 2024

Best Answers
ShyMae
QuickBooks Team

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

I appreciate you sharing additional information. I truly understand how valuable your time and efforts are. I'm here to help record these transactions. Consider me your partner in this, @blueview1901.

 

In your case, we can create a bank deposit with the total amount of each invoice and split it when we use the Receive Payment feature. Make sure to select the Accounts Receivable as the account.

Here is the step-by-step guide: 

 

  1. Click +New. Select Bank Deposit.
  2. Head to the Add funds to this deposit section. Pick your preferred customer.
  3. Choose Accounts Receivable in the Account dropdown.
  4. Enter the amount. Once done, hit Save and close.

 

Please see the attached screenshot for a visual guide.

 

Sample.PNG


Now, let's open one associated invoice.

 

  1. Hover to the Sales menu. Locate only one invoice included.
  2. Press Receive payment.
  3. In the Outstanding Transactions area, tick all the entries needed.
  4. Save and close.

 

Sample.PNG


For future reference, you can set up automatic invoice reminders, which saves you the hassle of manually tracking due dates. Check out this article on how to set this up: Send invoice reminders automatically.

 

I appreciate all the efforts you've already put in. I'm here to assist you every step of the way, so tell me how it goes after following the steps above. I hope everything goes well, @blueview1901!

View solution in original post

MAnneJ
QuickBooks Team

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

Thank you for clearing things up, @blueview1901Let me help you with this.

 

Once you have created the 2 invoice transactions for the $125 and $150 amounts, follow the initial steps for creating a bank deposit provided by my colleague above.

 

After this, instead of splitting the bank deposit into three, put a checkmark on the two Signing Service invoice transactions. You can create a line item for the Personal Signings that were not invoiced. Overall, doing this will help us accurately record these transactions and clear the $400 amount.

 

Here's how to add the fee as a line item:

 

  1. Go to the + New icon and select Receive Payment.
  2. Select the same customer.
  3. In the Outstanding Transactions section, put a checkmark on the two invoices.
  4. In the Add funds to this deposit, fill in the necessary details as well as the service fee amount of $125 in the Amount column.
  5. In the Credits section, select the Deposit amounting to $400.

 

Additionally, you might want to visit this article and learn how to personalize and add specific info to your sales forms: Customize invoices, estimates, and sales receipts in QuickBooks Online. 

 

I'm here to assist you if you need additional assistance with managing your invoices in QBO. Have a great day ahead! 

View solution in original post

15 Comments 15
Tori B
QuickBooks Team

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

Good morning, @blueview1901.

 

How's your day going so far? I hope all is well. 

 

You can certainly split a single deposit from a customer in QuickBooks Online. I'm including some steps to help walk you through the process below. 

 

  1. Go to Sales, then click on Invoices.
  2. Find the invoice to which you want to deposit, then hit Edit.
  3. Enter the amount in the Deposit field.
  4. From the Deposit to dropdown menu, choose Payments to deposit or Undeposited funds.
    Note: If you select a bank account, it won’t show up on your deposit detail report. The deposit detail report only shows deposit transactions and payments deposited directly to the bank.
  5. Tap on Save and close.

 

That should do the trick. For additional information, check out Add a Deposit to an Invoice in QuickBooks Online

 

I also wanted to mention our new QuickBooks Live Expert Assisted Bookkeeping. Here you can find help with tricky accounting questions to make the bookkeeping process a breeze. Our team of experts can help with common issues such as: 

 

  • What accounts you should add in QuickBooks
  • What categories you should categorize your transactions
  • Troubleshoot and resolve other bookkeeping errors

 

Please know I'm here if you have further questions or concerns. Don't hesitate to reach back out. Have a good one! 

blueview1901
Level 3

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

Good morning, thank you but that doesn't help. Here us the scenario. 1 customer check payment $400. One invoice $125. 2nd invoice $150. 3rd item is a non-invoiced item of $125 for service, tota; $400.

When I go to SALES>INVOICE>EDIT there is NOTHING THERE about DEPOSIT.

ShyMae
QuickBooks Team

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

I appreciate you sharing additional information. I truly understand how valuable your time and efforts are. I'm here to help record these transactions. Consider me your partner in this, @blueview1901.

 

In your case, we can create a bank deposit with the total amount of each invoice and split it when we use the Receive Payment feature. Make sure to select the Accounts Receivable as the account.

Here is the step-by-step guide: 

 

  1. Click +New. Select Bank Deposit.
  2. Head to the Add funds to this deposit section. Pick your preferred customer.
  3. Choose Accounts Receivable in the Account dropdown.
  4. Enter the amount. Once done, hit Save and close.

 

Please see the attached screenshot for a visual guide.

 

Sample.PNG


Now, let's open one associated invoice.

 

  1. Hover to the Sales menu. Locate only one invoice included.
  2. Press Receive payment.
  3. In the Outstanding Transactions area, tick all the entries needed.
  4. Save and close.

 

Sample.PNG


For future reference, you can set up automatic invoice reminders, which saves you the hassle of manually tracking due dates. Check out this article on how to set this up: Send invoice reminders automatically.

 

I appreciate all the efforts you've already put in. I'm here to assist you every step of the way, so tell me how it goes after following the steps above. I hope everything goes well, @blueview1901!

blueview1901
Level 3

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

THANK YOU THANK THANK YOU! That solves my problem!

Ethel_A
QuickBooks Team

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

I'm glad to know that the resolution provided by my colleague was able to help you resolve the issue you had with splitting a transaction, @blueview1901.

 

For future reference, you can read this article to help you reconcile your accounts in QuickBooks Online: Reconcile an account in QuickBooks Online.

 

Don't hesitate to click the Reply button below if you have other concerns with managing bank transactions in QuickBooks Online. The Community is always here to help. Have a great day.

blueview1901
Level 3

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

Greetings, stumped again. The first part of your answer, still works. The second part of your answer, QBO seems to have "changed."

 

Now, let's open one associated invoice.DONE

 

Hover to the Sales menu. Locate only one invoice included.DONE
Press Receive payment.DONE
In the Outstanding Transactions area, tick all the entries needed. DOES NOT EXIS
Save and close.

blueview1901
Level 3

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

Please allow me to correct my most recent comment

 When I do steps 1-4 it deposits my $250 check is deposited as follows:

$125 in SIGNING SERVICE BANK to account AR as directed

$125 in SIGNING SERVICE BANK to a different account

Total Deposit $250

 

When I do the subsequent steps, SALES>INVOICE>SPECIFICE INVOICE>RECEIEVE PAYMENT>OUTSTANDING TRANSACTIONS>SAVE AND CLOSE

 

I now have a $250 Deposit in SIGNING SERVICE BANK and a $125 deposit in SIGNING SERVICE BANK for a total deposit of $375 but I only deposited $250?

 

Am I missing something?

 

Candice C
QuickBooks Team

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

Hey, @blueview1901

 

Thanks for coming back and asking some additional questions. 

 

To clarify a few things, can you provide us with a screenshot of both of them? 

 

We want to ensure you get this taken care of as soon as possible. I'll be waiting for your response! 

blueview1901
Level 3

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

Here is first shot

blueview1901
Level 3

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

Here is 2nd

CarlSJ
QuickBooks Team

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

I appreciate you returning to this thread and providing us screenshots, @blueview1901. I'll outline the step-by-step process for splitting a single deposit into invoiced and non-invoiced revenue.

 

Once you've created invoices for the two transactions amounting to ($125 and $150), we can proceed with redoing the changes you've made and editing the current bank deposit. This time, let's ensure to include line items for the invoiced and non-invoiced amounting to $400 and associate it with the same customer:

 

  1. Go to the Magnifying glass icon.
  2. Search and open the deposit you've created.
  3. On the first line, select the Accounts Receivable (A/R) in the Account column and set the amount to $275.
  4. Select the same customer you choose when creating invoices in the Received From dropdown.
  5. On the second line, select the appropriate category you used to track the service income, then set the amount to $125.
  6. Click Save and Close.

 

Once done, let's link the deposit to the invoices to mark them as paid:

 

  1. Go to the + New icon and select Receive Payment.
  2. Select the same customer.
  3. In the Outstanding Transactions section, put a checkmark on the two invoices.
  4. In the Credits section, select the Deposit amounting to $275.
  5. Once done, click Save and Close.

 

Moreover, you can run financial reports in QBO and get an overview of your business performance.

 

Please comment below if you need further assistance splitting a single deposit into different sales transactions. Have a productive day.

blueview1901
Level 3

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

Please allow me to clarify. There are NOT 3 invoices. SIGNING SERVICE is when I hire other notaries to do the work I invoice the title company with a QBO invoice.. PERSONAL SIGNINGS, ones I do myself for title companies, are NOT invoiced in  QBO

Invariably, title companies will pay me on the same check for a SIGNING SERVICE invoiced transaction and a PERSONAL SIGNING non-invoiced transaction. How on the Good Lords Green Earth do I record it so the invoice can reflect as paid?

MAnneJ
QuickBooks Team

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

Thank you for clearing things up, @blueview1901Let me help you with this.

 

Once you have created the 2 invoice transactions for the $125 and $150 amounts, follow the initial steps for creating a bank deposit provided by my colleague above.

 

After this, instead of splitting the bank deposit into three, put a checkmark on the two Signing Service invoice transactions. You can create a line item for the Personal Signings that were not invoiced. Overall, doing this will help us accurately record these transactions and clear the $400 amount.

 

Here's how to add the fee as a line item:

 

  1. Go to the + New icon and select Receive Payment.
  2. Select the same customer.
  3. In the Outstanding Transactions section, put a checkmark on the two invoices.
  4. In the Add funds to this deposit, fill in the necessary details as well as the service fee amount of $125 in the Amount column.
  5. In the Credits section, select the Deposit amounting to $400.

 

Additionally, you might want to visit this article and learn how to personalize and add specific info to your sales forms: Customize invoices, estimates, and sales receipts in QuickBooks Online. 

 

I'm here to assist you if you need additional assistance with managing your invoices in QBO. Have a great day ahead! 

blueview1901
Level 3

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

Thank you very much for your assistance. That worked and I've got it now. My other remaining problem lies wit QB because mwhen I enter a BANK DEPOSIT and enter the check # as the reference #, you cannot search and find that transaction searching for the reference #. QB says that reference # cannot be found. When I enter the check # in the reference # spot for receiving payment for an invoice you can find it every time.

 

QB is SUPPOSEDLY been working on this for several months, but still, no solution, updates, or anything. It's MADDENING. If you put a number in the REFERENCE of ANY transaction you should be able to search for it and find it! What good is the reference # if you cannot search and find it?

Kurt_M
QuickBooks Team

How to split a single deposit from a customer into invoiced revenue and non invoiced revenue?

We'll provide more details about how the Search feature works inside QuickBooks Online (QBO) and track all your recordings accurately, @blueview1901.

 

The Search feature tracks transactions like invoices, sale receipts, bank deposits, and other transactions in your company file. Thus, tracking bank deposits using specific details like reference numbers added in the Add funds to this deposit section isn't possible. You'll need to manually search the transaction and access it to review information on your recordings.

 

As a workaround, you can consider generating the Deposit Detail report and filter it to show the data that you need for your business. We'll outline the steps to get you going:

 

  1. Access your QuickBooks Online company.
  2. On the left navigational bar, click the Reports tab.
  3. In the Search bar, enter Deposit Detail. Click on the result.
  4. Select or add a specific reporting period. Edit the filters to tailor it to your business needs.
  5. Once you're ready, click the Run report button.

 

If you wish to add more details or specification to the report, refer to this page: Customize reports in QuickBooks Online.

 

You can also enter Sales receipts whenever you render personal signing services to your customers instead of adding it as a line item in the Add funds to this deposit section. Doing this will help you track personal signing income right away.

 

In case you wish to send a feature request to improve the Search feature inside the program, feel free to check this page for further guidelines: How do I submit feedback?

 

Moreover, here are some articles to help you personalize sales forms and keep your current report settings for future use inside QBO:

 

 

The Community team is consistently available to assist you with any inquiries regarding transaction tracking or managing bank deposits within QuickBooks. Please feel free to visit us or leave a comment below, and we will respond to you promptly. Stay safe.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us