QuickBooks Best Practices

QuickBooks Best Practices

Add a rate to your time entries

  1. Go to the Sales or Invoicing menu.
  2. Select Product and Services.
  3. Look for the service item you want to modify.
  4. Select the Edit button.
  5. Enter an amount in the Sale price/rate field.

🚧

Please Note:

QuickBooks does not allow updates to time entries that have been linked to an invoice.

Future time entries with this service item will include this rate amount.

Add a customer for your clients

  1. Go to the Sales menu.
  2. Select the Customers tab.
  3. Select New Customer.
  4. Enter your customer’s info.
  5. Select Save.

Tip: If you need to keep notes or mark a customer as tax-exempt, you can enter this when you create their profile.

Add a sub-customer/job for your projects

You can create sub-customers of main customers (also known as parent accounts). This is useful if you want to track individuals who are part of a group or specific accounts for a larger organization.

First, create a regular customer account for the group or organization. Then add each member or account as a sub-customer:

  1. Go to the Sales menu.
  2. Select the Customers tab.
  3. Select New Customer.
  4. Select the Is sub-customer checkbox.
  5. Enter the sub-customer’s info.
  6. In the Parent ▼ dropdown, select the parent account.
    Tip: Select Bill with parent or Bill this customer if you want to bill sub-customers individually or as part of the group.
  7. Select Save.

You can have unlimited sub-sub-customers. Parent project can have up to three levels down of sub-customers.

Add a sub-sub-customer/sub-job for your phases

You can create sub-customers of main customers (also known as parent accounts). This is useful if you want to track individuals who are part of a group or specific accounts for a larger organization.

First, create a regular customer account for the group or organization. Then add each member or account as a sub-customer:

  1. Go to the Sales menu.
  2. Select the Customers tab.
  3. Select New Customer.
  4. Select the Is sub-customer checkbox.
  5. Enter the sub-customer’s info.
  6. In the Parent ▼ dropdown, select the parent account.
    Tip: Select Bill with parent or Bill this customer if you want to bill sub-customers individually or as part of the group.
  7. Select Save.

You can have unlimited sub-sub-customers. Parent project can have up to three levels down of sub-customers.

Make a sub-customer into a regular customer or vice versa

Simply edit the sub-customer's profile and uncheck the Is sub-customer checkbox.

Merge duplicate customers

If you have duplicate customers, merge their profiles. This deletes one profile and moves their existing data into the profile you want to keep.

  1. Make sure both customers don't have any sub-customers. If they do, make their sub-customers into regular customers.
    2. Go to the Sales menu.
    3. Select the Customers tab.
    4. Select and open the customer profile you don’t want to keep.
    5. Select Edit.
    6. In the Display name as field, enter the name of the customer profile you want to keep. The names need to match exactly.
    7. Select Save.
    8. When asked if you want to merge the two profiles, select Yes.
    Add a new product or service item for Work Categories
    You only have to create a product or service once. After you create them, you can add them to sales forms as many times as you need.
    1. Go to the Sales menu and select the Products and services tab.
    2. Select New.
    3. Select Non-inventory or Service.
    4. Add a name. If you track SKUs, enter a SKU for the product.
    5. From the Category ▼ dropdown, select the category that best describes your product or service. Learn more about item categories.
    6. When you're done, select Save and Close.

Tip: Already keeping track of your products and services in a spreadsheet? Save time and import them all at once.

Other Supported Data Formats

  • Customer(s) associated with your Client(s)
  • Sub-Customer for your Projects
  • Service Item for Phases
  • Customer(s) for your Project(s)
  • Sub-Customer(s) for your Sub-Project(s)
  • Service Item(s) for Phases

Mosaic Best Practices

How to promote and demote a QB customer on Mosaic

For missing Projects (QB sub-customer) that are showing up as Clients (QB customer) in Mosaic, you will need to demote the client to become a project.

For missing Clients (QB customer) that are showing up as Projects (QB sub-customer) in Mosaic, you will need to promote the project to become a client.

For missing Projects (QB sub-customer) that are showing up as Phases (QB sub-sub-customer) in Mosaic, you will need to promote the phase to become a project.

Demote a client (QB customer) to become a project (QB sub-customer)

  1. On Mosaic, go to Settings > Integrations > QuickBooks
  2. Under the Clients tab, find the client (QB customer) that you want to demote to a project
  3. Select the client and click Change to Project
30743074
  1. Navigate to the Projects tab > Linked
  2. You should find the new project listed under No Client
31063106

Promote a project (QB sub-customer) to become a client (QB customer)

  1. On Mosaic, go to Settings > Integrations > QuickBooks
  2. Under the Projects tab, find the project (QB sub-customer) that you want to promote to a client
  3. If the project is linked, unlink the project first
24582458
  1. Under Import, select the project and click Change 1 to Client
22262226
  1. Navigate to the Clients tab
  2. You should find the new client listed under QuickBooks Online CUSTOMERS TO IMPORT/LINK
25182518

❗️

Please Note:

Only Projects without a Client can be promoted to become a Client

Promote a phase (QB sub-sub-customer) to become a project (QB sub-customer)

  1. On Mosaic, go to Settings > Integrations > QuickBooks
  2. Under the Projects tab, find the phase (QB sub-sub-customer) that you want to promote to a project
  3. If the phase is linked, unlink the phase first
  4. Click the three dots to the right of the phase and click Change to Project
27602760
  1. You should find the new project now listed under No Client
25522552

How to Link a QuickBooks Project to a Mosaic Project

When to use Make Main Project a Phase

Use Make Main Project a Phase when:

  • Scenario 1: You do not have phases on the QuickBooks project or Mosaic project.
    • This syncs time entries directly under the Mosaic to the QuickBooks project (and vice versa). Use this when you are expecting to add time to the main project on either Mosaic or QuickBooks.
25602560
  • Scenario 2: You do not have phases on the QuickBooks project but do have phases on the Mosaic project, and are entering time on the Mosaic project and want that time to sync directly under the QuickBooks project.
    • This syncs time entries under the phases in the Mosaic project to directly under the QuickBooks project. Use this when you are expecting to add time to your Mosaic phases and want that time to sync directly under the QuickBooks project.

🚧

Please Note:

If you do not have phases on the QuickBooks project but do have phases on the Mosaic project, and have selected Make Main Project a Phase, time entries entered on QuickBooks (directly under the project) will sync to a default phase on the Mosaic project.

This default phase is not visible on the Integration Settings > Projects tab, but it is visible on the Project Budget modal, on each individual time entry, etc.

25042504

When to use Link all Phases to QuickBooks Project

Use Link all Phases to QuickBooks Project if you have phases on the Mosaic project but do not have phases on the QuickBooks Project.

This syncs time entries under all phases in Mosaic to the QuickBooks project.

25722572

When to use Import all phases to Mosaic Project

Use Import all phases to Mosaic Project if you have phases on the QuickBooks project but do not have phases on the Mosaic Project.

This syncs time entries under all phases in Mosaic to the corresponding phases in QuickBooks.

25582558

How to check if your project is linked

  • A Green Link Icon indicates that all phases are linked or the main project is a phase.
24962496
  • A Yellow Link Icon indicates that some phases are linked. The tool tip on hover will display the number of QuickBooks / Mosaic Phases that are linked / not linked.
25162516
  • A Red Link Icon indicates that none of the phases are linked or the main project is not a phase. No time entries will sync between the QuickBooks project and Mosaic project if you see a Red Link Icon for the project.

To resolve, you can:

24962496