Views:

The purpose of this article is to provide guidance on using SyncDirect in conjunction with PM and XPA. SyncDirect version 7.8.0.0 is a major release and incorporates some new features including:
  • Improved Collection Processes – Collection processes have been optimised. There have been improvements on the monthly collection process.
  • Writeback - The Writeback screen has been redesigned so that it is more user friendly and easier to use. The Mapping process has been changed to be quicker and more intuitive. Individual GST transactions are now included in the writeback process.
  • MYOB Essentials - The 400 transaction per period limit has been solved.
  • New Adapters – Introducing first iteration of the MYOB Essentials and CashManager. (Snapshots and Writeback are not yet supported)

Contents

 

What is SyncDirect

SyncDirect is a cloud-based technology which is integrated with the existing Advance suite of applications and will help streamline compliance and advisory processes.

Specifically, SyncDirect provides for collection of trial balance movement and/or journal transaction movement data from a client’s business accounting or cashbook application and makes that data available for many purposes, and in other systems (or end points), including the XPA client ledger within your practice.

SyncDirect enables Accountants and Advisors to:
  • Automate collecting client data monthly, quarterly, annual or custom date range.
  • Collect from multiple client systems across multiple locations - Desktop, Cloud, Local. • Snapshots include P&L, Bal Sheet, Aged Debtors/Creditors, Bank Reconciliation Rpt, Payroll Activity, GST Reconciliation, and GST Audit Rpt.
  • Support Tax Planning process – set periods to “completed” but be warned if anything changes in the source system.
  • Manage mapping data for use with multiple endpoints including XPA.
  • Writeback posted adjustments from XPA to a supported source Accounting System.
Businesses will always want choice when it comes to business accounting and cashbook software. The goal of having all of a firm’s clients on the same cloud accounting application and providing a “One Ledger” solution is a significant challenge. Instead, SyncDirect helps you implement “One Process” in your practice which can accommodate many applications your clients may be using now and into the future.

SyncDirect - One Process


Step 1 -  Collection

Client data can be collected by period directly from the client application into a secure cloud-based data warehouse.

Step 2 - Map

A mapping is required to “normalise” the data into a standard structure such as the client XPA file.

Step 3 - Import

Once the correct data period is selected, the data can then be imported into an appropriate end point such as their respective client XPA ledger.

Step 4 - Writeback Adjustments

Once adjustments have been prepared in XPA, these can be mapped and sent back into source Accounting System.

 

Supported Data Sources

Collection

SyncDirect is designed to support ‘one process’ for collecting data from clients regardless of which Business Accounting Software they use. SyncDirect supports collection of trial balance movement and transactional data movement from the following systems:

Desktop Systems

  • Reckon Accounts 2010-2019X (all versions)
  • MYOB AccountRight V19.X (all versions)
  • MYOB AccountRight 2015-19.X (Desktop)
  • Cash Manager Rural (no Snapshots or Writeback)
  • Cash Manager Focus (no Snapshots or Writeback)
  • Phoenix (no Snapshots or Writeback)

Cloud and Hybrid Systems

  • MYOB AccountRight Live 2019.X (Cloud has some limitations for snapshots)
  • MYOB Essentials (no Snapshots or Writeback)
  • Xero (has some limitations for snapshots)
  • Reckon One (no Snapshots or Writeback)
  • Intuit QuickBooks Online (no Snapshots or Writeback)

Other ERPs

  • Exported Excel/CSV files (both Trial Balance and Journal Transactions methods supported)
 

Writeback

SyncDirect supports the ability to post adjustments directly back in the source system via browse, cloud, or email data connection method. Note that the data feed collection method does not support Writeback in this version.

SyncDirect supports the Writeback of posted XPA data to the following systems:

Desktop Systems

  • Reckon Accounts 2010-2019X (all versions)
  • MYOB AccountRight V19.X (all versions)
  • MYOB AccountRight 2015-19.X (all versions)

Cloud and Hybrid Systems

  • MYOB AccountRight Live 2019.X
  • Xero
 

Connection Methods

