Use the L&I Payments Export report to export payment data from an L&I Remittance Advice that has been uploaded to Gardiant Works.
The L&I Payments Export report is formatted for export to Excel, which can then be imported to your accounting software. If your accounting software doesn’t accept Excel files for import, a third party application like Transaction Pro may be required to map the Excel file to your accounting software.
Parameters:
Quarter parameter (required) is pre-populated with the most recent yearly quarter. Use the drop-down to select a different quarter/year.
Remittance Advice parameter drop-down displays the uploaded L&I RAs paid during the selected quarter showing the Remittance# and Payment Date for each, with the most recent at top.
Notes:
The RA Number is a combination of Payment Date and RA Number.
Invoice IDs column combines the invoice#, the invoice item#, and the charge type number (1 = professional hours, 2 = travel/wait hours, 3 = mileage). This is designed to be a unique ID for the billing item that is also present in the L&I Invoice Export report so the payment item can be matched with the invoice item.
Amount Paid is the amount paid on the item in this particular remittance advice.
Invoice Date is the most recent date the item was invoiced. An item may be invoiced multiple times if it is resubmitted for adjustment.
