Our in-depth connection with the accounting tool Octopus goes both ways: invoices and credit notes in Teamleader are synchronized to Octopus, and payment data from Octopus is retrieved in Teamleader. This ensures that you are always aware of the latest financial activities in your organisation.
- Clients in Teamleader are first exported to Octopus before the actual synchronization of the invoices.
- You manage ledger accounts in Octopus. These are automatically synchronized to Teamleader.
Don't have an Octopus account yet? You can purchase one by visiting http://www.octopus.be.
Setting up the integration
You'll need to complete one of the following 3 steps:
A. My Octopus account is empty (and my Teamleader account is or is not empty)
If your Octopus account does not contain any data yet, you'll first need to arrange a few things:
- Create a fiscal year
- Create a journal
- Check ledger accounts
- Create a fiscal year by navigating to Management -> Fiscal years.
Note: You cannot change the start date. Fiscal years must be sequential and without intervening periods. (You may need to create additional fiscal years before you can create the year you want.)
2. Create a journal. First, check whether the right fiscal year is open (Menu Bar > Fiscal Year > Open fiscal year). You need two journals: one for invoices, and one for credit notes. Name the journal for invoices "V1" and credit notes "V2".
Note: always select 'Sales Entries' as Entry Type. Only journals of this type will be visible in Teamleader.
3. Check the accountancy accounts (Management > Accounts). Those starting with 70 are retrieved from Octopus. In Teamleader, you can indicate to which account they must be posted for each line of your invoices.
Note: Any editing of accounts is best done in consultation with your accountant.
B. My Teamleader account is empty and my Octopus account contains my customer database
You can easily import your customer database into Teamleader by selecting the 'Import companies from Octopus' slider.
C. Both my Teamleader account and my Octopus account contain my customer database
Note: to prevent double entries in Octopus, you should import all companies in Teamleader first. To do so, use the 'Import companies from Octopus' slider.
- Once you've imported companies you'll have some duplicates in Teamleader. Activate the 'Accounting package customer number' column in Teamleader to see which customers have an Octopus ID. This column is also available in the invoices overview.
- Merge the double entries manually or automatically.
- Enter the name of a company. If there are 2 results, select Actions > Merge.
Note: you can also merge using the details page of a company, under the small arrow at the top. Teamleader will automatically merge all fields, including customer number. In case of conflicting data, you'll have the option to select the correct entry.
Merging automatically (highly recommended in case of > 50 duplicate records)
- Create a segment with the rule 'Tags contain Octopus Import'. (all companies you just imported)
- Export this segment to Excel.
- In Teamleader, perform the bulk action 'Delete' on this segment.
- Delete any columns you don't need. (You only need "Name", "Accounting package customer number" and "VAT number".)
- Save the Excel file as .csv and import it in Teamleader.
- If you need to enter merging criteria, choose Name (if the name rarely differs) or VAT number (if most VAT numbers are filled in). You can try different criteria and use the preview function to see how many companies will be added (this should be as low as possible).
- Once you completed the import, all edited companies have now been given the correct customer number.
- All added companies could not be matched. You'll have to go through these and merge manually.
Note: if everything went well, the 'Accounting package customer number' field has been populated for all invoices. If this is not the case, compare your customer with the Excel file you exported. If your customer isn't in there, he'll be created in Octopus after the next sync.
The actual connection with Teamleader
- Click on the user icon on the top right corner and select 'Integrations/Marketplace'. Search for 'Octopus'.
- Once you've entered username and password, connect the created journals to the invoices and credit notes.
- Enter the start date of the sync, and indicate you want to import companies from Octopus.
- Click 'Save'.
The VAT percentages in Teamleader and Octopus are now connected. You can choose to select specific accounts automatically for specific VAT rates.
Note: we advise setting the automatic synchronisation only after the connection has been established.
Starting the sync
- Click 'Invoices'.
- A synchronisation symbol will now be displayed on the right side.
- Click this symbol to re-sync with Octopus.
- After a while, you'll see a notification with the results of the sync. If you experience any problems, check these notifications first.
- The sync contains: the synchronisation of customers with linked invoices/credit notes, the (imported) invoices and credit notes, and payment information (reconciliation) from Octopus.
- After syncing, you can see the posted invoices in Octopus by selecting 'Accounting' > 'Sales journal'. Note: be sure to close the sales journal during the sync!
You can also import CODA files from your bank (Accounting > Import > CODA files). Match those payments with invoices through Accounting > Reconcile > Reconcile customers. Invoices that are reconciled in Octopus will automatically be set as paid in Teamleader.
Note: when an invoice has obtained the status 'Paid' in Teamleader, it will also receive the status 'Paid' in Octopus. However, when you change the payment status in Octopus, the status in Teamleader will remain 'Paid' unless you change this manually.