GEM-CAR FAQ
Active and Inactive GL Accounts
When you import a chart of accounts, the accounts already configured in GEM-CAR will become inactive, and the imported accounts will become active.
So make sure that all your accounts are included in the chart of accounts you are importing.
For example, you have already set up your Petty Cash account (1002) in GEM-CAR but you want to import a chart of accounts.
If the chart of accounts you import does not include account 1002 - Petty Cash, this account will become inactive in the software.
The main accounts of type C, Accounts Receivable, and P, Accounts Payable, must have a starting balance of zero.
The trick is to add up the amounts of these two accounts and add it to the account type AJ, Adjustment account.
This way, your trial balance will balance after the import. You will only have to import your receivables and payables using the tab Invoices.
Where the lines of type Customer total the amount you had in the account of type C and those of Supplier total the amount of P.
Tip: In Excel, make sure you sum the "Start balance" column. If you get zero, you can proceed with the import, otherwise, you have some work to do. (Don't forget to delete this total before importing).
Posted
5 months
ago
by
Olivier Brunel
#425
47 views
Edited
3 months
ago