Import Client Payment Information

Import Client Payment Information

On the reports tab click on Invoice – Import Client Payment Info  
 

Next, you will see a list of possible Client imports, including and Excel import option . The most efficient, reliable, and stable way to upload client payment information is to use the Excel, CSV, Tab option as highlighted above.  

 
To start with the Excel import option - follow the steps below:

Before you choose your Excel file, make sure it is formatted properly, as shown below. 

Once your file has been formatted properly, you can select the file, enter the check number, check date, and the client for whom the payment is intended. You can choose whether or not you want to apply 0 dollar payments. Then click Process. 

Once you click process, you will be taken to a screen where you can designate columns. 

If you don’t apply payments via work order numbers, you can utilize alternative fields, such as the PPW number or client invoice number.  

 
 

Once you click set columns, you will be taken to the check import preview screen. This screen will show you what work orders you are making client payments for. If they are in the system, it will show a status of new in green. If they are not, it will say WO not found in red. The payment information will show an accurate payment in green, an underpayment in red, and an overpayment in blue. You can enter any comments you would like in the comment box. Once all fields have been filled out and confirmed, you can click save payments and that will apply the payments in bulk to the orders on that check.