EZRentOut can be integrated with a number of productivity applications by simply enabling their add-ons from Settings. A few popular integrations include Stripe, Authorize.Net, PayPal, Moneris, and Dropbox. Our QuickBooks and Xero add-ons are perfect for your accounting needs. In this blog post, we’ll talk in detail about Xero integration.
CONNECTING TO XERO
Start by connecting your EZRentOut and Xero accounts.
1) From Your Name at Top Right -> Settings -> Add Ons -> Integrate Xero
2) Click the Connect to Xero button
3) You’ll be redirected to Xero to log into your account. If you’re already signed into your Xero account, you’ll directly go to step 4
4) Authorize EZRentOut to access your Xero account. Make sure your organization is selected here.
5) After clicking the Authorize button, you should see the success message from Xero and will be redirected back to EZRentOut
6) After you’re redirected back to EZRentOut Add Ons page, you’ll be prompted to choose default Xero accounts. There are two accounts, you’ve to choose: The first one is Sales account where order/invoice line items go. The second one is Payments Account where payments received against an order go. Both these accounts must be selected.
CONFIGURING TAX SETTINGS
The taxes you need to use across EZRentOut and Xero should be an exact match. This has to do with mapping taxes correctly in Xero. To match taxes;
1) Configure taxes in EZRentOut by going to Settings -> Company Settings -> Tax Details. Create the ones that you’d need.
2) The Tax Name and its rate should be identical to one in your Xero account e.g. Federal Tax at 10% rate.
3) Let’s create a tax in EZRentOut. If this tax applies to every order, have the ‘applied to every order by default’ selected (only one tax rate is applied to an order)
4) Now we need to create the same tax in Xero. These settings are available under Settings -> General Settings -> Organization -> Click ‘Tax Rates’ under Organization -> Create ‘New Tax Rate’ under Tax Rates bar.
Alternatively, if there is a tax in your Xero account which you want to use in EZRentOut, create it in EZRentOut settings. The bottom line is that the tax names and rates should be an exact match.
5) In Xero -> Settings -> Chart of Accounts, you’re using Xero ‘Sales Account’ for EZRentOut Sales. Choose the default tax for this account under All Accounts -> Look for ‘Sales Account’ type in the listing e.g. EZRentOut.
In this example, it’s going to be Federal Tax.
Hit ‘Save’. Now we’re all set!
HOW THINGS MAP
Let’s begin with an order for Robert Williams as shown below:This order will appear in Xero once it’s rented out so let’s go ahead and rent it out. The invoice will appear in Xero -> Accounts -> Sales -> Invoices.
Here are the details of this order in Xero:
The customer record is also added to Xero -> Contacts -> All Contacts
EZRENTOUT ROUNDING ADJUSTMENTS
Xero calculates tax on a per line basis, rounding to two decimal places, and then sums the tax totals of each line to calculate the total invoice tax. To learn more about rounding in Xero, click here. EZRentOut, on the other hand, totals lines first and then calculates the tax amount, which can lead to a slight variance in the amounts calculated.
For example, here’s how Xero would calculate a 15% tax:
Invoice line 1: Product A @ $25.06, tax at 15%: $3.76 line total: $28.82
Invoice line 2: Product B @ $25.61, tax at 15%: $3.84 line total: $29.45
Invoice line 3: Product C @ $25.63, tax at 15%: $3.84 line total: $29.47
Xero totals: Subtotal: $76.30, Tax: $11.44
Xero document total: $87.74
And here’s how EZRentOut calculates the same 15% tax:
Invoice line 1: Product A @ $25.06
Invoice line 2: Product B @ $25.61
Invoice line 3: Product C @ $25.63
Line items added together: $25.06 + $25.61 + $25.63 = $76.30
$76.30 taxed at 15%: $11.45
EZRentOut total: Subtotal: $76.30, Tax: $11.45
Xero document total: $87.75
As we can see, there’s a difference of 0.01 in the way the two systems calculate tax. This difference would be accounted for in the invoice as a line item for the EZRentOut Rounding Adjustments Account. In this way, all your accounting calculations are always evened out between the two systems!
You can mark payments either from an EZRentOut Order or from the Xero Invoice. Once synced, the payments are updated to the other platform.
Payments marked in EZRentOut and Xero will be synced differently. If I charge $3000 in EZRentOut for Bob’s order (or Bob pays this amount online via the EZRentOut customer portal), the invoice in Xero will reflect this charge instantly.However, charging a payment in Xero will appear in EZRentOut as soon as the sync is done manually. See the next two sections for more details on syncing.
WHEN ARE DETAILS SYNCED?
Orders in EZRentOut are automatically synced over to Xero when these Orders are:
– Rented out (based on the setting checked under Xero Integration Add On)– Returned i.e. marked Paid in Xero.
– Booked (based on the setting checked under Xero Integration Add On). By default, this setting isn’t enabled. Also, when a booked order is canceled in EZRentOut, it’s invoice is marked as void in Xero.
– Voided Orders in EZRentOut are deleted in Xero.
– Any payment is charged in the order
Note that when renting out an order, customers are created in Xero if they don’t already exist.
In addition to this you can manually sync any changes made to an order in EZRentOut with Xero when you press the ‘Sync Invoice With Xero’ button shown on the order details page. This button becomes available once an order is rented out/booked (based on the settings enabled).
THINGS TO NOTE
– Payments for EZRentOut orders are synced across Xero and EZRentOut, irrespective of where you record the payment. However, this sync is only automatic if the payment is recorded in EZRentOut. For payments made in Xero, you’ll need to manually sync the Order in EZRentOut.
– Customers and Orders are pushed from EZRentOut to Xero. Your Xero Invoices and Customers are not pulled into EZRentOut
– If you change any tax rates or names, you must match the EZRentOut and Xero taxes as explained in Tax Settings above
– Refunds are not synced
SEND US YOUR FEEDBACK
Your suggestions and feedback is important to us. Let us know what enhancements would you want to see at firstname.lastname@example.org. We’re also active on Twitter @EZRentOut. Follow us to stay in touch with what we’re up to.