I am trying to get the current cash balance as a query in Excel by allowing web query on the report. However, it seems that financial reports do not have the option of allowing Web Query, is there a work around to get the updated cash balance? I am trying to forecast the cash balance based on A/P and A/R

try a General Ledger report. There is a field >>Active Account by Type >>Current Balance. Allows Web Query

Seems to be working, thanks a lot!