There are four connection methods available to collect and Writeback client data that is held either locally by the Accountant, on the Clients’ desktop or in the Cloud.

These are:
  • Browse - Browse for a data file held on the local machine or local network.
  • Cloud  - Collect data from a system located in the cloud.
  • Data Feed - Setup a data feed from your client’s desktop software. (no Writeback)
  • Email - Request data from your client’s desktop software via an email request
 

Period Collections

  • All collections are now Period based, either monthly/quarterly/annual or a custom period. Each period feed imports to XPA independently.
  • Improved notification for what the system is doing during a collection against large data files.
  • Custom period collections (based on from and to month) are handy for those clients that are on-boarding mid-year.
  • Snapshots are period driven.
  • Support for Tax Planning processes. Where a specific period is imported to XPA and only that period is worked on, any previous period in the same financial year can be set to ‘completed’. SyncDirect is now capable of importing data for a selected period only (to XPA). Previous periods in the current financial year remain unchanged inside XPA (or not imported).
  • Ledger Log feature tracks what has changed in the source system. Shows altered, deleted, and new transactions (in the source instance), and any XPA adjustments (written back to the source). Helps to determine if there are changes occurring at the source system for a period that should be completed.
 

Selecting the appropriate Connection Method

The Connection method affects both the collection and write of data to and from the Source Accounting System. In determining which data connection method would be appropriate to use with a Client, three questions should be considered:

Where is the client source data located?

What is the frequency of updates required?


How comfortable is the client with direct access?

Activate a SyncDirect Client

   Important Note - Some of these steps may need to be undertaken by a System Administrator with appropriate JOE Admin access.

Step 1 - Enable Client Link to SyncDirect

1. Go to Central Console > Attributes > change the SyncDirect Client Attribute to “Yes”.
 

 

Step 2 - Activate the Client

1. Go to Xcede Professional Accounting> SyncDirect Console


 
  • The Client List View presented shows all clients identified as SyncDirect Clients in Central Console by default, if no filters are set. 
     
2. Select the appropriate client in the grid.
3. Click Action then select Activate License.
  • This will assign a SyncDirect License to the client and make SyncDirect functionality available for that client.


 
   Important Note - Multiple client licences can be activated at once by selecting multiple lines using the Shift or Control Key to highlight the appropriate lines in the list
  • Once the licence is activated and the console is refreshed, the Activated column will show the date the client was activated.
 

Accessing the SyncDirect Console

There are two ways to access SyncDirect:
  • Multiple Client List View - From the SyncDirect Console in the Client List View, double click the desired client.
    • This will launch back into a client specific view in the XPA Ledger Console.
  • Single Client View - From Central Console, use the filter to find the desired client, then Click SyncDirect in the XPA Ledgers band.
   Important Note - The Multiple Client List View also provides a data feed list view – this is a list of data feeds that have been fulfilled and is useful to see which client have and have not responded.
 

Step 1 - Collect the data

1. Go to Action > Collect

  • The Collection Wizard will now assist stepping through the connection setup process.



2. Select a collection method. Browse, Cloud, Data Feed or Email, depending on the location of the data source.

Browse Method

The Browse collection method is used to collect data from a data file when the file is located on either a local machine or network. It supports connectivity to desktop Accounting software versions only.

1. Select the Data Type – General Ledger Transactions or Trial Balance.
2. Select the Financial Year.
3. Select the Period – Each period will collect a full financial Year. The Period option breaks the collection up into the selected Period collections.
4. Select if you want Snapshots.
5. Choose if you want Historical Snapshot reports.
6. Choose if you want Divisions.



7. Click Continue.
8. Select the connection type: Reckon Accounts; MYOB AccountRight v19; MYOB AccountRight 2012+; Excel\Manual, CashManager or Phoenix.
9. Click Continue.

Depending on the connection type selection, different options will be presented, prompting for the required information to complete the connection.

Reckon Accounts (Desktop)

To establish a link to a Reckon Accounts file using the Browse method, a copy of the client’s data file must be available on the network, along with Reckon Accounts installed on the local machine.



After browsing to the file, the authority to allow the SyncDirect to access Reckon Accounts may be requested.



