Exercise 1 – Creating/Using Excel-Based Entry Grids
IntroductionDuring this exercise you will create an entry grid for General Ledger transactions, enter some data, create an import file, and then import it into General Ledger. This process will be divided into two objectives:
- Creating A Reusable Entry Grid
- Using The Entry Grid And Importing Data
|Note -||This tutorial example is designed to work with the Timberline Construction Sample Data.|
Step 1 - Create An Entry Grid In ExcelThis exercise will demonstrate creating an Excel worksheet that can be used to quickly enter data into the General Ledger.
- Create a new Excel workbook.
- Click cell A1 of Sheet1.
- Click the Add-Ins tab, then click Import Wizard to display the Office Connector Import Wizard.
- Select GL Transaction Import File and click Next.
- Select the column name check boxes listed below, and then click Next:
- √ Account
- √ Accounting Date
- √ Journal
- √ Reference 1
- √ Description
- √ Debit
- √ Credit
- Under Values, click Create An Entry Grid For The Selected Columns and click Finish.
- Select Columns F and G and click the Home tab. Under Number, click thecomma button to automatically format the values with two decimals and commas.
Step 2 - Using The Entry Grid And Importing Data
- In this example, we are using the Construction Sample Data. By doing so, we ensure the suggested values (listed below), are valid and can be entered in to the grid. Depending on the version you have installed, you may need to utilize a different Accounting Date.
- Click Save Import File on the Office Connector Import toolbar.
- The default save location is sufficient for this example. If it is not already, the first action to be performed after the file has been created should be selected.
- Click OK to create the file and then launch Import Transactions from General Ledger (it may take a few seconds for this window to come up).
- Once Import Transactions – Print Selection appears, click the […] ellipses button for Import File, select the GLTransaction.TXT file, and click Open.
- Optionally – Click Printer Setup and change where the report will be sent.
- Click Start to import the data.
- Review the General Ledger Import Transactions report when the import has finished.