Prior Year Figures Import Via CSV

Step One: Locate and Select Import Trial Balance

1. From the files Working Paper Index, click on the Trial Balance button
2. Select Import Trial Balance

Step Two: Select the Method of Import

1. After clicking import trial balance, you'll be taken to our integrations page 

2. Select the Custom CSV import option

Step Three: Locate and Import The CSV

There are two methods to import your CSV document.

1. Click the Choose File button, locate and select the relevant CSV document
2. Locate the CSV document within your folders and then drag and drop the document onto the Choose File button
3. Once either method has been done click Upload

Step Four: Mapping Trial Balance Columns

1. In this step you need to ensure that the CY Debit & Credit fields are set to -Select- and that the PY Debit & Credit fields are mapped to the columns in your CSV file then click next

Step Five: Double Check the Figures

In this step make sure to double-check that only the prior year's figures are pulling through

Step Six: Choose the Correct Duplicate Accounts Handling

At the bottom of this page, you will find a drop-down option for Duplicate Accounts Handling make sure to select the correct option for your import

• Account Code Only – Select this if your file may contain multiple accounts that have the same account code but different account names and you want to combine them on confirming the import. 

• Account Name/Description Only – Select this if your trial balance doesn’t have account codes, and it may contain rows that have the same name or description and you want to combine them on confirming the import.

• Both Account Codes and Account Name/Description – Select this if your trial balance may contain rows where the account code is duplicated due to sub-accounts but the names are different. Where the account name is different multiple rows will be created in MyWorkpapers.

Step 7: Import

Click the Import button to complete the process.

You’ve now successfully imported the client’s prior year balances into MyWorkpapers and you can now start preparing the workpaper file!

If you have any questions or require any further assistance with this process please contact the MyWorkpapers Support Team