QuickBooks Link Invoice Creation Options

User Manuals > QuickBooks Link > QuickBooks Link Invoice Creation Options

With the Commit-QuickBooks Link you can create invoices in QuickBooks based on charges entered in CommitCRM.

This feature allows you to manage all the aspects of your service in one program: CommitCRM. You can manage Tickets, enter Charges, etc. in CommitCRM, while all billing is managed in QuickBooks.

QuickBooks invoices can easily be created from CommitCRM at the customer level, the service contract level and the ticket level.

All invoices created from CommitCRM are based on Charge records added in CommitCRM. Each Charge record is either a labor charge for work performed, a parts charge describing a part that has been used, or an expense charge for expenses spent on behalf of the customer, i.e. for special deliveries.

It is recommended that you familiarize yourself with the following terms in CommitCRM:

Tickets – Every incident, problem, or job you handle for a customer is managed in CommitCRM using a Ticket record. Click here to learn more.

Contracts – Contract records are used to manage your service contracts and track their status. Click here to learn more.

Charges – Charge records are used to track all activities that will be charged to customers, such as labor, parts and expenses. Click here to learn more.

Creating New Invoice

CommitCRM lets you create QuickBooks Invoices at the Account/Ticket/Contract levels.

If you create an invoice at the Account level, all Billable charges related to the Account that haven't been billed yet will be included in the invoice, including charges related to Tickets and Contracts.

If you create an invoice at the Contract level, only Billable charges that haven't been billed yet which are related to the selected Contract will be included in the invoice, including all Ticket-related charges.

If you create an invoice at the Ticket level, only Billable charges that haven't been billed yet which are related to the selected Ticket will be included in the invoice.

In all cases, you can also include not-billable charges in the invoice, which will be displayed in the invoice with a zero billable total amount. This way you can include all the charges without actually billing for not-billable charges.

There are two ways to create an invoice. The first option is creating an invoice for a specific Account, Ticket or Contract, and the second option is creating invoices for open balances in general.

Option 1: Go to the Accounts/Tickets/Contracts window, and select Create Invoice... on the QuickBooks drop down toolbar menu.

File:Commit accounts window create invoice menu.gif

or

File:Commit tickets window create invoice menu.gif

or

File:Commit contracts window create invoice menu.gif

Option 2: Go to the File menu, select New and then QuickBooks Invoice.

File:Commit new quickbooks invoice menu.gif

After selecting this option the Generate QuickBooks Invoice dialog box is displayed:

File:Commit general new invoice window.gif

Select the level at which you want to generate the invoice (either Accounts, Tickets, or Contracts).

View all the open Billable charges for the level you selected:

File:Commit all tickets to be invoiced.gif

In the example above, the Ticket level was selected. All the Tickets with open Billable charges are displayed. Select the Ticket for which you want to create an invoice and click Select Ticket and Continue.

After selecting the Account/Contract/Ticket record for which you want to create an invoice, the following window is displayed (this window is also displayed when the Create Invoice... option has been selected from the Account/Contact/Ticket window in Option 1 above):

File:Commit invoice wizard step2.gif

All Billable charges that haven't been billed yet and are related to the selected Account, Contract or Ticket record (Contract in the example above) are displayed and by default are selected (using the check mark) to be included in the invoice.

In the charge list you can select which charges will be included in the invoice by selecting or unselecting them by clicking on the checkbox to the left of the record.

Include/Exclude Not-Billable Charges
In addition to the billable charges, you can include Not-billable charges in the invoice. When adding them, Not-Billable charges are displayed in the invoice, however, they do not affect the invoice total.

To include or exclude the not-billable charges click the Include Not-Billable Charge/Exclude Not-Billable toggle Charges button. Note that Administrators can set the system to always include the Not-Billable charges from Tools > Options > QuickBooks.

To be Printed/To be Emailed Flags
Depending on your QuickBooks edition, Invoices in QuickBooks may include the following options: ‘To be printed’ and ‘To be emailed’.

By default, when creating new invoices from CommitCRM, the values for these options are taken from the default settings in QuickBooks (see the selected 'by QuickBooks' option). When un-checking the 'by QuickBooks' option, you can control the values to be used when generating the QuickBooks Invoice.

See more details in QuickBooks Link Settings.

Tip You can use the Quick Select and/or Quick Unselect and/or Advanced Sort buttons to more easily select the Charges to be billed (this is usually required when a lot of charges are displayed).

At this stage you can also set different parameters for the invoice itself. The following options are located at the top of the Generate QuickBooks Invoice window:

1. Bill To - This is the invoice billing address. By default it is taken from the Bill To data defined for the customer in QuickBooks. You can enter a different address in this box if necessary.
   If you have modified this information by mistake and want to use the QuickBooks defaults, right-click above the field and select Set by QuickBooks.
2. Ship To - This is the invoice shipping address. By default it is taken from the Ship To data set defined for the customer in QuickBooks. You can enter a different address in this box if necessary.
   If you have modified this information by mistake and want to use the QuickBooks defaults, right-click above the field and select Set by QuickBooks.
3. Date - This is the invoice date. By default, the date used is today's date. You can modify the date if necessary by typing an alternate date in this field.
4. Reference - This is the invoice Reference number. This number is set by default by QuickBooks. You can modify this number if necessary by typing an alternate Reference number in the field.
5. Due Date - This is the invoice Due Date. By default, the date is one month from today's date. You can modify this date if necessary by entering an alternate due date in the field.
6. Memo - This field is for invoice memo/notes. If necessary, enter a memo that will appear as part of the QuickBooks invoice.

After entering the invoice details and selecting the relevant Charges, click Next.

The lines of the invoice are now displayed as they will appear in the QuickBooks invoice.

File:Commit invoice wizard step3.gif

In this step you can modify the text which will be displayed on the invoice lines. Note that all modifications made to the invoice lines here are not applied to Charges in CommitCRM, and only apply to the QuickBooks invoice lines.

Move Line Up/Down You can use the Move Line Up/Move Line Down buttons or the Advanced Sort button to modify the order of the invoice lines.

Insert Line/s You can also use the Add Blank Line button to include blank lines between the invoice lines in order to space the invoice up and make it more readable

Incl. in Description You can also use the "Incl. in Description" button to include additional information to all invoice line simultaneously, such as:

File:Commit include in description button.gif

Click on Incl. in Description and select the data you wish to be added to the description for every invoice line. To add this information to all invoices by default go to Tools > Options > QuickBooks and select the information you want to include in invoice lines.

You can double-click on each invoice line to add or edit the text/description of the selected line.

As mentioned above, these changes will take affect only on the invoice lines in QuickBooks. The original charges will not be affected by these changes.

File:Commit edit invoice line description.gif

In the image below, you can see that additional information has appeared in the Description column of the invoice lines.

File:Commit invoice wizard step3 with changes .gif

When the invoice information is complete, click Generate QuickBooks Invoice.

CommitCRM will now verify all the settings with QuickBooks and will add the QuickBooks invoice. Once an invoice has been created, the following unofficial invoice will be displayed. This invoice is just to give you an idea of how the invoice was created in QuickBooks. For complete details, view the invoice details in QuickBooks.

File:Commit quickbooks invoice in commit.gif

If you wish to create another invoice, click on Create New Invoice'. Otherwise, you can close the window.

The invoice we've created looks like the following in QuickBooks:

File:Commit quickbooks invoice in quickbooks.gif

Creating Invoices - Advanced Invoice Creation Topics

This chapter provides more details about the invoice creation process.

Handling Unsynced Accounts

When creating an invoice, an asterisk * may appear near the Account's name. The asterisk means that the Account is not synchronized with QuickBooks.

In this case, you can still create the invoice. Continue with the invoice creation wizard, and at a later stage CommitCRM will let you create a link between the Account in CommitCRM and the Customer in QuickBooks, or create a new Customer in QuickBooks.

File:Commit all accounts to be invoiced.gif

In the example above, the selected Account has not been synchronized with QuickBooks.

Handling Unsynced Items

In the second stage of the Invoice creation wizard - Charge Selection, you might see an asterisk * sign near some of the Item's name. The asterisk means, that these Items are not synced with QuickBooks Items. To handle this situation, CommitCRM has automatically created 3 new Items in QuickBooks:

1. CMT Service Taxable Item
2. CMT Expense Taxable Item
3. CMT Products Taxable Item

File:Commit cmt items in quickbooks.gif

All unsynchronized Labor Items in CommitCRM that have been used in Billable charges will be automatically replaced with CMT Service Taxable Item in the invoice lines.
All unsynchronized Expense Items in CommitCRM that have been used in Billable charges will be automatically replaced with CMT Expense Taxable Item in the invoice lines.
All unsynchronized Products/Parts Items in CommitCRM that have been used in Billable charges will be automatically replaced with CMT Products Taxable Item in the invoice lines.

Therefore, you may proceed with the invoice creation process, and the system will replace the Items in the invoice lines with already existing Items in QuickBooks based on their type. The rest of the charge information will pass intact to the QuickBooks invoice; rates, totals, descriptions, etc. will be the same in the QuickBooks invoice as they were defined in Charges in CommitCRM.

