MYOB AccountRight Export

This module creates files that may be easily imported into MYOB AccountRightusing a standard import module.

ClosedGetting Started
Setup required before use Who Can Use It? Where Is It?

Settings

Prepare MYOB before sync

Administrator

System Administrator

Connect > MYOB Export

Tips:

Create Export files for - Job, Card and InvoiceMYOB AccountRight

ClosedComplete the following steps:
  1. Select Run.
  2. The preview window may appear.
  3. Save.
  4. Review the results screen for any warnings or records skipped.
  5. The text files have been created and are ready for import to MYOB AccountRight.
  6. Open MYOB AccountRight.
  7. Import Jobs. Refer information below. Review the MYOB results window. 
  8. Import Cards. Refer information below. Review the MYOB results window. 
  9. Import Sales. Refer information below. Review the MYOB results window. 

Click the Run button to start the batch process.

Preview a list of the records that will be exported

Opens the export directory where the files will be created

Set what data is to be exported and your MYOB AccountRight income code more... 

Reset an export file that can then be re-exported again

Preview window

The information will be processed and a summary window will appear displaying the records that will be exported.  A tab for contacts, invoices, credits and projects will display the records for export.  The uncheck option allows you to exclude certain records from the export.

Closed1 text file for each export option i.e. one file for Jobs, Cards and then Sales (including credits) will be generated. 

The files can be found in Synergy\Export - located on your Synergy file server.  Check Office Settings if you're not sure where that is. 

  1. Check against each record for any errors.
  2. Errors should be resolved before the export is saved.

Import Jobs to MYOB AccountRight

MYOB AccountRight checks the Synergytext file for new jobs and adds them to MYOB AccountRight.  This file would have been created if you've opted to send Projects to Jobs, Disciplines to Jobs or Cost Centre to Jobs.

ClosedComplete the following steps:
  1. Open MYOB AccountRight.
  2. Select File menu > Import Data > Jobs.  The following window will appear.  Ensure these same options have been selected:
  3. Click Continue > Browse to the Synergy directory on the server, open the Export folder.  Here will be a 100000000 MYOB Jobs.txt select this. NOTE the next time you create a batch from Synergy, the file will be named 100000001 MYOB Jobs.txt and so on.
  4. Select Open > An Import Data screen will appear displaying fields that can be matched from the Synergy text file and the MYOB AccountRight fields.
  5. Select Match All.
  6. Then Import.  The following message will prompt. Review the MYOB results window. 

Import Contact file to MYOB AccountRight

ClosedComplete the following steps:
  1. Open MYOB AccountRight.
  2. Select File menu > Import Data > Cards > Customer Cards.  The following screen will appear, ensure these settings are selected:

  3. Click Continue > Browse to the Synergy directory on the server, open the Export folder.  Here will be a 100000000 MYOB Cards.txt select this. NOTE the next time you create a batch from Synergy, the file will be named 100000001 MYOB Cards.txt and so on.
  4. Select Open > An Import Data screen will appear displaying fields that can be matched from the Synergy text file and the MYOB AccountRight fields.
  5. Select Match All.

  6. Then Import.  A message will appear stating the status of the import. If records are skipped or imported with warnings, review the MYOB results window.

Import Invoice file to MYOB

ClosedComplete the following steps:
  1. Open MYOB AccountRight.
  2. Select File menu > Import Data > Jobs.  The following window will appear.  Ensure these same options have been selected:

  3. Click Continue > Browse to the Synergy directory on the server, open the Export folder.  Here will be a 100000000 MYOB Sales.txt select this. NOTE the next time you create a batch from Synergy, the file will be named 100000001 MYOB Sales.txt and so on.
  4. Select Open > An Import Data screen will appear displaying fields that can be matched from the Synergy text file and the MYOB AccountRight fields.
  5. Select Match All.

  6. Then Import.
  7. A message will appear stating the status of the import. If errors occur, review the MYOB results window.

Cancelled or Credit Invoices

If an Invoice has been cancelled or credited in Synergy a record will also be created in the Export file.  When imported to MYOB AccountRight, the cancelled record will appear on the account as a credit transaction, which is required to negate the original Tax Invoice transaction.

To apply the creditClosed within MYOB AccountRight go to Sales Register > Settle Debits/Credits > select the credit and Apply to Sale

Invoice Write off

Changing the status of an invoice to Paid, when no payment or only part payment is made, indicates a bad Debt in Synergy this is called a Write off.  Bad Debts in Synergy will appear in the Accounting Interface File as a Negative Adjustment.  Once imported, you can open the Sale in MYOB AccountRight and modify the account code as necessary for Bad Debt write offs.

To apply the tax adjustment withinClosedMYOB AccountRight go to Sales Register Settle Debits/Credits select the credit and Apply to Sale

Reverse an Invoice Write off

If the balance has been written off in error, this action can be undone. This will also affect the information going across to MYOB AccountRight. Follow these steps to apply the credit reversal.  

ClosedUndo the credit in Synergy
  1. Go to the Invoices tab within a project.
  2. Select the screen filter and select All Invoices.
  3. Highlight the invoice number that was written off.
  4. Select Undo Write Off.
  5. Run the Sync to MYOB AccountRight.

Apply the credit reversal in MYOB AccountRight

The credit reversal can be found within MYOB AccountRight under Open Invoices - it will not appear under returns and credits. You may need to delete the Sales Journal for the original credit when it was applied to the outstanding invoice. Follow these steps.  

ClosedExample

Invoice 00000001 was raised for $5,600 and $5,000 was paid by the client. The client was not going to pay the $600 balance and a decision was made to write off the balance. The credit was applied to invoice 00000001 in MYOB AccountRight therefore making the balance $0. Now the client has paid the balance of $600, so we need to set the invoice balance to $600 so the payment can be applied. Creating a new invoice for $600 is not the way to go about it, as this would increase your income earned which is incorrect.     

  1. Drill into SJ000005 and delete the transaction that applied the credit to the invoice. This is the original credit applied to the invoice balance. 

SJ000005 represents the write off that was applied to the invoice balance

  1. The invoice balance will now be $600.
  2. What you'll be left with is 2 invoices - C0000001 ($600) and C0000002 $600. We want to apply Invoice C0000001 to invoice C0000002. 
  3. Open the Sales Register. Select Returns and Credits. 
  4. Highlight C0000001 and select Apply to Sale.
  5. Enter a date and apply the Credit Amount to C0000002. You will notice at this point the original invoice 00000001 is also outstanding and as it should be. 
  6. Payment can be made to Invoice 00000001.

Tip: If you've not yet applied the Write off credit to the original invoice in MYOB, then follow steps 5-7 only, as you don't need to delete the credit SJ. 

The above instructions will also apply when reversing a Credit.

Review errors

If errors occurred during the import routine i.e. 1 record skipped, or 1 record imported with warnings you MUST review these errors found in the MYOB AccountRight log located in the same folder as the MYOB AccountRight data file.  The file is called MYOBLog.txt (or MYOBPLog.txt for Premier).

Refer to the MYOB Export Log File topic for more information.

Want to learn more?

Looking for more help? Try reviewing the following topics: Concept Link IconView Topics

 

© 2019 Total Synergy Pty Ltd

 

 

Open topic with navigation