cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
j-addison86
Level 1

Can you match bills and sales invoices to one bank transaction? Our letting agent sends 1 lump sum which includes multiple tenants rents received less his invoiced fees?

 
Solved
Best answer May 07, 2020

Accepted Solutions
jamespaul
Moderator

Can you match bills and sales invoices to one bank transaction? Our letting agent sends 1 lump sum which includes multiple tenants rents received less his invoiced fees?

Hello, j-addison86.

 

You can only match invoices to money in bank transactions (Money received). Money out transactions (the bills) would have to be selected and matched separately. 

 

I have another way to handle the transactions based on your situation. You'll want to receive the invoice payments, then deposit them to the Undeposited Funds account. Next, create a bank deposit for the sum of all payments less the agent's fees using the Creditor account. Link the expense deposit to your bill, then wrap it up by matching the transactions. I'll show you the detailed steps below. 

 

Create a payment for the invoices: 

 

  1. Click the + New icon, then select Receive Payment.
  2. Enter the tenant's name under the Customer drop-down menu. 
  3. Select Undeposited Funds under the Deposit to drop-down menu (or select + Add new to create one).
  4. Enter the details of the payment, then click Save and new

You'll want to do this for your other tenant payments until you get the sum. 

 

To create a deposit: 

 

  1. Click the + New icon, then select Bank deposit.
  2. Check the payments under the Select the payments included in this deposit section. 
  3. Choose the agent's supplier profile under the Received From column in the Add funds to this deposit section.
  4. Put Creditors in the Account column. 
  5. Enter a negative amount for the fees under Amount. 
  6. Once done, click Save and close.

This is what it will look like before saving (click the picture to enlarge it): 

HandleBank1.PNG

 

This will deposit the money to your bank account. The fees will appear as a supplier credit under their profile. You would just need to make a payment to link the deposited fees and the bill together. This will offset the amount to zero. 

 

Here's how: 

  1. Hover your mouse on Expenses, then select Suppliers.
  2. Select the agent's profile.
  3. Find the open bill, then click on Make payment.
  4. Check the Bill and the Deposit in the Bill Payment screen.
  5. Enter other details, then click Save and close.

 

HandleBank2.PNG

 

Finally, you'll want to match the payment with the bank transaction. Simply go back to the Banking page, then find the downloaded transaction. It will automatically recognize the transactions you made. Simply click on the Match button. 

 

If not, tick the Find Match radio button, then find and check the Deposit transaction. Once done, click Save

 

This is what will show in your bank's Account History after doing the process. 

HandleBank3.PNG

 

When you're ready to reconcile, you can check this article for your guide: How to reconcile a bank account and common troubleshooting tips.

 

That concludes my guide on how to handle the transactions. We're always open if you have other questions or concerns. 

 

View solution in original post

1 REPLY 1
jamespaul
Moderator

Can you match bills and sales invoices to one bank transaction? Our letting agent sends 1 lump sum which includes multiple tenants rents received less his invoiced fees?

Hello, j-addison86.

 

You can only match invoices to money in bank transactions (Money received). Money out transactions (the bills) would have to be selected and matched separately. 

 

I have another way to handle the transactions based on your situation. You'll want to receive the invoice payments, then deposit them to the Undeposited Funds account. Next, create a bank deposit for the sum of all payments less the agent's fees using the Creditor account. Link the expense deposit to your bill, then wrap it up by matching the transactions. I'll show you the detailed steps below. 

 

Create a payment for the invoices: 

 

  1. Click the + New icon, then select Receive Payment.
  2. Enter the tenant's name under the Customer drop-down menu. 
  3. Select Undeposited Funds under the Deposit to drop-down menu (or select + Add new to create one).
  4. Enter the details of the payment, then click Save and new

You'll want to do this for your other tenant payments until you get the sum. 

 

To create a deposit: 

 

  1. Click the + New icon, then select Bank deposit.
  2. Check the payments under the Select the payments included in this deposit section. 
  3. Choose the agent's supplier profile under the Received From column in the Add funds to this deposit section.
  4. Put Creditors in the Account column. 
  5. Enter a negative amount for the fees under Amount. 
  6. Once done, click Save and close.

This is what it will look like before saving (click the picture to enlarge it): 

HandleBank1.PNG

 

This will deposit the money to your bank account. The fees will appear as a supplier credit under their profile. You would just need to make a payment to link the deposited fees and the bill together. This will offset the amount to zero. 

 

Here's how: 

  1. Hover your mouse on Expenses, then select Suppliers.
  2. Select the agent's profile.
  3. Find the open bill, then click on Make payment.
  4. Check the Bill and the Deposit in the Bill Payment screen.
  5. Enter other details, then click Save and close.

 

HandleBank2.PNG

 

Finally, you'll want to match the payment with the bank transaction. Simply go back to the Banking page, then find the downloaded transaction. It will automatically recognize the transactions you made. Simply click on the Match button. 

 

If not, tick the Find Match radio button, then find and check the Deposit transaction. Once done, click Save

 

This is what will show in your bank's Account History after doing the process. 

HandleBank3.PNG

 

When you're ready to reconcile, you can check this article for your guide: How to reconcile a bank account and common troubleshooting tips.

 

That concludes my guide on how to handle the transactions. We're always open if you have other questions or concerns. 

 

Need to get in touch?

Contact us