Loading
Uniconta
Get Uniconta
  • Visit a Country Site
    • Danmark
    • Deutschland
    • Eesti
    • Ísland
    • Lithuania
    • Nederland
    • Norge
    • Österreich
    • United Kingdom
  • Search
  • Uniconta
    • Ledger
    • Customer
    • Sales Order
    • Vendor
    • Purchase
    • Inventory
    • Logistics
    • Project
    • Light Manufacturing
    • CRM
    • Dashboard
    • Company
    • Adaptability
  • Download
    • Uniconta for Windows
    • Uniconta for Mac
  • Resellers
    • Find a reseller
    • Become a reseller
    • Become an integration partner
    • Partner Portal Login
    • Partner Portal sign up
  • Developers
    • Become an integration partner
    • Documentation
    • Downloads
    • Samples
    • Support
  • Accountants
    • Become a Univisor
  • News
  • About us
    • About us
    • Management
    • Contact

Unipedia

  • Introduction
    • Get started with Uniconta
    • Which browser are you using?
    • Get started with an existing set of accounts
  • Converting to Uniconta
    • Conversion tool
    • What can be converted to Uniconta?
    • Converting from NAV to Uniconta
    • Converting from e-conomic to Uniconta
    • Converting from C5 to Uniconta
    • Converting from eCtrl to Uniconta
    • Checking your accounts after conversion
  • General Ledger
    • How to split voucher PDF
    • Chart of Accounts
      • Chart of Accounts
      • Account types
      • System Accounts
      • Import a Chart of Accounts
    • General journals
      • Journal Entries
      • Import from a file
      • Import Bank statement
        • Automatic account selection
      • Posting in foreign currency
      • Posting customer payments
      • How to manage voucher number series
      • Setting up Journals
      • Cancel voucher/delete journal/delete record
    • Bank Reconciliation
      • Bank Management / Bank reconciliation
      • Automatic account selection
    • Budget
      • Budget
    • Reports
      • Account statements
      • Transactions
      • Financial Statement
      • Physical Vouchers
      • Posted Journals
    • VAT reporting
      • VAT reporting – Denmark
      • VAT specification – Denmark
      • EU sales
      • Intrastat
      • EU sales list
    • Pivot table
    • Maintenance
      • Dimensions
      • – Join two dimensions
      • – Reverse charged VAT – Denmark
      • Voucher number series
      • – Automatic allocation of number series
      • Terms of payment
      • – Managing cash discounts
      • Accounting year
      • – Year end closing/opening balances
      • Join two accounts
    • Audit activities
      • Company accounts templates
      • Export transactions
  • Customer
    • Customer
      • Customer
      • – Reconciling Customer Accounts
    • Quick invoice
      • Quick invoice
    • Sales
      • Sales orders
      • – Create purchase/sales order
      • Quotations
      • Mass update
      • – Generate UBL
      • – Purchases and sales without VAT
      • Order journal
    • Reports
      • Statement
      • Transactions
      • Open transactions
      • Payment proposals (SEPA)
      • Ageing report
      • Interest and collection letter
        • – Collection letter messages
      • Invoices
      • Delivery note
      • Stock transactions
      • Order lines
      • Customer statistics
      • Pivot table
    • Maintenance
      • Customer groups
      • Order groups
      • Shipments
      • Terms of delivery
      • Layout groups
      • Number sequences
        • – Error messages
      • Invoice layout
        • – Creating watermarks
      • E-mail setup
        • – Setting up SMTP
        • – Mail server set up
        • – Forwarding e-mails to Uniconta
      • Document messages
      • SEPA set up
      • Mandates (SEPA)
      • Customer Direct Debit
      • Join
        • Join two accounts
        • Join two sales orders
        • Join many
  • CRM
    • – Introduction to CRM
    • Prospects
      • – Creating an quotation for a prospect
      • – Create follow-up
    • Customers & Prospects
    • Follow-up activities
    • Create e-mail list
    • Campaign
    • Maintenance
      • Interests
      • Products
      • CRM groups
      • Follow-up groups
      • Campaign groups
  • Vendor
    • Mass update
    • – Purchases and sales without VAT
    • Reports
      • Statement
      • Merge payments
      • Ageing report
      • Pivot table
    • Maintenance
      • Vendor groups
      • Purchase order groups
      • Vendor layout groups
      • Number sequences
      • File formats for methods of payment
        • – Setting up messages for vendor payments
        • – Setting up bank days
      • Join
      • – Join two accounts
      • – Join two purchase orders
      • – Join many
  • Inventory
    • Items
    • Stock Journal
    • – Posting in the stock journals
    • – BOMs in Uniconta
    • – Handling packaging fees
    • Reports
      • Inventory account statement
      • Inventory transactions
      • Item stock status
      • On-hand
      • Re-order list
      • Pivot table
    • Maintenance
      • – Purchasing number series items
      • Join two items
      • Variants
        • – Default variants
        • – Importing old inventory transactions
  • Project
    • Get started with Project and Time
    • Invoicing in the project module
    • Project Categories
    • Pivot table
    • Project groups
  • Company
    • Company information
    • View a demonstration company
    • User rights
      • Manage users
      • Requests for company access
      • Request company access
    • Maintenance
      • Configure application functionality
      • Preferences
      • Subscription (Administrators)
      • – Create subscription (Administrators)
      • – Create subscription (Client)
      • – From trial period to subscription
      • – Counting financial items
      • Modification URL
      • Create a new company
    • Contacts
  • Administrator
    • Distributor Administration
    • User Login History
    • Partner Plugin
  • Tools
    • Main Menu
    • Save layout as a menu item
    • User Plugin
      • How to change Uniconta’s default plugin path
    • Report Generator
      • Report Generator
        • Acccount statement
        • Collection letter documents
        • Company accounts cover page
        • Picking list
        • Purchase documents
        • Sales documents
      • Create a report to be viewed externally
      • Expression binding for Reports
    • Additional setup
      • Local backup
      • Import e-conomic
  • Data Access
    • Transfer data from Uniconta to Excel
    • OData filter function
  • General
    • User Interface
      • User Profile
      • Shortcut Keys in Uniconta
      • Layout
      • Templates
      • How to search in Uniconta
      • Filter/Clear Filter
      • General tips
    • General Functions
      • Attachments
      • Copy and paste in Uniconta
      • Export data and reports to file format
      • Send documents and data by e-mail
      • Print reports and list forms
      • National company number lookup
      • Excel, export and import
    • Security
      • Who has access to my accounts?
      • Forgot Password
      • Backup
      • Uniconta Security
    • Installation
      • Installation on RDS – Remote Desktop Server
      • Optimal internet access for Uniconta
      • Install Uniconta in Windows 7
      • Uniconta in the Microsoft App-Store
      • Uniconta for Mac

