Bank Reconciliation > First Steps > Bank Reconciliation Self-guided Tour > Mapping sample GL data
The General Ledger Column Mapping dialog box (Figure 1 below) will appear.
 Figure 1 - General Ledger column mapping dialog box |
Similar to the mapping step for bank data, map the fields from your General Ledger field under the appropriate name. In this case, the Debit and Credit fields are mapped in place of Amount.
Click Next.
The Review Records dialog box (Figure 2 below) will appear.
 Figure 2 - General Ledger Review Records dialog box |
In this case, there were 235 importable records containing $521,110.74. However, unlike before there were 11 records deemed unimportable. Click the + sign to expand the Invalid Rows grouping. The invalid rows are blank rows, report headers, and other non-transactional data.
Click Next when finished.
The Import Complete dialog box will be displayed, confirming that data has been imported.
Click Finish.
At this point, both sets of data have been brought into Bank Reconciliation. The next step is Automated Transaction Matching to match bank data against the general ledger data.
Page url: http://www.treasurysoftware.com/TSHelp/index.html?mapping_sample_gl_data.htm