To setup access, the Reckon Accounts file must be open with the correct permissions applied for the first-time connection.
  • You will need to open the file in Reckon Accounts.
  • In Reckon Accounts, navigate to Edit >Preferences >Integrated Applications.
  • Check the ‘Yes, always; allow access even if QuickBooks is not running’ option.
  • Also check the ‘Allow the application to access personal bank account numbers, customer credit card information, and other personal data’ and then click Continue.

MYOB AccountRight V19

To establish the link, the MYOB Files’ Username and Password as well as the file access connection protocol (ODBC) is required. The correct version of MYOB must also be installed on the local machine.

  1. To select data file location, click Browse, navigate to the file location, highlight it and click OK.
  2. Enter the correct Username and Password to access the file then select Multiuser access and TCPIP protocol.
  3. Click Continue to establish the connection to the source file.

MYOB AccountRight 2012+ (Desktop)

To establish the link, the MYOB File Username and Password is required. The MYOB API settings will determine the network file location (if set correctly). The correct version of MYOB must also be installed on the local machine or network.



SyncDirect will look directly at the list of company files you have added to your MYOB Library. If the file you are looking for is not in the list, click the Refresh Companies button and check again. If the file is still missing, check the entry in the MYOB Library.

Excel\Manual

Transactions
Selecting the Excel\Manual option to import transactions presents the data entry screen below.



1. Click the Import from Excel button to browse for an Excel file and start the collection process.
2. Select the sheet within the workbook containing the data for import to load the data into SyncDirect.


 
Once the data has been loaded, the user needs to ‘profile’ the data, telling SyncDirect what data is in each column.

SyncDirect has pre-defined the data it requires for a successful import into XPA and populates these into the dropdown box.
3. Select each of these columns in sequence, map them to a column label in the imported spreadsheet data and click apply to confirm for each Column.



4. Once the data has been mapped, click Continue to return to the data collection screen.



These mappings can also be saved as templates for re-use by clicking the Save button.



5. The data collection screen now shows the collected data from the Excel spreadsheet. Click Complete to finish your data collection.


 
   Important Note - The ‘Complete’ button will only be enabled when all required fields are completed. Incomplete fields will be highlighted in yellow.

Trial Balance

Selecting the Excel\Manual collection method to collect trial balance data presents a similar data collection screen, adjusted to focus on Trial Balance data rather than journal transactions. The Import from Excel button functions similar to the transaction import method, however the process has been optimised for importing trial balance data rather than transactional data.

Both Dual column and single column formats are supported via the Import format type.



The data labels available for a trial balance also differ from transactional data imports.



Once the data in the spreadsheet has been mapped, it is imported to the data entry screen. If the data is valid, the Complete button will store the data in the cloud.


 
   Important Note - The ‘Complete’ button will only be enabled when all required fields are completed.

Phoenix

Selecting the Phoenix option will give you the file selection screen.



Browse to the correct file and select it.
Then click continue.

CashManager

Selecting the CashManager option will give you the file selection screen. Depending on what version of CashManager you are using will determine which file option you select.

CashManager Rural

You will need to export the APS export file AND the XLON2 export file and save them to your computer before doing the collection.

1. Click on the CashManager Rural Option.



2. Click Browse and select the APS export file you created.
3. Click Browse and select the XLON2 export file you created.
4. Click Continue to complete the collection process.

CashManager Focus

You will need to export the APS export file and save them to your computer before doing the collection.

1. Click on the CashManager Focus Option.



2. Click Browse and select the APS export file you created.
3. Click Continue to complete the collection process.

Cloud Method

The Cloud collection method is used to collect data on demand from supported cloud accounting data sources directly (using their APIs).

1. Select the Data Type – General Ledger Transactions or Trial Balance.
2. Select the Financial Year.
3. Select the Period – Each period will collect a full financial Year. The Period option breaks the collection up into the selected Period collections.
4. Select if you want Snapshots.
5. Select if you want Historical Snapshot reports.
6. Select if you want Divisions.



