This article does not apply for you if you are using one of our two-way bookkeeping synchronisations but if you use a one-way connection between Teamleader and your bookkeeping program. In this article, you find an overview of all available bookkeeping programs for your country.
In this article, you will get to know all about the following:
- Preparing your Teamleader account
- Exporting the invoices
- Uploading the invoices into your bookkeeping program
Preparing your Teamleader account
This step is two-fold: Managing customer numbers and setting up ledger accounts.
Managing customer numbers
From the moment you begin working with Teamleader, the idea is to manage your customers from Teamleader and send them to your accounting package. Therefore, no new customers should be entered in your accounting package. Teamleader matches your customers based on their bookkeeping customer id. Therefore, we recommend to import your customer data from your accountancy program into Teamleader.
- Export a list of your bookkeeping program including the bookkeeping number.
- Check this article on importing contacts and companies and import your file. Ensure here that you match the field "Bookkeeping customer ID". This field is not activated for every account by default. If you'd like to use this field, simply send an email to our support.
You may already have imported your companies and now there are duplicates in your database (because the company names were not exactly the same).
You can remove the duplicate records by undoing the import (only new companies will be deleted; those companies for which a customer number had already been entered, will not be deleted).
Next, you can go over the other companies manually and enter the customer number. In order to see directly which customer has an ID and which one not, go to your CRM > Companies > Dropdown menu next to the looking glass > Create new segment. In this segment, you choose the rules: "Bookkeeping customer ID" is not filled out. That way, you see all companies without an id. If these are companies/contacts that are already present in the accounting package, you must enter the customer number per customer manually by looking up the customer number in the file of your accountant.
Once all customer numbers are imported from your accounting package, you can indicate that the new customer numbers should be created automatically with the export. More on that in step 2.
From now on, Teamleader will create the customer numbers sequentially, beginning at a start value that you specify. For security reasons, this value is 100000 by default. First consult your accountant before lowering this value, or you run the risk that existing customers from your accounting package are overwritten!
If you do not yet have any customers in your accounting package, select the "Generate automatically" option when exporting your invoices. More on that in step 2.
If you only have a small number of customers (< 30) in your accounting package that have to be entered into Teamleader, you can, instead of importing, simply go over and edit the relevant customers and populate the "Accounting package customer number" field.
Setting up ledger accounts
It is necessary that every position on your invoice is assigned to the right ledger account.
- Go to Settings > Invoices > Ledger accounts
- Create all ledger accounts, you use. Note that if you use commercial discounts, you must also indicate an account for discounts.
- After creating your accounts, you can select "Auto-suggest accounts at certain VAT-tariffs". Here you can set that your invoice line will automatically select a specific account when a VAT rate is selected.
- You can also quickly set the accounts on the basis of the VAT rates for all your existing invoices in Teamleader so that you do not have to go through them manually.
Exporting the invoices
- Go to Invoices and click on Export in the right hand corner.
Choose ‘Export to bookkeeping program’.
The following screen allows you to specify the period of which you want to export your invoices and also lets you select your own bookkeeping program.
Before you continue, you can choose to manage your customer ID’s. Check above for more information.
Next, the cost calculations will be performed. Because these are bookkeeping programs with which we do not have a two way sync with, a fee of € 0.10 per invoice will be charged. This amount is collected through your Teamleader wallet. An invoice is only charged once, so if something goes wrong with the export, you will be able to export the same invoices for free the next time.
If you continue with the import, you will arrive at a screen where a number of parameters must still be provided with input. Many of these parameters differ from package to package, but the following are (almost) always present:
• VAT: On total/On lines. Teamleader calculates the VAT per line so always select "On Lines" here.
• Customers: Select Export customers too. This will ensure that customers are also exported.
• Invoice journal: this is the code of the journal to which your invoices are posted.
• Credit note journal: the journal where credit notes are posted. This can be the same as the journal for the invoices
Other parameters depend on the accounting package that you use. If there are parameters that you do not understand, please contact our support.
Once you have entered the correct parameters, a screen will be displayed where you will see your customers and invoices. If there are no errors, you can press "Next" and the file will be downloaded.
Uploading the invoices into your bookkeeping program
The file you just downloaded can be sent to your accountant to be imported. This step depends on your bookkeeping program.