> ## Documentation Index
> Fetch the complete documentation index at: https://docs.assetinfinity.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Upload CWIP

> Bringing SAP's capital work in progress across as a spreadsheet, checked row by row before it replaces the whole CWIP list.

Upload CWIP is where finance brings across the capital work in progress SAP holds — the assets under construction, each with its acquisition value so far — a spreadsheet at a time. The list it keeps is what the [CWIP Plan](https://docs.assetinfinity.ai/finance/capex-cwip-plan.md) plans, asset by asset.

**Upload CWIP** is under the **Capex** heading in the **Finance** group of the navigation, for people holding **View the CWIP list uploaded from SAP**. Uploading a file needs **Upload a CWIP file, which replaces the whole CWIP list**, which only administrators hold until your organisation gives it to a role.

> [!NOTE]
>
> If you don't see this in your navigation, your administrator can switch the module on under **Administration → Modules** (it is part of **Capex planning**), or it may not be included in your plan.

**Each file replaces the whole list.** SAP is where a row is put right, so the list here is always the latest file, never half of one month and half of the next. Nothing is typed into it on this screen.

## The list

Under the title, the screen says which file the list is, who uploaded it and when, how many rows it has and their total **Acquisition Value**. Before the first upload it says **Each file uploaded replaces the whole CWIP list. Nothing has been uploaded yet.**

![Upload CWIP, listing eight uploaded rows with asset code, sub-asset number, description, internal order, business area, class, acquisition value and project](https://mintcdn.com/assetinfinity/Nh_CqE52Bv2V-FCv/images/finance/capex-cwip-upload-light.png?fit=max\&auto=format\&n=Nh_CqE52Bv2V-FCv\&q=85\&s=2cadb8c342f626ec369c25cb58d91387)

**Search by asset, order, description, BusA, class or project**, saved **Views**, **Filter** and **Columns** work as on any register. A number typed whole finds the asset or internal order with that number. **Export** (needs **Download a plan's proposals and phasing as a spreadsheet**) downloads the rows the list is showing, under the template's headings, so a list downloaded here uploads again.

| Column | What it shows |
| - | - |
| **Asset Code** | SAP's number for the asset under construction |
| **Sub-Asset No.** | SAP's sub-number, 0 for the asset itself |
| **Asset Description** | SAP's description of it |
| **Inv. Order** | The internal order it is built under |
| **BusA** | SAP's business area |
| **Class** | SAP's asset class |
| **Acquisition Value** | What has been spent on it so far |
| **Project Name** | The project it belongs to |

**Columns** also offers **Row in file**, **File**, **Uploaded By** and **Uploaded On**, off until you turn them on.

## Uploading a file

| Step | What happens |
| - | - |
| **Download the template** | A **CWIP upload template** with the eight headings above, in order. You can fill it in from SAP's CWIP report or paste the report under its headings |
| **Upload a file** | Choose an `.xlsx` or `.csv` file. It is read in your browser and checked at once, without anything being written |
| Read the result | Every problem is listed against the row and column you will find in the file, with the value and what is wrong. **Download the problems** saves them as a sheet to work down beside the file. While there is one problem, nothing is uploaded and the list stays as it was |
| **Upload and replace the list** | Offered once the file is clean. The screen says how many rows are ready and their total acquisition value, and how many rows of the current list uploading deletes. For the very first file the button reads **Upload** |

An older `.xls` file is refused: open it in Excel, save it as `.xlsx`, and choose it again. A file can hold at most 20,000 rows.

How a file is read:

* The rows come from the first sheet with an **Asset Code** heading and at least one other of the eight on the same row, within its first thirty rows. A report's title and filters above the headings are passed over, and the screen says so. Other sheets are not read, and the screen names them.
* Headings are also recognised by SAP's own names for them, such as **Asset**, **Asset Number**, **Sub-number**, **Investment Order**, **Business Area**, **Asset Class** and **Acquis.val.**. A column that is not one of the eight is not read, and the screen names it.
* **Asset Code**, **Sub-Asset No.** and **Acquisition Value** are required on every row. Give 0 for the sub-number of the asset itself, and 0 where nothing has been spent.
* Each asset goes on one row: two rows with the same Asset Code and Sub-Asset No. are refused. An empty row is skipped.

> [card] [CWIP Plan](https://docs.assetinfinity.ai/finance/capex-cwip-plan.md)
>
> Planning when each asset on the list will be capitalized.

> [card] [Capitalization Planning](https://docs.assetinfinity.ai/finance/capex-capitalization-planning.md)
>
> When each approved proposal's money becomes assets.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.