How to Export Recurring Payment Schedules

noate00034.gif 

When you export the recurring payment schedule file you will have a choice to open it or to save it. If you select “open” the file will typically open in Excel. However, because this is a .csv file Excel will often corrupt the data—for example by removing leading zeros on routing numbers and zip codes.

If you want to use your export in Excel, the best practice is to save the .csv file to your hard drive. Then open a new workbook in Excel and import the .csv file. During the import process you can designate fields such as routing numbers, account numbers, and zip codes as “text” fields instead of number fields so that your data is not corrupted.

For detailed instructions on how to import .csv files into Excel, consult the Excel Help files.

Follow the steps below to export your filtered payment history to a .csv file.

  1. Go to the manage recurring payments screen.

  2. Filter the table to define the data set for the export, or leave the default selection of all schedules.

  3. Click the “export” link at the very top of the table, as shown:

    export_link_recurring_payments.jpg

     

  4. Depending on your browser, you will have the option to open and/or save the file.

    1. To open the file, click the “Open” button in the dialog box. In most cases (unless you have your system default .csv files to a different program), the file will open in Excel, but will not be saved. You will need to save the file if you want to store it on your computer.

      rec_export_open.jpg

       

    2. To save the file to your computer:

      1. Click the “Save” button in the dialog box. 

        rec_export_save.jpg

          

      2. A Save As dialog box opens.
        NOTE: In Google Chrome, and some other browsers, clicking the “csv” link will automatically save the file to your Downloads folder. You can open it from the browser “Downloads” bar or access it from the Downloads folder later.

        rec_export_save_to_pc.jpg

         

      3. Enter a name for your file, and select a location on your computer where you want to save the file.

      4. Click the “Save” button.

      5. You can now open the export at any time, or import it into an Excel file or other application software.

 

Next >