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. Please ensure the "Source Bookkeeping System" is kept as -Select- and finally your import options are both unticked at the bottom and then press 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 6: 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