Jovychris_A
Moderator

Other Questions

Thanks for adding a few details to make sure we can match the transactions from your bank, @Steven_ZA.

 

To match them, you can record the payment received (R200) and put it in the Undeposited Funds account (this will place the money on a clearing account until you deposit the funds to your bank). Then for the expense/refund (R50), you can create a bank deposit and add it as a new category/account in the Add funds to this deposit section to track the expense. Also, ensure to enter a negative amount to minus it with the invoice payment.

 

This way, you can link the expense/refund with the invoice payment and able to get the R150 total and match it with the bank statement line of R150 in a single deposit. Furthermore, this won't make use of the Resolve option when matching the records in QuickBooks with the bank statement.

 

Here are the steps to follow:

  1. Click +New and then select Receive payment.
  2. Choose the client name from the Customer drop-down list.
  3. Enter necessary details like Payment datePayment methodReference no., and then select the Undeposited Funds account in the Deposit to drop-down.
  4. Check the invoice box you want to apply for the R200 payment.
    7.PNG
  5. Hit Save and close.

 

Once done, you can create a bank deposit to choose the invoice payment and add the expense/refund manually as a new category to link the two transactions.

 

  1. Hit the +New above the left menu, then select Bank deposit.
  2. Choose your bank account in the Account drop-down list you need to deposit the money into.
  3. Check the box for the R200 worth of invoice payment.
  4. In the Add funds to this deposit section, you can enter the R50 (-50) worth expense/refund (click +Add new to create a new category/account) to negate the invoice amount.
  5. Click Save and close.

 

When you match transactions in the For review tab of the Banking page, QuickBooks will automatically detect the bank deposit recorded when you click the R150 worth entry in the bank statement. You can easily match or confirm it thoroughly.

 

If you matched the transactions recently with the incorrect transaction, you can go to the Categorised tab and click the Undo button to return the entries in the For review tab.

 

I've added some references to get more details about matching and categorising transactions from your bank and reconciling bank accounts in QuickBooks Online:

 

Categorise and match online banking transactions in QuickBooks Online.

Reconcile and account in QuickBooks Online.

 

It's good to know your interest to learn more. If you have additional questions about recording transactions and matching them with your bank statement/online banking, feel free to tag me (@Jovychris_A) and my other peers in your comment. We'll make sure to help you. Have a nice and prosperous day ahead!