MYOB AccountRight
Export
This module creates files that may
be easily imported into MYOB AccountRightusing a standard import module.
Tips:
- Ensure the option at Sales
import - Duplicate Records is set to Add Them.
- Please
contact support before upgrading to a version of MYOB AccountRight
that does not appear in the list of available supported versions.
- The
file/s created are stored in the Synergy/Export
folder on the server.
- Always
backup MYOB AccountRight before importing the Export
files created by Synergy.
Create
Export files for -
Job, Card and InvoiceMYOB AccountRight
Complete the following steps:
- Select Run.
- The preview window may appear.
- Save.
- Review the results screen for any warnings or records skipped.
- The text files have been created and are ready for import to
MYOB AccountRight.
- Open MYOB AccountRight.
- Import Jobs. Refer information below.
Review the MYOB results window.
- Import Cards. Refer information below.
Review the MYOB results window.
- 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.
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.
Complete the following steps:
- Open
MYOB AccountRight.
- Select
File menu > Import Data > Jobs. The following window will appear.
Ensure these same options have been selected:
- 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.
- Select
Open > An Import Data screen will appear displaying
fields that can be matched from the Synergy text file and the MYOB AccountRight fields.
- Select
Match All.
- Then
Import. The following message will prompt. Review
the MYOB results window.
Import Contact
file to MYOB AccountRight
Complete the following steps:
- Open
MYOB AccountRight.
- Select
File menu > Import Data > Cards > Customer Cards. The following screen
will appear, ensure these settings are selected:
- 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.
- Select
Open > An Import Data screen will appear
displaying fields that can be matched from the Synergy text
file and the MYOB AccountRight
fields.
- Select
Match All.
- 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
Complete the following steps:
- Open
MYOB AccountRight.
- Select
File menu > Import Data > Jobs. The following window will
appear. Ensure these same options have been selected:
- 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.
- Select
Open > An Import Data screen will appear displaying
fields that can be matched from the Synergy text file and the MYOB AccountRight fields.
- Select
Match All.
- Then
Import.
- 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 credit
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 within
MYOB 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.
Undo the credit in Synergy
- Go
to the Invoices tab within a project.
- Select
the screen filter and select All Invoices.
- Highlight
the invoice number that was written off.
- Select
Undo Write Off.
- 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.
Example
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.
- 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
- The
invoice balance will now be $600.
- What
you'll be left with is 2 invoices - C0000001 ($600) and C0000002 $600.
We want to apply Invoice C0000001 to invoice C0000002.
- Open
the Sales Register. Select Returns and Credits.
- Highlight
C0000001 and select Apply to Sale.
- 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.
- 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:
View Topics
©
2019 Total Synergy Pty Ltd
Open topic with navigation