Financial Transaction History - Export Invoices, Payments, Adjustments to CSV, PDF, or MS Excel

Financial Transaction History - Export Invoices, Payments, Adjustments to CSV, PDF, or MS Excel

From Order Management -> Finance -> click the Export Transactions Menu option.

1. Enter the Start and End date for the Financial Transactions that need to be exported.
   
2. Click Refresh Data
   
3. In the Transaction Description column header:
   
1. Leave blank to include all Transaction types
   
2. Type "Invoices" to include only Invoices
3. Type "Payments"  to include only Payments
   
4. Type "Adjustment" to include only Adjustments
   
5. Type "Finance" to include only Finance Charges
4. Sort the Transactions ascending or descending chronologically, by clicking the Created Date column header.
   
5. In the Status column header:
   
1. Leave blank to include all Paid and Unpaid Invoices and Charge Adjustments, and Applied and Unapplied Credits
   
2. Type "0" to include only Unpaid Invoices and Debit Adjustments, and Unapplied Credit Adjustments
   
3. Type "1" to include only Paid Invoices and Debit Adjustments and Applied Credit Adjustments
6. At the top right of the Export Transactions window, click the menu button to access additional options.
   
7. Click the Export Visible Data as ... menu option and select the type of document you want to create. 
   
8. Be sure to rename the file from "download.xls" to something meaningful.  such as "Payment Transaction History 2020-August" and browse to the directory to which you want to save it.
   

Example: To generate a spreadsheet of the Payment Transaction History for the month of August, 2020, enter the Start Date 8/1/2020, End Date 8/31/2020 and click Refresh Data. Type "Payment" in the Description column header. Click the Create Date column header to sort ascending or descending. Click the menu button to access additional options. Click to select Export Visible Data as Excel. Rename the file "Payment Transaction History August 2020" and browse to the directory to which you want to save it.

• Related Articles

• Price Lists - Export to CSV, PDF, or MS Excel

  Price Lists - Export to CSV, PDF, or MS Excel From Order Management -> Product Management -> click the Price Lists Menu option. Repeat the following for each price list that you wish to export to a file. At the top of your targeted Price List's ...

• 2019-12 December Update

  Below is a summary of the enhancements and bug fixes found in our latest update of VisualDLP Silent Printing from VisualDLP and User Settings for default printers and printer settings. Now you can set-up your default printer, paper size and ...

• Viewing Transactions Paid By A Payment

  Discussion There are two ways can apply a payment, manually or automatically.   Manually lets you pick the invoices and debits you are paying for, and Automatically forces the system to apply the payment to the oldest transactions first until all the ...

• 2019-10 October Update

  Below is a summary of the enhancements and bug fixes found in our latest update of VisualDLP Faster Updates to Orders - Saving an order is now three times faster than before. Added Account Phone Numbers to the Shipping Tab of the Order Entry Page ...

• Payment This Month/Payments Today not Showing

  In the September update, we rely on the Global Setting that sets the lab's Timezone. If its not set, the Payments info will not load.  To set the Time Zone Log in as an Admin Go to Globalsettings Click on General Settings Select the Time Zone you are ...