Payment proposals (SEPA)

369 views 28 August 2019 29 August 2019
Print Friendly, PDF & Email

Learn more about:

  • Layout
  • Filter/Clear Filter
  • Templates
  • How to search in Uniconta
  • Attachments
August 29th, 2019

Payment proposals (SEPA)

Payments are carried out in the ’Payment proposal’ screen shown below. This screen shows all open Customer transactions.

 

 

Note: that the word ’Payment’ is also used in this article to describe payments approved via mandates and drawn from the Customers’ bank accounts.

 

The following table gives a description of each column:

 

ColumnRead/WriteDescriptionNote
Payment statusRPayment status.The payment status column is updated automatically but can also be edited manually. For a more detailed description see the section below on the ’Change status’ button.
Date sentRThe ’date sent’ is the date/time upon/at which the payment request was sent.
AccountRCustomer number.
Account nameRCustomer name.
DateRPosting date for the transaction.
Due dateRDate after which the payment is past due.
Payment dateWPayment date.The Payment date is automatically set to the Due date unless the Due date is exceeded. If the Due date is exceeded, then today’s date is automatically entered in the Payment date field. Uniconta will take account of bank holidays, if activated (read about activation here).

The Payment date is the banking day upon which the transaction occurs in both your and your Customer’s accounts.

TextRTransaction text.This text will not be entered in the payment file.
InvoiceRInvoice number.
AmountRTransaction amount.
RemainingRAmount remaining.The remaining payment if the ’Partial payment’ field is not filled out.
Partial paymentWPartial payment amount.Must only be filled out if the full amount is not requested. If a Cash discount is given, then this field will automatically deduct said discount.
Transaction typeRTransaction type
Status informationRStatus informationA chronological log of all activities performed on the transaction.
CommentWInternal commentsInformation provided in this field is for internal use only and will not be printed on the payment file.
MessageWMessage to Customer.This text will be printed on the payment file.
System infoRSystem informationThis column includes system information on the transaction. For example, error messages etc.
Invoice textRNot usedOnly used for the Danish ‘Nets’ solution.
Payment formatWFormat (File format for methods of payment).This column shows which method of payment has been selected for the payment.
VoucherRVoucher number
PaymentRPayment terms
CurrencyRCurrency codeDirect Debit SEPA only allows payments in EUR.
Payment referenceRA unique ID for the payment.A unique payment ID is generated upon sending.
Merge paymentsRAn ID for merged payments.Merged payments use an ID for the grouping.
Cash discount dateWCash discount dateInvoices paid before this date will trigger a cash discount.
Cash discountWCash discount amount
Cash discount usedWUsed cash discountCash discount amount to be applied.

 

