Unable to Match bank transaction for Advance payment. Solution required.

Hi there, srscapital.

Currently, there's no option to match the bank transactions with the advance payment in QuickBooks Online. You can only match entries for invoice payments, deposits, journal entries, and transfers.

Meanwhile, you'll need to clear the advance payment on the Register page. Then, manually exclude the downloaded payment to avoid duplicate transactions.

To start with, I recommend going to the Banking section and click the Go to Bank register link. From there, choose the specific bank account where the advance payment deposited.

Here's how:

1. Click the Banking menu at the left panel. Then. choose Banking section.
2. Click the Go to Bank register link.
3. Find and select the account history you want to review.
4. Locate the Advance payment. Then, click it to expand the page.
5. Choose the Delete button.
6. You'll be prompted with This is just one part of a split transaction. Deleting it will remove the whole transaction. Are you sure you want to delete? Click Yes to confirm.

Once done, go back again to the Banking page and choose For Review tab. Then, locate the advance payment and exclude this. Please follow the steps below.

1. Go to the For Review tab.
2. Check the checkbox for each transaction you want to exclude.
3. Click the Exclude button.

Excluded transactions move to the Excluded tab. They won’t be added to QuickBooks or downloaded again.

For additional information, you can click this article: Categorise and match online bank transactions in QuickBooks Online.

Please refer to this article to see steps on how you can reconcile your accounts so they always match your bank and credit card statements to avoid discrepancies: Reconcile an account in QuickBooks Online.

Please let me know if you still have questions or concerns. I'm always here to assist you. Take care and have a good one.