Export Sales, A/R and A/P Vendor Transactions to Sage Accounting

Export Sales, A/R and A/P Vendor Transactions to Sage Accounting

Export RO and A/P Transactions to Sage Accounting

Q. Can you export your transactions from MaxxTraxx into a QuickBooks data file format (.IIF file extension) and import them not only into QuickBooks but also into the Sage Accounting program?
Answer:
  1. Yes you can. Here’s how:
    1. In MaxxTraxx, click on the Accounting menu item at the very top.
    2. Then click on Export to QuickBooks
    3. The Export Transactions dialog box will open up.
    4. In this window you will choose your export dates and other parameters to generate your list of transactions.
    5. Select your transactions individually or click the Select All button to get them all.
    6. Click the Export Selected Items button at the bottom left hand side when you are ready.
    7. This should export a dated file that has a .IIF file extension at the end to the following location:  c:\Scott Systems\MaxxTraxx Pro\Export
    8. In your accounting system, you will use the appropriate method to import those transactions.  This is the Sage Accounting or Sage 50 method:
      1. i.Reminder:  Always create a backup of your data before beginning any data import!
      2. Select File, Import/Export, then Import Records.
      3. Select OK
      4. Select QuickBooks
      5. Select Next
      6. Choose the item/s you want to import, corresponding to what was saved from.
      7. Browse to the location of your exported .IIF files from QuickBooks.  Select that file.
      8. Choose all that apply in the same window.
      9. Select Next the start the import process.
      10. Select OK
      11. Select Finish to complete the process.
    9. You did it!  Check your transactions and make sure all are correct before continuing to use that data


    • Related Articles

    • How to Find Vendor History

      Click on Vendors Select Accounts Payable Vendor List Double click on the Vendor from the list Click the Options button on the left Select View A/P Transactions Use the Show drop down box to select the time frame to view. It defaults to Open Invoices ...

    • Vendor Quick Check

      From time to time you might have to give a vendor a check before you can enter the restock ticket for the part or sublet purchase.  For this you would create what we call a “Vendor Quick Check”.  This will put a credit on their Vendor Account in ...

    • Adding QuickBook Accounting Method

      With the new update the feature of Exporting to QuickBooks is now a setup feature. It will no longer be visible under Accounting unless it's selected in Company set ups. To add QuickBooks as the accounting method to MaxxTraxx you would do the ...

    • Adding Quickbook Export

      With the new update the feature of Exporting to QuickBooks is now a setup feature. It will no longer be visible under Accounting unless it's selected in Company set ups. To add QuickBooks as the accounting method to MaxxTraxx you would do the ...

    • A/R Payments that use the Reference Number

      If a customer makes a payment for an A/R charge, and the payment is from a name that is different from our customer's name, and the payment refers to the Reference Number on the statement rather that to the RO number, it makes it difficult to know ...