The following section describes the buttons in the local menu.

 

 

’Validate’ button

This button runs a set of validations for the selected transactions according to their payment formats. The system checks deadlines, for example, whether there is an active mandate and performs a list of several other validations.

The result of the validation can be viewed in the ‘System info’ column. Only the payments with ’OK’ in this column will be sent.

’Export’ button

All selected payments with a Payment status of <Blank>, Resent or Stop will be sent upon pressing this button. Validation will automatically be run before sending. Read more about file creation below.

’Import’ button

Not used

’Merge payments’ button

Payments with the same Payment date can be merged. Read more about this function below.

’Expand All’ button

This button becomes active upon using the ’Merge payments’ function.

’Collapse All’ button

This button becomes active upon using the ’Merge payments’ function.

’Change status’ button

The payment status is automatically updated, however, it can also be updated manually using this button. The table below gives a detailed description of the various status options. It is possible to change the status of a transaction, with some limitations (see the last four columns in the table below in this regard).

 

StatusDescriptionChange -> <Blank>Change -> ResendChange -> On holdChange -> Stop
<Blank>Default status showing that the line is awaiting action. All lines can be edited to show this status independent of the line’s current status. However, it will not always be appropriate.NoNoYesNo
SentThe payment has been sent (the file has been created).YesNoNoYes
In progressNot usedYesNoNoNo
UnregisteredNot usedYesYesYesNo
RejectedNot usedYesYesYesNo
ReversedNot usedYesYesYesNo
ErrorNot usedYesYesYesNo
ReceivedNot usedYesNoNoNo
DifferenceNot usedYesNoNoNo
ResendNot usedYesNoYesNo
On holdThis payment status can be entered manually.YesNoNoNo
InformationNot usedYesYesYesNo
StopNot usedYesNoYesNo

 

’Transfer to journal’ button

This button transfers the selected transactions to a general journal. The following dialogue box will appear:

 

The dialogue box will automatically be filled out with the default values entered in the ’File formats for methods of payment’. In the above example, the payments will be transferred to the ‘SEPA’ journal and posted to the offset bank account 1010.

 

‘Layout’- ’Other fields’

Other fields (for example, from the mandate table) can be obtained using the ‘Layout’ button and by selecting ‘Other fields’. In the screenshot below the user has added the fields: ’Mandate’, ’Status’, ’Registered’, ’Scheme type’. The user can then filter for the active mandates.

 

Searching for payments

Payments can be selected by Due date, using the date delimitation fields as shown in the screenshot below.

Uniconta’s various filter functions are particularly useful here. In the example below, the user has set a filter in the ’Account’ column.

Note: Payment files are only sent for the listed/filtered payments shown.

Tip: Use the ’Comment’ field to filter for payments you wish to make.

In the example below, the user has typed an ’x’ in the ’Comment’ field for the payments that they wish to make. The user then filters for all fields with an ’x’ in the Comment field before sending.

Status ’On hold’

Status ‘On hold’ can also be used to search for payments. Use the ’Change status’ button to edit the status on the selected payments. Payments set to ’On hold’ will not be sent.

’Merge payments’ button

’Merge payments’ allows the user to merge payments by Customer and Payment date, enabling both efficiency and cost savings where the user needs to collect several payments from the same debtor on the same date.

Payments are merged using the ’Merge payments’ button. Uniconta will now attempt to merge the payments according to the conditions described above. We recommend sorting the payments to exclude those that the user does not wish to send at this time. This can be done using Uniconta’s filter functions.

All payments will be validated before they are merged. Any payments containing errors will be placed in an ’Excluded’ group. Read more about this group below.

Merged payments can be unmerged by clicking on the same button again (which is now called ‘Cancel merged payments’).

Credit notes etc.

