Import Funder Payments |
  
|
Import Funder Payments is designed for clinics who participate in a third party paying them a portion of the client balance, but for a fee that reduces the receivable a clinic will receive as a deposit. Funder balances imported will go directly to DC2, into the bank as the full amount when imported (without being shown/ reconciled in DC1) and then in DC3 a journal is created to reduce the bank and offset taxes and fees that were deducted from the entered receivable.
To access the formatting import sheet, click the EXCEL icon.
The Import Funder Payments EXCEL format is:
INVOICE TYPE (R=Repair I=Invoice) - Enter whether the Funder receivable is for a Invoice (I) or a Repair (R)
INVOICE NUMBER - Enter the Invoice number for this Funder receivable. (Note Accounts Receivable Start Up Invoice for Funder may also be entered.)
FUNDER ACCOUNT NUMBER - Enter the Funder Account Number associated to this Funder receivable.
PAYMENT REFERENCE - Enter a Payment Reference for this invoice.
PAYMENT NOTE - Enter a Payment Note for this invoice.
PAYMENT DATE - Enter a Payment Date for this invoice.
PAYMENT LOCATION - Enter the Location Code for this invoice's Funder receivable. Note that the method of payment will be assumed by the FUNDER SOURCE configuration.
TOTAL PAYMENT AMOUNT - Enter the Total Payment Amount (before any tax or fee amount deductions.)
TAX AMOUNT - Enter the Tax amount deducted from this invoice's receivable.
FEE AMOUNT - Enter the Fee amount deducted from this invoice's receivable.
To import your sheet, click the magnifying glass icon and select to find your import sheet either on the application server or on your own local machine. Once the file has been selected, you will be prompted whether you wish to rename the file or keep the file name.
Next press CONTINUE to run the import.
A summary excel file will be presented to show you the results of your import. A status line will show you if there was a failure, and what the failure reason is. If successful, each invoice line will show "successful" in the status line. The next DC2 and DC3 will reflect the values imported on this sheet.