GEM-WORK / Operations
Importing Payables and Receivables
Option 1: With the transfer tool
- Transfer with the tool.
- If the balances do not balance, you must delete the transaction(s) with the tool (coming November 23) and move on to option #2.
Option 2: Using the Excel file
- Transfer by Excel from V14 or other systems.
Go on the menu and select Configurations > Import/export > Receivables/payables.
- Example of formatting (validate dates YYY-MM-DD) and special characters.
- Put supplier for payables and customer for receivables.
- Put the transaction documents in Excel and PDF in the transaction generated by the import.
Option 3: Manually
Example of account receivable
In the transaction:
- Add the customer.
- Click the Invoice button on the left side.
- In the transaction use the counterpart 3520 to the credit.
Go on the menu Accounting > New transaction.
Account payable example
In the transaction:
- Add the Supplier.
- Click the Invoice button on the right side.
- Date: 1 day before GO LIVE or that of the real invoice if they are entered one by one.
- In the Name field: put the old invoice number if you enter the invoices one by one.
- In the transaction use the counterpart 3520 in the Debit, and the amount receivable in the Credit.
Other articles on the subject:
How to Import Your Data from Another Accounting Software
How to Import a Chart of Accounts
Importing Data from SAGE to GEM-CAR
Posted
1 year
ago
by
Olivier Brunel
#620
346 views
Edited
1 year
ago