Xero Link: Difference between revisions
No edit summary |
No edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
== Overview == | == Overview == | ||
Using the ''' | Using the '''RangerMSP-Xero Link''' you can run your computer services business more efficiently. It was designed to simplify routine business, accounting and financial management tasks. With the RangerMSP-Xero Link, you only need to enter data once and it will appear in both RangerMSP and Xero. This feature not only saves you the time of manually entering data, but it also minimizes the problems of duplicate, redundant and wrong data common to manual data entry. Now you can export your data from RangerMSP and Xero and ensure data accuracy, enhance your flexibility, and increase your control over your bottom line. | ||
==Getting Started== | ==Getting Started== | ||
To enjoy the benefits of the | To enjoy the benefits of the RangerMSP-Xero Link you first need to configure the settings. | ||
From | From RangerMSP’s main menu select '''''Tools > Options...''''' and then navigate to the '''''Accounting''''' tab (The tab may be called '''''QuickBooks''''' in case QuickBooks has been the one selected before) and select '''''Xero''''' as your accounting package: | ||
[[File: | [[File:xero_link_settings1.png|center]] | ||
Once selected all configuration options regarding the Xero Link will be displayed. See below | Once selected all configuration options regarding the Xero Link will be displayed. See below | ||
| Line 22: | Line 22: | ||
===Tax Settings=== | ===Tax Settings=== | ||
When Xero receives invoices from | When Xero receives invoices from RangerMSP (or other external sources) it ignores any customer’s Tax or Sales Account setting in Xero and relies on the values received from the RangerMSP. | ||
The actual tax rates, however, are taken from the tax setting in Xero. | The actual tax rates, however, are taken from the tax setting in Xero. | ||
Under '''''Tools > Options > Xero''''' tab click '''''Xero Tax Settings''''' to map tax codes used in | Under '''''Tools > Options > Xero''''' tab click '''''Xero Tax Settings''''' to map tax codes used in RangerMSP with tax codes used in Xero. | ||
[[File: | [[File:xero_link_settings2.png|center]] | ||
====Tax Settings for Customers==== | ====Tax Settings for Customers==== | ||
| Line 34: | Line 34: | ||
Enter the name of the Xero Tax Rate that will be applied for all customer and/or enter other Xero Tax Rate for specific Customers: | Enter the name of the Xero Tax Rate that will be applied for all customer and/or enter other Xero Tax Rate for specific Customers: | ||
[[File: | [[File:xero_link_customer_tax_settings.png|center]] | ||
| Line 45: | Line 45: | ||
Taxes can be optionally set for Items Group (Products/Expense/Labor) or for specific Items: | Taxes can be optionally set for Items Group (Products/Expense/Labor) or for specific Items: | ||
[[File: | [[File:xero_link_Item_tax_settings.png|center]] | ||
===Account Settings=== | ===Account Settings=== | ||
| Line 51: | Line 51: | ||
Go to '''''Tools > Option > Xero''''' tab and click '''''Xero Account Settings''''' button to set Sale Accounts for customers and/or Items: | Go to '''''Tools > Option > Xero''''' tab and click '''''Xero Account Settings''''' button to set Sale Accounts for customers and/or Items: | ||
[[File: | [[File:xero_link_Account_settings.png|center]] | ||
====Sales Accounts for Customers==== | ====Sales Accounts for Customers==== | ||
| Line 57: | Line 57: | ||
Enter the '''''Sales Account Code''''' that will be used for all customers or specify Sales Account Code for selected customer: | Enter the '''''Sales Account Code''''' that will be used for all customers or specify Sales Account Code for selected customer: | ||
[[File: | [[File:xero_link_Account_Code.png|center]] | ||
Account Code set in | Account Code set in RangerMSP must be the SAME as Account Code in Xero: | ||
[[File:Xero_Account_Code.png|center]] | [[File:Xero_Account_Code.png|center]] | ||
| Line 68: | Line 68: | ||
Sales Account can be optionally set for Items Group (Products/Expense/Labor) or for specific Items: | Sales Account can be optionally set for Items Group (Products/Expense/Labor) or for specific Items: | ||
[[File: | [[File:xero_link_Account_Code2.png|center]] | ||
===Customers=== | ===Customers=== | ||
When invoices are imported to Xero they get linked to the relevant customers by the customer name. The | When invoices are imported to Xero they get linked to the relevant customers by the customer name. The RangerMSP customer Account ‘'''''File As'''''’ field is matched with the Contact Name in Xero. In case no match is found Xero adds a new customer. | ||
In order to avoid duplicate customer records created during the import into Xero and in order to link existing | In order to avoid duplicate customer records created during the import into Xero and in order to link existing RangerMSP Accounts to existing Xero customers/contacts verify that the RangerMSP.Account.File As field exactly matches Xero.Customer/Contact.Name field. | ||
To batch send all | To batch send all RangerMSP Account to Xero export Accounts from RangerMSP to an Excel or a text file and then import them as Xero Contacts. | ||
To batch send all Xero customers into | To batch send all Xero customers into RangerMSP export Contacts from Xero to an Excel file then import them to RangerMSP as Accounts. | ||
Notes: | Notes: | ||
# If email dddress is filled in | # If email dddress is filled in RangerMSP Account it will be exported. As Xero blocks importing invoices if email address is invalid, for example, when domain is filled as Account email. It is recommended to move domain from the main Account and store it as the email address of a new Secondary Contact in RangerMSP (added under the Contacts tab). | ||
# Account address is exported from | # Account address is exported from RangerMSP. If the customer does not exist in Xero or cannot be matched based on the name (as explained above) Xero creates new customer records and uses all details exported from RangerMSP, including the address. However when an existing customer/contact is found in Xero - the address exported from RangerMSP is ignored and the address for this customer in Xero is used. | ||
==Invoice Creation Options== | ==Invoice Creation Options== | ||
===Creating New Invoice=== | ===Creating New Invoice=== | ||
RangerMSP lets you create Xero Invoices at the '''Account, Contract and Ticket''' 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 '''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. | ||
| Line 102: | Line 102: | ||
For example: | For example: | ||
[[File: | [[File:xero_link_Invoice_from_account.png|center]] | ||
Another example - generating an Invoice file for a Ticket: | Another example - generating an Invoice file for a Ticket: | ||
[[File: | [[File:xero_link_Invoice_from_ticket.png|center]] | ||
'''Option 2 - Generating a Single Invoice''' | '''Option 2 - Generating a Single Invoice''' | ||
| Line 113: | Line 113: | ||
From the menu select '''''File > New > Xero Invoice...''''' | From the menu select '''''File > New > Xero Invoice...''''' | ||
[[File: | [[File:xero_link_create_invoice.png|center]] | ||
After selecting this option the '''''Generate Xero Invoice''''' dialog window is displayed: | After selecting this option the '''''Generate Xero Invoice''''' dialog window is displayed: | ||
[[File: | [[File:xero_link_create_invoice_step1.png|center]] | ||
Select the level at which you want to generate the invoice file (either Accounts, Contracts or Tickets). | Select the level at which you want to generate the invoice file (either Accounts, Contracts or Tickets). | ||
| Line 124: | Line 124: | ||
Once the level is selected a list of all Accounts, Contracts or Tickets (according to your selection) that have open balances, e.g. Billable Charges logged under them that have not yet been billed, will be displayed: | Once the level is selected a list of all Accounts, Contracts or Tickets (according to your selection) that have open balances, e.g. Billable Charges logged under them that have not yet been billed, will be displayed: | ||
[[File: | [[File:xero_link_create_invoice_step2.png|center]] | ||
In the example above, the Account level was selected. All Accounts with open Billable charges are displayed. | In the example above, the Account level was selected. All Accounts with open Billable charges are displayed. | ||
| Line 135: | Line 135: | ||
Note: This is the same window that is displayed when initializing invoice creation from the Accounts, Contracts or Tickets window, as described in Option 1 above). | Note: This is the same window that is displayed when initializing invoice creation from the Accounts, Contracts or Tickets window, as described in Option 1 above). | ||
[[File: | [[File:xero_link_create_invoice_step3.png|center]] | ||
All Billable Charges that have not been billed yet and are related to the selected Account, Contract or Ticket record (Account in the example above) are displayed. | All Billable Charges that have not been billed yet and are related to the selected Account, Contract or Ticket record (Account in the example above) are displayed. | ||
| Line 163: | Line 163: | ||
The following window/step is displayed: | The following window/step is displayed: | ||
[[File: | [[File:xero_link_create_invoice_step4.png|center]] | ||
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 | 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 RangerMSP, and only apply to the Xero 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. | '''''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. | ||
| Line 173: | Line 173: | ||
'''''Incl. in Description''''' You can also use the "Incl. in Description" button to include additional information to all invoice line simultaneously, such as: | '''''Incl. in Description''''' You can also use the "Incl. in Description" button to include additional information to all invoice line simultaneously, such as: | ||
[[File: | [[File:xero_link_create_invoice_include_in_description.png|center]] | ||
| Line 180: | Line 180: | ||
'''Editing the Text Line''' - You can double-click on each invoice line to add or edit the text/description of the selected line. | '''Editing the Text Line''' - You can double-click on each invoice line to add or edit the text/description of the selected line. | ||
[[File: | [[File:xero_link_create_invoice_edit_line.png|center]] | ||
As mentioned above, these changes will take effect only on the invoice lines in Xero. The original Charges will not be affected by these changes. | As mentioned above, these changes will take effect only on the invoice lines in Xero. The original Charges will not be affected by these changes. | ||
| Line 190: | Line 190: | ||
In this step you can select the folder to save the exported invoice file and to then generate it: | In this step you can select the folder to save the exported invoice file and to then generate it: | ||
[[File: | [[File:xero_link_create_invoice_step5.png|center]] | ||
| Line 198: | Line 198: | ||
Congratulation! Invoice file created successfully and can be imported in Xero. | Congratulation! Invoice file created successfully and can be imported in Xero. | ||
[[File: | [[File:xero_link_create_invoice_step6.png|center]] | ||
| Line 219: | Line 219: | ||
Go to '''''File > New > Xero Batch Invoice Wizard'''''. The following window appears: | Go to '''''File > New > Xero Batch Invoice Wizard'''''. The following window appears: | ||
[[File: | [[File:Xero_link_Batch_Invoice.png|center]] | ||
Select the level at which you want to generate the invoices (either Accounts, Tickets, or Contracts). | Select the level at which you want to generate the invoices (either Accounts, Tickets, or Contracts). | ||
| Line 228: | Line 228: | ||
In this example, the Account level was selected and all the Accounts with open Billable charges are displayed. | In this example, the Account level was selected and all the Accounts with open Billable charges are displayed. | ||
[[File: | [[File:Xero_link_Batch_Invoice_step1.png|center]] | ||
| Line 235: | Line 235: | ||
In this step you can select the folder to save the exported invoices file and to then generate it: | In this step you can select the folder to save the exported invoices file and to then generate it: | ||
[[File: | [[File:Xero_link_Batch_Invoice_step2.png|center]] | ||
| Line 243: | Line 243: | ||
Congratulation! Invoices file created successfully and can be imported in Xero | Congratulation! Invoices file created successfully and can be imported in Xero | ||
[[File: | [[File:Xero_link_Batch_Invoice_finish.png|center]] | ||
| Line 251: | Line 251: | ||
#Open '''''Xero''''' and select '''''Accounts > Sales''''' menu option. | #Open '''''Xero''''' and select '''''Accounts > Sales''''' menu option. | ||
#Click '''''Import''''' under the Xero Sales page. | #Click '''''Import''''' under the Xero Sales page. | ||
#Click '''''Browse''''', under ‘Step 3’ in the import page and select the file that was just created by | #Click '''''Browse''''', under ‘Step 3’ in the import page and select the file that was just created by RangerMSP. | ||
'''''Tip''''': ''Click ‘Copy to Clipboard’ to copy the file path and past it in the Xero file selection option''. | '''''Tip''''': ''Click ‘Copy to Clipboard’ to copy the file path and past it in the Xero file selection option''. | ||
| Line 262: | Line 262: | ||
== | ==RangerMSP-Xero Link - Additional Options== | ||
===Configuring The Invoice Number=== | ===Configuring The Invoice Number=== | ||
| Line 269: | Line 269: | ||
[[File: | [[File:xero_link_options_Increment_invoice_no1.png|center]] | ||
Set the number for next Invoice: | Set the number for next Invoice: | ||
[[File: | [[File:xero_link_options_Increment_invoice_no2.png|center]] | ||
===Canceling Exported Invoices=== | ===Canceling Exported Invoices=== | ||
RangerMSP keeps track on the Invoices it exported to Xero. | |||
In some cases exported invoices do not end up generating Xero Invoices. For example, if you decided not to import exported invoice to Xero or imported them but decided to cancel one or more of the imported invoices. | In some cases exported invoices do not end up generating Xero Invoices. For example, if you decided not to import exported invoice to Xero or imported them but decided to cancel one or more of the imported invoices. | ||
RangerMSP lets you can cancel such exported invoices. | |||
Canceling exported invoices in | Canceling exported invoices in RangerMSP marks all involved Charges in RangerMSP as Unbilled again so they can be used again for invoicing. | ||
In order to cancel exported invoices click the '''''Xero''''' drop down in the Charges window and select the option '''''Cancel Exported Invoices''''': | In order to cancel exported invoices click the '''''Xero''''' drop down in the Charges window and select the option '''''Cancel Exported Invoices''''': | ||
[[File: | [[File:xero_link_cancel_export1.png|center]] | ||
nvoices can be canceled both on a one-by-one basis or in batches. | nvoices can be canceled both on a one-by-one basis or in batches. | ||
Single invoices can also be canceled from a batch. For example, if you exported 50 invoices to Xero using the Batch Invoice Creation Wizard, pushed the invoices to Xero and are only happy with 49 of them while need to cancel one that’s easy - cancel that one invoice in Xero and then cancel it in | Single invoices can also be canceled from a batch. For example, if you exported 50 invoices to Xero using the Batch Invoice Creation Wizard, pushed the invoices to Xero and are only happy with 49 of them while need to cancel one that’s easy - cancel that one invoice in Xero and then cancel it in RangerMSP. Done! | ||
| Line 304: | Line 304: | ||
See the screenshot below: | See the screenshot below: | ||
[[File: | [[File:xero_link_cancel_export2.png|center]] | ||
| Line 311: | Line 311: | ||
You can link Charges to existing Xero invoice. | You can link Charges to existing Xero invoice. | ||
In some cases, after an invoice got created in Xero you decide to include another line (e.g. service/product) in it or update an existing line. In order to keep things in sync with | In some cases, after an invoice got created in Xero you decide to include another line (e.g. service/product) in it or update an existing line. In order to keep things in sync with RangerMSP you can also add that new line to RangerMSP as a Charge, and then link it to the relevant invoice in Xero. | ||
| Line 319: | Line 319: | ||
Once the Charge is marked as billed and selected, select '''''Link to Existing Invoice in Xero...''''' from the Xero drop down: | Once the Charge is marked as billed and selected, select '''''Link to Existing Invoice in Xero...''''' from the Xero drop down: | ||
[[File: | [[File:xero_link_link_to_invoice.png|center]] | ||
The Filter by invoice reference number will display: | The Filter by invoice reference number will display: | ||
[[File: | [[File:xero_link_filter_by_invoice.png|center]] | ||
===Filter by Invoice Reference=== | ===Filter by Invoice Reference=== | ||
This option enables you to find all the | This option enables you to find all the RangerMSP Charges that were included in a specific Xero invoice according to invoice reference number. | ||
To do this, go to the Charges main window, and select Filter by Invoice Reference on the QuickBooks drop down toolbar menu. | To do this, go to the Charges main window, and select Filter by Invoice Reference on the QuickBooks drop down toolbar menu. | ||
| Line 336: | Line 336: | ||
The Filter by invoice reference number dialog box will open. | The Filter by invoice reference number dialog box will open. | ||
[[File: | [[File:xero_link_filter_by_invoice.png|center]] | ||
Latest revision as of 13:57, 8 July 2020
Overview
Using the RangerMSP-Xero Link you can run your computer services business more efficiently. It was designed to simplify routine business, accounting and financial management tasks. With the RangerMSP-Xero Link, you only need to enter data once and it will appear in both RangerMSP and Xero. This feature not only saves you the time of manually entering data, but it also minimizes the problems of duplicate, redundant and wrong data common to manual data entry. Now you can export your data from RangerMSP and Xero and ensure data accuracy, enhance your flexibility, and increase your control over your bottom line.
Getting Started
To enjoy the benefits of the RangerMSP-Xero Link you first need to configure the settings.
From RangerMSP’s main menu select Tools > Options... and then navigate to the Accounting tab (The tab may be called QuickBooks in case QuickBooks has been the one selected before) and select Xero as your accounting package:
Once selected all configuration options regarding the Xero Link will be displayed. See below
Tax Settings
When Xero receives invoices from RangerMSP (or other external sources) it ignores any customer’s Tax or Sales Account setting in Xero and relies on the values received from the RangerMSP.
The actual tax rates, however, are taken from the tax setting in Xero.
Under Tools > Options > Xero tab click Xero Tax Settings to map tax codes used in RangerMSP with tax codes used in Xero.
Tax Settings for Customers
Enter the name of the Xero Tax Rate that will be applied for all customer and/or enter other Xero Tax Rate for specific Customers:
Tax Rate details in Xero:
Tax Settings for Items
Taxes can be optionally set for Items Group (Products/Expense/Labor) or for specific Items:
Account Settings
Go to Tools > Option > Xero tab and click Xero Account Settings button to set Sale Accounts for customers and/or Items:
Sales Accounts for Customers
Enter the Sales Account Code that will be used for all customers or specify Sales Account Code for selected customer:
Account Code set in RangerMSP must be the SAME as Account Code in Xero:
Sales Accounts for Items
Sales Account can be optionally set for Items Group (Products/Expense/Labor) or for specific Items:
Customers
When invoices are imported to Xero they get linked to the relevant customers by the customer name. The RangerMSP customer Account ‘File As’ field is matched with the Contact Name in Xero. In case no match is found Xero adds a new customer.
In order to avoid duplicate customer records created during the import into Xero and in order to link existing RangerMSP Accounts to existing Xero customers/contacts verify that the RangerMSP.Account.File As field exactly matches Xero.Customer/Contact.Name field.
To batch send all RangerMSP Account to Xero export Accounts from RangerMSP to an Excel or a text file and then import them as Xero Contacts. To batch send all Xero customers into RangerMSP export Contacts from Xero to an Excel file then import them to RangerMSP as Accounts.
Notes:
- If email dddress is filled in RangerMSP Account it will be exported. As Xero blocks importing invoices if email address is invalid, for example, when domain is filled as Account email. It is recommended to move domain from the main Account and store it as the email address of a new Secondary Contact in RangerMSP (added under the Contacts tab).
- Account address is exported from RangerMSP. If the customer does not exist in Xero or cannot be matched based on the name (as explained above) Xero creates new customer records and uses all details exported from RangerMSP, including the address. However when an existing customer/contact is found in Xero - the address exported from RangerMSP is ignored and the address for this customer in Xero is used.
Invoice Creation Options
Creating New Invoice
RangerMSP lets you create Xero Invoices at the Account, Contract and Ticket 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 charges (billable or not) in the Invoice without actually billing your customer for ‘not-billable’ charges.
There are two ways to generate a single invoice file. 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 - Generating a Single Invoice Go to the Accounts, Tickets, Contracts or Tickets window, in the list - select the record that you want to invoice and then click the Xero button on the toolbar. Then, select Create Invoice file...
For example:
Another example - generating an Invoice file for a Ticket:
Option 2 - Generating a Single Invoice
From the menu select File > New > Xero Invoice...
After selecting this option the Generate Xero Invoice dialog window is displayed:
Select the level at which you want to generate the invoice file (either Accounts, Contracts or Tickets).
Once the level is selected a list of all Accounts, Contracts or Tickets (according to your selection) that have open balances, e.g. Billable Charges logged under them that have not yet been billed, will be displayed:
In the example above, the Account level was selected. All Accounts with open Billable charges are displayed.
Select the Account for which you want to create an invoice file and click Select Account and Continue.
After selecting the record for which you want to create an invoice and clicking the button to continue the following window is displayed:
Note: This is the same window that is displayed when initializing invoice creation from the Accounts, Contracts or Tickets window, as described in Option 1 above).
All Billable Charges that have not been billed yet and are related to the selected Account, Contract or Ticket record (Account in the example above) are displayed.
By default all such Charges are selected for inclusion in the invoice and you can un-select Charges that you do not wish to include in this invoice by clicking the checkbox.
Include/Exclude Not-Billable Charges In addition to the Billable Charges, you can also 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 - or - Exclude Not-Billable toggle Charges button accordingly. Administrators can default the inclusion of Not-Billable Charges by visiting Tools > Options > Xero tab.
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:
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.
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.
Reference - This is the invoice Reference in Xero (note: this is NOT an invoice number). You can modify the reference if necessary by typing an alternate Reference value in the field.
Click Next
The following window/step is displayed:
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 RangerMSP, and only apply to the Xero 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:
Click Incl. in Description and select the data you wish to be added to the description for every invoice line. To add this information for all invoices by default go to Tools > Options > Xero tab and select the information you want to include in invoice lines.
Editing the Text Line - 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 effect only on the invoice lines in Xero. The original Charges will not be affected by these changes.
When the invoice information is complete, click Next.
In this step you can select the folder to save the exported invoice file and to then generate it:
To generate the invoice file click Generate Xero Invoice.
Congratulation! Invoice file created successfully and can be imported in Xero.
If you wish to create another invoice, click on Create New Invoice. Otherwise, you can close the window.
Batch Invoice Creation
The Batch Invoice Creation Wizard allows you to general many invoices at once at the customer level, the service contract level or the ticket level.
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. When using the Batch Invoice Creation Wizard, you need to set the desired behavior for not-billable Charges from the Tools > Options > Xero tab .
To activate the Batch Invoice Creation Wizard: Go to File > New > Xero Batch Invoice Wizard. The following window appears:
Select the level at which you want to generate the invoices (either Accounts, Tickets, or Contracts).
Click Next to continue.
In this example, the Account level was selected and all the Accounts with open Billable charges are displayed.
Select the Accounts for which you want to create an invoice and click Next.
In this step you can select the folder to save the exported invoices file and to then generate it:
To generate the invoice file click Generate Xero Invoice.
Congratulation! Invoices file created successfully and can be imported in Xero
Importing Invoices to Xero
To import the invoice into Xero:
- Open Xero and select Accounts > Sales menu option.
- Click Import under the Xero Sales page.
- Click Browse, under ‘Step 3’ in the import page and select the file that was just created by RangerMSP.
Tip: Click ‘Copy to Clipboard’ to copy the file path and past it in the Xero file selection option.
The invoice we've created successfully:
RangerMSP-Xero Link - Additional Options
Configuring The Invoice Number
Go to Tools > Options > Xero tab and click the Increment Invoice Number button:
Set the number for next Invoice:
Canceling Exported Invoices
RangerMSP keeps track on the Invoices it exported to Xero.
In some cases exported invoices do not end up generating Xero Invoices. For example, if you decided not to import exported invoice to Xero or imported them but decided to cancel one or more of the imported invoices.
RangerMSP lets you can cancel such exported invoices.
Canceling exported invoices in RangerMSP marks all involved Charges in RangerMSP as Unbilled again so they can be used again for invoicing.
In order to cancel exported invoices click the Xero drop down in the Charges window and select the option Cancel Exported Invoices:
nvoices can be canceled both on a one-by-one basis or in batches.
Single invoices can also be canceled from a batch. For example, if you exported 50 invoices to Xero using the Batch Invoice Creation Wizard, pushed the invoices to Xero and are only happy with 49 of them while need to cancel one that’s easy - cancel that one invoice in Xero and then cancel it in RangerMSP. Done!
The following window lists all exported invoice files and the invoices included in each.
Select the one you wish to cancel and click Cancel by Selected File or, in case you wish to cancel by an invoice number, click Cancel by Invoice Number instead.
All Charges related to invoices being canceled will become Unbilled again and be available for inclusion in future invoices.
See the screenshot below:
Linking Charges to an Existing Invoice in Xero
You can link Charges to existing Xero invoice.
In some cases, after an invoice got created in Xero you decide to include another line (e.g. service/product) in it or update an existing line. In order to keep things in sync with RangerMSP you can also add that new line to RangerMSP as a Charge, and then link it to the relevant invoice in Xero.
Note: Linking a Charge to an invoice does not modify the invoice details in Xero.
To link a single Charge to an existing invoice in Xero, first manually set the Charge to Billed by clicking on Mark as Billed. Once the Charge is marked as billed and selected, select Link to Existing Invoice in Xero... from the Xero drop down:
The Filter by invoice reference number will display:
Filter by Invoice Reference
This option enables you to find all the RangerMSP Charges that were included in a specific Xero invoice according to invoice reference number.
To do this, go to the Charges main window, and select Filter by Invoice Reference on the QuickBooks drop down toolbar menu.
The Filter by invoice reference number dialog box will open.
Enter the Invoice Reference number and click OK.
All the charges that were included in this invoice will be displayed.
