Loading
Uniconta
Search
Generic filters
Free trial signup
  • Visit a Country Site
    • Dansk
    • Uniconta GermanyDeutsch
    • Eesti
    • Uniconta GermanyÍslenska
    • Lietuva
    • Uniconta NetherlandsNederlands
    • Norsk
    • English
  • Search
  • Uniconta
    • What is Uniconta ?
    • Modules
    • Ledger
    • Customer
    • Sales Order
    • Vendor
    • Purchase
    • Inventory
    • Logistics
    • Project
    • Light Manufacturing
    • CRM
    • Fixed assets
    • Dashboard
    • Company
    • Adaptability
    • Uniconta Assistant App
    • Uniconta Upload App
  • Download
    • Uniconta for Windows
    • Uniconta for Mac
    • Download for Developers
    • Free trial signup
  • Resellers
    • Find a reseller
    • Become a reseller
    • Uniconta Partner info Login
    • Uniconta Partner info Sign up
  • Developers
    • Become an integration partner
    • Documentation
    • Samples
    • Downloads
  • Accountants
    • Become a Univisor
  • News Overview
    • Blog
    • News
    • Uniconta Update
    • Customer cases
  • About us
    • About us
      • Management
      • Contact
      • IT Security ISAE 3402
      • System status
    • Terms & Conditions
      • License Agreement
      • Data Processing Agreement (DPA)
      • Privacy policy
      • Cookie policy
      • Sub-processors

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
      • – Azure Authentication in Uniconta
      • 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
      • 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
Search
Generic filters

– Managing cash discounts

1,222 views 10 January 2018 6 September 2019 5 minutes
Print Friendly, PDF & Email

Learn more about:

  • Layout
  • Filter/Clear Filter
  • Templates
  • How to search in Uniconta
  • Attachments
September 6th, 2019

 

‘Cash discounts’ can be given to customers or by vendors when invoices are paid by a specific date. These can be set up for both Customers and Vendors and are used for both Sales and Purchase orders.

Cash discounts can also be used when entering invoices directly in the accounting journals.

 

Setting up cash discounts

Several set up steps are necessary in order to use cash discounts in Uniconta, as described below.

 

Terms of payment


Use the navigation panel to go to General Ledger/Maintenance/Terms of payment. Cash discounts are set up under ‘Terms of payment’, as shown in the screenshot below.  In this example, two payment terms have been set up with a due date of 14 days and a cash discount for payment prior to a 10 and 5 days respectively.

 

(Click on screenshots to enlarge.)

 

Click on ‘Add’ or ‘Edit’ in the ‘Terms of payment’ toolbar/ribbon to add or edit terms of payment. The example below shows the detail form for payment due in 14 days, with a 5% discount if payment is made within 10 days. In this case the user has chosen to enter a short payment name of ‘NT_14_5_10’.

 

 

Vendor/Customer groups

Ledger accounts for cash discounts can be created within the Vendor and Customer modules where required.

Use the navigation panel, for example, to go to Vendor/Maintenance/Vendor groups and click on ‘Add vendor group’ or ‘Edit’ to add or edit a vendor group.

The same can be performed in the Customer module to edit any customer group.

Select a cash discount ledger account for each Customer/Vendor group under the ‘Settlement discount’ account selection dropdown menu. In the example below, account ‘40320 – Discounts and Allowances (vendor related)’ is chosen. 

 

(Click on the screenshots to enlarge).

 

Vendor cash discounts

 

Purchase orders

The example below describes how to set up a vendor invoice with a cash discount from the ‘Purchase order’. Use the navigation panel to go to Vendor/Purchase orders and create or select a purchase order by clicking on the ‘Add’ or the ‘Edit’ button in the toolbar/ribbon.

Set up the purchase order with payment terms that have already been created in Vendor/Maintenance/Terms of payment. The example below selects the NT_14_5_10 payment terms (14 days with a 5% discount for payment within 10 days) that was set up in the example above.

 

(Click on screenshot to enlarge).

 

Click ‘Save’ in the toolbar/ribbon and then ‘Refresh’ to update the edits. The ‘purchase orders’ screen now shows the purchase order line including the ‘Payment’ terms column. Read more about viewing columns in Unipedia’s Layout section.

 

(Click on screenshot to enlarge):

 

Overriding payment terms

There are two additional fields in the ‘Purchase order’ form that effect the invoice, as shown in the screenshot below. These would override the payment terms set up for the vendor.

 

 

