The Vendor Record is where the Vendor specific information for each Vendor resides in the system. Once you have opened a Vendor Record, the General Tab of the record will be displayed. In addition to the information found on the General tab, Vendor Additional Info, Vendor related Open Transactions, Vendor related All Transactions, Vendor related Contacts, and Vendor Locations are available to Users.
Click here to review the information about the '1099 Information' section of the 'Vendor Additional Info' Tab when entering or updating 1099 details.
To add a new Vendor, hover over the 'Vendor' tab in the top ribbon and click 'New Vendor'. A Vendor record will open in a new window.
To view an existing Vendor record, click 'Vendors' under 'Accounts Payable' in the 'Accounting' module. This will open a listing of Vendors to choose from.
The General tab is where the Vendor information and other Vendor settings can be managed.
1) Name - The Vendor Name is the only required field on a Vendor Record. Enter the Vendor Name as it will be displayed in Restaurant365
2) Number - Vendor Number is an open text field that can be populated with the Vendor Number, or any other value that could be used for sorting purposes
3) Primary Contact - Select, or Create a Primary Contact for this Vendor on this drop-down. Click here for more information on Creating Contacts
4) Contact Information - Enter the Contact Information for the Vendor in these fields. The Address information will be displayed on Printed Checks for mailing purposes
- Note: Ensure that the zip code does not include a four digit extension and that no special characters are used in the address fields (.,:;#@-*). When using R365 Payments, the payments will auto-fail if they contain either of these errors
5) Payment Terms - If the Vendor has specific Payment Terms, you can select them in this drop-down. Click here for more information on Payment Terms
6) Terms Discount Account - For Payment Terms that result in a discount, specify the GL Account where the discounts will post
7) Inactive checkbox - In the event that your organization drops a Vendor after recording transactions with that Vendor, you will not be able to Delete the Vendor Record. You can flag the Vendor as Inactive by checking this checkbox and the Vendor will no longer appear in any 'Select Vendor' drop-downs in the system
8) Comment - The Vendor Comment box is an open text field and can be used for any purpose. The values in this comment box will appear and be sortable on the Vendor List view in Restaurant365
9) Payment Hold - This checkbox will put this entire Vendor on hold from being paid.
- Note: Once this has been checked, the following will occur:
- Payment / Check Run - Any Invoices, even if they are due, will not be displayed until the hold has been removed
- Manual Payment - The Vendor will not appear in the Vendor listing in a manual payment
- Payment / Check Run - Any Invoices, even if they are due, will not be displayed until the hold has been removed
Vendor Additional Info Tab
On the 'Vendor Additional Info' tab, Users can enter in Payment, 1099, and ACH related information for the Vendor.
1) Check Name - The Vendor Name as it will appear when printed on a Check from within Restaurant365. This will be auto-populated based on the name written in the 'General' tab
- Note: If a User wants to change the name of this Vendor after it was previously created and Saved, a Warning will pop-up and ask if the Vendor Name should match the Payment Name, as shown in the image below
- Yes - Update the Payment Name - This option will update the Vendor Name for you, but it will not update the 1099 Vendor Name, as noted in the 'Note' at the bottom of this window. If this name also needs to be changed, this will have to be manually updated
- Cancel - This option will only update the name of the Vendor
2) Entry - Two choices will be available in this drop-down. If entering invoices for this Vendor by GL Accounts, select ‘By Account’. If entering invoices for this Vendor by Item, select ‘By Item’. The majority of Vendors will be invoiced by Account while Food & Beverage Vendors will likely be invoiced by Item. This option will change the Invoice Entry grid upon selecting the Vendor in the Select Vendor drop-down, as displayed below:
- By Account - Upon selecting a Vendor with Entry By Account, the Invoice grid will allow the User to select specific GL Accounts on the Invoice
- By Item - Upon selecting a Vendor with Entry By Item, the Invoice grid will allow the user to select the Vendor Items specific to the Vendor Selected, as well as all Purchased Items (non-specific Items in the System) on the Invoice
3) Default Check Memo - To have a specific Check Memo populate in the Check Memo field each time a payment is generated for this Vendor, enter that value here (i.e., Rent Payment)
- ACH - ACH represents ACH Push where a file containing ACH Stubs will be produced at the conclusion of the payment. ACH Push requires that the Vendor provides a Bank Account number, Routing Number, and Account Type so that ACH Stubs can be authored to the direct Bank Account of the Vendor. Most Users will not use ACH Push and are most likely using ACH Pull, where an Authorization has been granted to a Vendor to automatically withdrawal funds via ACH. If this is the case for your Vendor, choose the 'Auto-Direct Debit' option. No physical checks. Click here for more information on Setting up ACH Vendors
- Check - Allows the User to print a physical check to pay the Vendor
- Auto-Direct Debit - The Vendor automatically withdrawals payments from a Bank Account. This option works in conjunction with the Auto-pay feature
- Credit Card - The Vendor is paid via Credit Card. This option works in conjunction with the Auto-pay feature and does not allow physical checks
5) Entry Instructions - The detailed Entry Instructions for the Vendor that will appear during AP Invoice Entry (when saved on the Vendor record), as shown below:
6) Vendor Group - A listing of Vendor Groups for the Vendor. If a Vendor needs to be added, the User can create a Vendor via Quick-Add. On the Check Run, Invoices that are available to be paid can be filtered by Vendor Group
7) Bank Account Type - (Used only when Payment Type = ACH) - The type of Bank Account used for ACH processing for this Vendor
8) Bank Account Number - (Used only when Payment Type = ACH) - The Vendor's bank account number that payments will be sent to via ACH
9) Routing Number - (Used only when Payment Type = ACH) - The Vendor's routing number that payments will be sent to via ACH
10) Payment Per Invoice - Check this box if this Vendor needs a separate AP Payment record for each Payment created. On a Check Run, when multiple AP Invoices are paid for the same Vendor, a single AP Payment will be created that lists each AP Invoice. By Checking this box, a separate AP Payment and Check will be created for each Payment
11) Vendor Priority - The Priority Status assigned to this Vendor, which will in turn update the priority field on the AP Invoice. This can assist in identifying and prioritizing the payments on a check run that should be processed first so that cash flow is maximized. The Vendor Priority will also follow the Vendor on a duplicated or memorized transaction. This is an optional field that includes the following priority statuses:
12) Short Pay checkbox - This setting has specific uses for the restaurant industry and is used to control the way certain Vendors handle Credits and shortages on deliveries. A ‘Short Pay’ Vendor is one who only requires payment for goods and services actually delivered. This is likely most of your vendors.
- Smaller food suppliers, such as local produce suppliers, only expect to be paid for goods delivered. For example: if an order was placed for 7 Cases of Tomatoes and the delivery arrived with only 6 Cases of Tomatoes, the person receiving would mark the difference on the invoice given to them by the delivery person. A Short Pay vendors would expect payment for the 6 Cases of Tomatoes that had been delivered. The fact that the original invoice showed 7 Cases is irrelevant, as only 6 were delivered. Mark Short Pay as Yes for these vendors (Check the box).
- Larger food suppliers, such as Sysco, will require that you pay for what was ordered, not what was actually received. This creates the additional step for you to request a credit from them for anything not received. Restaurant365 makes this process easy, but the first step is setting up the vendor with the proper ‘Short Pay’ setting. For these vendors, be sure to mark Short Pay as ‘No’ (Leave the box unchecked). Click here for more information on Entering Invoices At Corporate
13) Default Expense Account - In specifying a Default Expense Account, when entering in Invoices for this Vendor, the Expense Account field will populate with this Account upon selecting the Vendor. The value is not locked and can be changed as needed on the Invoice Screen
14) Use Tax checkbox - Checking this box marks this as a Use Tax Vendor. This doesn't change how AP transactions process, but it can be referenced on some reports such as Purchases by Vendor or in Business Analytics (Ad Hoc Reports) to see totals for Use Tax Vendors only
15) Items Available on Invoice - For Vendors that have Vendor Items in Restaurant365, the Items available to select when entering Invoices for the vendor can be determined using this field. The options include the following:
- All Items - All Purchased Items, as well as Vendor Items specific to the Vendor would populate the Item list on the AP/AR invoice screen. This is the default setting for all Vendors
- Vendor Items Only - Only Vendor Items for the Vendor would populate the Item list on the AP/AR invoice screen. This would limit the selectable items to only the Vendor Items of the selected Vendor
16) Available To Managers – If checked, Restaurant Managers will be able to create transactions for this Vendor. If unchecked, Restaurant Mangers will not be able to create transactions for this Vendor, but will be able to see transactions involving this Vendor in their ‘AP Transactions’ list
17) PO File Format - The file format that Purchase Orders will be exported in for this Vendor. Options include:
18) Fintech Integration Credit Processing - If a Customer of Fintech, this selection enables the User to select how R365 will process refunds from Fintech. There are two options to choose from:
- Credit - Create a Credit Memo - This will create a Credit Memo to document this refund. This is the default option
- Refund - Create Bank Entry- This will insert a line item called 'Fintech Refund' on the negative invoice and will have Undeposited Funds or a bank account assigned to it to record the refund. Once mapped, the GL Account can be updated
1099 Information Section
19) Company Name - This is the proper legal name of the company. This will be auto-populated based on the name written in the 'General' tab
20) 1099 Box - Specify how the Vendor is a 1099 Vendor by selecting the correct Payment Type. At Year-End you can run a report on your 1099 Vendors and Prepare/Print 1099 forms using Restaurant365 (blank 1099 forms can be purchased online or at local office suppliers). When this box is filled out, the Tax ID and Company Name will be required
- Note: Upon entering information in this box, a pop-up window will appear asking if you want to update prior invoices, as shown below. Click 'Yes' to update both Approved and Unapproved invoices without having to open previously closed periods
21) Tax ID - For each Vendor that is a 1099 Vendor, the Tax ID must be included on the Vendor Record. This Tax ID may be the EIN (Employer Identification Number), or the SSN (Social Security Number) of the Vendor / Individual
Open Transactions Tab
Any Open Transactions associated with the Vendor will appear in this list view. Transactions that are past due or within ten days of being due will be marked as 'Past Due' or 'Due Soon', respectively, next to the due date.
All Transactions Tab
All transactions associated with this Vendor will appear in this list.
Any Contacts associated with the Vendor will appear in this list.
By default Vendors are accessible to All Locations, but Vendors can be limited to specific Locations as well. This means that if a Vendor is limited to specific locations, then that Vendor will only be available for transactions of the specified Vendor Locations (where the selected transaction header Location is set as one of the Vendor's Locations). Vendor Location Numbers can also be added for each Location as needed. These Location Numbers are used for EDI Vendor Integrations
- On the Vendor form, click the Location tab (screenshot above).
- By default the 'Available/Same All Locations' checkbox will be checked and the Location table will be hidden (meaning that this Vendor can be accessed by all Locations).
- To assign specific locations, uncheck 'Available/Same All Locations' and the Location selector and grid will appear.
- Choose a Location you want this Vendor to be accessible to in the 'Select Location' lookup field and click 'Add' to add that Location to the Locations table.
- Add the Location Specific 'Email' (used for Purchase Orders) and 'Vendor Location Number' (used for EDI Vendor Integrations) as needed.
- Continue these steps until all desired Locations have been added.
- Note: Ensure that all Vendors (even Vendors that will not be used in Purchase Orders or EDI Vendor Integrations) that will use this Vendor for AP Invoices / AP Credit Memos are added to this table, otherwise they will not be able to use or select this vendor during invoice entry
- Save the Vendor record.
Some Vendors may have contracts or buying agreements. These and any other Vendor specific documents you wish to keep readily accessible can be added to the Vendor Record in Restaurant365. Do this by clicking on the ‘Upload File’ button found on each tab. Click here for more information on Uploading Files.