Skip to main content

Search

Welcome to DCM Help Centre

Intergrations and Interoperability - Accounting Xero

  • Updated

DCM and Xero Setup, and Export from DCM to Xero.

IMPORTANT NOTE: Xero doesn't have the option of Backup and/or Restore. Be very careful when exporting from DCM and ensure you are double checking your workflow to ensure no errors in Xero. DCM Support will not be able to help you with a restore of data from Xero if errors occur. Possibly contact Xero for support but a warning, they do not have the Backup and/or Restore function available in their software.

Information regarding Public and private key cryptography and Guid's (Globally Unique Identifiers): What is a public key certificate? (techtarget.com), What is GUID? (techtarget.com).


DCM Client Setup in Xero

  1. Go to http://app.xero.com and log in with your Xero account details
  2. Select My Applications
  3. Click Add Application
  4. Select Private App 
  5. Under 'Application Name' type DCM
  6. Select the organisation/file you want DCM to link to
  7. Copy the public key below (IN BOLD), and paste to the field X509 Public Key Certificate OR upload the cer file provided by us
  8. Click Save
  9. Copy your Consumer Key on the right-hand side under OAuth Credentials (you may have to click 'Show' first), then select the text and copy
  10. In DCM ensure you have selected Xero as the Accounting Application in Utilities - Configure - Interfaces
  11. Then in Utilities - Entities - (Entity) - Locations - Accounting Link
  12. Paste the Consumer Key (which you copied in step 9) in the XERO Guid field
  13. Select 'Connect'
  14. Once connected, select the Undeposited Funds / Bank Account and the Prepayment Liability Account (you may have to add this account to XERO - log into my.xero.com.au)
  15. Select Apply
  16. Select Save

Setup Xero in DCM 

  • In DCM, go to Utilities - Configure and select Intergrations tab on the left side
  • Click on the Xero button and press Save then Close buttons

  • Under Utilities - Entities - Select the Entity by double clicking to open the form
  • Go to Locations (Active) tab - Select Locations to Edit (ensure you are on the correct provider location in this field)
  • Go to the Tabs underneath your chosen Location/Provider number (which will be for that Location/Provider number only) and click on the Accounting Link tab

  • You will see a pop-up form to enter your Xero credentials. If it does not appear, you may click on the Connect! button to launch the form

  • Once you have entered your credentials and if you have Multi-factor Authentication set up, you may need the authenticator app to login. You may download this on your mobile device you registered your account with

 

  • If you do not have access to your authenticator app, you may send the authentication code to your backup email address. You can do this by clicking on the 'Use another authentication method' link

  • Select backup email address and send code

  • Click on Send code

  • Select the organisation you have set up in your Xero account

  • Click on Allow access for 30 minutes
  • You are now connected. Please ensure you have Enable Export ticked

  • If you have more than one location for the entity you have selected, you may click on the Apply to all Locations button

  • Click the Save button to save

 

Export to Xero

It is recommended that you backup your accounting file before exporting data to it. Go to Utilities Backup Database (as you usually would) then you will be ready to Export once this is complete.

Variety of options to choose when exporting from DCM to Xero with further options to drill down on data to select. The most common export is through Regular Tasks - Export (export form). This form has a note at the top of the screen to remind you to backup prior to exporting data. The other way which allows you to drill down and select certain files in bulk is through Regular Tasks - Transactions - Find Transactions (explained further in options below). 

Transactions that DCM can export to Xero

  • All
  • IFC
  • Invoice
  • Invoices - Held
  • Prepayment
  • Receipt
  • Refund
  • Write Off

Export up to a certain date

  1. Go to Regular Tasks - Export - Select your entity or leave it as the default All. This will bring through all entities
  2. Select the date you wish to export up to
  3. Press Today button to start the export to Xero from DCM

Export date range only

  1. Go to Regular Tasks - Transactions - Find Transactions
  2. Select the Transaction Type All or one of the other choices if you want a specific type only
  3. Select the From Date and To Date and press the Search button. If you want all Transactions up until a certain date, untick the From Date box and it will pull everything prior to the date chosen
  4. Once data has loaded, you will notice a green tick in the ExportRequired row that means it has not been exported over and is required. Untick what you do not want to be exported
  5. Go to Regular Tasks - Export and follow the steps above, any data selected with the green tick in your Search Transactions view will then be exported

Export, selected transaction data only

  1. Go to Regular Tasks - Transactions - Find Transactions
  2. Select the Transaction Type, Entity or leave blank if you want all Entities included, and Date Range
  3. Select Search button
  4. Once data has loaded, drill down on the data by using the filter options, just under the heading of each column, click on the filter then type what you are looking for
  5. You will notice a green tick in the ExportRequired row that means it has not been exported over and is required. Untick what you do not want to be exported
  6. Right click on the top of the columns to click and drag and set your grid to your own needs, right click on the heading > column chooser to remove (click and drag) or add other headings
  7. Go to Regular Tasks - Export and follow the steps above, any data selected with the green tick in your Search Transactions view will then be exported

 

 

 


  

 
 
 
Powered by Zendesk