How can I import payments (open balances), and what do I need to know about the import format?

This interface allows synchronizing open balances per invoice between the accounting system and Scope.

Where to start

Go to Finance > Payments (Invoices) and click on Import in the top menu.

File Format

Picture of example CSV file for accounts receivables & payables with sign 

Supported file types

• CSV with separator ';'

• Excel (xls and xlsx)

Column headers are mandatory as they describe the content of the file and determine the import mode in Scope.

Different import modes exist for

• Account receivables AND account payables

• Account receivables only

• Account payables only

The import mode is determined by the naming of the column holding the debtor or creditor account number:

• Header name Account Number → import mode “Account payables & receivables”

• Header name Customer → import mode “Account receivables”

• Header name Vendor → import mode “Account payables”

When importing open balances, a complete list of all applicable invoices with an open balance different from zero is required. Applicable Invoices not contained in that list will be treated as paid. Applicability of invoices is determined by the import mode.

Import Modes

Account Receivables & Payables

Use one of the following formats:

• Signed amounts
  Account Number;Voucher Number;Voucher Date;Open Balance;Currency;
  Example: Accounts receivables & payables with sign.csv

• Unsigned amounts with D/C identifier
  Account Number; Voucher Number;Voucher Date;Open Balance;Type;Currency;
  Example: Accounts receivables & payables with DC.csv

Account Receivables only

Open account payables will not be marked as paid when using this import mode.

 Use one of the following formats:

• Signed amounts
  Customer;Voucher Number;Voucher Date;Open Balance;Currency;
  Example: Accounts receivables only with sign.csv

• Unsigned amounts with D/C indicator
  Customer; Voucher Number;Voucher Date;Open Balance;Type;Currency;
  Example: Accounts receivables only with DC.csv

Account Payables only

Open account receivables will not be marked as paid when using this import mode.

Use one of the following formats:

• Signed amounts
  Vendor;Voucher Number;Voucher Date;Open Balance;Currency;
  Example: Accounts payables only with sign.csv

• Unsigned amounts with D/C indicator
  Vendor; Voucher Number;Voucher Date;Open Balance;Type;Currency;
  Example: Accounts payables only with DC.csv

Open Balance Currencies

The open balance may either be reported in invoice currency or in local currency of the Scope legal entity.

In case the open balance is reported in legal entity currency, the exchange rate on invoice header level is used to convert the open balance into invoice currency. This option is only recommended to be used, if the accounting interface transfers all invoices to the accounting system in legal entity currency.

Debit Indicator

The default debit indicator to be used with column Type is “D”.

Alternative Column Names

To simplify the integration of this interface with different accounting systems, alternative column names and debit indicators may be used.

Alternative debit indicators to the default “D”:

• “S”