Supplier Statement Reconciliation
    • 11 Feb 2025
    • 9 Minutes to read
    • Dark
      Light

    Supplier Statement Reconciliation

    • Dark
      Light

    Article summary

    Marlin GTX enables users to compare and reconcile supplier statements with their recorded transactions, using the Supplier Statement Reconciliation module.

    The Supplier Statement Reconciliation module also enables users to:

    Once finalised, the statement can be recorded as paid from within the Reconciliation module itself, or by using the Payments module as usual.

    If enabled, reconciled statements for multiple suppliers can also be added to Bulk Supplier Payments and recorded simultaneously.

    To enable Supplier Statement Reconciliation, please contact the Megabus Support Team.

    Once enabled, the Supplier Statement Reconciliation module can be accessed by selecting Main > Data Entry > Supplier Statement Reconciliation.

    5D168CFF-441D-4700-83A6-1E09C121A0E2.png

    The module will open, showing a list of suppliers and their statement details.

    image.png

    Reconciling Supplier Statements

    Main > Data Entry > Supplier Statement Reconciliation

    Double-click on a supplier to open the worksheet screen, which can be used to reconcile their statement.

    image.png

    Note

    If the worksheet contains entries for a previous (finalised) reconciliation, click on the New Reconciliation button at the top of the module window.
    image.png

    In the section at the top, enter:

    • Statement Number
    • Latest Due Date
    • Salesperson
    • Statement Balances

    To begin the reconciliation:

    • Click on the Start button at the bottom-left.

    image.png

    Tip

    The supplier's contact information, purchase dates and account balances can be shown or hidden by clicking on the Maximise/Minimise Details button in the upper-right corner of the screen.

    The Unreconciled Transactions lists below will update, showing the supplier's outstanding transactions, up to the selected due date.

    image.png

    Compare the entries on the supplier's statement to those listed in the Unreconciled Transactions:

    • Check-off matching transactions by ticking the Approve checkboxes to their left.
    • Selected transactions will move to the Reconciled Transactions list on the right.
    • Note: Further transaction details can be viewed by double clicking on them, or by clicking on the Details button at the top of the Unreconciled Transactions list.

    The Reconciliation Total section at the bottom-right will be updated accordingly.

    image.png

    Note

    Whether checked transactions are transferred to the Reconciled Transactions list immediately or need to be moved manually can be controlled using the Move Transactions Immediately checkbox at the top of the Unreconciled Transactions list. This can be useful when comparing it to the list on a supplier's statement.

    image.png

    If the checkbox is not ticked, approved transactions can be moved over at the end, by clicking on the Blue Arrow buttons that appear between the lists (shown above).

    Tips
    • All of the unreconciled transactions can be checked-off at once, by clicking on the Select All button at the top of the Unreconciled Transactions list.

    • All of the reconciled transactions can also be unchecked at once by clicking on the Unselect All button at the top of the Reconciled Transactions list.

    • Transactions can also be filtered by various criteria, such dates and transaction type, by clicking on the Filter button at the top of the Unreconciled Transactions List.

    image.png

    Adding Transactions

    If the supplier's statement includes a transaction that is missing from the list of Unreconciled Transactions in GTX, then it needs to be added manually, as either a supplier invoice, credit note, or journal entry (using the relevant module).

    The transaction will then be added to the Unreconciled Transactions list, and can be checked-off as usual.

    Tip

    If the supplier reconciliation worksheet is already open and you don't see the transaction, click on the Refresh button at the top to refresh the list.

    image.png

    Previous Payments

    If there are transactions on the statement that have already been recorded as paid, these will not appear in the Unreconciled List and may affect the reconciliation total.

    Previous payments can be added to the reconciliation by click on the Edit Already Paid button, in the Reconciliation Total section at the bottom-right of the module window.

    image.png

    A pop-up window will open, showing a list of previously recorded Payments.

    image.png

    In the Payments pop-up:

    • Tick the checkboxes for any payments made toward the current statement
    • Checked-off payments will move to the Payments Made list on the right
    • To edit a payment amount: select it in the Payments Made list and click on the Edit button at the top.
    • Verify that the selected payments should be included in the statement total
    • Click OK (bottom-right)

    The reconciliation total will be updated accordingly.

    Searching Transactions

    Transactions can be searched for by reference number, date, or amount, using the Search fields at the bottom of the Unreconciled and Reconciled Transactions lists.

    image.png

    Transaction Filters

    The Unreconciled transactions lists can also be filtered, using fields like Date, Amount, Balance, Reference and Transaction Type, by clicking on the Filter button at the top.

    image.png

    Use the pop-up that opens to select and apply the desired filter options.

    F873D623-64FA-4F71-B0E3-125A39C8EEF8.png

    To remove a filter:

    • Re-open the filter window (filter icon)
    • click on the Clear button (bottom-right)
    • click Ok.

    image.png

    Approved Payment Amounts

    The Supplier Reconciliation module enables you to edit approved payment amounts for individual transactions.

    This can be useful when disputing a charge, or in other situations where you want to withhold a payment.

    To edit approved payment amounts:

    • Select the transaction in the Reconciled Transactions list
    • Click on the Edit Approved Amount button at the top

    image.png

    In the pop-up that opens:

    • Enter the New Approved Amount
    • Click Save

    image.png

    The new amount will be updated in the Approved column on the right.

    image.png

    Statement Attachments

    Electronic copies of the relevant statement or other supporting documents can be added to a reconciliation by clicking on the Attach button at the top of the module window.

    0677A81D-0ED1-4A7C-88B8-4269B9A0918D.png

    Reconciliation Notes

    Notes can be added to general reconciliations, as well as individual transactions.

    Once added, notes can be viewed again by clicking on the relevant Notes button, either at the top left of the module window, or the top of the relevant Transactions list (see below).

    General Notes

    General notes can be added to a reconciliation by clicking on the Notes button at the top-left of the reconciliation window.

    3226B55E-A91B-4109-A70F-6DEA0DC0CE7B.png

    The Statement notes pop-up window will open.

    56C9CB4A-E69E-4E41-98D5-64FCB75D6D12.png

    To add a new note:

    • Click on the Add button at the top
    • Enter the note in the textbox below
    • Click on the Save button at the top
    Note

    Existing notes can be deleted by selecting them in the pop-up and clicking on the Delete button at the top

    Tip

    Notes for previous reconciliations for the same supplier can be shown by ticking the Include Previous Statements checkbox at the top of the notes pop-up window.

    Transaction Notes

    Notes about individual transactions can also be added by selecting them (in either the Unreconciled or Reconciled Transactions lists) and clicking on the Notes button at the top of the relevant list.

    image.png

    Add the note using the same method for general notes (described above).

    Note

    The number of notes added to a transaction is shown in the Notes column of the relevant list, and can be viewed by clicking on the relevant Notes button again.
    image.png

    Tip: General notes can also be viewed from within the transaction notes window, using the Note Type drop-down at the top of the Notes pop-up.

    Tip

    Notes can also be viewed by clicking on the Maximise/Minimise Details button at the bottom right of the transaction list and clicking on the Notes tab at the top of the section that opens below.
    image.png

    Finalising Reconciliations

    When you're ready to finalise the reconciliation, click on the Finalise button at the top of the module window.

    image.png

    Note

    Make sure a Salesperson is selected in the section at the top, before finalising the statement.

    Statement Differences

    Statement reconciliations can be finalised with overpay or underpay amounts.

    image.png

    If there is a difference between the Statement Amount Due and Total approved payments (shown at the bottom-right), you will be asked to confirm whether you want to continue with the finalisation:

    • To cancel the finalisation and continue with the reconciliation, click No
    • To finalise the reconciliation as is, click Yes

    Cancelling Reconciliations

    Main > Data Entry > Supplier Statement Reconciliation

    Active and finalised supplier statement reconciliations can both be cancelled.

    To cancel a reconciliation, open the relevant supplier from the main suppliers list in the Supplier Statement Reconciliation module.

    The worksheet for the previous reconciliation will be shown, with its status set to either In Progress or Finalised.

    To cancel the reconciliation, click on the Cancel button at the top of the module window.

    image.png

    Note

    If another reconciliation is already in progress, it can be saved and returned to later by clicking on the Save button to the top-left.

    Recording Payments

    Main > Data Entry > Supplier Statement Reconciliation

    Once finalised, supplier statements can be recorded as paid from within the Reconciliation module.

    To record a supplier payment:

    • Re-open the supplier's reconciliation
    • Click on the Pay button at the top of the Finalised reconciliation window.
    • If prompted, enter your salesperson ID and password to continue

    image.png

    The Payment Details pop-up will open.

    image.png

    On the Payment Details screen:

    • Enter the payment method and amount.
    • Click OK.

    The reconciliation window will close and the supplier's status will update to Paid in the statement reconciliation list.

    Note

    When recording payments from the Supplier Statement Reconciliation module, the payment is recorded with the current date and GL period.

    Tip

    Reconciled allocation payments can be recorded with different dates and periods by adding them to the Payment Entry module, which can also be used to apply settlement discounts.

    Reconciled supplier allocations can also be added as part of Bulk Supplier Payments.

    Payment Entry

    If required, reconciliation allocations can also be added to and recorded using the Payments module (Main > Data Entry > Payments).

    This option can be used when you need to change the payment date or GL period, or apply a settlement discount when paying a supplier.

    Warning

    If a payment has already been recorded using the Reconciliation module, then it does not need to be recorded separately, using the Payments module.

    In the General section at the top of the Payments screen:

    • Select the Supplier
    • Update the Payment Date and GL period, if required
    • Enter your Salesperson ID

    image.png

    In the Line Details list below:

    • Click on the Add Allocation button at the top
    • Select Reconciled Transactions

    image.png

    The Allocation Confirmation screen will open, showing the details of the supplier's reconciliation.

    image.png

    this didn't actually open for me?

    Review the entries on each of the tabs, as required.

    To update the payment with the reconciliation information:

    • Click on the Allocate button (bottom right)

    The following information will be updated:

    • Amount Paid: added to payment header
    • Statement Date/Description: Added to Comment field
    • Payment Allocation Amounts: Updated in Line Details list

    Once ready, the payment can be finalised as usual, by clicking on the Finalise button at the top of the Payments window.

    Bulk Supplier Payments

    Main > Data Entry > Payments

    If you have reconciled the statements for multiple suppliers, you can use the Bulk Supplier Payments module to simultaneously record their payments.

    If enabled, Bulk Supplier Payments can be accessed by clicking on the Bulk Supplier Payments button on the left of the Payments module.

    image.png

    Click on the Add button at the top, to open the Select Supplier Transactions pop-up.

    image.png.

    In the Transaction Date section

    • Select the Due Date toggle
    • Tick the Only Reconciled Transactions check box, to the right
    • Enter the due date in the Up To field
    • Click Proceed (bottom-right)

    image.png

    Review and update the allocation and settlement discount amounts, as required.

    Once ready, the payment can be finalised as usual, by clicking on the Finalise button at the top of the Payments window.


    Was this article helpful?

    What's Next