Close

Our Blog

2022im体育

Getting Started with Reports in QuickBooks Online
You can do a lot of your accounting work in QuickBooks Online by generating reports. You can maintain your customer and vendor profiles. Create and send transactions like invoices and sales receipts, and record payments. Enter and pay bills. Create time records and coordinate projects. Track your mileage and, if you have employees, process payroll.

These activities help you document your daily financial workflow. But if you’re not using QuickBooks Online’s reports, you can’t know how individual elements of your business like sales and purchases are doing. And you don’t know how all of those individual pieces fit together to create a comprehensive picture of how your business is performing.

QuickBooks Online’s reports are plentiful. They’re customizable. They’re easy to create. And they’re critical to your understanding of your company’s financial state. They answer the small questions, like, How many widgets do I need to order?, and the larger, all-encompassing questions like, Will my business make a profit this year?

Getting the Lay of the Land

Let’s look at how reports are organized in QuickBooks Online. Click Reports in the toolbar. You’ll see they are divided into three areas that you can access by clicking the labeled tabs. Standard refers to the comprehensive list of reports that QuickBooks Online offers, displayed in related groups. Custom reports are reports that you’ve customized and saved so you can use the same format later. And Management reports are very flexible, specialized reports that can be used by company owners and managers.



A partial view of the list of QuickBooks Online’s Standard reports


Standard Reports

The Standard Reports area is where you’ll do most—if not all—of your reporting work. The list of available reports is divided into 10 categories. You’re most likely to spend most of your time in just a few of them, including:
  • Favorites. You’ll be able to designate reports that you run often as Favorites and access them here, at the top of the list. 
  • Who owes you. These are your receivables reports. You’ll come here when you need to know, for example, who is behind on making payments to you, how much individual customers owe you, and what billable charges and time haven’t been billed.
     
  • Sales and customers. What’s selling and what’s not? What have individual customers been buying? Which customers have accumulated billable time? 

  • What you owe. These are your payables reports. They tell you, for example, which bills you haven’t paid, the total amount of your unpaid bills (grouped by days past due), and your balances with individual vendors. 

  • Expenses and vendors. What have I purchased (grouped by vendor, product, or class)? What expenses have individual vendors incurred? Do I have any open purchase orders? 
The Business Overview contains advanced financial reports that we can run and analyze for you. The same goes for the For my accountant reports. Sales tax , Employees , and Payroll will be important to you if they’re applicable for your company.

Working with Individual Reports



Each individual report in QuickBooks Online has three related task options.


To open any report, you just click its title. If you want more information before you do that, just hover your cursor over the label. Click the question mark to see a brief description of the report. If you want to make the report a Favorite , click the star so it turns green. And clicking the three vertical dots opens the Customize link.

