Summary

Learn how to export accounts payable data from Xero for use in MindBridge.

Export an end of period outstanding payables list from Xero

1. Open the Accounting drop-down menu
2. Select Reports.
   
   
   
3. Go to the Purchases section.
4. Select Aged Payables Detail.
   
   
5. Select Report Settings and adjust the following:
   • Date Range: Select the correct date range for your data analysis period.
   • Numbers: Select whether or not to Show decimals.
   • Layout: Open the menu and select Standard.
   • Columns: Select Contact, Due Date, Invoice Date, Invoice Reference and Total.
   
   
   

   For reference, the columns exported from Xero are mapped as follows:

   Xero export	MindBridge mapped columns for end of period outstanding payables list
   Contact	Vendor Name*
   Invoice Date	Effective Date*
   Due Date	Due Date
   Invoice Reference	Entry ID*
   Total	Amount*

   Items marked with an asterisk (*) are required.
   
   

6. Select Update and run the report.
   
   • Note: Ensure that all required columns are present according to Data checklist: Accounts payable.
7. Select Export.
8. Select Excel.
9. Open the Excel file and format the appropriate columns in line with Data checklist: Accounts payable.
10. Follow the steps outlined in Import a vendor list to import the file into MindBridge.
    
    

Export an AP detail file from Xero

1. Open the Accounting menu.
2. Select Reports.
   
   
   
3. Go to the Accounting section.
4. Select Account Transactions.
   
   
   
5. Select Report Settings and adjust the following:
   • Accounts: Choose the accounts payable account applicable.
   • Date Range: Select the correct date range for your data analysis period.
   • Numbers: Select whether or not to Show decimals.
   • Layout: Open the menu and select Standard.
   • Columns: Select Account Code, Credit, Debit, Description, Reference and Source.
   
   
   

   For reference, the columns exported from Xero are mapped as follows:

   Xero export	MindBridge mapped columns for AP detail
   Date	Effective Date*
   Source	Entry Type*
   Description	Vendor Name*
   Reference	Entry ID*
   Debit	Debit*
   Credit	Credit*
   Account Code	Account ID

   Columns marked with an asterisk (*) are required.
   
   

6. Select Update and run the report.

   • Note: Ensure that all required columns are present according to Data checklist: Accounts payable.

7. Select Export.

8. Select Excel.

9. Open the Excel file and format the appropriate columns in line with Data checklist: Accounts payable.

10. Import the file into MindBridge.
    
    

Export a vendor list from Xero

1. Open the Contacts menu.
2. Select Suppliers.
   
   
   
3. Select Export to export the .csv file.
4. Follow the steps outlined in Import a vendor list to import the file into MindBridge.
   
   

Export the vendor opening balances

1. Open the Accounting menu.
2. Select Reports.
   
   
   
3. Go to the Purchases section.
4. Select Aged Payables Summary.
   
   
5. Select Report Settings and adjust the following:
   • Date Range: Select the correct date range for your data analysis period.
   • Numbers: Select whether or not to Show decimals.
   • Layout: Open the menus and select Group By and Document Type, respectively.
   • Columns: Select Contact and Total.
   
   
   

   For reference, the columns exported from Xero are mapped to the following:

   Xero Export	MindBridge mapped columns for end of period outstanding payables list
   Contact	Vendor Name*
   Total	Amount*

   Columns marked with an asterisk (*) are required.
   
   

6. Select Update and run the report.

   • Note: Ensure that all required columns are present according to Data checklist: Accounts payable.

7. Select Export.

8. Select Excel.

9. Open the Excel file and format the appropriate columns in line with Data checklist: Accounts payable.

10. Follow the steps outlined in Import a vendor list to import the file into MindBridge.
    
    

Export a start of period outstanding payables list

1. Open the Accounting menu.
2. Select Reports.
   
   
   
3. Go to the Purchases section.
4. Select Aged Payables Detail.
   
   
   
5. Select Report Settings and adjust the following:
   • Date Range: Select the correct date range for your data analysis period.
   • Numbers: Select whether or not to Show decimals.
   • Layout: Open the menu and select Standard.
   • Columns: Select Contact, Due Date, Invoice Date, Invoice Reference and Total.
   
   
   

   For reference, the columns exported from Xero are mapped to the following:

   Xero Export	MindBridge mapped columns for start of period outstanding payables list
   Contact	Vendor Name*
   Invoice Date	Effective Date*
   Due Date	Due Date
   Invoice Reference	Entry ID*
   Total	Amount*

   Columns marked with an asterisk (*) are required.
   
   

6. Select Update and run the report.

   • Note: Ensure that all required columns are present according to Data checklist: Accounts payable.

7. Select Export.

8. Select Excel.

9. Open the Excel file and format the appropriate columns in line with Data checklist: Accounts payable.

10. Follow the steps outlined in Import a vendor list to import the file into MindBridge.
    
    

Anything else on your mind? Chat with us or submit a request for further assistance.

Related articles

• Analyses available in MindBridge