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
|
|
Bank Reconciliation Reports |
Author |
Message |
|
Posted : 2008-12-24 01:03:59 |
I have many bank accounts across about 15 different Quickbooks companies. I am able to pull the current balances into Excel thru QODBC (by using the TrialBalance report with account type=Bank), however I would also like to be able to pull the Quickbooks previous bank reconciliation report for each account, with one exception. The previous reconciliation report includes all items cleared in that bank rec. I do not need the cleared items. I need the cleared balance at the end of the bank rec and a detailed list of all uncleared items. Is there a way to do this? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-12-24 09:58:08 |
Sorry, the Intuit qbXML SDK doesn't provide us access to the QuickBooks Previos Reconcilation Report. |
|
|
|
|
Posted : 2008-12-24 23:48:23 |
Is there a way then to get a G/L detail or similar report, for all bank accounts, but only get the transactions that are not cleared, no matter what time frame they are in?
I guess what I need is:
Detailed transactions by account for account type bank and status uncleared for time period all. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-12-26 10:14:44 |
Try:
sp_report CustomTxnDetail show TxnType, Date, RefNumber, Name, Memo, Account, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance parameters DateMacro = 'All', AccountFilterType = 'Bank', SummarizeRowsBy = 'TotalOnly', OpenBalanceAsOf = 'Today' where ClearedStatus = 'NotCleared'
See: How do I run a CustomTxnDetail Report? for more. |
|
|
|
|
Posted : 2009-01-08 04:24:33 |
This is working great, however can I get it sorted by Account number? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-08 10:00:17 |
Ok, try this:
sp_report CustomTxnDetail show TxnType, Date, RefNumber, Name, Memo, Account, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance parameters DateMacro = 'All', AccountFilterType = 'Bank', SummarizeRowsBy = 'TotalOnly', OpenBalanceAsOf = 'Today' where ClearedStatus = 'NotCleared' order by Account, Date |
|
|
|
|