Master vendor file complete? Not without these items
The master file vendor is the most critical material AP has at its disposal. So it’s worth asking if your master vendor file has all the info it needs.
Sure, master vendor files need vital info like addresses, contact info, TINs (Tax Identification Numbers) and paid invoices, so everything AP staffers need is right there when they need it.
But these materials are guaranteed to save AP time — and headaches — should a vendor problem or question come up.
- Contract. When pricing errors or disputes occur, your written contract has the potential to clear up a problem before it even starts.
- Dates and terms of discounts. How long does your company have to take advantage of an early-pay discount? Does the discount only apply to certain purchases?
- Limits and restrictions. Making sure your firm has minimum/maximum purchase limits in place for vendors can prevent inaccurate or duplicate-payment info from leaving your AP department.
- G/L info. Including General Ledger numbers in master vendor files can help out come month-end close.
- Sale tax items. It’s a good idea to check if any purchases from the vendor are exempt and include related certificates. Also, there’s possible tax implications if your company ever moves items purchased across state lines or uses them in its facilities.
- AP Comments. Taking the time to let employees know if a certain vendor happens to make the same invoice mistakes over and over again can be very helpful down the line.
Free Training & Resources
Further Reading
An Excel database is perfect for organizing — and clearly seeing — financial data. A database includes a series of records in r...
Sales tax compliance is a demanding job for finance teams like yours. For example, comparing the number of tax rate changes across the U...
The conditional formatting tool in Excel allows users to apply many different formatting options to data. The benefit: sorting and recogniz...
Full disclosure: We never know for certain which topics will grab the attention of CFOs, controllers and other finance professionals. O...
The Financial Accounting Standards Board (FASB) is taking a scalpel to its still-in-the-works expense reporting standard. If and when the b...
Formulas are the backbone of Excel’s functionality, enabling you to perform calculations, analyze data, and create dynamic reports. Maste...