Credit notes and other negative transactions are also included in the merged payments.

’Expand All’ button
This button is activated when ’Merge payments’ is used. All groups are expanded when this button is selected.

’Collapse All’ button
This button is activated when ’Merge payments’ is used. All groups are collapsed when this button is selected.

’Show/Hide Status information’ button
Status information is shown in the ’Status information’ column, but can also be shown at the bottom of the screen for a better view by using this button.

’Show/Hide Text’ button
Only used for the Danish ’Nets’ solution ’Payment service’.

’Validate’ button
Validates each payment in the group. If an error occurs on one of the payments, then it will not be merged with the other payments. A description of the error can be viewed in the ’System Info’ column.

The payments in the example above have been merged into six groups.

The first five groups will result in six payments. The last group ’Excluded’ contains all of the payments that will not be included in the payment file.

The following is a description of the groups. The groups are categorized by their ‘Merge payments’ ID. This ID is a combination of the unique key: (<Customer number>-<Payment date>) which identifies the payments in the group.

 

Merge payments: –
Payments in this group will be handled one at a time. This means that two payment requests will be made. One for each of the two Customers.

Merge payments: 50001-20190807
Customer 50001 has seven amounts due with a payment date of 07.08.2019. One merged payment will be created for the total of 2,990.50 DKK. The payment will be drawn on 07.08.2019.

Merge payments: 50002-20190729
Customer 50002 has two amounts due with a payment date of 29.07.2019. One merged payment will be created for the total of 1,847.27 DKK. The payment will be drawn on 29.07.2019.

Merge payments: 50002-20190807
Customer 50002 has four amounts due with a payment date of 07.08.2019. One merged payment will be created for the total of 1,322.40 DKK. The payment will be drawn on 07.08.2019.

Merge payments: 50005-20190729
Customer 50005 has eight amounts due with a payment date of 29.07.2019. One merged payment will be created for the total of 18,452.92 DKK. The payment will be drawn on 29.07.2019.
Note that two of the transactions are credit notes which will be deducted.

Merge payments: Excluded
All payments that contain one or more errors or do not fulfil the criteria for any other reason, will be placed in the ‘Excluded’ group. These payments will not be included in the payment file.

 

Transfer to journal

 

Uniconta keeps track of which payment lines were merged when they are transferred to the general journal.

 

 

The example above shows that 6 lines will be transferred to the journal. The ’Settlements’ column shows the transactions that are paid. These invoices will automatically be settled upon posting the journal.

 

File archive

All payment files that have been created will be archived in the ‘File archive’. The file archive can be opened directly from the local menu in the payment proposal screen.

The following is a description of the columns in the file archive.

 

ColumnRead/WriteDescriptionNote
CreatedRDate upon which the file was received/sent.
Vendor account numberRVendor account numberUnique company ID.
ExportRA tick here represents the receipt/sending of the file.Files created in Uniconta will receive a tick mark here.
File nameRThe name given to the electronic file.The file name is created using

the following information:
SEPA_<DirectDebitscheme>_<UniqueFileID>_<CompanyID>_<UniqueIndicationOfTime>

File-IDRA unique file ID
Payment formatRFormat (File format for methods of payment)Indicates which payment method the file relates to.
StatusRThe status column can be one of the following: Pending The file has not been read yet.
Ok The file has been correctly processed.
Error Indicates that this payment/mandate needs to be reviewed.
Status informationRA log of all activity.

 

The following is a description of the buttons in the local file archive menu:

 

’Show/Hide Status information’ button
The status information can be seen in the relevant column. However, it is also possible to see the information at the bottom of the screen for a clearer view.

’Export file’ button
It is possible to export files if the user wishes to review their content.

‘View’ button
This button can be used to view the contents of each file.

  • Was this Helpful ?
  • YesNo
Categories: Customer, Unipedia

Get in touch with us

Uniconta

  • Uniconta
  • Subscription Terms
  • System Status

PARTNER

  • Resellers
  • Get Uniconta
  • Documentation

INFO

  • News
  • Video
  • Security

Support

  • Unipedia
  • API Support
  • Visit a Country Site
    • Danmark
    • Deutschland
    • Eesti
    • Ísland
    • Lithuania
    • Nederland
    • Norge
    • Österreich
    • United Kingdom
Uniconta
© Copyright 2019 | All rights reserved | info@uniconta.com | Terms & Conditions
Facebook Twitter LinkedIn Youtube