Would you please show me how to create these three exports from QuickBooks Online Edition?

• Time Activities by Date Detail - Including these columns: Client, Activity date, Employee, Product/Service, Description, Rate, Duration, Billable Flag, Amount, Class, and Division    (Filtered to include all Time Activities in 2006)
• Invoice Transaction Report - Including these columns: Transaction Type, Date, Number, Client, Product/Service, Account, Memo Description, Amount, Employee, Hours, Class, and Division    (Filtered to include all Transactions in 2006, of the Type "Invoice", for all Income/Expense accounts)
• Bill Transaction Report - Including these columns: Transaction Type, Date, Number, Vendor, Product/Service, Account, Memo Description, Amount, Employee, Hours, Class, and Division    (Filtered to include all Transactions in 2006, of the Type "Bill", for all Income/Expense accounts)

Thanks,

- Kyle -

Please omit the "Division" requirement and show me how to extract the rest of the report specifications.

- Thanks

Tom,

Here are the screen images you requested.

Thanks for your help,

Kyle

Time Activities export:

• Time Activity Date = From: 01/01/2006 To: 12/31/2006

Invoices export:

• Transaction type = Invoices
• Distribution Account = All Income/Expense Accounts
• Time Activity Date = From: 01/01/2006 To: 12/31/2006

Bills export:

• Transaction type = Bill
• Distribution Account = All Income/Expense Accounts
• Transaction Date = From: 01/01/2006 To: 12/31/2006

Thanks . . .

Normally you would start by using these stored procedure reports in QODBC:

sp_report TimeByJobDetail show Blank, Text as Client, Date as "Activity Date", Name,
Duration, BillingStatus, Class parameters datefrom={d'2006-01-01'}, dateto={d'2006-12-31'}

sp_report CustomTxnDetail show Text, Blank, TxnType, Date, RefNumber, Name, Class, Memo,
Account, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance
parameters datefrom={d'2006-01-01'}, dateto={d'2006-12-31'},
TxnFilterTypes='Invoice',
OpenBalanceAsOf = 'Today',
AccountFilterType='IncomeAndExpense',
SummarizeRowsBy = 'Customer'

sp_report CustomTxnDetail show Text, Blank, TxnType, Date, RefNumber, Name, Class, Memo,
Account, ClearedStatus, SplitAccount, Debit, Credit, RunningBalance
parameters datefrom={d'2006-01-01'}, dateto={d'2006-12-31'},
TxnFilterTypes='Bill',
OpenBalanceAsOf = 'Today',
AccountFilterType='IncomeAndExpense',
SummarizeRowsBy = 'Vendor'

CustomTxnDetail Filters:

AccountFilterType= |AccountsPayable|AccountsReceivable|AllowedFor1099|APAndSalesTax|APOrCreditCard|ARAndAP
|Asset|BalanceSheet|Bank|BankAndARAndAPAndUF|BankAndUF|CostOfSales|CreditCard|CurrentAsset
|CurrentAssetAndExpense|CurrentLiability|Equity|EquityAndIncomeAndExpense
|ExpenseAndOtherExpense|FixedAsset|IncomeAndExpense|IncomeAndOtherIncome|Liability
|LiabilityAndEquity|LongTermLiability|NonPosting|OrdinaryExpense|OrdinaryIncome
|OrdinaryIncomeAndCOGS|OrdinaryIncomeAndExpense|OtherAsset|OtherCurrentAsset
|OtherCurrentLiability|OtherExpense|OtherIncome|OtherIncomeOrExpense|

TxnFilterTypes= |All|ARRefundCreditCard|Bill|BillPaymentCheck|BillPaymentCreditCard|BuildAssembly
|Charge|Check|CreditCardCharge|CreditCardCredit|CreditMemo|Deposit|Estimate
|InventoryAdjustment|Invoice|ItemReceipt|JournalEntry|LiabilityAdjustment|Paycheck
|PayrollLiabilityCheck|PurchaseOrder|ReceivePayment|SalesOrder|SalesReceipt
|SalesTaxPaymentCheck|Transfer|VendorCredit|YTDAdjustment|

SummarizeRowsBy= |Account|BalanceSheet|Class|Customer|CustomerType|Day|Employee|FourWeek|HalfMonth
|IncomeStatement|ItemDetail|ItemType|Month|Payee|PaymentMethod|PayrollItemDetail
|PayrollYtdDetail|Quarter|SalesRep|SalesTaxCode|ShipMethod|TaxLine|Terms
|TotalOnly|TwoWeek|Vendor|VendorType|Week|Year|

With the release of QODBC v6.00.00.176 you can now use the new stored procedure SP_REPORTS to list all the available sp_reports available to the company file you are working with.

As well as SP_PARAMETERS to list all the parameters available for a given SP_REPORT. The VALUES column lists available values that can be used with the parameter.

However, the QuickBooks Online Edition doesn't currently support any stored procedure reports:

So you will need to build the data from the tables instead. To do this you will need to post a screen dump of the output of each of these reports.