A fresh look at Supplier Prepayments: Strengthening Business Partnerships

Our previous blog about Supplier Prepayments highlighted some of the benefits of supplier prepayments from a financial perspective. This approach offers several other significant benefits that can foster stronger relationships with suppliers and enhance overall business operations, as follows.

Secured Supply Chains

Supplier prepayments create a sense of security for both parties. Suppliers receive funds upfront, ensuring they can cover production costs, maintain inventory levels, and meet demand without financial constraints. In return, businesses can count on a steady and uninterrupted supply of goods or services, reducing the risk of production delays or disruptions.

Negotiating Leverage

Paying suppliers in advance can give your business greater negotiating power. Suppliers may be more willing to offer favorable terms, or prioritize your orders when they know they’ll receive payment in advance. This can lead to cost savings and improved profit margins for your business.

Reduced Credit Risk

Just as customer prepayments reduce the risk of late or defaulted payments, supplier prepayments mitigate the risk of suppliers experiencing financial difficulties or failing to deliver as promised. This helps maintain the integrity of your supply chain and prevents potential production delays caused by supplier issues.

Enhanced Supplier Relationships

Building solid relationships with suppliers is essential for long-term success. Supplier prepayments demonstrate trust and commitment to your suppliers, fostering goodwill and encouraging them to go the extra mile to meet your needs. These enhanced relationships can lead to better service, quality, and reliability.

Streamlined Procurement

Supplier prepayments can streamline your procurement process. With funds already allocated to suppliers, you can simplify your accounts payable, reduce administrative overhead, and allocate resources more efficiently. This lets your team focus on strategic activities rather than chasing invoices and managing payment schedules.

Discounts and Cost Savings

Many suppliers offer discounts for early payments or prepayments. By taking advantage of these discounts, your business can significantly reduce its procurement costs, ultimately contributing to improved profitability.

Inventory Management

Supplier prepayments can also improve inventory management. With the assurance of timely deliveries, you can optimize inventory levels, reduce carrying costs, and minimize the risk of overstocking or stockouts.

Strategic Growth Opportunities

Having funds readily available through advance payments allows your suppliers to seize growth opportunities. Whether investing in research and development, expanding product lines, or entering new markets, supplier prepayments provide the financial flexibility to fuel strategic growth.

Supplier prepayments are a valuable financial strategy that can strengthen your business’s relationships with suppliers, improve operational efficiency, and drive cost savings. By embracing this approach, you mitigate risks and gain a competitive edge in your industry. Learn more about how DataRapt’s Supplier Prepayments Software can add even more value to your SYSPRO ERP System.

Need additional DataRapt knowledge? We can help!

Part 1: My DataRapt

You have DataRapt installed and ready to go, but where can you find more information about the product?

The answer is easy. In the product!

There are a host of tools that can be used right from your DataRapt screens. Before we go any further, remember that there is a full, context sensitive help function available from every screen in all modules.

The reconciliations

Let us start with the DataRapt Reconciliations at a Glance. Here, you can see all ten of the reconciliation modules in summary form, providing Sub-ledger, General Ledger and Variance details. But, that’s not all…

You can see whether any variances are caused by unposted GL journals, when and how the reconciliation was last refreshed, and a breakdown by control account. You can be re-directed to the full reconciliation simply by selecting a hyperlink. Perhaps best of all, you can refresh the reconciliation right here.

From within the detailed reconciliations, you can check individual transactional variances and look at our What Next? ideas. These are an accumulation of our product knowledge base, and while not exhaustive, provide an idea of how the variance may have occurred, along with guidelines of how to fix it. You can even add your own reasons according to your individual knowledge base.

You are able to add notes to variances, launch SYSPRO programs to make corrections and move variances around the reconciliation. There is a write-up in the News section of our website, Streamlining DataRapt Reconciliations. To name but a few of these ideas, you are able to:

  • Sort variances by their unsigned values. A column has been added to each of the details panes which displays the variance value without the minus sign, allowing you to sort on the unsigned value making it easier to find contra entries.
  • Use the Work List tab. This tab allows you to do as you will with variances from other details tabs. Move variances for a single customer, or follow the catch-up depreciation of a fixed asset purchased with an earlier purchase date. Here are a few more ideas:
    • Create one consolidated reconciliation including all lines from all tabs. This can be exported to Excel to manipulate as you see fit.
    • Sort variances lines from multiple tabs to find possible contra variances.
    • Separate variances that require further attention. Or no further attention!
  • Use the extended toolbar. There is an extended toolbar in each of the details tabs that allows you to easily move data to and from contra groups and the ‘Work List’ tab. You can also view the ‘What Next?’ text, print, search and filter the data and apply various standard formatting functions.

