Categories
Budgeting Reports

Can I make a copy of a budget in new QuickBooks Online?

You can “copy from an existing budget” to create new budget.

From the company gear (upper right hand corner) > Tools > Budgeting > select “New Budget” blue button (top right)

It will take to mini-interview screens. Page 2 of 4 mini-screen page will give you selection to choose “copy from and existing budget” drop-down selector.

Categories
Reports

In QB Online Plus can you run a trial balance by class?

Currently, there is no standard built-in Trial Balance by Class Report in QuickBooks Online. There is no way to customize from existing Trial Balance report.

You can run the Balance Sheet by Class (less Net Income line) and Profit and Loss by Class. Export it to Excel and merge it together.

That combined adjusted numbers distributed by class should be the same as the numbers in Trial Balance by Class if available.

If you think you need this feature added to future revision, you should send them your feedback to Intuit developers. You can create an “open customer feedback request” case from this Intuit website. This way other QBO users can also add valuable comments to your request. You can also review and vote on what other QBO users are asking for from here.
http://feedback.qbo.intuit.com/

post your idea

 


What’s on our feature request radar in QBO?

Many of our dedicated QBO users are asking for running balance in check register be a fixed permanent feature. You can also help by adding your Vote.

http://feedback.qbo.intuit.com/forums/168199-quickbooks-online-feature-requests/suggestions/10331052-running-balance-in-check-register

running balance in check register

 


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








Categories
Reports Settings

How do I change the accounting method for my company in new QuickBooks Online?

Accounting methods
Cash basis and accrual basis are accounting methods that determine when and how you report income and expenses for tax purposes.
The IRS wants you to use the same method each year when reporting income or loss. You should talk to your accountant about which is most appropriate for your business.

What is cash basis?
When you use cash basis as the accounting method, income is reported when you receive payments, instead of when you invoice a customer. Expenses are reported when you pay bills by cash, check, debit card, credit card or any other forms of payment that takes out money from your bank account. If you use invoices (Create (+) > Customers > Invoice) and receive bills (Create (+) > Vendors > Bill) to pay later this report method will affect the amount reflected in your A/R and A/P accounts.  On cash basis method,  when you run the company’s Balance Sheet, it should show  zero balance (or no balance) on A/R and A/P accounts.

What is accrual basis?
With accrual basis as the standard accounting method, income is reported as soon as you create invoice to a customer (Create (+) > Customer > Invoice) instead of when you record the payment and  expenses are reported when you record a bill (Create (+) > Vendor > Bill) instead of when you record the payment.

Accrual basis is more financially accurate than cash basis reporting. It also may let you manage your business better by showing you trends in income and expenses well in advance of the actual payments you make or receive.

To change company setting for the accounting method:

From the home page screen

  1. Go to the Company “Gear” tab and click Company Settings under Settings.
  2. Select “Account Method” under Company heading.
  3. Choose the accounting method to which you’d like your reports to default, and then click Save.

Note:  You can also keep your overall accounting method for reporting unchanged, but experiment with changing the accounting method only on an individual report here and there to see the difference that change makes in your reporting.

To change the accounting method on a report:

From the home page screen

  1. Go the blue navigation bar on the left,  click the Reports tab
  2. Go to report (magnifying glass) and type to open the report and select the report you’d like to view (for example Profit and Loss report, type Profit and Loss).
  3. At the top left, click the Customize blue button.
  4. In the new window that opens, go to the General section and then note the Accounting Method selected.
  5. You can click to select a new accounting method (cash basis or accrual).
  6. Make any other necessary selections and click Run Report.

How do I change the accounting method for my company in new QuickBooks Online

Categories
Reports

How to create a profit and loss report for selective accounts from our chart of accounts. Can this be done in new QuickBooks Online?

Let’s say in this example, you want to run profit and loss report for only two specific accounts from the chart of accounts:
Sales of Product Income and Costs of Goods

Yes, you can pull P&L report for those two accounts only in QuickBooks Online. Here’s how to start from the home page screen:

  • Click on the “Reports” link on the left hand side blue navigation bar of your screen
  • When the reports screen loads for you, there should be a “Go to report” search bar for you in the center of that screen
  • Go ahead and type “Profit and Loss” into that search bar
  • At that point, you can select the Profit and Loss report you would like to see. When it loads, you can alter the date range to show just the time range you need that report for
  • Click “Customize” button on the upper left corner
  • Select “Lists” under Customize Profit and Loss
  • Go to “Distribution Account” and choose “Select Multiple”
  • New “Select Accounts to Include in Report” will open
  • Add this point, you just need to choose “Add” button to add accounts
  • In this example, we want to add “Sales of Product Income” account and “Cost of Goods Sold” account from the list which is the Company’s Chart of Accounts
  • Click “OK” button
  • Click “ Run Report” button
  • It will take few seconds to load the revised report
  • Review it and choose Save Customization button if needed to memorize this report.

How to run Profit and Loss Report for selective accounts from Chart of Accounts in QuickBooks Online

Categories
Reports Sales Tax

I don’t see any data when I run sales tax report. I list non taxable and taxable sales when I deposit sales

In order to get total sales and taxable sales with sales tax collected, you will need to run a “Sales by Customer Detail” report. This stand-alone report will not give you all the information you need to file the Sales Tax Return. You will need to further customize it to work-around.

