Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Status
colourRed
titledraft

Excerpt

The Payments page allows for creating new Wire Transfer payments from uploaded bank statements or manually to allow for payment allocation to unpaid invoices. All forms of payments on orders can also be viewed in this screen.

Tip

For detailed information and how to page for creating wire transfers and payment allocations see: Wire transfers and Payment allocations.

Info

To enable the Payment back office screen, the following user role authorizations are required: WireTransfer command, BackOfficeOrder entity (view), Invoice entity (view), Payment entity (view, add, edit).

...

Info

The Payments back office page allows for the following functions:

  • Payments overview: Use search and filtering for a complete overview of all created payments in FBO One.

  • Allocate payments to orders and invoices: Allocate received payments from uploaded bank statements or manually created wire transfers to orders and invoices.

  • Upload bank statement files: Batch upload payments from bank statements quickly and easily. Saving time in manually creating many received payments. See How to upload wire transfer payments from bank file statements.

  • Record bank charges and payment differences: Account for bank charges for received payments and currency payment differences.

  • Add wire transfers: Manually create wire transfer payments for allocation to invoices and orders.

...

Filter

Description

Example

Free text search

Free text search, searching by: Payment key, Amount, Description, External POS number, Payment remarks.

Administration

Filters on available Administrations for payments, if blank then current Administration (based on FBO location) is used.

Tip

If Administration groups are used, they will show as an option with the number of Administration group members shown.

Image Modified

From debtor

Filters on debtor assigned to a payment. This can include payments that are received unallocated and already allocated. If blank, then all debtors show, including wire transfer payments without a debtor assigned.

Form of payment

Filters on the form of payment, if blank then all forms of payments are shown.

Payment uploads

Filters on payments uploaded from file. The ‘Payment uploads’ filter will populate after each successful upload in the following format: 'Date of upload | Administration | Settings name (Count for this date)'

Info

Note: The following filters are ignored when ‘Payment uploads' filter is used: From debtor, Form of payment, On or after date, Before date

On or after date

Filters to show payments on or after this date, shown in the ‘Date’ column.

Info

Note: The default ‘On or after date’ is the start of the current month. Tip: Using with ‘Before date' filter will create a date range.

Before date

Filters to show payments before this date, shown in the ‘Date’ column.

Info

Note: The default ‘Before date’ is the start of the next month. Tip: Using with ‘On or after date' filter will create a date range.

Only unallocated

Filter to show payment rows that have an ‘Unallocated’ amount greater or less than 0.

Info

Note: Only unallocated’ is enabled by default. When payments are fully allocated, they will automatically disappear due to no longer having an unallocated amount; disable this filter to show fully allocated payments.

Only payments received

Filters to show payment rows that have a positive amount ‘Amount’.

Info

Note: Only payments received’ is enabled by default. Disable this filter to view payment rows that have a negative amount e.g. credit payments.

Include ignored payments

Include any wire transfer payments that have been ignored, and therefore can no longer be allocated to orders and invoices.

Filter summary

Shows a result summary from current filtering. Format: Payments found and total amount sum | Administration | Filters applies.

Tip

Clicking the arrow button on the right will show or hide filters allowing for more space on smaller screens.

Image Added

Upload bank statement

'UPLOAD BANK STATEMENT' allows uploading bank statement files of various formats to batch create the payment lines directly into FBO One. Saving time compared to individually adding each wire payment.

Tip

See How to upload wire transfer payments from bank file statements guide and video for detailed information for uploading payments to FBO One.

Info

Payment upload info:

  • Uploading bank statements allow for batch creating payments for allocation.

  • Bank costs can be accounted for automatically against a received payment.

  • File upload settings allow for high flexibility for supporting different file formats and layouts from various banks.

  • File upload settings are saved and referenced automatically on next upload from the same bank.

  • Bank file statements can usually be downloaded from your bank website, accepted file types for upload are CSV, TAB, STA, TXT (if has a delimiter).

Add wire transfer

Adding a The 'ADD WIRE TRANSFER' allows manually creating received wire transfer , allows for amounts transferred as payment by specific Debtors, to be logged.
These transfers, may then be used in part, or in their entirety, on one or more orders for that Debtor. Both full and partial payments are possible when deducting from a wire transfer.
To add a wire transfer, go to the Back Office > Payments tab:

...

Use the ‘Add wire transfer' button to begin recording the transfer. Enter the Transfer date/time, Amount, Currency & Debtor from whom the transfer was received.
The 'Description’ field is mandatory. Enter N/A if no remarks are relevant

...

Once created, the Transfer will appear as follows:

...

Managing Mistakes in Wire Transfers

If a mistake has been made in creating a particular wire transfer, the payment must be 'Ignored', it cannot be deleted.

Info

Note: Ignored wire transfer payments can be reactivated if required.

Ignoring payments

Note

A wire transfer payment can only be ignored when it does not have any payment allocations made against it. If an amount has been allocated, all payment allocations must first be de-allocated before the payment can be ignored.

  1. Click the Menu icon in the top right corner of the payment column

  2. Click ‘Ignore payment’ option from the menu.

