Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : cash vs accrual basis in spReportSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v9 Forum

 New Topic 
 
 Post Reply 
[1]  
 cash vs accrual basis in spReport 
 Author   Message 
  Elin 
  
 Group: Members 
 Posts: 2 
 Joined: 2009-02-21 
 Profile
 Posted : 2009-02-21 12:04:28

I am a new user of QODBC and have set up an Access 2003 database that I am using as a central point to integrate our financial data from QB 2009 and other sources.  I have an Access query set up as a pass-through query to pull in data from sp_Report ProfitAndLossDetail.  This is a report that I frequently use in QB, but when I do, I change the report options to "cash basis" rather than "accrual basis", since that is how our company is set up.  I was tearing my hair out trying to figure out why my numbers weren't matching between Access QODBC and QB, when I realized that if I run the QB report as ACCRUAL, the numbers DO match up.  So this is leading me to the conclusion (perhaps wrong?) that when I run profit and loss detail from spReport, that it is using ACCRUAL basis.  Is there any way to get cash basis data from this report, like I can do in QB?  If not, is there a different way to get the data that I want besides figuring out the myriad of QB tables that I have to join to get the data?  I was so excited when I figured out spReport saves me all this work, so this is rather distressing....

Thanks for any help/insights!

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2009-02-22 10:24:33

The basics are covered in How do I run a Profit & Loss Standard Report? 

To change the reports to "Cash" reporting just add the ReportBasis parameter:

sp_report ProfitAndLossStandard show Text, Label, Amount_1 as Amount, Amount_1_Title as "As of"
parameters DateMacro = 'ThisMonthToDate', SummarizeColumnsBy = 'TotalOnly', ReportBasis='Cash'

The options are: |Cash|Accrual|None|

 

  Top 
  Elin 
  
 Group: Members 
 Posts: 2 
 Joined: 2009-02-21 
 Profile
 Posted : 2009-02-22 13:52:08
Thanks so much Tom!  I'm just discovering all the resources out there for this product (I'm a long time DBA, so am thrilled to have SQL access to QB!!!) 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to