USA Accounts Payable Best Practices for Processing Heavy Multiple Invoices & Cost Centers for 1 Vendor

Joined
Dec 18, 2018
Messages
7
Reaction score
0
Country
United States
Calling seasoned AP Pros! I am a General Ledger Accounting Contractor trying to help a client process higher-than normal invoices associated with Coronavirus supplies. One vendor has submitted dozens (50+) of supplies invoices billed at individual invoice # per cost center receiving the supplies. Hence, this is creating 2 problems:

(1) Tracking shipment of supplies - inventory controls: Some supplies were shipped to HQ for later dissemination to cost centers vs. others ordered by & shipped directly to cost centers. Currently, we cannot account for where-about of some of supplies ordered.
(2) Manual invoice input in AP module: 50+ small $ invoices to-date.

Currently, no PO is used by client but Accounting Mgr is open to starting process & accounting system can accommodate it. Do AP specialists have any strategies for reducing manual input while maintaining inventory controls?

Here are ideas that I came up with:
- Request a PO to track shipment delivery and consolidate orders.
- Request a YTD statement for all invoices due: Record in AP under 1 "master" invoice # and then allocate to cost centers via journal entry in GL. However, if Controller cannot approve all invoices, this may create review & approval issues in AP module due to multi-cost sites.
 

kirby

VIP Member
Joined
May 12, 2011
Messages
2,449
Reaction score
334
Country
United States
For your high invoice volume vendors, contact them and see if they can send you a data file with the invoice information that you can then take and load into your payables system. Maybe get this weekly and let them know what data you would need in the file.
 

Werner Reisacher

VIP Member
Joined
Jun 30, 2017
Messages
236
Reaction score
27
Country
Netherlands
I wish I had the talent of Kirby to summarize the essential in a few words. Therefore, please apologize for my lengthy input, but it might give you some ideas on how to create use as a model for your Consulting business.


What you describe is business as usual in most companies. Selling, ordering, and presenting the Financial Statements at meetings are considered intellectual decision-making processes. Technology stops when it comes to the handling all the papers necessary to compile this information in the first place. Account receivables and payables have to assume the manual “clean-up work” and it’s their job to figure it out.

EMERGENCY ACTION

To break through the present bottleneck, ask the Controller to set up a task force. A well-prepared conference call between the decision-makers and the people that handle the documents in their departments. Distribute spreadsheets with a list of pending issues (list of unapproved invoices, missing purchase orders, etc) Agree during the conference who is handling which list and give these individuals a few days to solve their problems. Keep the conference under tight control. Not the time to argue. From there on, handle the people that have been given a list of open items individually. Otherwise, you fall into the trap of “let’s decide when the next conference call will be”

ONGOING SOLUTION

The only way to help your customer, and to establish yourself in the process as an expert in the field of “integrated office processes” is the following. Your enemies are not the papers that float around. The fundamental problem is that purchasing, invoicing, cost centers, in your and the vendor's companies are operating under the control of managers/supervisors that act like king of little fiefdoms, defending their territories within the departmental silos. They all have different interests, pushing a purchase order through - if a stressful situation offers an opportunity - without having an approval, and delaying the handling of paperwork, in general, is part of their game to avoid transparency in the system. Chaos creates an umbrella under which they can hide their inefficiency and laziness.

