Transferring Payment Applications from ACD5 to Catina

Summary

The article "Resolving the Payment Application Issue" guides users on transferring G703 pay application data from ACD5 to Catina. It outlines steps to download, edit, and upload spreadsheets, ensuring seamless integration of payment data. Key processes include exporting Excel files and configuring G702 documents in Catina.

Process Overview

When starting a new pay application (pay app) for a project where previous pay apps were completed in ACD5, you can download a spreadsheet of your previous G703 and use that to create your next pay app in Catina. Follow these steps to transfer and update your data efficiently.

Accessing Previous Pay App Data in ACD5

1. Log into ACD5
2. Click on your project.
3. Open the last G703 (we just need the continuation sheet. We do not need the G702)
4. On the left-hand side, click "Download Draft". This action will trigger the download of an Excel version of your document to your computer. This file will be used in Catina.
5. Open this downloaded G703 on your computer

(Now you need to go to Catina to get a template to move the data over)

Creating a New Pay App in Catina

• Log into Catina.
• Select the "Projects" tab.
• Create a new project or select an existing project.
  • Include the project Value
• Click " +New Document".
• Select the "G702 Application and Certificate for Payment" and click "Configure".
• Name your document (Pay App2, 3, 4, etc) and add your project team as applicable
  1.  Set your pay period date
  2. Include related document “Yes” – This is how you are going to link your G702 and G703 continuation sheet together as one payment process
  3. Start from previous pay app – No
  4. Retention settings – Fixed means every single line item gets the same retainage, Variable if you want to enter a specific retainage /per line item manually

You can select multiple rows in the G703 pay application and apply a retainage percentage in bulk using the new checkbox column and Set Retainage button.

• • Apply the same retainage rate to dozens of rows with one action instead of manual entry.

How It Works

1. Users select one or more rows using the new checkbox column.
2. The Set Retainage button becomes active.
3. Enter a percentage (e.g., “10%”) in the modal, click Apply, and all selected rows update instantly.

Please Note: If you have retention listed on your G703 you will want to select Variable when configuring your new document in Catina, even if it is a fixed amount. Otherwise, when you import your Line Editor, it will wipe your retention amounts thinking that it only needs to be represented on the G702.

          5. Then click "Create Document" and will open in the online editor

Some of the columns have changed and in a different order

There are two ways to transfer your pay applications (Pay Apps) from ACD5 to Catina:

1. Manual Transfer: Copy and paste the Excel data from your ACD5 Excel sheet into the corresponding Catina sheet.

2. Import Method: Import the Excel data directly into Catina.

Manual Transfer

1. Click "Export" to Export the Excel File". This will download an Excel version of the file.

Troubleshooting Tip: Prior to exporting your document, you will want to add as many rows as needed for your continuation sheet. It is better to have more than you need since you cannot add rows within Excel. To do so, click the Add Row button, type in as many rows as you need, then click the arrow to apply.

     2. Use the data from the latest ACD5 pay app to copy and paste the relevant fields into the correct spots in the new Excel document.

• • (ACD5) Item # - (Catina) Item #            
  • (ACD5) Description of Work - (Catina)Description of Work
  • (ACD5) Scheduled Value - (Catina)Scheduled Value
  • (ACD5) Work Completed from Previous Application - (Catina)Work Completed from Previous Application
  • (ACD5) Work Completed This Period - (Catina)Work Completed This Period
  • (ACD5) Materials Presently Stored - (Catina)Materials Presently Stored
  • (ACD5) Total Retainage - (Catina)Total Retainage
  • Total Completed & Stored to date will automatically calculate
  • % Complete will automatically calculate

 Note:

In some cases, retainage may not come in unless it is set to variable rather than fixed.

    3. Make any additional edits or changes to the pay app in Excel, then save the document.

Uploading the Edited Excel Document Back to Catina

1. Click the "Projects" tab in Catina.
2. Click on the project you are working under and select the G702 document you previously created.
3. Once the editor is open, select "Import Excel File".
4. Select or drag and drop your Excel document, then click "Upload".
5. You can now continue editing your line items or edit the G702 within the document editor.

Import Method:

1. Click "Export" to Export the Excel File". This will download an Excel version of the file.

      Note:

• Formatting must match the ACD5 export structure in order to be recognized and imported correctly.

The percentage field is in a different location in Catina, so pay close attention to column headers when copying over.

• In some cases, retainage may not come in unless it is set to variable rather than fixed.

    3. Make any additional edits or changes to the pay app in Excel, then save the document.

Uploading the Edited Excel Document Back to Catina

1. Click the "Projects" tab in Catina.
2. Click on the project you are working under and select the G702 document you previously created.
3. Once the editor is open, select "Import Excel File".
4. Select or drag and drop your Excel document, then click "Upload".
5. You can now continue editing your line items or edit the G702 within the document editor.

FAQ's

1. What should I do if the percentage fields in the ACD5 file don’t match Catina’s format?
The percentage field is located in a different column in Catina compared to ACD5. When transferring data, carefully review the column headers in the new Excel file to ensure accurate placement.

2. Can I edit the G702 document in Catina after importing the Excel file?
Yes, once the Excel file is uploaded to Catina, you can continue editing the line items or make changes directly within the G702 document editor.

3. What file format is required for uploading data into Catina?
Catina requires an Excel file for importing data. Make sure the file is correctly formatted and saved as an Excel document before uploading it to the G702 document editor.