I know a better way to record the advance payment, heatherthebookkeeper.

You can create a liability account and record a retainer item. Here's how:

First, create a liability account:

1. From the Accounting tab, select Chart of accounts.
2. Select New.
3. From the Account Type dropdown menu, select Other Current Liabilities.
4. From the Detail Type dropdown menu, select Trust Accounts - Liabilities.
5. Enter a Name for the account.
6. Select an option from the When do you want to start tracking your finances from the is account in QuickBooks? dropdown list.
7. Click Save and Close.

Second, add a retainer item. I've added this article for the detailed steps: Record a retainer or deposit.

You can also browse this page on how you can run report for the sales: Run reports in QuickBooks Online.

I'm just around if you need help running reports.