How do I view or print previous bank reconciliation reports in QuickBooks Online QBO

To view or print the previous bank reconciliation report:

1. From the left Dashboard, select Reports.
2. Go to “For my accountant” section and select Reconciliation Reports.
3. Select Account. Select Report period.
4. Select “Statement Ending Date”.
5. Click “View Report” under Action column.
6. Click Print icon to print the report.

How to undo bank reconciliation in QuickBooks Online Accountant (QBOA) version?

What are the specific reports available in Plus version of Quickbooks Online

Plus plan is the top-of-the-line version of QuickBooks Online. The plan comes with main features like projects, purchase order, billable expenses to customers, class, location, budgeting, and inventory which are not available in Essentials.

These are the built-in standard reports available in Plus plan (June 2018).

Business Overview (19 reports):

  • Audit Log
  • Balance Sheet Comparison
  • Balance Sheet Detail
  • Balance Sheet Summary
  • Balance Sheet
  • Budget Overview
  • Bundget vs. Actuals
  • Business Snapshot
  • Profit and Loss as % of total income
  • Profit and Loss Comparison
  • Profit and Loss Detail
  • Profit and Loss year-to-date comparison
  • Profit and Loss by Class
  • Profit and Loss by Customer
  • Profit and Loss by Location
  • Profit and Loss by Month
  • Profit and Loss
  • Quarterly Profit and Loss Summary
  • Statement of Cash Flows

For General Ledger (GL) and Trial Balance, see below under “For my accountant” section.

Who owes you (11 reports):

  • Accounts Receivable aging detail
  • Accounts Receivable aging summary(1)
  • Collections Report
  • Customer Balance Detail
  • Customer Balance Summary
  • Invoice List
  • Open Invoices
  • Statement List
  • Terms List
  • Uninvoiced charges
  • Uninvoiced time

Sales and Customers (12 reports):

  • Customer Contact List
  • Deposit Detail
  • Estimates by Customer
  • Income by Customer Summary
  • Payment Method List
  • Product/Service List
  • Sales by Customer Detail
  • Sales by Customer Summary
  • Sales by Product/Service Detail
  • Sales by Product/Service Summary
  • Time Activities by Customer Detail
  • Transaction List by Customer

What you owe (6 reports):

  • Accounts payable aging detail
  • Accounts payable aging summary
  • Bill Payment List
  • Unpaid Bills
  • Vendor Balance Detail
  • Vendor Balance Summary

Expenses and Vendors (5 reports):

  • 1099 Transaction Detail Report
  • Check Detail
  • Expenses by Vendor Summary
  • Transaction List by Vendor
  • Vendor Contact List

Sales tax (3 reports):

  • Sales Tax Liability Report
  • Taxable Sales Detail
  • Taxable Sales Summary

Employees (3 reports):

  • Employees Contact List
  • Recent/Edited Time Activities
  • Time Activities by Employee Detail

For my accountant (15 reports):

  • Account List
  • Balance Sheet Comparison
  • Balance Sheet
  • General Ledger
  • Journal
  • Profit and Loss Comparison
  • Profit and Loss
  • Recent Transactions
  • Reconciliation Reports
  • Recurring Template List
  • Statement of Cash Flows
  • Transaction Detail by Account
  • Transaction List by Date
  • Transaction List with Splits
  • Trial Balance

Manage Payroll:
(Once you are subscribed to the Intuit Payroll service, you should see the following reports)

  • Time Activities by Employee Detail
  • Recent/Edited Time Activities
  • Payroll Summary
  • Payroll Tax Liability
  • Payroll Tax Payments
  • Payroll Billing Summary
  • Payroll Details
  • Employee Details
  • Payroll Tax and Wage Summary
  • Workers’ Compensation
  • Total Payroll Cost
  • Payroll Deductions/Contributions
  • Paycheck List
  • Total Pay
  • Vacation and Sick Leave
  • Retirement Plans
  • Multiple Worksites
  • Employee Directory

My Custom Reports
You can customize many of the built-in reports and make it your own reports. Set up to automatically distribute by email. Awesome!

Management Reports
Professional set of ready-to-use management reports as prepared by accounting firms. Also, an ability to add additional built-in reports to the management reports. You can’t automate the reports at this time.

If you found our answers useful then please contribute few bucks to support this forum. Thank you!





Thank you!






Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada








What are the specific reports available in Essentials version of Quickbooks Online

