--- title: ACCOUNTS PAYABLE - Import Transactions description: How to Import transactions into Accounts Payable --- [![company logo](https://cs.geminilogic.com/hs-fs/hubfs/Gemini-Logic-Logo%20(1).png?height=120&name=Gemini-Logic-Logo%20(1).png)](https://www.geminilogic.com/) [User Manual](https://cs.geminilogic.com/en/migrated/manual) - [Go to Gemini Logic](https://www.geminilogic.com/) - [New Ticket](https://cs.geminilogic.com/en/migrated/manual/kb-tickets/new) - [Go to Customer Portal](https://cs.geminilogic.com/tickets-view) Spire User Manual - Accounts Payable - [Spire Systems - General Knowledge Base](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base) - [Tips and Tricks](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#tips-and-tricks) - [Spire Administration - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-general-ledger) - [Spire Administration - Sales](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-sales) - [Spire Administration - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-inventory) - [Analytics for Spire](https://cs.geminilogic.com/en/migrated/manual/analytics-for-spire) - [Spire User Manual - System Overview](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-system-overview) - [Spire User Manual - User Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-settings) - [Spire User Manual - Vendors](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-vendors) - [Spire User Manual - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory) - [Pricing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory#pricing) - [Spire User Manual - Price Matrix](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-price-matrix) - [Spire User Manual - Purchase Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-purchase-orders) - [Spire User Manual - Sales Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-sales-orders) - [Spire User Manual - Keyboard Shortcuts](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-keyboard-shortcuts) - [Spire User Manual - Company Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-company-settings) - [Spire User Manual - New Instal/Company Setup](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-new-instal-company-setup) - [Spire User Manual - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-general-ledger) - [Spire User Manual - Accounts Receivable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-receivable) - [Spire User Manual - Accounts Payable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-payable) - [Spire User Manual - Payroll](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-payroll) - [Spire User Manual - Production Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-production-manager) - [Spire User Manual - Service Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-service-manager) - [Spire User Manual - User Defined Fields](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-defined-fields) - [Spire User Manual - Job Costing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-job-costing) - [HubSpot](https://cs.geminilogic.com/en/migrated/manual/hubspot) - [Updates](https://cs.geminilogic.com/en/migrated/manual/hubspot#updates) - [Gemini Logic](https://cs.geminilogic.com/en/migrated/manual/gemini-logic) - [Shipping](https://cs.geminilogic.com/en/migrated/manual/shipping) - [Sales Taxes](https://cs.geminilogic.com/en/migrated/manual/sales-taxes) - [Spire User Manual](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual) - [Customers](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual#customers) [Back to home](https://cs.geminilogic.com/en/migrated/manual) 1. [User Manual](https://cs.geminilogic.com/en/migrated/manual) 2. Spire User Manual - Accounts Payable - [Spire Systems - General Knowledge Base](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base) - [Tips and Tricks](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#tips-and-tricks) - [Spire Administration - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-general-ledger) - [Spire Administration - Sales](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-sales) - [Spire Administration - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-inventory) - [Analytics for Spire](https://cs.geminilogic.com/en/migrated/manual/analytics-for-spire) - [Spire User Manual - System Overview](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-system-overview) - [Spire User Manual - User Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-settings) - [Spire User Manual - Vendors](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-vendors) - [Spire User Manual - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory) - [Pricing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory#pricing) - [Spire User Manual - Price Matrix](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-price-matrix) - [Spire User Manual - Purchase Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-purchase-orders) - [Spire User Manual - Sales Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-sales-orders) - [Spire User Manual - Keyboard Shortcuts](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-keyboard-shortcuts) - [Spire User Manual - Company Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-company-settings) - [Spire User Manual - New Instal/Company Setup](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-new-instal-company-setup) - [Spire User Manual - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-general-ledger) - [Spire User Manual - Accounts Receivable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-receivable) - [Spire User Manual - Accounts Payable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-payable) - [Spire User Manual - Payroll](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-payroll) - [Spire User Manual - Production Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-production-manager) - [Spire User Manual - Service Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-service-manager) - [Spire User Manual - User Defined Fields](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-defined-fields) - [Spire User Manual - Job Costing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-job-costing) - [HubSpot](https://cs.geminilogic.com/en/migrated/manual/hubspot) - [Updates](https://cs.geminilogic.com/en/migrated/manual/hubspot#updates) - [Gemini Logic](https://cs.geminilogic.com/en/migrated/manual/gemini-logic) - [Shipping](https://cs.geminilogic.com/en/migrated/manual/shipping) - [Sales Taxes](https://cs.geminilogic.com/en/migrated/manual/sales-taxes) - [Spire User Manual](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual) - [Customers](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual#customers) # ACCOUNTS PAYABLE - Import Transactions ## How to Import transactions into Accounts Payable ### ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Sep-01-2022-09-31-44-28-AM.png?width=29&name=image-png-Sep-01-2022-09-31-44-28-AM.png)  - **Access** - Tools > Import![ToolsMenuImport](https://cs.geminilogic.com/hs-fs/hubfs/ToolsMenuImport.png?width=171&height=139&name=ToolsMenuImport.png) - option to open a previously saved import configuration / mapping  ![ImportOpenConfig](https://cs.geminilogic.com/hs-fs/hubfs/ImportOpenConfig.png?width=21&height=20&name=ImportOpenConfig.png) or continue as follows: - select the .xlsx or .csv file location **Source** using the **Browse Files** if this is an unsaved Import or **Browse Folders** button if this is a previously saved Import![APTransImport](https://cs.geminilogic.com/hs-fs/hubfs/APTransImport.png?width=467&height=381&name=APTransImport.png) - accept or change **Date Format **if applicable - select the **Import Type** (data) you are importing - **Accounts Payable** - map fields: - select the field under **Import File** - ie: ‘Vendor No’ - select the corresponding field under **Spire Fields** - ie: ‘Vendor No’ - click the **Match** button - matched items will transfer down to lower section, where you can then select the field and **Unmatch** if desired - continue to **Match** all fields you want to import into Spire - determine whether your spreadsheet ![CheckBoxCheckedBlue](https://cs.geminilogic.com/hs-fs/hubfs/CheckBoxCheckedBlue.png?width=16&height=16&name=CheckBoxCheckedBlue.png) **Has Header Row** or not (see top) - option to select a **Destination** folder to move the successful imported file to - option to select a **Failure** folder to move the unsuccessfully imported file to - click on ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Sep-01-2022-09-32-55-98-AM.png?width=16&name=image-png-Sep-01-2022-09-32-55-98-AM.png) **Save config** / ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Sep-01-2022-09-33-03-11-AM.png?width=16&name=image-png-Sep-01-2022-09-33-03-11-AM.png) **Save config as** to save the Source, Import Type, Field Mapping, Destination and Failure folders into the current user’s documents folder - click on ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Sep-01-2022-09-33-12-41-AM.png?width=21&name=image-png-Sep-01-2022-09-33-12-41-AM.png) **Import** to finish and review the newly imported records in Spire   [![company logo](https://cs.geminilogic.com/hs-fs/hubfs/Gemini%20Logic%20-%20Black-1.png?height=120&name=Gemini%20Logic%20-%20Black-1.png)](https://www.geminilogic.com/) Gemini Logic - [![linkedin_social_link_icon_alt_text](https://static.hsstatic.net/TemplateAssets/static-1.329/img/hs_default_template_images/modules/Follow+Me+-+Email/linkedin_circle_color.png)](https://www.linkedin.com/company/2460588) - [![youtube_social_link_icon_alt_text](https://static.hsstatic.net/TemplateAssets/static-1.329/img/hs_default_template_images/modules/Follow+Me+-+Email/youtube_circle_color.png)](https://www.youtube.com/user/GeminiLogicInc/featured) - [![twitter_social_link_icon_alt_text](https://static.hsstatic.net/TemplateAssets/static-1.329/img/hs_default_template_images/modules/Follow+Me+-+Email/twitter_circle_color.png)](https://twitter.com/gemini_logic) - [Go to Gemini Logic](https://www.geminilogic.com/) - [New Ticket](https://cs.geminilogic.com/en/migrated/manual/kb-tickets/new) - [Go to Customer Portal](https://cs.geminilogic.com/tickets-view)