Supplier Batch Payments
  • 24 Oct 2024
  • 7 Minutes to read
  • Dark
    Light
  • PDF

Supplier Batch Payments

  • Dark
    Light
  • PDF

Article summary

Marlin Tyre and Mechanical Workshop Software's Supplier Batch Payments module enables users to pay off outstanding supplier invoices in batches, using EFT banking files.

The Supplier Batch Payments module can be accessed by selecting Daily Activity > Supplier Batch Payments from the menu bar.

image.png

Supplier Batch Payments function similarly to Supplier EFT Payments module.

However, it records payments to each supplier as a single, combined supplier payment, rather than multiple payments made against individual invoices, allowing for easier Bank Reconciliations.

The Supplier Batch Payments module also enables the quick generation of Remittance Advice documents, which can be printed and sent, or emailed directly to suppliers.

Marlin currently supports the following EFT banking file formats:

  • Australia ABA
  • Australia ABA with balancing line
  • Indonesia - Mandiri Bank
Supplier Batch Payment Permissions

Users also require a seperate set of permissions to View, Edit and Commit supplier batch payments, to those used for regular supplier payments.
image.png

Tip

The Batch supplier Payments module can be also used to quickly allocate invoices for multiple suppliers, even if an EFT file is not required.

Supplier EFT Set Up

Before using Supplier Batch payments or Supplier EFT Payments, EFT file formats need to be set up for relevant bank accounts and EFT Payment information needs to be entered for relevant suppliers.

The SupplierAccount.DefaultValue.eftFileFormat company setting also needs to be set, in order to match the format of supplier banking details with the EFT file format.

The Supplier EFT Payments Set Up procedure is covered in its own, separate inform guide.

Adding Batch Payments

Quick Ref
  • Select Daily Activity > Supplier Batch Payments.
  • Click Add.
  • Select the Bank Account and Due Date for the batch.
  • Review batch transactions (double click to edit/allocate).
  • Click Commit.
  • Save the EFT banking file (and then send it to the bank).
  • Re-open to generate/send remittance (tick checkbox + click Deliver).
  • Click Complete when finished.

Once the required accounts and suppliers have been set up, the batch payments can be added and their relevant EFT files generated using the Supplier Batch Payments module.

The module can be accessed by selecting Daily Activity > Supplier Batch Payments from the menu bar.

image.png

The Supplier Batch Payments module will open on the Search page, showing a list of Current batch payments.

To add a new batch payment, click on the Add action button at the top-right of the module window.

image.png

The Add Supplier Batch Payment window will open.

image.png

In the Payment section at the top, use the Bank Account picker to select the bank account that the payment will be made from:

Use the Branch picker to select which branch the payment is being made from, (e.g. Head Office, rather than an individual branch).

The Payment Date calendar picker will default to the current date, but can be used to set a future date on which the payment should be made.

Use the Due Date picker in the Transaction Selection section below to restrict the supplier invoices that should be included as part of the batch.

Any outstanding transactions that have a due date equal to or prior to the selected date will be included in the batch.

Once the settings have been selected, click on the Ok button to create the batch.

Note

Supplier payments that are part of draft batch payments will also appear as drafts in the Search list of the Supplier Payments module, but can only be edited from the batch. However, they can still be committed or cancelled.

Supplier Batch Payment Details

Daily Activity > Supplier Batch Payments > [Batch Payment]

Supplier batch payments will open on the Payment tab, showing a list of supplier payments that will be included in the batch payment.

image.png

The Payment Details section at the top shows the details of the batch payment, including the total Amount.

The Bank Account, Payment Date and Branch pickers can be edited here, if necessary.

The Supplier Payments list at the bottom shows the suppliers that will be included in the batch payment and the Total Amount to be paid to each supplier.

Editing and Allocating Supplier Batch Payments

Daily Activity > Supplier Batch Payments > [Batch Payment]

A breakdown of the transactions for each supplier can be viewed and edited by double-clicking on the supplier in the supplier payments list.

image.png