Essentials plan is the middle version of QuickBooks Online. The plan comes with main features like Vendor payables, time tracking, and recurring transactions which are not available in Simple Start plan. But it still lacks few other features like projects, purchase order, billable expenses to customers, class, location, budgeting and inventory which are available in Plus plan only.

These are the built-in standard reports available in Essentials plan (June 2018).

Business Overview (15 reports):

  • Audit Log
  • Balance Sheet Comparison
  • Balance Sheet Detail
  • Balance Sheet Summary
  • Balance Sheet
  • Business Snapshot
  • Profit and Loss as % of total income
  • Profit and Loss Comparison
  • Profit and Loss
  • Profit and Loss year-to-date comparison
  • Profit and Loss by Customer
  • Profit and Loss by Month
  • Profit and Loss
  • Quarterly Profit and Loss Summary
  • Statement of Cash Flows

For General Ledger (GL) and Trial Balance, see below under “For my accountant” section.

Who owes you (11 reports):

  • Accounts Receivable aging detail
  • Accounts Receivable aging summary(1)
  • Collections Report
  • Customer Balance Detail
  • Customer Balance Summary
  • Invoice List
  • Open Invoices
  • Statement List
  • Terms List
  • Uninvoiced charges
  • Uninvoiced time

Sales and Customers (12 reports):

  • Customer Contact List
  • Deposit Detail
  • Estimates by Customer
  • Income by Customer Summary
  • Payment Method List
  • Product/Service List
  • Sales by Customer Detail
  • Sales by Customer Summary
  • Sales by Product/Service Detail
  • Sales by Product/Service Summary
  • Time Activities by Customer Detail
  • Transaction List by Customer

What you owe (6 reports):

  • Accounts payable aging detail
  • Accounts payable aging summary
  • Bill Payment List
  • Unpaid Bills
  • Vendor Balance Detail
  • Vendor Balance Summary

Expenses and Vendors (5 reports):

  • 1099 Transaction Detail Report
  • Check Detail
  • Expenses by Vendor Summary
  • Transaction List by Vendor
  • Vendor Contact List

Sales tax (3 reports):

  • Sales Tax Liability Report
  • Taxable Sales Detail
  • Taxable Sales Summary

Employees (3 reports):

  • Employees Contact List
  • Recent/Edited Time Activities
  • Time Activities by Employee Detail

For my accountant (15 reports):

  • Account List
  • Balance Sheet Comparison
  • Balance Sheet
  • General Ledger
  • Journal
  • Profit and Loss Comparison
  • Profit and Loss
  • Recent Transactions
  • Reconciliation Reports
  • Recurring Template List
  • Statement of Cash Flows
  • Transaction Detail by Account
  • Transaction List by Date
  • Transaction List with Splits
  • Trial Balance

Manage Payroll:
(Once you are subscribed to the Intuit Payroll service, you should see the following reports)

  • Time Activities by Employee Detail
  • Recent/Edited Time Activities
  • Payroll Summary
  • Payroll Tax Liability
  • Payroll Tax Payments
  • Payroll Billing Summary
  • Payroll Details
  • Employee Details
  • Payroll Tax and Wage Summary
  • Workers’ Compensation
  • Total Payroll Cost
  • Payroll Deductions/Contributions
  • Paycheck List
  • Total Pay
  • Vacation and Sick Leave
  • Retirement Plans
  • Multiple Worksites
  • Employee Directory

My Custom Reports
You can customize many of the built-in reports and make it your own reports. Set up to automatically distribute by email. Awesome!

Management Reports
Professional set of ready-to-use management reports as prepared by accounting firms. Also, an ability to add additional built-in reports to the management reports. You can’t automate the reports at this time.

If you found our answers useful then please contribute few bucks to support this forum. Thank you!





Thank you!






Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada








How do I run a weekly report of Sales Receipts from customers/clients

Most of the reports in QBO, you can’t customize the way you want it. Just wish, they’ve simple weekly sales reports filter by sales transaction type like Sales Receipt but they don’t.
The ideal report in QBO would be SALES BY CUSTOMER SUMMARY group by week. But this report you can’t filter it by Transaction Type to get Sales Receipts only.

In the meantime, you can run TRANSACTION LIST BY CUSTOMER report to get the data.

  • Report period = select as needed
  • Rows/columns Group by = Week
  • Customize > Filter > Transaction Type = Sales Receipt

You can make this My Custom Reports by clicking Save Customization button at the top right. Next time you will see this in My Custom Reports tab,

Prepare and file 1099s in QuickBooks Online Plus Subscription

