QuickBooks opens a Create Estimates form, which bears an uncanny resemblance to the Create Invoices form that you’ve seen if you’ve worked with QuickBooks at all. The Create Estimates window. Start filling in the blanks. On the sales screen, click on Estimates in the QuickBooks moneybar. Select the estimate you wish to accept from the list below and click on Pending in the Status column to open the estimate for customization.
. From the Reports menu, select Customers and Receivables, then click Customer Phone List. Click Customize Report.
On the Display tab, uncheck to remove Main Phone column. Scroll down the column list then check to add Sales Tax Code. Click the Filters tab. From the Filters list, select Sales Tax Code and from the drop-down, select All Taxable Codes or Tax depending on your need. Note: You may want to try one then the other to see which one gives you what you need. Click OK. You will see a report showing you all customers who are taxable. Click Memorize to save the report for future reference.
From the Reports menu, select Purchases then click Open Purchase Order by Job. Click Customize Report. On the Display tab, choose the following columns: Type, Date, Num, Source Name, Item, Item Description, Qty, Open Balance and Amount. Go to the Filters tab, then choose the following filters:. Transaction Type = Sales Order. Paid Status = Open.
Received = Either. Click the Header/Footer tab and change the Report Title to Open Sales Order Detail by Customer. Click Memorize to save this report for future use.
From the Reports menu, choose Banking then click Check Detail. Click Customize Report. On the Display tab, choose the appropriate date range. From the Filters tab, remove all selected filters under the Current Filter Choices. Select the filter for Transaction Type then choose Payment. Select the filter for Detail Level and choose All Except Summary. Note: If the Detail Level filter is selected as Summary Only, it will only show linked deposits.
You can filter this report for specific customers by choosing the Name filter and narrowing down to a single name or type of name. From the Reports menu, choose Banking then click Deposit Detail. Click Customize Report.
Select the date range. Go to the Filters tab, then choose the following filters:. Accounts = All Accounts Receivable. Transaction Type = Invoice. Detail Level = Summary Only. Paid Status = Open. Click Ok.
Click the Export button at the top of the report then select a new Excel workbook. Click the Advanced tab and select options as you wish. Click OK then Export. In the MS Excel Worksheet:. Delete all of the invoices that do not show a linked payment.
Move each of the invoice amounts on cell to the right. Under the payments, insert a Sum function, that will show you the total of the payments.
From the Reports menu, select List then click Customer Contact List. Click Customize Report. On the Display tab, select Job status, Estimate Total, Start Dateand Projected End columns. Remove any unwanted columns. You may 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 certain Start Dates, or only Awarded Jobs. You can also filter for one specific Customer or multiple Customers.
(Optional) Go to the Header/Footer tab to rename the report title. Click Memorize to save this report for future use. To see the price level field:. From the Lists menu, select Add/Edit Multiiple List Entries. In the Add/ Edit Multiple List Entries window, click the List drop down choose Customer. On the right hand side, click Customize Columns,.
In the Available Columns pane, scroll down and select Price Levelthen click Add button in the middle. With the Move Up button, arrange the columns so the Price Level is next to the Name or Job column. You can edit the field here but you cannot print or export this report. To print or export price level reports:. Create an export IIF file and open it in MS Excel.
Export your Customer List to your desktop. Browse to your desktop. Right-click the export file and choose Open with. Select Excel and the file will open in Excel. Find the information you need.
In the Excel spreadsheet, scroll down Column B until you see the word NAME in a cell. The customer names will be listed in the cells below. Scroll across the spreadsheet in the same row where the NAME cell was found. At the end of the row you will see PRICE LEVEL. Listed below are all the Price levels associated with these customers. Clean up the Spreadsheet.
Delete (or hide) the rows above the row where the NAME and the PRICE LEVEL cells were found. Delete any other columns in between NAME and PRICE LEVEL that you do not wish to see in your report. When saving the file. Excel will give you a message: File Name may contain features that are not compatible with Text (Tab delimited).
Do you want to keep the workbook in this format?. Select Yes. From the Vendors menu, select Print/E-file 1099s then click 1099 Summary or Detail report. From the 1099 Options drop-down, choose All Vendors, All Allowed Accounts and Ignore thresholds.
From the Dates drop-down, select All (or set the appropriate date range). Note: The modified report will now display ALL vendor payments to a vendor. There may be multiple columns to reflect the 1099 mapping (Box 1: Rent, Box 7: Non employee Compensation; Uncategorized, Total, etc.). The Total column will reflect all payments regardless of the 1099 mapping. If you need the report for more than one bill credits, modify the Check Detail report to show multiple bill credits. From the Reports menu, select ReportBanking Check Detail. Click Customize Report then go to the Filters tab.
Remove the default filters (Account, Amount and Detail Level). Add the Date filter then enter the appropriate date range. Add the Name filter and select the appropriate Vendor name. Add the Transaction Type filter then select Bill Credit.
Click Memorize to save the report. Follow these steps if you need a report that displays detailed vendor expenses totaled by Customer:job. From the Reports menu, select Custom Reports Transaction Detail. Click Customize Report then go to the Display tab. In the Display tab:.
Set the appropriate date range. In the Columns section, click to clear the checkmark next to Name, and then click to add a checkmark next to “Source Name”. Click the Total By drop-down arrow and select Customer. Go to the Filters tab and from the Filter List, select Transaction Type.
Select the transaction type associated with the Vendor purchases (i.e. Click OK to display the report.
From the Reports menu, select Custom Reports then click Transaction Detail. Click Customize Report. On the Display tab, select Item and Item Description columns. On the Filters tab, select the following filters:. Transaction Type = Purchase Order.
Posting Status = Either. Received = No for open Purchase Orders. Received = Yes for closed Purchase Orders. Note: In QuickBooks for Mac, click the Filters icon then check or uncheck a filter to add/delete it. Click Apply and close the window to save the changes. From the Reports menu, select Custom Reports then click Summary. On the Display tab, set the date range to the period you need.
Click Customize Report. On the Display rows by drop-down, select Item detail. Under Display columns for, select Quantity (leave default to Amount if dollar amount is required). On the Filters tab:.
Remove the Account filter. Add Transaction Type then select Build Assembly filter. Add Detail Level then select All except summary filter.
Click Memorize to save the report for future use. You also have the following options:. Set the Posting Status filter to Either to include pending builds. Change Display Columns by to Month to display data by month. Set the Item filter to Multiple items and select desired items.
Currently,QuickBooks can only create a Balance Sheet and a Profit and Loss report using the home currency. On these reports, transactions using foreign currencies are converted into their corresponding US dollar amounts.The following summary reports, however, allow you to choose to display amounts in your home currency (the default) or in foreign amounts:. A/R Aging. A/P Aging.
Customer Balance Summary. Vendor Balance Summary. Sales by Customer Summary.
Purchases by Vendor Summary (if purchase orders are turned on).