Import the Payables and Receivables

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. 

Manually

Go on the menu Accounting > New transaction.

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.

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.