...

Reactivating ignored payments

Ignored payments can no longer be used for allocation to any invoices or orders, this is indicated from the ‘Is ignored | Yes’ field shown in the payment. To allow an ignored wire transfer to be used for allocation, it requires reactivation, this can be done inside the opened payment column.

From the opened payment:

  1. Click the Menu icon in the top right corner of the payment column

  2. Click ‘Reactivate payment’ option from the menu.

...

Allocate payment

Payments can be allocated to Orders or to Invoices. This means that payments may be allocated as pre-payments for open Orders or as final payment to Invoices that have been issued.
Payments can be allocated in two ways:

Payments screen - Allocate payment

...

Click on the payment to be allocated

...

In the opened payment click the ‘Find invoice/order Allocate Payment’ field in the 'Payment Allocations’ section.

...

2. A drop-down dialog will open. Search the Invoice, or Order number, to which the payment should be allocated, and enter the amount to allocate.
Payment allocation remarks may also be added here:

...

Once a payment has been full, or partially allocated, the amount allocated so far will be updated.
A separate line will then be created for each individual ‘Payment Allocation'. The ‘Handling’ column will show reference to the Order and/or Invoice to which a Payment has been allocated.

...

Order screen - Select pre-payment

A payment can be allocated also from the Front Office Order screen:

  1. Click on the ‘This order needs payment / Amount Due' field to open payment menu.

  2. Select the 'Select pre-payment' option.

...

If any unallocated Wire transfer payments are available for the debtor, then these will be show in the drop-down:

  1. Select the ‘Search wire transfer’ field, a list of available payments will show, alternatively searching by payment key will show additional payments.

  2. Select an available payment to continue.

...

Once a payment is selected, the screen will expand to allow for the 'amount to allocate' to be entered. Full or partial payment of the order is possible here:

  1. Enter an amount to allocate for the order in the ‘Amount to allocate (EUR)’ field.

  2. Enter any payment remarks in the 'Payment allocation remarks'.

  3. Click ‘OK’ to complete the payment allocation and paying the outstanding amount.

Info

Note: 'Payment allocation remarks' will show to the customer on the payment line.

...

After payment allocation, the payment is applied to the order and shown on the order receipt.

...

payments for allocation to due invoices and outstanding orders.

Tip

For detailed information and how to add wire transfers see How to manually add a wire transfer payment or How to upload wire transfer payments from bank file statements.

...

Allocate payment

Info

Allocating payments in the Payments page info:

  • The Payments (Back office) page is the primary page for creating wire transfers, giving an overview of all payments for each Administration.

  • Clicking on any wire transfer payment, row opens the payment detail column allowing for payment allocations by searching by invoice and order key.

  • The Payments (Back office) page is suited for viewing all payment allocations, creating wire transfers, making corrections to payments and as an overview of all payment types.

Tip

See Payments: How to allocate wire transfer payments to invoices and orders in the Payments (Back office) page for details how to page for allocating wire transfer payments in the Payments page.

Payment grid

The payment grid gives an overview of all payments per Administration. Clicking a row will open the Payment detail column to allow to a

...

Column

Description

Example

Date

The payment date. This is the date the payment was created.

Key

The payment key. This is the unique number for the payment and can be searched for in ‘Free text search’.

Amount

The amount and currency received for payment. This is the gross amount before any adjustments from bank costs or payment differences.

Bank costs

Bank costs amounts from related uploaded bank cost payments. See How to upload payments from bank file statements.

Info

Note: Bank cost payments are linked to received payments by matching payment transfer details.

Payment differences

The total amount of payment differences for a wire transfers.

Image Added

Adjusted Amount

The total amount adjusted after accounting for Bank costs and Payment differences.

Info

Amount - (Bank costs - Payment differences)

Unallocated

The amount unallocated for a wire transfer payment. This is the amount that needs to be allocated to any unpaid orders or invoices to mark as paid.

Allocated

The amount allocated for a wire transfer payment. This is the amount that has already been allocated to orders or invoices to mark as paid.

Form of payment

The form of payment for the payment.

From

The debtor the payment is received from. For wire transfers, choosing a debtor restricts the unallocated amount to only be used for the debtor’s orders and invoices.

Transfer details

The transfer details for the payment. This is the remark added from the ‘Description’ column of created wire transfers, it’s also the ‘POS receipt number’ for standard payments.

Remarks

The payment remarks. The free text remarks added when creating the payment.

Image Added

Ignored

If the wire transfer payment has been ignored. If ‘Yes’ the wire transfer can no longer be used for any payment allocation to orders or invoices.

Payment detail

...

Info

