Because the end of day is 12AM PST, it's necessary to run the reports for that next business day. Run reports with the "next day" as the end date. For example, if you are trying to see information between 4/1/11 and 7/31/11 use the dates 4/1/2011-8/1/2011.
Also, remember that this report will give you information about when the purchase was initiated, not when the payment was made.
If the invoice generation and the payment dates are different, run this report based on the generation date not the payment date. This report is designed to only show you how monies are being attached to items sold based on GL account. This report will not show you when payment was made.