Add a Receipt Batch

1. Access the Import area.
   1. To access the General Ledger from the Home screen, do one of the following:

   1. • Click General Ledger on the navigation panel.
      • Click Areas > General Ledger on the menubar.
      • Click the down arrow next to Home on the options bar and select General Ledger.

   To access the General Ledger from another area of the program, do one of the following:

   • Click Home > General Ledger on the menubar.
   • Click the down arrow next to Home on the options bar and select General Ledger.

   2. Click Import on the navigation panel or Areas > Import on the menubar.
2. Click Receipts under Import on the navigation bar.
3. Do one of the following:
   • Click the Add button to the left of the list.
   • With focus on the list, press [Insert] on your keyboard.
   • Press [Ctrl] + N.
4. The Add Batch - Receipts screen displays. Click Browse and navigate to the file with the receipts you want imported. Select it and click Open.

5. Select a Mapping file that defines the data. See Import/Export for more information on creating mapping files.

   • Before importing mapping files, verify their formatting.
   • • Open all CSV files in Microsoft Notepad to determine whether commas or semicolons are used as delimiters between the values.
       1. Navigate to the location of the CSV file in Windows Explorer.
       2. Right click the CSV file and select Open with > Notepad.

       1. • If the file uses commas, select a mapping file with a File format of Comma Delimited.

          • If the file uses semicolons, select a mapping file with a File format of Semicolon Delimited.

     • Open all XLS or XLSX files in Microsoft Excel to determine whether they contain header rows and whether their cells are formatted as Text.
     • If you import an XLS or XLSX file without a header row whose cells are not formatted as Text, dates and amounts will be formatted according to Excel’s formatting settings, rather than the mapping formats set up in Configure. To ensure that the file uses these mapping formats, update the cell formatting to Text if necessary.
6. In the Start import from row field, enter the first row number that you want to import. All of the rows that follow the selected row will also be imported.
7. Select the Bank account to which the receipts apply.
8. Enter the Effective date of the receipts.
9. Enter the Accounting month in which the receipts fall.
10. Enter a Description for the receipts.
11. Select a GL schedule.
12. Click Finish to return to the Import - Receipts list.

The receipts are not imported automatically. You must use Import Batch under Actions to load the receipts into the system. We recommend reviewing the import before applying the receipts to make sure everything imports correctly.