7. Click Continue.
8. Select the connection type: QuickBooks Online, MYOB AccountRight 2012+, Xero, CashManager, MYOB Essentials or Reckon One.
9. Click Continue.

MYOB AccountRight Live 2019

To establish the link to MYOB in the cloud you will need 2 sets of login details:
  • The MYOB Cloud email and Password.
  • The MYOB file Username and Password
1. Tick Running in the Cloud.



2. Click the Authorise button to open the MYOB Sign in page. Enter the MYOB Cloud login details and click on Sign in.
3. From the Company File drop down box, select the relevant file. SyncDirect will look at the list of companies in your MYOB Library.
4. Enter the correct Username and Password to access the file. Click Continue to establish the connection to the source file. If the desired file is not in the list, then click the Refresh Companies button.
If there are connection issues, an error message indicating the source of the problem will be displayed.

MYOB Essentials

1. Click on the Authorise button. This will open the MYOB Sign In page.



2. Enter your MYOB Essentials login details.
3. The Unauthorised button will change to Authorised.
4. Select the Country the file comes from.



5. Then select the business file and click Continue to complete the collection.

Xero

To link to a Xero ledger, a Xero compatible web browser and a valid Username and Password will be required. As part of Xero’s connection protocols, an authorisation key generated by the Xero website will need to be entered to allow access to the data.
 
   Important Note - To collect Transactions with Snapshots your Xero Login will require Payroll with Administration rights.

There are 2 ways to do this:
  • Public Key (needs to be done every time you collect)
  • Private Key (only needs to be done once)
Public Key

This needs to be done every time you collect data but is easy to do.

1. Select Public in the Connection type box.



2. Click either With Payroll or Without Payroll depending on what file you are collecting from; the default internet browser will start a Xero web session. Enter your Xero Username and Password and click Login.



 
   Important Note - If your default browser is not supported by Xero, copy and paste the web address into a Xero supported browser.

3. Choose the correct organisation and then click Allow access for 30 mins.
4. The Authorisation Key will then be displayed in new screen. Click on Copy code or write down the code.



5. Enter the code into the Xero authorisation box in the SyncDirect Console and click Continue.
Note: Click on the  Icon to automatically paste the code in.
 


Private Key

1. Before you can use the Private Key, you need to setup and create the Private Key according to the Xero requirements. Instructions for this can be found on the Xero website at the link here.
 

2. Once you have installed OpenSSL and created your Certificate you need to locate the certificate file. public_privatekey.pfx This can usually be found at C:\OpenSSL-Win64\bin
3. Then rename the file to XeroCertificate.pfx and copy it to the Certificates folder in the ADV2000 folder. C:\Adv2000\Certificates
You can now create your Private Key in Xero. Go to the Xero Developer site using this link.
 
4. Click on the MyApps tab and login with your Xero login details.



5. Select Private Key, set an Application name for SyncDirect and then complete the rest of the form. Ensure that you select the CORRECT Organisation.
6. Click Browse and select the location of the XeroCertificate.pfx file in the location below and then click save. C:\Adv2000\Certificates



7. Once the Private Key has been created in Xero copy the Consumer Key to a txt file or straight into the Xero Collection process.



8. As you work through the collection process the third screen will ask for the collection type. Select Private and then paste the Private Key into the Consumer Key box.
 
 

9. Click Continue to complete the collection process. This also saves the Private Key for future use.
 
   Important Note - Please ensure you copy the correct Private Key from Xero to the matching client collection in SyncDirect.

Reckon One

1. To collect data from Reckon One select the Reckon One connection type and click Continue.



2. Then enter your Username and Password for the Reckon One Account and Click Authorise.



 
   Important Note - DO NOT enter your Customer ID number. You must user your Username and password.

3. Once your credentials have been Authorised your Books will be visible. Select the Book from the drop-down list that you wish to collect data from and click Continue.



Email Request

The Email collection method is used to collect data from a client’s accounting system on the client’s computer, with their complete timing and control on when the data is forwarded.