The regular supplier payment Allocations tab will open in a pop-up window, which can be used to adjust and allocate the payment, as usual.

Adjustments to the Payment Amount, Discount Granted and Tax amounts can also be adjusted for the supplier by editing the relevant textboxes at the top.

Note

Further details of individual supplier transactions can be viewed by double-clicking on them in the Allocations list.

Tip

The Batch Supplier Payments module can be used to quickly allocate to invoices for multiple suppliers, even if an EFT file is not required.

Removing Suppliers from Batch Payments

Daily Activity > Supplier Batch Payments > [Batch Payment]

To remove a supplier from a batch payment, double-click on them in the Supplier Payments list to open the Allocations pop-up and click on the Cancel button at the top-right of the pop-up window.

image.png

Warning

Once removed, suppliers cannot be added back to a batch payment, without cancelling the entire batch and creating a new batch.

Committing Supplier Batch Payments

Committing a supplier batch payment commits the payment records to the general ledger and generates the relevant EFT banking file, which then needs to be given to the bank, in order to process the payments.

Once all the supplier payments have been reviewed and are ready for payment, click on the Commit button to the top-right of the Supplier Batch Payments window.

If an EFT file format has been set for the selected bank account, you will be prompted to save the EFT file upon committing the batch.

Once a batch payment has been committed, remittance advice documents can be generated for the relevant suppliers, as required.

Once an EFT file has been received and processed by the bank and the required remittance documents have been sent to suppliers, the relevant batch can then be marked as complete.

Note

Once committed, the payments for each supplier can also be viewed and reversed using the regular Supplier Payments module, if necessary.

Generating EFT Banking Files

Daily Activity > Supplier Batch Payments > [Batch Payment]

Once all the supplier payments have been reviewed and are ready for payment, click on the Commit button to the top-right of the Supplier Batch Payments window.

image.png

Note

If Supplier Payment Approvals are being used, users who do not have permission to commit a batch payment will instead have the option to Submit the batch payment for approval, as usual.

Remember: Supplier Batch Payments and Supplier Payment modules have separate commit permissions.

If an EFT file format has been set for the selected bank account, you will prompted to generate an EFT file after clicking the commit button.

Use the pop-up window that opens to select where to save the EFT Extract file.

Once the EFT file is generated, the status of the batch payment will be updated from Draft to Pending Delivery.

Note

If required, the EFT extract can be generated again by opening a committed (Pending Delivery) batch payment and clicking the Generate Extract button at the top-right of the module window.

Tip

Completed batches can be viewed by changing the Supplier Batch payments Search list filter to All.

Supplier Remittance Advice

Daily Activity > Supplier Batch Payments > [Committed Batch Payment]

Once a supplier batch payment has been committed (and the EFT file uploaded to the bank), remittance advice can be generated as PDFs, to be printed and sent off, or emailed directly to the supplier.

Note

Remittance documents are sent/generated using the standard Document Delivery Sets settings for Remittance Advice. See the Supplier EFT Payments Set Up Inform guide for further information.

To generate and/or send supplier remittance advice, Open a Pending Delivery batch payment from the Search list.

The Delivery Method for each supplier is shown in the Supplier Payments list of the Pending Delivery batch payment window.

In the Supplier Payments list, tick the checkboxes for the suppliers you want to send remittance advice to.

To generate/send remittance advice for the selected suppliers, click on the Deliver button to the top-right of the module window.

Closing Supplier Batch Payments

Daily Activity > Supplier Batch Payments > [Committed Batch Payment]

Once the EFT file and all required remittance advice documents have been generated, batches can be closed by opening them and clicking on the Complete button to the top-right of the module window.

image.png

Cancelling Batch Payments

Daily Activity > Supplier Batch Payments > [Committed Batch Payment]

Draft batch payments can be cancelled by opening them and clicking on the Cancel button to the top-right of the module window.

image.png

Note

Only Draft batches can be cancelled, however, committed batch payments can still be reversed, as usual, using the regular Supplier Payments module.


Was this article helpful?