Import vendors from a spreadsheet | Pixie CRM Help Centre Canonical: https://pixiecrm.com/help-centre/import-vendors Publisher: Pixie Technologies LLC Accounting & Bookkeeping · How-to guide Import vendors from a spreadsheet Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on. Load multiple suppliers using the module's sample workbook and correct rejected rows safely. Audience: Accounts payable administrators; Feature: Vendor import; Module v1.4.5; Where to goAccounting → Vendors (https://pixiecrm.com/help-centre/topic/vendor) → Import Before you startThis guide follows Accounting and Bookkeeping module version 1.4.5. The required access is Accounting Vendor (https://pixiecrm.com/help-centre/topic/vendor): Create. A related screen can remain hidden when an optional module is inactive, a source record is in an ineligible status, the selected account is inactive or the user is not an assigned approver (https://pixiecrm.com/help-centre/topic/approval). What you’ll accomplish Load multiple suppliers (https://pixiecrm.com/help-centre/topic/vendor) using the module's sample workbook and correct rejected rows safely. It forms part of Pixie CRM Enterprise CRM's Accounting & Bookkeeping module and uses the module's permission-aware controller, status and mapping (https://pixiecrm.com/help-centre/topic/mapping) flow rather than a generic spreadsheet process. How it works The module includes vendor (https://pixiecrm.com/help-centre/topic/vendor) sample files, import screen and processing actions and removes old temporary error files. A technically successful import still requires business review for duplicate suppliers (https://pixiecrm.com/help-centre/topic/vendor), naming consistency and payment (https://pixiecrm.com/help-centre/topic/payment) method. Use vendor (https://pixiecrm.com/help-centre/topic/vendor) bulk actions only after the import has been checked. Follow these steps - Download the sample vendor (https://pixiecrm.com/help-centre/topic/vendor) import workbook. - Prepare a small test file. - Keep headers and formats unchanged. - Upload and run the import. - Check success and error counts. - Correct rejected rows without re-importing successful vendors (https://pixiecrm.com/help-centre/topic/vendor). - Search and open imported vendor (https://pixiecrm.com/help-centre/topic/vendor) profiles. Settings to check Sample workbookDefines accepted vendor (https://pixiecrm.com/help-centre/topic/vendor) columns. Vendor (https://pixiecrm.com/help-centre/topic/vendor) codeMust be unique. Name and contactRequired and optional fields follow import validation. AddressesKeep country and regional values in accepted formats. Error fileContains rows that failed validation. Partial successRequires a clean follow-up file containing only failed rows. Check it worked After the action is saved, Pixie CRM keeps the Accounting record connected to its source and updates the visible status or ledger data supported by this workflow. Review the saved result rather than relying only on a success message. Where the action posts accounting data, total debits and credits (https://pixiecrm.com/help-centre/topic/double-entry) must balance and the accounts must match the approved mapping (https://pixiecrm.com/help-centre/topic/mapping) or manual selection. - Open the saved record and confirm its final status. - Review the source reference and every debit and credit (https://pixiecrm.com/help-centre/topic/double-entry) line where ledger data was created. - Use the relevant register, ageing, reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) or report (https://pixiecrm.com/help-centre/topic/report) to verify the wider effect. Common mistakes to avoid - Do not import duplicate vendor (https://pixiecrm.com/help-centre/topic/vendor) codes. - Do not include unnecessary sensitive bank data. - Check (https://pixiecrm.com/help-centre/topic/check) country and address formats. - Verify payment (https://pixiecrm.com/help-centre/topic/payment) instructions independently. - Use the least destructive correction available and record the reason for material changes. - Do not bypass a permission, approval (https://pixiecrm.com/help-centre/topic/approval) or closed-period control by changing unrelated data. Accounting and data safetyDeletion, reset, void, refund, mapping (https://pixiecrm.com/help-centre/topic/mapping), journal and reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) actions can change financial history. Use approved access, retain supporting evidence and validate the result in the General Ledger or relevant control report (https://pixiecrm.com/help-centre/topic/report). Browse connected topics:payment (https://pixiecrm.com/help-centre/topic/payment)reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation)supplier bill (https://pixiecrm.com/help-centre/topic/bill)vendor (https://pixiecrm.com/help-centre/topic/vendor)check (https://pixiecrm.com/help-centre/topic/check)report (https://pixiecrm.com/help-centre/topic/report)approval (https://pixiecrm.com/help-centre/topic/approval)mapping (https://pixiecrm.com/help-centre/topic/mapping)double-entry (https://pixiecrm.com/help-centre/topic/double-entry) Related guides Vendor management overview (https://pixiecrm.com/help-centre/vendor-management-overview)Create and edit a vendor (https://pixiecrm.com/help-centre/create-and-edit-a-vendor)Use the vendor profile and transaction history (https://pixiecrm.com/help-centre/vendor-profile-and-history)Complete the Accounting setup checklist (https://pixiecrm.com/help-centre/complete-accounting-setup-checklist)Supplier bills overview (https://pixiecrm.com/help-centre/supplier-bills-overview)Create and edit a supplier bill (https://pixiecrm.com/help-centre/create-and-edit-a-supplier-bill)