1. Select the Data Type. General Ledger Transactions or Trial Balance.
2. Select the Financial Year.
3. Select the Period. Each period will collect a full financial year. The Period option breaks the collection up into the selected Periods.
4. Select it you want Snapshots or not. Choose if you want Historical Snapshot reports.
5. Select if you want Divisions.



6. Click Continue. This will generate an email in your default email program. Send this email to your Client. Your Client can then click on the link in the email and follow the instructions to upload their data securely to you.
Where necessary due to security settings, click to Allow SyncDirect to access Outlook.



Data Feed

A Data Feed is a permanent connection between the SyncDirect Console and the client application which allows for daily data transfers to occur automatically. This method requires a small application to installed on the client’s system to act as the link between the client data and the SyncDirect Bureau. The application is secured by a username and password at the client end. For this to transmit the data from your client to the SyncDirect Bureau the Clients computer must be turned on and logged in at the time of transmission.

1. Select the Data Type.
2. Select the Financial Year.
3. Select the Period.
4. Set a Client Username and Password.
5. Select a start date for the collections.



6. Click the Welcome Email button. This will generate an email in your default email program. Send this email to your Client. Your Client can then click on the link in the email and follow the instructions to start the DataFeed process.



The appropriate information will populate into an email using the Firm’s Data Feed Template, ready to send to the client.

7. Review the email message, add any additional details. Send the email then Click, Continue.
The SyncDirect window will populate with the future data feed status lines when collections are successful.
 

 

Managing Multiple Clients

Within the SyncDirect Status Console there are two SyncDirect Status views available:
  • Client List view.
  • Data Feed Status view.
To access this information about all clients, open the SyncDirect Status Console by clicking the SyncDirect menu option under Xcede Professional Accounting on the Central Console Menu.



The Select either Client List or Data Feed List.

Client List View

At a glance, the Client List view shows if a client has been activated for use with SyncDirect. If there is an activated date present, it also lists their mapping status, which third party accounting system data was last collected from and the access method it used. Each column can be filtered, or the data can be grouped to obtain the desired view of this information.

Data Feed Status View

At a glance, the Data Feed Status’ page is designed to show the user the status of each data feed, when or if it has been requested for collection, whether the client data has been received and when it was last imported into XPA (if applicable).


The user can establish a view of Client Data status according to the following statuses:
  • Not Due – The data feed is not yet due for collection.
  • Due – The data feed is due of collection.
  • Collected – The data feed has been uploaded to the bureau and ready for processing.
  • Imported – The data has been imported into XPA.
  • Changed – A new instance of client source data is available in the bureau.
  • Out of Balance – The client source data does not balance.
  • Completed – The data will no longer be collected.
The screen is designed to assist users to manage the timeliness of collecting data from clients.



Support for Tax Planning processes. 

Where a specific period is imported to XPA and only that period is worked on, any previous finished period in the same financial year can be set to ‘completed’. SyncDirect is now capable of importing data for a selected period only (to XPA). Previous periods in the current financial year remain unchanged inside XPA (or not imported).
   Important Note - Each column in the grid can be filtered, sorted and grouped. Irrelevant columns can also be hidden by dragging them into the data area of the grid.

Individual Client

 In Central Console, use the filter to find the desired client, then click the XPA Ledgers band. Click on the SyncDirect link. As above, the user can establish a view of the Client Data status according to the various statuses.

Viewing Source Client Data

There are 2 ways to view the data that has been uploaded into SyncDirect:
  • Normal View
  • Snapshots View

Normal View

This displays the data in a spreadsheet format.

Once the data has been collected by SyncDirect it can be viewed by selecting the Period, clicking on Action > View

Snapshots

This displays the data in a report format. It has several different reports that are displayed. (This may vary depending on the source of the data.)

Once the data has been collected by SyncDirect it can be viewed by selecting the Period, clicking on Action>Open Snapshots.



If you select Excel, it will create an Excel workbook displaying each report in a different worksheet. You will be able to edit the data as needed in the Excel file.

If you select PDF, it will create a PDF file for viewing and printing. It will show a navigation bar down the left listing all the reports available. You can click on the report in the Navigation bar or scroll through the pages.

Divisions

