Definitions
Let's clarify the key terms that we will refer to below:
General ledger account: this is a category in a company's chart of accounts that is used to classify and record financial transactions in a systematic way. Each account is identified by a unique number and a description.
Third-party accounts are general ledger accounts that record transactions with third parties, i.e. partners outside the company such as customers, suppliers, employees, etc. They are often subdivided into accounts that record transactions with third parties. They are often subdivided into subsidiary accounts for more detailed monitoring.
Sub-ledger accounts represent a subdivision of a G/L account. For example, instead of having a single account for all customers, a company can have a sub-account for each customer, which makes it easier to monitor receivables and payments.
Sub-ledger accounts must be attached to the correct ‘roots’, i.e. to the relevant G/L accounts. A customer sub-account must therefore be attached to the customer G/L account (i.e. account 411). Conversely, a supplier sub-account must be attached to the supplier G/L account (account 401).Importing accounting information for the bank journal - User guide
Step 1: Download templates on Agicap
Cogwheel bottom left
2. Preaccounting
3. Import file then click Import accounting accounts or Import third party accounts and finally Download template.
Step 2: Prep your import file
1) Import of accounts
Template ChartOfAccounts
2) Import of third party accounts
Template ThirdPartiesImportTemplate
⚠️ For the import of third parties to work, they must only be associated with accounting accounts that already exist in Agicap.
Is your import not working?
Here are the most common causes of failure:
Do not modify the template: do not change the order of the columns or their headings, simply fill in your data from line 2 without adding any extra headings. On the other hand, don't hesitate to delete any example line.
Check for the presence of special characters (hyphens, inverted commas, etc.)
Make sure you format your file in the format indicated, i.e. CSV-UTF 8
If you need to rework your CSV file, use Excel's native functions:
Open Excel, use the Data tab to import the CSV, make any changes you like, keeping 3 columns, use Excel's native save-as CSV UTF8 function (do not attempt to generate a CSV conversion manually).