That is to say that payment terms can be overriden within a ‘Purchase order’ by filling in the two fields in the screenshot above:

‘Cash discount date’ and,

‘Cash Discount (Amount)’.

If these fields are filled in, then the cash discount for this particular purchase order will not be calculated based on the ‘Terms of payment’ that have been previoulsy selected for this particular vendor.  Using the example in the screenshot above, the cash discount will be 100 GBP if payment is made before 10/03/2018.

 

Open transactions

Use the navigation panel to go to Vendor/Reports/Open transactions to see open transactions.

The screenshot below (English screenshots coming soon) shows an example of a vendor invoice set up with:

  • NT14_10_5 payment terms (‘Betaling’),
  • a 10% ‘Cash discount’ (Kasserabat) of 93.75,
  • on a 937.50 invoice ‘Amount’ (Beløb)
  • with a cash discount payment date of 13-01-2018 (Kasserabatdato)
  • and a due date of 22-01-2018 (Forfaldsdato)

 

(English screenshot coming soon).

 

TIP: If the columns are not visible, right click on any column heading and click on ‘Select Fields’ to drag and drop new headings. Read more about layouts here. 

 

Payments

Under Vendor/Reports/Payments, there are 3 columns affected by a cash discount, once a payment has been paid, as shown in the screenshot below.

 

(English screenshot coming soon).

The three columns affected are shown in the screenshot above and are:

 

Cash discount date: (Kasserabatdato) If a payment is paid by this date the cash discount is triggered.

Cash discount: (Kasserabatbeløbet) Cash discount amount to be used.

Cash discount used: (Udnyttet kasserabat) If the criteria for the cash discount are met (the cash discount date >= the payment date) then the cash discount amount will be entered in this column.

 

Example: Invoice (Faktura) number 234539

In the first line item in the example above, the criteria to receive a cash discount have been met i.e. the payment was made before the cash discount date.

The ‘Cash discount amount’ (Kasserabatbeløbet) is therefore shown in the ‘Cash discount used’ (Udnyttet kasserabat) column.

The ‘Payment amount’ (Betalingsbeløbet) is the ‘Invoice amount’ (Fakturabeløb) less the ‘Cash discount used’ (Udnyttet kasserabat)

 

Example: Invoice (Faktura) number 998877

The example in the second line item above, shows that the ‘Payment date’ (betalingsdato) is after the ‘Cash discount date’ (Kasserabatdato). The payment terms for a discount have therefore not been met.

The ‘Cash discount amount’ (Kasserabatbeløbet) of 600,00, therefore, does not appear in the ‘Cash discount used’ (Udnyttet kasserabat) column.

 

Payment journal entry


The payment journal entry accounts for the invoice payment including the cash discount. In the example below, the cash discount of 93.75 is posted as a credit to account number 4315, ‘Cash discount from vendor’ (Kontantrabat fra leverandører).

 

 

Go to Vendor/Reports/Transactions to view the vendor transactions. The example above appears in the ‘Vendor transactions’ (Kreditor posteringer) screen below.  The cash discount is described in the ‘Text’ (tekst) column as ‘Discount’ (Rabat).

 

(English screenshot coming soon).

 

Note that if users post a payment directly in a journal they will need to enter the ‘Cash discount used’ manually. This is because Uniconta does not assume that a cash discount was used upon payment, if the amount paid does not come from a bank file or a payment file that is then ‘Transferred to Journal’.

General links

Layout
Template
Search
Attachments
Filter/Clear Filter

Other useful links

Terms of payment

 

 

 

 

  • Was this Helpful ?
  • YesNo
Categories: General Ledger, Maintenace, Unipedia
Home » Unipedia » General Ledger » – Managing cash discounts

Get in touch with us

Uniconta

  • Uniconta
  • Modules
  • Downloads
  • Free trial signup
  • Subscription Terms
  • System Status

PARTNER

  • Become a Reseller
  • Uniconta API key application
  • For Developers
  • For Accountants (Univisor)
  • Uniconta Partner info

INFO

  • News
  • Updates
  • Customer cases
  • Video
  • IT Security
  • About us
  • Management

Support

  • Unipedia
  • API information
  • Contacts
  • Visit a Country Site
    • Dansk
    • Uniconta GermanyDeutsch
    • Eesti
    • Uniconta GermanyÍslenska
    • Lietuva
    • Uniconta NetherlandsNederlands
    • Norsk
    • English
Uniconta
© Copyright 2019 | All rights reserved | [email protected] | Terms & Conditions
Facebook LinkedIn Youtube