Thank you for choosing the Community forum to help with your loan repayment question, S1T9E9V4O. I'm here to assist you in matching the sales receipt to the full amount with repayment.
In QuickBooks Online (QBO), we can use the Resolve difference feature to help match a sales receipt and bank transactions with a different amount due to repayment.
Once the £100 transaction (the £20 will be automatically sent to the company loan) is downloaded to your QBO account, we can start matching it with the sales receipt. Here are the steps to follow:
- Go to the Transactions menu and select the Bank Transactions tab.
- Locate the £100 transaction and then click Match.
- Select the sales receipt and turn on the Resolve Difference option.
- Choose the liability account for the loan.
- In the VAT column, choose the appropriate option.
- Ensure the details are correct.
- Click on Match.
Alternatively, we can manually add the transaction instead. Beforehand, exclude the £100 entry to avoid duplicates. I'll show you how:
- From the Transactions menu, select the Bank Transactions tab.
- On the For review tab, tick the checkbox beside the transaction.
- Hit Exclude.
Once done, you can record the repayment by following Step 3 in this article: Set up a loan in QuickBooks Online.
Additionally, it's recommended to review and reconcile your accounts periodically. Doing so ensures that your records are up-to-date and free of errors.
I'm here to assist you with any future concerns you may have regarding managing loans and repayments in QuickBooks. I'll be happy to help you out.