This interface allows synchronizing open balances per invoice between the accounting system and Scope.
Based on the current open balances in Scope and the reported balances in the import file, payments are identified. Invoices not contained on the open balance list will be regarded as fully paid.
Open balances based on invoices not known in Scope - created by other billing systems - will also be imported and are included in the total open balance of a debtor. Note, that the open balances of these invoices need to be reported in local currency, as Scope doesn’t know the exchange rate to convert an open amount in foreign currency into local currency.
Where to start
Go to Finance > Payments (Invoices) and click on Import in the top menu.
File Format
![example csv](https://service.riege.com/hs-fs/hubfs/Scope%20Exit/example%20csv.png?width=688&height=144&name=example%20csv.png)
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.
Account Number |
Konto Kontonummer |
Customer |
Debtor Debitor |
Vendor |
Creditor Kreditor |
Voucher Number |
Rechnungsnummer Rechnungs-Nr. Rechnungs-Nr |
Voucher Date |
Rechnungsdatum Datum |
Open Balance |
Saldo Betrag |
Type |
Credit Debit Indicator Credit/Debit Indicator Soll-Haben-Kennzeichen Soll-/Haben-Kennzeichen S/H Betrag S/H Saldo |
Currency |
Währung |
Alternative Debit Indicators
Alternative debit indicators to the default “D”:
-
“S”