| Title |
Description |
Download |
| Banking |
| Check Listing by Bank Account |
Lists checks and other transactions that reduce the bank account balance. The report includes subtotals for each bank account. |
| Banking - Imported Reports Group.QBR |
 |
|
|
| Deposit Listing by Bank Account |
Lists checks and other transactions that reduce the bank account balance. The report includes subtotals for each bank account. |
| Customers |
| Customer Profitability Summary |
Summarizes how much you are making for each customer:job sorted by profitability. |
| Customers - Imported Reports Group.QBR |
|
|
|
| Payment details by Customer |
Shows all payments received from customers subtotaled by Customer:Job. |
| Payment summary by Customer & Amount |
Summarizes payments received by customer sorted by total amount. |
| Sales Items by Profitability |
Summarizes how much you are making on each sales item sorted by profitability. |
| Unpaid detail by Customer |
Lists unpaid accounts receivable transactions subtotaled by customer. |
| Payroll |
| Earnings by Employee |
Earnings by Employee summary. Shows employees in rows and Earnings payroll items across the top of the report in columns. |
| Payroll - Imported Reports Group.QBR |
|
|
|
| Payroll Detail Review - Federal Taxes |
Check your federal tax calculations with this report. It shows what QuickBooks has stored on paycheck, if a user edited the amount, what the amount should be, and any amount out of balance YTD, per employee per tax. |
| Payroll Detail Review - State Taxes |
Check your state tax calculations with this report. It shows what QuickBooks has stored on paycheck, if a user edited the amount, what the amount should be, and any amount out of balance YTD, per employee per tax. |
| Payroll Expenses detail by Class |
Payroll expenses detail shown by Class, with an "unclassified" section. |
| Payroll Expenses detail by Customer |
Detailed job-costed expenses & GOGS from Paychecks by Customer:Job. |
| Payroll Expenses summary by Class |
Payroll expenses shown by Class, with an "unclassified" column. |
| Payroll Expenses summary by Customer |
Summary job-costed expenses & GOGS from Paychecks by Customer:Job. |
| Payroll Liabilities Accrued by Date |
Total Payroll Liabilities accrued by payroll date (excluding payments.) |
| Payroll Liabilities Paid by Date |
Summary of your liability payments by the date the payments were paid *for* (not the check date.) |
| Payroll Liability Payments detail |
Details of each payroll liability payment, or "deposit". |
| Troubleshooting Reports |
| Items in Income Accounts - not Sales Forms |
Displays income accounts used on non-sales forms (like Checks, Bills, and others.) Use this report to find mistakes in data entry. |
| Troubleshooting - Imported Reports Group.QBR |
|
|
|
|
| Payment details by Vendor |
Shows all payments made to vendors subtotaled by vendor. |
| Payment summary by Vendor |
Summarizes payments made to each vendor. |
| Sales Items by Profitability |
Summarizes how much you are making on each sales item sorted by profitability. |
| Unapplied Customer Payments and Credits |
Shows all payments from customers and other customer credits that are unapplied (still have an open balance). |
| Unapplied Vendor Payments and Credits |
Lists all payments to vendors and other vendor credits that are unapplied (still have an open balance). |
| Unbilled Expenses |
| Unbilled Expenses - Items by Job |
Lists unbilled expenses and items (that are marked billable) subtotaled by customer:job. |
| Unbilled Expenses - Imported Reports Group.QBR |
|
|
|
|
| Unbilled Mileage by Job |
Lists unbilled mileage (marked billable) subtotaled by customer:job. |
| Unbilled Time by Job |
Lists unbilled (marked billable) time by customer:job. |
| Vendors |
| Bills by Customer:Job |
Shows the details bills to vendors subtotaled by customer:job. |
| Vendors - Imported Reports Group.QBR |
|
|
|
|
| Payments by Vendor |
Lists all payments made to vendors subtotaled by vendor. |
| Unpaid Bill details by Customer:Job |
Shows unpaid bills subtotaled by vendor. |
| Excel |
| Payroll Workbook for QuickBooks |
A workbook that connects directly to QuickBooks and get payroll transaction details. Use to create your own custom payroll reports. Includes fields you can't report on in QuickBooks like Employee Number, Custom Fields, and Tax Tracking Type. |
Payroll Workbook for QuickBooks.xls
|
| QuickBooks Workbook with Wizard |
A simple workbook that connects directly to QuickBooks and gets all posting transaction details.
Offers various options in a small wizard-like dialog: You can get transactions on a cash or accrual basis, all
transactions or subsets like All Sales or All Purchases, and choose from detail levels including All, Summary Only, and Detail only.
Contains example "Pivot Reports" you can modify and update.
Use this workbook to create your own custom reports. Includes open balance, due dates, over due days, custom fields, and
other columns (fields) of information commonly used to create financial statements. |
QuickBooks Workbook with Wizard.xls |
| QuickBooks Workbook |
A workbook that connects directly to QuickBooks and gets all posting transaction details, lists, and time records. Use this to create your own custom reports. Includes open balance, due dates, over due days, custom fields, and other columns of data commonly used to create financial statements. Contains example "Pivot Reports" you can modify and update. Contains sample code for creating different queries. This workbook includes some simple commented code that shows how to connect to QuickBooks and get data. |
QuickBooks Workbook.xls |
| More Reports |
| Accounts Payable Balance Detail - Cash Basis |
This report lists all transactions that make up your accounts payable balance on a cash basis.
|
Accounts Payable Balance Detail - Cash Basis.QBR
|
| Accounts Receivable Balance Detail - Cash Basis |
This report lists the transactions that make up your accounts receivable balance on a cash basis. |
Accounts Receivable Balance Detail - Cash Basis.QBR
|
| Accounts with No Tax Line Assignments |
This report lists the transactions that make up your accounts receivable balance on a cash basis.
|
Accounts with No Tax Line Assignments.QBR
|
| Annual Balance Sheet: Budgeted vs. Actual |
This report shows how well you met your annual budget for balance sheet accounts.
|
Annual Balance Sheet: Budgeted vs. Actual.QBR
|
| Annual Budget for Balance Sheet Accounts |
This report displays your annual budget for each balance sheet account.
|
Annual Budget for Balance Sheet Accounts.QBR
|
| Annual Budget for Income and Expenses |
This report displays your annual budget for income and expense accounts.
|
Annual Budget for Income and Expenses.QBR
|
| Annual Income and Expenses: Budgeted vs. Actual |
This report shows how well you met your annual budget for income and expense accounts.
|
Annual Income and Expenses: Budgeted vs. Actual.QBR
|
| Balance Sheets |
This report compares this year's balance sheet with last year's, showing the dollar amounts and percentage change for all asset, liability, and equity accounts. The report title has been changed to "Balance Sheets" which is GAAP and used by the AICPA when two years are included in the report.
|
Balance Sheets.QBR
|
| Bill History for the Previous Month |
This report lists your bills for the last month and shows all of the transactions (purchase orders, payments, credits) linked to each bill.
|
Bill History for the Previous Month.QBR
|
| Box 1 Data – Certified Payroll Report |
This report provides information you need to fill in Box 1 of a certified payroll report. The report shows the name, social security number, and address of each employee.
|
Box 1 Data – Certified Payroll Report.QBR
|
| Cash Flow Forecast by Month |
This report breaks down your projected cash flow by month.
|
Cash Flow Forecast by Month.QBR
|
| Cash Flow Forecast by Quarter |
This report breaks down your projected cash flow by quarter over the next fiscal year.
|
Cash Flow Forecast by Quarter.QBR
|
| Cash Flow Forecast for Next Year |
This report projects your cash flow for the next fiscal year.
|
Cash Flow Forecast for Next Year.QBR
|
| Check Register for this Month |
This report lists transactions recorded in each bank account for the current month.
|
Check Register for this Month.QBR
|
| Checking Register by Bank Account |
This report is useful when you need to print out all the information in a check register. For each bank account, the report shows debit and credit entries, much like a check register.
|
Checking Register by Bank Account.QBR
|
| Checks to be Printed |
This report lists all checks that are currently marked as "to be printed."
|
Checks to be Printed.QBR
|
| Cleared Transactions for All Bank Accounts |
This report lists all of your cleared transactions totaled by each bank account.
|
Cleared Transactions for All Bank Accounts.QBR
|
| Contacts for Open Invoices |
This report lists your open invoices, along with the phone number and e-mail address of each customer.
|
Contacts for Open Invoices.QBR
|
| Contacts for Pending Invoices |
This report lists your pending sales for each customer, showing the customer's contact name, phone number, and e-mail address.
|
Contacts for Pending Invoices.QBR
|
| Contacts for Pending Sales Receipts |
This report lists your pending cash sales for each customer, showing the customer's contact name, phone number, and e-mail address.
|
Contacts for Pending Sales Receipts.QBR
|
| Contributions by Donor |
This report lists the total contribution made by each donor to your organization. You can obtain a detailed list of a donor's individual contributions by double-clicking the donor's total in the report.
|
Contributions by Donor.QBR
|
| Cost Allocation of Hours Worked |
This report compares billed, unbilled, and not billable hours for each employee.
|
Cost Allocation of Hours Worked.QBR
|
| Credit Card Purchases This Month |
This report lists all credit card purchases for the current month.
|
Credit Card Purchases This Month.QBR
|
| Credit Card Purchases This Year |
This report lists all credit card purchases for the current year.
|
Credit Card Purchases This Year.QBR
|
| Customer E-mail List |
This report lists the e-mail address and current balance for each customer. The report is useful if you frequently contact customers by e-mail.
|
Customer E-mail List.QBR
|
| Customer Purchases by Item |
This report shows which customers are using which services and/or purchasing which items. The total income shown in the report matches the Total Income line on the Profit and Loss Standard report.
|
Customer Purchases by Item.QBR
|
| Customer Sales by Quantity |
This report helps you determine the quantity of each item sold to customers. The report lists sales transactions, grouped by customer and subtotaled by quantity sold.
|
Customer Sales by Quantity.QBR
|
| Customer Tax Codes |
This report displays sales tax code assigned to each customer.
|
Customer Tax Codes.QBR
|
| Employee Roster |
AThis report shows key information about each employee, including social security number, hire date, last pay period, and pay period frequency.
|
Employee Roster.QBR
|
| Employee Salary Information |
This report lists the current salary for each employee.
|
Employee Salary Information.QBR
|
| Employee Tax Calculation Review |
This report shows all the taxes withheld for each employee.
|
Employee Tax Calculation Review.QBR
|
| Employee Tax Information |
This report helps you verify that you have set up payroll tax information correctly for each employee. The report lists the standard taxes each employee is subject to.
|
Employee Tax Information.QBR
|
| Expenses by Customer |
This report provides a detailed look at job-related expenses. The report lists job-related expenses, totaled by customer or job and sorted by customer name.
|
Expenses by Customer.QBR
|
| Expenses by Vendor and Job |
This report lists your expenses, totaled by vendor. For each vendor, expenses are subtotaled and sorted by job.
|
Expenses by Vendor and Job.QBR
|
| Fixed Asset Changes |
This report lists changes that affect the balances of fixed asset accounts.
|
Fixed Asset Changes.QBR
|
| Franchise Sales Detail for Last Month |
This report shows sales revenue from the previous month broken down by class and item. For each item sold, the report shows the percentage of sales and quantity sold in addition to the dollar amount. The report's format makes it easy for franchisors to roll up franchisees’ reports when the report is exported to Excel and submitted electronically.
|
Franchise Sales Detail for Last Month.QBR
|
| Franchise Sales Detail for Last Week |
This report shows sales revenue from the previous week (Sunday through Saturday) broken down by class and item. For each item sold, the report shows the percentage of sales and quantity sold in addition to the dollar amount. The report's format makes it easy for franchisors to roll up franchisees’ reports when the report is exported to Excel and submitted electronically.
|
Franchise Sales Detail for Last Week.QBR
|
| Franchise Sales Summary for Last Month |
This report summarizes sales revenue by class and each major type of item sold for the previous month. The report's format makes it easy for franchisors to roll up franchisees’ reports when the report is exported to Excel and submitted electronically.
|
Franchise Sales Summary for Last Month.QBR
|
| Franchise Sales Summary for Last Week |
This report summarizes sales revenue for the previous week (Sunday through Saturday), broken down by class and item sold. The report's format makes it easy for franchisors to roll up franchisees’ reports when the report is exported to Excel and submitted electronically.
|
Franchise Sales Summary for Last Week.QBR
|
| General Journal Entries by Number |
This report lists all general journal entries sorted by number. It puts the entries in journalized form to meet audit requirements.
|
General Journal Entries by Number.QBR
|
| Hours Worked and Gross Pay Summary |
This report shows the quantity of hours worked and the amount you paid for each gross pay payroll item for this calendar year.
|
Hours Worked and Gross Pay Summary.QBR
|
| Income & Expense Budget Overview by Program |
Income & Expense Budget Overview by Program. Requires QuickBooks 2003; not compatible with QuickBooks 2002.
|
Income & Expense Budget Overview by Program.QBR
|
| Income and Expenses by Property |
This report helps you determine how to calculate property management fees. For each property, the report shows how much rental income was received and which expenses were paid.
|
Income and Expenses by Property.QBR
|
| Income Statement |
This report replaces the report title of the Profit & Loss Standard report with "Income Statement" which is preferred by the AICPA. Income Statement is more commonly used for compiled, reviewed, or audited financial statements.
|
Income Statement.QBR
|
| Income Statement: Previous Year Comparison |
This report replaces the title of the Profit & Loss Prev Year Comparison report with "Income Statements Prev Year Comparison." Income Statement is preferred by the AICPA. Income Statement is more commonly used for compiled, reviewed, or audited financial statements.
|
Income Statement: Previous Year Comparison.QBR
|
| Invoice Register for this Month |
This report lists all invoices and credit memos recorded for the current month.
|
Invoice Register for this Month.QBR
|
| Invoices to be Printed |
This report lists all invoices that are currently marked as "to be printed."
|
Invoices to be Printed.QBR
|
| Journal Entries Entered Last Year |
This report shows adjusting entries made by your accountant during the last fiscal year. It excludes adjusting entries made by QuickBooks.
|
Journal Entries Entered Last Year.QBR
|
| Largest Customer Balances |
This report helps you see quickly who owes you the most money. It lists the open balance for each customer, sorted from largest to smallest.
|
Largest Customer Balances.QBR
|
| Largest Vendor Balances |
This report helps you see quickly whom you owe the most money to. It lists the open balance for each vendor, sorted from largest to smallest.
|
Largest Vendor Balances.QBR
|
| Missing Invoices for All Dates |
This report lists all of your invoices in numeric order and warns you of invoice numbers that are missing or haven't been used.
|
Missing Invoices for All Dates.QBR
|
| Missing Invoices for This Month |
This report lists all of your invoices for the month in numeric order and warns you of invoice numbers that are missing or haven't been used.
|
Missing Invoices for This Month.QBR
|
| Monthly Balance Sheet: Budgeted vs. Actual |
This report shows how well you met your monthly budget for balance sheet accounts.
|
Monthly Balance Sheet: Budgeted vs. Actual.QBR
|
| Monthly Budget for Balance Sheet Accounts |
This report displays your monthly budget for each balance sheet account.
|
Monthly Budget for Balance Sheet Accounts.QBR
|
| Monthly Budget for Income and Expenses |
This report displays your monthly budget for each income and expense account.
|
Monthly Budget for Income and Expenses.QBR
|
| Monthly Income and Expenses: Budgeted vs. Actual |
This report shows how well you met your monthly budget for income and expense accounts.
|
Monthly Income and Expenses: Budgeted vs. Actual.QBR
|
| Non-Taxable Sales by Customer |
This report helps you determine which customers should never be charged sales tax. The report lists non-taxable sales, broken down by customer.
|
Non-Taxable Sales by Customer.QBR
|
| Non-Taxable Sales by Item |
This report helps you determine which items you should never charge sales tax for. The report lists non-taxable sales, broken down by item.
|
Non-Taxable Sales by Item.QBR
|
| Non-Taxable Sales Detail for Last Month |
This report lists all non-taxable sales that occurred in the past month.
|
Non-Taxable Sales Detail for Last Month.QBR
|
| Organizational Budget by Program |
This report provides an overview of your organizational budget, broken down by account and class.
|
Organizational Budget by Program.QBR
|
| Overhead as Percentage of Total Income and Expenses |
This report breaks down the income and expenses for your organization, showing each fund as a percentage of your total expenses. The column for your general fund shows the percentage that your overhead contributes to total income and expenses.
|
Overhead as Percentage of Total Income and Expenses.QBR
|
| Paycheck Audit Trail |
This report shows edits to paychecks and other employee related-transactions.
|
Paycheck Audit Trail.QBR
|
| Paychecks To Be Printed |
This report lists all paychecks marked as "to be printed." It helps you determine which paychecks you haven't printed yet.
|
Paychecks To Be Printed.QBR
|
| Payroll Compliance Report |
This report helps you verify compliance with payroll regulations. The report shows the hours, rate, and amount for all gross pay payroll items.
|
Payroll Compliance Report .QBR
|
| Payroll Expenses by Class |
This report breaks down payroll expenses by class.
|
Payroll Expenses by Class.QBR
|
| Payroll Expenses by Customer and Employee |
This report helps you determine which payroll expenses are not job-costed. The report lists payroll expenses by customer and employee.
|
Payroll Expenses by Customer and Employee.QBR
|
| Payroll Expenses by Customer and Job |
This report breaks down payroll expenses by customer and job. It is helpful if you bill customers for job-related payroll expenses.
|
Payroll Expenses by Customer and Job.QBR
|
| Payroll Item Rates and Limits |
This report displays the rate and annual limit for each payroll item.
|
Payroll Item Rates and Limits.QBR
|
| Payroll Items for Cost Allocation |
This report lists all the payroll items that you have set up as allocatable costs to customers and jobs. The report will help you determine whether your payroll items have been set up correctly for cost allocation.
|
Payroll Items for Cost Allocation.QBR
|
| Payroll Items that Affect Taxes |
This report helps you determine whether you have set up your payroll items correctly for tax calculations. The report shows all payroll items that currently affect tax calculations.
|
Payroll Items that Affect Taxes.QBR
|
| Payroll Liabilities Accrued by Month |
This report breaks down your accrued payroll liabilities by month.
|
Payroll Liabilities Accrued by Month.QBR
|
| Payroll Liabilities Balance Due by Month |
This report shows each month's balance due for your payroll liabilities.
|
Payroll Liabilities Balance Due by Month .QBR
|
| Payroll Liabilities Paid by Month |
This report can help you avoid paying payroll liabilities in the wrong month. The report shows the payroll liability payments you've made, broken down by month.
|
Payroll Liabilities Paid by Month.QBR
|
| Payroll Summary – Year to Date Comparison |
This report compares your payroll expenses for this quarter to your accumulated year-to-date expenses.
|
Payroll Summary – Year to Date Comparison.QBR
|
| Payroll Summary by Employee, Item, and Quarter |
This report provides a quick look at your summary payroll numbers for the current year. The report shows quarterly summary amounts for each employee and payroll item.
|
Payroll Summary by Employee, Item, and Quarter.QBR
|
| Pending Sales Detail |
This report lists your pending invoices, showing the line item detail for each invoice.
|
Pending Sales Detail.QBR
|
| Phone Numbers for Unpaid Bills |
This report lists your unpaid bills, showing the phone number for each vendor.
|
Phone Numbers for Unpaid Bills.QBR
|
| Previous Quarter Federal Payroll Taxes |
This report shows all of the payroll-related federal taxes that you have collected for the previous Quarter.
|
Previous Quarter Federal Payroll Taxes.QBR
|
| Profit & Loss Budget vs Actual by Program |
Profit & Loss Budget vs Actual by Program. Requires QuickBooks 2003; not compatible with QuickBooks 2002.
|
Profit & Loss Budget vs Actual by Program.QBR
|
| Program Income and Expenses: Budgeted vs. Actual |
This report provides an overview of how well your organization is meeting its budget goals. It compares budgeted amounts to actual amounts, broken down by account and class.
|
Program Income and Expenses: Budgeted vs. Actual.QBR
|
| Quarterly Balance Sheet: Budgeted vs. Actual |
This report shows how well you met your quarterly budget for balance sheet accounts.
|
Quarterly Balance Sheet: Budgeted vs. Actual.QBR
|
| Quarterly Budget for Balance Sheet Accounts |
This report displays your quarterly budget for each balance sheet account.
|
Quarterly Budget for Balance Sheet Accounts.QBR
|
| Quarterly Budget for Income and Expenses |
This report displays your quarterly budget for income and expense accounts.
|
Quarterly Budget for Income and Expenses.QBR
|
| Quarterly Income and Expenses: Budgeted vs. Actual |
This report shows how well you met your quarterly budget for income and expense accounts.
|
Quarterly Income and Expenses: Budgeted vs. Actual.QBR
|
| Retail Sales This Quarter |
This report shows the monthly sales to each customer in descending order by total sales. The report covers this fiscal quarter.
|
Retail Sales This Quarter.QBR
|
| Sales by City |
This report displays sales entered with invoices, sales receipts, credit memos and statement charges with the customer's city for each transaction. This will allow users to export the report to Excel and create summary sales reports by city.
|
Sales by City.QBR
|
| Sales by Customer Detail |
Similar to Sales by Customer Detail report, but oh so much better as the QTY is subtotaled.
|
Sales by Customer Detail.QBR
|
| Sales by State |
This report displays sales entered with invoices, sales receipts, credit memos and statement charges with the customer's state for each transaction. This will allow users to export the report to Excel and create summary sales reports by state.
|
Sales by State.QBR
|
| Sales by ZIP Code |
This report displays sales entered with invoices, sales receipts, credit memos and statement charges with the customer's zip code for each transaction. This will allow users to export the report to Excel and create summary sales reports by zip code.
|
Sales by ZIP Code.QBR
|
| Sales Volume Summary |
This report helps you see quickly which customers account for the greatest sales volume. The report lists the total sales and percentage of sales for each customer sorted from largest to smallest. The report covers the current fiscal year.
|
Sales Volume Summary.QBR
|
| Sick and Vacation Time Summary |
This report shows the accrued and used sick and vacation time for each employee as of the report date.
|
Sick and Vacation Time Summary.QBR
|
| Tax Table Usage Detail |
This report can help you spot Tax Table usage patterns quickly. The report lists all payroll transactions for the current year, showing when they were last modified and which Tax Table version was used to calculate tax amounts.
|
Tax Table Usage Detail.QBR
|
| Taxable Customer List |
This report helps you determine whether you have assigned a sales tax code to all of your retail customers. The report lists all active customers to whom you have assigned a taxable sales tax code.
|
Taxable Customer List.QBR
|
| Transactions Entered or Modified This Month |
This report lists all transactions entered during the current month.
|
Transactions Entered or Modified This Month.QBR
|
| Transactions Entered Today |
This report displays all transactions entered or modified on the current date.
|
Transactions Entered Today.QBR
|
| Unbilled Inventory Valuation Detail |
This report helps you determine which inventory items need to be billed to customers. The report shows all unbilled inventory assigned to a customer or job.
|
Unbilled Inventory Valuation Detail.QBR
|
| Uncleared Bank Transactions |
This report lists transactions for all bank accounts for the previous year that have not been reconciled.
|
Uncleared Bank Transactions.QBR
|
| Uncleared Credit Card Transactions |
This report lists all credit card transactions for the previous year that have not been reconciled. The report helps you verify that all credit card transactions have been verified prior to filing any financial reports.
|
Uncleared Credit Card Transactions.QBR
|
| Uncleared Transactions for All Bank Accounts |
This reports lists your uncleared transactions for each bank account.
|
Uncleared Transactions for All Bank Accounts .QBR
|
| Unpaid Bills at Year End |
This report lists all of your unpaid bills as of the end of the year.
|
Unpaid Bills at Year End.QBR
|
| Vendor E-mail List |
This report lists the e-mail address and current balance for each vendor. The report is useful if you frequently contact vendors by e-mail.
|
Vendor E-mail List.QBR
|
| Voided Paychecks |
This report lists all voided paychecks for the current year.
|
Voided Paychecks.QBR
|
| Wholesale Customer List |
This report helps you determine quickly whether you have assigned a resale number to each wholesale customer. The report lists all active customers to whom you have assigned a non-taxable sales tax code. The report also shows each customer's resale number, if you have assigned one.
|
Wholesale Customer List.QBR
|
