Export help

Includes: explanation on exporting to MYOB and QuickBooks, as well as how to print reports. 

Printing

  • Go to: [Accounts] > [Exports]
  • To view/print the next export, choose a report without selecting any previous exports (click on either [Exports] or [MYOB Payments])
    • To unselect any exports (for viewing the next export), click on the [Refresh] button at the gird's bottom left corner
  • Choose the format you wish to view/print the report
  • You can then [Print] or [Save As] the report in selected format

Exporting

  1. Go to: [Accounts] > [Exports]
  2. Select a date you wish to export up to:
    • The export will be between the [Last Export Date] and the [To Date] selected
    • The [To Date] can only be later than the [Last Export Date]
  3. Click on [Export] and confirm to export

Previous Exports

  1. Go to: [Accounts] > [Exports]
  2. Select the export you wish to view/print from the [Exports] list
  3. Select a report (click on either [Exports] or [MYOB Payments])
  4. Choose the format you wish to view/print report
  5. You can then [Print] or [Save As] the report in selected format


Importing into MYOB (ver. 19-20)

NB: You must import new customers first otherwise sales to those customers will not import.
NB: This can be done over and over, so if the reporting format is not correct, it can be corrected and redone.
  1. Go to: [Accounts] > [Exports]
  2. Select the export you wish to view/print from the [Exports] list
  3. Select the Report for [Customers], then Choose [Export], this will prompt you to save a file, do so and name in to "Customers" saving it to a location you know like Desktop (you can delete later)
  4. Select the Report for [Sales], then Choose [Export], this will prompt you to save a file, do so and name in to "Sales" saving it to a location you know like Desktop (you can delete later)
  5. Select the Report for [SpendMoney], then Choose [Export], this will prompt you to save a file, do so and name in to "SpendMoney" saving it to a location you know like Desktop (you can delete later)
  6. Open MYOB
  7. Customer:
    1. Go to: File > Import Data > Cards > Customer Cards
    2. Change [Duplicate records] "Update existing", Change [Identify records by] "Co./LastName" then [Continue]
    3. Find and choose the "Customers" file you saved, click [Open]
    4. [Match all], check that fields have in fact matched
    5. Click [Import], if error's note the log file contact SAM for help, don't import again or log file will be overwritten.
  8. Sales:
    1. Go to: File > Import Data > Sales > Professional Sales
    2. Change [Duplicate records] "Add them", Change [Identify records by] "Co./LastName" then [Continue]
    3. Find and choose the "Sales" file you saved, click [Open]
    4. [Match all], check that fields have in fact matched
    5. Click [Import], if error's note the log file contact SAM for help, don't import again or log file will be overwritten
  9. Spend money:
    1. Go to: File > Import Data > Disbursements > SpendMoney
    2. Change [Duplicate records] "Add them", Change [Identify records by] "Co./LastName" then [Continue]
    3. Find and choose the "SpendMoney" file you saved, click [Open]
    4. [Match all], check that fields have in fact matched
    5. Click [Import], if error's note the log file contact SAM for help, don't import again or log file will be overwritten

Importing into QuickBooks Online

NB: Requires Excel as well as QuickBooks
NB: This also requires App "Transaction Pro Importer/Exporter" ~$12.50US Per month
You will need to connect it to QBO, this is straight forward login to QBO and follow this link and prompts https://importer.transactionpro.com/
  1. Go to: [Accounts] > [Exports]
  2. Select the export you wish to view/print from the [Exports] list
  3. Select the Report for [QuickBooks Online], then Choose [Save to Excel], this will prompt you to save a file, do so and name in to "QuickBooks Online" saving it to a location you know like Desktop (you can delete later)
  4. Login to: QuickBooks Online, and Login to Transaction Pro Importer/Exporter
  5. From Transaction Pro Importer/Exporter 
  6. [Choose Import Type] - (top left side)
  7. Choose [Customers]
  8. Upload the file which you saved to your desktop
  9. This will then be ready when a Green tick appears on the file
  10. [Select File and Sheet] - (Bottom right)
  11. Choose [Import Customer] (or which Type your up to) - (Bottom right)
  12. Match Columns, this should auto match, please double check ... there is no Shipping fields
  13. [Preview and import] - (Bottom right)
  14. Transaction to Import - Click [Import] - Confirm (you can uncheck records you don't want to import here)
  15. Once imported repeat from steps 6 to 14 for each of the following types, Invoices, Sales receipts, Credit Memos, Checks (note some maybe empty)

Importing into QuickBooks


NB: Requires Excel as well as QuickBooks
NB: This can be done over and over, so if the reporting format is not correct, it can be corrected and redone.
  1. Go to: [Accounts] > [Exports]
  2. Select the export you wish to view/print from the [Exports] list
  3. Select the Report for [QuickBooks], then Choose [Export], this will prompt you to save a file, do so and name in to "QuickBooks" saving it to a location you know like Desktop (you can delete later)
  4. Go to: QuickBooks
  5. Go to: File > Import
  6. Find and choose the file you just saved, click [Import]

Importing into Xero


NB: This can be done over and over, so if the reporting format is not correct, it can be corrected and redone.

Xero Sales
  1. Go to: [Accounts] > [Exports]
  2. Select the export you wish to view/print from the [Exports] list
  3. Select the Report for [Xero Sales], then Choose [Export to Xero], this will prompt you to save a file or just download the file.
  4. Go to: Xero
  5. Go to: Business > Invoices > [Import]
  6. Browse and find the file you just saved, click [Import]
Xero Payments
  1. Go to: [Accounts] > [Exports]
  2. Select the export you wish to view/print from the [Exports] list
  3. Select the Report for [Xero Payments], then Choose [Export to Xero], this will prompt you to save a file or just download the file.
  4. Go to: Xero
  5. Go to: Accounting > Manual Journals > [Import]
  6. Browse and find the file you just saved, click [Import]

Feedback and Knowledge Base