The Retail Express Accounting Data Export transfers transaction information into MYOB using different journal types. Understanding where each transaction is recorded helps you review imported data and trace it back to the corresponding activity in Retail Express.
In this video we review the data that has been exported into MYOB through the Accounting Data Export method. This includes information on finding the source of journals within MYOB.
Chapters
Timestamp | Chapter |
|---|
00:02 | Overview |
00:17 | Reviewing General Journals |
00:48 | Understanding General Journal IDs |
01:12 | Reviewing Purchases and Bills |
01:46 | Understanding Purchase IDs |
02:09 | Reviewing Sales and Payments |
02:24 | Gift Vouchers, Debtors and Laybys |
02:46 | Viewing Service Sales |
Transcript
Accounting data exported from Retail Express is imported into different transaction journals in MYOB. Review the relevant journal to confirm that the exported information has been recorded correctly and to identify the Retail Express transaction associated with each entry.
Reviewing General Journals
The following Retail Express transactions are uploaded to MYOB as general journals:
- Stock adjustments
- Inter-Outlet transfers
- Cash-up variances
- Petty cash
- Duty on purchases
To review the imported general journals, log in to MYOB and navigate to:
Command Centre > Accounts > Transaction Journal
Understanding General Journal IDs
The ID assigned to a general journal entry is made up of the transaction type and the transaction date.
Use the journal ID to help identify the type and source of the imported transaction.
To view the complete journal entry, select the arrow beside the required transaction to expand its details.
Reviewing Purchases and Bills
Purchase Orders and supplier invoices from Retail Express are imported into MYOB as service purchases.
The total value of all products on the Purchase Order is uploaded as a summary entry rather than as separate product lines.
Miscellaneous costs associated with the purchase are uploaded as a separate line.
To review the imported service purchases, navigate to:
Command Centre > Purchases > Transaction Journal
Understanding Purchase IDs
The ID for an imported purchase begins with the prefix R, followed by the Purchase Order ID from Retail Express.
For example, the MYOB transaction ID can be used to trace the purchase back to its original Retail Express Purchase Order.
Select the arrow beside the transaction to expand and review the complete journal entry.
Reviewing Sales and Payments
Sales and payments exported from Retail Express are imported into MYOB as service sales.
The balance of each imported invoice should normally be zero because the invoice and its corresponding payments are exported together.
To review imported service sales, navigate to:
Command Centre > Sales > Transaction Journal
Gift Vouchers, Debtors and Laybys
A limitation in MYOB AccountRight 2018 and later versions, including MYOB AccountRight in the cloud, may cause an outstanding balance when a gift voucher has been accepted as payment.
Gift voucher payments must be manually allocated in MYOB to clear the outstanding balance.
Debtor and layby movements are handled through account movements so that they do not affect the final balance of the imported invoice.
Viewing Service Sales
The Sales Transaction Journal displays an invoice for each day’s imported sales.
Select the arrow beside an invoice to expand the entry and review its complete details.