(To learn more about the CMT Items, see Using Special QuickBooks Items and Accounts.)

Example:

File:Commit invoice wizard step2 2.gif

In the example above, one of the Items has not been synchronized with QuickBooks.

File:Commit invoice wizard step3 2.gif

When invoice lines are displayed, the unsynchronized product/part Item – in this case the Hard Disk - is replaced with CMT Products Taxable Item. The Charge's description, units, date, total, etc are the same as in the original Charge.

To proceed, click Generate QuickBooks Invoice.

If the selected Account is synchronized with QuickBooks, the invoice will be created. However, if the selected Account has not been synchronized with QuickBooks ( and an asterisk sign has appeared near the selected Account's name indicating that it has not been synchronized, as mentioned above), the system will provide you with three options:

File:Commit account sync settings window.gif

1. Link Account to Existing QuickBooks Customer/Job - Select this option when the Account exists in QuickBooks as a Customer, but they are not linked. You will be asked to select the parallel Customer in QuickBooks.<br
   

   File:Commit quickbooks customer selection window3.gif

   
   After creating the link between the CommitCRM and QuickBooks records, the system will immediately create the invoice.
   
2. Add Account as a New QuickBooks Customer - select this option if the selected Account doesn't exist in QuickBooks and you want to create a QuickBooks customer based on this CommitCRM Account. The system will create the Customer in QuickBooks and then file the invoice under this record.
3. Cancel Invoice Creation - this option will close the invoice creation wizard in CommitCRM.

If you select the first or second option, the following window will appear:

File:Commit quickbooks invoice in commit2.gif

The invoice which is created at the end of the process looks like the following in QuickBooks:

File:Commit quickbooks invoice in quickbooks2.gif

Using Special QuickBooks Items and Accounts

As explained above, there are cases when charged Items in CommitCRM have not been synchronized with QuickBooks Items. In these cases, the system cannot create the invoice since it does not know with which QuickBooks Items to link the invoice lines. To make the invoicing process easier and smoother, Commit-QuickBooks Link automatically creates the following Items in QuickBooks during the initial synchronization process:

File:Commit cmt items in quickbooks.gif

These special items are used when a CommitCRM Charge record uses an a CommitCRM Item that is not synced with QuickBooks, and therefore CommitCRM doesn't know what item should be used in QuickBooks for the invoice line.

These Items are used as follows:

1. Labor Items are replaced with CMT Service Taxable Item in QuickBooks.
2. Expense Items are replaced with CMT Expense Taxable Item in QuickBooks.
3. Product/Part Items are replaced with CMT Products Taxable Item in QuickBooks.

Since each Item in QuickBooks must be linked to an Account in QuickBooks, Commit-QuickBooks Link also automatically creates the following Accounts in QuickBooks during the initial synchronization process, and uses them in conjunction with the CMT Items:

File:Commit cmt accounts in quickbooks.gif

Note that the CMT Accounts in QuickBooks are also used for creating new Items in QuickBooks based on Items in CommitCRM. However, you can configure CommitCRM to use other QuickBooks Accounts for this purpose (the directions appear below).

In cases where CommitCRM default Items are used, as explained above, the invoice's amount will appear in the 'CMT Income Account' in QuickBooks as follows:

File:Commit cmt income account details.gif

You can modify this and move the invoice income to another QuickBooks Account by going to the relevant items in QuickBooks and changing their default Accounts. For the changes to apply to future and past transactions, you need to confirm the following message:

'You changed an account for this item. All future transactions with this item will use this new account. Would you like existing transactions with this item to use this new account?'

To prevent a situation where default Accounts are used, you can direct CommitCRM to use your preferred QuickBooks Accounts for new Items in QuickBooks that will be created for new Items in CommitCRM. To do this, go to Tools > Options > QuickBooks tab > Advanced Settings.

File:Commit options quickbooks tab2.gif

The Advanced Setting for the Commit-QuickBooks Link dialog box will appear. Click on the button to the right of each type to select other QuickBooks Accounts.

File:Commit options quickbooks tab advanced1.gif

The search window for QuickBooks Accounts will display.

File:Commit quickbooks accounts selection window.gif

Search for the relevant QuickBooks Account, select it, and click OK.

The QuickBooks Account for Invoice Income will be replaced with your selection.

File:Commit options quickbooks tab advanced2.gif

From now on, CommitCRM will use these QuickBooks accounts when creating new QuickBooks Items.

See Also

• Commit-QuickBooks Link