There is no option in Query to Use Gift Balance instead of Gift Amount for pledges, which results in inflated totals if both pledges and pledge payments are included in totals. To avoid double-counting, include either pledge or pay-cash among the gift types or use the query in the Export module, which allows you to select the Use Gift Balance instead of Gift Amount and/or Calculate gift balance based on date range, campaign, fund, and appeal options.