Using a non-profit version, I am trying to pull "donations" into Excel in order to do four years worth of yearly-quarterly-monthly comparison graphs. I have been using the "SalesReceiptsLine" table, but I have found that not all donations are receipted. For instance, Direct Deposits from organizations are not. The P/L report shows these as well as the receipted donations, and they are shown with specific 4-digit account numbers. Where can I find the Donor_Name,  Amount, account_number together so that I can import these into Excel? BTW, I tried using Item numbers too, but that doesn't work here.  Thanks in advance.

Norm Shimmel

Try looking at your Payment Deposits:

SELECT * FROM ReceivePaymentToDeposit

Thanks, Tom. But I found the table to be virtually empty. It gets cleared after the actual deposit is made. Nor did I see a 4 digit account number on the one item remaining. So the search goes on. I'm really desperate. The Excel workbook works fine. I'm just waiting for the correct raw data. I've tried to ask those in the QuickBooks forum, but they can't imagine anyone importing data from QuickBooks. They assume QuickBooks must export it.

Norm

You can try using the Profit and Loss Detail report directly in Excel instead. Just use the following example SQL Statement in MS Query:

sp_report ProfitAndLossDetail show TxnType, Date, RefNumber, Name, Memo, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance parameters DateMacro = 'ThisYearToDate' where RowType='DataRow'

and then run it multiple times with different dates on different cell ranges for comparsion.

For more details on the report see: QB REPORTS VIEW:  Profit And Loss Detail