Categories
QuickBooks Online QBO Sales

How to Record Consignment Sales on Consignee’s Books in QuickBooks Online

Categories
Cash Flows QuickBooks Online QBO

Cash Flow Dashboard Widget in QuickBooks Online

To turn this on: Gear > Your Company > QuickBooks Labs

The cash flow chart uses historical data from your Banking tab — bank connected transactions only.

The chart excludes:

CSV import, Credit card, entered manually into QBO, Multicurrency transactions

More Info…

Categories
Payroll QuickBooks Online QBO

QuickBooks Online: Employees and Payroll Helpful Articles

QuickBooks Online: Employees and Payroll Helpful Articles

Top 5 new posts:

Top 5 posts with an accepted solution:

Top 5 posts without an accepted solution:

Categories
QuickBooks Online QBO

How to record forgiveness of debt loan by vendor and bank in Quickbooks Online


Forgiveness of Debt Income
Forgiveness of Debt Income Account

Forgiveness of debt by vendor - creating vendor credit to clear open bill (A/P)
Forgiveness of debt by the Vendor – creating vendor credit to clear open bill (A/P)

Forgiveness of credit debt by credit card company
Forgiveness of credit debt by the Credit Card Company

Forgiveness of debt loan by loan company
Forgiveness of debt loan by the Loan Company

 

Categories
QuickBooks Online QBO

Tags in QuickBooks Online QBO – Tracking County Sales, Out of State Sales, Sales to Pay Rep Commissions

Tag transactions in QuickBooks Online

Tags are customizable labels that let you track transactions however you’d like right for your business.

You can tag transactions such as invoices sales receipts, expenses, checks, and bills.

When you put Tags into Tag Groups, you can easily see how your business is doing. You’ll need Tag Groups to get reports for your tags. Currently, they have got the following two standard reports:

  1. Profit and Loss by Tag Group
  2. Transaction List by Tag Group

In this video, it will show how to tag transactions for tracking California County Sales, Out of State Sales and Sales to pay Rep Commissions.

Examples of creating a tag group and tags:

Example 1:

  • Tag Group = Tracking California Statewide Sales or Out of State Sales
  • Tags = California counts such as Alameda, Humboldt, Merced, San Bernardo, Salona and so on.

Example 2:

  • Tag Group = Tracking Sales to pay Sales Commissions
  • Tags = Name of Sales Reps like Joe, Amy, Bette, Matthew, Bill, Jennifer and so on.
Tags Overview
Tags Overview

County Sales
County Sales
Sales by Sales Rep & Commission Expense
Sales by Sales Rep & Commission Expense
Transaction List
Transaction List



 

Categories
QuickBooks Online QBO

How can I make batch changes to categorized transactions without having to go through and click every single one of them in my register

Here is how to modify your transactions by batch so you’ll not go through each and every single one of them in your register:

With your expense transactions, you can visit the Expenses menu from the left Dashboard. You can filter the transaction you want to update except Split transaction, then categorize them.

  • Go to the Expenses menu from the left Dashboard.
  • Select the Expenses tab.
  • Click the Filter drop-down.
  • Choose Type, Dates, and Category as you need.
  • Select Apply.
  • Choose the transaction by clicking the box beside the Date column.
  • Click the Batch actions drop-down arrow, then select Categorize selected.
  • Select the correct category by clicking the drop-down arrow in the Categorize Selected window.
  • Click Apply.

In this example below, it shows how to batch recategorize expenses from the Purchases account category to the Purchases-1 account category.

Note: Batch action will not work on split transactions. Split transaction means more than one account has been used to record the transaction.

Categories
QuickBooks Online QBO

QuickBooks Online Tutorial: QuickBooks 2020 Getting Started for Beginners

QuickBooks Online Tutorial: QuickBooks 2020 Getting Started for Beginners

Sign up QuickBooks for a 30-day FREE Trial https://newqbo.com/test-drive/

Compare Features and Usage Limits of QuickBooks Online Plans – Advanced, Plus, Essentials, and Simple Start https://newqbo.com/features-and-usage-limits-in-various-quickbooks-online-plans/

Categories
QuickBooks Online QBO

How to customize Sales Report by Sales Rep to calculate Commissions in QuickBooks Online QBO

Currently, there is no built-in Customer Sales Detail by the Sales Rep report to pay commission in QBO at this time.

The workaround in QBO is to use one of three available custom fields on the sales forms (invoice and sales receipt) for Sales Rep (as a text field). And then you can run the standard Sales by Customer Detail Report, and filter Group by Sales Rep. Since this is just a text field so you will need to assign sales rep every time you create an invoice or sales receipt.

With QBO Advanced version, you can assign Sales Rep at the Customer Information level but on other plans, such feature option is not available.

Customer Sales Detail Report customized by Sales Rep
Gear icon > Your Company > Account & Settings > Sales > Sales form content > Custom fields > Save
Create an Invoice: Select “+ New” > Customers > Invoice (or Sales Receipt > Enter Sales Rep
Run Report: Left Dashboard > Reports > Select Sales by Customer Detail > Filter Group by “Sales Report” > Run Report. (Optional: Save Customization button if you want to customize this report to make it your own report).
Categories
QuickBooks Online QBO

Compare Features and Usage Limits of QuickBooks Online Plans – Advanced, Plus, Essentials, and Simple Start

The following table will show features and usage limits available in various QuickBooks Online plans:

Compare Features and Usage Limits of QuickBooks Online plans - Advanced, Plus, Essentials, Simple Start

 AdvancedPlusEssentialsSimple Start
Features
Price RulesYesYesNoNo
InventoryYesYesNoNo
Progress InvoicingYesYesYesYes
Track expenses and items by customerYesYesNoNo
Makes expenses and items billableYesYesNoNo
Purchase OrdersYesYesNoNo
Track classesYesYesNoNo
Track locationsYesYesNoNo
ProjectsYesYesNoNo
Time TrackingYesYesYesNo
Multi CurrencyYes YesYesNo
Recurring TransactionsYesYesYesNo
Custom FieldsYesNoNoNo
Manage WorkflowsYesNoNoNo
Import Data - Invoices from Excel CSV fileYesYesYesYes
BudgetingYesYesNoNo
Customer TypesYesYesNoNo
Customers - Delayed credit and Delayed chargeYesYesYesNo
Accounts Payable (Bill & Pay Bills)YesYesYesNo
Enter Batch Transactions for Invoices, Checks, Expenses, BillsYesNoNoNo
QBO Support - Priority CircleYesNoNoNo
Apps: Chronobooks, FathomYesNoNoNo
Usage limits
Billable Users25531
Invite Accountants/Accounting Firms3222
Chart of AccountsUnlimited250250250
Classes and locationsUnlimited40Not availableNot available

In this video, we will do a full comparison between various QuickBooks Online plans. We will do a deep dive into every aspect of Advanced, Plus, Essentials, Simple Start versions of QBO, and review all their features one by one. Hopefully, it will provide you with enough information to evaluate the right QBO plan for your business.


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





Categories
Import Data Invoice QuickBooks Online QBO

How to import INVOICES from Excel in QuickBooks Online QBO

Importing Invoices from Excel
Import Map Fields

UPDATE: This import invoices from the Excel CSV feature is available on all QBO plans now. Steps: Gear – Tools – Import Data – Invoices.