Questions? We have answers.

Xero: Accounts Payable Data

Article author
Tasha Kociszewski
  • Updated

Summary

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

Note: The following guide was created using the AUS edition of Xero; the same steps should apply to your local edition.

Export an end of period outstanding payables list from Xero

  1. Open the Accounting drop-down menu
  2. Select Reports.
    xero accounting menu open with reports highlighted

  3. Go to the Purchases section.
  4. Select Aged Payables Detail.xero summary screen with aged payables detail highlighted

  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.
    xero aged payables detail screen with previous list items checked

    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.
    xero accounting menu open with reports highlighted

  3. Go to the Accounting section.
  4. Select Account Transactions.
    xero reports menu with account transactions highlighted
  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.
    xero account transactions screen with items from previous list checked off

    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.
    xero contacts menu open with suppliers highlighted

  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.
    xero accounting menu open with reports highlighted

  3. Go to the Purchases section.
  4. Select Aged Payables Summary.xero summary screen with aged payables summary highlighted
  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.
    xero aged payables summary screen with previous list items checked

    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.
    xero accounting menu open with reports highlighted

  3. Go to the Purchases section.
  4. Select Aged Payables Detail.
    xero summary screen with aged payables detail highlighted

  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.
    xero aged payables detail screen with previous list items checked

    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?
Log in to MindBridge to chat with us, email support@mindbridge.ai, or reach out to your assigned Customer Success Manager.


Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.