When you click the Customize link, a vertical panel slides out from the right, and the actual report is behind it, grayed out. Customization options vary from report to report. Some are quite complex, and others offer fewer options. The Sales by Customer Detail report, for example, provides a number of ways for you to modify the content of your report so it represents exactly the “slice” of data you want. So you can indicate your preferences in areas like:
  • Report period  
  • Accounting method (cash or accrual) 
  • Rows/columns (you can select which columns should appear and in what order, and group them by Account , Customer , Day , etc.) 
  • Filter (choose the data group you want represented from several options, including Transaction Type , Product/Service , P ayment Method , and Sales Rep
Once you’ve run the report, you can click Save customization in the upper right corner and complete the fields in the window that opens. Your modification options will then be available when you click Custom reports , so you can run it again anytime with fresh data.



You can customize QuickBooks Online’s reports in a variety of ways.

We’ll go into more depth about report customization in a future issue. For now, we encourage you to explore QuickBooks Online’s reports and their modification options so that you’re familiar with them and can put them to use anytime. Let us know if you have any questions about the site’s reports, or if you need help making your use of QuickBooks Online more effective and productive.


Have a Question About This Topic?

I confirm this is a service inquiry and not an advertising message or solicitation. By clicking “Submit”, I acknowledge and agree to the creation of an account and to the Terms of Use and Privacy Policy .

NEVER MISS A STORY.

Sign up for our newsletters and get our articles delivered right to your inbox.

Back to Article List

'); mywindow.document.write(data); mywindow.document.write(' '); mywindow.document.close(); // necessary for IE >= 10 mywindow.focus(); // necessary for IE >= 10 mywindow.print(); mywindow.close(); return true; } function quote_standard() { var miscellaneous=0; var formName = document.ioq; $('#print').show(); /* START GLOBAL VARIABLES ***************************************************************************/ // Federal var form1040 = Math.round(120*1.3); var form1040A = Math.round(100*1.3); var form1040EZ = Math.round(60*1.3); var form1040X = Math.round(200*1.3); // State var form140AZ = Math.round(70*1.3); var form140AZPY = Math.round(90*1.3); var form140X = Math.round(90*1.3); var otherStateIncomeTax = Math.round(80*1.3); // Income var w2 = Math.round(10*1.5); var form1099R = Math.round(10*1.3); var k1 = Math.round(40*1.3); // Schedules var scheduleA = Math.round(110*1.3); var scheduleB = Math.round(20*1.3); var scheduleC = Math.round(120*1.3); var scheduleD = Math.round(40*1.3); var scheduleE = Math.round(200); var scheduleF = Math.round(100*1.3); var scheduleH = Math.round(100*1.3); var scheduleL = Math.round(20*1.3); var scheduleM = Math.round(20*1.3); // Forms var form982 = Math.round(80*1.3); var form2106 = Math.round(50*1.3); var form2441 = Math.round(40*1.3); var form4137 = Math.round(40*1.3); var form4562 = Math.round(30*1.3); var form4684 = Math.round(50*1.3); var form4797 = Math.round(140*1.3); var form5405 = Math.round(80*1.3); var form5695 = Math.round(80); var form6252 = Math.round(80*1.3); var form8283 = Math.round(40); var form8379 = Math.round(40*1.3); var form8396 = Math.round(30*1.3); var form8606 = Math.round(30*1.3); var form8824 = Math.round(150*1.3); var form8829 = Math.round(130); var form8863 = Math.round(50*1.3); // Income documents var incomeDocuments = Math.round(60); var incomeDocumentsAnswer = "Yes"; /* CALCULATES QUESTIONS NUMBER 2 ********************************************************************/ if (formName.DoYouHaveAMortgage_0.checked == true) { var doYouHaveAMortgage = 230; var doYouHaveAMortgageAnswer = "Yes"; } else { var doYouHaveAMortgage = 130; var doYouHaveAMortgageAnswer = "No" } /* CALCULATES QUESTIONS NUMBER 3 ********************************************************************/ if (formName.W2_0.checked == true) { var w2 = parseInt(w2) * parseInt(formName.W2_0_yes.value); var w2Answer = "Yes"; } else { var w2 = 0; var w2Answer = "No"; } /* CALCULATES QUESTIONS NUMBER 4 ********************************************************************/ if (formName.SelfEmployed_0.checked == true) { var selfEmployed = 170 * parseInt(formName.SelfEmployed_0_yes.value); var selfEmployedAnswer = "Yes"; } else { var selfEmployed = 0; var selfEmployedAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 5 ********************************************************************/ if (formName.DidYouLiveOutsideOfArizona_0.checked == true) { var didYouLiveOutsideOfArizona = parseInt(formName.DidYouLiveOutsideOfArizona_0_yes.value * 190); //didYouLiveOutsideOfArizona=Math.round(didYouLiveOutsideOfArizona*1.3); var didYouLiveOutsideOfArizonaAnswer = formName.DidYouLiveOutsideOfArizona_0_yes.value; } else { var didYouLiveOutsideOfArizona = 100; didYouLiveOutsideOfArizona=Math.round(didYouLiveOutsideOfArizona*1.3); var didYouLiveOutsideOfArizonaAnswer = 1; } /* CALCULATES QUESTIONS NUMBER 6 ********************************************************************/ if (formName.DidYouSellInvestments_0.checked == true) { // alert("Your fees could vary significantly depending upon the number and type of transactions. We can give you a firm quote when we meet. This quote is an estimate."); // Captures the quantity value of the drop down and multiplies it times the price. var didYouSellInvestments = (parseInt(formName.ScheduleD.value) * 5) + 50; if (parseInt(formName.ScheduleD.value) > 40) { didYouSellInvestments=didYouSellInvestments+((parseInt(scheduleD)-40)*3); } didYouSellInvestments=Math.round(didYouSellInvestments*1.3); var didYouSellInvestmentsAnswer = "Yes"; } else { var didYouSellInvestments = 0; var didYouSellInvestmentsAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 7 ********************************************************************/ if (formName.DidYouOwnRentalProperty_0.checked == true) { // Captures the quantity value of the drop down and multiplies it times the price. var didYouOwnRentalProperty = parseInt(scheduleE) * parseInt(formName.ScheduleEOwn.value); var didYouOwnRentalPropertyAnswer = "Yes"; } else { var didYouOwnRentalProperty = 0; var didYouOwnRentalPropertyAnswer = "No"; } if (formName.DidYouSellRentalProperty_0.checked == true) { // Captures the quantity value of the drop down and multiplies it times the price. var didYouSellRentalProperty = 250 * parseInt(formName.ScheduleESell.value); var didYouSellRentalPropertyAnswer = "Yes"; } else { var didYouSellRentalProperty = 0; var didYouSellRentalPropertyAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 9 ********************************************************************/ if (formName.ChildCare_0.checked == true) { var childCare = parseInt(form2441); var childCareAnswer = "Yes"; } else { var childCare = 0; var childCareAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 11 ********************************************************************/ if (formName.EnergyCredit_0.checked == true) { var energyCredit = parseInt(form5695) * parseInt(formName.EnergyCredit.value); var energyCreditAnswer = "Yes"; } else { var energyCredit = 0; var energyCreditAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 12 ********************************************************************/ if (formName.DonateNonCash_0.checked == true) { var donateNonCash = parseInt(form8283); var donateNonCashAnswer = "Yes"; } else { var donateNonCash = 0; var donateNonCashAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 13 ********************************************************************/ if (formName.BusinessUseOfHome_0.checked == true) { var businessUseOfHome = parseInt(form8829) + ((parseInt(formName.BusinessUseOfHome_0_yes.value) * 80) - 80); var businessUseOfHomeAnswer = "Yes"; } else { var businessUseOfHome = 0; var businessUseOfHomeAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 14 ********************************************************************/ if (formName.BusinessUseOfHome_0.checked == true) { var businessUseOfHome = parseInt(form8829) * parseInt(formName.BusinessUseOfHome_0_yes.value); var businessUseOfHomeAnswer = "Yes"; } else { var businessUseOfHome = 0; var businessUseOfHomeAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 15 ********************************************************************/ if (formName.CollegeTuition_0.checked == true) { var collegeTuition = parseInt(form8863) * parseInt(formName.Tuition_0_yes.value); var collegeTuitionAnswer = "Yes"; } else { var collegeTuition = 0; var collegeTuitionAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 16 ********************************************************************/ if (formName.IncomeDocuments_0.checked == true) { var incomeDocuments = parseInt(incomeDocuments); var incomeDocumentsAnswer = "Yes"; } else { var incomeDocuments = 0; var incomeDocumentsAnswer = "No"; } // Calculate the subtotal var subtotal = parseInt(doYouHaveAMortgage + w2 + selfEmployed + didYouLiveOutsideOfArizona + didYouSellInvestments + didYouOwnRentalProperty + didYouSellRentalProperty + childCare + energyCredit + donateNonCash + businessUseOfHome + collegeTuition + incomeDocuments); // create answer text var doYouHaveAMortgageAnswer = "2. Mortgage? " + doYouHaveAMortgageAnswer + " $" + doYouHaveAMortgage; var w2Answer = "3. W-2, 1099-R, SSA-1099, K-1 forms? " + w2Answer + " $" + w2; var selfEmployedAnswer = "4. Self-Employed? " + selfEmployedAnswer + " $" + selfEmployed; var didYouLiveOutsideOfArizonaAnswer = "5. State Returns: " + didYouLiveOutsideOfArizonaAnswer + " $" + didYouLiveOutsideOfArizona; var didYouSellInvestmentsAnswer = "6. Sold Investments? " + didYouSellInvestmentsAnswer + " $" + didYouSellInvestments; var didYouOwnRentalPropertyAnswer = "7a. Owned Rental Property? " + didYouOwnRentalPropertyAnswer + " $" + didYouOwnRentalProperty; var didYouSellRentalPropertyAnswer = "7b. Sold Rental Property? " + didYouSellRentalPropertyAnswer + " $" + didYouSellRentalProperty; var childCareAnswer = "8. Child Care? " + childCareAnswer + " $" + childCare; var energyCreditAnswer = "9. Energy Credit? " + energyCreditAnswer + " $" + energyCredit; var donateNonCashAnswer = "10. Donated more than $500? " + donateNonCashAnswer + " $" + donateNonCash; var businessUseOfHomeAnswer = "11. Business-use-of-home? " + businessUseOfHomeAnswer + " $" + businessUseOfHome; var collegeTuitionAnswer = "12. College Tuition? " + collegeTuitionAnswer + " $" + collegeTuition; var incomeDocumentsAnswer = "13. Earned Income Credit " + incomeDocumentsAnswer + " $" + incomeDocuments; // Check if existing client box is checked if (formName.ExistingClient_0.checked == true) { var existingClientAnswer = "1. Existing client? Yes"; var discount = parseInt(subtotal * .10); } else { var existingClientAnswer = "1. Existing client? No"; var discount = parseInt(subtotal * .20); } // Dependent discount check if (formName.DependentDiscount_0.checked == true) { var dependentDiscount = parseInt(subtotal * .5); var dependentDiscountText = "
Dependent Discount: -$"+ dependentDiscount; } else { var dependentDiscount = 0; var dependentDiscountText = ""; } var breakdown = existingClientAnswer + "
" + doYouHaveAMortgageAnswer + "
" + w2Answer + "
" + selfEmployedAnswer + "
" + didYouLiveOutsideOfArizonaAnswer + "
" + didYouSellInvestmentsAnswer + "
" + didYouOwnRentalPropertyAnswer + "
" + didYouSellRentalPropertyAnswer + "
" + childCareAnswer + "
" + energyCreditAnswer + "
" + donateNonCashAnswer + "
" + businessUseOfHomeAnswer + "
" + collegeTuitionAnswer + "
" + incomeDocumentsAnswer; var quote = breakdown + "
--------------------
Subtotal: $" + parseInt(subtotal) + "
Discount: -$" + parseInt(discount) + dependentDiscountText + "
--------------------
Total Only $" + parseInt(subtotal - discount - dependentDiscount + miscellaneous) + "! "; document.getElementById('quotearea').innerHTML=quote+'

If you have other transactions not mentioned above, your fees will be higher. This quote is an estimate. Please print this quote and bring it with you to your appointment. You must have a completed tax organizer to get the discount.'; return false; }