Obtaining General Ledger Files
Before importing general ledger into Bank Reconciliation, they must be obtained from your accounting package. The exact process depends on the package, but in general you will run a check register report for a given date range and then export this report to an Excel spreadsheet or CSV file. For more information or assistance in this, contact your corporate IT.
Importing General Ledger File
Click the the Import GL button on the main screen to start the Import Wizard.
Click the Select File Icon to choose a file to Import and click Open. (Common file types are Excel (.xls), Access (.mdb), Comma Delimited (.csv or .txt), tab delimited (.txt), and text (.txt).)
Copy and paste your data from your GL source document
The General Ledger Column Mapping screen allows you to specify the purpose of each column. Simply highlight a column, and select the appropriate column mapping from the drop down for the data.
After selecting the Column Mapping, the section about the column names (F1, F2, F3, etc.) will switch from Red to Green and list the selected mapping.
Repeat for each field that needs to be imported. Above, 'Date' is mapped to the field containing transactions dates. Some common fields for Bank Reconciliation are 'CheckNumber' for check number, 'Amount' for transaction amounts (alternatively, Debit/Credit if amount is split into two fields), and 'Description' for transaction description. See the article on 'Selecting Fields to Represent Amount' for more information on choosing an 'Amount' mapping field.
Once all fields are mapped, click Next.
This screen will display a list of the importable rows and invalid rows. To review the list of Importable Records, click on the “+” sign as shown below. The grid will display the list of importable checks, and the basic check information.
If the “Amount” and “# of Records” columns are correct, click Next and go to Finish.
The Invalid Rows section will list all rows that will not be imported into Bank Reconciliation. The software will automatically mark header rows, footer rows, summation lines, and blank lines as invalid. For each row that is invalid, a check mark will be placed in the appropriate column indicating why the row was invalid. In the screenshot below, there were several footer and summary rows which were automatically scrubbed out, as well as several blank rows.
Once you have verified the importable information is accurate, click Next. If you wish to Cancel the import process and try again, simply hit Cancel.
Click Finish to complete the General Ledger Import Wizard.
The next step is to import your bank data.