General Ledger Import Wizard (Custom CSV)

Step 1 - Open the General Ledger Import Wizard;

1. Open the Trial Balance in your file and select Import Trial Balance;

2. Select the Custom CSV import option under the "Import Trial Balance with Transactions" heading;

3. Click on the Choose File button;

4. Browse through your local computer to find the saved general ledger transaction report;

5. Click on the file to select it;

 (Note: The file must be in CSV format)

6. Click Open;

7. Click on the Blue Upload button;

Step 2 - Specify the General Ledger Columns;

1. Select the the header row of the general ledger transactions;

2. Select the appropriate Account Code, Account Name, Transaction Date, Transaction Description, Debt, and Credit columns;

(Note: If you have already imported a trial balance without a general ledger, this import will override all existing columns within the trial balance except for the Prior Year column)

3. Click Next;

Step 3 - General Ledger Check

1. Ensure the Account Code, Account Name, Transaction Date, Transaction Description, Debt, and Credit, columns are correctly mapped to the general ledger being imported; 

2. Ensure the debit and credits of the general ledger agree at the bottom of the screen;

3. Click Import;

4. The general ledger has now been successfully imported into MyWorkpapers and is ready for the Trial Balance to be updated. Click the Generate Trial Balance button to populate the Trial Balance.

Useful Articles:

Accessing the General Ledger