Refer to our Article on [**Navigating to your Working Trial Balance**](https://draftworx.helpjuice.com/en_US/cloud/importing-your-trial-balance-cloud)

On the **Working Trial Balance,** select the **Tax Year** you are working with, Select **Excel**

Ensure you are in the correct **Tax Year** tab when importing a **Tax Year** to ensure the information imports into the correct year. It will show as selected as per above.

select the **Select File** button this notification will also advise which **Tax Year** you are importing into.

Browse to the **Location** of your file, select it and click **Open**

**Draftworx** requires the following fields of the **Trial Balance** to be allocated:

**Account Number**: column containing the **Account Numbers**. If you do not have **Account Numbers**, this field can be assigned to **Account Name**. The column selected has to have unique **Account Numbers/Names**.

**Account Name:** Column containing the **Account Names** \
**Debit:** Column containing the **Debit** **Amounts** \
**Credit**: Column containing the **Credit** **Amounts**

Select **Assign Account Number** and then select the first **Account Number** (In this example cell B4) and continue by selecting the other required fields

If the **Debit** and **Credit** Amounts are in different columns, and reflect as both positive amounts , you can assign the **Debit** and **Credit** to the respective columns

The option **Import Into** can be changed when importing monthly amounts. **Select Import Into** then select the required period to **Import.**

Importing into **Opening Balance** is the default for if you are completing an **Annual Financial Statement** or **Year To Date Management Accounts.**

The only time it is necessary to change this from the default is if you are busy with **Monthly Financial Statements** and would like to see the respective months separately, you would then import the monthly values into the respective months.**

Once all the fields have been assigned the correct information, select **Import**

Once imported, your **Trial Balance** will show as follows.

To **Link** your **Trial Balance**, a process where you allocate each individual **Line Item** to a location in the **Annual Financial Statements**, please refer to our Articles on [**Linking your Working Trial Balance**](https://draftworx.helpjuice.com/en_US/cloud/linking-accounts-in-your-working-trial-balance-cloud).

This guide provides guidelines for importing a Trial Balance into Draftworx Cloud using Excel.

Draftworx Cloud: Importing a Trial Balance using Excel