What is Multi-Vendor™?
The Solid Multi-Vendor™ feature for Solid Route Accounting™ for QuickBooks®, also referred to as ‘Third-Party Billing’, is an optional licensed feature which allows invoices created by a DSD company to be paid to a supplier, who will then in turn then reimburse the DSD company. For more information and licensing options, please contact Solid Client Services or call 1-888-667-3769 x2.
Although that billing cycle is generally well understood, how to correctly setup Multi-Vendors™ and how to assign Customer records to them tends to be a bit less clear.
This guide has been created to assist with the configuration of the QuickBooks® company file in order to use the Solid Route Accounting™ Multi-Vendor™ feature.
QuickBooks® Company File Setup
- Allows distribution companies to supply products under a different company name automatically generating a separate invoice for each Solid Multi-Vendor™ account. The system also provides:
- 3rd party inventory control;
- special invoice numbering and printing; accounts receivable (A/R) and payable (A/P) handling;
- specialized GL accounting.
- Several Solid Multi-Vendor™ accounts may be created in the system. We recommend you read over this guide before setting up your first account.
- The vendor account that corresponds with the items(s) that are managed under the Solid Multi-Vendor™ feature for this vendor.
- The customer account that corresponds with the Super Vendor account above.
- The items that are handled by the Solid Multi-Vendor™ feature for a particular Super Vendor.
Super Vendor (Supplier) Record Configuration
Note: In order to designate one or more vendors as a Super Vendor supplier, you need to add a custom field to the vendor record:
- Select the Vendor Center from the Navigation menu
- Add a new vendor or edit an existing vendor you want to designate as a Multi-Vendor™
- Click on the Additional Info tab
- Click on the Define Fields button
- Enter “MVCode” as the label of the custom field. Note the spelling and capitalization.
- Put a check mark on the Customer and Vendor columns
- Then click OK
Now assign this vendor a code that uniquely identifies this Multi-Vendor™ (Note: you can use a combination of characters and number, however no special characters, e.g. MV01)
Note: the vendor’s Billed From address is the address that will be used on the mobile invoice’s pay to field. If you need any special designation in the pay to field, then add it to the Billed From address.
- Next, remaining on the Additional Info tab in the “Categorization and Defaults” section set the Type field to “Super Vendor”. Note, you may need to add this type if this is the first time you have setup such an account.
- Select the Account Prefill tab, and fill each of the 3 pre-fill account options in this order:
- Accounts Payable (A/P).
- Purchases (Cost of Goods Sold) (COGS).
- Vendor Refunds (Sales).
Super Customer Record Configuration
Now that we have one or more Super Vendors defined, you need to define one or more Super Customer records to handle the account receivable and the sales transactions.
To assign your customer records to a Super Vendor, you must enter the MVCode in the custom field for your customers:
- Select Customer Center from the Navigator Menu.
- Add a new customer or edit an existing customer
Click on the Additional Info tab
Note: The user defined field of “MVCode” should already be present from the Super Vendor configuration
- Enter the uniquely identifying Super Vendor code. If this customer needs to associated with more than one Super Vendor, then separate the code with a comma, e.g. MV01,MV02 (Note: no spaces)
- Next, remaining on the Additional Info tab in the “Categorization and Defaults” section set the Type field to “Super Customer”. Note, you may need to add this type if this is the first time you have setup such an account.
Super Item (Inventory) Record Configuration
For the Solid Multi-Vendor™ feature to work correctly, the items supplied by a specific Super Vendor must have the “Preferred Supplier” field set to that specific Super Vendor. To do this:
- Click on [List] in the menu, and select [Item List]
- Add a new item or edit an existing item
- Ensure that the Multi-Vendor™ is listed in the “Preferred vendor” field.
- Accounting Optional: Please see the next topic, “Accounting Configuration and Management” for additional, recommended accounting treatment.
- Items for the Solid Multi-Vendor™ account group:
- Type: this should be “Inventory Part” if you wish to track inventory quantities for resell.
- Item Name/Number: give a clear, abbreviated part number. Optionally, make it a sub item of group if items from this particular Super Vendor.
- COGS Account: select the Purchases (Cost of Goods Sold) (COGS) account for this Solid Multi-Vendor™ account group. You either select an existing or you may add a new COGS account at this time.
- Inventory Site Info: if running a Multi-Warehouse type setup, please assign the inventory to the correct supply warehouse, and not to the mobile computer.
Accounting Setup & Operations
Note: This is an advanced accounting topic. You should have a strong understanding of accounting principles and read this carefully before beginning. You may also do a trial configuration by copying your QuickBooks® company file and then testing the work.
Note: There can be several ways to setup the Chart of Accounts (aka General Ledger) to achieve different approaches to viewing results. Shown below, is one approach that provides a comprehensive audit trail.
Chart of Accounts
For each Super Vendor, add the following accounts to QuickBooks’s Chart of Accounts. Please note that each added account should be shown as a sub account to the heading in the next 6 lines:
- Accounts Receivable account (A/R)
- Inventory Asset account
- Accounts Payable account (A/P)
- Revenue account (Sales)
- Vendor Refunds account (Sales) – needed only if this Vendor will be paying a commission on your sales
- Purchases (Cost of Goods Sold) (COGS)
Setup for each Super Vendor
As transactions are created in Solid Sales Pro™, the route sales person simply opens a transaction (customer order or invoice) in the usual fashion. They proceed to select whatever items are to be sold on this visit and without regard to separating items by Super Customer. When [Save] is selected, Solid Sales Pro™ does the separation automatically creating separate transactions, optionally assigning references to special invoice numbers, pay to super customer, and sold by your company as distributor.
Submission to QuickBooks®
As transactions are returned to the office and subsequently to QuickBooks®, a few changes are made:
- Solid Mobile Central™:
- The original invoice together with delivery customer designation and customer signature can be reviewed or reprinted just as it looked in the field.
- Solid Fusion™, when submitting the transaction to QuickBooks®, several key changes are made:
- Accounts Receivable – The customer is remarked to be the super customer account. This results in the transaction being recorded against the Super Customer.
- The accounts receivable statement becomes the summary document to begin the reconciliation of sales to the approved accounts of the Super Vendor.
- Delivery Customer – The transaction’s audit trail is maintained by inserting a line item in the first position of the transaction. This line item describes the delivery account.
Accounting Transactions for a Solid Multi-Vendor™ Account Group
Different types of transactions are required and both A/R and A/P may need to be affected, therefore we recommend the amounts be worked out ahead of time using a spreadsheet and then applied to QuickBooks®. As usual, a paper trail should be maintained in order to preserve your audit trail.
- Payments from a Super Vendor:
- After splitting the receipt outside of QuickBooks®, apply the correct amount to A/R to retire the appropriate amount.
- Commissions from a Super Vendor:
- Apply the commission portion to the appropriate Vendor Refunds account.
- Payments to a Super Vendor:
- Apply the amount to be paid to the Super Vendor account.
- Balancing Differences between the Super Vendor and Super Customer accounts:
- Ensure the account balances and amounts of payments balance.
Reports for Solid Multi-Vendor™
- Statement of Sales:
- Use the Customer Statement for the Super Customer.
- Reprint the transactions if necessary. As noted above, the first line item on each invoice represents the actual customer the product was delivered to.