When paying a contractor, the accounting department may want a computer digestible version of the payment request for use in their accounting software. AWEbase can attach a CSV to payment request emails including all of the request's pertinent details:
Organization Name
Contractor Name
Contractor Nickname
Contractor Internal ID
Deliverable Name
Deliverable Internal ID
Deliverable Allocated Amount
Deliverable Amount
Payment Request Amount
Job Total Amount
Job Balance
Job Number
Job Name
Job Status
Job Deadline
Payment Request Number
Payment Request Created On
Payment Requested By
Exchange Commission Rate
Exchange Rate
Payment Request Message
Invoice Date
Invoice VAT %
Invoice Withholding %
Invoice Payment Terms
Invoice Message
Title Name
Title Code
Title Internal ID
Release Name
Release Code
Release Internal ID
Deliverable Category
Deliverable Type
Coordinator
Coordinator Message
Contract ID
Contract Template
Contract Date Signed
Partial Payment
In the event of a partial payment, AWEbase allocates payments to deliverables based on their percentage of the total cost. For example, a $1000 job is invoiced and subsequently had payment requested for $250. The job has two deliverables, one for $200 and another for $800. The first deliverable will have $50 allocated - (200/1000)*250. The other will have $200 allocated - (800/1000)*250.
There will always be an amount in the "Deliverable Allocated Amount" column, regardless of whether the payment was partial or not. However, if "Partial Request" is "TRUE" that amount will be less than the "Deliverable Amount" based on the calculation above.
If enabled, the CSV is attached and sent with the payment request email to the accounts payable email address.
To enable the CSV attachment follow the instructions below:
As an admin user, navigate to "Settings", then "Customization", and finally the "Payment Requests" tab.
Toggle the "Send weighted payment allocation CSV file with Payment Request Emails" option.
