How to remove customer refunds from unbilled expense report in quickbooks desktop?

You can use a Clearing Items/Expenses Filter instead of assigning the refund check directly to your standard expense or A/R account on the line item, and routing it through a dedicated service item breaks the link to the Unbilled Expenses report.

To start, go to the Lists menu at the top and select Item List. Click the Item button at the bottom left and then select New. Set the Type and Service, then name the item as Customer Overpayment Refund. In the Account dropdown menu, select Accounts Receivable or the specific liability account you use to hold customer deposits/overpayments. Once done, click OK.

Locate the original refund check stuck on your report and swap the account to your newly created refund item. Because the Unbilled Expenses report specifically targets the Expenses tab mapping, moving the transaction to the Items tab satisfies the report's filters and immediately removes it from the list.

Another workaround would be to filter the report to exclude the refund accounts. If you prefer not to alter your past transactions, you can change how the Unbilled Expenses report looks at your data by adjusting its underlying filter logic.

Open your Unbilled Costs by Job report and click Customize report. Under the Filters tab, search for Account and select Multiple Accounts from the dropdown. Check your operational expense accounts, but uncheck Accounts Receivable or the holding accounts where your refund checks are posted. Click OK twice to refresh, then click Memorize at the top to save this view.

If you have other questions about QuickBooks, please don't hesitate to click the Reply button below.