Understand Reports In QuickBooks Desktop

 Creating custom reports in QuickBooks Desktop

Customer and sales reports

Taxable customers

The report is a summary of all customers which have a taxable sales tax code.

• Through the Reports menu, select Customers and Receivables, then click Customer Phone List.
• Click Customize Report.
• From the Display tab, uncheck to remove Main Phone column.
• Scroll along the column list then check to incorporate Sales Tax Code.
• Click on the Filters tab.
• From the Filters list, select Sales Tax Code and through the drop-down, select All Taxable Codes or Tax based on your need. Note: you might try one then the other to see what type offers you what you need.
• Click OK. You'll see a study showing you all customers that are taxable.
• Click Memorize to save lots of the report for future reference.

Sales Receipts that show check number when it comes to payment

This report shows the check number specified by the user when they enter a sales receipt.

• From the Reports menu, select Customers & Receivables then click Transaction List by Customer.
• Click Customize Report.
• From the Display tab, check to add P.O. # and Pay Method columns.
• Click on the Filters tab.
• From the Filters list, select Transaction Type.
• From the Transaction Type drop-down, select Multiple Transactionsthen add Sales Receipts and Payments.
• Click OK.

Relted Article: https://markmiller1486.wixsite.com/mysite/post/understand-reports-in-quickbooks-desktop

Report that shows sales by state

This report shows sales by state. This is certainly particularly helpful if you want to see sales location trends or you want to correct sales tax for a specific state.

• From the Reports menu, select Sales then click Sales by Customer Detail.
• Click Customize Report.
• From the Display tab:
• From the Columns list, select Name State.
• Click on the Total by drop-down and choose Total Only.
• Click the Sort by drop-down and choose Name State.
• Click OK.
• 
  

Daily sales report totaled by payment method

Proceed with the steps below to create a study of payments totaled by payment methods:

• From the Lists menu, select Customer & Vendor Profile Lists then click Payment Method List.
• Within the Payment Method List window, click on the Reports drop-down and click QuickReport.
• Click Customize Report.
• Set the correct date range.
• Go directly to the Filters tab and from the Filters list, choose Payment Method.
• From the Payment Method drop-down, select Multiple Payment Methods then click on the payment method you wish to show regarding the report.
• Click Ok.

Sales Order report grouped by customer with Item Name displayed for open items only

The default Sales Order by Customer Report does not include Item detail and displays the total amount of the Sales Order in place of exactly what is open. The Sales Order by Item Detail Report can't be grouped by customer. To get these records, you'll want to customize the existing Open Purchase Orders by Job report.

• Through the Reports menu, select Purchases then click Open Purchase Order by Job.
• Click Customize Report.
• Regarding the Display tab, pick the following columns: Type, Date, Num, Source Name, Item, Item Description, Qty, Open Balance and Amount.
• Go right to the Filters tab, then choose the following filters:
• Transaction Type = Sales Order
• Paid Status = Open
• Received = Either
• Click the Header/Footer tab and alter the Report Title to start Sales Order Detail by Customer.
• Click OK.
• Click Memorize to save lots of this report for future use.

You may also read: https://accountingpro.blog.fc2.com/blog-entry-146.html

Customer payments while the invoices and deposits to which they are linked

This report is dependent on the Check Detail report. It shows customer payments you have received and the invoices and deposits to which the payments are linked. When formatted properly, it can function as a person Remittance report showing each Invoice and every Customer Payment.

• From the Reports menu, choose Banking then click Check Detail.
• Click CustomizeReport.
• From the Display tab, pick the appropriate date range.
• From the Filters tab, remove all selected filters underneath the Current Filter Choices.
• Choose the filter for Transaction Type then choose Payment.
• Choose the filter for Detail Level and select All Except Summary.

Note: If the Detail Level filter is selected as Summary Only, it will probably only show linked deposits. It is possible to filter this report for specific customers by seeking the Name filter and narrowing down seriously to an individual name or style of name.

• Select OK.

Payments linked to open invoices

Creating a written report to show all payments on open Invoices would require a filter to see in the event that Payment(s) are connected to an open invoice. The actual only real two reports that show selected transactions and other transactions to that they are linked are the Check Detail report and also the Deposit Detail report. However, these reports try not to total the payments. To get a total of all of the payments for open invoices export the Deposit Detail are accountable to MS Excel utilizing the Advanced option for Auto Filtering.

• From the Reports menu, choose Banking then click Deposit Detail.
• Click CustomizeReport.
• Choose the date range.
• Go right to the Filters tab, then pick the following filters:
• Accounts = All Accounts Receivable
• Transaction Type = Invoice
• Detail Level = Summary Only
• Paid Status = Open
• Click Ok.
• Click on the Export button towards the top of the report then select a brand new Excel workbook.
• Click the Advanced tab and select options as you wish..
• Click OK then Export.
• When you look at the MS Excel Worksheet:
• Delete all the invoices that don't show a linked payment.
• Move all the invoice amounts on cell to the right.
• Under the payments, insert a Sum function, that may explain to you the full total associated with the payments.

Amounts on Estimates

This report shows the outstanding amounts on estimates.

• From the Reports menu, select Jobs, Time & Mileage > Estimates by Job.
• Click Customize Report.
• On the Display tab, check to add the Open Balance column. Uncheck any unneeded columns.
• Select the date range then click Ok.
• Click Memorize this report for future use.

Open invoices as of a selected date

• Through the Reports menu, select Customers & Receivables then click Open Invoices.
• Click Customize Report.
• Click the Advanced… button.
• On view Balance/Aging area, select As of Report Date.
• Click OK within the Advanced Options then into the Customize Reportwindow.
• Go into the correct date in the report.
• Click Memorize to save this report for future use.

Customer invoices sorted by Invoice Number

This report shows all invoices for several customers sorted by Invoice Number in place of Date, Customer:job name or Item.

• Through the Reports menu, select Custom Reports then click Transaction Detail.
• In the Display tab:
• Set the date range.
• Click on the Sort by drop-down and select Num.
• On the Filters tab, set the following filters:
• Transaction type = Invoice
• Detail Level = Summary only
• Click OK.
• Click Memorize to save lots of the report for future use.

Customer:Job status, date and estimate totals

This report helps job related businesses that might need report of job status, start and end dates, and estimate totals.

• Through the Reports menu, select List then click Customer Contact List.
• Click Customize Report.
• From the Display tab, select Job status, Estimate Total, Start Dateand Projected End columns.
• Remove any unwanted columns. You might want to add Balance Totals (for invoice balances).
• Click Filters, and choose the same filters, as needed: Job Status, Estimate Total, Start Date, Projected End if you need to filter out specific criteria in these areas, such as for example certain Start Dates, or only Awarded Jobs. You could filter for starters specific Customer or multiple Customers.
• Click OK..
• (Optional) Go to the Header/Footer tab to rename the report title.
• Click Memorize to save lots of this report for future use.

A sales by rep report based on gross profit

Many companies want to pay commissions to sales reps according to Gross Profit rather than the gross of this sale. This permits companies to keep up a profitability on an item when it is deeply discounted. The Sales by Rep report is founded on the item total and never the gross profit. Follow the steps below to create a sales by rep report based on the gross profit:

• Through the Reports menu, select Custom Reports then click Summary.
• On the Display tab, select Rep when you look at the Display Rows by drop down.
• Choose the appropriate date range.
• Regarding the Filters tab, select the Multiple Accounts filter.
• Check to choose the appropriate Income and Cost of Goods Sold accounts.
• Click OK.
• Click Memorize to save this report for future use.

If you are still unable to Understand Reports In QuickBooks Desktop, please contact our experts.