To do this, you will to run a “Sales By Customer Detail” report, customize it and add “tax amount” and taxable amount” columns from selecting “Change Columns.

These are the necessary steps, you will need to take.

  • From the blue navigation bar on the left
  • Select Reports
  • Select “Go to report” (magnifying glass), type Sales by Customer Detail
  • Select “Sales by Customer Detail” from drop-down selector
  • Change Transaction Date as needed
  • Select “Customize” blue button (upper left)
  • Select “Change Columns” under Rows/Columns
  • Add Tax Amount (refers to tax collected)
  • Add Taxable Amount (refers to taxable sales)
  • Add Tax Name (if needed)
  • Select Remove button and remove unnecessary columns (optional)
  • Click OK button
  • Click Run Report

This will give Total Sales and Total Taxable Sales. Subtract these two columns in order to get Non-Taxable Sales.

Recommended: Also click “Save Customizations” button to make this as customized report for future use.

 

Customize Sales Tax Report - Change Columns
Customize Sales Tax Report – Change Columns

Customize Sales Tax Report - Total Sales and Taxable Sales

Customize Sales Tax Report - Taxable and Non-Taxable Sales

Categories
Reports

How to run previous months (not last reconciled) bank reconciliation reports in new QuickBooks Online?

This new QBO is very unfriendly on navigating previous months (not last reconciliation) bank reconciliation report. You can get it, although it’s hidden. It just takes one extra step to run this report.

From the home page screen

  • Select blue navigation bar on the left
  • Select Reports
  • Type in “Reconciliation Reports” in the search box (Gor to report, magnifying glass)
  • Select and click bank account under Account heading (or any other links)
  • It will take you to the last reconciled report.
  • Go to upper-left-corner and select previous reconciliation report from the drop-down selector under Period Ending (next Run Report button). Now, you’ve found previous months reconciliation reports.
  • See attached screenshot photos for reference

As I said, they made this very unfriendly process.

Reconciliation Reports
Reconciliation Reports
Run previous reconciliation report
Run previous reconciliation report

Help Video:

Categories
Company Gear Company Settings Custom Form Styles Customer Center Customers Invoice Reports Sales

How to run customized Sales Report by Sales Rep in new QuickBooks Online?

There is no built-in business report available by Sales Rep in new QBO at this time. By using available custom field on the sales forms (invoice and sales receipt), you can easily get the information by selecting and customizing standard built-in “SALES BY CUSTOMER SUMMARY” report.

This quick and easy tutorial video shows you how to customize sales report by sales rep for tracking sales and manually computing sales commissions in the new QuickBooks Online (QBO).

Here is another top-rated tutorial video by VPController for newQBO.com. We encourage you to watch the entire video.. You do not want to miss a step!

Sign up QuickBooks subscription for new company. Or add additional company subscription for using the same user ID (choose “Already have an Intuit user ID?”)

Categories
Reports

How to get a Balance Sheet Detail report that can be printed as one report in new QuickBooks Online?

Although there is no standard “Balance Sheet Detail” report in new QuickBooks Online, you can run and customize the “General Ledger” report which should reflect exactly like the “Balance Sheet Detail” report if there’s one such standard report.
To run this report, from the home page screen

  • Go to blue navigation bar on the left
  • Select Reports
  • Select “Go to report” (magnifying glass) type General Ledger
  • Select “General Ledger”
  • Click “Customize” button on top left
  • Select “Lists” on the left
  • You will notice “Account” and “All” as default under Lists
  • Select “All Balance Sheet Accounts” under Account drop-down selector
  • Change Report Title from “General Ledger” to “Balance Sheet Detail” under Header/Footer heading
  • Run Report
  • Change Transaction Date as needed
  • Save Customizations button, if like to Customize Reports for permanent use
Categories
Reports

How can I run a report that shows total income and total expenses for a specific customer (client) in the new QuickBooks Online?

Run Profit and Loss report and customize by customer.

GO to blue navigation bar (located on the left)

  • Select Reports
  • Go to report and type Profit & Loss
  • Select “Profit & Loss” from the drop-down selector
  • Run Profit & Loss report (for the wanted transaction date)
  • Click Customize button
  • Click Lists
  • Select “Customer” from the drop-down list (see attached screenshot below for reference)
  • Click Run Report

Optional: Click “Save Customizations” button if you need to make this report as Custom Report for future

Notes:

      Main source of income details = Created Invoice and Created Sales Receipts plus any issued credits
      Main source of expense details = Entered expense and product/service tracking by customer from Vendors & Purchases
Customize P&L by Customer
Customize P&L by Customer
Customize P&L by Customer Report
Customize P&L by Customer Report
Categories
Budgeting Reports

How do you run a Budget vs Actual P&L report in new QuickBooks Online?

Budget Reports

Budget vs. Actuals is a standard report in new QuickBooks Online. Once you have entered budget in QBO, you can run the following two reports:

      Budget Overview
      Budget vs. Actuals

To run this report:

  • From the home page screen
  • Go to blue navigation bar on the left
  • Select Reports
  • Select “Go to report” (magnifying glass), type Budget (or select from drop-down selector
  • Select Budget vs Actuals report
  • Customize as required

Go to Budget Report
Go to Budget Report

58-Budget Overview
58-Budget Overview

59-Budget vs Actuals
59-Budget vs Actuals