This allows you to collect the Location/Branch/Job details for a transaction if it is available. This will vary depending on what is available from the source file. (Not Available from all Source Types.)
This will help you with mapping them to the appropriate Sub Accounts in XPA if you wish to.

Step 2 - Mapping to the XPA Chart

Once the client source data is available it needs to be matched to the Target XPA Ledger. This is performed by using the Edit Mappings button for the Client. SyncDirect is designed to automate the mapping process as much as possible by accessing the chart of accounts directly from the linked XPA ledger.

Mapping Process

The Mapping Screen is broken up into four main sections.





The Client Elements (Source file accounts) are mapped to Target Elements (XPA accounts).
  1. Select the account on the right-hand side (client side)
  2. Select the XPA account of the left that you want to match the account to.
You can select multiple Client accounts at the same time by using Shift or CTRL select option then select the XPA account on the left. This will map multiple Client accounts to 1 XPA account.


Hiding unused elements

By checking Hide unused elements the Client Elements list is filtered to only show Chart of Account items in the client source data that contain values.

Displaying Unmapped Elements Only

By checking Show unmapped items only only elements that have not been mapped are displayed.

Displaying expected Target Elements only

By highlighting a Client Element item, then checking Show expected target items only the Target Element list reduces to show only suggested items from the XPA chart.

Using Show Predicted Mapping

Over time as mappings are established with the Practice, SyncDirect learns mappings based on all previous entries and the categories/subcategories applied. The predicted mapping code is displayed in Green. To accept the predicted mapping, double click the green arrow on the appropriate field.


 
   Important Note - For the predicted mapping function to be effective, enough historical mappings are required. A new bureau does not initially predicted mappings and it may take some time for accurate predictions to become available.


Using Show Codes

To assist with the mapping process, the Source Data codes can be shown or hidden depending on their value.

Filtering Columns

The contents of either the Client or Target Element lists can be filtered by entering relevant terms in the blank row at the top of either table.


Adding or updating the XPA Chart in SyncDirect

XPA chart refresh button improves support for XPA chart updates more quickly. Updates to the XPA COA can be added into XPA directly. This is done by opening the XPA ledger for the client and using the XPA ledger chart maintenance tools. Once the Chart has been updated, the COA changes can be quickly refreshed into SyncDirect by pressing the refresh button.


Other Mapping Functions

Export to Excel

This feature allows the user to export the mapping data to Excel. SyncDirect will launch Excel and the user will need to save the mapping data file.

Import from Excel

This feature allows for previously exported mappings to be imported and applied to the current client data set.

Import APS Mapping

This feature allows for mappings previously created using the Chart Mapping Toolbox in XPA to be used within the SyncDirect console.
 
   Important Note - If using integrated assets in XPA, remember to code all Fixed Asset transactions (i.e. asset additions and sales) to the Asset Suspense account, NOT the Fixed Asset accounts.

Delete Unmapped

This allows for deleting some or all the mapped Client Elements. A message box will appear to prompt for the relevant option.

Clear Current

Clears the mapping for the currently selected Client Elements.

Step 3 - Import data into XPA Ledger

Once the Client data has been uploaded into SyncDirect, the target XPA Ledger selected and mappings completed, the data can be imported into the XPA file.
  1. Highlight the relevant data line, check the correct ledger is selected
  2. Go to Action menu
  3. Click Import.



At this stage, the data will be checked by the system, and then any alerts regarding the issues with mapping will be displayed, e.g. unmapped elements.

If any warnings are displayed, please review your mapping via the Edit Mapping option. Fix any issues with the mapping and try again.



If there are no issues with the mapping, SyncDirect will then write the data to the client XPA ledger. On completion of a successful import, a message will appear to indicate this accordingly.


 
4. Open the appropriate ledger in XPA and the data will have been imported into the ledger according to the mappings.
 

Step 4 - Writeback

Writeback supports the ability to take journal adjustments that are created in XPA, and write them back into the source accounting system, either locally, to the cloud or via an email. The process is as follows:

