Here is how the integration works in a snapshot:
DIRECT CUSTOMERS INTEGRATING FOR THE FIRST TIME WITH XERO V2
Squirrel Street's direct integration with Xero works by you assigning Squirrel Street receipts into the appropriate Xero account code, then exporting directly into your Xero account.
Xero integration consists of the following steps:
1) The first time you start the integration, make sure you already have at least one receipt entered in your account.
2) While logged into Squirrel Street, click on this link to go to the Integrations page. Or go to Receipts > Export all > Accounting Export. Here's what the Integrations page looks like if you have no integrations:
3) If no connection exists, click on "Add integration".
6) Go back to Receipts, and categorise the receipts you've prepared earlier by selecting each receipt and assigning a Xerov2 code from the "Assign category" drop down menu. You should now find your Xero Chart of Accounts list! If you have many receipts to categorise, you may want to categorise them in bulk. Instructions can be found here.
7) Export will take place dependent on the settings you selected earlier. Automatic export will mean an export will occur every 2hrs. Manual export will occur when you click on the 'Export now' button.
THINGS TO REMEMBER:- Only receipts with a 'Xerov2 -' category added will be picked up by the export and added to your Xero account.
- In the receipts page, you'll see the 'Exported' category added to receipts that have been successfully exported.- If you have receipts that have a Xero category added to them, but you don't want them to be picked up by the export process, add the 'Do not export' category to those receipts, and the export process will skip those.
The following instructional video shows you step by step instructions:
Login to Squirrel Street and view your receipts. Then open <b><a href="https://integrations.squirrelstreet.com/AccountingIntegration" title="Link: https://integrations.squirrelstreet.com/AccountingIntegration">https://integrations.squirrelstreet.com/AccountingIntegration</a></b> in your favorite browser and click "Link"
Click on the down arrow
Click on the Squirrel Street account you wish to link
Click on the down arrow
Click on "Add Integration"
Click on "OK"
This will take you to Xero. Grant access for Squirrel Street to access your Xero file. You may need to enter your Xero credentials at this point.
Select where in Xero you would like the information to appear
Select whether you would like to manually export each time or have Squirrel Street export automatically (Auto export and Advanced) every two hours, on the hour.
Once the integration has been successful, go back to your receipts page. Xero will have imported its chart of accounts across to Squirrel at this stage.
This is how to code several receipts at a time, by filtering for vendor. Go to the field under "Vendors" and enter the vendor name.
For example, I've entered Coles here.
Click on the top-left box to select all the receipts on the page. (If the list is longer than a page, it's best to do this a page at a time).
Click on "Assign category"
You can use the "Search category" field to find a category. A receipt must have a current Xerov2 category to export successfully.<br>
Once you have successfully coded a receipt, you will be asked if you wish to create a rule, such that newly-entered receipts with this vendor name will automatically be assigned this category. Click on "Create rules" if this is what you want.
To manually export, click on "Export selected" or "Export all". Both will do the same thing.
Click on "Accounting Exports"
Click on "Export now"
That's it. You're done.