First thing first. You need somebody who sees your problem, accepts it and has the necessary decision power to add the purchasing procedures into the company’s policy and procedure manual. This is not the time to argue with individuals. Establish the rules and within 1 month, you will see the end of the tunnel.

  • Allowing people to order anything without a purchase order that is approved by a person who has the legal competency to enter such a commitment is as negligent as keeping the cash register unlocked.
  • Ordering without a properly approved document is a serious violation of the company’s policy.
  • Remind the Controller, that the auditors would have a problem with that.
  • Purchase orders must be numbered in sequential orders.
  • The book with the original stays with the person that is responsible for the administration of the purchase order book/register.
  • The original which includes all information needed for the vendor, as well as your company’s accounting, is sent to the vendor as the legal document for the purchase. (buying/selling companies often have different product codes for each item. By having both product codes on the purchase order avoids research needed to match incoming invoices with the accounting code is eliminated.
  • One copy goes to the warehouse. (of course, all these transactions can be handled electronically. The main thing is that “all information needed to drive future processes is included in this one-time data input)
  • When the goods arrive, the warehouse checks the delivery document with the goods delivered and signs off.
  • They pass the approved documents (delivery document attached to the purchase order) back to the purchasing department.
  • Incoming invoices from vendors go to the person that handles the purchasing process. It is their duty to verify that the quantities, product numbers, and the purchased amount equal the amount on the invoice, obtain the approval for the payment of the invoices, and pass all three documents to the accounts payable department for payment.

  • That’s why it is of utmost importance that the mail department is putting a date stamp on every incoming document. This helps to avoid that person sitting on vendor invoices for a long time delay all subsequent processes. (all part of avoiding transparency)
  • Once the entire batch of papers is ready to be processed in the payable department, the process should be straight forward.
The interface with the vendor is another story.

  • In order to be effective as an accountant, you should always look for personal contact with the accountant of the companies you are dealing with. This applies to Accounts Receivable as well as Payable. They are talking the same language and have the same problem. Both are looking for optimal handling solutions that reduce their workload.

  • I prepared at the end of the month a spreadsheet with a list of all invoices that were received during the month. I always used a standard template for this. The list is broken down into the following sections:
  • - - Invoices received and approved
  • - Total of invoices that will be paid this month
  • – List of invoices in dispute
  • – Total of the balance of our account with you.
  • There must be an agreement that both Controller’s or somebody with the necessary experience and decision power is in charge to solve the problems that have led to the disputed invoices and there must be an agreement that if disputes cannot be settled on a departmental level, the issue will be submitted to the CFO/CEO’s to make a decision.
The biggest savings of this is
  • Avoids unnecessary timely reconciliations of the account balances now and in the future.
  • Reduces the reconciliation process of accounts payable tremendously since disputed invoices are dealt with separately within 10 days and included in the next monthly payment. By using a spreadsheet that identifies those disputes establishes a paper trail that avoids reconciliation problems.
  • If you use this approach in intercompany transactions, both companies agree on the monthly charge, the receivable, and the payable balances are netted and one check will settle both accounts.
  • If you have multiple subsidiaries involved, this is the base on which you can build a “cash pool”. The mother company is acting as the banker. Each company sends a list of its receivable balance to the mother’s company for collection on their behalf from the payable subsidiary. The cash pool nets the balances each company owns or has to pay against each other. I five companies are part of the pool; five checks will settle the balances between the entire group and it reduces the cash floating between banks.
Do not take everything I listed “literally”. Just take it as a general guideline and integrate those parts that apply to your particular situation

Good luck
 
Joined
Dec 18, 2018
Messages
7
Reaction score
0
Country
United States
These are great AP strategies and guidelines! :) I will present these to the Controller and Assistant Controller to determine the feasibility of implementing with our current system and staffing resources. The company does not have a large, dedicated A/P department and will therefore be grateful for the expertise.

In regard to Werner's first two internal control points, I agree that a PO would greatly mitigate some of the company's risks from higher-than average inventory costs associated with special event (Covid-19 supplies). The supplies were ordered quickly in response to health event but fortunately by only 1 personnel which helps increase some of the controls. The main challenge now appears to be tracking down supplies that were inconsistently shipped to either HQ first or directly to individual cost centers.

I contacted the vendor sales rep today and confirmed that the orders (nearly 100 to date) are consistently billed to headquarters and shipped to individual cost centers. It is unclear how some of the Cost Centers were allegedly getting a copy of the invoices unless they had electronic account access. Therefore, the Sales Rep agreed to have the Billing Rep contact me to explore the PO and weekly data file option. In the near-term, the Controller is hoping that the vendor can change the order process to bill and ship directly to cost centers. This should help mitigate at least some of the inventory tracking issues.
 

Werner Reisacher

VIP Member
Joined
Jun 30, 2017
Messages
236
Reaction score
27
Country
Netherlands
Annie, I suggest you ask the Sales Rep to put you into contact with the Controller of the vendor. Cut out the middlemen. Time is of the essence. The Sales rep got probably a commission, he is not interested in solving the issue. If you ended up in the process with too many products, it might be advisable that your client's CEO gets in touch with his counterpart at the vendor's site. At this moment, they might negotiate a deal that some of the stuff can go back. In exchange for an agreement to become a loyal customer or whatever it takes to fix the problem.
I sent you a private message, please open it by clicking on the "letter logo" on the top right corner of this site.
And don't' forget yourself - safety first!
 
Joined
Dec 18, 2018
Messages
7
Reaction score
0
Country
United States
Greetings, Werner!
I followed your suggestion and spoke directly with a Billing Senior Advisor last week. This was productive and resulted in a detailed account statement and data file showing our partially versus fully shipped status along with all locations receiving shipments. As you mentioned the risk of product returns, we were in fact informed one of the product lines is back-ordered and therefore being cancelled from our order but only at a discount to us. This is a new development that is causing even more headaches with confirming receipt status and total billed.

Also as feared, the order process expanded beyond the Controller's awareness as several other locations have placed orders now totaling 200 invoices. I thought we were nearly finished with the orders when it remained at 80 as of the prior week. However, we have now learned that the Finance System team was contacted by the original manager placing the orders to bill the other facilities directly instead of Corporate. This was after the Controller decided to have all invoices billed directly to head-quarters for better-tracking. Therefore, we are probably not very popular with the billing systems team, :) but they are being very accommodating thus far.

While I commend the company for trying to respond quickly to the Covid-19 health concerns, it definitely created an Accounts Payable challenge with tracking inventory shipments and processing for payment. However, with this improved data and a direct channel to the vendor representatives, we hope to get it sorted out and fully paid soon.

Many thanks again for your helpful guidance!
Annie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
11,631
Messages
27,576
Members
21,374
Latest member
Imtiyaz12

Latest Threads

Top