1. Create Adjustments inside XPA against XPA COA. (as you would normally)
2. Create Writeback feed for the correct period – SD will automatically peek into a linked XPA file to pick up posted XPA adjustments when a Writeback feed for a given period is created.



3. Set Writeback Mapping - SD will automatically default to the same mapping used for collection. You may change the mapped account by clicking on the Drop-Down box and selecting the account to mapped to.
Once mapping is complete, Click on the Verify All button to lock the mapping into place.
If you wish to change any of the individual account mappings untick the Verify box and change the mapping. Then Tick the Verify box to lock the change in.



4. Once the mapping is complete and you are happy with what you have set, Click on Send to transfer the transactions to the Source file.
 
   Important Note - You can use the Import/Export Mappings buttons to export a specific set of mappings to an Excel file and then Import those mappings into a different client.

Writeback Method – the SD Writeback method is designed to support integration with Cloud, Hybrid and Desktop based source accounting systems. The methods are capable of writing journal adjustments back via Cloud, Browse and Email methods. Writeback using the data feed method is not supported in this version.

Writeback Status

Writeback status is reflected in the Writeback data feed line and in the Ledger Log. The process for XPA Adjustments to be written back occurs as follows:
 
Status Description
New SyncDirect knows that some new adjustments exist in XPA, but they have not yet been mapped for Writeback.
Mapped New adjustments have been mapped and are ready to be written back.
Sent Adjustments that have been sent to the source system.
Received Adjustments that we can tell have been received by the source system (either by confirming during the Writeback process or another collection).
Failure Adjustments that have been sent but we are unable to confirm they made it into the source system.

All Writeback transactions are posted into the third-party source system (NOT draft).

Description Filters

SyncDirect supports the ability to filter different Asset Groups allowing a simplified process for writing back depreciation.
  1. Select the Asset Group checkbox.
  2. Select the Asset Group in the dropdown.
  3. Select mapping in grid feature.
  4. Assumption is that multi selected filtered asset group accounts will/can be mapped to a single Depreciation Exp Account - <full amount> in one hit.

Journal Adjustment Limitation affecting Writeback

Depending on the source system, there are limitations to which accounts can have manual journal adjustments. Similarly, Writeback connections are subject to same constraints. These accounts are either system generated or restricted accounts.
  • XERO - Xero does not support Writeback journals to accounts receivable, accounts payable, retained earnings and bank accounts. (there may be other system accounts)
  • MYOB AccountRight 2012+ does not support Writeback journal adjustments retained earnings/current year earnings accounts.
  • Reckon Accounts Desktop does not support Writeback journals to accounts receivable, accounts payable, current year earnings, retained earnings and bank accounts.
  • Inventory Quantity adjustment is not supported.
 

Ledger Log

The Ledger Log shows the status of Writeback adjustments sent to the source and if they have been successfully received. It will also show changes that have been made in the source file since the last collection was performed

1. Run your Collection and then Map and Import into XPA.
2. Run the same collection at a later point in time for the Ledger Log to appear. This can also be done to confirm that the WriteBack transactions have been received.

Other Functions

Status History

To review the history of a collection, highlight the relevant line and then from the Action Menu Click Status History.



This will then display the Data Feed History screen. It can also change the Status of a specific Period to lock it.

Changing the Status to Completed allows you to lock the period. Once a period has been locked it can not be imported into XPA and if you recollect that locked period it will not overwrite the collection.

This can be useful when using the Quarterly or Monthly collections as you can lock off 1 part of the year and still work on the rest of the year at the same time.
 
   Important Note - You can change the Status back to Pending if you need to do new work on a looked Period. Select the Period and Click Action>Status and change the status in the dropdown box. Then Click Apply.

Clear

The Clear option deletes any previously collected data from the Bureau. Click the Action button and then the Clear button. Once completed a message saying you were successful will be displayed.



This would normally only be done if you have collected from the wrong file or if requested by an ASP Support person.

Delete Data Feed

Highlight the relevant data line. Click the Action button then click the Delete Data Feed button. You will be prompted to confirm this action. On success a message is displayed, and the data feed line will disappear.


 
   Important Note - This can only be done after all collections for that period have been Cleared.