The following functions are available in the Payment detail column:

  • Delete or Edit payment - Edit wire transfer detailspayments - Delete or edit payments, including amount amounts and date of transfer.

    Image Added
  • Assign debtor to unknown payments - Use the ‘From debtor’ icon Add debtors to restrict unallocated amounts to only be used for a certain debtor.

    Image RemovedImage Added
  • Allocate amounts to invoices - Allocate wire payment amounts received to invoices and orders with an amount due. See Wire transfers and Payment allocations for allocating payments.

    Image Added
  • Ignore payments - Mark wire transfer payments as ignored to prevent payment allocations to invoices or orders.

    Image Added

Deleting payments

...

Info

Deleting a payment is available for payments that have not been invoiced and for wire transfers that have no payment allocations.

Ticking the checkbox is required to ensure accidental payment deletes are not done.

...

Editing payments

...

Info

Editing a payment is available for payments that have not been invoiced and for wire transfers that have no payment allocations.

Editing wire transfers

Wire transfers that have no allocations can be edited to allow changing the following:

...

  • Transfer date/time: The payment date.

  • Amount: The wire transfer amount received.

  • Currency: Drop down of available currencies. Note: Currency exchange rates may need to be set for allocation to invoices in different currencies. See Exchange rates (Administration).

  • From debtor: The debtor the wire transfer was received from, and is restricted to for allocation.

...

  • Note: If not set, the wire transfer payment can be allocated to any debtor.

  • Transfer details: Free-text information for the wire transfer. This field is populated by the ‘Description’ column when uploading a bank statement.

...

Editing all other payments

Non-wire transfer payment types fields can be edited:

Info

The Amount cannot be edited. Deleting the payment and creating a new payment with the correct amount should be done instead.

  • Payment date: The payment date.

  • Form of payment: Change the form of payment type.

  • Payment remarks: Add free text remarks for the payment.

...

Fields

PaymentPayment allocationsBank Costs

Field

Description

Example

Image Added

From debtor

Displays the debtor the payment applies to. This restricts wire transfer allocation to this debtor only.

Tip

Clicking on ‘From debtor’ allows changing the debtor for the payment (wire transfers only).

Image RemovedImage Added

Date

The payment date. This is the date the payment was created.

Tip

Clicking on ‘Date’ allows editing the payment details.

Image RemovedImage Added

Online payment status

The current online payment status. Only applicable if the payment is an online payment.

Image RemovedImage Added

Bank statement source

The bank statement upload source. The date and settings used for upload of bank statement. See ‘Payment uploads' filter.

Image RemovedImage Added

Transfer details

The transfer detail description added for wire transfers or uploaded payments from bank statements.

Tip

Clicking on ‘Transfer details’ allows editing the payment details.

Image RemovedImage Added

Total payment

The total amount before any adjustments.

Tip

Clicking on ‘Total payment’ allows editing the payment details.

Image Removed

Payment source

The wire transfer source payment used as a source for payment allocation to an order or invoice. Image Added

POS receipt number

The point of sale receipt number added on offline payments.

Image RemovedImage Added

Cost for wire transfer

The payment key for the wire transfer the bank cost payment applies to.

Tip

Clicking on ‘Cost for wire transfer’ will open the cost payment’s detail.

Image RemovedImage Added

Payment difference

The payment differences sum for wire transfers.

Image Added

View order

The order that the payment was allocated to.

Tip

Clicking on the ‘View order’ button will open a 3rd column showing the order details.

Image RemovedImage Added

View invoice

The invoice the payment was allocated to.

Tip

Clicking on ‘View invoice’ will redirect to the invoice detail page.

Image RemovedImage Added

Source wire transfer

The payment key for the source payment used for payment allocation.

Tip

Clicking on ‘Source wire transfer’ will open the source payment’s detail.

Image RemovedImage Added

Remarks

Free-text remarks added on the payment.

Image Added
Image Added

Find invoice/order

On click expands to allow for allocating unallocated payment amounts from wire transfers to invoices or orders.

Image RemovedImage Added

Key

The payment key for the payment allocation.

Image RemovedImage Added

Handling

The order key and invoice for the payment allocation.

Image RemovedImage Added

Payment

The amount allocated as paid to the invoice.

Image RemovedImage Added

Remark

Payment remarks for the allocation.

  1. Total payment

  2. Payment differences

  3. Bank costs

Bank costs

Total
  1. The sum of all payment allocation rows.

Image Removed

Payment differences

  1. The sum of all payment differences.

  2. The sum of all bank costs incurred and added to the payment

amount
  1. for allocation.

Image RemovedImage Added
  1. Total payment adjusted

  2. Already allocated

  3. To be allocated

  1. The total payment adjustment after the total payment has had payment differences and bank costs deducted.

  2. The total amount allocated to orders and invoices.

  3. The total unallocated amount to be allocated (Total payment adjusted - Already allocated).

Image Added
Image Added

Date

The created payment date for the bank cost payment.

Image Added

Key

The payment key for the bank cost payment.

Image Added

Amount

The total amount for the bank cost payment.

Image Added

Transfer details

The transfer details/description for the bank cost payment.

Image Added

Content by Label
showLabelsfalse
max150
showSpacefalse
sorttitle
titleRelated pages:
excerptTypesimple
cqllabel = "

...

payments"