A feature that I really enjoy is the multiple row select capability. As in any Windows applications, simply use the Shift or Control keys to select adjacent or separate rows, or select the whole lot with Ctrl-A. These can be added to a contra group, allowing you to move  on to another tab that holds variances to be included in the group.

Likewise, multiple rows can be added and removed from the Work List tab.

And, perhaps the most important ‘Need to Know’ of them all…

DataRapt’s reconciliation products do not update SYSPRO tables. We extract data from SYSPRO into our own tables and populate reconciliation screens, groups and statuses from this data.

In the case of Prepayments, the links between prepayments and purchase orders or registered invoices are also stored in the DataRapt tables.

This means that, at any time, you can query the data, especially if you have historical data that can no longer be viewed in the reconciliations.

What of Supplier Prepayments?

The Supplier Prepayments module is a good workhorse, and the online help tells its story. It is worth mentioning that the Prepayments Query provides an overview of the whole system, and acts as a sub-ledger for the control account balances.

There is a Reference Guide for each version of SYSPRO. These are available to download from our Support Site.

We have a blog, Why You Should Consider Paying Suppliers In Advance, which we think provides useful information about the benefits of supplier prepayments.

Last, but not least – The General Ledger Reconciliation

The General Ledger Reconciliation is a completely user driven product. Here, you are able to reconcile single or predefined sets of General Ledger accounts in one place. Many actions are available. To list but a few, you can:

    • Analyse the ledger transactions processed against the account or a set of accounts across a range of financial periods.
    • Assign a user-defined status to a ledger transaction – perhaps to verify it or flag it for further investigation.
    • You can apply SYSPRO’s ‘listview styles’ to user-defined statuses so that each status has its own distinct text colour, background colour and font for easy identification when you view the full reconciliation.
    • Categorize data by accumulating GL transactions into user-defined groups. Including contra groups.
    • Use eSignatures to ensure that unauthorised amendments cannot be made to your reconciliation.

 

Why You Should Consider Paying Suppliers In Advance

Accounts payable is one of those business functions that gets put on the back burner when businesses have a look at how they can improve their functions. Management usually have many other things that require urgent attention, so they leave accounts payable to other ‘qualified’ hands and assume it will be managed in the best way possible.

Capital optimisation should always be a priority for businesses and optimising payables is a great place to start. Many businesses, though, take the approach of extending payables for as long as they possibly can as they reason that this will maximise free cash flow. The problem with this approach is that in many cases delaying payment actually erodes good supplier relationships, which results in slower delivery times, less willingness to fix defects, slower responses to queries, and much stricter and less forgiving payment terms.

Not adopting effective accounts payable processes can have many other consequences on all areas of the business. Some of these consequences arise because of the following reasons:

  • Businesses rely too much on manual processes (where errors are much more prevalent) to approve requisitions, scan supplier invoices and issue payments.
  • Businesses miss out on great opportunities for early payment discounts by pushing payment cycles to the max.
  • Businesses neglect to take advantage of maximum savings through volume rebates or trade spend initiatives.
  • Businesses do not have processes and/or systems in place to prevent late payments, under- or over-payments, duplicate payments or missed payments.

One of the most well-known reasons for paying suppliers in advance is the fact that many suppliers offer discounts and rebates to those who do so. This alone can be a great bonus for businesses and can also be very beneficial to start-ups and small businesses who need the extra cash. Below are 4 more reasons why you should consider paying suppliers in advance:

  1. Paying in advance shows suppliers that you are comfortable with their company and their product and/or service. This strengthens the customer and supplier relationship which can only be beneficial for both parties (this is especially true with new suppliers where you have just started to build a relationship with them).
  2. It frees up time for the finance department as they do not have to keep track of all sorts of deadlines (this benefit is even more prevalent if you have an automated prepayment system in place, as discussed later). Missed payments will also be something of the past which will release some of the pressure on the finance department.
  3. Some suppliers add interest to your accounts payable if you pay them late. This can translate into a much bigger expense that could have been prevented by having prepayments in place.
  4. Should there be a month (or two) where you cannot pay your suppliers, they will most likely be more forgiving and more open to accommodate you, as they know that you have kept to payment terms in the past.

To take full advantage of the benefits listed above, different teams have to work together and collaborate with senior management to make sure a working capital culture is a top priority throughout the company. It is also about more than just making sure invoices are received and processed as quickly as possible, but about adopting a management focus that emphasises the importance of optimising payables and freeing up working capital to fuel growth.

