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 ...

    • Change Sales Tax

      How to Update Sales Tax Rates and Recalculate Open Invoices Step 1: Update Sales Tax Rates for Future Transactions Go to Setups > Accounting and Payroll > Sales Tax Rates Highlight the tax rate you want to change and click Edit Make your changes and ...

    • Vendor Quick Check

      Sometimes you may need to issue a check to a vendor before entering the restock ticket for a part or sublet purchase. In these cases, you’ll use the Vendor Quick Check feature. This places a credit on the vendor's account in MaxxTraxx, which can be ...

    • Changing sales tax rates

      Updating Sales Tax Rates in MaxxTraxx Many municipalities will implement new tax rates beginning June 1st, 2025. To ensure accurate sales tax collection in MaxxTraxx, follow these two steps: Step 1: Update Sales Tax Rates for Future Transactions ...

    • 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 ...