Add a Receipt Batch
- Access the
Import area.
- Click Receipts
under Import on the navigation
bar.
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.
- The Add Batch - Receipts
screen displays. Click Browse
and navigate to the file
with the transactions you want to import. Select it and click Open.
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.
- 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.
- 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.
- Select the Bank
account to which the receipts apply.
- Enter the Effective
date of the receipts.
- Enter the Accounting
month in which the receipts fall.
- Enter a Description
for the receipts.
- Select a GL
schedule.
- 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.