Having a central accounts payable processing and reporting structure in place is the first step towards optimising payables. At the end of the day, such a system also has the added advantage of enabling businesses to accomplish more tasks in a faster timeframe and with much less resources, which ultimately will help in reducing enterprise costs.

pay suppliers in advance

DataRapt’s Supplier Prepayments system enables you to control prepayments to suppliers for goods and services. This system provides complete visibility of prepayments and related transactions, and can benefit any company that pays for goods and services upfront.

You can be prompted to capture a prepayment when a purchase order is created or after a supplier invoice is registered. Prepayments can also be posted manually with or without a link to a purchase order or registered invoice. When the supplier’s invoice is captured or the registered invoice is approved, you can be prompted to match their invoice to the prepayment on the fly.

DataRapt’s Supplier Prepayments system lets you have control over your prepayments by:

  1. Helping to identify your prepayment invoices with dedicated numbering.
  2. Letting you link your prepayment to the purchase order or registered invoice that initiated it.
  3. Helping you to make sure that you don’t overpay.
  4. Ensuring that you post the accounting transactions to the correct general ledger accounts.
  5. Providing the facility to ensure that the prepayment and supplier’s invoice are matched up.
  6. Providing a dedicated Prepayments Query.

Streamlined processes and a culture of working capital is all within reach by improving accounts payable processes, setting up management goals that are clear, and consistently tracking key metrics. Approached in the right way, corporate cost management can be strengthened, process complexity can be reduced, and risks associated with routine transaction processing can be minimised.

Sources:

Potential Prepayment Pitfalls (and how to avoid them)

pitfallsSYSPRO customers already know that it is now possible to handle supplier prepayments in SYSPRO. And if you have a small, manageable number of prepayments, you will no doubt be able to control the whole process manually, providing you have a reliable resource and time available. But there are potential pitfalls to be aware of that you can mitigate by implementing DataRapt’s Supplier Prepayments system. This is especially true if you have more complex requirements.

When handling prepayments manually:

  1. You will have to put in place a system to keep track of the prepayments you have processed.
  2. You will need to take care to ensure that the prepayment is posted to an appropriate prepayment control account.
  3. You will also need to make sure that when you receive an invoice from the supplier, that you match it up to the prepayment so that it isn’t paid twice by mistake.

 

DataRapt’s Supplier Prepayments system lets you have control over your prepayments by:

  1. Helping to identify your prepayment invoices with dedicated numbering.
  2. Letting you link your prepayment to the purchase order or registered invoice that initiated it.
  3. Helping you to make sure that you don’t overpay.
  4. Ensuring that you post the accounting transactions to the correct general ledger accounts.
  5. Providing the facility to ensure that the prepayment and supplier’s invoice are matched up.
  6. Providing a dedicated Prepayments Query.

 

The following table illustrates the functionality differences between the two systems:

Feature SYSPRO DataRapt
Record prepayment using dummy invoice ✔ ✔
Formatting options available for dummy invoice numbering for easy identification ✔
Optionally link the prepayment to a:
 – Purchase order ✔
 – Purchase order line ✔
 – Registered invoice ✔
Only process a prepayment when defined conditions are true [More info] ✔
Process payment as a:
 –  Manual check ✔ ✔
 – System check ✔
 – EFT payment ✔
Prepayment control account automatically assigned by:
 – Branch ✔
 – Currency ✔
Ensure the prepayment value does not exceed the net amount of the linked purchase order or registered invoice ✔
When capturing or approving the supplier’s invoice the product can prompt you to match it to prepayments ✔
If you have matched an invoice to a prepayment in error, you can unmatch it in one step ✔
Dedicated prepayments query [More info] ✔

Would you like to implement DataRapt’s Supplier Prepayments but are concerned about what will happen to any existing prepayments in your system? Well, DataRapt has a utility to transfer any of your existing negative balance invoices to the DataRapt Supplier Prepayments system.

To learn more about the system, please visit our product page or watch the video here:

Footnotes

 

[i] You can define triggers to prompt you to add a prepayment when adding a purchase order or registering an invoice.

At a basic level, the triggers will prompt you to add a prepayment every time you add a purchase order or register an invoice. But you can also define additional filters so that you are only prompted to add a prepayment when certain criteria are true. The filters that you can apply:

  • A list of suppliers
  • A list of supplier branches
  • A list of supplier currencies
  • A list of supplier classes
  • A list of invoice terms
  • A list of purchase order types

 

[ii] DataRapt provides a comprehensive prepayment query. This includes filters by financial period, branch, supplier and prepayment status.

Prepaymentsblog