Prepare and file 1099s in QuickBooks Online Plus Subscription
QuickBooks Help for filing 2016 1099-MISC forms.
From the article:
We’ve created this guide to help you prepare, distribute, and file 1099-MISC forms for your vendors.

  • See 1099 checklists and deadlines
  • Prepare and file 1099s in QuickBooks

Thank you for your business in 2016. Here’s to a successful new year in 2017! ….


 

FREQUENTLY ASKED QUESTIONS
Question: How to run 1099 Vendor Summary Report in QBO Plus?

Answer: Unfortunately, there is no such built-in report yet available in any QBO plus.
The workaround is to run Vendor Transaction Details Report and filter select vendors (who you think should get 1099s) from the report but that many not determine who should actually get a 1099-MISC based on such transactions.

Refer to these articles and also consult your Accountant.


 







QuickBooks Online - Buy now and save 50%



FREE Trial
USA
CANADA

XERO - Alternative to QuickBooks

SAGE 50 Accounting

Limited Time Offer—Save Up To 37% On Sage 50 Accounting Software!

How do I create a Profit and Loss Report by Month for entire last year

New Redesigned report format (still in QuickBooks Labs):
From the home page screen, go the left navigation bar and select Reports
Go to report (search field) and type Profit and Loss
Run the regular Profit and Loss Report
Under “Report period” tab, select “Last year” (or report period as you need it)
Under Display columns by tab, select “Months” columns
Run Report

See screenshot below.

profit-and-loss-by-month-redesigned

 

Old Report format:
From the home page screen, go the left navigation bar and select Reports
Go to report (search field) and type Profit and Loss
Run the regular Profit and Loss Report
Click “Customize” button (top left corner)
Select Transaction Date to “Last Year” (or report period as you need it)
Under Rows/Columns, select “Months” columns
Run Report

See screenshot below.

profit-and-loss-by-month-old

Optional: Click “Save Customization” button at top right corner, if you want to make it your pwn memorized report under “My Custom Reports” tab.

 
Other Option

From the home page screen, go the left navigation bar and select Reports
Select “All Reports” tab
Select “Business Overview” tab
You may also see the “Profit and Loss by Month as new report

See screenshot below.

profit-and-loss-by-month-new

 





Why mark it billable to a customer and select “track returns for customers” box on a bank deposit

This has to do with reflecting accurate direct expenses related to customers on Income by Customer Report.

If you are depositing a vendor/supplier refund for an expense that was previously Billed to a customer, select “Track returns for customers” box and choose that same customer on the deposit and mark it Billable.

For example, if you buy a material for a customer’s job, you would bill the expense to the customer. But if the customer later returns the material to you and you return it to the vendor/supplier for a refund that you are depositing, you need to mark the deposit billable to that same customer and also select “Track returns for customers” box. Otherwise, it will show as customer billed for the material expense, and the vendor credit will not appear on Income by Customer Summary Report.


 





 
Here is an example of what happens when $1,000 billable purchase returned to the supplier for a refund and deposited that money in the bank. The goal is to show zero expense related to that customer.

SHOWING RESULT WITHOUT BILLABLE AND RETURNS FROM CUSTOMERS

deposit without billable-and track returns for customers
deposit without billable-and track returns for customers
income by customer summary without billable track returns from customers
income by customer summary without billable track returns from customers

SHOWING RESULT WITH BILLABLE AND RETURNS FROM CUSTOMERS

deposit with billable and track returns for customers
deposit with billable and track returns for customers
income by customer summary with billable track returns from customers
income by customer summary with billable track returns from customers

 
WATCH VIDEO
QuickBooks Online Plus: Track returns for customers box on Deposit Form


 





 

Converted to a new accounting system from QBO. What QBO data do I need to keep in the event of an audit?

Here is a list of reports I recommend to have it on record (export to excel, or save as pdf) before canceling the QBO subscription:

  1. General Ledger (All Dates). Depending upon the file size limits, it may need to be downloaded in batches.
  2. Trial Balance by Fiscal Year Ending
  3. Bank Reconciliation Reports (for last three months)
  4. A/R Aging Report
  5. A/P Aging Report
  6. Open Invoices to match A/R Aging Report
  7. Open Bills to match A/P Aging Report
  8. Profit and Loss by Fiscal Year
  9. Balance Sheet by Fiscal Year Ending
  10. Sales Tax Liability Report (+ Taxable Sales Detail and Summary)
  11. Contact List (Vendor and Customer)
  12. Chart of Accounts

Note: Even after QBO cancellation, you will still have access to company file for a year. Just make sure the account is canceled, not suspended.