STX offers a way to export sales information for import into MYOB (Mind Your Own Business) accounting software. Visit www.myob.com/us/ for information about the MYOB software. You must also have the Excel spreadsheet software installed on your computer in order for the MYOB export to function properly.
When setting up the accounts in MYOB, you must follow the generalized numbering chart for each account set up. The account numbers are 5 digits long. The first digit is reserved to indicate the type of the account (asset or liability, for example). The remaining four digits can be whatever you choose.
Asset
The things a company owns, seen on the Balance Sheet and represented as 1-xxxx accounts in your Chart of Accounts.
Liability
The things a company owes in cash or other resources, represented as 2-xxxx in your Chart of Accounts. These are claims against assets.
Equity (Capital)
The owner’s interest in the business, which is the total assets minus the total liabilities of a company, seen on the balance sheet and represented as 3-xxxx accounts in your Chart of Accounts.
Revenue
The dollar amount of sales during a specific period, including discounts and returned merchandise. It is all the income produced by a particular source. Seen on the Profit and Loss and represented as 4-xxxx accounts in your Chart of Accounts.
Cost of Goods Sold (COGS)
Represents the cost of items or services sold to customers. These costs are kept in the Inventory Asset account (1-xxxx) until they are sold. Then they are passed over to the COGS (5-xxxx) account. Seen on the Profit and Loss and represented as 5-xxxx accounts in your Chart of Accounts
Expenses
Costs incurred in the business used to generate revenue. Seen on the Profit and Loss report and represented in your Chart of Accounts as 6-xxxx accounts.
Other Income
Represents income from activities other than normal business operations, such as investment interest, foreign exchange gains, rent income, and profit from the sale of non-inventory assets. Seen on the Profit and Loss and represented as 8-xxxx accounts in your Chart of Accounts.
Other Expenses
Represents the expenses of a business independent of how much revenue is generated. Can also be considered Fixed Costs. Seen on the Profit and Loss and represented as 9-xxxx accounts in your Chart of Accounts.
Once you have the accounts set up properly in MYOB, you must set the same accounts in STX. Do not change the names of the original accounts pre-set in STX. Instead, make the unused accounts Inactive.
To set up accounts in STX, go to Setup: Finance: Accounts. Each account must have the same account number you assigned in MYOB. If you do not have account numbers established in STX, the export will not function. The names and account numbers MUST match what is set in MYOB in order for the export to function properly. There must not be any unpaid ticket balances during the period of the export, or the export will fail.
Now that you have all of the accounts set up the same in both MYOB and STX, all transactions entered after the set up will be coded properly and will export correctly.
Any transactions entered prior to the set up will not export. You must also make sure you do not have any unpaid or partial paid transactions for the time period you are exporting. If you have any transactions still in RED, the MYOB Export will fail.
To export the sales information from STX, go to Reports: Transactions: Export MYOB.
Enter the Start and End dates for the time period you wish to export. Click the Export button and Save the export document to the Desktop.
Before saving the document, you may change the name of the document to something indicating what it is you have exported.
Once the document appears on your desktop, you will need to change the file extension from ".txt" to ".xls" in order to turn it into an Excel document. The following alert will appear: Are you sure you want to change the extension?
Click Use .xls. Now the document will appear as an Excel document on your desktop.
Open the Excel document to verify the exported information. Once you have verified the information, Quit Excel and proceed to the import into the MYOB Accounting software.
Please see the documentation available with your MYOB Accounting software for information on how to perform the import.