How to sync with FreeAgent
Introduction
Connex can sync sales as invoices, credit notes and merchant fees as bills to FreeAgent. Please review this demo:
How do I pair?
Here are the steps:
- In FreeAgent, go to settings > accounting categories.
- Click add. Enter current assets and add Accounts Receivable.
- Click add. Enter Merchant Fees under admin expenses. Enter auto VAT as exempt:
- Go to settings > price list. Add two items. One called shipping and another called orderdiscount. Connex creates no new items in FreeAgent. If you require this logic, please contact us:
- Login to Connex.
- Click add selling channel.
- Click other accounting system on the pair accounting page.
- Choose FreeAgent.
- Sign into FreeAgent through Connex.
- Complete the install wizard.
How does VAT map?
We will map Standard 20% for all UK sales that are tax inclusive. No additional settings in Connex are required. Here is a sale in Shopify and FreeAgent:
Here is FreeAgent:
How do tax exempt orders appear?
In this example, the customer is from the U.S. Connex will add tax exempt to FreeAgent and send no tax. Here is a mapping:
How does Connex map merchant fees?
Here is a demo:
You must instruct Connex to add merchant fees to sales. In this example, we will use Shopify. There are two ways to add fees. If you use Shopify payments, Connex receives the merchant fees. If you use another payment processor, you can add a rule to map the fees manually:
Map Merchant Fee Item Name
Instruct Connex on the account to use for bills.
- In Connex, go to rules engine.
- Click add new rule.
- Select map rule without order number.
- Click submit.
Enter these rules:
Action | Rule | Map To | Required | Notes |
Map Merchant Fee Item Name | order number, is not * | Merchant Fees | Yes | |
Map Bill Expense Account | order number, is not * | Merchant Fees | Yes | |
Map Merchant Fee Percent | order number, is not * | 3 | No | Adds fees if you do not use Shopify payments. |
Map Merchant Fee Cents | order number, is not * | .05 | No | Adds fees if you do not use Shopify payments. |
Connex will create a bill, if there are merchant fees. Here is a bill:
How do fields map?
Here is a diagram:
FreeAgent | Connex |
Invoice Number | Order Number |
Billing Address | Billing Address |
Shipping Address | Shipping Address |
Phone | Phone |
Reference Number | Usually order number |
Date | Order Date |
Due Date | Based on terms. If you ask Connex to map NET 30, then it's 30 days from the creation date. |
Total | Order Total |
Balance | Balance |
Payments | Payments |
Line Items | Line Items. We map product SKU from your selling channel to the FreeAgent code field. Line item description is your product name. |
Currency Code | Currency Code |
Comments | Notes |
Tax/VAT | Tax |