Top

Trial Balance Import (CSV) - BGL Desktop and Reckon

Step 1-Ensure you are in the Working Paper Index of the fund you want to begin auditing;

2. Click on Trial Balance | Import Trial Balance;

3. Select Custom CSV as your import source

 

4. Download and open either the Reckon template or the BGL Desktop template;

(The format the trial balance exports in from BGL Desktop and Reckon requires editing before it can be uploaded. We have provided templates for you to use to quickly manipulate the data into an appropriate format before uploading the trial balance.) 
2.PNG

  1. Copy and paste the raw trial balance exported in excel directly from Recon or BGL Desktop into the second sheet of the template;
    3.PNG

  2. Open the third sheet of the template - "MyWorkpapers TB Import";

  3. Save As this as a CSV (Comma Delimited) file to your local computer;
  4. In the MyWorkpapers application select this file from your local computer by clicking on the Choose File button;
    1.PNG

Once the file has been saved and selected please see our instructions here on the Trial Balance Import Wizard.

 

 5. One your trial balance is imported it will look similar to the below picture: 



6. To map the trial balance please select ToolsMap accounting structure (industry templates)

  • If you are BGL desktop select; BGL>BGL CSV
  • If you are Reckon select; Reckon>Reckon CSV

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.